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

7 rows where report_id = "R41364"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress, bill_type, bill_number, bill_id

id ▼ report_id bill_title congress bill_type bill_number bill_id
25203 Capital Gains Tax Options: Behavioral Responses and Revenues R41364   111 pub 111-312 111-pub-111-312
25204 Capital Gains Tax Options: Behavioral Responses and Revenues R41364   112 pub 112-240 112-pub-112-240
25205 Capital Gains Tax Options: Behavioral Responses and Revenues R41364   115 pub 115-97 115-pub-115-97
25206 Capital Gains Tax Options: Behavioral Responses and Revenues R41364   119 pub 119-21 119-pub-119-21
25207 Capital Gains Tax Options: Behavioral Responses and Revenues R41364   111 pub 111-312 111-pub-111-312
25208 Capital Gains Tax Options: Behavioral Responses and Revenues R41364 A bill to amend the Internal Revenue Code of 1986 to eliminate tax loopholes that allow billionaires to defer tax indefinitely through planning strategies such as "buy, borrow, die", to modify over 30 tax provisions so that billionaires are required to pay taxes annually, and for other purposes. 119 s 2845 119-s-2845
25209 Capital Gains Tax Options: Behavioral Responses and Revenues R41364 To amend the Internal Revenue Code of 1986 to eliminate tax loopholes that allow billionaires to defer tax indefinitely through planning strategies such as "buy, borrow, die", to modify over 30 tax provisions so that billionaires are required to pay taxes annually, and for other purposes. 119 hr 5427 119-hr-5427

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