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

16 rows where report_id = "R47240"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bill_title, congress, bill_type, bill_number, bill_id

id ▼ report_id bill_title congress bill_type bill_number bill_id
92928 Navigating the Appropriations Status Table R47240   117 pub 117-14 117-pub-117-14
92929 Navigating the Appropriations Status Table R47240   118 pub 118-42 118-pub-118-42
92930 Navigating the Appropriations Status Table R47240   118 pub 118-15 118-pub-118-15
92931 Navigating the Appropriations Status Table R47240   118 pub 118-82 118-pub-118-82
92932 Navigating the Appropriations Status Table R47240   118 pub 118-42 118-pub-118-42
92933 Navigating the Appropriations Status Table R47240   118 pub 118-47 118-pub-118-47
92934 Navigating the Appropriations Status Table R47240 A concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2022 and setting forth the appropriate budgetary levels for fiscal years 2023 through 2031. 117 sconres 14 117-sconres-14
92935 Navigating the Appropriations Status Table R47240 Providing for consideration of the bill (H.R. 4394) making appropriations for energy and water development and related agencies for the fiscal year ending September 30, 2024, and for other purposes, and providing for consideration of the bill (H.R. 4364) making appropriations for the Legislative Branch for the fiscal year ending September 30, 2024, and for other purposes. 118 hres 756 118-hres-756
92936 Navigating the Appropriations Status Table R47240 Making supplemental appropriations for the fiscal year ending September 30, 2024, and for other purposes. 118 hr 9468 118-hr-9468
92937 Navigating the Appropriations Status Table R47240 A concurrent resolution urging the establishment of a United States Commission on Truth, Racial Healing, and Transformation. 119 sconres 14 119-sconres-14
92938 Navigating the Appropriations Status Table R47240 Making appropriations for military construction, the Department of Veterans Affairs, and related agencies for the fiscal year ending September 30, 2024, and for other purposes. 118 hr 4366 118-hr-4366
92939 Navigating the Appropriations Status Table R47240 An original bill making appropriations for energy and water development and related agencies for the fiscal year ending September 30, 2024, and for other purposes. 118 s 2443 118-s-2443
92940 Navigating the Appropriations Status Table R47240 Making appropriations for energy and water development and related agencies for the fiscal year ending September 30, 2024, and for other purposes. 118 hr 4394 118-hr-4394
92941 Navigating the Appropriations Status Table R47240 Making continuing appropriations for fiscal year 2024, and for other purposes. 118 hr 5860 118-hr-5860
92942 Navigating the Appropriations Status Table R47240 Making appropriations for military construction, the Department of Veterans Affairs, and related agencies for the fiscal year ending September 30, 2024, and for other purposes. 118 hr 4366 118-hr-4366
92943 Navigating the Appropriations Status Table R47240 To reauthorize the Morris K. Udall and Stewart L. Udall Trust Fund, and for other purposes. 118 hr 2882 118-hr-2882

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