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 = "R48936"

✎ 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
109322 The Electoral College: Frequently Asked Questions R48936   117 pub 117-328 117-pub-117-328
109323 The Electoral College: Frequently Asked Questions R48936 Proposing an amendment to the Constitution of the United States providing that the Senate is made more representative by adding twelve Senators to be elected using a national popular vote, and providing for twelve Electors at-large for President and Vice-President, who shall cast their ballots for the respective winners of the national popular vote. 119 hjres 102 119-hjres-102
109324 The Electoral College: Frequently Asked Questions R48936 Proposing an amendment to the Constitution of the United States to abolish the electoral college and to provide for the direct election of the President and Vice President of the United States. 118 hjres 227 118-hjres-227
109325 The Electoral College: Frequently Asked Questions R48936 A joint resolution proposing an amendment to the Constitution of the United States to abolish the electoral college and to provide for the direct election of the President and Vice President of the United States. 118 sjres 121 118-sjres-121
109326 The Electoral College: Frequently Asked Questions R48936 A joint resolution proposing an amendment to the Constitution to provide for the direct popular election of the President and Vice President of the United States. 95 sjres 1 95-sjres-1
109327 The Electoral College: Frequently Asked Questions R48936 A joint resolution proposing an amendment to the Constitution of the United States providing for the election of the President and the Vice President of the United States. 95 sjres 8 95-sjres-8
109328 The Electoral College: Frequently Asked Questions R48936 A joint resolution to amend the Constitution relating to the Electoral College. 95 sjres 18 95-sjres-18

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