locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Aleutians West" and state = "AK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vaccines_offered, latitude, longitude, 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
36572 Oonalaska Wellness Center AK Pharmacy 908-581-2742 Po Box 1130, 34 Lavelle Ct #A, Unalaaska, AK 99685 Unalaaska Aleutians West 99685 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:76495199-cfb7-49e4-93af-92a7bb02619f",
    "vaccinefinder_org:76495199-cfb7-49e4-93af-92a7bb02619f"
]
   https://www.vaccinatethestates.com/?lng=-166.53920&lat=53.87236#lqxfd lqxfd <Binary: 60 bytes> 53.87236 -166.5392
36625 IFHS- 34 Lavelle Court, Unalaska, AK AK Pharmacy 907-581-1202 34 Lavelle Court, Unalaska, AK 99685 Unalaska Aleutians West 99685 
{
    "unstructured": ""
}
 http://www.ifhs.org/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:4700b968-ffa9-4a8f-9e78-d4ec9f0ba003",
    "arcgis:efebfec9-fa2b-448d-8fcf-9984f1527289",
    "ak_arcgis:efebfec9-fa2b-448d-8fcf-9984f1527289",
    "vaccinefinder_org:4700b968-ffa9-4a8f-9e78-d4ec9f0ba003",
    "us_carbon_health:76e1c2b1-59d0-4a78-9966-410e71b4389b",
    "ak_clinic_list:efebfec9-fa2b-448d-8fcf-9984f1527289"
]
   https://www.vaccinatethestates.com/?lng=-166.53920&lat=53.87236#lqxkm lqxkm <Binary: 60 bytes> 53.87236 -166.5392
36633 Adak Community Health Clinic AK Pharmacy 907-592-8383 2105 Main Street, Suite 100, Adak, AK 99546 Adak Aleutians West 99546 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:3ea36e0b-d70a-418c-992a-f4765bfdb7ed",
    "vaccinefinder_org:3ea36e0b-d70a-418c-992a-f4765bfdb7ed",
    "us_carbon_health:1cea07e6-4174-42a8-b213-a05ac5e64e85"
]
   https://www.vaccinatethestates.com/?lng=-176.65900&lat=51.85131#lqxkz lqxkz <Binary: 60 bytes> 51.85131 -176.659

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;