country information data compile
$100-117.65 USD
Paid on delivery
This project is creating one universal data-set from seven (7)
sources. It will require using provided excel or tab files of single
country data (GDP, Allies, etc) to create new indexes for a dyad of
countries (1 set of 2 countries paired together). Each line of coding
is based on the dyad year from 1900 to 2011.
## Deliverables
This project is creating one universal data-set from seven (7)
sources. It will require using provided excel or tab files of single
country data (GDP, Allies, etc) to create new indexes for a dyad of
countries (1 set of 2 countries paired together). Each line of coding
is based on the dyad year from 1900 to 2011.
Coding Instructions: In each directive below, I use the terms Country
A and Country B as examples of relationships such as between India and
Pakistan, or Kosovo and Serbia. These are what I mean when I refer to
"a country Dyad" - two countries as one unit of analysis. Each line
of coding will be based upon the "dyad year." An example excel sheet
is provided for what the final product must look like.
Variable 1: Bilateral Trade between dyad countries. This variable is
interested in calculating how connected two country's economies are in
a particular year. One dataset provided has every country year's GDP.
Another dataset provided has every country year's exports and imports
from other countries. This index will take combined imports and
exports between country A and Country B as a percent of both A and B
GDP.
BiLateral Trade = (exports of A to B + exports of B to A) +(
IMPORTS of A from B + Imports of B from A) / GDP of A x GDP of B
(per year)
Variable 2: Multilateral Trade. This variable is interested in
calculating the total value of global trade for the dyad for each
year. Based on the dataset provided, take country A total exports +
Country A total imports as a percent of country A GDP and add it to
country B total exports + country B total imports as a percent of
country B GDP.
Multilateral Trade = (Exports of A + Imports of A / GDP of A) +
(Exports of B + Imports of B /GDP of B ) (per year)
Variable 3: Allies Shared. This variable is interested in calculating
how many allies two countries share in a particular year. You will
calculate this by taking the allies dataset and counting how many
allies country A and country B have total combined in a given year.
Then you will calculate how many of those allies are shared between
the two countries and input the percentage shared.
Allies Shared of A+B / Total Allies of A + B (per year)
Variable 4: Dyadic Alliance? This variable is to determine whether or
not two countries are allies with one another in a given year. The
allies data set that is provided will indicate three levels of
alliance between two countries. Input the alliance as it is in the file, 0,1,2,3.
Variable 5: Co-membership in international organizations. This
variable is intended to reveal how many international organization
memberships a dyad shares out of their total membership per dyad year.
This is simply calculated by taking the international organization
dataset and counting how many total organizations country A and
country B are members of in a given year. Then you will calculate how
many of those organizations are shared between the two countries and
input the percentage shared.
Co-membership in Ios AB / total IO membership AB (per year)
Variable 6: Co-Treaty Signature. This variable is intended to
calculate how many international treaties a country dyad has in common
in a given year. This is simply calculated by taking the international
treaties dataset and counting how many total treaties country A and
country B are signatory to in a given year. The data-set indicates
both ratification (coded as 2) and signature (coded as 1). You will
count your input dichotomously (1 for either sign 0 for none: ignore
ratification variable). Then you will calculate how many of those
treaties are shared between the two countries and input the percentage
shared.
Co-signature treaties AB / total-signed treaties AB (per year)
Variable 7: UN Co-vote. The final variable is intended to calculate
how many times the dyad votes the same way at the United Nations in a
given year. This is calculated by taking the UN voting dataset and
counting how many total votes country A and country B execute in a
given year in the General Assembly. Then you will calculate how many
of those votes are shared between the two countries and input the
percentage shared.
Co-General Assembly votes AB / Total General Assembly votes AB (per year)
Project ID: #2787687