home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a81cebbd-3c9e-436e-9b19-e4035b3d70ea

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
a81cebbd-3c9e-436e-9b19-e4035b3d70ea Q1 73271 SIGNAL GROUP CONSULTING, LLC 166978 AMERICAN SOCIETY FOR THE PREVENTION OF CRUELTY TO ANIMALS 2018 first_quarter 2018-04-20T10:03:07.677000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a81cebbd-3c9e-436e-9b19-e4035b3d70ea/", "filing_uuid": "a81cebbd-3c9e-436e-9b19-e4035b3d70ea", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2018, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a81cebbd-3c9e-436e-9b19-e4035b3d70ea/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Amanda Lee", "dt_posted": "2018-04-20T10:03:07.677000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "455 Massachusetts Avenue, NW", "registrant_address_2": "12th Floor", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "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": "TOR", "general_issue_code_display": "Torts", "description": "Issues related to cost of care for animals seized by law enforcement, including HR 398.", "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"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "FY2018 Agriculture Appropriations, including the prevention of horse slaughter. The Safeguard American Food Exports Act of 2017 (HR 113).", "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": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "Animal protection issues including the prevention of horse slaughter. Safeguard American Food Exports Act of 2017 (HR 113) and the FY2018 Agriculture Appropriations bill.Issues related to the cost of care for animals seized by law enforcement, including HR 398.", "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": 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

  • 3 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 9.46ms