NHSPI_domains_subdomains

Table actions

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

204 rows where obsid = "230.0"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

obsid ✖

  • 230.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
23 23 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 AK 6.800000000000001
49 49 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 AK 7.0
75 75 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 AK 7.2
101 101 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 AK 3.4000000000000004
179 179 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 AL 9.600000000000001
205 205 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 AL 9.4
231 231 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 AL 9.5
257 257 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 AL 8.3
335 335 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 AR 8.1
361 361 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 AR 7.9
387 387 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 AR 7.7
413 413 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 AR 7.4
491 491 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 AZ 8.1
517 517 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 AZ 7.800000000000001
543 543 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 AZ 7.6000000000000005
569 569 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 AZ 7.5
647 647 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 CA 8.700000000000001
673 673 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 CA 8.5
699 699 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 CA 8.200000000000001
725 725 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 CA 8.4
803 803 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 CO 8.3
829 829 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 CO 8.4
855 855 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 CO 8.3
881 881 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 CO 8.700000000000001
959 959 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 CT 8.3
985 985 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 CT 8.1
1011 1011 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 CT 8.200000000000001
1037 1037 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 CT 7.5
1115 1115 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 DC 5.0
1141 1141 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 DC 5.7
1167 1167 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 DC 4.9
1193 1193 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 DC 7.0
1271 1271 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 DE 7.7
1297 1297 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 DE 8.0
1323 1323 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 DE 7.6000000000000005
1349 1349 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 DE 6.800000000000001
1427 1427 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 FL 8.4
1453 1453 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 FL 8.5
1479 1479 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 FL 8.3
1505 1505 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 FL 8.3
1583 1583 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 GA 9.0
1609 1609 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 GA 8.8
1635 1635 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 GA 8.8
1661 1661 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 GA 6.6000000000000005
1739 1739 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 HI 7.4
1765 1765 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 HI 8.0
1791 1791 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 HI 8.0
1817 1817 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 HI 8.5
1895 1895 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 IA 9.0
1921 1921 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 IA 9.200000000000001
1947 1947 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 IA 8.700000000000001
1973 1973 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 IA 8.700000000000001
2051 2051 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 ID 8.3
2077 2077 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 ID 8.6
2103 2103 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 ID 8.0
2129 2129 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 ID 8.200000000000001
2207 2207 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 IL 9.3
2233 2233 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 IL 9.4
2259 2259 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 IL 9.200000000000001
2285 2285 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 IL 8.700000000000001
2363 2363 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 IN 9.5
2389 2389 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 IN 9.200000000000001
2415 2415 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 IN 9.200000000000001
2441 2441 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 IN 8.5
2519 2519 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 KS 5.300000000000001
2545 2545 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 KS 5.0
2571 2571 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 KS 4.4
2597 2597 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 KS 7.0
2675 2675 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 KY 8.5
2701 2701 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 KY 8.200000000000001
2727 2727 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 KY 7.9
2753 2753 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 KY 8.5
2831 2831 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 LA 7.800000000000001
2857 2857 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 LA 8.0
2883 2883 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 LA 7.9
2909 2909 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 LA 7.1000000000000005
2987 2987 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 MA 8.8
3013 3013 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 MA 8.9
3039 3039 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 MA 8.5
3065 3065 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 MA 7.0
3143 3143 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 MD 8.9
3169 3169 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 MD 9.0
3195 3195 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 MD 9.0
3221 3221 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 MD 8.6
3299 3299 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 ME 8.3
3325 3325 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 ME 8.0
3351 3351 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 ME 8.3
3377 3377 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 ME 8.6
3455 3455 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 MI 6.7
3481 3481 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 MI 6.800000000000001
3507 3507 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 MI 6.800000000000001
3533 3533 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 MI 8.5
3611 3611 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 MN 9.0
3637 3637 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 MN 8.9
3663 3663 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 MN 8.4
3689 3689 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 MN 8.3
3767 3767 230.0 2018 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.199999809 8.620000000000001 7.87 MO 8.6
3793 3793 230.0 2017 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.300000191 8.620000000000001 7.91 MO 8.4
3819 3819 230.0 2016 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 8.100000381 8.47 7.71 MO 8.3
3845 3845 230.0 2015 FWS Subdomain Active EOH FWS Food & Water Security The sufficient availability, access, use, and protection of safe and clean food and water resources to support human well-being and health. 7.800000191 8.23 7.45 MO 7.6000000000000005

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