locations_expanded (view)

Data source: Vaccinate The States

23 rows where county = "Mesa" and state = "CO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, phone_number, 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
7410 Safeway Pharmacy #897 CO Pharmacy 970-257-0233 2512 Broadway, Grand Junction, CO 81507 Grand Junction Mesa 81507 
{
    "unstructured": "09:00AM - 08:00PM Mon-Fri, 09:00AM - 05:00PM Sat, 10:00AM - 05:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:f22e8058-e067-469b-a4a2-e8804742bdef",
    "vaccinefinder_org:f22e8058-e067-469b-a4a2-e8804742bdef",
    "safeway:897",
    "us_giscorps_vaccine_providers:ddf1f0da-f962-44be-aafd-ed0103a42aa2",
    "vaccinespotter_org:1048067",
    "_tag_provider:safeway",
    "us_carbon_health:fb0a14d7-dd32-4bb1-852a-a3c1e7d07b79"
]
   https://www.vaccinatethestates.com/?lng=-108.58857&lat=39.06692#ldrxp ldrxp <Binary: 60 bytes> 39.06692 -108.58857
7575 Safeway Pharmacy #1533 CO Pharmacy 970-248-9871 2901 F Road, Grand Junction, CO 81504 Grand Junction Mesa 81504 
{
    "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 
[
    "Moderna"
]
 
[
    "vaccinefinder:870fd679-46e2-4d0b-bb73-7ce7410bdf6f",
    "vaccinefinder_org:870fd679-46e2-4d0b-bb73-7ce7410bdf6f",
    "safeway:1533",
    "us_giscorps_vaccine_providers:769a65bf-567f-47e3-b42e-214b6a9639e7",
    "vaccinespotter_org:1046554",
    "_tag_provider:safeway",
    "us_carbon_health:87e8dc67-1234-4657-b208-428485fbf0f7"
]
   https://www.vaccinatethestates.com/?lng=-108.51376&lat=39.09042#ldtmx ldtmx <Binary: 60 bytes> 39.09042 -108.51376
7839 Safeway Pharmacy #2625 CO Pharmacy 970-257-1392 681 Horizon Drive, Grand Junction, CO 81506 Grand Junction Mesa 81506 
{
    "unstructured": "09:00AM - 08:00PM Mon-Fri, 09:00AM - 05:00PM Sat, 10:00AM - 05:00PM Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:33479f34-e568-44a6-b029-4710bf81c1d0",
    "safeway:2625",
    "vaccinefinder_org:33479f34-e568-44a6-b029-4710bf81c1d0",
    "us_giscorps_vaccine_providers:8b8030f3-a03d-41a2-a64f-853611072399",
    "vaccinespotter_org:1046593",
    "_tag_provider:safeway",
    "us_carbon_health:bab8c79a-88dd-42f7-9000-f3b946941a7e"
]
   https://www.vaccinatethestates.com/?lng=-108.55133&lat=39.10399#ldwph ldwph <Binary: 60 bytes> 39.10399 -108.55133
16054 City Market Pharmacy #62500401 CO Pharmacy (970) 245-1215 2770 Hwy 50 S, Grand Junction, CO 81503 Grand Junction Mesa 81503 
{
    "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:31ca8c48-8c10-4231-a7b4-7cfab89ca1e8",
    "vaccinefinder_org:31ca8c48-8c10-4231-a7b4-7cfab89ca1e8"
]
   https://www.vaccinatethestates.com/?lng=-108.53903&lat=39.04006#lgwwp lgwwp <Binary: 60 bytes> 39.04006 -108.53903
16061 City Market Pharmacy #62500413 CO Pharmacy (970) 858-9508 135 S Plum St, Fruita, CO 81521 Fruita Mesa 81521 
{
    "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:0cd0df89-9f47-4e3c-acd9-a2b54a2e55cf",
    "vaccinefinder_org:0cd0df89-9f47-4e3c-acd9-a2b54a2e55cf",
    "us_giscorps_vaccine_providers:fa08fe41-4dfe-4b41-9382-fd76288a8efa",
    "vaccinespotter_org:9104946",
    "us_carbon_health:3da5e006-9262-4b39-9c90-e59aed154367"
]
   https://www.vaccinatethestates.com/?lng=-108.73521&lat=39.15776#lgwwz lgwwz <Binary: 60 bytes> 39.15776 -108.73521
16069 City Market Pharmacy #62500425 CO Pharmacy (970) 434-9651 569 32Nd Rd, Grand Junction, CO 81504 Grand Junction Mesa 81504 
{
    "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:39245898-4c45-4c13-b3d6-4c6da8b68cd9",
    "vaccinefinder_org:39245898-4c45-4c13-b3d6-4c6da8b68cd9"
]
   https://www.vaccinatethestates.com/?lng=-108.46210&lat=39.08700#lgwxm lgwxm <Binary: 60 bytes> 39.087 -108.4621
16081 City Market Pharmacy #62500444 CO Pharmacy (970) 628-7563 2600 North 12Th Street, Grand Junction, CO 81501 Grand Junction Mesa 81501 
{
    "unstructured": "8: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",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:8d42c11b-fff1-4b85-ba57-5bc977c7f8f0",
    "vaccinefinder_org:8d42c11b-fff1-4b85-ba57-5bc977c7f8f0",
    "vaccinespotter_org:9104947"
]
   https://www.vaccinatethestates.com/?lng=-108.55114&lat=39.09065#lgwyf lgwyf <Binary: 60 bytes> 39.09065 -108.55114
16085 City Market Pharmacy #62500451 CO Pharmacy (970) 244-8110 630 24 Road, Grand Junction, CO 81505 Grand Junction Mesa 81505 
{
    "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:f2b27049-d232-4040-b69d-e89ea5c1d653",
    "vaccinefinder_org:f2b27049-d232-4040-b69d-e89ea5c1d653",
    "vaccinespotter_org:9104945"
]
   https://www.vaccinatethestates.com/?lng=-108.60753&lat=39.09648#lgwym lgwym <Binary: 60 bytes> 39.09648 -108.60753
27751 Walgreens Co. #6108 CO Pharmacy 970-523-0193 572 32 Rd, Clifton, CO 81520-7606 Clifton Mesa 81520-7606 
{
    "unstructured": "08:00AM - 10:00PM Mon-Fri, 09:00AM - 9:00PM Sat-Sun"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:6108",
    "vaccinefinder:e1f6987c-7556-4961-accb-f91973773c6d",
    "vaccinefinder_org:e1f6987c-7556-4961-accb-f91973773c6d"
]
   https://www.vaccinatethestates.com/?lng=-108.45923&lat=39.08770#lmrtd lmrtd <Binary: 60 bytes> 39.0877 -108.45923
28952 Walgreens Co. #9769 CO Pharmacy 970-208-1014 2900 North Ave, Grand Junction, CO 81504-5315 Grand Junction Mesa 81504-5315 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Johnson & Johnson"
]
 
[
    "walgreens:9769",
    "vaccinefinder:460fda88-0bbd-4c00-bead-1bfdd5be7e12",
    "vaccinefinder_org:460fda88-0bbd-4c00-bead-1bfdd5be7e12"
]
   https://www.vaccinatethestates.com/?lng=-108.51450&lat=39.07787#lmzkf lmzkf <Binary: 60 bytes> 39.07787 -108.5145
29200 Walgreens Co. #10307 CO Pharmacy 970-208-1252 240 W Park Dr, Grand Junction, CO 81505-1450 Grand Junction Mesa 81505-1450 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:10307",
    "vaccinefinder:e47f377d-fdb8-407f-8778-b9b47793b894",
    "vaccinefinder_org:e47f377d-fdb8-407f-8778-b9b47793b894"
]
   https://www.vaccinatethestates.com/?lng=-108.57262&lat=39.09133#lpbht lpbht <Binary: 60 bytes> 39.09133 -108.57262
33091 Walmart Inc #10-1280 CO Pharmacy 9702416061 2881 North Ave, Grand Junction, CO 81501-5064 Grand Junction Mesa 81501-5064 
{
    "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/1280 
[
    "Moderna"
]
 
[
    "vaccinefinder:c84594ae-a363-4f5e-a984-9fd6acafd180",
    "_tag_provider:walmart",
    "us_carbon_health:74fef893-6dac-4965-9966-b3c75ec17fe0",
    "walmart:1280"
]
   https://www.vaccinatethestates.com/?lng=-108.51886&lat=39.07613#lpzqb lpzqb <Binary: 60 bytes> 39.07613 -108.51886
35170 Walmart Inc #10-4491 CO Pharmacy 9702080042 541 Warrior Way, Grand Junction, CO 81504-6401 Grand Junction Mesa 81504-6401 
{
    "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/4491 
[]
 
[
    "vaccinefinder:47dfd2ae-7ff7-4961-90e2-fd2c26e58949",
    "walmart:4491",
    "_tag_provider:walmart",
    "us_carbon_health:c2403801-81fa-403f-9b33-51683d80e49d"
]
   https://www.vaccinatethestates.com/?lng=-108.47409&lat=39.08352#lqmtb lqmtb <Binary: 60 bytes> 39.08352 -108.47409
35478 Walmart Inc #10-5099 CO Pharmacy 9702480031 2545 Rimrock Ave, Grand Junction, CO 81505-8664 Grand Junction Mesa 81505-8664 
{
    "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/5099 
[
    "Moderna"
]
 
[
    "vaccinefinder:0400a020-bc15-48fa-bb37-32f44c426df0",
    "walmart:5099",
    "_tag_provider:walmart",
    "us_carbon_health:aaeeb4d3-61ca-4200-a91f-74075ab2648d"
]
   https://www.vaccinatethestates.com/?lng=-108.58120&lat=39.07722#lqpyg lqpyg <Binary: 60 bytes> 39.07722 -108.5812
36030 Sams Club #10-6360 CO Pharmacy 9702439203 1040 Independent Ave, Grand Junction, CO 81505-7133 Grand Junction Mesa 81505-7133 
{
    "unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon-Fri, 9:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sat,  Sun"
}
 https://www.samsclub.com/club/6360 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:ffa4b344-4ddc-4605-bb42-0dfea00cbfe3",
    "us_carbon_health:4c1a33b2-b0ee-401f-84e1-e8eca3627d91",
    "_tag_provider:sams",
    "sams:6360"
]
   https://www.vaccinatethestates.com/?lng=-108.58305&lat=39.08289#lqtbx lqtbx <Binary: 60 bytes> 39.08289 -108.58305
37618 Mesa County PH CVS CO Pharmacy (970) 248-6900 159 Main St, Grand Junction, CO 81501 Grand Junction Mesa 81501 
{
    "unstructured": " Mon,  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 - 7:00 PM Sat,  Sun"
}
 https://health.mesacounty.us/covid19/vaccine/ 
[
    "Moderna",
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:a187b8eb-541f-4401-991f-a8c7e5eaed88",
    "us_carbon_health:83d0a4b7-e54f-4624-91e4-a5ea4d7f83c2"
]
   https://www.vaccinatethestates.com/?lng=-108.56988&lat=39.06697#lrcqb lrcqb <Binary: 60 bytes> 39.06697 -108.56988
49056 CVS Pharmacy, Inc. #16024 CO Unknown (970) 241-2477 2424 HIGHWAY 6 AND 50 GRAND JUNCTION, CO 81505 GRAND JUNCTION Mesa 81505 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:61814630-c55b-41ac-ab76-e987961d9bce",
    "cvs:16024"
]
   https://www.vaccinatethestates.com/?lng=-108.60170&lat=39.09357#lxbdb lxbdb <Binary: 60 bytes> 39.09357 -108.6017
53667 SCL Health St. Mary's Hospital CO Unknown (970) 298-2273 2635 N 7th St Grand Junction, CO 81501 Grand Junction Mesa 81501 
{
    "unstructured": null
}
 http://www.sclhealth.org/covidvaccine 
[]
 
[
    "us_giscorps_vaccine_providers:5886fc63-6295-4842-acac-771dd645988a",
    "us_carbon_health:f5243cae-6aaa-4cd7-b038-1aefd1fc3183"
]
   https://www.vaccinatethestates.com/?lng=-108.56271&lat=39.09048#lydqc lydqc <Binary: 60 bytes> 39.09048 -108.56271
53671 Mesa County Public Health Red Building CO Unknown (970) 248-6900 215 N. Plum St. Fruita Colo, CO 81521 Colo Mesa 81521 
{
    "unstructured": null
}
 https://health.mesacounty.us/covid19/vaccine/ 
[]
 
[
    "us_giscorps_vaccine_providers:d5dfb1bb-2cba-4a86-8c15-15e4a75b8b6d"
]
   https://www.vaccinatethestates.com/?lng=-108.73516&lat=39.16110#lydqh lydqh <Binary: 60 bytes> 39.1611 -108.73516
53798 Walgreens Co. #11187 CO Unknown 970-858-0147 316 W ASPEN AVE FRUITA, CO 81521 FRUITA Mesa 81521 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Pfizer"
]
 
[
    "vaccinefinder_org:e60e4d7a-d5b7-4f83-aff9-a44477faf087",
    "walgreens:11187",
    "vaccinespotter_org:2732342"
]
   https://www.vaccinatethestates.com/?lng=-108.73662&lat=39.15814#lyfch lyfch <Binary: 60 bytes> 39.15814 -108.73662
62268 City Market Grand Junction CO Unknown   2770 Highway 50 Grand Jucntion, CO 81503 Grand Jucntion Mesa 81503 
{
    "unstructured": null
}
 https://www.kroger.com/i/coronavirus-update/vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:02cd046f-2bd4-4ba0-b0e2-45158ceaa9da"
]
   https://www.vaccinatethestates.com/?lng=-108.56600&lat=39.04900#lcbgmx lcbgmx <Binary: 60 bytes> 39.049 -108.566
62308 Colorado West Healthcare CO Unknown (970) 242-0920 2351 G Rd Grand Junction, CO 81505 Grand Junction Mesa 81505 
{
    "unstructured": null
}
 http://yourcommunityhospital.com 
[]
 
[
    "us_giscorps_vaccine_providers:76d8d083-e0e9-4a07-b034-cdd71628c2f1",
    "us_carbon_health:38fc1b45-60f8-47cc-ac70-50d5fc03ba23"
]
   https://www.vaccinatethestates.com/?lng=-108.61527&lat=39.10520#lcbgrh lcbgrh <Binary: 60 bytes> 39.1052 -108.61527
62335 Colorado Canyons Hospital and Medical Center CO Unknown (970) 858-3900 300 W Ottley Ave Fruita, CO 81521 Fruita Mesa 81521 
{
    "unstructured": null
}
 http://coloradocanyonshospital.com 
[]
 
[
    "us_giscorps_vaccine_providers:8dd2411e-f504-49d8-84fa-6723ca32cdca",
    "us_carbon_health:e73f2c3f-cc6a-4501-a9f9-c575bfa5397e"
]
   https://www.vaccinatethestates.com/?lng=-108.73664&lat=39.16365#lcbgwb lcbgwb <Binary: 60 bytes> 39.16365 -108.73664

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;