home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 24262dde-cb13-4e5c-b3fe-eaca6f4af009

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
24262dde-cb13-4e5c-b3fe-eaca6f4af009 Q2 11195 COVINGTON & BURLING LLP 115195 AMERICAN SHAREHOLDERS IN YUKOS (AN INFORMAL COALITION) 2015 second_quarter 2015-07-20T15:31:51.427000-04:00 90000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/24262dde-cb13-4e5c-b3fe-eaca6f4af009/", "filing_uuid": "24262dde-cb13-4e5c-b3fe-eaca6f4af009", "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/24262dde-cb13-4e5c-b3fe-eaca6f4af009/print/", "filing_document_content_type": "text/html", "income": "90000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Marney Cheek", "dt_posted": "2015-07-20T15:31:51.427000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "850 Tenth Street, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 11195, "url": "https://lda.senate.gov/api/v1/registrants/11195/", "house_registrant_id": 31827, "name": "COVINGTON & BURLING LLP", "description": "Law firm", "address_1": "850 10th Street, NW", "address_2": null, "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": "BRIAN SMITH", "contact_telephone": "+1 202-662-5090", "dt_updated": "2026-01-26T21:21:48.674471-05:00"}, "client": {"id": 115195, "url": "https://lda.senate.gov/api/v1/clients/115195/", "client_id": 1004835, "name": "AMERICAN SHAREHOLDERS IN YUKOS (AN INFORMAL COALITION)", "general_description": "American shareholders in the former Yukos Oil 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": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-05-18"}, "lobbying_activities": [{"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Building U.S. government support for the rule of law in Russia and the assistance of the U.S. government in obtaining compensation from the Russian Federation for the interests of U.S. shareholders in the Yukos oil company.", "foreign_entity_issues": "Affiliates of GML Limited also hold claims against the Russian Federation related to the ownership of shares in the Yukos Oil Company.", "lobbyists": [{"lobbyist": {"id": 40805, "prefix": "mr", "prefix_display": "MR.", "first_name": "STUART", "nickname": null, "middle_name": "E", "last_name": "EIZENSTAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41877, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": "P", "last_name": "LARSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16562, "prefix": null, "prefix_display": null, "first_name": "MARNEY", "nickname": null, "middle_name": "L", "last_name": "CHEEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51923, "prefix": null, "prefix_display": null, "first_name": "MUFTIAH", "nickname": null, "middle_name": null, "last_name": "MCCARTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45165, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": null, "last_name": "WICHTERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Building U.S. government support for the rule of law in Russia and the assistance of the U.S. government in obtaining compensation from the Russian Federation for the interests of U.S. shareholders in the Yukos oil company.", "foreign_entity_issues": "Affiliates of GML Limited also hold claims against the Russian Federation related to the ownership of shares in the Yukos Oil Company.", "lobbyists": [{"lobbyist": {"id": 40805, "prefix": "mr", "prefix_display": "MR.", "first_name": "STUART", "nickname": null, "middle_name": "E", "last_name": "EIZENSTAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41877, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": "P", "last_name": "LARSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16562, "prefix": null, "prefix_display": null, "first_name": "MARNEY", "nickname": null, "middle_name": "L", "last_name": "CHEEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51923, "prefix": null, "prefix_display": null, "first_name": "MUFTIAH", "nickname": null, "middle_name": null, "last_name": "MCCARTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45165, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": null, "last_name": "WICHTERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Building U.S. government support for the rule of law in Russia and the assistance of the U.S. government in obtaining\ncompensation from the Russian Federation for the interests of U.S. shareholders in the Yukos oil company.", "foreign_entity_issues": "Affiliates of GML Limited also hold claims against the Russian Federation related to the ownership of shares in the Yukos Oil Company.", "lobbyists": [{"lobbyist": {"id": 40805, "prefix": "mr", "prefix_display": "MR.", "first_name": "STUART", "nickname": null, "middle_name": "E", "last_name": "EIZENSTAT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41877, "prefix": null, "prefix_display": null, "first_name": "ALAN", "nickname": null, "middle_name": "P", "last_name": "LARSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 16562, "prefix": null, "prefix_display": null, "first_name": "MARNEY", "nickname": null, "middle_name": "L", "last_name": "CHEEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51923, "prefix": null, "prefix_display": null, "first_name": "MUFTIAH", "nickname": null, "middle_name": null, "last_name": "MCCARTIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45165, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": null, "last_name": "WICHTERMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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