NHSPI_domains_subdomains
Data source: Big Local News · About: big-local-datasette
204 rows where obsid = "0.0" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: Year, National_score, Upper CI, Lower CI, State_score
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
5331 | 5331 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NY | 6.800000000000001 | |||
5305 | 5305 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NY | 6.9 | |||
5227 | 5227 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NV | 5.5 | |||
5201 | 5201 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NV | 5.7 | |||
5175 | 5175 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NV | 5.800000000000001 | |||
5149 | 5149 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NV | 6.1000000000000005 | |||
5071 | 5071 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NM | 6.0 | |||
5045 | 5045 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NM | 6.0 | |||
5019 | 5019 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NM | 6.2 | |||
4993 | 4993 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NM | 6.2 | |||
4915 | 4915 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NJ | 5.9 | |||
4889 | 4889 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NJ | 6.2 | |||
4863 | 4863 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NJ | 6.300000000000001 | |||
4837 | 4837 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NJ | 6.6000000000000005 | |||
4759 | 4759 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NH | 6.5 | |||
4733 | 4733 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NH | 6.6000000000000005 | |||
4707 | 4707 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NH | 6.7 | |||
4681 | 4681 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NH | 6.800000000000001 | |||
4603 | 4603 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NE | 6.9 | |||
4577 | 4577 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NE | 6.9 | |||
4551 | 4551 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NE | 6.9 | |||
4525 | 4525 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NE | 7.300000000000001 | |||
4447 | 4447 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | ND | 6.300000000000001 | |||
4421 | 4421 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | ND | 6.4 | |||
4395 | 4395 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | ND | 6.5 | |||
4369 | 4369 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | ND | 6.800000000000001 | |||
4291 | 4291 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NC | 6.2 | |||
4265 | 4265 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NC | 6.6000000000000005 | |||
4239 | 4239 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NC | 6.7 | |||
4213 | 4213 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NC | 6.7 | |||
4135 | 4135 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MT | 6.1000000000000005 | |||
4109 | 4109 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MT | 6.2 | |||
4083 | 4083 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MT | 6.4 | |||
4057 | 4057 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MT | 6.5 |
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 );