lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where filing_uuid = "a00df7ab-e38f-468f-83e5-e246a291da0b" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 634192 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | TRD | World Customs Organization exercise to revise Chapters 84, 85, and 90 of the Harmonized Tariff System (print cartridges, power modules, multichip devices, video games, recorded and unrecorded media) European environmental regulations (EU RoHS, EU WEEE review, EUP and Energy Efficiency activities) (need for global harmonization of RoHS requirements) Monitoring China's compliance with the World Trade Organization commitments (Intellectual Property, Industrial policies, development of new standards, Government Procurement Agreement negotiations, encryption regulations) WTO Doha Development Agenda (trade facilitation, electronics sectoral, non-tariff barriers, e-commerce, market access) Chinese environmental regulations (China RoHS, China WEEE, Energy Efficiency Activities) Customs and Border Protection classification issues (LCD displays, print cartridges) China Intellectual Property Rights DOC Deemed Export Proposed Regulations (all provisions) India Market Access (non tariff barriers, IT Law Amendments, Tax Issues, Government Procurement, US-India ICT Dialogue) US China Bilateral Relationship (Joint Commission on Commerce and Trade, US-China Strategic Economic Dialogue, Government Procurement negotiations) Substance bans as TBTs (Technical Barriers to Trade) China RoHS, Korea RoHS, Thailand RoHS, EU RoHS, WEEE, REACH US Malaysia FTA - government procurement, rules of origin, customs, trade facilitation, technical barriers to trade, investment, telecommunications, services, e-commerce, intellectual property rights, tariff reduction WTO maintenance of Information Technology Agreement (all provisions for treatment of information technology products, supporting efforts to get changes in EU policies under ITA that remove IT products from coverage) US - Peru FTA supporting the agreements, specifically interested in rules of origin, customs, trade facilitation, technical barriers to trade, investment, telecommunications, services, e-commerce, intellectual property rights, government procurement ,tariff reduction under … | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634193 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | ACC | General issues involving congressional oversight of the Financial Standards Accounting Board (FASB), International Accounting Standards Board (IASB), FASB and IASB policies regarding stock option accounting, the Sarbanes-Oxley Act and other related issues S. 1726 The Business Activity Simplification Act of 2007 - All provisions relating to business activity taxes H.R. 5267, The Business Activity Simplification Act of 2008, all provisions relating to business activity taxes H.R. 1049 Amend Misinterpreted Excessive Regulation in Corporate America Act, provisions relating to the internal controls requirements of the Sarbanes-Oxley Act H.R. 2727 Small Business SOX Compliance Extension Act, Small Business SOX Compliance Extension Act, provisions relating to the Sarbanes-Oxley Act's internal controls requirements S. 2209, Research Credit Improvement Act of 2007, all provisions relating to the R&D tax credit | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634194 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | TAX | S. 1726 the Business Activity Simplification Act of 2007, all provisions relating to business activity taxes H.R. 5267, The Business Activity Simplification Act of 2008, all provisions relating to business activity taxes. H.R. 5140, Economic Stimulus Act of 2008, provisions relating to business incentives HR 5107, Giving Resources and Opportunities to the Workforce Act of 2008, provisions relating to expensing business assets and net operating losses S. 2539 provisions relating to special depreciation allowance for certain property HR 4995, Middle Class Jobs Protection Act of 2008, provisions relating to expensing business assets, bonus depreciation, and carrybacks for certain net operating losses. HR 2138 Investment in America Act of 2007, entire bill relating to R&D tax credit S. 41 Research Competitiveness Act of 2007, entire bill relating to R&D tax credit H.R. 3418 Employee Educational Assistance Act of 2007, bill provides for a permanent exclusion from gross income for employer-provided educational assistance H.R. 3996, Temporary Tax Relief Act of 2007, bill relating to simplification and fairness in the administration and collection of sales and use taxes S. 34 Sales Tax Fairness and Simplification Act, bill relating to simplification and fairness in the administration and collection of sales and use taxes H.R. 3970, Tax Reduction and Reform Act of 2007, provisions relating to R&D tax credit, and other business tax provisions S. 2209, Research Credit Improvement Act of 2007, bill relating to R&D tax credit HR 6049, Renewable Energy and Job Creation Act of 2008, a bill to extend certain expiring tax provisions S. 3125, Energy Independence and Tax Relief Act of 2008, a bill to extend certain expiring tax provisions | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634195 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | TEC | S. 1492 Broadband Data Improvement Act - All provisions related to broadband S. 1190 Connect the Nation Act- All provisions - All provisions related to broadband H.R. 1818 Broadband Deployment Acceleration Act- All provisions related to broadband H.R. 3281 Community Broadband Act- All provisions - All provisions related to broadband | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634196 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | CPT | HR 275 Global Online Freedom Act - Title I and II relates to liability for companies storing personal information in countries designated as Internet restricting countries. Online Behavioral Advertising - Proposed self-regulated principles on online advertising Congressional Internet Caucus Advisory Committee - Review of Internet Issues on Capitol Hill | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634197 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | HCR | S. 1693 Wired For Health Care Quality Act - Provisions on the deployment of electronic health records H.R. 3800 Promoting Health Information Technology Act - Provisions on the deployment of electronic health records H.R. 1467 10,000 Trained by 2010 - Provisions on the increase in the number of qualified Health IT workers by 2010 | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634198 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | BUD | H.R. 2638 Department of Homeland Security Appropriations Act, 2008 - Provisions on funding government scientific research & education S. 1644 Department of Homeland Security Appropriations Act, 2008 - Provisions on funding government scientific research & education S. 1751 Energy and Water Development Appropriations Act, 2008 - Provisions on funding government scientific research & education H.R. 2641 Energy and Water Development and Related Agencies Appropriations Act, 2008 - Provisions on funding government scientific research & education H.R. 3093 Commerce, Justice, Science, and Related Agencies Appropriations Act, 2008 - Provisions on funding government scientific research & education S. 1745 Departments of Commerce and Justice, Science, and Related Agencies Appropriations Act, 2008 - Provisions on funding government scientific research & education H.R. 2829 Financial Services Appropriations Act, 2008 - Provisions on funding government scientific research & education Omnibus Appropriations Bill HR 2764 - Provisions on funding government scientific research & education Omnibus Appropriations Bill S. 2764 - Provisions on funding government scientific research & education H.R. 2642 Supplemental Appropriations Act, 2008 - Provisions on funding Government science research and education | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634199 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | IMM | H.R. 2538 Defend the American Dream Act of 2007- Provisions relating to the increase in the number of H1B and Green Cards H.R. 1930 SKIL Act of 2007 - Provisions relating to the increase in the number of H1B and Green Cards S. 1351 H-1B Visa Program Modernization Act of 2007 - All provisions relating to expansion of Visas S. 1397 Skilled Worker Immigration and Fairness Act - Provisions relating to the increase in the number of H1B and Green Cards | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634200 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | EDU | H.R. 2272 21st Century Competitiveness Act of 2007 (Same as S. 761) S. 761 America Creating Opportunities to Meaningfully Promote Excellence in Technology, Education, and Science Act - Provisions for the creation of programs for science technology, engineering, and math. Also provides for the increase in funding for DOE, NIST, NSF | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634201 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | CPI | H.R 275 Global Online Freedom Act - Title I and II relates to liability for companies storing personal information in countries designated as Internet restricting countries Online Behavioral Advertising - Proposed self-regulated principles on online advertising Congressional Internet Caucus Advisory Committee - Review of Internet Issues on Capitol Hill | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-04:00 | |
| 634202 | AMERICAN ELECTRONICS ASSOCIATION a00df7ab-e38f-468f-83e5-e246a291da0b | Q2 | AMERICAN ELECTRONICS ASSOCIATION | 2263 | AMERICAN ELECTRONICS ASSOCIATION | 2008 | second_quarter | SCI | HR 5819, the SBIR / STTR Reauthorization Act, a bill that amends the Small Business Act to improve the Small Business Innovation Research (SBIR) program and the Small Business Technology Transfer (STTR) program. | Commerce, Dept of (DOC),Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Natl Security Council (NSC),Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR),White House Office | 256000 | 0 | 0 | 2008-07-17T14:57:10-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);