U.S. Local Climatological Data (LCD)

National Oceanic and Atmospheric Administration, Department of Commerce

@usgov.noaa_gov_u_s_local_climatological_data_lcd2

Table List

1 table(92.36 KB)

Table 1

@usgov.noaa_gov_u_s_local_climatological_data_lcd2.table_1

This sample data file shows how the data are formatted and is for example purposes only.

92.36 KB
772 rows
86 columns

station STATION	station_name STATION NAME	elevation ELEVATION	latitude LATITUDE	longitude LONGITUDE	date DATE	reporttype ReportType	hourlyskyconditions HourlySkyConditions	hourlyvisibility HourlyVisibility	hourlypresentweathertype HourlyPresentWeatherType	hourlydrybulbtemperaturef HourlyDryBulbTemperatureF	hourlydrybulbtemperaturec HourlyDryBulbTemperatureC	hourlywetbulbtemperaturef HourlyWetBulbTemperatureF	hourlywetbulbtemperaturec HourlyWetBulbTemperatureC	hourlydewpointtemperaturef HourlyDewPointTemperatureF	hourlydewpointtemperaturec HourlyDewPointTemperatureC	hourlyrelativehumidity HourlyRelativeHumidity	hourlywindspeed HourlyWindSpeed	hourlywinddirection HourlyWindDirection	hourlystationpressure HourlyStationPressure	hourlypressuretendency HourlyPressureTendency	hourlypressurechange HourlyPressureChange	hourlysealevelpressure HourlySeaLevelPressure	hourlyprecipitation HourlyPrecipitation	hourlyaltimetersetting HourlyAltimeterSetting	dailysunrise DailySunrise	dailysunset DailySunset	dailyprecipitation DailyPrecipitation	dailysnowdepth DailySnowDepth
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 00:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	SCT:04 70 OVC:08 90	10		30	-1.1	26	-3.4	16	-8.9	56	9	330	29.28			30.02		30	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 01:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	OVC:08 50	10		30	-1.1	26	-3.3	17	-8.3	58		000	29.27			30.02		29.99	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 02:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	OVC:08 29	6	-SN:03 \|SN:71 \|	29	-1.7	26	-3.2	21	-6.1	72	8	330	29.28	1	-0.03	30.02	0.01s	30	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 03:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	VV:09 9	0.75	-SN:03 \|SN:71 \|	28	-2.2	26	-3.3	23	-5	81		000	29.29			30.04	0.03	30.01	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 04:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	OVC:08 8	10		26	-3.3	24	-4.5	20	-6.7	78	11	350	29.32			30.06	0.01	30.04	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 05:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	BKN:07 10 OVC:08 20	10		25	-3.9	22	-5.3	17	-8.3	72	11	360	29.35	3	-0.07	30.09		30.07	1227	2342	0.06	3
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 06:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	BKN:07 12 OVC:08 20	5	HZ:7 \|FU:05 \|HZ:05	23	-5	21	-6.4	15	-9.4	72	7	360	29.37			30.12		30.09	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 07:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	BKN:07 14 OVC:08 25	10		21	-6.1	18	-7.5	12	-11.1	68	11	360	29.42			30.17		30.14	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 08:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	OVC:08 27	9		21	-6.1	18	-7.6	11	-11.7	65	9	360	29.45	2	-0.09	30.19		30.17	1227	2342
WBAN:94846	CHICAGO OHARE INTERNATIONAL AIRPORT IL US	201.8	41.995	-87.9336	Sat Mar 01 2014 09:51:00 GMT+0000 (Coordinated Universal Time)	FM-15	SCT:04 27 OVC:08 35	10		21	-6.1	18	-7.7	10	-12.2	62	9	360	29.46			30.21		30.18	1227	2342


CREATE TABLE table_1 (
  "station" VARCHAR,
  "station_name" VARCHAR,
  "elevation" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date" TIMESTAMP,
  "reporttype" VARCHAR,
  "hourlyskyconditions" VARCHAR,
  "hourlyvisibility" DOUBLE,
  "hourlypresentweathertype" VARCHAR,
  "hourlydrybulbtemperaturef" DOUBLE,
  "hourlydrybulbtemperaturec" DOUBLE,
  "hourlywetbulbtemperaturef" DOUBLE,
  "hourlywetbulbtemperaturec" DOUBLE,
  "hourlydewpointtemperaturef" DOUBLE,
  "hourlydewpointtemperaturec" DOUBLE,
  "hourlyrelativehumidity" DOUBLE,
  "hourlywindspeed" DOUBLE,
  "hourlywinddirection" VARCHAR,
  "hourlywindgustspeed" DOUBLE,
  "hourlystationpressure" DOUBLE,
  "hourlypressuretendency" DOUBLE,
  "hourlypressurechange" DOUBLE,
  "hourlysealevelpressure" VARCHAR,
  "hourlyprecipitation" VARCHAR,
  "hourlyaltimetersetting" DOUBLE,
  "dailymaximumdrybulbtemperature" DOUBLE,
  "dailyminimumdrybulbtemperature" DOUBLE,
  "dailyaveragedrybulbtemperature" DOUBLE,
  "dailydeparturefromnormalaveragetemperature" DOUBLE,
  "dailyaveragerelativehumidity" DOUBLE,
  "dailyaveragedewpointtemperature" VARCHAR,
  "dailyaveragewetbulbtemperature" DOUBLE,
  "dailyheatingdegreedays" DOUBLE,
  "dailycoolingdegreedays" DOUBLE,
  "dailysunrise" BIGINT,
  "dailysunset" BIGINT,
  "dailyprecipitation" VARCHAR,
  "dailysnowfall" VARCHAR,
  "dailysnowdepth" DOUBLE,
  "dailyaveragestationpressure" DOUBLE,
  "dailyaveragesealevelpressure" DOUBLE,
  "dailyaveragewindspeed" DOUBLE,
  "dailypeakwindspeed" DOUBLE,
  "peakwinddirection" DOUBLE,
  "dailysustainedwindspeed" DOUBLE,
  "dailysustainedwinddirection" DOUBLE,
  "monthlymaximumtemperature" VARCHAR,
  "monthlyminimumtemperature" VARCHAR,
  "monthlymeantemperature" VARCHAR,
  "monthlyaveragerh" VARCHAR,
  "monthlydewpointtemperature" VARCHAR,
  "monthlywetbulb" VARCHAR,
  "monthlyheatingdegreedays" VARCHAR,
  "monthlycoolingdegreedays" VARCHAR,
  "monthlystationpressure" VARCHAR,
  "monthlysealevelpressure" VARCHAR,
  "monthlyaveragewindspeed" VARCHAR,
  "monthlytotalsnowfall" VARCHAR,
  "monthlydeparturefromnormalmaximumtemperature" VARCHAR,
  "monthlydeparturefromnormalminimumtemperature" VARCHAR,
  "monthlydeparturefromnormalaveragetemperature" VARCHAR,
  "monthlydeparturefromnormalprecipitation" VARCHAR,
  "monthlytotalliquidprecipitation" VARCHAR,
  "monthlygreatestprecip" VARCHAR,
  "monthlygreatestprecipdate" VARCHAR,
  "monthlygreatestsnowfall" VARCHAR,
  "monthlygreatestsnowfalldate" VARCHAR,
  "monthlygreatestsnowdepth" VARCHAR,
  "monthlygreatestsnowdepthdate" VARCHAR,
  "monthlydayswithgt90temp" VARCHAR,
  "monthlydayswithlt32temp" VARCHAR,
  "monthlydayswithgt32temp" VARCHAR,
  "monthlydayswithlt0temp" VARCHAR,
  "monthlydayswithgt001precip" VARCHAR,
  "monthlydayswithgt010precip" VARCHAR,
  "monthlymaxsealevelpressurevalue" VARCHAR,
  "monthlymaxsealevelpressurevaluedate" VARCHAR,
  "monthlymaxsealevelpressurevaluetime" VARCHAR,
  "monthlyminsealevelpressurevalue" VARCHAR,
  "monthlyminsealevelpressurevaluedate" VARCHAR,
  "monthlyminsealevelpressurevaluetime" VARCHAR,
  "monthlytotalheatingdegreedays" VARCHAR,
  "monthlytotalcoolingdegreedays" VARCHAR,
  "monthlydeparturefromnormalheatingdd" VARCHAR,
  "monthlydeparturefromnormalcoolingdd" VARCHAR
);