locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Montezuma" and state = "CO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, zip_code, hours, vaccines_offered, last_verified_by_vts (date), 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
7712 Safeway Pharmacy #1892 CO Pharmacy 970-564-1353 1580 E. Main Street, Cortez, CO 81321 Cortez Montezuma 81321 
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 06:00PM Sat, 10:00AM - 06:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:282e74f8-7588-4118-a228-361260e2b9d0",
    "vaccinefinder_org:282e74f8-7588-4118-a228-361260e2b9d0",
    "safeway:1892",
    "us_giscorps_vaccine_providers:3e9afa4b-0730-4a58-9696-9ab5ad914cc0",
    "vaccinespotter_org:1046579",
    "_tag_provider:safeway",
    "us_carbon_health:67ac29f2-87ad-4533-8f01-f90da8e9a43f"
]
   https://www.vaccinatethestates.com/?lng=-108.56580&lat=37.35044#ldwbk ldwbk <Binary: 60 bytes> 37.35044 -108.5658
16058 City Market Pharmacy #62500408 CO Pharmacy (970) 565-6466 508 E Main St, Cortez, CO 81321 Cortez Montezuma 81321 
{
    "unstructured": "9:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 10:00 AM - 5:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:df559ad0-6859-4a04-b21c-b560ae99b350",
    "vaccinefinder_org:df559ad0-6859-4a04-b21c-b560ae99b350",
    "us_giscorps_vaccine_providers:97fc56f7-0724-4b3a-847a-f19d711a7082",
    "vaccinespotter_org:9104943"
]
   https://www.vaccinatethestates.com/?lng=-108.57786&lat=37.34994#lgwww lgwww <Binary: 60 bytes> 37.34994 -108.57786
29222 Walgreens Co. #10370 CO Pharmacy 970-564-9165 1671 E Main St, Cortez, CO 81321-3033 Cortez Montezuma 81321-3033 
{
    "unstructured": "08:00AM - 10:00PM Mon-Fri, 09:00AM - 9:00PM Sat-Sun"
}
 https://www.walgreens.com 
[
    "Johnson & Johnson"
]
 
[
    "walgreens:10370",
    "vaccinefinder:68ff41ee-650b-422e-990d-ddf51da52067",
    "vaccinefinder_org:68ff41ee-650b-422e-990d-ddf51da52067"
]
   https://www.vaccinatethestates.com/?lng=-108.56441&lat=37.34833#lpbmc lpbmc <Binary: 60 bytes> 37.34833 -108.56441
32812 Walmart Inc #10-0966 CO Pharmacy 9705656138 1835 E Main St, Cortez, CO 81321-3037 Cortez Montezuma 81321-3037 
{
    "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/966 
[
    "Moderna"
]
 
[
    "vaccinefinder:c6a1ab74-560b-4559-a3f6-2e6cdb741203",
    "walmart:966",
    "us_carbon_health:e4c22b15-c37b-472b-a68a-cd83a8fa115d",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-108.56209&lat=37.34620#lpymq lpymq <Binary: 60 bytes> 37.3462 -108.56209
56714 Montezuma County Public Health Department CO Unknown (970) 565-3056 106 W North St Cortez, CO 81321 Cortez Montezuma 81321 
{
    "unstructured": null
}
 https://www.facebook.com/Montezuma-County-Colorado-2285304624842661/ 
[]
 
[
    "us_giscorps_vaccine_providers:cf6fd84d-b0fc-4df7-922d-61fe83c2f653",
    "us_carbon_health:3ea77a38-5703-408a-ace4-9730d5e91d39"
]
 2021-05-13T22:53:32.775043+00:00 https://www.vaccinatethestates.com/?lng=-108.58699&lat=37.34988#lyyrg lyyrg <Binary: 60 bytes> 37.34988 -108.58699
62318 Southwest Memorial Hospital CO Unknown (970) 565-6666 1311 N Mildred Rd Cortez, CO 81321 Cortez Montezuma 81321 
{
    "unstructured": null
}
 https://www.swhealth.org/southwestmemorialhospital/ 
[]
 
[
    "us_giscorps_vaccine_providers:c1e85a9f-a866-48c2-9465-799226c99f4e",
    "us_carbon_health:477eb7eb-2570-4b6f-85fa-e62773c0d306"
]
   https://www.vaccinatethestates.com/?lng=-108.57377&lat=37.36189#lcbgrz lcbgrz <Binary: 60 bytes> 37.36189 -108.57377

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;