NHSPI_domains_subdomains

Table actions

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

204 rows where obsid = "0.0" sorted by State_score

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

obsid ✖

  • 0.0 · 204 ✖
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 ▼
79 79 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AK 5.2
5227 5227 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NV 5.5
53 53 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AK 5.6000000000000005
27 27 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AK 5.7
235 235 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AL 5.7
1639 1639 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 GA 5.7
2887 2887 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 LA 5.7
3979 3979 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MS 5.7
5201 5201 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NV 5.7
7879 7879 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WY 5.7
547 547 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AZ 5.800000000000001
1795 1795 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 HI 5.800000000000001
5175 5175 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NV 5.800000000000001
1 1 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AK 5.9
1327 1327 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DE 5.9
2107 2107 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 ID 5.9
4915 4915 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NJ 5.9
5487 5487 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OH 5.9
5513 5513 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OH 5.9
5539 5539 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OH 5.9
7723 7723 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WV 5.9
7853 7853 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WY 5.9
2263 2263 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IL 6.0
2393 2393 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IN 6.0
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
5695 5695 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OK 6.0
6475 6475 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SD 6.0
7827 7827 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WY 6.0
521 521 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AZ 6.1000000000000005
651 651 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CA 6.1000000000000005
703 703 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CA 6.1000000000000005
1613 1613 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 GA 6.1000000000000005
1769 1769 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 HI 6.1000000000000005
2419 2419 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IN 6.1000000000000005
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
4135 4135 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MT 6.1000000000000005
5149 5149 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NV 6.1000000000000005
5461 5461 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OH 6.1000000000000005
6007 6007 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 PA 6.1000000000000005
6631 6631 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TN 6.1000000000000005
7645 7645 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WV 6.1000000000000005
209 209 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AL 6.2
677 677 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CA 6.2
2367 2367 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IN 6.2
2575 2575 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 KS 6.2
3485 3485 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 MI 6.2
4109 4109 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 MT 6.2
4291 4291 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NC 6.2
4889 4889 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NJ 6.2
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
5643 5643 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OK 6.2
5669 5669 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OK 6.2
5851 5851 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OR 6.2
7411 7411 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WA 6.2
7671 7671 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WV 6.2
7697 7697 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WV 6.2
391 391 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AR 6.300000000000001
495 495 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AZ 6.300000000000001
625 625 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CA 6.300000000000001
1015 1015 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CT 6.300000000000001
1301 1301 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 DE 6.300000000000001
2081 2081 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 ID 6.300000000000001
2341 2341 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IN 6.300000000000001
2549 2549 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 KS 6.300000000000001
2809 2809 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 LA 6.300000000000001
3511 3511 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MI 6.300000000000001
3953 3953 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 MS 6.300000000000001
4447 4447 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 ND 6.300000000000001
4863 4863 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NJ 6.300000000000001
6319 6319 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SC 6.300000000000001
6397 6397 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 SD 6.300000000000001
6423 6423 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 SD 6.300000000000001
6449 6449 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 SD 6.300000000000001
6761 6761 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TX 6.300000000000001
6787 6787 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TX 6.300000000000001
7567 7567 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WI 6.300000000000001
859 859 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CO 6.4
1431 1431 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 FL 6.4
1457 1457 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 FL 6.4
1483 1483 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 FL 6.4
1717 1717 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 HI 6.4
1743 1743 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 HI 6.4
2705 2705 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 KY 6.4
3043 3043 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MA 6.4
3823 3823 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MO 6.4
4083 4083 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 MT 6.4
4421 4421 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 ND 6.4
6605 6605 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TN 6.4
6735 6735 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 TX 6.4
7359 7359 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WA 6.4
7385 7385 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WA 6.4
7801 7801 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WY 6.4
183 183 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AL 6.5
365 365 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AR 6.5
1587 1587 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 GA 6.5
2211 2211 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IL 6.5
2237 2237 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IL 6.5

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