174 rows where regionName = 1

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633492 October 01, 2019 - 06:42:00 UTC 37.09211 -119.55301 Auberry 1 [{"latitude": "37.07158", "longitude": "-119.55997"}, {"latitude": "37.08179", "longitude": "-119.48869"}, {"latitude": "37.09631", "longitude": "-119.47547"}, {"latitude": "37.117", "longitude": "-119.50395"}, {"latitude": "37.12482", "longitude": "-119.51752"}, {"latitude": "37.12727", "longitude": "-119.52403"}, {"latitude": "37.13099", "longitude": "-119.60005"}, {"latitude": "37.11367", "longitude": "-119.65236"}, {"latitude": "37.09416", "longitude": "-119.62977"}, {"latitude": "37.09", "longitude": "-119.62078"}]
633900 October 01, 2019 - 17:09:36 UTC 37.09187 -119.51418 Auberry 1 []
633942 October 01, 2019 - 17:34:44 UTC 37.09249 -119.52935 Auberry 1 []
641099 October 03, 2019 - 21:16:37 UTC 37.07694 -119.5083 Auberry 1 []
643962 October 05, 2019 - 14:54:32 UTC 37.06583 -119.50928 Auberry 1 []
644253 October 05, 2019 - 16:26:28 UTC 37.06364 -119.50806 Auberry 1 []
644493 October 05, 2019 - 17:11:08 UTC 37.07264 -119.49984 Auberry 1 []
644724 October 05, 2019 - 19:19:59 UTC 37.0687 -119.52346 Auberry 1 []
644753 October 05, 2019 - 20:41:06 UTC 37.062 -119.51083 Auberry 1 []
645826 October 07, 2019 - 15:06:00 UTC 37.05822 -119.48997 Auberry 1 []
646142 October 07, 2019 - 18:44:24 UTC 37.05103 -119.48744 Auberry 1 []
646146 October 07, 2019 - 18:52:48 UTC 37.0498 -119.47022 Auberry 1 []
647081 October 08, 2019 - 14:40:00 UTC 37.09553 -119.49743 Auberry 1 []
647524 October 08, 2019 - 20:24:57 UTC 37.07023 -119.42732 Auberry 1 []
654608 October 11, 2019 - 21:57:11 UTC 37.07808 -119.43183 Auberry 1 []
658847 October 15, 2019 - 15:17:00 UTC 37.05849 -119.43635 Auberry 1 [{"latitude": "37.04623", "longitude": "-119.41756"}, {"latitude": "37.04816", "longitude": "-119.40932"}, {"latitude": "37.0489", "longitude": "-119.40979"}, {"latitude": "37.04985", "longitude": "-119.41227"}, {"latitude": "37.0505", "longitude": "-119.41897"}, {"latitude": "37.05054", "longitude": "-119.42027"}, {"latitude": "37.04851", "longitude": "-119.41946"}]
662363 October 16, 2019 - 21:21:19 UTC 37.08015 -119.51448 Auberry 1 []
664028 October 17, 2019 - 15:50:00 UTC 37.06724 -119.52333 Auberry 1 [{"latitude": "37.06453", "longitude": "-119.52367"}, {"latitude": "37.06565", "longitude": "-119.52228"}, {"latitude": "37.06631", "longitude": "-119.52301"}]
664082 October 17, 2019 - 16:10:24 UTC 37.06635 -119.52636 Auberry 1 []
680245 October 25, 2019 - 15:23:00 UTC 37.06884 -119.49012 Auberry 1 []
688931 October 27, 2019 - 20:37:37 UTC 37.06622 -119.50391 Auberry 1 [{"latitude": "37.05532", "longitude": "-119.51253"}, {"latitude": "37.05664", "longitude": "-119.51128"}, {"latitude": "37.06088", "longitude": "-119.50797"}, {"latitude": "37.07264", "longitude": "-119.49984"}, {"latitude": "37.07994", "longitude": "-119.5017"}, {"latitude": "37.08127", "longitude": "-119.50443"}, {"latitude": "37.08482", "longitude": "-119.527"}, {"latitude": "37.07049", "longitude": "-119.53448"}]
689184 October 27, 2019 - 20:52:00 UTC 37.09211 -119.55301 Auberry 1 [{"latitude": "37.07158", "longitude": "-119.55997"}, {"latitude": "37.08179", "longitude": "-119.48869"}, {"latitude": "37.09631", "longitude": "-119.47547"}, {"latitude": "37.117", "longitude": "-119.50395"}, {"latitude": "37.12482", "longitude": "-119.51752"}, {"latitude": "37.12727", "longitude": "-119.52403"}, {"latitude": "37.13099", "longitude": "-119.60005"}, {"latitude": "37.11367", "longitude": "-119.65236"}, {"latitude": "37.09416", "longitude": "-119.62977"}, {"latitude": "37.09", "longitude": "-119.62078"}]
689540 October 27, 2019 - 21:40:23 UTC 37.06887 -119.48181 Auberry 1 []
689544 October 27, 2019 - 21:40:46 UTC 37.05459 -119.46851 Auberry 1 []
689558 October 27, 2019 - 21:41:21 UTC 37.05633 -119.48635 Auberry 1 []
689559 October 27, 2019 - 21:41:24 UTC 37.06048 -119.47818 Auberry 1 []
689560 October 27, 2019 - 21:41:21 UTC 37.05967 -119.39093 Auberry 1 []
689561 October 27, 2019 - 21:41:21 UTC 37.05973 -119.39124 Auberry 1 []
689562 October 27, 2019 - 21:41:21 UTC 37.08874 -119.42079 Auberry 1 []
689563 October 27, 2019 - 21:41:21 UTC 37.08834 -119.42073 Auberry 1 []
689564 October 27, 2019 - 21:41:21 UTC 37.08744 -119.4208 Auberry 1 []
689565 October 27, 2019 - 21:41:24 UTC 37.08456 -119.41618 Auberry 1 []
689566 October 27, 2019 - 21:41:24 UTC 37.0646 -119.41034 Auberry 1 []
689567 October 27, 2019 - 21:41:21 UTC 37.05864 -119.37711 Auberry 1 []
689568 October 27, 2019 - 21:41:21 UTC 37.05815 -119.38484 Auberry 1 []
689572 October 27, 2019 - 21:41:24 UTC 37.05521 -119.36137 Auberry 1 []
689573 October 27, 2019 - 21:41:21 UTC 37.04445 -119.38111 Auberry 1 []
689574 October 27, 2019 - 21:41:21 UTC 37.03908 -119.38905 Auberry 1 []
689575 October 27, 2019 - 21:41:21 UTC 37.04328 -119.38114 Auberry 1 []
689576 October 27, 2019 - 21:41:21 UTC 37.04556 -119.37402 Auberry 1 []
689577 October 27, 2019 - 21:41:24 UTC 37.05868 -119.37711 Auberry 1 []
689578 October 27, 2019 - 21:41:24 UTC 37.05837 -119.38559 Auberry 1 []
689579 October 27, 2019 - 21:41:21 UTC 37.0479 -119.41522 Auberry 1 []
689592 October 27, 2019 - 21:41:21 UTC 37.08963 -119.47515 Auberry 1 []
689593 October 27, 2019 - 21:41:21 UTC 37.12776 -119.45333 Auberry 1 []
689594 October 27, 2019 - 21:41:25 UTC 37.08763 -119.46878 Auberry 1 []
689595 October 27, 2019 - 21:41:21 UTC 37.05528 -119.48258 Auberry 1 []
689650 October 27, 2019 - 21:45:55 UTC 37.07571 -119.48332 Auberry 1 []
689816 October 27, 2019 - 21:33:00 UTC 37.0536 -119.46142 Auberry 1 [{"latitude": "37.03228", "longitude": "-119.33411"}, {"latitude": "37.03258", "longitude": "-119.26416"}, {"latitude": "37.03617", "longitude": "-119.24334"}, {"latitude": "37.0381", "longitude": "-119.24383"}, {"latitude": "37.09172", "longitude": "-119.33324"}, {"latitude": "37.09209", "longitude": "-119.3356"}, {"latitude": "37.0934", "longitude": "-119.41972"}, {"latitude": "37.05478", "longitude": "-119.45929"}, {"latitude": "37.03908", "longitude": "-119.38905"}, {"latitude": "37.0335", "longitude": "-119.35082"}]
689872 October 27, 2019 - 21:33:00 UTC 37.08115 -119.48766 Auberry 1 [{"latitude": "37.08123", "longitude": "-119.48769"}, {"latitude": "37.08402", "longitude": "-119.4781"}, {"latitude": "37.08832", "longitude": "-119.4692"}, {"latitude": "37.08977", "longitude": "-119.46825"}, {"latitude": "37.09118", "longitude": "-119.46944"}, {"latitude": "37.09235", "longitude": "-119.47611"}, {"latitude": "37.08769", "longitude": "-119.48818"}]
689883 October 27, 2019 - 21:33:00 UTC 37.08763 -119.46878 Auberry 1 [{"latitude": "37.06476", "longitude": "-119.43962"}, {"latitude": "37.06626", "longitude": "-119.4269"}, {"latitude": "37.06854", "longitude": "-119.42495"}, {"latitude": "37.09822", "longitude": "-119.42055"}, {"latitude": "37.10762", "longitude": "-119.42118"}, {"latitude": "37.11007", "longitude": "-119.42508"}, {"latitude": "37.08727", "longitude": "-119.46862"}, {"latitude": "37.07706", "longitude": "-119.46794"}, {"latitude": "37.07641", "longitude": "-119.46755"}, {"latitude": "37.07616", "longitude": "-119.46723"}]
689898 October 27, 2019 - 21:33:00 UTC 37.09064 -119.46857 Auberry 1 [{"latitude": "37.10106", "longitude": "-119.46157"}, {"latitude": "37.1094", "longitude": "-119.45059"}, {"latitude": "37.13782", "longitude": "-119.42126"}, {"latitude": "37.1379", "longitude": "-119.42274"}, {"latitude": "37.13474", "longitude": "-119.44842"}, {"latitude": "37.13111", "longitude": "-119.4517"}, {"latitude": "37.12127", "longitude": "-119.45961"}]
689923 October 27, 2019 - 21:33:00 UTC 37.05896 -119.38766 Auberry 1 [{"latitude": "37.03228", "longitude": "-119.33411"}, {"latitude": "37.03258", "longitude": "-119.26416"}, {"latitude": "37.03617", "longitude": "-119.24334"}, {"latitude": "37.0381", "longitude": "-119.24383"}, {"latitude": "37.09172", "longitude": "-119.33324"}, {"latitude": "37.09209", "longitude": "-119.3356"}, {"latitude": "37.09175", "longitude": "-119.33727"}, {"latitude": "37.08965", "longitude": "-119.3429"}, {"latitude": "37.05894", "longitude": "-119.38756"}, {"latitude": "37.0439", "longitude": "-119.3905"}, {"latitude": "37.03908", "longitude": "-119.38905"}, {"latitude": "37.0335", "longitude": "-119.35082"}]
690008 October 27, 2019 - 21:33:00 UTC 37.05301 -119.3706 Auberry 1 [{"latitude": "37.03228", "longitude": "-119.33411"}, {"latitude": "37.03258", "longitude": "-119.26416"}, {"latitude": "37.03617", "longitude": "-119.24334"}, {"latitude": "37.0381", "longitude": "-119.24383"}, {"latitude": "37.03887", "longitude": "-119.24667"}, {"latitude": "37.05452", "longitude": "-119.31686"}, {"latitude": "37.0549", "longitude": "-119.32063"}, {"latitude": "37.05599", "longitude": "-119.36472"}, {"latitude": "37.04721", "longitude": "-119.36975"}, {"latitude": "37.04452", "longitude": "-119.37128"}, {"latitude": "37.0335", "longitude": "-119.35082"}]
690317 October 27, 2019 - 20:52:00 UTC 37.09877 -119.51869 Auberry 1 [{"latitude": "37.11384", "longitude": "-119.50431"}, {"latitude": "37.11392", "longitude": "-119.50394"}, {"latitude": "37.11518", "longitude": "-119.50273"}, {"latitude": "37.117", "longitude": "-119.50395"}, {"latitude": "37.12482", "longitude": "-119.51752"}, {"latitude": "37.12727", "longitude": "-119.52403"}]
690322 October 27, 2019 - 20:52:00 UTC 37.09266 -119.55192 Auberry 1 [{"latitude": "37.08992", "longitude": "-119.59557"}, {"latitude": "37.10504", "longitude": "-119.59209"}, {"latitude": "37.11926", "longitude": "-119.59049"}, {"latitude": "37.13099", "longitude": "-119.60005"}, {"latitude": "37.11367", "longitude": "-119.65236"}, {"latitude": "37.09416", "longitude": "-119.62977"}, {"latitude": "37.09", "longitude": "-119.62078"}, {"latitude": "37.08993", "longitude": "-119.61814"}]
691480 October 28, 2019 - 16:10:00 UTC 37.06838 -119.49617 Auberry 1 []
691512 October 28, 2019 - 13:06:24 UTC 37.06819 -119.49628 Auberry 1 [{"latitude": "36.96613", "longitude": "-119.52316"}, {"latitude": "36.96684", "longitude": "-119.52129"}, {"latitude": "36.9712", "longitude": "-119.5124"}, {"latitude": "37.02367", "longitude": "-119.46101"}, {"latitude": "37.05095", "longitude": "-119.47044"}, {"latitude": "37.05277", "longitude": "-119.47186"}, {"latitude": "37.06318", "longitude": "-119.48896"}, {"latitude": "37.06785", "longitude": "-119.49799"}, {"latitude": "37.0616", "longitude": "-119.59241"}, {"latitude": "37.05747", "longitude": "-119.59547"}, {"latitude": "37.01047", "longitude": "-119.584"}, {"latitude": "37.00375", "longitude": "-119.58176"}, {"latitude": "36.99693", "longitude": "-119.57538"}, {"latitude": "36.97478", "longitude": "-119.54082"}, {"latitude": "36.96767", "longitude": "-119.52669"}]
692267 October 27, 2019 - 20:52:00 UTC 37.09293 -119.54754 Auberry 1 []
692269 October 27, 2019 - 20:52:00 UTC 37.09239 -119.52571 Auberry 1 [{"latitude": "37.08177", "longitude": "-119.48978"}, {"latitude": "37.08179", "longitude": "-119.48869"}, {"latitude": "37.09631", "longitude": "-119.47547"}, {"latitude": "37.10925", "longitude": "-119.49508"}, {"latitude": "37.11015", "longitude": "-119.50266"}, {"latitude": "37.09851", "longitude": "-119.51884"}, {"latitude": "37.09294", "longitude": "-119.52525"}, {"latitude": "37.08325", "longitude": "-119.51713"}]
692336 October 27, 2019 - 21:33:00 UTC 37.11421 -119.44817 Auberry 1 [{"latitude": "37.11594", "longitude": "-119.44865"}, {"latitude": "37.13049", "longitude": "-119.4291"}, {"latitude": "37.13782", "longitude": "-119.42126"}, {"latitude": "37.1379", "longitude": "-119.42274"}, {"latitude": "37.13474", "longitude": "-119.44842"}, {"latitude": "37.13111", "longitude": "-119.4517"}, {"latitude": "37.12127", "longitude": "-119.45961"}]
693089 October 29, 2019 - 13:43:06 UTC 37.07151 -119.49006 Auberry 1 []
698205 November 02, 2019 - 17:33:40 UTC 37.09822 -119.42055 Auberry 1 []
704326 November 11, 2019 - 17:50:09 UTC 37.04624 -119.50054 Auberry 1 []
708678 November 17, 2019 - 18:51:46 UTC 37.07997 -119.43091 Auberry 1 []
710935 November 20, 2019 - 16:09:56 UTC 37.04487 -119.50003 Auberry 1 []
710936 November 20, 2019 - 16:10:04 UTC 37.0451 -119.49928 Auberry 1 []
711347 November 20, 2019 - 17:35:38 UTC 37.0442 -119.49926 Auberry 1 []
711348 November 20, 2019 - 17:35:37 UTC 37.04487 -119.50003 Auberry 1 []
712203 November 21, 2019 - 17:57:57 UTC 37.05132 -119.48054 Auberry 1 []
712231 November 21, 2019 - 18:26:41 UTC 37.07253 -119.53162 Auberry 1 []
712289 November 21, 2019 - 19:33:13 UTC 37.05015 -119.48006 Auberry 1 []
712307 November 21, 2019 - 20:03:34 UTC 37.06103 -119.47988 Auberry 1 []
712647 November 22, 2019 - 15:18:45 UTC 37.05476 -119.46957 Auberry 1 []
712749 November 22, 2019 - 16:51:00 UTC 37.03602 -119.48664 Auberry 1 []
712840 November 22, 2019 - 17:29:43 UTC 37.08149 -119.41124 Auberry 1 []
712945 November 22, 2019 - 19:17:21 UTC 37.08058 -119.42756 Auberry 1 []
713117 November 22, 2019 - 23:19:03 UTC 37.04624 -119.50054 Auberry 1 []
713313 November 23, 2019 - 15:34:11 UTC 37.06121 -119.53935 Auberry 1 []
713314 November 23, 2019 - 15:41:12 UTC 37.05575 -119.5268 Auberry 1 []
714121 November 25, 2019 - 15:37:54 UTC 37.07964 -119.4275 Auberry 1 []
714732 November 25, 2019 - 23:18:18 UTC 37.04333 -119.50767 Auberry 1 []
721079 November 27, 2019 - 18:19:00 UTC 37.0415 -119.34332 Auberry 1 [{"latitude": "37.04183", "longitude": "-119.34388"}, {"latitude": "37.04391", "longitude": "-119.34106"}, {"latitude": "37.04419", "longitude": "-119.34502"}, {"latitude": "37.04412", "longitude": "-119.34571"}, {"latitude": "37.04375", "longitude": "-119.34672"}]
722420 November 28, 2019 - 05:41:19 UTC 37.05301 -119.3706 Auberry 1 [{"latitude": "37.03228", "longitude": "-119.33411"}, {"latitude": "37.03258", "longitude": "-119.26416"}, {"latitude": "37.03617", "longitude": "-119.24334"}, {"latitude": "37.0381", "longitude": "-119.24383"}, {"latitude": "37.03887", "longitude": "-119.24667"}, {"latitude": "37.05452", "longitude": "-119.31686"}, {"latitude": "37.0549", "longitude": "-119.32063"}, {"latitude": "37.05599", "longitude": "-119.36472"}, {"latitude": "37.04721", "longitude": "-119.36975"}, {"latitude": "37.04452", "longitude": "-119.37128"}, {"latitude": "37.0335", "longitude": "-119.35082"}]
722932 November 28, 2019 - 19:43:47 UTC 37.05521 -119.36137 Auberry 1 [{"latitude": "37.0435", "longitude": "-119.35611"}, {"latitude": "37.04954", "longitude": "-119.35523"}, {"latitude": "37.05313", "longitude": "-119.35588"}, {"latitude": "37.05455", "longitude": "-119.35999"}, {"latitude": "37.0482", "longitude": "-119.35894"}, {"latitude": "37.04351", "longitude": "-119.35689"}]
723413 November 29, 2019 - 16:50:37 UTC 37.05054 -119.42027 Auberry 1 []
727366 December 02, 2019 - 18:13:40 UTC 37.09579 -119.49659 Auberry 1 []
730300 December 05, 2019 - 16:25:00 UTC 37.08341 -119.48823 Auberry 1 []
732399 December 07, 2019 - 17:07:00 UTC 37.07458 -119.42846 Auberry 1 [{"latitude": "37.07556", "longitude": "-119.42821"}, {"latitude": "37.08026", "longitude": "-119.42612"}, {"latitude": "37.09822", "longitude": "-119.42055"}, {"latitude": "37.10762", "longitude": "-119.42118"}, {"latitude": "37.11007", "longitude": "-119.42508"}, {"latitude": "37.09875", "longitude": "-119.4463"}, {"latitude": "37.09699", "longitude": "-119.44624"}]
734437 December 09, 2019 - 18:30:09 UTC 37.06048 -119.47818 Auberry 1 [{"latitude": "37.0547", "longitude": "-119.48045"}, {"latitude": "37.0552", "longitude": "-119.47702"}, {"latitude": "37.05936", "longitude": "-119.47873"}, {"latitude": "37.06045", "longitude": "-119.47938"}, {"latitude": "37.06103", "longitude": "-119.47988"}, {"latitude": "37.05858", "longitude": "-119.48035"}, {"latitude": "37.05562", "longitude": "-119.48075"}]
734454 December 09, 2019 - 18:41:00 UTC 37.05528 -119.48258 Auberry 1 []
734595 December 09, 2019 - 19:53:00 UTC 37.05528 -119.48258 Auberry 1 []
734685 December 09, 2019 - 18:30:09 UTC 37.05504 -119.47934 Auberry 1 []
785911 February 10, 2020 - 01:35:45 UTC 37.11015 -119.50266 Auberry 1 []
789110 February 12, 2020 - 02:32:59 UTC 37.07884 -119.43181 Auberry 1 []
1058706 September 07, 2020 - 23:09:47 UTC 37.0536 -119.46142 Auberry 1 [{"latitude": "37.03228", "longitude": "-119.33411"}, {"latitude": "37.03258", "longitude": "-119.26416"}, {"latitude": "37.03617", "longitude": "-119.24334"}, {"latitude": "37.0381", "longitude": "-119.24383"}, {"latitude": "37.0934", "longitude": "-119.41972"}, {"latitude": "37.05478", "longitude": "-119.45929"}, {"latitude": "37.03908", "longitude": "-119.38905"}, {"latitude": "37.0335", "longitude": "-119.35082"}]
1058722 September 07, 2020 - 23:15:00 UTC 37.08115 -119.48766 Auberry 1 [{"latitude": "37.06476", "longitude": "-119.43962"}, {"latitude": "37.06626", "longitude": "-119.4269"}, {"latitude": "37.06854", "longitude": "-119.42495"}, {"latitude": "37.09822", "longitude": "-119.42055"}, {"latitude": "37.13782", "longitude": "-119.42126"}, {"latitude": "37.1379", "longitude": "-119.42274"}, {"latitude": "37.13474", "longitude": "-119.44842"}, {"latitude": "37.13111", "longitude": "-119.4517"}, {"latitude": "37.08769", "longitude": "-119.48818"}, {"latitude": "37.08123", "longitude": "-119.48769"}]
1068992 September 14, 2020 - 18:09:29 UTC 37.07562 -119.43402 Auberry 1 []
1070361 September 14, 2020 - 23:00:00 UTC 37.063 -119.41015 Auberry 1 []
1070555 September 15, 2020 - 01:20:00 UTC 37.08229 -119.41474 Auberry 1 []

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