NHSPI_domains_subdomains

Table actions

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

51 rows where National_score = "8.100000381" and Relevant Subdomain = "FWS"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: State_score

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3975 3975 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 MS 8.8
4131 4131 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 MT 7.7
4287 4287 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 NC 9.4
4443 4443 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 ND 7.7
4599 4599 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 NE 8.8
4755 4755 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 NH 9.3
4911 4911 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 NJ 7.2
5067 5067 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 NM 7.6000000000000005
5223 5223 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 NV 8.3
5379 5379 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 NY 9.1
5535 5535 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 OH 7.6000000000000005
5691 5691 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 OK 7.9
5847 5847 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 OR 7.800000000000001
6003 6003 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 PA 8.8
6159 6159 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 RI 9.1
6315 6315 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 SC 9.1
6471 6471 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 SD 8.9
6627 6627 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 TN 9.1
6783 6783 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 TX 7.9
6939 6939 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 UT 6.2
7095 7095 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 VA 9.1
7251 7251 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 VT 7.1000000000000005
7407 7407 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 WA 7.4
7563 7563 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 WI 8.4
7719 7719 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 WV 7.9
7875 7875 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 WY 7.6000000000000005

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