Routes with largest source→dest weight change

Custom SQL query returning 40 rows (hide) 

SELECT source, destination, ore_stream, trips,
       tonnage_src AS src_tons, tonnage AS dst_tons, delta
FROM routes
WHERE trips > 50
ORDER BY ABS(delta) DESC LIMIT 40;

Edit SQL

This data as json, CSV

sourcedestinationore_streamtripssrc_tonsdst_tonsdelta
Sarmanas Jetty Mormugao Port Trust (MPT) royalty 433 817857.2 831134.2 13277.0
Sarmanas Jetty Vedanta PID Amona royalty 86 147950.3 157355.3 9405.0
Mormugao Port Trust (MPT) Vedanta PID Amona imported 144 192966.0 200593.0 7627.0
KYARKOPPA RAILWAY STATION Vedanta PID Amona imported 8877 312668.0 313965.4 1297.5
Bicholim Mineral Block - I Sarmanas Jetty royalty 113318 1294001.3 1292912.7 -1088.6
Thakur Industries Vedanta PID Amona imported 8333 282923.4 281864.8 -1058.6
Mormugao Port Trust (MPT) Mandovi River Pellets Pvt Ltd (MRPPL) imported 467 827204.4 828020.0 815.6
Navelim Jetty AMBEY METALLICS eauction 2574 29641.0 30209.2 568.2
D B Bandodkar Tixem Jetty Vagus Jetty eauction 3795 42506.0 42036.4 -469.5
Sangod Dharbandora D B Bandodkar Tixem Jetty eauction 3596 41194.6 41551.9 357.3
TPL Maina Jetty Mormugao Port Trust (MPT) eauction 73 113351.6 113682.7 331.1
Thakur Industries Vedanta PID Navelim imported 3179 107590.7 107275.8 -314.9
Navelim Jetty TPL Maina Jetty eauction 27686 318100.8 318399.2 298.5
TPL Maina Jetty Vagus Jetty eauction 2203 25000.0 25266.6 266.6
Sandur Manganese & Iron Ore Ltd Vedanta PID Amona imported 2934 101980.5 101717.0 -263.5
NOMOXITEMBO -DE- CAUREM 14/52 TPL Jetty Capxem eauction 2830 33332.6 33080.1 -252.5
Patiem / Tudou Mine TPL Jetty Capxem eauction 12009 140850.0 141097.3 247.3
Bicholim Mineral Block - I Pilgao Beneficiation Plant (NBP) royalty 8443 97368.7 97571.8 203.1
KEJ Minerals Vedanta PID Amona imported 1980 68006.3 67826.0 -180.3
Alcon Jetty Vedanta PID Navelim royalty 3329 37741.0 37623.1 -117.9
ACORE INDUSTRIES Vedanta PID Navelim imported 2496 86243.6 86126.9 -116.6
NMDC KIOM Mandovi River Pellets Pvt Ltd (MRPPL) imported 745 25937.2 25824.3 -112.9
Cotombi Bicholim Vedanta PID Amona eauction 873 10000.0 10102.4 102.4
NMDC KIOM Vedanta PID Amona imported 1686 58600.7 58499.2 -101.4
GUELLEIM E GAVAL PISSURLEM IRON ORE MINE 55/51 Vagus Jetty eauction 1655 19053.8 19144.9 91.2
Kalane Mines Vedanta PID Navelim imported 1302 43621.7 43695.2 73.5
Kalane Mines Vedanta PID Amona imported 546 18523.7 18591.4 67.7
M/s. STAR MINERALS Mandovi River Pellets Pvt Ltd (MRPPL) imported 112 3914.4 3966.2 51.8
Doddannavar Brothers Vedanta PID Amona imported 148 5061.5 5112.0 50.5
Cotombi Bicholim Vedanta PID Navelim eauction 1225 14000.0 14047.4 47.4
MML 995 Mines Ubbalagandi Mandovi River Pellets Pvt Ltd (MRPPL) imported 146 5000.0 4954.1 -45.9
ACORE INDUSTRIES Vedanta PID Amona imported 969 33298.3 33259.8 -38.4
KEJ Minerals Vedanta PID Navelim imported 1041 36000.0 35969.9 -30.1
D B Bandodkar Tixem Jetty D B Bandodkar Tixem Jetty eauction 1162 11904.9 11933.5 28.6
VRKP Bellary Vedanta PID Navelim imported 192 6577.3 6552.2 -25.1
Karnataka Limpo Cements Industries Vedanta PID Amona imported 184 6280.0 6305.0 25.0
ZEST FERRO BENEFICIATION PLANT-Bellary Vedanta PID Amona imported 623 21234.8 21213.4 -21.4
Karwar Port Vedanta PID Navelim imported 200 6443.0 6423.1 -19.9
Cotombi Bicholim D B Bandodkar Tixem Jetty eauction 266 3000.0 3015.1 15.1
KYARKOPPA RAILWAY STATION Vedanta PID Navelim imported 662 23433.6 23448.3 14.6