Department of Homeland Security in Missouri

A thin DHS file on a Missouri tag

Department of Homeland Security as awarding agency, Missouri as place-of-performance: 664 records summing to $2,678,143,184.91. A Department of Homeland Security award coded outside MO is out. An award in Missouri from a different awarding agency is out even if the topic sounds related. Missouri (MO) excludes Kansas, Illinois, Iowa, Arkansas, Kentucky, Tennessee, Nebraska, and Oklahoma. An East St. Louis-coded award is Illinois.

Six hundred sixty-four awards is a thin DHS file. A large implied mean is what few rows do to a multi-billion dollar numerator. Unique recipients are unpublished. Do not read 664 as 664 unique disaster declarations, FEMA applicants, or named field offices. The overlay Department of Homeland Security in Missouri is the both-keys table. Missouri federal spending is the all-agency state hub. Department of Homeland Security is the agency book without an MO filter. All spending ties lists other joins.

St. Louis and Kansas City are unpublished. Do not treat the award count as two metro emergency lists. Correlation is not causation: Missouri did not “cause” $2,678,143,184.91 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × MO only.

Not a flood-declaration or applicant count

$2,678,143,184.91 does not measure disaster declarations, FEMA applicants, or named field offices. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 070 and an MO place-of-performance tag.

Do not treat 664 awards as a census of disaster declarations, FEMA applicants, or named field offices. Parent hubs are supposed to be larger than this pair. If Missouri federal spending or Department of Homeland Security matched $2,678,143,184.91 and 664, the join would be pointless. Use the overlay when both keys must stay on. Kansas, Illinois, and Arkansas DHS joins are other pairs, not addends.

Questions

How much has the Department of Homeland Security obligated in Missouri?

USAspending.gov records $2,678,143,184.91 across 664 awards with awarding agency 070 and a Missouri tag. That is an obligation join, not an outlay and not a count of disaster declarations, FEMA applicants, or named field offices. Department of Homeland Security in Missouri is the live overlay for this pair. Keep both keys when quoting $2,678,143,184.91.

Is $2,678,143,184.91 a measure of disaster declarations, FEMA applicants, or named field offices?

No. The packet publishes $2,678,143,184.91 and 664 awards for agency 070 inside MO 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 DHS file have 664 awards?

That is the award-record count for 070 × MO. Combined with $2,678,143,184.91, the average is about $4.03 million. Modifications and repeat instruments add rows. 664 is not unique disaster declarations, FEMA applicants, or named field offices. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Homeland Security in Missouri is the overlay. Missouri federal spending and Department of Homeland Security are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,678,143,184.91. USAspending.gov is the source. Obligations are not outlays.