home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 5cdc8b95-dd24-41fb-a45e-6054396ebdff

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
5cdc8b95-dd24-41fb-a45e-6054396ebdff Q1 400786367 TAUZIN STRATEGIC NETWORKS 195292 TAUZIN CONSULTANTS (ON BEHALF OF T-MOBILE USA, INC.) 2020 first_quarter 2020-04-10T11:28:44.897000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/5cdc8b95-dd24-41fb-a45e-6054396ebdff/", "filing_uuid": "5cdc8b95-dd24-41fb-a45e-6054396ebdff", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/5cdc8b95-dd24-41fb-a45e-6054396ebdff/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Aidan Adams", "dt_posted": "2020-04-10T11:28:44.897000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "412 Biltmore Way", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Lafayette", "registrant_state": "LA", "registrant_zip": "70508", "registrant": {"id": 400786367, "url": "https://lda.senate.gov/api/v1/registrants/400786367/", "house_registrant_id": null, "name": "TAUZIN STRATEGIC NETWORKS", "description": "Strategic advice.", "address_1": "19343 E. US Hwy 57", "address_2": null, "address_3": null, "address_4": null, "city": "Batesville", "state": "TX", "state_display": "Texas", "zip": "78829", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "AIDAN ADAMS", "contact_telephone": "+1 307-399-2226", "dt_updated": "2026-01-01T05:43:03.837318-05:00"}, "client": {"id": 195292, "url": "https://lda.senate.gov/api/v1/clients/195292/", "client_id": 90, "name": "TAUZIN CONSULTANTS (ON BEHALF OF T-MOBILE USA, INC.)", "general_description": "Government relations, business development, and business incubation firm.", "client_government_entity": false, "client_self_select": null, "state": "LA", "state_display": "Louisiana", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2015-06-19"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Advocated for issues related internet service provider (ISP) privacy, wireless spectrum, and the wireless industry. \nAlso, issues related to the FCC spectrum auction repacking process and issues related to the Sprint Merger.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55181, "prefix": "mr", "prefix_display": "MR.", "first_name": "W.J.", "nickname": "BILLY", "middle_name": null, "last_name": "TAUZIN", "suffix": null, "suffix_display": null}, "covered_position": "Member of Congress (LA-3)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Advocated for issues related to cybersecurity, internet service provider (ISP) privacy, wireless spectrum, and the wireless industry. \nAlso, issues related to the FCC spectrum auction repacking process, issues related to the Sprint Merger.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55181, "prefix": "mr", "prefix_display": "MR.", "first_name": "W.J.", "nickname": "BILLY", "middle_name": null, "last_name": "TAUZIN", "suffix": null, "suffix_display": null}, "covered_position": "Member of Congress (LA-3)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": [{"name": "T-MOBILE USA, INC.", "url": null, "address_1": "601 Pennsylvania Ave NW Suite 800 N", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_city": null, "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America"}]} TX US   LA DC US US Government relations, business development, and business incubation firm. 0 1        

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 1 row from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.914ms