lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "eafccaf1-059b-4146-9a69-63c65baf714f" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3014688 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | CPI | Executive Order 14028 - Improving the Nation's Cybersecurity, zero trust architecture provisions; FY 2024 Appropriations Bills, IT and Cloud provisions; Issues related to virtualization, mobility and digital workspaces; Issues related to cybersecurity and cloud services; Issues related to blockchain; Issues related to Federal IT modernization; 5G issues; Issues related to commercial privacy and healthcare security; Issues related to the implementation of federal Cybersecurity Strategy. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014689 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | DEF | National Defense Authorization Act for Fiscal Year 2024, technology, cybersecurity, software factories, 5G/Open RAN, multi-cloud, software factory and software-defined data center provisions; Monitor issues related to RFI for cloud services procurement; Issues related to network security; Issues related to Zero Trust and Remote Work. | HOUSE OF REPRESENTATIVES,SENATE | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014690 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | INT | S. 2103/H.R. 3932 - National Intelligence Authorization Act for FY 2024, 5G/Open RAN, digital transformation, multi-cloud, and app modernization issues. | HOUSE OF REPRESENTATIVES,SENATE | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014691 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | SCI | 5G telecommunications legislation; Issues related to consumer privacy, mobility, interoperability, cybersecurity and cloud services; Issues related to Federal IT modernization; Issues related to commercial privacy. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),White House Office | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014692 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | BUD | FY 2024 Commerce, Justice, and Science Appropriations; FY 2024 Military Construction and Veterans Affairs Appropriations; FY 2024 Defense Appropriations; FY 2024 Homeland Security Appropriations; FY 2024 Financial Services Appropriations; FY 2024 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Bill; FY 2024 State, Foreign Operations, and Related Programs Appropriations Bill; FY 2024 Interior, Environment, and Related Agencies Appropriations Bill. | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014693 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | COM | Infrastructure Investment and Jobs Act (PL 117-58), Division F, Broadband provisions; Issues related to the establishment of new NSF directorate with federal R&D funding for advanced technologies, such as telecommunications, quantum computing, and data; Issues related to FCC NOI on Open RAN. | Commerce, Dept of (DOC),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 | |
| 3014694 | VMWARE, INC. eafccaf1-059b-4146-9a69-63c65baf714f | Q2 | VMWARE, INC. | 401103603 | VMWARE, INC. | 2023 | second_quarter | TAX | Inflation Reduction Act (PL 117-169), Title XIII, Subtitle H, corporate and international tax provisions; S. 2254 - Tax Cuts and Jobs Act of 2017 (115th Congress), Section 174, research and development capitalization provision; Treasury Department January 2022 Foreign Tax Credit Rule. | HOUSE OF REPRESENTATIVES,SENATE | 310000 | 0 | 0 | 2023-07-19T11:39:46-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);