lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where filing_uuid = "96d78ddb-e639-43a7-a52d-94d14a752a77" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1804866 | GEMALTO, INC 96d78ddb-e639-43a7-a52d-94d14a752a77 | Q1 | GEMALTO, INC | 400275273 | GEMALTO INC | 2016 | first_quarter | MMM | Health IT, e-Authentication, privacy protection, Medicare fraud prevention S. 2586 Medicare CAC. H.R. 2, the Medicare Access and CHIPS Reauthorization Act 2015 - specifically Section 503, Consideration of Measures Regarding Medicare Beneficiary Smart Cards | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 0 | 0 | 2016-04-11T15:37:21.240000-04:00 |
| 1804867 | GEMALTO, INC 96d78ddb-e639-43a7-a52d-94d14a752a77 | Q1 | GEMALTO, INC | 400275273 | GEMALTO INC | 2016 | first_quarter | VET | Securing any VA card (Senate's VA Choice card) and solution for Vets to obtain medical services outside VA network. Upgrade of VA patient cards to include electronic authentication. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 0 | 0 | 2016-04-11T15:37:21.240000-04:00 |
| 1804868 | GEMALTO, INC 96d78ddb-e639-43a7-a52d-94d14a752a77 | Q1 | GEMALTO, INC | 400275273 | GEMALTO INC | 2016 | first_quarter | IMM | Upgrade & modernization of Social Security Card for use with e-Verify for employment verification : Senate Immigration Reform and House Immigration reform bill discussions. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 0 | 0 | 2016-04-11T15:37:21.240000-04:00 |
| 1804869 | GEMALTO, INC 96d78ddb-e639-43a7-a52d-94d14a752a77 | Q1 | GEMALTO, INC | 400275273 | GEMALTO INC | 2016 | first_quarter | CPI | ID Management; e-authentication; Health IT; Cybersecurity; Homeland Security Presidential Directive -12; Immigration Reform; e-Verify; EMV (Europay, MasterCard, Visa) Credit Card Standards, National Strategy for Trusted Identities in Cyberspace (NSTIC) | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 0 | 0 | 2016-04-11T15:37:21.240000-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,
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);