lobbying_filings_raw: 03a3f46d-e1ff-43e5-a94f-2dee2ad3e4e8

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
03a3f46d-e1ff-43e5-a94f-2dee2ad3e4e8 Q2 310938 CJ LAKE, LLC 183719 CITY OF THORNTON 2017 second_quarter 2017-07-19T14:08:44.043000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/03a3f46d-e1ff-43e5-a94f-2dee2ad3e4e8/", "filing_uuid": "03a3f46d-e1ff-43e5-a94f-2dee2ad3e4e8", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/03a3f46d-e1ff-43e5-a94f-2dee2ad3e4e8/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "LYNNETTE R. JACQUEZ", "dt_posted": "2017-07-19T14:08:44.043000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "525 9th Street, NW", "registrant_address_2": "Suite 800", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 310938, "url": "https://lda.senate.gov/api/v1/registrants/310938/", "house_registrant_id": 38616, "name": "CJ LAKE, LLC", "description": "Lobbying Firm", "address_1": "733 10th Street, NW", "address_2": "Suite 900", "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": "LYNNETTE R. JACQUEZ", "contact_telephone": "+1 202-465-3000", "dt_updated": "2026-02-25T18:45:15.972811-05:00"}, "client": {"id": 183719, "url": "https://lda.senate.gov/api/v1/clients/183719/", "client_id": 1005077, "name": "CITY OF THORNTON", "general_description": "Municipal government", "client_government_entity": true, "client_self_select": false, "state": "CO", "state_display": "Colorado", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2010-02-01"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "FY17 (HR 244) FY18 transportation funding \nFAST Act Implementation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44421, "prefix": "ms", "prefix_display": "MS.", "first_name": "LYNNETTE", "nickname": null, "middle_name": "R", "last_name": "JACQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27099, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BACQUE DA SILVA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58055, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "LUND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61274, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "BYRNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY17 (HR 244) FY18 funding, Transportation funding \nFY17 (HR 244) FY18 funding, Clean Water funding \nOppose cuts in the President's FY18 budget related to the Departments of Transportation and Housing and Urban Development.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44421, "prefix": "ms", "prefix_display": "MS.", "first_name": "LYNNETTE", "nickname": null, "middle_name": "R", "last_name": "JACQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27099, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BACQUE DA SILVA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58055, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "LUND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61274, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "BYRNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Eminent domain legislation, livability grant programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44421, "prefix": "ms", "prefix_display": "MS.", "first_name": "LYNNETTE", "nickname": null, "middle_name": "R", "last_name": "JACQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27099, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BACQUE DA SILVA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58055, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "LUND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61274, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "BYRNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "FY18 Livable Communities interagency program\nFY18 HUD community challenge grants", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44421, "prefix": "ms", "prefix_display": "MS.", "first_name": "LYNNETTE", "nickname": null, "middle_name": "R", "last_name": "JACQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27099, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BACQUE DA SILVA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58055, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "LUND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61274, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "BYRNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Regulations involving urban watershed, water quality and waste water management.\nMonitor the Waters of the United States Regulation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44421, "prefix": "ms", "prefix_display": "MS.", "first_name": "LYNNETTE", "nickname": null, "middle_name": "R", "last_name": "JACQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 27099, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BACQUE DA SILVA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58055, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "CHRISTOPHER", "last_name": "LUND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61274, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "BYRNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables