Department of Health and Human Services and Colorado as a join

The third Colorado agency pair in this inventory

Colorado appears with Social Security Administration, Department of Defense, and Department of Health and Human Services in this slice of ties. This page is only 075 × CO. $54,138,333,971.89 is the HHS obligation sum. 5,006 is the HHS award count. Adding the three Colorado joins would invent a combined number the packet does not give.

About $10.81 million per award follows from a relatively thin row count under a large dollar total. The mean is not a typical research grant and not a typical benefit. Award types are mixed in one obligation field.

Two numbers, one filter. $54,138,333,971.89 is the obligation sum inside the filter. 5,006 is how many award records remain. Stories that need a third number — years, outlays, unique vendors — have to look somewhere this packet does not go.

Agency 075 without Colorado, and Colorado without 075

The HHS agency hub drops the CO filter and will not equal $54,138,333,971.89. The Colorado state hub drops 075 and includes other awarding agencies. Overlay /states/co/agencies/075/ is the live both-keys table for 5,006 awards.

The architecture is simple. One hub is the agency without geography. One hub is the geography without this agency. One overlay is both. $54,138,333,971.89 and 5,006 belong to the overlay. The hubs answer different questions.

CO as a performance-state code

Place of performance Colorado excludes neighboring states. HHS awards tagged to those states are outside $54,138,333,971.89. Recipient headquarters can differ from performance state. The Colorado federal spending hub is the place to see 075 next to 028 and 097 as table neighbors, not as a single pipeline.

Geography here is the place-of-performance state on the award, not a metro name, not a commuting zone, and not a list of neighboring states. $54,138,333,971.89 does not grow because a region “feels” connected. Recipient address can differ from that state tag.

What 5,006 records can hide

A small number of large instruments can dominate $54,138,333,971.89. The overlay, not the average, is where that mix would be visible. This page has no outlay total and no year. The 5,006 count is not unique recipients.

De-obligation can shrink a prior commitment. The published figure is the harvested obligation aggregate.

Causation leftover

HHS obligations in Colorado do not measure health status and do not show that campaign contributions funded awards. Use Department of Health and Human Services in Colorado, Colorado federal spending, Department of Health and Human Services, and All spending ties.

How to read this pair next to the hubs

Colorado’s HHS pair is concentrated: $54,138,333,971.89 on 5,006 awards, about $10.81 million per record.

Department of Health and Human Services in Colorado is the filtered table. Colorado federal spending drops the agency key. Department of Health and Human Services drops the state key. All spending ties is the rest of the index. Attach $54,138,333,971.89 to both keys whenever it is quoted. 5,006 is records, not people.

Commitments are not disbursements. This harvest has no outlay column and no year column, so $54,138,333,971.89 is not “spent this year.” Place of performance is not a resident-benefit census. Neighboring states are other codes. FEC filings are another system.

If the overlay later disagrees with this snapshot, trust the live table. Do not add this join to other agency overlays on the same state hub. Do not treat the per-award average as a forecast. The pair is $54,138,333,971.89 on 5,006 awards.

State lines in USAspending are codes, not culture. Informal regions do not add into $54,138,333,971.89. A vendor headquartered elsewhere can still appear if performance is tagged here; a local vendor can vanish from 5,006 if performance is tagged elsewhere. Those coding facts are why this page will not narrate $54,138,333,971.89 as “the federal government chose this state” in a causal sense. It will narrate $54,138,333,971.89 as the obligation sum inside a two-field filter, with 5,006 records, on Department of Health and Human Services in Colorado, with parents at Colorado federal spending and Department of Health and Human Services.

Questions

How much has HHS obligated in Colorado?

USAspending records $54,138,333,971.89 in obligations for agency 075 with Colorado place of performance, on 5,006 awards. That is the HHS–Colorado pair only. The pair is awarding agency 075 (Department of Health and Human Services) and place-of-performance Colorado. It is not Department of Health and Human Services nationwide and not Colorado from every awarding agency.

Does this include Colorado’s SSA or DoD totals?

No. Those joins use agency codes 028 and 097. This page is 075 only: $54,138,333,971.89 on 5,006 awards. Only place-of-performance Colorado plus awarding agency 075 (Department of Health and Human Services) enter $54,138,333,971.89. Adjacent state codes are other filters, if they exist as ties at all.

Why is the average about $10.81 million?

Because $54,138,333,971.89 is divided across 5,006 awards. A thinner file raises the mean. The mean is not a typical award. That ratio uses only $54,138,333,971.89 and 5,006 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Are these outlays?

No. The aggregate is obligations. The 5,006 figure is an award-record count, not a payment count. USAspending’s source note for this aggregate is that obligations are not outlays. Place of performance Colorado is a geography tag, not a roster of residents, vendors, or named facilities.