lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where filing_uuid = "3ed8100d-b2ec-4f0a-acd2-e548cf813d15" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 471250 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | BNK | Corporate Bankruptcy Reforms; Bayh-Conyers Bill (H.R. 5113; S. 2556) | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471251 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | CHM | Chemical Security | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471252 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | DEF | Defense Authorization bills (FY 2007); Defense Appropriations bills (FY 2007); DOD Buy American Requirements, C17 Aircraft; Contracting Out. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471253 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | TRD | CAFTA; U.S.-Thailand Free Trade Agreement; US-Korea FTA; Oman FTA; Peru FTA; Malaysia FTA; Exchange rates/currency intervention; OECD Guidelines for Multinational Enterprises; Fast Track Renewal; Columbia FTA; WTO Doha Negotiations. Monitoring China WTO Membership; NAFTA; Japan, Korea and China Auto Trade; Worker Rights & WTO; Export-Import Bank; IMF Bailouts; Trade Adjustment Assistance; International Worker Rights; Free Trade Area of the Americas (FTAA); Andean Free Trade Pact; | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471254 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | CIV | Fair Pay Act; ENDA; Hate Crimes Legislation; Funding for Civil Rights enforcement activities; Racial Profilling legislation; charitable choice legislation; Affirmative Action; Voting Rights Act; DC Voting Rights Legislation (H.R. 5338). | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471255 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | TAX | Efforts to make Bush tax cuts permanent; Section 120 - Group Legal Services; Estate tax repeal; Tax extenders | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471256 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | RET | Social Security - reform and solvency; privatization proposals; stock market investments; COLA protection; Private Pensions - Administration pension proposals; Boehner bill; Grassley-Baucus bill; Enzi-Kennedy bill; Thomas bill; PBGC deficit; Cash Balance plans; funding rules; Interest rate assumptions; Assets smoothing proposals; benefit limits; credit ratings; credit balances; Erie Legislation - ADEA and retiree health benefits; Enron related legislation; Investment advice legislation. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471257 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | BAN | Consumer financial issues; Abusive credit practices; Credit Union Conversions; Industrial Loan Corporations | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471258 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | EDU | Vouchers/Education Savings Accounts; School Construction; Class Size reduction; Head Start Reauthorization; Higher Education Reauthorization; No Child Left Behind-Funding | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471259 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | TOR | Asbestos trust fund legislation | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471260 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | MMM | Medicare Prescription Drug law-modifications; Medicaid (Increase state match; restoration of benefits to Immigrants; block grant proposals; Medicaid waivers; funding cuts); Asset transfers. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471261 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | HCR | Insurance Program (SCHIP); drugs & medical device safety; tax credits for uninsured; HSAs;AHPs; Health Care Information Technology; Healthcare Choice Act; Drug Safety; Bioshield; Health Disparities; Pandemic Flu; Avian Flu Vaccine; Safe Patient Handling; T.B.; Ryan White Reauthorization; Medicare for All; Generic Biologics; GASB Retiree Health. Taxation of health care benefits; Catastrophic Reinsurance; Health care for retirees; Medical Errors (Patient safety); Pay-for-performance; Medical malpractice; Prescripton Drug Prices; Greater Access to Affordable Pharmaceuticals Act; State Child Health | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471262 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | BUD | FY07 Budget resolutions; Commerce, Justice, Science Appropriations and Science, State Judiciary & Commerce Appropriaations; (Legal Services Corp.) FY 2007; VA-HUD Appropriations (Housing Programs), FY 2007; Labor-HHS Appropriations (NLRB, OSHA, Labor Dept., Training Programs), FY 2007; FY 2007 Social Security Administration. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471263 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | GOV | Election Day Holiday bill; Judicial and Executive Branch Nominations; Election Reform funding and security Lobby reforms; Sunset Commissions. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471264 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | IMM | Legal immigration - H-1B program; H-2A program; other guest worker programs; Legalization Programs; foreign students; Kennedy-McCain bill; Kyl-Cornyn bill; Hagel bill. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471265 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | LBR | Family Time Flexibility Act;Minimum Wage Legislation; Expansion of Family and Medical Leave Act; Federal Prisons Industries Competition Contracting Act; Card Check Recognition; Kennedy-Miller Employee Free Choice Act (S.842;HR 1696); Kentucky River cases; NYU recognition campaign Metalworking fluids health effects; World Trade Center Compensation Fund; Combustible Dust Standard. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471266 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | UNM | Dislocated Workers/Job Training - Reauthorization; Unemployment Insurances - devolution; personal re-employment accounts; career accounts; Workforce Investment Act; Reauthorization (Wagner Payser Act) | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471267 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | FAM | Child Care; Welfare Reauthorization; Healthy Families Act | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471268 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | AUT | Global Warming; CAFE legislation-administration proposal; Barton and Lott bills; Obama bills; Advanced Technology Vehicles - Tax Credits/Conversion/Grants; Marshall Plan for Auto Industry. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-05:00 | |
| 471269 | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 3ed8100d-b2ec-4f0a-acd2-e548cf813d15 | YY | UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 39052 | UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS | 2006 | year_end | HOU | National Housing Trust Fund; Low Income Housing Assistance; Fair Housing. | Export-Import Bank of the United States (EXIM Bank),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 764630 | 0 | 0 | 2007-02-08T09:30:00-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,
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);