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

2 rows where report_id = "IF12744"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ report_id bill_title congress bill_type bill_number bill_id
9624 Patent Law: An Introduction and Issues for Congress IF12744 A bill to amend title 35, United States Code, to invest in inventors in the United States, maintain the United States as the leading innovation economy in the world, and protect the property rights of the inventors that grow the economy of the United States, and for other purposes. 119 s 1553 119-s-1553
9625 Patent Law: An Introduction and Issues for Congress IF12744 To promote the leadership of the United States in global innovation by establishing a robust patent system that restores and protects the right of inventors to own and enforce private property rights in inventions and discoveries, and for other purposes. 119 hr 5811 119-hr-5811

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);