Department of Health and Human Services in Nebraska

A thin HHS file on Nebraska

The pair is 075 × NE. $31,592,609,589.54 is the obligation sum. 1,861 is the award count. Fewer than two thousand records under $31.59 billion produces a mean near $16.98 million. A small number of large instruments can dominate. Ranking Nebraska against Iowa or Kansas would require other packets.

The join does not split Medicaid, research, or other labels. Those names are not in this aggregate.

$31,592,609,589.54 can look inevitable once it is printed in a headline. It is not. It is the sum of records that happen to carry both tags, 1,861 of them in this harvest. A different coding of place of performance would change the sum. So would a different awarding-agency code.

Agency 075 without Nebraska

The Department of Health and Human Services hub drops the NE filter and will not equal $31,592,609,589.54. The Nebraska hub drops 075. Overlay /states/ne/agencies/075/ is the both-keys table for 1,861 awards.

If a citation of $31,592,609,589.54 does not mention both the awarding agency and the place-of-performance state, it is not citing this join. If a citation of 1,861 does not mention both keys, it is not this file’s count.

Questions

How much has HHS obligated in Nebraska?

USAspending records $31,592,609,589.54 in obligations for agency 075 with Nebraska place of performance, on 1,861 awards. That is an obligation join, not an outlay total. The pair is awarding agency 075 (Department of Health and Human Services) and place-of-performance Nebraska.

Why is the average about $16.98 million?

Because $31,592,609,589.54 is divided by only 1,861 awards. A thin file raises the mean. The mean is not a typical grant. That ratio uses only $31,592,609,589.54 and 1,861 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Does this include Iowa or Kansas?

No. Place of performance is Nebraska only. Other states are outside $31,592,609,589.54 and outside the 1,861 awards. Only place-of-performance Nebraska plus awarding agency 075 (Department of Health and Human Services) enter $31,592,609,589.54. Adjacent state codes are other filters, if they exist as ties at all.

Are these outlays?

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