COVID-19 Public Therapeutic Locator

<b>NOTE: This dataset is no longer updated as of 1/31/2024. Please use <a href="https://healthdata.gov/ASPR/COVID-19-Treatments/xkzp-zhs7/about_data">COVID-19 Treatments.</a></b>

Locations of publicly available COVID-19 Therapeutics. Dataset only includes locations for Paxlovid (oral antiviral), Lagevrio (oral antiviral), and outpatient Veklury (intravenous antiviral infusion). COVID-19 therapeutics require a prescription to obtain. Limitations: public contact information.

<b> To filter, click 'View Data' below, then 'Filter.' To save your view, click 'Save as,' and this configuration will be saved in your profile under 'My Assets.' <u>Please try not to publish dataset publicly, unless necessary.</b></u>

On 1/3/2022 - The following changes were made to this dataset.

• Dropped the Expected Deliver Date column - This was a derived field set to 3 days after the Last Order Date field.

• Added the following fields

  Last Date Delivered

  Total Courses

  Courses Available

  Courses Available Date

On 1/4/2022 - Added Geocoded Address

On 1/11/2022 - Added NPI - National Provider Identifier

On 2/18/2022 - Added new therapeutics, Bebtelovimab & Sotrovimab.

On 3/16/2022 - Dropped the following columns

  - last_order_date

  - last_date_delivered

  - total_courses

  - courses_available_date

Added the following columns

  - facility_id

  - last_report_date

  - grantee_code

  - provider_pin

  - state_provider_pin

On 3/31/2022 - Dropped the following columns

  - facility_id

  - grantee_code

  - provider_pin

  - state_provider_pin

Added the following columns

  - provider_status

  - provider_note

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"healthdata-gov/covid19-public-therapeutic-locator-rxn6-qnx8\".\"covid19_public_therapeutic_locator\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.