NHSPI_domains_subdomains

Table actions

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

306 rows where Item Name = "overall" sorted by National_score

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Item Name ✖

  • overall · 306 ✖
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
131 131   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AK 4.7
287 287   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AL 5.6000000000000005
443 443   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AR 5.800000000000001
599 599   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AZ 5.5
755 755   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CA 5.6000000000000005
911 911   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CO 6.0
1067 1067   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CT 6.300000000000001
1223 1223   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 DC 6.4
1379 1379   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 DE 5.6000000000000005
1535 1535   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 FL 5.800000000000001
1691 1691   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 GA 5.300000000000001
1847 1847   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 HI 5.800000000000001
2003 2003   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IA 6.5
2159 2159   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 ID 5.9
2315 2315   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IL 5.800000000000001
2471 2471   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IN 6.1000000000000005
2627 2627   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 KS 6.0
2783 2783   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 KY 6.2
2939 2939   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 LA 5.6000000000000005
3095 3095   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MA 6.300000000000001
3251 3251   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MD 6.5
3407 3407   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 ME 6.300000000000001
3563 3563   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MI 6.4
3719 3719   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MN 6.1000000000000005
3875 3875   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MO 6.4
4031 4031   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MS 5.1000000000000005
4187 4187   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 MT 5.300000000000001
4343 4343   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NC 5.9
4499 4499   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 ND 6.2
4655 4655   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NE 6.6000000000000005
4811 4811   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NH 5.9
4967 4967   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NJ 5.800000000000001
5123 5123   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NM 5.7
5279 5279   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NV 5.4
5435 5435   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 NY 6.1000000000000005
5591 5591   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OH 5.5
5747 5747   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OK 5.9
5903 5903   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 OR 5.9
6059 6059   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 PA 5.9
6215 6215   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 RI 6.2
6371 6371   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 SC 6.2
6527 6527   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 SD 5.9
6683 6683   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 TN 6.1000000000000005
6839 6839   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 TX 5.800000000000001
6995 6995   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 UT 6.4
7151 7151   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 VA 6.300000000000001
7307 7307   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 VT 6.5
7463 7463   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WA 6.0
7619 7619   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WI 6.0
7775 7775   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WV 5.6000000000000005
7931 7931   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 WY 5.4
105 105   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AK 5.0
261 261   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AL 5.7
417 417   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AR 6.1000000000000005
573 573   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AZ 5.6000000000000005
729 729   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CA 5.9
885 885   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CO 6.2
1041 1041   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CT 6.300000000000001
1197 1197   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 DC 6.7
1353 1353   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 DE 5.7
1509 1509   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 FL 6.2
1665 1665   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 GA 5.6000000000000005
1821 1821   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 HI 5.9
1977 1977   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IA 6.800000000000001
2133 2133   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 ID 5.9
2289 2289   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IL 5.9
2445 2445   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IN 6.2
2601 2601   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 KS 6.2
2757 2757   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 KY 6.4
2913 2913   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 LA 5.800000000000001
3069 3069   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MA 6.300000000000001
3225 3225   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MD 6.6000000000000005
3381 3381   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 ME 6.300000000000001
3537 3537   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MI 6.4
3693 3693   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MN 6.5
3849 3849   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MO 6.5
4005 4005   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MS 5.5
4161 4161   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 MT 5.9
4317 4317   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NC 6.1000000000000005
4473 4473   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 ND 6.2
4629 4629   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NE 6.800000000000001
4785 4785   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NH 6.300000000000001
4941 4941   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NJ 6.0
5097 5097   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NM 5.7
5253 5253   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NV 5.6000000000000005
5409 5409   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 NY 6.300000000000001
5565 5565   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OH 5.6000000000000005
5721 5721   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OK 5.9
5877 5877   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 OR 6.2
6033 6033   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 PA 6.0
6189 6189   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 RI 6.5
6345 6345   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SC 6.1000000000000005
6501 6501   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 SD 5.9
6657 6657   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 TN 6.300000000000001
6813 6813   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 TX 6.0
6969 6969   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 UT 6.6000000000000005
7125 7125   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 VA 6.4
7281 7281   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 VT 6.7
7437 7437   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WA 6.1000000000000005
7593 7593   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 WI 6.300000000000001

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