home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1e3c28c8-1bb3-4e2a-b18f-d58d54f0a4d2

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
1e3c28c8-1bb3-4e2a-b18f-d58d54f0a4d2 Q2 19935 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 126454 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2012 second_quarter 2012-07-12T11:02:28.690000-04:00 771704.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1e3c28c8-1bb3-4e2a-b18f-d58d54f0a4d2/", "filing_uuid": "1e3c28c8-1bb3-4e2a-b18f-d58d54f0a4d2", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2012, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/1e3c28c8-1bb3-4e2a-b18f-d58d54f0a4d2/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "771704.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Lynn Palmer, Office Administrator", "dt_posted": "2012-07-12T11:02:28.690000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "555 12th STREET, NW", "registrant_address_2": "SUITE 660", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "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": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "H.R.3356, \"The Access Act,\" (ADA Compliance for Customer Entry to Stores and Services). All provisions.", "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": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "S.1452, H.R.2701, \"The Main Street Fairness Act,\" to promote simplification and fairness in the administration and collection of sales and use taxes. All provisions. \nProposal to amend Section 118 of the Internal Revenue Code regarding capital contributions by a non-shareholder to include \npartnerships. No bill introduced. H.R.2989, \"Real Estate Jobs & Investment Act of 2011,\" all provisions.\n\nTax reform specifically addressing concerns about pass through and depreciation.\n\nH.R.1265, to amend the IRC of 1986 to permanently extend the 15 year recovery period for qualified leasehold improvement property, qualified restaurant property, and qualified retail improvement property. All provisions.\n\nS.1832, \"The Marketplace Fairness Act,\" to improve the states' rights to enforce the collection of state sales and use tax laws and for other purposes. All provisions.\n\nH.R.3179, \"The Marketplace Equity Act,\" to restore states' sovereign rights to enforce state and local sales and use tax laws and for other purposes. All provisions. \n\nH.R.4016, Carried Interest Fairness Act of 2012.\" All provisions.\n\nH.R.5746, \"Update and Streamline REIT Act of 2012.\" All provisions.\n\nS.1616, \"Real Estate Investment and Jobs Act of 2012.\" All provisions.", "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}, {"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}, {"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}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R.931, to make participation in the American Community Survey voluntary.\nH.R.5326, S.2323, Commerce, Justice, Science and Related Agencies Appropriations Act of 2013, Title I, Bureau of the Census, periodic censuses and programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53577, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": null, "last_name": "KELLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"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}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "H.R.5911, \"Lead Exposure Reduction Amendment Act,\" U.S. EPA Lead: Renovation, Repair, and Painting Rule. All provisions.", "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": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BNK", "general_issue_code_display": "Bankruptcy", "description": "S.2370, \"The Small Business Reorganization Efficiency and Clarity Act.\" All provisions.", "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": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "EPA Energy Star and Portfolio Manager programs along with the Department of Energy CBECS survey project.\nS.1000, \"Energy Savings and Industrial Competitiveness Act of 2011.\"\nProposed Asset Rating System by Department of Energy.\nH.R.4017, \"Smart Energy Act in U.S. House,\" (companion bill to S.1000). \"Green Appraisals,\" draft legislative language to permit consideration of operating cost savings due to energy efficiency improvements during real estate appraisals. No bill.", "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": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Proposed EPA post-construction stormwater regulations 308, 402 and 404 of Clean Water Act. \nEPA TMDL for the Chesapeake Bay Watershed.\nDraft Guidance regarding identification of waters protected by the Clean Water 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": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 13.719ms