721 rows where regionName = 27

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633480 October 01, 2019 - 05:07:09 UTC 37.70999 -122.17583 San Leandro 27 []
633990 October 01, 2019 - 18:24:22 UTC 37.7291 -122.13521 San Leandro 27 []
635783 October 02, 2019 - 15:23:00 UTC 37.73991 -122.15183 San Leandro 27 [{"latitude": "37.73686", "longitude": "-122.15261"}, {"latitude": "37.73705", "longitude": "-122.1508"}, {"latitude": "37.73729", "longitude": "-122.15089"}, {"latitude": "37.73945", "longitude": "-122.15171"}, {"latitude": "37.73816", "longitude": "-122.15349"}]
638844 October 03, 2019 - 01:23:00 UTC 37.71 -122.12683 San Leandro 27 []
640493 October 03, 2019 - 19:48:55 UTC 37.7063 -122.16236 San Leandro 27 []
641673 October 03, 2019 - 22:53:10 UTC 37.7063 -122.16236 San Leandro 27 []
642144 October 04, 2019 - 01:32:56 UTC 37.69173 -122.15794 San Leandro 27 []
643511 October 04, 2019 - 19:19:01 UTC 37.71838 -122.15519 San Leandro 27 []
643998 October 05, 2019 - 15:16:00 UTC 37.71495 -122.15118 San Leandro 27 []
645490 October 06, 2019 - 06:55:39 UTC 37.70999 -122.17583 San Leandro 27 []
645744 October 07, 2019 - 03:29:13 UTC 37.70999 -122.17583 San Leandro 27 []
645805 October 07, 2019 - 14:12:07 UTC 37.72013 -122.16365 San Leandro 27 []
645866 October 07, 2019 - 15:41:38 UTC 37.6971 -122.13217 San Leandro 27 []
646180 October 07, 2019 - 19:43:34 UTC 37.70999 -122.17583 San Leandro 27 []
646213 October 07, 2019 - 20:19:36 UTC 37.72605 -122.14118 San Leandro 27 []
647611 October 08, 2019 - 23:20:01 UTC 37.71529 -122.15856 San Leandro 27 []
650130 October 09, 2019 - 11:33:00 UTC 37.72231 -122.1508 San Leandro 27 []
650816 October 09, 2019 - 16:44:00 UTC 37.68612 -122.14577 San Leandro 27 []
650860 October 09, 2019 - 17:38:03 UTC 37.73653 -122.14312 San Leandro 27 []
652380 October 10, 2019 - 06:44:00 UTC 37.71065 -122.14887 San Leandro 27 [{"latitude": "37.71992", "longitude": "-122.15687"}, {"latitude": "37.7201", "longitude": "-122.15595"}, {"latitude": "37.72059", "longitude": "-122.15487"}, {"latitude": "37.75031", "longitude": "-122.10496"}, {"latitude": "37.74081", "longitude": "-122.15425"}, {"latitude": "37.73726", "longitude": "-122.16555"}, {"latitude": "37.73327", "longitude": "-122.16683"}, {"latitude": "37.72707", "longitude": "-122.1623"}]
652420 October 10, 2019 - 06:56:10 UTC 37.72113 -122.15708 San Leandro 27 []
652421 October 10, 2019 - 06:56:10 UTC 37.72521 -122.1571 San Leandro 27 []
652422 October 10, 2019 - 06:56:10 UTC 37.72219 -122.15865 San Leandro 27 []
652439 October 10, 2019 - 07:02:21 UTC 37.73664 -122.16253 San Leandro 27 []
652618 October 10, 2019 - 14:04:00 UTC 37.71928 -122.15542 San Leandro 27 []
652627 October 10, 2019 - 14:19:01 UTC 37.71962 -122.15517 San Leandro 27 []
652642 October 10, 2019 - 14:47:00 UTC 37.72425 -122.15498 San Leandro 27 []
652979 October 10, 2019 - 18:21:22 UTC 37.7098 -122.1352 San Leandro 27 []
652984 October 10, 2019 - 18:24:00 UTC 37.72562 -122.15453 San Leandro 27 []
653062 October 10, 2019 - 19:03:35 UTC 37.73206 -122.1576 San Leandro 27 []
653585 October 10, 2019 - 23:01:00 UTC 37.73289 -122.1641 San Leandro 27 []
653594 October 10, 2019 - 23:08:00 UTC 37.73579 -122.16615 San Leandro 27 []
653632 October 10, 2019 - 23:31:00 UTC 37.73437 -122.16223 San Leandro 27 []
653821 October 11, 2019 - 02:08:00 UTC 37.74013 -122.14432 San Leandro 27 []
653824 October 11, 2019 - 02:11:00 UTC 37.74068 -122.14642 San Leandro 27 []
653837 October 11, 2019 - 02:20:46 UTC 37.74015 -122.14529 San Leandro 27 []
653850 October 11, 2019 - 02:35:00 UTC 37.74197 -122.14598 San Leandro 27 []
654424 October 11, 2019 - 19:14:27 UTC 37.72014 -122.13791 San Leandro 27 []
654647 October 11, 2019 - 22:32:32 UTC 37.72257 -122.14987 San Leandro 27 []
654926 October 12, 2019 - 03:06:50 UTC 37.7296 -122.15595 San Leandro 27 []
656513 October 14, 2019 - 17:06:59 UTC 37.72715 -122.18908 San Leandro 27 []
658033 October 14, 2019 - 20:47:00 UTC 37.72527 -122.15936 San Leandro 27 []
658514 October 14, 2019 - 22:04:09 UTC 37.72095 -122.14352 San Leandro 27 []
658924 October 15, 2019 - 16:11:00 UTC 37.73198 -122.13439 San Leandro 27 [{"latitude": "37.73235", "longitude": "-122.13525"}, {"latitude": "37.73243", "longitude": "-122.13471"}, {"latitude": "37.7328", "longitude": "-122.134"}, {"latitude": "37.7331", "longitude": "-122.13463"}]
658956 October 15, 2019 - 16:19:17 UTC 37.73221 -122.13329 San Leandro 27 []
658992 October 15, 2019 - 16:47:39 UTC 37.7293 -122.13199 San Leandro 27 []
659812 October 15, 2019 - 20:57:39 UTC 37.69134 -122.14059 San Leandro 27 []
660322 October 16, 2019 - 15:48:42 UTC 37.73525 -122.15835 San Leandro 27 []
660513 October 16, 2019 - 16:01:55 UTC 37.73138 -122.13396 San Leandro 27 []
660673 October 16, 2019 - 16:35:23 UTC 37.73031 -122.1372 San Leandro 27 []
661133 October 16, 2019 - 18:55:11 UTC 37.74015 -122.14529 San Leandro 27 []
661777 October 16, 2019 - 20:02:00 UTC 37.68541 -122.13999 San Leandro 27 []
661834 October 16, 2019 - 20:16:26 UTC 37.73525 -122.15835 San Leandro 27 []
663265 October 17, 2019 - 07:24:49 UTC 37.69398 -122.17367 San Leandro 27 []
666255 October 17, 2019 - 21:01:35 UTC 37.73206 -122.1576 San Leandro 27 []
666256 October 17, 2019 - 21:01:35 UTC 37.73158 -122.15641 San Leandro 27 []
666998 October 17, 2019 - 23:18:03 UTC 37.69083 -122.1413 San Leandro 27 []
667217 October 18, 2019 - 00:48:35 UTC 37.69083 -122.1413 San Leandro 27 []
667316 October 18, 2019 - 06:15:00 UTC 37.73158 -122.15641 San Leandro 27 []
671913 October 19, 2019 - 16:45:15 UTC 37.70935 -122.16 San Leandro 27 []
674946 October 21, 2019 - 01:35:19 UTC 37.68573 -122.15343 San Leandro 27 []
674975 October 21, 2019 - 04:55:42 UTC 37.70789 -122.13253 San Leandro 27 []
676435 October 21, 2019 - 23:22:33 UTC 37.73227 -122.13246 San Leandro 27 []
676994 October 22, 2019 - 20:42:02 UTC 37.71674 -122.16457 San Leandro 27 []
677185 October 23, 2019 - 01:27:29 UTC 37.71712 -122.16944 San Leandro 27 []
677529 October 23, 2019 - 17:19:37 UTC 37.71444 -122.13844 San Leandro 27 []
677665 October 23, 2019 - 19:52:15 UTC 37.71444 -122.13844 San Leandro 27 []
677668 October 23, 2019 - 19:57:42 UTC 37.74015 -122.14529 San Leandro 27 []
678267 October 23, 2019 - 22:03:37 UTC 37.72515 -122.13664 San Leandro 27 []
679552 October 24, 2019 - 17:04:09 UTC 37.6966 -122.14755 San Leandro 27 []
683469 October 27, 2019 - 03:23:34 UTC 37.7292 -122.13786 San Leandro 27 [{"latitude": "37.72923", "longitude": "-122.14058"}, {"latitude": "37.72928", "longitude": "-122.13967"}, {"latitude": "37.73031", "longitude": "-122.1372"}, {"latitude": "37.73052", "longitude": "-122.13818"}]
684062 October 27, 2019 - 03:49:00 UTC 37.71901 -122.13094 San Leandro 27 [{"latitude": "37.71618", "longitude": "-122.12722"}, {"latitude": "37.71701", "longitude": "-122.12569"}, {"latitude": "37.71945", "longitude": "-122.12469"}, {"latitude": "37.72705", "longitude": "-122.12447"}, {"latitude": "37.73206", "longitude": "-122.1297"}, {"latitude": "37.73138", "longitude": "-122.13396"}, {"latitude": "37.73096", "longitude": "-122.13541"}, {"latitude": "37.72986", "longitude": "-122.13609"}, {"latitude": "37.72783", "longitude": "-122.13688"}, {"latitude": "37.71676", "longitude": "-122.12777"}]
684604 October 27, 2019 - 04:53:24 UTC 37.72958 -122.13935 San Leandro 27 []
684724 October 27, 2019 - 04:56:34 UTC 37.72963 -122.13917 San Leandro 27 [{"latitude": "37.72989", "longitude": "-122.13905"}, {"latitude": "37.73227", "longitude": "-122.13246"}, {"latitude": "37.73252", "longitude": "-122.13186"}, {"latitude": "37.73336", "longitude": "-122.13324"}, {"latitude": "37.73439", "longitude": "-122.14086"}, {"latitude": "37.73255", "longitude": "-122.14081"}]
684775 October 27, 2019 - 05:04:21 UTC 37.70841 -122.12709 San Leandro 27 [{"latitude": "37.69949", "longitude": "-122.10699"}, {"latitude": "37.70251", "longitude": "-122.10382"}, {"latitude": "37.71489", "longitude": "-122.11605"}, {"latitude": "37.71704", "longitude": "-122.11927"}, {"latitude": "37.71519", "longitude": "-122.12848"}, {"latitude": "37.70802", "longitude": "-122.12906"}, {"latitude": "37.70745", "longitude": "-122.12906"}, {"latitude": "37.70611", "longitude": "-122.12897"}, {"latitude": "37.70487", "longitude": "-122.12753"}, {"latitude": "37.70443", "longitude": "-122.12696"}, {"latitude": "37.70403", "longitude": "-122.12628"}]
687221 October 27, 2019 - 15:22:00 UTC 37.74013 -122.14432 San Leandro 27 []
687223 October 27, 2019 - 15:24:00 UTC 37.74083 -122.14601 San Leandro 27 []
687249 October 27, 2019 - 15:37:40 UTC 37.73984 -122.1461 San Leandro 27 []
687524 October 27, 2019 - 16:43:56 UTC 37.74015 -122.14529 San Leandro 27 []
687926 October 27, 2019 - 18:05:02 UTC 37.73608 -122.15101 San Leandro 27 []
687959 October 27, 2019 - 18:08:44 UTC 37.73853 -122.15445 San Leandro 27 []
687961 October 27, 2019 - 18:08:44 UTC 37.72991 -122.16603 San Leandro 27 []
687962 October 27, 2019 - 18:08:41 UTC 37.70944 -122.12858 San Leandro 27 []
687989 October 27, 2019 - 18:11:08 UTC 37.72911 -122.14631 San Leandro 27 []
688018 October 27, 2019 - 18:16:51 UTC 37.73399 -122.15973 San Leandro 27 []
688029 October 27, 2019 - 18:19:58 UTC 37.73398 -122.15139 San Leandro 27 []
688030 October 27, 2019 - 18:19:58 UTC 37.73 -122.14901 San Leandro 27 []
688045 October 27, 2019 - 18:22:28 UTC 37.68695 -122.13132 San Leandro 27 []
688083 October 27, 2019 - 18:28:23 UTC 37.70306 -122.13188 San Leandro 27 []
688119 October 27, 2019 - 18:35:12 UTC 37.72232 -122.15383 San Leandro 27 []
688306 October 27, 2019 - 19:03:15 UTC 37.73073 -122.16183 San Leandro 27 []
688779 October 27, 2019 - 20:15:19 UTC 37.70888 -122.13314 San Leandro 27 [{"latitude": "37.70703", "longitude": "-122.12999"}, {"latitude": "37.70887", "longitude": "-122.12948"}, {"latitude": "37.71129", "longitude": "-122.12897"}, {"latitude": "37.7129", "longitude": "-122.13103"}, {"latitude": "37.71293", "longitude": "-122.13262"}, {"latitude": "37.70987", "longitude": "-122.13447"}]
689025 October 27, 2019 - 20:47:44 UTC 37.72924 -122.15491 San Leandro 27 []
689494 October 27, 2019 - 21:36:07 UTC 37.7291 -122.15739 San Leandro 27 []
689622 October 27, 2019 - 21:43:20 UTC 37.71615 -122.14424 San Leandro 27 [{"latitude": "37.71168", "longitude": "-122.1472"}, {"latitude": "37.71186", "longitude": "-122.14596"}, {"latitude": "37.71221", "longitude": "-122.14537"}, {"latitude": "37.71517", "longitude": "-122.14392"}, {"latitude": "37.71606", "longitude": "-122.14436"}, {"latitude": "37.71373", "longitude": "-122.14745"}, {"latitude": "37.71286", "longitude": "-122.14735"}]
689743 October 27, 2019 - 21:59:47 UTC 37.70825 -122.13414 San Leandro 27 []
689891 October 27, 2019 - 22:23:04 UTC 37.68362 -122.14742 San Leandro 27 []
689939 October 27, 2019 - 17:50:13 UTC 37.7374 -122.1609 San Leandro 27 []
689940 October 27, 2019 - 17:50:12 UTC 37.73787 -122.15929 San Leandro 27 []
689948 October 27, 2019 - 17:50:13 UTC 37.74028 -122.15058 San Leandro 27 []

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outages] (
   [id] INTEGER PRIMARY KEY,
   [outageStartTime] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [outageDevices] TEXT
);