home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4e2b4732-c12a-4e59-b6c2-98eed72ef209

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
4e2b4732-c12a-4e59-b6c2-98eed72ef209 Q1 401108978 HARPER & BAILEY GOVERNMENTAL SOLUTIONS LLC 63137 FORREST-LAMAR ALLIANCE 2025 first_quarter 2025-04-14T11:07:22-04:00 22500.0 0 0 0 {"url": "https://lda.gov/api/v1/filings/4e2b4732-c12a-4e59-b6c2-98eed72ef209/", "filing_uuid": "4e2b4732-c12a-4e59-b6c2-98eed72ef209", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/4e2b4732-c12a-4e59-b6c2-98eed72ef209/print/", "filing_document_content_type": "text/html", "income": "22500.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Brett Bailey", "dt_posted": "2025-04-14T11:07:22-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "317 East Capitol Street", "registrant_address_2": "Suite 100", "registrant_different_address": false, "registrant_city": "Jackson", "registrant_state": "MS", "registrant_zip": "39201", "registrant": {"id": 401108978, "url": "https://lda.gov/api/v1/registrants/401108978/", "house_registrant_id": 56711, "name": "HARPER & BAILEY GOVERNMENTAL SOLUTIONS LLC", "description": null, "address_1": "317 East Capitol Street", "address_2": "Suite 100", "address_3": null, "address_4": null, "city": "Jackson", "state": "MS", "state_display": "Mississippi", "zip": "39201", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MAGGIE BAILEY", "contact_telephone": "+1 601-291-2702", "dt_updated": "2026-01-06T11:17:59.297195-05:00"}, "client": {"id": 63137, "url": "https://lda.gov/api/v1/clients/63137/", "client_id": 63137, "name": "FORREST-LAMAR ALLIANCE", "general_description": "City/County Partnerships", "client_government_entity": null, "client_self_select": false, "state": "MS", "state_display": "Mississippi", "country": "US", "country_display": "United States of America", "ppb_state": "MS", "ppb_state_display": "Mississippi", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2024-11-01"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Engage directly with federal Congressional delegation representing the Hattiesburg region to educate them on the expedited need for review and approval by the Corps, EPA, and other agencies of jurisdiction.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 148055, "prefix": null, "prefix_display": null, "first_name": "BRETT", "nickname": null, "middle_name": null, "last_name": "BAILEY", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Relations, Harper & Bailey", "new": false}, {"lobbyist": {"id": 148054, "prefix": null, "prefix_display": null, "first_name": "GREGG", "nickname": null, "middle_name": null, "last_name": "HARPER", "suffix": null, "suffix_display": null}, "covered_position": "Former Member of Congress (2009-2019); President, Harper & Bailey Governmental Solutions LLC", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} MS US 56711 MS MS US US City/County Partnerships   0        

Links from other tables

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