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", filing_year = 2020 and issue_code = "DEF" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2430612 | 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 | DEF | Lobbied OGR and HSGAC against H.R. 5329 and S. 2990, the "Freedom From Government Competition Act." Lobbied issues related to Commissary supply chain in connection with H.R. 6210, the "Family First Coronovirus Response Act." Lobbied Personal Protective Equipment issues related to Defense Product Act in H.R. 6390, the "Medical Supply Chain Emergency Act." Lobbied Armed Services Committees against TRANSCOM household goods management privatization. Lobbied HASC and SASC regarding Commissary and Child Care Personal Protective Equipment shortages. Lobbied HASC and SASC related to GAO review of DoD Plans to merge DeCA with Exchanges. Lobbied HASC and SASC related to NDAA 2020 GAO and FFRDC directed studies on borrowed military manpower, total force management, term and temporary abuses and hiring process. Lobbied in favor of H.R. 2581 and S. 1357, the "Nurse Staffing Standards for Hospital Patient Safety and Quality Care Act of 2019" being included in markup of National Defense Authorization act for Fiscal Year 2021 (NDAA 2021). Lobbied HASC, SASC, HAC-D, SAC-D, HAC-FSGG and SAC-FSGG to defund implementation of national security exception under chapter 71 of title 5 related to collective bargaining agreements. Lobbied for Congressional letters to Secretary of Defense Esper and President Trump regarding his delegation of authority to the Secretary of Defense to exclude collective bargaining from DoD or components of DoD. Lobbied HASC and SASC with language to condition implementation of Trump delegation of authority on Pentagon report to Congress subject to GAO review. Lobbied HAC-FSGG and SAC-FSGG for continuation of public-private competition moratorium. Lobbied HAC-D, HAC-FSGG and SAC-D, and SAC-FSGG for aligning Wage Grade and General Schedule localities related to pay. Lobbied HAC-D and SAC-D to conform section 8012 to Fiscal Year 2020 NDAA section 1103 regarding the repeal of personnel caps in DoD. Lobbied to prohibit misusing term or temporary hiring authorities for enduring functions. Lobbied… | 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);