sam_entities

One row per registered federal entity, ingested from the SAM.gov Entity Management API v4 (/entities list endpoint) by build_sam_entities. The authoritative federal entity registry — the directory of organizations registered to do business with or receive assistance from the U.S. government — keyed by the Unique Entity ID (uei). This anchors organization/entity resolution across the corpus: the same UEI ties a commenting organization to its registered identity. Filtered to public active registrations (registrationStatus=A). Scope is deliberately list-level only (no per-entity detail fetches), and ingest is bounded and incremental (deduped on uei). All columns are stored as VARCHAR.

• Parquet file: sam_entities.parquet
• Queryable via MCP query_sql: Yes

Column	Type	Description
uei	VARCHAR	Unique Entity ID (SAM ueiSAM, 12-char alphanumeric, e.g. Q93HWX24PGA4). Primary key / dedup key; the entity-resolution join key.
cage_code	VARCHAR	Commercial and Government Entity (CAGE) code assigned to the entity. Often null for newly registered entities.
legal_business_name	VARCHAR	Legal business name as registered in SAM.gov.
dba_name	VARCHAR	'Doing business as' name, when the entity registered one. Often null.
entity_structure_desc	VARCHAR	Entity structure description (coreData.generalInformation.entityStructureDesc, e.g. Corporate Entity (Not Tax Exempt)).
entity_type_desc	VARCHAR	Entity type description (e.g. Business or Organization).
profit_structure_desc	VARCHAR	Profit-structure description (e.g. For Profit Organization, Non-Profit Organization).
state	VARCHAR	State or province code of the physical address (coreData.physicalAddress.stateOrProvinceCode). Null for many non-US registrants.
city	VARCHAR	City of the physical address.
zip_code	VARCHAR	ZIP / postal code of the physical address.
congressional_district	VARCHAR	U.S. congressional district of the physical address (coreData.congressionalDistrict). Null for non-US registrants.
primary_naics	VARCHAR	Primary NAICS industry code the entity asserted (assertions.goodsAndServices.primaryNaics). Often null.
registration_status	VARCHAR	Registration status as returned by the API (e.g. Active). The ingest filters on the request-side registrationStatus=A.
registration_date	VARCHAR	Date the entity's current registration was recorded (ISO 8601 string).
registration_expiration_date	VARCHAR	Date the current registration expires (ISO 8601 string).
exclusion_status_flag	VARCHAR	Whether the entity has an active exclusion/debarment record (Y/N).
purpose_of_registration_desc	VARCHAR	Purpose-of-registration description (e.g. Federal Assistance Awards, All Awards).
entity_url	VARCHAR	Entity's self-reported website URL (coreData.entityInformation.entityURL). Often null.