locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Washington" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, 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
10826 CVS Pharmacy, Inc. #04480 FL Pharmacy (850) 638-7896 1037 Main St., Chipley, FL 32428 Chipley Washington 32428 
{
    "unstructured": "08:00AM-09:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004480 
[
    "Pfizer"
]
 
[
    "cvs:04480",
    "vaccinefinder:604a414a-2a92-4c24-8a6e-ae15af9c2f7d",
    "vaccinespotter_org:270386369",
    "us_giscorps_vaccine_providers:cd773281-7173-41a7-8ee3-8975ea1c8785"
]
   https://www.vaccinatethestates.com/?lng=-85.53698&lat=30.77227#lfpgc lfpgc <Binary: 60 bytes> 30.77227 -85.53698
33768 Walmart Inc #10-2114 FL Pharmacy 8506382243 1621 Main St, Chipley, FL 32428-5992 Chipley Washington 32428-5992 
{
    "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/2114 
[]
 
[
    "vaccinefinder:a1262e77-1ac8-4e59-8cb7-1c19e0050f38",
    "walmart:2114",
    "us_carbon_health:d3f4a803-8119-4a04-9cfa-0a65275e45bb",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.54722&lat=30.75273#lqdfh lqdfh <Binary: 60 bytes> 30.75273 -85.54722
37619 King Discount Drug #101074 FL Pharmacy (850) 638-4875 1242 Main Street, Chipley, FL 32428 Chipley Washington 32428 
{
    "unstructured": "8:00 AM - 5:30 PM Mon-Fri, 8:00 AM - 1:00 PM Sat, Closed Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder_org:7b75c896-9ae5-470a-a512-0b4fac5b9e0e",
    "us_carbon_health:189cfd95-4d96-401c-8d8c-87ed73275ecd"
]
   https://www.vaccinatethestates.com/?lng=-85.54156&lat=30.76557#lrcqc lrcqc <Binary: 60 bytes> 30.76557 -85.54156
47176 Vernon Discount Health Mart Pharmacy FL Unknown   3248 Main Street Vernon, FL 32462 Vernon Washington 32462 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141693767"
]
   https://www.vaccinatethestates.com/?lng=-85.71704&lat=30.60895#lwmyb lwmyb <Binary: 60 bytes> 30.60895 -85.71704
60749 Washington-Holmes District COVID Vaccination Site FL Unknown   654 Pecan Street Chipley, FL 32428 Chipley Washington 32428 
{
    "unstructured": null
}
 https://myvaccine.fl.gov/ 
[]
 
[
    "fl_state:37996"
]
   https://www.vaccinatethestates.com/?lng=-85.53214&lat=30.78141#lzypw lzypw <Binary: 60 bytes> 30.78141 -85.53214
61237 Florida Department of Health in Washington County FL Unknown   1338 South Blvd Chipley, FL 32428 Chipley Washington 32428 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40291"
]
   https://www.vaccinatethestates.com/?lng=-85.54396&lat=30.77229#lcbbmg lcbbmg <Binary: 60 bytes> 30.77229 -85.54396

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;