Mirror Trade Database V1 (1950-2014) (doi:10.7910/DVN/RBRHFE)

View:

Part 1: Document Description
Part 2: Study Description
Part 3: Data Files Description
Part 4: Variable Description
Part 5: Other Study-Related Materials
Entire Codebook

Mirror Trade Database V1 (1950-2014)

doi:10.7910/DVN/RBRHFE

Harvard Dataverse

2022-11-13

2

Linsi, Lukas; Burgoon, Brian; Mügge, Daniel, 2022, "Mirror Trade Database V1 (1950-2014)", https://doi.org/10.7910/DVN/RBRHFE, Harvard Dataverse, V2, UNF:6:+Kdmqii7RYjt5MczsSFHNA== [fileUNF]

Mirror Trade Database V1 (1950-2014)

doi:10.7910/DVN/RBRHFE

Linsi, Lukas (University of Groningen)

Burgoon, Brian (University of Amsterdam)

Mügge, Daniel (University of Amsterdam)

Harvard Dataverse

Linsi, Lukas

Linsi, Lukas

2022-11-13

https://doi.org/10.7910/DVN/RBRHFE

Social Sciences, trade

Version 1 of the Mirror Trade Database, covering the years 1950-2014. It contains two databases: one for dyadic (bilateral) trade, and one for monadic (country-level) trade. The databases enable researchers to adjust statistical analyses of international trade flows for mirror trade asymmetries. For all trading relationships, the dyadic database provides two mirror observations of all recorded flows, as well as a quality-weighted average of the two. We recommend checking the robustness of trade-related analyses at the bilateral level by running the analyses using either side of the mirror and the weighted average of the two. The monadic database contains estimates, for each country-year, of the aggregate value of the subset of flows that are observed twice independently by "home" and partner countries, and a derived ABBA factor indicating the size of monadic ABBA discrepancies relative to the size of the trade value. The higher the monadic ABBA factor, the lower the inferred measurement quality. Monadic ABBA factors are available for imports, exports and total trade. The databases are provided in dta and csv format. Variables are defined in the codebook. Furthermore, we provide the do-files with the STATA code that were used to generate the weighed averages and monadic ABBA values. Researchers should feel free to adapt those codes according to their own needs. The rationale of the databases and recommendations for researchers are described in more detail in the underlying journal article published in International Studies Quarterly.

10.1093/isq/sqad020

Linsi, L., Burgoon, B., Mügge, D. (2023), "The Problem with Trade Measurement in International Relations", International Studies Quarterly 67(2).

• Number of cases: 1344648

• No. of variables per record: 8

• Type of File: text/tab-separated-values

UNF:6:nRYs6pffq3T3bMqSmrE57g==

• Number of cases: 1344648

• No. of variables per record: 8

• Type of File: text/tab-separated-values

UNF:6:wm/VeDbuloME/TNF/GCc/A==

• Number of cases: 9556

• No. of variables per record: 12

• Type of File: text/tab-separated-values

UNF:6:aXwQp4PZVu374vYiqU8saQ==

• Number of cases: 9556

• No. of variables per record: 12

• Type of File: text/tab-separated-values

UNF:6:0kfFwy3icgsVydA+5shzdw==

• cowcodeA - COW country code trade partner A
• cowcodeB - COW country code trade partner B
• countryA_name - Name country A
• countryB_name - Name country B
• year - Year
• flowBAA - trade flow from B to A according to A; in mio USD; from IMF DOTS
• flowBAB - mirror value: trade flow from B to A according to B; in mio USD; from IMF DOTS
• flowWAV - weighted average of mirror flows
• cowcodeA - cowcodeA
• cowcodeB - cowcodeB
• countryA_name - countryA_name
• countryB_name - countryB_name
• year - year
• flowBAA - flowBAA
• flowBAB - flowBAB
• flowWAV - flowWAV
• cowcode - cowcode
• country_name - country_name
• year - year
• mirrorimports_home - mirrorimports_home
• mirrorimports_partners - mirrorimports_partners
• mirrorexports_partners - mirrorexports_partners
• mirrorexports_home - mirrorexports_home
• mirrortrade_home - mirrortrade_home
• mirrortrade_partners - mirrortrade_partners
• importABBA_relimp - importABBA_relimp
• exportABBA_relexp - exportABBA_relexp
• tradeABBA_reltrade - tradeABBA_reltrade
• cowcode - COW code
• country_name - Country name
• year - Year
• mirrorimports_home - Monadic aggregate mirror imports, home
• mirrorimports_partners - Monadic aggregate mirror imports, partners
• mirrorexports_partners - Monadic aggregate mirror exports, partners
• mirrorexports_home - Monadic aggregate mirror exports, home
• mirrortrade_home - Monadic aggregate mirror trade, home
• mirrortrade_partners - Monadic aggregate mirror trade, partners
• importABBA_relimp - imports ABBA relative to total value of imports (average of home and partner est
• exportABBA_relexp - exports ABBA relative to total value of exports (average of home and partner est
• tradeABBA_reltrade - total trade ABBA relative to total value of trade (average of home and partner e

f6707574 Location:

Summary Statistics: Valid 1344648.0; Min. 2.0; Max. 990.0; Mean 446.3365579727453; StDev 253.19110090588904

Variable Format: numeric

Notes: UNF:6:OKRjeOCgw1YSukQNMABh2g==

f6707574 Location:

Summary Statistics: Mean 446.3365579690955; StDev 253.1911009053063; Valid 1344648.0; Min. 2.0; Max. 990.0

Variable Format: numeric

Notes: UNF:6:otAdAYh/fYYRpW5XtUjQ9Q==

f6707574 Location:

Variable Format: character

Notes: UNF:6:cNQrEehM7Js1pM77iJCpjg==

f6707574 Location:

Variable Format: character

Notes: UNF:6:tqtNL3Ftx/pLQBAA7u9lEQ==

f6707574 Location:

Summary Statistics: Valid 1344648.0; Mean 1989.314427270182; Min. 1950.0; Max. 2014.0; StDev 16.540737036895475;

Variable Format: numeric

Notes: UNF:6:3YNMB2dDh78IeQcdI+ex5A==

f6707574 Location:

Summary Statistics: Max. 466754.46875; Min. 0.0; Valid 1118921.0; StDev 3061.7545377525867; Mean 216.92009637970526

Variable Format: numeric

Notes: UNF:6:taNfeJomgM3dC7oR0zv1CQ==

f6707574 Location:

Summary Statistics: Mean 228.49209993205315; Valid 873879.0; Max. 397099.3125; StDev 3150.411419250809; Min. 0.0

Variable Format: numeric

Notes: UNF:6:p/7+4M9+zc6rGsJce5qWZg==

f6707574 Location:

Summary Statistics: Min. 0.0; Mean 363.6742774670964; Valid 495205.0; StDev 4108.135545900994; Max. 417377.25

Variable Format: numeric

Notes: UNF:6:d+20TlhtFY+1wuveFKJNQQ==

f6707576 Location:

Summary Statistics: Max. 990.0; StDev 253.19110090588904; Valid 1344648.0; Min. 2.0; Mean 446.3365579727453

Variable Format: numeric

Notes: UNF:6:OKRjeOCgw1YSukQNMABh2g==

f6707576 Location:

Summary Statistics: Min. 2.0; Mean 446.3365579690955; StDev 253.1911009053063; Max. 990.0; Valid 1344648.0

Variable Format: numeric

Notes: UNF:6:otAdAYh/fYYRpW5XtUjQ9Q==

f6707576 Location:

Variable Format: character

Notes: UNF:6:cNQrEehM7Js1pM77iJCpjg==

f6707576 Location:

Variable Format: character

Notes: UNF:6:tqtNL3Ftx/pLQBAA7u9lEQ==

f6707576 Location:

Summary Statistics: Min. 1950.0; StDev 16.540737036895475; Max. 2014.0; Valid 1344648.0; Mean 1989.314427270182

Variable Format: numeric

Notes: UNF:6:3YNMB2dDh78IeQcdI+ex5A==

f6707576 Location:

Summary Statistics: StDev 3061.7545408564615; Valid 1118921.0; Min. 0.0; Max. 466754.47; Mean 216.9200964703121

Variable Format: numeric

Notes: UNF:6:njwE0b6ZQMyU4Vs7wwLUbA==

f6707576 Location:

Summary Statistics: Min. 0.0; Max. 397099.31; Mean 228.49209994354428; StDev 3150.4114196822993; Valid 873879.0

Variable Format: numeric

Notes: UNF:6:BXTWrisF0SwtB96QaZkAgg==

f6707576 Location:

Summary Statistics: Min. 0.0; Max. 417377.25; Valid 495205.0; StDev 4108.1355494473; Mean 363.67427757919967

Variable Format: numeric

Notes: UNF:6:TmydNveQejT5WhlAIuFEiQ==

f6707572 Location:

Summary Statistics: StDev 254.01388812639425; Valid 9556.0; Min. 20.0; Mean 456.40906236922393; Max. 990.0

Variable Format: numeric

Notes: UNF:6:B6kFMgpRvisrKLiDw52vqQ==

f6707572 Location:

Variable Format: character

Notes: UNF:6:w0C5nJnF+t16l7xCSROgrg==

f6707572 Location:

Summary Statistics: Valid 9556.0; Min. 1950.0; Mean 1986.4190037672665; Max. 2014.0; StDev 17.660459131527602;

Variable Format: numeric

Notes: UNF:6:cYZiwCgYmDLHfKdUUWmecw==

f6707572 Location:

Summary Statistics: Max. 1151459.4; Mean 20206.882160753652; Min. 0.0; Valid 7606.0; StDev 74231.8621010357;

Variable Format: numeric

Notes: UNF:6:1a9PajxM4mPZsUYkLc8mqA==

f6707572 Location:

Summary Statistics: StDev 70752.10142319532; Min. 0.0; Mean 19382.583644355433; Max. 1076457.3; Valid 7606.0

Variable Format: numeric

Notes: UNF:6:dEAkMq5pjoQib+9WZroLbQ==

f6707572 Location:

Summary Statistics: StDev 84652.49048218779; Mean 21249.250909692073; Valid 7749.0; Max. 1844785.3; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:xiCweFtyBzCvec6aO00UfA==

f6707572 Location:

Summary Statistics: StDev 78199.5973086677; Valid 7749.0; Min. 0.0; Max. 1575027.1; Mean 20236.00570010364;

Variable Format: numeric

Notes: UNF:6:fHqnfYi6z4VM3s48/sxoTg==

f6707572 Location:

Summary Statistics: Min. 0.0; StDev 150812.31693931573; Mean 41252.176044072265; Max. 2403910.0; Valid 7526.0

Variable Format: numeric

Notes: UNF:6:ib7co++/mcHakvDPOPjqvA==

f6707572 Location:

Summary Statistics: Max. 2503961.5; Valid 7526.0; Mean 41462.224530625346; Min. 0.0; StDev 152115.60972433022;

Variable Format: numeric

Notes: UNF:6:nzjQ0/0AVLrMlQopq5Q58A==

f6707572 Location:

Summary Statistics: Min. 0.0; StDev 0.2727578804845384; Valid 7153.0; Max. 2.0; Mean 0.20946823625449887

Variable Format: numeric

Notes: UNF:6:uTKvMsCw54Bck5G8d4I2Lg==

f6707572 Location:

Summary Statistics: Min. 0.0; Valid 7562.0; StDev 0.4400367294225672; Max. 2.0; Mean 0.3455793898757663

Variable Format: numeric

Notes: UNF:6:jWTCYcxpsFUZooIvFWRk3Q==

f6707572 Location:

Summary Statistics: Valid 7395.0; Min. 0.0; Mean 0.24096271158822677; StDev 0.33857869299993726; Max. 2.0;

Variable Format: numeric

Notes: UNF:6:n+D/mdN3FnSsbllwAn0Q9g==

f6707573 Location:

Summary Statistics: Valid 9556.0; Min. 20.0; Max. 990.0; Mean 456.40906236922393; StDev 254.01388812639425

Variable Format: numeric

Notes: UNF:6:B6kFMgpRvisrKLiDw52vqQ==

f6707573 Location:

Variable Format: character

Notes: UNF:6:w0C5nJnF+t16l7xCSROgrg==

f6707573 Location:

Summary Statistics: Min. 1950.0; Valid 9556.0; Max. 2014.0; StDev 17.660459131527602; Mean 1986.4190037672665

Variable Format: numeric

Notes: UNF:6:cYZiwCgYmDLHfKdUUWmecw==

f6707573 Location:

Summary Statistics: Min. 0.0; StDev 74231.86169840531; Mean 20206.882115223176; Max. 1151459.375; Valid 7606.0

Variable Format: numeric

Notes: UNF:6:gSWhEW0TbSChsf2GAu+2bw==

f6707573 Location:

Summary Statistics: Valid 7606.0; Min. 0.0; StDev 70752.10130327413; Max. 1076457.25; Mean 19382.58360612715

Variable Format: numeric

Notes: UNF:6:/TXz54GdqQMlD8+GfOT1EA==

f6707573 Location:

Summary Statistics: StDev 84652.49002453816; Max. 1844785.25; Min. 0.0; Valid 7749.0; Mean 21249.250865916867

Variable Format: numeric

Notes: UNF:6:V/z01Hv88r7d3nMAMiVVgQ==

f6707573 Location:

Summary Statistics: StDev 78199.59694504068; Min. 0.0; Max. 1575027.125; Mean 20236.005655867295; Valid 7749.0;

Variable Format: numeric

Notes: UNF:6:ylry9qlWimyZimIWlzDXiQ==

f6707573 Location:

Summary Statistics: Max. 2403910.0; Valid 7526.0; StDev 150812.31594297246; Min. 0.0; Mean 41252.1759007106

Variable Format: numeric

Notes: UNF:6:eXAZPnozvPKbsPSei75q6A==

f6707573 Location:

Summary Statistics: Mean 41462.22439897341; Min. 0.0; Max. 2503961.5; StDev 152115.60887246326; Valid 7526.0

Variable Format: numeric

Notes: UNF:6:a/4L18/KG83ddNl/Ek4Qxg==

f6707573 Location:

Summary Statistics: Mean 0.2094682361915068; Valid 7153.0; Min. 0.0; StDev 0.27275788025846376; Max. 2.0;

Variable Format: numeric

Notes: UNF:6:6GCq+cC05jYzEUVQ+hSFHw==

f6707573 Location:

Summary Statistics: Min. 0.0; StDev 0.4400367296759052; Valid 7562.0; Mean 0.34557939000080795; Max. 2.0;

Variable Format: numeric

Notes: UNF:6:wqs7OTSkdzji6q/i4YdNhQ==

f6707573 Location:

Summary Statistics: StDev 0.33857869306090005; Max. 2.0; Valid 7395.0; Mean 0.2409627115903248; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:qTiLO/87NAI5vyZgo/W6Kg==

Label:

codebook mirror trade database v1.pdf

Text:

Codebook describing variables in dyadic and monadic datasets

application/pdf

Label:

code used to generate monadic values.do

Text:

STATA do-file used to derive monadic values

application/x-stata-syntax

Label:

code used to generate weighted averages.do

Text:

STATA do-file used to generate weighted averages

application/x-stata-syntax

Label:

LBM trade measurement isq2023.pdf

Text:

Journal article in ISQ providing background on which the database is built

application/pdf