location_aliases

Maps every raw location string to a canonical_name in locations.

333 rows

✎ View and edit SQL

This data as json, CSV (advanced)

raw_name ▼ canonical_name
ABCD, Karnataka, Bellary, Hospet ABCD
ACC Cement Ltd, Wadi ACC Cement Ltd, Wadi
ACM Jetty ACM Jetty
ACM/ DTRIPL Jetty No. 2 ACM/ DTRIPL Jetty No. 2
ACORE INDUSTRIES ACORE INDUSTRIES
ACORE INDUSTRIES PRIVATE LIMITED, Karnataka, Bellary, Bellary ACORE INDUSTRIES
ACORE INDUSTRIES PRIVATE LIMITED, Karnataka, Bellary, Sandur ACORE INDUSTRIES
AMBEY METALLIC PRIVATE LIMITED , Maharashtra, Sindhudurg, Dodamarg AMBEY METALLIC PRIVATE LIMITED
AMBEY METALLICS AMBEY METALLICS
Adrem Jetty Adrem Jetty
Advalpale Thivim Mineral Block - V Advalpale Thivim Mineral Block - V
Alcon Jetty Alcon Jetty
B L Rani Samyuktha, Karnataka, Chitradurga, Chitradurga B L Rani Samyuktha
B. Kumar Gowda Mines B. Kumar Gowda Mines
BALAJI MALTS PVT.LTD., Maharashtra, Ratnagiri, Jaigad BALAJI MALTS PVT.LTD.
BANDEKAR KOTAMBI TIXEM PLOT D B Bandodkar Tixem Jetty
BANDEKAR VAGUS PLOT Bandekar Vagus Plot
BICHOLIM MINE AMLG Bicholim Mineral Block - I
BIMBOL MINE 23/53 BIMBOL MINE 23/53
BONDRA ADVONA CODLI MINE 61/53 BONDRA ADVONA CODLI MINE 61/53
BORCHI MORDI MAINA 06/1961 BORCHI MORDI MAINA 06/1961
BOTVADEACHO DONGOR28/51 BOTVADEACHO DONGOR28/51
Balaji Malts private limited, Maharashtra, Ratnagiri, Jaigad BALAJI MALTS PVT.LTD.
Bellary Ispat Private Limited Bellary Ispat Private Limited
Belur Industrial Area - Dharwad Belur Industrial Area - Dharwad
Beteagal 12/53 Beteagal 12/53
Bhadrashree Steel and Power Limited Bhadrashree Steel and Power Limited
Bharathi Cement Bharathi Cement
Bicholim Mineral Block - I Bicholim Mineral Block - I
Bicholim Mineral Block- 1 Bicholim Mineral Block - I
Bimbol mines 7/41 Bimbol mines 7/41
CALVI JETTY Calvi Jetty
CANTOR MINE 3/51 CANTOR MINE 3/51
CCPL BNF PLANT CCPL BNF PLANT
CCPL DSP SIRIGAO CCPL DSP SIRIGAO
CCPL PALE PLOT CCPL PALE PLOT
CCPL WASHING PLANT A CCPL WASHING PLANT A
CHINA CHINA
CHORIANCHO TEMBO DONGOR 07/41 CHORIANCHO TEMBO DONGOR 07/41
CODLI MINE AMLG CODLI MINE AMLG
COLLEM MINE 30/50 COLLEM MINE 30/50
COPILA GAICHEM PAUL MINE 88/52 COPILA GAICHEM PAUL MINE 88/52
CORMOLEM E BOG MINE 45/52 CORMOLEM E BOG MINE 45/52
COSTI CCPL MINE 10/AMLG COSTI CCPL MINE 10/AMLG
COSTI VVCL AMLG COSTI VVCL AMLG
CUDNEM PLANT CUDNEM PLANT
Chunimolo 75/52, Columba Chunimolo 75/52, Columba
Chunimolo Mine 28/52 Chunimolo Mine 28/52
Cotombi Bicholim Cotombi Bicholim
Cuddegalivoril Soddo Mine - 62/51 Cuddegalivoril Soddo Mine - 62/51
Cudnem Plot/KMPCPL Survey Number 148 Cudnem Plot/KMPCPL Survey Number 148
Curpem Mines 11/AMLG Curpem Mines 11/AMLG
D B BANDODKAR COTAMBI JETTY D B Bandodkar Tixem Jetty
D B BANDODKAR TIXEM JETTY D B Bandodkar Tixem Jetty
DEULEM PISSURLEM IRON ORE MINE 70/51 DEULEM PISSURLEM IRON ORE MINE 70/51
DIGNEM MINE 92/52 DIGNEM MINE 92/52
Dalmia Cement (Bhara) Limited Dalmia Cement (Bhara) Limited
Dinar Tarcar Resources (India) Private Limited Jetties Dinar Tarcar Resources (India) Private Limited Jetties
Doddannavar Brothers Doddannavar Brothers
Doddannavar brothers, Karnataka, Bagalkot, Bagalkot Doddannavar Brothers
Doddannavar brothers, Karnataka, Bagalkot, Hungund Doddannavar Brothers
E RAMAMURTHY MINERALS AND METALS PVT LTD, Karnataka, Chitradurga, Chitradurga E RAMAMURTHY MINERALS AND METALS PVT LTD
EMCO JETTY EMCO JETTY
Fomento Maina Plot Sy No 67 TPL Maina Jetty
Fomento Resources Pvt Ltd, Sindhudurg Fomento Resources Pvt Ltd, Sindhudurg
GAVANEM CCPL 31/55 GAVANEM CCPL 31/55
GODBAIM PLOT GODBAIM PLOT
GOGORO-OU-GULCAN DONGOR 6/49 GOGORO-OU-GULCAN DONGOR 6/49
GUELLEIM E GAVAL PISSURLEM IRON ORE MINE 55/51 GUELLEIM E GAVAL PISSURLEM IRON ORE MINE 55/51
Goa Mineral Pvt Ltd Goa Mineral Pvt Ltd
Goa Minerals Private Limited, Karnataka, Dharwad, Dharwad Goa Minerals Private Limited
Goa Sponge Goa Sponge
Guinea Guinea
HINDALCO INDUSTRIES HINDALCO INDUSTRIES
HULDOOL DONGOR BIMBOL IRON ORE MINE - 8/41 HULDOOL DONGOR BIMBOL IRON ORE MINE - 8/41
HUNANTLO DONGOR Fe - Mn MINE 17/49 HUNANTLO DONGOR Fe - Mn MINE 17/49
Hindalco Industries, Belagavi Hindalco Industries, Belagavi
INDSIL HYDROPOWER AND MANGANESE LTD. INDSIL HYDROPOWER AND MANGANESE LTD.
INFRASTRUCTURE LOGISTICS PRIVATE LIMITED, HOUSE NO.508E C/O BALKRISHNA JADHAV PANCHASHEEL NAGAR BHINGOLI, TALUKA MANDANGAD RATNAGIRI, INDIA, Maharashtra, Ratnagiri, Mandangad INFRASTRUCTURE LOGISTICS PRIVATE LIMITED, HOUSE NO.508E C/O BALKRISHNA JADHAV PANCHASHEEL NAGAR BHINGOLI, TALUKA MANDANGAD RATNAGIRI, INDIA
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
INTERMEDIATE ORE STOCK M.L NO.2 FE 77 S No 86 INTERMEDIATE ORE STOCK M.L NO.2 FE 77 S No 86
JOLERACHO DONGOR 44/51 JOLERACHO DONGOR 44/51
JSW Jaigarh Port Limited JSW Jaigarh Port Limited
JSW Steel Ltd, Dolvi JSW Steel Ltd, Dolvi
KALAY IRON ORE MINE 02/AMLG KALAY IRON ORE MINE 02/AMLG
KALAY RAILWAY STATION KALAY RAILWAY STATION
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
KELI MINE - PLOT KELI MINE - PLOT
KMPCPL Survey Number 148 KMPCPL Survey Number 148
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
KYARKOPPA RAILWAY STATION KYARKOPPA RAILWAY STATION
Kalane Mines Kalane Mines

Next page

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