locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Kingman" and state = "KS"

✎ 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
16550 Kingman Drug KS Pharmacy (620) 532-5113 211 N. Main St., Kingman, KS 67068 Kingman Kingman 67068 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 8:00 AM - 3:00 PM Sat, Closed Sun"
}
 www.kingmanrx.com 
[]
 
[
    "vaccinefinder:df87a1e2-64d3-4da9-9c30-0aaf95e58b30",
    "vaccinefinder_org:df87a1e2-64d3-4da9-9c30-0aaf95e58b30",
    "vaccinespotter_org:141765412",
    "us_carbon_health:d8244f94-6834-4b54-a154-82726f97088f"
]
   https://www.vaccinatethestates.com/?lng=-98.11343&lat=37.64342#lgytr lgytr <Binary: 60 bytes> 37.64342 -98.11343

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;