NHSPI_domains_subdomains
Data source: Big Local News · About: big-local-datasette
7,956 rows sorted by Relevant Domain
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2601 | 2601 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | KS | 6.2 | ||||
2627 | 2627 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | KS | 6.0 | ||||
2653 | 2653 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | KY | 6.7 | |||
2679 | 2679 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | KY | 6.6000000000000005 | |||
2705 | 2705 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | KY | 6.4 | |||
2731 | 2731 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | KY | 6.7 | |||
2757 | 2757 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | KY | 6.4 | ||||
2783 | 2783 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | KY | 6.2 | ||||
2809 | 2809 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | LA | 6.300000000000001 | |||
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 | |||
2887 | 2887 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | LA | 5.7 | |||
2913 | 2913 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | LA | 5.800000000000001 | ||||
2939 | 2939 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | LA | 5.6000000000000005 | ||||
2965 | 2965 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MA | 7.4 | |||
2991 | 2991 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MA | 7.300000000000001 | |||
3017 | 3017 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MA | 6.9 | |||
3043 | 3043 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MA | 6.4 | |||
3069 | 3069 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MA | 6.300000000000001 | ||||
3095 | 3095 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MA | 6.300000000000001 | ||||
3121 | 3121 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MD | 7.300000000000001 | |||
3147 | 3147 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MD | 7.300000000000001 | |||
3173 | 3173 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MD | 7.0 | |||
3199 | 3199 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MD | 6.7 | |||
3225 | 3225 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MD | 6.6000000000000005 | ||||
3251 | 3251 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MD | 6.5 | ||||
3277 | 3277 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | ME | 6.6000000000000005 | |||
3303 | 3303 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | ME | 6.7 | |||
3329 | 3329 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | ME | 6.6000000000000005 | |||
3355 | 3355 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | ME | 6.6000000000000005 | |||
3381 | 3381 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | ME | 6.300000000000001 | ||||
3407 | 3407 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | ME | 6.300000000000001 | ||||
3433 | 3433 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MI | 6.5 | |||
3459 | 3459 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MI | 6.6000000000000005 | |||
3485 | 3485 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MI | 6.2 | |||
3511 | 3511 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MI | 6.300000000000001 | |||
3537 | 3537 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MI | 6.4 | ||||
3563 | 3563 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MI | 6.4 | ||||
3589 | 3589 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MN | 6.800000000000001 | |||
3615 | 3615 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MN | 6.7 | |||
3641 | 3641 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MN | 6.6000000000000005 | |||
3667 | 3667 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MN | 6.5 | |||
3693 | 3693 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MN | 6.5 | ||||
3719 | 3719 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MN | 6.1000000000000005 | ||||
3745 | 3745 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MO | 6.7 | |||
3771 | 3771 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MO | 6.800000000000001 | |||
3797 | 3797 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MO | 6.6000000000000005 | |||
3823 | 3823 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MO | 6.4 | |||
3849 | 3849 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MO | 6.5 | ||||
3875 | 3875 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MO | 6.4 | ||||
3901 | 3901 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MS | 6.5 | |||
3927 | 3927 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MS | 6.5 | |||
3953 | 3953 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MS | 6.300000000000001 | |||
3979 | 3979 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MS | 5.7 | |||
4005 | 4005 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MS | 5.5 | ||||
4031 | 4031 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MS | 5.1000000000000005 | ||||
4057 | 4057 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | MT | 6.5 | |||
4083 | 4083 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | MT | 6.4 | |||
4109 | 4109 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | MT | 6.2 | |||
4135 | 4135 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | MT | 6.1000000000000005 | |||
4161 | 4161 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | MT | 5.9 | ||||
4187 | 4187 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | MT | 5.300000000000001 | ||||
4213 | 4213 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NC | 6.7 | |||
4239 | 4239 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NC | 6.7 | |||
4265 | 4265 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NC | 6.6000000000000005 | |||
4291 | 4291 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NC | 6.2 | |||
4317 | 4317 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | NC | 6.1000000000000005 | ||||
4343 | 4343 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | NC | 5.9 | ||||
4369 | 4369 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | ND | 6.800000000000001 | |||
4395 | 4395 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | ND | 6.5 | |||
4421 | 4421 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | ND | 6.4 | |||
4447 | 4447 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | ND | 6.300000000000001 | |||
4473 | 4473 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | ND | 6.2 | ||||
4499 | 4499 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | ND | 6.2 | ||||
4525 | 4525 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NE | 7.300000000000001 | |||
4551 | 4551 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NE | 6.9 | |||
4577 | 4577 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NE | 6.9 | |||
4603 | 4603 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NE | 6.9 | |||
4629 | 4629 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | NE | 6.800000000000001 | ||||
4655 | 4655 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | NE | 6.6000000000000005 | ||||
4681 | 4681 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NH | 6.800000000000001 | |||
4707 | 4707 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NH | 6.7 | |||
4733 | 4733 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NH | 6.6000000000000005 | |||
4759 | 4759 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NH | 6.5 | |||
4785 | 4785 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | NH | 6.300000000000001 | ||||
4811 | 4811 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | NH | 5.9 | ||||
4837 | 4837 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NJ | 6.6000000000000005 | |||
4863 | 4863 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NJ | 6.300000000000001 | |||
4889 | 4889 | 0.0 | 2016 | overall | Active | Overall Index | NHSPI Index | 6.400000095 | 6.53 | 6.29 | NJ | 6.2 | |||
4915 | 4915 | 0.0 | 2015 | overall | Active | Overall Index | NHSPI Index | 6.199999809 | 6.32 | 6.05 | NJ | 5.9 | |||
4941 | 4941 | 2014 | overall | Active | Overall Index | NHSPI Index | 6.099999905 | 6.24 | 5.96 | NJ | 6.0 | ||||
4967 | 4967 | 2013 | overall | Active | Overall Index | NHSPI Index | 5.900000095 | 6.07 | 5.7700000000000005 | NJ | 5.800000000000001 | ||||
4993 | 4993 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NM | 6.2 | |||
5019 | 5019 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NM | 6.2 | |||
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 | |||
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 | ||||
5149 | 5149 | 0.0 | 2018 | overall | Active | Overall Index | NHSPI Index | 6.699999809 | 6.8100000000000005 | 6.55 | NV | 6.1000000000000005 | |||
5175 | 5175 | 0.0 | 2017 | overall | Active | Overall Index | NHSPI Index | 6.5 | 6.67 | 6.41 | NV | 5.800000000000001 |
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 );