Oral Antiviral Locations

Paxlovid & Lagevrio Availability

@kaggle.noeyislearning_oral_antiviral_locations

Table List

1 table(3.16 MB)

Raw Oral Antiviral Locations

@kaggle.noeyislearning_oral_antiviral_locations.raw_oral_antiviral_locations

3.16 MB
57943 rows
10 columns

provider_name Provider Name	address1 Address1	address2 Address2	city City	state State	zip Zip	last_report_date Last Report Date	public_website Public Website	phone_number Phone Number	geopoint Geopoint
PHARMAG PHARMACY	6622 SW 24 ST	nan	MIAMI	FL	33155	01/30/2024 12:00:00 AM	nan	nan	POINT (-80.30304 25.74779)
SNEADS PHARMACY	7995 HWY 90	nan	SNEADS	FL	32460	01/30/2024 12:00:00 AM	nan	nan	POINT (-84.928003 30.709665)
FEDCO DRUGS	255 SUNRISE AVE	nan	PALM BEACH	FL	33480	01/30/2024 12:00:00 AM	nan	nan	POINT (-80.040021 26.720425)
LONGS DRUGS #09955	848 ALA LILIKOI ST	nan	HONOLULU	HI	96818	01/30/2024 12:00:00 AM	nan	nan	POINT (-157.91342 21.345818)
ELKMONT PHARMACY	25462 HL HWY 127	nan	ELKMONT	AL	35620	01/30/2024 12:00:00 AM	nan	nan	POINT (-86.988302 34.919333)
H & M DRUGS	146 VILLAGE LANE	nan	WEDOWEE	AL	36278	01/30/2024 12:00:00 AM	nan	nan	POINT (-85.484095 33.314584)
GIL DRUGS	52 LINCOLNWAY	nan	VALPARAISO	IN	463835574	01/30/2024 12:00:00 AM	nan	nan	POINT (-87.061145 41.467933)
CVS PHARMACY #16030	2209 STATE ST	nan	NEW ALBANY	IN	47150	01/30/2024 12:00:00 AM	nan	nan	POINT (-85.841822 38.30496)
HARVEY DRUG	204 N CEDAR ST	nan	ABILENE	KS	67410	01/30/2024 12:00:00 AM	nan	nan	POINT (-97.216804 38.916862)
GAP DRUG	233 PUMPHOUSE RD	nan	SOMERSET	KY	42503	01/30/2024 12:00:00 AM	nan	nan	POINT (-84.59033 37.104162)


CREATE TABLE raw_oral_antiviral_locations (
  "provider_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "last_report_date" VARCHAR,
  "public_website" VARCHAR,
  "phone_number" VARCHAR,
  "geopoint" VARCHAR
);