lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts. Sortable columns (indexed): client_name, issue_code, filing_year, filing_uuid. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

7 rows where filing_uuid = "30c97917-d131-4771-b78e-22165477cea0" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 7

filing_year 1

filing_period 1

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
1234256 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter TRD None this period. HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234257 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter CPT None this period. HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234258 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter RET HR 677/S 267: LIFETIME INCOME DISCLOSURE ACT; PROVISIONS RELATED TO ANNUITY ILLUSTRATION HR 1173: FISCAL RESPONSIBILITY AND RETIREMENT SECURITY ACT OF 2011; PROVISIONS RELATED TO THE REPEAL OF THE CLASS ACT HR 1534: SMALL BUSINESSES ADD VALUE FOR EMPLOYEES (SAVE) ACT OF 2011; PROVISIONS RELATED TO VOLUNTARY AUTO-INDIVIDUAL RETIREMENT ACCOUNTS (IRA) HR 5025: TO AMEND THE PUBLIC HEALTH SERVICE ACT AND THE SOCIAL SECURITY ACT TO EXTEND HEALTH INFORMATION TECHNOLOGY ASSISTANCE ELIGIBILITY TO BEHAVIORAL HEALTH, MENTAL HEALTH, AND SUBSTANCE ABUSE PROFESSIONALS AND FACILITIES, AND FOR OTHER PURPOSES; PROVISIONS RELATED TO THE EXTENSION OF HEALTH INFORMATION TECHNOLOGY ACCOUNTING REQUIREMENTS TO LONG-TERM CARE INSURERS S 1121: SAVINGS ENHANCEMENT BY ALLEVIATING LEAKAGE IN 401(K) SAVINGS ACT OF 2011; PROVISIONS RELATED TO LIMITS BORROWING FROM 401(K) PLANS S 1557: AUTOMATIC IRA ACT OF 2011; PROVISIONS RELATED TO VOLUNTARY IRAS AND MULTIPLE EMPLOYER PLANS P.L. 110-233 (111th CONGRESS): GENETIC INFORMATION NONDISCRIMINATION ACT OF 2008; PROVISIONS RELATED TO UNDERWRITING RESTRICTIONS ON LONG-TERM CARE INSURANCE H. CON.RES. 101: EXPRESSING THE SENSE OF THE CONGRESS IN SUPPORT OF THE CURRENT SYSTEM OF RETIREMENT SAVINGS TAX INCENTIVES; ALL PROVISIONS. H.R. 4049, AUTOMATIC IRA ACT OF 2012; ALL PROVISIONS. H.R. 4050, RETIREMENT PLAN SIMPLIFICATION AND ENHANCEMENT ACT OF 2012; PROVISIONS RELATED TO MULTIPLE EMPLOYER PLANES, E-DELIVERY, AND ANNUITY REFORMS. HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234259 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter FIN HR 654: DO NOT TRACK ME ONLINE ACT; PROVISIONS RELATED TO PRIVACY HR 890: HOLOCAUST INSURANCE ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION HR 1249/S 23: LEAHY-SMITH AMERICA INVESTS ACT; ALL PROVISIONS OF THE BILL HR 1528: CONSUMER PRIVACY PROTECTION ACT OF 2011; PROVISIONS RELATED TO PRIVACY HR 1573: TO FACILITATE IMPLEMENTATION OF TITLE VII OF THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, PROMOTE REGULATORY COORDINATION, AND AVOID MARKET DISRUPTION; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES HR 1610: THE BUSINESS RISK MITIGATION AND PRICE STABILIZATION ACT OF 2011; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES HR 2577: SECURE AND FORTIFY ELECTRONIC (SAFE) DATA ACT; PROVISIONS RELATED TO PRIVACY S 466: RESTORATION OF LEGAL RIGHTS FOR CLAIMANTS UNDER HOLOCAUST-ERA INSURANCE POLICIES ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION S 799: COMMERCIAL PRIVACY BILL OF RIGHTS ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 947: A BILL TO PROVIDE END USER EXEMPTIONS FROM CERTAIN PROVISIONS OF THE COMMODITY EXCHANGE ACT AND THE SECURITIES EXCHANGE ACT OF 1934 AND FOR OTHER PURPOSES; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES S 1151: PERSONAL DATA PRIVACY AND SECURITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1152: CYBERSECURITY ENHANCEMENT ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1207: DATA SECURITY AND BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1408: DATA BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1535: PERSONAL DATA PROTECTION AND BREACH ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1615: FINANCIAL REGULATORY RESPONSIBILITY ACT OF 2011; PROVISIONS RELATED TO DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND REGULATORY REFORM S 1789: 21ST CENTURY POSTAL SERVICE ACT OF 2011; PROVISIONS RELATED TO MAIL DELIVERY P.L.… HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234260 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter TAX HR 1151: EMERGENCY MORTGAGE RELIEF AND NEGHBORHOOD STABILIZATION PROGRAMS COST RECOUPMENT ACT OF 2011; PROVISIONS RELATED TO THE TAXATION OF LIFE INSURANCE COMPANIES FY 2013 PRESIDENTIAL BUDGET PROPOSAL AND TREASURY GREENBOOK; MODIFICATION OF DIVIDENDS-RECEIVED DEDUCTION FOR LIFE INSURANCE COMPANY SEPARATE ACCOUNTS - PROVISIONS RELATED TO TAXATION OF LIFE INSURANCE COMPANIES; EXPANSION OF PRO RATA INTEREST EXPENSE DISALLOWANCE FOR INTEREST UNRELATED CORPORATE-OWNED LIFE INSURANCE - PROVISIONS RELATED TO TAXATION OF THE BUSINESS USE OF LIFE INSURANCE; MODIFICATION OF RULES THAT APPLY TO SALES OF LIFE INSURANCE CONTRACTS - PROVISIONS RELATED TO COMPLIANCE BURDEN AND ACCURACY FOR LIFE INSURANCE COMPANIES HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234261 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter INS HR 654: DO NOT TRACK ME ONLINE ACT; PROVISIONS RELATED TO PRIVACY HR 890: HOLOCAUST INSURANCE ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION HR 1528: CONSUMER PRIVACY PROTECTION ACT OF 2011; PROVISIONS RELATED TO PRIVACY HR 1573: TO FACILITATE IMPLEMENTATION OF TITLE VII OF THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, PROMOTE REGULATORY COORDINATION, AND AVOID MARKET DISRUPTION; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES HR 1610: THE BUSINESS RISK MITIGATION AND PRICE STABILIZATION ACT OF 2011; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES HR 2577: SECURE AND FORTIFY ELECTRONIC (SAFE) DATA ACT; PROVISIONS RELATED TO PRIVACY S 466: RESTORATION OF LEGAL RIGHTS FOR CLAIMANTS UNDER HOLOCAUST-ERA INSURANCE POLICIES ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION S 799: COMMERCIAL PRIVACY BILL OF RIGHTS ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 947: A BILL TO PROVIDE END USER EXEMPTIONS FROM CERTAIN PROVISIONS OF THE COMMODITY EXCHANGE ACT AND THE SECURITIES EXCHANGE ACT OF 1934 AND FOR OTHER PURPOSES; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES S 1151: PERSONAL DATA PRIVACY AND SECURITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1152: CYBERSECURITY ENHANCEMENT ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1207: DATA SECURITY AND BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1408: DATA BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1535: PERSONAL DATA PROTECTION AND BREACH ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1615: FINANCIAL REGULATORY RESPONSIBILITY ACT OF 2011; PROVISIONS RELATED TO DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND REGULATORY REFORM P.L. 111-203: DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT; IMPLEMENTATION OF PROVISIONS RELATED TO REGULATORY REFORM H. CON.RES. 101: EXPRESSING THE S… HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00
1234262 TRANSAMERICA COMPANIES 30c97917-d131-4771-b78e-22165477cea0 Q1 TRANSAMERICA COMPANIES 44093 TRANSAMERICA COMPANIES 2012 first_quarter CSP HR 654: DO NOT TRACK ME ONLINE ACT; PROVISIONS RELATED TO PRIVACY HR 890: HOLOCAUST INSURANCE ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION HR 1528: CONSUMER PRIVACY PROTECTION ACT OF 2011; PROVISIONS RELATED TO PRIVACY HR 1610: THE BUSINESS RISK MITIGATION AND PRICE STABILIZATION ACT OF 2011; PROVISIONS RELATED TO THE DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND DERIVATIVES HR 2577: SECURE AND FORTIFY ELECTRONIC (SAFE) DATA ACT; PROVISIONS RELATED TO PRIVACY S 466: RESTORATION OF LEGAL RIGHTS FOR CLAIMANTS UNDER HOLOCAUST-ERA INSURANCE POLICIES ACT OF 2011; PROVISIONS RELATED TO INSURANCE REGULATION S 799: COMMERCIAL PRIVACY BILL OF RIGHTS ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1151: PERSONAL DATA PRIVACY AND SECURITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1152: CYBERSECURITY ENHANCEMENT ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1207: DATA SECURITY AND BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S 1408: DATA BREACH NOTIFICATION ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1535: PERSONAL DATA PROTECTION AND BREACH ACCOUNTABILITY ACT OF 2011; PROVISIONS RELATED TO PRIVACY S. 1615: FINANCIAL REGULATORY RESPONSIBILITY ACT OF 2011; PROVISIONS RELATED TO DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT, AND REGULATORY REFORM P.L. 111-203: DODD-FRANK WALL STREET REFORM AND CONSUMER PROTECTION ACT; IMPLEMENTATION OF PROVISIONS RELATED TO REGULATORY REFORM HOUSE OF REPRESENTATIVES,SENATE 0 0 2012-04-18T21:49:08.953000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);