Mirror Trade Database V2 (1948-2021) (doi:10.7910/DVN/HOOTBB)

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 V2 (1948-2021)

doi:10.7910/DVN/HOOTBB

Harvard Dataverse

2023-01-09

2

Linsi, Lukas; Brian Burgoon; Daniel Mügge; Stefan Sliwa Ruiz, 2023, "Mirror Trade Database V2 (1948-2021)", https://doi.org/10.7910/DVN/HOOTBB, Harvard Dataverse, V2, UNF:6:2fzcWFh05IJlupextVCnpA== [fileUNF]

Mirror Trade Database V2 (1948-2021)

doi:10.7910/DVN/HOOTBB

Linsi, Lukas (University of Groningen)

Brian Burgoon (University of Amsterdam)

Daniel Mügge (University of Amsterdam)

Stefan Sliwa Ruiz (University of Groningen)

Harvard Dataverse

Linsi, Lukas

Linsi, Lukas

2023-01-09

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

Social Sciences, trade

Version 2 of the Mirror Trade Database, covering the years 1948-2021. 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: 9066

• No. of variables per record: 12

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

UNF:6:93vOhg8KwShpzCkY+FQOJQ==

• Number of cases: 9066

• No. of variables per record: 12

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

UNF:6:+nwXJ8GGXZD+z8L/jicVIA==

• year - year
• country_name - country_name
• country_code - country_code
• 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
• year - Year
• country_name - Country name
• country_code - Alpha-2 code
• 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

f6881102 Location:

Summary Statistics: StDev 20.71926573221158; Max. 2021.0; Valid 9066.0; Mean 1990.0906684315023; Min. 1948.0

Variable Format: numeric

Notes: UNF:6:TZlQnNiLZ2/D7io8yJDumQ==

f6881102 Location:

Variable Format: character

Notes: UNF:6:1WzKccdMVH8Qh88k1bEZOA==

f6881102 Location:

Variable Format: character

Notes: UNF:6:BzlPMTGYsYD9WvobyTlS/Q==

f6881102 Location:

Summary Statistics: Min. 0.0044749998; Max. 2717247.8; StDev 142166.27700016965; Mean 35461.126859875105; Valid 8939.0

Variable Format: numeric

Notes: UNF:6:iFFv6wZkARarc0GR6RVoog==

f6881102 Location:

Summary Statistics: Max. 2750836.3; StDev 132804.61547175155; Mean 34057.45842166943; Valid 8939.0; Min. 0.0044749998

Variable Format: numeric

Notes: UNF:6:B9pDDBAJ1akqaaG1AKJACA==

f6881102 Location:

Summary Statistics: Valid 8851.0; StDev 130822.52837809359; Mean 35772.225698790506; Max. 2759581.0; Min. 0.0060000001

Variable Format: numeric

Notes: UNF:6:GrbEw5yU8yJOmjEZuaEiYA==

f6881102 Location:

Summary Statistics: Max. 2853060.8; Mean 34347.32372444999; Valid 8851.0; StDev 126734.98370961846; Min. 0.0080000004

Variable Format: numeric

Notes: UNF:6:aAG5AQZIyOtrEjCv3BejSw==

f6881102 Location:

Summary Statistics: Min. 0.89999998; StDev 261252.78585100995; Valid 8724.0; Mean 70726.49951089801; Max. 4882512.0

Variable Format: numeric

Notes: UNF:6:pc7qPnNwJHp4AgvnH8TlsQ==

f6881102 Location:

Summary Statistics: Mean 70661.9253065539; Max. 4253653.0; StDev 254197.77917872817; Valid 8724.0; Min. 0.77999997;

Variable Format: numeric

Notes: UNF:6:tjvY0V7oBoukT00cDvEoPQ==

f6881102 Location:

Summary Statistics: Max. 1.9891953; StDev 0.2459474633572675; Min. 0.0; Mean 0.19492476950406162; Valid 8939.0

Variable Format: numeric

Notes: UNF:6:K5d+rUlN8vpG/A4i+1f7qw==

f6881102 Location:

Summary Statistics: Mean 0.2669747390209027; Valid 8851.0; StDev 0.3359160216057148; Max. 1.9923156; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:OUTmq3xibHeZZ/FQhpd3tw==

f6881102 Location:

Summary Statistics: Mean 0.1799841243639326; Valid 8724.0; Min. 1.6150861E-5; StDev 0.2504394118991772; Max. 1.990503

Variable Format: numeric

Notes: UNF:6:uapUSjz//6O7E2KHoIbt9g==

f6881105 Location:

Summary Statistics: Valid 9066.0; StDev 20.71926573221158; Min. 1948.0; Max. 2021.0; Mean 1990.0906684315023;

Variable Format: numeric

Notes: UNF:6:TZlQnNiLZ2/D7io8yJDumQ==

f6881105 Location:

Variable Format: character

Notes: UNF:6:VBmyX4qbLsm6trfH4pOt9Q==

f6881105 Location:

Variable Format: character

Notes: UNF:6:BzlPMTGYsYD9WvobyTlS/Q==

f6881105 Location:

Summary Statistics: StDev 142166.2761397795; Min. 0.004474999848753214; Mean 35461.12677287472; Max. 2717247.75; Valid 8939.0

Variable Format: numeric

Notes: UNF:6:kL8zGah4Rsk9sWh8o5x8iA==

f6881105 Location:

Summary Statistics: StDev 132804.61423269185; Mean 34057.45828778687; Min. 0.004474999848753214; Max. 2750836.25; Valid 8939.0

Variable Format: numeric

Notes: UNF:6:rMfESyvnmAfrM3W2drvjzw==

f6881105 Location:

Summary Statistics: StDev 130822.52748177442; Max. 2759581.0; Valid 8851.0; Min. 0.006000000052154064; Mean 35772.225594060845

Variable Format: numeric

Notes: UNF:6:FxTz7flhDvAT1Jfu4B0nLA==

f6881105 Location:

Summary Statistics: Max. 2853060.75; Min. 0.00800000037997961; Valid 8851.0; StDev 126734.98294838922; Mean 34347.3236224337

Variable Format: numeric

Notes: UNF:6:I83ZuThHqjiLketTchYA+g==

f6881105 Location:

Summary Statistics: Mean 70726.4991664554; Valid 8724.0; Max. 4882512.0; StDev 261252.78401732497; Min. 0.8999999761581421;

Variable Format: numeric

Notes: UNF:6:zNMOct0Pxiq8EEqht2RsQA==

f6881105 Location:

Summary Statistics: Valid 8724.0; Max. 4253653.0; StDev 254197.77750438312; Mean 70661.92497205077; Min. 0.7799999713897705;

Variable Format: numeric

Notes: UNF:6:9/O4/9K4VAHv3PkjLu+wbg==

f6881105 Location:

Summary Statistics: Valid 8939.0; Max. 1.9891953468322754; Min. 0.0; StDev 0.245947463454813; Mean 0.19492476951999121

Variable Format: numeric

Notes: UNF:6:QbGOjdoLa9nVbA2E+gqNDw==

f6881105 Location:

Summary Statistics: Max. 1.992315649986267; Valid 8851.0; Mean 0.26697473906118124; Min. 0.0; StDev 0.3359160217484613

Variable Format: numeric

Notes: UNF:6:4wwxlEI+AHn+4O28dsn1Kw==

f6881105 Location:

Summary Statistics: StDev 0.25043941169237355; Mean 0.17998412433044247; Min. 1.6150861483765766E-5; Max. 1.990502953529358; Valid 8724.0

Variable Format: numeric

Notes: UNF:6:RBphfhNziLy8Sc04WCahkg==

Label:

codebook mirror trade database v2.pdf

Text:

Codebook describing variables in dyadic and monadic datasets

application/pdf

Label:

code used to generate monadic values(2).do

Text:

STATA do-file used to derive monadic values

application/x-stata-syntax

Label:

code used to generate weighted averages(1).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 on which the database builds upon

application/pdf

Label:

mirrortrade_dyadic.csv

Text:

Mirror Trade Database for dyadic (bilateral) trade, 1948-2021 [csv]

text/csv

Label:

mirrortrade_dyadic.dta

Text:

Mirror Trade Database for dyadic (bilateral) trade, 1948-2021 [dta]

application/x-stata-14