ASPR Treatments Locator
U.S. Department of Health & Human Services
@usgov.hhs_gov_aspr_treatments_locator
U.S. Department of Health & Human Services
@usgov.hhs_gov_aspr_treatments_locator
CREATE TABLE table_1 (
"provider_name" VARCHAR,
"address_1" VARCHAR,
"address_2" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" VARCHAR,
"public_phone" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"geopoint" VARCHAR,
"last_report_date" VARCHAR,
"is_pap_site" BOOLEAN,
"prescribing_services_available" VARCHAR,
"appointment_url" VARCHAR,
"home_delivery" BOOLEAN,
"is_icatt_site" BOOLEAN,
"has_usg_product" BOOLEAN,
"has_commercial_product" BOOLEAN,
"has_paxlovid" BOOLEAN,
"has_commercial_paxlovid" BOOLEAN,
"has_usg_paxlovid" BOOLEAN,
"has_lagevrio" BOOLEAN,
"has_commercial_lagevrio" BOOLEAN,
"has_usg_lagevrio" BOOLEAN,
"has_veklury" BOOLEAN,
"has_oseltamivir_generic" BOOLEAN,
"has_oseltamivir_suspension" BOOLEAN,
"has_oseltamivir_tamiflu" BOOLEAN,
"has_baloxavir" BOOLEAN,
"has_zanamivir" BOOLEAN,
"has_peramivir" BOOLEAN,
"grantee_code" VARCHAR,
"is_flu" BOOLEAN,
"is_covid_19" BOOLEAN
);
Anyone who has the link will be able to view this.