lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where filing_uuid = "4f147b1c-3fcf-4e8d-987e-cf0f2c482f70" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2609426 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | DEF | Lobbied on Department of Defense Senate Confirmed Nominations with Questions and Questions for Record and Proposed Advanced Policy Questions related to Secretary of Defense Austin and Deputy Secretary of Defense Hicks. Lobbied on the following issues for the Fiscal Year 2022 National Defense Authorization Act by requesting House Armed Services Committee and Senate Armed Services Committee Members submit Member Requests Amendments on the following issues: 1.Inclusion of language in the FY 2022 NDAA that clarifies the civilian personnel cap prohibition in Section 129 of title 10 by removing ambiguous and contradictory language and clarifying prohibitions against using erm or temporary hiring authorities for enduring functions. 2.Inclusion of language in the FY 2022 NDAA that requires compliance with contract service planning, programming, and budgeting statutory requirements and Total Force Management statutory limitations on privatization (including compliance with the public-private competition moratorium). 3.Inclusion of language in the FY 2022 NDAA that aligns the Federal Wage System Areas with General Schedule Locality Pay Areas. 4.Inclusion of language in the FY 2022 NDAA that requires compliance of Reductions in Force procedures under Section 3502 of Title 5 (Seniority, Veterans Preference, Performance) repealing inconsistent provisions included in Section 1597(f) of title 10, United States Code, enacted in section 1101 of the National Defense Authorization Act for Fiscal Year 2016. 5.Inclusion of language in the FY 2022 NDAA that prohibits the downsizing of military medical treatment facilities by requiring Military Department Surgeon General Certifications and Government Accountability Office reviews addressing TRICARE quality of care standards and capacity; third party collections; readiness impacts; and efforts to backfill military structure with government civilian employees. 6.Inclusion of language in the FY 2022 prohibiting the merger of commissaries with exchanges, carrying forward and making pe… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609427 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | VET | Lobbied for changes to Veterans Benefits Administration's (VBA) employee performance standards. Lobbied against the severe reduction of "excluded time" proposed by the VA in the "#bestyearever" plan related to performance standards. Lobbied for increased oversight and changes to performance standards for Legal Administrative Assistants in the VBA National Call Centers. Lobbied for comprehensive changes to internal VBA processes for claims, including changes to the VBA National Work Queue. Lobbied on the processing of complex claims within the Veterans Benefits Administration, including how it relates to Military Sexual Trauma and Traumatic Brain Injury. Lobbied against the elimination of Claims Assistant positions across the VBA. Lobbied for the specialization of claims processing for highly complex cases. C&P Exams: Submitted a Statement for the Record on the House Veterans Affairs Committee Subcommittee on Disability Assistance and Memorial Affairs hearing titled VA compensation and pension exams during the covid-19 pandemic: a path forward. Lobbied against contracting out of Compensation and Pension (C&P) Exams and bringing those exams back into the VA. Lobbied to keep all specialty C&P Exams including but not limited to Traumatic Brain Injury (TBI), Post Traumatic Stress Disorder (PTSD), Military Sexual Trauma (MST), veterans who served as Prisoners of War (POWs), veterans who suffered catastrophic injuries, and veterans who are currently eligible (or will likely soon be eligible) to pursue toxic exposure claims. Lobbied for the VA to utilize more internal C&P Providers by hiring more staff and returning staff to C&P positions who had previously been reassigned. Lobbied to keep Integrated Disability Evaluation System (IDES) Exams within the VA. Collective Bargaining Rights: Lobbied for Congressional oversight on the VA's behavior during the negotiation of a new collective bargaining agreement. Lobbied on changes to the, "VA Accountability Act." Lobbied for the expanded use of telework du… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609428 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | BUD | Lobbied against negative impact on federal employees' compensation and benefits including requiring employees to pay additional salary towards retirement. FY 2022 Homeland Security Appropriations--Lobbied in support for additional funding of 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). FY 2022 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. FY 2022 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 2022 Interior and Environment Appropriations--Lobbied on provisions relating to full funding and staffing, implementation of Executive Order 14003, preventing the relocation, consolidation or closure of any EPA facility, and adequate health and safety protocols. FY 2022 Labor-HHS-Education Appropriations-Lobbied on contracting out, funding cuts to services such as college aid for students, rural healthcare services, and funding the National Institutes of Health (NIH), and status of collective bargaining. Lobbied against Administration proposal to close and transfer Forest Service Job Corps Civilian Conservation Centers. Lobbied for increased Social Security Administration funding and status of collective bargaining. Lobbied to restore adequate funding to the Social Security Administration for field operations and for telework and a review of legal assistant positions in the Office of Hearing Operations. Lobbied in support for… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609429 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | GOV | Lobbied for H.R. 302, Preventing a Patronage System Act or the PPSA Act. Lobbied for H.R. 326, Saving the Civil Service Act. Lobbied for H.R. 1272 and S. 392, the COST of Relocations Act. Lobbied in support of reintroduction of the "Federal Firefighters Fairness Act" to amend chapter 81 of title 5, creating a presumption that a disability or death of a federal employee in fire protection activities caused by any of certain diseases is the result of the performance of such employee's duty. Lobbied in support of H.R. 393, the "Federal Firefighter Pay Equity Act," to provide for more accurate computation of retirement benefits for federal firefighters. Lobbied in support of H. R. 521 / S. 129, the First Responder Fair RETIRE Act, to ensure federal firefighters, law enforcement officials, Border Patrol officers, and other federal first responders qualify for full retirement benefits if they are injured on the job. Lobbied in support of H.R. 938, the Wildland Firefighter Classification bill, to require the Director of the Office of Personnel Management to create a classification that more accurately reflects the vital role of wildland firefighters. Lobbied in support of S. 231, the PFAS bill, which directs FEMA to train employees on PFAS cancer causing chemicals in firefighting foam materials. Lobbied in support of H.R. 962, the "Law Enforcement Officer Equity Act," to include certain federal positions within the definition of law enforcement officer for retirement purposes. Lobbied on effects on workforce of proposed Sustainability Awareness Act. Lobbied in support of the "Equipment Safety for Firefighters Act." Lobbied in support of H.R. 603, the "Raise the Wage Act." Lobbied in support of H.R. 842, the "Protecting the Right to Organize Act of 2019." Lobbied against H.R. 1902 the "Do Your Job Act of 2019." Lobbied in support of H.R. 564, the "Comprehensive Paid Leave for Federal Employees Act," that would grant federal workers 12 weeks of paid FMLA. Lobbied in support of an emergency temporar… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609430 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | HOM | FY 2022 Homeland Security Appropriations--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, 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. Lobbied to encourage original cosponsors for reintroduction of the "Honoring Our Fallen TSA Heroes Act," 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. Briefed Homeland Security staff and chair on the status of vaccination availability to the various components of the Department of Homeland Security workforce. Lobbied on proposed Air Travel Task Force legislation for inclusion of the unionized workforce view in decision-making. Lobbied in support of H.R. 1813, 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. Lobbied in support of H.… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609431 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | CIV | Lobbied BOP to provide additional safety measures for correctional officers during the COVID-19 pandemic. FY 2022 Commerce-Justice-Science Appropriations--Lobbied against proposals to compromise the Equal Employment Opportunity Commissions (EEOC) ability to protect employees from employment discrimination, including staffing cuts and contracting out. FY 2022 Commerce-Justice-Science Appropriations--Lobbied for higher funding levels for Bureau of Prisons (BOP) and continued prohibition of closure of minimum security camps; lobbied for funding to hire adequate numbers of correctional staff; end the use of augmentation to compensate for lack of hiring correctional officer positions; alleviating overcrowding at high-security institutions; need to increase unit officer staff at high security institutions; and reduce the use of BOP contract prisons. Lobbied in support of language to end augmentation of corrections workers, hire more correctional officers, and phase out the use of private prisons. Lobbied in support of H.R. 6427, the "PANDEMIC ACT," to prevent the transfer of prisoners between Bureau of Prisons (BOP) facilities during the COVID-19 pandemic. Lobbied in support of H.R. 72, the "Thin Blue Line Act," which would make murdering a law enforcement officer an aggravated factor in sentencing for a capital crime. Lobbied in support of H.R. 3980 and S. 2264, "Eric's Law," to require that crimes punishable death receive a unanimous jury verdict, or a new jury be impaneled. Lobbied in support of H.R. 1, the "For the People Act," in particular its provisions to expand the participation of eligible voters in elections and its support for statehood for the District of Columbia. Lobbied in support of H.R. 5, the "Equality Act," which prohibits discrimination based on sex, sexual orientation, and gender identity in a wide variety of areas including public accommodations and facilities, education, federal funding, employment, housing, credit, and the jury system. Lobbied for passage of H.R. 1065, the "Pregn… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609432 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | AGR | FY 2022 Agriculture Appropriations - lobbied for provisions relating to pay, benefits, staffing levels, and job security of USDA employees. Lobbied to prohibit funds from being spent to create a modernized beef slaughter inspection system or issue line speed waivers to beef or hog slaughter plants. Lobbied for H.R. 1815 and S. 713, the "Safe Line Speeds in COVID-19 Act." H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609433 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | TAX | Lobbied to increase funding for the IRS and better target IRS tax enforcement. Lobbied for H.R. 1786 and S. 725, a bill to end offshore corporate tax avoidance, and for other purposes, known as the, No Tax Breaks for Outsourcing Act. Lobbied for S. 994, a bill to reinstate estate and generation-skipping taxes, and for other purposes, known as the, For the 99.5% Act. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609434 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | HCR | Lobbied to protect the Federal Employee Health Benefits Plan and against any premium increases. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609435 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | FOR | FY 2022 Foreign Operations Appropriations--lobbied on the provisions related to the pay, benefits, staffing levels, and job security of Department of State employees. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609436 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | HOU | FY 2022 Transportation, Housing and Urban Development (THUD) Appropriations--lobbied on contracting out, pay, benefits, and working conditions of federal employees in the Department of Housing and Urban Development. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609437 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | DOC | Lobbied for a provision in H.R. 1319, the "American Rescue Plan Act of 2021," to fix the fact that D.C. was treated as a territory instead of as a state in the Coronavirus Relief Fund the "CARES Act" and was deprived of $755 million as a result. Lobbied in support of H.R. 1, the "For the People Act," in particular its provision in support of statehood for the District of Columbia. Lobbied in support of H.R. 51, the "Washington, D.C. Admission Act." H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609438 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | IMM | FY 2022 Homeland Security Appropriations--lobbied on provisions on CPB, CIS, and ICE relating to contracting out, pay, benefits, staffing levels, safety, and job security of these DHS employees. Lobbied against further threat of furloughs of more than 70% of the U.S. Citizenship and Immigration Services (USCIS) workforce, effectively shutting down the agencys operations indefinitely. Specifically lobbied for full implementation of the Emergency Stopgap USCIS Stabilization Act, authorized in 2020. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609439 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | FOO | FY 2022 Agriculture Appropriations--lobbied against the contracting out of federal employee jobs and potential food and public risks. Lobbied against funding cuts of the meat and poultry inspection program. Lobbied against further expanding the program of putting plant employees, not inspectors, in charge of quality control and contamination. Lobbied to prohibit funds from being spent to create a modernized beef slaughter inspection system or issue line speed waivers to beef slaughter plants. Lobbied against the Food Safety and Inspection Services' (FSIS) rule on hog slaughter to eliminate hundreds of FSIS online inspector positions and transfer their responsibilities to rank and file hog company employees. Lobbied for H.R. 1815 and S. 713, the "Safe Line Speeds in COVID-19 Act." H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609440 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | LBR | Lobbied for appointment and confirmation of a quorum to the Merit Systems Protection Board to address the growing case backlog. Lobbied against any attempts the expand the Department of Veterans Affairs' Accountability and Whistleblower Protection Act government wide. Lobbied in support of H.R. 304, the "Equal COLA Act," to achieve parity between the cost-of-living adjustment to an annuity under the Federal Employees Retirement System and an annuity under the Civil Service Retirement System. Lobbied in support of the right of federal employees who are furloughed to be eligible for unemployment compensation. Lobbied in support of back pay for employees in the event of a lapse in appropriations. Lobbied in support of extended leave carryover due to COVID-19 pandemic. Lobbied in support of reintroduction of Protecting Employees' Security Clearances Act (PESCA), which requires consideration of a lapse in appropriations as a mitigating condition when assessing financial consideration for security clearances. Lobbied in support of H.R. 392/S. 561, the "Federal Adjustment of Income Rates Act," to provide federal employees with a 3.2% salary adjustment in 2022. Lobbied in support of H.R. 82, the "Social Security Fairness Act," to repeal the government pension offset and windfall elimination provisions. Lobbied in support of H.R. 7/S. 205, the "Paycheck Fairness Act," to amend the "Fair Labor Standards Act of 1938" to provide more effective remedies to victims of discrimination in the payment of wages on the basis of sex, and for other purposes. Lobbied against H.R. 1902 to eliminate the use of official time by federal employees. Lobbied for H.R. 1195, the Workplace Violence Prevention for Health Care and Social Service Workers Act, to require DOL to address workplace violence in the health care and social service sectors. Lobbied for H.R. 603/S. 53, the Raise the Wage Act, to increase the federal minimum wage for regular employees over a 7-year period, for tipped employees, and for newly hired em… | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-04:00 | |
| 2609441 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO 4f147b1c-3fcf-4e8d-987e-cf0f2c482f70 | Q1 | AMERICAN FED OF GOVERNMENT EMPLOYEES, AFL-CIO | 54302 | AMERICAN FED OF GOVERNMENT EMPLOYEES AFL-CIO | 2021 | first_quarter | NAT | FY 2022 Interior and Environmental Appropriations--lobbied on provisions relating to the pay, benefits, staffing levels, job security, and contracting out of Department of Interior (DOI) employees. Lobbied on provisions relating to full funding and staffing, implementation of Executive Order 14003, preventing the relocation, consolidation or closure of any EPA facility, and adequate health and safety protocols. FY 2022 Energy and Water Appropriations--Lobbied on provisions relating to consolidation or closure of any National Energy Technology Laboratories (NETL facilities, human capital authority at NETL and cuts in funding for fossil fuel research conducted at NETL. H.R. 1319, the "American Rescue Plan Act"--Lobbied for inclusion of emergency paid leave for frontline workers, presumption of workplace illness for purposes of workers compensation eligibility for frontline workers who contract Coronavirus, and opposed efforts to strip those provisions from the bill. Opposed efforts to reduce or eliminate official time, further privatize medical services at the Veterans Health Administration, further privatize federal prisons, deny recovery rebate payments to federal employees and their families, create a Schedule F class of federal employees who would have no job protections, reduce federal employees compensation and benefits, enact across-the-board cuts to federal programs, undermine Transportation Security Officers pay and benefits, further politicize the decision to relocate federal agencies and block District of Columbia residents from moving forward with statehood proceedings. | 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 | 399000 | 0 | 0 | 2021-04-20T09:34:46.917000-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);