locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Bradley" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vaccines_offered (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
53852 Walgreens Co. #15817 AR Unknown 870-226-3746 310 S MARTIN ST WARREN, AR 71671 WARREN Bradley 71671 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Moderna"
]
 
[
    "walgreens:15817",
    "vaccinefinder_org:b6c62724-b6b7-42e9-8a74-d41e30fa7701",
    "vaccinespotter_org:2728923"
]
   https://www.vaccinatethestates.com/?lng=-92.07211&lat=33.61140#lyfgt lyfgt <Binary: 60 bytes> 33.6114 -92.07211

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;