home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dcb2beae-71cf-4e9a-bc0a-618ea69d5c51

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
dcb2beae-71cf-4e9a-bc0a-618ea69d5c51 Q3 313715 CAPITOL COUNSEL LLC 212357 US SERVICE ANIMALS (USSA) 2022 third_quarter 2022-10-18T15:34:54-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dcb2beae-71cf-4e9a-bc0a-618ea69d5c51/", "filing_uuid": "dcb2beae-71cf-4e9a-bc0a-618ea69d5c51", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2022, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/dcb2beae-71cf-4e9a-bc0a-618ea69d5c51/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Allegra M. Han", "dt_posted": "2022-10-18T15:34:54-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "700 13th Street NW, 2nd Floor", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 313715, "url": "https://lda.senate.gov/api/v1/registrants/313715/", "house_registrant_id": 39384, "name": "CAPITOL COUNSEL LLC", "description": "Government affairs.", "address_1": "700 13th Street NW, 2nd Floor", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TRACEY A. GRAY", "contact_telephone": "+1 202-861-3200", "dt_updated": "2026-01-30T14:41:10.487511-05:00"}, "client": {"id": 212357, "url": "https://lda.senate.gov/api/v1/clients/212357/", "client_id": 1007770, "name": "US SERVICE ANIMALS (USSA)", "general_description": "Provide patients with expert diagnosis and registration for emotional support animals.", "client_government_entity": false, "client_self_select": null, "state": "LA", "state_display": "Louisiana", "country": "US", "country_display": "United States of America", "ppb_state": "LA", "ppb_state_display": "Louisiana", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2021-07-01"}, "lobbying_activities": [{"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "Informational engagement with policymakers/regulators on benefits of Emotional Support Animals (ESAs) and USSAs standards and practices. Provide input on potential regulatory action.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62733, "prefix": null, "prefix_display": null, "first_name": "WARREN", "nickname": null, "middle_name": "J.", "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 101393, "prefix": null, "prefix_display": null, "first_name": "MONIQUE", "nickname": null, "middle_name": null, "last_name": "FRAZIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102514, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "KOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69294, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EANNELLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70388, "prefix": null, "prefix_display": null, "first_name": "LYNDON", "nickname": null, "middle_name": null, "last_name": "BOOZER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Informational engagement with policymakers/regulators on benefits of Emotional Support Animals (ESAs) and USSAs standards and practices. Provide input on potential regulatory action.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62733, "prefix": null, "prefix_display": null, "first_name": "WARREN", "nickname": null, "middle_name": "J.", "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 101393, "prefix": null, "prefix_display": null, "first_name": "MONIQUE", "nickname": null, "middle_name": null, "last_name": "FRAZIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102514, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "KOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69294, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EANNELLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70388, "prefix": null, "prefix_display": null, "first_name": "LYNDON", "nickname": null, "middle_name": null, "last_name": "BOOZER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "Informational engagement with policymakers/regulators on benefits of Emotional Support Animals (ESAs) and USSAs standards and practices. Provide input on potential regulatory action. Issues regarding enhancements to the Office of Fair Housing and Equal Opportunity (FHEO) Notice FHEO-2020-01, sometimes referred to as the Assistance Animals Notice.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62733, "prefix": null, "prefix_display": null, "first_name": "WARREN", "nickname": null, "middle_name": "J.", "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 101393, "prefix": null, "prefix_display": null, "first_name": "MONIQUE", "nickname": null, "middle_name": null, "last_name": "FRAZIER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102514, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "KOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69294, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EANNELLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70388, "prefix": null, "prefix_display": null, "first_name": "LYNDON", "nickname": null, "middle_name": null, "last_name": "BOOZER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 8.672ms