lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "2403f9af-befb-43f2-aa95-e4e37bf37c09" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1527572 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | TAR | H.R. 6727 - U.S. Job Creation and Manufacturing Competitiveness Act of 2013, provision related to the temporary duty suspension for preparations, such as tablets or chewing gum, intended to assist smokers to stop smoking (provided for in subheading 2106.90.99) | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527573 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | TRD | H.R. 3830 - Bipartisan Congressional Trade Priorities Act of 2014, provisions related to trade agreeemnts S. 1900 - Bipartisan Congressional Trade Priorities Act of 2014, provisions related to trade agreeemnts No bill # assigned - Trans-Pacific Strategic Economic Partnership Agreement (TPP)provisions related to intellectual property, market access and public health issuesNo bill # assigned - Transatlantic Trade and Investment Partnership (TTIP), provisions related to market access, intellectual property, regulatory harmonization and other issues No bill # assigned - India innovation, IP and market access issues No bill # assigned - International market access and intellectual property issues No bill # assigned - Canada IP and market access issues No bill # assigned - Turkey Market Access Issues | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527574 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | TAX | No bill # assigned - Tax reform policy issues, provisions related to corporate tax reform and research and development tax credit | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527575 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | CPT | H.R. 2582 - PATENT Jobs Act, provisions related to patent user fees H.R. 2605 - Manufacturing Innovation in America Act of 2013, provisions related to patent tax boxes H.R. 2639 - Patent Litigation and Innovation Act, patent litigation proposols H.R. 2766 - STOP Act, provisions related to business method patentsH.R. 3309 - Innovation Act, provisions related to patent litigation reform H.R. 3349 - Innovation Protection Act, provisions related to PTO fee diversion H.R. 3540 - Demand Letter Transparency Act H.R. 3709 - Protecting Consumer Access to Generic Drugs, provisions related to patent settlements H.R. 4287 - Independent Innovator and Repurposing Act, provisions related to patent term restoration S. 214 - The Preserve Access to Affordable Generics Act, provisions relating to patent settlements S. 504 - Fair and Immediate Release of Generic Drugs Act, provisions related to patent settlements S. 866 - Patent Quality Improvement Act of 2013, provisions related to business methods patents S. 1013 - Patent Abuse Reduction Act of 2013, provisions related to patent litigation reform S. 1612 - Patent Litigation Integrity Act, patent litigation provisions including bonding S. 1720 - Patent Transparency and Improvements Act S. 2049 - Transparency in Assertion of Patents Act, provisions related to patent demand letters S. 2150 - Independent Innovator and Repurposing Act, provisions related to patent term restoration S. 2196 - Patent Fee Integrity Act, patent fee diversion prohibition No bill # assigned - Biopharmaceutical innovation policy issues No bill # assigned - Biologics data protection issues No bill # assigned - Counterfeit drug issues | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527576 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | HCR | H.R. 1248 - Family Health Care Flexibility Act, provisions relating to reimbursement of OTC drugs under flexible spending and health savings accounts H.R. 3204 - Drug Quality and Security Act, provisions relating to pharmacy compounding and supply chain H.R. 3742 - Antibiotic Development to Advance Patient Treatment ActH.R. 4260 - Ryan White Patient Equity and Choice Act, provisions related to ADAP S. 610 - Family Health Care Flexibility Act, provisions relating to reimbursement of OTC drugs under flexible spending and health savings accounts S. 957 - Drug Supply Chain Security Act, provisions related to supply chain security S. 959 - Pharmaceutical Compounding Quality and Accountability Act, provisions related to pharmaceutical compounding S. 1165 - Access to Appropriate Immunizations for Veterans Act of 2013, provisions related to extending VA performance measure to include all federally recommended vaccine No bill # assigned - Implementation issues relating to the Patient Protection and Affordable Care Act (PPACA) (Public Law 111-148), including Standards Related to Essential Health Benefits, Actuarial Value, and Accreditation rulemaking No bill # assigned - FDA special medical use, issues related to limited population antibacterial drug approval pathway No bill # assigned - FDA accelerated approval policy issues No bill # assigned - Comparative effectiveness policy issues No bill # assigned - Biopharmaceutical innovation policy issues No bill # assigned - Pharmaceutical supply chain security issues No bill # assigned - 340B policy issues No bill # assigned - Implementation issues relating to the Physician Payment Sunshine Act | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527577 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | MMM | H.R. 351 - Protecting Seniors' Access to Medicare Act of 2013, provisions related to the Independent Payment Advisory Board H.R. 928 - Medicare Prescription Drug Savings and Choice Act of 2013, provisions related to Medicare Part D H.R. 1024 - Medication Therapy Empowerment Act of 2013, provisions related to Part D issuesH.R. 1102 - Medicare Prescription Drug Price Negotiation Act of 2013, Provisions related to Part D issues and non-interference H.R. 1588 - Medicare Drug Savings Act of 2013, provisions related to Part D issues H.R. 2810 - Medicare Patient Access and Quality Improvement Act of 2013, provisions related to SGR reform H.R. 2827 - To amend title XVIII of the Social Security Act to allow for fair application of the exceptions process for drugs in tiers in formularies in prescription drug plans under Medicare part D, provisions related to Medicare Part D Drug Tier Formularies H.R. 3890 - Better Care, Lower Cost Act, provisions related to Part D, value-based insurance design, and chronic disease H.R 4160 - Keep the Promise to Seniors Act of 2014, provisions related to Part D H.R. 4187 - Developing an Innovative Strategy for Antimicrobial Resistant Microorganisms (DISARM) Act H.R. 4302 - Protecting Access to Medicare Act of 2014, provisions related to the biopharmaceutical industry S. 117 - Medicare Prescription Drug Price Negotiation Act of 2013, provisions related to Part D issues S. 351 - Protecting Seniors' Access to Medicare Act of 2013, provisions related to the Independent Payment Advisory Board S. 408 - Medicare Prescription Drug Savings and Choice Act of 2013, provisions related to Medicare Part D S. 557 - Medication Therapy Empowerment Act of 2013, provisions related to Part D issues S. 740 - Medicare Drug Savings Act of 2013, provisions related to Part D issues S. 1871 - SGR Repeal and Medicare Beneficiary Access Act of 2013, provisions related to reforming Medicare physician payments S. 1932 - Better Care, Lower Cost Act, provisions related to Part D, value-based insurance design, and chronic … | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-04:00 | |
| 1527578 | GSK (FKA GLAXOSMITHKLINE INC.) 2403f9af-befb-43f2-aa95-e4e37bf37c09 | Q1 | GSK (FKA GLAXOSMITHKLINE INC.) | 16293 | GSK (FKA GLAXOSMITHKLINE INC.) | 2014 | first_quarter | BUD | H.R. 3547 - Consolidated Appropriations Act of 2014, Provisions related to Medicare Part D, FDA regulation and funding, sequestration, drug importation, Customs and Board Control Agency funding, 340B, IPAB, ADAP, BARDA, Section 317 and Issues related to user fee reauthorization and FDA reformNo bill # assigned - Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act of 2015, provisions relating to FDA regulation and funding, sequestration, drug importation No bill # assigned - Labor, Health and Human Services, Education and Related Agencies Appropriations Act of 2014, provisions related to ADAP, BARDA and Section 317 | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 1630000 | 0 | 0 | 2014-04-18T14:11:03.963000-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);