locations_expanded (view)

Data source: Vaccinate The States

15 rows where county = "Walton" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, website, vaccines_offered, vaccines_offered (array), 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
10709 CVS Pharmacy, Inc. #03684 FL Pharmacy (850) 837-3999 130 Scenic Gulf Drive, Miramar Beach, FL 32550 Miramar Beach Walton 32550 
{
    "unstructured": "09:00AM-08:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/003684 
[
    "Pfizer"
]
 
[
    "cvs:03684",
    "vaccinefinder:5e3cb4e6-3c1a-48d5-b2f4-d6adbf55fb10",
    "vaccinespotter_org:270207404",
    "us_giscorps_vaccine_providers:7a2f0ace-1431-4f1f-b192-8d8a3237d9c4",
    "fl_state:39820",
    "fl_state:40047"
]
   https://www.vaccinatethestates.com/?lng=-86.35059&lat=30.37694#lfmww lfmww <Binary: 60 bytes> 30.37694 -86.35059
19058 The Prescription Place #Ms1000851 FL Pharmacy (850) 892-6898 1337 Us Highway 90 W, Defuniak Springs, FL 32433 Defuniak Springs Walton 32433 
{
    "unstructured": "8:00 AM - 5:30 PM Mon-Fri, 8:00 AM - 12:00 PM Sat, Closed Sun"
}
 http://prescriptionplacerx.com 
[]
 
[
    "vaccinefinder:450cee2f-f1e9-41b5-b2cb-6b10bedb81a6",
    "vaccinefinder_org:450cee2f-f1e9-41b5-b2cb-6b10bedb81a6",
    "fl_state:39520"
]
   https://www.vaccinatethestates.com/?lng=-86.13982&lat=30.73076#lhpqq lhpqq <Binary: 60 bytes> 30.73076 -86.13982
21165 Publix Super Markets Inc. #885 FL Pharmacy (850) 622-3772 725 Grand Blvd, Sandestin, FL 32550 Sandestin Walton 32550 
{
    "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:0289d931-8818-44ce-adc9-6f3288ec2f9f",
    "vaccinespotter_org:206729185",
    "vaccinefinder_org:0289d931-8818-44ce-adc9-6f3288ec2f9f",
    "publix:885",
    "fl_state:39290",
    "_tag_provider:publix",
    "us_carbon_health:ba5c68db-e69a-4e9c-98ed-b4604c384296"
]
   https://www.vaccinatethestates.com/?lng=-86.31161&lat=30.37949#lkbyg lkbyg <Binary: 60 bytes> 30.37949 -86.31161
21378 Publix Super Markets Inc. #1258 FL Pharmacy (850) 267-1166 2038 Us Highway 98 West, Santa Rosa Beach, FL 32459 Santa Rosa Beach Walton 32459 
{
    "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:44eb0d1c-bca6-4686-948e-f8e94e865057",
    "vaccinespotter_org:206729183",
    "vaccinefinder_org:44eb0d1c-bca6-4686-948e-f8e94e865057",
    "publix:1258",
    "fl_state:39291",
    "us_carbon_health:27bef8df-253a-4daa-9b91-cef79e8a0d69",
    "_tag_provider:publix",
    "us_carbon_health:2c8bb3e5-8052-4675-b04b-1b5480743212"
]
   https://www.vaccinatethestates.com/?lng=-86.21311&lat=30.37523#lkctq lkctq <Binary: 60 bytes> 30.37523 -86.21311
21450 Publix Super Markets Inc. #1351 FL Pharmacy (850) 835-2317 16400 Us Highway 331 South, Freeport, FL 32439 Freeport Walton 32439 
{
    "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:810bc345-beb9-43db-b4a4-e37a6c67677b",
    "vaccinefinder_org:810bc345-beb9-43db-b4a4-e37a6c67677b",
    "publix:1351",
    "vaccinespotter_org:206729184",
    "fl_state:39292",
    "us_carbon_health:61405457-b9b9-4dd2-bb79-96e3bf924efe",
    "_tag_provider:publix",
    "us_carbon_health:9dea758f-9461-461b-86f7-3203cba31dd3"
]
   https://www.vaccinatethestates.com/?lng=-86.12333&lat=30.48741#lkdbc lkdbc <Binary: 60 bytes> 30.48741 -86.12333
23643 Winn-Dixie #577 FL Pharmacy 850-892-9668 1030 Hwy 331 South, Defuniak Springs, FL 32435 Defuniak Springs Walton 32435 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 12:00PM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:c2359ed0-daeb-4d23-911a-0989d97b84b4",
    "vaccinefinder_org:c2359ed0-daeb-4d23-911a-0989d97b84b4",
    "winn_dixie:577",
    "us_giscorps_vaccine_providers:a8c91316-b075-4f02-904c-b6ee04b7129b",
    "us_carbon_health:b424e54d-69a6-48e3-b3ea-d74301b92e6d",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-86.12445&lat=30.70736#lkrqp lkrqp <Binary: 60 bytes> 30.70736 -86.12445
29016 Walgreens Co. #9914 FL Pharmacy 850-951-9880 1103 Us Highway 331 S, Defuniak Springs, FL 32435-3383 Defuniak Springs Walton 32435-3383 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:9914",
    "vaccinefinder:6b079ce7-b85f-416b-b99c-e2a05a0a5efa",
    "vaccinefinder_org:6b079ce7-b85f-416b-b99c-e2a05a0a5efa"
]
   https://www.vaccinatethestates.com/?lng=-86.12214&lat=30.70649#lmzrf lmzrf <Binary: 60 bytes> 30.70649 -86.12214
32963 Walmart Inc #10-1134 FL Pharmacy 8508923138 1226 Freeport Hwy S, De Funiak Springs, FL 32435-3396 De Funiak Springs Walton 32435-3396 
{
    "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/1134 
[]
 
[
    "vaccinefinder:60e0f9f8-95ad-4038-bc3d-9566ede05f14",
    "us_carbon_health:475bcb1c-cf76-49ac-97d1-53c830ade011",
    "_tag_provider:walmart",
    "walmart:1134"
]
   https://www.vaccinatethestates.com/?lng=-86.12499&lat=30.70450#lpzcb lpzcb <Binary: 60 bytes> 30.7045 -86.12499
35887 Walmart Inc #10-5872 FL Pharmacy 8506226237 6712 Us Highway 98 W, Santa Rosa Beach, FL 32459-6900 Santa Rosa Beach Walton 32459-6900 
{
    "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/5872 
[]
 
[
    "vaccinefinder:9db665c8-8c7e-454f-96a3-a8860d2ce989",
    "walmart:5872",
    "_tag_provider:walmart",
    "us_carbon_health:2dd61787-ce0b-4ee1-8f77-46de8b0079b9"
]
   https://www.vaccinatethestates.com/?lng=-86.28893&lat=30.37706#lqrmy lqrmy <Binary: 60 bytes> 30.37706 -86.28893
37623 Fisher's Pharmacy, Inc. #105388 FL Pharmacy (850) 892-5612 688 Baldwin Avenue, Defuniak Springs, FL 32435 Defuniak Springs Walton 32435 
{
    "unstructured": "8:00 AM - 5:30 PM Mon, 8:00 AM - 5:00 PM Tue, 8:00 AM - 5:30 PM Wed, 8:00 AM - 5:30 PM Thrus, 8:00 AM - 5:30 PM Fri, 8:00 AM - 12:00 PM Sat,  Sun"
}
 http://www.fishersdfs.com 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:f027d7d0-52b1-4a2c-9b7b-8f6e53663a90",
    "fl_state:39519",
    "us_carbon_health:93e69952-6942-463d-a00d-c04918ce0fb0"
]
   https://www.vaccinatethestates.com/?lng=-86.11249&lat=30.72035#lrcqh lrcqh <Binary: 60 bytes> 30.72035 -86.11249
46736 Everlasting Word Church FL Unknown   2132 US-90 West DeFuniak Springs Defuniak Springs, FL 32433 Defuniak Springs Walton 32433 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:40bb9e53-96b3-404e-b5ad-e4c08ad9eed2"
]
   https://www.vaccinatethestates.com/?lng=-86.15232&lat=30.73485#lwkcx lwkcx <Binary: 60 bytes> 30.73485 -86.15232
46864 CVS Pharmacy, Inc. #07113 FL Unknown (850) 269-7780 60 S. HOLIDAY RD. MIRAMAR BEACH, FL 32550 MIRAMAR BEACH Walton 32550 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:93aca433-ce56-43b1-9683-85d25c50bfc4",
    "cvs:7113",
    "vaccinespotter_org:270262976",
    "fl_state:39298"
]
   https://www.vaccinatethestates.com/?lng=-86.38092&lat=30.38425#lwkqy lwkqy <Binary: 60 bytes> 30.38425 -86.38092
61217 Walton County Fairgrounds (Thursdays from 1 p.m. - 7 p.m.) FL Unknown   790 N 9th St Defuniak Springs, FL 32459 Defuniak Springs Walton 32459 
{
    "unstructured": null
}
 http://walton.floridahealth.gov 
[]
 
[
    "fl_state:39781"
]
   https://www.vaccinatethestates.com/?lng=-86.22733&lat=30.38589#lcbbkb lcbbkb <Binary: 60 bytes> 30.38589 -86.22733
61218 Walton County Health Department Coastal Branch FL Unknown   361 Greenway Trail Santa Rosa Beach, FL 32459 Santa Rosa Beach Walton 32459 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40290",
    "us_carbon_health:842f70b1-e4a1-4a11-b374-ef78b510c18f"
]
   https://www.vaccinatethestates.com/?lng=-86.18245&lat=30.37480#lcbbkc lcbbkc <Binary: 60 bytes> 30.3748 -86.18245
61221 Florida Department of Health in Walton County FL Unknown   790 State Highway 83 DeFuniak Springs, FL 32433 DeFuniak Springs Walton 32433 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40289"
]
   https://www.vaccinatethestates.com/?lng=-86.11403&lat=30.73191#lcbbkg lcbbkg <Binary: 60 bytes> 30.73191 -86.11403

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;