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

7 rows where bill_id = "113-sres-502"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
113-sres-502,Adoption and foster care A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Adoption and foster care
113-sres-502,Africa A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Africa
113-sres-502,Child health A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Child health
113-sres-502,Child safety and welfare A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Child safety and welfare
113-sres-502,Democratic Republic of the Congo A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Democratic Republic of the Congo
113-sres-502,Human rights A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Human rights
113-sres-502,Visas and passports A resolution concerning the suspension of exit permit issuance by the Government of the Democratic Republic of Congo for adopted Congolese children seeking to depart the country with their adoptive parents. 113-sres-502 Visas and passports

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