locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Delta" and state = "CO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, website, 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
7704 Safeway Pharmacy #1863 CO Pharmacy 970-874-9091 1550 Highway 92, Delta, CO 81416 Delta Delta 81416 
{
    "unstructured": "09:00AM - 07:00PM Mon-Fri, 09:00AM - 05:00PM Sat, 10:00AM - 04:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Moderna"
]
 
[
    "vaccinefinder:bab71c2e-f66b-40b8-b9bf-b169fc4d6582",
    "vaccinefinder_org:bab71c2e-f66b-40b8-b9bf-b169fc4d6582",
    "safeway:1863",
    "us_giscorps_vaccine_providers:78a5363e-7052-4dfc-8ee9-e47f261f04b7",
    "vaccinespotter_org:1046576",
    "_tag_provider:safeway",
    "us_carbon_health:00dd0505-9fdb-49a5-bbf5-c10ef5a5897e"
]
   https://www.vaccinatethestates.com/?lng=-108.05171&lat=38.75139#ldtzy ldtzy <Binary: 60 bytes> 38.75139 -108.05171
16056 City Market Pharmacy #62500404 CO Pharmacy (970) 874-5771 122 Gunnison River Dr, Delta, CO 81416 Delta Delta 81416 
{
    "unstructured": "9:00 AM - 8:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 10:00 AM - 5:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:7c8ae5b9-a62e-4115-b954-a583cb53614f",
    "vaccinefinder_org:7c8ae5b9-a62e-4115-b954-a583cb53614f",
    "us_giscorps_vaccine_providers:43ddfebf-7ef9-42bf-8ac5-ca7efc0e6539",
    "vaccinespotter_org:9104928",
    "us_carbon_health:6ef7b148-bd14-4963-8d79-468144527797"
]
   https://www.vaccinatethestates.com/?lng=-108.07228&lat=38.74788#lgwwr lgwwr <Binary: 60 bytes> 38.74788 -108.07228
16071 City Market Pharmacy #62500429 CO Pharmacy (970) 872-2623 215 Sixth St, Hotchkiss, CO 81419 Hotchkiss Delta 81419 
{
    "unstructured": "9:00 AM - 8:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 10:00 AM - 5:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:11e9c4de-c734-41ae-a328-888d84fe3635",
    "vaccinefinder_org:11e9c4de-c734-41ae-a328-888d84fe3635",
    "us_giscorps_vaccine_providers:0b06e020-d238-43d6-aee1-8dc4f3578dc1",
    "vaccinespotter_org:9104924"
]
   https://www.vaccinatethestates.com/?lng=-107.71246&lat=38.79961#lgwxq lgwxq <Binary: 60 bytes> 38.79961 -107.71246
35730 Walmart Inc #10-5458 CO Pharmacy 9708741585 37 Stafford Ln, Delta, CO 81416-3465 Delta Delta 81416-3465 
{
    "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/5458 
[
    "Moderna"
]
 
[
    "vaccinefinder:e64a6091-2cf1-4b6f-b102-13501bb9596f",
    "_tag_provider:walmart",
    "us_carbon_health:60439323-2879-42e4-bf3d-8abd17d559b8",
    "walmart:5458"
]
   https://www.vaccinatethestates.com/?lng=-108.05412&lat=38.74919#lqqyb lqqyb <Binary: 60 bytes> 38.74919 -108.05412
57220 Hays Drugstore Mart CO Unknown   224 Grand Avenue Paonia, CO 81428 Paonia Delta 81428 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141584606"
]
   https://www.vaccinatethestates.com/?lng=-107.59800&lat=38.86820#lzbrf lzbrf <Binary: 60 bytes> 38.8682 -107.598
58985 Delta County Memorial Hospital CO Unknown (970) 874-7681 1501 E 3rd St Delta, CO 81416 Delta Delta 81416 
{
    "unstructured": null
}
 https://www.deltahospital.org/covid-19-vaccine/ 
[]
 
[
    "us_giscorps_vaccine_providers:0dcc6e8d-5c9f-43ca-bc25-3f650b45a3a9",
    "us_carbon_health:0a884b98-e17c-4ec2-ba63-3b5d49612c9c"
]
   https://www.vaccinatethestates.com/?lng=-108.04764&lat=38.74531#lzmqy lzmqy <Binary: 60 bytes> 38.74531 -108.04764
62204 Cedaredge Health Mart Pharmacy CO Unknown   215 W MAIN ST Cedaredge, CO 81413 Cedaredge Delta 81413 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141806155"
]
   https://www.vaccinatethestates.com/?lng=-107.92600&lat=38.90050#lcbgfx lcbgfx <Binary: 60 bytes> 38.9005 -107.926

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;