locations_expanded (view)

Data source: Vaccinate The States

24 rows where county = "Highlands" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, location_type, city, zip_code, hours, website, vaccines_offered, latitude, 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
10519 CVS Pharmacy, Inc. #02444 FL Pharmacy (863) 453-7505 1105 W Main St, Avon Park, FL 33825 Avon Park Highlands 33825 
{
    "unstructured": "09:00AM-09:00PM Mon-Fri, 10:00AM-06:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/002444 
[
    "Pfizer"
]
 
[
    "cvs:02444",
    "vaccinefinder:04fd82ed-2022-4d7d-9fe5-62d677005971",
    "vaccinespotter_org:270134254",
    "us_giscorps_vaccine_providers:1d7bb99e-7d61-4c02-95e4-74032f270def"
]
   https://www.vaccinatethestates.com/?lng=-81.51499&lat=27.59500#lfmby lfmby <Binary: 60 bytes> 27.595 -81.51499
19314 Shamrock Pharmacy #Ms1002170 FL Pharmacy (863) 659-4744 5 North Main Ave Ste 101, Lake Placid, FL 33852 Lake Placid Highlands 33852 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:b4d1f8d1-33e3-414d-bc57-06fee7958a05",
    "vaccinefinder_org:b4d1f8d1-33e3-414d-bc57-06fee7958a05"
]
   https://www.vaccinatethestates.com/?lng=-81.36681&lat=27.29744#lhqqw lhqqw <Binary: 60 bytes> 27.29744 -81.36681
21446 Publix Super Markets Inc. #1347 FL Pharmacy (863) 385-5523 3610 U.S. Highway 27 North, Sebring, FL 33870 Sebring Highlands 33870 
{
    "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:1573d3cc-ee79-436b-b291-0e99b474b9d7",
    "vaccinefinder_org:1573d3cc-ee79-436b-b291-0e99b474b9d7",
    "publix:1347",
    "us_giscorps_vaccine_providers:ec4b77c9-4be1-463f-85b6-6cd14b1e954f",
    "fl_state:37886",
    "_tag_provider:publix",
    "us_carbon_health:f90d9a59-60ff-4f35-93bd-2b3a54909ac8"
]
   https://www.vaccinatethestates.com/?lng=-81.49524&lat=27.51566#lkczx lkczx <Binary: 60 bytes> 27.51566 -81.49524
21588 Publix Super Markets Inc. #1517 FL Pharmacy (863) 314-8774 2848 Us Hwy 27 S Suite 107, Sebring, FL 33870 Sebring Highlands 33870 
{
    "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:097c3b3d-ae04-4a09-b43f-1dc654674a68",
    "vaccinefinder_org:097c3b3d-ae04-4a09-b43f-1dc654674a68",
    "publix:1517",
    "us_giscorps_vaccine_providers:ae33982b-b088-42bc-9701-5d2496910db5",
    "_tag_provider:publix",
    "us_carbon_health:4d2bd9ce-a076-4267-82d1-e40e880c12e7"
]
   https://www.vaccinatethestates.com/?lng=-81.44447&lat=27.47361#lkdpt lkdpt <Binary: 60 bytes> 27.47361 -81.44447
21615 Publix Super Markets Inc. #1547 FL Pharmacy (863) 699-2182 586 Us 27 N, Lake Placid, FL 33852 Lake Placid Highlands 33852 
{
    "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:d8c2a60d-e8a9-4a2c-90c9-b015b5def77f",
    "publix:1547",
    "vaccinefinder_org:d8c2a60d-e8a9-4a2c-90c9-b015b5def77f",
    "us_giscorps_vaccine_providers:e926cff3-16d9-452a-a07a-713e452c6520",
    "vaccinespotter_org:206803562",
    "fl_state:37888",
    "us_carbon_health:3d880564-dd4b-4c65-90e6-a31e98b1e8b6",
    "_tag_provider:publix"
]
   https://www.vaccinatethestates.com/?lng=-81.36014&lat=27.30282#lkdrk lkdrk <Binary: 60 bytes> 27.30282 -81.36014
23752 Winn-Dixie #2465 FL Pharmacy 863-471-1268 3250 Us 27 South, Sebring, FL 33870 Sebring Highlands 33870 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 10:00AM - 4:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:fa1a3843-faa6-41b4-bf81-a7dc1888788c",
    "vaccinespotter_org:54273086",
    "vaccinefinder_org:fa1a3843-faa6-41b4-bf81-a7dc1888788c",
    "winn_dixie:2465",
    "us_giscorps_vaccine_providers:f2b2ff89-ec98-4f52-a55e-e7990076ca54",
    "fl_state:37883",
    "us_carbon_health:b1c0af3b-148d-47cb-8e74-b37f8efa8df3",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-81.43813&lat=27.47058#lktbh lktbh <Binary: 60 bytes> 27.47058 -81.43813
27684 Walgreens Co. #5946 FL Pharmacy 863-453-0222 93 Us Highway 27 S, Avon Park, FL 33825-3334 Avon Park Highlands 33825-3334 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:5946",
    "vaccinefinder:51e05cc5-cb40-4447-b03f-d41a334d7d2b",
    "vaccinefinder_org:51e05cc5-cb40-4447-b03f-d41a334d7d2b"
]
   https://www.vaccinatethestates.com/?lng=-81.51375&lat=27.59510#lmrkz lmrkz <Binary: 60 bytes> 27.5951 -81.51375
27685 Walgreens Co. #5947 FL Pharmacy 863-385-9929 3027 Us Highway 27 S, Sebring, FL 33870-5064 Sebring Highlands 33870-5064 
{
    "unstructured": "06:00AM - 11:59PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:5947",
    "vaccinefinder:a3e2af36-d436-4363-81bf-348d9ebeb70c",
    "vaccinefinder_org:a3e2af36-d436-4363-81bf-348d9ebeb70c"
]
   https://www.vaccinatethestates.com/?lng=-81.44390&lat=27.47116#lmrmb lmrmb <Binary: 60 bytes> 27.47116 -81.4439
28601 Walgreens Co. #9006 FL Pharmacy 863-402-5624 3619 Us Highway 27 N, Sebring, FL 33870-1642 Sebring Highlands 33870-1642 
{
    "unstructured": "07:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:9006",
    "vaccinefinder:55b29ea9-0723-4bc0-a0cb-d79ab2d99c51",
    "vaccinefinder_org:55b29ea9-0723-4bc0-a0cb-d79ab2d99c51"
]
   https://www.vaccinatethestates.com/?lng=-81.49570&lat=27.51618#lmybg lmybg <Binary: 60 bytes> 27.51618 -81.4957
28635 Walgreens Co. #9098 FL Pharmacy 863-465-1178 2 Us 27 S, Lake Placid, FL 33852-9453 Lake Placid Highlands 33852-9453 
{
    "unstructured": "07:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:9098",
    "vaccinefinder:12503761-5447-4cda-aa37-fbf37aa0f065",
    "vaccinefinder_org:12503761-5447-4cda-aa37-fbf37aa0f065"
]
   https://www.vaccinatethestates.com/?lng=-81.35928&lat=27.29675#lmydk lmydk <Binary: 60 bytes> 27.29675 -81.35928
32550 Walmart Inc #10-0666 FL Pharmacy 8634711200 3525 Us Highway 27 N, Sebring, FL 33870-1640 Sebring Highlands 33870-1640 
{
    "unstructured": "9:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 9:00 AM - 7:00 PM Wed, 9:00 AM - 7:00 PM Thrus, 9:00 AM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/666 
[
    "Moderna"
]
 
[
    "vaccinefinder:600368d3-1f39-4bed-b088-7d5b5a83e71a",
    "us_carbon_health:848344d0-fbd9-4fe4-b506-42427eeb196f",
    "walmart:666",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.49689&lat=27.51261#lpxmf lpxmf <Binary: 60 bytes> 27.51261 -81.49689
34935 Walmart Inc #10-3887 FL Pharmacy 8634534177 1041 Us Highway 27 N, Avon Park, FL 33825-9142 Avon Park Highlands 33825-9142 
{
    "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:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/3887 
[
    "Moderna"
]
 
[
    "vaccinefinder:2c3abbee-9895-463d-8cd4-437f25bf2110",
    "us_carbon_health:75f46487-e503-4cc3-91ea-d89ae539c708",
    "walmart:3887",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.51764&lat=27.60872#lqkwh lqkwh <Binary: 60 bytes> 27.60872 -81.51764
44722 Highlands County Sports Complex FL Unknown   216 Sheriffs Tower Rd. Sebring Sebring, FL 33870 Sebring Highlands 33870 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:f235f68c-5f11-42f1-972a-b02d818b5090",
    "us_giscorps_vaccine_providers:18cdd95a-9d40-4ee8-bf37-4c029b034642"
]
   https://www.vaccinatethestates.com/?lng=-81.43106&lat=27.49521#ltycz ltycz <Binary: 60 bytes> 27.49521 -81.43106
45301 CVS Pharmacy, Inc. #03130 FL Unknown (863) 465-4810 5 S US HWY 27 LAKE PLACID, FL 33852 LAKE PLACID Highlands 33852 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:4f04c48d-7b60-47f9-a719-cf45d18db945",
    "cvs:3130",
    "vaccinespotter_org:270042878",
    "us_carbon_health:2049c779-a6be-41b6-b820-f87d70192456"
]
   https://www.vaccinatethestates.com/?lng=-81.35769&lat=27.29675#lwbmd lwbmd <Binary: 60 bytes> 27.29675 -81.35769
45761 Avon Park Parks & Recreation FL Unknown   207 Malcolm St. Avon Park Avon Park, FL 33825 Avon Park Highlands 33825 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:643aecde-758f-4d22-b122-926cd764a0c0"
]
   https://www.vaccinatethestates.com/?lng=-81.49595&lat=27.59031#lwdgd lwdgd <Binary: 60 bytes> 27.59031 -81.49595
46493 Lake Placid Camp and Conference Center FL Unknown   2665 Placid View Dr. Lake Placid Lake Placid, FL 33852 Lake Placid Highlands 33852 
{
    "unstructured": null
}
 https://www.floridadisaster.org/Vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:3d81a801-20bc-446b-9a3b-7eee8e9241a6"
]
   https://www.vaccinatethestates.com/?lng=-81.37015&lat=27.26435#lwhdm lwhdm <Binary: 60 bytes> 27.26435 -81.37015
47148 CVS Pharmacy, Inc. #03155 FL Unknown (863) 385-2525 2728 US HWY 27 S SEBRING, FL 33870 SEBRING Highlands 33870 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:2713eb4c-6eb3-40be-a946-d93c90f07479",
    "cvs:3155",
    "vaccinespotter_org:270373723"
]
   https://www.vaccinatethestates.com/?lng=-81.44578&lat=27.47305#lwmwc lwmwc <Binary: 60 bytes> 27.47305 -81.44578
47449 Gilbert Drugs FL Unknown   2190 Lakeview Dr Sebring, FL 33870 Sebring Highlands 33870 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141707115"
]
   https://www.vaccinatethestates.com/?lng=-81.44466&lat=27.49788#lwpzk lwpzk <Binary: 60 bytes> 27.49788 -81.44466
60019 Florida Department of Health in Highlands County FL Unknown   400 S. Lake Ave Avon Park, FL 33825 Avon Park Highlands 33825 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:37844"
]
   https://www.vaccinatethestates.com/?lng=-81.50240&lat=27.59194#lztrx lztrx <Binary: 60 bytes> 27.59194 -81.5024
60267 Walmart Inc FL Unknown   1041 US HIGHWAY 27 N Avon Park, FL 33825 Avon Park Highlands 33825 
{
    "unstructured": null
}
 https://www.walmart.com/covidvaccine 
[]
 
[
    "fl_state:37882"
]
   https://www.vaccinatethestates.com/?lng=-81.51390&lat=27.58388#lzwrq lzwrq <Binary: 60 bytes> 27.58388 -81.5139
60820 Florida Department of Health in Highlands County FL Unknown   106 N. Main Ave Lake Placid, FL 33852 Lake Placid Highlands 33852 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39823"
]
   https://www.vaccinatethestates.com/?lng=-81.36587&lat=27.29853#lzyxf lzyxf <Binary: 60 bytes> 27.29853 -81.36587
60823 Florida Department of Health in Highlands County FL Unknown   7205 S George Blvd. Sebring, FL 33875 Sebring Highlands 33875 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39822"
]
   https://www.vaccinatethestates.com/?lng=-81.42063&lat=27.43691#lzyxk lzyxk <Binary: 60 bytes> 27.43691 -81.42063
61248 Lakeshore Mall FL Unknown   901 U. S. Hwy. 27 North; Suite 68 Sebring, FL 33870 Sebring Highlands 33870 
{
    "unstructured": null
}
 https://www.highlandsfl.gov/vaccine_information/index.php 
[]
 
[
    "fl_state:37885",
    "us_carbon_health:42fb68eb-4a10-41a2-8b53-a139ee317ae5"
]
   https://www.vaccinatethestates.com/?lng=-81.48742&lat=27.49043#lcbbmz lcbbmz <Binary: 60 bytes> 27.49043 -81.48742
65767 Publix Super Markets Inc. #1357 FL Unknown (352) 243-8845 2430 US Hwy. 27 Clermont, FL 34714 Clermont Highlands 34714 
{
    "unstructured": null
}
 https://www.publix.com/pharmacy/pharmacy-services/vaccinations 
[]
 
[
    "_tag_provider:publix",
    "us_carbon_health:d21e1f7e-124c-484b-87c1-2445847f8108",
    "publix:1357"
]
   https://www.vaccinatethestates.com/?lng=-81.51172&lat=27.55818#lccdfb lccdfb <Binary: 60 bytes> 27.55818 -81.51172

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;