This data as json, atom, CSV (advanced)
Suggested facets: outageDevices
| id | outageStartTime | latitude ▼ | longitude | regionName | outageDevices |
|---|---|---|---|---|---|
| 687260 | October 27, 2019 - 15:41:20 UTC | 38.03376 | -121.7393 | Rio Vista 21 | [] |
| 688072 | October 27, 2019 - 18:26:05 UTC | 38.03531 | -121.73556 | Rio Vista 21 | [{"latitude": "38.03988", "longitude": "-121.72715"}, {"latitude": "38.04552", "longitude": "-121.71496"}, {"latitude": "38.04739", "longitude": "-121.71113"}, {"latitude": "38.04353", "longitude": "-121.72152"}] |
| 725784 | December 01, 2019 - 16:22:04 UTC | 38.05013 | -121.70133 | Rio Vista 21 | [] |
| 709176 | November 18, 2019 - 17:43:44 UTC | 38.05282 | -121.7833 | Rio Vista 21 | [] |
| 706174 | November 13, 2019 - 20:01:12 UTC | 38.07212 | -121.75875 | Rio Vista 21 | [] |
| 708661 | November 17, 2019 - 18:22:07 UTC | 38.07212 | -121.75875 | Rio Vista 21 | [] |
| 701688 | November 07, 2019 - 16:42:25 UTC | 38.07311 | -121.7565 | Rio Vista 21 | [] |
| 706132 | November 13, 2019 - 19:09:42 UTC | 38.07345 | -121.75573 | Rio Vista 21 | [] |
| 708368 | November 16, 2019 - 21:00:50 UTC | 38.07345 | -121.75573 | Rio Vista 21 | [] |
| 654991 | October 12, 2019 - 07:55:08 UTC | 38.08023 | -121.73164 | Rio Vista 21 | [] |
| 654985 | October 12, 2019 - 06:17:00 UTC | 38.08057 | -121.73318 | Rio Vista 21 | [{"latitude": "38.06312", "longitude": "-121.77892"}, {"latitude": "38.06614", "longitude": "-121.77157"}, {"latitude": "38.07423", "longitude": "-121.75398"}, {"latitude": "38.07462", "longitude": "-121.7532"}, {"latitude": "38.08291", "longitude": "-121.73807"}, {"latitude": "38.08081", "longitude": "-121.7432"}, {"latitude": "38.07172", "longitude": "-121.76327"}] |
| 658959 | October 15, 2019 - 16:26:03 UTC | 38.10416 | -121.69409 | Rio Vista 21 | [] |
| 725460 | December 01, 2019 - 09:30:39 UTC | 38.11628 | -121.68885 | Rio Vista 21 | [] |
| 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 | [] |
| 640674 | October 03, 2019 - 20:19:03 UTC | 38.11836 | -121.74075 | Rio Vista 21 | [] |
| 641897 | October 04, 2019 - 00:01:56 UTC | 38.11836 | -121.74075 | 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 | [] |
| 630055 | September 30, 2019 - 15:24:00 UTC | 38.12243 | -121.83043 | Rio Vista 21 | [] |
| 705542 | November 13, 2019 - 00:40:00 UTC | 38.12243 | -121.83043 | Rio Vista 21 | [] |
| 680937 | October 26, 2019 - 22:58:21 UTC | 38.12853 | -121.74417 | Rio Vista 21 | [] |
| 691552 | October 28, 2019 - 16:46:52 UTC | 38.12853 | -121.74417 | Rio Vista 21 | [] |
| 727169 | December 02, 2019 - 16:25:04 UTC | 38.14282 | -121.69542 | Rio Vista 21 | [] |
| 647591 | October 08, 2019 - 22:34:00 UTC | 38.1434 | -121.72547 | Rio Vista 21 | [] |
| 695930 | October 31, 2019 - 00:38:00 UTC | 38.1434 | -121.72547 | Rio Vista 21 | [] |
| 697513 | November 01, 2019 - 19:07:00 UTC | 38.1434 | -121.72547 | 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 | [] |
| 643813 | October 05, 2019 - 01:09:00 UTC | 38.14629 | -121.71346 | Rio Vista 21 | [] |
| 691560 | October 28, 2019 - 16:49:00 UTC | 38.14629 | -121.71346 | Rio Vista 21 | [] |
| 782249 | February 09, 2020 - 18:28:10 UTC | 38.15008 | -121.695 | Rio Vista 21 | [] |
| 695876 | October 31, 2019 - 00:13:47 UTC | 38.15042 | -121.70561 | Rio Vista 21 | [] |
| 700358 | November 06, 2019 - 01:21:14 UTC | 38.15134 | -121.6988 | 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 | [] |
| 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"}] |
| 701214 | November 07, 2019 - 00:23:11 UTC | 38.15217 | -121.69589 | 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 | [] |
| 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 | [] |
| 697971 | November 02, 2019 - 01:11:28 UTC | 38.15234 | -121.69408 | Rio Vista 21 | [] |
| 726334 | December 02, 2019 - 00:15:20 UTC | 38.15276 | -121.80834 | Rio Vista 21 | [] |
| 713482 | November 23, 2019 - 19:10:53 UTC | 38.15536 | -121.69342 | 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"}] |
| 744607 | December 17, 2019 - 20:30:03 UTC | 38.15652 | -121.6909 | Rio Vista 21 | [] |
| 702867 | November 08, 2019 - 21:12:51 UTC | 38.15713 | -121.68942 | Rio Vista 21 | [] |
| 700550 | November 06, 2019 - 15:58:05 UTC | 38.15718 | -121.69162 | Rio Vista 21 | [] |
| 686648 | October 27, 2019 - 11:21:47 UTC | 38.1584 | -121.69572 | Rio Vista 21 | [] |
| 701660 | November 07, 2019 - 16:15:52 UTC | 38.1584 | -121.70377 | Rio Vista 21 | [] |
| 686552 | October 27, 2019 - 10:29:34 UTC | 38.15859 | -121.69673 | Rio Vista 21 | [] |
| 743533 | December 16, 2019 - 20:15:16 UTC | 38.15859 | -121.69673 | Rio Vista 21 | [] |
| 686681 | October 27, 2019 - 11:37:50 UTC | 38.1586 | -121.70127 | Rio Vista 21 | [] |
| 691345 | October 28, 2019 - 14:59:51 UTC | 38.1586 | -121.70127 | Rio Vista 21 | [] |
| 693651 | October 29, 2019 - 17:14:34 UTC | 38.1586 | -121.70127 | Rio Vista 21 | [] |
| 710721 | November 20, 2019 - 15:14:28 UTC | 38.1586 | -121.70127 | Rio Vista 21 | [] |
| 701156 | November 06, 2019 - 23:42:55 UTC | 38.15922 | -121.70484 | Rio Vista 21 | [] |
| 654093 | October 11, 2019 - 14:15:44 UTC | 38.15927 | -121.69669 | Rio Vista 21 | [] |
| 708530 | November 17, 2019 - 06:35:40 UTC | 38.15927 | -121.69669 | Rio Vista 21 | [] |
| 710752 | November 20, 2019 - 15:17:40 UTC | 38.15927 | -121.69669 | Rio Vista 21 | [] |
| 788469 | February 11, 2020 - 17:17:36 UTC | 38.15927 | -121.69669 | Rio Vista 21 | [] |
| 789266 | February 12, 2020 - 15:46:22 UTC | 38.15927 | -121.69669 | Rio Vista 21 | [] |
| 711398 | November 20, 2019 - 18:09:50 UTC | 38.1595 | -121.7001 | 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"}] |
| 680956 | October 26, 2019 - 23:33:00 UTC | 38.15998 | -121.73215 | Rio Vista 21 | [] |
| 695886 | October 31, 2019 - 00:18:00 UTC | 38.15998 | -121.73215 | Rio Vista 21 | [] |
| 697519 | November 01, 2019 - 19:12:02 UTC | 38.15998 | -121.73215 | Rio Vista 21 | [] |
| 693985 | October 29, 2019 - 19:21:32 UTC | 38.16019 | -121.69822 | Rio Vista 21 | [] |
| 709703 | November 19, 2019 - 03:35:00 UTC | 38.16043 | -121.70083 | 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"}] |
| 699229 | November 04, 2019 - 18:37:27 UTC | 38.16063 | -121.70322 | Rio Vista 21 | [] |
| 700449 | November 06, 2019 - 08:47:00 UTC | 38.16063 | -121.69639 | Rio Vista 21 | [{"latitude": "38.15986", "longitude": "-121.69446"}, {"latitude": "38.16063", "longitude": "-121.69022"}, {"latitude": "38.16115", "longitude": "-121.68943"}, {"latitude": "38.16292", "longitude": "-121.68688"}, {"latitude": "38.1633", "longitude": "-121.68756"}, {"latitude": "38.16368", "longitude": "-121.68847"}, {"latitude": "38.16482", "longitude": "-121.69349"}, {"latitude": "38.16537", "longitude": "-121.69727"}, {"latitude": "38.16206", "longitude": "-121.69695"}, {"latitude": "38.16148", "longitude": "-121.69642"}, {"latitude": "38.16124", "longitude": "-121.69618"}, {"latitude": "38.16047", "longitude": "-121.6954"}] |
| 700557 | November 06, 2019 - 16:02:00 UTC | 38.16063 | -121.70322 | Rio Vista 21 | [] |
| 680277 | October 25, 2019 - 16:06:33 UTC | 38.16092 | -121.69351 | Rio Vista 21 | [] |
| 680459 | October 25, 2019 - 19:29:05 UTC | 38.16105 | -121.695 | Rio Vista 21 | [] |
| 681302 | October 27, 2019 - 00:32:43 UTC | 38.16143 | -121.73341 | Rio Vista 21 | [] |
| 697501 | November 01, 2019 - 19:01:00 UTC | 38.16143 | -121.73341 | Rio Vista 21 | [] |
| 709617 | November 19, 2019 - 00:43:00 UTC | 38.16202 | -121.702 | Rio Vista 21 | [{"latitude": "38.15922", "longitude": "-121.70484"}, {"latitude": "38.16063", "longitude": "-121.70322"}, {"latitude": "38.16181", "longitude": "-121.70188"}, {"latitude": "38.16028", "longitude": "-121.7041"}] |
| 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 | [] |
| 700548 | November 06, 2019 - 15:57:47 UTC | 38.16243 | -121.69975 | Rio Vista 21 | [] |
| 743556 | December 16, 2019 - 20:25:50 UTC | 38.16248 | -121.68852 | Rio Vista 21 | [] |
| 640875 | October 03, 2019 - 20:35:00 UTC | 38.1628 | -121.73002 | Rio Vista 21 | [] |
| 691568 | October 28, 2019 - 16:55:01 UTC | 38.1628 | -121.73002 | Rio Vista 21 | [] |
| 637413 | October 02, 2019 - 19:47:35 UTC | 38.16335 | -121.68582 | Rio Vista 21 | [] |
| 700528 | November 06, 2019 - 15:54:00 UTC | 38.16391 | -121.6923 | 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 | [] |
| 686717 | October 27, 2019 - 12:19:02 UTC | 38.16482 | -121.69349 | Rio Vista 21 | [] |
| 700280 | November 05, 2019 - 23:26:00 UTC | 38.16488 | -121.69107 | Rio Vista 21 | [] |
| 699225 | November 04, 2019 - 18:35:03 UTC | 38.16525 | -121.69279 | 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 | [] |
| 713670 | November 24, 2019 - 03:33:52 UTC | 38.16537 | -121.69727 | Rio Vista 21 | [] |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [outages] ( [id] INTEGER PRIMARY KEY, [outageStartTime] INTEGER, [latitude] TEXT, [longitude] TEXT, [regionName] INTEGER REFERENCES [regionName]([id]), [outageDevices] TEXT )