outages

284 rows where regionName = 42 sorted by outageDevices descending

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices ▲
686637 October 27, 2019 - 11:16:20 UTC 38.01338 -121.82341 Antioch 42 [{"latitude": "38.01266", "longitude": "-121.82057"}, {"latitude": "38.01267", "longitude": "-121.81831"}, {"latitude": "38.01338", "longitude": "-121.81644"}, {"latitude": "38.01409", "longitude": "-121.8165"}, {"latitude": "38.01624", "longitude": "-121.81708"}, {"latitude": "38.01624", "longitude": "-121.8182"}, {"latitude": "38.01624", "longitude": "-121.8191"}, {"latitude": "38.01338", "longitude": "-121.82247"}, {"latitude": "38.01267", "longitude": "-121.82275"}]
779728 February 07, 2020 - 05:07:05 UTC 38.0103 -121.83262 Antioch 42 [{"latitude": "38.01014", "longitude": "-121.83296"}, {"latitude": "38.01014", "longitude": "-121.83134"}, {"latitude": "38.01083", "longitude": "-121.83159"}]
780348 February 08, 2020 - 01:09:00 UTC 37.99854 -121.78306 Antioch 42 [{"latitude": "38.00583", "longitude": "-121.81247"}, {"latitude": "38.00596", "longitude": "-121.7521"}, {"latitude": "38.00649", "longitude": "-121.75096"}, {"latitude": "38.00939", "longitude": "-121.74934"}, {"latitude": "38.01644", "longitude": "-121.74685"}, {"latitude": "38.01858", "longitude": "-121.74881"}, {"latitude": "38.0194", "longitude": "-121.7503"}, {"latitude": "38.01962", "longitude": "-121.75361"}, {"latitude": "38.0198", "longitude": "-121.81996"}, {"latitude": "38.01774", "longitude": "-121.82712"}, {"latitude": "38.01357", "longitude": "-121.82804"}, {"latitude": "38.0061", "longitude": "-121.81515"}]
677433 October 23, 2019 - 16:01:00 UTC 38.00534 -121.76687 Antioch 42 [{"latitude": "38.00574", "longitude": "-121.76656"}, {"latitude": "38.00796", "longitude": "-121.76633"}, {"latitude": "38.00632", "longitude": "-121.76656"}]
1074075 September 16, 2020 - 14:57:00 UTC 37.99704 -121.79348 Antioch 42 [{"latitude": "37.99571", "longitude": "-121.79417"}, {"latitude": "37.99661", "longitude": "-121.79349"}, {"latitude": "37.99682", "longitude": "-121.79349"}]
686773 October 27, 2019 - 13:01:47 UTC 37.99692 -121.80535 Antioch 42 [{"latitude": "37.99449", "longitude": "-121.80532"}, {"latitude": "37.99663", "longitude": "-121.80534"}, {"latitude": "37.99612", "longitude": "-121.80596"}, {"latitude": "37.99455", "longitude": "-121.80714"}]
703153 November 09, 2019 - 11:45:56 UTC 37.99242 -121.84017 Antioch 42 [{"latitude": "37.99177", "longitude": "-121.83939"}, {"latitude": "37.99178", "longitude": "-121.83806"}, {"latitude": "37.9922", "longitude": "-121.83736"}, {"latitude": "37.9932", "longitude": "-121.83816"}, {"latitude": "37.99225", "longitude": "-121.83935"}]
706614 November 14, 2019 - 16:32:00 UTC 37.9847 -121.78799 Antioch 42 [{"latitude": "37.98515", "longitude": "-121.78791"}, {"latitude": "37.98782", "longitude": "-121.78794"}, {"latitude": "37.98964", "longitude": "-121.78882"}, {"latitude": "37.98904", "longitude": "-121.7887"}]
734396 December 09, 2019 - 17:57:00 UTC 37.99014 -121.78882 Antioch 42 [{"latitude": "37.98515", "longitude": "-121.78791"}, {"latitude": "37.98782", "longitude": "-121.78794"}, {"latitude": "37.98964", "longitude": "-121.78882"}, {"latitude": "37.98904", "longitude": "-121.7887"}]
737952 December 13, 2019 - 04:21:13 UTC 37.9848 -121.75401 Antioch 42 [{"latitude": "37.98416", "longitude": "-121.75569"}, {"latitude": "37.98437", "longitude": "-121.75478"}, {"latitude": "37.987", "longitude": "-121.75791"}, {"latitude": "37.9857", "longitude": "-121.758"}, {"latitude": "37.98442", "longitude": "-121.75744"}]
780360 February 08, 2020 - 01:08:00 UTC 37.99854 -121.78309 Antioch 42 [{"latitude": "37.9836", "longitude": "-121.83771"}, {"latitude": "37.98596", "longitude": "-121.82451"}, {"latitude": "37.98617", "longitude": "-121.82334"}, {"latitude": "37.99711", "longitude": "-121.78651"}, {"latitude": "37.99757", "longitude": "-121.78709"}, {"latitude": "38.00267", "longitude": "-121.80998"}, {"latitude": "38.00374", "longitude": "-121.81857"}, {"latitude": "38.00376", "longitude": "-121.81954"}, {"latitude": "38.00335", "longitude": "-121.82232"}, {"latitude": "37.9971", "longitude": "-121.83939"}, {"latitude": "37.99661", "longitude": "-121.84038"}, {"latitude": "37.99653", "longitude": "-121.84042"}, {"latitude": "37.99183", "longitude": "-121.84204"}, {"latitude": "37.99127", "longitude": "-121.84194"}, {"latitude": "37.98703", "longitude": "-121.84022"}, {"latitude": "37.98448", "longitude": "-121.83873"}]
634830 October 01, 2019 - 20:49:39 UTC 37.97436 -121.75807 Antioch 42 [{"latitude": "37.97389", "longitude": "-121.75999"}, {"latitude": "37.97395", "longitude": "-121.75907"}, {"latitude": "37.97449", "longitude": "-121.75783"}, {"latitude": "37.97547", "longitude": "-121.75771"}, {"latitude": "37.97567", "longitude": "-121.75947"}, {"latitude": "37.97499", "longitude": "-121.76123"}]
709135 November 18, 2019 - 17:14:00 UTC 37.97344 -121.78399 Antioch 42 [{"latitude": "37.97241", "longitude": "-121.78139"}, {"latitude": "37.97381", "longitude": "-121.78106"}, {"latitude": "37.97421", "longitude": "-121.78111"}, {"latitude": "37.97554", "longitude": "-121.78244"}, {"latitude": "37.97558", "longitude": "-121.78368"}, {"latitude": "37.97525", "longitude": "-121.78486"}, {"latitude": "37.97394", "longitude": "-121.78651"}, {"latitude": "37.97354", "longitude": "-121.78663"}]
1093735 September 26, 2020 - 15:03:51 UTC 37.96477 -121.81282 Antioch 42 [{"latitude": "37.96419", "longitude": "-121.8149"}, {"latitude": "37.96508", "longitude": "-121.81239"}, {"latitude": "37.96425", "longitude": "-121.81718"}]
1080954 September 18, 2020 - 19:10:10 UTC 37.96395 -121.80523 Antioch 42 [{"latitude": "37.96325", "longitude": "-121.80405"}, {"latitude": "37.96391", "longitude": "-121.80322"}, {"latitude": "37.96369", "longitude": "-121.80499"}]
1079716 September 18, 2020 - 14:34:00 UTC 37.96395 -121.80523 Antioch 42 [{"latitude": "37.96202", "longitude": "-121.8015"}, {"latitude": "37.96302", "longitude": "-121.80135"}, {"latitude": "37.9642", "longitude": "-121.80219"}, {"latitude": "37.96369", "longitude": "-121.80499"}]
738370 December 13, 2019 - 17:24:02 UTC 37.96092 -121.8086 Antioch 42 [{"latitude": "37.95863", "longitude": "-121.81759"}, {"latitude": "37.95905", "longitude": "-121.81052"}, {"latitude": "37.96059", "longitude": "-121.80931"}, {"latitude": "37.95948", "longitude": "-121.81866"}]
699918 November 05, 2019 - 17:13:00 UTC 37.95983 -121.79724 Antioch 42 [{"latitude": "37.95823", "longitude": "-121.79959"}, {"latitude": "37.96048", "longitude": "-121.79754"}, {"latitude": "37.96087", "longitude": "-121.7995"}, {"latitude": "37.95922", "longitude": "-121.79979"}]
706762 November 14, 2019 - 18:00:00 UTC 37.96009 -121.75487 Antioch 42 [{"latitude": "37.95709", "longitude": "-121.75902"}, {"latitude": "37.95754", "longitude": "-121.75768"}, {"latitude": "37.95826", "longitude": "-121.75623"}, {"latitude": "37.95912", "longitude": "-121.75744"}, {"latitude": "37.95985", "longitude": "-121.75891"}]
699926 November 05, 2019 - 17:11:00 UTC 37.96279 -121.79758 Antioch 42 [{"latitude": "37.95608", "longitude": "-121.80478"}, {"latitude": "37.9581", "longitude": "-121.79806"}, {"latitude": "37.95923", "longitude": "-121.79771"}, {"latitude": "37.96048", "longitude": "-121.79754"}, {"latitude": "37.96374", "longitude": "-121.79804"}, {"latitude": "37.96431", "longitude": "-121.79916"}, {"latitude": "37.96381", "longitude": "-121.80061"}, {"latitude": "37.95769", "longitude": "-121.80645"}, {"latitude": "37.95685", "longitude": "-121.80573"}]
699895 November 05, 2019 - 17:07:00 UTC 37.95451 -121.78822 Antioch 42 [{"latitude": "37.95444", "longitude": "-121.78994"}, {"latitude": "37.95782", "longitude": "-121.79136"}, {"latitude": "37.9576", "longitude": "-121.79514"}, {"latitude": "37.95703", "longitude": "-121.79558"}]
699885 November 05, 2019 - 17:02:00 UTC 37.95662 -121.79695 Antioch 42 [{"latitude": "37.95436", "longitude": "-121.80095"}, {"latitude": "37.95452", "longitude": "-121.79766"}, {"latitude": "37.95502", "longitude": "-121.79923"}, {"latitude": "37.9551", "longitude": "-121.80035"}, {"latitude": "37.95499", "longitude": "-121.80169"}, {"latitude": "37.95438", "longitude": "-121.80179"}]
633519 October 01, 2019 - 11:16:20 UTC 37.99355 -121.84289 Antioch 42 []
635774 October 02, 2019 - 15:17:05 UTC 38.00077 -121.83397 Antioch 42 []
638813 October 03, 2019 - 00:27:19 UTC 38.01631 -121.81607 Antioch 42 []
638842 October 03, 2019 - 01:19:32 UTC 37.98186 -121.82152 Antioch 42 []
640954 October 03, 2019 - 20:49:29 UTC 38.01631 -121.81607 Antioch 42 []
641916 October 04, 2019 - 00:17:58 UTC 38.00425 -121.80547 Antioch 42 []
642266 October 04, 2019 - 15:00:33 UTC 38.00165 -121.83557 Antioch 42 []
642385 October 04, 2019 - 15:31:03 UTC 38.00239 -121.79165 Antioch 42 []
643426 October 04, 2019 - 17:44:07 UTC 38.00612 -121.80508 Antioch 42 []
643884 October 05, 2019 - 05:44:45 UTC 38.00686 -121.78894 Antioch 42 []
645570 October 06, 2019 - 16:21:38 UTC 37.99225 -121.83935 Antioch 42 []
645847 October 07, 2019 - 15:32:58 UTC 37.984 -121.77956 Antioch 42 []
645860 October 07, 2019 - 15:38:03 UTC 38.00097 -121.83373 Antioch 42 []
645869 October 07, 2019 - 15:44:41 UTC 38.00184 -121.83329 Antioch 42 []
647101 October 08, 2019 - 15:12:39 UTC 38.00204 -121.833 Antioch 42 []
647109 October 08, 2019 - 15:21:15 UTC 38.00094 -121.83479 Antioch 42 []
647543 October 08, 2019 - 21:07:39 UTC 37.9995 -121.81424 Antioch 42 []
647777 October 09, 2019 - 04:44:10 UTC 37.98724 -121.76593 Antioch 42 []
650805 October 09, 2019 - 16:30:37 UTC 38.00964 -121.79079 Antioch 42 []
650823 October 09, 2019 - 16:54:26 UTC 38.00833 -121.81831 Antioch 42 []
655080 October 12, 2019 - 15:27:55 UTC 37.99665 -121.80822 Antioch 42 []
655486 October 13, 2019 - 12:15:07 UTC 38.00394 -121.80786 Antioch 42 []
655639 October 13, 2019 - 22:28:55 UTC 38.01217 -121.80433 Antioch 42 []
655650 October 13, 2019 - 23:50:00 UTC 37.96772 -121.75645 Antioch 42 []
655922 October 14, 2019 - 16:00:23 UTC 37.99354 -121.8133 Antioch 42 []
658353 October 14, 2019 - 21:37:58 UTC 38.00184 -121.79165 Antioch 42 []
658394 October 14, 2019 - 21:44:04 UTC 37.97298 -121.7636 Antioch 42 []
660818 October 16, 2019 - 18:13:11 UTC 38.00937 -121.80078 Antioch 42 []
660838 October 16, 2019 - 18:25:51 UTC 38.01054 -121.79996 Antioch 42 []
661573 October 16, 2019 - 19:29:57 UTC 37.99044 -121.80794 Antioch 42 []
661733 October 16, 2019 - 19:48:32 UTC 38.00381 -121.80356 Antioch 42 []
661881 October 16, 2019 - 20:25:00 UTC 37.96688 -121.76465 Antioch 42 []
663233 October 17, 2019 - 04:19:24 UTC 38.00165 -121.83557 Antioch 42 []
665113 October 17, 2019 - 18:13:18 UTC 38.00165 -121.83557 Antioch 42 []
668937 October 18, 2019 - 17:52:24 UTC 38.00383 -121.79437 Antioch 42 []
669913 October 18, 2019 - 20:24:22 UTC 38.00499 -121.82478 Antioch 42 []
670313 October 18, 2019 - 21:27:38 UTC 37.9792 -121.82907 Antioch 42 []
670593 October 18, 2019 - 22:13:30 UTC 37.98036 -121.77345 Antioch 42 []
670719 October 18, 2019 - 23:08:32 UTC 38.00499 -121.82478 Antioch 42 []
673153 October 19, 2019 - 19:40:40 UTC 37.99926 -121.83422 Antioch 42 []
674936 October 21, 2019 - 00:51:04 UTC 38.00281 -121.79459 Antioch 42 []
676101 October 21, 2019 - 17:56:42 UTC 38.01481 -121.82016 Antioch 42 []
676269 October 21, 2019 - 20:12:45 UTC 38.00812 -121.81351 Antioch 42 []
676305 October 21, 2019 - 20:45:29 UTC 37.98036 -121.77345 Antioch 42 []
676400 October 21, 2019 - 22:17:46 UTC 37.98036 -121.77345 Antioch 42 []
676637 October 22, 2019 - 14:59:14 UTC 38.01208 -121.8076 Antioch 42 []
677194 October 23, 2019 - 01:47:18 UTC 38.01481 -121.82016 Antioch 42 []
677217 October 23, 2019 - 02:25:56 UTC 37.95557 -121.78009 Antioch 42 []
679431 October 24, 2019 - 15:47:15 UTC 37.9912 -121.81611 Antioch 42 []
679572 October 24, 2019 - 17:23:51 UTC 37.96419 -121.8149 Antioch 42 []
679831 October 24, 2019 - 22:24:24 UTC 38.00302 -121.82397 Antioch 42 []
680024 October 25, 2019 - 01:25:37 UTC 37.99331 -121.78633 Antioch 42 []
684259 October 27, 2019 - 04:18:11 UTC 38.0035 -121.80786 Antioch 42 []
685624 October 27, 2019 - 06:49:27 UTC 38.00506 -121.83221 Antioch 42 []
686508 October 27, 2019 - 10:11:34 UTC 38.01217 -121.75856 Antioch 42 []
686574 October 27, 2019 - 10:47:42 UTC 38.00138 -121.83095 Antioch 42 []
686575 October 27, 2019 - 10:47:41 UTC 37.99906 -121.82825 Antioch 42 []
686791 October 27, 2019 - 13:10:15 UTC 37.99449 -121.80532 Antioch 42 []
687281 October 27, 2019 - 15:49:30 UTC 38.01197 -121.77502 Antioch 42 []
687508 October 27, 2019 - 16:41:57 UTC 38.01155 -121.79176 Antioch 42 []
687565 October 27, 2019 - 16:55:00 UTC 38.01034 -121.79939 Antioch 42 []
687897 October 27, 2019 - 18:00:21 UTC 37.96578 -121.76629 Antioch 42 []
687910 October 27, 2019 - 18:01:46 UTC 38.01016 -121.80179 Antioch 42 []
688065 October 27, 2019 - 18:24:55 UTC 38.01624 -121.8191 Antioch 42 []
688622 October 27, 2019 - 19:53:27 UTC 38.00363 -121.75936 Antioch 42 []
688768 October 27, 2019 - 20:15:15 UTC 37.99951 -121.80754 Antioch 42 []
688769 October 27, 2019 - 20:15:15 UTC 38.0002 -121.80967 Antioch 42 []
688770 October 27, 2019 - 20:15:15 UTC 38.00071 -121.80569 Antioch 42 []
688802 October 27, 2019 - 20:17:48 UTC 37.99449 -121.80532 Antioch 42 []
688846 October 27, 2019 - 20:25:59 UTC 38.01173 -121.81121 Antioch 42 []
688971 October 27, 2019 - 20:40:43 UTC 38.00213 -121.85286 Antioch 42 []
689888 October 27, 2019 - 22:22:25 UTC 37.97521 -121.78079 Antioch 42 []
690083 October 27, 2019 - 22:51:55 UTC 37.99927 -121.81372 Antioch 42 []
690138 October 27, 2019 - 23:03:47 UTC 37.99888 -121.76689 Antioch 42 []
690622 October 28, 2019 - 01:37:46 UTC 38.01624 -121.8191 Antioch 42 []
690760 October 28, 2019 - 02:29:13 UTC 37.9944 -121.81462 Antioch 42 []
690849 October 28, 2019 - 03:24:49 UTC 37.98443 -121.77086 Antioch 42 []
691330 October 28, 2019 - 14:43:09 UTC 37.99606 -121.81979 Antioch 42 []

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
)
Powered by Datasette · Query took 326.48ms · About: About this site