reports_rkpk
Current published release
Current data
Latest passing release for each Table
- Rows
- 66,203
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_rkpk
- Version
- —
- reports_rkpk
Data preview
reports_rkpk| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RKPK | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 30.20 | -1.0 | 14.00 | 50.47 | 310.00 | 4.00 | — | 30.450 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 33.80 | 1.0 | 15.80 | 47.22 | 340.00 | 6.00 | — | 30.470 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 37.40 | 3.0 | 19.40 | 47.80 | 290.00 | 7.00 | — | 30.450 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 41.00 | 5.0 | 19.40 | 41.54 | 310.00 | 9.00 | — | 30.420 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 42.80 | 6.0 | 19.40 | 38.75 | 290.00 | 9.00 | — | 30.390 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T05:00:00.000000Z | METAR | 2020-01-01 | 42.80 | 6.0 | 19.40 | 38.75 | 290.00 | 8.00 | — | 30.390 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T06:00:00.000000Z | METAR | 2020-01-01 | 42.80 | 6.0 | 19.40 | 38.75 | 320.00 | 7.00 | — | 30.390 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T07:00:00.000000Z | METAR | 2020-01-01 | 42.80 | 6.0 | 19.40 | 38.75 | 310.00 | 7.00 | — | 30.390 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T08:00:00.000000Z | METAR | 2020-01-01 | 41.00 | 5.0 | 19.40 | 41.54 | 280.00 | 6.00 | — | 30.390 | — | — | — | — | — | — | — | — |
| RKPK | 2020-01-01T09:00:00.000000Z | METAR | 2020-01-01 | 37.40 | 3.0 | 19.40 | 47.80 | 290.00 | 5.00 | — | 30.420 | — | — | — | — | — | — | — | — |
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: RKPK | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 66,203100.0% |
Top: 2020-01-01 00:00:00+00 · 66,191 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4443.7% |
Top: 2020-08-07 · 65,316 more values | — |
| temp_f | decimal | — | 1.3%857 values | 53<0.1% |
Top: 77.00 · 35,765 more values | Median 62.60P25 48.20 · P75 75.20 |
| temp_c | decimal | — | 1.3%857 values | 53<0.1% |
Top: 25.0 · 35,765 more values | Median 17.0P25 9.0 · P75 24.0 |
| dewpoint_f | decimal | — | 1.3%857 values | 65<0.1% |
Top: 75.20 · 38,737 more values | Median 50.00P25 32.00 · P75 66.20 |
| relative_humidity_pct | decimal | — | 1.3%857 values | 1,9192.9% |
Top: 100.00 · 59,895 more values | Median 68.15P25 50.17 · P75 82.86 |
| wind_direction_degrees | decimal | — | 1.3%830 values | 37<0.1% |
Top: 320.00 · 25,775 more values | Median 200.00P25 70.00 · P75 310.00 |
| wind_speed_kt | decimal | — | 1.3%830 values | 48<0.1% |
Top: 3.00 · 4,808 more values | Median 6.00P25 3.00 · P75 9.00 |
| wind_gust_kt | decimal | — | 95.7%63,345 values | 521.8% |
Top: 20.00 · 505 more values | Median 22.00P25 20.00 · P75 25.00 |
| altimeter_inhg | decimal | — | 1.3%847 values | 1560.2% |
Top: 29.800 · 31,841 more values | Median 29.970P25 29.800 · P75 30.150 |
| sea_level_pressure_hpa | decimal | — | 99.9%66,111 values | 7278.3% |
Top: 1010.40 · 63 more values | Median 1012.00P25 1007.70 · P75 1019.10 |
| sky_cover_1 | string | — | 41.9%27,759 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 46.3%30,670 values | 450.1% |
Top: 3000.00 · 970 more values | Median 3000.00P25 1500.00 · P75 3500.00 |
| sky_cover_2 | string | — | 58.7%38,871 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 58.7%38,873 values | 560.2% |
Top: 20000.00 · 3,869 more values | Median 5000.00P25 2000.00 · P75 18000.00 |
| sky_cover_3 | string | — | 83.9%55,575 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 83.9%55,576 values | 440.4% |
Top: 3000.00 · 1,180 more values | Median 5000.00P25 3000.00 · P75 13000.00 |
| sky_cover_4 | string | — | 99.1%65,594 values | 30.5% |
Top: OVC | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 99.1%65,597 values | 203.3% |
Top: 3000.00 · 29 more values | Median 3000.00P25 3000.00 · P75 10000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | 1.3%870 values | 24<0.1% |
Top: 6.21 · 174 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 85.5%56,596 values | 480.5% |
Top: -RA · 250 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%66,203 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%66,203 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%66,203 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%66,203 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 66,197100.0% |
Top: RKPK 060647Z 06SPECI · 66,185 more values | — |
| cli_product | string | — | 100.0%66,203 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%66,203 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%66,203 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%66,203 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 43<0.1% |
Top: 78.80 · 33,224 more values | Median 71.60P25 57.20 · P75 82.40 |
| metar_low_f | decimal | — | 0.0%0 values | 42<0.1% |
Top: 77.00 · 36,178 more values | Median 53.60P25 39.20 · P75 69.80 |
| metar_high_c | decimal | — | 0.0%0 values | 43<0.1% |
Top: 26.0 · 33,224 more values | Median 22.0P25 14.0 · P75 28.0 |
| metar_low_c | decimal | — | 0.0%0 values | 42<0.1% |
Top: 25.0 · 36,178 more values | Median 12.0P25 4.0 · P75 21.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 66,203
- 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-rkpk.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/2037293c-b5d7-4ca5-8238-96680b925c9a/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2037293c-b5d7-4ca5-8238-96680b925c9a/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2037293c-b5d7-4ca5-8238-96680b925c9a/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.
