home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3d79f8a0-3285-4d2c-a149-0d7e2b0db7ec

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
3d79f8a0-3285-4d2c-a149-0d7e2b0db7ec 1A 3071 AMERICAN PHARMACISTS ASSOCIATION 103628 AMERICAN PHARMACISTS ASSOCIATION 2017 first_quarter 2017-04-12T15:13:53.620000-04:00 30000.0 1 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3d79f8a0-3285-4d2c-a149-0d7e2b0db7ec/", "filing_uuid": "3d79f8a0-3285-4d2c-a149-0d7e2b0db7ec", "filing_type": "1A", "filing_type_display": "1st Quarter - Amendment", "filing_year": 2017, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3d79f8a0-3285-4d2c-a149-0d7e2b0db7ec/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "30000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Alicia Kerry J. Mica", "dt_posted": "2017-04-12T15:13:53.620000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2215 CONSTITUTION AVENUE, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20037", "registrant": {"id": 3071, "url": "https://lda.senate.gov/api/v1/registrants/3071/", "house_registrant_id": 31620, "name": "AMERICAN PHARMACISTS ASSOCIATION", "description": null, "address_1": "2215 CONSTITUTION AVENUE, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20037", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DOUGLAS HUYNH", "contact_telephone": "+1 202-429-7573", "dt_updated": "2026-01-26T09:17:08.917208-05:00"}, "client": {"id": 103628, "url": "https://lda.senate.gov/api/v1/clients/103628/", "client_id": 12, "name": "AMERICAN PHARMACISTS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "ALC", "general_issue_code_display": "Alcohol and Drug Abuse", "description": "HR 1271 DXM Abuse Prevention Act of 2017\nHR 1375 Prescriber Support Act of 2017\nHR 1575 Addiction Recovery through Family Health Accounts Act\nS 523 Budgeting for Opioid Addiction Treatment Act \nS 581 To include information concerning a patient's opioid addiction in certain medical records.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "HR 1409 Cancer Drug Parity Act of 2017\nHR 1610 Medical Loss Ratio Accountability Act of 2017\nHR 1589 Fair Access to Health Care Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "HR 1316 To amend title XVIII of the Social Security Act to provide for pharmacy benefits manager standards under the Medicare prescription drug program and Medicare Advantage program to further transparency of payment methodologies to pharmacies, and for other purposes.\nHR 1038, S 413 Improving Transparency and Accuracy in Medicare Part D Spending Act\nHR 1939 To amend title XVIII of the Social Security Act to ensure equal access of Medicare beneficiaries to community pharmacies in underserved areas as network pharmacies under Medicare prescription drug coverage, and for other purposes.\nHR 592, S 109 To amend title XVIII of the Social Security Act to provide for coverage under the Medicare program of pharmacist services.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "S 523 Budgeting for Opioid Addiction Treatment Act \nHR 1436 To provide for reconciliation pursuant to title II of the concurrent resolution on the budget for fiscal year 2017.\nHR 1628 American Health Care Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "HR 1316 To amend title XVIII of the Social Security Act to provide for pharmacy benefits manager standards under the Medicare prescription drug program and Medicare Advantage program to further transparency of payment methodologies to pharmacies, and for other purposes.\nS 495 Medical Innovation Prize Fund Act\nHR 1621 Protecting Seniors from Health Care Fraud Act of 2017\nHR 1703 Medical Product Communications Act of 2017\nS 771 Improving Access To Affordable Prescription Drugs Act\nHR 1775 Prescription Reduction in Costs for Everyone (PRICE) Act of 2017\nHR 1776 Improving Access To Affordable Prescription Drugs Act\nHR 1480 Safe and Affordable Drugs from Canada Act of 2017\nHR 1245, S 469 To amend the Federal Food, Drug, and Cosmetic Act to allow for the importation of affordable and safe drugs by wholesale distributors, pharmacies, and individuals.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "HR 1038, S 413 Improving Transparency and Accuracy in Medicare Part D Spending Act\nHR 1939 To amend title XVIII of the Social Security Act to ensure equal access of Medicare beneficiaries to community pharmacies in underserved areas as network pharmacies under Medicare prescription drug coverage, and for other purposes.\nHR 592, S 109 To amend title XVIII of the Social Security Act to provide for coverage under the Medicare program of pharmacist services.\nHR 1480 Safe and Affordable Drugs from Canada Act of 2017\nS 637 Creating Transparency to Have Drug Rebates Unlocked (C-THRU) Act of 2017\nHR 1586 To amend the Federal Food, Drug, and Cosmetic Act to ensure that liquid over-the-counter medications are packaged with appropriate dosage delivery devices and, in the case of such medications labeled for pediatric use, appropriate flow restrictors, and for other purposes.\nS 778 Prescription Drug Monitoring Act of 2017\nHR 934 Personal Drug Importation Fairness Act of 2017\nHR 421 Allowing Greater Access to Safe and Effective Contraception Act\nHR 1436 To provide for reconciliation pursuant to title II of the concurrent resolution on the budget for fiscal year 2017.\nHR 1245, S 469 To amend the Federal Food, Drug, and Cosmetic Act to allow for the importation of affordable and safe drugs by wholesale distributors, pharmacies, and individuals.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66187, "prefix": null, "prefix_display": null, "first_name": "ALICIA", "nickname": null, "middle_name": "KERRY J.", "last_name": "MICA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31620 DC DC US US   0 0 2280588   alias 0.85

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.085ms