lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where filing_uuid = "2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429085 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | DEF | H.R. 5631: FY '07 Defense Appropriations: Title II: O&M H.R. 5631: FY '07 Defense Appropriations: Title III: National Guard & Reserve Equipment H.R. 5631: FY '07 Defense Appropriations: Title IV: R&D Test and Evaluation | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429086 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | LBR | H.R. 1748: Union Member Freedom to Strike Act H.R. 27: Job Training Improvement Act H.R. 874: Secret Ballot Protection Act | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429087 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | TRD | S. 295: China Currency Legislation S. 1421: United State Trade Rights Enforcement Act H.R. 3066: Trade Reduction Legislation: Tractor Body Parts H.R. 3067: Trade Reduction Legislation: Log Forwards H.R. 32: Stop Counterfeiting Manufactured Goods Act Russian WTO Accession Negotiations Ukraine WTO Accession Negotiations | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429088 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | BAN | H.R. 1461: Federal Housing Enterprise Regulatory Reform Act of 2005 S. 190: Federal Housing Enterprise Regulatory Reform Act of 2005 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429089 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | MAN | H.R. 250: Manufacturers Technology Competitiveness ACt of 2005 FY '07 CJSS Appropriations; Manufacture Extension Program | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429090 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | TEC | S. 714: Junk Fax Prevention Act S. 2389: Protection Consumers Phone Records Act H.R. 29: SPAYWARE Act H.R. 2995: Intellectual Property Jursidiction Clarification Act H.R. 6: Energy Policy Act of 2005; Section 1287: Privacy; P.L. 109-58 H.R. 744: Internet Spyware Prevention Act H.R. 4127: Data Accountability and Trust Act H.R. 3997: Financial Data Protection Act | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429091 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | CPT | H.R. 683: Trademark Dilution Act of 2005 H.R. 2791: Patent Free Diversion H.R. 2830: Patent Reform Act | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429092 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | RET | S. 219: National Employee Savings & Trust Guarantee ACt S. 1158: Stop Terminating our Pensions Act H.R. 2830: Pension Protection Act H.R. 2831: Pension Preservation & Portability Act | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429093 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | FIN | S. 1326: Notification of Risk to Personal Data Act of 2005 S. 1332: Peraonal Data Privacy S. 190: Federal Housing Enterprise Regulatory Reform Act of 2005 S. 687: SPY Block Act S. 751: Data Breach Notification Act S. 810: Safeguarding Americans from Exporting Identification Data Act S. 1408: Identify Theft Protection Act S. 1864: Amend IRS Code of 1986 to change farm machinery & equipment as a 5-year property for depreciation S. 1216: Financial Privacy Breech Notification Act of 2005 H.R. 3505: Financial Services Regulatory Relief Act of 2005 H.R. 1461: Federal Housing Enterprise Regulatory Reform Act of 2005 H.R. 1653: Safeguarding Americans from Exporting Identification Data Act H.R. 32: Stop Counterfeiting in Manufactured Goods Act H.R. 4236: Amend IRS Code of 1986 to change farm machinery & equipment as a 5-year property for deprecation | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429094 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | AGR | H.R. 3081: Renewable Fuels Act of 2005 S. 573: Agricultural Security Assistance Act of 2005 S. 1804: Agriculture Assistance Act of 2005 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429095 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | TAX | S. 1066: Economic Development Act of 2005 S. 1076: Biodiesel Tax Extension S. 1359: Retirement Savings & Security Act of 2005 S. 1447: Tax Technical Corrections Act of 2005 S. 1696: Katrina Emergency Tax Relief Act, P.L. 109-73 S. 1826: Older Worker Oppertunity Act S. 309: Flexible Spending Arrangement (FSA) Carryover S. 35: Amend IRS Code of 1986 for Permanent Extension of PTC for Wind S. 627: R&D Tax Credit Extension Act S. 7: Extend Tax Relief for Dividends & Capital Gains S. 715: Wind Power Tax Incentive Act S. 1864: Amend IRS Tax Code of 1986 to treat farm equipment as 5-year property for depreciation S. 2020: Tax Relief Act of 2005; P.L. 109-222 S. 420: Permanent Death Tax Repeal H.R. 141: Amend IRS Code of 1986 for Permanent Extension of PTC Credit for Wind H.R. 1417: Amend IRS Code for Permanent Exemption for Active Fianancing Income H.R. 1511: Amend IRS Code of 1986 to provide a 5-year PTC extension H.R. 1956: Business Activity Tax Simplication ACt H.R. 2471: Economic Development Act of 2005 H.R. 2498: Biodiesel Tax Extension H.R. 3376: Tax Technical Corrections Act of 2005 H.R. 364: bonus Depreciation Extension Act H.R. 3768: Katrina Emergency Tax Relief Act; P.L. 109-73 H.R. 809: Extend Tax Relief for Dividends and Capital Gains H.R. 4236: Amend IRS Code of 1986 to treat farm equipment as 5-year property for depreciation H.R. 4297: Tax Relief Act of 2005; Subpart F; P.L. 109-222 H.R. 8: Permanent Death Tax Repeal H.R. 4297: Tax Relief Act of 2005; R&D Tax Credit; P.L. 109-222 H.R. 1956: Business Activity Tax Simplification ACt H.R. 4511: The Flex HSA Act H.R. 4440: The Gulf Opportuity Zone Act of 2005 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429096 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | HCR | S. 354: Health Care Liability Reform S. 1015: Health Care CHOICE Act of 2005 S. 1227: Health Information Technology Quality Act S. 1355: Health Information Technology Quality & Improvement Act of 2005 S. 1356: Medicare Value Purchasing Act of 2005 S. 932: Healthy Families Act S. 3585: Health Savings Accounts Improvement & Expansion Act of 2006 S. 3488: Tax-Free Healthcare Savings, Access, & Portability Act H.R. 1872: Health Care for the Uninsured Act of 2005 H.R. 1902: Healthy Families Act H.R. 2355: Health Care CHOICE Act of 2005 H.R. 66: Health Care Cost Deductions H.R. 4157: Health Information Technology Promotion Act of 2005 H.R. 4511: Flex HSA Act H.R. 4262: Tax-Free Health Savings Accounts | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429097 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | BUD | HR 4241: Deficit Reduction Act of 2005, P.L. 109-362 S. 1932: Deficit Reduction Act of 2005, P.L. 109-362 S. 2020: Tax Relief Act of 2005, P.L. 109-222 H.R. 4297: Tax Reconcilliation Bill, P.L. 109-222 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429098 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | ENV | H.R. 3824: Threatened and Endangered Species Recovery Act of 2005 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429099 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | INS | S. 359: Ag Job Opportunities, Benefits, and Security Act of 2005 S. 467: Extending Terrorism Risk Insurance Act of 2005 H.R. 884: Ag Job Opportunities, Benefits, and Security Act of 2005 H.R. 4320: National Flood Insurance Program Commitment to Policyholders and Reform Act of 2005 H.R. 4314: Terrorism Risk Insurance Revision Act of 2005 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429100 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | CSP | S. 1326: Notification of Risk to Personal Data Act of 2005 S. 1332: Personal Data Privacy S. 687: SPY Block Act S. 751: Data Break Notification Act S. 810: Safeguarding Americans from Exporting Identification Data Act S. 1216: Financial Privacy Breach Notification Act of 2005 S. 1408: Identity Theft Protection Act S. 1789: Personal Data Privacy and Protection Act of 2005 S. 2389: Protection Consumers Phone Records Act H.R. 1653: Safeguarding Americans from Exporting Identification Data Act H.R. 4127: Data Accountability and Trust Act H.R. 3997: Financial Data Protection Act H.R. 32: Stop Counterfeiting in Manufactured Goods Act H.R. 5318: Identity Theft Bill | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429101 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | ENG | S. 10: Energy Policy Act of 2005; P.L. 109-58 S. 1034: Environmentally Responsible Windpower Act of 2005 S. Con. Res 97: A concurrent resolution expressing the sense of Congress that it is the goal of the United States that, not later than January 1, 2025, the agricultural, forestry, and working land of the United States should provide from renewable resources not less than 25 percent of the total energy consumed in the United States and continue to produce safe, abundant, and affordable food, feed, and fiber. H.R. 2938: Environmentally Responsible Windpower Act 2005 H.R. 6: Energy Policy Act of 2005; P.L. 109-58 H.R. 5427: FY '07 Energy & Water Appropriations: Title 3 (On-Highway Funding) H.Con.Res 424:A concurrent resolution expressing the sense of Congress that it is the goal of the United States that, not later than January 1, 2025, the agricultural, forestry, and working land of the United States should provide from renewable resources not less than 25 percent of the total energy consumed in the United States and continue to produce safe, abundant, and affordable food, feed, and fiber. | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429102 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | IMM | H.R. 98: Social Security Card Immigration Reform H.R. 4437: Border Protection, Antiterrorism, and Illegal Immigration Control Act of 2005: Section 301 (Joint Strategic Plan for US Border Surveillance and Support) S. 2454: Securing America's Borders Act; Section 102 (Technological Assests) S. 2454: Securing America's Borders Act; Section 111 (Surveillance Plan) S. 2612: Immigration Reform Bill; Section 102 (Technological Assets) S. 2612: Immigration Reform Bill; Section 111 (Surveillance Plans) S. 2454: Securing America's Borders Act; Title IV (Backlog Reduction and Visas for Students, Medical Professionals, and Aliens with Advanced Degrees) S. 2612: Immigration Reform bill: Title VII; Subtitle B; Chapter 2 (Reform of H-2A Worker Program) | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429103 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | TOR | S. 852: Fairness to Asbestos Injury Resolution Act (FAIR) of 2005 H.R. 3509: Statue of Repose H.R. 1363: Statue of Repose | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-04:00 |
| 429104 | DEERE & COMPANY 2b4c1bd3-d5c8-4717-a8b2-8efbaf7c6499 | MM | DEERE & COMPANY | 11878 | DEERE & COMPANY | 2006 | mid_year | CAW | S. 10: Energy Policy Act of 2005: Global Climate Change, P.L. 109-58 S. 1265: Diesel Emissions Reduction Act H.R. 6: Energy Policy Act of 2005, Section 791-797 (Diesel Emissions Reduction); P.L. 109-58 H.R. 6: Energy Policy Act of 2005, Section 741 (Clean School Bus Program); P.L. 109-58 | Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office | 0 | 0 | 2006-07-13T00:00:00-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,
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);