home / lobbying / lobbying_filings_raw

lobbying_filings_raw: fcb0e38f-0e58-487d-8a30-e997d1f7a59a

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
fcb0e38f-0e58-487d-8a30-e997d1f7a59a 4T 401105819 VON BATTEN-MONTAGUE-YORK 211283 VON BATTEN-MONTAGUE-YORK 2021 fourth_quarter 2021-11-03T11:30:23.203000-04:00 60000.0 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/fcb0e38f-0e58-487d-8a30-e997d1f7a59a/", "filing_uuid": "fcb0e38f-0e58-487d-8a30-e997d1f7a59a", "filing_type": "4T", "filing_type_display": "4th Quarter - Termination", "filing_year": 2021, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/fcb0e38f-0e58-487d-8a30-e997d1f7a59a/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "60000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Karl Von Batten", "dt_posted": "2021-11-03T11:30:23.203000-04:00", "termination_date": "2021-11-03", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1300 Pennsylvania Avenue N.W.", "registrant_address_2": "Suite 700", "registrant_different_address": false, "registrant_city": "Washington, D.C.", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 401105819, "url": "https://lda.senate.gov/api/v1/registrants/401105819/", "house_registrant_id": null, "name": "VON BATTEN-MONTAGUE-YORK", "description": "Von Batten-Montague-York, L.C. is a policy advisory and advocacy group.", "address_1": "1300 Pennsylvania Avenue N.W.", "address_2": "Suite 700", "address_3": null, "address_4": null, "city": "Washington, D.C.", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "KARL VON BATTEN", "contact_telephone": "+1 202-341-2014", "dt_updated": "2026-02-16T13:33:23.320334-05:00"}, "client": {"id": 211283, "url": "https://lda.senate.gov/api/v1/clients/211283/", "client_id": 36, "name": "VON BATTEN-MONTAGUE-YORK", "general_description": null, "client_government_entity": false, "client_self_select": true, "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": "2021-06-21"}, "lobbying_activities": [{"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Lobbied to increase US pressure on the government of the Federal Democratic Republic of Ethiopia by removing Ethiopia from key US preferred trade agreements, particularly from the African Growth and Opportunity Act eligibility list of 2022.Lobbied to increase US pressure on the Ethiopian government via increased sanctions and financial restrictions to isolate the Ethiopian government. \nThe goal is to compel the Ethiopian government to: remove all Ethiopian-allied forces and militia from the Tigray region of Ethiopia, allow for unhindered delivery of humanitarian aid to civilians in Tigray, stop the human rights violations and atrocities committed by Ethiopian and Ethiopian-allies forces and militia against civilians in Tigray, allow for an independent investigation into the reported human rights violations and atrocities committed against civilians in Tigray.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 85887, "prefix": null, "prefix_display": null, "first_name": "KARL", "nickname": null, "middle_name": null, "last_name": "VON BATTEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 2.658ms