location_aliases
7 rows where canonical_name = "LLOYDS METALS AND ENERGY LIMITED"
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE location_aliases ( raw_name TEXT PRIMARY KEY, canonical_name TEXT REFERENCES locations(canonical_name) );