lobbying_filings_raw: 67c940a4-80f2-4b5a-8d9a-0ebc8bfd3bbd

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
67c940a4-80f2-4b5a-8d9a-0ebc8bfd3bbd	3T	73271	SIGNAL GROUP CONSULTING, LLC	167063	NETJETS INC.	2019	third_quarter	2019-10-10T19:58:09.083000-04:00	60000.0	0	0	1	{"url": "https://lda.senate.gov/api/v1/filings/67c940a4-80f2-4b5a-8d9a-0ebc8bfd3bbd/", "filing_uuid": "67c940a4-80f2-4b5a-8d9a-0ebc8bfd3bbd", "filing_type": "3T", "filing_type_display": "3rd Quarter - Termination", "filing_year": 2019, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/67c940a4-80f2-4b5a-8d9a-0ebc8bfd3bbd/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Amanda Lee", "dt_posted": "2019-10-10T19:58:09.083000-04:00", "termination_date": "2019-09-30", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1750 K Street, NW", "registrant_address_2": "Suite 200", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 73271, "url": "https://lda.senate.gov/api/v1/registrants/73271/", "house_registrant_id": 35943, "name": "SIGNAL GROUP CONSULTING, LLC", "description": "Public affairs and government relations.", "address_1": "200 Massachusetts Ave NW", "address_2": "Floor 7", "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": "ERIKA BELLIDO-JIN", "contact_telephone": "+1 202-234-1224", "dt_updated": "2026-01-30T12:01:02.280070-05:00"}, "client": {"id": 167063, "url": "https://lda.senate.gov/api/v1/clients/167063/", "client_id": 1006830, "name": "NETJETS INC.", "general_description": "Private aviation company with fractional and charter operations.", "client_government_entity": false, "client_self_select": null, "state": "OH", "state_display": "Ohio", "country": "US", "country_display": "United States of America", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2018-12-08"}, "lobbying_activities": [{"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Issues associated with pilot retirement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46524, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "WILLIAM", "last_name": "CHAMBERLIN", "suffix": null, "suffix_display": null}, "covered_position": "Chief Counsel, US Senate Commerce Committee; Senior Counsel, US Senate Commerce Committee; Asst. Counsel, House Transportation and Infrastructure Committee (Asst. Counsel, House Transportation and Infrastructure Committee)", "new": false}, {"lobbyist": {"id": 45404, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "WHITEHORN", "suffix": null, "suffix_display": null}, "covered_position": "Deputy, SD/GC, US Senate Commerce Committee; Acting SD, US Senate Commerce Committee; Sr. Counsel, US Senate Commerce Committee", "new": false}, {"lobbyist": {"id": 65676, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "HRDLICKA", "suffix": null, "suffix_display": null}, "covered_position": "Associate Director, Office of the Asst. Secretary for Governmental Affairs, US Dept. of Transportation; Democratic Staff Asst., Senate Committee on Commerce, Science and Transportation; Staff Asst., Office of Senator Mark Dayton", "new": false}, {"lobbyist": {"id": 68680, "prefix": null, "prefix_display": null, "first_name": "MAX", "nickname": null, "middle_name": null, "last_name": "ROSEN", "suffix": null, "suffix_display": null}, "covered_position": "Research Assistant, Subcommittee on Aviation, Committee on Transportation and Infrastructure", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 77, "name": "Natl Transportation Safety Board (NTSB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Issues associated with pilot retirement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46524, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "WILLIAM", "last_name": "CHAMBERLIN", "suffix": null, "suffix_display": null}, "covered_position": "Chief Counsel, US Senate Commerce Committee; Senior Counsel, US Senate Commerce Committee; Asst. Counsel, House Transportation and Infrastructure Committee (Asst. Counsel, House Transportation and Infrastructure Committee)", "new": false}, {"lobbyist": {"id": 45404, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "WHITEHORN", "suffix": null, "suffix_display": null}, "covered_position": "Deputy, SD/GC, US Senate Commerce Committee; Acting SD, US Senate Commerce Committee; Sr. Counsel, US Senate Commerce Committee", "new": false}, {"lobbyist": {"id": 65676, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "HRDLICKA", "suffix": null, "suffix_display": null}, "covered_position": "Associate Director, Office of the Asst. Secretary for Governmental Affairs, US Dept. of Transportation; Democratic Staff Asst., Senate Committee on Commerce, Science and Transportation; Staff Asst., Office of Senator Mark Dayton", "new": false}, {"lobbyist": {"id": 68680, "prefix": null, "prefix_display": null, "first_name": "MAX", "nickname": null, "middle_name": null, "last_name": "ROSEN", "suffix": null, "suffix_display": null}, "covered_position": "Research Assistant, Subcommittee on Aviation, Committee on Transportation and Infrastructure", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 77, "name": "Natl Transportation Safety Board (NTSB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Issues associated with pilot retirement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46524, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "WILLIAM", "last_name": "CHAMBERLIN", "suffix": null, "suffix_display": null}, "covered_position": "Chief Counsel, US Senate Commerce Committee; Senior Counsel, US Senate Commerce Committee; Asst. Counsel, House Transportation and Infrastructure Committee (Asst. Counsel, House Transportation and Infrastructure Committee)", "new": false}, {"lobbyist": {"id": 45404, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "WHITEHORN", "suffix": null, "suffix_display": null}, "covered_position": "Deputy SD/GC, US Senate Commerce Committee; Acting SD, US Senate Commerce Committee; Sr. Counsel, US Senate Commerce Committee", "new": false}, {"lobbyist": {"id": 65676, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "HRDLICKA", "suffix": null, "suffix_display": null}, "covered_position": "Associate Director, Office of the Asst. Secretary for Governmental Affairs, US Dept. of Transportation; Democratic Staff Assistant, Senate Committee on Commerce, Science and Transportation; Staff Asst., Office of Senator Mark Dayton", "new": false}, {"lobbyist": {"id": 68680, "prefix": null, "prefix_display": null, "first_name": "MAX", "nickname": null, "middle_name": null, "last_name": "ROSEN", "suffix": null, "suffix_display": null}, "covered_position": "Research Assistant, Subcommittee on Aviation, Committee on Transportation and Infrastructure", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 77, "name": "Natl Transportation Safety Board (NTSB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Issues associated with pilot retirement. Implementation of the FAA Reauthorization Act of 2018 (P.L. 115-254).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46524, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "WILLIAM", "last_name": "CHAMBERLIN", "suffix": null, "suffix_display": null}, "covered_position": "Chief Counsel, US Senate Commerce Committee; Senior Counsel, US Senate Commerce Committee; Asst. Counsel, House Transportation and Infrastructure Committee (Asst. Counsel, House Transportation & Infrastructure Committee)", "new": false}, {"lobbyist": {"id": 45404, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "WHITEHORN", "suffix": null, "suffix_display": null}, "covered_position": "Deputy SD/GC, US Senate Commerce Committee; Acting SD, US Senate Commerce Committee; Sr. Counsel, US Senate Commerce Committee", "new": false}, {"lobbyist": {"id": 65676, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "HRDLICKA", "suffix": null, "suffix_display": null}, "covered_position": "Associate Director, Office of the Asst. Secretary for Governmental Affairs, US Dept. of Transportation; Democratic Staff Asst., Senate Committee on Commerce, Science and Transportation; Staff Asst., Senator Mark Dayton", "new": false}, {"lobbyist": {"id": 68680, "prefix": null, "prefix_display": null, "first_name": "MAX", "nickname": null, "middle_name": null, "last_name": "ROSEN", "suffix": null, "suffix_display": null}, "covered_position": "Research Assistant, Subcommittee on Aviation, Committee on Transportation and Infrastructure", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 77, "name": "Natl Transportation Safety Board (NTSB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Issues associated with pilot retirement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46524, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": "WILLIAM", "last_name": "CHAMBERLIN", "suffix": null, "suffix_display": null}, "covered_position": "Chief Counsel, US Senate Commerce Committee; Senior Counsel, US Senate Commerce Committee; Asst. Counsel, House Transportation and Infrastructure Committee (Asst. Counsel, House Transportation and Infrastructure Committee)", "new": false}, {"lobbyist": {"id": 45404, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": null, "last_name": "WHITEHORN", "suffix": null, "suffix_display": null}, "covered_position": "Deputy, SD/GC, US Senate Commerce Committee; Acting SD, US Senate Commerce Committee; Sr. Counsel, US Senate Commerce Committee", "new": false}, {"lobbyist": {"id": 65676, "prefix": null, "prefix_display": null, "first_name": "JULIE", "nickname": null, "middle_name": null, "last_name": "HRDLICKA", "suffix": null, "suffix_display": null}, "covered_position": "Associate Director, Office of the Asst. Secretary for Governmental Affairs, US Dept. of Transportation; Democratic Staff Asst., Senate Committee on Commerce, Science and Transportation; Staff Asst., Office of Senator Mark Dayton", "new": false}, {"lobbyist": {"id": 68680, "prefix": null, "prefix_display": null, "first_name": "MAX", "nickname": null, "middle_name": null, "last_name": "ROSEN", "suffix": null, "suffix_display": null}, "covered_position": "Research Assistant, Subcommittee on Aviation, Committee on Transportation and Infrastructure", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 77, "name": "Natl Transportation Safety Board (NTSB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	35943	OH	OH	US	US	Private aviation company with fractional and charter operations.	0	0	2288954		alias	0.85

Links from other tables

5 rows from filing_uuid in lobbying_activities
4 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs