location_aliases

Maps every raw location string to a canonical_name in locations.

3 rows where canonical_name = "Karnataka Limpo Cements Industries"

✎ View and edit SQL

This data as json, CSV (advanced)

raw_name ▼ canonical_name
Karnataka Limpo Cements Industries Karnataka Limpo Cements Industries
Karnataka Limpo Cements Industries, Karnataka, Tumkur, Chiknayakanhalli Karnataka Limpo Cements Industries
Karnataka Limpo Cements Industries, Karnataka, Tumkur, Tiptur Karnataka Limpo Cements Industries

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE location_aliases (
  raw_name TEXT PRIMARY KEY,
  canonical_name TEXT REFERENCES locations(canonical_name)
);