lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "ba2f9664-e7fb-4ece-b814-ba8354d84886" and issue_code = "BUD" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2430609 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO ba2f9664-e7fb-4ece-b814-ba8354d84886 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2020 | first_quarter | BUD | FY 2021 Budget Resolution - lobbied against the Presidents FY 2021 budget. Lobbied against negative impact on federal employees' compensation and benefits including requiring employees to pay additional salary towards retirement. Lobbied against privatizing of airport screening jobs. FY 2021 Homeland Security Appropriations--Lobbied in support for additional funding of Customs and Border Protection (CBP), Immigration and Customs Enforcement (ICE), Citizenship and Immigration Services (CIS), Federal Emergency Management Agency (FEMA), Coast Guard (USCG), Federal Protective Service (FPS), and Transportation Security Administration (TSA). Specifically, lobbied for retention of prohibitions against the OMB Circular A-76 process in the Coast Guard's National Vessel Documentation Center (NVDC) and on certain positions in CIS related to investigating and adjudicating immigration rights benefits. Lobbied for funding to increase number of Transportation Security Officer (TSO) full time equivalents (FTEs) and other personnel issues. FY 2021 Defense Appropriations -- Lobbied in support of limitations on use of appropriated funds for service contracts unless their planning, programming and budgeting is in compliance with section 2329 of title 10 and related total force management statutes. House directive report language (pp. 12-13) FY 2021 Military Quality of Life/Veterans Affairs Appropriations--Lobbied in support for funding to hire new employees to fill vacancies; provisions to provide adequate funding for VA health and benefits programs and against further contracting out. Lobbied for the inclusion of language to prevent unilateral implementation of collective bargaining agreements. FY 2021 Interior and Environment Appropriations - Lobbied for adequate funding of EPA, National Endowment for the Arts and Humanities, issues related to contracting out, pay, and working conditions of federal employee jobs and proposed EPA spending cuts. FY 2021 Labor-HHS-Education Appropriations-Lobbied on contracting out,… | Agriculture, Dept of (USDA),Air Force, Dept of,Army, Dept of (Corps of Engineers),Army, Dept of (Other),Bureau of Citizenship & Immigration Services (BCIS),Commerce, Dept of (DOC),Defense Commissary Agency,Defense Contract Audit Agency (DCAA),Defense, Dept of (DOD),Defense Finance & Accounting Service (DFAS),Education, Dept of,Energy, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Navy, Dept of,Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Immigration & Customs Enforcement (ICE),U.S. Marines,Veterans Affairs, Dept of (VA) | 464000 | 0 | 0 | 2020-04-17T10:38:27.953000-04: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,
income_amount INTEGER,
expense_amount INTEGER,
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);