locations_expanded (view)

Data source: Vaccinate The States

9 rows where county = "Baldwin" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, vaccines_offered, 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
14418 Kroger Pharmacy #01100694 GA Pharmacy (478) 414-2145 2809 N. Columbia St., Milledgeville, GA 31061 Milledgeville Baldwin 31061 
{
    "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:31c81ed2-bad9-4ffa-80cd-8494920baa36",
    "vaccinefinder_org:31c81ed2-bad9-4ffa-80cd-8494920baa36",
    "kroger:1100694",
    "vaccinespotter_org:9103159"
]
   https://www.vaccinatethestates.com/?lng=-83.27437&lat=33.15350#lgkkg lgkkg <Binary: 60 bytes> 33.1535 -83.27437
29445 Walgreens Co. #10832 GA Pharmacy 478-414-1168 2350 N Columbia St, Milledgeville, GA 31061-2091 Milledgeville Baldwin 31061-2091 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:10832",
    "vaccinefinder:ca331989-977c-4119-9f8f-ac2c15506ae3",
    "vaccinefinder_org:ca331989-977c-4119-9f8f-ac2c15506ae3",
    "_tag_provider:walgreens",
    "us_carbon_health:e4336839-00ef-4bcb-914b-d5c2c31ad998"
]
   https://www.vaccinatethestates.com/?lng=-83.25491&lat=33.10836#lpchb lpchb <Binary: 60 bytes> 33.10836 -83.25491
32952 Walmart Inc #10-1121 GA Pharmacy 4784530667 2592 N Columbia St, Milledgeville, GA 31061-8709 Milledgeville Baldwin 31061-8709 
{
    "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/1121 
[
    "Moderna"
]
 
[
    "vaccinefinder:94e7dbf9-eec1-470f-9437-679ab8e41f80",
    "walmart:1121",
    "us_carbon_health:ddd3bcf6-921e-4acf-aac9-ef00fa14fe9c",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-83.26561&lat=33.11716#lpzbh lpzbh <Binary: 60 bytes> 33.11716 -83.26561
51451 CVS Pharmacy GA Unknown (478) 452-3566 423 South Wayne Street Milledgeville, GA 31061 Milledgeville Baldwin 31061 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:a6db004f-7bfe-4911-b619-2c65cb1487c6",
    "vaccinespotter_org:270225590"
]
   https://www.vaccinatethestates.com/?lng=-83.22626&lat=33.07613#lxqwt lxqwt <Binary: 60 bytes> 33.07613 -83.22626
51972 Gordon Drug Health Mart Pharmacy GA Unknown   240 MILLEDGEVILLE ROAD Gordon, GA 31031 Gordon Baldwin 31031 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141553745"
]
   https://www.vaccinatethestates.com/?lng=-83.25550&lat=33.00206#lxtxt lxtxt <Binary: 60 bytes> 33.00206 -83.2555
52127 BALDWIN COUNTY HEALTH DEPARTMENT GA Unknown 478-445-4274 953 Barrows Ferry Road, NE Milledgeville, GA 31061 Milledgeville Baldwin 31061 
{
    "unstructured": null
}
 http://nowebsite.nothing.com 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:9f8f7667-c626-4de2-ae14-b13167116b82"
]
   https://www.vaccinatethestates.com/?lng=-83.22304&lat=33.09613#lxwmq lxwmq <Binary: 60 bytes> 33.09613 -83.22304
59716 CVS Pharmacy in MILLEDGEVILLE, GA GA Unknown   960 N COLUMBIA ST MILLEDGEVILLE, GA 31061 MILLEDGEVILLE Baldwin 31061 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:371686458"
]
   https://www.vaccinatethestates.com/?lng=-83.23791&lat=33.09187#lzrmw lzrmw <Binary: 60 bytes> 33.09187 -83.23791
64433 Medical Arts Pharmacy GA Unknown (478) 452-1222 650 North Cobb Street Milledgeville Milledgeville, GA 31061 Milledgeville Baldwin 31061 
{
    "unstructured": null
}
 https://www.mygnp.com/pharmacies/programs/covid-19-vaccine/?state=ga 
[]
 
[
    "us_giscorps_vaccine_providers:24f88223-8d59-4568-883f-e9987834d8bd"
]
   https://www.vaccinatethestates.com/?lng=-83.24414&lat=33.08701#lcbwzq lcbwzq <Binary: 60 bytes> 33.08701 -83.24414
65974 Baldwin County Health Department (COVID Vaccine) GA Unknown (478) 749-0179 100 Ireland Drive Milledgeville, GA 31061 Milledgeville Baldwin 31061 
{
    "unstructured": null
}
   
[]
 
[
    "us_carbon_health:cf74bec6-2eec-466c-a716-9f71d16e0a91"
]
   https://www.vaccinatethestates.com/?lng=-83.25093&lat=33.09020#lccfbb lccfbb <Binary: 60 bytes> 33.0902 -83.25093

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;