NHSPI_domains_subdomains

Table actions

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

306 rows where Relevant Subdomain = "" sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Relevant Subdomain ✖

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
7931 7931   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WY 5.4
7905 7905   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WY 5.800000000000001
7879 7879 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WY 5.7
7853 7853 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WY 5.9
7827 7827 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WY 6.0
7801 7801 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WY 6.4
7775 7775   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WV 5.6000000000000005
7749 7749   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WV 5.800000000000001
7723 7723 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WV 5.9
7697 7697 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WV 6.2
7671 7671 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WV 6.2
7645 7645 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WV 6.1000000000000005
7619 7619   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WI 6.0
7593 7593   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WI 6.300000000000001
7567 7567 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WI 6.300000000000001
7541 7541 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WI 6.7
7515 7515 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WI 6.9
7489 7489 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WI 6.800000000000001
7463 7463   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WA 6.0
7437 7437   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WA 6.1000000000000005
7411 7411 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WA 6.2
7385 7385 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WA 6.4
7359 7359 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WA 6.4
7333 7333 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WA 6.5
7307 7307   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 VT 6.5
7281 7281   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 VT 6.7
7255 7255 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 VT 6.800000000000001
7229 7229 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 VT 7.0
7203 7203 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 VT 7.0
7177 7177 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 VT 7.2
7151 7151   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 VA 6.300000000000001
7125 7125   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 VA 6.4
7099 7099 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 VA 6.7
7073 7073 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 VA 6.800000000000001
7047 7047 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 VA 7.2
7021 7021 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 VA 7.2
6995 6995   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 UT 6.4
6969 6969   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 UT 6.6000000000000005
6943 6943 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 UT 6.5
6917 6917 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 UT 6.7
6891 6891 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 UT 6.800000000000001
6865 6865 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 UT 7.1000000000000005
6839 6839   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 TX 5.800000000000001
6813 6813   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 TX 6.0
6787 6787 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TX 6.300000000000001
6761 6761 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TX 6.300000000000001
6735 6735 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 TX 6.4
6709 6709 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 TX 6.5
6683 6683   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 TN 6.1000000000000005
6657 6657   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 TN 6.300000000000001
6631 6631 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TN 6.1000000000000005
6605 6605 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TN 6.4
6579 6579 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 TN 6.5
6553 6553 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 TN 6.800000000000001
6527 6527   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 SD 5.9
6501 6501   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SD 5.9
6475 6475 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SD 6.0
6449 6449 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 SD 6.300000000000001
6423 6423 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 SD 6.300000000000001
6397 6397 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 SD 6.300000000000001
6371 6371   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 SC 6.2
6345 6345   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SC 6.1000000000000005
6319 6319 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SC 6.300000000000001
6293 6293 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 SC 6.5
6267 6267 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 SC 6.6000000000000005
6241 6241 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 SC 6.7
6215 6215   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 RI 6.2
6189 6189   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 RI 6.5
6163 6163 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 RI 6.5
6137 6137 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 RI 6.800000000000001
6111 6111 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 RI 6.9
6085 6085 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 RI 7.2
6059 6059   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 PA 5.9
6033 6033   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 PA 6.0
6007 6007 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 PA 6.1000000000000005
5981 5981 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 PA 6.6000000000000005
5955 5955 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 PA 6.6000000000000005
5929 5929 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 PA 6.7
5903 5903   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OR 5.9
5877 5877   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OR 6.2
5851 5851 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OR 6.2
5825 5825 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OR 6.6000000000000005
5799 5799 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OR 6.5
5773 5773 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OR 6.7
5747 5747   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OK 5.9
5721 5721   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OK 5.9
5695 5695 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OK 6.0
5669 5669 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OK 6.2
5643 5643 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OK 6.2
5617 5617 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OK 6.6000000000000005
5591 5591   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OH 5.5
5565 5565   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OH 5.6000000000000005
5539 5539 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OH 5.9
5513 5513 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OH 5.9
5487 5487 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OH 5.9
5461 5461 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OH 6.1000000000000005
5435 5435   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NY 6.1000000000000005
5409 5409   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NY 6.300000000000001
5383 5383 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NY 6.6000000000000005
5357 5357 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NY 6.6000000000000005

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