lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
15 rows where filing_uuid = "cf010893-c78c-494d-9bb7-ece3330fe8eb" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2510678 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | DEF | Dental Licensure Examinations during COVID Pandemic | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510679 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | VET | Veterans Affairs Innovation Center Dental Pilot Program | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510680 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | TRD | Tariffs on medical products and supplies to respond to the COVID-19 Pandemic | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510681 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | AGR | Reauthorization of the Healthy, Hunger-Free Kids Act of 2010 (HHFKA) (National School Lunch Program, WIC program, Team Nutrition) | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510682 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | TAX | Health savings accounts, flexible spending accounts, expand and make permanent the 199A/pass through deduction for small businesses. H.R. 1366, Responsible Additions and Increases to Sustain Employee Health Benefits Act of 2019 (RAISE ACT) (health savings accounts, flexible spending accounts) S. 503, Responsible Additions and Increases to Sustain Employee Health Benefits Act of 2019 (RAISE ACT) (health savings accounts, flexible spending accounts) H.R. 6886/H.R. 7001 Paycheck Protection Program Flexibility Act Implementation S. 3833 Paycheck Protection Program Extension Act H.R. 7216 Small Business Personal Protective Equipment (PPE) Tax Credit Act S. 3716 Main Street Enhancement and Safety Act H.R. 6821 Small Business Expense Protection Act H.R. 6776 JOBS Credit Act of 2020 H.R. 266 Paycheck Protection Program and Health Care Enhancement Act H.R. 6433, Helping Emergency Responders Overcome Emergency Situations (HEROES) Act S. 2871/H.R. 6448 Indian Health Service Health Professions Tax Fairness Act H.R. 7777 Paycheck Protection Small Business Forgiveness Act S. 4117 Paycheck Protection Small Business Forgiveness Act H.R. 6697 Local Chamber, Tourism, and 501(c)(6) Protection Act S. 4525/H.R. 7819 Eliminating the Provider Relief Fund Tax Penalties Act of 2020 Direct Primary Care Agreements | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510683 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | HCR | Authority for dental-related programs to operate, caries prevention and oral health promotion, access to dental care, dental research, oral and craniofacial defects, filling Chief Dental Officer positions at CMS, prescribing practices (e.g., opioid prescribing), etc. H.R. 3630, No Surprises Act S. 1895, Lower Health Care Costs Act H.R. 269, to clarify the regulatory framework with respect to certain nonprescription drugs that are marketed without an approved drug application H.R. 1379, Ensuring Lasting Smiles Act (ELSA Act) H.R. 1614, John S. McCain Opioid Addiction Prevention Act S. 192, Community and Public Health Programs Extension Act S. 560, Ensuring Lasting Smiles Act (ELSA Act) S. 724, John S. McCain Opioid Addiction Prevention Act H.R. 3762, Dental and Optometric Care Access Act of 2019 (DOC Access Act) H.R. 5826, the Consumer Protections Against Surprise Medical Bills Act of 2020 H.R. 5800, the Ban Surprise Medical Billing Act Health care coverage during pandemic H.R. 7158, The Health Enterprise Zones Act Oral health initiatives, Chief Dental Officer Allowing dental practices to apply for Telehealth Program Funds regardless of size, location, or non-profit status Action for Dental Health Implementation COVID - 19 reopening guidance Health Profession Shortage Areas Access to personal protective equipment for dental offices Provider Relief Fund Including dental benefits in child support orders S. 4055 Strengthening Americas Health Care Readiness Act House Energy and Commerce Committee Investigation into Dental Insurers Disinfectant shortage Unused Leave for Commissioned Corps Members Fluoride monograph | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510684 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | SMB | Increased flexibility for the Paycheck Protection Programs loans Increased funding for small business loan programs H.R. 7777 Paycheck Protection Small Business Forgiveness Act H.R. 6697 Local Chamber, Tourism, and 501(c)(6) Protection Act H.R. 6886/H.R. 7001 Paycheck Protection Program Flexibility Act Implementation S. 3833 Paycheck Protection Program Extension Act H.R. 7216 Small Business Personal Protective Equipment (PPE) Tax Credit Act S. 3716 Main Street Enhancement and Safety Act H.R. 6821 Small Business Expense Protection Act H.R. 7011 Pandemic Risk Insurance Act S. 4317 SAFE TO WORK Act Health, Economic Assistance, Liability Protection, and Schools Act | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510685 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | MMM | Expansion of adult dental Medicaid benefits Section 1332 Waivers Medicare Part C (Medicare Advantage participation/enrollment requirement) Medicare Part D (Medicare Part D prescriber registration/enrollment requirement) E-Prescribing Regulation Medicaid funding for the US territories House Resolution 826, expressing disapproval of recent Centers for Medicare and Medicaid Services guidance on Medicaid block grants Medicaid block grants - Healthy Adult Opportunity Initiative Chief Dental Officer Appointment to CMS Federal Medical Assistance Percentage Increase and Maintenance of Effort | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510686 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | BUD | Funding for dental coverage and benefits, caries prevention and oral health promotion, the dental workforce (incl. alternative dental providers and dental residencies), dental research, and other dental-related agencies, programs and services. Fiscal Year 2020 Appropriations-Agriculture (WIC, school lunches, Team Nutrition) Fiscal Year 2020 Appropriations-Defense (dental research programs Fiscal Year 2020 Appropriations-Interior, Environment, and Related Agencies (IHS oral health division) Fiscal Year 2020 Appropriations-Labor, Health and Human Services, Education, and Related Agencies (AHRQ, CDC, CMS, HHS, HRSA, NIH/NIDCR, other dental-related agencies) H.R. 748 Coronavirus Aid, Relief, and Economic Security Act or the CARES Act H.R. 6201 Families First Coronavirus Response Act. | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510687 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | ENV | Clear aligners Minamata Convention on Mercury Flexibility in enforcing environmental compliance regulations COVID-19 guidance | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510688 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | TOB | Vaping (oral health impact) Congressional Caucus to End the Youth Vaping Epidemic H.R. 2339, the Reversing the Youth Tobacco Epidemic Act of 2019 H.R. 1498, Stopping Appealing Flavors in E-Cigarettes for Kids Act (SAFE Kids Act) S. 655, Stopping Appealing Flavors in E-Cigarettes for Kids Act (SAFE Kids Act) H.R. 1854, the Traditional Cigar Manufacturing and Small Business Jobs Preservation Act of 2019 S. 9, the Traditional Cigar Manufacturing and Small Business Jobs Preservation Act of 2019 H.R. 3942, the Preventing Online Sales of E-Cigarettes to Children Act H.R. 4742, a bill that would impose an excise tax on nicotine H.R. 7286, the Quit Because of COVID-19 Act | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510689 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | IMM | Extending the Grace Period for Dentists on H-1B Visas | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510690 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | EDU | Educational debt, student loans, loan repayment programs, dental school accreditation Reauthorization of the Higher Education Act (student loans, accreditation) H.R. 996, Dental Loan Repayment Assistance Act H.R. 1554, Resident Education Deferred Interest Act (REDI Act) H.R. 1899, Student Loan Refinancing and Recalculation Act H.R. 2186, Student Loan Refinancing Act S. 359, Dental Loan Repayment Assistance Act H.R. 3418, Protecting Our Students by Terminating Graduate Rates that Add to Debt Act (POST Grad Act) S. 2871/H.R. 6448 Indian Health Service Health Professions Tax Fairness Act H.R. 4674, College Affordability Act Student loan relief during COVID-19 pandemic Open Access Publishing H.R. 7032, Skills Renewal Act | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510691 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | LBR | H.R. 1418, Competitive Health Insurance Reform Act of 2019 S. 350, Competitive Health Insurance Reform Act of 2019 H.R. 748 Coronavirus Aid, Relief, and Economic Security Act or the CARES Act Implementation H.R. 6201 Families First Coronavirus Response Act Implementation Small business exemptions from Family and Medical Leave Act requirements COVID-19 Guidance for dental practices Adjustment of the fee schedule for registration and reregistration for DEA certification | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-04:00 | |
| 2510692 | AMERICAN DENTAL ASSOCIATION cf010893-c78c-494d-9bb7-ece3330fe8eb | Q3 | AMERICAN DENTAL ASSOCIATION | 2228 | AMERICAN DENTAL ASSOCIATION | 2020 | third_quarter | IND | S. 2871/H.R. 6448 Indian Health Service Health Professions Tax Fairness Act Supporting IHS Dentists | Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Indian Health Service,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Occupational Safety & Health Administration (OSHA),Office of Science & Technology Policy (OSTP),SENATE,Small Business Administration (SBA),Treasury, Dept of,U.S. Immigration & Customs Enforcement (ICE),Veterans Affairs, Dept of (VA),White House Office | 610000 | 0 | 0 | 2020-10-16T11:06:31.347000-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);