spending_awards

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

198,007 rows where agency = "Department of Transportation" sorted by award_amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE spending_awards (
    generated_internal_id TEXT PRIMARY KEY,
    award_id TEXT,
    agency TEXT,
    sub_agency TEXT,
    award_category TEXT,
    award_type TEXT,
    recipient_name TEXT,
    recipient_name_normalized TEXT,
    recipient_uei TEXT,
    recipient_duns TEXT,
    recipient_id TEXT,
    recipient_location_state TEXT,
    award_amount REAL,
    total_outlays REAL,
    description TEXT,
    start_date TEXT,
    end_date TEXT,
    fiscal_year INTEGER,
    state_code TEXT,
    cfda_number TEXT,
    naics_code TEXT,
    naics_description TEXT,
    last_modified TEXT
);
CREATE INDEX idx_spending_agency ON spending_awards(agency);
CREATE INDEX idx_spending_category ON spending_awards(award_category);
CREATE INDEX idx_spending_fy ON spending_awards(fiscal_year);
CREATE INDEX idx_spending_recipient ON spending_awards(recipient_name);
CREATE INDEX idx_spending_recipient_norm ON spending_awards(recipient_name_normalized);
CREATE INDEX idx_spending_recip_fy ON spending_awards(recipient_name_normalized, fiscal_year);
CREATE INDEX idx_spending_uei ON spending_awards(recipient_uei) WHERE recipient_uei IS NOT NULL;
CREATE INDEX idx_spending_duns ON spending_awards(recipient_duns) WHERE recipient_duns IS NOT NULL;
CREATE INDEX idx_spending_state ON spending_awards(state_code);