lobbying_filings_raw: 4fa2a13b-b6be-4aeb-b7f5-202aa97f56a3

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
4fa2a13b-b6be-4aeb-b7f5-202aa97f56a3 Q1 14451 THE FERGUSON GROUP 120014 COLLEGE PARK-GA CITY OF 2013 first_quarter 2013-04-18T15:56:30.533000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4fa2a13b-b6be-4aeb-b7f5-202aa97f56a3/", "filing_uuid": "4fa2a13b-b6be-4aeb-b7f5-202aa97f56a3", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2013, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4fa2a13b-b6be-4aeb-b7f5-202aa97f56a3/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kareem D. Murphy, Partner", "dt_posted": "2013-04-18T15:56:30.533000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1130 CONNECTICUT AVENUE NW", "registrant_address_2": "SUITE 300", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 14451, "url": "https://lda.senate.gov/api/v1/registrants/14451/", "house_registrant_id": 32589, "name": "THE FERGUSON GROUP", "description": "Government Relations/Lobbying Firm", "address_1": "1901 Pennsylvania Avenue, NW", "address_2": "Suite 700", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LAURA COSENZO", "contact_telephone": "+1 202-331-8500", "dt_updated": "2026-02-25T18:10:13.781235-05:00"}, "client": {"id": 120014, "url": "https://lda.senate.gov/api/v1/clients/120014/", "client_id": 5088, "name": "COLLEGE PARK-GA CITY OF", "general_description": null, "client_government_entity": true, "client_self_select": null, "state": "GA", "state_display": "Georgia", "country": "US", "country_display": "United States of America", "ppb_state": "GA", "ppb_state_display": "Georgia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Funding for roadway and arterial improvements in City and connections with Atlanta airpot.\nTIGER grant support.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8388, "prefix": "mr", "prefix_display": "MR.", "first_name": "KAREEM", "nickname": null, "middle_name": "D", "last_name": "MURPHY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Water/wastewater infrastructure improvements.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8388, "prefix": "mr", "prefix_display": "MR.", "first_name": "KAREEM", "nickname": null, "middle_name": "D", "last_name": "MURPHY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Making appropriations for Departments of Education, Justice, Interior, Transportation, Treasury, and Housing and Urban Development, Labor, Health and Human Services, the Judiciary, District of Columbia, and Independent Agencies for fiscal yeard ending September 30, 2013 and 2014.Making appropriations for Department of Interior, Environment, and Related Agencies for fiscal years ending September 30, 2013 and 2014.\n\nHartsfield International Airport (ATL) development and noise mitigation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8388, "prefix": "mr", "prefix_display": "MR.", "first_name": "KAREEM", "nickname": null, "middle_name": "D", "last_name": "MURPHY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Encroachment of Hartsfield-Jackson Atlanta International Airport and the City of Atlanta on the incorporated city limits of College Park, GA, enforcement of FAA regulations related to federal acquired lands at commerical airports.\n\nFY 2011 Transportation appropriations.FAA Reauthorization.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8388, "prefix": "mr", "prefix_display": "MR.", "first_name": "KAREEM", "nickname": null, "middle_name": "D", "last_name": "MURPHY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32589 GA GA US US   1 0         20000.0  

Links from other tables