DOI: 10.34894/s0iluc
title: Lippe brick-makers: database

description: &lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;!--&lt;h1&gt;Online HTML Editor&lt;/h1&gt;--&gt;
This dataset is part of the &lt;a href="https://datasets.iisg.amsterdam/dataverse/lippe"&gt;Lippe brickmakers project&lt;/a&gt;.
&lt;br&gt;
&lt;br&gt;
It contains two files:
&lt;ul&gt;
&lt;li&gt;A file in tabular format (.tab): in each row there is data about a person (brick-maker) from Lippe and it's migratory seasonal work. The original "code book" can be found in &lt;a href="https://iisg.nl/migration/ziegler/datenbank-ueber.php"&gt;this web page&lt;/a&gt;, which is also archived at the &lt;a href="https://web.archive.org/web/20230928174841/https://iisg.nl/migration/ziegler/datenbank-ueber.php"&gt; Internet Archive's Wayback machine&lt;/a&gt;. A list with the main columns is also presented here below.&lt;/li&gt;
&lt;li&gt;A file in n-triples format (.nt), wich contains the same data as the previous file but represented in linked data format (triples). This linked data version is the basis for exploring and querying the data via this &lt;a href="https://druid.datalegend.net/IISG/-/stories/ziegler"&gt;"data story"&lt;/a&gt; via the linked data publication platform.
&lt;/ul&gt;
&lt;br&gt;
These are the columns in this dataset and what they contain:
&lt;br&gt;
&lt;ul&gt;
&lt;li&gt;'row', 'ID', 'original_source', 'original_ID': these columns contain legacy Ids from the previous databases where the data resided before it was uploaded.
&lt;li&gt;&lt;b&gt;'Signatur', 'Folio_original', 'Folio'&lt;/b&gt;: In the Lippe archive there is a "fond" (broader unit) identified with number L77A. This fond contains different "signaturen", for example, "4698", or "4716". Both numbers (L77A, and 4698) were assigned by the archive who hosted the original scans (Landesarchiv Nordrhein-Westfalen). For more information see the &lt;a href=" https://datasets.iisg.amsterdam/dataset.xhtml?persistentId=hdl:10622/1RNBFT"&gt;"Lippe brickmakers project: archival pages transcriptions" dataset&lt;/a&gt;.
&lt;li&gt;&lt;b&gt;Jahr&lt;/b&gt;: the year of the original document (year in which the worker went to do seasonal work).
&lt;li&gt;&lt;b&gt;Bezirk&lt;/b&gt;: district
&lt;li&gt;&lt;b&gt;Amt&lt;/b&gt;: office or jurisdiction (Bailiwick or office within Lippe-Detmold in which the worker resides)
&lt;li&gt;&lt;b&gt;Ortschaft&lt;/b&gt;:: Locality, town or district of Lipper where the worker lived or lives before going for work. It can also be in the border areas of Lipper.
&lt;li&gt;&lt;b&gt;Kataster&lt;/b&gt;: cadastral number of the farms in Lippe-Detmold. Residents do not have their own cadastral number.
&lt;li&gt;&lt;b&gt;Beziehung&lt;/b&gt;: (relationship)
&lt;li&gt;&lt;b&gt;Colon&lt;/b&gt;: in the passport lists it should be mentioned whether a worker is a colon - owner of the colonate - or his son.
&lt;li&gt;&lt;b&gt;Kötter&lt;/b&gt;: whether a worker is a peasant or a resident. 
&lt;li&gt;&lt;b&gt;Enrolliert&lt;/b&gt;: (in military service).
&lt;li&gt;&lt;b&gt;Alter&lt;/b&gt;: age of the worker
&lt;li&gt;&lt;b&gt;Wohin&lt;/b&gt;: suspected workplace on migrant labour.
&lt;li&gt;&lt;b&gt;Nächster_Stadt&lt;/b&gt;: Next_City
&lt;li&gt;&lt;b&gt;Land&lt;/b&gt;: country or province of the workplace.
&lt;li&gt;&lt;b&gt;Wie_lange&lt;/b&gt;: passports are issued for a specific period of time.
&lt;li&gt;&lt;b&gt;Datum&lt;/b&gt;: date of the work passport.
&lt;li&gt;&lt;b&gt;Fabrik&lt;/b&gt;: names of the brick manufacturers or the company.
&lt;li&gt;&lt;b&gt;Arbeit&lt;/b&gt;: labour, job
&lt;li&gt;&lt;b&gt;Arbeit_q&lt;/b&gt;: A: The work is explicitly mentioned in the source. B: The work is derived from the source.
&lt;li&gt;&lt;b&gt;Betragen&lt;/b&gt;: remark about the behaviour in the workplace.
&lt;li&gt;&lt;b&gt;Gruppe&lt;/b&gt;: number of the group in the brick messenger lists. Some lists are numbered consecutively, others are numbered by area. Numbers used in error for the second time are numbered differently.
&lt;li&gt;&lt;b&gt;Grösse&lt;/b&gt;: size of the workers' group.
&lt;li&gt;&lt;b&gt;Grösse_q&lt;/b&gt;: A: Size was a number; B: Size is calculated from the persons named per group.
&lt;li&gt;&lt;b&gt;Stellung&lt;/b&gt;: sequence number of the worker within the group.
&lt;li&gt;&lt;b&gt;Notiz&lt;/b&gt;: remarks at the fields or references after the individual named outside the lists.
&lt;li&gt;&lt;b&gt;page_scan_url&lt;/b&gt;: link to the digitized scan of the page from which the data was extracted.
&lt;/ul&gt;
&lt;br&gt;
&lt;br&gt;
More information about the Lippische Ziegler project can be found in the &lt;a href="https://datasets.iisg.amsterdam/dataverse/lippe"&gt;Lippe brickmakers project dataverse&lt;/a&gt;. The linked data version can be used for exploring and querying the data in this &lt;a href="https://druid.datalegend.net/IISG/-/stories/ziegler"&gt;"data story"&lt;/a&gt; via the linked data publication platform.
&lt;br&gt;
&lt;br&gt;
&lt;/body&gt;
&lt;/html&gt;