Data and Code for: China in Tax Havens (doi:10.7910/DVN/KJIOXH)

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

Document Description

Citation

Title:

Data and Code for: China in Tax Havens

Identification Number:

doi:10.7910/DVN/KJIOXH

Distributor:

Harvard Dataverse

Date of Distribution:

2023-04-29

Version:

Bibliographic Citation:

Clayton, Christopher; Coppola, Antonio; Dos Santos, Amanda; Maggiori, Matteo; Schreger, Jesse, 2023, "Data and Code for: China in Tax Havens", https://doi.org/10.7910/DVN/KJIOXH, Harvard Dataverse, V1, UNF:6:nDJF79md6lFYFBezpSJViw== [fileUNF]

Study Description

Citation

Title:

Data and Code for: China in Tax Havens

Identification Number:

doi:10.7910/DVN/KJIOXH

Authoring Entity:

Clayton, Christopher (Yale University)

Coppola, Antonio (Stanford University)

Dos Santos, Amanda (Columbia University)

Maggiori, Matteo (Stanford University)

Schreger, Jesse (Columbia University)

Distributor:

Harvard Dataverse

Access Authority:

Global Capital Allocation Project

Depositor:

Global Capital Allocation Project

Date of Deposit:

2023-04-29

Holdings Information:

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

Study Scope

Keywords:

Social Sciences

Abstract:

This package contains replication code and data for the paper "China in Tax Havens" (AEA Papers and Proceedings, 2023).

Methodology and Processing

Sources Statement

Data Access

Other Study Description Materials

File Description--f7082809

File: Restated_Bilateral_External_Portfolios.tab

Number of cases: 398816
No. of variables per record: 15
Type of File: text/tab-separated-values

Notes:

UNF:6:pN0Kk+BFBgGSnay039NYiQ==

File Description--f7082801

File: Restatement_Matrices.tab

Number of cases: 4148327
No. of variables per record: 8
Type of File: text/tab-separated-values

Notes:

UNF:6:54/vnZ8NE3zhd7NwIpsWuw==

Variable Description

List of Variables:

Methodology
Year
Investor_Name
Investor
Asset_Class
Asset_Class_Code
Issuer_Name
Issuer
Position_Residency
Restatement_TH_Only
Restatement_Full
Restatement_Ex_Domestic
Restatement_Sales
Restatement_Sales_Ex_Domestic
Estimated_Common_Equity
Methodology
Year
Investor
Asset_Class
Asset_Class_Code
Destination
Destination_Restated
Value

Variables

Methodology

f7082809 Location:

Value	Label	Frequency
3.	Issuance	325732
2.	Fund Holdings	62920
1.	Enhanced Fund Holdings	10164

Summary Statistics: Mean 2.791262135923076; StDev 0.4649062098047674; Max. 3.0; Min. 1.0; Valid 398816.0;

Variable Format: numeric

Notes: UNF:6:sUl0RFEkugfQb/5ymmDwAg==

Year

f7082809 Location:

Summary Statistics: Max. 2020.0; Min. 2007.0; Mean 2012.474514563111; Valid 398816.0; StDev 3.4050021670934605

Variable Format: numeric

Notes: UNF:6:cYDKsJeyeDpP4dbktHDMiQ==

Investor_Name

f7082809 Location:

Value	Label	Frequency
31.	India	5324
46.	Mexico	5324
19.	Costa Rica	5324
29.	Hungary	5324
40.	Kuwait	5324
9.	Belarus	1936
58.	Saudi Arabia	2420
57.	Russian Federation	5324
65.	Turkey	5324
52.	Panama	5324
39.	Kosovo	3872
5.	Bahamas	3872
34.	Israel	5324
66.	Ukraine	5324
45.	Mauritius	5324
70.	Venezuela, Bolivarian Republic of	5324
20.	Cura��ao	3872
10.	Bermuda	5324
7.	Bangladesh	1936
69.	Uruguay	5324
35.	Japan	5324
21.	Czech Republic	5324
41.	Lebanon	5324
22.	Denmark	12100
14.	Canada	12100
62.	Sweden	12100
67.	United Kingdom	12100
47.	Mongolia	3872
63.	Switzerland	12100
26.	Guernsey	5324
16.	Chile	5324
48.	Netherlands Antilles	1452
61.	Sovranational	5324
30.	Iceland	5324
38.	Korea, Republic of	5324
37.	Kazakhstan	5324
50.	Norway	15488
43.	Macedonia, the Former Yugoslav Republic of	968
2.	Argentina	5324
68.	United States	25652
42.	Macao	5324
18.	Colombia	5324
27.	Honduras	1936
28.	Hong Kong	5324
32.	Indonesia	5324
24.	European Monetary Union	12100
59.	Singapore	5324
44.	Malaysia	5324
6.	Bahrain	4840
12.	Brazil	5324
36.	Jersey	5324
11.	Bolivia, Plurinational State of	3388
23.	Egypt	5324
4.	Australia	2420
64.	Thailand	5324
3.	Aruba	5324
25.	Gibraltar	5324
33.	Isle of Man	5324
51.	Pakistan	5324
56.	Romania	5324
53.	Peru	1452
1.	Albania	1452
54.	Philippines	5324
8.	Barbados	4356
17.	China	1452
15.	Cayman Islands	5324
55.	Poland	5324
60.	South Africa	5324
13.	Bulgaria	5324
49.	New Zealand	5324

Summary Statistics: StDev 20.64832294771204; Mean 39.26941747572902; Valid 398816.0; Max. 70.0; Min. 1.0;

Variable Format: numeric

Notes: UNF:6:2QOgRhke7XlvBe11Ausr/g==

Investor

f7082809 Location:

Variable Format: character

Notes: UNF:6:K+3S3LMZNSyzn0XZzik/ug==

Asset_Class

f7082809 Location:

Value	Label	Frequency
2.	Asset-Backed Securities	3388
1.	All Bonds	186582
4.	Common Equity and Fund Shares	186582
3.	Common Equity	9438
6.	Government Bonds	3388
5.	Corporate Bonds	9438

Summary Statistics: Max. 6.0; Valid 398816.0; Mean 2.596480582524306; StDev 1.534923016563937; Min. 1.0;

Variable Format: numeric

Notes: UNF:6:cpmhuq3/NuMBY3+VQAt2Pg==

Asset_Class_Code

f7082809 Location:

Variable Format: character

Notes: UNF:6:9n0bZJq1vzZ/VF7VY5q6Wg==

Issuer_Name

f7082809 Location:

Value	Label	Frequency
113.	Kiribati	1648
51.	Costa Rica	1648
130.	Madagascar	1648
34.	Burundi	1648
206.	Sudan	1648
12.	Australia	1648
97.	Hungary	1648
147.	Montserrat	1648
1.	Afghanistan	1648
81.	Ghana	1648
116.	Kosovo	1648
41.	Chad	1648
86.	Guadeloupe	1648
179.	Russian Federation	1648
4.	American Samoa	1648
202.	South Sudan	1648
146.	Montenegro	1648
210.	Switzerland	1648
191.	Senegal	1648
38.	Cape Verde	1648
181.	R��union	1648
17.	Bangladesh	1648
52.	Croatia	1648
212.	Taiwan, Province of China	1648
125.	Liechtenstein	1648
194.	Sierra Leone	1648
112.	Kenya	1648
119.	Lao People's Democratic Republic	1648
182.	Saint Helena, Ascension and Tristan da Cunha	1648
172.	Philippines	1648
42.	Chile	1648
137.	Martinique	1648
96.	Hong Kong	1648
189.	Sao Tome and Principe	1648
227.	Ukraine	1648
46.	Colombia	1648
144.	Monaco	1648
72.	Finland	1648
98.	Iceland	1648
99.	India	1648
27.	Bosnia and Herzegovina	1648
103.	Ireland	1648
71.	Fiji	1648
143.	Moldova, Republic of	1648
19.	Belarus	1648
135.	Malta	1648
40.	Central African Republic	1648
166.	Pakistan	1648
61.	Dominican Republic	1648
214.	Tanzania, United Republic of	1648
73.	France	1648
121.	Lebanon	1648
131.	Malawi	1648
92.	Guyana	1648
36.	Cameroon	1648
160.	Nigeria	1648
221.	Tunisia	1648
239.	Western Sahara	1648
149.	Mozambique	1648
13.	Austria	1648
208.	Swaziland	1648
219.	Tonga	1648
215.	Thailand	1648
230.	United States	1648
159.	Niger	1648
53.	Cuba	1648
118.	Kyrgyzstan	1648
111.	Kazakhstan	1648
242.	Zimbabwe	1648
188.	San Marino	1648
100.	Indonesia	1648
106.	Italy	1648
128.	Macao	1648
133.	Maldives	1648
240.	Yemen	1648
7.	Anguilla	1648
167.	Palau	1648
224.	Turks and Caicos Islands	1648
2.	Albania	1648
55.	Cyprus	1648
44.	Christmas Island	1648
168.	Panama	1648
88.	Guatemala	1648
50.	Cook Islands	1648
9.	Argentina	1648
150.	Myanmar	1648
211.	Syrian Arab Republic	1648
8.	Antigua and Barbuda	1648
80.	Germany	1648
76.	French Southern Territories	1648
197.	Slovakia	1648
158.	Nicaragua	1648
204.	Spain	1648
151.	Namibia	1648
31.	Brunei Darussalam	1648
164.	Oman	1648
109.	Jersey	1648
207.	Suriname	1648
110.	Jordan	1648
78.	Gambia	1648
65.	Equatorial Guinea	1648
163.	Norway	1648
101.	Iran, Islamic Republic of	1648
142.	Micronesia, Federated States of	1648
29.	Brazil	1648
195.	Singapore	1648
124.	Libya	1648
49.	Congo, the Democratic Republic of the	1648
141.	Mexico	1648
108.	Japan	1648
171.	Peru	1648
21.	Belize	1648
89.	Guernsey	1648
33.	Burkina Faso	1648
35.	Cambodia	1648
231.	Uruguay	1648
201.	South Africa	1648
185.	Saint Pierre and Miquelon	1648
75.	French Polynesia	1648
156.	New Caledonia	1648
95.	Honduras	1648
152.	Nauru	1648
148.	Morocco	1648
233.	Vanuatu	1648
117.	Kuwait	1648
69.	Falkland Islands (Malvinas)	1648
115.	Korea, Republic of	1648
11.	Aruba	1648
32.	Bulgaria	1648
229.	United Kingdom	1648
126.	Lithuania	1648
154.	Netherlands	1648
85.	Grenada	1648
162.	Norfolk Island	1648
178.	Romania	1648
180.	Rwanda	1648
192.	Serbia	1648
57.	C��te d'Ivoire	1648
67.	Estonia	1648
134.	Mali	1648
218.	Tokelau	1648
196.	Sint Maarten (Dutch part)	1648
169.	Papua New Guinea	1648
213.	Tajikistan	1648
120.	Latvia	1648
235.	Viet Nam	1648
138.	Mauritania	1648
223.	Turkmenistan	1648
122.	Lesotho	1648
77.	Gabon	1648
26.	Bonaire, Sint Eustatius and Saba	1648
63.	Egypt	1648
90.	Guinea	1648
93.	Haiti	1648
155.	Netherlands Antilles	1648
186.	Saint Vincent and the Grenadines	1648
107.	Jamaica	1648
62.	Ecuador	1648
183.	Saint Kitts and Nevis	1648
153.	Nepal	1648
127.	Luxembourg	1648
83.	Greece	1648
241.	Zambia	1648
205.	Sri Lanka	1648
79.	Georgia	1648
94.	Holy See (Vatican City State)	1648
87.	Guam	1648
114.	Korea, Democratic People's Republic of	1648
129.	Macedonia, the Former Yugoslav Republic of	1648
47.	Comoros	1648
15.	Bahamas	1648
184.	Saint Lucia	1648
222.	Turkey	1648
22.	Benin	1648
18.	Barbados	1648
190.	Saudi Arabia	1648
203.	Sovranational	1648
28.	Botswana	1648
91.	Guinea-Bissau	1648
225.	Tuvalu	1648
16.	Bahrain	1648
64.	El Salvador	1648
37.	Canada	1648
45.	Cocos (Keeling) Islands	1648
14.	Azerbaijan	1648
136.	Marshall Islands	1648
157.	New Zealand	1648
170.	Paraguay	1648
105.	Israel	1648
6.	Angola	1648
173.	Pitcairn	1648
176.	Puerto Rico	1648
54.	Cura��ao	1648
30.	British Indian Ocean Territory	1648
132.	Malaysia	1648
10.	Armenia	1648
48.	Congo	1648
20.	Belgium	1648
177.	Qatar	1648
25.	Bolivia, Plurinational State of	1648
139.	Mauritius	1648
58.	Denmark	1648
199.	Solomon Islands	1648
104.	Isle of Man	1648
217.	Togo	1648
3.	Algeria	1648
237.	Virgin Islands, U.S.	1648
140.	Mayotte	1648
60.	Dominica	1648
187.	Samoa	1648
165.	Other	1648
56.	Czech Republic	1648
200.	Somalia	1648
123.	Liberia	1648
24.	Bhutan	1648
234.	Venezuela, Bolivarian Republic of	1648
209.	Sweden	1648
226.	Uganda	1648
161.	Niue	1648
82.	Gibraltar	1648
216.	Timor-Leste	1648
102.	Iraq	1648
70.	Faroe Islands	1648
174.	Poland	1648
198.	Slovenia	1648
145.	Mongolia	1648
23.	Bermuda	1648
84.	Greenland	1648
175.	Portugal	1648
68.	Ethiopia	1648
220.	Trinidad and Tobago	1648
5.	Andorra	1648
193.	Seychelles	1648
43.	China	1648
236.	Virgin Islands, British	1648
238.	Wallis and Futuna	1648
59.	Djibouti	1648
232.	Uzbekistan	1648
228.	United Arab Emirates	1648
39.	Cayman Islands	1648
74.	French Guiana	1648
66.	Eritrea	1648

Summary Statistics: Min. 1.0; Mean 121.5; Max. 242.0; Valid 398816.0; StDev 69.85887371606235;

Variable Format: numeric

Notes: UNF:6:VKxJ9O+XPXHlY3v3g3Mw0A==

Issuer

f7082809 Location:

Variable Format: character

Notes: UNF:6:VbGJ03Z3caiNDa53SuWBlQ==

Position_Residency

f7082809 Location:

Summary Statistics: Mean 5596.052958568354; Valid 398791.0; StDev 166590.50786254424; Max. 2.6737168E7; Min. -3935.6418708363

Variable Format: numeric

Notes: UNF:6:+iY029kyzn31Pd9VDGwdWw==

Restatement_TH_Only

f7082809 Location:

Summary Statistics: Valid 398791.0; StDev 171252.7226007614; Mean 5596.052632020017; Min. -3935.641845703125; Max. 2.757374328307724E7;

Variable Format: numeric

Notes: UNF:6:NteE6qjid+xcQpQoJNy3SQ==

Restatement_Full

f7082809 Location:

Summary Statistics: Min. -3935.641845703125; Mean 18040.21334529839; Max. 2.7530574659651518E7; StDev 310912.12242626183; Valid 116135.0;

Variable Format: numeric

Notes: UNF:6:zaXHSC9C59f50l8waQo0hg==

Restatement_Ex_Domestic

f7082809 Location:

Summary Statistics: Max. 2.7745788659651518E7; Valid 398791.0; Min. -3935.641845703125; Mean 5596.05255444471; StDev 172036.10247610023

Variable Format: numeric

Notes: UNF:6:Jnk34/Zxy5p6uduengrj+w==

Restatement_Sales

f7082809 Location:

Summary Statistics: Mean 17621.271399529498; StDev 228916.73256667593; Max. 1.9259074552984554E7; Valid 109359.0; Min. -2587.853909331561;

Variable Format: numeric

Notes: UNF:6:Q9kgfUK/99MA40aG+jMY/Q==

Restatement_Sales_Ex_Domestic

f7082809 Location:

Summary Statistics: Max. 2.8684986448386405E7; Mean 5215.019649705629; Min. -3310.6045196831237; Valid 386691.0; StDev 169845.3691055981

Variable Format: numeric

Notes: UNF:6:cFa8j9HRnVsd45aNAtV9og==

Estimated_Common_Equity

f7082809 Location:

Summary Statistics: StDev 8353.020165816488; Max. 579394.9375; Mean 784.4507941522832; Min. -55.85611343383789; Valid 40067.0

Variable Format: numeric

Notes: UNF:6:vfReBnP1TtaT1owquu2neA==

Methodology

f7082801 Location:

Value	Label	Frequency
3.	Issuance	32252
1.	Enhanced Fund Holdings	25429
6.	Sales-Based, Issuance	478092
5.	Sales-Based, Fund Holdings	3088409
4.	Sales-Based, Enhanced Fund Holdings	356749
2.	Fund Holdings	167396

Summary Statistics: Max. 6.0; Mean 4.868123944954255; StDev 0.8223188192666752; Min. 1.0; Valid 4148327.0

Variable Format: numeric

Notes: UNF:6:Wzr75YcqWDBotlt2CDStqQ==

Year

f7082801 Location:

Summary Statistics: Mean 2013.6962170531915; Min. 2007.0; Valid 4148327.0; Max. 2020.0; StDev 3.8963940370620826;

Variable Format: numeric

Notes: UNF:6:yn6fJeqCWX1OFgOBp4hfzw==

Investor

f7082801 Location:

Variable Format: character

Notes: UNF:6:h0nWb2/12C/gmhHaOe3gvQ==

Asset_Class

f7082801 Location:

Value	Label	Frequency
1.	All Bonds	1030495
3.	Common Equity	1908798
5.	Government Bonds	2582
2.	Asset-Backed Securities	3593
4.	Corporate Bonds	1202859

Summary Statistics: Mean 2.7935167598871566; StDev 1.115496294283763; Max. 5.0; Min. 1.0; Valid 4148327.0

Variable Format: numeric

Notes: UNF:6:4cY1QjlfVeiDuei6QDXUUg==

Asset_Class_Code

f7082801 Location:

Variable Format: character

Notes: UNF:6:EgyE1h5m00ml6AHR3Yl2zA==

Destination

f7082801 Location:

Variable Format: character

Notes: UNF:6:ImbmSvZTQ/6j8Nqb8fszzA==

Destination_Restated

f7082801 Location:

Variable Format: character

Notes: UNF:6:0eRWuA5cSMGy6UNhEUPuzQ==

Value

f7082801 Location:

Summary Statistics: Mean 0.0410360611883152; Max. 1.0000000223517422; Min. 1.4350780534681915E-15; StDev 0.18513016393583479; Valid 4148327.0;

Variable Format: numeric

Notes: UNF:6:aOA94MULb2QLbcrkT+L9NA==

Other Study-Related Materials

Label:

README.pdf

Notes:

application/pdf

Other Study-Related Materials

Label:

Append_MS_Data.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Currency.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Firm_Level.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Holdings.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Issuance.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Master_Build.sh

Notes:

application/x-sh

Other Study-Related Materials

Label:

Master_Controller.sh

Notes:

application/x-sh

Other Study-Related Materials

Label:

Master_Controller_R.sh

Notes:

application/x-sh

Other Study-Related Materials

Label:

MS_Data.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Project_Globals.do

Notes:

application/x-stata-syntax

Other Study-Related Materials

Label:

Sankey_Plot.R

Notes:

type/x-r-syntax

Other Study-Related Materials

Label:

scheme-gcap_solid.scheme

Notes:

application/octet-stream