locations_expanded (view)

Data source: Vaccinate The States

11 rows where county = "Gadsden" 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
10696 CVS Pharmacy, Inc. #03624 FL Pharmacy (850) 875-3021 1208 W. Jefferson St., Quincy, FL 32351 Quincy Gadsden 32351 
{
    "unstructured": "09:00AM-08:00PM Mon-Fri, 10:00AM-06:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/003624 
[
    "Pfizer"
]
 
[
    "cvs:03624",
    "vaccinefinder:ccfc0304-184c-4565-9aec-f70a6c87964b",
    "vaccinespotter_org:270138058",
    "us_carbon_health:479c035c-e804-4eff-9710-dacb1f35f761"
]
   https://www.vaccinatethestates.com/?lng=-84.59171&lat=30.58857#lfmtz lfmtz <Binary: 60 bytes> 30.58857 -84.59171
13232 Buy Rite Drugs - Havana FL Pharmacy 850-539-8080 704 S Us Hwy 27, Havana, FL 32333 Havana Gadsden 32333 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:9bb6aff7-a1dc-4a63-8574-2bfc27295ed8",
    "vaccinefinder_org:9bb6aff7-a1dc-4a63-8574-2bfc27295ed8",
    "vaccinespotter_org:141693107"
]
   https://www.vaccinatethestates.com/?lng=-84.41969&lat=30.61624#lgctm lgctm <Binary: 60 bytes> 30.61624 -84.41969
23605 Winn-Dixie #184 FL Pharmacy 850-627-4686 1632 W. Jefferson St., Quincy, FL 32351 Quincy Gadsden 32351 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 1:00PM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:eccf368a-b8f8-4c21-be7a-d4fe802fbdef",
    "vaccinespotter_org:54272644",
    "vaccinefinder_org:eccf368a-b8f8-4c21-be7a-d4fe802fbdef",
    "winn_dixie:184",
    "us_giscorps_vaccine_providers:95168a48-0979-4f99-a828-b1efa201966a",
    "us_carbon_health:e223a3e1-0b9a-4801-bbd9-bd56fd193962",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-84.59770&lat=30.58704#lkrmd lkrmd <Binary: 60 bytes> 30.58704 -84.5977
29116 Walgreens Co. #10147 FL Pharmacy 850-627-7663 1217 W Jefferson St, Quincy, FL 32351-2125 Quincy Gadsden 32351-2125 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:10147",
    "vaccinefinder:5fe313d6-ebc2-4190-b6f3-b00d2f70fbcd",
    "vaccinefinder_org:5fe313d6-ebc2-4190-b6f3-b00d2f70fbcd"
]
   https://www.vaccinatethestates.com/?lng=-84.59206&lat=30.58743#lpbbm lpbbm <Binary: 60 bytes> 30.58743 -84.59206
32388 Walmart Inc #10-0488 FL Pharmacy 8508751661 1940 Pat Thomas Pkwy, Quincy, FL 32351-8785 Quincy Gadsden 32351-8785 
{
    "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/488 
[
    "Moderna"
]
 
[
    "vaccinefinder:8ba5ef58-764d-47ca-b439-12e38dae5cdd",
    "_tag_provider:walmart",
    "us_carbon_health:25c4d265-5c5a-4bb0-ad32-e310dc2aa9cf",
    "walmart:488"
]
   https://www.vaccinatethestates.com/?lng=-84.59541&lat=30.55718#lpwxc lpwxc <Binary: 60 bytes> 30.55718 -84.59541
45564 CVS Pharmacy, Inc. #05167 FL Unknown (850) 663-2268 12 DECATUR ST CHATTAHOOCHEE, FL 32324 CHATTAHOOCHEE Gadsden 32324 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:f90040df-ad8a-4cbf-b7da-fc3859b43ffd",
    "cvs:5167"
]
   https://www.vaccinatethestates.com/?lng=-84.84668&lat=30.70540#lwcmt lwcmt <Binary: 60 bytes> 30.7054 -84.84668
60778 Chattahoochee FL Unknown   35 Jefferson Street Chattahoochee, FL 32324 Chattahoochee Gadsden 32324 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:37843"
]
   https://www.vaccinatethestates.com/?lng=-84.84612&lat=30.70401#lzyrq lzyrq <Binary: 60 bytes> 30.70401 -84.84612
60815 Gadsden County Health Department FL Unknown   278 LaSalle LeFalle Drive Quincy, FL 32351 Quincy Gadsden 32351 
{
    "unstructured": null
}
 http://gadsden.floridahealth.gov/ 
[]
 
[
    "fl_state:37839"
]
   https://www.vaccinatethestates.com/?lng=-84.54867&lat=30.56716#lzywy lzywy <Binary: 60 bytes> 30.56716 -84.54867
61280 Neighborhood Health Service FL Unknown   604 EAST 5TH AVENUE Havana, FL 32333 Havana Gadsden 32333 
{
    "unstructured": null
}
 https://neighborhoodmedicalcenter.org/ 
[]
 
[
    "fl_state:39806"
]
   https://www.vaccinatethestates.com/?lng=-84.39625&lat=30.63750#lcbbqz lcbbqz <Binary: 60 bytes> 30.6375 -84.39625
61285 Capital Regional Medical Center - Gadsden Campus FL Unknown   23186 Blue Star Highway Quincy, FL 32351 Quincy Gadsden 32351 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:40122"
]
   https://www.vaccinatethestates.com/?lng=-84.54888&lat=30.56874#lcbbrg lcbbrg <Binary: 60 bytes> 30.56874 -84.54888
61465 Gretna FL Unknown   14833 Main Street Gretna, FL 32332 Gretna Gadsden 32332 
{
    "unstructured": null
}
   
[]
 
[
    "fl_state:37842"
]
   https://www.vaccinatethestates.com/?lng=-84.66099&lat=30.61134#lcbchq lcbchq <Binary: 60 bytes> 30.61134 -84.66099

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;