Department of Health and Human Services in New Mexico

HHS crossed with New Mexico

Keep agency 075 and place-of-performance NM. The obligation sum in this harvest is $37,853,152,078.42. The award count is 7,228. Neither figure is New Mexico’s full federal ledger. Neither is HHS nationwide.

About $5.24 million per award is the ratio. It mixes award types. Indian Health Service, Medicaid, and research labels are not in this packet, so they are not assigned shares of $37,853,152,078.42.

$37,853,152,078.42 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, 7,228 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 the NM filter

The Department of Health and Human Services hub will not equal $37,853,152,078.42 because it drops the state key. New Mexico’s state hub drops 075. Overlay /states/nm/agencies/075/ is the both-keys table for 7,228 awards.

Neither parent page equals this pair. The awarding-agency hub omits the state and will not show $37,853,152,078.42 as its total. The state hub omits the agency and will not isolate 7,228 records for this pair. Relationship pages exist so those two omissions are not papered over.

Questions

How much has HHS obligated in New Mexico?

USAspending records $37,853,152,078.42 in obligations for agency 075 with New Mexico place of performance, on 7,228 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 New Mexico.

What is the average award?

About $5.24 million ($37,853,152,078.42 ÷ 7,228). The average mixes award types and is not a typical grant. That ratio uses only $37,853,152,078.42 and 7,228 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Does this include tribal health programs by name?

The facts are agency 075 and place-of-performance NM totaling $37,853,152,078.42 on 7,228 awards. Program names and tribal geography are not in this aggregate. Only place-of-performance New Mexico plus awarding agency 075 (Department of Health and Human Services) enter $37,853,152,078.42. Adjacent state codes are other filters, if they exist as ties at all.

Are Texas or Arizona included?

No. Place of performance is New Mexico only. Other states are outside $37,853,152,078.42. Only place-of-performance New Mexico plus awarding agency 075 (Department of Health and Human Services) enter $37,853,152,078.42. Adjacent state codes are other filters, if they exist as ties at all.