location_aliases

Maps every raw location string to a canonical_name in locations.

3 rows where canonical_name = "INFRASTRUCTURE LOGISTICS PRIVATE LIMITED"

✎ View and edit SQL

This data as json, CSV (advanced)

raw_name ▼ canonical_name
INFRASTRUCTURE LOGISTICS PRIVATE LIMITED, Karnataka, Gulbarga, Gulbarga INFRASTRUCTURE LOGISTICS PRIVATE LIMITED
INFRASTRUCTURE LOGISTICS PRIVATE LIMITED, Maharashtra, Ratnagiri, Mandangad INFRASTRUCTURE LOGISTICS PRIVATE LIMITED
INFRASTRUCTURE LOGISTICS PVT LIMITED, Maharashtra, Ratnagiri, Mandangad INFRASTRUCTURE LOGISTICS PRIVATE LIMITED

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