Data source: Big Local News · About: big-local-datasette

306 rows

View and edit SQL

Suggested facets: Year

Link rowid ▼ Year Data Dates State Per_lhd_emgncy_coord
1 2018 2013 & 2016 AK 100.0
2 2017 2013 & 2016 AK 100.0
3 2016 2013 & 2016 AK 100.0
4 2015 2013 & 2016 AK 83.33333333
5 2014 2013 & 2016 AK 83.33333333
6 2013 2013 & 2016 AK 83.33333333
7 2018 2013 & 2016 AL 51.12457
8 2017 2013 & 2016 AL 51.12457
9 2016 2013 & 2016 AL 51.12457
10 2015 2013 & 2016 AL 42.1875
11 2014 2013 & 2016 AL 42.1875
12 2013 2013 & 2016 AL 42.1875
13 2018 2013 & 2016 AR 79.851
14 2017 2013 & 2016 AR 79.851
15 2016 2013 & 2016 AR 79.851
16 2015 2013 & 2016 AR 79.16666667
17 2014 2013 & 2016 AR 79.16666667
18 2013 2013 & 2016 AR 79.16666667
19 2018 2013 & 2016 AZ 93.66349
20 2017 2013 & 2016 AZ 93.66349
21 2016 2013 & 2016 AZ 93.66349
22 2015 2013 & 2016 AZ 100.0
23 2014 2013 & 2016 AZ 100.0
24 2013 2013 & 2016 AZ 100.0
25 2018 2013 & 2016 CA 94.76375
26 2017 2013 & 2016 CA 94.76375
27 2016 2013 & 2016 CA 94.76375
28 2015 2013 & 2016 CA 97.61904762
29 2014 2013 & 2016 CA 97.61904762
30 2013 2013 & 2016 CA 97.61904762
31 2018 2013 & 2016 CO 90.95326999999999
32 2017 2013 & 2016 CO 90.95326999999999
33 2016 2013 & 2016 CO 90.95326999999999
34 2015 2013 & 2016 CO 91.66666667
35 2014 2013 & 2016 CO 91.66666667
36 2013 2013 & 2016 CO 91.66666667
37 2018 2013 & 2016 CT 85.90411
38 2017 2013 & 2016 CT 85.90411
39 2016 2013 & 2016 CT 85.90411
40 2015 2013 & 2016 CT 79.59183673
41 2014 2013 & 2016 CT 79.59183673
42 2013 2013 & 2016 CT 79.59183673
43 2018 2013 & 2016 DC 100.0
44 2017 2013 & 2016 DC 100.0
45 2016 2013 & 2016 DC 100.0
46 2015 2013 & 2016 DC 100.0
47 2014 2013 & 2016 DC 100.0
48 2013 2013 & 2016 DC 100.0
49 2018 2013 & 2016 DE 50.868359999999996
50 2017 2013 & 2016 DE 50.868359999999996
51 2016 2013 & 2016 DE 50.868359999999996
52 2015 2013 & 2016 DE 50.0
53 2014 2013 & 2016 DE 50.0
54 2013 2013 & 2016 DE 50.0
55 2018 2013 & 2016 FL 100.0
56 2017 2013 & 2016 FL 100.0
57 2016 2013 & 2016 FL 100.0
58 2015 2013 & 2016 FL 98.50746269
59 2014 2013 & 2016 FL 98.50746269
60 2013 2013 & 2016 FL 98.50746269
61 2018 2013 & 2016 GA 100.0
62 2017 2013 & 2016 GA 100.0
63 2016 2013 & 2016 GA 100.0
64 2015 2013 & 2016 GA 91.66666667
65 2014 2013 & 2016 GA 91.66666667
66 2013 2013 & 2016 GA 91.66666667
67 2018 2013 & 2016 HI  
68 2017 2013 & 2016 HI  
69 2016 2013 & 2016 HI  
70 2015 2013 & 2016 HI  
71 2014 2013 & 2016 HI  
72 2013 2013 & 2016 HI  
73 2018 2013 & 2016 IA 79.77344000000001
74 2017 2013 & 2016 IA 79.77344000000001
75 2016 2013 & 2016 IA 79.77344000000001
76 2015 2013 & 2016 IA 82.35294118
77 2014 2013 & 2016 IA 82.35294118
78 2013 2013 & 2016 IA 82.35294118
79 2018 2013 & 2016 ID 100.0
80 2017 2013 & 2016 ID 100.0
81 2016 2013 & 2016 ID 100.0
82 2015 2013 & 2016 ID 100.0
83 2014 2013 & 2016 ID 100.0
84 2013 2013 & 2016 ID 100.0
85 2018 2013 & 2016 IL 88.15484000000001
86 2017 2013 & 2016 IL 88.15484000000001
87 2016 2013 & 2016 IL 88.15484000000001
88 2015 2013 & 2016 IL 88.23529412
89 2014 2013 & 2016 IL 88.23529412
90 2013 2013 & 2016 IL 88.23529412
91 2018 2013 & 2016 IN 86.25239
92 2017 2013 & 2016 IN 86.25239
93 2016 2013 & 2016 IN 86.25239
94 2015 2013 & 2016 IN 87.27272727
95 2014 2013 & 2016 IN 87.27272727
96 2013 2013 & 2016 IN 87.27272727
97 2018 2013 & 2016 KS 82.23441
98 2017 2013 & 2016 KS 82.23441
99 2016 2013 & 2016 KS 82.23441
100 2015 2013 & 2016 KS 82.27848101

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [M107_per_lhd_emgncy_coord] (
   [Year] INTEGER,
   [Data Dates] TEXT,
   [State] TEXT,
   [Per_lhd_emgncy_coord] TEXT
);