Data Website

for Hummels, David, "Transportation Costs and International Trade in the Second Era of Globalization", Journal of Economic Perspectives, Vol 21, No 3, pp 131-154.

• Please cite this paper if you use these data
• The author thanks the National Science Foundation for funding this project under Award Number 0318242.

Data Figures and Tables in the Paper

table1.xls

table2.xls

FIgures1_4.zip

• This zip file contains all the stata code and stata datasets to generate figures 1-4.

Table2_Figure5_6.zip

• This (large -- 50 MB) zip file contains all the stata code and datasets to generate table 2 and figures 5 and 6.
• Of special note, it contains "sitcreallysmall_allyears.dta".  This is a data set covering US imports from 1974-2004, with detail on exporting country x SITC revision 2 (5 digit) commodity x transport mode.  It contains shipment values, weight, quantity, tariffs, and transportation charges.

Details on Construction of the dataset

These data come from annual Imports of Merchandise CDs provided by the Census bureau. Full details on

this set of CD's can be found here...

http://www.census.gov/foreign-trade/reference/products/catalog/fl_imp.txt

The particular database employed in each year from those CD's is IMP_DETL.DBF

The file below takes these data and does the following transformations

1. Data are concorded from TSUSA -> SITC Rev 2 or from HS -> SITC Rev 2, depending on the year

2. Data are aggregated across product codes and entry ports so that there is a single observation for each exporter x SITC2 product

The specific data are below

Contains data from Table2_Figure5_6.zip\sitcreallysmall_allyears.dta

obs: 1,388,675

vars: 15 9 Mar 2006 10:52

size: 154,142,925 (70.6% of memory free)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

storage display value

variable name type format label variable label

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

ctry int %10.0g Census country subcode

sitc2 str5 %9s SITC Rev 2, 5 digit

con_qy1 double %10.0g Imports for Consumption, 1st Unit of Quantity

con_qy2 double %10.0g Imports for Consumption, 2nd Unit of Quantity

con_val double %10.0g Imports for Consumption, Customs Value

ves_val double %10.0g Shipments by Ocean Vessel, Customs Value

air_val double %10.0g Shipments by Air, Customs Value

con_cha double %10.0g Imports for Consumption,Import Charges (Freight)

ves_cha double %10.0g Shipments by Ocean Vessel, Import Charges (Freight)

air_cha double %10.0g Shipments by Air, Import Charges (Freight)

air_wgt double %10.0g Shipments by Air, Shipping Weight (KG)

ves_wgt double %10.0g Shipments by Ocean Vessel, SHipping Weight (KG)

duty double %10.0g Import Duties

rec double %12.0g NUmber of Detailed Records

yr float %9.0g Year

Additional Supporting Data

Modal Quantities

sea transport growth statistics.xls

IATA air transport growth statistics.xls

Modal Prices

bls air price indices.xls  (Bureau of Labor Statistics index number price data on air passenger and air freight)

icao data.xls    (International Civil Aviation Organization data on air fares and air freights by international region 1973-1993)

• definition of icao route groups.pdf

ocean price indices.xls   (Various index numbers for ocean shipping prices from 1948 onward)

per commodity ad-valorem rates.xls  (liner shipping rates for specific commodities 1963-2004)