home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d2e5aa24-26d6-4df8-af78-81788bb2d9f4

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
d2e5aa24-26d6-4df8-af78-81788bb2d9f4 MM 38164 TIMMONS AND COMPANY, INC. 146567 CHRYSLER LLC 2007 mid_year 2007-08-06T12:02:04-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d2e5aa24-26d6-4df8-af78-81788bb2d9f4/", "filing_uuid": "d2e5aa24-26d6-4df8-af78-81788bb2d9f4", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d2e5aa24-26d6-4df8-af78-81788bb2d9f4/print/", "filing_document_content_type": "application/pdf", "income": "200000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-08-06T12:02:04-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 38164, "url": "https://lda.senate.gov/api/v1/registrants/38164/", "house_registrant_id": 30974, "name": "TIMMONS AND COMPANY, INC.", "description": "Government Relations and Lobbying Firm", "address_1": "1110 Vermont Avenue, NW", "address_2": "Suite 1000", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MR. MICHAEL J. BATES", "contact_telephone": "", "dt_updated": "2022-04-06T16:08:29.257498-04:00"}, "client": {"id": 146567, "url": "https://lda.senate.gov/api/v1/clients/146567/", "client_id": 87, "name": "CHRYSLER LLC", "general_description": null, "client_government_entity": false, "client_self_select": false, "state": null, "state_display": null, "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-06"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "\r\nH.J. Res. 20 - Revised Continuing Appropriations Resolution, 2007\nH.R. 2206 - U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7217, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": "DEPUTY COS - OFFICE OF SEN. BILL NELSON", "new": null}, {"lobbyist": {"id": 9053, "prefix": null, "prefix_display": null, "first_name": "GINGER", "nickname": null, "middle_name": null, "last_name": "LOPER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12917, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17742, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "KELLIHER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37458, "prefix": null, "prefix_display": null, "first_name": "BRYCE", "nickname": null, "middle_name": "L", "last_name": "HARLOW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45785, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "TARPLIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45882, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "E", "last_name": "TIMMONS", "suffix": "sr", "suffix_display": "SR"}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "\r\nH.R. 698 - Industrial Bank Holding Company Act of 2007\nS. 1356 - Industrial Bank Holding Company Act of 2007\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7217, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": "DEPUTY COS - OFFICE OF SEN. BILL NELSON", "new": null}, {"lobbyist": {"id": 9053, "prefix": null, "prefix_display": null, "first_name": "GINGER", "nickname": null, "middle_name": null, "last_name": "LOPER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12917, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17742, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "KELLIHER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37458, "prefix": null, "prefix_display": null, "first_name": "BRYCE", "nickname": null, "middle_name": "L", "last_name": "HARLOW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45785, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "TARPLIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45882, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "E", "last_name": "TIMMONS", "suffix": "sr", "suffix_display": "SR"}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nH.R. 2776 - Renewable Energy and Energy Conservation Tax Act of 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7217, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": "DEPUTY COS - OFFICE OF SEN. BILL NELSON", "new": null}, {"lobbyist": {"id": 9053, "prefix": null, "prefix_display": null, "first_name": "GINGER", "nickname": null, "middle_name": null, "last_name": "LOPER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12917, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17742, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "KELLIHER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37458, "prefix": null, "prefix_display": null, "first_name": "BRYCE", "nickname": null, "middle_name": "L", "last_name": "HARLOW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45785, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "TARPLIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45882, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "E", "last_name": "TIMMONS", "suffix": "sr", "suffix_display": "SR"}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "\r\nS. 6 - To enhance the security of the United States by reducing the dependence of the United States on foreign and unsustainable energy sources and the risks of global warming, and for other purposes.\nS. 183 - Improved Passenger Automobile Fuel Economy Act of 2007\nS. 357 - To improve passenger automobile fuel economy and safety, reduce greenhouse gas emissions, reduce dependence on foreign oil, and for other purposes.\nS. 1419 - Renewable Fuels, Consumer Protection, and Energy Efficiency Act of 2007\nS. 875 \u2013 SAFE Energy Act of 2007\n\r\nH.R. 6 - CLEAN Energy Act of 2007\nH.R. 1506 - Fuel Economy Reform Act\nH.R. 2927 - To increase the corporate average fuel economy standards for automobiles, to promote the domestic development and production of advanced technology vehicles, and for other purposes.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7217, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": "DEPUTY COS - OFFICE OF SEN. BILL NELSON", "new": null}, {"lobbyist": {"id": 9053, "prefix": null, "prefix_display": null, "first_name": "GINGER", "nickname": null, "middle_name": null, "last_name": "LOPER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12917, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17742, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "KELLIHER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37458, "prefix": null, "prefix_display": null, "first_name": "BRYCE", "nickname": null, "middle_name": "L", "last_name": "HARLOW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45785, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "TARPLIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45882, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "E", "last_name": "TIMMONS", "suffix": "sr", "suffix_display": "SR"}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MON", "general_issue_code_display": "Minting/Money/Gold Standard", "description": "\r\nS. 1021 - To address the exchange-rate misalignment of the Japanese yen with respect to the United States dollar, and for other purposes.\nS. 1607 - Currency Exchange Rate Oversight Reform Act of 2007\n\r\nH.R. \u2013 321 - To require the Secretary of the Treasury to analyze and report on the exchange rate policies of the People's Republic of China, and to require that additional tariffs be imposed on products of that country on the basis of the rate of manipulation by that country of the rate of exchange between the currency of that country and the United States dollar.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 7217, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": "DEPUTY COS - OFFICE OF SEN. BILL NELSON", "new": null}, {"lobbyist": {"id": 9053, "prefix": null, "prefix_display": null, "first_name": "GINGER", "nickname": null, "middle_name": null, "last_name": "LOPER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 12917, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "J", "last_name": "BATES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17742, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "KELLIHER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 37458, "prefix": null, "prefix_display": null, "first_name": "BRYCE", "nickname": null, "middle_name": "L", "last_name": "HARLOW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45785, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "TARPLIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 45882, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "E", "last_name": "TIMMONS", "suffix": "sr", "suffix_display": "SR"}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30974     US US   0 0         200000.0  

Links from other tables

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