select distinct json_extract(coordinates, ‚$.longitude‘) AS long,json_extract(coordinates, ‚$.latitude‘) AS lat from twitter where coordinates not null limit 10
select distinct json_extract(coordinates, ‚$.longitude‘) AS long,json_extract(coordinates, ‚$.latitude‘) AS lat from twitter where coordinates not null limit 10