locations_expanded (view)

Data source: Vaccinate The States

9 rows where county = "Ketchikan Gateway" and state = "AK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
36517 Safeway Pharmacy #1818 AK Pharmacy 907-228-1960 2417 Tongass Ave, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": "09:00AM - 07:00PM Mon-Fri, 10:00AM - 06:00PM Sat-Sun"
}
 https://www.safeway.com/pharmacy/covid-19.html 
[
    "Moderna"
]
 
[
    "vaccinefinder:3136b289-aabd-41fe-80a3-4077eb902ae9",
    "arcgis:03d5ed09-ee81-4788-8373-c81c2b32f04d",
    "vaccinefinder_org:3136b289-aabd-41fe-80a3-4077eb902ae9",
    "ak_arcgis:03d5ed09-ee81-4788-8373-c81c2b32f04d",
    "safeway:1818",
    "us_giscorps_vaccine_providers:706bf893-9419-4541-8538-76fd9140de0d",
    "vaccinespotter_org:1047667",
    "us_carbon_health:8fe805f9-a1a4-4d71-a3d9-f25689a1a4ee",
    "_tag_provider:safeway",
    "us_carbon_health:b15a312a-e272-4c0e-a116-35c8ddd2c46f",
    "ak_clinic_list:03d5ed09-ee81-4788-8373-c81c2b32f04d"
]
   https://www.vaccinatethestates.com/?lng=-131.67340&lat=55.34849#lqwzm lqwzm <Binary: 60 bytes> 55.34849 -131.6734
36546 PeaceHealth Ketchikan Medical Center AK Pharmacy 907-228-8140 3100 Tongass Ave, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": ""
}
   
[
    "Pfizer"
]
 
[
    "vaccinefinder:4e3138e9-d19d-4139-b301-8cb247af57e8",
    "arcgis:53629867-760e-4b63-88b9-3f07f6b47474",
    "ak_arcgis:53629867-760e-4b63-88b9-3f07f6b47474",
    "vaccinefinder_org:4e3138e9-d19d-4139-b301-8cb247af57e8",
    "us_carbon_health:fb167089-91a9-4b11-b16b-58043cfb2882",
    "ak_clinic_list:53629867-760e-4b63-88b9-3f07f6b47474"
]
   https://www.vaccinatethestates.com/?lng=-131.68664&lat=55.35366#lqxcp lqxcp <Binary: 60 bytes> 55.35366 -131.68664
36556 Serenity Health and Wellness, LLC AK Pharmacy 907-247-9355 120 Carlanna Lake Rd, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": ""
}
 https://www.serenityketchikan.com/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:2f3afbe7-0db5-4676-9720-bbaa0ea39c01",
    "arcgis:4e016e2c-1c3e-4c53-8370-def2caf71711",
    "ak_arcgis:4e016e2c-1c3e-4c53-8370-def2caf71711",
    "vaccinefinder_org:2f3afbe7-0db5-4676-9720-bbaa0ea39c01",
    "us_carbon_health:0eab6c2c-4561-49a5-872e-621876e7c71e",
    "ak_clinic_list:4e016e2c-1c3e-4c53-8370-def2caf71711"
]
   https://www.vaccinatethestates.com/?lng=-131.68852&lat=55.35416#lqxdd lqxdd <Binary: 60 bytes> 55.35416 -131.68852
36586 Power of Wellness Health Services LLC AK Pharmacy 907-220-4447 3528 Tongass Ave., Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:9dbd1ab6-074e-446a-bbae-42620a2e6a34",
    "arcgis:8bbe55db-2b9c-4473-88dc-839172d7b663",
    "ak_arcgis:8bbe55db-2b9c-4473-88dc-839172d7b663",
    "vaccinefinder_org:9dbd1ab6-074e-446a-bbae-42620a2e6a34",
    "us_carbon_health:af733151-0533-4b50-bd97-223f4c4503d4",
    "ak_clinic_list:8bbe55db-2b9c-4473-88dc-839172d7b663"
]
   https://www.vaccinatethestates.com/?lng=-131.69246&lat=55.35600#lqxgb lqxgb <Binary: 60 bytes> 55.356 -131.69246
36610 Ketchikan Public Health Center AK Pharmacy 907-842-5221 605 Gateway Court, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": ""
}
   
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:0f055d41-3f29-4c30-b8be-4c4316d8898e",
    "arcgis:57bd2fa7-17d5-4d27-890d-67cd38fdcd67",
    "ak_arcgis:57bd2fa7-17d5-4d27-890d-67cd38fdcd67",
    "us_giscorps_vaccine_providers:6aa1d33e-011b-4cda-8131-ab44251e7b18",
    "vaccinefinder_org:0f055d41-3f29-4c30-b8be-4c4316d8898e",
    "us_carbon_health:cb2b3b46-8310-44e8-b52f-8832fd79d64f",
    "ak_clinic_list:57bd2fa7-17d5-4d27-890d-67cd38fdcd67"
]
   https://www.vaccinatethestates.com/?lng=-131.68466&lat=55.35442#lqxhp lqxhp <Binary: 60 bytes> 55.35442 -131.68466
36628 Northway Family Healthcare AK Pharmacy 907-225-4325 130 Carlanna Lake Rd. Suite 201, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:20797797-b015-483e-8201-8b4c01de6e95",
    "vaccinefinder_org:20797797-b015-483e-8201-8b4c01de6e95",
    "us_carbon_health:7da89f5b-fad5-40d5-be5a-9b8658b0afa7"
]
   https://www.vaccinatethestates.com/?lng=-131.68800&lat=55.35412#lqxkr lqxkr <Binary: 60 bytes> 55.35412 -131.688
36664 Walmart Inc #10-2710 AK Pharmacy 9072472156 4230 Don King Rd, Ketchikan, AK 99901-9047 Ketchikan Ketchikan Gateway 99901-9047 
{
    "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 - 2:00 PM Sun"
}
 https://www.walmart.com/store/2710 
[
    "Moderna"
]
 
[
    "vaccinefinder:f86ff32d-7174-421e-9637-c4deb984a776",
    "_tag_provider:walmart",
    "walmart:2710",
    "us_carbon_health:778533b4-d9ff-4cb2-b954-d3305fe32548",
    "ak_clinic_list:990af512-714b-4aa0-8945-c8c2e4cdce39"
]
   https://www.vaccinatethestates.com/?lng=-131.72057&lat=55.37547#lqxpy lqxpy <Binary: 60 bytes> 55.37547 -131.72057
37412 Creekside Family Health Clinic, Inc. AK Pharmacy 907-220-9982 320 Bawden Street, Suite 313, Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 10:00 AM - 4:00 PM Sat, Closed Sun"
}
 http://creeksidehealth.com 
[]
 
[
    "vaccinefinder_org:d7a50def-6179-4652-98e9-af29292c4e19"
]
   https://www.vaccinatethestates.com/?lng=-131.64417&lat=55.34266#lrbtz lrbtz <Binary: 60 bytes> 55.34266 -131.64417
43975 Island Pharmacy AK Unknown   3526 Tongass Ave Ketchikan, AK 99901 Ketchikan Ketchikan Gateway 99901 
{
    "unstructured": null
}
 https://www.islandpharmacyak.com 
[]
 
[
    "ak_arcgis:e46950e8-ab1f-4fa6-8eb0-17a3f20e7f8f",
    "vaccinefinder_org:ef75b3e2-6efe-4fed-82b9-fc5bc71ead0c",
    "us_giscorps_vaccine_providers:861426d1-1492-4b49-a4df-f594d296a076",
    "us_carbon_health:c5d5da05-300c-4330-a4ce-85f787180684",
    "ak_clinic_list:e46950e8-ab1f-4fa6-8eb0-17a3f20e7f8f"
]
   https://www.vaccinatethestates.com/?lng=-131.69272&lat=55.35578#lttcr lttcr <Binary: 60 bytes> 55.35578 -131.69272

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;