lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where filing_uuid = "4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 834795 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | FOO | H.R. 759, Food and Drug Administration Globalization Act of 2009 | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834796 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | PHA | S. 540/H.R. 1346, Medical Device Safety Act of 2009 General background on drug and device labeling rules and the doctrine of Federal preemption (no specific legislation introduced) | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834797 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | MAR | S. 588/H.R. 1485, Cruise Vessel Security and Safety Act | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834798 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | MMM | Potential legislation dealing with the Medicare Secondary Payer provisions of the Medicare statute (not yet introduced) H.R. 3200, America's Affordable Health Choices Act, provisions on Medicare Secondary Payer | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834799 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | CHM | H.R. 2868, Chemical Facility Anti-Terrorism Act of 2009 | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834800 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | TAX | S. 437/H.R. 2519, A bill to amend the Internal Revenue Code of 1986 to allow the deduction of attorney-advanced expenses and court costs in contingency fee cases | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834801 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | BUD | H.R. 2847, FY 2010 Commerce, Justice, Science, and Related Agencies Appropriations Act, provisions on the Legal Services Corporation | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834802 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | ENG | H.R. 2454, American Clean Energy and Security Act of 2009, provisions on state attorneys general and civil litigation | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834803 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | LAW | General background on the issue of over-criminalization of federal law (no specific legislation introduced) | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834804 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | FIN | H.R. 1105/S. 673, Omnibus Appropriations Act of 2009, provisions on state attorney general HIPPA enforcement General background on U.S. capital markets competitiveness and regulation, securities litigation and attorney pay-to-play issues in securities litigation (no specific legislation) P.L. 104-67, Private Securities Litigation Reform Act of 1995 S. 1551, Liability for Aiding and Abetting Securities Violations Act H.R. 2309, Consumer Credit Protection Agency Act, provisions on state attorney general enforcement H.R. 3126, Consumer Financial Protection Agency Act of 2009 | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834805 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | AUT | H.R. 609, Right to Clean Vehicles Act | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834806 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | HCR | H.R.1/S. 570, American Recovery and Reinvestment Act of 2009, provisions on state attorney general enforcement | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834807 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | CSP | S. 2831 (110th Congress bill), A bill to reauthorize the Federal Trade Commission, and for other purposes P.L. 110-314, Consumer Product Safety Improvement Act of 2008 | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834808 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | GOV | S. 386, Fraud Enforcement and Recovery Act of 2009 H.R. 1788, False Claims Act Correction Act of 2009 S. 458, False Claims Act Clarification Act S. 139, Data Breach Notification Act S. 386, Fraud Enforcement Recovery Act, provisions on civil investigative demand S. 418, Secondary Metal Theft Prevention Act of 2009, provisions on state attorneys general General background and information on the doctrine of Federal preemption (no specific legislation introduced) General background on state attorneys general and their enforcement authority/activities (no specific legislation introduced) | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834809 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | LBR | S. 560/H.R. 1409, Employee Free Choice Act of 2009 S. 181/H.R. 11, Lilly Ledbetter Fair Pay Act of 2009 The nomination of Craig Becker to serve on the National Labor Relations Board | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-04:00 | |
| 834810 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b | Q3 | U.S. CHAMBER INSTITUTE FOR LEGAL REFORM | 51172 | U S CHAMBER INSTITUTE FOR LEGAL REFORM | 2009 | third_quarter | TOR | H.R. 1020/S. 931, Arbitration Fairness Act of 2009 H.R. 1214, Payday Loan Reform Act of 2009 S. 537/H.R. 1508, Sunshine in Litigation Act of 2009 S. 263, Servicemembers Access to Justice Act of 2009 S. 512/H.R. 1237, Fairness in Nursing Home Arbitration Act H.R. 991, Consumer Fairness Act of 2009 H.R. 1728, Mortgage Reform and Anti-Predatory Lending Act, arbitration provisions H.R. 3451, Foreclosure and Sound Mortgage Servicing Act of 2009, arbitration provisions H.R. 3200, Affordable Health Choices Act, provisions on medical malpractice S. 445, Attorney-Client Privilege Protection Act of 2009 S. 1504, Notice Pleading Restoration Act of 2009 S. 585, Taxpayer Abuse Prevention Act, arbitration provisions General background on legal reform issues, discovery reform, medical liability reform, medical malpractice and arbitration and other alternative dispute resolution mechanisms (no specific legislation introduced) | HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE | 4240000 | 0 | 0 | 2009-10-19T09:39:30-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);