crs_report_bills

Cross-references between CRS reports and related legislation. Links CRS analysis to specific bills tracked in the legislation table.

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

11 rows where report_id = "IF12265"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress

id ▼ report_id bill_title congress bill_type bill_number bill_id
8203 China Primer: Human Rights IF12265   119 pub 119-75 119-pub-119-75
8204 China Primer: Human Rights IF12265   105 pub 105-292 105-pub-105-292
8205 China Primer: Human Rights IF12265   107 pub 107-228 107-pub-107-228
8206 China Primer: Human Rights IF12265   115 pub 115-330 115-pub-115-330
8207 China Primer: Human Rights IF12265   116 pub 116-260 116-pub-116-260
8208 China Primer: Human Rights IF12265   118 pub 118-70 118-pub-118-70
8209 China Primer: Human Rights IF12265   116 pub 116-145 116-pub-116-145
8210 China Primer: Human Rights IF12265   117 pub 117-78 117-pub-117-78
8211 China Primer: Human Rights IF12265   118 pub 118-31 118-pub-118-31
8212 China Primer: Human Rights IF12265   114 pub 114-328 114-pub-114-328
8213 China Primer: Human Rights IF12265   115 pub 115-232 115-pub-115-232

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE crs_report_bills (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id TEXT NOT NULL REFERENCES crs_reports(id),
    bill_title TEXT,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    bill_id TEXT
);
CREATE INDEX idx_crb_report ON crs_report_bills(report_id);
CREATE INDEX idx_crb_bill ON crs_report_bills(bill_id);