lobbying_filings_raw: 24692cd7-b7ba-40bd-b002-e2eaee3ef2f9

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
24692cd7-b7ba-40bd-b002-e2eaee3ef2f9 Q1 401105797 AGORA CONSULTING, LLC 53972 SOMFY NORTH AMERICA 2024 first_quarter 2024-04-03T10:33:53-04:00 21000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/24692cd7-b7ba-40bd-b002-e2eaee3ef2f9/", "filing_uuid": "24692cd7-b7ba-40bd-b002-e2eaee3ef2f9", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2024, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/24692cd7-b7ba-40bd-b002-e2eaee3ef2f9/print/", "filing_document_content_type": "text/html", "income": "21000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Andrew Goldberg", "dt_posted": "2024-04-03T10:33:53-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": 53972, "url": "https://lda.senate.gov/api/v1/clients/53972/", "client_id": 53972, "name": "SOMFY NORTH AMERICA", "general_description": "Building product manufacturing", "client_government_entity": null, "client_self_select": false, "state": "NJ", "state_display": "New Jersey", "country": "US", "country_display": "United States of America", "ppb_state": "NJ", "ppb_state_display": "New Jersey", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2023-01-01"}, "lobbying_activities": [{"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Support for building energy code changes", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Applicability of Sec. 48 Investment Tax Credit and Sec. 25C Energy Efficient Home Improvement Credit to automated shading systems", "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": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "H. R. 2491/S. 1107, SAFE School Act H.R. 2483/S. 1083, School Security Enhancement Act H.R.2479/S.1082, Securing Our Schools Act of 2023 H.R.887, Securing Our Students Act H.R., 3618, Safer Schools Act of 2023 H.R. 5184, School Security Enhancement Act S. 2608, Rebuild America's Schools Act", "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