ig_reports

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

34,880 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_type, date_issued (date)

Next page

CREATE TABLE ig_reports (
    report_id TEXT PRIMARY KEY,
    title TEXT,
    date_issued TEXT,
    report_number TEXT,
    report_type TEXT,
    agency_reviewed TEXT,
    submitting_oig TEXT,
    location TEXT,
    description TEXT,
    num_recommendations INTEGER DEFAULT 0,
    questioned_costs INTEGER DEFAULT 0,
    funds_for_better_use INTEGER DEFAULT 0,
    pdf_url TEXT,
    detail_url TEXT
);
CREATE INDEX idx_ig_date ON ig_reports(date_issued);
CREATE INDEX idx_ig_agency ON ig_reports(agency_reviewed);
CREATE INDEX idx_ig_type ON ig_reports(report_type);
CREATE INDEX idx_ig_oig ON ig_reports(submitting_oig);