Tired of Inconsistent Agency Names in SAM.gov?

"Department of Defense", "DOD", "DEPT OF DEFENSE" - Why does the same agency have 20 different names in government data? Download our free CSV that maps 1,400+ agency name variations to standardized names.

1,397

Agency Mappings

CSV

Format

100%

Free

Daily

Updated

CSV File Contents

The Problem: Same Agency, 20 Different Names

Department of Defense appears as: • "DEPT OF DEFENSE.DEFENSE LOGISTICS AGENCY" • "Department of Defense" • "DOD" • "Defense Department" • "US DEPARTMENT OF DEFENSE" • "DEPARTMENT OF DEFENSE (DOD)" ...and 50+ other variations Our CSV maps them all to: "DEPARTMENT OF DEFENSE"

CSV File Structure:

raw_agency_text,canonical_agency,department,confidence,frequency "DEPT OF DEFENSE.DEFENSE LOGISTICS AGENCY.DLA MARITIME...","DEFENSE LOGISTICS AGENCY","DEPT OF DEFENSE",0.9,8780 "VETERANS AFFAIRS, DEPARTMENT OF.250-NETWORK CONTRACT...","VETERANS AFFAIRS, DEPARTMENT OF","VETERANS AFFAIRS, DEPARTMENT OF",0.9,461
Column Descriptions:
  • raw_agency_text: Messy agency name from SAM.gov (exactly as it appears)
  • canonical_agency: Clean, standardized agency name
  • department: Parent department (DoD, VA, etc.)
  • confidence: How confident we are in this mapping (0-1)
  • frequency: How often this exact variation appears in contracts

1,397 agency mappings • Free download • No signup required

Finally Solve These Common Problems

"Where Are All The Navy Contracts?"

They're listed under "DEPT OF THE NAVY", "Department of the Navy", "US NAVY", "NAVAL", and 15 other variations. Our CSV maps them all to one standard name.

"My Analysis Counts Agencies Wrong"

Excel shows Department of Defense as 20 different agencies because of name inconsistencies. Fix this instantly with our standardized mappings.

"SAM.gov Search Misses Results"

Searching for "Air Force" misses contracts listed under "USAF", "DEPT OF THE AIR FORCE", etc. Know all the variations agencies use.

Need Federal Contract Data Too?

This free CSV is powered by GovCon API - the most comprehensive federal contracts database.

Explore Contract Opportunities API