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

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