home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 8fb6eb8a-bbf8-4a75-804d-4b60315cf4ce

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
8fb6eb8a-bbf8-4a75-804d-4b60315cf4ce Q2 84775 RICH FEUER ANDERSON 172571 LONDON STOCK EXCHANGE GROUP PLC 2015 second_quarter 2015-07-15T15:54:37.093000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/8fb6eb8a-bbf8-4a75-804d-4b60315cf4ce/", "filing_uuid": "8fb6eb8a-bbf8-4a75-804d-4b60315cf4ce", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2015, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/8fb6eb8a-bbf8-4a75-804d-4b60315cf4ce/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "MR. MITCHELL FEUER", "dt_posted": "2015-07-15T15:54:37.093000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1133 Connecticut Ave., NW", "registrant_address_2": "Suite 620", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 84775, "url": "https://lda.senate.gov/api/v1/registrants/84775/", "house_registrant_id": 36473, "name": "RICH FEUER ANDERSON", "description": "Government relations firm", "address_1": "1133 Connecticut Ave., NW", "address_2": "Suite 620", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ALEX TEEL", "contact_telephone": "+1 205-515-1851", "dt_updated": "2026-01-29T09:06:11.384360-05:00"}, "client": {"id": 172571, "url": "https://lda.senate.gov/api/v1/clients/172571/", "client_id": 1004633, "name": "LONDON STOCK EXCHANGE GROUP PLC", "general_description": "Bond, equity and derivatives markets and post-trade and risk management services.", "client_government_entity": false, "client_self_select": null, "state": null, "state_display": null, "country": "GB", "country_display": "United Kingdom", "ppb_state": null, "ppb_state_display": null, "ppb_country": "GB", "ppb_country_display": "United Kingdom", "effective_date": "2014-07-01"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Implementation of the \"Dodd-Frank Wall Street Reform and Consumer Protection Act,\" including regulation of derivative instruments, regulation and capitalization of clearinghouses, protection of customer assets, and extraterritorial application, and H.R. 2289, the \"Commodity End-User Relief Act.\"", "foreign_entity_issues": "London Stock Exchange Group plc is incorporated in the United Kingdom.", "lobbyists": [{"lobbyist": {"id": 31521, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, House Energy and Commerce Committee", "new": false}, {"lobbyist": {"id": 3688, "prefix": null, "prefix_display": null, "first_name": "MITCHELL", "nickname": null, "middle_name": null, "last_name": "FEUER", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, Senate Banking Committee", "new": false}, {"lobbyist": {"id": 57938, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "A", "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": "Sr. Pol. Advsr., Sen. Crapo; Leg. Asst., Rep. Metcalf", "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Implementation of the \"Dodd-Frank Wall Street Reform and Consumer Protection Act,\" including regulation of derivative instruments, regulation and capitalization of clearinghouses, protection of customer assets, and extraterritorial application, and H.R. 2289, the \"Commodity End-User Relief Act.\"", "foreign_entity_issues": "London Stock Exchange Group plc is incorporated in the United Kingdom.", "lobbyists": [{"lobbyist": {"id": 31521, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, House Energy and Commerce Committee", "new": false}, {"lobbyist": {"id": 3688, "prefix": null, "prefix_display": null, "first_name": "MITCHELL", "nickname": null, "middle_name": null, "last_name": "FEUER", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, Senate Banking Committee", "new": false}, {"lobbyist": {"id": 57938, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "A", "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": "Sr. Pol. Advsr., Sen. Crapo; Leg. Asst., Rep. Metcalf", "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "CDT", "general_issue_code_display": "Commodities (big ticket)", "description": "Implementation of the \"Dodd-Frank Wall Street Reform and Consumer Protection Act,\" including regulation of derivative instruments, regulation and capitalization of clearinghouses, protection of customer assets, and extraterritorial application, and H.R. 2289, the \"Commodity End-User Relief Act.\"", "foreign_entity_issues": "London Stock Exchange Group plc is incorporated in the United Kingdom.", "lobbyists": [{"lobbyist": {"id": 31521, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, House Energy and Commerce Committee", "new": false}, {"lobbyist": {"id": 3688, "prefix": null, "prefix_display": null, "first_name": "MITCHELL", "nickname": null, "middle_name": null, "last_name": "FEUER", "suffix": null, "suffix_display": null}, "covered_position": "Counsel, Senate Banking Committee", "new": false}, {"lobbyist": {"id": 57938, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "A", "last_name": "ANDERSON", "suffix": null, "suffix_display": null}, "covered_position": "Sr. Pol. Advsr., Sen. Crapo; Leg. Asst., Rep. Metcalf", "new": false}], "government_entities": [{"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 11.942ms