Department of Education in Utah

A thinner Education file on Utah

Department of Education as awarding agency, Utah as place-of-performance: 1,014 records summing to $5,409,286,285.04. A Department of Education award coded outside UT is out. An award in Utah from a different awarding agency is out even if the topic sounds related. Utah (UT) excludes Idaho, Wyoming, Colorado, Arizona, Nevada, and New Mexico. A Las Vegas-coded award is Nevada.

One thousand fourteen awards is a thinner Education file. The implied mean is correspondingly higher because the denominator is smaller, not because enrollment is a packet fact. Unique recipients are unpublished. Do not read 1,014 as 1,014 unique enrollment, unique districts, or named universities. The overlay Department of Education in Utah is the both-keys table. Utah federal spending is the all-agency state hub. Department of Education is the agency book without a UT filter. All spending ties lists other joins.

Salt Lake and rural districts are unpublished. A thinner file is not evidence of a smaller student population; enrollment is not a packet fact. Correlation is not causation: Utah did not “cause” $5,409,286,285.04 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 091 × UT only.

1,014 rows are not 1,014 districts

$5,409,286,285.04 does not measure enrollment, unique districts, or named universities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 091 and a UT place-of-performance tag.

Do not treat 1,014 awards as a census of enrollment, unique districts, or named universities. Parent hubs are supposed to be larger than this pair. If Utah federal spending or Department of Education matched $5,409,286,285.04 and 1,014, the join would be pointless. Use the overlay when both keys must stay on. Colorado, Idaho, and Nevada Education joins are other pairs, not addends.

Questions

How much has the Department of Education obligated in Utah?

USAspending.gov records $5,409,286,285.04 across 1,014 awards with awarding agency 091 and an Utah tag. That is an obligation join, not an outlay and not a count of enrollment, unique districts, or named universities. Department of Education in Utah is the live overlay for this pair. Keep both keys when quoting $5,409,286,285.04.

Is $5,409,286,285.04 a measure of enrollment, unique districts, or named universities?

No. The packet publishes $5,409,286,285.04 and 1,014 awards for agency 091 inside UT 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 Education file have 1,014 awards?

That is the award-record count for 091 × UT. Combined with $5,409,286,285.04, the average is about $5.33 million. Modifications and repeat instruments add rows. 1,014 is not unique enrollment, unique districts, or named universities. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Education in Utah is the overlay. Utah federal spending and Department of Education are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $5,409,286,285.04. USAspending.gov is the source. Obligations are not outlays.