joined.sql

create or replace table joined as 
select 
  location_history.*
  , uk_geo.county_name 
from location_history, uk_geo 
where ST_Within(location_history.geo_location, uk_geo.county_geo);