reports_lfpg
Current published release
Current data
Latest passing release for each Table
- Rows
- 117,379
- across released Tables
- Tables
- 1
- released
- Columns
- 37
- reports_lfpg
- Version
- —
- reports_lfpg
Data preview
reports_lfpg| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LFPG | 2020-01-01T00:00:00.000000Z | METAR | 2020-01-01 | 33.80 | 1.0 | 30.20 | 86.49 | 120.00 | 7.00 | — | 30.450 | — | NSC | — | — | — | — | — | — |
| LFPG | 2020-01-01T00:30:00.000000Z | SPECI | 2020-01-01 | 33.80 | 1.0 | 30.20 | 86.49 | 130.00 | 10.00 | — | 30.450 | — | NSC | — | — | — | — | — | — |
| LFPG | 2020-01-01T01:00:00.000000Z | METAR | 2020-01-01 | 33.80 | 1.0 | 30.20 | 86.49 | 130.00 | 9.00 | — | 30.450 | — | NSC | — | — | — | — | — | — |
| LFPG | 2020-01-01T01:30:00.000000Z | SPECI | 2020-01-01 | 32.00 | 0.0 | 30.20 | 92.97 | 160.00 | 6.00 | — | 30.450 | — | NSC | — | — | — | — | — | — |
| LFPG | 2020-01-01T02:00:00.000000Z | METAR | 2020-01-01 | 30.20 | -1.0 | 28.40 | 92.92 | 180.00 | 5.00 | — | 30.450 | — | NSC | — | — | — | — | — | — |
| LFPG | 2020-01-01T02:30:00.000000Z | SPECI | 2020-01-01 | 32.00 | 0.0 | 30.20 | 92.97 | 190.00 | 10.00 | — | 30.420 | — | FEW | 0.00 | BKN | 200.00 | — | — | — |
| LFPG | 2020-01-01T03:00:00.000000Z | METAR | 2020-01-01 | 30.20 | -1.0 | 30.20 | 100.00 | 190.00 | 8.00 | — | 30.420 | — | BKN | 0.00 | — | — | — | — | — |
| LFPG | 2020-01-01T03:30:00.000000Z | SPECI | 2020-01-01 | 32.00 | 0.0 | 30.20 | 92.97 | 180.00 | 5.00 | — | 30.450 | — | BKN | 0.00 | — | — | — | — | — |
| LFPG | 2020-01-01T04:00:00.000000Z | METAR | 2020-01-01 | 32.00 | 0.0 | 30.20 | 92.97 | 130.00 | 4.00 | — | 30.450 | — | BKN | 0.00 | — | — | — | — | — |
| LFPG | 2020-01-01T04:30:00.000000Z | SPECI | 2020-01-01 | 32.00 | 0.0 | 30.20 | 92.97 | 140.00 | 5.00 | — | 30.450 | — | BKN | 0.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: LFPG | — |
| event_time_utc | timestamp_utc | — | 0.0%0 values | 117,379100.0% |
Top: 2020-01-01 00:00:00+00 · 117,367 more values | — |
| observation_type | string | — | 0.0%0 values | 2<0.1% |
Top: SPECI | — |
| local_standard_date | date | — | 0.0%0 values | 2,4432.1% |
Top: 2020-01-28 · 116,773 more values | — |
| temp_f | decimal | — | <0.1%6 values | 48<0.1% |
Top: 50.00 · 48,729 more values | Median 55.40P25 46.40 · P75 64.40 |
| temp_c | decimal | — | <0.1%6 values | 48<0.1% |
Top: 10.0 · 48,729 more values | Median 13.0P25 8.0 · P75 18.0 |
| dewpoint_f | decimal | — | <0.1%6 values | 37<0.1% |
Top: 46.40 · 32,984 more values | Median 46.40P25 39.20 · P75 53.60 |
| relative_humidity_pct | decimal | — | <0.1%6 values | 1,2081.0% |
Top: 100.00 · 97,754 more values | Median 76.51P25 59.97 · P75 87.47 |
| wind_direction_degrees | decimal | — | 3.9%4,525 values | 37<0.1% |
Top: 10.00 · 56,872 more values | Median 190.00P25 70.00 · P75 250.00 |
| wind_speed_kt | decimal | — | <0.1%12 values | 38<0.1% |
Top: 7.00 · 14,846 more values | Median 8.00P25 5.00 · P75 11.00 |
| wind_gust_kt | decimal | — | 98.2%115,319 values | 412.0% |
Top: 23.00 · 801 more values | Median 25.00P25 21.00 · P75 32.00 |
| altimeter_inhg | decimal | — | <0.1%6 values | 78<0.1% |
Top: 30.030 · 53,621 more values | Median 30.030P25 29.850 · P75 30.180 |
| sea_level_pressure_hpa | decimal | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| sky_cover_1 | string | — | 41.7%48,933 values | 8<0.1% |
Top: FEW | — |
| sky_base_1_ft | decimal | — | 46.6%54,659 values | 850.1% |
Top: 2000.00 · 37,723 more values | Median 2000.00P25 1000.00 · P75 3200.00 |
| sky_cover_2 | string | — | 65.0%76,345 values | 5<0.1% |
Top: BKN | — |
| sky_base_2_ft | decimal | — | 65.1%76,399 values | 1180.3% |
Top: 26000.00 · 26,779 more values | Median 4200.00P25 2200.00 · P75 7200.00 |
| sky_cover_3 | string | — | 89.8%105,359 values | 5<0.1% |
Top: BKN | — |
| sky_base_3_ft | decimal | — | 89.8%105,424 values | 1141.0% |
Top: 26000.00 · 7,202 more values | Median 6600.00P25 4000.00 · P75 12000.00 |
| sky_cover_4 | string | — | 99.3%116,522 values | 50.6% |
Top: /// | — |
Show 17 more columns
| sky_base_4_ft | decimal | — | 99.7%116,969 values | 7117.3% |
Top: 26000.00 · 212 more values | Median 8300.00P25 5300.00 · P75 13000.00 |
|---|---|---|---|---|---|---|
| visibility_miles | decimal | — | <0.1%9 values | 61<0.1% |
Top: 6.21 · 1,820 more values | Median 6.21P25 6.21 · P75 6.21 |
| weather_codes | string | — | 85.8%100,653 values | 1010.6% |
Top: -RA · 1,801 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%117,379 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_direction_degrees | decimal | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| peak_wind_time | string | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| snow_depth_inches | decimal | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| raw_metar | string | — | 0.0%0 values | 117,378100.0% |
Top: LFPG 022100Z 34006KT CAVOK 18/09 Q1017 NOSIG · 117,366 more values | — |
| cli_product | string | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| cli_high_f | integer | — | 100.0%117,379 values | 00.0% | No distribution published All-row histogram | — |
| cli_low_f | integer | — | 100.0%117,379 values | 00.0% | No distribution published All-row histogram | — |
| cli_report_type | string | — | 100.0%117,379 values | 00.0% | No distribution published No distribution published | — |
| metar_high_f | decimal | — | 0.0%0 values | 43<0.1% |
Top: 53.60 · 54,964 more values | Median 62.60P25 51.80 · P75 73.40 |
| metar_low_f | decimal | — | 0.0%0 values | 34<0.1% |
Top: 46.40 · 39,425 more values | Median 48.20P25 41.00 · P75 57.20 |
| metar_high_c | decimal | — | 0.0%0 values | 43<0.1% |
Top: 12.0 · 54,964 more values | Median 17.0P25 11.0 · P75 23.0 |
| metar_low_c | decimal | — | 0.0%0 values | 34<0.1% |
Top: 8.0 · 39,425 more values | Median 9.0P25 5.0 · P75 14.0 |
Release status
Facts from the current passing release
- Release
- Passing
- Rows
- 117,379
- Columns
- 37
- 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-lfpg.parquet \
-H "x-api-key: $MOSTLYRIGHT_API_KEY" \
"https://mostlyright.md/api/v2/public/tables/a5b16566-b80d-4194-883f-71af694da675/current"
# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/a5b16566-b80d-4194-883f-71af694da675/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/a5b16566-b80d-4194-883f-71af694da675/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.
