lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where filing_uuid = "2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1913567 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | GOV | Any and all issues related to barcode, secure identification and real-time location systems. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913568 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | HOM | Any and all issues related to barcode, secure identification and real-time location systems. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913569 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | CPI | Issues related to Internet of Things (IoT); Issues surrounding Congressional testimony on wearable (IoT-based) technologies and Congressional panel presentation on healthcare IoT technologies provided by Zebra Technologies Corporation and other companies. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913570 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | IMM | H.R. 1147, the "Legal Workforce Act", provisions regarding e-verify authentication pilot programs. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913571 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | DEF | Any and all issues related to barcode, secure identification and real-time location systems, including the DoD Maintenance, Repair and Overhaul Depot Network. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913572 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | CPT | H.R. 9, "The Innovation Act" (regarding patent reform and frivolous lawsuits) | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913573 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | VET | Issues related to establishing secure VA choice card with chip and pin technology. Working on resolving issues related to enabling VA health care workers to utilize state-of-the-art mobile technology to enhance and maximize health care delivery service quality for veterans. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05:00 |
| 1913574 | HEARTLAND SOLUTIONS GROUP, INC. 2f911d9f-3ff7-4d6e-acd3-1feffafc5ce7 | Q4 | HEARTLAND SOLUTIONS GROUP, INC. | 312133 | ZEBRA TECHNOLOGIES CORPORATION | 2016 | fourth_quarter | MMM | H.R. 3220, "Medicare Common Access Card Act of 2015," all sections S. 1871, "Medicare Common Access Card Act of 2015," all sections H.R. 3547, FY'14 Omnibus, Labor-HHS-Education title, HHS/CMS section, language regarding Medicare fraud prevention GAO study (explanatory statement) H.R. 2, Medicare Access and CHIP Reauthorization Act of 2015, Section 503 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2017-01-15T18:28:55-05: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,
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);