lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "2adb59f3-e69d-43ed-a9c3-a8cbccccc233" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2508485 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | TAX | Issues related to the Tax Cuts ands Jobs Act; Section 1061 regulations; capital gains tax policy; Carried Interest Fairness Act, H.R. 1735/S. 781; Ending the Carried Interest Loophole Act, S. 1639; carried interest capital gains; partnership tax policy; tax policy that encourages new company formation including: R&D credit, Section 1202, Section 382, stock options, medical device tax, tax extenders, opportunity zones, energy innovation tax issues, including the Energy Sector Innovation Credit Act HR 7196; Research & Development Tax Credit Expansion Act, S. 2207; CEO and Worker Pension Fairness Act; Families First Coronavirus Response Act; Issues related to the Coronavirus Aid, Relief, and Economic Security Act; Issues related to the Phase IV economic relief package including monetization of tax assets for growth companies and the employee retention tax credit; IGNITE American Innovation Act HR 7917; HEROES Act HR 6800; Tax bills to encourage American innovation and medical independence, HRs 7766, 7505, 7556 | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508486 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | TEC | Cybersecurity; data privacy issues; Net Neutrality; fintech; Emerging and foundational technologies rulemaking; antitrust and competition policy impacting startups | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508487 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | CPT | Various patent litigation reform issues that impact investment in the startup ecosystem; STRONGER Patents Act | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508488 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | HCR | Drug pricing issues; proposals to create limited pathways for certain drugs; CMS reimbursement policy; Elijah E. Cummings Lower Drug Costs Now Act HR 3; Prescription Drug Pricing Reduction Act of 2019 S 2543 | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508489 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | SMB | Small business issues; SBA 8(a) & 8(m) programs; SBIR/STTR programs, including proposals relating to venture capital ownership threshold for program eligibility; Small Business Innovation Voucher Act; Enhancing Entrepreneurship for the 21st Century Act, S. 2535; Issues related to the Coronavirus Aid, Relief, and Economic Security Act; Paycheck Protection Program (PPP) | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508490 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | ENG | Cleantech energy policy issues, including energy innovation tax issues; ARPA-E; Energy and Water Appropriations; Energy Sector Innovation Credit Act HR 7196 | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508491 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | IMM | Startup Act; Invest Visa; Entrepreneurial Visa; Executive Order on Immigration; Comprehensive Immigration Reform; International Entrepreneur Rule | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508492 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | SCI | Basic research funding and technology commercialization issues; H.R. 539/S. 118 Innovators to Entrepreneurs Act of 2019; Endless Frontier Act S. 3832/ H.R. 6978 | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-04:00 | |
| 2508493 | NATIONAL VENTURE CAPITAL ASSOCIATION 2adb59f3-e69d-43ed-a9c3-a8cbccccc233 | Q3 | NATIONAL VENTURE CAPITAL ASSOCIATION | 21687 | NATIONAL VENTURE CAPITAL ASSOCIATION | 2020 | third_quarter | BAN | Small company capital formation issues; capital markets reform to encourage more IPOs, including disclosure of material short positions, venture exchanges, issues related to shareholder proposals, improving research coverage for small companies; Dodd-Frank regulatory issues including: revising the definition of venture capital fund for purposes of fund registration, Volcker Rule; blockchain regulatory and policy issues, including the Token Taxonomy Act H.R. 2144; Implementation of the Foreign Investment Risk Review Modernization Act (FIRRMA); Developing and Empowering our Aspiring Leaders (DEAL) Act; Fostering Innovation Act S. 452, H.R. 3886; Amendment to Accelerated Filer and Large Accelerated Filer definition; Beneficial ownership legislation including Corporate Transparency Act, H.R. 2513/S. 1978 and Illicit Cash Act, S. 2563; Private Securities Transparency and Reform Act; Managed Stablecoins are Securities Act H.R. 5197; Helping Startups Continue to Grow Act HR 4918; SEC proposal to modernize advertising and cash solicitation rules; Issues related to Coronavirus Aid, Relief, and Economic Security Act; Main Street Loan Program. | Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Communications Commission (FCC),Federal Reserve System,Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Science & Technology Policy (OSTP),Office of the Comptroller of the Currency (OCC),Patent & Trademark Office (PTO),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),Treasury, Dept of,White House Office | 588387 | 0 | 0 | 2020-10-15T09:07:57.210000-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);