outages

48 rows where regionName = 22 sorted by latitude

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude ▼ longitude regionName outageDevices
646831 October 07, 2019 - 21:49:47 UTC 36.3795 -119.94166 Riverdale 22 []
677685 October 23, 2019 - 20:15:26 UTC 36.3795 -119.94166 Riverdale 22 []
631794 September 30, 2019 - 19:30:12 UTC 36.37987 -119.92783 Riverdale 22 []
655768 October 14, 2019 - 08:43:00 UTC 36.39484 -119.83492 Riverdale 22 []
721789 November 27, 2019 - 22:41:35 UTC 36.39486 -119.82314 Riverdale 22 []
721876 November 27, 2019 - 23:34:00 UTC 36.39486 -119.82207 Riverdale 22 []
722236 November 27, 2019 - 22:41:35 UTC 36.39486 -119.82314 Riverdale 22 []
722237 November 27, 2019 - 23:34:00 UTC 36.39486 -119.82207 Riverdale 22 []
655781 October 14, 2019 - 10:25:43 UTC 36.39493 -119.81039 Riverdale 22 [{"latitude": "36.39487", "longitude": "-119.81673"}, {"latitude": "36.39491", "longitude": "-119.81238"}, {"latitude": "36.3949", "longitude": "-119.81352"}]
725324 December 01, 2019 - 06:40:32 UTC 36.40199 -119.85124 Riverdale 22 [{"latitude": "36.37472", "longitude": "-119.8512"}, {"latitude": "36.39425", "longitude": "-119.83984"}, {"latitude": "36.4011", "longitude": "-119.85125"}, {"latitude": "36.39848", "longitude": "-119.86917"}, {"latitude": "36.39775", "longitude": "-119.87365"}, {"latitude": "36.39476", "longitude": "-119.87837"}, {"latitude": "36.39391", "longitude": "-119.87925"}, {"latitude": "36.38377", "longitude": "-119.87803"}]
779373 February 06, 2020 - 20:05:04 UTC 36.40211 -119.79986 Riverdale 22 []
687057 October 27, 2019 - 14:28:18 UTC 36.40435 -119.89453 Riverdale 22 []
680536 October 25, 2019 - 21:22:01 UTC 36.4076 -119.80394 Riverdale 22 []
779165 February 06, 2020 - 17:30:44 UTC 36.4076 -119.80394 Riverdale 22 []
779257 February 06, 2020 - 18:39:27 UTC 36.40929 -119.80906 Riverdale 22 []
663425 October 17, 2019 - 14:35:07 UTC 36.41515 -119.99914 Riverdale 22 []
688446 October 27, 2019 - 19:32:08 UTC 36.41586 -119.83412 Riverdale 22 []
704082 November 11, 2019 - 00:57:00 UTC 36.41654 -119.79906 Riverdale 22 []
643711 October 04, 2019 - 21:16:16 UTC 36.41798 -119.89538 Riverdale 22 []
724502 November 30, 2019 - 23:28:00 UTC 36.42338 -119.85132 Riverdale 22 [{"latitude": "36.36015", "longitude": "-119.85194"}, {"latitude": "36.36031", "longitude": "-119.8513"}, {"latitude": "36.36259", "longitude": "-119.84525"}, {"latitude": "36.39826", "longitude": "-119.81525"}, {"latitude": "36.40324", "longitude": "-119.8118"}, {"latitude": "36.40403", "longitude": "-119.81181"}, {"latitude": "36.41244", "longitude": "-119.8164"}, {"latitude": "36.41988", "longitude": "-119.83406"}, {"latitude": "36.42876", "longitude": "-119.88712"}, {"latitude": "36.42089", "longitude": "-119.89566"}, {"latitude": "36.40552", "longitude": "-119.89799"}, {"latitude": "36.3936", "longitude": "-119.8992"}, {"latitude": "36.38742", "longitude": "-119.89624"}, {"latitude": "36.36557", "longitude": "-119.8793"}, {"latitude": "36.3621", "longitude": "-119.86921"}]
721772 November 27, 2019 - 22:36:20 UTC 36.42667 -119.84593 Riverdale 22 [{"latitude": "36.42492", "longitude": "-119.8459"}, {"latitude": "36.42561", "longitude": "-119.84591"}, {"latitude": "36.42625", "longitude": "-119.84592"}]
634013 October 01, 2019 - 18:45:55 UTC 36.42984 -119.99478 Riverdale 22 []
680919 October 26, 2019 - 21:30:26 UTC 36.43082 -119.81754 Riverdale 22 []
712338 November 21, 2019 - 20:37:52 UTC 36.43095 -119.83861 Riverdale 22 [{"latitude": "36.42243", "longitude": "-119.83867"}, {"latitude": "36.43133", "longitude": "-119.83863"}, {"latitude": "36.43054", "longitude": "-119.83882"}, {"latitude": "36.42806", "longitude": "-119.83878"}]
722399 November 28, 2019 - 05:01:00 UTC 36.43095 -119.83861 Riverdale 22 [{"latitude": "36.42243", "longitude": "-119.83867"}, {"latitude": "36.43054", "longitude": "-119.83882"}, {"latitude": "36.42806", "longitude": "-119.83878"}]
721765 November 27, 2019 - 22:32:44 UTC 36.43133 -119.83863 Riverdale 22 []
728612 December 03, 2019 - 18:14:31 UTC 36.43438 -119.86088 Riverdale 22 []
782120 February 09, 2020 - 18:16:13 UTC 36.43505 -119.85098 Riverdale 22 []
790391 February 13, 2020 - 19:30:39 UTC 36.43505 -119.85098 Riverdale 22 []
778421 February 05, 2020 - 17:54:37 UTC 36.44179 -119.90507 Riverdale 22 []
696922 October 31, 2019 - 21:45:36 UTC 36.44518 -120.00415 Riverdale 22 []
635780 October 02, 2019 - 15:22:00 UTC 36.44541 -119.80802 Riverdale 22 []
725657 December 01, 2019 - 13:30:14 UTC 36.44545 -119.89311 Riverdale 22 []
704257 November 11, 2019 - 16:11:00 UTC 36.44549 -119.86084 Riverdale 22 []
697288 November 01, 2019 - 15:33:00 UTC 36.44565 -119.97699 Riverdale 22 [{"latitude": "36.44639", "longitude": "-119.97699"}, {"latitude": "36.44818", "longitude": "-119.97283"}, {"latitude": "36.45904", "longitude": "-119.97706"}]
730116 December 05, 2019 - 03:09:00 UTC 36.44567 -119.79891 Riverdale 22 [{"latitude": "36.36015", "longitude": "-119.85194"}, {"latitude": "36.36031", "longitude": "-119.8513"}, {"latitude": "36.36259", "longitude": "-119.84525"}, {"latitude": "36.39826", "longitude": "-119.81525"}, {"latitude": "36.43419", "longitude": "-119.78747"}, {"latitude": "36.43819", "longitude": "-119.78937"}, {"latitude": "36.44224", "longitude": "-119.79827"}, {"latitude": "36.43894", "longitude": "-119.86826"}, {"latitude": "36.43844", "longitude": "-119.86976"}, {"latitude": "36.42876", "longitude": "-119.88712"}, {"latitude": "36.42089", "longitude": "-119.89566"}, {"latitude": "36.40552", "longitude": "-119.89799"}, {"latitude": "36.3936", "longitude": "-119.8992"}, {"latitude": "36.38742", "longitude": "-119.89624"}, {"latitude": "36.36557", "longitude": "-119.8793"}, {"latitude": "36.3621", "longitude": "-119.86921"}]
636454 October 02, 2019 - 17:24:32 UTC 36.44661 -119.93651 Riverdale 22 []
779897 February 07, 2020 - 16:34:50 UTC 36.45909 -119.99014 Riverdale 22 []
730133 December 05, 2019 - 03:27:00 UTC 36.47098 -119.82598 Riverdale 22 []
702202 November 08, 2019 - 00:56:57 UTC 36.47099 -119.9871 Riverdale 22 []
780313 February 08, 2020 - 00:36:57 UTC 36.47307 -119.82554 Riverdale 22 []
723149 November 28, 2019 - 23:35:15 UTC 36.47415 -119.84752 Riverdale 22 []
720116 November 27, 2019 - 13:46:00 UTC 36.47443 -119.83326 Riverdale 22 []
724102 November 30, 2019 - 17:42:00 UTC 36.47443 -119.83326 Riverdale 22 []
646003 October 07, 2019 - 17:11:06 UTC 36.48897 -119.98446 Riverdale 22 []
691506 October 28, 2019 - 16:20:51 UTC 36.51759 -119.97048 Riverdale 22 []
780070 February 07, 2020 - 18:29:19 UTC 36.53356 -120.00771 Riverdale 22 [{"latitude": "36.53785", "longitude": "-120.00769"}, {"latitude": "36.55396", "longitude": "-119.99858"}, {"latitude": "36.55773", "longitude": "-120.00752"}, {"latitude": "36.56022", "longitude": "-120.02562"}, {"latitude": "36.56075", "longitude": "-120.0346"}, {"latitude": "36.56083", "longitude": "-120.04812"}, {"latitude": "36.54678", "longitude": "-120.03454"}, {"latitude": "36.5379", "longitude": "-120.01163"}]
780393 February 08, 2020 - 01:24:13 UTC 36.54328 -120.00739 Riverdale 22 []

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 952.87ms · About: About this site