home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9ccaf954-d0c8-4eda-a6f9-e4f0f2d53f25

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
9ccaf954-d0c8-4eda-a6f9-e4f0f2d53f25 Q1 14451 THE FERGUSON GROUP 119919 JACKSON-TN CITY OF 2013 first_quarter 2013-04-18T16:05:08.993000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9ccaf954-d0c8-4eda-a6f9-e4f0f2d53f25/", "filing_uuid": "9ccaf954-d0c8-4eda-a6f9-e4f0f2d53f25", "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/9ccaf954-d0c8-4eda-a6f9-e4f0f2d53f25/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kareem D. Murphy, Partner", "dt_posted": "2013-04-18T16:05:08.993000-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": 119919, "url": "https://lda.senate.gov/api/v1/clients/119919/", "client_id": 2688, "name": "JACKSON-TN CITY OF", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "TN", "state_display": "Tennessee", "country": "US", "country_display": "United States of America", "ppb_state": "TN", "ppb_state_display": "Tennessee", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-08"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Assistance with Early Retiree Reinsurance Program (ERRP) claim for reimbursement.", "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": 157, "name": "Bureau of Justice Assistance"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Making appropriations for Science, Department of State, Justice, and Commerce, and Related Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Justice, all provisions related to funding for local police departments' communications infrastructure.Making appropriations for Departments of Transportation, Treasury, and Housing and Urban Development, the Judiciary, District of Columbia, and Independent Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Transportation, Federal Highway Administration, Surface Transportation Program, all provisions related to funding for local governments.\n\nMakings appropriations for the Departments of Labor, Health and Human Services, and Education and Related Agencies for fiscal years ending September 30, 2013 and 2014, all provisions related to funding for local drug treatment programs for local governments.\n\nMaking appropriations for Department of Interior, Environment, and Related Agencies for fiscal years ending September 30, 2013 and 2014, Title 2, Environmental Protection Agency, State and Tribual Assistance Grants, all provisions related to environmental restoration needs for local governments.", "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": 157, "name": "Bureau of Justice Assistance"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Making appropriations for Science, Department of State, Justice, and Commerce, and Related Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Justice, all provisions related to funding for local police departments' communications infrastructure.\nAssistance with Southern Bypass Project.Making appropriations for Departments of Transportation, Treasury, and Housing and Urban Development, the Judiciary, District of Columbia, and Independent Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Transportation, Federal Highway Administration, Surface Transportation Program, all provisions related to funding for local governments.\n\nWater Resources Development Act, provisions related to extension of water withdrawal contract between City and U.S. Army Corps of Engineers; Water Resources, language to clarify legal status Sandy Creek in Western Tennessee.\n\nPassage of MAP-21 and implementation.", "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": 157, "name": "Bureau of Justice Assistance"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Making appropriations for Science, Department of State, Justice, and Commerce, and Related Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Justice, all provisions related to funding for local police departments' communications infrastructure.Making appropriations for Departments of Transportation, Treasury, and Housing and Urban Development, the Judiciary, District of Columbia, and Independent Agencies for fiscal years ending September 30, 2013 and 2014, Title 1, Department of Transportation, Federal Highway Administration, Surface Transportation Program, all provisions related to funding for local governments.\n\nMakings appropriations for the Departments of Labor, Health and Human Services, and Education and Related Agencies for fiscal years ending September 30, 2013 and 2014, all provisions related to funding for local drug treatment programs for local governments.\n\nMaking appropriations for Department of Interior, Environment, and Related Agencies for fiscal years ending September 30, 2013 and 2014, Title 2, Environmental Protection Agency, State and Tribual Assistance Grants, all provisions related to environmental restoration needs for local governments.\n\nWater Resources Development Act, provisions related to extension of water withdrawal contract between City and U.S. Army Corps of Engineers; Water Resources, language to clarify legal status Sandy Creek in Western Tennessee.\n\nRecovery from damage caused by national disaster.", "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": 157, "name": "Bureau of Justice Assistance"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32589 TN TN US US   0 0        

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 8.418ms