ig_recommendations

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

1 row where report_id = "2022-audit-cfpbs-information-security-program"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ report_id rec_number significant text questioned_costs funds_for_better_use
12 12 2022 Audit of the CFPB’s Information Security Program 2022-audit-cfpbs-information-security-program 4 No Ensure that an enterprisewide software inventory is conducted and maintained. 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE ig_recommendations (
    report_id TEXT REFERENCES ig_reports(report_id),
    rec_number TEXT,
    significant TEXT,
    text TEXT,
    questioned_costs INTEGER DEFAULT 0,
    funds_for_better_use INTEGER DEFAULT 0
);
CREATE INDEX idx_ig_rec_report ON ig_recommendations(report_id);
CREATE INDEX idx_ig_rec_sig ON ig_recommendations(significant);