Toflit18, le retour.
Auteur : Guillaume Daudin
Toflit18, le retour.
Auteur : Guillaume Daudin
Analyse historique du commerce extérieur français – le projet TOFLIT 18.
Auteurs : Corentin Ponton, Quentin Vidal et Guillaume Daudin
The retranscribed variable is “quantity_unit” (1,564 different values).
The file “classification_quantityunit_orthographic.csv” establishes a correspondance between the variable “quantity_unit” and the variable “quantity_unit_orthographic” (701 values). 235,000 observations have “livres” in “quantity_unit_ortho” and 164,000 have “unité manquante” (out of 555,000).
The file “classification_quantityunit_simplification.csv” establishes a correspondance between the variable “quantity_unit_orthographic” and “quantity_unit_simplification” & “conv_orthographic_to_simplification”.
“quantity_unit_simplification” is the name of the simplified quantity unit.
“conv_orthographic_to_simplification” is the conversion factor between quantity_unit_orthographic and quantity_unit_simplification.
E.g. for “douzaine”, these are «nombre» and “12”
The file “classification_quantityunit_metric1” establishes a link between “quantity_unit_simplification” and “quantity_unit_metric” + “conv_simplification_to_metric” when possible directly.
If not, we flag “needs_more_details” which indicate that we cannot know the metric equivalent without using more variables.
The file “classification_quantityunit_metric2” establishes a correspondance between :
quantity_unit_simplification + product_simplification + product_revolutionempire + exportsimports + customs_region + partner_grouping with “quantity_unit_metric” + “conv_simplification_to_metric”
In the end, 277,000 trade flows are expressed in kilograms, 164,000 have no quantity unit, 70,000 are expressed in numbers, 13,000 in liters, 10,000 in centimeters, 3000 in containers and 2,200 in sheets. 15,000 have not “quantity_metric” esquivalent.
Bienvenue à Léon Guillot, qui vient faire un Master que Guillaume Daudin va encadrer.
“Actuellement étudiant dans le Master d’Analyse Economique Quantitative, à l’Université Paris-Dauphine, au sein de la filière “Politique publique”, je prépare un mémoire sur l’existence d’un phénomène de maladie hollandaise dans l’économie française du XVIIIe siècle, du fait de l’importance du commerce avec les Antilles.
Thanks to the funding provided by DIAL we were able to hire the great developers at OuestWare to update the datascape. We are very excited by the changes they made and we urge you to go and check them out !
The two main improvements are optimization and permalinks. And you can still use regular expressions. More details below the line.
Bienvenue à Grégory Donnat qui vient nous donner un coup de main, dans la continuité de ce qu’avait fait Maëlle Stricot.
Loïc Charles et Guillaume Daudin ont présenté un travail sur “Haut de gamme, excédent commercial et dynamique des exportationsdans la France pré-Industrielle” au colloque “Vers le haut de gamme Made in France” le 22 novembre 2019.
We welcome Stephen Jackson in the team. He will stay for June and July 2019, and will work in the beginning on a new 200 category classification of merchandises based on the documents from the Revolution and the Empire. A short self-presentation follows.
After spending three years at the University of Warwick studying economics at undergraduate level, I decided to move back to France and follow up my bachelor’s degree with a master’s in development economics at Panthéon-Sorbonne University (Paris I).
The research-oriented nature of postgraduate study makes experiences in the field of academia all the more valuable. Joining the project as an intern is an opportunity to further explore an area of economics that has always interested me while experiencing first-hand what it takes to be engaged in research at the forefront of the discipline.
I’ll be joining the TOFLIT18 project for two months over the summer of 2019. My tasks as part of the team include elaborating a new classification of products based on earlier simplification work as well as harmonisation of data in the early years of Revolutionary France to address potential shifts in classification methodology and reporting.
Although economic history has always featured prominently in my choice of courses at university, this internship also represents a step into the unknown. Working with such a large collection of data and facing the challenges tied to historical records is something new and fascinating for me. In my short time on board, I hope I can contribute to the large body of work that has been carried out so far and pave the way for future use of the dataset.
Paul Girard presented the project on February 2nd at FOSDEM 19 in Brussels.
The presentation was a great success, and you can find the slides and a video recording here : https://fosdem.org/2019/schedule/event/graph_french_trade_study/
Thanks to the hard work of Paul Girard, there is now a new version of the datascape with updated data and a number of bug fixes. You can access it here.
We are happy to report that we will benefit from new support from the 3rd “Governance Analytics” call.
Loïc Charles and Guillaume Daudin «Cross-checking STRO with the French Balance du Commerce data», in Jan Willem Veluwenkamp & Werner Scheltjens (Ed.), Early Modern Shipping and Trade : Novel Approaches Using Sound Toll Registers Online (pp. 133-150). Boston & Leiden: Brill (2018)
This chapter looks at trade between France and Northern Europe as reported by the Sound Toll Register Database and the French Balance of Trade statistics from 1750 to 1789.
Although these two sets of data are quite different, we developed a common methodology to analyse comparatively both datasets in order to better understand the nature of the information they contain and to assess how to use them.
Our results are: the comparison of the flows registered in physical quantities and in the number of cargoes by the STRO and the French data registered in values is disappointing. Conversely, the Sound Toll Registers tax indicator is a reasonable proxy for the French data; Norway accounts for a significant part of French imports from Denmark, but it is not the case for French exports to the same country; French exports to each of the Baltic countries share a similar structure and are dominated by wine and colonial goods, there is a strong differentiation of French imports as Swedish exports are made almost exclusively of iron and its derivatives and Danish exports are made mostly of wood and to a lesser extent of European foodstuff, while Russian exports are dominated by primary goods.
Trade Statistics ; Sound ; France ; Eighteenth Century ; Baltic Trade ; Scandinavia ; Russia
«La collecte du chiffre au xviiie siècle: Le Bureau de la Balance du Commerce et la production de données sur le commerce extérieur de la France», with Loïc Charles, Revue d’Histoire Moderne et Contemporaine, vol. 58, n°1, p. 128-155, 2011 https://doi.org/10.3917/rhmc.581.0128
The retranscribed variable is “quantity_unit” (1,538 different values).
The file “Units_Normalisation_Orthographique.dta” establishes a correspondance between the variable “quantity_unit” and the variable “quantity_unit_ortho” (701 values). 210,000 observations have “livres” in “quantity_unit_ortho” and 160,000 have “unité manquante” (out of 510,000).
The file “Units_Normalisation_Métrique1” establishes a correspondance between the variable “quantity_unit_ortho” and either
– 1. the variables “quantity_unit_ajustees” (simplifying the “quantity_unit_ortho”), “u_conv” (a metric unit of quantity) and “q_conv” (the number of u_conv in “quantity_unit_ortho”). e.g. “quantity_unit_orth” “douzaine de paires” has “douzaine de paires” as “quantity_unit_ajustees”, “pièce” as u_conv and “24” as “q_conv”.
– 2. a variable “needs_more_details” which indicate that we cannot know the metric equivalent without using more variables.
The file “Units_Normalisation_Métrique2” establishes a correspondance between :
exportsimports + pays_grouping + direction + marchandises_simplification + quantity_unit_ortho and “quantity_unit_ajustees” (simplifying the “quantity_unit_ortho”), “u_conv” (a metric unit of quantity) and “q_conv” (the number of u_conv in “quantity_unit_ortho”).
Here is the document created by Matthias Loise to document the first version of the datascape. It can be used as a guide to the second one.