lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "9f51d757-2b95-4e39-856f-e144fdc2b5e3" and issue_code = "RET" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);