locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Liberty" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, 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
9281 Hinesville Pharmacy #110407 GA Pharmacy (912) 876-8125 481 Elma G Miles Parkway, Hinesville, GA 31313 Hinesville Liberty 31313 
{
    "unstructured": "9:00 AM - 6:30 PM Mon-Fri, 9:00 AM - 2:00 PM Sat, Closed Sun"
}
 https://coastalpharmacyinc.com/hsp/ 
[]
 
[
    "vaccinefinder:bce96412-079c-487e-afaf-2d347049f41a",
    "vaccinefinder_org:bce96412-079c-487e-afaf-2d347049f41a",
    "us_carbon_health:8858bf7f-e716-4e51-b2ad-c32cd727907c",
    "us_carbon_health:8c673d2a-7d69-441b-ae85-4f92da091a48"
]
   https://www.vaccinatethestates.com/?lng=-81.60321&lat=31.84020#lfddy lfddy <Binary: 60 bytes> 31.8402 -81.60321
12158 Coastal Drug Company #1123657 GA Pharmacy (912) 884-9255 204 Butler Avenue, Midway, GA 31320 Midway Liberty 31320 
{
    "unstructured": "9:00 AM - 6:30 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 http://COASTALDRUGCOMPANY.COM 
[]
 
[
    "vaccinefinder:a7782ad9-1287-4a5d-a4d1-48f89d1b298a"
]
   https://www.vaccinatethestates.com/?lng=-81.41822&lat=31.80260#lfxmp lfxmp <Binary: 60 bytes> 31.8026 -81.41822
14370 Kroger Pharmacy #01100487 GA Pharmacy (912) 876-6675 555 W Oglethorpe Hwy, Hinesville, GA 31313 Hinesville Liberty 31313 
{
    "unstructured": "8:00 AM - 8:00 PM Mon-Fri, 9:00 AM - 7:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:23ffce91-f13d-4028-bdca-4298e105debf",
    "vaccinefinder_org:23ffce91-f13d-4028-bdca-4298e105debf",
    "kroger:1100487",
    "vaccinespotter_org:9103004"
]
   https://www.vaccinatethestates.com/?lng=-81.59723&lat=31.83612#lgkfg lgkfg <Binary: 60 bytes> 31.83612 -81.59723
32718 Walmart Inc #10-0862 GA Pharmacy 9123693600 751 W Oglethorpe Hwy, Hinesville, GA 31313-4416 Hinesville Liberty 31313-4416 
{
    "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/862 
[
    "Moderna"
]
 
[
    "vaccinefinder:e893b363-b647-44bf-847d-38a786ff21bb",
    "walmart:862",
    "_tag_provider:walmart",
    "us_carbon_health:ec05a74d-32e3-4748-9f42-f130c08def14"
]
   https://www.vaccinatethestates.com/?lng=-81.60179&lat=31.82585#lpyct lpyct <Binary: 60 bytes> 31.82585 -81.60179
35184 Walmart Inc #10-4519 GA Pharmacy 9122556010 801-A East General Stewart Way, Hinesville, GA 31313-2661 Hinesville Liberty 31313-2661 
{
    "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 - 4:00 PM Sun"
}
 https://www.walmart.com/store/4519 
[
    "Moderna"
]
 
[
    "vaccinefinder:4f909ed2-f612-466b-a7c6-7664551410da",
    "walmart:4519",
    "us_carbon_health:a83c03bd-8e2e-4d46-ad85-d394a6e062e4",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.57847&lat=31.85125#lqmty lqmty <Binary: 60 bytes> 31.85125 -81.57847
35188 Walmart Inc #10-4525 GA Pharmacy 9128779810 1422 W Oglethorpe Hwy Ste A, Hinesville, GA 31313-5645 Hinesville Liberty 31313-5645 
{
    "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 - 4:00 PM Sun"
}
 https://www.walmart.com/store/4525 
[
    "Moderna"
]
 
[
    "vaccinefinder:570eacac-900f-49b1-928d-f04a86a40bdf",
    "us_carbon_health:a614a8a3-d372-4577-9aa8-67e6daa2e3ba",
    "walmart:4525",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.60590&lat=31.79643#lqmwd lqmwd <Binary: 60 bytes> 31.79643 -81.6059
45477 CVS Pharmacy in HINESVILLE, GA GA Unknown   114 EAST GENERAL SCREVEN WAY HINESVILLE, GA 31313 HINESVILLE Liberty 31313 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[
    "Johnson & Johnson"
]
 
[
    "vaccinespotter_org:270450423"
]
   https://www.vaccinatethestates.com/?lng=-81.59719&lat=31.84085#lwcdf lwcdf <Binary: 60 bytes> 31.84085 -81.59719

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;