location_aliases

Maps every raw location string to a canonical_name in locations.

4 rows where canonical_name = "KSMCL-Mysore Minerals"

✎ View and edit SQL

This data as json, CSV (advanced)

raw_name ▼ canonical_name
KSMCL / Mysore Minerals Ltd KSMCL-Mysore Minerals
KSMCL-Mysore Minerals, Karnataka, Bellary, Bellary KSMCL-Mysore Minerals
KSMCL-Mysore Minerals, Karnataka, Bellary, Sandur KSMCL-Mysore Minerals
KSMCL-Mysore Minerals, Karnataka, Mysore, Mysore KSMCL-Mysore Minerals

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)
);