Energy
17 columns
250 rows
8 formats

Meteorological Station Weather Observations

This dataset provides granular, real-time and historical weather observations from utility-owned and commercial weather stations, including temperature, humidity, wind, precipitation, barometric pressure, and solar irradiance. It is ideal for energy grid management, renewable resource forecasting, and climate analytics, offering high spatial and temporal resolution with robust quality controls.

last updated 2 Nov 2025
by GoMask

The brief that made it

Grid management and load forecasting for utilities

Sample rows

preview · 8 of 250 rows · all 17 columns

observation_idstring	data_sourcestring	wind_speed_mpsfloat	station_owner_typestring	station_idstring	station_namestring	station_latitudefloat	station_longitudefloat	station_elevation_mfloat	observation_datetimedatetime	temperature_cfloat	humidity_percentfloat	wind_direction_deginteger	precipitation_mmfloat	barometric_pressure_hpafloat	solar_irradiance_wm2float	quality_flagstring
WX-0001-NY001	station	5.2	utility	NY001	Albany Utility Station	42.6526	-73.7562	95	2024-01-07T14:10:00Z	-6.7	73.4	45	0.8	1018.2	0	valid
WX-0002-CASF	station	3.5	utility	CASF003	San Francisco Downtown	37.7749	-122.4194	16	2024-06-12T11:00:00Z	15.2	61.8	260	0	1013.7	540	valid
WX-0003-TXLGV	commercial service	2.8	commercial	TX-LGV	Longview Commercial Site	32.5007	-94.7405	110	2024-08-21T16:45:00Z	36.4	42.1	185	2.9	1009.9	1240	valid
WX-0004-ILCHI	station	7.9	utility	ILCHI002	Chicago Lakefront	41.8781	-87.6298	181	2024-04-15T08:30:00Z	7.4	81.5	90	6.7	1022.5	120	valid
WX-0005-FLMBH	station	5.7	utility	FLMBH01	Miami Beach Weather	25.7907	-80.13	4	2024-07-02T12:10:00Z	31.9	91.2	128	21.6	1007.6	980	valid
WX-0006-WASEA	station	2.1	utility	WASEA03	Seattle Utility Station	47.6062	-122.3321	56	2024-11-09T18:50:00Z	8.3	88.7	15	3.5	1002.2	47	valid
WX-0007-NVLVG	station	1.9	utility	NVLVG01	Las Vegas Utility Station	36.1699	-115.1398	610	2024-07-24T13:25:00Z	41.7	13.9	225	0	1009.8	1360	valid
WX-0008-MNMIN	station	6.1	utility	MNMIN03	Minneapolis Downtown	44.9778	-93.265	256	2024-02-19T07:15:00Z	-22.5	61.3	314	1.7	1010	blank	valid
WX-0009-ORPOR	commercial service	3.3	commercial	ORPOR05	Portland Commercial	45.5051	-122.675	13	2024-03-10T10:45:00Z	9.3	71	90	4.2	1012.9	235	valid
WX-0010-COBOU	station	7.2	utility	COBOU02	Boulder Utility Station	40.015	-105.2705	1624	2024-05-04T17:40:00Z	18.1	35.6	270	0	912.5	1122	valid
WX-0011-TNNSV	station	1.4	utility	TNNSV01	Nashville Utility Station	36.1627	-86.7816	137	2024-05-21T22:30:00Z	22.8	68.2	33	0.1	1012.1	blank	valid
WX-0012-NJNEW	commercial service	2.6	commercial	NJNEW01	Newark Commercial Site	40.7357	-74.1724	7	2024-09-14T07:30:00Z	18.2	79.6	120	0	1009.2	0	valid
WX-0013-CASD1	station	4.3	utility	CASD001	San Diego North	32.7157	-117.1611	23	2024-08-03T14:00:00Z	29.6	59.4	190	0	1011.5	990	valid
WX-0014-MAHRB	station	5.6	utility	MAHRB01	Harbor Utility Station	42.3601	-71.0589	10	2024-10-23T06:10:00Z	6.2	93.1	60	7.9	1016.2	blank	valid
WX-0015-MDALT	station	4.6	utility	MDALT02	Baltimore Altitude	39.2904	-76.6122	30	2024-04-08T09:20:00Z	13.8	72.5	340	2.3	1018.4	110	valid
WX-0016-TXHOU	commercial service	5.1	commercial	TXHOU01	Houston Commercial	29.7604	-95.3698	12	2024-07-16T15:20:00Z	34.8	78.7	175	24.5	1006.7	1155	valid
WX-0017-COASP	station	8.6	utility	COASP01	Aspen Utility Station	39.1911	-106.8175	2400	2024-02-17T17:10:00Z	-11.2	38.6	305	2.1	890.8	622	valid
WX-0018-ILSPR	commercial service	3.2	commercial	ILSPR02	Springfield Commercial	39.798	-89.6446	187	2024-09-28T23:50:00Z	16.9	81.2	114	2.4	1008.9	blank	valid
WX-0019-MISAG	station	4	utility	MISAG01	Saginaw Utility Station	43.4195	-83.9508	182	2024-10-02T10:35:00Z	10.7	73.9	240	5.6	1015.7	245	valid
WX-0020-GAATL	station	4.8	utility	GAATL01	Atlanta Airport	33.6407	-84.4277	313	2024-06-22T19:55:00Z	29.1	68.5	200	0.7	1012.2	290	valid

What the 250 rows show

from the 250-row sample

Simulator (data source) stands out: mean wind_speed_mps is 40.1, against 5.4 for the rest.

5.6median wind_speed_mps
3quality flags
94.5median station_elevation_m
18.4median temperature_c
69.3median humidity_percent
160median wind_direction_deg

Mean wind_speed_mps by data_source250 rows

wind_speed_mps250 rows, in bands of 20

Median 5.6, from 0.0 to 101.0.

station_owner_type250 rows · 3 values

utility164
commercial80
simulator6

17 columns by typefrom the column list below

string 6
integer 1
float 9
datetime 1

Columns

17 columns in three groups

blueprint · 17 columns
column	type	description	example
Text 6 columns
`observation_id`	string	Unique identifier for each weather observation recordunique	WX-0001-NY001
`station_id`	string	Unique identifier for the weather station where the observation was recorded	NY001
`station_name`	string	Human-readable name of the weather stationoptional	Albany Utility Station
`station_owner_type`	string	Type of station ownership (utility or commercial)utility · commercial	utility
`data_source`	string	Source of the observation data (e.g., station, commercial service)3 sources	station
`quality_flag`	string	Quality control flag for the observation (e.g., valid, suspect, missing)valid · suspect · missing · optional	valid
Numbers 10 columns
`station_latitude`	float	Latitude of the weather station location-90 to 90	42.6526
`station_longitude`	float	Longitude of the weather station location-180 to 180	-73.7562
`station_elevation_m`	float	Elevation of the weather station above sea level, in meters-500 to 9,000 · optional	95
`temperature_c`	float	Ambient air temperature in degrees Celsius-90 to 60	-6.7
`humidity_percent`	float	Relative humidity as a percentage (0-100)0 to 100	73.4
`wind_speed_mps`	float	Wind speed in meters per second0 to 100	5.2
`wind_direction_deg`	integer	Wind direction in degrees (0-359, where 0 = North)0 to 359	45
`precipitation_mm`	float	Total precipitation since last observation, in millimeters0 or more	0.8
`barometric_pressure_hpa`	float	Barometric pressure in hectopascals800 to 1,100	1018.2
`solar_irradiance_wm2`	float	Solar irradiance in watts per square meter0 to 2,000 · optional	0
Dates and times 1 column
`observation_datetime`	datetime	Timestamp of the weather observation (UTC)	2024-01-07T14:10:00Z

Use it for

An energy dashboard
Wind_speed_mps by data_source and a breakdown of station_owner_type. Excel, Power BI or Tableau.
Why do the 44 simulator rows have a mean wind_speed_mps of 40.1?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Observations250
WX-0001-NY0015.2station
WX-0002-CASF3.5station
WX-0003-TXLGV2.8commerci…
A software demo
Believable observations with station_id, station_name and station_owner_type to fill a screen in front of a buyer.

This dataset250 rows17 columns

Yours1,000 rows17 columns

blueprint · meteorological-station-weather-observations

Behind this dataset

Same schema. As many rows as you need.

These 250 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Station ID and geographic location (lat/long, elevation)
Observation timestamp at 5-minute or hourly intervals
Temperature in °F or °C (dry bulb, wet bulb, dew point)
Relative humidity percentage (0-100%)
Wind speed (mph or m/s) and direction (degrees, 0-360)
Precipitation: rainfall (inches/mm), snowfall, snow depth
Barometric pressure (inHg or mbar) for storm tracking
Solar irradiance (W/m²) for solar PV forecasting

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: meteorological-station-weather-observations

What should your data show?

No signup. No card.

Sample rows

What the 250 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?