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

7 rows where report_id = "R49352"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ report_id bill_title congress bill_type bill_number bill_id
112086 Mongolia: In Brief R49352 To support and promote the human rights of Southern Mongolians in the People's Republic of China, and for other purposes. 119 hr 6877 119-hr-6877
112087 Mongolia: In Brief R49352 A bill to support and promote human rights of Southern Mongolians in the People's Republic of China, and for other purposes. 119 s 288 119-s-288
112088 Mongolia: In Brief R49352 To promote United States-Mongolia trade by authorizing duty-free treatment for certain imports from Mongolia, and for other purposes. 118 hr 6539 118-hr-6539
112089 Mongolia: In Brief R49352 To enhance the security, resilience, and protection of critical undersea infrastructure vital to Taiwan's national security, economic stability, and defense, particularly in countering gray zone tactics employed by the People's Republic of China, and for other purposes. 119 hr 8177 119-hr-8177
112090 Mongolia: In Brief R49352 A bill to enhance the security, resilience, and protection of undersea communication cables vital to Taiwan's national security, economic stability, and defense, particularly in countering gray zone tactics employed by the People's Republic of China, and for other purposes. 119 s 2222 119-s-2222
112091 Mongolia: In Brief R49352 Reaffirming the strategic partnership between the United States and Mongolia and observing the 30th anniversary of democracy in Mongolia. 116 hres 1100 116-hres-1100
112092 Mongolia: In Brief R49352 A resolution reaffirming the strategic partnership between the United States and Mongolia and recognizing the 30th anniversary of democracy in Mongolia. 117 sres 36 117-sres-36

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