reports_kokc
Current published release
Current data
Latest passing release for each Table
- Rows
- 67,921
- across released Tables
- Tables
- 1
- released
- Columns
- 34
- reports_kokc
- Version
- —
- 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | — | — | — | — | — | — |
| 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 | — | — | — | — | — | — |
| 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 | — | — | — | — | — | — |
| 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 | — | — | — | — | — | — |
| KOKC | 2020-01-01T10:52:00.000000Z | METAR | 2020-01-01 | 33.00 | 23.00 | 66.06 | 160.00 | 6.00 | — | 29.910 | 1013.20 | FEW | 25000.00 | — | — | — | — | — | — |
| KOKC | 2020-01-01T11:52:00.000000Z | METAR | 2020-01-01 | 33.00 | 24.10 | 69.17 | 190.00 | 9.00 | — | 29.890 | 1012.70 | FEW | 25000.00 | — | — | — | — | — | — |
| KOKC | 2020-01-01T12:52:00.000000Z | METAR | 2020-01-01 | 36.00 | 25.00 | 63.98 | 190.00 | 13.00 | — | 29.860 | 1011.60 | FEW | 25000.00 | — | — | — | — | — | — |
| KOKC | 2020-01-01T13:52:00.000000Z | METAR | 2020-01-01 | 38.00 | 26.10 | 62.14 | 200.00 | 14.00 | — | 29.840 | 1010.90 | FEW | 25000.00 | — | — | — | — | — | — |
| KOKC | 2020-01-01T14:52:00.000000Z | METAR | 2020-01-01 | 40.00 | 27.00 | 59.65 | 190.00 | 9.00 | — | 29.840 | 1010.90 | FEW | 25000.00 | — | — | — | — | — | — |
| KOKC | 2020-01-01T15:52:00.000000Z | METAR | 2020-01-01 | 46.00 | 28.90 | 51.03 | 200.00 | 14.00 | — | 29.830 | 1010.50 | FEW | 25000.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: KOKC | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 67,919100.0% |
Top: 2023-02-27 01:35:00+00 · 67,907 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4433.6% |
Top: 2026-01-24 · 67,172 more values | — |
| temp_f | decimal | — | <0.1%9 values | 1810.3% |
Top: 73.00 · 50,625 more values | Median 63.00P25 48.00 · P75 75.00 |
| dewpoint_f | decimal | — | <0.1%10 values | 1540.2% |
Top: 68.00 · 45,118 more values | Median 52.00P25 34.00 · P75 64.00 |
| relative_humidity_pct | decimal | — | <0.1%10 values | 4,9577.3% |
Top: 100.00 · 63,921 more values | Median 69.59P25 51.08 · P75 86.06 |
| wind_direction_degrees | decimal | — | 1.5%1,020 values | 39<0.1% |
Top: 170.00 · 24,962 more values | Median 170.00P25 110.00 · P75 210.00 |
| wind_speed_kt | decimal | — | 0.1%73 values | 44<0.1% |
Top: 7.00 · 15,512 more values | Median 9.00P25 6.00 · P75 13.00 |
| wind_gust_kt | decimal | — | 80.7%54,817 values | 500.4% |
Top: 24.00 · 3,284 more values | Median 25.00P25 21.00 · P75 28.00 |
| altimeter_inhg | decimal | — | <0.1%1 values | 1480.2% |
Top: 29.980 · 49,063 more values | Median 30.000P25 29.890 · P75 30.120 |
| sea_level_pressure_hpa | decimal | — | 14.2%9,627 values | 5140.9% |
Top: 1013.70 · 53,298 more values | Median 1015.00P25 1011.10 · P75 1019.60 |
| sky_cover_1 | string | — | <0.1%4 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 16.8%11,412 values | 810.1% |
Top: 25000.00 · 28,465 more values | Median 6000.00P25 1800.00 · P75 20000.00 |
| sky_cover_2 | string | — | 57.4%39,010 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 57.4%39,010 values | 810.3% |
Top: 25000.00 · 10,554 more values | Median 15000.00P25 4700.00 · P75 25000.00 |
| sky_cover_3 | string | — | 82.3%55,898 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 82.3%55,898 values | 720.6% |
Top: 25000.00 · 3,211 more values | Median 18000.00P25 8000.00 · P75 25000.00 |
| sky_cover_4 | string | — | 96.8%65,745 values | 40.2% |
Top: BKN | — |
| sky_base_4_ft | decimal | — | 96.8%65,745 values | 150.7% |
Top: 25000.00 · 6 more values | Median 25000.00P25 20000.00 · P75 25000.00 |
Show 14 more columns
| visibility_miles | decimal | — | <0.1%7 values | 20<0.1% |
Top: 10.00 · 1,603 more values | Median 10.00P25 10.00 · P75 10.00 |
|---|---|---|---|---|---|---|
| weather_codes | string | — | 84.8%57,565 values | 1401.4% |
Top: BR · 1,912 more values | — |
| precipitation_in_1h | decimal | — | 6.6%4,469 values | 1210.2% |
Top: 0.000 · 1,209 more values | Median 0.000P25 0.000 · P75 0.000 |
| peak_wind_gust_kt | decimal | — | 87.1%59,190 values | 370.4% |
Top: 26.00 · 789 more values | Median 29.00P25 27.00 · P75 33.00 |
| peak_wind_direction_degrees | decimal | — | 87.1%59,190 values | 360.4% |
Top: 180.00 · 2,009 more values | Median 190.00P25 160.00 · P75 320.00 |
| peak_wind_time | string | — | 87.1%59,190 values | 7,49985.9% |
Top: 2021-06-26 08:59 · 8,652 more values | — |
| snow_depth_inches | decimal | — | 99.8%67,765 values | 117.1% |
Top: 0.00 | Median 2.00P25 0.00 · P75 5.00 |
| raw_metar | string | — | 0.0%0 values | 67,921100.0% |
Top: KOKC 010001Z 02007KT 10SM FEW010 SCT019 OVC200 19/17 A3004 RMK AO2 T01940172 $ · 67,909 more values | — |
| cli_product | string | — | 0.2%107 values | 1<0.1% |
Top: CLIOKC | — |
| cli_high_f | integer | — | 0.2%107 values | 980.1% | 4110 All-row histogram | Median 75P25 60 · P75 88 |
| cli_low_f | integer | — | 0.2%107 values | 830.1% | -1482 All-row histogram | Median 52P25 37 · P75 66 |
| cli_report_type | string | — | 0.2%107 values | 3<0.1% |
Top: final | — |
| metar_high_f | decimal | — | 0.0%0 values | 1110.2% |
Top: 90.00 · 48,714 more values | Median 75.00P25 59.00 · P75 87.00 |
| metar_low_f | decimal | — | 0.0%0 values | 1120.2% |
Top: 64.00 · 48,199 more values | Median 53.00P25 37.00 · P75 66.00 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 67,921
- Columns
- 34
- Published
- 9 Sept 2026, 06:29
- 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-kokc.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/7d37bd5e-899b-4f75-a7d5-ace9de947066/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/7d37bd5e-899b-4f75-a7d5-ace9de947066/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/7d37bd5e-899b-4f75-a7d5-ace9de947066/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.
