100 rows where regionName = 50

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633547 October 01, 2019 - 16:00:00 UTC 41.17032 -121.68866 Burney 50 [{"latitude": "41.1996", "longitude": "-121.68917"}, {"latitude": "41.19965", "longitude": "-121.68311"}, {"latitude": "41.20079", "longitude": "-121.68503"}]
646012 October 07, 2019 - 17:14:05 UTC 41.02277 -121.65743 Burney 50 []
660342 October 16, 2019 - 15:49:53 UTC 41.20079 -121.68503 Burney 50 []
661877 October 16, 2019 - 20:22:57 UTC 41.20079 -121.68503 Burney 50 []
671001 October 19, 2019 - 01:43:41 UTC 40.91577 -121.62479 Burney 50 []
671839 October 19, 2019 - 16:30:21 UTC 40.91683 -121.6289 Burney 50 []
699156 November 04, 2019 - 17:58:23 UTC 40.99761 -121.63082 Burney 50 []
701644 November 07, 2019 - 16:04:00 UTC 40.87274 -121.66127 Burney 50 [{"latitude": "40.87064", "longitude": "-121.66736"}, {"latitude": "40.87096", "longitude": "-121.66467"}, {"latitude": "40.87134", "longitude": "-121.66249"}, {"latitude": "40.87315", "longitude": "-121.66302"}, {"latitude": "40.87317", "longitude": "-121.66921"}, {"latitude": "40.87299", "longitude": "-121.6704"}, {"latitude": "40.87136", "longitude": "-121.6693"}]
703217 November 09, 2019 - 16:34:00 UTC 40.94622 -121.64775 Burney 50 []
706985 November 14, 2019 - 21:57:03 UTC 40.87701 -121.6729 Burney 50 []
718487 November 27, 2019 - 04:27:00 UTC 41.03588 -121.62974 Burney 50 []
720401 November 27, 2019 - 15:23:00 UTC 41.03588 -121.62974 Burney 50 []
727819 December 02, 2019 - 23:22:44 UTC 41.04141 -121.67025 Burney 50 []
729031 December 03, 2019 - 23:59:32 UTC 41.04141 -121.67025 Burney 50 []
729446 December 04, 2019 - 16:03:15 UTC 40.87531 -121.66942 Burney 50 []
730875 December 06, 2019 - 00:57:00 UTC 41.04141 -121.67025 Burney 50 []
732390 December 07, 2019 - 17:00:25 UTC 41.1996 -121.68917 Burney 50 []
736661 December 11, 2019 - 22:40:05 UTC 40.87753 -121.67292 Burney 50 []
744985 December 18, 2019 - 02:22:20 UTC 40.87733 -121.66684 Burney 50 []
780656 February 08, 2020 - 21:27:31 UTC 40.87624 -121.68069 Burney 50 []
1060269 September 08, 2020 - 09:16:26 UTC 40.88818 -121.67088 Burney 50 [{"latitude": "40.8529", "longitude": "-121.76406"}, {"latitude": "40.85314", "longitude": "-121.75992"}, {"latitude": "40.87116", "longitude": "-121.66027"}, {"latitude": "40.87457", "longitude": "-121.65342"}, {"latitude": "40.93188", "longitude": "-121.56714"}, {"latitude": "40.95299", "longitude": "-121.56246"}, {"latitude": "40.96987", "longitude": "-121.58002"}, {"latitude": "40.97088", "longitude": "-121.58109"}, {"latitude": "40.97414", "longitude": "-121.58612"}, {"latitude": "40.96325", "longitude": "-121.65673"}, {"latitude": "40.94737", "longitude": "-121.73523"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1060321 September 08, 2020 - 09:29:54 UTC 40.88817 -121.67074 Burney 50 [{"latitude": "40.88188", "longitude": "-121.66252"}, {"latitude": "40.88189", "longitude": "-121.66008"}, {"latitude": "40.88784", "longitude": "-121.65237"}, {"latitude": "40.89081", "longitude": "-121.65089"}, {"latitude": "40.8947", "longitude": "-121.64996"}, {"latitude": "40.88884", "longitude": "-121.67064"}, {"latitude": "40.88778", "longitude": "-121.67098"}, {"latitude": "40.88259", "longitude": "-121.66849"}, {"latitude": "40.88199", "longitude": "-121.66642"}]
1062874 September 10, 2020 - 16:59:15 UTC 40.91449 -121.62926 Burney 50 []
1063279 September 10, 2020 - 19:01:06 UTC 40.9184 -121.62656 Burney 50 []
1063406 September 10, 2020 - 19:47:00 UTC 40.92563 -121.68538 Burney 50 []
1064524 September 11, 2020 - 17:28:15 UTC 40.96325 -121.65673 Burney 50 []
1064930 September 11, 2020 - 19:25:37 UTC 40.94622 -121.64775 Burney 50 []
1064990 September 11, 2020 - 21:00:10 UTC 40.87567 -121.67007 Burney 50 []
1068114 September 14, 2020 - 15:07:39 UTC 40.88561 -121.66101 Burney 50 []
1068919 September 14, 2020 - 17:05:00 UTC 40.88633 -121.66077 Burney 50 []
1070053 September 14, 2020 - 21:38:20 UTC 40.88103 -121.70837 Burney 50 []
1075334 September 16, 2020 - 19:03:43 UTC 40.88316 -121.70848 Burney 50 []
1078936 September 17, 2020 - 21:23:36 UTC 40.88265 -121.66716 Burney 50 []
1083735 September 21, 2020 - 14:42:27 UTC 40.87403 -121.66942 Burney 50 []
1084673 September 21, 2020 - 17:58:00 UTC 40.87729 -121.66181 Burney 50 []
1086735 September 22, 2020 - 15:13:16 UTC 40.87734 -121.66627 Burney 50 []
1088195 September 22, 2020 - 21:29:16 UTC 40.91527 -121.6292 Burney 50 []
1093721 September 26, 2020 - 14:25:29 UTC 40.88316 -121.70848 Burney 50 []
1093875 September 26, 2020 - 18:52:34 UTC 40.87729 -121.66181 Burney 50 []
1103158 October 01, 2020 - 15:02:00 UTC 40.88318 -121.66364 Burney 50 []
1103276 October 01, 2020 - 15:19:52 UTC 40.88368 -121.66778 Burney 50 []
1103515 October 01, 2020 - 16:12:55 UTC 40.88396 -121.66994 Burney 50 []
1103718 October 01, 2020 - 17:00:05 UTC 40.88372 -121.66713 Burney 50 []
1104013 October 01, 2020 - 18:07:50 UTC 40.88374 -121.66921 Burney 50 []
1105035 October 01, 2020 - 21:09:16 UTC 40.88884 -121.67064 Burney 50 []
1119860 October 17, 2020 - 18:30:45 UTC 41.02005 -121.68019 Burney 50 []
1125558 October 25, 2020 - 21:07:00 UTC 40.87947 -121.6747 Burney 50 [{"latitude": "40.8529", "longitude": "-121.76406"}, {"latitude": "40.85314", "longitude": "-121.75992"}, {"latitude": "40.87028", "longitude": "-121.69579"}, {"latitude": "40.8752", "longitude": "-121.68044"}, {"latitude": "40.8756", "longitude": "-121.67941"}, {"latitude": "40.87915", "longitude": "-121.67511"}, {"latitude": "40.90607", "longitude": "-121.82841"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1125561 October 25, 2020 - 21:07:00 UTC 40.91302 -121.64694 Burney 50 [{"latitude": "40.91358", "longitude": "-121.64695"}, {"latitude": "40.99113", "longitude": "-121.62556"}, {"latitude": "40.99165", "longitude": "-121.62575"}, {"latitude": "41.00198", "longitude": "-121.62985"}, {"latitude": "41.00394", "longitude": "-121.63179"}, {"latitude": "41.02251", "longitude": "-121.65592"}, {"latitude": "41.02277", "longitude": "-121.65743"}, {"latitude": "41.02127", "longitude": "-121.68112"}, {"latitude": "40.99841", "longitude": "-121.74705"}, {"latitude": "40.99805", "longitude": "-121.7476"}, {"latitude": "40.94737", "longitude": "-121.73523"}, {"latitude": "40.92837", "longitude": "-121.72526"}, {"latitude": "40.92041", "longitude": "-121.71936"}, {"latitude": "40.91574", "longitude": "-121.7094"}]
1125586 October 25, 2020 - 21:07:00 UTC 41.03173 -121.67191 Burney 50 [{"latitude": "41.03191", "longitude": "-121.63249"}, {"latitude": "41.03417", "longitude": "-121.62953"}, {"latitude": "41.077", "longitude": "-121.6294"}, {"latitude": "41.15179", "longitude": "-121.65102"}, {"latitude": "41.19965", "longitude": "-121.68311"}, {"latitude": "41.20079", "longitude": "-121.68503"}, {"latitude": "41.1996", "longitude": "-121.68917"}, {"latitude": "41.14175", "longitude": "-121.70904"}, {"latitude": "41.0475", "longitude": "-121.68666"}, {"latitude": "41.04097", "longitude": "-121.68268"}, {"latitude": "41.03821", "longitude": "-121.67608"}, {"latitude": "41.03755", "longitude": "-121.67449"}]
1125592 October 25, 2020 - 21:07:00 UTC 41.02144 -121.6772 Burney 50 [{"latitude": "41.0197", "longitude": "-121.67968"}, {"latitude": "41.01971", "longitude": "-121.67922"}, {"latitude": "41.02048", "longitude": "-121.67819"}, {"latitude": "41.02184", "longitude": "-121.677"}, {"latitude": "41.03122", "longitude": "-121.67213"}, {"latitude": "41.03662", "longitude": "-121.68441"}, {"latitude": "41.02005", "longitude": "-121.68019"}]
1126334 October 25, 2020 - 23:09:21 UTC 40.91576 -121.63195 Burney 50 []
1129303 October 25, 2020 - 21:07:00 UTC 40.9901 -121.62723 Burney 50 [{"latitude": "40.98971", "longitude": "-121.62616"}, {"latitude": "40.99113", "longitude": "-121.62556"}, {"latitude": "40.99165", "longitude": "-121.62575"}, {"latitude": "41.00198", "longitude": "-121.62985"}, {"latitude": "41.00394", "longitude": "-121.63179"}, {"latitude": "41.02251", "longitude": "-121.65592"}, {"latitude": "41.02277", "longitude": "-121.65743"}, {"latitude": "41.0211", "longitude": "-121.67688"}]
1136557 November 05, 2020 - 18:55:04 UTC 40.88277 -121.66308 Burney 50 []
1136700 November 05, 2020 - 20:53:42 UTC 40.88625 -121.66625 Burney 50 []
1136786 November 05, 2020 - 22:10:43 UTC 40.88315 -121.6648 Burney 50 []
1137757 November 06, 2020 - 22:03:54 UTC 40.88168 -121.7076 Burney 50 []
1140962 November 10, 2020 - 17:04:47 UTC 40.87552 -121.66568 Burney 50 []
1145453 November 15, 2020 - 16:30:00 UTC 40.8883 -121.67079 Burney 50 [{"latitude": "40.8524", "longitude": "-121.76551"}, {"latitude": "40.85265", "longitude": "-121.76132"}, {"latitude": "40.87116", "longitude": "-121.66027"}, {"latitude": "40.87457", "longitude": "-121.65342"}, {"latitude": "40.93218", "longitude": "-121.56672"}, {"latitude": "40.95466", "longitude": "-121.56038"}, {"latitude": "40.97088", "longitude": "-121.58109"}, {"latitude": "40.97421", "longitude": "-121.58617"}, {"latitude": "40.96371", "longitude": "-121.65804"}, {"latitude": "40.94737", "longitude": "-121.73523"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1145617 November 15, 2020 - 22:04:47 UTC 40.91364 -121.63189 Burney 50 []
1148136 November 18, 2020 - 12:38:59 UTC 40.88265 -121.66716 Burney 50 []
1154215 November 25, 2020 - 00:39:09 UTC 40.92209 -121.6217 Burney 50 []
1155502 November 28, 2020 - 18:27:16 UTC 40.92243 -121.62356 Burney 50 []
1167348 December 07, 2020 - 17:00:00 UTC 41.20005 -121.68421 Burney 50 []
1170412 December 08, 2020 - 16:29:05 UTC 40.89731 -121.63609 Burney 50 []
1171687 December 08, 2020 - 19:26:00 UTC 41.02152 -121.67851 Burney 50 [{"latitude": "41.0197", "longitude": "-121.67968"}, {"latitude": "41.01971", "longitude": "-121.67922"}, {"latitude": "41.02048", "longitude": "-121.67819"}, {"latitude": "41.02005", "longitude": "-121.68019"}]
1196220 December 21, 2020 - 16:05:26 UTC 40.87985 -121.67407 Burney 50 []
1201853 December 31, 2020 - 20:36:44 UTC 40.87985 -121.67407 Burney 50 []
1203914 January 04, 2021 - 21:52:40 UTC 40.92062 -121.62547 Burney 50 []
1204651 January 05, 2021 - 20:44:57 UTC 41.09331 -121.6391 Burney 50 []
1204762 January 05, 2021 - 23:00:35 UTC 40.92062 -121.62547 Burney 50 []
1210309 January 14, 2021 - 17:07:00 UTC 41.02167 -121.68021 Burney 50 [{"latitude": "41.0197", "longitude": "-121.67968"}, {"latitude": "41.01971", "longitude": "-121.67922"}, {"latitude": "41.03191", "longitude": "-121.63249"}, {"latitude": "41.03417", "longitude": "-121.62953"}, {"latitude": "41.077", "longitude": "-121.6294"}, {"latitude": "41.15179", "longitude": "-121.65102"}, {"latitude": "41.19965", "longitude": "-121.68311"}, {"latitude": "41.20079", "longitude": "-121.68503"}, {"latitude": "41.1996", "longitude": "-121.68917"}, {"latitude": "41.14175", "longitude": "-121.70904"}, {"latitude": "41.03662", "longitude": "-121.68441"}, {"latitude": "41.02005", "longitude": "-121.68019"}]
1218285 January 20, 2021 - 16:00:00 UTC 40.87607 -121.66623 Burney 50 []
1242439 January 30, 2021 - 02:06:41 UTC 40.87904 -121.67292 Burney 50 []
1251330 February 09, 2021 - 17:21:35 UTC 40.91905 -121.62901 Burney 50 []
1257100 February 18, 2021 - 16:32:00 UTC 40.87283 -121.66129 Burney 50 [{"latitude": "40.87064", "longitude": "-121.66736"}, {"latitude": "40.87096", "longitude": "-121.66467"}, {"latitude": "40.87134", "longitude": "-121.66249"}, {"latitude": "40.87315", "longitude": "-121.66302"}, {"latitude": "40.87317", "longitude": "-121.66921"}, {"latitude": "40.87299", "longitude": "-121.6704"}, {"latitude": "40.87136", "longitude": "-121.6693"}]
1257362 February 18, 2021 - 20:56:00 UTC 40.87188 -121.6642 Burney 50 []
1258871 February 21, 2021 - 16:45:00 UTC 40.8827 -121.66426 Burney 50 []
1259201 February 22, 2021 - 16:31:21 UTC 40.93126 -121.65386 Burney 50 []
1265176 March 02, 2021 - 16:02:00 UTC 40.87742 -121.66132 Burney 50 []
1270519 March 06, 2021 - 04:27:45 UTC 40.86976 -121.76618 Burney 50 [{"latitude": "40.8742", "longitude": "-121.77093"}, {"latitude": "40.90607", "longitude": "-121.82841"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1282762 March 15, 2021 - 16:20:01 UTC 40.87855 -121.65796 Burney 50 []
1289649 March 20, 2021 - 14:32:00 UTC 40.89323 -121.65079 Burney 50 []
1290677 March 21, 2021 - 05:38:22 UTC 40.93763 -121.72706 Burney 50 []
1290721 March 21, 2021 - 13:56:00 UTC 40.92993 -121.72544 Burney 50 [{"latitude": "40.93763", "longitude": "-121.72706"}, {"latitude": "40.9429", "longitude": "-121.72233"}, {"latitude": "40.94737", "longitude": "-121.73523"}]
1290951 March 22, 2021 - 01:46:24 UTC 40.93839 -121.72712 Burney 50 []
1296666 March 25, 2021 - 14:10:49 UTC 40.87067 -121.69714 Burney 50 []
1301980 March 28, 2021 - 21:01:12 UTC 40.87067 -121.69714 Burney 50 []
1302500 March 29, 2021 - 18:37:26 UTC 41.03097 -121.68215 Burney 50 []
1304425 March 31, 2021 - 20:28:33 UTC 40.92062 -121.62547 Burney 50 []
1310381 April 08, 2021 - 15:00:38 UTC 40.903 -121.64782 Burney 50 [{"latitude": "40.90295", "longitude": "-121.64556"}, {"latitude": "40.90298", "longitude": "-121.64121"}, {"latitude": "40.90299", "longitude": "-121.64227"}, {"latitude": "40.90302", "longitude": "-121.65319"}]
1313058 April 11, 2021 - 21:22:30 UTC 40.91744 -121.63019 Burney 50 []
1323442 April 19, 2021 - 19:28:27 UTC 40.94918 -121.64683 Burney 50 []
1325399 April 20, 2021 - 19:50:28 UTC 40.91548 -121.62883 Burney 50 []
1336733 April 29, 2021 - 15:33:15 UTC 40.903 -121.64782 Burney 50 [{"latitude": "40.90295", "longitude": "-121.64556"}, {"latitude": "40.90298", "longitude": "-121.64121"}, {"latitude": "40.90299", "longitude": "-121.64227"}, {"latitude": "40.90302", "longitude": "-121.65319"}]
1338148 April 30, 2021 - 23:29:00 UTC 40.89081 -121.65089 Burney 50 []
1338149 April 30, 2021 - 23:30:00 UTC 40.88174 -121.64766 Burney 50 []
1338150 April 30, 2021 - 23:30:00 UTC 40.88401 -121.66083 Burney 50 []
1338175 April 30, 2021 - 23:26:00 UTC 40.88829 -121.67079 Burney 50 [{"latitude": "40.8524", "longitude": "-121.76551"}, {"latitude": "40.85265", "longitude": "-121.76132"}, {"latitude": "40.87124", "longitude": "-121.66027"}, {"latitude": "40.87457", "longitude": "-121.65342"}, {"latitude": "40.93218", "longitude": "-121.56672"}, {"latitude": "40.95466", "longitude": "-121.56038"}, {"latitude": "40.97088", "longitude": "-121.58109"}, {"latitude": "40.97421", "longitude": "-121.58617"}, {"latitude": "40.96371", "longitude": "-121.65804"}, {"latitude": "40.94737", "longitude": "-121.73523"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1338191 May 01, 2021 - 00:09:00 UTC 40.88829 -121.67079 Burney 50 [{"latitude": "40.8524", "longitude": "-121.76551"}, {"latitude": "40.85265", "longitude": "-121.76132"}, {"latitude": "40.87124", "longitude": "-121.66027"}, {"latitude": "40.87457", "longitude": "-121.65342"}, {"latitude": "40.93218", "longitude": "-121.56672"}, {"latitude": "40.95466", "longitude": "-121.56038"}, {"latitude": "40.97088", "longitude": "-121.58109"}, {"latitude": "40.97421", "longitude": "-121.58617"}, {"latitude": "40.96371", "longitude": "-121.65804"}, {"latitude": "40.94737", "longitude": "-121.73523"}, {"latitude": "40.9059", "longitude": "-121.82893"}, {"latitude": "40.90518", "longitude": "-121.82858"}]
1338248 May 01, 2021 - 01:12:00 UTC 41.04161 -121.67016 Burney 50 []

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