9 – Data

A caveat: all the downloadable files given below correspond to their version on the date of the first publication of this post on 2023-03-03. They are still subject to modification; their final version will be put online at the end of this project.

Population density of the German empire, based on the 1890 census. The origin of this coloured map is unclear. A similar 2-colour map is available from Wikimedia commons. Its legend does not refer to any census. The source, for both maps, is Meyers Konversations-Lexikon; eine Encyklopädie des allgemeinen Wissens, by Hermann Julius Meyer (1826-1909) , 4. Aufl., vol. 4, Bibliographisches institut in Leipzig, article “Deutschland”.

All the data used in this study are available from this post. They are given in three formats: CSV 1, xlsx2 and Gnumeric, which is the spreadsheet used for this Project.

5.1 The complete weddings data set, file BTF (“Big Tonner File”)

This is the final/corrected version the dataset as used in this study, and assembled from files downloaded from the website of KJ Tonner (KJT)

at the end of January 2022. Details are provided in the post entitled 1 – The project database.

The places or origin of the spouses are identified by their “raw names”. Missing fields are left empty.

The Serial number was assigned for the purpose of this Project.

Download: BTF_raw.csv.zip , BTF_raw.xlsx , BTF_raw.gnumeric.zip

5.2 List of wedding places (“WP File”)

Although the coordinates and the list of wedding places are available from other data files, they are given here in one simple file for the ease of reference. Coordinates are given with six decimals, although the high precision is unnecessary (the 4th decimal corresponds approximately to 1 m at the latitude of the Eifel) .

Download: WP.csv

Only the csv file is given as the other formats lead to larger files!

5.3 “Stripped” and “clean” names correspondence (“S2C File”)

The table below, which is extracted “as is” from the S2C file illustrates several features

Column 1 has the “stripped name”, which is the slightly modified wedding place name as it appears in the BTF (5.1 above). The number of homonyms is the number of places with the same name. In the case of Burg, we have 4, referred to as Burg_1-Mosel (Burg on the Moselle) , Burg_2-Mettendorf (Burg near Mettendorf), Burg_3-Landscheid (Burg near Landscheid) and Burg_4-Seinsfeld (Burg near Seinsfeld). Each of them has, naturally, different coordinates.

The “clean name” for Bunzlau (a city in south-east Poland, near the Czech border) is Bolesławiec, i.e. the place was renamed from its historical German name to its current Polish name. Buprich, in the municipality of Schmelz, Landkreis Saarlouis in Saarland appears as the correct current spelling (Buprich) but is also mis-spelled as Buperich. Both “stripped names” buprich and buperich are assigned to the “clean” and final variant Buprich. A similar situation arises for (“clean” name) Burger-Mühle which occurs in the BTF as (¨stripped” names) burgermmühle, burgermühle and burgermühlehupperath. Burbach near Prüm occurs in the BTF as burbach, burbachkreisprüm, burbachkrsprüm and burbachprüm, etc.

Without the rather painstaking systematic examination of all individual “stripped” names, it would have been impossible to conduct this study!

Download: S2C.csv.zip, S2C.xlsx, S2C.gnumeric.zip

5.4 Final list of “clean” place names (FC File)

The FC file, in addition to the information in the S2C files, contains additional localities as well as an indicator about the “type” of locality: U (unique), H (homonym) or A (average). The specific meaning of the “average” is explained in post 2 – Locating places and sampling the database.

If you have been worrying about the recent eviction of Lützerath to allow the expansion of the Garzweiler coalmine3, note that this happened at Lützerath-2. Lüttzerath-1 is about 100 km further south, and the places with the clean names of Altmühle-Lützerath, Neumühle-Lützerath and Lüzerather-mühle-average are all near Lützerath-1.

Download: FC.csv.zip, FC.xlsx, FC.gnumeric.zip

5.5 Prussia 1881 shapefile

The file was prepared based on the shapefile published in the Cshapes project of the Center for Comparative and International Studies, Department of Humanities, Social and Political Sciences, ETH Zurich. Compared with the original file, Ostbelgien and the so called “Prussian Walloonia” were added and the level of detail (1:1 million scale) was increased on the western border from Alsace, Lorraine, Luxembourg and Belgium.

Download: Prussia 1881 shapefile

  1. Comma separated variable, directly readable into most spreadsheets[]
  2. ECMA 376 1st edition; MS Excel 2007 (TM), as ouput by Gnumeric[]
  3. actually Braunkohle, i.e. lignite[]
0 0 votes
Article Rating
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments