locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Bourbon" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
10598 CVS Pharmacy, Inc. #03016 KY Pharmacy (859) 988-9753 101 Lacy Lane, Paris, KY 40361 Paris Bourbon 40361 
{
    "unstructured": "08:00AM-10:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/003016 
[
    "Pfizer"
]
 
[
    "cvs:03016",
    "vaccinefinder:a1b480a9-6723-4a41-812a-a7c0789b21b6",
    "us_giscorps_vaccine_providers:cdec24b3-491b-4a0e-9c45-5bd7d2eb7dae",
    "vaccinespotter_org:270374036"
]
   https://www.vaccinatethestates.com/?lng=-84.27588&lat=38.19310#lfmhx lfmhx <Binary: 60 bytes> 38.1931 -84.27588
16673 Bourbon County Health Department KY Pharmacy (859) 987-1915 341 East Main Street, Paris, KY 40361 Paris Bourbon 40361 
{
    "unstructured": "8:00 AM - 4:30 PM Mon-Fri"
}
 http://bourboncohd.org 
[
    "Moderna"
]
 
[
    "vaccinefinder:445e84ff-b518-434f-b33a-1570345f26c7",
    "ky_govstatus:342",
    "vaccinefinder_org:445e84ff-b518-434f-b33a-1570345f26c7",
    "us_carbon_health:e7628a0a-8247-44fc-b236-cd9e78227f5c"
]
   https://www.vaccinatethestates.com/?lng=-84.23956&lat=38.21919#lgzfp lgzfp <Binary: 60 bytes> 38.21919 -84.23956
16770 Bourbontown Pharmacy KY Pharmacy   1822 Main Street, Paris, KY 40361 Paris Bourbon 40361 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:ee6ca122-e23b-432d-9c0f-702f7965570d",
    "ky_govstatus:338",
    "vaccinefinder_org:ee6ca122-e23b-432d-9c0f-702f7965570d",
    "us_carbon_health:fe2e358c-290e-40b2-acc9-446a2500e60e"
]
   https://www.vaccinatethestates.com/?lng=-84.26538&lat=38.19988#lgzqq lgzqq <Binary: 60 bytes> 38.19988 -84.26538
16857 Bluegrass Family Clinic KY Pharmacy (859) 987-5016 22 Clinic Drive, Paris, KY 40361 Paris Bourbon 40361 
{
    "unstructured": "8:30 AM - 5:00 PM Mon-Fri"
}
 http://www.bourbonmedicalgroup.com/ 
[]
 
[
    "vaccinefinder:bd71ca4c-9c2b-4f8b-a55b-c905497b1617",
    "vaccinefinder_org:bd71ca4c-9c2b-4f8b-a55b-c905497b1617",
    "us_carbon_health:a45e72b7-e267-4892-83b9-ffddc0ed0578"
]
   https://www.vaccinatethestates.com/?lng=-84.23665&lat=38.22133#lgzzc lgzzc <Binary: 60 bytes> 38.22133 -84.23665
31155 Walgreens Co. #18005 KY Pharmacy 859-987-1210 103 Ash Dr, Paris, KY 40361-2256 Paris Bourbon 40361-2256 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:18005",
    "vaccinefinder:c4b46ece-01ea-4ac5-8b8e-2e6872427cf1",
    "vaccinefinder_org:c4b46ece-01ea-4ac5-8b8e-2e6872427cf1",
    "_tag_provider:walgreens",
    "us_carbon_health:63eebb36-834a-4365-81bf-b2b64d30e682"
]
   https://www.vaccinatethestates.com/?lng=-84.27439&lat=38.19889#lpmzy lpmzy <Binary: 60 bytes> 38.19889 -84.27439
32393 Walmart Inc #10-0493 KY Pharmacy 8599872817 305 Letton Dr, Paris, KY 40361-2252 Paris Bourbon 40361-2252 
{
    "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 - 6:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/493 
[]
 
[
    "vaccinefinder:c5ade451-8203-45ad-805c-667f939b759c",
    "walmart:493",
    "_tag_provider:walmart",
    "us_carbon_health:73b3356d-4744-49d3-ab0b-1a9d9d3b3afd"
]
   https://www.vaccinatethestates.com/?lng=-84.27808&lat=38.19701#lpwxk lpwxk <Binary: 60 bytes> 38.19701 -84.27808

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;