NHSPI_domains_subdomains

Table actions

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

7,956 rows sorted by Relevant Domain

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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