Data provided by Big Local News. Data from the National Health Security Preparedness Index. The overall index is useful for examining a state’s readiness in dealing with any number of issues. There also are specific metrics that directly relate to states’ abilities to respond to the Coronavirus pandemic. With that in mind, we have pulled out and processed key metrics -- from preparedness for surge testing to evaluating how many people in each state have access to paid time off. Our goal is to make it easier for journalists to access and analyze for their reporting. For more information, please start with the NHSPI_READ_ME file. Questions? Contact biglocalnews@stanford.edu.

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

306 rows sorted by Year

View and edit SQL

Suggested facets: Year

Link rowid Year ▼ Data Dates State Per_lhd_emgncy_coord
6 2013 2013 & 2016 AK 83.33333333
12 2013 2013 & 2016 AL 42.1875
18 2013 2013 & 2016 AR 79.16666667
24 2013 2013 & 2016 AZ 100.0
30 2013 2013 & 2016 CA 97.61904762
36 2013 2013 & 2016 CO 91.66666667
42 2013 2013 & 2016 CT 79.59183673
48 2013 2013 & 2016 DC 100.0
54 2013 2013 & 2016 DE 50.0
60 2013 2013 & 2016 FL 98.50746269
66 2013 2013 & 2016 GA 91.66666667
72 2013 2013 & 2016 HI  
78 2013 2013 & 2016 IA 82.35294118
84 2013 2013 & 2016 ID 100.0
90 2013 2013 & 2016 IL 88.23529412
96 2013 2013 & 2016 IN 87.27272727
102 2013 2013 & 2016 KS 82.27848101
108 2013 2013 & 2016 KY 98.03921569
114 2013 2013 & 2016 LA 88.88888889
120 2013 2013 & 2016 MA 74.01574803
126 2013 2013 & 2016 MD 100.0
132 2013 2013 & 2016 ME 100.0
138 2013 2013 & 2016 MI 100.0
144 2013 2013 & 2016 MN 98.33333333
150 2013 2013 & 2016 MO 92.47311828
156 2013 2013 & 2016 MS 88.88888889
162 2013 2013 & 2016 MT 97.22222222
168 2013 2013 & 2016 NC 96.05263158
174 2013 2013 & 2016 ND 66.66666667
180 2013 2013 & 2016 NE 100.0
186 2013 2013 & 2016 NH 100.0
192 2013 2013 & 2016 NJ 62.96296296
198 2013 2013 & 2016 NM 100.0
204 2013 2013 & 2016 NV 100.0
210 2013 2013 & 2016 NY 93.47826087
216 2013 2013 & 2016 OH 97.72727273
222 2013 2013 & 2016 OK 100.0
228 2013 2013 & 2016 OR 100.0
234 2013 2013 & 2016 PA 100.0
240 2013 2013 & 2016 RI  
246 2013 2013 & 2016 SC 100.0
252 2013 2013 & 2016 SD 25.0
258 2013 2013 & 2016 TN 71.73913043
264 2013 2013 & 2016 TX 79.54545455
270 2013 2013 & 2016 UT 100.0
276 2013 2013 & 2016 VA 100.0
282 2013 2013 & 2016 VT 100.0
288 2013 2013 & 2016 WA 100.0
294 2013 2013 & 2016 WI 68.35443038
300 2013 2013 & 2016 WV 100.0
306 2013 2013 & 2016 WY 90.47619048
5 2014 2013 & 2016 AK 83.33333333
11 2014 2013 & 2016 AL 42.1875
17 2014 2013 & 2016 AR 79.16666667
23 2014 2013 & 2016 AZ 100.0
29 2014 2013 & 2016 CA 97.61904762
35 2014 2013 & 2016 CO 91.66666667
41 2014 2013 & 2016 CT 79.59183673
47 2014 2013 & 2016 DC 100.0
53 2014 2013 & 2016 DE 50.0
59 2014 2013 & 2016 FL 98.50746269
65 2014 2013 & 2016 GA 91.66666667
71 2014 2013 & 2016 HI  
77 2014 2013 & 2016 IA 82.35294118
83 2014 2013 & 2016 ID 100.0
89 2014 2013 & 2016 IL 88.23529412
95 2014 2013 & 2016 IN 87.27272727
101 2014 2013 & 2016 KS 82.27848101
107 2014 2013 & 2016 KY 98.03921569
113 2014 2013 & 2016 LA 88.88888889
119 2014 2013 & 2016 MA 74.01574803
125 2014 2013 & 2016 MD 100.0
131 2014 2013 & 2016 ME 100.0
137 2014 2013 & 2016 MI 100.0
143 2014 2013 & 2016 MN 98.33333333
149 2014 2013 & 2016 MO 92.47311828
155 2014 2013 & 2016 MS 88.88888889
161 2014 2013 & 2016 MT 97.22222222
167 2014 2013 & 2016 NC 96.05263158
173 2014 2013 & 2016 ND 66.66666667
179 2014 2013 & 2016 NE 100.0
185 2014 2013 & 2016 NH 100.0
191 2014 2013 & 2016 NJ 62.96296296
197 2014 2013 & 2016 NM 100.0
203 2014 2013 & 2016 NV 100.0
209 2014 2013 & 2016 NY 93.47826087
215 2014 2013 & 2016 OH 97.72727273
221 2014 2013 & 2016 OK 100.0
227 2014 2013 & 2016 OR 100.0
233 2014 2013 & 2016 PA 100.0
239 2014 2013 & 2016 RI  
245 2014 2013 & 2016 SC 100.0
251 2014 2013 & 2016 SD 25.0
257 2014 2013 & 2016 TN 71.73913043
263 2014 2013 & 2016 TX 79.54545455
269 2014 2013 & 2016 UT 100.0
275 2014 2013 & 2016 VA 100.0
281 2014 2013 & 2016 VT 100.0
287 2014 2013 & 2016 WA 100.0
293 2014 2013 & 2016 WI 68.35443038

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