NHSPI_domains_subdomains

Table actions

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

51 rows where Item Description = "Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment." and Lower CI = "4.57"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
155 155   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 AK 6.300000000000001
311 311   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 AL 3.7
467 467   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 AR 3.3000000000000003
623 623   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 AZ 5.300000000000001
779 779   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 CA 7.2
935 935   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 CO 5.800000000000001
1091 1091   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 CT 7.2
1247 1247   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 DC 3.7
1403 1403   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 DE 6.2
1559 1559   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 FL 8.8
1715 1715   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 GA 4.5
1871 1871   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 HI 4.3
2027 2027   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 IA 3.9000000000000004
2183 2183   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 ID 4.7
2339 2339   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 IL 3.5
2495 2495   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 IN 4.0
2651 2651   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 KS 4.9
2807 2807   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 KY 4.2
2963 2963   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 LA 6.5
3119 3119   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MA 7.300000000000001
3275 3275   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MD 8.3
3431 3431   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 ME 7.300000000000001
3587 3587   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MI 4.2
3743 3743   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MN 4.1000000000000005
3899 3899   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MO 3.4000000000000004
4055 4055   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MS 4.6000000000000005
4211 4211   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 MT 4.9
4367 4367   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NC 5.0
4523 4523   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 ND 3.3000000000000003
4679 4679   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NE 4.4
4835 4835   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NH 6.2
4991 4991   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NJ 6.1000000000000005
5147 5147   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NM 3.9000000000000004
5303 5303   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NV 5.6000000000000005
5459 5459   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 NY 5.2
5615 5615   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 OH 3.9000000000000004
5771 5771   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 OK 3.7
5927 5927   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 OR 7.300000000000001
6083 6083   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 PA 4.800000000000001
6239 6239   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 RI 3.0
6395 6395   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 SC 6.1000000000000005
6551 6551   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 SD 2.7
6707 6707   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 TN 4.4
6863 6863   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 TX 5.7
7019 7019   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 UT 5.0
7175 7175   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 VA 6.7
7331 7331   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 VT 6.4
7487 7487   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 WA 8.9
7643 7643   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 WI 6.2
7799 7799   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 WV 2.7
7955 7955   2013 PEI Subdomain Active EOH PEI Physical Environment and Infrastructure Actions taken to reduce health hazards in the physical environment, including elements of the natural and built environment. 5.199999809 5.74 4.57 WY 3.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
);