locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Nome" and state = "AK"

✎ View and edit SQL

This data as json, CSV (advanced)

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
36608 Norton Sound Health Corporation AK Pharmacy 907-434-0461 1000 Greg Kruschek Avenue, Nome, AK 99762 Nome Nome 99762 
{
    "unstructured": ""
}
   
[
    "Moderna",
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:63b0718f-278a-48fc-a47d-98260fbae52d",
    "vaccinefinder_org:63b0718f-278a-48fc-a47d-98260fbae52d"
]
   https://www.vaccinatethestates.com/?lng=-165.37840&lat=64.49923#lqxhk lqxhk <Binary: 60 bytes> 64.49923 -165.3784

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;