home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bbf38daa-e71b-44c1-874f-edb4a4f460ed

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 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
bbf38daa-e71b-44c1-874f-edb4a4f460ed Q4 18524 HOME SCHOOL LEGAL DEFENSE ASSN 125609 HOME SCHOOL LEGAL DEFENSE ASSN 2011 fourth_quarter 2012-01-25T15:42:52.553000-05:00 75000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bbf38daa-e71b-44c1-874f-edb4a4f460ed/", "filing_uuid": "bbf38daa-e71b-44c1-874f-edb4a4f460ed", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2011, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bbf38daa-e71b-44c1-874f-edb4a4f460ed/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "75000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "William A. Estrada, Esq., Director of Federal Relations", "dt_posted": "2012-01-25T15:42:52.553000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1 PATRICK HENRY CIRCLE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "PURCELLVILLE", "registrant_state": "VA", "registrant_zip": "20134", "registrant": {"id": 18524, "url": "https://lda.senate.gov/api/v1/registrants/18524/", "house_registrant_id": 30992, "name": "HOME SCHOOL LEGAL DEFENSE ASSN", "description": null, "address_1": "1 PATRICK HENRY CIRCLE", "address_2": null, "address_3": null, "address_4": null, "city": "PURCELLVILLE", "state": "VA", "state_display": "Virginia", "zip": "20134", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM A. ESTRADA", "contact_telephone": "+1 540-338-5600", "dt_updated": "2022-04-06T16:07:22.695919-04:00"}, "client": {"id": 125609, "url": "https://lda.senate.gov/api/v1/clients/125609/", "client_id": 12, "name": "HOME SCHOOL LEGAL DEFENSE ASSN", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-10"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Work with Members of Congress and their staff to ensure that homeschool graduates are able to continue to enlist without problems in the U.S. Armed Forces. Work on NDAA, HR 1540 and S. 1253.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45127, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "ANTHONY", "last_name": "ESTRADA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49694, "prefix": null, "prefix_display": null, "first_name": "MELANIE", "nickname": null, "middle_name": null, "last_name": "PALAZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Opposition to S. 1877, Federal Mandatory Reporting of Child Abuse Legislation introduced by Senators Boxer and Casey. We believe that this bill would lead to gross violations of the civil rights of innocent families, who may be hotlined for child abuse/neglect for no reason.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45127, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "ANTHONY", "last_name": "ESTRADA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49694, "prefix": null, "prefix_display": null, "first_name": "MELANIE", "nickname": null, "middle_name": null, "last_name": "PALAZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 50877, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "PAUL", "last_name": "FARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FAM", "general_issue_code_display": "Family issues/Abortion/Adoption", "description": "Opposition to any attempt to ratify the U.N. Convention on the Rights of the Child.\nOpposition to any attempt to ratify the U.N. Convention On the Elimination of All Forms of Discrimation Against Women.\nOpposition to any attempt to ratify the U.N. Convention on the Rights of Persons with Disabilities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45127, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "ANTHONY", "last_name": "ESTRADA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 50877, "prefix": "mr", "prefix_display": "MR.", "first_name": "MICHAEL", "nickname": null, "middle_name": "PAUL", "last_name": "FARRIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49694, "prefix": null, "prefix_display": null, "first_name": "MELANIE", "nickname": null, "middle_name": null, "last_name": "PALAZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Protection of home education from government regulation - meetings with various Congressional offices to talk about homeschooling success.\nMeetings with Members of Congress and staff about protecting homeschool freedom in the reauthorization of the Elementary and Secondary Education Act, including protecting the language codified in 20 U.S.C. 7886, if Congress reauthorizes ESEA. Opposition to Senate's ESEA reauthorization draft legislation that was introduced by Senators Harkin and Enzi due to concerns that it significantly increases the federal role in education. We believe that this legislation could lead to federal/state control over homeschooling.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45127, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "ANTHONY", "last_name": "ESTRADA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49694, "prefix": null, "prefix_display": null, "first_name": "MELANIE", "nickname": null, "middle_name": null, "last_name": "PALAZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 30992 VA VA US US   0 0 975279   normalized_name_state 0.9

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 133.315ms