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

10 rows where report_id = "94-636"

✎ 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
27 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   103 pub 103-121 103-pub-103-121
28 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   103 pub 103-121 103-pub-103-121
29 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   103 pub 103-317 103-pub-103-317
30 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   98 pub 98-111 98-pub-98-111
31 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   100 pub 100-459 100-pub-100-459
32 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   101 pub 101-246 101-pub-101-246
33 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636   103 pub 103-236 103-pub-103-236
34 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636 Agriculture Environmental Restoration Act of 1990 101 hr 4782 101-hr-4782
35 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636 Part-Time and Temporary Workers Protection Act of 1991 102 hr 3793 102-hr-3793
36 Radio and Television Broadcasting to Cuba: Background and Issues Through 1994 94-636 Departments of Commerce, Justice, and State, the Judiciary and Related Agencies Appropriations Act, 1995 103 hr 4603 103-hr-4603

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