home / openregs

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 = "94-834"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress

id ▼ report_id bill_title congress bill_type bill_number bill_id
51 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   91 pub 91-93 91-pub-91-93
52 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   94 pub 94-440 94-pub-94-440
53 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   97 pub 97-35 97-pub-97-35
54 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   97 pub 97-253 97-pub-97-253
55 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   98 pub 98-270 98-pub-98-270
56 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   98 pub 98-21 98-pub-98-21
57 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   98 pub 98-369 98-pub-98-369
58 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   99 pub 99-177 99-pub-99-177
59 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   99 pub 99-509 99-pub-99-509
60 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   100 pub 100-119 100-pub-100-119
61 Cost-of-Living Adjustments for Federal Civil Service Annuities 94-834   103 pub 103-66 103-pub-103-66

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);
Powered by Datasette · Queries took 19.414ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API