Wet Bulb Globe Temperature readings from a network of 14 field sensors. WBGT combines air temperature, humidity and radiant heat into a single measure of heat stress, which is why it is used for athletic and occupational safety thresholds rather than plain air temperature.
| Column | Meaning |
|---|---|
observed_at |
Observation time, UTC |
observed_epoch |
Same instant as a Unix timestamp — use this for range filters |
wet_bulb_c |
Wet bulb temperature, °C |
black_globe_c |
Black globe temperature, °C — the radiant heat component |
air_temp_c |
Dry bulb air temperature, °C |
humidity_pct |
Relative humidity, % |
latitude, longitude |
Sensor position |
device_name |
Which sensor reported |
synced_at |
When the row reached the database |
Filter on observed_epoch, which is indexed:
?observed_epoch__between=1760000000,1762000000&order=-observed_epoch
Filtering on observed_at is not supported — it is a derived column, and a
range scan over it cannot use an index.
Sensors are field hardware and go offline; gaps in the series are expected and are not interpolated. Readings are as-reported with no quality control applied beyond the cleaning already done upstream.
weather/observations543,947 rows · 2025-04-23 18:06:53 to 2026-11-08 04:59:00 UTC · 11 columns
Filter on: device_name, observed_epoch
Sort on: id, observed_epoch
| Column | Type | Null |
|---|---|---|
id | bigint(20) | no |
observed_at | timestamp /* mariadb-5.3 */ | yes |
observed_epoch | int(11) | yes |
wet_bulb_c | decimal(10,1) | yes |
black_globe_c | decimal(10,1) | yes |
air_temp_c | decimal(10,1) | yes |
humidity_pct | decimal(10,1) | yes |
latitude | decimal(9,6) | no |
longitude | decimal(9,6) | no |
device_name | text | no |
synced_at | timestamp | no |
Append __op to any filterable column:
eq (default), ne, lt, lte, gt,
gte, in, prefix, isnull, between.
?data_year__gte=2020&state__in=NJ,NY,PA&order=-inc_date&limit=100
?format=csv
?cursor=<next_cursor from the previous response>