outages

109 rows where regionName = 80

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633610 October 01, 2019 - 15:07:17 UTC 37.60368 -122.02977 Union City 80 []
633883 October 01, 2019 - 16:47:07 UTC 37.6083 -122.03215 Union City 80 []
633985 October 01, 2019 - 16:47:07 UTC 37.6083 -122.03215 Union City 80 []
643515 October 04, 2019 - 19:23:11 UTC 37.59419 -122.02682 Union City 80 []
647535 October 08, 2019 - 20:49:37 UTC 37.59681 -122.01886 Union City 80 []
653196 October 10, 2019 - 19:44:21 UTC 37.59304 -122.05933 Union City 80 []
653723 October 11, 2019 - 00:49:00 UTC 37.58493 -122.0209 Union City 80 []
653724 October 11, 2019 - 00:50:00 UTC 37.59266 -122.02591 Union City 80 []
653725 October 11, 2019 - 00:53:00 UTC 37.58721 -122.01909 Union City 80 []
654848 October 12, 2019 - 01:34:11 UTC 37.56856 -122.06721 Union City 80 []
655238 October 12, 2019 - 19:44:01 UTC 37.59115 -122.01489 Union City 80 []
667093 October 17, 2019 - 23:43:28 UTC 37.5877 -122.05126 Union City 80 []
667368 October 18, 2019 - 12:46:16 UTC 37.5942 -122.02257 Union City 80 [{"latitude": "37.59323", "longitude": "-122.02143"}, {"latitude": "37.59359", "longitude": "-122.02125"}, {"latitude": "37.59387", "longitude": "-122.02219"}]
675434 October 21, 2019 - 15:13:16 UTC 37.60257 -122.02628 Union City 80 []
677624 October 23, 2019 - 19:08:35 UTC 37.59554 -122.08209 Union City 80 []
677699 October 23, 2019 - 20:33:32 UTC 37.57542 -122.07272 Union City 80 []
680042 October 25, 2019 - 01:46:46 UTC 37.61084 -122.07827 Union City 80 []
680369 October 25, 2019 - 17:22:24 UTC 37.5946 -122.0392 Union City 80 []
687859 October 27, 2019 - 17:56:00 UTC 37.58946 -122.04691 Union City 80 [{"latitude": "37.5882", "longitude": "-122.0454"}, {"latitude": "37.58964", "longitude": "-122.04486"}, {"latitude": "37.59108", "longitude": "-122.04503"}, {"latitude": "37.59255", "longitude": "-122.04752"}, {"latitude": "37.59176", "longitude": "-122.04876"}, {"latitude": "37.5904", "longitude": "-122.04749"}]
687887 October 27, 2019 - 17:58:58 UTC 37.59882 -122.06769 Union City 80 []
687890 October 27, 2019 - 17:59:00 UTC 37.59659 -122.05578 Union City 80 [{"latitude": "37.5977", "longitude": "-122.05522"}, {"latitude": "37.59964", "longitude": "-122.05311"}, {"latitude": "37.60148", "longitude": "-122.05274"}, {"latitude": "37.60312", "longitude": "-122.05273"}, {"latitude": "37.60455", "longitude": "-122.05288"}, {"latitude": "37.60267", "longitude": "-122.05829"}, {"latitude": "37.59994", "longitude": "-122.05907"}, {"latitude": "37.59809", "longitude": "-122.05728"}]
687891 October 27, 2019 - 17:59:44 UTC 37.59907 -122.06575 Union City 80 []
687900 October 27, 2019 - 18:00:00 UTC 37.5935 -122.04777 Union City 80 []
687925 October 27, 2019 - 18:04:59 UTC 37.59622 -122.06608 Union City 80 []
688070 October 27, 2019 - 18:23:00 UTC 37.59527 -122.01746 Union City 80 [{"latitude": "37.57821", "longitude": "-121.97504"}, {"latitude": "37.57836", "longitude": "-121.97471"}, {"latitude": "37.6011", "longitude": "-121.98976"}, {"latitude": "37.60491", "longitude": "-122.0189"}, {"latitude": "37.60491", "longitude": "-122.01989"}, {"latitude": "37.60191", "longitude": "-122.01885"}, {"latitude": "37.59673", "longitude": "-122.01611"}, {"latitude": "37.59274", "longitude": "-122.01278"}, {"latitude": "37.58775", "longitude": "-122.00797"}, {"latitude": "37.58305", "longitude": "-121.99812"}, {"latitude": "37.58011", "longitude": "-121.99073"}, {"latitude": "37.5787", "longitude": "-121.98286"}]
688100 October 27, 2019 - 18:32:29 UTC 37.60423 -122.02033 Union City 80 []
688169 October 27, 2019 - 18:44:00 UTC 37.60408 -122.01894 Union City 80 []
688340 October 27, 2019 - 19:12:19 UTC 37.59734 -122.06633 Union City 80 []
688348 October 27, 2019 - 19:14:11 UTC 37.59994 -122.06857 Union City 80 []
688358 October 27, 2019 - 17:56:00 UTC 37.59108 -122.04503 Union City 80 []
688387 October 27, 2019 - 19:22:57 UTC 37.59582 -122.04826 Union City 80 []
688709 October 27, 2019 - 18:44:00 UTC 37.60408 -122.01894 Union City 80 []
688717 October 27, 2019 - 18:32:29 UTC 37.60423 -122.02033 Union City 80 []
688917 October 27, 2019 - 20:35:23 UTC 37.59706 -122.04822 Union City 80 []
689259 October 27, 2019 - 21:04:26 UTC 37.593 -122.00594 Union City 80 []
689318 October 27, 2019 - 21:11:01 UTC 37.59254 -122.00291 Union City 80 []
689472 October 27, 2019 - 21:31:29 UTC 37.59646 -122.01943 Union City 80 []
690380 October 28, 2019 - 00:09:38 UTC 37.60595 -122.02198 Union City 80 []
691362 October 28, 2019 - 15:12:36 UTC 37.60491 -122.01989 Union City 80 []
692021 October 28, 2019 - 21:20:11 UTC 37.60372 -122.01763 Union City 80 []
692751 October 29, 2019 - 03:46:59 UTC 37.59387 -122.02219 Union City 80 []
692873 October 29, 2019 - 09:45:00 UTC 37.58638 -122.02359 Union City 80 []
694249 October 29, 2019 - 22:09:40 UTC 37.59447 -122.00766 Union City 80 []
698929 November 04, 2019 - 13:39:54 UTC 37.59693 -122.03844 Union City 80 []
699899 November 05, 2019 - 17:08:20 UTC 37.58592 -122.05072 Union City 80 []
702438 November 08, 2019 - 15:46:51 UTC 37.58311 -122.06479 Union City 80 []
702988 November 08, 2019 - 23:15:00 UTC 37.60487 -122.02107 Union City 80 []
703052 November 09, 2019 - 01:01:10 UTC 37.59437 -122.02831 Union City 80 []
704014 November 10, 2019 - 22:00:20 UTC 37.58536 -122.06649 Union City 80 []
704122 November 11, 2019 - 02:53:09 UTC 37.60089 -122.01766 Union City 80 []
704749 November 12, 2019 - 16:30:30 UTC 37.60175 -122.03535 Union City 80 []
710056 November 19, 2019 - 18:16:15 UTC 37.5969 -122.07359 Union City 80 []
710137 November 19, 2019 - 19:23:50 UTC 37.5886 -122.03215 Union City 80 []
712503 November 21, 2019 - 23:54:27 UTC 37.5886 -122.03215 Union City 80 []
713496 November 23, 2019 - 19:33:10 UTC 37.5969 -122.07359 Union City 80 []
714266 November 25, 2019 - 17:54:15 UTC 37.60595 -122.02419 Union City 80 []
723670 November 29, 2019 - 21:10:47 UTC 37.59705 -122.01235 Union City 80 []
724770 December 01, 2019 - 01:19:18 UTC 37.60224 -122.02046 Union City 80 []
724776 December 01, 2019 - 01:23:19 UTC 37.59899 -122.02937 Union City 80 []
725336 December 01, 2019 - 06:51:35 UTC 37.60029 -122.02293 Union City 80 []
728668 December 03, 2019 - 18:50:50 UTC 37.60342 -122.02553 Union City 80 []
728996 December 03, 2019 - 23:17:20 UTC 37.59786 -122.02902 Union City 80 []
729145 December 04, 2019 - 03:22:05 UTC 37.60027 -122.04834 Union City 80 []
729731 December 04, 2019 - 19:23:42 UTC 37.62908 -121.94661 Union City 80 []
730140 December 05, 2019 - 03:45:51 UTC 37.60027 -122.04834 Union City 80 []
730270 December 05, 2019 - 16:01:28 UTC 37.59994 -122.05907 Union City 80 []
731319 December 06, 2019 - 17:16:58 UTC 37.62908 -121.94661 Union City 80 []
733995 December 09, 2019 - 01:29:01 UTC 37.60217 -122.06204 Union City 80 []
734085 December 09, 2019 - 08:42:04 UTC 37.57236 -122.06907 Union City 80 [{"latitude": "37.5715", "longitude": "-122.07044"}, {"latitude": "37.57297", "longitude": "-122.06948"}, {"latitude": "37.57392", "longitude": "-122.07155"}, {"latitude": "37.5726", "longitude": "-122.07304"}, {"latitude": "37.57195", "longitude": "-122.07219"}]
734976 December 10, 2019 - 02:24:51 UTC 37.59536 -122.0797 Union City 80 []
734989 December 10, 2019 - 02:55:00 UTC 37.6039 -122.05991 Union City 80 [{"latitude": "37.59985", "longitude": "-122.06048"}, {"latitude": "37.60182", "longitude": "-122.05991"}, {"latitude": "37.60387", "longitude": "-122.0598"}, {"latitude": "37.6018", "longitude": "-122.06223"}]
734990 December 10, 2019 - 02:55:54 UTC 37.59378 -122.07605 Union City 80 []
734991 December 10, 2019 - 02:56:05 UTC 37.60653 -122.06847 Union City 80 []
736821 December 12, 2019 - 01:12:49 UTC 37.58312 -122.0681 Union City 80 []
737663 December 12, 2019 - 21:01:06 UTC 37.60258 -122.05992 Union City 80 []
737967 December 13, 2019 - 04:58:14 UTC 37.60002 -122.02569 Union City 80 []
738699 December 13, 2019 - 23:42:08 UTC 37.60383 -122.06987 Union City 80 []
739213 December 14, 2019 - 16:20:58 UTC 37.59527 -122.03015 Union City 80 []
743745 December 16, 2019 - 23:20:45 UTC 37.60636 -122.07248 Union City 80 []
744446 December 17, 2019 - 18:25:37 UTC 37.62932 -121.94744 Union City 80 []
744535 December 17, 2019 - 19:35:16 UTC 37.59235 -122.05909 Union City 80 []
780611 February 08, 2020 - 19:10:49 UTC 37.6027 -122.01977 Union City 80 []
783651 February 09, 2020 - 20:09:22 UTC 37.58974 -122.01649 Union City 80 []
783704 February 09, 2020 - 20:16:00 UTC 37.60139 -122.0648 Union City 80 []
783738 February 09, 2020 - 20:21:00 UTC 37.58692 -122.07381 Union City 80 []
784392 February 09, 2020 - 21:32:00 UTC 37.607 -122.04118 Union City 80 []
785514 February 10, 2020 - 00:09:02 UTC 37.58259 -122.06748 Union City 80 []
785672 February 10, 2020 - 00:39:13 UTC 37.59233 -122.06206 Union City 80 []
786174 February 10, 2020 - 03:21:06 UTC 37.5925 -122.07204 Union City 80 []
786184 February 10, 2020 - 03:23:00 UTC 37.59048 -122.07243 Union City 80 []
786185 February 10, 2020 - 03:25:52 UTC 37.60446 -122.0722 Union City 80 []
786306 February 10, 2020 - 03:50:00 UTC 37.60217 -122.06204 Union City 80 []
786543 February 10, 2020 - 05:31:00 UTC 37.6039 -122.05991 Union City 80 [{"latitude": "37.59985", "longitude": "-122.06048"}, {"latitude": "37.60182", "longitude": "-122.05991"}, {"latitude": "37.60387", "longitude": "-122.0598"}, {"latitude": "37.6018", "longitude": "-122.06223"}]
786765 February 10, 2020 - 09:36:00 UTC 37.59439 -122.05217 Union City 80 []
787159 February 10, 2020 - 17:14:59 UTC 37.58362 -122.00846 Union City 80 []
787179 February 10, 2020 - 17:22:00 UTC 37.6018 -122.06223 Union City 80 []
788952 February 11, 2020 - 23:12:45 UTC 37.59157 -122.06342 Union City 80 []
789043 February 12, 2020 - 00:40:15 UTC 37.60057 -122.01851 Union City 80 []
789664 February 12, 2020 - 21:27:54 UTC 37.59646 -122.01943 Union City 80 []
1061473 September 09, 2020 - 01:13:42 UTC 37.60014 -122.02046 Union City 80 []

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
)
Powered by Datasette · Query took 1067.445ms · About: About this site