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

13 rows where report_id = "R49343"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ report_id bill_title congress bill_type bill_number bill_id
111999 Agriculture and Related Agencies: FY2027 Appropriations R49343   119 pub 119-103 119-pub-119-103
112000 Agriculture and Related Agencies: FY2027 Appropriations R49343   119 pub 119-4 119-pub-119-4
112001 Agriculture and Related Agencies: FY2027 Appropriations R49343   119 pub 119-37 119-pub-119-37
112002 Agriculture and Related Agencies: FY2027 Appropriations R49343   119 pub 119-75 119-pub-119-75
112003 Agriculture and Related Agencies: FY2027 Appropriations R49343   118 pub 118-42 118-pub-118-42
112004 Agriculture and Related Agencies: FY2027 Appropriations R49343   119 pub 119-103 119-pub-119-103
112005 Agriculture and Related Agencies: FY2027 Appropriations R49343 Making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies programs for the fiscal year ending September 30, 2027, and for other purposes. 119 hr 8646 119-hr-8646
112006 Agriculture and Related Agencies: FY2027 Appropriations R49343 Making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies programs for the fiscal year ending September 30, 2027, and for other purposes. 119 hr 8646 119-hr-8646
112007 Agriculture and Related Agencies: FY2027 Appropriations R49343 An original bill making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies for the fiscal year ending September 30, 2025, and for other purposes. 118 s 4690 118-s-4690
112008 Agriculture and Related Agencies: FY2027 Appropriations R49343 Making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies programs for the fiscal year ending September 30, 2026, and for other purposes. 119 hr 4121 119-hr-4121
112009 Agriculture and Related Agencies: FY2027 Appropriations R49343 An original bill making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies for the fiscal year ending September 30, 2026, and for other purposes. 119 s 2256 119-s-2256
112010 Agriculture and Related Agencies: FY2027 Appropriations R49343 Making appropriations for military construction, the Department of Veterans Affairs, and related agencies for the fiscal year ending September 30, 2026, and for other purposes. 119 hr 3944 119-hr-3944
112011 Agriculture and Related Agencies: FY2027 Appropriations R49343 Providing for consideration of the bill (H.R. 8646) making appropriations for Agriculture, Rural Development, Food and Drug Administration, and Related Agencies programs for the fiscal year ending September 30, 2027, and for other purposes; providing for consideration of the bill (H.R. 7726) to amend the Child Care and Development Block Grant Act of 1990 to withhold funds from noncompliant States under such Act; providing for consideration of the bill (H.R. 7892) to amend the Higher Education Act of 1965 to require to the Secretary of Education to use an identity fraud detection system to review each FAFSA to determine whether the FAFSA presents a reasonable suspicion of identity fraud; and providing for consideration of the bill (H.R. 8872) to amend part A of title IV of the Social Security Act to target funds to low-income families, strengthen program integrity guardrails for State expenditure of funds, require measurement of improper payments, and establish goals for eliminating fraud and improper payments under the program of block grants to States for temporary assistance for needy families, and for other purposes. 119 hres 1333 119-hres-1333

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