{"id":34711,"date":"2022-10-22T22:48:05","date_gmt":"2022-10-23T02:48:05","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=34711"},"modified":"2022-10-22T22:48:05","modified_gmt":"2022-10-23T02:48:05","slug":"chinese-global-development-trends-2000-2017","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/chinese-global-development-trends-2000-2017\/","title":{"rendered":"Chinese Global Development Trends: 2000-2017"},"content":{"rendered":"\n

Background<\/em><\/strong><\/p>\n\n\n\n

Along with China\u2019s rise as a global superpower in recent decades, the Chinese government has expanded its vision to territories beyond their national borders and into the world. Indeed, \u201csince the turn of the century, China has doled out nearly as much aid as the United States, even if it has kept that financing low-key and hard to track.\u201d (Allen-Ebrahimian, 2017) Furthermore, after the current President of China, Jinping Xi, came to power in 2013, he subsequently unrolled the \u201cBelt and Road\u201d initiative that was nominally supposed to help develop global infrastructure, but rumors circulated that these projects were in reality a neo-colonial effort to dominate resources and grow China\u2019s global influence and power. (Ani, 2022) <\/p>\n\n\n\n

In my report, I wish to use AidData\u2019s incredibly comprehensive dataset on Chinese global development projects from 2000 to 2017 to get a glimpse of the nature and the intentions behind these \u201cforeign aid\u201d projects. This dataset captures \u201cvast amounts of unstructured, open-source, project-level information\u201d about 13,427 projects that are worth $843 billion across 145 countries, and includes variables related to debt conditions, transactional details, and project implementation. As the scope of this dataset is large, this lab report will only serve as an exploratory study of my final project. Research questions of interest include: the destination of these funds, the length of the projects, and the amount of money spent on these projects.<\/p>\n\n\n\n

Materials<\/em><\/strong><\/p>\n\n\n\n

Dataset: Global Chinese Development Finance Dataset, Version 2.0 \u2013 AidData<\/a><\/p>\n\n\n\n

Tools: Excel (data analysis), Tableau (data visualization)<\/p>\n\n\n\n

Methods<\/em><\/strong><\/p>\n\n\n\n

Viz #1: First, I would like to understand which countries received the most amounts of money from China and if there are any continental trends in these countries. As 139 projects only have a continent designation instead of a country one (these projects contains the word \u201cregional\u201d, as in \u201cAfrica, regional\u201d), I filtered these out. Then, I aggregated the \u201cAmount (Constant US2017)\u201d field by their sum (since I\u2019m interested in the total value committed by China), which is the inflation-adjusted monetary value of the official commitment issued by the Chinese funding agency. Then I color-coded them by their continents, which is recorded in the \u201cRecipient Region\u201d field. <\/p>\n\n\n\n

Viz#2: Second, I would like to understand the average project length and if they have grown longer or shorter with time. In order to do this, I took two fields, \u201cCommitment Year\u201d and \u201cCompletion Year\u201d, removed their null values, and added a new calculated field that took the difference of the two called \u201cProject Length\u201d. Then, I plotted the average of these differences against the \u201cCommitment Year\u201d as a time variable. <\/p>\n\n\n\n

Viz #3: Lastly, I tried to understand if there are any meaningful relationships between average project length and the amount spent on each project across the years, with the latter being a possible indicator of project size. To do this, I chose a dual line chart and plotted the average of the \u201cProject Length\u201d field and the \u201cAmount (Constant US2017)\u201d variable against the \u201cCommitment Year\u201d. <\/p>\n\n\n\n

Results<\/em><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Viz #1<\/strong>: The top 20 countries that received the most funding are listed in this bar chart. A quick glance of this first visualization shows that Russia received the most amount of project development funds in total from 2000-2017, at ~$183 billion, followed by Venezuela at ~$173 billion. One can also see that among these top 20 countries, 7 are from Asia, 5 are from Africa, 4 are from the Americas, 3 are from Europe (all from Eastern Europe), and only 1 is from the Middle East (Iran).\u00a0<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Viz #2<\/strong>: This plot shows that the average project length has decreased through time, with 2017 being the year with the lowest average project length, at just about half a year per project. Interestingly enough, this downward trend has exacerbated since the unrolling of the Belt and Road initiative, leading one to wonder if this was a reflection of the decreasing quality of the projects instead of its size.\u00a0<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Viz #3<\/strong>: Interestingly enough, the dual line chart shows that as the money spent on global projects increased through the years, the average time spent on each project actually decreased, with 2013 \u2013 the unrolling of the \u201cBelt and Road\u201d initiative – as a dividing point. \u00a0<\/p>\n\n\n\n

Reflection<\/em><\/strong><\/p>\n\n\n\n

This lab report served to answer some of my fundamental questions about the dataset, including who\u2019s getting the money, the general trend of money CCP spent on foreign investment and how much time was spent on each project in average. The fact that the project length went down was very interesting and should be further explored in the final project: was it because there were more smaller-scaled projects? Or was it because the government was trying to rush the projects along? Furthermore, I would also like to understand the sectors in which the money was invested, as well as any debt conditions that came with such loans. <\/p>\n\n\n\n

References<\/em><\/strong><\/p>\n\n\n\n

Allen-Ebrahimian, Bethany. (2017, October 11). \u201cRussia is the Biggest Recipient of Chinese Foreign Aid.\u201d Foreign Policy. https:\/\/foreignpolicy.com\/2017\/10\/11\/russia-is-the-biggest-recipient-of-chinese-foreign-aid-north-korea\/<\/a><\/p>\n\n\n\n

Ani. (2022, March 19). \u201cChina Facing Criticism in Africa for \u2018Shoddy\u2019 Quality Projects.\u201d The Print. https:\/\/theprint.in\/world\/china-facing-criticism-in-africa-for-shoddy-quality-projects\/880046\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Background Along with China\u2019s rise as a global superpower in recent decades, the Chinese government has expanded its vision to territories beyond their national borders and into the world. Indeed, \u201csince the turn of the century, China has doled out nearly as much aid as the United States, even if it has kept that financing…<\/p>\n","protected":false},"author":4018,"featured_media":34712,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[340,149,339],"tags":[1827,1828,123],"coauthors":[1802],"class_list":["post-34711","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs","category-timelines","tag-china","tag-project-development","tag-tableau-public"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2022\/10\/viz1-country.png?fit=2072%2C1040&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-91R","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/4018"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=34711"}],"version-history":[{"count":4,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34711\/revisions"}],"predecessor-version":[{"id":34721,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34711\/revisions\/34721"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/34712"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=34711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=34711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=34711"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=34711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}