lobbying_filings_raw: 09cef763-91ca-453e-9c37-2535c42d47df

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
09cef763-91ca-453e-9c37-2535c42d47df Q4 61072 LAWRENCE J. ROMANS & ASSOCIATES, LLC 161447 AMERICAN COUNCIL OF LIFE INSURERS 2009 fourth_quarter 2010-01-15T16:59:25.557000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/09cef763-91ca-453e-9c37-2535c42d47df/", "filing_uuid": "09cef763-91ca-453e-9c37-2535c42d47df", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2009, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/09cef763-91ca-453e-9c37-2535c42d47df/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Lawrence J. Romans, Sole Proprietor", "dt_posted": "2010-01-15T16:59:25.557000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "499 SOUTH CAPITOL STREET, SW, #410", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 61072, "url": "https://lda.senate.gov/api/v1/registrants/61072/", "house_registrant_id": 35384, "name": "LAWRENCE J. ROMANS & ASSOCIATES, LLC", "description": "Self employed public affairs consultant", "address_1": "499 SOUTH CAPITOL STREET, SW, #410", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LARRY ROMANS", "contact_telephone": "+1 202-488-1301", "dt_updated": "2022-04-06T16:07:10.523146-04:00"}, "client": {"id": 161447, "url": "https://lda.senate.gov/api/v1/clients/161447/", "client_id": 164, "name": "AMERICAN COUNCIL OF LIFE INSURERS", "general_description": "Financial Services trade 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": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-09-01"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "H.R. 3126, The Consumer Financial Protection Agency Act of 2009, H.R. 1880, The National Insurance Consumer Protection\nAct, H.R. 2609, The Insurance Informationa Act of 2009, H.R. 4173, The Wall Street Reform and Consumer\nProtection Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 3719, "prefix": "mr", "prefix_display": "MR.", "first_name": "LAWRENCE", "nickname": null, "middle_name": "J", "last_name": "ROMANS", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Bruce Vento", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "H.R. 3126, The Consumer Financial Protection Agency Act of 2009, H.R. 1880, The National Insurance Consumer Protection\nAct, H.R. 2609, The Insurance Informationa Act of 2009, H.R. 4173, The Wall Street Reform and Consumer\nProtection Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 3719, "prefix": "mr", "prefix_display": "MR.", "first_name": "LAWRENCE", "nickname": null, "middle_name": "J", "last_name": "ROMANS", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Bruce Vento", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "H.R. 3126, The Consumer Financial Protection Agency Act of 2009, H.R. 1880, The National Insurance Consumer Protection\nAct, H.R. 2609, The Insurance Informationa Act of 2009, H.R. 4173, The Wall Street Reform and Consumer\nProtection Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 3719, "prefix": "mr", "prefix_display": "MR.", "first_name": "LAWRENCE", "nickname": null, "middle_name": "J", "last_name": "ROMANS", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Bruce F. Vento, MC", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 35384 DC DC US US Financial Services trade association 0 0         30000.0  

Links from other tables