{"schema_version":"mostlyright-public-catalog.v1","dataset":{"id":"e16e26f4-bdc6-4714-a21b-ef53f8fc1de9","slug":"hourly-rainfall-and-gauge-history-u-s-cities-20002026","title":"Hourly rainfall and gauge history, U.S. cities, 2000–2026","summary":"**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.\n\nRows are station-hours, with one analysis table per city and an `is_latest` flag for each station's newest available report. It is a delayed archive snapshot, not a real-time feed.\n\n## Coverage\n- Legacy LCD supplements missing LCDv2 years for Austin (2016–2017) and Oklahoma City (2000–2017 and 2019–2022), with metric units and the actual source URL retained.\n- Rainfall window: January 1, 2000 through the latest available NOAA observations at the snapshot cutoff.\n- Location and equipment histories are matched to the local date of each hourly observation, using NOAA effective periods.\n- Main outputs: one joined station-hour table per city. Earlier reference tables are retired.\n- Chicago uses Midway (KMDW). Houston includes Hobby and Bush Intercontinental. New York uses Central Park (KNYC).\n- Coverage includes 27 cities. Eight additional catalog cities remain outside the confirmed station scope.\n- `is_latest` identifies the newest available report for each station. The verified LCDv2 reports currently end September 5, 2026 at 11:00 UTC for most stations; West Palm Beach ends September 1, 2026 at 04:00 UTC; the snapshot was requested on September 14, 2026. This is a delayed archive snapshot, not a real-time feed.\n\n## Columns\n- `station_id`, `city`, `state`: station and location identifiers shared across tables.\n- `observed_at`, `hour_utc`: original report time converted to UTC and its hour bucket.\n- `precipitation_mm`, `precipitation_raw`, `is_trace`: hourly liquid-equivalent precipitation, original value, and trace indicator.\n- `report_type`, `quality_status`: observation method and retained value status.\n- `latitude`, `longitude`, `coordinate_precision`, `coordinate_datum`: published station coordinates and precision metadata.\n- `equipment_types`, `equipment_record_count`: distinct equipment codes and the number of active NOAA precipitation-program records.\n- `location_valid_from`, `location_valid_to`: effective dates of the location joined to each hourly report.\n- `source_url`, `snapshot_date`: source provenance and retrieval snapshot date.\n\n## Missing values\nMissing precipitation remains null, distinct from zero and trace. Hours without a qualifying source report are absent rather than filled with zero. One report is selected per hour: NOAA hourly summaries take priority, with routine METAR rolling-hour reports as fallback; overlapping reports are never summed. Unverified gauge coordinates remain unavailable. Station coordinates are approximate gauge locations, not surveyed gauge positions. A metadata coordinate update does not necessarily mean equipment moved. Equipment history covers 26 stations; Midway and St. Petersburg have no precipitation-equipment history in HOMR. Overlapping program records are retained as distinct equipment codes without multiplying hourly rows. Historical periods may describe predecessor sites and do not establish when a metadata change first became publicly known.\n\n## Suitable for\n- Comparing hourly precipitation across stations\n- Investigating station and instrument changes\n- Preparing city-level machine-learning inputs with historically applicable station metadata\n\n## Source and rights\nNOAA National Centers for Environmental Information supplies [Local Climatological Data (LCDv2 and legacy LCD)](https://www.ncei.noaa.gov/products/land-based-station/local-climatological-data) and the [Historical Observing Metadata Repository](https://www.ncei.noaa.gov/access/homr/). License: CC0-1.0, matching [NOAA’s LCDv2 catalog record](https://catalog.data.gov/dataset/local-climatological-data-lcd-version-2-lcdv2). NOAA station metadata is public-domain federal information. Source links and quality limitations remain attached to records.","topics":["rain gauges","airports","asos","weather stations","united states","central park"],"publisher":{"handle":"mostlyrightmd","display_name":"Mostly Right","avatar_url":"https://mostlyright.md/api/public/avatars/e70f8c973d16894fcee5cb5aba887feafc75cc0d67419bd0ed321cfde9d0d967.webp","mark":{"background":"#FFC613","facets":["#2B5FE3","#F15B22","#17160F"],"pattern":2,"rotation":90}},"star_count":2,"table_count":27,"row_count":6466020,"published_at":"2026-09-14T21:16:48.070Z","updated_at":"2026-10-01T13:41:11.991Z","cover_image_url":"https://storage.googleapis.com/mostlyright-dataset-covers/v1/b5561c84-a4a2-4180-9c69-16a47232cda8/444dcd4fcbdcdb5a9cc94156595b66055ac0c30b1694e77e1d7f3661142cab97.webp","cover_tile_url":"https://storage.googleapis.com/mostlyright-dataset-covers/v1/b5561c84-a4a2-4180-9c69-16a47232cda8/444dcd4fcbdcdb5a9cc94156595b66055ac0c30b1694e77e1d7f3661142cab97.tile.webp","activity":{"views":4151,"likes":2},"canonical_url":"https://mostlyright.md/datasets/hourly-rainfall-and-gauge-history-u-s-cities-20002026","tables":[{"id":"7950ccf9-6ad8-4684-b518-8764917165e7","slug":"west-palm-beach-hourly","title":"west_palm_beach_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"bf248ecb-2cf4-5caf-bb77-a7a733527a0b"},{"id":"7502368f-b46c-43f1-8aad-12f9c06473e6","slug":"new-orleans-hourly","title":"new_orleans_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"bff6a47d-c01f-51e8-9d7d-a97822525e87"},{"id":"7ef3423e-8e54-4971-8f82-fef02711c4c6","slug":"atlanta-hourly","title":"atlanta_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"e001957e-a25a-5d12-9cbe-7fedc791f7e6"},{"id":"7e5118dc-fdb9-4a8a-8dd0-90f676e3f73b","slug":"oklahoma-city-hourly","title":"oklahoma_city_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"02a1431c-8c15-5619-a011-45259ddbe6d0"},{"id":"820b0a6c-272d-47d0-97fb-0a6055c1dd6c","slug":"san-francisco-hourly","title":"san_francisco_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"b047b853-7cb9-5637-99cf-e44574d5dab0"},{"id":"c6e4e81a-faa3-4240-93c2-ac8784544064","slug":"newark-hourly","title":"newark_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"d25a8306-0c50-58af-a5a4-368c566b6a2e"},{"id":"4e2dd927-1dda-4e01-b0d2-a0a4778da723","slug":"san-antonio-hourly","title":"san_antonio_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"ad855f61-6975-5e9f-b1f6-7624a005e3dd"},{"id":"ea9b58db-f773-405b-8090-2eecddb33547","slug":"san-diego-hourly","title":"san_diego_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"f71d25c3-2316-5773-81f4-f4d18878ee5a"},{"id":"836440da-703e-4879-93b6-8a00daab49e9","slug":"dallas-hourly","title":"dallas_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"7dbe1b5e-5b79-5d42-a310-602bb02e23a9"},{"id":"5d5d3c34-802e-4d3b-bf29-fb6a604b8772","slug":"phoenix-hourly","title":"phoenix_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"b298edf2-13c4-5cac-88b5-fc4369c1fe5b"},{"id":"3a8eccd3-5119-43d6-a9c8-66b0e9f43c4a","slug":"las-vegas-hourly","title":"las_vegas_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"612e9b87-0e5c-59c4-9657-4d65cd6a909c"},{"id":"a33c4098-ba6d-4e51-9df9-feae54b1e3c6","slug":"minneapolis-hourly","title":"minneapolis_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"b69f68c7-be39-5de1-8049-f70a35f3c697"},{"id":"48c04cba-1176-444d-ab7e-0aecc5a5daf4","slug":"chicago-hourly","title":"chicago_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"f37b6425-10bf-5de1-be70-bc7717c4de33"},{"id":"f6426770-013e-4d08-8b79-87f1fc504392","slug":"houston-hourly","title":"houston_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"43b179a2-5616-58c5-b6a0-d69cfc88b084"},{"id":"3343523d-6070-4423-999d-e3a0606f6061","slug":"st-petersburg-hourly","title":"st_petersburg_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"9b0719c4-c6a8-593d-9461-007ff2263ff6"},{"id":"5e04b0fd-21e5-4c8d-bccd-39e7bce5c672","slug":"seattle-hourly","title":"seattle_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"74aa4b21-7ea4-5381-9d18-444502d4b2a5"},{"id":"e4364816-e783-4081-bcbf-c06d1d886199","slug":"san-jose-hourly","title":"san_jose_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"2eb37d75-a0f1-57d1-9eb4-0215fbef2088"},{"id":"6b45af58-a5ed-4637-b9fc-c62b555a945d","slug":"trenton-hourly","title":"trenton_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"e1bafb51-b5fc-5e5d-bf03-21ed26119b4b"},{"id":"5504cff2-7c08-496d-b71e-0d8569d383df","slug":"new-york-city-hourly","title":"new_york_city_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"68e8d08b-48fc-5d1f-9891-ca76f0c85122"},{"id":"734f5a32-4dce-49ea-8186-87b7656752ba","slug":"boston-hourly","title":"boston_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA source lookup URL. Advancing observations use their local observation day; exact acquisition windows and digests are in the build receipt.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Latest UTC observation date included in this table snapshot; acquisition timestamps are recorded in the build receipt.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"c3ec337d-6e64-5dfe-a93c-8ba92628b287"},{"id":"06853326-303b-416b-8b2a-2b20465c8b03","slug":"louisville-hourly","title":"louisville_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"0cb63258-74e7-5565-9158-8f208e95e352"},{"id":"b9fc860e-0a94-4a0f-b1de-92a18fb2b84a","slug":"denver-hourly","title":"denver_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"317b1c6a-cf73-54fa-b15e-ba287d085607"},{"id":"665d7e2e-568d-4f45-ad00-b09a937e65d6","slug":"miami-hourly","title":"miami_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"12b9540f-e312-5170-93b8-5637e33db6d1"},{"id":"dc23b222-5b66-478c-9fda-8742305368e1","slug":"washington-dc-hourly","title":"washington_dc_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"c1ce007b-eefd-5240-af28-e2a9e4f7116c"},{"id":"48a299a6-0de3-4cf0-b8fc-f27922999824","slug":"philadelphia-hourly","title":"philadelphia_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"6fd5b693-b4fc-5527-8692-26f99f0bd907"},{"id":"c680aba3-dc97-469c-8935-1e7ef57f1455","slug":"los-angeles-hourly","title":"los_angeles_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"28527e86-4fb3-5157-8dee-57b428518cd4"},{"id":"91666c3b-118f-4001-97d1-cab2d32d5a6c","slug":"austin-hourly","title":"austin_hourly","license":"CC0-1.0","schema":{"columns":27,"column_details":[{"name":"station_id","unit":null,"meaning":"Current canonical station identifier; historical aliases resolve to this station.","nullable":null,"logical_type":"string"},{"name":"city","unit":null,"meaning":"City associated with the observation station.","nullable":null,"logical_type":"string"},{"name":"state","unit":null,"meaning":"U.S. state abbreviation.","nullable":null,"logical_type":"string"},{"name":"ghcn_id","unit":null,"meaning":"NOAA GHCN station identifier.","nullable":null,"logical_type":"string"},{"name":"hour_utc","unit":null,"meaning":"UTC hour bucket containing the selected report time.","nullable":null,"logical_type":"timestamp_utc"},{"name":"observed_at","unit":null,"meaning":"Selected report timestamp converted from local standard time to UTC.","nullable":null,"logical_type":"timestamp_utc"},{"name":"reported_local_standard_time","unit":null,"meaning":"Original NOAA report time in local standard time without daylight saving adjustments.","nullable":null,"logical_type":"string"},{"name":"report_type","unit":null,"meaning":"SODHP hourly summary preferred; FM-15 routine METAR fallback.","nullable":null,"logical_type":"string"},{"name":"report_source","unit":null,"meaning":"NOAA source code.","nullable":null,"logical_type":"string"},{"name":"precipitation_raw","unit":null,"meaning":"Original HourlyPrecipitation token, preserving trace and quality flags.","nullable":null,"logical_type":"string"},{"name":"precipitation_mm","unit":null,"meaning":"Hourly liquid-equivalent precipitation in millimeters; trace or unparseable values remain null.","nullable":null,"logical_type":"decimal"},{"name":"is_trace","unit":null,"meaning":"True for source trace token T.","nullable":null,"logical_type":"boolean"},{"name":"quality_status","unit":null,"meaning":"Missing, trace, numeric, suspect, or unparsed source value.","nullable":null,"logical_type":"string"},{"name":"interval_basis","unit":null,"meaning":"Summary hourly interval or preceding rolling hour of a routine METAR.","nullable":null,"logical_type":"string"},{"name":"is_latest","unit":null,"meaning":"True for the most recent report hour available for this station.","nullable":null,"logical_type":"boolean"},{"name":"source_url","unit":null,"meaning":"NOAA acquisition URL for the source time slice.","nullable":null,"logical_type":"string"},{"name":"snapshot_date","unit":null,"meaning":"Date this archived source snapshot was requested.","nullable":null,"logical_type":"date"},{"name":"latitude","unit":null,"meaning":"Station latitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"longitude","unit":null,"meaning":"Station longitude effective on the local report date; approximate gauge location.","nullable":null,"logical_type":"decimal"},{"name":"coordinate_precision","unit":null,"meaning":"Published precision code for the historical coordinate.","nullable":null,"logical_type":"string"},{"name":"coordinate_datum","unit":null,"meaning":"Published horizontal datum.","nullable":null,"logical_type":"string"},{"name":"coordinate_source","unit":null,"meaning":"Published coordinate evidence source.","nullable":null,"logical_type":"string"},{"name":"location_valid_from","unit":null,"meaning":"Start of the matched location effective period.","nullable":null,"logical_type":"date"},{"name":"location_valid_to","unit":null,"meaning":"End of the matched period; null for Present.","nullable":null,"logical_type":"date"},{"name":"metadata_source_url","unit":null,"meaning":"NOAA HOMR station-history source.","nullable":null,"logical_type":"string"},{"name":"equipment_types","unit":null,"meaning":"Distinct precipitation equipment codes for all active NOAA program records, separated by |; null if no matching history.","nullable":null,"logical_type":"string"},{"name":"equipment_record_count","unit":null,"meaning":"Number of active precipitation equipment history records, including overlapping observation programs.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"b6e8aff4-45b6-53a0-bf98-62c7a373dcac"}]}}