ig_recommendations

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

3 rows where report_id = "2017-hurricane-relief-emergency-conservation-program"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: questioned_costs

Link rowid ▼ report_id rec_number significant text questioned_costs funds_for_better_use
5 5 2017 Hurricane Relief Emergency Conservation Program 2017-hurricane-relief-emergency-conservation-program 3 Yes Establish and implement monitoring procedures in guidance requiring State officials to ensure district directors complete reviews and evaluate the results of the reviews to ensure ECP policies are being followed. 718755 0
6 6 2017 Hurricane Relief Emergency Conservation Program 2017-hurricane-relief-emergency-conservation-program 4 Yes Establish and implement procedures in guidance to define how the district director reviews should be documented. 0 0
7 7 2017 Hurricane Relief Emergency Conservation Program 2017-hurricane-relief-emergency-conservation-program 5 Yes Establish and implement monitoring procedures in guidance requiring State officials to ensure county executive directors complete spot checks and evaluate the results of the reviews. 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);