176 rows where regionName = 31

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633394 September 30, 2019 - 23:59:30 UTC 36.45004 -121.35438 Soledad 31 []
638663 October 02, 2019 - 23:15:21 UTC 36.37679 -121.3851 Soledad 31 []
643698 October 04, 2019 - 20:49:01 UTC 36.3517 -121.29323 Soledad 31 []
644435 October 05, 2019 - 16:59:42 UTC 36.4708 -121.39405 Soledad 31 [{"latitude": "36.47798", "longitude": "-121.38256"}, {"latitude": "36.50081", "longitude": "-121.35189"}, {"latitude": "36.4969", "longitude": "-121.36893"}, {"latitude": "36.47911", "longitude": "-121.38421"}]
646925 October 07, 2019 - 23:44:29 UTC 36.42426 -121.32138 Soledad 31 []
647516 October 08, 2019 - 20:22:10 UTC 36.32728 -121.29875 Soledad 31 []
650651 October 09, 2019 - 14:25:31 UTC 36.44493 -121.31089 Soledad 31 [{"latitude": "36.4449", "longitude": "-121.29956"}, {"latitude": "36.44533", "longitude": "-121.29786"}, {"latitude": "36.45002", "longitude": "-121.29671"}, {"latitude": "36.45645", "longitude": "-121.29872"}, {"latitude": "36.44492", "longitude": "-121.30761"}]
650786 October 09, 2019 - 16:13:49 UTC 36.41304 -121.38073 Soledad 31 []
651107 October 09, 2019 - 20:56:29 UTC 36.41304 -121.38073 Soledad 31 []
654756 October 11, 2019 - 23:52:45 UTC 36.41304 -121.38073 Soledad 31 []
655347 October 12, 2019 - 22:57:00 UTC 36.44295 -121.32109 Soledad 31 []
673173 October 19, 2019 - 19:40:50 UTC 36.39285 -121.30522 Soledad 31 []
673193 October 19, 2019 - 19:45:41 UTC 36.41302 -121.31494 Soledad 31 []
677045 October 22, 2019 - 22:05:24 UTC 36.36044 -121.25602 Soledad 31 []
677663 October 23, 2019 - 19:49:50 UTC 36.39285 -121.30522 Soledad 31 []
679601 October 24, 2019 - 18:00:32 UTC 36.37888 -121.26645 Soledad 31 []
680821 October 26, 2019 - 17:13:42 UTC 36.46989 -121.46705 Soledad 31 []
684965 October 27, 2019 - 05:26:14 UTC 36.47254 -121.4717 Soledad 31 []
685145 October 27, 2019 - 05:39:00 UTC 36.44224 -121.32527 Soledad 31 [{"latitude": "36.43764", "longitude": "-121.32276"}, {"latitude": "36.4388", "longitude": "-121.31927"}, {"latitude": "36.44095", "longitude": "-121.31898"}, {"latitude": "36.44179", "longitude": "-121.31915"}, {"latitude": "36.44434", "longitude": "-121.32133"}, {"latitude": "36.44487", "longitude": "-121.32248"}, {"latitude": "36.44246", "longitude": "-121.32682"}, {"latitude": "36.44115", "longitude": "-121.32805"}, {"latitude": "36.44049", "longitude": "-121.32804"}, {"latitude": "36.43956", "longitude": "-121.32671"}]
685297 October 27, 2019 - 05:49:10 UTC 36.44252 -121.32511 Soledad 31 [{"latitude": "36.44272", "longitude": "-121.32773"}, {"latitude": "36.44292", "longitude": "-121.32593"}, {"latitude": "36.44393", "longitude": "-121.32242"}, {"latitude": "36.4441", "longitude": "-121.3265"}, {"latitude": "36.44405", "longitude": "-121.33012"}]
685320 October 27, 2019 - 05:58:55 UTC 36.42894 -121.32962 Soledad 31 [{"latitude": "36.41909", "longitude": "-121.31392"}, {"latitude": "36.41921", "longitude": "-121.31219"}, {"latitude": "36.42206", "longitude": "-121.31194"}, {"latitude": "36.42468", "longitude": "-121.31284"}, {"latitude": "36.42556", "longitude": "-121.31348"}, {"latitude": "36.42641", "longitude": "-121.31563"}, {"latitude": "36.42894", "longitude": "-121.32882"}, {"latitude": "36.42797", "longitude": "-121.32978"}, {"latitude": "36.42717", "longitude": "-121.32882"}, {"latitude": "36.4217", "longitude": "-121.3211"}]
685324 October 27, 2019 - 05:58:55 UTC 36.4308 -121.31331 Soledad 31 []
685370 October 27, 2019 - 05:58:57 UTC 36.46447 -121.3878 Soledad 31 []
685371 October 27, 2019 - 05:58:57 UTC 36.4365 -121.43674 Soledad 31 []
685372 October 27, 2019 - 05:58:57 UTC 36.45379 -121.47471 Soledad 31 []
685373 October 27, 2019 - 05:58:57 UTC 36.42838 -121.33121 Soledad 31 [{"latitude": "36.42173", "longitude": "-121.32308"}, {"latitude": "36.42298", "longitude": "-121.32352"}, {"latitude": "36.4259", "longitude": "-121.32614"}, {"latitude": "36.42861", "longitude": "-121.33069"}, {"latitude": "36.42764", "longitude": "-121.33061"}]
685376 October 27, 2019 - 05:58:57 UTC 36.48294 -121.39346 Soledad 31 []
685378 October 27, 2019 - 05:58:58 UTC 36.4537 -121.29835 Soledad 31 []
685379 October 27, 2019 - 05:58:58 UTC 36.4379 -121.31301 Soledad 31 []
685380 October 27, 2019 - 05:58:58 UTC 36.42533 -121.30752 Soledad 31 [{"latitude": "36.35743", "longitude": "-121.22506"}, {"latitude": "36.46341", "longitude": "-121.2194"}, {"latitude": "36.47094", "longitude": "-121.22886"}, {"latitude": "36.47574", "longitude": "-121.23984"}, {"latitude": "36.48271", "longitude": "-121.25893"}, {"latitude": "36.44542", "longitude": "-121.29414"}, {"latitude": "36.42788", "longitude": "-121.30919"}, {"latitude": "36.42174", "longitude": "-121.30607"}, {"latitude": "36.41734", "longitude": "-121.30373"}, {"latitude": "36.41098", "longitude": "-121.29949"}, {"latitude": "36.36101", "longitude": "-121.23006"}]
685381 October 27, 2019 - 05:58:58 UTC 36.44132 -121.3171 Soledad 31 [{"latitude": "36.44061", "longitude": "-121.3163"}, {"latitude": "36.44487", "longitude": "-121.31794"}, {"latitude": "36.44323", "longitude": "-121.31859"}, {"latitude": "36.4425", "longitude": "-121.31872"}]
685382 October 27, 2019 - 05:58:57 UTC 36.43253 -121.32627 Soledad 31 []
685383 October 27, 2019 - 05:58:58 UTC 36.41811 -121.32188 Soledad 31 []
685384 October 27, 2019 - 05:58:58 UTC 36.37686 -121.32323 Soledad 31 []
685385 October 27, 2019 - 05:58:58 UTC 36.36013 -121.31408 Soledad 31 []
685386 October 27, 2019 - 05:58:58 UTC 36.368 -121.3209 Soledad 31 []
685387 October 27, 2019 - 05:58:57 UTC 36.42664 -121.40273 Soledad 31 []
685388 October 27, 2019 - 05:58:57 UTC 36.38387 -121.42846 Soledad 31 []
685406 October 27, 2019 - 06:05:00 UTC 36.43362 -121.31296 Soledad 31 []
685632 October 27, 2019 - 05:20:00 UTC 36.46802 -121.39007 Soledad 31 []
685644 October 27, 2019 - 05:20:00 UTC 36.46554 -121.38372 Soledad 31 []
685646 October 27, 2019 - 05:20:00 UTC 36.46718 -121.39128 Soledad 31 [{"latitude": "36.43755", "longitude": "-121.37054"}, {"latitude": "36.44265", "longitude": "-121.36804"}, {"latitude": "36.45288", "longitude": "-121.36921"}, {"latitude": "36.49557", "longitude": "-121.43182"}, {"latitude": "36.49032", "longitude": "-121.44466"}, {"latitude": "36.4879", "longitude": "-121.44716"}, {"latitude": "36.48199", "longitude": "-121.44451"}, {"latitude": "36.45598", "longitude": "-121.41867"}, {"latitude": "36.43783", "longitude": "-121.37755"}]
686171 October 27, 2019 - 05:20:00 UTC 36.42966 -121.33251 Soledad 31 [{"latitude": "36.41909", "longitude": "-121.31392"}, {"latitude": "36.41921", "longitude": "-121.31219"}, {"latitude": "36.42206", "longitude": "-121.31194"}, {"latitude": "36.45771", "longitude": "-121.31976"}, {"latitude": "36.46901", "longitude": "-121.32982"}, {"latitude": "36.47016", "longitude": "-121.33745"}, {"latitude": "36.45092", "longitude": "-121.36661"}, {"latitude": "36.43497", "longitude": "-121.36575"}, {"latitude": "36.42741", "longitude": "-121.3636"}]
686181 October 27, 2019 - 05:58:55 UTC 36.42974 -121.33239 Soledad 31 [{"latitude": "36.43084", "longitude": "-121.33416"}, {"latitude": "36.43125", "longitude": "-121.3313"}, {"latitude": "36.43467", "longitude": "-121.33109"}, {"latitude": "36.51684", "longitude": "-121.34428"}, {"latitude": "36.52103", "longitude": "-121.36909"}, {"latitude": "36.52629", "longitude": "-121.41782"}, {"latitude": "36.50526", "longitude": "-121.4386"}, {"latitude": "36.50124", "longitude": "-121.43722"}, {"latitude": "36.49939", "longitude": "-121.43631"}, {"latitude": "36.44706", "longitude": "-121.3903"}]
686185 October 27, 2019 - 05:58:55 UTC 36.42974 -121.33242 Soledad 31 [{"latitude": "36.35192", "longitude": "-121.3162"}, {"latitude": "36.35743", "longitude": "-121.22506"}, {"latitude": "36.46341", "longitude": "-121.2194"}, {"latitude": "36.47094", "longitude": "-121.22886"}, {"latitude": "36.47574", "longitude": "-121.23984"}, {"latitude": "36.48271", "longitude": "-121.25893"}, {"latitude": "36.43307", "longitude": "-121.40114"}, {"latitude": "36.43206", "longitude": "-121.4038"}, {"latitude": "36.42871", "longitude": "-121.40652"}, {"latitude": "36.39213", "longitude": "-121.42993"}, {"latitude": "36.38387", "longitude": "-121.42846"}, {"latitude": "36.35641", "longitude": "-121.35993"}]
691901 October 28, 2019 - 20:20:57 UTC 36.43147 -121.32001 Soledad 31 []
691907 October 28, 2019 - 20:22:23 UTC 36.43467 -121.33109 Soledad 31 []
692000 October 28, 2019 - 21:08:23 UTC 36.4379 -121.31301 Soledad 31 []
692001 October 28, 2019 - 21:08:45 UTC 36.42231 -121.32562 Soledad 31 []
692418 October 29, 2019 - 00:32:57 UTC 36.43217 -121.32085 Soledad 31 []
696517 October 31, 2019 - 16:35:02 UTC 36.46989 -121.46705 Soledad 31 []
697109 November 01, 2019 - 01:23:57 UTC 36.42407 -121.32026 Soledad 31 []
698002 November 02, 2019 - 02:38:12 UTC 36.50341 -121.50666 Soledad 31 []
698104 November 02, 2019 - 15:16:25 UTC 36.46236 -121.383 Soledad 31 [{"latitude": "36.46393", "longitude": "-121.38264"}, {"latitude": "36.4673", "longitude": "-121.39065"}, {"latitude": "36.46657", "longitude": "-121.38949"}]
699149 November 04, 2019 - 17:52:43 UTC 36.39465 -121.27573 Soledad 31 []
699717 November 05, 2019 - 08:48:41 UTC 36.4223 -121.32487 Soledad 31 []
704381 November 11, 2019 - 17:46:00 UTC 36.32493 -121.29588 Soledad 31 [{"latitude": "36.32701", "longitude": "-121.2997"}, {"latitude": "36.32728", "longitude": "-121.29875"}, {"latitude": "36.33707", "longitude": "-121.28252"}, {"latitude": "36.33389", "longitude": "-121.30174"}]
704678 November 12, 2019 - 14:25:19 UTC 36.42114 -121.31698 Soledad 31 []
704709 November 12, 2019 - 15:48:00 UTC 36.44745 -121.31042 Soledad 31 []
705052 November 12, 2019 - 19:31:49 UTC 36.42114 -121.31698 Soledad 31 []
706008 November 13, 2019 - 17:47:02 UTC 36.32728 -121.29875 Soledad 31 []
706456 November 14, 2019 - 03:03:00 UTC 36.35189 -121.26898 Soledad 31 [{"latitude": "36.33514", "longitude": "-121.2745"}, {"latitude": "36.33528", "longitude": "-121.27419"}, {"latitude": "36.34097", "longitude": "-121.27147"}, {"latitude": "36.35161", "longitude": "-121.26949"}, {"latitude": "36.34772", "longitude": "-121.27896"}, {"latitude": "36.34178", "longitude": "-121.28142"}]
706457 November 14, 2019 - 03:04:00 UTC 36.32574 -121.3104 Soledad 31 []
706460 November 14, 2019 - 03:04:58 UTC 36.33583 -121.35399 Soledad 31 []
706552 November 14, 2019 - 15:46:55 UTC 36.43118 -121.32837 Soledad 31 [{"latitude": "36.43212", "longitude": "-121.32599"}, {"latitude": "36.43251", "longitude": "-121.32537"}, {"latitude": "36.43477", "longitude": "-121.3247"}, {"latitude": "36.43518", "longitude": "-121.32543"}, {"latitude": "36.43253", "longitude": "-121.32627"}]
707186 November 15, 2019 - 05:50:00 UTC 36.43519 -121.32426 Soledad 31 [{"latitude": "36.4338", "longitude": "-121.32499"}, {"latitude": "36.43477", "longitude": "-121.3247"}, {"latitude": "36.43518", "longitude": "-121.32543"}]
707194 November 15, 2019 - 06:10:44 UTC 36.43118 -121.32837 Soledad 31 []
707858 November 15, 2019 - 22:53:25 UTC 36.40611 -121.37002 Soledad 31 [{"latitude": "36.38569", "longitude": "-121.38742"}, {"latitude": "36.40148", "longitude": "-121.3708"}, {"latitude": "36.40314", "longitude": "-121.37114"}, {"latitude": "36.40355", "longitude": "-121.3716"}, {"latitude": "36.39753", "longitude": "-121.3825"}, {"latitude": "36.39345", "longitude": "-121.38436"}]
708878 November 18, 2019 - 10:51:00 UTC 36.48724 -121.50802 Soledad 31 []
709420 November 18, 2019 - 21:21:57 UTC 36.32708 -121.30451 Soledad 31 []
709846 November 19, 2019 - 16:17:20 UTC 36.42969 -121.33387 Soledad 31 []
710055 November 19, 2019 - 18:15:00 UTC 36.44033 -121.31987 Soledad 31 []
710892 November 20, 2019 - 16:01:05 UTC 36.33389 -121.30174 Soledad 31 []
712344 November 21, 2019 - 20:49:01 UTC 36.37938 -121.33988 Soledad 31 [{"latitude": "36.35641", "longitude": "-121.35993"}, {"latitude": "36.36824", "longitude": "-121.34284"}, {"latitude": "36.37187", "longitude": "-121.33799"}, {"latitude": "36.37641", "longitude": "-121.33697"}, {"latitude": "36.37881", "longitude": "-121.34011"}, {"latitude": "36.38026", "longitude": "-121.34307"}, {"latitude": "36.38106", "longitude": "-121.34883"}, {"latitude": "36.3631", "longitude": "-121.35955"}]
713038 November 22, 2019 - 21:32:50 UTC 36.42675 -121.32758 Soledad 31 []
713151 November 23, 2019 - 00:12:23 UTC 36.39972 -121.34674 Soledad 31 []
714212 November 25, 2019 - 17:11:33 UTC 36.4365 -121.43674 Soledad 31 []
714613 November 25, 2019 - 21:57:56 UTC 36.37187 -121.33799 Soledad 31 []
714614 November 25, 2019 - 21:57:55 UTC 36.3631 -121.35955 Soledad 31 []
714618 November 25, 2019 - 22:02:00 UTC 36.37898 -121.34299 Soledad 31 []
714689 November 25, 2019 - 23:00:46 UTC 36.39729 -121.33769 Soledad 31 [{"latitude": "36.3657", "longitude": "-121.36284"}, {"latitude": "36.36768", "longitude": "-121.35868"}, {"latitude": "36.36967", "longitude": "-121.35474"}, {"latitude": "36.38717", "longitude": "-121.33741"}, {"latitude": "36.39634", "longitude": "-121.33832"}, {"latitude": "36.39488", "longitude": "-121.34506"}, {"latitude": "36.38361", "longitude": "-121.35251"}]
714874 November 26, 2019 - 02:47:43 UTC 36.41128 -121.3559 Soledad 31 []
715997 November 26, 2019 - 23:14:28 UTC 36.40496 -121.37479 Soledad 31 []
719661 November 27, 2019 - 09:34:23 UTC 36.4484 -121.29799 Soledad 31 []
720734 November 27, 2019 - 17:01:08 UTC 36.4484 -121.29799 Soledad 31 []
722718 November 28, 2019 - 16:48:18 UTC 36.34077 -121.27219 Soledad 31 []
722776 November 28, 2019 - 17:28:00 UTC 36.34714 -121.27843 Soledad 31 []
722809 November 28, 2019 - 18:03:20 UTC 36.42959 -121.32571 Soledad 31 []
722888 November 28, 2019 - 19:20:18 UTC 36.42959 -121.32571 Soledad 31 []
723126 November 28, 2019 - 22:49:24 UTC 36.45947 -121.3775 Soledad 31 [{"latitude": "36.46447", "longitude": "-121.3421"}, {"latitude": "36.48686", "longitude": "-121.34791"}, {"latitude": "36.48196", "longitude": "-121.36751"}, {"latitude": "36.46793", "longitude": "-121.37298"}, {"latitude": "36.46481", "longitude": "-121.3671"}]
723448 November 29, 2019 - 17:32:01 UTC 36.42588 -121.38921 Soledad 31 []
726145 December 01, 2019 - 21:41:06 UTC 36.42607 -121.32497 Soledad 31 [{"latitude": "36.42634", "longitude": "-121.3247"}, {"latitude": "36.42774", "longitude": "-121.3233"}, {"latitude": "36.42723", "longitude": "-121.32382"}]
727378 December 02, 2019 - 18:22:25 UTC 36.34772 -121.27896 Soledad 31 []
728444 December 03, 2019 - 16:42:27 UTC 36.41288 -121.31891 Soledad 31 []
728446 December 03, 2019 - 16:43:41 UTC 36.42121 -121.31765 Soledad 31 []
729023 December 03, 2019 - 23:51:01 UTC 36.41288 -121.31891 Soledad 31 []
729914 December 04, 2019 - 22:27:00 UTC 36.46802 -121.39007 Soledad 31 []
730010 December 05, 2019 - 00:14:56 UTC 36.47384 -121.37519 Soledad 31 []
731937 December 07, 2019 - 03:12:34 UTC 36.43206 -121.4038 Soledad 31 []
734761 December 09, 2019 - 21:44:58 UTC 36.4365 -121.43674 Soledad 31 []

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