324 rows where regionName = 21 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
690431 October 28, 2019 - 00:27:29 UTC 38.30654 -121.60211 Rio Vista 21 [{"latitude": "38.3043", "longitude": "-121.60647"}, {"latitude": "38.3066", "longitude": "-121.60462"}, {"latitude": "38.30674", "longitude": "-121.60667"}]
1150475 November 21, 2020 - 04:03:40 UTC 38.30654 -121.60211 Rio Vista 21 [{"latitude": "38.3043", "longitude": "-121.60647"}, {"latitude": "38.3066", "longitude": "-121.60462"}, {"latitude": "38.30674", "longitude": "-121.60667"}]
692411 October 29, 2019 - 00:28:42 UTC 38.28777 -121.60629 Rio Vista 21 []
1144644 November 14, 2020 - 10:47:46 UTC 38.30604 -121.62337 Rio Vista 21 []
1146049 November 16, 2020 - 17:19:29 UTC 38.29215 -121.62404 Rio Vista 21 []
735110 December 10, 2019 - 14:04:16 UTC 38.30021 -121.63031 Rio Vista 21 []
735838 December 10, 2019 - 23:02:13 UTC 38.30021 -121.63031 Rio Vista 21 []
778813 February 06, 2020 - 01:24:41 UTC 38.30021 -121.63031 Rio Vista 21 []
1134974 November 03, 2020 - 16:38:00 UTC 38.19585 -121.65985 Rio Vista 21 []
1165349 December 05, 2020 - 20:58:00 UTC 38.18834 -121.66323 Rio Vista 21 [{"latitude": "38.17148", "longitude": "-121.67786"}, {"latitude": "38.17281", "longitude": "-121.67598"}, {"latitude": "38.17444", "longitude": "-121.67425"}, {"latitude": "38.18785", "longitude": "-121.66368"}, {"latitude": "38.17207", "longitude": "-121.67872"}]
1147105 November 17, 2020 - 18:01:00 UTC 38.18415 -121.66711 Rio Vista 21 []
735743 December 10, 2019 - 21:18:55 UTC 38.18882 -121.67415 Rio Vista 21 []
686712 October 27, 2019 - 12:12:00 UTC 38.17238 -121.67662 Rio Vista 21 [{"latitude": "38.16303", "longitude": "-121.68505"}, {"latitude": "38.16309", "longitude": "-121.68406"}, {"latitude": "38.16335", "longitude": "-121.68357"}, {"latitude": "38.17041", "longitude": "-121.67773"}, {"latitude": "38.1722", "longitude": "-121.67693"}, {"latitude": "38.17306", "longitude": "-121.68686"}, {"latitude": "38.16984", "longitude": "-121.69004"}, {"latitude": "38.16665", "longitude": "-121.69247"}, {"latitude": "38.16534", "longitude": "-121.69336"}, {"latitude": "38.16367", "longitude": "-121.69075"}]
708113 November 16, 2019 - 15:29:00 UTC 38.17238 -121.67662 Rio Vista 21 [{"latitude": "38.16303", "longitude": "-121.68505"}, {"latitude": "38.16309", "longitude": "-121.68406"}, {"latitude": "38.16335", "longitude": "-121.68357"}, {"latitude": "38.17041", "longitude": "-121.67773"}, {"latitude": "38.1722", "longitude": "-121.67693"}, {"latitude": "38.17306", "longitude": "-121.68686"}, {"latitude": "38.16984", "longitude": "-121.69004"}, {"latitude": "38.16665", "longitude": "-121.69247"}, {"latitude": "38.16534", "longitude": "-121.69336"}, {"latitude": "38.16367", "longitude": "-121.69075"}]
714360 November 25, 2019 - 19:26:46 UTC 38.17041 -121.67773 Rio Vista 21 []
779268 February 06, 2020 - 18:53:54 UTC 38.17035 -121.67825 Rio Vista 21 []
1202030 January 01, 2021 - 06:13:11 UTC 38.17035 -121.67825 Rio Vista 21 []
697831 November 01, 2019 - 22:15:00 UTC 38.15612 -121.67901 Rio Vista 21 [{"latitude": "38.03101", "longitude": "-121.75028"}, {"latitude": "38.0312", "longitude": "-121.74671"}, {"latitude": "38.03361", "longitude": "-121.73742"}, {"latitude": "38.04739", "longitude": "-121.71113"}, {"latitude": "38.11979", "longitude": "-121.64343"}, {"latitude": "38.1626", "longitude": "-121.62344"}, {"latitude": "38.19407", "longitude": "-121.61569"}, {"latitude": "38.19427", "longitude": "-121.61666"}, {"latitude": "38.19188", "longitude": "-121.62807"}, {"latitude": "38.18763", "longitude": "-121.64151"}, {"latitude": "38.17317", "longitude": "-121.66329"}, {"latitude": "38.16871", "longitude": "-121.66958"}, {"latitude": "38.06025", "longitude": "-121.78341"}, {"latitude": "38.05735", "longitude": "-121.78371"}, {"latitude": "38.05282", "longitude": "-121.7833"}]
699202 November 04, 2019 - 18:27:42 UTC 38.16841 -121.68037 Rio Vista 21 []
659923 October 16, 2019 - 00:02:32 UTC 38.16907 -121.68092 Rio Vista 21 []
660719 October 16, 2019 - 17:06:44 UTC 38.16907 -121.68092 Rio Vista 21 []
1103933 October 01, 2020 - 17:58:56 UTC 38.16937 -121.68147 Rio Vista 21 []
647457 October 08, 2019 - 18:57:24 UTC 38.14456 -121.68347 Rio Vista 21 []
708719 November 17, 2019 - 20:52:13 UTC 38.14456 -121.68347 Rio Vista 21 []
715837 November 26, 2019 - 22:26:26 UTC 38.14467 -121.68347 Rio Vista 21 []
1194434 December 19, 2020 - 16:13:00 UTC 38.14456 -121.68347 Rio Vista 21 []
1153761 November 24, 2020 - 17:02:00 UTC 38.16584 -121.68377 Rio Vista 21 [{"latitude": "38.16367", "longitude": "-121.69075"}, {"latitude": "38.16657", "longitude": "-121.68506"}, {"latitude": "38.16674", "longitude": "-121.68762"}, {"latitude": "38.16665", "longitude": "-121.69247"}, {"latitude": "38.16534", "longitude": "-121.69336"}]
1232895 January 27, 2021 - 13:18:00 UTC 38.17051 -121.68414 Rio Vista 21 []
725504 December 01, 2019 - 08:59:27 UTC 38.11939 -121.68496 Rio Vista 21 []
736708 December 11, 2019 - 23:34:34 UTC 38.11939 -121.68496 Rio Vista 21 []
736721 December 11, 2019 - 23:34:34 UTC 38.11939 -121.68496 Rio Vista 21 []
1145426 November 15, 2020 - 15:14:36 UTC 38.11939 -121.68496 Rio Vista 21 []
637413 October 02, 2019 - 19:47:35 UTC 38.16335 -121.68582 Rio Vista 21 []
700448 November 06, 2019 - 08:47:00 UTC 38.15991 -121.68691 Rio Vista 21 [{"latitude": "38.15483", "longitude": "-121.69047"}, {"latitude": "38.15521", "longitude": "-121.68967"}, {"latitude": "38.16153", "longitude": "-121.68553"}, {"latitude": "38.16298", "longitude": "-121.6866"}, {"latitude": "38.15978", "longitude": "-121.68861"}, {"latitude": "38.15515", "longitude": "-121.69093"}, {"latitude": "38.15488", "longitude": "-121.69056"}]
736713 December 11, 2019 - 23:35:23 UTC 38.11762 -121.68828 Rio Vista 21 []
736720 December 11, 2019 - 23:40:02 UTC 38.11762 -121.68828 Rio Vista 21 []
743556 December 16, 2019 - 20:25:50 UTC 38.16248 -121.68852 Rio Vista 21 []
1200814 December 29, 2020 - 20:35:17 UTC 38.15978 -121.68861 Rio Vista 21 []
700460 November 06, 2019 - 10:33:00 UTC 38.16045 -121.68865 Rio Vista 21 [{"latitude": "38.15765", "longitude": "-121.69096"}, {"latitude": "38.15809", "longitude": "-121.69041"}, {"latitude": "38.15875", "longitude": "-121.68965"}, {"latitude": "38.15952", "longitude": "-121.68911"}, {"latitude": "38.16028", "longitude": "-121.68985"}, {"latitude": "38.16026", "longitude": "-121.69025"}, {"latitude": "38.16019", "longitude": "-121.69154"}, {"latitude": "38.16016", "longitude": "-121.69202"}]
725460 December 01, 2019 - 09:30:39 UTC 38.11628 -121.68885 Rio Vista 21 []
1122047 October 21, 2020 - 14:45:59 UTC 38.11628 -121.68885 Rio Vista 21 []
686755 October 27, 2019 - 12:48:00 UTC 38.16234 -121.68934 Rio Vista 21 []
706957 November 14, 2019 - 21:28:54 UTC 38.16234 -121.68934 Rio Vista 21 []
702867 November 08, 2019 - 21:12:51 UTC 38.15713 -121.68942 Rio Vista 21 []
696709 October 31, 2019 - 18:45:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700450 November 06, 2019 - 09:35:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700459 November 06, 2019 - 09:35:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700527 November 06, 2019 - 15:54:00 UTC 38.16435 -121.69039 Rio Vista 21 []
1129654 October 27, 2020 - 09:54:00 UTC 38.16435 -121.69039 Rio Vista 21 []
1144362 November 14, 2020 - 02:10:00 UTC 38.16435 -121.69039 Rio Vista 21 []
1232429 January 27, 2021 - 10:54:25 UTC 38.16435 -121.69039 Rio Vista 21 []
744607 December 17, 2019 - 20:30:03 UTC 38.15652 -121.6909 Rio Vista 21 []
700280 November 05, 2019 - 23:26:00 UTC 38.16488 -121.69107 Rio Vista 21 []
1210415 January 14, 2021 - 19:48:38 UTC 38.16488 -121.69107 Rio Vista 21 []
1196256 December 21, 2020 - 16:44:06 UTC 38.15401 -121.69142 Rio Vista 21 []
1202789 January 03, 2021 - 20:43:25 UTC 38.15401 -121.69142 Rio Vista 21 []
1153859 November 24, 2020 - 18:25:42 UTC 38.15347 -121.69143 Rio Vista 21 []
1154122 November 24, 2020 - 22:28:19 UTC 38.15347 -121.69143 Rio Vista 21 []
1227350 January 27, 2021 - 03:31:04 UTC 38.15347 -121.69143 Rio Vista 21 []
1227445 January 27, 2021 - 03:40:00 UTC 38.15347 -121.69143 Rio Vista 21 []
700550 November 06, 2019 - 15:58:05 UTC 38.15718 -121.69162 Rio Vista 21 []
1153022 November 23, 2020 - 15:56:01 UTC 38.15718 -121.69162 Rio Vista 21 []
691173 October 28, 2019 - 07:01:42 UTC 38.16627 -121.69167 Rio Vista 21 []
686416 October 27, 2019 - 09:39:00 UTC 38.15223 -121.69188 Rio Vista 21 []
699217 November 04, 2019 - 18:32:15 UTC 38.15223 -121.69188 Rio Vista 21 []
743317 December 16, 2019 - 19:49:51 UTC 38.15223 -121.69188 Rio Vista 21 []
1227518 January 27, 2021 - 03:43:00 UTC 38.15223 -121.69188 Rio Vista 21 []
1122474 October 21, 2020 - 21:32:37 UTC 38.15813 -121.69192 Rio Vista 21 []
700528 November 06, 2019 - 15:54:00 UTC 38.16391 -121.6923 Rio Vista 21 []
1236469 January 27, 2021 - 23:50:58 UTC 38.16053 -121.69259 Rio Vista 21 []
699225 November 04, 2019 - 18:35:03 UTC 38.16525 -121.69279 Rio Vista 21 []
686419 October 27, 2019 - 09:39:59 UTC 38.15219 -121.69297 Rio Vista 21 []
699219 November 04, 2019 - 18:33:52 UTC 38.15219 -121.69297 Rio Vista 21 []
1152688 November 22, 2020 - 16:10:14 UTC 38.15219 -121.69297 Rio Vista 21 []
1227514 January 27, 2021 - 03:43:18 UTC 38.15219 -121.69297 Rio Vista 21 []
1206376 January 08, 2021 - 00:15:59 UTC 38.15431 -121.693 Rio Vista 21 []
1206912 January 08, 2021 - 21:55:45 UTC 38.15431 -121.693 Rio Vista 21 []
696692 October 31, 2019 - 18:34:08 UTC 38.16534 -121.69336 Rio Vista 21 []
700451 November 06, 2019 - 09:36:25 UTC 38.16534 -121.69336 Rio Vista 21 []
1144285 November 14, 2020 - 01:48:49 UTC 38.16534 -121.69336 Rio Vista 21 []
713482 November 23, 2019 - 19:10:53 UTC 38.15536 -121.69342 Rio Vista 21 []
686717 October 27, 2019 - 12:19:02 UTC 38.16482 -121.69349 Rio Vista 21 []
680277 October 25, 2019 - 16:06:33 UTC 38.16092 -121.69351 Rio Vista 21 []
1144039 November 14, 2020 - 00:16:18 UTC 38.16235 -121.69351 Rio Vista 21 []
1079278 September 17, 2020 - 22:35:19 UTC 38.16146 -121.69363 Rio Vista 21 []
1227349 January 27, 2021 - 03:31:03 UTC 38.15294 -121.69385 Rio Vista 21 []
686404 October 27, 2019 - 09:36:17 UTC 38.15154 -121.69387 Rio Vista 21 []
690917 October 28, 2019 - 04:15:00 UTC 38.15154 -121.69387 Rio Vista 21 []
1131476 October 29, 2020 - 17:49:40 UTC 38.16422 -121.69397 Rio Vista 21 []
701171 November 06, 2019 - 23:49:58 UTC 38.17054 -121.69401 Rio Vista 21 []
731246 December 06, 2019 - 16:25:33 UTC 38.17054 -121.69401 Rio Vista 21 []
697971 November 02, 2019 - 01:11:28 UTC 38.15234 -121.69408 Rio Vista 21 []
658959 October 15, 2019 - 16:26:03 UTC 38.10416 -121.69409 Rio Vista 21 []
698278 November 02, 2019 - 20:16:29 UTC 38.17363 -121.69415 Rio Vista 21 []
701250 November 07, 2019 - 00:35:40 UTC 38.17363 -121.69415 Rio Vista 21 []
686769 October 27, 2019 - 09:36:17 UTC 38.15214 -121.69423 Rio Vista 21 [{"latitude": "38.14942", "longitude": "-121.69288"}, {"latitude": "38.15037", "longitude": "-121.69239"}, {"latitude": "38.15347", "longitude": "-121.69143"}, {"latitude": "38.15401", "longitude": "-121.69142"}, {"latitude": "38.15308", "longitude": "-121.69262"}, {"latitude": "38.15168", "longitude": "-121.6943"}]
1227655 January 27, 2021 - 03:54:07 UTC 38.15798 -121.69432 Rio Vista 21 []
1155536 November 28, 2020 - 19:27:54 UTC 38.15735 -121.69438 Rio Vista 21 []
699238 November 04, 2019 - 18:45:11 UTC 38.17281 -121.69441 Rio Vista 21 []
1215442 January 19, 2021 - 15:29:53 UTC 38.15947 -121.69445 Rio Vista 21 []

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
);