Economics Journal

Playground evidence · kirchner.bols

which company ships the largest number of goods between shenzhen and los angeles, and how did this change o…

ClickHouse tests from this investigation. The model finished the queries and then stalled before writing the paper, so this page is the evidence it already had.

Published 4 November 2026

Abstract

The investigation ran the tests below against kirchner.bols. Numbers are from those queries, not from memory. Prose interpretation did not finish in time; do not treat this page as a finished working paper.

Question: which company ships the largest number of goods between shenzhen and los angeles, and how did this change over the last ten years

1. loading_port

Table 1. loading_port · 188,495,086 rows from ClickHouse.

valuen
57078, YANTIAN31,466,934
57035, SHANGHAI23,235,242
57020, NINGPO14,530,128
58023, PUSAN10,448,673
58309, KAO HSIUNG5,924,824
55206, VUNG TAU5,589,146
42870, BREMERHAVEN5,322,934
55976, SINGAPORE4,961,771
58201, HONG KONG4,943,554
57047, QINGDAO4,412,128
57069, XIAMEN4,397,250
42305, ANVERS4,080,220
53313, JAWAHARLAL NEHRU2,986,729
42879, STADERSAND2,725,392
54201, COLOMBO HARBOR2,452,519
42157, ROTTERDAM2,281,392
54930, LAEM CHABANG2,227,228
57,0372,182,862
47527, GENOA2,032,216
53306, MUNDRA1,947,040
47094, VALENCIA1,795,643
47531, LA SPEZIA1,661,765
42737, LE HAVRE1,541,754
58886, TOKYO1,283,383
22556, PUERTO MANZANILLO1,221,407

2. unloading_port

Table 2. unloading_port · 188,495,086 rows from ClickHouse.

valuen
2709, LONG BEACH, CA38,994,615
2704, LOS ANGELES, CA37,951,423
4601, NEW YORK/NEWARK AREA, NEWARK, NJ27,430,166
1703, SAVANNAH, GA11,995,774
5301, HOUSTON, TX9,753,504
3002, TACOMA, WA8,430,434
1401, NORFOLK, VA8,114,720
1601, CHARLESTON, SC7,222,318
2811, OAKLAND, CA5,769,881
3001, SEATTLE, WA5,487,667
1001, NEW YORK, NY4,668,283
5201, MIAMI, FL4,173,939
5203, PORT EVERGLADES, FL2,672,658
1303, BALTIMORE, MD2,668,562
1101, PHILADELPHIA, PA2,110,215
4909, SAN JUAN, PUERTO RICO1,395,366
1803, JACKSONVILLE, FL1,125,373
1901, MOBILE, AL1,118,439
0401, BOSTON, MA896,551
2002, NEW ORLEANS, LA771,933
1102, CHESTER, PA660,573
1501, WILMINGTON, NC585,028
5204, WEST PALM BEACH, FL485,276
2501, SAN DIEGO, CA449,515
1801, TAMPA, FL408,098

3. carrier_sasc_code

Table 3. carrier_sasc_code · 188,495,086 rows from ClickHouse.

valuen
MAEU, MAERSK LINES, INC.10,212,798
CMDU, COMPAGNIE MARITIME DAFFRETEMEN8,180,815
MEDU, BCSL US-MED LINE LTD.7,495,721
EXDO, EXPEDITORS INTERNATIONAL6,278,668
DWCH6,053,844
EGLV, EAGLE VAN LINES INC6,041,299
BANQ, KUEHNE & NAGEL INC.5,888,786
HLCU, HAPAG-LLOYD A G5,766,584
COSU, CHINA OCEAN STEAMSHIP LTD3,931,734
ONEY3,930,923
CHSL, CHISLEY MOTOR COACHES3,616,830
OOLU, ORIENT OVERSEAS CONTAINER LINE INC3,585,402
HANF3,166,648
MSCU, MEDITERRANEAN SHIPPING CORP3,059,340
TZWH2,888,996
APLU, AMERICAN PRESIDENT LINES LTD2,492,096
HDMU, HYUNDAI MERCHANT MARINE (AMERICA) INC2,359,875
DMAL, DANMAR LINES LTD2,000,131
OERT1,868,889
GFSY, GENERAL FREIGHT SYSTEMS INC1,743,052
HNLT1,661,222
ZIMU, ZIM ISRAEL NAVIGATION CO1,631,865
SMLU, SEABOARD MARINE LTD1,625,267
DSVF1,511,372
SUDU, SUD HAMBURG/COLUMBUS LINE1,412,059

4. Find all loading_port values that contain Shenzhen, Yantian, Shekou, or Chiwan to understand the full Shenzhen port family.

Table 4. Find all loading_port values that contain Shenzhen, Yantian, Shekou, or Chiwan to understand the full Shenzhen port family. · 3 rows from ClickHouse.

loading_portrows
57078, YANTIAN7,486,257
57018, SHEKOU233,731
57067, CHIWAN114,652

5. Check average weight by carrier on the Shenzhen→LA lane to detect parcel vs container traffic before ranking.

Table 5. Check average weight by carrier on the Shenzhen→LA lane to detect parcel vs container traffic before ranking. · 30 rows from ClickHouse.

carrier_sasc_codeunique_bolsavg_kg
EGLV, EAGLE VAN LINES INC539,27312,276
MAEU, MAERSK LINES, INC.407,10810,666
IBRN327,1502
CMDU, COMPAGNIE MARITIME DAFFRETEMEN296,02717,450
AMZD266,5584,554
TZWH261,19830
HANF257,22014
DWCH180,3481,913
GFSY, GENERAL FREIGHT SYSTEMS INC177,9083
APLU, AMERICAN PRESIDENT LINES LTD175,09013,880
MEDU, BCSL US-MED LINE LTD.173,2739,430
HDMU, HYUNDAI MERCHANT MARINE (AMERICA) INC137,7148,765
IEGL136,2156
EXDO, EXPEDITORS INTERNATIONAL134,6508,862
ONEY113,44910,713
CHSL, CHISLEY MOTOR COACHES110,90510,413
YMLU, YANG MING MARINE TRANSPORT CORP110,23311,588
COSU, CHINA OCEAN STEAMSHIP LTD106,95113,339
MSCU, MEDITERRANEAN SHIPPING CORP103,8389,048
JCSM90,2363
BANQ, KUEHNE & NAGEL INC.87,1709,950
GWTH82,5814
HNLT77,16227,622
SDNY69,7877
PXWS69,2085

6. Top consignees by unique bills on Shenzhen→LA lane, weight > 1000 kg, 2014–present, to find the dominant US importers.

Table 6. Top consignees by unique bills on Shenzhen→LA lane, weight > 1000 kg, 2014–present, to find the dominant US importers. · 30 rows from ClickHouse.

consignee_name_stdunique_bolsavg_kgtotal_mt_millions
HOME DEPOT22,57510,424245.3
IKEA SUPPLY21,7415,273116.6
SAMSUNG ELECTRONICS16,09310,616173.5
COSTCO WHOLESALE15,0647,409112.7
CONAIR12,72721,982293.6
HEWLETT PACKARD8,66811,571101.5
MATTEL IMPORT SERVICES8,18714,828124.6
DOLLAR GENERAL7,93818,420152.4
AMAZON SERVICES7,71712,691122.2
TOYS R US DELAWARE7,70112,12693.88
MUNCHKIN7,6977,02957.39
KMART7,50116,558125.3
MATTEL7,39513,662102.7
STEVE MADDEN7,2856,67249.05
J C PENNEY PURCHASING7,1366,63247.41
KIDS II6,9917,31758.15
AMAZON6,73611,81585.81
99 CENTS ONLY STORES6,62915,869105.5
ACER6,40111,55175.01
LG ELECTRONICS5,76011,19065
IKEA DISTRIBUTION SERVICES INC L5,56110,89760.81
NIKE5,2987,72642.59
J B HUNT TRANSPORT5,28822,292121.9
MICHAEL KORS5,2686,13932.63
LITE ON TRADE5,2189,97259.33

7. Total unique bills on the Shenzhen→LA lane by year (weight > 1000 kg) to understand the lane's overall trajectory.

Table 7. Total unique bills on the Shenzhen→LA lane by year (weight > 1000 kg) to understand the lane's overall trajectory. · 13 rows from ClickHouse.

yearunique_bolstotal_mt_millions
2,014340,7505,255.9
2,015311,4535,737.0
2,016364,8904,965.8
2,017385,2817,068.3
2,018338,8445,552.9
2,019364,5985,454.3
2,020385,8426,232.7
2,021360,2746,259.6
2,022326,9545,844.2
2,023423,4617,377.2
2,024403,4857,037.8
2,025418,9655,617.1
2,026315,3034,017.8

8. Year-by-year unique bills on Shenzhen→LA for the top consignees: Home Depot, IKEA Supply, Samsung Electronics, Costco, Conair, Amazon combined — to show 10-year trend.

Table 8. Year-by-year unique bills on Shenzhen→LA for the top consignees: Home Depot, IKEA Supply, Samsung Electronics, Costco, Conair, Amazon combined — to show 10-year trend. · 106 rows from ClickHouse.

yearconsignee_name_stdunique_bols
2,014HEWLETT PACKARD6,279
2,014COSTCO WHOLESALE6,210
2,014HOME DEPOT3,255
2,014SAMSUNG ELECTRONICS1,530
2,014DOLLAR GENERAL1,122
2,014CONAIR476
2,014IKEA SUPPLY116
2,014AMAZON56
2,014AMAZON SERVICES1
2,015COSTCO WHOLESALE7,309
2,015HEWLETT PACKARD2,361
2,015SAMSUNG ELECTRONICS1,726
2,015DOLLAR GENERAL890
2,015HOME DEPOT419
2,015IKEA SUPPLY132
2,015AMAZON87
2,015CONAIR43
2,016DOLLAR GENERAL1,160
2,016SAMSUNG ELECTRONICS954
2,016CONAIR814
2,016AMAZON SERVICES18
2,016IKEA SUPPLY18
2,016HOME DEPOT18
2,016AMAZON18
2,016HEWLETT PACKARD11

9. Verify Conair's average weight on this lane — 22k kg seems very high, check if it is a name fragment issue or genuine heavy cargo.

Table 9. Verify Conair's average weight on this lane — 22k kg seems very high, check if it is a name fragment issue or genuine heavy cargo. · 3 rows from ClickHouse.

consignee_namerowsavg_kgbols
CONAIR CORP8,74022,3798,345
CONAIR LLC4,50821,1624,282
CONAIR CORP USA10724,197100

Limits

This is a fallback exhibit from the query cache. Unique bills must be uniqExact(bill_of_lading). Ocean AMS only. A later turn can still replace this tab with a written paper.