Department of State in Ohio

A thicker State Department file on Ohio

Department of State as awarding agency, Ohio as place-of-performance: 408 records summing to $64,078,673.66. A Department of State award coded outside OH is out. An award in Ohio from a different awarding agency is out even if the topic sounds related. Ohio (OH) excludes Pennsylvania, Michigan, Indiana, Kentucky, and West Virginia. A Pittsburgh-coded award is PA even if a vendor sits in Cleveland. Awarding agency 019 can mix diplomatic and domestic instruments. The packet does not name the mix.

Four hundred eight records against $64,078,673.66 is thicker than Minnesota’s 122-row State cell and still a record count, not unique contractors. Unique recipients are unpublished. Do not read 408 as 408 unique posts, named missions, or unique contractors. The overlay Department of State in Ohio is the both-keys table. Ohio federal spending is the all-agency state hub. Department of State is the agency book without an OH filter. All spending ties lists other joins. Columbus, Cleveland, and Cincinnati are unpublished. Do not treat 408 as unique Ohio vendors. Correlation is not causation: Ohio did not cause $64,078,673.66 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 019 × OH only.

Not embassies, named posts, or unique contractors

$64,078,673.66 does not measure unique posts, named missions, or unique contractors. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 019 and an OH place-of-performance tag. Awarding agency 019 can mix diplomatic and domestic instruments. The packet does not name the mix.

Do not treat 408 awards as a census of unique posts, named missions, or unique contractors. Parent hubs are supposed to be larger than this pair. If Ohio federal spending or Department of State matched $64,078,673.66 and 408, the join would be pointless. Use the overlay when both keys must stay on. Pennsylvania, Indiana, and Michigan State Department joins are other pairs, not addends. Four hundred eight is not unique Ohio contractors. Modifications can add rows.

Questions

How much has the Department of State obligated in Ohio?

USAspending.gov records $64,078,673.66 across 408 awards with awarding agency 019 and an Ohio tag. That is an obligation join, not an outlay and not a count of unique posts, named missions, or unique contractors. Department of State in Ohio is the live overlay for this pair. Keep both keys when quoting $64,078,673.66.

Is $64,078,673.66 a measure of unique posts, named missions, or unique contractors?

No. The packet publishes $64,078,673.66 and 408 awards for agency 019 inside OH coding. Those other series are unpublished here. Unique recipients are unpublished. Quote the dollar total and the award count together. Obligations are not outlays. Keep both keys.

Does 408 State awards mean 408 Ohio posts?

No. 408 is the award-record count for 019 × OH. Combined with $64,078,673.66, the average is about $157,056. Modifications and repeat instruments add rows. 408 is not unique posts, named missions, or unique contractors. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live State Dept–Ohio table?

Department of State in Ohio is the overlay. Ohio federal spending and Department of State are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $64,078,673.66. USAspending.gov is the source. Obligations are not outlays.