locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Alpine" and state = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_verified_by_vts (date), 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
1696 County Hospital (Alpine County, California) CA Hospital / Clinic 530-694-2146 75 Diamond Valley Rd, Markleeville, CA 96120, USA   Alpine   
{
    "unstructured": "Monday - Friday: 8:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
}
   
[]
 
[
    "google_places:ChIJo93LbCHqmYARYrBUfwobOKk"
]
 2021-05-04T21:54:44.792306+00:00 https://www.vaccinatethestates.com/?lng=-119.81692&lat=38.76927#recNWNFSbZ1xUgZEv recNWNFSbZ1xUgZEv <Binary: 60 bytes> 38.76927 -119.81692

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;