home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4e8e38f6-2fa4-41a9-977d-9c48adea06c2

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
4e8e38f6-2fa4-41a9-977d-9c48adea06c2 Q2 25055 MEXICAN AMERICAN LEGAL DEFENSE AND EDUCATIONAL FUND 132631 MEXICAN AMERICAN LEGAL DEFENSE AND EDUCATIONAL FUND 2015 second_quarter 2015-07-22T12:33:01.400000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4e8e38f6-2fa4-41a9-977d-9c48adea06c2/", "filing_uuid": "4e8e38f6-2fa4-41a9-977d-9c48adea06c2", "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/4e8e38f6-2fa4-41a9-977d-9c48adea06c2/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Geraldine Alonso", "dt_posted": "2015-07-22T12:33:01.400000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1016 16th Street, NW, Ste. 100", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 25055, "url": "https://lda.senate.gov/api/v1/registrants/25055/", "house_registrant_id": 32641, "name": "MEXICAN AMERICAN LEGAL DEFENSE AND EDUCATIONAL FUND", "description": "Civil rights organization", "address_1": "1016 16th Street, NW", "address_2": "Suite 100", "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": "ANDREA SENTENO", "contact_telephone": "+1 202-293-2828", "dt_updated": "2025-07-10T16:48:58.147563-04:00"}, "client": {"id": 132631, "url": "https://lda.senate.gov/api/v1/clients/132631/", "client_id": 12, "name": "MEXICAN AMERICAN LEGAL DEFENSE AND EDUCATIONAL FUND", "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": "2010-04-01"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "H.R.5, the Student Success Act.\nS. 1177, the Every Child Achieves Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57861, "prefix": "mr", "prefix_display": "MR.", "first_name": "ADAM", "nickname": null, "middle_name": "J", "last_name": "FERNANDEZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Staff Attorney", "new": false}, {"lobbyist": {"id": 53408, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "ANDREW", "last_name": "SAENZ", "suffix": null, "suffix_display": null}, "covered_position": "President and General Counsel", "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "H.R. 885, Voting Rights Amendment Act of 2015.\nS.1659/H.R. 2867, Voting Rights Advancement Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60241, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "SENTENO", "suffix": null, "suffix_display": null}, "covered_position": "Staff Attorney", "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "President's executive actions on Immigration.\nS. 178, Justice for Victims of Trafficking Act of 2015.\nH.R. 140, The Birthright Citizenship Act of 2015.\nH.R. 2578, The Commerce, Justice, Science, and Related Agencies Appropriations Act for FY 2016.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60241, "prefix": null, "prefix_display": null, "first_name": "ANDREA", "nickname": null, "middle_name": null, "last_name": "SENTENO", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Staff Attorney", "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Introductions to new staff member. General discussions of labor issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62550, "prefix": null, "prefix_display": null, "first_name": "ERNIE", "nickname": null, "middle_name": null, "last_name": "DOMINGUEZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Staff Attorney", "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 81, "name": "Office of Personnel Management (OPM)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 43.092ms