locations_expanded (view)

Data source: Vaccinate The States

9 rows where county = "Grand" 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
7598 Safeway Pharmacy #1568 CO Pharmacy 970-726-6920 40 Country Rd #804, Fraser, CO 80442 Fraser Grand 80442 
{
    "unstructured": "09:00AM - 07:00PM Mon-Fri, 09:00AM - 06:00PM Sat, 10:00AM - 06:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Moderna"
]
 
[
    "vaccinefinder:c9f09c02-2b8f-41d3-a720-6ec3e6013cc1",
    "vaccinefinder_org:c9f09c02-2b8f-41d3-a720-6ec3e6013cc1",
    "safeway:1568",
    "us_giscorps_vaccine_providers:676659c3-e9c7-44a7-b230-14fc9e4b9984",
    "vaccinespotter_org:1046558",
    "us_carbon_health:a69445f4-110d-4793-9a62-06c9f8767037",
    "_tag_provider:safeway",
    "us_carbon_health:aac35f9b-98f8-4804-83f8-8b76c552e532"
]
   https://www.vaccinatethestates.com/?lng=-105.81087&lat=39.94556#ldtqg ldtqg <Binary: 60 bytes> 39.94556 -105.81087
16083 City Market Pharmacy #62500446 CO Pharmacy (970) 887-7150 1001 Thompson Rd, Granby, CO 80446 Granby Grand 80446 
{
    "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 
[]
 
[
    "vaccinefinder:840c0180-0c6e-4e6f-ab19-0b4912f60528",
    "vaccinefinder_org:840c0180-0c6e-4e6f-ab19-0b4912f60528",
    "vaccinespotter_org:9613239"
]
   https://www.vaccinatethestates.com/?lng=-105.92942&lat=40.06285#lgwyh lgwyh <Binary: 60 bytes> 40.06285 -105.92942
44987 Middle Park High School CO Unknown   795 N Second St Granby, CO 80446 Granby Grand 80446 
{
    "unstructured": null
}
 https://www.comassvax.org/clinic/search 
[]
 
[
    "vaccinespotter_org:190606054"
]
   https://www.vaccinatethestates.com/?lng=-105.92850&lat=40.07390#ltzfc ltzfc <Binary: 60 bytes> 40.0739 -105.9285
58853 Grand County Public Health CO Unknown (970) 725-3288 150 Moffat Ave Hot Sulphur Springs, CO 80451 Hot Sulphur Springs Grand 80451 
{
    "unstructured": null
}
 https://www.co.grand.co.us/vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:b9404f3f-0b80-417b-ab9b-89712e40c4e9"
]
   https://www.vaccinatethestates.com/?lng=-106.10143&lat=40.07197#lzmcr lzmcr <Binary: 60 bytes> 40.07197 -106.10143
60391 Byers Peak Family Medicine CO Unknown (970) 722-0300 78878 US Highway 40 Winter Park, CO 80482 Winter Park Grand 80482 
{
    "unstructured": null
}
 http://www.byerspeakfm.com 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:ace4e736-8db5-428e-be8b-d92ce7cbf2be",
    "vaccinespotter_org:261721295"
]
   https://www.vaccinatethestates.com/?lng=-105.78560&lat=39.91865#lzxdh lzxdh <Binary: 60 bytes> 39.91865 -105.7856
60504 Middle Park Kremmling Hospital CO Unknown (970) 724-3442 214 4th St Kremmling, CO 80459 Kremmling Grand 80459 
{
    "unstructured": null
}
 http://middleparkhealth.org 
[]
 
[
    "us_giscorps_vaccine_providers:e666c581-9934-4de3-b6a2-19d51819e87c"
]
   https://www.vaccinatethestates.com/?lng=-106.39044&lat=40.05692#lzxqm lzxqm <Binary: 60 bytes> 40.05692 -106.39044
62285 Middle Park Health Granby CO Unknown (970) 887-5800 1000 Granby Park Dr. Granby, CO 80446 Granby Grand 80446 
{
    "unstructured": null
}
 https://middleparkhealth.org/ 
[]
 
[
    "us_giscorps_vaccine_providers:b826a4f6-a13f-4602-ac09-dd3f380430f2"
]
   https://www.vaccinatethestates.com/?lng=-105.92571&lat=40.07644#lcbgpy lcbgpy <Binary: 60 bytes> 40.07644 -105.92571
62365 Fraser Medical Clinic CO Unknown   45 CR 804 Fraser, CO 80442 Fraser Grand 80442 
{
    "unstructured": null
}
 https://www.comassvax.org/clinic/search 
[]
 
[
    "vaccinespotter_org:214471370"
]
   https://www.vaccinatethestates.com/?lng=-105.81720&lat=39.94500#lcbgxy lcbgxy <Binary: 60 bytes> 39.945 -105.8172
62372 Denver Health East Grand Community Health CO Unknown (970) 726-4299 145 Parsenn Rd. Winter Park, CO 80482 Winter Park Grand 80482 
{
    "unstructured": null
}
 https://www.denverhealth.org/patients-visitors/coronavirus 
[]
 
[
    "us_giscorps_vaccine_providers:cf02764b-d595-4845-af1e-789c7a6ee113",
    "us_carbon_health:78a703a9-16f8-43c9-bc8b-80d55d7ac122"
]
   https://www.vaccinatethestates.com/?lng=-105.76311&lat=39.88587#lcbgyh lcbgyh <Binary: 60 bytes> 39.88587 -105.76311

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;