Department of Veterans Affairs in New Mexico

A high-count VA file on New Mexico

Department of Veterans Affairs as awarding agency, New Mexico as place-of-performance: 11,288 records summing to $4,282,922,469.95. A Department of Veterans Affairs award coded outside NM is out. An award in New Mexico from a different awarding agency is out even if the topic sounds related. New Mexico (NM) excludes Texas, Arizona, Colorado, Utah, and Oklahoma. An El Paso-coded award is Texas even if a veteran travels I-10.

Eleven thousand two hundred eighty-eight awards is a thick VA action file. Modifications add rows; unique veterans are unpublished. Unique recipients are unpublished. Do not read 11,288 as 11,288 unique veteran headcount, clinic visits, or disability ratings. The overlay Department of Veterans Affairs in New Mexico is the both-keys table. New Mexico federal spending is the all-agency state hub. Department of Veterans Affairs is the agency book without an NM filter. All spending ties lists other joins.

Albuquerque and Las Cruces are unpublished. Do not treat 11,288 as two metro clinic lists glued together. Correlation is not causation: New Mexico did not “cause” $4,282,922,469.95 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 036 × NM only.

Not a Four Corners enrollment ledger

$4,282,922,469.95 does not measure veteran headcount, clinic visits, or disability ratings. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 036 and an NM place-of-performance tag.

Do not treat 11,288 awards as a census of veteran headcount, clinic visits, or disability ratings. Parent hubs are supposed to be larger than this pair. If New Mexico federal spending or Department of Veterans Affairs matched $4,282,922,469.95 and 11,288, the join would be pointless. Use the overlay when both keys must stay on. Texas, Arizona, and Colorado VA joins are other pairs, not addends.

Questions

How much has the Department of Veterans Affairs obligated in New Mexico?

USAspending.gov records $4,282,922,469.95 across 11,288 awards with awarding agency 036 and a New Mexico tag. That is an obligation join, not an outlay and not a count of veteran headcount, clinic visits, or disability ratings. Department of Veterans Affairs in New Mexico is the live overlay for this pair. Keep both keys when quoting $4,282,922,469.95.

Is $4,282,922,469.95 a measure of veteran headcount, clinic visits, or disability ratings?

No. The packet publishes $4,282,922,469.95 and 11,288 awards for agency 036 inside NM 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 VA file have 11,288 awards?

That is the award-record count for 036 × NM. Combined with $4,282,922,469.95, the average is about $379,423. Modifications and repeat instruments add rows. 11,288 is not unique veteran headcount, clinic visits, or disability ratings. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Veterans Affairs in New Mexico is the overlay. New Mexico federal spending and Department of Veterans Affairs are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $4,282,922,469.95. USAspending.gov is the source. Obligations are not outlays.