lobbying_filings_raw: 41acc6d8-8363-45ca-841d-ffebc2c4e778

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
41acc6d8-8363-45ca-841d-ffebc2c4e778 4T 73271 SIGNAL GROUP CONSULTING, LLC 166978 AMERICAN SOCIETY FOR THE PREVENTION OF CRUELTY TO ANIMALS 2022 fourth_quarter 2022-12-16T13:01:58-05:00 0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/41acc6d8-8363-45ca-841d-ffebc2c4e778/", "filing_uuid": "41acc6d8-8363-45ca-841d-ffebc2c4e778", "filing_type": "4T", "filing_type_display": "4th Quarter - Termination", "filing_year": 2022, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/41acc6d8-8363-45ca-841d-ffebc2c4e778/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Emily Ellickson", "dt_posted": "2022-12-16T13:01:58-05:00", "termination_date": "2022-10-31", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1750 K Street, NW", "registrant_address_2": "Suite 200", "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 73271, "url": "https://lda.senate.gov/api/v1/registrants/73271/", "house_registrant_id": 35943, "name": "SIGNAL GROUP CONSULTING, LLC", "description": "Public affairs and government relations.", "address_1": "200 Massachusetts Ave NW", "address_2": "Floor 7", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ERIKA BELLIDO-JIN", "contact_telephone": "+1 202-234-1224", "dt_updated": "2026-01-30T12:01:02.280070-05:00"}, "client": {"id": 166978, "url": "https://lda.senate.gov/api/v1/clients/166978/", "client_id": 1006031, "name": "AMERICAN SOCIETY FOR THE PREVENTION OF CRUELTY TO ANIMALS", "general_description": "Animal welfare nonprofit organization", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2012-09-10"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to tax incentives for humane agriculture operations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53077, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": null, "last_name": "COOPER", "suffix": null, "suffix_display": null}, "covered_position": "CoS, Rep. Adam Putnam; Policy Director, House Rep. Conference; Staff Director, Rep. Policy Committee; LD, Rep. Mario Diaz-Balart; LA, Rep. Felix Grucci; LC, Senator Jon Kyl; Staff Asst., Senator Connie Mack", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "Issues related to animal protection including the slaughter of horses for human consumption, wild horses on federal lands, and the cost of care for animals seized by law enforcement. Issues related to puppy mills. Issues related to pets in housing and shelters.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53077, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": null, "last_name": "COOPER", "suffix": null, "suffix_display": null}, "covered_position": "CoS, Rep. Adam Putnam; Policy Director, House Republican Conference; Staff Director, Republican Policy Committee; LD, Rep. Mario Diaz-Balart; LA, Rep. Felix Grucci; LC, Senator Jon Kyl; Staff Asst., Senator Connie Mack", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Legislation related to the slaughter of horses for human consumption.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53077, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": null, "last_name": "COOPER", "suffix": null, "suffix_display": null}, "covered_position": "CoS, Rep. Adam Putnam; Policy Director, House Republican Conference; Staff Director, Republican Policy Committee; LD, Rep. Mario Diaz-Balart; LA, Rep. Felix Grucci; LC, Senator Jon Kyl; Staff Asst., Senator Connie Mack", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Issues related to the transportation of horses for the purpose of slaughter.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53077, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": null, "last_name": "COOPER", "suffix": null, "suffix_display": null}, "covered_position": "CoS, Rep. Adam Putnam; Policy Director, House Republican Conference; Staff Director, Republican Policy Committee; LD, Rep. Mario Diaz-Balart; LA, Rep. Felix Grucci; LC, Senator Jon Kyl; Staff Asst., Senator Connie Mack", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 35943 DC   US US Animal welfare nonprofit organization 0 0         10000.0  

Links from other tables