NHSPI_domains_subdomains

Table actions

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

51 rows where National_score = "8.300000191" 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3949 3949 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 MS 8.8
4105 4105 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 MT 8.4
4261 4261 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 NC 9.4
4417 4417 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 ND 8.9
4573 4573 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 NE 9.3
4729 4729 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 NH 9.3
4885 4885 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 NJ 7.2
5041 5041 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 NM 7.0
5197 5197 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 NV 8.700000000000001
5353 5353 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 NY 9.1
5509 5509 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 OH 7.800000000000001
5665 5665 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 OK 8.0
5821 5821 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 OR 8.1
5977 5977 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 PA 8.5
6133 6133 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 RI 8.9
6289 6289 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 SC 9.4
6445 6445 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 SD 9.200000000000001
6601 6601 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 TN 8.9
6757 6757 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 TX 8.1
6913 6913 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 UT 6.9
7069 7069 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 VA 9.3
7225 7225 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 VT 7.300000000000001
7381 7381 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 WA 7.1000000000000005
7537 7537 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 WI 8.6
7693 7693 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 WV 7.4
7849 7849 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 WY 8.200000000000001

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