Data source: Vaccinate The States

28 rows where county = "Canyon" and state = "ID"

View and edit SQL

Suggested facets: location_type, phone_number, city, zip_code, hours, website, vaccines_offered, geometry, latitude, longitude, 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
7165 Sav-On Pharmacy #103 ID Pharmacy 208-459-1756 415 Cleveland Blvd, Caldwell, ID 83605 Caldwell Canyon 83605
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 07:00PM Sat, 10:00AM - 04:00PM Sun"
}
https://www.albertsons.com/pharmacy/covid-19.html
[
    "Moderna",
    "Johnson & Johnson"
]
[
    "vaccinefinder:3c6e4688-7bd3-42a7-830d-9c0e2a90e390",
    "vaccinefinder_org:3c6e4688-7bd3-42a7-830d-9c0e2a90e390",
    "sav_on:103",
    "us_giscorps_vaccine_providers:1a5850e0-2dcb-414a-adb5-ef66951a650e",
    "vaccinespotter_org:1046460",
    "_tag_provider:sav_on",
    "us_carbon_health:c91559d6-27f6-4785-8438-422cec226ce3"
]
  https://www.vaccinatethestates.com/?lng=-116.69294&lat=43.66718#ldqyd ldqyd <Binary: 60 bytes> 43.66718 -116.69294
7198 Sav-On Pharmacy #166 ID Pharmacy 208-454-0484 2500 Blaine St, Caldwell, ID 83605 Caldwell Canyon 83605
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 07:00PM Sat, 10:00AM - 04:00PM Sun"
}
https://www.albertsons.com/pharmacy/covid-19.html
[
    "Moderna"
]
[
    "vaccinefinder:66551e67-fb01-4485-b503-fe83f5146d88",
    "vaccinefinder_org:66551e67-fb01-4485-b503-fe83f5146d88",
    "sav_on:166",
    "us_giscorps_vaccine_providers:56bde99f-bc71-4e38-b143-5e7a85fe8b4f",
    "vaccinespotter_org:1046472",
    "_tag_provider:sav_on",
    "us_carbon_health:a46f2bb9-124c-44cc-9bb6-60136cf4999b"
]
  https://www.vaccinatethestates.com/?lng=-116.67105&lat=43.65220#ldrbf ldrbf <Binary: 60 bytes> 43.6522 -116.67105
7204 Sav-On Pharmacy #176 ID Pharmacy 208-463-2903 2400 12Th Avenue Rd, Nampa, ID 83686 Nampa Canyon 83686
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 07:00PM Sat, 10:00AM - 04:00PM Sun"
}
https://www.albertsons.com/pharmacy/covid-19.html
[
    "Moderna",
    "Johnson & Johnson"
]
[
    "vaccinefinder:ee75239e-95e7-4279-a298-e2329f5b62a1",
    "vaccinefinder_org:ee75239e-95e7-4279-a298-e2329f5b62a1",
    "sav_on:176",
    "us_giscorps_vaccine_providers:0ed54af2-6a30-41fc-ad26-91576fd4aa3c",
    "vaccinespotter_org:1046476",
    "us_carbon_health:093ce455-6fa5-4912-82bb-fd7f478d56ed",
    "_tag_provider:sav_on"
]
  https://www.vaccinatethestates.com/?lng=-116.57157&lat=43.54543#ldrbq ldrbq <Binary: 60 bytes> 43.54543 -116.57157
7615 Sav-On Pharmacy #1602 ID Pharmacy 208-466-3592 715 12Th Ave S, Nampa, ID 83651 Nampa Canyon 83651
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 07:00PM Sat, 10:00AM - 04:00PM Sun"
}
https://www.albertsons.com/pharmacy/covid-19.html
[
    "Moderna",
    "Johnson & Johnson"
]
[
    "vaccinefinder:af55356f-67fc-492f-a8dc-fbf42baf6113",
    "vaccinefinder_org:af55356f-67fc-492f-a8dc-fbf42baf6113",
    "sav_on:1602",
    "us_giscorps_vaccine_providers:48f043cb-a88d-45c9-9eae-ffad48af866d",
    "vaccinespotter_org:1046490",
    "_tag_provider:sav_on",
    "us_carbon_health:f31febec-3662-4096-a42b-8fd86ad7f0a5"
]
  https://www.vaccinatethestates.com/?lng=-116.56677&lat=43.57438#ldtrh ldtrh <Binary: 60 bytes> 43.57438 -116.56677
13934 Medicap Pharmacy #8391 ID Pharmacy 208-722-5269 410 E Grove Ave, Parma, ID 83660 Parma Canyon 83660
{
    "unstructured": ""
}
 
[
    "Moderna"
]
[
    "vaccinefinder:05af8898-0449-43dd-b9a1-00f9d382ffae",
    "vaccinefinder_org:05af8898-0449-43dd-b9a1-00f9d382ffae"
]
  https://www.vaccinatethestates.com/?lng=-116.94228&lat=43.78429#lggmy lggmy <Binary: 60 bytes> 43.78429 -116.94228
13937 Reddish Pharmacy ID Pharmacy (208) 466-7823 215 E Hawaii Ave. Suite 100, Nampa, ID 83686 Nampa Canyon 83686
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
http://reddishpharmacy.com
[]
[
    "vaccinefinder:5245e7b3-f963-47bb-b89c-3e7a4581c517"
]
  https://www.vaccinatethestates.com/?lng=-116.57083&lat=43.55462#lggpc lggpc <Binary: 60 bytes> 43.55462 -116.57083
13948 Ridley's Pharmacy 8442 ID Pharmacy (208) 585-2900 430 E Main St, Middleton, ID 83644 Middleton Canyon 83644
{
    "unstructured": ""
}
 
[
    "Moderna"
]
[
    "vaccinefinder:da0eab68-99cb-43d2-a811-6f4ee4594912",
    "vaccinefinder_org:da0eab68-99cb-43d2-a811-6f4ee4594912"
]
  https://www.vaccinatethestates.com/?lng=-116.61724&lat=43.70398#lggpw lggpw <Binary: 60 bytes> 43.70398 -116.61724
16240 Fred Meyer Pharmacy #70100226 ID Pharmacy (208) 465-2836 50 Second St S, Nampa, ID 83651 Nampa Canyon 83651
{
    "unstructured": "10:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 7:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
www.krogerhealth.com
[
    "Moderna",
    "Johnson & Johnson"
]
[
    "vaccinefinder:6847202f-6082-4a96-bf0c-159bf0dc30a2",
    "vaccinefinder_org:6847202f-6082-4a96-bf0c-159bf0dc30a2",
    "fred_meyer:70100226",
    "us_giscorps_vaccine_providers:6943d74c-6aee-4afe-aa47-960634dd21e7",
    "vaccinespotter_org:9613395"
]
  https://www.vaccinatethestates.com/?lng=-116.57548&lat=43.58864#lgxpd lgxpd <Binary: 60 bytes> 43.58864 -116.57548
19233 Reddish Pharmacy #Ms1001592 ID Pharmacy 208-466-7823 215 E Hawaii Ave Suite 100, Nampa, ID 83686 Nampa Canyon 83686
{
    "unstructured": ""
}
 
[]
[
    "vaccinefinder:5ecc367e-4909-4018-8e06-f6fb93213449"
]
  https://www.vaccinatethestates.com/?lng=-116.57083&lat=43.55462#lhqgr lhqgr <Binary: 60 bytes> 43.55462 -116.57083
22872 Rite Aid #RA105409 ID Pharmacy 208-455-1094 2107 Blaine Street, Caldwell, ID 83605-4427 Caldwell Canyon 83605-4427
{
    "unstructured": "09:00 AM-9:00 PM Mon-Fri, 09:00 AM-6:00 PM Sat, 10:00 AM-6:00 PM Sun"
}
https://www.riteaid.com
[
    "Moderna"
]
[
    "vaccinefinder:d0007848-8b8a-40b2-8c4b-af239d94f350"
]
  https://www.vaccinatethestates.com/?lng=-116.67506&lat=43.65553#lkmpz lkmpz <Binary: 60 bytes> 43.65553 -116.67506
24411 Ridley'S #18442 #106647 ID Pharmacy (208) 585-2900 430 E Main, Ridley'S #18442, Middleton, ID 83644 Middleton Canyon 83644
{
    "unstructured": ""
}
http://www.shopridleys.com
[
    "Moderna"
]
[
    "vaccinefinder:0eec5654-09f9-4483-bb90-a24e55739ce2",
    "vaccinefinder_org:0eec5654-09f9-4483-bb90-a24e55739ce2"
]
  https://www.vaccinatethestates.com/?lng=-116.61694&lat=43.70424#lkxqx lkxqx <Binary: 60 bytes> 43.70424 -116.61694
27553 Walgreens Co. #5648 ID Pharmacy 208-467-1560 700 12Th Ave S, Nampa, ID 83651-4255 Nampa Canyon 83651-4255
{
    "unstructured": "07:00AM - 11:00PM"
}
https://www.walgreens.com
[
    "Pfizer"
]
[
    "walgreens:5648",
    "vaccinefinder:56af8d7e-5cc5-4496-b8d6-1b69c52df617",
    "vaccinefinder_org:56af8d7e-5cc5-4496-b8d6-1b69c52df617"
]
  https://www.vaccinatethestates.com/?lng=-116.56708&lat=43.57352#lmqyw lmqyw <Binary: 60 bytes> 43.57352 -116.56708
28246 Walgreens Co. #7276 ID Pharmacy 208-455-1792 1012 Cleveland Blvd, Caldwell, ID 83605-3852 Caldwell Canyon 83605-3852
{
    "unstructured": "07:00AM - 11:59PM"
}
https://www.walgreens.com
[
    "Pfizer"
]
[
    "walgreens:7276",
    "vaccinefinder:ae7c7383-2455-425d-9201-0cbf51ddbbaf",
    "vaccinefinder_org:ae7c7383-2455-425d-9201-0cbf51ddbbaf"
]
  https://www.vaccinatethestates.com/?lng=-116.68755&lat=43.66201#lmwrc lmwrc <Binary: 60 bytes> 43.66201 -116.68755
29373 Walgreens Co. #10672 ID Pharmacy 208-318-0536 2219 12Th Ave Rd, Nampa, ID 83686-6313 Nampa Canyon 83686-6313
{
    "unstructured": "08:00AM - 10:00PM"
}
https://www.walgreens.com
[
    "Pfizer"
]
[
    "walgreens:10672",
    "vaccinefinder:4ca67e2b-ff06-4cb8-bf04-c7ae6debc4e2",
    "vaccinefinder_org:4ca67e2b-ff06-4cb8-bf04-c7ae6debc4e2"
]
  https://www.vaccinatethestates.com/?lng=-116.57344&lat=43.54762#lpcbp lpcbp <Binary: 60 bytes> 43.54762 -116.57344
29753 Walgreens Co. #11541 ID Pharmacy 208-402-0154 4110 S 10Th Ave, Caldwell, ID 83605-5706 Caldwell Canyon 83605-5706
{
    "unstructured": "08:00AM - 10:00PM"
}
https://www.walgreens.com
[
    "Pfizer"
]
[
    "walgreens:11541",
    "vaccinefinder:af2978d4-7bd8-42c8-8b64-c9d358480ce7",
    "vaccinefinder_org:af2978d4-7bd8-42c8-8b64-c9d358480ce7"
]
  https://www.vaccinatethestates.com/?lng=-116.69383&lat=43.63298#lpdpg lpdpg <Binary: 60 bytes> 43.63298 -116.69383
30099 Walgreens Co. #12483 ID Pharmacy 208-318-0018 932 Caldwell Blvd, Nampa, ID 83651-1711 Nampa Canyon 83651-1711
{
    "unstructured": "08:00AM - 10:00PM"
}
https://www.walgreens.com
[
    "Pfizer"
]
[
    "walgreens:12483",
    "vaccinefinder:ed0c5885-236d-40e6-8c50-dacdf16f93dc",
    "vaccinefinder_org:ed0c5885-236d-40e6-8c50-dacdf16f93dc"
]
  https://www.vaccinatethestates.com/?lng=-116.59217&lat=43.59879#lpfxy lpfxy <Binary: 60 bytes> 43.59879 -116.59217
34220 Walmart Inc #10-2780 ID Pharmacy 2084550066 5108 Cleveland Blvd, Caldwell, ID 83607-8002 Caldwell Canyon 83607-8002
{
    "unstructured": "8:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 8:00 AM - 7:00 PM Wed, 8:00 AM - 7:00 PM Thrus, 8: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/2780
[
    "Moderna"
]
[
    "vaccinefinder:ede85f39-df90-4c08-aa6f-ac0eb457b7dc",
    "us_carbon_health:ea66d1ed-6f85-4c9e-9ad6-6df5fda5943a",
    "_tag_provider:walmart",
    "walmart:2780"
]
  https://www.vaccinatethestates.com/?lng=-116.64510&lat=43.63194#lqfzq lqfzq <Binary: 60 bytes> 43.63194 -116.6451
34221 Walmart Inc #10-2781 ID Pharmacy 2084675047 2100 12Th Ave Rd, Nampa, ID 83686-6441 Nampa Canyon 83686-6441
{
    "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/2781
[
    "Pfizer"
]
[
    "vaccinefinder:2ec517ed-3ee6-4567-ba81-7e49261d14ca",
    "walmart:2781",
    "us_carbon_health:591ecb1e-d9a5-49f7-9398-978a039f5ed2",
    "_tag_provider:walmart"
]
  https://www.vaccinatethestates.com/?lng=-116.57056&lat=43.54904#lqfzr lqfzr <Binary: 60 bytes> 43.54904 -116.57056
34839 Walmart Inc #10-3739 ID Pharmacy 2084616481 5875 E Franklin Rd, Nampa, ID 83687-5020 Nampa Canyon 83687-5020
{
    "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/3739
[
    "Moderna"
]
[
    "vaccinefinder:07a93534-54c9-4765-8c40-39b7b49ebd90",
    "_tag_provider:walmart",
    "walmart:3739",
    "us_carbon_health:b156d329-ee45-4800-9350-7f08e85840df"
]
  https://www.vaccinatethestates.com/?lng=-116.51046&lat=43.60287#lqkkh lqkkh <Binary: 60 bytes> 43.60287 -116.51046
34997 Walmart Inc #10-4180 ID Pharmacy 2085463337 175 S Middleton Rd, Nampa, ID 83651-7538 Nampa Canyon 83651-7538
{
    "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/4180
[
    "Moderna",
    "Johnson & Johnson"
]
[
    "vaccinefinder:68a6758d-a6a0-4536-a99a-36693de06287",
    "us_carbon_health:22b15792-2621-4079-881c-a274809f3567",
    "_tag_provider:walmart",
    "walmart:4180"
]
  https://www.vaccinatethestates.com/?lng=-116.61400&lat=43.56651#lqmbf lqmbf <Binary: 60 bytes> 43.56651 -116.614
35171 Walmart Inc #10-4494 ID Pharmacy 2084545640 622 E Ustick Rd, Caldwell, ID 83605-6248 Caldwell Canyon 83605-6248
{
    "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/4494
[
    "Pfizer"
]
[
    "vaccinefinder:dd658e2b-8bbe-4482-bbb7-8ef6b4cd0fd7",
    "us_carbon_health:ff4faf3c-d48a-4a57-bcc4-9c54db52ba36",
    "walmart:4494",
    "_tag_provider:walmart"
]
  https://www.vaccinatethestates.com/?lng=-116.69091&lat=43.63212#lqmtc lqmtc <Binary: 60 bytes> 43.63212 -116.69091
42467 Saltzer Health - North Nampa Urgent Care Clinic ID Unknown (208) 463-3000 9850 W. St. Luke's Drive Nampa ID 83687 Nampa, ID 83687 Nampa Canyon 83687
{
    "unstructured": null
}
 
[]
[
    "us_giscorps_vaccine_providers:67ac0367-4aa7-440f-ac17-d07109f96507"
]
2021-05-14T21:47:28.692551+00:00 https://www.vaccinatethestates.com/?lng=-116.59048&lat=43.61654#lthcw lthcw <Binary: 60 bytes> 43.61654 -116.59048
50525 Primary Health Medical ID Unknown (208) 809-2869 1375 N. Happy Valley Road Nampa Nampa, ID 83687 Nampa Canyon 83687
{
    "unstructured": null
}
 
[]
[
    "us_giscorps_vaccine_providers:0dad57f5-47ff-4d11-b396-da01d1ee2682"
]
2021-05-14T17:46:51.882087+00:00 https://www.vaccinatethestates.com/?lng=-116.51484&lat=43.59633#lxkdg lxkdg <Binary: 60 bytes> 43.59633 -116.51484
50973 Primary Health Clinic ID Unknown (208) 466-6567 700 Caldwell Blvd. Nampa Nampa, ID 83686 Nampa Canyon 83686
{
    "unstructured": null
}
 
[]
[
    "us_giscorps_vaccine_providers:f9299080-e560-4887-a4fa-ec802e593b7e"
]
2021-05-14T17:38:08.733575+00:00 https://www.vaccinatethestates.com/?lng=-116.58980&lat=43.59645#lxmym lxmym <Binary: 60 bytes> 43.59645 -116.5898
50984 Nampa ID Unknown   16700 N MARKET PLACE BLVD NAMPA, ID 83687 NAMPA Canyon 83687
{
    "unstructured": null
}
https://www.costco.com/covid-vaccine.html
[]
[
    "vaccinespotter_org:170709145"
]
  https://www.vaccinatethestates.com/?lng=-116.59200&lat=43.61400#lxmzd lxmzd <Binary: 60 bytes> 43.614 -116.592
51029 Primary Health ID Unknown (208) 809-2875 512 N. 21st Avenue Caldwell Caldwell, ID 83605 Caldwell Canyon 83605
{
    "unstructured": null
}
 
[]
[
    "us_giscorps_vaccine_providers:97fc8ba8-421a-4cd1-8c63-dc1879178989"
]
  https://www.vaccinatethestates.com/?lng=-116.66769&lat=43.66125#lxpdb lxpdb <Binary: 60 bytes> 43.66125 -116.66769
51046 Vic's Family Pharmacy ID Unknown (208) 465-7000 1513 12th Ave. Nampa Nampa, ID 83686 Nampa Canyon 83686
{
    "unstructured": null
}
 
[]
[
    "us_giscorps_vaccine_providers:9f763987-aadf-4656-a6d8-f0fdba9e9d02"
]
2021-05-14T17:35:12.912197+00:00 https://www.vaccinatethestates.com/?lng=-116.57353&lat=43.55371#lxpfc lxpfc <Binary: 60 bytes> 43.55371 -116.57353
51070 Medical Clinic Health Mart Pharmacy ID Unknown   315 E Elm , Ste. 150 Caldwell, ID 83605 Caldwell Canyon 83605
{
    "unstructured": null
}
https://www.healthmartcovidvaccine.com/
[]
[
    "vaccinespotter_org:141588236"
]
  https://www.vaccinatethestates.com/?lng=-116.69479&lat=43.65388#lxpgr lxpgr <Binary: 60 bytes> 43.65388 -116.69479

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;