legislation_subjects

CRS legislative subject terms assigned to bills, useful for filtering by topic.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

13 rows where bill_id = "106-hjres-57"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-hjres-57,China Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 China
106-hjres-57,Civil Rights and Liberties, Minority Issues Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Civil Rights and Liberties, Minority Issues
106-hjres-57,Congress Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Congress
106-hjres-57,Congress and foreign policy Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Congress and foreign policy
106-hjres-57,Congressional veto Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Congressional veto
106-hjres-57,East Asia Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 East Asia
106-hjres-57,Emigration Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Emigration
106-hjres-57,Human rights Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Human rights
106-hjres-57,Immigration Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Immigration
106-hjres-57,International Affairs Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 International Affairs
106-hjres-57,Most favored nation principle Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Most favored nation principle
106-hjres-57,Normal trade relations Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Normal trade relations
106-hjres-57,Trade agreements Disapproving the extension of nondiscriminatory treatment (normal trade relations treatment) to the products of the People's Republic of China. 106-hjres-57 Trade agreements

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE legislation_subjects (
    bill_id TEXT REFERENCES legislation(bill_id),
    subject TEXT,
    PRIMARY KEY (bill_id, subject)
);
CREATE INDEX idx_legsub_subject ON legislation_subjects(subject);