NHSPI_domains_subdomains
Data source: Big Local News · About: big-local-datasette
7,956 rows sorted by Relevant Subdomain
This data as json, copyable, CSV (advanced)
Suggested facets: obsid, Item Name, Relevant Domain, Relevant Subdomain, Item Name
Link | rowid | obsid | Year | Item Name | Item Type | Item Status | Relevant Domain | Relevant Subdomain ▼ | Item Name | Item Description | National_score | Upper CI | Lower CI | State | State_score |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | AK | 5.9 | |||
27 | 27 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | AK | 5.7 | |||
53 | 53 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | AK | 5.6000000000000005 | |||
79 | 79 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | AK | 5.2 | |||
105 | 105 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | AK | 5.0 | ||||
131 | 131 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | AK | 4.7 | ||||
157 | 157 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | AL | 6.800000000000001 | |||
183 | 183 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | AL | 6.5 | |||
209 | 209 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | AL | 6.2 | |||
235 | 235 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | AL | 5.7 | |||
261 | 261 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | AL | 5.7 | ||||
287 | 287 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | AL | 5.6000000000000005 | ||||
313 | 313 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | AR | 6.6000000000000005 | |||
339 | 339 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | AR | 6.7 | |||
365 | 365 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | AR | 6.5 | |||
391 | 391 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | AR | 6.300000000000001 | |||
417 | 417 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | AR | 6.1000000000000005 | ||||
443 | 443 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | AR | 5.800000000000001 | ||||
469 | 469 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | AZ | 6.6000000000000005 | |||
495 | 495 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | AZ | 6.300000000000001 | |||
521 | 521 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | AZ | 6.1000000000000005 | |||
547 | 547 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | AZ | 5.800000000000001 | |||
573 | 573 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | AZ | 5.6000000000000005 | ||||
599 | 599 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | AZ | 5.5 | ||||
625 | 625 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | CA | 6.300000000000001 | |||
651 | 651 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | CA | 6.1000000000000005 | |||
677 | 677 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | CA | 6.2 | |||
703 | 703 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | CA | 6.1000000000000005 | |||
729 | 729 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | CA | 5.9 | ||||
755 | 755 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | CA | 5.6000000000000005 | ||||
781 | 781 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | CO | 7.1000000000000005 | |||
807 | 807 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | CO | 6.9 | |||
833 | 833 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | CO | 6.800000000000001 | |||
859 | 859 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | CO | 6.4 | |||
885 | 885 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | CO | 6.2 | ||||
911 | 911 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | CO | 6.0 | ||||
937 | 937 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | CT | 6.800000000000001 | |||
963 | 963 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | CT | 6.7 | |||
989 | 989 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | CT | 6.7 | |||
1015 | 1015 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | CT | 6.300000000000001 | |||
1041 | 1041 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | CT | 6.300000000000001 | ||||
1067 | 1067 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | CT | 6.300000000000001 | ||||
1093 | 1093 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | DC | 7.300000000000001 | |||
1119 | 1119 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | DC | 6.800000000000001 | |||
1145 | 1145 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | DC | 6.7 | |||
1171 | 1171 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | DC | 6.6000000000000005 | |||
1197 | 1197 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | DC | 6.7 | ||||
1223 | 1223 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | DC | 6.4 | ||||
1249 | 1249 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | DE | 6.7 | |||
1275 | 1275 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | DE | 6.7 | |||
1301 | 1301 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | DE | 6.300000000000001 | |||
1327 | 1327 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | DE | 5.9 | |||
1353 | 1353 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | DE | 5.7 | ||||
1379 | 1379 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | DE | 5.6000000000000005 | ||||
1405 | 1405 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | FL | 6.7 | |||
1431 | 1431 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | FL | 6.4 | |||
1457 | 1457 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | FL | 6.4 | |||
1483 | 1483 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | FL | 6.4 | |||
1509 | 1509 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | FL | 6.2 | ||||
1535 | 1535 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | FL | 5.800000000000001 | ||||
1561 | 1561 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | GA | 6.7 | |||
1587 | 1587 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | GA | 6.5 | |||
1613 | 1613 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | GA | 6.1000000000000005 | |||
1639 | 1639 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | GA | 5.7 | |||
1665 | 1665 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | GA | 5.6000000000000005 | ||||
1691 | 1691 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | GA | 5.300000000000001 | ||||
1717 | 1717 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | HI | 6.4 | |||
1743 | 1743 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | HI | 6.4 | |||
1769 | 1769 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | HI | 6.1000000000000005 | |||
1795 | 1795 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | HI | 5.800000000000001 | |||
1821 | 1821 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | HI | 5.9 | ||||
1847 | 1847 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | HI | 5.800000000000001 | ||||
1873 | 1873 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | IA | 6.800000000000001 | |||
1899 | 1899 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | IA | 6.800000000000001 | |||
1925 | 1925 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | IA | 6.7 | |||
1951 | 1951 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | IA | 6.7 | |||
1977 | 1977 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | IA | 6.800000000000001 | ||||
2003 | 2003 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | IA | 6.5 | ||||
2029 | 2029 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | ID | 6.6000000000000005 | |||
2055 | 2055 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | ID | 6.6000000000000005 | |||
2081 | 2081 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | ID | 6.300000000000001 | |||
2107 | 2107 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | ID | 5.9 | |||
2133 | 2133 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | ID | 5.9 | ||||
2159 | 2159 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | ID | 5.9 | ||||
2185 | 2185 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | IL | 6.7 | |||
2211 | 2211 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | IL | 6.5 | |||
2237 | 2237 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | IL | 6.5 | |||
2263 | 2263 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | IL | 6.0 | |||
2289 | 2289 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | IL | 5.9 | ||||
2315 | 2315 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | IL | 5.800000000000001 | ||||
2341 | 2341 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | IN | 6.300000000000001 | |||
2367 | 2367 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | IN | 6.2 | |||
2393 | 2393 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | IN | 6.0 | |||
2419 | 2419 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | IN | 6.1000000000000005 | |||
2445 | 2445 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | IN | 6.2 | ||||
2471 | 2471 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | IN | 6.1000000000000005 | ||||
2497 | 2497 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | KS | 6.7 | |||
2523 | 2523 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | KS | 6.6000000000000005 | |||
2549 | 2549 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | KS | 6.300000000000001 | |||
2575 | 2575 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | KS | 6.2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [NHSPI_domains_subdomains] ( [obsid] TEXT, [Year] INTEGER, [Item Name] TEXT, [Item Type] TEXT, [Item Status] TEXT, [Relevant Domain] TEXT, [Relevant Subdomain] TEXT, [Item Name] TEXT, [Item Description] TEXT, [National_score] TEXT, [Upper CI] TEXT, [Lower CI] TEXT, [State] TEXT, [State_score] TEXT );