Parish Registers of Clerkenwell, London 1550-1753: Documentation

Description

This data collection contains five comma separated variable files that are the tables of a relational database representing parish register baptism, marriages and burial events for the parishes of St James Clerkenwell and St John Clerkwell, London, with additional marriages, between 1550 and 1753. These data were input some years previously from Harleian Society and other published transcriptions of parish registers as well as from microfilm copies of the Fleet Registers  (TNA/RG7) as part of an unfinished Cambridge University PhD project by the late Amanda Copley. 

This database was created by Gill Newton at the Cambridge Group for the History of Population from text files supplied by Ros Davies of the Cambridge Group of the data compiled by Amanda Copley. This database was created between October 2003 and September 2006 as part of the AHRB-funded project People in Place. 

An alternative version of this resource together with the related resource ‘Reconstituted families of Clerkewell, London’ exists as a Microsoft Access 2000 database. This also contains a version of the user interface Forms used for data input that may be used for viewing transcriptions of each parish register baptism, marriage and burial event. This database was created by Gill Newton. The .csv files of this data collection were generated from this database

Structure and Related Datasets

Event.csv	7,688,834 bytes	120,515 lines + field names on first line	text values in ""	
Person.csv	7,184,742 bytes	140,713 lines + field names on first line	text values in ""	
Related_people.csv	5,932,544 bytes	95,927 lines + field names on first line	text values in ""	
Condition.csv	874,435 bytes	38,539 lines + field names on first line	text values in ""	
RPCondition.csv	9,380 bytes	368 lines + field names on first line	text values in ""	

There are five tables representing parish register Events as a whole, their component subject Persons and those Persons’ Conditions or status,  Related_people and those Related_people’s Conditions or status. The tables are joined as indicated in the table and field descriptions given below. 

These tables are related to the data collection ‘Reconstituted families of Clerkenwell, London’, which contains family reconstitutions of these events. There are joins between the key field of tables in this database and foreign key fields of that database as indicated in that data collection.

The structure and fields of these tables is a subset of that in the data collection ‘Parish Registers of Cheapside, London’ and the key fields are numbered in such a way as to produce no overlap between the two datasets, to facilitate combining them for analysis. However, there are some differences in the field contents, primarily concerning whether they are standardised or in original orthography. These tables are related to the data collection ‘Reconstituted families of Clerkenwell, London’, which contains family reconstitutions of these events. There are joins between the key field of tables in this database and foreign key fields of that database as indicated in that data collection.

Event.csv

Each record represents a baptism, marriage or burial Event recorded in one of the sources, which are usually parish registers. An Event must have one or more Persons, who is/are the subject(s) of that Event.

Event_id (Integer)

Unique identifier for each baptism, marriage or burial Event.

Link_Event_ID (Integer)

Non-unique identifier that is the same for duplicate Events from different sources, allowing them  to be grouped.

Event_date (Date)

The date of an Event as given in the sources, where dates are usually in the Julian calendar with each year beginning on 25 March. Where partially given in the source, derived from its position relative to other dated Events in the register, or where the day is unclear, set to the first day of the month, or where the month is unclear, set to the first month in the year. Unclear dates are annotated in the [Memo] field. 

Parish (String)

Indicates the source area of the Event, ie Clerkenwell. This also includes marriages of Clerkenwell inhabitants that took place elsewhere: see [Marriage_location] field. 
			
Event (String)

The type of Event recorded in a register. Can be baptism, marriage or burial

Memo (String)
 
Used to record any comments or pertinent further information concerning an Event that is given.

Marriage_location (String)

Used only for marriage Events (see [Event] field). Standardised version of the location in which a marriage is stated to have taken place, generally a parish or irregular marriage centre, where such information is given. The options are as follows:

all hallows bread street	
all hallows lombard street	
all hallows staining	
all hallows the great, thames street	
Ashford, Kent	
bedford	
bridewell hospital chapel	
Charlton (Kent?)	
charterhouse chapel	
christchurch newgate	
cowley	
Edmonton	
ely chapel, holborn	
Enfield	
Finchley	
grays inn	
Greenford	
holy trinity minories	
holy trinity the less	
kensington	
lamb's chapel alias St James on the Wall	
Lee (Kent)	
lincolns inn	
mercer's hall chapel	
Monken Hadley	
New Brentford	
poplar, middlesex	
southwark	
st alban wood street	
st alphage, london wall	
st andrew by the wardrobe	
st andrews holborn	
st andrews undershaft	
st ann and st agnes aldersgate	
st ann blackfriars	
st ann soho	
st antholins budge row	
st augustine wih st faiths	
st bartholomew by the exchange	
st bartholomew the great	
st bartholomew the less	
st benet and st peter, paul's wharf	
st benet fink	
st benet gracechurch and st leonard eastcheap	
st botolph without aldersgate	
st botolph without aldgate	
st brides fleet street	
st christopher le stocks	
st clement danes	
st clement eastcheap	
st dionis backchurch	
st dunstan in the east	
st dunstans in the west	
st edmund, king & martyr, lombard street	
st george bloomsbury	
st george botolph lane (with st botolph billingsgate)	
st george hanover square	
st george the martyr, queen's square	
st george's chapel mayfair	
st giles without cripplegate	
st gregory by st paul's	
st helen bishopsgate	
St James Clerkenwell	
st james dukes place	
st james garlickhithe	
st james westminster (piccadilly)	
St James, Clerkenwell	
st john the baptist, clerkenwell	
st john westminster (smith square)	
st katherine by the tower	
st katherine coleman	
st katherine cree	
st lawrence jewry	
st lawrence pountney	
st magnus the martyr & st margaret new fish street	
st margaret lothbury	
st margaret moses & st mildred bread street	
st margaret pattens	
st martin ludgate	
st martin outwich	
st mary abchurch	
st mary aldermary	
st mary islington	
st mary le bone	
st mary le bow & all hallows honey lane & st pancras soper lane	
st mary le strand (aka savoy)	
st mary magdalen old fish street	
st mary mounthaw	
st mary somerset	
st mary the virgin, aldermanbury	
st mary woolnoth / st mary woolchurch	
st matthew Friday street	
st michael bassishaw	
st michael cornhill	
st michael crooked lane	
st michael paternoster royal	
st michael queenhithe	
st mildred poultry	
st nicholas cole abbey	
st olave old jewry	
st pancras, middlesex	
st paul's cathedral	
st paul's covent garden	
st peter cornhill	
st peter le poor	
st peter west cheap	
st sepulchres	
st stephen coleman street	
st stephen's walbrook & st benet sherehog	
st swithin & st mary bothaw (united)	
st swithin (alone)	
st thomas the apostle	
st vedast foster lane	
Stepney	
temple church	
the Fleet	
tottenham	
walthamstow	
wandsworth	

Marriage_authorisation (String)

Used only for marriage Events (see [Event] field). Indicates whether a marriage was authorised by the calling of banns, or by licence, where this information is given in a register. Can be B for banns or L for licence.

Person.csv

Each record represents a Person who is a subject of a baptism, burial or marriage Event as recorded in one of the sources, which are usually parish registers. Each record must have a corresponding Event record (see Event.csv). A Person may have one or more Conditions (see Condition.csv).

PID (Integer)

Unique identifier for each Person record.

Event_id (Integer)

Foreign key indicating the Event record to which  a Person belongs (see Event.csv).

Birth_date (Date)

Used only for baptism Events (see Event table [Event] field). The date of birth where such information is given in the source. Dates are in the Gregorian calendar. Where partially given in the source so noted in the [comment] field or in the Event table [Memo] field. 

Death_date (String)

Used only for burial Events (see Event table [Event] field). The date of death where such information is given in the source. Dates are in the Gregorian calendar. Where partially given in the source so noted in the [comment] field or in the Event table [Memo] field. 

Forename (String)

Forename of a Person in the original orthography as given in the source. Where two variants are given the second is enclosed in square brackets [].

Surname (String)

Forename of a Person in the original orthography as given in the source. Where two variants are given the second is enclosed in square brackets [].

stated_sex (String)

The sex of a Person. Can be M for male, F for female or X for unknown.

Residence (String)

Place of residence of a Person, where such information is given. Unstandardised.

Occupation (String)

Occupation or economic status of a Person, including titles, where such information is given. Unstandardised 

Age (String)

Age of a Person, where such information is given in the source. May be a precise age in years, days or months, or a general descriptor such as “aged”. Unstandardised.

Cause_of_death (String)

The cause of death of a Person, where such information is given in the source. Unstandardised.

comment (String)

Any other information given in the original source which applies to a particular Person rather than to the whole Event (compare the Event table [Memo] field). 

Related_people.csv

Each record represents an individual who is related to a Person who is the subject of an Event. This includes but is not limited to mothers and fathers, husbands and wives of the subject Person. Each related_people record must belong to a Person (see Person.csv). A Related_people individual may have one or more RP_Condition records (see RP_Condition.csv).

RPID (Integer)

Unique identifier for each Related_people record.

Relationship (String)

The relationship of a Person (see Person.csv) to a Related_people individual (not the relationship from the Related_people individual’s perspective). Standardised. The options are:

brother of	
child of	
daughter of	
father of	
grandchild of	
granddaughter of	
grandson of	
husband of	
in-law-brother of	
in-law-child of	
in-law-daughter of	
in-law-father of	
in-law-sister of	
in-law-son of	
mother of	
parent of	
sibling of	
sister of	
son of	
unstated	
wife of	

Related_to (Integer)

Foreign key identifying the Person record [PID] field (see Person.csv) to which a Related_people individual belongs.

Event_id (Integer)

Foreign key identifying the Event record (see Event.csv) to which a Related_people individual belongs.

Forename (String)

Forename of a Related_people individual in the original orthography as given in the source. Where two variants are given the second is enclosed in square brackets [].

Surname (String)

Forename of a Related_people individual in the original orthography as given in the source. Where two variants are given the second is enclosed in square brackets [].

stated_sex (String)

The sex of a Related_people individual. Can be M for male, F for female or X for unknown.

Residence (String)

Place of residence of a Related_people individual, where such information is given. Unstandardised; sometimes abbreviated.

Occupation (String)

Occupation or economic status of a Related_people individual, including titles, where such information is given. Unstandardised; sometimes abbreviated.

Age (String)

Age of a Related_people individual, where such information is given in the source. May be a precise age in years, days or months, or a general descriptor such as “aged”. Unstandardised.

Condition.csv

Each record represents any Conditions, or standardised piece of status information, belonging to a Person. A Person may have one Condition. Each Condition must have a corresponding Person (see Person.csv).

FlagID (Integer)

Unique identifier for each Condition record.

PersonID (Integer)

Foreign key identifying the [PID] field of the Person to which a Condition belongs (see Person.csv)

Flags (String)

A standardised version of some piece of especially pertinent status information about a Person which is given in the source. The options are:

abortive	
chrisom	
chrisom child	
chrisom triplet quadruplet	
chrisom twins	
deceased	
elder/senior	
foundling	
foundling chrisom	
foundling twins	
illegitimate	
illegitimate chrisom	
illegitimate stillborn	
illegitimate twins	
married	
married nonconformist	
nonconformist	
posthumous	
posthumous illegitimate	
posthumous twins	
single	
single triplets	
single, the younger	
stillborn	
stillborn chrisom	
stillborn illegitimate	
stillborn illegitimate twins	
stillborn twins	
the younger	
triplet	
triplet quadruplet	
twin	
twins	
twins, chrisom	
under 21	
widowed	
widowed nonconformist	

RP_Condition

Each record represents a Condition, or standardised piece of status information, belonging to a Related_people individual. A Related_people individual may have one or more Condition. Each Condition must have a corresponding Related_people individual (see Related_people.csv).

FlagID (Integer)

Unique identifier for each Condition record.

PersonID (Integer)

Foreign key identifying the [RPID] field of the Related_people individual to which a Condition belongs (see Related_people.csv)

Flags (String)

A standardised version of some piece of especially pertinent status information about a Related_people individual which is given in the source. The options are as given for the Condition table [Flags] field (see Condition.csv).