# US Weather Reports and Daily Highs in 20 Cities

**Compare airport weather reports with official daily highs and lows in 20 United States cities.** Each city has its own table of METAR and SPECI observations since 2020, joined to the National Weather Service daily result for that station's standard-time date. Use it to evaluate daily temperature forecasts or train models from conditions observed so far. Rows are report-level, usually hourly wit…

US Weather Reports and Daily Highs in 20 Cities is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-weather-reports-and-daily-highs-in-20-cities`
- Canonical page: https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-09-12T09:15:44.352Z
- Tables: 20
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-weather-reports-and-daily-highs-in-20-cities`
- Topics: weather, united states, metar, national weather service, daily high temperature, hourly observations, 20 cities

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and nothing else: no filter, sort, search, download or page past row 500.
3. Sign in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: reports_kphl

- Table id: `f38ee271-11bc-4803-a2fc-37287440e519`
- Slug: `reports-kphl`
- Immutable version: `ea28d6c8-da66-5d6f-9e0e-bbc62a438749`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f38ee271-11bc-4803-a2fc-37287440e519/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_khou

- Table id: `9382176f-6ad8-47fe-b4b6-8c423a09ac1f`
- Slug: `reports-khou`
- Immutable version: `17996ea2-3519-556c-89ba-25eb5ae8b0a0`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/9382176f-6ad8-47fe-b4b6-8c423a09ac1f/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kdca

- Table id: `b13df66e-c104-4c12-8b18-71c5f30b775a`
- Slug: `reports-kdca`
- Immutable version: `83ec349e-dfe3-5bb3-a493-d7b05246ecc8`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/b13df66e-c104-4c12-8b18-71c5f30b775a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_knyc

- Table id: `cdc8c2aa-4ccd-43da-ac53-90b2850121cb`
- Slug: `reports-knyc`
- Immutable version: `65a9dde1-60ef-5b63-adad-8b4fa02c38f8`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/cdc8c2aa-4ccd-43da-ac53-90b2850121cb/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_katl

- Table id: `6509f331-30e7-4593-bae6-a1f7aaba0159`
- Slug: `reports-katl`
- Immutable version: `b3e94f3e-d960-54c4-9b7f-f288998b2932`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/6509f331-30e7-4593-bae6-a1f7aaba0159/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kphx

- Table id: `77031a86-8bbb-4217-a7a0-2758ac77d561`
- Slug: `reports-kphx`
- Immutable version: `3671f6ad-43be-5a64-a073-6f89d40ab29c`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/77031a86-8bbb-4217-a7a0-2758ac77d561/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (32)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_ksea

- Table id: `da9c5982-e772-414c-bcc5-e35e816420fc`
- Slug: `reports-ksea`
- Immutable version: `4b2800f8-65f7-5491-b00d-c124312d19f8`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/da9c5982-e772-414c-bcc5-e35e816420fc/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_ksfo

- Table id: `f290a279-c39c-4bc7-8e04-974e0bcd480a`
- Slug: `reports-ksfo`
- Immutable version: `97238273-943e-51e2-b54a-145eaa2a41b5`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f290a279-c39c-4bc7-8e04-974e0bcd480a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (32)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kdfw

- Table id: `ed9260f8-0253-423f-9ba1-ce58a8632702`
- Slug: `reports-kdfw`
- Immutable version: `3ac25f11-eb15-5f97-8fce-49a86ea74042`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kmsp

- Table id: `aea40995-a418-4eee-a004-bd0b23ced5cd`
- Slug: `reports-kmsp`
- Immutable version: `3b1654c9-2437-5cb5-a9f5-db0061dd33f2`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/aea40995-a418-4eee-a004-bd0b23ced5cd/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_ksat

- Table id: `bd6885b8-9935-4cd2-bcc7-620fc83d9ff0`
- Slug: `reports-ksat`
- Immutable version: `b7197e4d-c051-568b-bc85-032e25ab4725`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/bd6885b8-9935-4cd2-bcc7-620fc83d9ff0/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kden

- Table id: `779b3250-90d2-4d72-9d90-e7275da1c2c0`
- Slug: `reports-kden`
- Immutable version: `0f75b7b1-678b-5e09-892b-df5096f35d52`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/779b3250-90d2-4d72-9d90-e7275da1c2c0/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_klax

- Table id: `1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20`
- Slug: `reports-klax`
- Immutable version: `91ac454e-5d38-54c0-bf37-a19ef40bad42`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/1d64b41d-ffdc-4b0d-b6b4-1a1a03ec8d20/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kmdw

- Table id: `1933e0be-5f4a-47e9-9085-f95a898a64fa`
- Slug: `reports-kmdw`
- Immutable version: `312b65ee-d36e-5e26-8cec-a347f2d3b1c7`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/1933e0be-5f4a-47e9-9085-f95a898a64fa/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kokc

- Table id: `fdfd9aee-c524-409e-b387-23a11aae653d`
- Slug: `reports-kokc`
- Immutable version: `3638fed7-499c-51b4-a3bc-27286930d096`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kbos

- Table id: `d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c`
- Slug: `reports-kbos`
- Immutable version: `ad399af4-e19b-53ef-88e6-adbf937f1b63`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/d6fb2d0f-1843-45fe-a3b2-e9217a35cb1c/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |
| `cli_high_f` | integer | Official NWS daily maximum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_low_f` | integer | Official NWS daily minimum temperature for the report's climate date, degrees Fahrenheit. |
| `cli_report_type` | string | NWS report version inferred from issue time: preliminary, final, or correction. |

## Table: reports_kmsy

- Table id: `b7e704f9-a128-4ff0-bded-52d062d2406e`
- Slug: `reports-kmsy`
- Immutable version: `9d748811-345c-5413-babd-a5fc5b25bc20`
- Licence: CC-BY-4.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/b7e704f9-a128-4ff0-bded-52d062d2406e/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (33)

| Column | Type | Description |
| --- | --- | --- |
| `station` | string | ICAO code of the reporting station. |
| `event_time_utc` | timestamp_utc | Report time in UTC. |
| `observation_type` | string | METAR for a routine report, SPECI for a special report. |
| `local_standard_date` | date | Climate date on the station's fixed standard-time offset; daylight saving time is not applied. |
| `temp_f` | decimal | Air temperature, degrees Fahrenheit. |
| `dewpoint_f` | decimal | Dew-point temperature, degrees Fahrenheit. |
| `relative_humidity_pct` | decimal | Relative humidity, percent. |
| `wind_direction_degrees` | decimal | Wind direction clockwise from true north, degrees. |
| `wind_speed_kt` | decimal | Sustained wind speed, knots. |
| `wind_gust_kt` | decimal | Reported wind gust, knots. |
| `altimeter_inhg` | decimal | Altimeter setting, inches of mercury. |
| `sea_level_pressure_hpa` | decimal | Sea-level pressure, hectopascals. |
| `sky_cover_1` | string | First sky-cover layer code. |
| `sky_base_1_ft` | decimal | First sky-layer base, feet above ground. |
| `sky_cover_2` | string | Second sky-cover layer code. |
| `sky_base_2_ft` | decimal | Second sky-layer base, feet above ground. |
| `sky_cover_3` | string | Third sky-cover layer code. |
| `sky_base_3_ft` | decimal | Third sky-layer base, feet above ground. |
| `sky_cover_4` | string | Fourth sky-cover layer code. |
| `sky_base_4_ft` | decimal | Fourth sky-layer base, feet above ground. |
| `visibility_miles` | decimal | Horizontal visibility, statute miles. |
| `weather_codes` | string | Present-weather codes from the report. |
| `precipitation_in_1h` | decimal | Reported one-hour precipitation accumulation, inches; intervals can overlap. |
| `peak_wind_gust_kt` | decimal | Peak-wind gust from report remarks, knots. |
| `peak_wind_direction_degrees` | decimal | Peak-wind direction from report remarks, degrees. |
| `peak_wind_time` | string | Peak-wind time as reported. |
| `snow_depth_inches` | decimal | Reported snow depth, inches. |
| `raw_metar` | string | Original METAR or SPECI report text. |
| `valid` | string | Report time in UTC exactly as the Iowa Environmental Mesonet publishes it (YYYY-MM-DD HH:MM); refreshes replace whole days keyed on it. |
| `cli_product` | string | NWS CLI product identifier the day's official values came from; null when no report was archived for the date. |

This document was cut at 60 KiB. The complete version is at https://mostlyright.md/datasets/us-weather-reports-and-daily-highs-in-20-cities.