lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "8a48e417-7502-4b8c-b59f-e982d3c7e047" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2684134 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | CPI | Issues related to data protection and privacy. H.R. 1319 - American Rescue Plan Act of 2021; P.L. 117-2 - IT Reform/tech modernization. Issues related to Global Supply Chain. S. 1260 - United States Innovations & Competition Act of 2021. Issues related to government procurement. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-04:00 | |
| 2684135 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | TRD | Issues related to international trade. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-04:00 | |
| 2684136 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | TAX | Issues related to the Implementation of PL 115-97 - Tax Cuts and Jobs Act Corporate & International Tax Policy. The Build Back Better Act, A bill to provide for reconciliation pursuant to title II of the Concurrent Resolution on the Budget for Fiscal Year 2022, S. Con. Res. 14. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-04:00 | |
| 2684137 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | FOR | Issues related to foreign aid to provide technology solutions restoring efficiencies. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-04:00 | |
| 2684138 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | LBR | Issues related to diversity and inclusion. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-04:00 | |
| 2684139 | MEHLMAN CONSULTING, INC. 8a48e417-7502-4b8c-b59f-e982d3c7e047 | Q3 | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2021 | third_quarter | ENV | Monitor legislation and administration activities related to sustainability and circular economy. | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2021-10-18T10:31:49.200000-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);