home / openregs

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

9 rows where bill_id = "118-hjres-115"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-hjres-115,Administrative law and regulatory procedures Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Administrative law and regulatory procedures
118-hjres-115,Animal and plant health Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Animal and plant health
118-hjres-115,Congressional oversight Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Congressional oversight
118-hjres-115,Department of Agriculture Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Department of Agriculture
118-hjres-115,Food industry and services Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Food industry and services
118-hjres-115,Latin America Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Latin America
118-hjres-115,Meat Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Meat
118-hjres-115,Paraguay Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Paraguay
118-hjres-115,Trade restrictions Disapproving the rule submitted by the Department of Agriculture relating to "Importation of Fresh Beef From Paraguay". 118-hjres-115 Trade restrictions

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