Department of State in Connecticut

State Department 019 awards tagged to Connecticut

Department of State as awarding agency, Connecticut as place-of-performance: 726 records summing to $57,804,814.22. A Department of State award coded outside CT is out. An award in Connecticut from a different awarding agency is out even if the topic sounds related. Connecticut (CT) excludes New York, Massachusetts, and Rhode Island. A New York-coded award is NY even if a vendor sits in Fairfield County. Awarding agency 019 is the published State key. Keep 019 in the citation so this cell is not mixed with another Connecticut State slug.

Seven hundred twenty-six records against $57,804,814.22 is a mid-count State Department file on awarding-agency 019, thicker than Massachusetts’s 179-row 019 cell and still not unique contractors. Unique recipients are unpublished. Do not read 726 as 726 unique posts, named missions, or unique contractors. The overlay Department of State in Connecticut is the both-keys table. Connecticut federal spending is the all-agency state hub. Department of State is the agency book without a CT filter. All spending ties lists other joins. Agency code 019 is the disambiguator on this duplicate slug. Do not merge it with a different State code in another Connecticut join. Named contractors are unpublished. Correlation is not causation: Connecticut did not cause $57,804,814.22 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 019 × CT only.

Not embassies, named posts, or unique contractors

$57,804,814.22 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 a CT place-of-performance tag. Awarding agency 019 is the published State key. Keep 019 in the citation so this cell is not mixed with another Connecticut State slug.

Do not treat 726 awards as a census of unique posts, named missions, or unique contractors. Parent hubs are supposed to be larger than this pair. If Connecticut federal spending or Department of State matched $57,804,814.22 and 726, the join would be pointless. Use the overlay when both keys must stay on. New York, Massachusetts, and Rhode Island State Department joins are other pairs, not addends. Keep 019 on $57,804,814.22. A thicker row list than Massachusetts does not rank Connecticut as a larger diplomatic state.

Questions

How much has the Department of State obligated in Connecticut?

USAspending.gov records $57,804,814.22 across 726 awards with awarding agency 019 and a Connecticut 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 Connecticut is the live overlay for this pair. Keep both keys when quoting $57,804,814.22.

Is $57,804,814.22 a measure of unique posts, named missions, or unique contractors?

No. The packet publishes $57,804,814.22 and 726 awards for agency 019 inside CT 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 726 State 019 awards mean 726 Connecticut posts?

No. 726 is the award-record count for 019 × CT. Combined with $57,804,814.22, the average is about $79,621. Modifications and repeat instruments add rows. 726 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 019–Connecticut table?

Department of State in Connecticut is the overlay. Connecticut 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 $57,804,814.22. USAspending.gov is the source. Obligations are not outlays.