286 rows where regionName = 73

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633614 October 01, 2019 - 15:07:00 UTC 36.2548 -119.69212 Hanford 73 [{"latitude": "36.25358", "longitude": "-119.69094"}, {"latitude": "36.25474", "longitude": "-119.68388"}, {"latitude": "36.25476", "longitude": "-119.68508"}, {"latitude": "36.25481", "longitude": "-119.69108"}]
633794 October 01, 2019 - 16:04:00 UTC 36.39417 -119.53801 Hanford 73 []
634613 October 01, 2019 - 20:06:37 UTC 36.38594 -119.65496 Hanford 73 []
635754 October 02, 2019 - 14:59:00 UTC 36.28404 -119.59789 Hanford 73 [{"latitude": "36.28399", "longitude": "-119.58605"}, {"latitude": "36.284", "longitude": "-119.58741"}, {"latitude": "36.28401", "longitude": "-119.59184"}]
645934 October 07, 2019 - 16:20:28 UTC 36.16751 -119.64621 Hanford 73 []
647679 October 09, 2019 - 00:48:00 UTC 36.43349 -119.60195 Hanford 73 []
650757 October 09, 2019 - 15:44:34 UTC 36.25295 -119.56834 Hanford 73 []
655883 October 14, 2019 - 15:38:57 UTC 36.38944 -119.69102 Hanford 73 []
667733 October 18, 2019 - 15:22:00 UTC 36.26926 -119.64971 Hanford 73 []
669113 October 18, 2019 - 18:40:54 UTC 36.19248 -119.70862 Hanford 73 []
676876 October 22, 2019 - 18:25:18 UTC 36.21351 -119.61225 Hanford 73 []
677527 October 23, 2019 - 17:17:05 UTC 36.27127 -119.70655 Hanford 73 []
679824 October 24, 2019 - 22:12:55 UTC 36.18913 -119.70858 Hanford 73 []
680234 October 25, 2019 - 15:05:10 UTC 36.26948 -119.59994 Hanford 73 []
680394 October 25, 2019 - 17:49:00 UTC 36.22638 -119.65592 Hanford 73 [{"latitude": "36.14424", "longitude": "-119.64605"}, {"latitude": "36.17503", "longitude": "-119.61375"}, {"latitude": "36.2185", "longitude": "-119.61993"}, {"latitude": "36.22007", "longitude": "-119.62084"}, {"latitude": "36.22251", "longitude": "-119.62786"}, {"latitude": "36.22424", "longitude": "-119.63695"}, {"latitude": "36.22533", "longitude": "-119.6559"}, {"latitude": "36.2237", "longitude": "-119.7077"}, {"latitude": "36.22002", "longitude": "-119.71321"}, {"latitude": "36.21096", "longitude": "-119.72616"}, {"latitude": "36.19296", "longitude": "-119.72637"}, {"latitude": "36.17427", "longitude": "-119.71762"}, {"latitude": "36.16704", "longitude": "-119.71002"}]
680405 October 25, 2019 - 18:08:00 UTC 36.20196 -119.63662 Hanford 73 []
680716 October 26, 2019 - 06:50:54 UTC 36.19248 -119.70862 Hanford 73 []
680717 October 26, 2019 - 06:50:57 UTC 36.19679 -119.6861 Hanford 73 []
680718 October 26, 2019 - 06:50:58 UTC 36.16672 -119.68962 Hanford 73 []
680719 October 26, 2019 - 06:50:55 UTC 36.20266 -119.72489 Hanford 73 []
680720 October 26, 2019 - 06:51:49 UTC 36.21011 -119.70417 Hanford 73 []
680755 October 26, 2019 - 14:56:00 UTC 36.26948 -119.59994 Hanford 73 []
693749 October 29, 2019 - 17:35:14 UTC 36.25519 -119.69396 Hanford 73 []
694228 October 29, 2019 - 21:58:36 UTC 36.35927 -119.72899 Hanford 73 []
694229 October 29, 2019 - 21:58:36 UTC 36.37175 -119.7329 Hanford 73 []
696340 October 31, 2019 - 13:59:00 UTC 36.26948 -119.59994 Hanford 73 []
697869 November 01, 2019 - 22:50:21 UTC 36.40211 -119.73154 Hanford 73 []
699798 November 05, 2019 - 16:02:40 UTC 36.35296 -119.74647 Hanford 73 []
702186 November 08, 2019 - 00:29:15 UTC 36.23499 -119.57422 Hanford 73 []
702191 November 08, 2019 - 00:45:00 UTC 36.2362 -119.57282 Hanford 73 []
702304 November 08, 2019 - 12:24:23 UTC 36.2113 -119.6098 Hanford 73 []
702305 November 08, 2019 - 12:24:00 UTC 36.28051 -119.67258 Hanford 73 []
702310 November 08, 2019 - 12:24:00 UTC 36.26923 -119.67359 Hanford 73 []
702311 November 08, 2019 - 12:25:00 UTC 36.28386 -119.68205 Hanford 73 []
702317 November 08, 2019 - 12:25:42 UTC 36.21011 -119.70417 Hanford 73 []
702318 November 08, 2019 - 12:25:42 UTC 36.21125 -119.69132 Hanford 73 []
702319 November 08, 2019 - 12:25:42 UTC 36.16672 -119.68962 Hanford 73 []
702320 November 08, 2019 - 12:24:59 UTC 36.26781 -119.70458 Hanford 73 []
702321 November 08, 2019 - 12:25:42 UTC 36.26415 -119.68404 Hanford 73 []
702322 November 08, 2019 - 12:25:00 UTC 36.27299 -119.61876 Hanford 73 []
702327 November 08, 2019 - 12:28:00 UTC 36.21037 -119.58268 Hanford 73 [{"latitude": "36.20384", "longitude": "-119.58982"}, {"latitude": "36.20392", "longitude": "-119.58338"}, {"latitude": "36.20393", "longitude": "-119.58303"}, {"latitude": "36.21099", "longitude": "-119.56893"}, {"latitude": "36.21316", "longitude": "-119.57751"}, {"latitude": "36.21315", "longitude": "-119.57832"}]
702330 November 08, 2019 - 12:28:33 UTC 36.21511 -119.6369 Hanford 73 []
702331 November 08, 2019 - 12:29:01 UTC 36.2386 -119.57422 Hanford 73 [{"latitude": "36.22951", "longitude": "-119.57417"}, {"latitude": "36.23689", "longitude": "-119.5726"}, {"latitude": "36.23688", "longitude": "-119.57396"}, {"latitude": "36.23499", "longitude": "-119.57422"}, {"latitude": "36.23264", "longitude": "-119.5742"}]
702333 November 08, 2019 - 12:29:00 UTC 36.22339 -119.58312 Hanford 73 []
702334 November 08, 2019 - 12:29:00 UTC 36.21141 -119.63541 Hanford 73 []
702335 November 08, 2019 - 12:35:25 UTC 36.23958 -119.57406 Hanford 73 []
702336 November 08, 2019 - 12:36:00 UTC 36.27548 -119.61878 Hanford 73 []
702339 November 08, 2019 - 12:45:00 UTC 36.22388 -119.62906 Hanford 73 []
702340 November 08, 2019 - 12:45:29 UTC 36.18 -119.60089 Hanford 73 [{"latitude": "36.16027", "longitude": "-119.60104"}, {"latitude": "36.16759", "longitude": "-119.59829"}, {"latitude": "36.17791", "longitude": "-119.59974"}, {"latitude": "36.17526", "longitude": "-119.60089"}, {"latitude": "36.16893", "longitude": "-119.60282"}, {"latitude": "36.1684", "longitude": "-119.60294"}]
702342 November 08, 2019 - 12:48:00 UTC 36.21351 -119.61225 Hanford 73 []
702343 November 08, 2019 - 12:49:00 UTC 36.22583 -119.60953 Hanford 73 []
702344 November 08, 2019 - 12:51:00 UTC 36.28315 -119.61885 Hanford 73 []
702346 November 08, 2019 - 12:54:00 UTC 36.20196 -119.63662 Hanford 73 []
702347 November 08, 2019 - 12:56:00 UTC 36.21087 -119.62778 Hanford 73 []
702348 November 08, 2019 - 13:03:00 UTC 36.26942 -119.61084 Hanford 73 []
702429 November 08, 2019 - 15:38:00 UTC 36.26948 -119.59994 Hanford 73 []
702542 November 08, 2019 - 16:39:14 UTC 36.43806 -119.54923 Hanford 73 []
702603 November 08, 2019 - 17:12:16 UTC 36.40691 -119.56383 Hanford 73 []
702788 November 08, 2019 - 17:12:00 UTC 36.40167 -119.55001 Hanford 73 []
705550 November 13, 2019 - 00:58:29 UTC 36.48288 -119.53744 Hanford 73 []
707299 November 15, 2019 - 15:51:00 UTC 36.26948 -119.59994 Hanford 73 []
708066 November 16, 2019 - 13:01:15 UTC 36.25506 -119.56595 Hanford 73 []
708069 November 16, 2019 - 13:14:46 UTC 36.25132 -119.57327 Hanford 73 []
708700 November 17, 2019 - 20:09:08 UTC 36.38995 -119.63718 Hanford 73 []
709772 November 19, 2019 - 13:27:14 UTC 36.41946 -119.56014 Hanford 73 []
713107 November 22, 2019 - 22:59:53 UTC 36.23677 -119.59954 Hanford 73 []
715038 November 26, 2019 - 15:07:02 UTC 36.28406 -119.62815 Hanford 73 []
719767 November 27, 2019 - 11:12:44 UTC 36.28408 -119.63034 Hanford 73 []
719908 November 27, 2019 - 12:59:00 UTC 36.39909 -119.52305 Hanford 73 []
719910 November 27, 2019 - 13:03:00 UTC 36.40134 -119.6173 Hanford 73 [{"latitude": "36.37251", "longitude": "-119.55092"}, {"latitude": "36.37283", "longitude": "-119.53279"}, {"latitude": "36.38826", "longitude": "-119.50108"}, {"latitude": "36.40106", "longitude": "-119.47498"}, {"latitude": "36.4081", "longitude": "-119.46632"}, {"latitude": "36.41457", "longitude": "-119.46432"}, {"latitude": "36.41954", "longitude": "-119.47483"}, {"latitude": "36.41003", "longitude": "-119.58435"}, {"latitude": "36.40235", "longitude": "-119.61096"}, {"latitude": "36.40134", "longitude": "-119.61423"}, {"latitude": "36.39918", "longitude": "-119.6163"}, {"latitude": "36.37379", "longitude": "-119.55857"}]
721258 November 27, 2019 - 18:59:19 UTC 36.39888 -119.5232 Hanford 73 []
722384 November 28, 2019 - 04:50:18 UTC 36.39973 -119.51081 Hanford 73 []
722721 November 28, 2019 - 16:50:00 UTC 36.41625 -119.64746 Hanford 73 []
723860 November 30, 2019 - 03:06:32 UTC 36.22539 -119.71122 Hanford 73 []
723921 November 30, 2019 - 05:31:00 UTC 36.22007 -119.70901 Hanford 73 []
724265 November 30, 2019 - 21:08:15 UTC 36.434 -119.54697 Hanford 73 []
726008 December 01, 2019 - 19:39:46 UTC 36.22539 -119.71122 Hanford 73 []
726405 December 02, 2019 - 00:52:43 UTC 36.27921 -119.61882 Hanford 73 []
727104 December 02, 2019 - 15:28:51 UTC 36.27672 -119.58269 Hanford 73 []
728455 December 03, 2019 - 16:45:32 UTC 36.19358 -119.6905 Hanford 73 []
729382 December 04, 2019 - 15:33:06 UTC 36.16576 -119.53127 Hanford 73 []
730000 December 04, 2019 - 23:59:33 UTC 36.28386 -119.68205 Hanford 73 []
730242 December 05, 2019 - 14:52:00 UTC 36.22462 -119.60117 Hanford 73 [{"latitude": "36.16027", "longitude": "-119.60104"}, {"latitude": "36.18098", "longitude": "-119.58183"}, {"latitude": "36.21099", "longitude": "-119.56893"}, {"latitude": "36.21821", "longitude": "-119.58323"}, {"latitude": "36.22229", "longitude": "-119.59881"}, {"latitude": "36.22233", "longitude": "-119.60114"}, {"latitude": "36.21397", "longitude": "-119.61901"}, {"latitude": "36.2041", "longitude": "-119.63703"}, {"latitude": "36.19814", "longitude": "-119.64194"}]
732545 December 07, 2019 - 18:47:31 UTC 36.35844 -119.74607 Hanford 73 []
733868 December 08, 2019 - 22:20:05 UTC 36.40228 -119.56023 Hanford 73 []
734888 December 10, 2019 - 00:14:00 UTC 36.28377 -119.67342 Hanford 73 [{"latitude": "36.27984", "longitude": "-119.68337"}, {"latitude": "36.28036", "longitude": "-119.68081"}, {"latitude": "36.28384", "longitude": "-119.67924"}, {"latitude": "36.28385", "longitude": "-119.68046"}, {"latitude": "36.28386", "longitude": "-119.68205"}, {"latitude": "36.28386", "longitude": "-119.68297"}, {"latitude": "36.28377", "longitude": "-119.68632"}]
735839 December 10, 2019 - 23:06:25 UTC 36.27984 -119.68337 Hanford 73 []
736856 December 12, 2019 - 02:20:00 UTC 36.48288 -119.53744 Hanford 73 []
737483 December 12, 2019 - 18:15:57 UTC 36.17007 -119.54192 Hanford 73 []
737701 December 12, 2019 - 21:47:15 UTC 36.15312 -119.5587 Hanford 73 []
743875 December 17, 2019 - 02:30:54 UTC 36.40144 -119.57478 Hanford 73 []
744093 December 17, 2019 - 16:02:09 UTC 36.25485 -119.5867 Hanford 73 []
744165 December 17, 2019 - 16:12:00 UTC 36.19803 -119.63687 Hanford 73 []
778912 February 06, 2020 - 13:31:00 UTC 36.27032 -119.7446 Hanford 73 [{"latitude": "36.272", "longitude": "-119.74431"}, {"latitude": "36.272", "longitude": "-119.74242"}, {"latitude": "36.27877", "longitude": "-119.73688"}, {"latitude": "36.30247", "longitude": "-119.72739"}, {"latitude": "36.30176", "longitude": "-119.75088"}, {"latitude": "36.30163", "longitude": "-119.75382"}, {"latitude": "36.29944", "longitude": "-119.75983"}, {"latitude": "36.29679", "longitude": "-119.75953"}, {"latitude": "36.27515", "longitude": "-119.75002"}]
779153 February 06, 2020 - 17:13:33 UTC 36.44347 -119.5911 Hanford 73 []
779201 February 06, 2020 - 17:58:44 UTC 36.41447 -119.67585 Hanford 73 []
779425 February 06, 2020 - 20:46:18 UTC 36.40976 -119.565 Hanford 73 []
787143 February 10, 2020 - 17:09:39 UTC 36.41289 -119.63992 Hanford 73 []
788780 February 11, 2020 - 20:48:41 UTC 36.24518 -119.58518 Hanford 73 []
789024 February 12, 2020 - 00:12:57 UTC 36.16707 -119.53803 Hanford 73 [{"latitude": "36.16735", "longitude": "-119.53805"}, {"latitude": "36.17429", "longitude": "-119.5381"}, {"latitude": "36.17776", "longitude": "-119.53814"}, {"latitude": "36.17063", "longitude": "-119.54226"}, {"latitude": "36.17007", "longitude": "-119.54192"}]

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