lobbying_filings_raw: 7444dbbe-6624-4b99-8369-b76c11eb7226

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
7444dbbe-6624-4b99-8369-b76c11eb7226 Q2 12208 DICKSTEIN SHAPIRO LLP 117011 AMERICAN GAS ASSOCIATION 2014 second_quarter 2014-07-10T21:30:02.887000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7444dbbe-6624-4b99-8369-b76c11eb7226/", "filing_uuid": "7444dbbe-6624-4b99-8369-b76c11eb7226", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2014, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7444dbbe-6624-4b99-8369-b76c11eb7226/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "L. Andrew Zausner, Partner", "dt_posted": "2014-07-10T21:30:02.887000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1825 Eye St., NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 12208, "url": "https://lda.senate.gov/api/v1/registrants/12208/", "house_registrant_id": 31737, "name": "DICKSTEIN SHAPIRO LLP", "description": "Law firm", "address_1": "1825 Eye Street NW", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SCOTT THOMAS", "contact_telephone": "+1 202-420-2200", "dt_updated": "2022-04-06T16:07:57.938885-04:00"}, "client": {"id": 117011, "url": "https://lda.senate.gov/api/v1/clients/117011/", "client_id": 1005065, "name": "AMERICAN GAS ASSOCIATION", "general_description": "Energy utility association", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "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": "2013-10-01"}, "lobbying_activities": [{"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Monitor federal activity and legislation related to cyber security and anti-terrorism liability protection.\nMonitor federal activity and legislation related to Internet safety.\nMonitor passage of FY 2014 omnibus appropriations bill (P.L. 113-76).H.R. 2146, Terrorism Risk Insurance Program Reauthorization Act of 2013.\nDraft, House Department of Homeland Security Appropriations Act, 2015.\nDraft, Senate Department of Homeland Security Appropriations Act, 2015. \nH.R. 3696, National Cybersecurity and Critical Infrastructure Protection Act of 2013.\nDraft, Senate cyber tax incentive bill.\nExecutive Order 13636, Improving Critical Infrastructure Cybersecurity.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 36109, "prefix": null, "prefix_display": null, "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "FINCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Congressman (1993-1997)", "new": true}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": "Min. Approps. Clerk, Sen. Mikulski (1994-1996)", "new": true}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Congressman (1992-2008)", "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31737 DC   US US Energy utility association 0 0         10000.0  

Links from other tables