locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Yakutat" 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
36613 Yakutat Community Health Center AK Pharmacy 907-784-3275 115 Airport Road, Yakutat, AK 99689 Yakutat Yakutat 99689 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:ebd62690-9df6-49a6-8b51-d09992a9e95f",
    "vaccinefinder_org:ebd62690-9df6-49a6-8b51-d09992a9e95f",
    "us_carbon_health:51eef233-8d98-4234-b669-66af4131ba0f"
]
   https://www.vaccinatethestates.com/?lng=-139.69675&lat=59.52770#lqxht lqxht <Binary: 60 bytes> 59.5277 -139.69675
42655 Yakutat Community Health Center AK Unknown (907) 784-3275 115 Airport Road, PO Box 112 Yakutat, AK 99689 Yakutat Yakutat 99689 
{
    "unstructured": null
}
   
[]
 
[
    "ak_arcgis:a4d318b8-9594-450f-8d2e-9f38f2c1bf94",
    "ak_clinic_list:a4d318b8-9594-450f-8d2e-9f38f2c1bf94"
]
   https://www.vaccinatethestates.com/?lng=-139.73211&lat=59.54924#lthxx lthxx <Binary: 60 bytes> 59.54924 -139.73211

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;