Lippe brick-makers: database (hdl:10622/ZKS9BA)

View:

Part 1: Document Description
Part 2: Study Description
Part 3: Data Files Description
Part 4: Variable Description
Part 5: Other Study-Related Materials
Entire Codebook

(external link)

Document Description

Citation

Title:

Lippe brick-makers: database

Identification Number:

hdl:10622/ZKS9BA

Distributor:

IISH Data Collection

Date of Distribution:

2020-04-05

Version:

8

Bibliographic Citation:

Lucassen, Jan; Lourens, Piet, 2020, "Lippe brick-makers: database", https://hdl.handle.net/10622/ZKS9BA, IISH Data Collection, V8, UNF:6:3eYojjH54ozxbEENSbAhWQ== [fileUNF]

Study Description

Citation

Title:

Lippe brick-makers: database

Identification Number:

hdl:10622/ZKS9BA

Authoring Entity:

Lucassen, Jan (International Institute of Social History)

Lourens, Piet (International Institute of Social History)

Distributor:

IISH Data Collection

Access Authority:

Zijdeman, Richard

Depositor:

Zijdeman, Richard

Date of Deposit:

2017-07-24

Holdings Information:

https://hdl.handle.net/10622/ZKS9BA

Study Scope

Keywords:

Arts and Humanities, Social Sciences, brickmaker, Ziegler, Lippe

Topic Classification:

labor history

Abstract:

<!DOCTYPE html> <html> <head> </head> <body> <!--<h1>Online HTML Editor</h1>--> This dataset is part of the <a href="https://datasets.iisg.amsterdam/dataverse/lippe">Lippe brickmakers project</a>. <br> <br> It contains two files: <ul> <li>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 <a href="https://iisg.nl/migration/ziegler/datenbank-ueber.php">this web page</a>, which is also archived at the <a href="https://web.archive.org/web/20230928174841/https://iisg.nl/migration/ziegler/datenbank-ueber.php"> Internet Archive's Wayback machine</a>. A list with the main columns is also presented here below.</li> <li>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 <a href="https://druid.datalegend.net/IISG/-/stories/ziegler">"data story"</a> via the linked data publication platform. </ul> <br> These are the columns in this dataset and what they contain: <br> <ul> <li>'row', 'ID', 'original_source', 'original_ID': these columns contain legacy Ids from the previous databases where the data resided before it was uploaded. <li><b>'Signatur', 'Folio_original', 'Folio'</b>: 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 <a href=" https://datasets.iisg.amsterdam/dataset.xhtml?persistentId=hdl:10622/1RNBFT">"Lippe brickmakers project: archival pages transcriptions" dataset</a>. <li><b>Jahr</b>: the year of the original document (year in which the worker went to do seasonal work). <li><b>Bezirk</b>: district <li><b>Amt</b>: office or jurisdiction (Bailiwick or office within Lippe-Detmold in which the worker resides) <li><b>Ortschaft</b>:: 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. <li><b>Kataster</b>: cadastral number of the farms in Lippe-Detmold. Residents do not have their own cadastral number. <li><b>Beziehung</b>: (relationship) <li><b>Colon</b>: in the passport lists it should be mentioned whether a worker is a colon - owner of the colonate - or his son. <li><b>Kötter</b>: whether a worker is a peasant or a resident. <li><b>Enrolliert</b>: (in military service). <li><b>Alter</b>: age of the worker <li><b>Wohin</b>: suspected workplace on migrant labour. <li><b>Nächster_Stadt</b>: Next_City <li><b>Land</b>: country or province of the workplace. <li><b>Wie_lange</b>: passports are issued for a specific period of time. <li><b>Datum</b>: date of the work passport. <li><b>Fabrik</b>: names of the brick manufacturers or the company. <li><b>Arbeit</b>: labour, job <li><b>Arbeit_q</b>: A: The work is explicitly mentioned in the source. B: The work is derived from the source. <li><b>Betragen</b>: remark about the behaviour in the workplace. <li><b>Gruppe</b>: 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. <li><b>Grösse</b>: size of the workers' group. <li><b>Grösse_q</b>: A: Size was a number; B: Size is calculated from the persons named per group. <li><b>Stellung</b>: sequence number of the worker within the group. <li><b>Notiz</b>: remarks at the fields or references after the individual named outside the lists. <li><b>page_scan_url</b>: link to the digitized scan of the page from which the data was extracted. </ul> <br> <br> More information about the Lippische Ziegler project can be found in the <a href="https://datasets.iisg.amsterdam/dataverse/lippe">Lippe brickmakers project dataverse</a>. The linked data version can be used for exploring and querying the data in this <a href="https://druid.datalegend.net/IISG/-/stories/ziegler">"data story"</a> via the linked data publication platform. <br> <br> </body> </html>

Country:

Germany

Geographic Bounding Box:

  • West Bounding Longitude: 5.86500017310021
  • East Bounding Longitude: 5.0338181816394
  • South Bounding Latitude: 47.2747181278471
  • North Bounding Latitude: 55.0565271350945

Methodology and Processing

Sources Statement

Data Access

Other Study Description Materials

Related Publications

Citation

Identification Number:

978-3-8375-1882-5

Bibliographic Citation:

Joergens, B. & J. Lucassen (eds). 2017. Saisonale Arbeitsmigration in der Geschichte. Landesarchiv Nordrhein Westfalen / Klartext Verlag. More publications related to this project can be found in the OrcId profile of one of the main researchers: https://orcid.org/0009-0009-6065-3947

File Description--f33284

File: lippe_brickmakers_database.tab

  • Number of cases: 128612

  • No. of variables per record: 41

  • Type of File: text/tab-separated-values

Notes:

UNF:6:3eYojjH54ozxbEENSbAhWQ==

Variable Description

List of Variables:

Variables

row

f33284 Location:

Summary Statistics: StDev 37127.230747794805; Max. 128612.0; Mean 64306.5; Min. 1.0; Valid 128612.0

Variable Format: numeric

Notes: UNF:6:XadZxL4+UCxNXyTPsc+JHA==

ID

f33284 Location:

Summary Statistics: Min. 1.0; Mean 64306.5; StDev 37127.230747794805; Valid 128612.0; Max. 128612.0

Variable Format: numeric

Notes: UNF:6:lGfkzJxVhnc4nuSBh8SVvg==

original_source

f33284 Location:

Variable Format: character

Notes: UNF:6:34Md3GoN0MTxWpN9w+Sq/g==

original_ID

f33284 Location:

Summary Statistics: Max. 2201160.0; Mean 764009.4956225759; Min. 1.0; StDev 588392.6637934898; Valid 128612.0

Variable Format: numeric

Notes: UNF:6:LrCL//22KrlWR2eCLW+epA==

Signatur

f33284 Location:

Summary Statistics: Max. 4739.0; Valid 128612.0; StDev 8.358915495031189; Min. 4698.0; Mean 4723.121147326843

Variable Format: numeric

Notes: UNF:6:5mBcoW4gY+1e8FBg5f9J3Q==

inventory_number

f33284 Location:

Variable Format: character

Notes: UNF:6:o9/NhkO8GL1NUFno3kRX1Q==

Folio_original

f33284 Location:

Variable Format: character

Notes: UNF:6:fjossLYV1nZ5cmNzEYvizg==

Folio

f33284 Location:

Variable Format: character

Notes: UNF:6:0Lo4HmTuJnxgUuUf88JimQ==

Jahr

f33284 Location:

Summary Statistics: Mean 1838.030370416443; Min. 1778.0; Max. 1869.0; Valid 128612.0; StDev 24.70029313076261;

Variable Format: numeric

Notes: UNF:6:bFx7/ra8XglD8kT/RFbHhg==

Bezirk

f33284 Location:

Summary Statistics: Min. 0.0; Valid 128612.0; StDev 0.9254600876746705; Max. 4.0; Mean 1.4247270861193395

Variable Format: numeric

Notes: UNF:6:iwEd/bJ59kWbR5SwevHF1w==

Namen

f33284 Location:

Variable Format: character

Notes: UNF:6:Uc9LAtMKOuJOWYnvP33h6Q==

Vornamen

f33284 Location:

Variable Format: character

Notes: UNF:6:zXxrsHZ5GKbUHY0KRgoSOA==

Amt

f33284 Location:

Variable Format: character

Notes: UNF:6:hunwexB4B3MH07ConKdo6A==

Ortschaft

f33284 Location:

Variable Format: character

Notes: UNF:6:IBnVlcQi2WpKG203a9A8NA==

Kataster

f33284 Location:

Variable Format: character

Notes: UNF:6:kU2Sil/B/1OQrCHQjWskmw==

Beziehung

f33284 Location:

Variable Format: character

Notes: UNF:6:FjgRnOPCL1LltgLZP99AmA==

Colon

f33284 Location:

Variable Format: character

Notes: UNF:6:3OdWF5tCEhcRIlIRwtvR2w==

Kotter

f33284 Location:

Summary Statistics: Mean 1308.757409882897; Max. 2201057.0; Min. 0.0; Valid 128612.0; StDev 44588.59939816173

Variable Format: numeric

Notes: UNF:6:lCgT1gLjxyhR1J4HHeJooQ==

Enrolliert

f33284 Location:

Variable Format: character

Notes: UNF:6:puI85PNtPON0Crp7r9riWg==

Alter

f33284 Location:

Summary Statistics: Mean 4.108590178210761; Valid 128612.0; StDev 10.34398437942117; Min. 0.0; Max. 88.0

Variable Format: numeric

Notes: UNF:6:OEvLALxF8bQGCn/0AbRSkA==

Wohin

f33284 Location:

Variable Format: character

Notes: UNF:6:WDL5XJLNRvM4++IKefRPRg==

wohin_WHG_identifier

f33284 Location:

Summary Statistics: StDev 212670.75810585456; Min. 0.0; Mean 5991.529678414564; Valid 128612.0; Max. 7554740.0

Variable Format: numeric

Notes: UNF:6:PrDcEC89VIPwM3Dua4nFaw==

wohin_matches

f33284 Location:

Variable Format: character

Notes: UNF:6:71lQ4YrvWIpbTkMLhb48AA==

wohin_geowkt

f33284 Location:

Variable Format: character

Notes: UNF:6:lSeuG97qh+bm8JPgtYS0rg==

wohin_latitude

f33284 Location:

Summary Statistics: Mean 0.027024518088408788; Min. 0.0; StDev 1.2018552447920872; Max. 54.683333333333; Valid 128612.0;

Variable Format: numeric

Notes: UNF:6:ka95by0WfOIyRhUz9ernAw==

wohin_longitude

f33284 Location:

Summary Statistics: Valid 128612.0; StDev 0.1925266354673893; Min. 0.0; Mean 0.004321986784103059; Max. 9.8019993

Variable Format: numeric

Notes: UNF:6:66X+MNMTTmpmCAPZlBkeRQ==

Nachste_Stadt

f33284 Location:

Variable Format: character

Notes: UNF:6:Sz3Fjy4jLIyopVfIRdF4Yg==

Land

f33284 Location:

Variable Format: character

Notes: UNF:6:LRnyaI+ul8uqiMDvEUblow==

Wie_lange

f33284 Location:

Variable Format: character

Notes: UNF:6:ug7PIKBAr42qlx5lRaJkbA==

Datum

f33284 Location:

Variable Format: character

Notes: UNF:6:UYfwAo+8ibXOh+OwUsjoLw==

Fabrik

f33284 Location:

Variable Format: character

Notes: UNF:6:6Cxq3SZPqalI5BJ62hlKTQ==

Arbeit

f33284 Location:

Variable Format: character

Notes: UNF:6:zGJzQ/jGQe7Y3na3RXvW/Q==

Arbeit_q

f33284 Location:

Variable Format: character

Notes: UNF:6:O+jqdn3fhBWlyxrfU6TTvQ==

Betragen

f33284 Location:

Variable Format: character

Notes: UNF:6:FRzMFCv7e47BKKaHctfUkA==

Gruppe

f33284 Location:

Summary Statistics: Mean 54.70687027649943; Max. 991.0; Valid 128612.0; Min. 0.0; StDev 72.06895575487052;

Variable Format: numeric

Notes: UNF:6:5qBAMtNRJU1wxADQ8PZwnA==

Grosse

f33284 Location:

Summary Statistics: StDev 6.542276020811587; Max. 178.0; Min. 0.0; Mean 5.720749230243697; Valid 128612.0

Variable Format: numeric

Notes: UNF:6:junhz040juG1vBmPC7qbAg==

Grosse_q

f33284 Location:

Variable Format: character

Notes: UNF:6:ZUEMzgcgDMKCv8+gR/E7Lg==

Stellung

f33284 Location:

Summary Statistics: Valid 128612.0; Max. 61.0; Min. 0.0; Mean 2.73774608901144; StDev 3.985951878622893

Variable Format: numeric

Notes: UNF:6:79s7WleKGbKjhqvPYAlt0w==

Notiz

f33284 Location:

Variable Format: character

Notes: UNF:6:hn8z14qbgQQ6f5oEuNlOIw==

page_scan_url

f33284 Location:

Variable Format: character

Notes: UNF:6:+Z3CXJVdOzMcDJI0pqwLcw==

file_Id

f33284 Location:

Variable Format: character

Notes: UNF:6:RDUYJgFdTTL8LIjMFp/b/A==

Other Study-Related Materials

Label:

lippe_brickmakers_database_as_lod.nt

Text:

This file contains the same data as the file "lippe_brickmakers_database.tab" but converted to triples in nt (N-triples) format.

Notes:

application/octet-stream

Other Study-Related Materials

Label:

lippe_csv_to_lod_database.py

Text:

Python script that transforms the csv file to .nt triples.

Notes:

text/x-python-script

Other Study-Related Materials

Label:

ziegler_dataset_deprecated.tsv

Text:

This version has parsing issues. But it was used as the basis for the updated versions. Preferably use those instead of this one.

Notes:

text/tab-separated-values