home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4b29ba9a-e2c4-4f48-9fcc-d5dcc449c459

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
4b29ba9a-e2c4-4f48-9fcc-d5dcc449c459 Q4 305932 THE PETRIZZO GROUP, INC. 181761 CHARTER COMMUNICATIONS 2009 fourth_quarter 2010-01-13T13:49:50.480000-05:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4b29ba9a-e2c4-4f48-9fcc-d5dcc449c459/", "filing_uuid": "4b29ba9a-e2c4-4f48-9fcc-d5dcc449c459", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2009, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4b29ba9a-e2c4-4f48-9fcc-d5dcc449c459/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Thomas J. \"T.J.\" Petrizzo, Chairman and CEO", "dt_posted": "2010-01-13T13:49:50.480000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "601 13TH STREET, N.W.", "registrant_address_2": "SUITE 430 NORTH", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 305932, "url": "https://lda.senate.gov/api/v1/registrants/305932/", "house_registrant_id": 38088, "name": "THE PETRIZZO GROUP, INC.", "description": "Government Relations and Strategic Communications Firm", "address_1": "601 New Jersey Avenue NW", "address_2": "Suite 830", "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": "T.J. PETRIZZO", "contact_telephone": "+1 202-365-4583", "dt_updated": "2026-01-10T16:22:46.380302-05:00"}, "client": {"id": 181761, "url": "https://lda.senate.gov/api/v1/clients/181761/", "client_id": 1000580, "name": "CHARTER COMMUNICATIONS", "general_description": "Broadband Communications Company", "client_government_entity": false, "client_self_select": false, "state": null, "state_display": null, "country": "", "country_display": "* Undetermined", "ppb_state": null, "ppb_state_display": null, "ppb_country": "", "ppb_country_display": "* Undetermined", "effective_date": "2007-08-07"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Voice competition issues, including number portability, retnetion marketing and interconnection. Financial institutions (including TARP funded institutions) and their lending practices in general and with regard to bankruptcy proceedings. SHVERA Reauthorization and Channel Migration issues in selected states.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 3241, "prefix": null, "prefix_display": null, "first_name": "TJ", "nickname": null, "middle_name": null, "last_name": "PETRIZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2710, "prefix": null, "prefix_display": null, "first_name": "OMAR", "nickname": null, "middle_name": null, "last_name": "FRANCO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43733, "prefix": null, "prefix_display": null, "first_name": "JUSTIN", "nickname": null, "middle_name": null, "last_name": "LEBLANC", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41492, "prefix": null, "prefix_display": null, "first_name": "TRICIA", "nickname": null, "middle_name": null, "last_name": "BARRENTINE GUAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46106, "prefix": null, "prefix_display": null, "first_name": "LINDSEY", "nickname": null, "middle_name": null, "last_name": "LEDWIN", "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": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Voice competition issues, including number portability, retnetion marketing and interconnection. Financial institutions (including TARP funded institutions) and their lending practices in general and with regard to bankruptcy proceedings. SHVERA Reauthorization and Channel Migration issues in selected states.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 3241, "prefix": null, "prefix_display": null, "first_name": "TJ", "nickname": null, "middle_name": null, "last_name": "PETRIZZO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43733, "prefix": null, "prefix_display": null, "first_name": "JUSTIN", "nickname": null, "middle_name": null, "last_name": "LEBLANC", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2710, "prefix": null, "prefix_display": null, "first_name": "OMAR", "nickname": null, "middle_name": null, "last_name": "FRANCO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41492, "prefix": null, "prefix_display": null, "first_name": "TRICIA", "nickname": null, "middle_name": null, "last_name": "BARRENTINE GUAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46106, "prefix": null, "prefix_display": null, "first_name": "LINDSEY", "nickname": null, "middle_name": null, "last_name": "LEDWIN", "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

  • 2 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 30.042ms