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

8 rows where report_id = "R43631"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress, bill_number, bill_id

id ▼ report_id bill_title congress bill_type bill_number bill_id
46746 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   108 pub 108-446 108-pub-108-446
46747 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   108 pub 108-446 108-pub-108-446
46748 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   94 pub 94-142 94-pub-94-142
46749 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   111 pub 111-5 111-pub-111-5
46750 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   108 pub 108-446 108-pub-108-446
46751 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   101 pub 101-476 101-pub-101-476
46752 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   94 pub 94-142 94-pub-94-142
46753 The Individuals with Disabilities Education Act (IDEA), Part C: Early Intervention for Infants and Toddlers with Disabilities R43631   99 pub 99-457 99-pub-99-457

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 380.319ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API