reports_rksi
Current published release
Current data
Latest passing release for each Table
- Rows
- 117,199
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_rksi
- Version
- —
- reports_rksi
Data preview
reports_rksi| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RKSI | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 26.60 | -3.0 | 17.60 | 68.40 | 100.00 | 5.00 | — | 30.500 | — | OVC | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T00:30:00.000000Z | SPECI | 2020-01-01 | 26.60 | -3.0 | 17.60 | 68.40 | 80.00 | 4.00 | — | 30.500 | — | OVC | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 26.60 | -3.0 | 19.40 | 73.89 | 70.00 | 4.00 | — | 30.500 | — | OVC | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T01:30:00.000000Z | SPECI | 2020-01-01 | 28.40 | -2.0 | 19.40 | 68.61 | 60.00 | 6.00 | — | 30.500 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 28.40 | -2.0 | 21.20 | 74.08 | 70.00 | 4.00 | — | 30.500 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T02:30:00.000000Z | SPECI | 2020-01-01 | 30.20 | -1.0 | 21.20 | 68.83 | 50.00 | 4.00 | — | 30.470 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 30.20 | -1.0 | 21.20 | 68.83 | 140.00 | 3.00 | — | 30.470 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T03:30:00.000000Z | SPECI | 2020-01-01 | 33.80 | 1.0 | 23.00 | 64.23 | 100.00 | 4.00 | — | 30.470 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 33.80 | 1.0 | 23.00 | 64.23 | 170.00 | 3.00 | — | 30.450 | — | BKN | 4000.00 | — | — | — | — | — |
| RKSI | 2020-01-01T04:30:00.000000Z | SPECI | 2020-01-01 | 33.80 | 1.0 | 23.00 | 64.23 | 150.00 | 7.00 | — | 30.450 | — | SCT | 2500.00 | BKN | 20000.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: RKSI | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 117,199100.0% |
Top: 2020-01-01 00:00:00+00 · 117,187 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4442.1% |
Top: 2020-07-28 · 116,614 more values | — |
| temp_f | decimal | — | <0.1%1 values | 54<0.1% |
Top: 77.00 · 70,354 more values | Median 57.20P25 41.00 · P75 71.60 |
| temp_c | decimal | — | <0.1%1 values | 54<0.1% |
Top: 25.0 · 70,354 more values | Median 14.0P25 5.0 · P75 22.0 |
| dewpoint_f | decimal | — | <0.1%1 values | 54<0.1% |
Top: 73.40 · 74,704 more values | Median 46.40P25 30.20 · P75 64.40 |
| relative_humidity_pct | decimal | — | <0.1%1 values | 1,5471.3% |
Top: 100.00 · 106,178 more values | Median 72.92P25 57.41 · P75 86.69 |
| wind_direction_degrees | decimal | — | 0.0%0 values | 37<0.1% |
Top: 320.00 · 57,335 more values | Median 210.00P25 110.00 · P75 300.00 |
| wind_speed_kt | decimal | — | 0.0%0 values | 36<0.1% |
Top: 5.00 · 14,528 more values | Median 7.00P25 4.00 · P75 10.00 |
| wind_gust_kt | decimal | — | 98.9%115,914 values | 383.0% |
Top: 29.00 · 504 more values | Median 28.00P25 23.00 · P75 33.00 |
| altimeter_inhg | decimal | — | 0.0%0 values | 57<0.1% |
Top: 29.830 · 63,576 more values | Median 30.000P25 29.830 · P75 30.210 |
| sea_level_pressure_hpa | decimal | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 48.3%56,608 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 58.6%68,649 values | 46<0.1% |
Top: 3000.00 · 10,043 more values | Median 2000.00P25 800.00 · P75 3000.00 |
| sky_cover_2 | string | — | 73.3%85,944 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 73.3%85,944 values | 590.2% |
Top: 2500.00 · 5,886 more values | Median 5000.00P25 2500.00 · P75 10000.00 |
| sky_cover_3 | string | — | 90.0%105,422 values | 3<0.1% |
Top: OVC | — |
| sky_base_3_ft | decimal | — | 90.0%105,422 values | 350.3% |
Top: 7000.00 · 1,012 more values | Median 7000.00P25 7000.00 · P75 10000.00 |
| sky_cover_4 | string | — | 99.9%117,026 values | 21.2% |
Top: OVC | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 99.9%117,026 values | 105.8% |
Top: 7000.00 | Median 7000.00P25 7000.00 · P75 7000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | <0.1%1 values | 61<0.1% |
Top: 6.21 · 3,410 more values | Median 6.21P25 5.59 · P75 6.21 |
| weather_codes | string | — | 81.7%95,785 values | 820.4% |
Top: BR · 1,267 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%117,199 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 117,199100.0% |
Top: COR RKSI 020800Z 32007KT 270V340 CAVOK 17/04 Q1017 TEMPO 9999 -RA NSC · 117,187 more values | — |
| cli_product | string | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%117,199 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%117,199 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%117,199 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 48<0.1% |
Top: 80.60 · 66,422 more values | Median 66.20P25 48.20 · P75 78.80 |
| metar_low_f | decimal | — | 0.0%0 values | 44<0.1% |
Top: 33.80 · 69,840 more values | Median 50.00P25 33.80 · P75 66.20 |
| metar_high_c | decimal | — | 0.0%0 values | 48<0.1% |
Top: 27.0 · 66,422 more values | Median 19.0P25 9.0 · P75 26.0 |
| metar_low_c | decimal | — | 0.0%0 values | 44<0.1% |
Top: 1.0 · 69,840 more values | Median 10.0P25 1.0 · P75 19.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 117,199
- Columns
- 37
- Published
- 9 Sept 2026, 06:35
- 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-rksi.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/5a225855-ffc7-4381-bf37-f76e4208e020/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/5a225855-ffc7-4381-bf37-f76e4208e020/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/5a225855-ffc7-4381-bf37-f76e4208e020/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.
