NHSPI_domains_subdomains

Table actions

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

51 rows where Item Name = "FWS" and National_score = "8.199999809"

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3923 3923 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 MS 8.8
4079 4079 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 MT 8.3
4235 4235 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 NC 9.3
4391 4391 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 ND 8.8
4547 4547 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 NE 9.4
4703 4703 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 NH 9.200000000000001
4859 4859 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 NJ 7.4
5015 5015 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 NM 7.2
5171 5171 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 NV 8.8
5327 5327 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 NY 9.200000000000001
5483 5483 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 OH 7.9
5639 5639 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 OK 8.1
5795 5795 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 OR 8.200000000000001
5951 5951 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 PA 8.700000000000001
6107 6107 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 RI 7.9
6263 6263 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 SC 9.200000000000001
6419 6419 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 SD 9.1
6575 6575 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 TN 9.0
6731 6731 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 TX 8.3
6887 6887 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 UT 6.1000000000000005
7043 7043 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 VA 9.5
7199 7199 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 VT 7.6000000000000005
7355 7355 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 WA 7.2
7511 7511 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 WI 8.4
7667 7667 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 WV 7.7
7823 7823 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 WY 7.7

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