home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cf238c94-9a24-4cb8-8ea7-e00a3025f991

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
cf238c94-9a24-4cb8-8ea7-e00a3025f991 Q2 401104641 LOT SIXTEEN LLC 202175 AMERICAN WIND ENERGY ASSOCIATION 2019 second_quarter 2019-07-22T10:16:51.137000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cf238c94-9a24-4cb8-8ea7-e00a3025f991/", "filing_uuid": "cf238c94-9a24-4cb8-8ea7-e00a3025f991", "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/cf238c94-9a24-4cb8-8ea7-e00a3025f991/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Colin T. Hayes", "dt_posted": "2019-07-22T10:16:51.137000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "923 15th Street, NW", "registrant_address_2": "Second Floor", "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 401104641, "url": "https://lda.senate.gov/api/v1/registrants/401104641/", "house_registrant_id": null, "name": "LOT SIXTEEN LLC", "description": "Government relations and communications consulting and support.", "address_1": "1500 K Street, NW", "address_2": "Suite 825", "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": "OLIVIA HAZZARD", "contact_telephone": "+1 703-577-7175", "dt_updated": "2026-01-27T11:46:36.445681-05:00"}, "client": {"id": 202175, "url": "https://lda.senate.gov/api/v1/clients/202175/", "client_id": 51, "name": "AMERICAN WIND ENERGY ASSOCIATION", "general_description": "National trade association that represents the interests of Americas wind energy industry", "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": "2018-01-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY20 Energy and Water Appropriations bills (H.R. 2960 & Senate version)\nFY20 Interior Appropriations bills (H.R. 3052 & Senate version)\nFY20 Defense Appropriations bills (H.R. 2968 & Senate version)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Committee on Energy & Natural Resources", "new": false}, {"lobbyist": {"id": 70241, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EAVES", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Rep. Paul Tonko", "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Potential changes to the Jones Act being considered in the Coast Guard Reauthorization Act (H.R. 3409)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Committee on Energy & Natural Resources", "new": false}, {"lobbyist": {"id": 70241, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EAVES", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Rep. Paul Tonko", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Legislation to provide for an investment tax credit for offshore wind (S. 1957; H.R. 3473; Carper-Collins bill (no number assigned yet)\nLegislation to provide for transferability of the renewable energy production tax credit (PTC) (H.R. 2704)\nLegislation to establish a storage investment tax credit, the Energy Storage Tax Incentive and Deployment Act (H.R. 2096; S. 1142); the Clean Energy for America Act, (S.1288)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70241, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EAVES", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Rep. Paul Tonko", "new": true}, {"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Committee on Energy & Natural Resources", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Legislation to provide FERC with backstop authority for transmission siting and to have Congress direct FERC to improve interregional transmission planning (H.R. 2741)\nWind workforce training legislation, not yet introduced, that would support wind tech students, wind technicians and veterans entering the wind energy workforce.\nOffshore Wind Jobs & Opportunities Act, (H.R. 3068); Offshore Renewable Energy for Territories Act (S.499 & H.R. 1014)\nInfrastructure and Electricity Markets\nGeneral wind energy issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Energy & Natural Resources Committee", "new": false}, {"lobbyist": {"id": 70241, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EAVES", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Rep. Paul Tonko", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "General permit for incidental take under the Bald and Golden Eagle Protection Action Act (BGEPA)\nESA and low-effect Habitat Conservation Plans", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Committee on Energy & Natural Resources", "new": false}, {"lobbyist": {"id": 70241, "prefix": null, "prefix_display": null, "first_name": "JOSEPH", "nickname": null, "middle_name": null, "last_name": "EAVES", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director, Rep. Paul Tonko", "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "BOEM leasing process; offshore wind permitting issues & fisheries", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68994, "prefix": null, "prefix_display": null, "first_name": "COLIN", "nickname": null, "middle_name": "T", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": "Staff Director, U.S. Senate Committee on Energy & Natural Resources", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.215ms