NHSPI_domains_subdomains

Table actions

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

306 rows where Item Type = "" sorted by State_score

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: obsid, Year, National_score, Upper CI, Lower CI, State_score

Item Type ✖

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 ▼
131 131   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AK 4.7
105 105   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AK 5.0
4031 4031   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MS 5.1000000000000005
79 79 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AK 5.2
1691 1691   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 GA 5.300000000000001
4187 4187   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MT 5.300000000000001
5279 5279   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NV 5.4
7931 7931   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WY 5.4
599 599   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AZ 5.5
4005 4005   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MS 5.5
5227 5227 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NV 5.5
5591 5591   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OH 5.5
53 53 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AK 5.6000000000000005
287 287   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AL 5.6000000000000005
573 573   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AZ 5.6000000000000005
755 755   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CA 5.6000000000000005
1379 1379   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 DE 5.6000000000000005
1665 1665   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 GA 5.6000000000000005
2939 2939   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 LA 5.6000000000000005
5253 5253   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NV 5.6000000000000005
5565 5565   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OH 5.6000000000000005
7775 7775   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WV 5.6000000000000005
27 27 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AK 5.7
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
1353 1353   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 DE 5.7
1639 1639 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 GA 5.7
2887 2887 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 LA 5.7
3979 3979 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MS 5.7
5097 5097   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NM 5.7
5123 5123   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NM 5.7
5201 5201 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NV 5.7
7879 7879 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WY 5.7
443 443   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AR 5.800000000000001
547 547 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AZ 5.800000000000001
1535 1535   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 FL 5.800000000000001
1795 1795 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 HI 5.800000000000001
1847 1847   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 HI 5.800000000000001
2315 2315   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IL 5.800000000000001
2913 2913   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 LA 5.800000000000001
4967 4967   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NJ 5.800000000000001
5175 5175 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NV 5.800000000000001
6839 6839   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 TX 5.800000000000001
7749 7749   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WV 5.800000000000001
7905 7905   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WY 5.800000000000001
1 1 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AK 5.9
729 729   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CA 5.9
1327 1327 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DE 5.9
1821 1821   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 HI 5.9
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
2289 2289   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IL 5.9
4161 4161   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MT 5.9
4343 4343   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NC 5.9
4811 4811   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NH 5.9
4915 4915 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NJ 5.9
5487 5487 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OH 5.9
5513 5513 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OH 5.9
5539 5539 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OH 5.9
5721 5721   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OK 5.9
5747 5747   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OK 5.9
5903 5903   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OR 5.9
6059 6059   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 PA 5.9
6501 6501   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SD 5.9
6527 6527   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 SD 5.9
7723 7723 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WV 5.9
7853 7853 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WY 5.9
911 911   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CO 6.0
2263 2263 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IL 6.0
2393 2393 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IN 6.0
2627 2627   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 KS 6.0
4941 4941   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NJ 6.0
5045 5045 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NM 6.0
5071 5071 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NM 6.0
5695 5695 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OK 6.0
6033 6033   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 PA 6.0
6475 6475 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SD 6.0
6813 6813   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 TX 6.0
7463 7463   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WA 6.0
7619 7619   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WI 6.0
7827 7827 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WY 6.0
417 417   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AR 6.1000000000000005
521 521 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AZ 6.1000000000000005
651 651 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CA 6.1000000000000005
703 703 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CA 6.1000000000000005
1613 1613 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 GA 6.1000000000000005
1769 1769 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 HI 6.1000000000000005
2419 2419 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IN 6.1000000000000005
2471 2471   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IN 6.1000000000000005
2835 2835 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 LA 6.1000000000000005
2861 2861 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 LA 6.1000000000000005
3719 3719   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MN 6.1000000000000005
4135 4135 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MT 6.1000000000000005
4317 4317   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NC 6.1000000000000005
5149 5149 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NV 6.1000000000000005
5435 5435   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NY 6.1000000000000005
5461 5461 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OH 6.1000000000000005
6007 6007 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 PA 6.1000000000000005
6345 6345   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SC 6.1000000000000005

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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