1,122 rows where regionName = 19

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633460 October 01, 2019 - 03:38:35 UTC 38.69685 -120.77764 Placerville 19 []
634113 October 01, 2019 - 18:52:42 UTC 38.71636 -120.90585 Placerville 19 []
634865 October 01, 2019 - 21:58:00 UTC 38.78533 -120.75834 Placerville 19 []
635749 October 02, 2019 - 14:56:00 UTC 38.64102 -120.76184 Placerville 19 [{"latitude": "38.63098", "longitude": "-120.76273"}, {"latitude": "38.63328", "longitude": "-120.7625"}, {"latitude": "38.63247", "longitude": "-120.76499"}, {"latitude": "38.63109", "longitude": "-120.76589"}]
636153 October 02, 2019 - 16:54:02 UTC 38.76674 -120.93891 Placerville 19 []
637415 October 02, 2019 - 19:48:20 UTC 38.79444 -120.9237 Placerville 19 []
638806 October 03, 2019 - 00:17:37 UTC 38.73052 -120.80042 Placerville 19 []
639041 October 03, 2019 - 15:08:09 UTC 38.77288 -120.96444 Placerville 19 []
639099 October 03, 2019 - 16:01:00 UTC 38.73276 -120.73184 Placerville 19 []
639162 October 03, 2019 - 16:05:13 UTC 38.73411 -120.74207 Placerville 19 []
640473 October 03, 2019 - 19:43:55 UTC 38.71884 -120.7394 Placerville 19 []
641453 October 03, 2019 - 22:08:09 UTC 38.75839 -120.76453 Placerville 19 [{"latitude": "38.75841", "longitude": "-120.76417"}, {"latitude": "38.76032", "longitude": "-120.75789"}, {"latitude": "38.76179", "longitude": "-120.75621"}, {"latitude": "38.76776", "longitude": "-120.75528"}, {"latitude": "38.76914", "longitude": "-120.75629"}, {"latitude": "38.77069", "longitude": "-120.76022"}, {"latitude": "38.76462", "longitude": "-120.76278"}, {"latitude": "38.76058", "longitude": "-120.76407"}]
642222 October 04, 2019 - 06:28:29 UTC 38.73804 -120.82819 Placerville 19 []
642386 October 04, 2019 - 15:26:36 UTC 38.71031 -120.88602 Placerville 19 []
642473 October 04, 2019 - 15:32:38 UTC 38.66678 -120.80374 Placerville 19 []
642475 October 04, 2019 - 15:38:00 UTC 38.76085 -120.87065 Placerville 19 []
642776 October 04, 2019 - 16:13:00 UTC 38.73284 -120.93276 Placerville 19 []
643033 October 04, 2019 - 16:40:53 UTC 38.73527 -120.78531 Placerville 19 []
643401 October 04, 2019 - 17:22:23 UTC 38.75956 -120.8993 Placerville 19 []
643800 October 05, 2019 - 00:37:00 UTC 38.67761 -120.63702 Placerville 19 []
644024 October 05, 2019 - 15:38:00 UTC 38.69643 -120.78608 Placerville 19 []
644040 October 05, 2019 - 15:52:00 UTC 38.75596 -120.87108 Placerville 19 []
644053 October 05, 2019 - 15:45:41 UTC 38.7198 -120.80203 Placerville 19 []
644177 October 05, 2019 - 16:03:37 UTC 38.75413 -120.7793 Placerville 19 []
644533 October 05, 2019 - 17:20:51 UTC 38.72686 -120.79804 Placerville 19 []
645547 October 06, 2019 - 15:02:30 UTC 38.73316 -120.80268 Placerville 19 []
645613 October 06, 2019 - 18:52:12 UTC 38.66751 -120.76058 Placerville 19 []
646059 October 07, 2019 - 17:45:37 UTC 38.7282 -120.79095 Placerville 19 []
646080 October 07, 2019 - 18:08:44 UTC 38.74435 -120.79495 Placerville 19 []
646152 October 07, 2019 - 18:55:15 UTC 38.69984 -120.68147 Placerville 19 []
647287 October 08, 2019 - 16:20:00 UTC 38.71496 -120.82355 Placerville 19 [{"latitude": "38.71073", "longitude": "-120.81833"}, {"latitude": "38.71199", "longitude": "-120.81804"}, {"latitude": "38.71632", "longitude": "-120.81841"}, {"latitude": "38.71723", "longitude": "-120.82233"}, {"latitude": "38.71495", "longitude": "-120.82352"}, {"latitude": "38.71099", "longitude": "-120.81913"}]
647355 October 08, 2019 - 17:00:47 UTC 38.75347 -120.77655 Placerville 19 []
647455 October 08, 2019 - 18:55:00 UTC 38.66604 -120.67142 Placerville 19 []
647477 October 08, 2019 - 19:29:00 UTC 38.72846 -120.76022 Placerville 19 [{"latitude": "38.71076", "longitude": "-120.78729"}, {"latitude": "38.71232", "longitude": "-120.7636"}, {"latitude": "38.71283", "longitude": "-120.7586"}, {"latitude": "38.71575", "longitude": "-120.74051"}, {"latitude": "38.71884", "longitude": "-120.7394"}, {"latitude": "38.72672", "longitude": "-120.75079"}, {"latitude": "38.72857", "longitude": "-120.76056"}, {"latitude": "38.72852", "longitude": "-120.76213"}, {"latitude": "38.72313", "longitude": "-120.78841"}, {"latitude": "38.72248", "longitude": "-120.7891"}, {"latitude": "38.72165", "longitude": "-120.78987"}, {"latitude": "38.72053", "longitude": "-120.7899"}, {"latitude": "38.7138", "longitude": "-120.78992"}]
647542 October 08, 2019 - 21:04:22 UTC 38.72252 -120.78868 Placerville 19 []
648296 October 09, 2019 - 07:49:27 UTC 38.6935 -120.76785 Placerville 19 [{"latitude": "38.61934", "longitude": "-120.79886"}, {"latitude": "38.63098", "longitude": "-120.76273"}, {"latitude": "38.65212", "longitude": "-120.7406"}, {"latitude": "38.66133", "longitude": "-120.73154"}, {"latitude": "38.66625", "longitude": "-120.72793"}, {"latitude": "38.69709", "longitude": "-120.72336"}, {"latitude": "38.70131", "longitude": "-120.72682"}, {"latitude": "38.71513", "longitude": "-120.74534"}, {"latitude": "38.71315", "longitude": "-120.75519"}, {"latitude": "38.70995", "longitude": "-120.75933"}, {"latitude": "38.67546", "longitude": "-120.80299"}, {"latitude": "38.66995", "longitude": "-120.80442"}, {"latitude": "38.62326", "longitude": "-120.80742"}]
648300 October 09, 2019 - 07:49:27 UTC 38.6915 -120.7656 Placerville 19 [{"latitude": "38.68336", "longitude": "-120.74439"}, {"latitude": "38.68795", "longitude": "-120.732"}, {"latitude": "38.69296", "longitude": "-120.72424"}, {"latitude": "38.69709", "longitude": "-120.72336"}, {"latitude": "38.70131", "longitude": "-120.72682"}, {"latitude": "38.703", "longitude": "-120.73041"}, {"latitude": "38.70078", "longitude": "-120.75127"}, {"latitude": "38.69152", "longitude": "-120.76466"}, {"latitude": "38.68383", "longitude": "-120.75857"}]
648317 October 09, 2019 - 07:49:27 UTC 38.67385 -120.75972 Placerville 19 [{"latitude": "38.61934", "longitude": "-120.79886"}, {"latitude": "38.62547", "longitude": "-120.78712"}, {"latitude": "38.62871", "longitude": "-120.78271"}, {"latitude": "38.63963", "longitude": "-120.77367"}, {"latitude": "38.64347", "longitude": "-120.77115"}, {"latitude": "38.67095", "longitude": "-120.75788"}, {"latitude": "38.67313", "longitude": "-120.75944"}, {"latitude": "38.67367", "longitude": "-120.76013"}, {"latitude": "38.67859", "longitude": "-120.78031"}, {"latitude": "38.67749", "longitude": "-120.79122"}, {"latitude": "38.67546", "longitude": "-120.80299"}, {"latitude": "38.66995", "longitude": "-120.80442"}, {"latitude": "38.62326", "longitude": "-120.80742"}]
648985 October 09, 2019 - 07:41:43 UTC 38.73104 -120.84266 Placerville 19 [{"latitude": "38.72853", "longitude": "-120.85561"}, {"latitude": "38.72908", "longitude": "-120.85296"}, {"latitude": "38.73136", "longitude": "-120.84294"}, {"latitude": "38.73494", "longitude": "-120.84364"}, {"latitude": "38.7418", "longitude": "-120.84641"}, {"latitude": "38.74919", "longitude": "-120.85279"}, {"latitude": "38.7577", "longitude": "-120.87079"}, {"latitude": "38.75278", "longitude": "-120.88072"}, {"latitude": "38.74953", "longitude": "-120.88539"}, {"latitude": "38.74045", "longitude": "-120.88446"}, {"latitude": "38.73788", "longitude": "-120.88316"}]
649266 October 09, 2019 - 08:00:42 UTC 38.76379 -120.92646 Placerville 19 [{"latitude": "38.74807", "longitude": "-120.90988"}, {"latitude": "38.74863", "longitude": "-120.8946"}, {"latitude": "38.75015", "longitude": "-120.88977"}, {"latitude": "38.75056", "longitude": "-120.88898"}, {"latitude": "38.75576", "longitude": "-120.8854"}, {"latitude": "38.7602", "longitude": "-120.88721"}, {"latitude": "38.77026", "longitude": "-120.9166"}, {"latitude": "38.76337", "longitude": "-120.92612"}, {"latitude": "38.75558", "longitude": "-120.92026"}]
649417 October 09, 2019 - 08:00:42 UTC 38.76905 -120.92738 Placerville 19 [{"latitude": "38.75913", "longitude": "-120.93377"}, {"latitude": "38.75947", "longitude": "-120.93172"}, {"latitude": "38.7624", "longitude": "-120.92988"}, {"latitude": "38.76282", "longitude": "-120.92975"}, {"latitude": "38.7732", "longitude": "-120.92699"}, {"latitude": "38.79142", "longitude": "-120.92366"}, {"latitude": "38.79752", "longitude": "-120.93613"}, {"latitude": "38.79682", "longitude": "-120.94295"}, {"latitude": "38.7951", "longitude": "-120.95447"}, {"latitude": "38.78842", "longitude": "-120.96672"}, {"latitude": "38.78195", "longitude": "-120.97435"}, {"latitude": "38.75967", "longitude": "-120.97554"}, {"latitude": "38.75944", "longitude": "-120.97289"}]
649427 October 09, 2019 - 08:00:42 UTC 38.77412 -120.92011 Placerville 19 [{"latitude": "38.76587", "longitude": "-120.8855"}, {"latitude": "38.76934", "longitude": "-120.87616"}, {"latitude": "38.79422", "longitude": "-120.86996"}, {"latitude": "38.82356", "longitude": "-120.88277"}, {"latitude": "38.84088", "longitude": "-120.89071"}, {"latitude": "38.85248", "longitude": "-120.94637"}, {"latitude": "38.79886", "longitude": "-120.96907"}, {"latitude": "38.76784", "longitude": "-120.90595"}, {"latitude": "38.7668", "longitude": "-120.89605"}]
649685 October 09, 2019 - 10:38:33 UTC 38.71002 -120.7151 Placerville 19 [{"latitude": "38.70493", "longitude": "-120.72599"}, {"latitude": "38.70575", "longitude": "-120.71778"}, {"latitude": "38.70817", "longitude": "-120.71644"}, {"latitude": "38.71003", "longitude": "-120.71583"}, {"latitude": "38.71164", "longitude": "-120.71791"}, {"latitude": "38.71349", "longitude": "-120.73763"}, {"latitude": "38.7089", "longitude": "-120.73879"}]
649686 October 09, 2019 - 10:38:33 UTC 38.703 -120.71958 Placerville 19 []
649687 October 09, 2019 - 10:38:33 UTC 38.62985 -120.74815 Placerville 19 []
649705 October 09, 2019 - 10:38:33 UTC 38.67704 -120.68574 Placerville 19 []
649719 October 09, 2019 - 10:38:33 UTC 38.80162 -120.69931 Placerville 19 []
649720 October 09, 2019 - 10:38:33 UTC 38.793 -120.69591 Placerville 19 []
649721 October 09, 2019 - 10:38:33 UTC 38.79277 -120.70559 Placerville 19 []
649722 October 09, 2019 - 10:38:33 UTC 38.79408 -120.70635 Placerville 19 []
649723 October 09, 2019 - 10:38:33 UTC 38.79466 -120.70719 Placerville 19 []
649724 October 09, 2019 - 10:38:33 UTC 38.80175 -120.71961 Placerville 19 []
649725 October 09, 2019 - 10:38:33 UTC 38.79717 -120.72219 Placerville 19 []
649726 October 09, 2019 - 10:38:33 UTC 38.81606 -120.74685 Placerville 19 []
649742 October 09, 2019 - 10:39:28 UTC 38.7968 -120.70259 Placerville 19 []
649743 October 09, 2019 - 10:39:28 UTC 38.80002 -120.7001 Placerville 19 [{"latitude": "38.79864", "longitude": "-120.70335"}, {"latitude": "38.79998", "longitude": "-120.70106"}, {"latitude": "38.80134", "longitude": "-120.70208"}, {"latitude": "38.80195", "longitude": "-120.70268"}, {"latitude": "38.80247", "longitude": "-120.70356"}]
649760 October 09, 2019 - 10:41:00 UTC 38.73781 -120.81941 Placerville 19 []
649762 October 09, 2019 - 10:41:00 UTC 38.73706 -120.81185 Placerville 19 []
649769 October 09, 2019 - 10:41:52 UTC 38.68587 -120.61053 Placerville 19 []
649807 October 09, 2019 - 10:41:00 UTC 38.73125 -120.7839 Placerville 19 [{"latitude": "38.70411", "longitude": "-120.8072"}, {"latitude": "38.71575", "longitude": "-120.74051"}, {"latitude": "38.71884", "longitude": "-120.7394"}, {"latitude": "38.72282", "longitude": "-120.75006"}, {"latitude": "38.74349", "longitude": "-120.82789"}, {"latitude": "38.74347", "longitude": "-120.82861"}, {"latitude": "38.74144", "longitude": "-120.83148"}, {"latitude": "38.73898", "longitude": "-120.8326"}, {"latitude": "38.73764", "longitude": "-120.83245"}, {"latitude": "38.73326", "longitude": "-120.83079"}, {"latitude": "38.70528", "longitude": "-120.81694"}, {"latitude": "38.70421", "longitude": "-120.80968"}]
649812 October 09, 2019 - 10:46:09 UTC 38.7235 -120.79687 Placerville 19 [{"latitude": "38.7243", "longitude": "-120.79615"}, {"latitude": "38.72443", "longitude": "-120.79511"}, {"latitude": "38.7271", "longitude": "-120.79715"}, {"latitude": "38.72686", "longitude": "-120.79804"}, {"latitude": "38.72599", "longitude": "-120.80097"}, {"latitude": "38.72509", "longitude": "-120.79933"}]
649813 October 09, 2019 - 10:46:08 UTC 38.7183 -120.8027 Placerville 19 []
649814 October 09, 2019 - 10:46:08 UTC 38.72391 -120.8137 Placerville 19 []
649815 October 09, 2019 - 10:46:08 UTC 38.72162 -120.80721 Placerville 19 []
649816 October 09, 2019 - 10:46:08 UTC 38.72397 -120.80919 Placerville 19 []
649817 October 09, 2019 - 10:46:08 UTC 38.72311 -120.80314 Placerville 19 []
649818 October 09, 2019 - 10:46:08 UTC 38.72388 -120.80515 Placerville 19 []
649819 October 09, 2019 - 10:46:08 UTC 38.72571 -120.80417 Placerville 19 []
649820 October 09, 2019 - 10:46:09 UTC 38.73125 -120.78396 Placerville 19 [{"latitude": "38.71986", "longitude": "-120.74108"}, {"latitude": "38.72539", "longitude": "-120.70849"}, {"latitude": "38.73838", "longitude": "-120.67796"}, {"latitude": "38.7453", "longitude": "-120.68575"}, {"latitude": "38.76974", "longitude": "-120.73552"}, {"latitude": "38.77355", "longitude": "-120.74676"}, {"latitude": "38.77284", "longitude": "-120.75626"}, {"latitude": "38.73255", "longitude": "-120.78219"}, {"latitude": "38.7319", "longitude": "-120.78199"}, {"latitude": "38.73099", "longitude": "-120.78115"}, {"latitude": "38.73017", "longitude": "-120.78024"}, {"latitude": "38.72767", "longitude": "-120.77693"}, {"latitude": "38.727", "longitude": "-120.77531"}, {"latitude": "38.72271", "longitude": "-120.76436"}]
649821 October 09, 2019 - 10:46:08 UTC 38.73241 -120.80075 Placerville 19 [{"latitude": "38.73054", "longitude": "-120.80341"}, {"latitude": "38.73072", "longitude": "-120.80221"}, {"latitude": "38.73136", "longitude": "-120.8011"}, {"latitude": "38.73169", "longitude": "-120.80063"}, {"latitude": "38.73208", "longitude": "-120.80063"}, {"latitude": "38.73283", "longitude": "-120.80091"}, {"latitude": "38.73155", "longitude": "-120.80241"}]
649822 October 09, 2019 - 10:46:00 UTC 38.73766 -120.80578 Placerville 19 [{"latitude": "38.73769", "longitude": "-120.80575"}, {"latitude": "38.73816", "longitude": "-120.80324"}, {"latitude": "38.73907", "longitude": "-120.80294"}, {"latitude": "38.73929", "longitude": "-120.80293"}, {"latitude": "38.73979", "longitude": "-120.80316"}, {"latitude": "38.74023", "longitude": "-120.80364"}, {"latitude": "38.7399", "longitude": "-120.80596"}, {"latitude": "38.7398", "longitude": "-120.80642"}]
649834 October 09, 2019 - 10:46:09 UTC 38.80469 -120.79003 Placerville 19 []
649843 October 09, 2019 - 10:46:00 UTC 38.7046 -120.70717 Placerville 19 [{"latitude": "38.69904", "longitude": "-120.69188"}, {"latitude": "38.70721", "longitude": "-120.68338"}, {"latitude": "38.71078", "longitude": "-120.68669"}, {"latitude": "38.71157", "longitude": "-120.69577"}, {"latitude": "38.70552", "longitude": "-120.70726"}, {"latitude": "38.70388", "longitude": "-120.70726"}, {"latitude": "38.70216", "longitude": "-120.70579"}]
649851 October 09, 2019 - 10:48:04 UTC 38.72047 -120.82891 Placerville 19 []
649902 October 09, 2019 - 10:51:47 UTC 38.72845 -120.83373 Placerville 19 []
649913 October 09, 2019 - 10:52:58 UTC 38.62835 -120.70536 Placerville 19 []
649915 October 09, 2019 - 10:53:11 UTC 38.71963 -120.80618 Placerville 19 []
649917 October 09, 2019 - 10:53:37 UTC 38.72256 -120.80532 Placerville 19 []
649922 October 09, 2019 - 10:54:00 UTC 38.7353 -120.79475 Placerville 19 []
649931 October 09, 2019 - 10:56:00 UTC 38.73164 -120.79907 Placerville 19 []
649938 October 09, 2019 - 10:57:00 UTC 38.74455 -120.78962 Placerville 19 []
649948 October 09, 2019 - 10:59:00 UTC 38.76343 -120.76121 Placerville 19 []
649953 October 09, 2019 - 11:00:00 UTC 38.73219 -120.79752 Placerville 19 []
649964 October 09, 2019 - 11:01:00 UTC 38.65628 -120.69126 Placerville 19 []
649975 October 09, 2019 - 11:03:00 UTC 38.74605 -120.80296 Placerville 19 []
650122 October 09, 2019 - 11:32:00 UTC 38.69649 -120.66535 Placerville 19 []
650128 October 09, 2019 - 11:33:00 UTC 38.6495 -120.69742 Placerville 19 []
650135 October 09, 2019 - 11:34:00 UTC 38.7388 -120.77792 Placerville 19 []
650136 October 09, 2019 - 11:34:00 UTC 38.69459 -120.69965 Placerville 19 []
650146 October 09, 2019 - 11:36:00 UTC 38.68709 -120.65652 Placerville 19 []
650185 October 09, 2019 - 11:46:00 UTC 38.61839 -120.7647 Placerville 19 []
650195 October 09, 2019 - 10:33:50 UTC 38.73125 -120.78396 Placerville 19 [{"latitude": "38.71986", "longitude": "-120.74108"}, {"latitude": "38.72539", "longitude": "-120.70849"}, {"latitude": "38.73838", "longitude": "-120.67796"}, {"latitude": "38.7453", "longitude": "-120.68575"}, {"latitude": "38.76974", "longitude": "-120.73552"}, {"latitude": "38.77355", "longitude": "-120.74676"}, {"latitude": "38.77284", "longitude": "-120.75626"}, {"latitude": "38.73255", "longitude": "-120.78219"}, {"latitude": "38.7319", "longitude": "-120.78199"}, {"latitude": "38.73099", "longitude": "-120.78115"}, {"latitude": "38.73017", "longitude": "-120.78024"}, {"latitude": "38.72767", "longitude": "-120.77693"}, {"latitude": "38.727", "longitude": "-120.77531"}, {"latitude": "38.72271", "longitude": "-120.76436"}]
650207 October 09, 2019 - 10:33:50 UTC 38.73125 -120.78395 Placerville 19 [{"latitude": "38.72661", "longitude": "-120.79007"}, {"latitude": "38.73163", "longitude": "-120.78358"}, {"latitude": "38.76962", "longitude": "-120.8184"}, {"latitude": "38.78419", "longitude": "-120.86361"}, {"latitude": "38.78596", "longitude": "-120.86927"}, {"latitude": "38.78526", "longitude": "-120.87077"}, {"latitude": "38.76339", "longitude": "-120.88522"}, {"latitude": "38.7599", "longitude": "-120.88549"}, {"latitude": "38.75463", "longitude": "-120.87647"}, {"latitude": "38.72839", "longitude": "-120.80617"}]
650217 October 09, 2019 - 11:54:00 UTC 38.67331 -120.70831 Placerville 19 []
650230 October 09, 2019 - 10:33:50 UTC 38.73125 -120.78391 Placerville 19 [{"latitude": "38.7128", "longitude": "-120.79934"}, {"latitude": "38.7128", "longitude": "-120.79824"}, {"latitude": "38.72283", "longitude": "-120.7849"}, {"latitude": "38.73028", "longitude": "-120.78343"}, {"latitude": "38.73055", "longitude": "-120.7841"}, {"latitude": "38.73061", "longitude": "-120.78648"}, {"latitude": "38.73045", "longitude": "-120.83711"}, {"latitude": "38.72743", "longitude": "-120.83789"}, {"latitude": "38.72473", "longitude": "-120.83735"}, {"latitude": "38.71974", "longitude": "-120.8361"}, {"latitude": "38.71738", "longitude": "-120.83358"}, {"latitude": "38.71283", "longitude": "-120.8089"}]
650241 October 09, 2019 - 10:33:50 UTC 38.73125 -120.7839 Placerville 19 [{"latitude": "38.70411", "longitude": "-120.8072"}, {"latitude": "38.71575", "longitude": "-120.74051"}, {"latitude": "38.71884", "longitude": "-120.7394"}, {"latitude": "38.72282", "longitude": "-120.75006"}, {"latitude": "38.74349", "longitude": "-120.82789"}, {"latitude": "38.74347", "longitude": "-120.82861"}, {"latitude": "38.74144", "longitude": "-120.83148"}, {"latitude": "38.73898", "longitude": "-120.8326"}, {"latitude": "38.73764", "longitude": "-120.83245"}, {"latitude": "38.73326", "longitude": "-120.83079"}, {"latitude": "38.70528", "longitude": "-120.81694"}, {"latitude": "38.70421", "longitude": "-120.80968"}]
650266 October 09, 2019 - 10:33:50 UTC 38.73126 -120.784 Placerville 19 [{"latitude": "38.73013", "longitude": "-120.7964"}, {"latitude": "38.73225", "longitude": "-120.7855"}, {"latitude": "38.73388", "longitude": "-120.77887"}, {"latitude": "38.73466", "longitude": "-120.77678"}, {"latitude": "38.73795", "longitude": "-120.76943"}, {"latitude": "38.7854", "longitude": "-120.71551"}, {"latitude": "38.91217", "longitude": "-120.65936"}, {"latitude": "38.96853", "longitude": "-120.71032"}, {"latitude": "38.97522", "longitude": "-120.72007"}, {"latitude": "38.98579", "longitude": "-120.73577"}, {"latitude": "38.98845", "longitude": "-120.74023"}, {"latitude": "38.98995", "longitude": "-120.74881"}, {"latitude": "38.98966", "longitude": "-120.77259"}, {"latitude": "38.98433", "longitude": "-120.78155"}, {"latitude": "38.86903", "longitude": "-120.89167"}, {"latitude": "38.83236", "longitude": "-120.88876"}, {"latitude": "38.81031", "longitude": "-120.88123"}, {"latitude": "38.73061", "longitude": "-120.8046"}, {"latitude": "38.73021", "longitude": "-120.80102"}]
650331 October 09, 2019 - 10:35:00 UTC 38.69445 -120.67791 Placerville 19 [{"latitude": "38.67066", "longitude": "-120.72329"}, {"latitude": "38.68796", "longitude": "-120.68486"}, {"latitude": "38.68952", "longitude": "-120.68234"}, {"latitude": "38.69253", "longitude": "-120.67861"}, {"latitude": "38.69443", "longitude": "-120.67884"}, {"latitude": "38.6951", "longitude": "-120.67894"}, {"latitude": "38.70721", "longitude": "-120.68338"}, {"latitude": "38.71078", "longitude": "-120.68669"}, {"latitude": "38.71808", "longitude": "-120.699"}, {"latitude": "38.72502", "longitude": "-120.71742"}, {"latitude": "38.72758", "longitude": "-120.73167"}, {"latitude": "38.72752", "longitude": "-120.73388"}, {"latitude": "38.7273", "longitude": "-120.73558"}, {"latitude": "38.72672", "longitude": "-120.7381"}, {"latitude": "38.7089", "longitude": "-120.73879"}, {"latitude": "38.67771", "longitude": "-120.73165"}, {"latitude": "38.67131", "longitude": "-120.72833"}]
650341 October 09, 2019 - 10:35:00 UTC 38.6734 -120.72264 Placerville 19 [{"latitude": "38.65191", "longitude": "-120.7032"}, {"latitude": "38.65263", "longitude": "-120.7008"}, {"latitude": "38.65493", "longitude": "-120.69921"}, {"latitude": "38.67097", "longitude": "-120.69061"}, {"latitude": "38.67551", "longitude": "-120.69099"}, {"latitude": "38.67807", "longitude": "-120.69518"}, {"latitude": "38.6786", "longitude": "-120.70755"}, {"latitude": "38.67203", "longitude": "-120.71755"}, {"latitude": "38.65964", "longitude": "-120.71816"}, {"latitude": "38.65812", "longitude": "-120.71765"}, {"latitude": "38.65344", "longitude": "-120.7158"}]
650347 October 09, 2019 - 10:35:00 UTC 38.65252 -120.7006 Placerville 19 [{"latitude": "38.63969", "longitude": "-120.70156"}, {"latitude": "38.64148", "longitude": "-120.69679"}, {"latitude": "38.64622", "longitude": "-120.68678"}, {"latitude": "38.64791", "longitude": "-120.68501"}, {"latitude": "38.6516", "longitude": "-120.68183"}, {"latitude": "38.65341", "longitude": "-120.68293"}, {"latitude": "38.65759", "longitude": "-120.68567"}, {"latitude": "38.65765", "longitude": "-120.6886"}, {"latitude": "38.65408", "longitude": "-120.69672"}, {"latitude": "38.65189", "longitude": "-120.70061"}, {"latitude": "38.65028", "longitude": "-120.70295"}, {"latitude": "38.64516", "longitude": "-120.70677"}, {"latitude": "38.64294", "longitude": "-120.70685"}, {"latitude": "38.64013", "longitude": "-120.703"}]

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