reports_kokc
Release V4 publication snapshot
Current data
Latest passing release for each Table
- Rows
- 67,777
- across released Tables
- Tables
- 1
- released
- Columns
- 32
- reports_kokc
- Version
- V4 publication snapshot
- reports_kokc
Data preview
reports_kokc| station | event_time_utc | observation_type | local_standard_date | temp_f | 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 | sky_base_4_ft | visibility_miles | weather_codes | precipitation_in_1h | peak_wind_gust_kt | peak_wind_direction_degrees | peak_wind_time | snow_depth_inches | raw_metar | cli_product | cli_high_f | cli_low_f | cli_report_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KOKC | 2020-01-01T00:52:00.000000Z | METAR | 2019-12-31 | 37.00 | 19.90 | 49.61 | 220.00 | 4.00 | — | 30.080 | 1019.60 | CLR | — | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010052Z 22004KT 10SM CLR 03/M07 A3008 RMK AO2 SLP196 T00281067 $ | — | — | — | — |
| KOKC | 2020-01-01T01:52:00.000000Z | METAR | 2019-12-31 | 37.00 | 19.90 | 49.61 | 220.00 | 4.00 | — | 30.070 | 1019.20 | CLR | — | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010152Z 22004KT 10SM CLR 03/M07 A3007 RMK AO2 SLP192 T00281067 $ | — | — | — | — |
| KOKC | 2020-01-01T02:52:00.000000Z | METAR | 2019-12-31 | 34.00 | 21.00 | 58.56 | 200.00 | 6.00 | — | 30.060 | 1018.80 | CLR | — | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010252Z 20006KT 10SM CLR 01/M06 A3006 RMK AO2 SLP188 T00111061 58008 $ | — | — | — | — |
| KOKC | 2020-01-01T03:52:00.000000Z | METAR | 2019-12-31 | 32.00 | 21.90 | 65.92 | 190.00 | 6.00 | — | 30.050 | 1018.50 | CLR | — | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010352Z 19006KT 10SM CLR 00/M06 A3005 RMK AO2 SLP185 T00001056 $ | — | — | — | — |
| KOKC | 2020-01-01T04:52:00.000000Z | METAR | 2019-12-31 | 32.00 | 21.90 | 65.92 | 180.00 | 5.00 | — | 30.050 | 1018.20 | CLR | — | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010452Z 18005KT 10SM CLR 00/M06 A3005 RMK AO2 SLP182 T00001056 $ | — | — | — | — |
| KOKC | 2020-01-01T05:52:00.000000Z | METAR | 2019-12-31 | 32.00 | 23.00 | 69.04 | 170.00 | 7.00 | — | 30.020 | 1017.10 | FEW | 25000.00 | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010552Z 17007KT 10SM FEW250 00/M05 A3002 RMK AO2 SLP171 T00001050 10044 20000 401061050 58012 $ | — | — | — | — |
| KOKC | 2020-01-01T06:52:00.000000Z | METAR | 2020-01-01 | 32.00 | 23.00 | 69.04 | 170.00 | 7.00 | — | 30.000 | 1016.20 | FEW | 25000.00 | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010652Z 17007KT 10SM FEW250 00/M05 A3000 RMK AO2 SLP162 T00001050 $ | CLIOKC | 56 | 30 | final |
| KOKC | 2020-01-01T07:52:00.000000Z | METAR | 2020-01-01 | 32.00 | 23.00 | 69.04 | 180.00 | 7.00 | — | 29.980 | 1015.50 | FEW | 25000.00 | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010752Z 18007KT 10SM FEW250 00/M05 A2998 RMK AO2 SLP155 T00001050 $ | CLIOKC | 56 | 30 | final |
| KOKC | 2020-01-01T08:52:00.000000Z | METAR | 2020-01-01 | 30.00 | 23.00 | 74.87 | 180.00 | 10.00 | — | 29.960 | 1014.90 | FEW | 25000.00 | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010852Z 18010KT 10SM FEW250 M01/M05 A2996 RMK AO2 SLP149 T10111050 56020 $ | CLIOKC | 56 | 30 | final |
| KOKC | 2020-01-01T09:52:00.000000Z | METAR | 2020-01-01 | 34.00 | 23.00 | 63.72 | 170.00 | 7.00 | — | 29.950 | 1014.40 | FEW | 25000.00 | — | — | — | — | — | — | 10.00 | — | 0.000 | — | — | — | — | KOKC 010952Z 17007KT 10SM FEW250 01/M05 A2995 RMK AO2 SLP144 T00111050 $ | CLIOKC | 56 | 30 | final |
Columns
Schema, units, meaning, and verified release profile
| Column | Type | Unit | Missing | Distinct | Distribution | Summary |
|---|---|---|---|---|---|---|
| station0 source inputs · 4 transformations | string | — | 0.0%0 values | 1<0.1% |
Top: KOKC | — |
| event_time_utc0 source inputs · 4 transformations | timestamp_utc | — | 0.0%0 values | 67,775100.0% | 2020-01-012026-01-01 per year All rows, per year | — |
| observation_type0 source inputs · 4 transformations | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date0 source inputs · 4 transformations | date | — | 0.0%0 values | 2,4383.6% | 2019-01-012026-01-01 per year All rows, per year | — |
| temp_f0 source inputs · 4 transformations | decimal | — | <0.1%9 values | 1810.3% | -11.00110.00 All-row histogram | Median 63.00P25 48.00 · P75 75.00 |
| dewpoint_f0 source inputs · 4 transformations | decimal | — | <0.1%10 values | 1540.2% | -18.0081.00 All-row histogram | Median 52.00P25 34.00 · P75 64.00 |
| relative_humidity_pct0 source inputs · 4 transformations | decimal | — | <0.1%10 values | 4,9577.3% | 8.98100.00 All-row histogram | Median 69.63P25 51.10 · P75 86.06 |
| wind_direction_degrees0 source inputs · 4 transformations | decimal | — | 1.5%1,015 values | 39<0.1% | 0.00360.00 All-row histogram | Median 170.00P25 110.00 · P75 210.00 |
| wind_speed_kt0 source inputs · 4 transformations | decimal | — | 0.1%73 values | 44<0.1% | 0.0052.00 All-row histogram | Median 9.00P25 6.00 · P75 13.00 |
| wind_gust_kt0 source inputs · 4 transformations | decimal | — | 80.7%54,708 values | 500.4% | 11.0065.00 All-row histogram | Median 25.00P25 21.00 · P75 28.00 |
| altimeter_inhg0 source inputs · 4 transformations | decimal | — | <0.1%1 values | 1480.2% | 29.25030.730 All-row histogram | Median 30.000P25 29.890 · P75 30.120 |
| sea_level_pressure_hpa0 source inputs · 4 transformations | decimal | — | 14.2%9,625 values | 5140.9% | 989.601042.40 All-row histogram | Median 1015.00P25 1011.10 · P75 1019.60 |
| sky_cover_10 source inputs · 4 transformations | string | — | <0.1%4 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft0 source inputs · 4 transformations | decimal | — | 16.7%11,344 values | 810.1% | 0.0030000.00 All-row histogram | Median 6000.00P25 1800.00 · P75 20000.00 |
| sky_cover_20 source inputs · 4 transformations | string | — | 57.4%38,891 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft0 source inputs · 4 transformations | decimal | — | 57.4%38,891 values | 810.3% | 100.0030000.00 All-row histogram | Median 15000.00P25 4700.00 · P75 25000.00 |
| sky_cover_30 source inputs · 4 transformations | string | — | 82.3%55,759 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft0 source inputs · 4 transformations | decimal | — | 82.3%55,759 values | 720.6% | 1100.0030000.00 All-row histogram | Median 18000.00P25 8000.00 · P75 25000.00 |
| sky_cover_40 source inputs · 4 transformations | string | — | 96.8%65,601 values | 40.2% |
Top: BKN | — |
| sky_base_4_ft0 source inputs · 4 transformations | decimal | — | 96.8%65,601 values | 150.7% | 13000.0030000.00 All-row histogram | Median 25000.00P25 20000.00 · P75 25000.00 |
Show 12 more columns
| visibility_miles0 source inputs · 4 transformations | decimal | — | <0.1%7 values | 20<0.1% | 0.0010.00 All-row histogram | Median 10.00P25 10.00 · P75 10.00 |
|---|---|---|---|---|---|---|
| weather_codes0 source inputs · 4 transformations | string | — | 84.7%57,421 values | 1401.4% |
Top: BR · 1,912 more values | — |
| precipitation_in_1h0 source inputs · 4 transformations | decimal | — | 6.6%4,469 values | 1210.2% | 0.0002.680 All-row histogram | Median 0.000P25 0.000 · P75 0.000 |
| peak_wind_gust_kt0 source inputs · 4 transformations | decimal | — | 87.1%59,048 values | 370.4% | 26.0065.00 All-row histogram | Median 29.00P25 27.00 · P75 33.00 |
| peak_wind_direction_degrees0 source inputs · 4 transformations | decimal | — | 87.1%59,048 values | 360.4% | 10.00360.00 All-row histogram | Median 190.00P25 160.00 · P75 320.00 |
| peak_wind_time0 source inputs · 4 transformations | string | — | 87.1%59,048 values | 7,49785.9% | 7,497 distinct values, no chart No shape worth drawing · 8,729 more values | — |
| snow_depth_inches0 source inputs · 4 transformations | decimal | — | 99.8%67,621 values | 117.1% | 0.0010.00 All-row histogram | Median 2.00P25 0.00 · P75 5.00 |
| raw_metar0 source inputs · 4 transformations | string | — | 0.0%0 values | 67,777100.0% | 67,777 distinct values, no chart No shape worth drawing · 67,777 more values | — |
| cli_product0 source inputs · 4 transformations | string | — | 0.2%113 values | 1<0.1% |
Top: CLIOKC | — |
| cli_high_f0 source inputs · 4 transformations | integer | — | 0.2%113 values | 980.1% | 4110 All-row histogram | Median 75P25 60 · P75 88 |
| cli_low_f0 source inputs · 4 transformations | integer | — | 0.2%113 values | 830.1% | -1482 All-row histogram | Median 52P25 37 · P75 66 |
| cli_report_type0 source inputs · 4 transformations | string | — | 0.2%113 values | 3<0.1% |
Top: final | — |
Release status
Facts from the current passing release
- Release
- V4 publication snapshot
- Rows
- 67,777
- Columns
- 32
- Published
- 4 Sept 2026, 09:28
- Analytics
- Verified across all rows
Use dataset
Query it over the API, connect an agent over MCP, or download the current Parquet file. Everything below is copy-pastable and live.
# Current release — the complete Parquet file
curl -sS -o reports-kokc.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/fdfd9aee-c524-409e-b387-23a11aae653d/query" \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
-H "content-type: application/json" \
--data '{"columns": ["station","event_time_utc"], "limit": 100}'MOSTLYRIGHT_API_KEY takes an mr_use_ key, minted from a workspace that uses this dataset. These routes refuse an mr_live_ key. Full reference: OpenAPI · guide.
