reports_kdca

Current published release

Current data

Latest passing release for each Table

Updated 9 Sept 2026, 06:27

Rows: 71,633; across released Tables
Tables: 1; released
Columns: 34; reports_kdca
Version: —; reports_kdca

Data preview

reports_kdca

Preview rows for reports_kdca
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
KDCA	2020-01-01T05:52:00.000000Z	METAR	2020-01-01	44.00	28.90	54.85	340.00	7.00	—	29.760	1007.80	OVC	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T06:52:00.000000Z	METAR	2020-01-01	43.00	28.90	57.21	320.00	8.00	—	29.780	1008.40	OVC	5500.00	—	—	—	—	—	—
KDCA	2020-01-01T07:52:00.000000Z	METAR	2020-01-01	43.00	28.00	55.14	320.00	8.00	—	29.790	1008.60	BKN	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T08:52:00.000000Z	METAR	2020-01-01	42.00	27.00	54.78	330.00	9.00	—	29.790	1008.80	BKN	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T09:52:00.000000Z	METAR	2020-01-01	41.00	27.00	57.15	340.00	6.00	—	29.800	1008.90	BKN	6000.00	BKN	14000.00	OVC	25000.00	—	—
KDCA	2020-01-01T10:52:00.000000Z	METAR	2020-01-01	42.00	27.00	54.78	300.00	6.00	—	29.810	1009.30	BKN	6000.00	BKN	14000.00	OVC	25000.00	—	—
KDCA	2020-01-01T11:52:00.000000Z	METAR	2020-01-01	41.00	26.10	55.07	310.00	6.00	—	29.820	1009.60	BKN	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T12:52:00.000000Z	METAR	2020-01-01	42.00	26.10	52.78	300.00	5.00	—	29.830	1010.20	SCT	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T13:52:00.000000Z	METAR	2020-01-01	44.00	26.10	48.88	280.00	5.00	—	29.860	1011.10	FEW	6000.00	—	—	—	—	—	—
KDCA	2020-01-01T14:52:00.000000Z	METAR	2020-01-01	45.00	25.00	45.12	300.00	11.00	—	29.880	1011.90	FEW	6000.00	—	—	—	—	—	—

Columns

Schema, units, meaning, and verified release profile

34 columns

Verified column analytics for reports_kdca
Column	Type	Unit	Missing	Distinct	Distribution	Summary
station	string	—	0.0%0 values	1<0.1%	KDCA100% Top: KDCA	—
event_time_utc	timestamp_utc	—	0.0%0 values	71,631100.0%	2024-12-29 03:50:00+000% 2025-05-28 11:50:00+000% 2020-01-01 05:52:00+000% Other (71,619) Top: 2024-12-29 03:50:00+00 · 71,619 more values	—
observation_type	string	—	0.0%0 values	2<0.1%	METAR82% SPECI18% Top: METAR	—
local_standard_date	date	—	0.0%0 values	2,4433.4%	2022-12-310% 2025-01-060% 2024-12-100% Other (2,431) Top: 2022-12-31 · 70,690 more values	—
temp_f	decimal	—	<0.1%8 values	1410.2%	76.003% 75.002% 74.002% Other (129) Top: 76.00 · 52,835 more values	Median 61.00P25 47.00 · P75 74.00
dewpoint_f	decimal	—	<0.1%13 values	1400.2%	70.002% 71.002% 69.002% Other (128) Top: 70.00 · 53,000 more values	Median 50.00P25 34.00 · P75 64.00
relative_humidity_pct	decimal	—	<0.1%13 values	4,5686.4%	100.000% 90.400% 87.240% Other (4,556) Top: 100.00 · 69,722 more values	Median 68.82P25 50.42 · P75 84.46
wind_direction_degrees	decimal	—	1.6%1,176 values	38<0.1%	0.008% 190.007% 180.006% Other (26) Top: 0.00 · 30,138 more values	Median 180.00P25 70.00 · P75 290.00
wind_speed_kt	decimal	—	0.1%72 values	38<0.1%	6.0010% 5.0010% 7.0010% Other (26) Top: 6.00 · 6,208 more values	Median 7.00P25 4.00 · P75 10.00
wind_gust_kt	decimal	—	86.4%61,923 values	440.5%	21.009% 19.008% 22.008% Other (32) Top: 21.00 · 2,225 more values	Median 22.00P25 19.00 · P75 26.00
altimeter_inhg	decimal	—	<0.1%9 values	1920.3%	29.9602% 29.9802% 30.0302% Other (180) Top: 29.960 · 54,143 more values	Median 30.020P25 29.890 · P75 30.160
sea_level_pressure_hpa	decimal	—	18.4%13,182 values	5651.0%	1016.401% 1014.701% 1015.801% Other (553) Top: 1016.40 · 53,993 more values	Median 1017.10P25 1012.70 · P75 1021.90
sky_cover_1	string	—	<0.1%2 values	6<0.1%	FEW37% BKN21% SCT20% Top: FEW	—
sky_base_1_ft	decimal	—	7.0%4,996 values	770.1%	25000.0012% 6000.005% 5000.005% Other (65) Top: 25000.00 · 35,711 more values	Median 5000.00P25 1700.00 · P75 11000.00
sky_cover_2	string	—	44.1%31,556 values	4<0.1%	BKN44% OVC23% SCT20% Top: BKN	—
sky_base_2_ft	decimal	—	44.1%31,556 values	790.2%	25000.0026% 10000.004% 11000.003% Other (67) Top: 25000.00 · 17,232 more values	Median 10000.00P25 4500.00 · P75 25000.00
sky_cover_3	string	—	76.5%54,822 values	4<0.1%	OVC47% BKN42% SCT10% Top: OVC	—
sky_base_3_ft	decimal	—	76.5%54,822 values	670.4%	25000.0030% 11000.007% 10000.004% Other (55) Top: 25000.00 · 5,475 more values	Median 12000.00P25 7000.00 · P75 25000.00
sky_cover_4	string	—	96.5%69,091 values	30.1%	BKN67% OVC30% SCT3% Top: BKN	—
sky_base_4_ft	decimal	—	96.5%69,091 values	140.6%	25000.0068% 20000.008% 15000.006% Other (2) Top: 25000.00 · 18 more values	Median 25000.00P25 20000.00 · P75 25000.00

Show 14 more columns

Verified column analytics for reports_kdca
visibility_miles	decimal	—	<0.1%5 values	20<0.1%	10.0081% 9.002% 4.002% Other (8) Top: 10.00 · 1,257 more values	Median 10.00P25 10.00 · P75 10.00
weather_codes	string	—	79.7%57,115 values	1491.0%	-RA24% -RA BR15% BR10% Other (137) Top: -RA · 2,700 more values	—
precipitation_in_1h	decimal	—	9.6%6,912 values	1210.2%	0.00087% 0.0104% 0.0202% Other (109) Top: 0.000 · 1,607 more values	Median 0.000P25 0.000 · P75 0.000
peak_wind_gust_kt	decimal	—	93.1%66,713 values	320.7%	26.0015% 27.0013% 28.0010% Other (20) Top: 26.00 · 605 more values	Median 30.00P25 27.00 · P75 34.00
peak_wind_direction_degrees	decimal	—	93.1%66,713 values	360.7%	320.0013% 330.0012% 290.009% Other (24) Top: 320.00 · 1,189 more values	Median 300.00P25 240.00 · P75 320.00
peak_wind_time	string	—	93.1%66,713 values	3,96280.5%	2021-07-02 01:060% 2021-07-01 19:070% 2020-07-22 19:540% Other (3,950) Top: 2021-07-02 01:06 · 4,808 more values	—
snow_depth_inches	decimal	—	99.8%71,454 values	73.9%	2.0021% 3.0020% 1.0018% Top: 2.00	Median 3.00P25 2.00 · P75 5.00
raw_metar	string	—	0.0%0 values	71,633100.0%	KDCA 010000Z 00000KT 10SM TS SCT025CB BKN070 31/24 A2983 RMK AO2 LTG DSNT E-SW TSB2356 OCNL LTGICCC E AND S TS E AND S MOV E T03110244 $0% KDCA 010000Z 01009KT 4SM -SNPL BR SCT008 OVC012 M01/M02 A3002 RMK AO2 PLB58 P0000 T100610170% KDCA 010000Z 32010G21KT 2 1/2SM TSRA BKN032CB BKN050 OVC090 19/16 A2960 RMK AO2 WSHFT 2339 OCNL LTGIC ALQDS TS ALQDS MOV NE P0006 T018901610% Other (71,621) Top: KDCA 010000Z 00000KT 10SM TS SCT025CB BKN070 31/24 A2983 RMK AO2 LTG DSNT E-SW TSB2356 OCNL LTGICCC E AND S TS E AND S MOV E T03110244 $ · 71,621 more values	—
cli_product	string	—	<0.1%14 values	1<0.1%	CLIDCA100% Top: CLIDCA	—
cli_high_f	integer	—	0.3%206 values	830.1%	21104 All-row histogram	Median 71P25 55 · P75 84
cli_low_f	integer	—	0.3%206 values	740.1%	984 All-row histogram	Median 52P25 39 · P75 67
cli_report_type	string	—	<0.1%14 values	3<0.1%	final99% correction1% preliminary0% Top: final	—
metar_high_f	decimal	—	0.0%0 values	970.1%	87.003% 83.003% 88.003% Other (85) Top: 87.00 · 52,067 more values	Median 70.00P25 55.00 · P75 83.00
metar_low_f	decimal	—	0.0%0 values	1020.1%	73.003% 75.003% 74.003% Other (90) Top: 73.00 · 50,649 more values	Median 53.00P25 40.00 · P75 68.00

Release status

Facts from the current passing release

Release: Passing
Rows: 71,633
Columns: 34
Published: 9 Sept 2026, 06:27
Analytics: Verified across all rows

Use dataset

Query this dataset with the API, connect an AI tool with MCP, or download a Parquet file.

cURL · reports_kdca

reports_kdca

# Current release — the complete Parquet file
curl -sS -o reports-kdca.parquet \
  -H "x-api-key: $MOSTLYRIGHT_API_KEY" \
  "https://mostlyright.md/api/v2/public/tables/0b8ae885-ed95-4190-b4c0-e9c6510afa28/current"

# Bounded JSON query (schema at https://mostlyright.md/api/v2/public/tables/0b8ae885-ed95-4190-b4c0-e9c6510afa28/schema)
curl -sS "https://mostlyright.md/api/v2/public/tables/0b8ae885-ed95-4190-b4c0-e9c6510afa28/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.

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

Washington, DC weather reports and daily highs since 2020

reports_kdca

Release status