lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "e44aff86-3f38-4d51-a275-f7ca9511ffe9" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2917032 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | HOM | H.R. 3233: National Commission to Investigate the January 6 Attack on the United States Capitol Complex Act | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917033 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | LAW | H.J.Res. 53: Proposing an amendment to the Constitution of the United States to prohibit the use of slavery and involuntary servitude as a punishment for a crime; H.R. 2584: Judiciary Act of 2021; H.R. 7647: Supreme Court Ethics, Recusal, and Transparency Act of 2022 | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917034 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | FIN | H.R. 1996: SAFE Banking Act of 2021 | SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917035 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | DEF | H.R. 7900: National Defense Authorization Act for Fiscal Year 2023; H.R. 8900: To amend the National Defense Authorization Act for Fiscal Year 2021, to authorize certain prizes for the development of non-PFAS-containing turnout gear, and for other purposes | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917036 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | FOR | H.J.Res. 87: Directing the removal of United States Armed Forces from hostilities in the Republic of Yemen that have not been authorized by Congress | HOUSE OF REPRESENTATIVES | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917037 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | LBR | H.R. 1065: Pregnant Workers Fairness Act | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917038 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | COM | PN 1536 -- Confirm Gigi B. Sohn -- Federal Communications Commission | Executive Office of the President (EOP) | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917039 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | IMM | H.R. 8685: Afghan Adjustment Act | HOUSE OF REPRESENTATIVES | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917040 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | CIV | H.R. 8404/S. 4556: Respect for Marriage Act. | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
| 2917041 | MOVEON.ORG CIVIC ACTION e44aff86-3f38-4d51-a275-f7ca9511ffe9 | Q4 | MOVEON.ORG CIVIC ACTION | 401106098 | MOVEON.ORG CIVIC ACTION | 2022 | fourth_quarter | ECN | H.R. 2471: Consolidated Appropriations Act, 2022. | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-01-18T13:46:29-05:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);