reports_oejn
Current published release
Current data
Latest passing release for each Table
- Rows
- 59,048
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_oejn
- Version
- —
- reports_oejn
Data preview
reports_oejn| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OEJN | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 69.80 | 21.0 | 55.40 | 60.21 | 0.00 | 0.00 | — | 29.940 | — | — | — | — | — | — | — | — |
| OEJN | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 69.80 | 21.0 | 55.40 | 60.21 | 0.00 | 0.00 | — | 29.910 | — | — | — | — | — | — | — | — |
| OEJN | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 68.00 | 20.0 | 55.40 | 64.04 | 0.00 | 0.00 | — | 29.910 | — | — | — | — | — | — | — | — |
| OEJN | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 68.00 | 20.0 | 53.60 | 59.97 | 0.00 | 0.00 | — | 29.940 | — | FEW | 4000.00 | — | — | — | — | — |
| OEJN | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 68.00 | 20.0 | 55.40 | 64.04 | 0.00 | 0.00 | — | 29.940 | — | FEW | 4000.00 | — | — | — | — | — |
| OEJN | 2020-01-01T05:00:00.000000Z | METAR | 2020-01-01 | 69.80 | 21.0 | 55.40 | 60.21 | 290.00 | 2.00 | — | 29.940 | — | FEW | 4000.00 | — | — | — | — | — |
| OEJN | 2020-01-01T06:00:00.000000Z | METAR | 2020-01-01 | 73.40 | 23.0 | 53.60 | 49.90 | 10.00 | 4.00 | — | 29.970 | — | FEW | 4000.00 | — | — | — | — | — |
| OEJN | 2020-01-01T07:00:00.000000Z | METAR | 2020-01-01 | 77.00 | 25.0 | 53.60 | 44.25 | 290.00 | 8.00 | — | 29.970 | — | — | — | — | — | — | — | — |
| OEJN | 2020-01-01T08:00:00.000000Z | METAR | 2020-01-01 | 78.80 | 26.0 | 55.40 | 44.52 | 360.00 | 6.00 | — | 29.970 | — | FEW | 4000.00 | — | — | — | — | — |
| OEJN | 2020-01-01T09:00:00.000000Z | METAR | 2020-01-01 | 78.80 | 26.0 | 55.40 | 44.52 | 270.00 | 6.00 | — | 29.970 | — | FEW | 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: OEJN | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 59,048100.0% |
Top: 2020-01-01 00:00:00+00 · 59,036 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4444.1% |
Top: 2022-11-24 · 58,685 more values | — |
| temp_f | decimal | — | <0.1%2 values | 34<0.1% |
Top: 87.80 · 13,968 more values | Median 86.00P25 80.60 · P75 93.20 |
| temp_c | decimal | — | <0.1%2 values | 34<0.1% |
Top: 31.0 · 13,968 more values | Median 30.0P25 27.0 · P75 34.0 |
| dewpoint_f | decimal | — | <0.1%3 values | 44<0.1% |
Top: 69.80 · 15,482 more values | Median 66.20P25 59.00 · P75 71.60 |
| relative_humidity_pct | decimal | — | <0.1%3 values | 1,4482.5% |
Top: 52.73 · 54,987 more values | Median 51.98P25 39.67 · P75 62.68 |
| wind_direction_degrees | decimal | — | 1.1%667 values | 37<0.1% |
Top: 330.00 · 13,770 more values | Median 300.00P25 220.00 · P75 330.00 |
| wind_speed_kt | decimal | — | <0.1%1 values | 32<0.1% |
Top: 4.00 · 6,166 more values | Median 6.00P25 4.00 · P75 10.00 |
| wind_gust_kt | decimal | — | 99.7%58,896 values | 2818.4% |
Top: 25.00 · 35 more values | Median 25.00P25 22.00 · P75 28.00 |
| altimeter_inhg | decimal | — | <0.1%1 values | 29<0.1% |
Top: 29.650 · 11,216 more values | Median 29.770P25 29.680 · P75 29.880 |
| sea_level_pressure_hpa | decimal | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 63.8%37,666 values | 7<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 70.7%41,766 values | 11<0.1% |
Top: 4000.00 | Median 4000.00P25 4000.00 · P75 4000.00 |
| sky_cover_2 | string | — | 97.2%57,368 values | 30.2% |
Top: SCT | — |
| sky_base_2_ft | decimal | — | 97.2%57,368 values | 120.7% |
Top: 4000.00 | Median 4000.00P25 4000.00 · P75 10000.00 |
| sky_cover_3 | string | — | 99.9%59,002 values | 24.3% |
Top: SCT | — |
| sky_base_3_ft | decimal | — | 99.9%59,002 values | 510.9% |
Top: 4000.00 | Median 4000.00P25 4000.00 · P75 10000.00 |
| sky_cover_4 | string | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | <0.1%1 values | 38<0.1% |
Top: 6.21 · 112 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 97.6%57,653 values | 322.3% |
Top: BLDU · 59 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%59,048 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 59,020100.0% |
Top: OEJN 010000Z 00000KT CAVOK 21/13 Q1014 NOSIG · 59,024 more values | — |
| cli_product | string | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%59,048 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%59,048 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%59,048 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 25<0.1% |
Top: 100.40 · 9,845 more values | Median 95.00P25 87.80 · P75 100.40 |
| metar_low_f | decimal | — | 0.0%0 values | 21<0.1% |
Top: 84.20 · 8,400 more values | Median 80.60P25 73.40 · P75 84.20 |
| metar_high_c | decimal | — | 0.0%0 values | 25<0.1% |
Top: 38.0 · 9,845 more values | Median 35.0P25 31.0 · P75 38.0 |
| metar_low_c | decimal | — | 0.0%0 values | 21<0.1% |
Top: 29.0 · 8,400 more values | Median 27.0P25 23.0 · P75 29.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 59,048
- Columns
- 37
- Published
- 9 Sept 2026, 07:20
- 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-oejn.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/54537168-12c3-4b56-ae1e-358ece2f48b9/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/54537168-12c3-4b56-ae1e-358ece2f48b9/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/54537168-12c3-4b56-ae1e-358ece2f48b9/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.
