home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bfbd2ef3-a259-4ecc-8df3-c323282d9e7b

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
bfbd2ef3-a259-4ecc-8df3-c323282d9e7b Q2 401105797 AGORA CONSULTING, LLC 207026 AMERICAN CULTURAL RESOURCES ASSN 2022 second_quarter 2022-07-12T15:43:40-04:00 13500.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bfbd2ef3-a259-4ecc-8df3-c323282d9e7b/", "filing_uuid": "bfbd2ef3-a259-4ecc-8df3-c323282d9e7b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bfbd2ef3-a259-4ecc-8df3-c323282d9e7b/print/", "filing_document_content_type": "text/html", "income": "13500.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew Goldberg", "dt_posted": "2022-07-12T15:43:40-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "10771 DEBORAH DRIVE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "POTOMAC", "registrant_state": "MD", "registrant_zip": "20854", "registrant": {"id": 401105797, "url": "https://lda.senate.gov/api/v1/registrants/401105797/", "house_registrant_id": null, "name": "AGORA CONSULTING, LLC", "description": "Government relations consulting", "address_1": "10771 DEBORAH DRIVE", "address_2": null, "address_3": null, "address_4": null, "city": "POTOMAC", "state": "MD", "state_display": "Maryland", "zip": "20854", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANDREW GOLDBERG", "contact_telephone": "+1 202-321-1877", "dt_updated": "2026-02-05T12:09:28.757112-05:00"}, "client": {"id": 207026, "url": "https://lda.senate.gov/api/v1/clients/207026/", "client_id": 12, "name": "AMERICAN CULTURAL RESOURCES ASSN", "general_description": "Trade association", "client_government_entity": false, "client_self_select": null, "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": "2020-10-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 2471 - Consolidated Appropriations Act, 2022 Full funding of Historic Preservation Fund in FY22 budget", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 80924, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "GOLDBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RES", "general_issue_code_display": "Real Estate/Land Use/Conservation", "description": "H.R. 6589 - Historic Preservation Enhancement Act H.R. 6805/S. 3667 African American Burial Grounds Preservation Act H.R. 2930/S. 1471 - Safeguard Tribal Objects of Patrimony Act of 2021 H.R> 3587 - Requirements, Expectations, and Standard Procedures for Effective Consultation with Tribes Act (RESPECT Act) Support for Sec. 106 of the National Historic Preservation Act Revisions to 2020 changes to NEPA Regulations Army Corps proposed revisions to Appendix C", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 80924, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "GOLDBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 214, "name": "Advisory Council on Historic Preservation (ACHP)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "PPP program on government contracting rates for small firms General small business issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 80924, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "GOLDBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 12.595ms