locations_expanded (view)

Data source: Vaccinate The States

22 rows where county = "Columbia" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, hours, vaccines_offered, last_verified_by_vts (date), concordances (array)

rowid name state location_type phone_number full_address city county zip_code hours website vaccines_offered concordances last_verified_by_vts vts_url id geometry latitude longitude
10807 CVS Pharmacy, Inc. #04357 FL Pharmacy (386) 755-2770 283 Sw Baya Dr, Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": "08:00AM-08:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004357 
[
    "Pfizer"
]
 
[
    "cvs:04357",
    "vaccinefinder:85c9b63f-e12d-4f20-bb0f-8baf60ead1fc",
    "us_giscorps_vaccine_providers:a9b48a5d-ba49-41b2-90a5-90a8db42540a",
    "vaccinespotter_org:270182976",
    "fl_state:37697",
    "fl_state:40113",
    "fl_state:40128"
]
   https://www.vaccinatethestates.com/?lng=-82.63986&lat=30.18444#lfpdy lfpdy <Binary: 60 bytes> 30.18444 -82.63986
13319 Baya Pharmacy West FL Pharmacy 386 755-2233 1465 Us Hwy 90 West #110, Lake City, FL 32055 Lake City Columbia 32055 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:672f0b25-fe08-46e5-a07a-6531109e83fa",
    "vaccinefinder_org:672f0b25-fe08-46e5-a07a-6531109e83fa"
]
   https://www.vaccinatethestates.com/?lng=-82.65750&lat=30.18354#lgdbz lgdbz <Binary: 60 bytes> 30.18354 -82.6575
13434 Baya Pharmacy FL Pharmacy 386 755-6677 780 Se Baya Drive, Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:11b2b01c-f683-4dc0-963d-133b54c9de62",
    "vaccinefinder_org:11b2b01c-f683-4dc0-963d-133b54c9de62",
    "vaccinespotter_org:141692529",
    "fl_state:38256",
    "fl_state:40111",
    "fl_state:40129"
]
   https://www.vaccinatethestates.com/?lng=-82.62560&lat=30.18292#lgdpm lgdpm <Binary: 60 bytes> 30.18292 -82.6256
18918 Cheek & Scott Drugs Inc #Ms1000311 FL Pharmacy (386) 754-5377 4785 W Us Hwy 90, Lake City, FL 32055 Lake City Columbia 32055 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 8:00 AM - 1:00 PM Sat, Closed Sun"
}
 www.cheekandscott.com 
[]
 
[
    "vaccinefinder:2df0ea00-9cc6-4fce-b688-dc8036b8080f",
    "vaccinefinder_org:2df0ea00-9cc6-4fce-b688-dc8036b8080f"
]
   https://www.vaccinatethestates.com/?lng=-82.71005&lat=30.18531#lhpbk lhpbk <Binary: 60 bytes> 30.18531 -82.71005
21335 Publix Super Markets Inc. #1192 FL Pharmacy (386) 719-5451 255 N. W. Commons Loop, Lake City, FL 32055 Lake City Columbia 32055 
{
    "unstructured": "9:00AM - 9:00PM Mon-Fri, 9:00AM - 7:00PM Sat, 11:00AM - 6:00PM Sun"
}
 https://www.publix.com/pharmacy/pharmacy-services/vaccinations 
[]
 
[
    "vaccinefinder:7b5e4741-a0a5-4387-a00f-0a5ca638e3ee",
    "vaccinefinder_org:7b5e4741-a0a5-4387-a00f-0a5ca638e3ee",
    "publix:1192",
    "us_giscorps_vaccine_providers:e12c31f3-de00-40fb-80fa-42957dd8ad06",
    "fl_state:37696",
    "us_carbon_health:6ff9a4e3-9baf-4317-a256-2803f6a087ec",
    "_tag_provider:publix"
]
   https://www.vaccinatethestates.com/?lng=-82.66438&lat=30.18155#lkcpy lkcpy <Binary: 60 bytes> 30.18155 -82.66438
23584 Winn-Dixie #81 FL Pharmacy 386-755-0997 580 South Marion Ave., Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 10:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:8299da21-efbf-470c-ae90-406eab764abf",
    "vaccinespotter_org:54271879",
    "vaccinefinder_org:8299da21-efbf-470c-ae90-406eab764abf",
    "winn_dixie:81",
    "us_giscorps_vaccine_providers:e6949b19-f5f0-404d-950d-cf630ad0dcd5",
    "fl_state:39543",
    "us_carbon_health:1bd5117d-041c-42fe-80a8-efcc5c604c0d",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-82.63838&lat=30.18260#lkrhx lkrhx <Binary: 60 bytes> 30.1826 -82.63838
32629 Walmart Inc #10-0767 FL Pharmacy 3867552427 2767 W Us Highway 90, Lake City, FL 32055-4755 Lake City Columbia 32055-4755 
{
    "unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:15PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:15PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/767 
[
    "Moderna"
]
 
[
    "vaccinefinder:ad5bc069-595a-462e-8ea0-c4e41323f926",
    "walmart:767",
    "us_carbon_health:86db3a21-dd2c-4c7a-a5aa-cec32006d2b5",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-82.67771&lat=30.18140#lpxwd lpxwd <Binary: 60 bytes> 30.1814 -82.67771
44151 Walgreens Co. #6263 FL Unknown 386-755-0313 2094 W US HIGHWAY 90 LAKE CITY, FL 32055 LAKE CITY Columbia 32055 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Moderna",
    "Pfizer"
]
 
[
    "vaccinefinder_org:d53601ad-67c5-4a31-b91c-5ca9ae117d54",
    "walgreens:6263",
    "us_giscorps_vaccine_providers:4163efee-de69-4017-ae55-f1d35d97dd15",
    "vaccinespotter_org:2717509",
    "fl_state:37699"
]
   https://www.vaccinatethestates.com/?lng=-82.66649&lat=30.17799#lttwy lttwy <Binary: 60 bytes> 30.17799 -82.66649
45676 CVS Pharmacy, Inc. #01817 FL Unknown (386) 752-8090 2233 US HIGHWAY 90 WEST LAKE CITY, FL 32055 LAKE CITY Columbia 32055 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:ed34e223-adcd-4bbc-a2bd-320c30d00ab8",
    "cvs:1817",
    "vaccinespotter_org:270748192",
    "fl_state:39530",
    "fl_state:40112",
    "fl_state:40127"
]
   https://www.vaccinatethestates.com/?lng=-82.66846&lat=30.17950#lwcyx lwcyx <Binary: 60 bytes> 30.1795 -82.66846
47294 PALMS MED LAKE CITY FL Unknown (386) 755-4020 173 NW ALBRITTON LANE LAKE CITY, FL 32055 LAKE CITY Columbia 32055 
{
    "unstructured": null
}
 https://www.palmsmg.org/ 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:2a162dc0-c756-476c-bc06-7ed212e2b116"
]
   https://www.vaccinatethestates.com/?lng=-82.63978&lat=30.22012#lwphp lwphp <Binary: 60 bytes> 30.22012 -82.63978
47587 PALMS MEDICAL GROUP- LAKE CITY WEST FL Unknown (386) 269-9260 4784 W US HWY 90 LAKE CITY, FL 32055 LAKE CITY Columbia 32055 
{
    "unstructured": null
}
 https://www.palmsmg.org/ 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:0810f9e3-42af-4acb-b99d-598f8f5d7107",
    "fl_state:39542"
]
   https://www.vaccinatethestates.com/?lng=-82.71014&lat=30.18406#lwqpg lwqpg <Binary: 60 bytes> 30.18406 -82.71014
56156 Lake City VAMC FL Hospital / Clinic   619 S. Marion Avenue Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": ""
}
 https://al-telegov.egov.com/alabamavaccine/CustomerCreateAppointments/SelectLocation?appointmentTypeid=1 
[]
 
[]
 2021-05-10T02:28:54.973919+00:00 https://www.vaccinatethestates.com/?lng=-82.63570&lat=30.18209#lywkt lywkt <Binary: 60 bytes> 30.18209 -82.6357
60142 North Florida Pharmacy - Fort White FL Unknown   7729 US 27 Fort White, FL 32038 Fort White Columbia 32038 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39534"
]
   https://www.vaccinatethestates.com/?lng=-82.71419&lat=29.92343#lzwdp lzwdp <Binary: 60 bytes> 29.92343 -82.71419
60288 Lake City Medical Center FL Unknown   340 NW Commerce Dr Lake City, FL 32055 Lake City Columbia 32055 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39533"
]
   https://www.vaccinatethestates.com/?lng=-82.68785&lat=30.18348#lzwty lzwty <Binary: 60 bytes> 30.18348 -82.68785
60756 Southside Sports Complex FL Unknown   1963 SW Bascom Norris Drive Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40110"
]
   https://www.vaccinatethestates.com/?lng=-82.65520&lat=30.16756#lzyqf lzyqf <Binary: 60 bytes> 30.16756 -82.6552
60769 North Florida Pharmacy - US 90 FL Unknown   3718 W US Highway 90 Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39536"
]
   https://www.vaccinatethestates.com/?lng=-82.69353&lat=30.17926#lzyrb lzyrb <Binary: 60 bytes> 30.17926 -82.69353
61254 Columbia County Health Department FL Unknown   217 NE Franklin Street Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39529"
]
   https://www.vaccinatethestates.com/?lng=-82.63547&lat=30.19385#lcbbph lcbbph <Binary: 60 bytes> 30.19385 -82.63547
61290 Southern Internal Medicine FL Unknown   404 NW Hall of Fame Dr Lake City, FL 32055 Lake City Columbia 32055 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:34416"
]
   https://www.vaccinatethestates.com/?lng=-82.69535&lat=30.18411#lcbbrq lcbbrq <Binary: 60 bytes> 30.18411 -82.69535
61302 Office of Brent Hayden, MD FL Unknown   733 SW SR 47 Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39527"
]
   https://www.vaccinatethestates.com/?lng=-82.64423&lat=30.16146#lcbbth lcbbth <Binary: 60 bytes> 30.16146 -82.64423
61391 Fresenius Kidney Care FL Unknown   1445 SW Main Blvd Suite 120 Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39531"
]
   https://www.vaccinatethestates.com/?lng=-82.63935&lat=30.17038#lcbcbz lcbcbz <Binary: 60 bytes> 30.17038 -82.63935
61414 Florida Gateway Fairgrounds FL Unknown   164 SW Mary Ethel Ln Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
 https://bit.ly/2PAhNRW 
[]
 
[
    "fl_state:37698"
]
   https://www.vaccinatethestates.com/?lng=-82.67632&lat=30.17616#lcbcdk lcbcdk <Binary: 60 bytes> 30.17616 -82.67632
61415 North Florida Pharmacy FL Unknown   347 SW Main Blvd Lake City, FL 32025 Lake City Columbia 32025 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39535"
]
   https://www.vaccinatethestates.com/?lng=-82.63888&lat=30.18589#lcbcdm lcbcdm <Binary: 60 bytes> 30.18589 -82.63888

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW locations_expanded AS 
select
  locations.rowid,
  locations.*,
  y(locations.geometry) as latitude,
  x(locations.geometry) as longitude
from
  locations;