reports_rjtt
Current published release
Current data
Latest passing release for each Table
- Rows
- 124,276
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_rjtt
- Version
- —
- reports_rjtt
Data preview
reports_rjtt| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RJTT | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 42.80 | 6.0 | 24.80 | 48.67 | 30.00 | 7.00 | — | 30.210 | — | FEW | 3000.00 | BKN | 4000.00 | — | — | — |
| RJTT | 2020-01-01T00:30:00.000000Z | SPECI | 2020-01-01 | 42.80 | 6.0 | 24.80 | 48.67 | 30.00 | 8.00 | — | 30.210 | — | FEW | 3000.00 | BKN | 4000.00 | — | — | — |
| RJTT | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 44.60 | 7.0 | 23.00 | 42.14 | 30.00 | 6.00 | — | 30.210 | — | FEW | 3000.00 | BKN | 4000.00 | — | — | — |
| RJTT | 2020-01-01T01:30:00.000000Z | SPECI | 2020-01-01 | 44.60 | 7.0 | 23.00 | 42.14 | 40.00 | 5.00 | — | 30.180 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 44.60 | 7.0 | 26.60 | 48.96 | 40.00 | 5.00 | — | 30.180 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T02:30:00.000000Z | SPECI | 2020-01-01 | 44.60 | 7.0 | 24.80 | 45.44 | 40.00 | 6.00 | — | 30.150 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 46.40 | 8.0 | 24.80 | 42.44 | 50.00 | 5.00 | — | 30.150 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T03:30:00.000000Z | SPECI | 2020-01-01 | 46.40 | 8.0 | 26.60 | 45.73 | 60.00 | 5.00 | — | 30.120 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 46.40 | 8.0 | 24.80 | 42.44 | 50.00 | 4.00 | — | 30.120 | — | FEW | 3000.00 | — | — | — | — | — |
| RJTT | 2020-01-01T04:30:00.000000Z | SPECI | 2020-01-01 | 46.40 | 8.0 | 26.60 | 45.73 | 60.00 | 4.00 | — | 30.120 | — | FEW | 3000.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: RJTT | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 124,276100.0% |
Top: 2020-01-01 00:00:00+00 · 124,264 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: SPECI | — |
| local_standard_date | date | — | 0.0%0 values | 2,4442.0% |
Top: 2023-03-23 · 123,193 more values | — |
| temp_f | decimal | — | 0.0%0 values | 41<0.1% |
Top: 69.80 · 66,405 more values | Median 64.40P25 51.80 · P75 75.20 |
| temp_c | decimal | — | 0.0%0 values | 41<0.1% |
Top: 21.0 · 66,405 more values | Median 18.0P25 11.0 · P75 24.0 |
| dewpoint_f | decimal | — | 0.0%0 values | 48<0.1% |
Top: 77.00 · 68,498 more values | Median 55.40P25 39.20 · P75 69.80 |
| relative_humidity_pct | decimal | — | 0.0%0 values | 1,3201.1% |
Top: 100.00 · 111,986 more values | Median 72.74P25 57.25 · P75 83.88 |
| wind_direction_degrees | decimal | — | 2.6%3,205 values | 37<0.1% |
Top: 190.00 · 46,158 more values | Median 180.00P25 70.00 · P75 280.00 |
| wind_speed_kt | decimal | — | 0.0%0 values | 43<0.1% |
Top: 6.00 · 30,169 more values | Median 10.00P25 6.00 · P75 14.00 |
| wind_gust_kt | decimal | — | 96.5%119,931 values | 461.1% |
Top: 30.00 · 758 more values | Median 31.00P25 28.00 · P75 34.00 |
| altimeter_inhg | decimal | — | 0.0%0 values | 58<0.1% |
Top: 29.910 · 50,480 more values | Median 29.910P25 29.770 · P75 30.060 |
| sea_level_pressure_hpa | decimal | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 10.9%13,521 values | 6<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 11.1%13,741 values | 48<0.1% |
Top: 3000.00 · 9,433 more values | Median 2000.00P25 1400.00 · P75 3000.00 |
| sky_cover_2 | string | — | 37.1%46,141 values | 4<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 52.4%65,122 values | 630.1% |
Top: 5000.00 · 22,824 more values | Median 3500.00P25 1500.00 · P75 7000.00 |
| sky_cover_3 | string | — | 76.5%95,116 values | 4<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 82.0%101,898 values | 600.3% |
Top: 2000.00 · 7,110 more values | Median 3500.00P25 2000.00 · P75 7000.00 |
| sky_cover_4 | string | — | 99.4%123,506 values | 40.5% |
Top: BKN | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 99.5%123,659 values | 274.4% |
Top: 3000.00 · 84 more values | Median 4000.00P25 3000.00 · P75 8000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | 0.0%0 values | 42<0.1% |
Top: 6.21 · 683 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 80.1%99,583 values | 760.3% |
Top: -SHRA · 1,081 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%124,276 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 124,276100.0% |
Top: COR RJTT 021300Z 19007KT 9999 FEW030 BKN/// 22/17 Q1019 NOSIG RMK 1CU030 A3009 · 124,264 more values | — |
| cli_product | string | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%124,276 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%124,276 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%124,276 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 35<0.1% |
Top: 77.00 · 63,369 more values | Median 69.80P25 57.20 · P75 80.60 |
| metar_low_f | decimal | — | 0.0%0 values | 34<0.1% |
Top: 78.80 · 63,213 more values | Median 59.00P25 44.60 · P75 71.60 |
| metar_high_c | decimal | — | 0.0%0 values | 35<0.1% |
Top: 25.0 · 63,369 more values | Median 21.0P25 14.0 · P75 27.0 |
| metar_low_c | decimal | — | 0.0%0 values | 34<0.1% |
Top: 26.0 · 63,213 more values | Median 15.0P25 7.0 · P75 22.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 124,276
- 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-rjtt.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/a9e9ba28-6954-4478-a935-333bb63be8e9/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/a9e9ba28-6954-4478-a935-333bb63be8e9/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/a9e9ba28-6954-4478-a935-333bb63be8e9/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.
