home / lobbying / lobbying_filings_raw

lobbying_filings_raw: be2fdb63-9590-4da1-b8a3-4ab2eb407e2f

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
be2fdb63-9590-4da1-b8a3-4ab2eb407e2f Q3 20744 TIBER CREEK GROUP 127152 THE ALLSTATE CORPORATION 2016 third_quarter 2016-10-20T09:42:04.847000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/be2fdb63-9590-4da1-b8a3-4ab2eb407e2f/", "filing_uuid": "be2fdb63-9590-4da1-b8a3-4ab2eb407e2f", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2016, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/be2fdb63-9590-4da1-b8a3-4ab2eb407e2f/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Jeffrey J. Peck, Partner", "dt_posted": "2016-10-20T09:42:04.847000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1300 CONNECTICUT AVENUE, NW", "registrant_address_2": "SIXTH FLOOR", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 20744, "url": "https://lda.senate.gov/api/v1/registrants/20744/", "house_registrant_id": 31587, "name": "TIBER CREEK GROUP", "description": "Government Relations.", "address_1": "750 9th Street NW", "address_2": "Suite 501", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GRACE BAUM", "contact_telephone": "+1 202-381-6896", "dt_updated": "2026-01-28T11:50:36.069441-05:00"}, "client": {"id": 127152, "url": "https://lda.senate.gov/api/v1/clients/127152/", "client_id": 1005038, "name": "THE ALLSTATE CORPORATION", "general_description": "Insurance company.", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2015-02-15"}, "lobbying_activities": [{"general_issue_code": "BNK", "general_issue_code_display": "Bankruptcy", "description": "Puerto Rico bankruptcy issues. H.R. 5278, Puerto Rico Oversight, Management, and Economic Stability Act or PROMESA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AUT", "general_issue_code_display": "Automotive Industry", "description": "Issues relating to after-market parts. E-title transfer.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 26450, "prefix": null, "prefix_display": null, "first_name": "JONATHON", "nickname": null, "middle_name": null, "last_name": "JONES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Issues relating to capital standards. H.R 5143, Transparent Insurance Standards Act of 2016. General Fin Tech issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "FAA reauthorization, AIRR Act, H.R. 4441, Federal Aviation Administration Reauthorization Act of 2016. General drone issues. S. 2658, Federal Aviation Administration Reauthorization Act of 2016. Commercial use of drones for natural disasters.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52662, "prefix": null, "prefix_display": null, "first_name": "LINDSEY", "nickname": null, "middle_name": null, "last_name": "LEDWIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "Issues relating to capital standards and flood insurance and asbestos reform. H.R.526, Furthering Asbestos Claim Transparency (FACT) Act of 2015. S. 357, FACT Act. S.1679, Flood Insurance Market Parity and Modernization Act. H.R.2901, Flood Insurance Market Parity and Modernization Act. FAA reauthorization, H.R. 4441/S. 2658, general drone issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52662, "prefix": null, "prefix_display": null, "first_name": "LINDSEY", "nickname": null, "middle_name": null, "last_name": "LEDWIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Department of Labor's proposed rule to redefine fiduciary under ERISA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "H.R.1770 Data Security and Breach Notification Act of 2015. H.R.2205 Data Security Act of 2015. S.961 Data Security Act of 2015. Cybersecurity Act of 2015 included in H.R. 2029, Consolidated Appropriations Act of 2016. S. 2410 Cybersecurity Disclosure Act of 2016, S. 2604/H.R. 4651 Digital Security Commission Act of 2016, S. 2607 DIGIT Act, S. 2665 State and Local Cyber Protections Act of 2016, general encryption issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41105, "prefix": null, "prefix_display": null, "first_name": "DREW", "nickname": null, "middle_name": null, "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35657, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "PECK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 26450, "prefix": null, "prefix_display": null, "first_name": "JONATHON", "nickname": null, "middle_name": null, "last_name": "JONES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58384, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52662, "prefix": null, "prefix_display": null, "first_name": "LINDSEY", "nickname": null, "middle_name": null, "last_name": "LEDWIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31587 DC DC US US Insurance company. 0 0 1330   normalized_name_dc_fallback 0.8

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.999ms