lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "9f51d757-2b95-4e39-856f-e144fdc2b5e3" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 637487 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | CSP | See attachment. CSP Second Quarter Report 2008 H.R. 493 - Genetic Information Nondiscrimination Act of 2007 H.R. 948 - The Social Security Number Protection Act of 2007 H.R. 964 - Securely Protect Yourself Against Cyber Trespass Act H.R. 1065 - The Non - Admitted and Reinsurance Reform Act of 2007 H.R 1081/S 618 - Insurance Industry Competition Act of 2007 H.R. 1525 - Internet Spyware (I-SPY) Prevention Act of 2007 H.R. 3046 - The Social Security Number Privacy and ID Theft Prevention Act of 2007 H.R. 3200 - The National Insurance Act of 2007 H.R. 5611 National Association of Registered Agents and Brokers Act of 2008 H.R. 5792 Increasing Insurance Coverage Options for Consumers Act of 2008 H.R. 5840 Insurance Information Act of 2008 H.R. 6357 Protecting Records, Optimizing Treatments, and Easing Communications Through Healthcare Technology Act of 2008 (ProTECHt Act) S. 40 - The National Insurance Act of 2007 S. 239 - Notification of Risk to Personal Data Act of 2007 S. 358 - Genetic Information Nondiscrimination Act of 2007 S. 495 - The Personal Data Privacy and Security Act of 2007 S. 1178 - The Identity Theft Prevention Act of 2007 S. 1202 - The Personal Data Protection Act of 2007 S. 1260 - Data Security Act of 2007 S. 1693 - Wired for Health Care Quality Act S. 1814 - Health Information Privacy and Security Act S. 1865 - Life Insurance Fairness for Travelers Act of 2007 | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-04:00 | |
| 637488 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | FIN | See attachment. FIN Second Quarter Report 2008 H.R. 493 - Genetic Information Nondiscrimination Act of 2007 H.R. 948 - The Social Security Number Protection Act of 2007 H.R. 964 - Securely Protect Yourself Against Cyber Trespass Act H.R. 1065 - The Non - Admitted and Reinsurance Reform Act of 2007 H.R 1081/S 618 - Insurance Industry Competition Act of 2007 H.R. 1525 - Internet Spyware (I-SPY) Prevention Act of 2007 H.R. 3046 - The Social Security Number Privacy and ID Theft Prevention Act of 2007 H.R. 3200 - The National Insurance Act of 2007 H.R. 5611 National Association of Registered Agents and Brokers Reform Act of 2008 H.R. 5792 Increasing Insurance Coverage Options for Consumers Act of 2008 H.R. 5840 Insurance Information Act of 2008 H.R. 6357 Protecting Records, Optimizing Treatments, and Easing Communications Through Healthcare Technology Act of 2008 (ProTECHt Act) S. 40 - The National Insurance Act of 2007 S. 239 - Notification of Risk to Personal Data Act of 2007 S. 358 - Genetic Information Nondiscrimination Act of 2007 S. 495 - The Personal Data Privacy and Security Act of 2007 S. 1178 - The Identity Theft Prevention Act of 2007 S. 1202 - The Personal Data Protection Act of 2007 S. 1260 - Data Security Act of 2007 S. 1693 - Wired for Health Care Quality Act S. 1814 - Health Information Privacy and Security Act S. 1865 - Life Insurance Fairness for Travelers Act of 2007 S. 2794 - Senior Investor Protection Act of 2008 Securities Exchange Commission - Review of Rand Study and possible future changes to broker-dealer and investment adviser regulation - proposed Standard of Care | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-04:00 | |
| 637489 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | TAX | See attachment. TAX Second Quarter Report 2008 H.R. 25 - Fair Tax Act of 2007 H.R.150 - Life Insurance Employee Notification Act H.R. 377 - Insuring Families for Their Future Act of 2007 H.R. 411 - To amend the Internal Revenue Code of 1986 to make permanent certain temporary provisions applicable to individuals, including the sales tax deduction, the child credit, the repeal of the estate tax, and the deduction for higher education expenses. H.R.1810 - To amend the Internal Revenue Code of 1986 to permit the consolidation of life insurance companies with other companies. H.R. 3170 - To make permanent the individual income tax rates for capital gains, and for other purposes. H.R. 3970 - Tax Reduction and Reform Act of 2007 H.R. 4159 - Simplified USA Tax Act of 2007 H.R. 3361 - Pension Protection Technical Corrections Act of 2007 H.CON.RES.312 Revising the congressional budget for the United States Government for fiscal year 2008, establishing the congressional budget for the United States Government for fiscal year 2009, and setting forth appropriate budgetary levels for fiscal years 2010 through 2013. S.14 - A bill to repeal the sunset on certain tax rates and other incentives and to repeal the individual alternative minimum tax, and for other purposes. S.1025 Fair Tax Act of 2007 S.1111 Fair Flat Tax Act of 2007 S.1366 -A bill to amend the Internal Revenue Code of 1986 to permit the consolidation of life insurance companies with other S.1974 - Pension Protection Technical Corrections Act of 2007 S.CON.RES.70 An original concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2009 and including the appropriate budgetary levels for fiscal years 2008 and 2010 through 2013. Treasury Notice 2008-18 - Principle Based Reserves Treasury Notice 2007-15 - Simplification of correction programs for violation of sections 7702, 7702A and 817(h). Treasury Notice 2008-24 - Taxation of partial exchanges. Dept of Treasury - Internal Revenue … | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-04:00 | |
| 637490 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | RET | See attachment. RET Second Quarter Report 2008 H.R. 2 - Fair Minimum Wage Act H.R. 46 - Small Business Tax Fairness and Simplification Act H.R. 914 - Tax Equity and Affordability Act H.R. 976 - Small Business Tax Relief Act H.R. 1807 - Alzheimers Family Assistance Act H.R. 2205/ S. 1010 - Tax Incentive for Non Qualified Annuities H.R. 2419 Farm Bill Extension Act H.R. 2582 Qualified Long-Term Care Fairness Act of 2007 H.R. 3088 Long-Term Care Act of 2007 H.R. 3185 - The 401(k) Fair Disclosure for Retirement Security Act of 2007 H.R. 3361 - To make technical corrections related to the Pension Protection Act of 2006 H.R. 3363 Long Term Care Affordability and Security Act of 2007 H.R. 4839 Tax Technical Corrections H.R. 5160 Small Business Add Value for Employees Act of 2008 H.R. 5559 The Long Term Care and Retirement Security Act of 2008 H.R. 6143 Pension Protection Act ERISA Amendments of 2008 H.R. 6237 The Tax Relief for Long Term Care Act of 2008 H.R. 6357 Protecting Records, Optimizing Treatments, and Easing Communications Through Healthcare Technology Act of 2008 (ProTECHt Act) H.R. 6382 Pension Protection Act Technical Corrections H.R. (Concurrent Resolution) 133 - Supporting the Goals of the Long Term Care Awareness Week S. 555 - Simple Cafeteria Plan Act S. 897 - Alzheimers Family Assistance Act S. 1288 - Women's Retirement Act of 2007 S. 1974 - The Pension Protection Technical Corrections Act of 2007 S. 1809 Long-Term Care Act of 2007 S. 2337 - Long Term Care Affordability and Security Act of 2007 S. 3952 - Automatic IRA Act of 2007 S. 1758 Community Living Assistance Services and Supports Act S. 2121 Caregiver Assistance and Relief Effort Act of 2007 S. 2268 Long-Term Care Insurance Integrity Act of 2007 S. 2473 Defined Contribution Fee Disclosure Act S. 2794 The Senior Investor Protection Act of 2008 S. 1693 The Wired for Healthcare Quality Act Final 403(b) Regulations/Revenue Proceeding 2007-71 - issues related to timing relief, clarification of tr… | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-04:00 | |
| 637491 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | INS | See attachment. INS Second Quarter Report 2008 H.R. 948 - The Social Security Number Protection Act of 2007 H.R. 964 - Securely Protect Yourself Against Cyber Trespass Act H.R. 1065 - The Non - Admitted and Reinsurance Reform Act of 2007 H.R. 1081/S 618 - Insurance Industry Competition Act of 2007 H.R. 1525 - Internet Spyware (I-SPY) Prevention Act of 2007 H.R. 3046 - The Social Security Number Privacy and ID Theft Prevention Act of 2007 H.R. 3200 - The National Insurance Act of 2007 H.R. 5792 Increasing Insurance Coverage Options for Consumers Act of 2008 H.R. 5840 Insurance Information Act of 2008 H.R. 6357 Protecting Records, Optimizing Treatments, and Easing Communications Through Healthcare Technology Act of 2008 (ProTECHt Act) S. 40 - The National Insurance Act of 2007 S. 239 - Notification of Risk to Personal Data Act of 2007 S. 495 Personal Data Privacy and Security Act of 2007 S. 929 Non - admitted and Reinsurance Reform Act of 2007 S. 1178 - The Identity Theft Prevention Act of 2007 S. 1202 - The Personal Data Protection Act of 2007 S. 1260 - Data Security Act of 2007 S. 1693 Wired for Health Care Quality Act S. 1814 - Health Information Privacy and Security Act S. 1865 - Life Insurance Fairness for Travelers Act of 2007 | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-04:00 | |
| 637492 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY 9f51d757-2b95-4e39-856f-e144fdc2b5e3 | Q2 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 29607 | THE NORTHWESTERN MUTUAL LIFE INSURANCE COMPANY | 2008 | second_quarter | LBR | See attachment. LBR - Second Quarter Report 2008 H.R. 3195 - Americans with Disabilities Restoration Act S. 1881 - Americans with Disabilities Restoration Act | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 910000 | 0 | 0 | 2008-07-18T11:03:05-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);