lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "aa10f42d-e79a-4e00-a8dc-e71d2d1fec87" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 641964 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | FIN | H.R. 1685 - Data Security Act of 2007 - All provisions H.R. 2124 - Federal Agency Data Breach - All provisions H.R. 220 - Identity Theft Prevention Act of 2007 - All provisions H.R. 336 - Identity Theft Prevention and Timely Reporting Act of 2007 - All provisions H.R. 958 - Data Accountability and Trust Act - All provisions S. 1178 - Identity Theft Prevention Act of 2007 - All provisions S. 1202 - Personal Data Protection Act of 2007 - All provisions S. 239 - Notification of Risk to Personal Data Act of 2007 - All provisions S. 495 - Personal Data Privacy and Security Act of 2007 - All provisions S. 806 - Consumer ID Protection and Security Act - All provisions S. 1260 - Data Security Act of 2007 - All provisions S. 1625 - Counter Spy Act - All provisions H.R. 1525 - Internet Spyware (I-SPY) Prevention Act of 2007 - All provisions H.R. 964 - SPY Act - All provisions | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641965 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | AUT | H.R. 1015 - A bill to require automobile dealers to disclose to consumers the presence of event data recorders or "black boxes," on new automobiles and to require manufacturers to provide the consumer with the option to enable and disable such devices on future automobiles. H.R. 1216 - Cameron Gulbransen Kids and Cars Safety Act of 2007 - All provisions S. 694 - Cameron Gulbransen Kids and Cars Safety Act of 2007 - All provisions H.R. 1029 - Damaged Vehicle Information Act - All provisions H.R. 2811 - Passenger Vehicle Loss Disclosure Act - All provisions S. 545 - Passenger Vehicle Loss Disclosure Act - All provisions | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641966 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | DIS | H.R. 1212 - Catastrophic Disaster Recovery Improvements Act of 2007 - All provisions H.R. 164 - Policyholder Disaster Protection Act of 2007 - All provisions H.R. 1787 - Catastrophe Savings Accounts Act of 2007 - All provisions H.R. 1832 - National Hurricane Research Initiative Act of 2007 - All provisions H.R. 2407 - National Hurricane Research Initiative Act of 2007 - All provisions H.R. 537 - Commission on Catastrophic Disaster Risk and Insurance Act of 2007 - All provisions H.R. 846 - Emergency and Disaster Assistance Fraud Penalty Enhancement Act of 2007 - All provisions H.R. 913 - Hurricane and Tornado Mitigation Investment Act of 2007 - All provisions H.R. 3355 - Homeowners' Defense Act of 2007 - All provisions H.R. 3644 - A bill to establish a nonpartisan Commission on Natural Catastrophe Risk Management and Insurance, and for other purposes - All provisions S. 292 - Commission on Catastrophic Disaster Risk and Insurance Act of 2007 - All provisions S. 538 - Work, Hope and Opportunity for the Disaster Area Today Act - All provisions S. 690 - Catastrophic Disaster Recovery Improvements Act of 2007 - All provisions S. 926 - Policyholder Disaster Protection Act of 2007 - All provisions S. 927 - Catastrophe Savings Accounts Act of 2007 - All provisions S. 928 - Homeowners Protection Act of 2007 - All provisions S. 930 - Hurricane and Tornado Mitigation Investment Act of 2007 - All provisions S. 931 - National Hurricane Research Initiative Act of 2007 - All provisions S. 929 - Non-admitted and Reinsurance Reform Act of 2007 - All provisions S. 2286 - Commission on Natural Catastrophe Risk Management and Insurance Act of 2007 - All provisions S. 2310 - A bill to establish a national catastrophic risks consortium and a national homeowners' insurance stabilization program - All provisions S. 2327 - A bill to amend the Internal Revenue Code of 1986 to provide a credit against tax for increased homeowners insurance premiums suffered by certain coastal homeowners or resulting from hurricane events - All provisions S… | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641967 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | CPT | H.R. 1908 - Patent Reform Act of 2007 - All provisions; S. 1145 - Patent Reform Act of 2007 - All provisions; H.R. 5638 - A bill to amend Title 35, United States Code, to create an exception from infringement for certain component parts used to repair another article of manufacture - All provisions | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641968 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | INS | H.R. 330 - Homeowners' Insurance Availability Act of 2007 - All provisions H.R. 91 - Homeowners' Insurance Protection Act of 2007 - All provisions S. 1061 - Homeowners' Insurance Noncoverage Disclosure Act of 2007 - All provisions H.R. 957 - To amend the Iran Sanctions Act of 1996 to expand and clarify the entities against which sanctions may be imposed - All provisions H.R. 1682 - Flood Insurance Reform and Modernization Act of 2007 - All provisions H.R. 2549 - Medicare Secondary Payer and Worker's Compensation Settlement Agreement Act of 2007 - All provisions H.R. 3121 - Flood Insurance Reform and Modernization Act of 2007 - All provisions H.R. 3926 - Safe Building Codes Act of 2007 - All provisions H.R. 3959 - A bill to amend the National Flood Insurance Act of 1968 to provide for the phase-in of actuarial rates for certain pre-FIRM properties - All provisions H.R. - 4050 - Levee-Like structure Consideration Act of 2007 - All provisions H.R. 4299 - Terrorism Risk Insurance Program Reauthorization Act of 2007 - All provisions H.R. 4721 - Terrorism Risk Insurance Improvement Act of 2007 - All provisions H.R. 920 - Multiple Peril Insurance Act of 2007 - All provisions H.R. 921 - Flood Insurance Community Outreach Grant Program Act of 2007 - All provisions H.R. 922 - National Flood Insurance Program Participation Evaluation Act of 2007 - All provisions H.R. 3200 - National Insurance Act of 2007 - All provisions H.R. 1049 - Amend Misinterpreted Excessive Regulation in Corporate America Act - All provisions H.R. 1065 - Non-admitted and Reinsurance Reform Act of 2007 - All provisions H.R. 2761 - Terrorism Risk Insurance Program Reauthorization Act of 2007 - All provisions H.R. 4461 - A bill to promote and enhance the operation of local building code enforcement administration across the country by establishing a competitive federal matching grant program - All provisions H.R. 5611 - A bill to reform the National Association of Registered Agents and Brokers, and for other purposes - All provisions H.R. 5633 - Nondis… | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641969 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | LBR | H.R. 1081 - Insurance Industry Competition Act of 2007 - All provisions S. 618 - Insurance Industry Competition Act of 2007 - All provisions S. 846 - Longshore and Harbor Workers' Compensation Act Amendments of 2007 - All provisions H.R. 3195 - ADA Restoration Act of 2007 - All provisions H.R. 5804 - A bill to amend the Internal Revenue Code of 1986 to modify the rules relating to the treatment of individuals as independent contractors or employees, and for other purposes - All provisions S. 2044 - A bill to provide procedures for the proper classification of employees and independent contractors, and for other purposes - All provisions | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-04:00 | |
| 641970 | ALLSTATE INSURANCE COMPANY aa10f42d-e79a-4e00-a8dc-e71d2d1fec87 | Q2 | ALLSTATE INSURANCE COMPANY | 1114 | ALLSTATE INSURANCE COMPANY | 2008 | second_quarter | TOR | H.R. 2183 - Commonsense Consumption Act of 2007 - All provisions; S. 1323 - Commonsense Consumption Act of 2007 - All provisions; S. 2041 - False Claims Act Correction Act of 2007 - All provisions; S. 2449 - Sunshine in Litigation Act of 2007 - All provisions; S. 2663 - CPSC Reform Act - All provisions; H.R. 4040 - Consumer Product Safety Modernization Act - All provisions H.R. 1289 - Community Reinvestment Modernization Act of 2007 - All provisions H.R. 2830 - A bill to authorize appropriations for the Coast Guard for fiscal year 2008, and for other purposes - All provisions H.R. 6285 - A bill to amend the National Flood Insurance Act of 1968 to provide for adequate progress on the construction of a flood protection system to include the appropriation of at least 60 percent of the system cost from Federal, State or local funds - All provisions | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 710000 | 0 | 0 | 2008-07-18T17:22:36-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);