reports_rctp
Current published release
Current data
Latest passing release for each Table
- Rows
- 131,919
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_rctp
- Version
- —
- reports_rctp
Data preview
reports_rctp| station | event_time_utc | observation_type | local_standard_date | temp_f | temp_c | dewpoint_f | relative_humidity_pct | wind_direction_degrees | wind_speed_kt | wind_gust_kt | altimeter_inhg | sea_level_pressure_hpa | sky_cover_1 | sky_base_1_ft | sky_cover_2 | sky_base_2_ft | sky_cover_3 | sky_base_3_ft | sky_cover_4 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RCTP | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 60.80 | 16.0 | 55.40 | 82.37 | 60.00 | 15.00 | — | 30.360 | — | FEW | 1200.00 | BKN | 2000.00 | BKN | 3500.00 | — |
| RCTP | 2020-01-01T00:30:00.000000Z | SPECI | 2020-01-01 | 60.80 | 16.0 | 55.40 | 82.37 | 50.00 | 17.00 | — | 30.360 | — | FEW | 1200.00 | BKN | 2000.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 60.80 | 16.0 | 55.40 | 82.37 | 60.00 | 18.00 | — | 30.390 | — | FEW | 1200.00 | BKN | 2000.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T01:30:00.000000Z | SPECI | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 16.00 | — | 30.390 | — | FEW | 1200.00 | BKN | 2500.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 17.00 | — | 30.390 | — | FEW | 1200.00 | BKN | 2500.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T02:30:00.000000Z | SPECI | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 18.00 | — | 30.390 | — | FEW | 1200.00 | BKN | 2500.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 19.00 | — | 30.360 | — | FEW | 1200.00 | BKN | 2200.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T03:30:00.000000Z | SPECI | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 20.00 | — | 30.360 | — | FEW | 1200.00 | BKN | 2200.00 | BKN | 5000.00 | — |
| RCTP | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 19.00 | — | 30.330 | — | FEW | 1200.00 | BKN | 2200.00 | BKN | 4000.00 | — |
| RCTP | 2020-01-01T04:30:00.000000Z | SPECI | 2020-01-01 | 62.60 | 17.0 | 55.40 | 77.29 | 50.00 | 19.00 | — | 30.330 | — | FEW | 1200.00 | BKN | 2500.00 | BKN | 4000.00 | — |
Columns
Schema, units, meaning, and verified release profile
| Column | Type | Unit | Missing | Distinct | Distribution | Summary |
|---|---|---|---|---|---|---|
| station | string | — | 0.0%0 values | 1<0.1% |
Top: RCTP | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 131,919100.0% |
Top: 2020-01-01 00:00:00+00 · 131,907 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: SPECI | — |
| local_standard_date | date | — | 0.0%0 values | 2,4441.9% |
Top: 2025-07-25 · 130,856 more values | — |
| temp_f | decimal | — | 0.0%0 values | 34<0.1% |
Top: 82.40 · 48,467 more values | Median 75.20P25 66.20 · P75 82.40 |
| temp_c | decimal | — | 0.0%0 values | 34<0.1% |
Top: 28.0 · 48,467 more values | Median 24.0P25 19.0 · P75 28.0 |
| dewpoint_f | decimal | — | 0.0%0 values | 32<0.1% |
Top: 77.00 · 33,967 more values | Median 69.80P25 60.80 · P75 77.00 |
| relative_humidity_pct | decimal | — | 0.0%0 values | 6830.5% |
Top: 100.00 · 103,768 more values | Median 83.09P25 72.20 · P75 93.55 |
| wind_direction_degrees | decimal | — | 4.9%6,445 values | 37<0.1% |
Top: 40.00 · 40,605 more values | Median 70.00P25 40.00 · P75 230.00 |
| wind_speed_kt | decimal | — | 0.0%0 values | 44<0.1% |
Top: 5.00 · 46,929 more values | Median 10.00P25 6.00 · P75 16.00 |
| wind_gust_kt | decimal | — | 94.8%125,068 values | 450.7% |
Top: 30.00 · 1,364 more values | Median 30.00P25 27.00 · P75 33.00 |
| altimeter_inhg | decimal | — | 0.0%0 values | 65<0.1% |
Top: 29.800 · 52,079 more values | Median 29.910P25 29.770 · P75 30.060 |
| sea_level_pressure_hpa | decimal | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 0.6%793 values | 5<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 0.6%793 values | 29<0.1% |
Top: 1500.00 · 3,436 more values | Median 1500.00P25 800.00 · P75 1500.00 |
| sky_cover_2 | string | — | 17.4%22,971 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 17.4%22,971 values | 77<0.1% |
Top: 20000.00 · 44,086 more values | Median 2500.00P25 1200.00 · P75 7000.00 |
| sky_cover_3 | string | — | 50.9%67,083 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 50.9%67,083 values | 720.1% |
Top: 2000.00 · 19,414 more values | Median 3000.00P25 1800.00 · P75 6000.00 |
| sky_cover_4 | string | — | 97.9%129,167 values | 30.1% |
Top: BKN | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 97.9%129,167 values | 351.3% |
Top: 2000.00 · 446 more values | Median 3500.00P25 2000.00 · P75 6000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | <0.1%13 values | 42<0.1% |
Top: 6.21 · 2,178 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 75.1%99,119 values | 440.1% |
Top: -RA · 1,742 more values | — |
| precipitation_in_1h | decimal | — | 0.0%0 values | 1<0.1% |
Top: 0.000 | Median 0.000P25 0.000 · P75 0.000 |
| peak_wind_gust_kt | decimal | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 131,919100.0% |
Top: COR RCTP 010842Z 27018KT 7000 -RA SCT006 BKN010 BKN015 23/22 Q1009 WS R23R NOSIG RMK A2981 · 131,907 more values | — |
| cli_product | string | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%131,919 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%131,919 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%131,919 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 31<0.1% |
Top: 93.20 · 48,031 more values | Median 80.60P25 71.60 · P75 91.40 |
| metar_low_f | decimal | — | 0.0%0 values | 25<0.1% |
Top: 80.60 · 34,058 more values | Median 71.60P25 60.80 · P75 78.80 |
| metar_high_c | decimal | — | 0.0%0 values | 31<0.1% |
Top: 34.0 · 48,031 more values | Median 27.0P25 22.0 · P75 33.0 |
| metar_low_c | decimal | — | 0.0%0 values | 25<0.1% |
Top: 27.0 · 34,058 more values | Median 22.0P25 16.0 · P75 26.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 131,919
- Columns
- 37
- Published
- 9 Sept 2026, 07:21
- Analytics
- Verified across all rows
Use dataset
Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.
# Current release — the complete Parquet file
curl -sS -o reports-rctp.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/f81bced2-6d73-49fa-9ee3-0a43fe5e4f9a/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/f81bced2-6d73-49fa-9ee3-0a43fe5e4f9a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/f81bced2-6d73-49fa-9ee3-0a43fe5e4f9a/query" \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
-H "content-type: application/json" \
--data '{"columns": ["station","event_time_utc"], "limit": 100}'MOSTLYRIGHT_API_KEY requires an mr_use_ API key from a workspace that has added this dataset. An mr_live_ key will not work here. Reference: OpenAPI · guide.
