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

11 rows where report_id = "R48921"

✎ 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
109181 Paid Sick Leave in the United States R48921   116 pub 116-127 116-pub-116-127
109182 Paid Sick Leave in the United States R48921   116 pub 116-92 116-pub-116-92
109183 Paid Sick Leave in the United States R48921   116 pub 116-127 116-pub-116-127
109184 Paid Sick Leave in the United States R48921 To allow Americans to earn paid sick time so that they can address their own health needs and the health needs of their families. 119 hr 7531 119-hr-7531
109185 Paid Sick Leave in the United States R48921 A bill to allow Americans to earn paid sick time so that they can address their own health needs and the health needs of their families. 119 s 3869 119-s-3869
109186 Paid Sick Leave in the United States R48921 To amend the Fair Labor Standards Act of 1938 to provide compensatory time for employees in the private sector. 119 hr 2870 119-hr-2870
109187 Paid Sick Leave in the United States R48921 To require employers to provide paid annual leave to employees, and for other purposes. 119 hr 4763 119-hr-4763
109188 Paid Sick Leave in the United States R48921 To allow Americans to earn paid sick time so that they can address their own health needs and the health needs of their families. 116 hr 1784 116-hr-1784
109189 Paid Sick Leave in the United States R48921 A bill to enhance the rights of domestic employees, and for other purposes. 119 s 3396 119-s-3396
109190 Paid Sick Leave in the United States R48921 To amend title 49, United States Code, with respect to sick leave for certain employees of Class I railroads, and for other purposes. 118 hr 3255 118-hr-3255
109191 Paid Sick Leave in the United States R48921 A bill to amend the Fair Labor Standards Act of 1938 to provide compensatory time for employees in the private sector. 119 s 1158 119-s-1158

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