Carbon Monoxide Daily Summary

A summary of daily CO levels from 1990 to 2017

@kaggle.epa_carbon_monoxide

Table List

1 table(177.93 MB)

Epa Co Daily Summary

@kaggle.epa_carbon_monoxide.epa_co_daily_summary

177.93 MB
8064820 rows
29 columns

state_code State Code	county_code County Code	site_num Site Num	parameter_code Parameter Code	poc Poc	latitude Latitude	longitude Longitude	datum Datum	parameter_name Parameter Name	sample_duration Sample Duration	pollutant_standard Pollutant Standard	date_local Date Local	units_of_measure Units Of Measure	event_type Event Type	observation_count Observation Count	observation_percent Observation Percent	arithmetic_mean Arithmetic Mean	first_max_value First Max Value	first_max_hour First Max Hour	aqi Aqi	method_code Method Code	method_name Method Name	local_site_name Local Site Name	address Address	state_name State Name	county_name County Name	city_name City Name	cbsa_name Cbsa Name	date_of_last_change Date Of Last Change
6	73	5	42101	1	33.20265	-117.365925	NAD27	Carbon monoxide	1 HOUR	CO 1-hour 1971	Tue Feb 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	1.129167	1.9	8		66	INSTRUMENTAL - NONDISPERSIVE INFRARED	Oceanside-Mission Ave	1701 MISSION AVE. OCEANSIDE	California	San Diego	Oceanside	San Diego-Carlsbad CA	Wed Apr 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
39	113	28	42101	1	39.787222	-84.226111	NAD83	Carbon monoxide	1 HOUR	CO 1-hour 1971	Mon Apr 29 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.533333	1.2	17		67	INSTRUMENTAL - NONDISPERSIVE INFRARED	FROC	901 WEST FAIRVIEW AVE.	Ohio	Montgomery	Dayton	Dayton OH	Tue Apr 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
30	31	16	42101	1	44.661393	-111.105891	WGS84	Carbon monoxide	1 HOUR	CO 1-hour 1971	Thu May 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	23	96	0.156522	0.3	22		93	INSTRUMENTAL - GAS FILTER CORRELATION CO ANALYZER	West Yellowstone City Center	ALLEY	Montana	Gallatin	West Yellowstone	Bozeman MT	Sun Apr 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
51	13	20	42101	1	38.8577	-77.05922	WGS84	Carbon monoxide	1 HOUR	CO 1-hour 1971	Thu May 05 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.2875	0.8	5		67	INSTRUMENTAL - NONDISPERSIVE INFRARED	Aurora Hills Visitors Center	S 18TH AND HAYES ST	Virginia	Arlington	Arlington	Washington-Arlington-Alexandria DC-VA-MD-WV	Thu Apr 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
6	65	8001	42101	1	33.99958	-117.41601	WGS84	Carbon monoxide	1 HOUR	CO 1-hour 1971	Sun Jun 19 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	23	96	0.321739	0.6	5		67	INSTRUMENTAL - NONDISPERSIVE INFRARED	Rubidoux	5888 MISSION BLVD. RUBIDOUX	California	Riverside	Rubidoux	Riverside-San Bernardino-Ontario CA	Thu Apr 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
32	31	1005	42101	1	39.540917	-119.746761	WGS84	Carbon monoxide	1 HOUR	CO 1-hour 1971	Sat Sep 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.383333	0.8	6		93	INSTRUMENTAL - GAS FILTER CORRELATION CO ANALYZER	Sparks	750 4TH ST SPARKS NV 89431	Nevada	Washoe	Sparks	Reno NV	Sat Apr 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
34	39	3	42101	1	40.662389	-74.214817	WGS84	Carbon monoxide	8-HR RUN AVG END HOUR	CO 8-hour 1971	Mon Jun 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.375	0.4		5		-	Elizabeth	7 Broad Street	New Jersey	Union	Elizabeth	New York-Newark-Jersey City NY-NJ-PA	Fri Mar 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)
23	3	1100	42101	1	46.696431	-68.033006	NAD83	Carbon monoxide	8-HR RUN AVG END HOUR	CO 8-hour 1971	Fri Sep 03 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.1875	0.2		2		-	MICMAC HEALTH DEPARTMENT	8 NORTHERN ROAD PRESQUE ISLE ME 04769	Maine	Aroostook	Presque Isle	nan	Tue Feb 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
48	439	3011	42101	1	32.656357	-97.088585	NAD83	Carbon monoxide	8-HR RUN AVG END HOUR	CO 8-hour 1971	Thu Jul 16 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	0.2	0.2		2		-	Arlington Municipal Airport	5504 South Collins Street	Texas	Tarrant	Arlington	Dallas-Fort Worth-Arlington TX	Mon Apr 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
9	3	17	42101	1	41.769167	-72.670278	WGS84	Carbon monoxide	8-HR RUN AVG END HOUR	CO 8-hour 1971	Sun Jul 20 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Parts per million	nan	24	100	1.008333	1.3		15		-	nan	COURTHOUSE 155 MORGAN STREET	Connecticut	Hartford	Hartford	Hartford-West Hartford-East Hartford CT	Mon Apr 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE epa_co_daily_summary (
  "state_code" BIGINT,
  "county_code" BIGINT,
  "site_num" BIGINT,
  "parameter_code" BIGINT,
  "poc" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datum" VARCHAR,
  "parameter_name" VARCHAR,
  "sample_duration" VARCHAR,
  "pollutant_standard" VARCHAR,
  "date_local" TIMESTAMP,
  "units_of_measure" VARCHAR,
  "event_type" VARCHAR,
  "observation_count" BIGINT,
  "observation_percent" DOUBLE,
  "arithmetic_mean" DOUBLE,
  "first_max_value" DOUBLE,
  "first_max_hour" BIGINT,
  "aqi" DOUBLE,
  "method_code" DOUBLE,
  "method_name" VARCHAR,
  "local_site_name" VARCHAR,
  "address" VARCHAR,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "cbsa_name" VARCHAR,
  "date_of_last_change" TIMESTAMP
);