People+Place database

Creator(s): Laila Ellmoos; Penny Crook

Year: 2006

Summary

The People+Place database is a customised relational database, created in Microsoft Access, and designed to store, display, search and analyse historical occupancy data about Individuals and Buildings or Places in which they lived or worked. While its primary aim is to link archaeological assemblages with the houses, shops and pubs from which they were excavated and the people who lived and worked there, it also serves the needs of historians or heritage managers undertaking site-specific or neighbourhood research. The People+Place database has three major features: (1) It has the capacity to hold data from many different types of historical sources, encompassing Birth Certificates, Council Rates records, newspaper articles and manuscripts that mention a particular building, occupant or landlord. (2) It records both this ‘raw’ data and summarised biographies about people and places, enabling future users to verify the information presented to them. (3) It tracks filial and other relationships between individuals linked to the study area, including marriages, parents and siblings, business partnerships and friendships.

Cite this Record

People+Place database. Laila Ellmoos, Penny Crook. 2006 ( tDAR id: 407299) ; doi:10.6067/XCV8377BSR

This Resource is Part of the Following Collections

Data Set Structure

Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)

Table Information: BiblioData

Column Name Data Type Type Category Coding Sheet Ontology Search
SourceID ID number automatically allocated to each bibliographic entry.
BIGINT  Uncoded Value uncategorized none none true
AuthorSurname Surname of the main author.
TEXT  Uncoded Value uncategorized none none true
AuthorFirstName First name or initial of the main author.
TEXT  Uncoded Value uncategorized none none true
OtherAuthorSeparator The punctuation or words that should separate the primary author and the co-author, or the first of several co-authors, eg ',', 'and', or 'in association with'
TEXT  Uncoded Value uncategorized none none true
Other Authors Full names of other authors, with firstname first, eg 'Jane Smith'.
TEXT  Uncoded Value uncategorized none none true
Title The full title of the published document or report, or a description of an excerpt or other work.
TEXT  Uncoded Value uncategorized none none true
Publisher Name of the publisher or client. If a client, include 'for': eg, 'for Jo Smith Pty Ltd'.
TEXT  Uncoded Value uncategorized none none true
PublishedIn Place of publication.
TEXT  Uncoded Value uncategorized none none true
PublishedDate Year of publication or the year a report was released.
TEXT  Uncoded Value uncategorized none none true
Vol Number of volumes included in this entry. (Each volume in a series may be given its own entry.)
TEXT  Uncoded Value uncategorized none none true
Volume or Series Details Details of the series (if this is one volume from a larger series) or all the volumes (if all volumes in a series are included in this record).
TEXT  Uncoded Value uncategorized none none true
PageFrom If an article or excerpt from a larger document, the first page number of this excerpt.
TEXT  Uncoded Value uncategorized none none true
PageTo If an article or excerpt from a larger document, the last page number of this excerpt.
TEXT  Uncoded Value uncategorized none none true
Datefrom Earliest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none true
DateTo Latest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none true
Source The place or places where this document is held.
TEXT  Uncoded Value uncategorized none none true
RefNo The reference number or name to retrieve this document from the source selected.
TEXT  Uncoded Value uncategorized none none true
SourceType The type of information contained in this document: either primary or secondary.
TEXT  Uncoded Value uncategorized none none true
Format Format of physical document, eg 'photocopies of newspapers', 'book', 'box of photographs'.
TEXT  Uncoded Value uncategorized none none true
DocumentType Type of document: 'official', 'post-office directory', 'excavation report' etc
TEXT  Uncoded Value uncategorized none none true
Comments Any additional comments about the work.
TEXT  Uncoded Value uncategorized none none true
Entered by Name of the person who entered the information about this document into this form.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date when the information about this document was entered into People+Place.
DATETIME  Uncoded Value uncategorized none none true
Enteredby Login name of the person who entered the record into People+Place.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The latest date on which the record was modified using the Biblio form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last modified the record using the Biblio form.
TEXT  Uncoded Value uncategorized none none true

Table Information: Core_Buildings

Column Name Data Type Type Category Coding Sheet Ontology Search
BuildingID ID number automatically allocated to each Building.
BIGINT  Uncoded Value uncategorized none none true
SiteName The archaeological site on which the building was excavated (where relevant).
TEXT  Uncoded Value uncategorized none none true
BldgName The primary name by which the Building will be listed, this is usually the most recent or common street address (eg 1 Carahers Lane).
TEXT  Uncoded Value uncategorized none none true
OtherName Other names by which the Building is referred to historical documentation or recent reports, eg 'The Massey Terraces'
TEXT  Uncoded Value uncategorized none none true
FormerAddresses Former street addresses of this building.
TEXT  Uncoded Value uncategorized none none true
BldgCode A unique code allocated to each building, used to sort all buildings by street address and on reports where there is not sufficient space to show the full Building Name.
TEXT  Uncoded Value uncategorized none none true
StreetNo The number of the house.
TEXT  Uncoded Value uncategorized none none true
StreetName The name of the street.
TEXT  Uncoded Value uncategorized none none true
Section The Section (or block) number on which the house is situated. This appears on official survey plans.
TEXT  Uncoded Value uncategorized none none true
LotNumber The lot number within the Section or block.
TEXT  Uncoded Value uncategorized none none true
ConstructionDate The year the buliding was constructed. (Use of circa is OK.)
TEXT  Uncoded Value uncategorized none none true
DemolitionDate The year the buliding was demolished. (Use of circa is OK.)
TEXT  Uncoded Value uncategorized none none true
HouseOwners The name(s) of the original owner(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none true
Builder The name(s) of the original builder(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none true
Occupants The name(s) of the original occupant(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none true
Description Description of the building etc known from historical or archaeological sources.
TEXT  Uncoded Value uncategorized none none true
NoOfFloors Number of floors, if known.
BIGINT  Uncoded Value uncategorized none none true
NoRooms Number of rooms, if known.
DOUBLE  Uncoded Value uncategorized none none true
DwellingType Dwelling type, at time of construction
TEXT  Uncoded Value uncategorized none none true
Notes Additional notes or comments about the building and/or its owners/occupiers/builders.
TEXT  Uncoded Value uncategorized none none true
BibliographicReferences References for relevant reports and documents that discuss this building.
TEXT  Uncoded Value uncategorized none none true
Trench For excavated buildings only, the Trench in which it was recovered.
TEXT  Uncoded Value uncategorized none none true
ArchaeologicalEvidence For excavated buildings only, details of the archaeological remains of the building.
TEXT  Uncoded Value uncategorized none none true
ExcavSheetRef For excavated buildings only, the excavation plans in which the building appears.
TEXT  Uncoded Value uncategorized none none true
ContextNo For excavated buildings only, key context numbers associated with the building.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date on which the Building's record was created in the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Building's record in the People+Place database.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date on which the Building's record was last updated or modified using the Buildings Register.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Building's form using the Buildings Register.
TEXT  Uncoded Value uncategorized none none true

Table Information: Core_Individuals

Column Name Data Type Type Category Coding Sheet Ontology Search
IndividualID ID number automatically allocated to each Individual.
BIGINT  Uncoded Value uncategorized none none true
Title Individual's Title, eg Mr, Mrs or Miss (if known).
TEXT  Uncoded Value uncategorized none none true
Surname Individual's Surname. Use the most common or best-known spelling, or the last known surname for married women. Alternative spellings and names can be entered in the 'Other Surnames' field.
TEXT  Uncoded Value uncategorized none none true
Forename Individual's first name.
TEXT  Uncoded Value uncategorized none none true
MaidenName If the individual is a married woman, enter her maiden name here (if known)
TEXT  Uncoded Value uncategorized none none true
OtherMarriedNames If the individual is a woman who has married more than once, enter her former married names here (if known)
TEXT  Uncoded Value uncategorized none none true
OtherSurnames If the individual's surname has multiple spellings, enter the variations here.
TEXT  Uncoded Value uncategorized none none true
Occupation The Occupation(s) of the Individual, if known
TEXT  Uncoded Value uncategorized none none true
Born The year the individual was born, if known
TEXT  Uncoded Value uncategorized none none true
Died The year the individual died, if known
TEXT  Uncoded Value uncategorized none none true
Sex Whether the Individual is male or female
TEXT  Uncoded Value uncategorized none none true
Married Whether the Individual is married. If yes give the year of marriage in the following format: 'Yes: 1858'
TEXT  Uncoded Value uncategorized none none true
Children? Whether the Individual has children. If yes, give the number in the following format: 'Yes: 1'.
TEXT  Uncoded Value uncategorized none none true
Immigrant Whether the Individual was an Immigrant to Australia. If yes, give the year they arrived in the following format: 'Yes: 1862'.
TEXT  Uncoded Value uncategorized none none true
Birthplace Where the Individual was born, if known.
TEXT  Uncoded Value uncategorized none none true
EthnicGroup The Ethnic Grouping of the Individual and/or their family (eg, English, Scottish, Chinese), if known.
TEXT  Uncoded Value uncategorized none none true
Religion The religious denomination of the Individual and/or their family, if known.
TEXT  Uncoded Value uncategorized none none true
Literate Whether or not the Individual was literate, if known.
TEXT  Uncoded Value uncategorized none none true
Biography Include here any known biographical notes about the Individual's life.
TEXT  Uncoded Value uncategorized none none true
Notes Include here any notes about the Individual's record, concerns or justification for the inclusion of particular information.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date on which the Individual's record was created in the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Individual's record in the People+Place database.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date on which the Individual's record was last updated or modified using the Individuals Register.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Individual's form using the Individuals Register.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataI_Births

Column Name Data Type Type Category Coding Sheet Ontology Search
BirthsRecordID ID number automatically allocated to each Birth record
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual referred to in this Birth Certificate or Baptism Register. Pick from list. Double-click to add an Individual to the list
BIGINT  Uncoded Value uncategorized none none true
Surname The Surname of the Individual exactly as it appears on the Birth Certificate or Baptism Register (ie including mispellings)
TEXT  Uncoded Value uncategorized none none true
Given Name The forename of the Individual exactly as it appears on the Birth Certificate or Baptism Register (ie including mispellings)
TEXT  Uncoded Value uncategorized none none true
Sex Whether male or female
TEXT  Uncoded Value uncategorized none none true
Date of Birth Date of Birth as listed on the Certificate
DATETIME  Uncoded Value uncategorized none none true
DateofBaptism Date of Baptism, if given
DATETIME  Uncoded Value uncategorized none none true
RegNo Registration Number as it appears on the Certificate
TEXT  Uncoded Value uncategorized none none true
PlaceofRegistration The place where the child's birth was registered.
TEXT  Uncoded Value uncategorized none none true
Father Father's name as it appears on the Certificate (ie including mispellings), if given.
TEXT  Uncoded Value uncategorized none none true
FathersAge Father's age as it appears on the Certificate, if given.
TEXT  Uncoded Value uncategorized none none true
FathersBirthPlace Father's place of birth as it appears on the Certificate, if given.
TEXT  Uncoded Value uncategorized none none true
Father'sOccupation Father's occupation as it appears on the Certificate, if given.
TEXT  Uncoded Value uncategorized none none true
FatherPreviousIssueLiving The father's surviving children from previous marriages
TEXT  Uncoded Value uncategorized none none true
FatherPreviousIssueDeceased The father's deceased children from previous marriages
TEXT  Uncoded Value uncategorized none none true
Mother Mother's name as it appears on the Certificate (ie including mispellings), if given.
TEXT  Uncoded Value uncategorized none none true
MothersAge Mother's age as it appears on the Certificate, if given.
TEXT  Uncoded Value uncategorized none none true
MothersBirthPlace Mother's place of birth as it appears on the Certificate, if given.
TEXT  Uncoded Value uncategorized none none true
WhenMarried Date or year when the child's parents married, if given
TEXT  Uncoded Value uncategorized none none true
WhereMarried Place where the child's parents married, if given
TEXT  Uncoded Value uncategorized none none true
MotherPreviousIssueLiving The mother's surviving children from previous marriages
TEXT  Uncoded Value uncategorized none none true
MotherPreviousIssueDeceased The mother's deceased children from previous marriages
TEXT  Uncoded Value uncategorized none none true
Residence Where the parents are currently residing
TEXT  Uncoded Value uncategorized none none true
InformantName Name of the person who supplied the information for the registration
TEXT  Uncoded Value uncategorized none none true
InformantDescription Relationship of the Informant to the family
TEXT  Uncoded Value uncategorized none none true
InformantResidence Where the Informant currently resides
TEXT  Uncoded Value uncategorized none none true
PresentatBirth Names of individuals present at the birth, if given
TEXT  Uncoded Value uncategorized none none true
Witnesses Witnesses
TEXT  Uncoded Value uncategorized none none true
Nurse Attending nurse
TEXT  Uncoded Value uncategorized none none true
Denomination Religious Denomination of the family
TEXT  Uncoded Value uncategorized none none true
Parish Parish in which they family lives
TEXT  Uncoded Value uncategorized none none true
Minister Name of minister
TEXT  Uncoded Value uncategorized none none true
Registrar Name of the Registrar who processed the form
TEXT  Uncoded Value uncategorized none none true
RegYear Registration Year
BIGINT  Uncoded Value uncategorized none none true
VolRef Volume reference for the certificate
TEXT  Uncoded Value uncategorized none none true
Index Year Index Year
BIGINT  Uncoded Value uncategorized none none true
District District in which the child was born
TEXT  Uncoded Value uncategorized none none true
Country County in which the child was born
TEXT  Uncoded Value uncategorized none none true
Notes Use this field to make any necessary notes about the Certificate or its database record.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Birth Record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Birth Record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Birth Record was last updated or modified using the Births form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who modified the Birth Record using the Births form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataI_Deaths

Column Name Data Type Type Category Coding Sheet Ontology Search
Age Age at time of death
BIGINT  Uncoded Value uncategorized none none true
DeathRecordID ID number automatically allocated to each Death record
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual referred to in this Death Certificate. Pick from list. Double-click to add an Individual to the list
BIGINT  Uncoded Value uncategorized none none true
RegNo Registration Number
TEXT  Uncoded Value uncategorized none none true
Surname Surname of the deceased exactly as it appears on the Death Certificate (ie including mispellings)
TEXT  Uncoded Value uncategorized none none true
Given Name Forename of the deceased exactly as it appears on the Death Certificate (ie including mispellings)
TEXT  Uncoded Value uncategorized none none true
Date Date of death
DATETIME  Uncoded Value uncategorized none none true
Place Place of death
TEXT  Uncoded Value uncategorized none none true
Occupation Occupation of the deceased
TEXT  Uncoded Value uncategorized none none true
CauseOfDeath Illness or condition that caused death
TEXT  Uncoded Value uncategorized none none true
DurationLastIllness Length of time that the deceased had been suffering from their fatal illness/injuries
TEXT  Uncoded Value uncategorized none none true
MedicalAttendant Medical attendant by whom the death was certified
TEXT  Uncoded Value uncategorized none none true
MedicalAttendantLastSeen When Medical Attendant last saw the deceased
TEXT  Uncoded Value uncategorized none none true
Mother The deceased's mother
TEXT  Uncoded Value uncategorized none none true
Father The deceased's father
TEXT  Uncoded Value uncategorized none none true
Informant Signature, description and residence of informant
TEXT  Uncoded Value uncategorized none none true
InformantID If the Informant is stored in the People+Place database, you can select their name from this list
BIGINT  Uncoded Value uncategorized none none true
WhenBuried Date the deceased was buried
TEXT  Uncoded Value uncategorized none none true
WhereBuried Place where the deceased was buried
TEXT  Uncoded Value uncategorized none none true
Undertaker Name of the undertaker
TEXT  Uncoded Value uncategorized none none true
Minister Name of the minister
TEXT  Uncoded Value uncategorized none none true
Witnesses Names of any witnesses, if given
TEXT  Uncoded Value uncategorized none none true
PlaceOfBirth Place where the deceased was born
TEXT  Uncoded Value uncategorized none none true
TimeAustnColonies Time spent in the Australian colonies
TEXT  Uncoded Value uncategorized none none true
MarriageWhere Where the deceased was married
TEXT  Uncoded Value uncategorized none none true
MarriageAge The age of the deceased when they married
TEXT  Uncoded Value uncategorized none none true
MarriageSpouse Name of the deceased's spouse
TEXT  Uncoded Value uncategorized none none true
Issue Issue in order of birth and age at parent's death
TEXT  Uncoded Value uncategorized none none true
Index Year Year of the Index in which the entry appears
BIGINT  Uncoded Value uncategorized none none true
Denomination Religious Denomination of the deceased
TEXT  Uncoded Value uncategorized none none true
Parish Parish in which the deceased lived
TEXT  Uncoded Value uncategorized none none true
VolRef Volume Reference
TEXT  Uncoded Value uncategorized none none true
RegYear Registration Year
TEXT  Uncoded Value uncategorized none none true
Notes Use this field to make any necessary notes about the Certificate or its database record.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Death Record was entered into People+Place.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who entered the Death Record into People+Place.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The latest date on which the Death Record was modified using the Deaths form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last modified the Death Record using the Deaths form
TEXT  Uncoded Value uncategorized none none true

Table Information: DataI_Marriages

Column Name Data Type Type Category Coding Sheet Ontology Search
WifeStatus Wife's marital status
TEXT  Uncoded Value uncategorized none none true
PlaceOfRegistration Place of Registration
TEXT  Uncoded Value uncategorized none none true
MarriageRecordID ID number automatically allocated to each Marriage record
BIGINT  Uncoded Value uncategorized none none true
HusbandID Unique ID of the husband as stored in the People+Places database. Pick from list. Double-click to add an Individual to the list
BIGINT  Uncoded Value uncategorized none none true
WifeID Unique ID of the wife as stored in the People+Places database. Pick from list. Double-click to add an Individual to the list
BIGINT  Uncoded Value uncategorized none none true
RegNo Registration number
TEXT  Uncoded Value uncategorized none none true
RegYear Registration Year
BIGINT  Uncoded Value uncategorized none none true
VolumeNumber Volume Number
TEXT  Uncoded Value uncategorized none none true
DateofMarriage Date of Marriage
DATETIME  Uncoded Value uncategorized none none true
HusbandFirstName Husband's forename as it appears on the Certificate (ie including spelling mistakes)
TEXT  Uncoded Value uncategorized none none true
HusbandSurname Husband's Surname as it appears on the Certificate (ie including spelling mistakes)
TEXT  Uncoded Value uncategorized none none true
HusbandStatus Husband's marital status
TEXT  Uncoded Value uncategorized none none true
HusbandBirthPlace Husband's place of birth
TEXT  Uncoded Value uncategorized none none true
HusbandOccupation Husband's Rank or Profession
TEXT  Uncoded Value uncategorized none none true
HusbandAge Age of Husband at Time of Marriage
BIGINT  Uncoded Value uncategorized none none true
HusbandUsualResidence Husband's usual residence
TEXT  Uncoded Value uncategorized none none true
NameofHusband'sFather Husband's father
TEXT  Uncoded Value uncategorized none none true
NameofHusband'sMother Husband's mother
TEXT  Uncoded Value uncategorized none none true
Husand'sFather'sOccupation Husand's father's occupation
TEXT  Uncoded Value uncategorized none none true
WifeFirstName Wife's First Name as it appears on the Certificate (ie including spelling mistakes)
TEXT  Uncoded Value uncategorized none none true
WifeSurname Wife's Surname or Maiden Name as it appears on the Certificate (ie including spelling mistakes)
TEXT  Uncoded Value uncategorized none none true
WifeBirthPlace Wife's place of birth
TEXT  Uncoded Value uncategorized none none true
WifeOccupation Wife's Rank or Occupation
TEXT  Uncoded Value uncategorized none none true
WifeAge Age of Wife at Time of Marriage
BIGINT  Uncoded Value uncategorized none none true
Wife'sUsualResidence Wife's usual place of residence at the time of marriage
TEXT  Uncoded Value uncategorized none none true
NameofWife'sFather Wife's father
TEXT  Uncoded Value uncategorized none none true
NameofWife'sMother Wife's mother
TEXT  Uncoded Value uncategorized none none true
Wife'sFather'sOccupation Wife's father's occupation
TEXT  Uncoded Value uncategorized none none true
ChildrenfromFormerMarriage Children Living and dead by Each Former Marriage
TEXT  Uncoded Value uncategorized none none true
Witnesses Name of Witnesses to the marriage
TEXT  Uncoded Value uncategorized none none true
Minister Minister's name
TEXT  Uncoded Value uncategorized none none true
Parish Town and Church
TEXT  Uncoded Value uncategorized none none true
Denomination Religion
TEXT  Uncoded Value uncategorized none none true
Annotations Annotations made on the Certificate
TEXT  Uncoded Value uncategorized none none true
Notes Use this field to make any necessary notes about the Certificate or its database record.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Marriage Record was entered into the People+Place database
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who entered the record
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date that the record was last modified while using the Marriages form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last modified the record while using the Marriages form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataIB_Directories

Column Name Data Type Type Category Coding Sheet Ontology Search
DirectoriesRecordID ID number automatically allocated to each Directory Listing.
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual most likely to be referred to in this Directory Listing. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
BuildingID The Building most likely to be referred to in this Directory Listing. Pick from list. Double-click to add a Building to the list.
BIGINT  Uncoded Value uncategorized none none true
IBcode A Code automatically allocated once an Individual and/or Building has been selected. This represents the Individual ID and Building ID numbers.
TEXT  Uncoded Value uncategorized none none true
SourceID The bibliographic reference for the source of this Directory Listing. Pick from list. Double-click to add an item to the list.
BIGINT  Uncoded Value uncategorized none none true
Year Year in which the Directory was listed. (NB even if the Source includes the year, you must repeat it in the 'Year' field to enable sorting.)
BIGINT  Uncoded Value uncategorized none none true
Block The section in which the house appears in the Directory. (Each block was separated in directories by cross streets marked as 'Here lies Cribbs' Lane'.)
TEXT  Uncoded Value uncategorized none none true
StreetName The name of the street given in the original listing, transcribed exactly as it appears (ie including mispellings)
TEXT  Uncoded Value uncategorized none none true
StreetNo The number of the house given in the original listing. Note house numbers changed frequently so these may differ from the no. listed in the 'Building' field.
TEXT  Uncoded Value uncategorized none none true
Title The title (eg Mrs, Miss, Dr) of the Individual exactly as it appears in the original listing (ie including mispellings), where given
TEXT  Uncoded Value uncategorized none none true
FirstName The forename of the Individual exactly as it appears in the original listing (ie including mispellings), where given
TEXT  Uncoded Value uncategorized none none true
Surname The Surname of the Individual exactly as it appears in the original listing (ie including mispellings). For companies, place Company name here.
TEXT  Uncoded Value uncategorized none none true
Occupation The Occupation of the Individual exactly as it appears in the original listing, where given
TEXT  Uncoded Value uncategorized none none true
PageRef The page on which the Directory listing appears
TEXT  Uncoded Value uncategorized none none true
Notes Include here any notes about the listing or concerns, or justification, for the allocation of this listing to an Individual or Building.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Listing was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Listing was last updated or modified using the Directories form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who modified the record using the Directories form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataIB_Insolvency

Column Name Data Type Type Category Coding Sheet Ontology Search
InsolvencyID Unique ID number, automatically allocated to each Insolvency Record
BIGINT  Uncoded Value uncategorized none none true
InsolvRecordNo The Insolvency File number as it appears on the original documents.
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual most likely to be referred to in this Insolvency Record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
BuildingID The Building most likely to be referred to in this Insolvency Record. Pick from list. Double-click to add a Building to the list.
BIGINT  Uncoded Value uncategorized none none true
SourceID The bibliographic reference for the source of this Insolvency Record. Pick from list. Double-click to add an item to the list.
BIGINT  Uncoded Value uncategorized none none true
Surname The Surname of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none true
First Name The forename of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none true
Address The address of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none true
Occupation The Occupation of the Individual exactly as it appears in the original record.
TEXT  Uncoded Value uncategorized none none true
InsolvDate Date the Individual filed for insolvency.
DATETIME  Uncoded Value uncategorized none none true
InventDate Date that the inventory of the Individual's possessions was taken.
DATETIME  Uncoded Value uncategorized none none true
Inspector Name of the inspector who made the inventory, if given.
TEXT  Uncoded Value uncategorized none none true
Insolv Type Type of insolvency claim (eg voluntary or compulsory).
TEXT  Uncoded Value uncategorized none none true
In Debt Total debts that the Individual had accrued.
BIGINT  Uncoded Value uncategorized none none true
Owed Total of amounts owed to the Individual.
BIGINT  Uncoded Value uncategorized none none true
Furniture Value Total estimated value of the Individual's furnishings.
BIGINT  Uncoded Value uncategorized none none true
Apparel Value Total estimated value of the Individual's clothing and apparel.
BIGINT  Uncoded Value uncategorized none none true
Other value Total estimated value of the other items belonging to the Individual, as listed in the inventory.
TEXT  Uncoded Value uncategorized none none true
Notes Additional notes relevant to the record.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Insolvency record was entered into the People+Place database. (The date will appear automatically each time a new record is created.)
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who entered the record into the People+Place database. (The name will appear automatically each time a new record is created.)
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date on which the Insolvency record was last updated or modified using the Insolvency form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified using the Insolvency form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataIB_InsolvencyInv

Column Name Data Type Type Category Coding Sheet Ontology Search
EnteredBy Login name of the person who entered the record into the People+Place database. (The name will appear automatically each time a new record is created.)
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date on which the Insolvency Inventory record was last updated or modified using the Insolvency form.
DATETIME  Uncoded Value uncategorized none none true
InventoryRecordNo ID number automatically allocated to each item in the Inventory.
BIGINT  Uncoded Value uncategorized none none true
InsolvencyID The Insolvency ID number. (If entering the Inventory from the main Insolvency form, this number will be copied automatically from the main part of the form.)
BIGINT  Uncoded Value uncategorized none none true
InsolvNo The Insolvency File number as it appears on the original documents. (If entering the Inventory from the main Insolvency form, this number will be copied automatically from the main part of the form.)
BIGINT  Uncoded Value uncategorized none none true
Room Room in which the item was recorded
TEXT  Uncoded Value uncategorized none none true
Item Name of the item
TEXT  Uncoded Value uncategorized none none true
Quantity Number of items
BIGINT  Uncoded Value uncategorized none none true
Unclear Check box to note whether the notations were unclear and therefore the transcription is uncertain.
BOOLEAN  Uncoded Value uncategorized none none true
Notes Additional notes relevant to the record.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Inventory item was entered into the People+Place database. (The date will appear automatically each time a new record is created.)
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Insolvency Inventory record using the Insolvency form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataIB_ManuscriptNotes

Column Name Data Type Type Category Coding Sheet Ontology Search
ManuscriptRecordID ID number automatically allocated to each Manuscript record
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual most likely to be referred to in this Manuscript record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
BuildingID The Building most likely to be referred to in this Manuscript Record. Pick from list. Double-click to add a Building to the list.
BIGINT  Uncoded Value uncategorized none none true
SourceID The bibliographic reference for the source of this Manuscript. Pick from list. Double-click to add an item to the list.
BIGINT  Uncoded Value uncategorized none none true
ArchivesRef The catalogue number or other referece used by the Library or Archives to identify this manuscript (or its source).
TEXT  Uncoded Value uncategorized none none true
PageFrom The first or only page of the volume in which this Manuscript record appears.
BIGINT  Uncoded Value uncategorized none none true
PageTo The last page on which this Manuscript record appears.
BIGINT  Uncoded Value uncategorized none none true
DateFrom The date on which this Manuscript record was created, or for records produced over a period of time, the date the record was started.
DATETIME  Uncoded Value uncategorized none none true
DateTo For records produced over a period of time, the date the record was last amended.
DATETIME  Uncoded Value uncategorized none none true
DateNotes Field to include details of approximate or estimated dates etc.
TEXT  Uncoded Value uncategorized none none true
Detail The transcript or summary of the Manuscript record. Enclose direct quotes in quotation marks.
TEXT  Uncoded Value uncategorized none none true
Notes Additional Comments about the Manuscript record or allocation of Individual or Building IDs.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Manuscript record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Manuscript record was last updated or modified using the Manuscripts form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the record using the Manuscripts form.
TEXT  Uncoded Value uncategorized none none true

Table Information: DataIB_Rates

Column Name Data Type Type Category Coding Sheet Ontology Search
RateRecordID ID number automatically allocated to each Rates record.
BIGINT  Uncoded Value uncategorized none none true
SourceID The bibliographic reference for the source of this Rates record. Pick from list. Double-click to add an item to the list.
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual most likely to be the Person Rates in this rates assessment record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
IndividualName Name of Person Rated, as it appears on the original record (ie showing mis-spelling where relevant).
TEXT  Uncoded Value uncategorized none none true
OwnerID The Individual most likely to be the Owner or Landlord noted in this rates assessment record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
OwnerOrLandlord Name of the Owner or Landlord, as it appears on the original record (ie showing mis-spelling where relevant).
TEXT  Uncoded Value uncategorized none none true
StreetName The name of the street given in the original listing, transcribed exactly as it appears (ie including mis-spellings), NB street names changed often so these may differ from the street listed in the 'Building' field.
TEXT  Uncoded Value uncategorized none none true
StreetNo The number of the house given in the original rates assessment. Note house numbers changed frequently so these may differ from the no. listed in the 'Building' field.
TEXT  Uncoded Value uncategorized none none true
BuildingID The Building most likely to be referred to in this Rates Assessment Record. Pick from list. Double-click to add a Building to the list.
BIGINT  Uncoded Value uncategorized none none true
IBcode A Code automatically allocated once the Rated Person and/or Building has been selected. This represents the Individual ID and Building ID numbers.
TEXT  Uncoded Value uncategorized none none true
IBcodeOwner A Code automatically allocated once the Owner and/or Building has been selected. This represents the Individual ID and Building ID numbers.
TEXT  Uncoded Value uncategorized none none true
Year Year of assessment
BIGINT  Uncoded Value uncategorized none none true
BldgUse Primary use of the building (i.e. house, warehouse or shop)
TEXT  Uncoded Value uncategorized none none true
BuildingMaterial The building's primary fabric (i.e. brick, stone, timber)
TEXT  Uncoded Value uncategorized none none true
BuildingRoofingMaterials Type of roofing material (i.e. slate, shingles)
TEXT  Uncoded Value uncategorized none none true
NoOfFloors Number of floors
BIGINT  Uncoded Value uncategorized none none true
NoOfRooms Number of rooms
BIGINT  Uncoded Value uncategorized none none true
Rating Nett value fixed by Court of Quarter Sessions
BIGINT  Uncoded Value uncategorized none none true
Comments Comments made on the rates assessment book
TEXT  Uncoded Value uncategorized none none true
Notes Include here any notes about the listing or concerns, or justification, for the allocation of this listing to an Individual or Building.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Rates record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Rates record was last updated or modified using the Rates form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the record using the Rates form.
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkI_Family

Column Name Data Type Type Category Coding Sheet Ontology Search
IndividualID ID number of the Individual linked to the Family
BIGINT  Uncoded Value uncategorized none none true
FamilyLinkID ID number automatically allocated to each Family Link Record, ie each record for which an Individual is linked to a Family name
BIGINT  Uncoded Value uncategorized none none true
FamilyID Unique ID number allocated to each Family
BIGINT  Uncoded Value uncategorized none none true
Notes Include here any notes about the Family Link record or concerns, or justification, for the allocation of this Individual to this Family
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Family Link record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Family Link record in the People+Place database.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Family Link record was last updated or modified using the Family Associations tab on the Individuals Register
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Family Link record using the Family Associations tab on the Individuals Register Login name of the person who last updated or modified the Occupancy Record using the Occupancy Owner form.
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkI_OccupationGroup

Column Name Data Type Type Category Coding Sheet Ontology Search
ID Unique ID automatically allocated to each occupation linked to an Individual. (NB an individual can be linked to more than one Occupation.)
BIGINT  Uncoded Value uncategorized none none true
OccupationGroupName Eg 'Blacksmith', 'Stevedore'
TEXT  Uncoded Value uncategorized none none true
Industry Eg 'Manufacturing', 'Shipping'
TEXT  Uncoded Value uncategorized none none true
Subclassification Eg "Metal Trades', 'Wharves'
TEXT  Uncoded Value uncategorized none none true
IndividualID Unique ID of the Individual
BIGINT  Uncoded Value uncategorized none none true
Notes Add here any notes about the Occupation record
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkI_Relationships

Column Name Data Type Type Category Coding Sheet Ontology Search
RelationshipID ID number automatically allocated to each Relationship
BIGINT  Uncoded Value uncategorized none none true
IndividualID ID number of the first Individual in the relationship. They are the subject, ie Individual 1 is the wife of Individual 2.
BIGINT  Uncoded Value uncategorized none none true
RelationshipType Description of the relationship, ie wife, sister, brother-in-law
TEXT  Uncoded Value uncategorized none none true
RelationshipTo ID number of the second Individual in the relationship. They are the object, ie Individual 1 is the wife of Individual 2.
BIGINT  Uncoded Value uncategorized none none true
Notes Include here any notes about the Relationship or concerns, or justification, for the allocation of Individuals
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the Relationship record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Relationship Record in the People+Place database.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Relationship Record was last updated or modified using the Relationships tab of the Individuals Register
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Relationship Record using the Relationships tab of the Individuals Register Login name of the person who last updated or modified the Occupancy Record using the Occupancy Owner form.
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkIB_IndividualArtefacts

Column Name Data Type Type Category Coding Sheet Ontology Search
IndArtID ID number automatically allocated to each Link between an Individual and an artefact
BIGINT  Uncoded Value uncategorized none none true
IndividualID ID number of the Individual who owned, used or may be otherwise associated with the artefact.
BIGINT  Uncoded Value uncategorized none none true
CatalogueNumber The Catalogue Number of the artefact, as it appears in the EAMC Archaeology Database.
TEXT  Uncoded Value uncategorized none none true
Notes Add here any notes about the association between this Individual and the artefact
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkIB_IndividualContexts

Column Name Data Type Type Category Coding Sheet Ontology Search
IndContextID ID number automatically allocated to each Link between an Individual and a stratigraphic context.
BIGINT  Uncoded Value uncategorized none none true
IndividualID ID number of the Individual associated with this stratigraphic context.
BIGINT  Uncoded Value uncategorized none none true
Site The site from which the stratigraphic context was recovered, as it appears in the EAMC Archaeology Database.
TEXT  Uncoded Value uncategorized none none true
UnitAndArea The Context Number of the stratigraphic context associated with this Individual, as it appears in the EAMC Archaeology Database.
TEXT  Uncoded Value uncategorized none none true
MasterContext The Master Context group to which the stratigraphic context was allocated, as it appears in the EAMC Archaeology Database.
TEXT  Uncoded Value uncategorized none none true
ConfidenceLevel The degree of confidence with which this stratigraphic context has been associated with this Individual.
TEXT  Uncoded Value uncategorized none none true
Notes Add here any notes about the association between this Individual and the stratigraphic context.
TEXT  Uncoded Value uncategorized none none true

Table Information: LinkIB_OccupancyOwner

Column Name Data Type Type Category Coding Sheet Ontology Search
OccupancyRecordID ID number automatically allocated to each recorded period of ownership or occupancy.
BIGINT  Uncoded Value uncategorized none none true
IBcode A Unique code representing the Individual ID and Building ID numbers. Added automatically, but editable. Add ‘a’, ‘b’, ‘c’ to the end of the Code to distinguish between multiple occupancy periods for the an Individual in the same Building at a later time.
TEXT  Uncoded Value uncategorized none none true
BuildingID The Building owned or occupied by the Individual in this record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
IndividualID The Individual who owned or occupied the Building in this record. Pick from list. Double-click to add an Individual to the list.
BIGINT  Uncoded Value uncategorized none none true
OccupantType The type of occupation/ownership, eg 'Owner', 'Occupant'
TEXT  Uncoded Value uncategorized none none true
DateFrom The first known year of occupation or ownership, according to current research.
BIGINT  Uncoded Value uncategorized none none true
DateTo The last known year of occupation or ownership, according to current research.
BIGINT  Uncoded Value uncategorized none none true
Notes Add here any notes about this period of ownership/occupancy.
TEXT  Uncoded Value uncategorized none none true
Verified Whether or not the record has been reviewed and Verified. Once Verified, a record will not be affected by the automatic upload features of People+Place.
BOOLEAN  Uncoded Value uncategorized none none true
DateEntered Date the Occupancy Link record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who created the Occupancy Link in the People+Place database.
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date the Occupancy Link was last updated or modified using the Occupancy Link screen.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the Occupancy Link using the Occupancy Link screen.
TEXT  Uncoded Value uncategorized none none true

Table Information: List_FamilyNames

Column Name Data Type Type Category Coding Sheet Ontology Search
FamilyID ID number automatically allocated to each Family.
BIGINT  Uncoded Value uncategorized none none true
Surname Family's surname
TEXT  Uncoded Value uncategorized none none true
CurrentDescendants Name of current descendants if known
TEXT  Uncoded Value uncategorized none none true
ImmigrationDetails Details of when the family first migrated to the colonies, if known
TEXT  Uncoded Value uncategorized none none true
Notes Additional notes or comments about the family
TEXT  Uncoded Value uncategorized none none true
DateEntered Date the family was entered into the People+Place database
DATETIME  Uncoded Value uncategorized none none true
EnteredBy Login name of the person who entered the family into the People+Place database
TEXT  Uncoded Value uncategorized none none true
DateUpdated Date that the family's record was last updated or modified using the Families screen.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy Login name of the person who last updated or modified the family's record using the Families screen.
TEXT  Uncoded Value uncategorized none none true

Table Information: Switchboard Items

Column Name Data Type Type Category Coding Sheet Ontology Search
SwitchboardID BIGINT  Uncoded Value uncategorized none none true
ItemNumber BIGINT  Uncoded Value uncategorized none none true
ItemText TEXT  Uncoded Value uncategorized none none true
Command BIGINT  Uncoded Value uncategorized none none true
Argument TEXT  Uncoded Value uncategorized none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
ONE_TO_MANY Core_Individuals DataIB_Insolvency IndividualID IndividualID
ONE_TO_MANY Core_Buildings DataIB_Insolvency BuildingID BuildingID
ONE_TO_MANY List_FamilyNames LinkI_Family FamilyID FamilyID
ONE_TO_MANY Core_Individuals LinkI_Relationships IndividualID IndividualID
ONE_TO_MANY Core_Individuals LinkI_Family IndividualID IndividualID
ONE_TO_MANY Core_Individuals LinkIB_IndividualArtefacts IndividualID IndividualID
ONE_TO_ONE DataIB_InsolvencyInv DataIB_Insolvency InventoryRecordNo InsolvRecordNo
ONE_TO_MANY Core_Individuals LinkI_Relationships IndividualID RelationshipTo

Temporal Coverage

Calendar Date: 1795 to 1919 (Occupancy range)

Spatial Coverage

min long: 151.206; min lat: -33.861 ; max long: 151.207; max lat: -33.859 ;

Record Identifiers

TDAR ID(s): 6866

FAIMS ID(s): repo.fedarch.org/dataset/6866

Notes

Rights & Attribution: Copyright EAMC Industry Partners 2006

File Information

  Name Size Creation Date Date Uploaded Access
peopleandplace.mdb 64.49mb Aug 20, 2016 11:39:30 AM Public