NHSPI_domains_subdomains

Table actions

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

204 rows where obsid = "0.0"

✎ 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
1 1 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AK 5.9
27 27 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AK 5.7
53 53 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AK 5.6000000000000005
79 79 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AK 5.2
157 157 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AL 6.800000000000001
183 183 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AL 6.5
209 209 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AL 6.2
235 235 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AL 5.7
313 313 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AR 6.6000000000000005
339 339 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AR 6.7
365 365 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AR 6.5
391 391 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AR 6.300000000000001
469 469 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AZ 6.6000000000000005
495 495 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AZ 6.300000000000001
521 521 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AZ 6.1000000000000005
547 547 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AZ 5.800000000000001
625 625 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CA 6.300000000000001
651 651 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CA 6.1000000000000005
677 677 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CA 6.2
703 703 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CA 6.1000000000000005
781 781 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CO 7.1000000000000005
807 807 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CO 6.9
833 833 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CO 6.800000000000001
859 859 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CO 6.4
937 937 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CT 6.800000000000001
963 963 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CT 6.7
989 989 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CT 6.7
1015 1015 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CT 6.300000000000001
1093 1093 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 DC 7.300000000000001
1119 1119 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 DC 6.800000000000001
1145 1145 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 DC 6.7
1171 1171 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DC 6.6000000000000005
1249 1249 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 DE 6.7
1275 1275 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 DE 6.7
1301 1301 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 DE 6.300000000000001
1327 1327 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DE 5.9
1405 1405 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 FL 6.7
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
1561 1561 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 GA 6.7
1587 1587 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 GA 6.5
1613 1613 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 GA 6.1000000000000005
1639 1639 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 GA 5.7
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
1769 1769 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 HI 6.1000000000000005
1795 1795 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 HI 5.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
1925 1925 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IA 6.7
1951 1951 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IA 6.7
2029 2029 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 ID 6.6000000000000005
2055 2055 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 ID 6.6000000000000005
2081 2081 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 ID 6.300000000000001
2107 2107 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 ID 5.9
2185 2185 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IL 6.7
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
2263 2263 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IL 6.0
2341 2341 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IN 6.300000000000001
2367 2367 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IN 6.2
2393 2393 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IN 6.0
2419 2419 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IN 6.1000000000000005
2497 2497 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 KS 6.7
2523 2523 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 KS 6.6000000000000005
2549 2549 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 KS 6.300000000000001
2575 2575 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 KS 6.2
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
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
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
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
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
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
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
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

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