526 rows where regionName = 38

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
717128 November 27, 2019 - 02:10:26 UTC 37.74909 -121.42997 Tracy 38 []
717243 November 27, 2019 - 02:20:25 UTC 37.68086 -121.27362 Tracy 38 []
717251 November 27, 2019 - 02:22:00 UTC 37.72832 -121.41699 Tracy 38 []
717267 November 27, 2019 - 02:23:40 UTC 37.6829 -121.28007 Tracy 38 []
717508 November 27, 2019 - 02:46:06 UTC 37.68327 -121.28093 Tracy 38 []
717739 November 27, 2019 - 03:10:45 UTC 37.74304 -121.43846 Tracy 38 []
718262 November 27, 2019 - 04:03:21 UTC 37.67816 -121.27635 Tracy 38 []
719044 November 27, 2019 - 05:45:51 UTC 37.74304 -121.43846 Tracy 38 []
720115 November 27, 2019 - 13:46:26 UTC 37.7308 -121.50791 Tracy 38 []
720708 November 27, 2019 - 16:55:01 UTC 37.69507 -121.41372 Tracy 38 []
720813 November 27, 2019 - 17:13:35 UTC 37.69355 -121.41292 Tracy 38 []
721028 November 27, 2019 - 18:11:00 UTC 37.6443 -121.32434 Tracy 38 []
722010 November 28, 2019 - 00:41:00 UTC 37.75283 -121.3497 Tracy 38 [{"latitude": "37.6996", "longitude": "-121.36119"}, {"latitude": "37.69961", "longitude": "-121.35963"}, {"latitude": "37.76058", "longitude": "-121.31091"}, {"latitude": "37.77245", "longitude": "-121.30472"}, {"latitude": "37.7795", "longitude": "-121.30234"}, {"latitude": "37.78736", "longitude": "-121.30915"}, {"latitude": "37.78592", "longitude": "-121.34145"}, {"latitude": "37.73965", "longitude": "-121.37695"}, {"latitude": "37.70591", "longitude": "-121.36924"}]
723810 November 30, 2019 - 00:55:19 UTC 37.68327 -121.28093 Tracy 38 []
724217 November 30, 2019 - 20:10:11 UTC 37.69595 -121.43356 Tracy 38 []
724870 December 01, 2019 - 01:45:00 UTC 37.74805 -121.4163 Tracy 38 [{"latitude": "37.7448", "longitude": "-121.42191"}, {"latitude": "37.74746", "longitude": "-121.42006"}, {"latitude": "37.75036", "longitude": "-121.42061"}, {"latitude": "37.75345", "longitude": "-121.42576"}, {"latitude": "37.75367", "longitude": "-121.42659"}, {"latitude": "37.74964", "longitude": "-121.43069"}, {"latitude": "37.74835", "longitude": "-121.42997"}, {"latitude": "37.74482", "longitude": "-121.42505"}, {"latitude": "37.7448", "longitude": "-121.4238"}]
724884 December 01, 2019 - 01:49:42 UTC 37.75029 -121.42939 Tracy 38 []
725058 December 01, 2019 - 02:58:36 UTC 37.73703 -121.42725 Tracy 38 []
725260 December 01, 2019 - 05:56:00 UTC 37.68639 -121.34914 Tracy 38 [{"latitude": "37.68122", "longitude": "-121.35069"}, {"latitude": "37.68181", "longitude": "-121.3482"}, {"latitude": "37.68204", "longitude": "-121.34758"}, {"latitude": "37.6828", "longitude": "-121.34641"}, {"latitude": "37.68582", "longitude": "-121.3491"}, {"latitude": "37.68177", "longitude": "-121.35453"}]
725355 December 01, 2019 - 07:17:00 UTC 37.75968 -121.41946 Tracy 38 [{"latitude": "37.75968", "longitude": "-121.42054"}, {"latitude": "37.75969", "longitude": "-121.42139"}, {"latitude": "37.75969", "longitude": "-121.4228"}]
725388 December 01, 2019 - 07:47:00 UTC 37.67582 -121.41744 Tracy 38 []
725390 December 01, 2019 - 07:49:00 UTC 37.68121 -121.41621 Tracy 38 []
725396 December 01, 2019 - 08:00:19 UTC 37.73703 -121.42725 Tracy 38 []
725459 December 01, 2019 - 09:30:09 UTC 37.7197 -121.44944 Tracy 38 []
725477 December 01, 2019 - 07:15:10 UTC 37.6673 -121.32849 Tracy 38 [{"latitude": "37.66662", "longitude": "-121.33863"}, {"latitude": "37.6673", "longitude": "-121.32856"}, {"latitude": "37.66846", "longitude": "-121.33547"}]
725517 December 01, 2019 - 10:05:00 UTC 37.77364 -121.3833 Tracy 38 []
725521 December 01, 2019 - 10:06:18 UTC 37.67075 -121.41047 Tracy 38 []
725809 December 01, 2019 - 16:40:49 UTC 37.69576 -121.44727 Tracy 38 []
725825 December 01, 2019 - 16:55:00 UTC 37.76556 -121.335 Tracy 38 []
725851 December 01, 2019 - 17:27:00 UTC 37.67546 -121.27119 Tracy 38 []
726012 December 01, 2019 - 19:43:54 UTC 37.74922 -121.40881 Tracy 38 []
726338 December 02, 2019 - 00:19:18 UTC 37.71462 -121.55351 Tracy 38 []
727014 December 02, 2019 - 13:57:36 UTC 37.75394 -121.40907 Tracy 38 []
727743 December 02, 2019 - 22:21:45 UTC 37.79049 -121.4571 Tracy 38 []
727744 December 02, 2019 - 22:21:45 UTC 37.79048 -121.45493 Tracy 38 []
727754 December 02, 2019 - 22:22:38 UTC 37.79047 -121.47081 Tracy 38 []
727755 December 02, 2019 - 22:22:15 UTC 37.7942 -121.4618 Tracy 38 []
727816 December 02, 2019 - 23:19:44 UTC 37.67899 -121.27252 Tracy 38 []
729207 December 04, 2019 - 09:58:39 UTC 37.73127 -121.45329 Tracy 38 [{"latitude": "37.73049", "longitude": "-121.45225"}, {"latitude": "37.73058", "longitude": "-121.4501"}, {"latitude": "37.73085", "longitude": "-121.44592"}, {"latitude": "37.73257", "longitude": "-121.44788"}, {"latitude": "37.73286", "longitude": "-121.45175"}, {"latitude": "37.73221", "longitude": "-121.45244"}]
729594 December 04, 2019 - 17:44:27 UTC 37.77156 -121.42335 Tracy 38 []
729657 December 04, 2019 - 18:22:40 UTC 37.6339 -121.29028 Tracy 38 []
729730 December 04, 2019 - 19:21:32 UTC 37.76983 -121.41912 Tracy 38 [{"latitude": "37.77058", "longitude": "-121.41841"}, {"latitude": "37.77059", "longitude": "-121.41756"}, {"latitude": "37.7728", "longitude": "-121.42166"}]
729994 December 04, 2019 - 23:51:58 UTC 37.80271 -121.48483 Tracy 38 []
730027 December 05, 2019 - 00:53:24 UTC 37.74364 -121.42995 Tracy 38 []
730277 December 05, 2019 - 16:05:54 UTC 37.70059 -121.44005 Tracy 38 [{"latitude": "37.70078", "longitude": "-121.43817"}, {"latitude": "37.70184", "longitude": "-121.43743"}, {"latitude": "37.70279", "longitude": "-121.43686"}, {"latitude": "37.70282", "longitude": "-121.44046"}]
730396 December 05, 2019 - 17:40:00 UTC 37.74367 -121.43748 Tracy 38 []
730428 December 05, 2019 - 17:40:49 UTC 37.753 -121.35365 Tracy 38 []
730486 December 05, 2019 - 18:15:00 UTC 37.74384 -121.43845 Tracy 38 []
730532 December 05, 2019 - 18:51:25 UTC 37.7728 -121.42166 Tracy 38 []
730538 December 05, 2019 - 18:56:07 UTC 37.73652 -121.40344 Tracy 38 []
730602 December 05, 2019 - 20:03:57 UTC 37.74871 -121.43439 Tracy 38 []
730683 December 05, 2019 - 21:17:00 UTC 37.75283 -121.3497 Tracy 38 [{"latitude": "37.6996", "longitude": "-121.36119"}, {"latitude": "37.69961", "longitude": "-121.35963"}, {"latitude": "37.76058", "longitude": "-121.31091"}, {"latitude": "37.77245", "longitude": "-121.30472"}, {"latitude": "37.7795", "longitude": "-121.30234"}, {"latitude": "37.78736", "longitude": "-121.30915"}, {"latitude": "37.78592", "longitude": "-121.34145"}, {"latitude": "37.73965", "longitude": "-121.37695"}, {"latitude": "37.70591", "longitude": "-121.36924"}]
731015 December 06, 2019 - 09:24:37 UTC 37.76983 -121.41912 Tracy 38 [{"latitude": "37.77058", "longitude": "-121.41841"}, {"latitude": "37.77059", "longitude": "-121.41756"}, {"latitude": "37.7728", "longitude": "-121.42166"}]
731042 December 06, 2019 - 12:59:58 UTC 37.77135 -121.51331 Tracy 38 [{"latitude": "37.76424", "longitude": "-121.51955"}, {"latitude": "37.76568", "longitude": "-121.51272"}, {"latitude": "37.77074", "longitude": "-121.51331"}, {"latitude": "37.7685", "longitude": "-121.51811"}]
731089 December 06, 2019 - 15:24:08 UTC 37.76982 -121.51331 Tracy 38 []
732320 December 07, 2019 - 16:22:13 UTC 37.76789 -121.49947 Tracy 38 []
733257 December 08, 2019 - 02:19:46 UTC 37.75486 -121.57558 Tracy 38 []
733518 December 08, 2019 - 09:00:15 UTC 37.752 -121.35794 Tracy 38 []
733689 December 08, 2019 - 18:42:58 UTC 37.77156 -121.42335 Tracy 38 []
734058 December 09, 2019 - 03:52:19 UTC 37.74483 -121.59608 Tracy 38 [{"latitude": "37.74385", "longitude": "-121.60298"}, {"latitude": "37.74502", "longitude": "-121.59958"}, {"latitude": "37.74505", "longitude": "-121.60249"}]
734391 December 09, 2019 - 17:53:52 UTC 37.74794 -121.41889 Tracy 38 []
734741 December 09, 2019 - 21:31:38 UTC 37.68086 -121.27362 Tracy 38 []
734851 December 09, 2019 - 23:30:06 UTC 37.73794 -121.42534 Tracy 38 []
735427 December 10, 2019 - 17:36:51 UTC 37.73792 -121.42532 Tracy 38 []
735981 December 11, 2019 - 03:02:34 UTC 37.74602 -121.59659 Tracy 38 []
736265 December 11, 2019 - 17:05:00 UTC 37.73127 -121.45329 Tracy 38 [{"latitude": "37.73049", "longitude": "-121.45225"}, {"latitude": "37.73058", "longitude": "-121.4501"}, {"latitude": "37.73085", "longitude": "-121.44592"}, {"latitude": "37.73257", "longitude": "-121.44788"}, {"latitude": "37.73286", "longitude": "-121.45175"}, {"latitude": "37.73221", "longitude": "-121.45244"}]
736266 December 11, 2019 - 17:05:00 UTC 37.71272 -121.47881 Tracy 38 [{"latitude": "37.71563", "longitude": "-121.46385"}, {"latitude": "37.72212", "longitude": "-121.44443"}, {"latitude": "37.72791", "longitude": "-121.44494"}, {"latitude": "37.73347", "longitude": "-121.44604"}, {"latitude": "37.73833", "longitude": "-121.44946"}, {"latitude": "37.74069", "longitude": "-121.45422"}, {"latitude": "37.74347", "longitude": "-121.46016"}, {"latitude": "37.74401", "longitude": "-121.46465"}, {"latitude": "37.74313", "longitude": "-121.46497"}, {"latitude": "37.74162", "longitude": "-121.46547"}, {"latitude": "37.71685", "longitude": "-121.47356"}]
736332 December 11, 2019 - 17:42:00 UTC 37.74029 -121.4584 Tracy 38 []
736397 December 11, 2019 - 18:23:11 UTC 37.72977 -121.45827 Tracy 38 []
736426 December 11, 2019 - 18:49:17 UTC 37.74738 -121.41889 Tracy 38 []
736587 December 11, 2019 - 21:12:15 UTC 37.74212 -121.43846 Tracy 38 []
736610 December 11, 2019 - 21:36:48 UTC 37.70749 -121.30734 Tracy 38 []
736715 December 11, 2019 - 23:37:18 UTC 37.71593 -121.42851 Tracy 38 []
737923 December 13, 2019 - 02:02:57 UTC 37.76453 -121.46234 Tracy 38 []
737969 December 13, 2019 - 05:08:53 UTC 37.7522 -121.43676 Tracy 38 []
738059 December 13, 2019 - 12:30:21 UTC 37.71057 -121.46492 Tracy 38 []
738519 December 13, 2019 - 19:32:34 UTC 37.73286 -121.45175 Tracy 38 []
738788 December 14, 2019 - 03:21:24 UTC 37.73018 -121.43389 Tracy 38 []
738799 December 14, 2019 - 04:02:00 UTC 37.7337 -121.43614 Tracy 38 []
740293 December 15, 2019 - 21:21:34 UTC 37.75055 -121.43021 Tracy 38 []
742234 December 16, 2019 - 18:09:08 UTC 37.72265 -121.41749 Tracy 38 []
743600 December 16, 2019 - 21:02:03 UTC 37.74796 -121.57658 Tracy 38 []
778008 February 05, 2020 - 00:10:00 UTC 37.7172 -121.4435 Tracy 38 []
778144 February 05, 2020 - 04:48:28 UTC 37.72172 -121.44908 Tracy 38 []
778230 February 05, 2020 - 15:43:26 UTC 37.76774 -121.42907 Tracy 38 []
779114 February 06, 2020 - 17:01:02 UTC 37.7217 -121.49471 Tracy 38 []
779146 February 06, 2020 - 17:21:05 UTC 37.80486 -121.45001 Tracy 38 []
779294 February 06, 2020 - 19:18:12 UTC 37.74978 -121.30259 Tracy 38 []
779419 February 06, 2020 - 20:40:09 UTC 37.72915 -121.33219 Tracy 38 []
780320 February 08, 2020 - 00:55:27 UTC 37.7514 -121.39211 Tracy 38 []
780646 February 08, 2020 - 21:02:32 UTC 37.76084 -121.469 Tracy 38 []
780790 February 09, 2020 - 04:23:57 UTC 37.71538 -121.40879 Tracy 38 [{"latitude": "37.71242", "longitude": "-121.40809"}, {"latitude": "37.71305", "longitude": "-121.40755"}, {"latitude": "37.71438", "longitude": "-121.40799"}, {"latitude": "37.71337", "longitude": "-121.41033"}, {"latitude": "37.7132", "longitude": "-121.41051"}]
781781 February 09, 2020 - 17:43:00 UTC 37.71364 -121.40827 Tracy 38 []
784005 February 09, 2020 - 20:42:27 UTC 37.68098 -121.26826 Tracy 38 []
784807 February 09, 2020 - 22:10:29 UTC 37.69908 -121.40909 Tracy 38 []
785601 February 10, 2020 - 00:22:57 UTC 37.67943 -121.2745 Tracy 38 []
785847 February 10, 2020 - 01:12:15 UTC 37.68086 -121.27362 Tracy 38 []
785902 February 10, 2020 - 01:33:03 UTC 37.75596 -121.4322 Tracy 38 []
786313 February 09, 2020 - 20:42:27 UTC 37.68098 -121.26826 Tracy 38 []
787069 February 10, 2020 - 16:44:36 UTC 37.75626 -121.43277 Tracy 38 []

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