outages

26 rows where regionName = 84

View and edit SQL

Suggested facets: outageStartTime, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633634 October 01, 2019 - 15:19:23 UTC 36.43936 -119.63487 Laton 84 []
654122 October 11, 2019 - 14:52:29 UTC 36.46371 -119.64094 Laton 84 []
656533 October 14, 2019 - 17:09:21 UTC 36.42367 -119.78794 Laton 84 []
659881 October 15, 2019 - 22:45:00 UTC 36.43835 -119.72091 Laton 84 []
659882 October 15, 2019 - 22:45:00 UTC 36.43113 -119.75753 Laton 84 [{"latitude": "36.42436", "longitude": "-119.74522"}, {"latitude": "36.43664", "longitude": "-119.722"}, {"latitude": "36.43835", "longitude": "-119.72033"}, {"latitude": "36.44109", "longitude": "-119.73781"}, {"latitude": "36.43963", "longitude": "-119.75357"}, {"latitude": "36.43828", "longitude": "-119.75473"}, {"latitude": "36.43114", "longitude": "-119.75641"}, {"latitude": "36.42927", "longitude": "-119.75573"}]
667373 October 18, 2019 - 13:25:00 UTC 36.45999 -119.76466 Laton 84 [{"latitude": "36.45194", "longitude": "-119.77155"}, {"latitude": "36.45765", "longitude": "-119.76707"}, {"latitude": "36.45998", "longitude": "-119.76531"}, {"latitude": "36.46171", "longitude": "-119.76847"}, {"latitude": "36.45988", "longitude": "-119.78729"}]
680737 October 26, 2019 - 11:11:21 UTC 36.46919 -119.7681 Laton 84 []
680739 October 26, 2019 - 11:11:26 UTC 36.47489 -119.7483 Laton 84 []
680905 October 26, 2019 - 21:03:14 UTC 36.46212 -119.76283 Laton 84 []
705999 November 13, 2019 - 17:38:12 UTC 36.43109 -119.69703 Laton 84 []
713412 November 23, 2019 - 17:12:54 UTC 36.44315 -119.69965 Laton 84 []
715201 November 26, 2019 - 18:31:23 UTC 36.48186 -119.70821 Laton 84 []
727773 December 02, 2019 - 22:39:59 UTC 36.43097 -119.64872 Laton 84 []
729760 December 04, 2019 - 19:43:12 UTC 36.46197 -119.73627 Laton 84 []
731349 December 06, 2019 - 17:32:38 UTC 36.4381 -119.63496 Laton 84 []
736613 December 11, 2019 - 21:37:37 UTC 36.43423 -119.6812 Laton 84 []
780707 February 09, 2020 - 00:26:50 UTC 36.43322 -119.68733 Laton 84 [{"latitude": "36.43337", "longitude": "-119.6874"}, {"latitude": "36.43393", "longitude": "-119.68764"}, {"latitude": "36.43453", "longitude": "-119.6879"}, {"latitude": "36.43706", "longitude": "-119.68917"}, {"latitude": "36.43533", "longitude": "-119.68992"}, {"latitude": "36.43414", "longitude": "-119.68917"}]
780710 February 09, 2020 - 00:38:00 UTC 36.43657 -119.68657 Laton 84 []
788889 February 11, 2020 - 22:05:26 UTC 36.40208 -119.77189 Laton 84 []
789626 February 12, 2020 - 20:46:23 UTC 36.43372 -119.67198 Laton 84 []
1061641 September 09, 2020 - 05:16:00 UTC 36.47117 -119.79232 Laton 84 []
1066641 September 12, 2020 - 21:54:00 UTC 36.47607 -119.79043 Laton 84 []
1071114 September 15, 2020 - 15:19:47 UTC 36.47015 -119.76269 Laton 84 []
1071624 September 15, 2020 - 16:56:36 UTC 36.41088 -119.796 Laton 84 []
1075800 September 16, 2020 - 20:34:12 UTC 36.43716 -119.68061 Laton 84 []
1091197 September 24, 2020 - 18:44:16 UTC 36.43414 -119.68917 Laton 84 []

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