NHSPI_domains_subdomains

Table actions

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

19 rows where Item Description = "NHSPI Index" and State_score = "6.800000000000001"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
157 157 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AL 6.800000000000001
833 833 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CO 6.800000000000001
937 937 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CT 6.800000000000001
1119 1119 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 DC 6.800000000000001
1873 1873 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IA 6.800000000000001
1899 1899 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IA 6.800000000000001
1977 1977   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IA 6.800000000000001
3589 3589 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 MN 6.800000000000001
3771 3771 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 MO 6.800000000000001
4369 4369 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 ND 6.800000000000001
4629 4629   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NE 6.800000000000001
4681 4681 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NH 6.800000000000001
5331 5331 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NY 6.800000000000001
6137 6137 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 RI 6.800000000000001
6553 6553 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 TN 6.800000000000001
6891 6891 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 UT 6.800000000000001
7073 7073 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 VA 6.800000000000001
7255 7255 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 VT 6.800000000000001
7489 7489 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WI 6.800000000000001

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