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

7 rows where bill_id = "97-s-2188"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2188,Authorization A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Authorization
97-s-2188,Community development A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Community development
97-s-2188,Community development corporations A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Community development corporations
97-s-2188,Corporations and Stocks A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Corporations and Stocks
97-s-2188,District of Columbia A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 District of Columbia
97-s-2188,Economics and Public Finance A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Economics and Public Finance
97-s-2188,Government corporations A bill to amend the Pennsylvania Avenue Development Corporation Act of 1972 to authorize appropriations and further borrowings for implementation of the development plan for Pennsylvania Avenue between the Capitol and the White House, and for other purposes. 97-s-2188 Government corporations

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