Air Quality Data

The Environmental Protection Agency's Air Quality Index (AQI)

@kaggle.yakhyojon_air_quality_data

Table List

1 table(19.47 KB)

C4 Epa Air Quality

@kaggle.yakhyojon_air_quality_data.c4_epa_air_quality

19.47 KB
260 rows
10 columns

unnamed_0 Unnamed: 0	date_local Date Local	state_name State Name	county_name County Name	city_name City Name	local_site_name Local Site Name	parameter_name Parameter Name	units_of_measure Units Of Measure	arithmetic_mean Arithmetic Mean	aqi Aqi
	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Arizona	Maricopa	Buckeye	BUCKEYE	Carbon monoxide	Parts per million	0.473684	7
1	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Ohio	Belmont	Shadyside	Shadyside	Carbon monoxide	Parts per million	0.263158	5
2	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Wyoming	Teton	Not in a city	Yellowstone National Park - Old Faithful Snow Lodge	Carbon monoxide	Parts per million	0.111111	2
3	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Pennsylvania	Philadelphia	Philadelphia	North East Waste (NEW)	Carbon monoxide	Parts per million	0.3	3
4	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Iowa	Polk	Des Moines	CARPENTER	Carbon monoxide	Parts per million	0.215789	3
5	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Hawaii	Honolulu	Not in a city	Kapolei	Carbon monoxide	Parts per million	0.994737	14
6	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Hawaii	Honolulu	Not in a city	Kapolei	Carbon monoxide	Parts per million	0.2	2
7	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Pennsylvania	Erie	Erie	nan	Carbon monoxide	Parts per million	0.2	2
8	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Hawaii	Honolulu	Honolulu	Honolulu	Carbon monoxide	Parts per million	0.4	5
9	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Colorado	Larimer	Fort Collins	Fort Collins - CSU - S. Mason	Carbon monoxide	Parts per million	0.3	6


CREATE TABLE c4_epa_air_quality (
  "unnamed_0" BIGINT,
  "date_local" TIMESTAMP,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "local_site_name" VARCHAR,
  "parameter_name" VARCHAR,
  "units_of_measure" VARCHAR,
  "arithmetic_mean" DOUBLE,
  "aqi" BIGINT
);