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

15 rows where bill_id = "110-s-3441"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-3441,Energy facilities Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Energy facilities
110-s-3441,Energy storage Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Energy storage
110-s-3441,Federal preemption Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Federal preemption
110-s-3441,Federal-state relations Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Federal-state relations
110-s-3441,Foreign Trade and International Finance Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Foreign Trade and International Finance
110-s-3441,Government Operations and Politics Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Government Operations and Politics
110-s-3441,Government paperwork Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Government paperwork
110-s-3441,Imports Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Imports
110-s-3441,Liquefied natural gas Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Liquefied natural gas
110-s-3441,Marine terminals Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Marine terminals
110-s-3441,Pipelines Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Pipelines
110-s-3441,Public meetings Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Public meetings
110-s-3441,State laws Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 State laws
110-s-3441,Transportation and Public Works Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Transportation and Public Works
110-s-3441,Transportation safety Liquefied Natural Gas Import Terminal Authorization Act 110-s-3441 Transportation safety

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