228 rows where regionName = 102

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633780 October 01, 2019 - 15:53:00 UTC 37.77511 -120.82238 Oakdale 102 [{"latitude": "37.77385", "longitude": "-120.82186"}, {"latitude": "37.77486", "longitude": "-120.82235"}, {"latitude": "37.7739", "longitude": "-120.82247"}]
633783 October 01, 2019 - 15:57:00 UTC 37.72426 -120.72623 Oakdale 102 []
633906 October 01, 2019 - 17:18:28 UTC 37.72428 -120.72627 Oakdale 102 []
636314 October 02, 2019 - 17:11:00 UTC 37.77499 -120.82312 Oakdale 102 []
637293 October 02, 2019 - 19:34:00 UTC 37.71106 -120.7937 Oakdale 102 [{"latitude": "37.70325", "longitude": "-120.81203"}, {"latitude": "37.70383", "longitude": "-120.80584"}, {"latitude": "37.71106", "longitude": "-120.79587"}, {"latitude": "37.71449", "longitude": "-120.81201"}, {"latitude": "37.70907", "longitude": "-120.81739"}]
638905 October 03, 2019 - 06:29:05 UTC 37.7656 -120.8837 Oakdale 102 []
638907 October 03, 2019 - 06:38:46 UTC 37.76713 -120.87882 Oakdale 102 []
639227 October 03, 2019 - 16:39:00 UTC 37.77482 -120.82409 Oakdale 102 []
642198 October 04, 2019 - 03:15:00 UTC 37.808 -120.72178 Oakdale 102 [{"latitude": "37.79284", "longitude": "-120.71942"}, {"latitude": "37.8127", "longitude": "-120.70661"}, {"latitude": "37.81248", "longitude": "-120.71137"}, {"latitude": "37.80818", "longitude": "-120.71493"}, {"latitude": "37.79864", "longitude": "-120.71971"}]
642953 October 04, 2019 - 16:24:56 UTC 37.77461 -120.82477 Oakdale 102 [{"latitude": "37.77338", "longitude": "-120.82459"}, {"latitude": "37.77445", "longitude": "-120.82468"}, {"latitude": "37.77405", "longitude": "-120.82465"}]
646936 October 08, 2019 - 00:05:02 UTC 37.70123 -120.87706 Oakdale 102 []
647450 October 08, 2019 - 18:49:48 UTC 37.82019 -120.91217 Oakdale 102 []
648454 October 09, 2019 - 08:55:54 UTC 37.77971 -120.81826 Oakdale 102 []
650878 October 09, 2019 - 17:58:38 UTC 37.73603 -120.90786 Oakdale 102 []
653646 October 10, 2019 - 23:47:49 UTC 37.72953 -120.89429 Oakdale 102 []
654851 October 12, 2019 - 01:36:10 UTC 37.69566 -120.80511 Oakdale 102 []
655010 October 12, 2019 - 12:17:15 UTC 37.77486 -120.78254 Oakdale 102 []
655011 October 12, 2019 - 12:17:15 UTC 37.77082 -120.78327 Oakdale 102 []
655012 October 12, 2019 - 12:17:15 UTC 37.7637 -120.78569 Oakdale 102 [{"latitude": "37.76435", "longitude": "-120.78439"}, {"latitude": "37.76439", "longitude": "-120.78353"}, {"latitude": "37.76439", "longitude": "-120.78359"}]
656113 October 14, 2019 - 16:29:10 UTC 37.75945 -120.8582 Oakdale 102 []
656713 October 14, 2019 - 17:29:14 UTC 37.77599 -120.77686 Oakdale 102 []
658395 October 14, 2019 - 21:46:22 UTC 37.76308 -120.83561 Oakdale 102 []
658731 October 15, 2019 - 03:41:20 UTC 37.84764 -120.93751 Oakdale 102 []
659953 October 16, 2019 - 01:48:14 UTC 37.85687 -120.91055 Oakdale 102 []
662393 October 16, 2019 - 21:34:27 UTC 37.80924 -120.7289 Oakdale 102 []
664030 October 17, 2019 - 15:47:13 UTC 37.77448 -120.82612 Oakdale 102 []
667677 October 18, 2019 - 15:17:00 UTC 37.77472 -120.8253 Oakdale 102 []
668133 October 18, 2019 - 16:06:16 UTC 37.71131 -120.81198 Oakdale 102 []
668134 October 18, 2019 - 16:06:16 UTC 37.71104 -120.81197 Oakdale 102 [{"latitude": "37.70325", "longitude": "-120.81203"}, {"latitude": "37.70383", "longitude": "-120.80584"}, {"latitude": "37.7086", "longitude": "-120.8119"}]
668933 October 18, 2019 - 17:50:55 UTC 37.76604 -120.85922 Oakdale 102 []
669533 October 18, 2019 - 19:38:00 UTC 37.78292 -120.90451 Oakdale 102 []
669953 October 18, 2019 - 20:32:35 UTC 37.76323 -120.84599 Oakdale 102 []
676449 October 21, 2019 - 23:37:58 UTC 37.74459 -120.81704 Oakdale 102 []
676489 October 22, 2019 - 00:36:04 UTC 37.74403 -120.81694 Oakdale 102 []
680272 October 25, 2019 - 16:01:17 UTC 37.77811 -120.84876 Oakdale 102 []
693692 October 29, 2019 - 17:24:53 UTC 37.7927 -120.73203 Oakdale 102 []
697295 November 01, 2019 - 15:44:08 UTC 37.81852 -120.86663 Oakdale 102 [{"latitude": "37.81792", "longitude": "-120.86795"}, {"latitude": "37.81793", "longitude": "-120.86718"}, {"latitude": "37.81816", "longitude": "-120.86663"}]
698051 November 02, 2019 - 11:09:45 UTC 37.81884 -120.86827 Oakdale 102 []
699540 November 05, 2019 - 00:05:22 UTC 37.76179 -120.84897 Oakdale 102 []
699884 November 05, 2019 - 17:02:41 UTC 37.75745 -120.86605 Oakdale 102 []
699923 November 05, 2019 - 17:16:31 UTC 37.75198 -120.90204 Oakdale 102 [{"latitude": "37.72868", "longitude": "-120.92572"}, {"latitude": "37.72901", "longitude": "-120.92349"}, {"latitude": "37.73603", "longitude": "-120.90944"}, {"latitude": "37.73963", "longitude": "-120.90587"}, {"latitude": "37.74708", "longitude": "-120.89911"}, {"latitude": "37.75053", "longitude": "-120.89972"}, {"latitude": "37.75662", "longitude": "-120.91032"}, {"latitude": "37.75142", "longitude": "-120.91829"}, {"latitude": "37.74917", "longitude": "-120.91956"}]
700127 November 05, 2019 - 20:37:12 UTC 37.76908 -120.85707 Oakdale 102 []
700132 November 05, 2019 - 20:46:00 UTC 37.75834 -120.86686 Oakdale 102 [{"latitude": "37.75687", "longitude": "-120.86566"}, {"latitude": "37.75769", "longitude": "-120.86544"}, {"latitude": "37.75893", "longitude": "-120.86687"}, {"latitude": "37.75699", "longitude": "-120.86651"}]
700428 November 06, 2019 - 05:22:09 UTC 37.71115 -120.85003 Oakdale 102 []
700553 November 06, 2019 - 16:01:22 UTC 37.7516 -120.83241 Oakdale 102 []
700923 November 06, 2019 - 19:28:09 UTC 37.76998 -120.85159 Oakdale 102 []
701170 November 06, 2019 - 23:49:29 UTC 37.76661 -120.84458 Oakdale 102 []
702179 November 08, 2019 - 00:22:00 UTC 37.76939 -120.75625 Oakdale 102 []
702742 November 08, 2019 - 18:42:37 UTC 37.76909 -120.85902 Oakdale 102 []
703875 November 10, 2019 - 16:11:25 UTC 37.75185 -120.83797 Oakdale 102 []
703955 November 10, 2019 - 19:04:52 UTC 37.81643 -120.70649 Oakdale 102 []
704500 November 11, 2019 - 22:11:43 UTC 37.76233 -120.88667 Oakdale 102 []
705527 November 13, 2019 - 00:15:05 UTC 37.75293 -120.8264 Oakdale 102 []
706804 November 14, 2019 - 18:29:44 UTC 37.76017 -120.84717 Oakdale 102 []
706889 November 14, 2019 - 19:46:05 UTC 37.80272 -120.90504 Oakdale 102 []
707147 November 15, 2019 - 03:04:51 UTC 37.81884 -120.86827 Oakdale 102 []
707292 November 15, 2019 - 15:36:33 UTC 37.71059 -120.84839 Oakdale 102 [{"latitude": "37.68905", "longitude": "-120.8447"}, {"latitude": "37.69653", "longitude": "-120.84391"}, {"latitude": "37.70982", "longitude": "-120.84839"}, {"latitude": "37.69684", "longitude": "-120.8531"}, {"latitude": "37.69043", "longitude": "-120.84822"}, {"latitude": "37.68967", "longitude": "-120.84727"}]
707576 November 15, 2019 - 18:48:15 UTC 37.77095 -120.8426 Oakdale 102 []
707793 November 15, 2019 - 21:19:15 UTC 37.77095 -120.8426 Oakdale 102 []
708901 November 18, 2019 - 14:14:14 UTC 37.76846 -120.85058 Oakdale 102 []
710286 November 19, 2019 - 21:57:22 UTC 37.70123 -120.87706 Oakdale 102 []
711818 November 21, 2019 - 00:40:38 UTC 37.77068 -120.85141 Oakdale 102 []
711832 November 21, 2019 - 00:58:28 UTC 37.76971 -120.84132 Oakdale 102 []
712091 November 21, 2019 - 17:00:44 UTC 37.69489 -120.81483 Oakdale 102 []
715083 November 26, 2019 - 16:22:21 UTC 37.75461 -120.84885 Oakdale 102 []
717286 November 27, 2019 - 02:25:12 UTC 37.76604 -120.85922 Oakdale 102 []
718889 November 27, 2019 - 05:05:32 UTC 37.79822 -120.88658 Oakdale 102 []
718969 November 27, 2019 - 05:19:01 UTC 37.77597 -120.89635 Oakdale 102 []
719729 November 27, 2019 - 10:39:06 UTC 37.7183 -120.79439 Oakdale 102 [{"latitude": "37.71641", "longitude": "-120.80224"}, {"latitude": "37.71733", "longitude": "-120.79673"}, {"latitude": "37.71831", "longitude": "-120.79572"}, {"latitude": "37.7204", "longitude": "-120.79754"}, {"latitude": "37.71976", "longitude": "-120.80564"}, {"latitude": "37.71834", "longitude": "-120.8063"}]
720196 November 27, 2019 - 14:23:17 UTC 37.84492 -120.91087 Oakdale 102 []
723488 November 29, 2019 - 18:12:28 UTC 37.75462 -120.77277 Oakdale 102 []
723540 November 29, 2019 - 18:12:00 UTC 37.75457 -120.7685 Oakdale 102 [{"latitude": "37.75079", "longitude": "-120.76257"}, {"latitude": "37.75199", "longitude": "-120.7687"}, {"latitude": "37.75103", "longitude": "-120.76556"}]
723637 November 29, 2019 - 20:40:36 UTC 37.71873 -120.77589 Oakdale 102 []
725689 December 01, 2019 - 14:49:21 UTC 37.77338 -120.82459 Oakdale 102 []
725921 December 01, 2019 - 18:22:36 UTC 37.77566 -120.84786 Oakdale 102 []
726000 December 01, 2019 - 19:36:12 UTC 37.69653 -120.84455 Oakdale 102 []
726019 December 01, 2019 - 19:49:24 UTC 37.76936 -120.84531 Oakdale 102 []
726127 December 01, 2019 - 21:27:30 UTC 37.76998 -120.85159 Oakdale 102 []
726303 December 01, 2019 - 23:51:51 UTC 37.76998 -120.85159 Oakdale 102 []
727083 December 02, 2019 - 15:11:19 UTC 37.76587 -120.84298 Oakdale 102 []
727810 December 02, 2019 - 23:11:06 UTC 37.78703 -120.88438 Oakdale 102 []
728122 December 03, 2019 - 07:40:46 UTC 37.76136 -120.84936 Oakdale 102 [{"latitude": "37.76016", "longitude": "-120.85148"}, {"latitude": "37.76055", "longitude": "-120.85054"}, {"latitude": "37.76139", "longitude": "-120.84937"}, {"latitude": "37.76179", "longitude": "-120.84897"}, {"latitude": "37.7627", "longitude": "-120.84956"}, {"latitude": "37.76419", "longitude": "-120.85056"}, {"latitude": "37.76446", "longitude": "-120.85139"}, {"latitude": "37.76411", "longitude": "-120.85203"}, {"latitude": "37.76183", "longitude": "-120.85297"}]
728123 December 03, 2019 - 07:42:15 UTC 37.75979 -120.85087 Oakdale 102 []
728125 December 03, 2019 - 07:42:00 UTC 37.76103 -120.84941 Oakdale 102 []
728132 December 03, 2019 - 08:24:27 UTC 37.75873 -120.85991 Oakdale 102 []
728147 December 03, 2019 - 08:55:51 UTC 37.76103 -120.84941 Oakdale 102 []
728154 December 03, 2019 - 09:47:00 UTC 37.76419 -120.85056 Oakdale 102 []
728301 December 03, 2019 - 15:36:09 UTC 37.76136 -120.84936 Oakdale 102 [{"latitude": "37.76016", "longitude": "-120.85148"}, {"latitude": "37.76055", "longitude": "-120.85054"}, {"latitude": "37.76139", "longitude": "-120.84937"}, {"latitude": "37.76323", "longitude": "-120.85057"}, {"latitude": "37.7639", "longitude": "-120.85101"}, {"latitude": "37.76446", "longitude": "-120.85139"}, {"latitude": "37.76411", "longitude": "-120.85203"}, {"latitude": "37.76183", "longitude": "-120.85297"}]
728783 December 03, 2019 - 20:04:08 UTC 37.75115 -120.88829 Oakdale 102 []
729119 December 04, 2019 - 02:25:49 UTC 37.74171 -120.90578 Oakdale 102 []
729637 December 04, 2019 - 18:12:57 UTC 37.73942 -120.81234 Oakdale 102 []
729815 December 04, 2019 - 20:52:18 UTC 37.78848 -120.90473 Oakdale 102 []
730160 December 05, 2019 - 05:11:00 UTC 37.74007 -120.79779 Oakdale 102 [{"latitude": "37.73463", "longitude": "-120.79454"}, {"latitude": "37.7417", "longitude": "-120.7978"}, {"latitude": "37.73587", "longitude": "-120.79937"}]
730423 December 05, 2019 - 17:26:00 UTC 37.80578 -120.91502 Oakdale 102 [{"latitude": "37.80571", "longitude": "-120.91788"}, {"latitude": "37.80571", "longitude": "-120.91696"}, {"latitude": "37.80578", "longitude": "-120.91597"}]
730876 December 06, 2019 - 00:57:41 UTC 37.799 -120.8866 Oakdale 102 []
731008 December 06, 2019 - 08:35:00 UTC 37.76884 -120.83892 Oakdale 102 []
731328 December 06, 2019 - 17:21:25 UTC 37.799 -120.8866 Oakdale 102 []
731450 December 06, 2019 - 18:38:12 UTC 37.76191 -120.81989 Oakdale 102 []
731629 December 06, 2019 - 22:07:14 UTC 37.76101 -120.85206 Oakdale 102 []
731804 December 07, 2019 - 00:06:11 UTC 37.76197 -120.8621 Oakdale 102 []

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