135 rows where regionName = 8

View and edit SQL

Suggested facets: outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
633435 October 01, 2019 - 01:45:58 UTC 36.81337 -120.25931 Firebaugh 8 [{"latitude": "36.81427", "longitude": "-120.27279"}, {"latitude": "36.81428", "longitude": "-120.26792"}, {"latitude": "36.81431", "longitude": "-120.25973"}, {"latitude": "36.82184", "longitude": "-120.29503"}, {"latitude": "36.81443", "longitude": "-120.29517"}]
638921 October 03, 2019 - 09:39:31 UTC 36.85206 -120.52709 Firebaugh 8 [{"latitude": "36.86075", "longitude": "-120.52704"}, {"latitude": "36.86735", "longitude": "-120.51785"}, {"latitude": "36.87321", "longitude": "-120.527"}, {"latitude": "36.87382", "longitude": "-120.54116"}, {"latitude": "36.86326", "longitude": "-120.53828"}, {"latitude": "36.86234", "longitude": "-120.53535"}]
639014 October 03, 2019 - 15:08:50 UTC 36.89543 -120.58537 Firebaugh 8 [{"latitude": "36.91251", "longitude": "-120.59395"}, {"latitude": "36.91259", "longitude": "-120.5852"}, {"latitude": "36.91274", "longitude": "-120.58575"}, {"latitude": "36.91657", "longitude": "-120.60871"}, {"latitude": "36.91652", "longitude": "-120.60857"}, {"latitude": "36.91254", "longitude": "-120.59465"}]
641576 October 03, 2019 - 22:32:00 UTC 36.89413 -120.65227 Firebaugh 8 [{"latitude": "36.87102", "longitude": "-120.56316"}, {"latitude": "36.89067", "longitude": "-120.5094"}, {"latitude": "36.89124", "longitude": "-120.50867"}, {"latitude": "36.90989", "longitude": "-120.50908"}, {"latitude": "36.96703", "longitude": "-120.52081"}, {"latitude": "36.97804", "longitude": "-120.54533"}, {"latitude": "36.97653", "longitude": "-120.56144"}, {"latitude": "36.97147", "longitude": "-120.59896"}, {"latitude": "36.92034", "longitude": "-120.64532"}, {"latitude": "36.89415", "longitude": "-120.64917"}, {"latitude": "36.88721", "longitude": "-120.63602"}, {"latitude": "36.88333", "longitude": "-120.62675"}]
645027 October 05, 2019 - 23:16:08 UTC 36.86 -120.45847 Firebaugh 8 []
651504 October 09, 2019 - 23:17:31 UTC 36.909 -120.62639 Firebaugh 8 []
656415 October 14, 2019 - 16:58:59 UTC 36.86735 -120.51785 Firebaugh 8 []
657413 October 14, 2019 - 19:11:17 UTC 36.85423 -120.45074 Firebaugh 8 []
657655 October 14, 2019 - 19:44:30 UTC 36.79988 -120.43397 Firebaugh 8 []
658925 October 15, 2019 - 14:34:00 UTC 36.886 -120.65585 Firebaugh 8 []
658929 October 15, 2019 - 14:35:00 UTC 36.88602 -120.65585 Firebaugh 8 []
659053 October 15, 2019 - 17:14:49 UTC 36.79468 -120.30882 Firebaugh 8 []
659760 October 15, 2019 - 20:13:42 UTC 36.85087 -120.5278 Firebaugh 8 []
663153 October 17, 2019 - 00:29:59 UTC 36.8501 -120.44872 Firebaugh 8 []
663941 October 17, 2019 - 15:31:43 UTC 36.88729 -120.44634 Firebaugh 8 []
668535 October 18, 2019 - 17:07:33 UTC 36.86617 -120.4577 Firebaugh 8 []
673753 October 19, 2019 - 21:28:45 UTC 36.77805 -120.7294 Firebaugh 8 [{"latitude": "36.76323", "longitude": "-120.74736"}, {"latitude": "36.76359", "longitude": "-120.73836"}, {"latitude": "36.76361", "longitude": "-120.73793"}, {"latitude": "36.77112", "longitude": "-120.73375"}, {"latitude": "36.77788", "longitude": "-120.75612"}, {"latitude": "36.77766", "longitude": "-120.76386"}, {"latitude": "36.77439", "longitude": "-120.76698"}]
674785 October 20, 2019 - 16:28:32 UTC 36.89524 -120.68145 Firebaugh 8 []
676466 October 21, 2019 - 23:52:30 UTC 36.77805 -120.7294 Firebaugh 8 [{"latitude": "36.76323", "longitude": "-120.74736"}, {"latitude": "36.76359", "longitude": "-120.73836"}, {"latitude": "36.76361", "longitude": "-120.73793"}, {"latitude": "36.77112", "longitude": "-120.73375"}, {"latitude": "36.77788", "longitude": "-120.75612"}, {"latitude": "36.77766", "longitude": "-120.76386"}, {"latitude": "36.77439", "longitude": "-120.76698"}]
694018 October 29, 2019 - 19:42:05 UTC 36.78001 -120.72902 Firebaugh 8 []
696597 October 31, 2019 - 17:31:45 UTC 36.85924 -120.76365 Firebaugh 8 []
697056 November 01, 2019 - 00:14:48 UTC 36.8228 -120.72877 Firebaugh 8 []
697462 November 01, 2019 - 18:22:21 UTC 36.81441 -120.46099 Firebaugh 8 []
697956 November 02, 2019 - 00:49:02 UTC 36.8228 -120.72877 Firebaugh 8 []
697958 November 02, 2019 - 00:52:08 UTC 36.85924 -120.76365 Firebaugh 8 []
698360 November 02, 2019 - 23:48:49 UTC 36.77413 -120.72063 Firebaugh 8 []
700717 November 06, 2019 - 16:32:00 UTC 36.80546 -120.49462 Firebaugh 8 [{"latitude": "36.80073", "longitude": "-120.47637"}, {"latitude": "36.80822", "longitude": "-120.47631"}, {"latitude": "36.81047", "longitude": "-120.47846"}, {"latitude": "36.81779", "longitude": "-120.49417"}, {"latitude": "36.81711", "longitude": "-120.49419"}, {"latitude": "36.80698", "longitude": "-120.48534"}]
704863 November 12, 2019 - 17:33:21 UTC 37.04717 -120.49245 Firebaugh 8 [{"latitude": "37.04356", "longitude": "-120.49716"}, {"latitude": "37.04716", "longitude": "-120.49249"}, {"latitude": "37.04718", "longitude": "-120.50124"}]
705672 November 13, 2019 - 09:02:00 UTC 36.88616 -120.6558 Firebaugh 8 [{"latitude": "36.7875", "longitude": "-120.75747"}, {"latitude": "36.78908", "longitude": "-120.74706"}, {"latitude": "36.81748", "longitude": "-120.69607"}, {"latitude": "36.836", "longitude": "-120.67203"}, {"latitude": "36.83621", "longitude": "-120.67179"}, {"latitude": "36.88333", "longitude": "-120.65392"}, {"latitude": "36.8905", "longitude": "-120.65483"}, {"latitude": "36.89114", "longitude": "-120.65521"}, {"latitude": "36.95229", "longitude": "-120.70425"}, {"latitude": "36.98036", "longitude": "-120.81918"}, {"latitude": "36.97529", "longitude": "-120.86075"}, {"latitude": "36.9694", "longitude": "-120.86965"}, {"latitude": "36.96862", "longitude": "-120.8693"}, {"latitude": "36.92627", "longitude": "-120.84545"}, {"latitude": "36.78901", "longitude": "-120.76525"}]
706366 November 13, 2019 - 23:54:34 UTC 36.86276 -120.46122 Firebaugh 8 [{"latitude": "36.86294", "longitude": "-120.46116"}, {"latitude": "36.86329", "longitude": "-120.46067"}, {"latitude": "36.86358", "longitude": "-120.46035"}]
706795 November 14, 2019 - 18:25:04 UTC 36.86345 -120.46183 Firebaugh 8 [{"latitude": "36.86337", "longitude": "-120.46151"}, {"latitude": "36.86424", "longitude": "-120.46055"}, {"latitude": "36.86393", "longitude": "-120.46148"}]
707028 November 14, 2019 - 23:10:33 UTC 36.85825 -120.4192 Firebaugh 8 []
710144 November 19, 2019 - 19:27:57 UTC 36.94835 -120.58611 Firebaugh 8 []
710292 November 19, 2019 - 22:03:12 UTC 36.85077 -120.59085 Firebaugh 8 []
711513 November 20, 2019 - 19:18:00 UTC 36.85406 -120.45567 Firebaugh 8 []
712222 November 21, 2019 - 18:24:33 UTC 36.93431 -120.69886 Firebaugh 8 []
712325 November 21, 2019 - 20:30:46 UTC 36.77984 -120.29558 Firebaugh 8 []
712838 November 22, 2019 - 17:29:11 UTC 36.83617 -120.64048 Firebaugh 8 []
714328 November 25, 2019 - 18:59:27 UTC 36.84582 -120.61763 Firebaugh 8 []
714381 November 25, 2019 - 19:42:14 UTC 36.86428 -120.45708 Firebaugh 8 []
719499 November 27, 2019 - 08:03:51 UTC 36.85819 -120.43903 Firebaugh 8 [{"latitude": "36.85184", "longitude": "-120.43634"}, {"latitude": "36.85312", "longitude": "-120.43523"}, {"latitude": "36.85582", "longitude": "-120.43606"}, {"latitude": "36.85622", "longitude": "-120.43661"}, {"latitude": "36.85765", "longitude": "-120.43904"}, {"latitude": "36.85764", "longitude": "-120.43973"}, {"latitude": "36.85762", "longitude": "-120.44107"}, {"latitude": "36.8567", "longitude": "-120.44101"}]
720512 November 27, 2019 - 16:00:04 UTC 36.87593 -120.47671 Firebaugh 8 []
720936 November 27, 2019 - 17:45:47 UTC 36.93245 -120.37412 Firebaugh 8 []
721943 November 28, 2019 - 00:14:00 UTC 36.95112 -120.38297 Firebaugh 8 [{"latitude": "36.91751", "longitude": "-120.38216"}, {"latitude": "36.93114", "longitude": "-120.34881"}, {"latitude": "36.93819", "longitude": "-120.35529"}, {"latitude": "36.94549", "longitude": "-120.38283"}, {"latitude": "36.94138", "longitude": "-120.39617"}, {"latitude": "36.93066", "longitude": "-120.41817"}, {"latitude": "36.92709", "longitude": "-120.42318"}, {"latitude": "36.92376", "longitude": "-120.4183"}]
723045 November 28, 2019 - 21:09:57 UTC 36.92337 -120.37994 Firebaugh 8 []
723966 November 30, 2019 - 08:14:19 UTC 36.86534 -120.45995 Firebaugh 8 []
724143 November 30, 2019 - 18:34:00 UTC 36.8641 -120.46243 Firebaugh 8 [{"latitude": "36.86425", "longitude": "-120.46002"}, {"latitude": "36.86546", "longitude": "-120.45726"}, {"latitude": "36.86529", "longitude": "-120.45892"}, {"latitude": "36.86452", "longitude": "-120.46182"}]
724254 November 30, 2019 - 20:53:00 UTC 36.86617 -120.45764 Firebaugh 8 []
724269 November 30, 2019 - 21:09:00 UTC 36.8641 -120.46243 Firebaugh 8 []
727641 December 02, 2019 - 20:58:23 UTC 36.92409 -120.38246 Firebaugh 8 []
727913 December 03, 2019 - 00:48:49 UTC 36.95258 -120.44699 Firebaugh 8 []
729460 December 04, 2019 - 16:23:32 UTC 36.95258 -120.44699 Firebaugh 8 []
729472 December 04, 2019 - 16:33:29 UTC 36.76406 -120.5689 Firebaugh 8 []
729473 December 04, 2019 - 16:33:31 UTC 36.81779 -120.49417 Firebaugh 8 []
730568 December 05, 2019 - 19:18:44 UTC 36.93278 -120.40071 Firebaugh 8 []
734374 December 09, 2019 - 17:44:41 UTC 36.8741 -120.46078 Firebaugh 8 []
735896 December 11, 2019 - 00:25:16 UTC 36.97147 -120.44821 Firebaugh 8 []
736220 December 11, 2019 - 16:41:19 UTC 36.91257 -120.71078 Firebaugh 8 []
738558 December 13, 2019 - 20:22:06 UTC 36.87978 -120.63603 Firebaugh 8 []
743593 December 16, 2019 - 20:56:00 UTC 36.65125 -120.58027 Firebaugh 8 [{"latitude": "36.53089", "longitude": "-120.48275"}, {"latitude": "36.57419", "longitude": "-120.38837"}, {"latitude": "36.5815", "longitude": "-120.37826"}, {"latitude": "36.63048", "longitude": "-120.35228"}, {"latitude": "36.63219", "longitude": "-120.35232"}, {"latitude": "36.6362", "longitude": "-120.37021"}, {"latitude": "36.66902", "longitude": "-120.5317"}, {"latitude": "36.66232", "longitude": "-120.55892"}, {"latitude": "36.58845", "longitude": "-120.53292"}, {"latitude": "36.54034", "longitude": "-120.49382"}, {"latitude": "36.53092", "longitude": "-120.48527"}]
743771 December 16, 2019 - 23:39:49 UTC 36.64804 -120.57176 Firebaugh 8 []
778334 February 05, 2020 - 17:00:45 UTC 36.86011 -120.45441 Firebaugh 8 []
778342 February 05, 2020 - 17:08:38 UTC 36.98128 -120.38318 Firebaugh 8 []
778961 February 06, 2020 - 16:02:39 UTC 36.82221 -120.30325 Firebaugh 8 [{"latitude": "36.82215", "longitude": "-120.31699"}, {"latitude": "36.82216", "longitude": "-120.31366"}, {"latitude": "36.82221", "longitude": "-120.30342"}, {"latitude": "36.82219", "longitude": "-120.30863"}]
780084 February 07, 2020 - 18:48:27 UTC 36.9889 -120.38318 Firebaugh 8 []
780676 February 08, 2020 - 22:38:30 UTC 36.86529 -120.45892 Firebaugh 8 []
780847 February 09, 2020 - 07:05:23 UTC 36.78484 -120.55649 Firebaugh 8 []
787091 February 10, 2020 - 16:50:15 UTC 36.83658 -120.45743 Firebaugh 8 []
787476 February 10, 2020 - 19:58:51 UTC 36.86702 -120.462 Firebaugh 8 []
789134 February 12, 2020 - 03:49:34 UTC 36.87463 -120.47528 Firebaugh 8 []
789290 February 12, 2020 - 16:07:05 UTC 36.836 -120.7293 Firebaugh 8 []
789909 February 13, 2020 - 02:17:00 UTC 36.96754 -120.69004 Firebaugh 8 []
1061995 September 09, 2020 - 17:20:26 UTC 36.87157 -120.46456 Firebaugh 8 []
1063283 September 10, 2020 - 19:09:01 UTC 36.88712 -120.53204 Firebaugh 8 []
1063832 September 10, 2020 - 22:38:49 UTC 36.85359 -120.4364 Firebaugh 8 []
1065153 September 11, 2020 - 22:13:35 UTC 36.85791 -120.50492 Firebaugh 8 []
1065365 September 12, 2020 - 03:52:39 UTC 36.85536 -120.45633 Firebaugh 8 []
1079506 September 17, 2020 - 23:47:29 UTC 36.8013 -120.33116 Firebaugh 8 []
1082215 September 19, 2020 - 16:26:02 UTC 37.00216 -120.37606 Firebaugh 8 []
1083249 September 20, 2020 - 17:19:00 UTC 36.84997 -120.71772 Firebaugh 8 []
1083251 September 20, 2020 - 17:18:00 UTC 36.87942 -120.76385 Firebaugh 8 []
1083252 September 20, 2020 - 17:25:54 UTC 36.83593 -120.75815 Firebaugh 8 []
1083274 September 20, 2020 - 18:30:33 UTC 36.87945 -120.76345 Firebaugh 8 []
1083330 September 20, 2020 - 22:42:50 UTC 36.83593 -120.75348 Firebaugh 8 []
1084414 September 21, 2020 - 17:05:02 UTC 36.84897 -120.71707 Firebaugh 8 []
1084516 September 21, 2020 - 17:26:16 UTC 36.78541 -120.64804 Firebaugh 8 []
1086094 September 21, 2020 - 23:54:56 UTC 36.80697 -120.44991 Firebaugh 8 []
1086189 September 22, 2020 - 02:52:00 UTC 36.74801 -120.60342 Firebaugh 8 [{"latitude": "36.72799", "longitude": "-120.59419"}, {"latitude": "36.73441", "longitude": "-120.53171"}, {"latitude": "36.78582", "longitude": "-120.58493"}, {"latitude": "36.78559", "longitude": "-120.62082"}, {"latitude": "36.76392", "longitude": "-120.63467"}, {"latitude": "36.7492", "longitude": "-120.64117"}, {"latitude": "36.73462", "longitude": "-120.62591"}, {"latitude": "36.73163", "longitude": "-120.61279"}]
1086260 September 22, 2020 - 07:12:53 UTC 36.64056 -120.62045 Firebaugh 8 []
1086289 September 22, 2020 - 12:07:16 UTC 36.77775 -120.6028 Firebaugh 8 []
1086290 September 22, 2020 - 12:23:11 UTC 36.75015 -120.63774 Firebaugh 8 []
1086291 September 22, 2020 - 12:29:00 UTC 36.75006 -120.63932 Firebaugh 8 []
1087657 September 22, 2020 - 18:24:00 UTC 36.64815 -120.62301 Firebaugh 8 [{"latitude": "36.579", "longitude": "-120.68494"}, {"latitude": "36.63766", "longitude": "-120.61933"}, {"latitude": "36.64056", "longitude": "-120.62045"}, {"latitude": "36.64811", "longitude": "-120.62798"}, {"latitude": "36.64816", "longitude": "-120.63984"}]
1088595 September 22, 2020 - 23:32:43 UTC 36.80697 -120.44991 Firebaugh 8 []
1092613 September 25, 2020 - 18:01:06 UTC 36.8502 -120.44755 Firebaugh 8 []
1096903 September 28, 2020 - 22:12:52 UTC 36.83404 -120.44782 Firebaugh 8 []
1101934 September 30, 2020 - 20:29:23 UTC 36.69907 -120.63077 Firebaugh 8 []
1108174 October 02, 2020 - 23:37:42 UTC 36.82216 -120.31653 Firebaugh 8 []
1108754 October 03, 2020 - 06:05:56 UTC 36.83593 -120.75348 Firebaugh 8 []
1110875 October 04, 2020 - 21:27:41 UTC 36.8865 -120.4606 Firebaugh 8 []

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