South Korean Pollution

Pollutant levels in South Korea

@kaggle.calebreigada_south_korean_pollution

Table List

2 tables(3.32 MB)

South Korean Weather

@kaggle.calebreigada_south_korean_pollution.south_korean_weather

2.92 MB
160046 rows
16 columns

unnamed_0 Unnamed: 0	station STATION	name NAME	latitude LATITUDE	longitude LONGITUDE	elevation ELEVATION	date DATE	liquid_precipitation LIQUID PRECIPITATION	dew DEW	extreme_air_temp EXTREME AIR TEMP	atmospheric_pressure ATMOSPHERIC PRESSURE	sea_level_pressure SEA LEVEL PRESSURE	temp TEMP	vis VIS	wnd WND
	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	12000131	51	120,N,+0024,1	999990100541	101381	441	12000199	270,1,N,0062,1
1	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 06:00:00 GMT+0000 (Coordinated Universal Time)		31	nan	999990100461	101291	721	15000199	270,1,N,0072,1
2	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 09:00:00 GMT+0000 (Coordinated Universal Time)		311	nan	999990100511	101351	651	11000199	270,1,N,0062,1
3	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 12:00:00 GMT+0000 (Coordinated Universal Time)	12000021	31	240,M,+0074,1	999990100711	101551	581	8000199	320,1,N,0051,1
4	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 15:00:00 GMT+0000 (Coordinated Universal Time)		-311	nan	999990100991	101841	301	13000199	340,1,N,0051,1
5	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 18:00:00 GMT+0000 (Coordinated Universal Time)		-711	nan	999990101061	101921	171	18000199	360,1,N,0026,1
6	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Wed Jan 01 2014 21:00:00 GMT+0000 (Coordinated Universal Time)		-461	nan	999990101201	102061	81	20000199	320,1,N,0021,1
7	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Thu Jan 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	12000091	-941	120,N,-0001,1	999990101401	102261	31	20000199	020,1,N,0021,1
8	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Thu Jan 02 2014 03:00:00 GMT+0000 (Coordinated Universal Time)		-941	nan	999990101441	102291	391	20000199	270,1,N,0015,1
9	47112099999	INCHEON, KS	37.4666666	126.6333333	70	Thu Jan 02 2014 06:00:00 GMT+0000 (Coordinated Universal Time)		-621	nan	999990101271	102121	571	20000199	250,1,N,0021,1


CREATE TABLE south_korean_weather (
  "unnamed_0" BIGINT,
  "station" BIGINT,
  "name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" DOUBLE,
  "date" TIMESTAMP,
  "liquid_precipitation" DOUBLE,
  "snow_depth" DOUBLE,
  "dew" BIGINT,
  "extreme_air_temp" VARCHAR,
  "atmospheric_pressure" DOUBLE,
  "sea_level_pressure" BIGINT,
  "temp" BIGINT,
  "vis" BIGINT,
  "wnd" VARCHAR
);