Department of Transportation federal obligations in Kansas

A thin-mid DOT file on Kansas

Department of Transportation as awarding agency, Kansas as place-of-performance: 993 records summing to $3,385,209,567.82. A Department of Transportation award coded outside KS is out. An award in Kansas from a different awarding agency is out even if the topic sounds related. Kansas (KS) excludes Nebraska, Missouri, Oklahoma, and Colorado. A Kansas City, Missouri-coded award is MO.

Nine hundred ninety-three awards is a thin-mid DOT file: more than a handful of lab-style cells, fewer than a USDA assistance flood. Unique recipients are unpublished. Do not read 993 as 993 unique lane-miles, unique contractors, or named Interstates. The overlay Department of Transportation in Kansas is the both-keys table. Kansas federal spending is the all-agency state hub. Department of Transportation is the agency book without a KS filter. All spending ties lists other joins.

Wichita and Topeka are unpublished. Do not treat 993 as two metro project lists glued together. Correlation is not causation: Kansas did not “cause” $3,385,209,567.82 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × KS only.

Not a two-city highway ranking

$3,385,209,567.82 does not measure lane-miles, unique contractors, or named Interstates. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and a KS place-of-performance tag.

Do not treat 993 awards as a census of lane-miles, unique contractors, or named Interstates. Parent hubs are supposed to be larger than this pair. If Kansas federal spending or Department of Transportation matched $3,385,209,567.82 and 993, the join would be pointless. Use the overlay when both keys must stay on. Missouri, Oklahoma, and Nebraska DOT joins are other pairs, not addends.

Kansas, not a Kansas City bi-state rollup

Place of performance KS is a geography tag on the award, not a metro list and not a commuting zone. Kansas (KS) excludes Nebraska, Missouri, Oklahoma, and Colorado. A Kansas City, Missouri-coded award is MO. Recipient address can differ from that state tag.

Wichita and Topeka are unpublished. Do not treat 993 as two metro project lists glued together. This packet does not split $3,385,209,567.82 by city, county, or named facility. 993 awards stay statewide. A county table would be a different extract.

Formula grants versus cash in the ground

Even a thick or thin file records obligations, not necessarily outlays. $3,385,209,567.82 can include amounts that pay on a later schedule. Citing it as cash already sent in Kansas confuses two concepts. Deobligations and upward adjustments both move the total.

Kansas’s own budget is a different ledger. Mixing it with the 993-award USAspending file leaves this series. No fiscal year is published in this packet, so this page does not invent one. Keep the obligation label on $3,385,209,567.82.

Citing DOT in Kansas

Cite USAspending.gov: Department of Transportation (agency 069) obligated $3,385,209,567.82 on 993 awards coded to Kansas. Name both sides. Keep “obligations.” Do not relabel the total as lane-miles, unique contractors, or named Interstates.

Prefer Department of Transportation in Kansas if the overlay has refreshed after an ingest. Kansas federal spending still includes every other awarding agency tagged to KS. Department of Transportation is the 069 parent without the KS filter. All spending ties indexes other pairs. Do not add those parents into $3,385,209,567.82.

A usable footnote names Department of Transportation, Kansas, $3,385,209,567.82, and 993. The compact headline $3.39 billion is that same dollar total rounded. It is not a second extract. The implied mean near $3.41 million is $3,385,209,567.82 divided by 993. Means are not medians. USAspending.gov remains the originating system.

Nine hundred ninety-three awards is a thin-mid DOT file: more than a handful of lab-style cells, fewer than a USDA assistance flood. On this join the implied mean near $3.41 million should not be treated as a typical award size. Without a distribution, $3,385,209,567.82 can be dominated by a few rows even when 993 is large, or by those same few rows when 993 is small. This page will not pretend to know which pattern holds. It keeps repeating the two facts and the two keys: Department of Transportation (069) and Kansas (KS). Place of performance still does not mean every dollar was disbursed locally. Obligations still do not mean outlays. Wichita and Topeka are unpublished. Do not treat 993 as two metro project lists glued together.

Questions

How much has the Department of Transportation obligated in Kansas?

USAspending.gov records $3,385,209,567.82 across 993 awards with awarding agency 069 and a Kansas tag. That is an obligation join, not an outlay and not a count of lane-miles, unique contractors, or named Interstates. Department of Transportation in Kansas is the live overlay for this pair. Keep both keys when quoting $3,385,209,567.82.

Is $3,385,209,567.82 a measure of lane-miles, unique contractors, or named Interstates?

No. The packet publishes $3,385,209,567.82 and 993 awards for agency 069 inside KS coding. Those other series are unpublished here. Unique recipients are unpublished. Quote the dollar total and the award count together. Obligations are not outlays.

Why does this DOT file have 993 awards?

That is the award-record count for 069 × KS. Combined with $3,385,209,567.82, the average is about $3.41 million. Modifications and repeat instruments add rows. 993 is not unique lane-miles, unique contractors, or named Interstates. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Transportation in Kansas is the overlay. Kansas federal spending and Department of Transportation are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $3,385,209,567.82. USAspending.gov is the source. Obligations are not outlays.