outages

1,748 rows where regionName = 2 sorted by outageStartTime

View and edit SQL

id outageStartTime ▼ latitude longitude regionName outageDevices
647324 October 08, 2019 - 16:27:39 UTC 35.40635 -118.95156 Bakersfield 2 []
647327 October 08, 2019 - 16:29:26 UTC 35.31802 -119.18468 Bakersfield 2 []
647467 October 08, 2019 - 19:14:28 UTC 35.40339 -118.8642 Bakersfield 2 []
647502 October 08, 2019 - 20:04:10 UTC 35.31583 -119.00668 Bakersfield 2 []
647511 October 08, 2019 - 20:09:07 UTC 35.4125 -118.96376 Bakersfield 2 []
647556 October 08, 2019 - 21:22:00 UTC 35.39726 -118.9251 Bakersfield 2 []
647619 October 08, 2019 - 23:26:47 UTC 35.40547 -118.98243 Bakersfield 2 []
647622 October 08, 2019 - 23:29:00 UTC 35.33623 -119.00958 Bakersfield 2 []
647625 October 08, 2019 - 23:37:31 UTC 35.37602 -118.96639 Bakersfield 2 [{"latitude": "35.37638", "longitude": "-118.96497"}, {"latitude": "35.37831", "longitude": "-118.96373"}, {"latitude": "35.37858", "longitude": "-118.96484"}, {"latitude": "35.37887", "longitude": "-118.96606"}, {"latitude": "35.37903", "longitude": "-118.96675"}, {"latitude": "35.3779", "longitude": "-118.96684"}, {"latitude": "35.37682", "longitude": "-118.96687"}, {"latitude": "35.37659", "longitude": "-118.96593"}]
647626 October 08, 2019 - 23:45:25 UTC 35.35733 -119.04595 Bakersfield 2 []
647773 October 09, 2019 - 04:33:14 UTC 35.33994 -119.0561 Bakersfield 2 []
648131 October 09, 2019 - 08:08:04 UTC 35.34203 -118.99271 Bakersfield 2 []
650527 October 09, 2019 - 13:39:08 UTC 35.32614 -119.0602 Bakersfield 2 []
650772 October 09, 2019 - 15:50:24 UTC 35.06962 -119.10893 Bakersfield 2 []
650792 October 09, 2019 - 16:20:29 UTC 35.3823 -118.94527 Bakersfield 2 []
650835 October 09, 2019 - 16:56:54 UTC 35.3737 -118.94605 Bakersfield 2 []
650838 October 09, 2019 - 16:57:52 UTC 35.40189 -118.98137 Bakersfield 2 [{"latitude": "35.40206", "longitude": "-118.98137"}, {"latitude": "35.40326", "longitude": "-118.98059"}, {"latitude": "35.40458", "longitude": "-118.98069"}, {"latitude": "35.40397", "longitude": "-118.98107"}, {"latitude": "35.4038", "longitude": "-118.98117"}, {"latitude": "35.40316", "longitude": "-118.98136"}]
650894 October 09, 2019 - 18:13:44 UTC 35.31493 -119.03724 Bakersfield 2 []
650907 October 09, 2019 - 18:30:00 UTC 35.40525 -118.98016 Bakersfield 2 []
651218 October 09, 2019 - 22:20:22 UTC 35.24726 -119.15781 Bakersfield 2 []
651595 October 10, 2019 - 00:02:00 UTC 35.40885 -118.93229 Bakersfield 2 []
651596 October 10, 2019 - 00:02:00 UTC 35.35987 -119.12963 Bakersfield 2 []
651672 October 10, 2019 - 00:39:17 UTC 35.38692 -119.03003 Bakersfield 2 [{"latitude": "35.38728", "longitude": "-119.02968"}, {"latitude": "35.38809", "longitude": "-119.02867"}, {"latitude": "35.38758", "longitude": "-119.02937"}]
651992 October 10, 2019 - 03:24:25 UTC 35.34998 -119.01148 Bakersfield 2 []
652196 October 10, 2019 - 06:09:00 UTC 35.37467 -118.93133 Bakersfield 2 []
652676 October 10, 2019 - 15:34:16 UTC 35.44107 -119.0474 Bakersfield 2 []
652808 October 10, 2019 - 16:52:00 UTC 35.42221 -118.9007 Bakersfield 2 [{"latitude": "35.39619", "longitude": "-118.85642"}, {"latitude": "35.39825", "longitude": "-118.83467"}, {"latitude": "35.42852", "longitude": "-118.75007"}, {"latitude": "35.43631", "longitude": "-118.74107"}, {"latitude": "35.43682", "longitude": "-118.74052"}, {"latitude": "35.44134", "longitude": "-118.79662"}, {"latitude": "35.44287", "longitude": "-118.85785"}, {"latitude": "35.43651", "longitude": "-118.87525"}, {"latitude": "35.41984", "longitude": "-118.89982"}, {"latitude": "35.4114", "longitude": "-118.90015"}, {"latitude": "35.41064", "longitude": "-118.90013"}, {"latitude": "35.39688", "longitude": "-118.86511"}]
653423 October 10, 2019 - 16:52:00 UTC 35.43913 -118.7971 Bakersfield 2 [{"latitude": "35.42852", "longitude": "-118.75007"}, {"latitude": "35.43631", "longitude": "-118.74107"}, {"latitude": "35.43682", "longitude": "-118.74052"}, {"latitude": "35.43904", "longitude": "-118.7969"}, {"latitude": "35.43525", "longitude": "-118.79631"}]
652838 October 10, 2019 - 17:06:00 UTC 35.47706 -118.88704 Bakersfield 2 [{"latitude": "35.48529", "longitude": "-118.88908"}, {"latitude": "35.48543", "longitude": "-118.88696"}, {"latitude": "35.48585", "longitude": "-118.89055"}]
653522 October 10, 2019 - 17:06:00 UTC 35.4825 -118.88719 Bakersfield 2 []
652845 October 10, 2019 - 17:13:00 UTC 35.09349 -119.10118 Bakersfield 2 [{"latitude": "34.99612", "longitude": "-119.08841"}, {"latitude": "35.00136", "longitude": "-119.06026"}, {"latitude": "35.07272", "longitude": "-119.03824"}, {"latitude": "35.07653", "longitude": "-119.03751"}, {"latitude": "35.08366", "longitude": "-119.03825"}, {"latitude": "35.11534", "longitude": "-119.0744"}, {"latitude": "35.11059", "longitude": "-119.09205"}, {"latitude": "35.06941", "longitude": "-119.11395"}, {"latitude": "35.0369", "longitude": "-119.1178"}, {"latitude": "35.03391", "longitude": "-119.11786"}]
652858 October 10, 2019 - 17:18:00 UTC 35.55934 -118.95738 Bakersfield 2 [{"latitude": "35.49373", "longitude": "-118.86122"}, {"latitude": "35.51156", "longitude": "-118.88089"}, {"latitude": "35.54862", "longitude": "-118.95672"}, {"latitude": "35.55042", "longitude": "-118.96194"}, {"latitude": "35.54041", "longitude": "-118.9601"}, {"latitude": "35.52954", "longitude": "-118.95592"}, {"latitude": "35.49916", "longitude": "-118.93647"}]
653529 October 10, 2019 - 17:18:00 UTC 35.49946 -118.90511 Bakersfield 2 [{"latitude": "35.49373", "longitude": "-118.86122"}, {"latitude": "35.51156", "longitude": "-118.88089"}, {"latitude": "35.5053", "longitude": "-118.89122"}, {"latitude": "35.50295", "longitude": "-118.89012"}]
652864 October 10, 2019 - 17:23:00 UTC 35.55934 -118.95732 Bakersfield 2 [{"latitude": "35.49984", "longitude": "-118.90535"}, {"latitude": "35.5575", "longitude": "-118.81194"}, {"latitude": "35.57844", "longitude": "-118.81222"}, {"latitude": "35.57987", "longitude": "-118.81244"}, {"latitude": "35.59765", "longitude": "-118.8238"}, {"latitude": "35.59774", "longitude": "-118.82689"}, {"latitude": "35.56652", "longitude": "-118.94527"}, {"latitude": "35.55855", "longitude": "-118.9572"}, {"latitude": "35.50811", "longitude": "-118.9203"}, {"latitude": "35.50023", "longitude": "-118.90614"}]
653443 October 10, 2019 - 17:23:00 UTC 35.55324 -118.93489 Bakersfield 2 [{"latitude": "35.49984", "longitude": "-118.90535"}, {"latitude": "35.5575", "longitude": "-118.81194"}, {"latitude": "35.57844", "longitude": "-118.81222"}, {"latitude": "35.57987", "longitude": "-118.81244"}, {"latitude": "35.59765", "longitude": "-118.8238"}, {"latitude": "35.59774", "longitude": "-118.82689"}, {"latitude": "35.55323", "longitude": "-118.93335"}, {"latitude": "35.50811", "longitude": "-118.9203"}, {"latitude": "35.50023", "longitude": "-118.90614"}]
652870 October 10, 2019 - 17:29:00 UTC 35.55933 -118.95714 Bakersfield 2 [{"latitude": "35.52005", "longitude": "-118.97864"}, {"latitude": "35.52744", "longitude": "-118.95981"}, {"latitude": "35.62995", "longitude": "-118.80719"}, {"latitude": "35.64388", "longitude": "-118.80672"}, {"latitude": "35.64443", "longitude": "-118.80683"}, {"latitude": "35.64895", "longitude": "-118.81466"}, {"latitude": "35.65649", "longitude": "-118.84323"}, {"latitude": "35.65587", "longitude": "-118.95781"}, {"latitude": "35.65101", "longitude": "-118.97686"}, {"latitude": "35.6496", "longitude": "-118.98125"}, {"latitude": "35.58951", "longitude": "-119.04716"}, {"latitude": "35.58266", "longitude": "-119.04424"}]
653542 October 10, 2019 - 17:29:00 UTC 35.62109 -118.84832 Bakersfield 2 [{"latitude": "35.62928", "longitude": "-118.85458"}, {"latitude": "35.62995", "longitude": "-118.80719"}, {"latitude": "35.64388", "longitude": "-118.80672"}, {"latitude": "35.64443", "longitude": "-118.80683"}, {"latitude": "35.64895", "longitude": "-118.81466"}, {"latitude": "35.65649", "longitude": "-118.84323"}, {"latitude": "35.65628", "longitude": "-118.84556"}, {"latitude": "35.65443", "longitude": "-118.84831"}, {"latitude": "35.63288", "longitude": "-118.87435"}]
653544 October 10, 2019 - 17:29:00 UTC 35.62055 -118.84755 Bakersfield 2 [{"latitude": "35.61404", "longitude": "-118.8349"}, {"latitude": "35.6224", "longitude": "-118.81923"}, {"latitude": "35.62519", "longitude": "-118.81959"}, {"latitude": "35.6267", "longitude": "-118.8302"}, {"latitude": "35.62314", "longitude": "-118.83557"}]
652879 October 10, 2019 - 17:33:00 UTC 35.08906 -118.97666 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.0325", "longitude": "-118.94709"}, {"latitude": "35.06081", "longitude": "-118.9441"}, {"latitude": "35.08263", "longitude": "-118.95805"}, {"latitude": "35.08628", "longitude": "-118.96808"}, {"latitude": "35.08973", "longitude": "-119.00367"}, {"latitude": "35.08979", "longitude": "-119.01173"}, {"latitude": "35.08979", "longitude": "-119.01236"}, {"latitude": "35.08346", "longitude": "-119.02903"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
652962 October 10, 2019 - 18:13:47 UTC 35.13748 -119.20782 Bakersfield 2 []
653011 October 10, 2019 - 18:34:43 UTC 35.33267 -118.86955 Bakersfield 2 []
653152 October 10, 2019 - 19:27:51 UTC 35.30846 -119.10821 Bakersfield 2 []
653246 October 10, 2019 - 20:02:29 UTC 35.45598 -118.8725 Bakersfield 2 []
653511 October 10, 2019 - 20:37:00 UTC 35.45605 -118.88595 Bakersfield 2 [{"latitude": "35.45452", "longitude": "-118.87299"}, {"latitude": "35.4551", "longitude": "-118.87257"}, {"latitude": "35.45993", "longitude": "-118.87149"}, {"latitude": "35.4607", "longitude": "-118.87514"}]
653486 October 10, 2019 - 21:56:13 UTC 35.31823 -119.04709 Bakersfield 2 []
653568 October 10, 2019 - 22:53:00 UTC 35.34753 -119.04656 Bakersfield 2 []
653606 October 10, 2019 - 23:16:53 UTC 35.37666 -118.99432 Bakersfield 2 []
653635 October 10, 2019 - 23:34:13 UTC 35.34753 -119.04656 Bakersfield 2 []
653666 October 11, 2019 - 00:03:30 UTC 35.31275 -119.06221 Bakersfield 2 []
653755 October 11, 2019 - 01:17:07 UTC 35.33317 -119.08736 Bakersfield 2 []
653774 October 11, 2019 - 01:32:00 UTC 35.314 -119.09591 Bakersfield 2 []
653788 October 11, 2019 - 01:45:10 UTC 35.34478 -119.07683 Bakersfield 2 []
653790 October 11, 2019 - 01:45:10 UTC 35.34569 -119.07666 Bakersfield 2 []
653795 October 11, 2019 - 01:45:11 UTC 35.34499 -119.07632 Bakersfield 2 []
653796 October 11, 2019 - 01:48:00 UTC 35.30829 -119.11486 Bakersfield 2 []
653815 October 11, 2019 - 02:00:50 UTC 35.34506 -119.08466 Bakersfield 2 []
653849 October 11, 2019 - 02:32:44 UTC 35.38235 -118.98038 Bakersfield 2 []
653926 October 11, 2019 - 03:44:00 UTC 35.4115 -118.89178 Bakersfield 2 []
654020 October 11, 2019 - 06:29:00 UTC 35.38235 -118.98038 Bakersfield 2 []
654053 October 11, 2019 - 08:05:16 UTC 35.23854 -118.96342 Bakersfield 2 []
654051 October 11, 2019 - 08:05:19 UTC 35.23617 -118.98108 Bakersfield 2 []
654052 October 11, 2019 - 08:05:19 UTC 35.23814 -118.96735 Bakersfield 2 []
654213 October 11, 2019 - 16:01:00 UTC 35.35502 -119.07443 Bakersfield 2 [{"latitude": "35.35459", "longitude": "-119.07635"}, {"latitude": "35.35547", "longitude": "-119.07512"}, {"latitude": "35.35678", "longitude": "-119.0748"}, {"latitude": "35.36165", "longitude": "-119.07439"}, {"latitude": "35.36089", "longitude": "-119.07876"}, {"latitude": "35.35987", "longitude": "-119.08162"}]
654220 October 11, 2019 - 16:03:03 UTC 35.30044 -118.98513 Bakersfield 2 []
654252 October 11, 2019 - 16:20:26 UTC 35.3872 -118.95477 Bakersfield 2 []
654266 October 11, 2019 - 16:41:39 UTC 35.40082 -118.90785 Bakersfield 2 []
654414 October 11, 2019 - 19:10:03 UTC 35.38549 -118.98389 Bakersfield 2 []
654455 October 11, 2019 - 19:49:00 UTC 35.2975 -119.07934 Bakersfield 2 []
654471 October 11, 2019 - 20:08:59 UTC 35.38649 -119.04707 Bakersfield 2 []
654481 October 11, 2019 - 20:23:00 UTC 35.4115 -118.89178 Bakersfield 2 []
654655 October 11, 2019 - 22:38:13 UTC 35.43132 -118.86533 Bakersfield 2 []
654659 October 11, 2019 - 22:40:20 UTC 35.22321 -119.00928 Bakersfield 2 []
654668 October 11, 2019 - 22:47:57 UTC 35.48471 -119.07985 Bakersfield 2 []
654687 October 11, 2019 - 23:18:00 UTC 35.411 -118.89349 Bakersfield 2 []
654860 October 12, 2019 - 01:48:38 UTC 35.35839 -119.01474 Bakersfield 2 []
654997 October 12, 2019 - 09:44:40 UTC 35.50023 -118.90614 Bakersfield 2 []
655125 October 12, 2019 - 16:50:26 UTC 35.6162 -118.98685 Bakersfield 2 []
655159 October 12, 2019 - 17:41:12 UTC 35.38273 -118.95776 Bakersfield 2 []
655232 October 12, 2019 - 19:34:39 UTC 35.37486 -118.99642 Bakersfield 2 [{"latitude": "35.37399", "longitude": "-118.99277"}, {"latitude": "35.37407", "longitude": "-118.99309"}, {"latitude": "35.37415", "longitude": "-118.99342"}, {"latitude": "35.37468", "longitude": "-118.99566"}, {"latitude": "35.37479", "longitude": "-118.99613"}, {"latitude": "35.37448", "longitude": "-118.99483"}]
655247 October 12, 2019 - 20:08:37 UTC 35.35346 -119.0257 Bakersfield 2 []
655257 October 12, 2019 - 20:26:41 UTC 35.37865 -119.02943 Bakersfield 2 []
655331 October 12, 2019 - 22:28:44 UTC 35.40588 -118.93014 Bakersfield 2 []
655357 October 12, 2019 - 23:24:24 UTC 35.29762 -119.12877 Bakersfield 2 []
655385 October 13, 2019 - 00:35:00 UTC 35.29624 -119.02076 Bakersfield 2 []
655388 October 13, 2019 - 00:56:48 UTC 35.29484 -119.02062 Bakersfield 2 []
655406 October 13, 2019 - 01:49:00 UTC 35.30115 -119.01637 Bakersfield 2 []
655407 October 13, 2019 - 01:50:00 UTC 35.29315 -119.00918 Bakersfield 2 []
655408 October 13, 2019 - 01:50:00 UTC 35.30306 -119.00757 Bakersfield 2 []
655409 October 13, 2019 - 01:51:00 UTC 35.30395 -119.01569 Bakersfield 2 []
655411 October 13, 2019 - 01:51:00 UTC 35.31077 -119.01277 Bakersfield 2 []
655410 October 13, 2019 - 01:51:27 UTC 35.29703 -119.02174 Bakersfield 2 []
655416 October 13, 2019 - 01:54:00 UTC 35.28947 -118.99613 Bakersfield 2 []
655413 October 13, 2019 - 01:54:07 UTC 35.30997 -119.0063 Bakersfield 2 []
655415 October 13, 2019 - 01:54:35 UTC 35.29393 -119.01115 Bakersfield 2 []
655414 October 13, 2019 - 01:54:39 UTC 35.30638 -119.01253 Bakersfield 2 []
655545 October 13, 2019 - 16:28:09 UTC 35.32378 -119.18194 Bakersfield 2 []
655547 October 13, 2019 - 16:58:47 UTC 35.32055 -119.19759 Bakersfield 2 []
655575 October 13, 2019 - 18:19:00 UTC 35.37841 -118.99282 Bakersfield 2 []
655584 October 13, 2019 - 18:43:20 UTC 35.17925 -118.96843 Bakersfield 2 []
655608 October 13, 2019 - 20:22:00 UTC 35.3565 -119.02629 Bakersfield 2 []

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 32.169ms · About: About this site