To make the animation, seven datafiles were created.
The first is the master datafile, which contains all of the data used to make the trade flow time series that are depicted. This is an Excel Workbook with 617 worksheets, one for each of the 616 trade dyads and one that serves as a “table of contents” for the others.
[1] Dyadic Trade Data for v3 animation-all data
The next two Excel files contain the final trade flow columns from the master file worksheets sorted by trade dyad and then by year. Number [2] contains rows for all years even if there is no data in some rows.
[2] Dyadic Trade Data for v3 animation vertical stack-sorted by trade dyad with empty data rows
Number [3] includes only those rows containing import or export data.
[3] Dyadic Trade Data for v3 animation vertical stack-sorted by trade dyad
The fourth and fifth files contain the same data as the third file except that they are sorted by year and then trade dyad. They differ in their format.
Number [4] is an Excel file.
[4] Dyadic Trade Data for v3 animation vertical stack-sorted by year
Number [5] is a comma-separated-values (.csv) format file.
[5] Dyadic Trade Data for v3 animation vertical stack-sorted by year
The sixth file contains the latitude and longitude data for the geographic centers of the 99 countries in .csv format and serves as the nodes file for the data visualization software.
[6] Dyadic Trade Nodes 1790-1919
The seventh file is a .csv listing of the numeric codes used to identify the countries. It is an extension of the COW country codes document with additional codes for countries not in that listing.
[7] COW country codes extended
_______________
Below is a second dyadic trade nodes file that includes additional countries, those in the COW trade dataset version 3. I provide this simply to save someone who wants to use this type of data a bunch of work.