lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1 row where filing_uuid = "0dcd02c4-e182-4f7f-8eb5-802e4b5e37ae" and issue_code = "HOM" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

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
2693611 AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 0dcd02c4-e182-4f7f-8eb5-802e4b5e37ae Q3 AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 54302 AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO 2021 third_quarter HOM FY 2022 Homeland Security Appropriations (H.R. 4431) --lobbied on provisions on the pay, benefits, contracting out, staffing levels, funding, and job security of DHS employees in CIS, ICE, CIS, FEMA, FPS, USCG, and TSA. Lobbied on issues surrounding safe workplaces under the coronavirus pandemic and standards for reopening of all agencies within Homeland Security. Lobbied in support of H.R. 903 and S. 1856, the "Rights for the Transportation Security Administration Workforce Act," which would grant Transportation Security Officers (TSOs) rights under Title 5 of the U.S. code and for preparation for reintroduction of similar legislation in the Senate. Provided technical assistance and communications with Committee members in preparation for House Homeland Security Committee markup of H.R. 903 on July 28, 2021. Lobbied to encourage cosponsors of the "Honoring Our Fallen TSA Heroes Act," (H.R. 2616) ensuring public safety officer benefits to TSOs killed or injured in the line of duty. Lobbied against any legislation that would allow for the privatization of airport ID checks and allowing private companies to determine whether a passenger is subject to secondary screening. Provided background on legislation to establish a temperature check pilot in airports to combat the spread of disease. Lobbied in support of H.R. 1813 and S. 2717, the "Funding for Aviation Screeners and Threat Elimination Restoration (FASTER) Act," to amend title 49, United States Code, to ensure that revenues collected from passengers as aviation security fees are used to help finance the costs of aviation security screening by repealing a requirement that a portion of such fees be credited as offsetting receipts and deposited in the general fund of the Treasury, and allowing funds to be used to pay the TSA workforce in the event of a government shutdown. Lobbied in support of H.R. 1893, the Transportation Security Preparation Act of 2021 to provide for planning and preparation in the event of a future communicable disease outbreak. Lob… 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,Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),General Services Administration (GSA),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),Voice of America   420000 0 0 2021-10-19T16:35:01.657000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);