reports_kewr
Current published release
Current data
Latest passing release for each Table
- Rows
- 66,437
- across released Tables
- Tables
- 1
- released
- Columns
- 34
- reports_kewr
- Version
- —
- reports_kewr
Data preview
reports_kewr| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KEWR | 2020-01-01T05:51:00.000000Z | METAR | 2020-01-01 | 40.00 | 28.00 | 62.15 | 260.00 | 12.00 | — | 29.660 | 1004.20 | FEW | 3000.00 | BKN | 8000.00 | OVC | 10000.00 | — | — |
| KEWR | 2020-01-01T06:51:00.000000Z | METAR | 2020-01-01 | 39.00 | 28.90 | 66.79 | 270.00 | 12.00 | — | 29.670 | 1004.60 | BKN | 7000.00 | BKN | 10000.00 | — | — | — | — |
| KEWR | 2020-01-01T07:51:00.000000Z | METAR | 2020-01-01 | 39.00 | 28.00 | 64.37 | 260.00 | 9.00 | — | 29.680 | 1005.00 | FEW | 4000.00 | BKN | 7000.00 | OVC | 10000.00 | — | — |
| KEWR | 2020-01-01T08:51:00.000000Z | METAR | 2020-01-01 | 39.00 | 26.10 | 59.52 | 270.00 | 10.00 | — | 29.690 | 1005.40 | FEW | 3000.00 | BKN | 7000.00 | BKN | 10000.00 | BKN | 21000.00 |
| KEWR | 2020-01-01T09:51:00.000000Z | METAR | 2020-01-01 | 38.00 | 26.10 | 62.14 | 290.00 | 11.00 | — | 29.700 | 1005.70 | BKN | 3500.00 | BKN | 4400.00 | OVC | 10000.00 | — | — |
| KEWR | 2020-01-01T10:43:00.000000Z | SPECI | 2020-01-01 | 36.00 | 28.00 | 72.43 | 260.00 | 7.00 | — | 29.710 | — | FEW | 3500.00 | SCT | 4500.00 | OVC | 6000.00 | — | — |
| KEWR | 2020-01-01T10:51:00.000000Z | METAR | 2020-01-01 | 36.00 | 28.90 | 75.15 | 260.00 | 8.00 | — | 29.720 | 1006.20 | FEW | 3200.00 | SCT | 4500.00 | OVC | 6000.00 | — | — |
| KEWR | 2020-01-01T11:36:00.000000Z | SPECI | 2020-01-01 | 37.00 | 26.10 | 64.38 | 270.00 | 12.00 | 21.00 | 29.720 | — | FEW | 3000.00 | SCT | 4800.00 | OVC | 6000.00 | — | — |
| KEWR | 2020-01-01T11:51:00.000000Z | METAR | 2020-01-01 | 37.00 | 25.00 | 61.50 | 270.00 | 9.00 | — | 29.720 | 1006.30 | FEW | 3000.00 | SCT | 4800.00 | OVC | 6000.00 | — | — |
| KEWR | 2020-01-01T12:51:00.000000Z | METAR | 2020-01-01 | 37.00 | 24.10 | 59.24 | 250.00 | 10.00 | — | 29.730 | 1006.60 | FEW | 3000.00 | OVC | 6500.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: KEWR | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 66,430100.0% |
Top: 2023-06-25 22:50:00+00 · 66,418 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: METAR | — |
| local_standard_date | date | — | 0.0%0 values | 2,4433.7% |
Top: 2021-02-18 · 65,852 more values | — |
| temp_f | decimal | — | <0.1%7 values | 1480.2% |
Top: 74.00 · 50,388 more values | Median 58.00P25 43.00 · P75 73.00 |
| dewpoint_f | decimal | — | <0.1%9 values | 1410.2% |
Top: 70.00 · 51,830 more values | Median 45.00P25 28.90 · P75 60.00 |
| relative_humidity_pct | decimal | — | <0.1%9 values | 4,9857.5% |
Top: 100.00 · 64,801 more values | Median 62.34P25 46.00 · P75 79.92 |
| wind_direction_degrees | decimal | — | 3.4%2,230 values | 37<0.1% |
Top: 0.00 · 32,439 more values | Median 210.00P25 80.00 · P75 280.00 |
| wind_speed_kt | decimal | — | 0.1%71 values | 39<0.1% |
Top: 5.00 · 8,446 more values | Median 7.00P25 5.00 · P75 11.00 |
| wind_gust_kt | decimal | — | 79.9%53,070 values | 430.3% |
Top: 21.00 · 3,159 more values | Median 22.00P25 19.00 · P75 26.00 |
| altimeter_inhg | decimal | — | <0.1%2 values | 1980.3% |
Top: 30.000 · 51,393 more values | Median 30.000P25 29.860 · P75 30.160 |
| sea_level_pressure_hpa | decimal | — | 11.9%7,905 values | 5941.0% |
Top: 1016.70 · 54,323 more values | Median 1016.30P25 1011.60 · P75 1021.50 |
| sky_cover_1 | string | — | <0.1%3 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 4.5%2,983 values | 830.1% |
Top: 25000.00 · 32,454 more values | Median 4500.00P25 1700.00 · P75 8000.00 |
| sky_cover_2 | string | — | 31.4%20,841 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 31.4%20,841 values | 780.2% |
Top: 25000.00 · 21,696 more values | Median 9000.00P25 3800.00 · P75 20000.00 |
| sky_cover_3 | string | — | 61.7%41,016 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 61.7%41,016 values | 730.3% |
Top: 25000.00 · 8,614 more values | Median 14000.00P25 7000.00 · P75 25000.00 |
| sky_cover_4 | string | — | 89.5%59,488 values | 3<0.1% |
Top: BKN | — |
| sky_base_4_ft | decimal | — | 89.5%59,488 values | 170.2% |
Top: 25000.00 · 161 more values | Median 25000.00P25 17000.00 · P75 25000.00 |
Show 14 more columns
| visibility_miles | decimal | — | <0.1%7 values | 19<0.1% |
Top: 10.00 · 1,095 more values | Median 10.00P25 10.00 · P75 10.00 |
|---|---|---|---|---|---|---|
| weather_codes | string | — | 81.3%54,045 values | 1140.9% |
Top: -RA · 1,599 more values | — |
| precipitation_in_1h | decimal | — | 10.0%6,620 values | 1070.2% |
Top: 0.000 · 1,091 more values | Median 0.000P25 0.000 · P75 0.000 |
| peak_wind_gust_kt | decimal | — | 90.4%60,064 values | 330.5% |
Top: 26.00 · 721 more values | Median 30.00P25 27.00 · P75 34.00 |
| peak_wind_direction_degrees | decimal | — | 90.4%60,064 values | 360.6% |
Top: 290.00 · 1,290 more values | Median 290.00P25 250.00 · P75 310.00 |
| peak_wind_time | string | — | 90.4%60,064 values | 5,77090.5% |
Top: 2022-02-19 19:58 · 6,306 more values | — |
| snow_depth_inches | decimal | — | 99.4%66,019 values | 225.3% |
Top: 1.00 · 27 more values | Median 3.00P25 1.00 · P75 7.00 |
| raw_metar | string | — | 0.0%0 values | 66,437100.0% |
Top: KEWR 010000Z 19017G28KT 10SM BKN025 BKN070 OVC120 18/14 A2949 RMK AO2 PK WND 19028/2353 RAE00 P0000 T01830139 · 66,425 more values | — |
| cli_product | string | — | <0.1%48 values | 1<0.1% |
Top: CLIEWR | — |
| cli_high_f | integer | — | <0.1%48 values | 870.1% | 17105 All-row histogram | Median 68P25 51 · P75 82 |
| cli_low_f | integer | — | <0.1%48 values | 790.1% | 585 All-row histogram | Median 49P25 36 · P75 65 |
| cli_report_type | string | — | <0.1%48 values | 3<0.1% |
Top: final | — |
| metar_high_f | decimal | — | 0.0%0 values | 1050.2% |
Top: 82.00 · 49,987 more values | Median 67.00P25 50.00 · P75 81.00 |
| metar_low_f | decimal | — | 0.0%0 values | 1050.2% |
Top: 68.00 · 48,527 more values | Median 50.00P25 36.00 · P75 65.00 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 66,437
- Columns
- 34
- Published
- 9 Sept 2026, 06:32
- 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-kewr.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/2d979af9-2e2d-4c93-986e-5fd1621b7d2b/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/2d979af9-2e2d-4c93-986e-5fd1621b7d2b/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/2d979af9-2e2d-4c93-986e-5fd1621b7d2b/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.
