US Weather Reports and Daily Highs in 20 Cities

Public

reports_kdfw

Release V4 publication snapshot

Current data

Latest passing release for each Table

Updated 4 Sept 2026, 09:28
Rows
67,941
across released Tables
Tables
1
released
Columns
32
reports_kdfw
Version
V4 publication snapshot
reports_kdfw

Data preview

reports_kdfw
Preview rows for reports_kdfw
stationevent_time_utcobservation_typelocal_standard_datetemp_fdewpoint_frelative_humidity_pctwind_direction_degreeswind_speed_ktwind_gust_ktaltimeter_inhgsea_level_pressure_hpasky_cover_1sky_base_1_ftsky_cover_2sky_base_2_ftsky_cover_3sky_base_3_ftsky_cover_4sky_base_4_ftvisibility_milesweather_codesprecipitation_in_1hpeak_wind_gust_ktpeak_wind_direction_degreespeak_wind_timesnow_depth_inchesraw_metarcli_productcli_high_fcli_low_fcli_report_type
KDFW2020-01-01T00:00:00.000000ZSPECI2019-12-3150.0021.0031.60120.004.001020.50METAR KDFW 010000Z AUTO 12004KT 10/M06 RMK AO2 SLP205 T01001061 IEM_GHCNH
KDFW2020-01-01T00:53:00.000000ZMETAR2019-12-3147.0024.1040.44130.005.0030.1301020.20BKN30000.0010.000.000KDFW 010053Z 13005KT 10SM BKN300 08/M04 A3013 RMK AO2 SLP202 T00831044
KDFW2020-01-01T01:53:00.000000ZMETAR2019-12-3147.0023.0038.62120.003.0030.1201019.90OVC30000.0010.000.000KDFW 010153Z 12003KT 10SM OVC300 08/M05 A3012 RMK AO2 SLP199 T00831050
KDFW2020-01-01T02:53:00.000000ZMETAR2019-12-3145.0023.0041.50130.003.0030.1101019.70BKN30000.0010.000.000KDFW 010253Z 13003KT 10SM BKN300 07/M05 A3011 RMK AO2 SLP197 T00721050 56007
KDFW2020-01-01T03:53:00.000000ZMETAR2019-12-3143.0025.0048.70170.004.0030.1101019.40OVC30000.0010.000.000KDFW 010353Z 17004KT 10SM OVC300 06/M04 A3011 RMK AO2 SLP194 T00611039
KDFW2020-01-01T04:53:00.000000ZMETAR2019-12-3142.0027.0054.78200.006.0030.1101019.60OVC30000.0010.000.000KDFW 010453Z 20006KT 10SM OVC300 06/M03 A3011 RMK AO2 SLP196 T00561028 $
KDFW2020-01-01T05:53:00.000000ZMETAR2019-12-3143.0027.0052.91200.005.0030.1001019.00BKN30000.0010.000.000KDFW 010553Z 20005KT 10SM BKN300 06/M03 A3010 RMK AO2 SLP190 T00611028 10100 20050 401331006 58006 $
KDFW2020-01-01T06:53:00.000000ZMETAR2020-01-0142.0026.1052.78180.005.0030.0801018.40BKN30000.0010.000.000KDFW 010653Z 18005KT 10SM BKN300 06/M03 A3008 RMK AO2 SLP184 T00561033 $CLIDFW5640final
KDFW2020-01-01T07:53:00.000000ZMETAR2020-01-0142.0025.0050.42190.007.0030.0601017.90BKN30000.0010.000.000KDFW 010753Z 19007KT 10SM BKN300 06/M04 A3006 RMK AO2 SLP179 T00561039 $CLIDFW5640final
KDFW2020-01-01T08:53:00.000000ZMETAR2020-01-0143.0024.1046.91180.007.0030.0401017.10SCT24000.00OVC30000.0010.000.000KDFW 010853Z 18007KT 10SM SCT240 OVC300 06/M04 A3004 RMK AO2 SLP171 T00611044 58019 $CLIDFW5640final
A bounded preview of the immutable release.

Columns

Schema, units, meaning, and verified release profile

32 columns
Verified column analytics for reports_kdfw
ColumnTypeUnitMissingDistinctDistributionSummary
station0 source inputs · 4 transformationsstring0.0%0 values1<0.1%
  • KDFW100%

Top: KDFW

event_time_utc0 source inputs · 4 transformationstimestamp_utc0.0%0 values67,939100.0%
Timeline per year: 2020-01-01, 10,499; 2021-01-01, 10,394; 2022-01-01, 10,093; 2023-01-01, 10,159; 2024-01-01, 10,323; 2025-01-01, 9,945; 2026-01-01, 6,528
2020-01-012026-01-01

per year

All rows, per year

observation_type0 source inputs · 4 transformationsstring0.0%0 values2<0.1%
  • METAR86%
  • SPECI14%

Top: METAR

local_standard_date0 source inputs · 4 transformationsdate0.0%0 values2,4383.6%
Timeline per year: 2019-01-01, 7; 2020-01-01, 10,509; 2021-01-01, 10,386; 2022-01-01, 10,091; 2023-01-01, 10,159; 2024-01-01, 10,323; 2025-01-01, 9,944; 2026-01-01, 6,522
2019-01-012026-01-01

per year

All rows, per year

temp_f0 source inputs · 4 transformationsdecimal<0.1%20 values1640.2%
Histogram: -0.90000000000000002 to 12.8375, 96; 12.8375 to 26.574999999999999, 828; 26.574999999999999 to 40.3125, 3,677; 40.3125 to 54.049999999999997, 10,704; 54.049999999999997 to 67.787499999999994, 15,317; 67.787499999999994 to 81.525000000000006, 21,731; 81.525000000000006 to 95.262500000000003, 13,451; 95.262500000000003 to 109, 2,117
-0.90109.00

All-row histogram

Median 70.00P25 56.00 · P75 80.60
dewpoint_f0 source inputs · 4 transformationsdecimal<0.1%20 values1380.2%
Histogram: -6 to 4.8249999999999993, 233; 4.8249999999999993 to 15.649999999999999, 1,018; 15.649999999999999 to 26.474999999999998, 3,874; 26.474999999999998 to 37.299999999999997, 8,268; 37.299999999999997 to 48.125, 9,421; 48.125 to 58.949999999999996, 11,264; 58.949999999999996 to 69.774999999999991, 23,308; 69.774999999999991 to 80.599999999999994, 10,535
-6.0080.60

All-row histogram

Median 58.00P25 42.00 · P75 67.00
relative_humidity_pct0 source inputs · 4 transformationsdecimal<0.1%20 values4,9207.2%
Histogram: 7.3399999999999999 to 18.922499999999999, 588; 18.922499999999999 to 30.504999999999999, 3,677; 30.504999999999999 to 42.087500000000006, 7,723; 42.087500000000006 to 53.670000000000002, 10,561; 53.670000000000002 to 65.252499999999998, 11,437; 65.252499999999998 to 76.835000000000008, 12,062; 76.835000000000008 to 88.417500000000004, 11,575; 88.417500000000004 to 100, 10,298
7.34100.00

All-row histogram

Median 65.23P25 47.84 · P75 81.65
wind_direction_degrees0 source inputs · 4 transformationsdecimal1.9%1,282 values37<0.1%
Histogram: 0 to 45, 9,969; 45 to 90, 3,416; 90 to 135, 7,789; 135 to 180, 16,767; 180 to 225, 15,200; 225 to 270, 1,716; 270 to 315, 2,577; 315 to 360, 9,225
0.00360.00

All-row histogram

Median 170.00P25 110.00 · P75 200.00
wind_speed_kt0 source inputs · 4 transformationsdecimal0.1%88 values700.1%
Histogram: 0 to 6.125, 21,633; 6.125 to 12.25, 29,988; 12.25 to 18.375, 13,146; 18.375 to 24.5, 2,735; 24.5 to 30.625, 298; 30.625 to 36.75, 36; 36.75 to 42.875, 11; 42.875 to 49, 6
0.0049.00

All-row histogram

Median 9.00P25 6.00 · P75 12.00
wind_gust_kt0 source inputs · 4 transformationsdecimal81.5%55,343 values830.7%
Histogram: 14 to 22, 4,358; 22 to 30, 6,519; 30 to 38, 1,460; 38 to 46, 196; 46 to 54, 41; 54 to 62, 11; 62 to 70, 11; 70 to 78, 2
14.0078.00

All-row histogram

Median 23.00P25 20.00 · P75 27.00
altimeter_inhg0 source inputs · 4 transformationsdecimal<0.1%11 values1440.2%
Histogram: 29.289999999999999 to 29.474999999999998, 116; 29.474999999999998 to 29.66, 1,477; 29.66 to 29.844999999999999, 11,342; 29.844999999999999 to 30.030000000000001, 29,004; 30.030000000000001 to 30.215, 17,952; 30.215 to 30.399999999999999, 6,299; 30.399999999999999 to 30.585000000000001, 1,521; 30.585000000000001 to 30.77, 219
29.29030.770

All-row histogram

Median 29.980P25 29.880 · P75 30.090
sea_level_pressure_hpa0 source inputs · 4 transformationsdecimal14.1%9,565 values4720.8%
Histogram: 932.5 to 946.28750000000002, 1; 946.28750000000002 to 960.07500000000005, 0; 960.07500000000005 to 973.86249999999995, 0; 973.86249999999995 to 987.64999999999998, 0; 987.64999999999998 to 1001.4375, 585; 1001.4375 to 1015.2249999999999, 31,790; 1015.2249999999999 to 1029.0125, 24,021; 1029.0125 to 1042.8, 1,979
932.501042.80

All-row histogram

Median 1014.50P25 1011.20 · P75 1018.80
sky_cover_10 source inputs · 4 transformationsstring<0.1%14 values6<0.1%
  • FEW39%
  • BKN18%
  • SCT18%

Top: FEW

sky_base_1_ft0 source inputs · 4 transformationsdecimal15.6%10,586 values1230.2%
Histogram: 0 to 4125, 27,688; 4125 to 8250, 10,886; 8250 to 12375, 3,181; 12375 to 16500, 1,713; 16500 to 20625, 1,956; 20625 to 24750, 635; 24750 to 28875, 9,777; 28875 to 33000, 1,519
0.0033000.00

All-row histogram

Median 4500.00P25 1700.00 · P75 15000.00
sky_cover_20 source inputs · 4 transformationsstring51.0%34,631 values4<0.1%
  • BKN44%
  • SCT23%
  • OVC16%

Top: BKN

sky_base_2_ft0 source inputs · 4 transformationsdecimal51.0%34,631 values1290.4%
Histogram: 200 to 3925, 8,825; 3925 to 7650, 5,316; 7650 to 11375, 3,370; 11375 to 15100, 2,225; 15100 to 18825, 1,512; 18825 to 22550, 1,469; 22550 to 26275, 9,118; 26275 to 30000, 1,475
200.0030000.00

All-row histogram

Median 10000.00P25 3700.00 · P75 25000.00
sky_cover_30 source inputs · 4 transformationsstring77.7%52,790 values4<0.1%
  • BKN49%
  • OVC36%
  • SCT12%

Top: BKN

sky_base_3_ft0 source inputs · 4 transformationsdecimal77.7%52,790 values1230.8%
Histogram: 700 to 4362.5, 1,983; 4362.5 to 8025, 2,348; 8025 to 11687.5, 1,967; 11687.5 to 15350, 1,407; 15350 to 19012.5, 871; 19012.5 to 22675, 580; 22675 to 26337.5, 5,409; 26337.5 to 30000, 586
700.0030000.00

All-row histogram

Median 15000.00P25 7000.00 · P75 25000.00
sky_cover_40 source inputs · 4 transformationsstring95.2%64,670 values40.1%
  • BKN62%
  • OVC34%
  • SCT4%

Top: BKN

sky_base_4_ft0 source inputs · 4 transformationsdecimal95.2%64,670 values150.5%
Histogram: 9500 to 12062.5, 1; 12062.5 to 14625, 380; 14625 to 17187.5, 295; 17187.5 to 19750, 140; 19750 to 22312.5, 188; 22312.5 to 24875, 63; 24875 to 27437.5, 2,057; 27437.5 to 30000, 147
9500.0030000.00

All-row histogram

Median 25000.00P25 20000.00 · P75 25000.00
Show 12 more columns
Verified column analytics for reports_kdfw
visibility_miles0 source inputs · 4 transformationsdecimal<0.1%4 values20<0.1%
Histogram: 0 to 1.25, 985; 1.25 to 2.5, 1,525; 2.5 to 3.75, 1,591; 3.75 to 5, 648; 5 to 6.25, 1,558; 6.25 to 7.5, 1,002; 7.5 to 8.75, 960; 8.75 to 10, 59,668
0.0010.00

All-row histogram

Median 10.00P25 10.00 · P75 10.00
weather_codes0 source inputs · 4 transformationsstring86.6%58,853 values1471.6%
  • BR18%
  • -RA16%
  • -RA BR10%
  • Other (135)

Top: BR · 1,884 more values

precipitation_in_1h0 source inputs · 4 transformationsdecimal7.8%5,296 values1270.2%
Histogram: 0 to 0.37624999999999997, 62,272; 0.37624999999999997 to 0.75249999999999995, 271; 0.75249999999999995 to 1.1287499999999999, 61; 1.1287499999999999 to 1.5049999999999999, 27; 1.5049999999999999 to 1.8812499999999999, 10; 1.8812499999999999 to 2.2574999999999998, 1; 2.2574999999999998 to 2.63375, 2; 2.63375 to 3.0099999999999998, 1
0.0003.010

All-row histogram

Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt0 source inputs · 4 transformationsdecimal89.5%60,783 values400.6%
Histogram: 26 to 32.5, 5,479; 32.5 to 39, 1,220; 39 to 45.5, 320; 45.5 to 52, 76; 52 to 58.5, 28; 58.5 to 65, 21; 65 to 71.5, 10; 71.5 to 78, 4
26.0078.00

All-row histogram

Median 29.00P25 27.00 · P75 32.00
peak_wind_direction_degrees0 source inputs · 4 transformationsdecimal89.5%60,783 values360.5%
Histogram: 10 to 53.75, 601; 53.75 to 97.5, 71; 97.5 to 141.25, 216; 141.25 to 185, 2,524; 185 to 228.75, 1,352; 228.75 to 272.5, 238; 272.5 to 316.25, 513; 316.25 to 360, 1,643
10.00360.00

All-row histogram

Median 190.00P25 170.00 · P75 310.00
peak_wind_time0 source inputs · 4 transformationsstring89.5%60,783 values6,10085.2%

6,100 distinct values, no chart

No shape worth drawing · 7,158 more values

snow_depth_inches0 source inputs · 4 transformationsdecimal100.0%67,918 values417.4%
Histogram: 1 to 1.375, 7; 1.375 to 1.75, 0; 1.75 to 2.125, 2; 2.125 to 2.5, 0; 2.5 to 2.875, 0; 2.875 to 3.25, 10; 3.25 to 3.625, 0; 3.625 to 4, 4
1.004.00

All-row histogram

Median 3.00P25 1.00 · P75 3.00
raw_metar0 source inputs · 4 transformationsstring0.0%0 values67,941100.0%

67,941 distinct values, no chart

No shape worth drawing · 67,941 more values

cli_product0 source inputs · 4 transformationsstring0.2%108 values1<0.1%
  • CLIDFW100%

Top: CLIDFW

cli_high_f0 source inputs · 4 transformationsinteger0.2%108 values880.1%
Histogram: 14 to 26, 281; 27 to 38, 1,040; 39 to 50, 2,817; 51 to 62, 7,740; 63 to 74, 13,596; 75 to 86, 17,607; 87 to 98, 19,247; 99 to 110, 5,505
14110

All-row histogram

Median 81P25 67 · P75 91
cli_low_f0 source inputs · 4 transformationsinteger0.2%108 values770.1%
Histogram: -2 to 9, 121; 10 to 20, 732; 21 to 31, 2,861; 32 to 42, 9,992; 43 to 53, 11,684; 54 to 64, 13,412; 65 to 75, 18,318; 76 to 86, 10,713
-286

All-row histogram

Median 60P25 46 · P75 72
cli_report_type0 source inputs · 4 transformationsstring0.2%108 values3<0.1%
  • final100%
  • preliminary0%
  • correction0%

Top: final

Release status

Facts from the current passing release

Release
V4 publication snapshot
Rows
67,941
Columns
32
Published
4 Sept 2026, 09:28
Analytics
Verified across all rows

Use dataset

Query it over the API, connect an agent over MCP, or download the current Parquet file. Everything below is copy-pastable and live.

cURL · reports_kdfw
reports_kdfw
# Current release — the complete Parquet file
curl -sS -o reports-kdfw.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/ed9260f8-0253-423f-9ba1-ce58a8632702/query" \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  -H "content-type: application/json" \
  --data '{"columns": ["station","event_time_utc"], "limit": 100}'

MOSTLYRIGHT_API_KEY takes an mr_use_ key, minted from a workspace that uses this dataset. These routes refuse an mr_live_ key. Full reference: OpenAPI · guide.

Report this Table

Build your own datasets

Create a free workspace to build and maintain data your team keeps private.

Create a free workspace

Already have an account? Log in

DocsPricingTermsPrivacyStatus