location_aliases

Maps every raw location string to a canonical_name in locations.

6 rows where canonical_name = "KEJ Minerals"

✎ View and edit SQL

This data as json, CSV (advanced)

raw_name ▼ canonical_name
KEJ Minerals KEJ Minerals
KEJ Minerals Pvt Ltd, Karnataka, Bellary, Bellary KEJ Minerals
KEJ Minerals Pvt Ltd, Karnataka, Bellary, Sandur KEJ Minerals
KEJ Minerals Pvt Ltd, Karnataka, Koppal, Koppal KEJ Minerals
Kej mineral , Karnataka, Bellary, Bellary KEJ Minerals
kej minerals, Karnataka, Bellary, Bellary KEJ 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)
);