locations_expanded (view)

Data source: Vaccinate The States

0 rows where county = "Lincoln" and state = "ID"

✎ View and edit SQL

This data as json

0 records

CREATE VIEW locations_expanded AS 
select
  locations.rowid,
  locations.*,
  y(locations.geometry) as latitude,
  x(locations.geometry) as longitude
from
  locations;