home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 111ccb45-e624-48b7-8d46-5dd94ea0a751

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
111ccb45-e624-48b7-8d46-5dd94ea0a751 Q2 401103938 FARRAGUT PARTNERS LLP 200396 NATIONAL CABLE AND TELECOMMUNICATIONS ASSOCIATION 2019 second_quarter 2019-07-18T14:27:21.577000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/111ccb45-e624-48b7-8d46-5dd94ea0a751/", "filing_uuid": "111ccb45-e624-48b7-8d46-5dd94ea0a751", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2019, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/111ccb45-e624-48b7-8d46-5dd94ea0a751/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Jeffrey MacKinnon", "dt_posted": "2019-07-18T14:27:21.577000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1225 New York Ave, NW", "registrant_address_2": "Suite 600", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 401103938, "url": "https://lda.senate.gov/api/v1/registrants/401103938/", "house_registrant_id": null, "name": "FARRAGUT PARTNERS LLP", "description": "Lobbying Firm", "address_1": "1225 New York Ave, NW", "address_2": "Suite 600", "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": "WILL KRIEGER", "contact_telephone": "+1 202-778-4014", "dt_updated": "2026-01-27T11:30:36.207423-05:00"}, "client": {"id": 200396, "url": "https://lda.senate.gov/api/v1/clients/200396/", "client_id": 125, "name": "NATIONAL CABLE AND TELECOMMUNICATIONS ASSOCIATION", "general_description": "Telecommunications", "client_government_entity": false, "client_self_select": null, "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": "2016-01-01"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Privacy and Behavioral Advertising issues\nrelating to the gathering, retention, and use of online information. \nProgram access, Net neutrality, spectrum reform and reallocation, broadband deployment issues including use of stimulus finds for broadband deployment and adoption and broadband\nconduit legislation. \nNational Broadband Plan issues relating to competition and innovation in navigation devices.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64574, "prefix": null, "prefix_display": null, "first_name": "JEFFERY", "nickname": null, "middle_name": "C.", "last_name": "MORTIER", "suffix": null, "suffix_display": null}, "covered_position": "Prof Staff on E&C Cmte, LA Rep Whitfield and Intern Devin Nunes", "new": false}, {"lobbyist": {"id": 63678, "prefix": null, "prefix_display": null, "first_name": "JEFF", "nickname": null, "middle_name": null, "last_name": "MACKINNON", "suffix": null, "suffix_display": null}, "covered_position": "LD & LA Rep. Joe Barton (RTexas)", "new": false}, {"lobbyist": {"id": 65220, "prefix": null, "prefix_display": null, "first_name": "JODY", "nickname": null, "middle_name": "SHINTARO", "last_name": "GALE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65005, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "WALTER", "suffix": null, "suffix_display": null}, "covered_position": "Former Legislative Director/Chief Counsel, Sen. John Breaux", "new": false}, {"lobbyist": {"id": 65006, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "DANIEL", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": "LD Rep. Wayne Gilchrest and LA Rep. Jack Buechner", "new": false}, {"lobbyist": {"id": 66364, "prefix": null, "prefix_display": null, "first_name": "EDWARD", "nickname": null, "middle_name": null, "last_name": "WHITFIELD", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Representative (21 yrs.)", "new": false}, {"lobbyist": {"id": 70223, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Advisory, LA, Staff Assistant Gene Greene (D-TX) Staff Assistant GK Butterfield (D-NC)", "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": "Privacy and Behavioral Advertising issues\nrelating to the gathering, retention, and use of online information. \nProgram access, Net neutrality, spectrum reform and reallocation, broadband deployment issues including use of stimulus finds for broadband deployment and adoption and broadband\nconduit legislation. \nNational Broadband Plan issues relating to competition and innovation in navigation devices.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64574, "prefix": null, "prefix_display": null, "first_name": "JEFFERY", "nickname": null, "middle_name": "C.", "last_name": "MORTIER", "suffix": null, "suffix_display": null}, "covered_position": "Prof Staff on E&C Cmte, LA Rep Whitfield and Intern Devin Nunes", "new": false}, {"lobbyist": {"id": 63678, "prefix": null, "prefix_display": null, "first_name": "JEFF", "nickname": null, "middle_name": null, "last_name": "MACKINNON", "suffix": null, "suffix_display": null}, "covered_position": "LD & LA Rep. Joe Barton (RTexas)", "new": false}, {"lobbyist": {"id": 65220, "prefix": null, "prefix_display": null, "first_name": "JODY", "nickname": null, "middle_name": "SHINTARO", "last_name": "GALE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65005, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "WALTER", "suffix": null, "suffix_display": null}, "covered_position": "Former Legislative Director/Chief Counsel, Sen. John Breaux", "new": false}, {"lobbyist": {"id": 65006, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "DANIEL", "last_name": "WALSH", "suffix": null, "suffix_display": null}, "covered_position": "LD Rep. Wayne Gilchrest and LA Rep. Jack Buechner", "new": false}, {"lobbyist": {"id": 66364, "prefix": null, "prefix_display": null, "first_name": "EDWARD", "nickname": null, "middle_name": null, "last_name": "WHITFIELD", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Representative (21 yrs.)", "new": false}, {"lobbyist": {"id": 70223, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": "Health Policy Advisory, LA, Staff Assistant Gene Greene (D-TX) Staff Assistant GK Butterfield (D-NC)", "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
  • 7 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.289ms