Department of Health and Human Services in Colorado

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.

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.