NHSPI_domains_subdomains

Table actions

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

51 rows where National_score = "7.900000095" 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
127 127   2014 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.900000095 8.26 7.46 AK 3.7
283 283   2014 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.900000095 8.26 7.46 AL 8.200000000000001
439 439   2014 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.900000095 8.26 7.46 AR 7.4
595 595   2014 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.900000095 8.26 7.46 AZ 7.5
751 751   2014 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.900000095 8.26 7.46 CA 8.4
907 907   2014 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.900000095 8.26 7.46 CO 8.6
1063 1063   2014 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.900000095 8.26 7.46 CT 7.800000000000001
1219 1219   2014 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.900000095 8.26 7.46 DC 6.2
1375 1375   2014 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.900000095 8.26 7.46 DE 7.0
1531 1531   2014 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.900000095 8.26 7.46 FL 8.6
1687 1687   2014 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.900000095 8.26 7.46 GA 6.5
1843 1843   2014 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.900000095 8.26 7.46 HI 8.0
1999 1999   2014 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.900000095 8.26 7.46 IA 9.0
2155 2155   2014 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.900000095 8.26 7.46 ID 8.200000000000001
2311 2311   2014 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.900000095 8.26 7.46 IL 8.8
2467 2467   2014 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.900000095 8.26 7.46 IN 8.700000000000001
2623 2623   2014 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.900000095 8.26 7.46 KS 6.9
2779 2779   2014 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.900000095 8.26 7.46 KY 8.9
2935 2935   2014 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.900000095 8.26 7.46 LA 6.9
3091 3091   2014 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.900000095 8.26 7.46 MA 6.800000000000001
3247 3247   2014 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.900000095 8.26 7.46 MD 8.700000000000001
3403 3403   2014 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.900000095 8.26 7.46 ME 8.8
3559 3559   2014 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.900000095 8.26 7.46 MI 8.6
3715 3715   2014 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.900000095 8.26 7.46 MN 9.0
3871 3871   2014 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.900000095 8.26 7.46 MO 7.6000000000000005
4027 4027   2014 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.900000095 8.26 7.46 MS 8.1
4183 4183   2014 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.900000095 8.26 7.46 MT 7.6000000000000005
4339 4339   2014 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.900000095 8.26 7.46 NC 8.9
4495 4495   2014 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.900000095 8.26 7.46 ND 7.4
4651 4651   2014 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.900000095 8.26 7.46 NE 8.5
4807 4807   2014 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.900000095 8.26 7.46 NH 8.8
4963 4963   2014 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.900000095 8.26 7.46 NJ 8.6
5119 5119   2014 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.900000095 8.26 7.46 NM 7.9
5275 5275   2014 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.900000095 8.26 7.46 NV 8.5
5431 5431   2014 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.900000095 8.26 7.46 NY 9.0
5587 5587   2014 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.900000095 8.26 7.46 OH 6.0
5743 5743   2014 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.900000095 8.26 7.46 OK 6.300000000000001
5899 5899   2014 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.900000095 8.26 7.46 OR 8.0
6055 6055   2014 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.900000095 8.26 7.46 PA 6.300000000000001
6211 6211   2014 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.900000095 8.26 7.46 RI 7.5
6367 6367   2014 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.900000095 8.26 7.46 SC 7.0
6523 6523   2014 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.900000095 8.26 7.46 SD 8.8
6679 6679   2014 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.900000095 8.26 7.46 TN 8.9
6835 6835   2014 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.900000095 8.26 7.46 TX 8.1
6991 6991   2014 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.900000095 8.26 7.46 UT 7.1000000000000005
7147 7147   2014 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.900000095 8.26 7.46 VA 9.3
7303 7303   2014 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.900000095 8.26 7.46 VT 6.4
7459 7459   2014 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.900000095 8.26 7.46 WA 8.0
7615 7615   2014 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.900000095 8.26 7.46 WI 8.4
7771 7771   2014 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.900000095 8.26 7.46 WV 8.8
7927 7927   2014 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.900000095 8.26 7.46 WY 7.800000000000001

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