Supporting material for the comparison of French and Sound data


Denmark–??? Denmark–0a: Foodstuff, European Denmark–0b: Foodstuff, Exotic Denmark–1: Beverages and tobacco Denmark–2: Raw materials Denmark–3: Fuels Denmark–4: Oils Denmark–5: Chemicals Denmark–6: Manuf. goods, by material Denmark–6a: Manuf. goods, linen Denmark–6b: Manuf. goods, wool Denmark–6c: Manuf. goods, silk Denmark–6d: Manuf. goods, coton Denmark–7: Machinery and transport goods Denmark–8: Misc. manuf. goods Denmark–9: Other (incl. weapons) Denmark–9a: Species Denmark

Russia–??? Russia–0a: Foodstuff, European Russia–0b: Foodstuff, Exotic Russia–1: Beverages and tobacco Russia–2: Raw materials Russia–3: Fuels Russia–4: Oils Russia–5: Chemicals Russia–6: Manuf. goods, by material Russia–6a: Manuf. goods, linen Russia–6b: Manuf. goods, wool Russia–6c: Manuf. goods, silk Russia–6d: Manuf. goods, coton Russia–7: Machinery and transport goods  Russia–8: Misc. manuf. goods Russia–9: Other (incl. weapons) Russia

Sweden–??? Sweden–0a: Foodstuff, European Sweden–0b: Foodstuff, Exotic Sweden–1: Beverages and tobacco Sweden–2: Raw materials Sweden–3: Fuels Sweden–4: Oils Sweden–5: Chemicals Sweden–6: Manuf. goods, by material Sweden–6a: Manuf. goods, linen Sweden–6b: Manuf. goods, wool Sweden Sweden–6c: Manuf. goods, silk Sweden–6d: Manuf. goods, coton Sweden–7: Machinery and transport goods Sweden–8: Misc. manuf. goods Sweden–9: Other (incl. weapons) Sweden–9a: Species

Denmark– Russia– Sweden–

July 3rd internal meeting



Present : Alexandre Aubourg, Loïc Charles, Guillaume Daudin, Pierre Gervais, Paul Girard, Jérémy Hervelin, Demba Konate, Emmanuelle Lavallée, Ivan Ledezma, Sandrine Mesplé-Somps, Laura Moutou, Guillaume Plique


1) Discussion on RICARDO

The transition from Access to SQL Lite and Matteo Azzi’s work were first described by Paul and Beatrice. Paul also introduced the interface and its 5 “views”. Depending on the “view”, we will be able to observe the flows between two countries and their trade declarations, compare global trade between entities or follow the evolution of the share of each country.

The data is still being cleaned up and a large part of the work should be done by the end of the month. Furthermore, the database should be put online in October. The objective is to make the project publicly available. Some issues regarding the use of API to download the data by researchers were also raised (e.g. we need to make them available in csv rather than JSON).


2) Work with Guillaume Plique

If it is accepted by Europe, Guillaume Plique will start working with us in April 2015. Transcription and brainstorming about the datascape should then be finished. He will work till October on developing it.


3) Online storage of the data

Pictures and databases can be found on If you wish to access the files, make comments or contribute, do not hesitate to contact me to obtain the username and the password.


4) Transcription of the data

Demba and Laura are currently working on La Rochelle. National and regional data are also being retranscribed by the two service companies.

6 years will be delivered by SMSI – only 1788, 1789 and the 19th century will be remaining from the national data. Regarding the regional data, Thasectra will send a first batch (Bordeaux, Nantes) in September and the data from Marseille, Bayonne and Rouen should be ready by the end of the year. Thanks to the regional sources, we will be able to reconstitue the French national trade from 1725 onwards.

Prices and transcription errors will be checked by Jérémy, Demba and Alexandre. Everything should be imported into Stata by the end of January 2015.


5) Expenditure

They are now all available : thanks !


6) Discussion on the database

The database is made up of roughly 120 000 observations giving the details of bilateral flows by products. It is linked to a “Country database” (300 observations) and a “Unit database” converting quantities to the Metric system – the structure of which has to be defined. Other relational databases aim at standardizing (8000 observations) and classifying the names of goods.

The history of local nomenclatures, the links between regional and national sources and the issues related to quantity units were discussed. Regarding the names of goods, Paul insisted on the importance of classification levels and described how we could create networks with the names. We discussed the differences between administrative and business practices in naming goods. In any event, it will be essential to :

– work on the spelling of information units in the name of goods (Open Refine is our friend)

– find a way to exploit the original categories (notably regarding the use of  “;”)

– rethink the organization of the relational databases.

– we need to think about research questions ASAP. Ivan will collate what we promised and what he believes we can do


7) Next meeting

September 18th at 10am at SciencesPo médialab (13 rue de l’université)


Jérémy Hervelin

Bienvenue à Jérémy Hervelin, qui nous a rejoint depuis juillet 2012 et travaille par intermittence sur ce projet, notamment durant ce mois de juillet.


Jérémy Hervelin est étudiant à l’université Paris 1 Panthéon-Sorbonne dans le Master Economie Internationale. En 2013, il a obtenu une Licence mention Economie-Gestion, parcours économie, à l’université de Reims Champagne-Ardenne.


Il a intégré le projet ANR TOFLIT 18 dans le cadre d’une démarche personnelle, initiée par le coordinateur INED, Loïc Charles. Il a effectué et effectuera diverses tâches telles que la retranscription, le traitement et l’analyse de données. À cela s’ajoutera la supervision de travaux de saisies déjà effectués.


« Ce travail effectué en sus de mon parcours universitaire depuis maintenant ma deuxième année de Licence à travers différents contrats, auquel s’est ajouté un stage d’un mois pour l’obtention de mon diplôme final en janvier 2013, m’a permis d’élargir mon champ de vision et mes compétences. Souhaitant devenir moi-même enseignant-chercheur en sciences économiques dans le futur, ce projet représente une première étape. Ce dernier étant ambitieux et novateur dans son genre, il m’offre la possibilité de participer à une étude de grande envergure, concrète et complète. À quoi s’ajoute une atmosphère de travail des plus agréables, ce qui est bien entendu, non négligeable. »