locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Cleveland" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
8977 Rison Pharmacy AR Pharmacy   300 Pine St., Rison, AR 71665 Rison Cleveland 71665 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:511707be-a702-479e-8b46-8aff58c4a388",
    "vaccinefinder_org:511707be-a702-479e-8b46-8aff58c4a388",
    "us_carbon_health:e85bfeca-35bf-499b-961b-6553dd320095"
]
   https://www.vaccinatethestates.com/?lng=-92.19197&lat=33.95849#lfbzr lfbzr <Binary: 60 bytes> 33.95849 -92.19197
65414 Rison Pharmacy AR Unknown (870) 325-6262 300 Pine St. Box 534 Rison, AR 71665 Rison Cleveland 71665 
{
    "unstructured": ""
}
 https://www.facebook.com/risonpharmacy/ 
[]
 
[
    "us_carbon_health:399f325f-3e3c-4bae-9fd9-c2f0c641bede"
]
   https://www.vaccinatethestates.com/?lng=-92.19199&lat=33.95889#lccbwy lccbwy <Binary: 60 bytes> 33.95889 -92.19199

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;