Department of Energy in New Jersey

A very thin Energy file on a New Jersey tag

Department of Energy as awarding agency, New Jersey as place-of-performance: 201 records summing to $2,658,673,808.65. A Department of Energy award coded outside NJ is out. An award in New Jersey from a different awarding agency is out even if the topic sounds related. New Jersey (NJ) excludes New York, Pennsylvania, and Delaware. A New York City-coded award is NY even if a New Jersey utility appears in folklore.

Two hundred one awards is a very thin Energy file. A large implied mean is what few rows do to a multi-billion dollar numerator. Unique recipients are unpublished. Do not read 201 as 201 unique lab employees, megawatts, or named national laboratories. The overlay Department of Energy in New Jersey is the both-keys table. New Jersey federal spending is the all-agency state hub. Department of Energy is the agency book without an NJ filter. All spending ties lists other joins.

Princeton-area lab folklore is unpublished. Unique recipients are unpublished. Do not treat 201 as unique facilities. Correlation is not causation: New Jersey did not “cause” $2,658,673,808.65 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 089 × NJ only.

Not a lab-headcount or megawatt series

$2,658,673,808.65 does not measure lab employees, megawatts, or named national laboratories. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 089 and an NJ place-of-performance tag.

Do not treat 201 awards as a census of lab employees, megawatts, or named national laboratories. Parent hubs are supposed to be larger than this pair. If New Jersey federal spending or Department of Energy matched $2,658,673,808.65 and 201, the join would be pointless. Use the overlay when both keys must stay on. New York and Pennsylvania Energy joins are other pairs, not addends.

Questions

How much has the Department of Energy obligated in New Jersey?

USAspending.gov records $2,658,673,808.65 across 201 awards with awarding agency 089 and a New Jersey tag. That is an obligation join, not an outlay and not a count of lab employees, megawatts, or named national laboratories. Department of Energy in New Jersey is the live overlay for this pair. Keep both keys when quoting $2,658,673,808.65.

Is $2,658,673,808.65 a measure of lab employees, megawatts, or named national laboratories?

No. The packet publishes $2,658,673,808.65 and 201 awards for agency 089 inside NJ 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 DOE file have 201 awards?

That is the award-record count for 089 × NJ. Combined with $2,658,673,808.65, the average is about $13.23 million. Modifications and repeat instruments add rows. 201 is not unique lab employees, megawatts, or named national laboratories. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Energy in New Jersey is the overlay. New Jersey federal spending and Department of Energy are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,658,673,808.65. USAspending.gov is the source. Obligations are not outlays.