lobbying_filings_raw: 0598b293-3c44-40ef-8e08-2a51015fb235

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
0598b293-3c44-40ef-8e08-2a51015fb235	Q4	19935	INTERNATIONAL COUNCIL OF SHOPPING CENTERS	126454	INTERNATIONAL COUNCIL OF SHOPPING CENTERS	2009	fourth_quarter	2009-10-20T16:42:45-04:00	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/0598b293-3c44-40ef-8e08-2a51015fb235/", "filing_uuid": "0598b293-3c44-40ef-8e08-2a51015fb235", "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/0598b293-3c44-40ef-8e08-2a51015fb235/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "237000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Lynn Palmer, Office Administrator", "dt_posted": "2009-10-20T16:42:45-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1399 NEW YORK AVENUE, NW, #720", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 19935, "url": "https://lda.senate.gov/api/v1/registrants/19935/", "house_registrant_id": 30931, "name": "INTERNATIONAL COUNCIL OF SHOPPING CENTERS", "description": "marketplaces association (retail real estate)", "address_1": "975 F Street NW", "address_2": "Suite 560", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM MOUTRAY MCLAREN", "contact_telephone": "+1 864-363-8303", "dt_updated": "2026-01-27T15:19:45.236781-05:00"}, "client": {"id": 126454, "url": "https://lda.senate.gov/api/v1/clients/126454/", "client_id": 12, "name": "INTERNATIONAL COUNCIL OF SHOPPING CENTERS", "general_description": "Marketplaces Industry (retail real estate)", "client_government_entity": false, "client_self_select": true, "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": "2022-01-14"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R.1409, S.560, \"The Employee Free Choice Act of 2009.\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20020, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "PLATT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28959, "prefix": null, "prefix_display": null, "first_name": "BETSY", "nickname": null, "middle_name": null, "last_name": "LAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "To Be Introduced, \"The Mainstreet Fairness Act,\" to promote simplification and fairness in the administration and collection of sales and use taxes. All provisions. H.R.1724, America's Brownfield Cleanup Act of 2009, amends the Internal Revenue Code of 1986 to provide tax incentives for the remediation of contaminated sites.\n\nTo Be Introduced, amends the Internal Revenue Code of 1986 to make the expensing of environmental remediation costs permanent law and to repeat the recapture of such expenses under Section 1254 of such code.\n\nH.R.1935, amends the Internal Revenue Code of 1986 provides for the treatment of partnership interests held by partners providing services.\n\nH.R.561, S.293, S.823, a bill to allow five year carry-back of operating losses and for other purposes.\n\nRegulatory change in the rules for Real Estate Mortgage and Investment Conduits for Commercial Real Estate.\n\nTo be introduced, amends Section 118 of the Internal Revenue Code regarding capital contributions by a non-shareholder to include partnerships.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20020, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "PLATT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10604, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": null, "last_name": "JEFFREYS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28959, "prefix": null, "prefix_display": null, "first_name": "BETSY", "nickname": null, "middle_name": null, "last_name": "LAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Clean Water Act permits (Section 404 permits) for dredged or fill material = Title 33 U.S. Code Section 1344 of the Public law 92-500.\nS.787, \"The Clean Water Restoration Act of 2009.\" House version not introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10604, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": null, "last_name": "JEFFREYS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Term Asset Backed Loan Facility expanded to include CMBS to be extended through 2010.\nExtension of bank-held whole loans and use of debt service coverage for appraisals.\nAccounting Rules: FAS140/FIN46R; FAS13/IAS17; FAS157", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20020, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "PLATT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28959, "prefix": null, "prefix_display": null, "first_name": "BETSY", "nickname": null, "middle_name": null, "last_name": "LAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R.2892, S.1298, FY2010 Department of Homeland Security appropriations bill, Title III, Protection, Preparedness, Response and Recovery proposal to fund security awareness training program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 28959, "prefix": null, "prefix_display": null, "first_name": "BETSY", "nickname": null, "middle_name": null, "last_name": "LAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Legislative initiative on \"net metering\" of renewable generated electricity, no specific bill introduced.\nH.R.2454, American Clean Energy and Security Act of 2009, Title II, provisions on building code standards and energy efficiency. \nS.1733, Clean Energy Jobs and American Power Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10604, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": null, "last_name": "JEFFREYS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 183, "name": "Office of the Comptroller of the Currency (OCC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	30931	DC	DC	US	US	Marketplaces Industry (retail real estate)	0	0						237000.0

Links from other tables

6 rows from filing_uuid in lobbying_activities
3 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs