lobbying_filings_raw: 4346786b-1597-4a8a-8e05-16daa96e4e8e

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
4346786b-1597-4a8a-8e05-16daa96e4e8e	Q1	10332	COMPUTER & COMMUNICATIONS INDUSTRY ASSOCIATION	114215	COMPUTER & COMMUNICATIONS INDUSTRY ASSOCIATION	2025	first_quarter	2025-04-16T14:41:46-04:00	0	0	0	{"url": "https://lda.gov/api/v1/filings/4346786b-1597-4a8a-8e05-16daa96e4e8e/", "filing_uuid": "4346786b-1597-4a8a-8e05-16daa96e4e8e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/4346786b-1597-4a8a-8e05-16daa96e4e8e/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "80000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "DANIEL JOHNSON", "dt_posted": "2025-04-16T14:41:46-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "25 Massachusetts Ave", "registrant_address_2": "Suite 300C", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 10332, "url": "https://lda.gov/api/v1/registrants/10332/", "house_registrant_id": 30839, "name": "COMPUTER & COMMUNICATIONS INDUSTRY ASSOCIATION", "description": null, "address_1": "25 Massachusetts Ave", "address_2": "Suite 300C", "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": "DANIEL JOHNSON", "contact_telephone": "+1 202-783-0070", "dt_updated": "2026-01-20T17:52:45.723437-05:00"}, "client": {"id": 114215, "url": "https://lda.gov/api/v1/clients/114215/", "client_id": 12, "name": "COMPUTER & COMMUNICATIONS INDUSTRY ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "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": "1996-02-14"}, "lobbying_activities": [{"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "S 5379 TRAIN Act, Kids online safety/privacy, HR 633 TAKE IT DOWN Act, HR 8187, Intimate Privacy Protection Act, Patent Reform, Artificial Intelligence, Content Moderation, Digital Replicas, Privacy, Section 230, Digital Trade Barriers, Tmobile/UScellular Transaction, Privacy Working Group, space and spectrum policy, S 4875 No Fakes Act, Export Controls, DMA, S 278 Kids Off Social Media Act S. 2220 Prevail act, S 4533 Restore Act, S 2140 Patent Eligibility Restoration Act, S 281 TICKET Act, S 2114 Foreign Adversary Communications Transparency Act, HR 699 Email Privacy Act, Korea's Platform Regulation Bill, immigration reform,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 109, "name": "Intl Trade Administration (ITA)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 207, "name": "U.S. Copyright Office"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Skilled Immigration Reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "International Trade Issues, International Digital Policy, USMCA, Gatekeeper, Canada Online News law, Korrea Cloud Certification, AUSFTA, Korea Platform Regulations,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Copyright and Patent Reform, Copyright enforcement, Copyright Modernization, Intermediary Liability, Section 301, IPR, RAIA, S2891, WIPO, Music Licensing, Prevail Act S2220, S1409, NO FAKES Act, S1409, generative AI, PADRA, S2140 Patent Eligibility Restoration Act,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 207, "name": "U.S. Copyright Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Online Tax, Tax reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Open Internet, Broadband deployment, Special Access, Peering Act, Save thee Internet Act S3195 (Consumer Online Privacy Rights Act, HR 8152 American Data Privacy and Protection Act, HR 8575 and S 2427 Fair contributions Act, SHOPSAFE, INFORM Consumers Act, T-Mobile / USCellular transition", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INT", "general_issue_code_display": "Intelligence", "description": "International Communications Privacy, hacking back, encryption, Cross boarder Protection, Export Controls", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145994, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "MCMILLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	30839	DC	DC	US	US		0	0						80000.0

Links from other tables

21 rows from filing_uuid in lobbying_activities
3 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs