home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a2a8a7b8-817a-4298-8a7f-178fe5a8a2aa

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
a2a8a7b8-817a-4298-8a7f-178fe5a8a2aa Q3 59012 EMC CORPORATION 160740 EMC CORPORATION 2014 third_quarter 2014-10-20T09:40:24.670000-04:00 790000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a2a8a7b8-817a-4298-8a7f-178fe5a8a2aa/", "filing_uuid": "a2a8a7b8-817a-4298-8a7f-178fe5a8a2aa", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2014, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a2a8a7b8-817a-4298-8a7f-178fe5a8a2aa/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "790000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "James L. Hayes, Senior Director, Government Affairs & Public Policy", "dt_posted": "2014-10-20T09:40:24.670000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 K Street NW, Suite 410", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 59012, "url": "https://lda.senate.gov/api/v1/registrants/59012/", "house_registrant_id": 35292, "name": "EMC CORPORATION", "description": null, "address_1": "1101 K Street NW, Suite 410", "address_2": null, "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": "JILL SHAPIRO", "contact_telephone": "+1 202-741-1517", "dt_updated": "2022-04-06T16:08:17.131442-04:00"}, "client": {"id": 160740, "url": "https://lda.senate.gov/api/v1/clients/160740/", "client_id": 12, "name": "EMC CORPORATION", "general_description": null, "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": "2007-08-10"}, "lobbying_activities": [{"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "H.R. 15/S. 744, the Border Security, Economic Opportunity, and Immigration Modernization Act, provisions related to immigration reform, high-skilled visa reform, and STEM educationH.R. 2131 - Supplying Knowledge Based Immigrants and Lifting Levels of STEM Visas (SKILLS) Act, provisions related to immigration reform, high-skilled visa reform, and STEM education", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "H.R. 1960, National Defense Authorization Act for Fiscal Year 2014, provisions related to cyber security and information technologyS. 1197, National Defense Authorization Act for Fiscal Year 2014, provisions related to cyber security and information technology \nS. 2410, Carl Levin National Defense Authorization Act for Fiscal Year 2015, provisions related to cyber security and information technology \nH.R. 4435, Howard P. Buck McKeon National Defense Authorization Act for Fiscal Year 2015, provisions related to cyber security and information technology \nS. 884, the Deter Cyber Theft Act, provisions related to cyber security and information technology", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55582, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "COLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "General issues relating to corporate tax reform.\nS. 2260, Expiring Provisions Improvement Reform and Efficiency (EXPIRE) Act of 2014; provisions related to tax extensions\nH.R. 4438, American Research and Competitiveness Act of 2014, provisions related to tax extensions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "H.R. 2024, End Anonymous Patents Act, provisions related to patent litigation reform \nS. 866, Patent Quality Improvement Act, provisions related to patent litigation reform\nS. 1013, Patent Abuse Reduction Act, provisions related to patent litigation reformH.R. 845, Saving High-Tech Innovators from Egregious Legal Disputes Act of 2013 (the SHIELD Act), provisions related to patent litigation reform\nS. 1612, Patent Litigation Integrity Act, provisions related to patent litigation reform\nS. 1720, Patent Transparency and Improvements Act, provisions related to patent litigation reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 4800 / S. 2389, Commerce, Justice, Science, and Related Agencies Appropriations Act, 2014, provisions related to cyber security/supply chain/information technology programsS. 2534 / H.R. 4903 Homeland Security Appropriations Act of 2015, provisions related to cyber security, supply chain, and information technology programs \nH.R. 4486 Military Construction and Veterans Affairs and Related Agencies Appropriations Act, 2015, provisions related to cyber security, supply chain, and information technology programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55582, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "COLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 540, Energy Efficient Government Technology Act, provisions related to energy efficiency\nS. 1392, Energy Savings and Industrial Competitiveness Act of 2013, provisions related to energy efficiency\nS. 2165, Access to Consumer Energy Information (E-Access) Act, provisions related to energy efficiency", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55582, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "COLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "H.R. 1232, The Federal Information Technology Acquisition Reform Act (FITARA), provisions related to information technology policiesS. 1611, Federal Data Center Consolidation Act of 2013, provisions related to information technology policies\nS. 2521, Federal Information Security Modernization Act of 2014, provisions related to information technology policies\nH.R. 3361/S. 1599, USA Freedom Act, provisions related to information technology policies\nH.R. 4291 FISA Transparency and Modernization Act, provisions related to information technology policies\nH.R. 1468 SECURE IT Act, provisions related to information technology policies", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55582, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "COLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "H.R. 1960, National Defense Authorization Act, provisions related to cyber security and information technology policies \nH.R. 624, the Cyber Intelligence Sharing and Protection Act (CISPA), provisions related to cyber security and information technology policies\nS. 1353, the Cyber Security Act of 2013, provisions related to cyber security and information technology policiesHR 3696, National Cybersecurity and Critical Infrastructure Protection Act of 2013, provisions related to cyber security and information technology policies\nH.R. 4800 / S. 2389 Commerce, Justice, Science, and Related Agencies Appropriations Act, 2015, provisions related to cyber security and information technology policies\nS. 2519, The National Cybersecurity and Communications Integration Center Act of 2014, provisions related to cyber security and information technology policies\nS. 2354, DHS Cybersecurity Workforce Recruitment and Retention Act of 2014, provisions related to cyber security and information technology policies\nS. 2588, Cybersecurity Information Sharing Act of 2014, provisions related to cyber security and information technology policies", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54884, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAMES", "nickname": null, "middle_name": "L", "last_name": "HAYES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55582, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "COLBERG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59770, "prefix": "ms", "prefix_display": "MS.", "first_name": "JILL", "nickname": null, "middle_name": "ANDREA", "last_name": "SHAPIRO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.998ms