home / openregs

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

5 rows where report_id = "IF10256"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress, bill_type

id ▼ report_id bill_title congress bill_type bill_number bill_id
2848 U.S.-Taiwan Trade and Economic Relations IF10256   118 pub 118-13 118-pub-118-13
2849 U.S.-Taiwan Trade and Economic Relations IF10256   117 pub 117-167 117-pub-117-167
2850 U.S.-Taiwan Trade and Economic Relations IF10256 To amend the Internal Revenue Code of 1986 to provide special rules for the taxation of certain residents of Taiwan with income from sources within the United States. 119 hr 33 119-hr-33
2851 U.S.-Taiwan Trade and Economic Relations IF10256 A bill to amend the Internal Revenue Code of 1986 to provide special rules for the taxation of certain residents of Taiwan with income from sources within the United States. 119 s 199 119-s-199
2852 U.S.-Taiwan Trade and Economic Relations IF10256 A bill to promote the energy security of Taiwan, and for other purposes. 119 s 2722 119-s-2722

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);
Powered by Datasette · Queries took 941.273ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API