locations_expanded (view)

Data source: Vaccinate The States

10 rows where county = "Taylor" and state = "FL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, website, vaccines_offered (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
10823 CVS Pharmacy, Inc. #04472 FL Pharmacy (850) 584-5847 105 West Hampton Springs Ave, Perry, FL 32347 Perry Taylor 32347 
{
    "unstructured": "09:00AM-08:00PM Mon-Fri, 10:00AM-06:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/004472 
[
    "Pfizer"
]
 
[
    "cvs:04472",
    "vaccinefinder:0ffc3ba0-186b-4054-ac8d-7d5b1782c6c0",
    "us_giscorps_vaccine_providers:8951aeb0-8704-4dac-a91a-e38963e47a73",
    "vaccinespotter_org:270747582",
    "fl_state:39228"
]
   https://www.vaccinatethestates.com/?lng=-83.58246&lat=30.11128#lfpfy lfpfy <Binary: 60 bytes> 30.11128 -83.58246
18902 Steinhatchee Drugs #Ms1000221 FL Pharmacy (352) 498-0680 102 9Th St Se, Steinhatchee, FL 32359 Steinhatchee Taylor 32359 
{
    "unstructured": "8:00 AM - 7:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:3c9cd20a-1e95-46a0-977a-ea70653a85df"
]
   https://www.vaccinatethestates.com/?lng=-83.37954&lat=29.67595#lhmzh lhmzh <Binary: 60 bytes> 29.67595 -83.37954
19430 Jay'S Pharmacy #Ms1002807 FL Pharmacy 850-584-7800 828 South Jefferson Street, Perry, FL 32347 Perry Taylor 32347 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:fb0bf99a-d9b6-4a11-8f10-fa31e30ae5fa",
    "vaccinefinder_org:fb0bf99a-d9b6-4a11-8f10-fa31e30ae5fa"
]
   https://www.vaccinatethestates.com/?lng=-83.58174&lat=30.11204#lhrcd lhrcd <Binary: 60 bytes> 30.11204 -83.58174
23588 Winn-Dixie #104 FL Pharmacy 850-584-5616 2057 S. Byron Butler Pkwy Suite 1, Perry, FL 32348 Perry Taylor 32348 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 6:00PM Sat, 10:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:5bc1141b-1123-4c45-a6b5-2bd32e2f2462",
    "vaccinefinder_org:5bc1141b-1123-4c45-a6b5-2bd32e2f2462",
    "winn_dixie:104",
    "us_carbon_health:b1fbcb6c-8390-4939-b447-04c408cfffea",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-83.58544&lat=30.09798#lkrkc lkrkc <Binary: 60 bytes> 30.09798 -83.58544
30134 Walgreens Co. #12578 FL Pharmacy 850-584-2627 2117 S Byron Butler Pkwy, Perry, FL 32348-6101 Perry Taylor 32348-6101 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:12578",
    "vaccinefinder:dc93ad3e-67d3-4dd0-a681-dce581458038",
    "vaccinefinder_org:dc93ad3e-67d3-4dd0-a681-dce581458038"
]
   https://www.vaccinatethestates.com/?lng=-83.58303&lat=30.09723#lpgbc lpgbc <Binary: 60 bytes> 30.09723 -83.58303
35523 Walmart Inc #10-5172 FL Pharmacy 8502234179 1900 S Jefferson St, Perry, FL 32348-5615 Perry Taylor 32348-5615 
{
    "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/5172 
[]
 
[
    "vaccinefinder:a96950e4-14ac-4270-9672-3c142df4ee46",
    "walmart:5172",
    "_tag_provider:walmart",
    "us_carbon_health:70522496-256a-42d3-8974-93bcf881aa59"
]
   https://www.vaccinatethestates.com/?lng=-83.57995&lat=30.10221#lqqcc lqqcc <Binary: 60 bytes> 30.10221 -83.57995
60122 Florida Department of Health in Taylor County FL Unknown   1215 N Peacock Avenue Perry, FL 32347 Perry Taylor 32347 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40285"
]
   https://www.vaccinatethestates.com/?lng=-83.57683&lat=30.12726#lzwcg lzwcg <Binary: 60 bytes> 30.12726 -83.57683
60770 Doctors' Memorial Hospital Steinhatchee Clinic FL Unknown   1209 1st Avenue South Steinhatchee, FL 32359 Steinhatchee Taylor 32359 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39227"
]
   https://www.vaccinatethestates.com/?lng=-83.37485&lat=29.67290#lzyrc lzyrc <Binary: 60 bytes> 29.6729 -83.37485
61339 Doctors' Memorial Hospital Medical Plaza FL Unknown   555 N. Byron Butler Parkway Perry, FL 32347 Perry Taylor 32347 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:39225"
]
   https://www.vaccinatethestates.com/?lng=-83.59767&lat=30.12724#lcbbxt lcbbxt <Binary: 60 bytes> 30.12724 -83.59767
61350 Forest Capital Hall FL Unknown   204 Forest Park Drive Perry, FL 32348 Perry Taylor 32348 
{
    "unstructured": null
}
 http://taylor.floridahealth.gov/ 
[]
 
[
    "fl_state:39226"
]
   https://www.vaccinatethestates.com/?lng=-83.56880&lat=30.08027#lcbbyk lcbbyk <Binary: 60 bytes> 30.08027 -83.5688

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;