uei_registry

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

97,796 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_fiscal_year, last_fiscal_year, match_method, created_at (date)

Next page

CREATE TABLE uei_registry (
            uei TEXT PRIMARY KEY,
            canonical_name TEXT NOT NULL,
            canonical_name_normalized TEXT NOT NULL,
            state TEXT,
            n_awards INTEGER NOT NULL,
            total_amount REAL,
            first_fiscal_year INTEGER,
            last_fiscal_year INTEGER,
            match_method TEXT,            -- how we resolved this UEI to an entity
            matched_entity_id INTEGER,
            matched_gov_unit_id INTEGER,
            created_at TEXT NOT NULL
        );
CREATE INDEX idx_ur_nn_state ON uei_registry(canonical_name_normalized, state);
CREATE INDEX idx_ur_nn ON uei_registry(canonical_name_normalized);