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

7,956 rows sorted by Relevant Domain

View and edit SQL

Suggested facets: obsid, Year, Item Name, Item Type, Relevant Domain, Item Name

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 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AK 5.9
27 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AK 5.7
53 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AK 5.6000000000000005
79 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AK 5.2
105   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AK 5.0
131   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AK 4.7
157 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AL 6.800000000000001
183 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AL 6.5
209 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AL 6.2
235 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AL 5.7
261   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AL 5.7
287   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AL 5.6000000000000005
313 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AR 6.6000000000000005
339 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AR 6.7
365 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AR 6.5
391 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AR 6.300000000000001
417   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AR 6.1000000000000005
443   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AR 5.800000000000001
469 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 AZ 6.6000000000000005
495 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 AZ 6.300000000000001
521 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 AZ 6.1000000000000005
547 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 AZ 5.800000000000001
573   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 AZ 5.6000000000000005
599   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 AZ 5.5
625 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CA 6.300000000000001
651 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CA 6.1000000000000005
677 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CA 6.2
703 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CA 6.1000000000000005
729   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CA 5.9
755   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CA 5.6000000000000005
781 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CO 7.1000000000000005
807 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CO 6.9
833 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CO 6.800000000000001
859 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CO 6.4
885   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CO 6.2
911   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CO 6.0
937 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 CT 6.800000000000001
963 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 CT 6.7
989 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 CT 6.7
1015 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 CT 6.300000000000001
1041   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 CT 6.300000000000001
1067   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 CT 6.300000000000001
1093 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 DC 7.300000000000001
1119 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 DC 6.800000000000001
1145 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 DC 6.7
1171 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DC 6.6000000000000005
1197   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 DC 6.7
1223   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 DC 6.4
1249 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 DE 6.7
1275 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 DE 6.7
1301 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 DE 6.300000000000001
1327 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 DE 5.9
1353   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 DE 5.7
1379   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 DE 5.6000000000000005
1405 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 FL 6.7
1431 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 FL 6.4
1457 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 FL 6.4
1483 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 FL 6.4
1509   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 FL 6.2
1535   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 FL 5.800000000000001
1561 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 GA 6.7
1587 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 GA 6.5
1613 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 GA 6.1000000000000005
1639 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 GA 5.7
1665   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 GA 5.6000000000000005
1691   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 GA 5.300000000000001
1717 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 HI 6.4
1743 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 HI 6.4
1769 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 HI 6.1000000000000005
1795 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 HI 5.800000000000001
1821   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 HI 5.9
1847   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 HI 5.800000000000001
1873 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IA 6.800000000000001
1899 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IA 6.800000000000001
1925 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IA 6.7
1951 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IA 6.7
1977   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IA 6.800000000000001
2003   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IA 6.5
2029 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 ID 6.6000000000000005
2055 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 ID 6.6000000000000005
2081 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 ID 6.300000000000001
2107 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 ID 5.9
2133   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 ID 5.9
2159   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 ID 5.9
2185 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IL 6.7
2211 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IL 6.5
2237 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IL 6.5
2263 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IL 6.0
2289   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IL 5.9
2315   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IL 5.800000000000001
2341 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 IN 6.300000000000001
2367 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 IN 6.2
2393 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 IN 6.0
2419 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 IN 6.1000000000000005
2445   2014 overall   Active     Overall Index NHSPI Index 6.099999905 6.24 5.96 IN 6.2
2471   2013 overall   Active     Overall Index NHSPI Index 5.900000095 6.07 5.7700000000000005 IN 6.1000000000000005
2497 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 KS 6.7
2523 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 KS 6.6000000000000005
2549 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 KS 6.300000000000001
2575 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 KS 6.2

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