System For Award Management (SAM) Public Extract - Exclusions by US Government | Demographics and Population Studies

About this Dataset

System For Award Management (SAM) Public Extract - Exclusions

This dataset contains a daily snapshot of active exclusion records entered by the U.S. Federal government identifying those parties excluded from receiving Federal contracts, certain subcontracts, and certain types of Federal financial and non-financial assistance and benefits. The data was formerly contained in the Excluded Parties List System (EPLS). In July 2012, EPLS was incorporated into the System for Award Management (SAM). SAM is now the electronic, web-based system that keeps its user community aware of administrative and statutory exclusions across the entire government, and individuals barred from entering the United States. Users must read the exclusion record completely to understand how it impacts the excluded party.

Note - Here is the link for the SAM Functional Data Dictionary - https://www.sam.gov/SAM/transcript/SAM_Functional_Data_Dictionary.pdf
Organization: General Services Administration
Last updated: 2021-03-16T17:41:20.545431
Tags: black-list, debarred-list, epls, excluded-parties-list, ineligible-proceedings-completed, ineligible-proceedings-pending, list-of-exclusions, prohibition-restriction, sam, system-for-award-management, voluntary-exclusion

Tables

SAM Exclusions Public Extract GSA-1626

@usgov.gsa_gov_system_for_award_management_sam_public_extract_874a3219.sam_exclusions_public_extract_gsa_1626

5.46 MB
144058 rows
29 columns


CREATE TABLE sam_exclusions_public_extract_gsa_1626 (
  "classification" VARCHAR,
  "name" VARCHAR,
  "prefix" VARCHAR,
  "first" VARCHAR,
  "middle" VARCHAR,
  "last" VARCHAR,
  "suffix" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "city" VARCHAR,
  "state_province" VARCHAR,
  "country" VARCHAR,
  "zip_code" VARCHAR,
  "duns" VARCHAR,
  "exclusion_program" VARCHAR,
  "excluding_agency" VARCHAR,
  "ct_code" VARCHAR,
  "exclusion_type" VARCHAR,
  "additional_comments" VARCHAR,
  "active_date" TIMESTAMP,
  "termination_date" VARCHAR,
  "record_status" VARCHAR,
  "cross_reference" VARCHAR,
  "sam_number" VARCHAR,
  "cage" VARCHAR,
  "npi" DOUBLE,
  "creation_date" TIMESTAMP
);