# Hourly rainfall and gauge history, U.S. cities, 2000–2026

**Compare hourly rainfall with station and gauge history across 27 U.S. cities.** This dataset joins NOAA precipitation observations at 28 sites to historically applicable station locations and equipment records for city-level analysis and machine-learning preparation. Rows are station-hours, with one analysis table per city and an `is_latest` flag for each station's newest available report. It i…

Hourly rainfall and gauge history, U.S. cities, 2000–2026 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: `hourly-rainfall-and-gauge-history-u-s-cities-20002026`
- Canonical page: https://mostlyright.md/datasets/hourly-rainfall-and-gauge-history-u-s-cities-20002026
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-09-14T21:16:48.070Z
- Tables: 27
- 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/hourly-rainfall-and-gauge-history-u-s-cities-20002026`
- Topics: rain gauges, airports, asos, weather stations, united states, central park

## 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: west_palm_beach_hourly

- Table id: `7950ccf9-6ad8-4684-b518-8764917165e7`
- Slug: `west-palm-beach-hourly`
- Immutable version: `bf248ecb-2cf4-5caf-bb77-a7a733527a0b`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/7950ccf9-6ad8-4684-b518-8764917165e7/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/7950ccf9-6ad8-4684-b518-8764917165e7/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/7950ccf9-6ad8-4684-b518-8764917165e7/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/7950ccf9-6ad8-4684-b518-8764917165e7/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: new_orleans_hourly

- Table id: `7502368f-b46c-43f1-8aad-12f9c06473e6`
- Slug: `new-orleans-hourly`
- Immutable version: `bff6a47d-c01f-51e8-9d7d-a97822525e87`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/7502368f-b46c-43f1-8aad-12f9c06473e6/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/7502368f-b46c-43f1-8aad-12f9c06473e6/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/7502368f-b46c-43f1-8aad-12f9c06473e6/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/7502368f-b46c-43f1-8aad-12f9c06473e6/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: atlanta_hourly

- Table id: `7ef3423e-8e54-4971-8f82-fef02711c4c6`
- Slug: `atlanta-hourly`
- Immutable version: `e001957e-a25a-5d12-9cbe-7fedc791f7e6`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/7ef3423e-8e54-4971-8f82-fef02711c4c6/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/7ef3423e-8e54-4971-8f82-fef02711c4c6/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/7ef3423e-8e54-4971-8f82-fef02711c4c6/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/7ef3423e-8e54-4971-8f82-fef02711c4c6/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: oklahoma_city_hourly

- Table id: `7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b`
- Slug: `oklahoma-city-hourly`
- Immutable version: `02a1431c-8c15-5619-a011-45259ddbe6d0`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: san_francisco_hourly

- Table id: `820b0a6c-272d-47d0-97fb-0a6055c1dd6c`
- Slug: `san-francisco-hourly`
- Immutable version: `b047b853-7cb9-5637-99cf-e44574d5dab0`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/820b0a6c-272d-47d0-97fb-0a6055c1dd6c/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/820b0a6c-272d-47d0-97fb-0a6055c1dd6c/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/820b0a6c-272d-47d0-97fb-0a6055c1dd6c/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/820b0a6c-272d-47d0-97fb-0a6055c1dd6c/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: newark_hourly

- Table id: `c6e4e81a-faa3-4240-93c2-ac8784544064`
- Slug: `newark-hourly`
- Immutable version: `d25a8306-0c50-58af-a5a4-368c566b6a2e`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/c6e4e81a-faa3-4240-93c2-ac8784544064/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/c6e4e81a-faa3-4240-93c2-ac8784544064/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/c6e4e81a-faa3-4240-93c2-ac8784544064/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/c6e4e81a-faa3-4240-93c2-ac8784544064/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: san_antonio_hourly

- Table id: `4e2dd927-1dda-4e01-b0d2-a0a4778da723`
- Slug: `san-antonio-hourly`
- Immutable version: `ad855f61-6975-5e9f-b1f6-7624a005e3dd`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/4e2dd927-1dda-4e01-b0d2-a0a4778da723/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/4e2dd927-1dda-4e01-b0d2-a0a4778da723/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/4e2dd927-1dda-4e01-b0d2-a0a4778da723/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/4e2dd927-1dda-4e01-b0d2-a0a4778da723/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: san_diego_hourly

- Table id: `ea9b58db-f773-405b-8090-2eecddb33547`
- Slug: `san-diego-hourly`
- Immutable version: `f71d25c3-2316-5773-81f4-f4d18878ee5a`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/ea9b58db-f773-405b-8090-2eecddb33547/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/ea9b58db-f773-405b-8090-2eecddb33547/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/ea9b58db-f773-405b-8090-2eecddb33547/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/ea9b58db-f773-405b-8090-2eecddb33547/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: dallas_hourly

- Table id: `836440da-703e-4879-93b6-8a00daab49e9`
- Slug: `dallas-hourly`
- Immutable version: `7dbe1b5e-5b79-5d42-a310-602bb02e23a9`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/836440da-703e-4879-93b6-8a00daab49e9/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/836440da-703e-4879-93b6-8a00daab49e9/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/836440da-703e-4879-93b6-8a00daab49e9/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/836440da-703e-4879-93b6-8a00daab49e9/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: phoenix_hourly

- Table id: `5d5d3c34-802e-4d3b-bf29-fb6a604b8772`
- Slug: `phoenix-hourly`
- Immutable version: `b298edf2-13c4-5cac-88b5-fc4369c1fe5b`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/5d5d3c34-802e-4d3b-bf29-fb6a604b8772/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/5d5d3c34-802e-4d3b-bf29-fb6a604b8772/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/5d5d3c34-802e-4d3b-bf29-fb6a604b8772/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/5d5d3c34-802e-4d3b-bf29-fb6a604b8772/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: las_vegas_hourly

- Table id: `3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a`
- Slug: `las-vegas-hourly`
- Immutable version: `612e9b87-0e5c-59c4-9657-4d65cd6a909c`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: minneapolis_hourly

- Table id: `a33c4098-ba6d-4e51-9df9-feae54b1e3c6`
- Slug: `minneapolis-hourly`
- Immutable version: `b69f68c7-be39-5de1-8049-f70a35f3c697`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/a33c4098-ba6d-4e51-9df9-feae54b1e3c6/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/a33c4098-ba6d-4e51-9df9-feae54b1e3c6/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/a33c4098-ba6d-4e51-9df9-feae54b1e3c6/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/a33c4098-ba6d-4e51-9df9-feae54b1e3c6/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: chicago_hourly

- Table id: `48c04cba-1176-444d-ab7e-0aecc5a5daf4`
- Slug: `chicago-hourly`
- Immutable version: `f37b6425-10bf-5de1-be70-bc7717c4de33`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/48c04cba-1176-444d-ab7e-0aecc5a5daf4/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/48c04cba-1176-444d-ab7e-0aecc5a5daf4/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/48c04cba-1176-444d-ab7e-0aecc5a5daf4/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/48c04cba-1176-444d-ab7e-0aecc5a5daf4/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: houston_hourly

- Table id: `f6426770-013e-4d08-8b79-87f1fc504392`
- Slug: `houston-hourly`
- Immutable version: `43b179a2-5616-58c5-b6a0-d69cfc88b084`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f6426770-013e-4d08-8b79-87f1fc504392/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f6426770-013e-4d08-8b79-87f1fc504392/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f6426770-013e-4d08-8b79-87f1fc504392/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f6426770-013e-4d08-8b79-87f1fc504392/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: st_petersburg_hourly

- Table id: `3343523d-6070-4423-999d-e3a0606f6061`
- Slug: `st-petersburg-hourly`
- Immutable version: `9b0719c4-c6a8-593d-9461-007ff2263ff6`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/3343523d-6070-4423-999d-e3a0606f6061/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/3343523d-6070-4423-999d-e3a0606f6061/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/3343523d-6070-4423-999d-e3a0606f6061/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/3343523d-6070-4423-999d-e3a0606f6061/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: seattle_hourly

- Table id: `5e04b0fd-21e5-4c8d-bccd-39e7bce5c672`
- Slug: `seattle-hourly`
- Immutable version: `74aa4b21-7ea4-5381-9d18-444502d4b2a5`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/5e04b0fd-21e5-4c8d-bccd-39e7bce5c672/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/5e04b0fd-21e5-4c8d-bccd-39e7bce5c672/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/5e04b0fd-21e5-4c8d-bccd-39e7bce5c672/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/5e04b0fd-21e5-4c8d-bccd-39e7bce5c672/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: san_jose_hourly

- Table id: `e4364816-e783-4081-bcbf-c06d1d886199`
- Slug: `san-jose-hourly`
- Immutable version: `2eb37d75-a0f1-57d1-9eb4-0215fbef2088`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/e4364816-e783-4081-bcbf-c06d1d886199/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/e4364816-e783-4081-bcbf-c06d1d886199/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/e4364816-e783-4081-bcbf-c06d1d886199/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/e4364816-e783-4081-bcbf-c06d1d886199/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |
| `equipment_record_count` | integer | Number of active precipitation equipment history records, including overlapping observation programs. |

## Table: trenton_hourly

- Table id: `6b45af58-a5ed-4637-b9fc-c62b555a945d`
- Slug: `trenton-hourly`
- Immutable version: `e1bafb51-b5fc-5e5d-bf03-21ed26119b4b`
- Licence: CC0-1.0
- Schema: `GET https://mostlyright.md/api/v2/public/tables/6b45af58-a5ed-4637-b9fc-c62b555a945d/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/6b45af58-a5ed-4637-b9fc-c62b555a945d/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/6b45af58-a5ed-4637-b9fc-c62b555a945d/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/6b45af58-a5ed-4637-b9fc-c62b555a945d/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (27)

| Column | Type | Description |
| --- | --- | --- |
| `station_id` | string | Current canonical station identifier; historical aliases resolve to this station. |
| `city` | string | City associated with the observation station. |
| `state` | string | U.S. state abbreviation. |
| `ghcn_id` | string | NOAA GHCN station identifier. |
| `hour_utc` | timestamp_utc | UTC hour bucket containing the selected report time. |
| `observed_at` | timestamp_utc | Selected report timestamp converted from local standard time to UTC. |
| `reported_local_standard_time` | string | Original NOAA report time in local standard time without daylight saving adjustments. |
| `report_type` | string | SODHP hourly summary preferred; FM-15 routine METAR fallback. |
| `report_source` | string | NOAA source code. |
| `precipitation_raw` | string | Original HourlyPrecipitation token, preserving trace and quality flags. |
| `precipitation_mm` | decimal | Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null. |
| `is_trace` | boolean | True for source trace token T. |
| `quality_status` | string | Missing, trace, numeric, suspect, or unparsed source value. |
| `interval_basis` | string | Summary hourly interval or preceding rolling hour of a routine METAR. |
| `is_latest` | boolean | True for the most recent report hour available for this station. |
| `source_url` | string | NOAA acquisition URL for the source time slice. |
| `snapshot_date` | date | Date this archived source snapshot was requested. |
| `latitude` | decimal | Station latitude effective on the local report date; approximate gauge location. |
| `longitude` | decimal | Station longitude effective on the local report date; approximate gauge location. |
| `coordinate_precision` | string | Published precision code for the historical coordinate. |
| `coordinate_datum` | string | Published horizontal datum. |
| `coordinate_source` | string | Published coordinate evidence source. |
| `location_valid_from` | date | Start of the matched location effective period. |
| `location_valid_to` | date | End of the matched period; null for Present. |
| `metadata_source_url` | string | NOAA HOMR station-history source. |
| `equipment_types` | string | Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history. |

This document was cut at 60 KiB. The complete version is at https://mostlyright.md/datasets/hourly-rainfall-and-gauge-history-u-s-cities-20002026.