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

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