tDAR Logo tDAR digital antiquity

People+Place database

Creator(s): Laila Ellmoos ; Penny Crook

Year: 2006

» Downloads & Basic Metadata

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.


This Resource is Part of the Following Collections


Cite this Record

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


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
UpdatedBy Login name of the person who last modified the record using the Biblio form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The latest date on which the record was modified using the Biblio form.
DATETIME  Uncoded Value uncategorized none none
Enteredby Login name of the person who entered the record into People+Place.
TEXT  Uncoded Value uncategorized none none
DateEntered Date when the information about this document was entered into People+Place.
DATETIME  Uncoded Value uncategorized none none
Entered by Name of the person who entered the information about this document into this form.
TEXT  Uncoded Value uncategorized none none
Comments Any additional comments about the work.
TEXT  Uncoded Value uncategorized none none
DocumentType Type of document: 'official', 'post-office directory', 'excavation report' etc
TEXT  Uncoded Value uncategorized none none
Format Format of physical document, eg 'photocopies of newspapers', 'book', 'box of photographs'.
TEXT  Uncoded Value uncategorized none none
SourceType The type of information contained in this document: either primary or secondary.
TEXT  Uncoded Value uncategorized none none
RefNo The reference number or name to retrieve this document from the source selected.
TEXT  Uncoded Value uncategorized none none
Source The place or places where this document is held.
TEXT  Uncoded Value uncategorized none none
DateTo Latest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none
Datefrom Earliest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none
PageTo If an article or excerpt from a larger document, the last page number of this excerpt.
TEXT  Uncoded Value uncategorized none none
PageFrom If an article or excerpt from a larger document, the first page number of this excerpt.
TEXT  Uncoded Value uncategorized none none
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
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
PublishedDate Year of publication or the year a report was released.
TEXT  Uncoded Value uncategorized none none
PublishedIn Place of publication.
TEXT  Uncoded Value uncategorized none none
Publisher Name of the publisher or client. If a client, include 'for': eg, 'for Jo Smith Pty Ltd'.
TEXT  Uncoded Value uncategorized none none
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
Other Authors Full names of other authors, with firstname first, eg 'Jane Smith'.
TEXT  Uncoded Value uncategorized none none
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
AuthorFirstName First name or initial of the main author.
TEXT  Uncoded Value uncategorized none none
AuthorSurname Surname of the main author.
TEXT  Uncoded Value uncategorized none none
SourceID ID number automatically allocated to each bibliographic entry.
BIGINT  Uncoded Value uncategorized none none

Table Information: Core_Buildings

Column Name Data Type Type Category Coding Sheet Ontology
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
DateUpdated Date on which the Building's record was last updated or modified using the Buildings Register.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the Building's record in the People+Place database.
TEXT  Uncoded Value uncategorized none none
DateEntered Date on which the Building's record was created in the People+Place database.
DATETIME  Uncoded Value uncategorized none none
ContextNo For excavated buildings only, key context numbers associated with the building.
TEXT  Uncoded Value uncategorized none none
ExcavSheetRef For excavated buildings only, the excavation plans in which the building appears.
TEXT  Uncoded Value uncategorized none none
ArchaeologicalEvidence For excavated buildings only, details of the archaeological remains of the building.
TEXT  Uncoded Value uncategorized none none
Trench For excavated buildings only, the Trench in which it was recovered.
TEXT  Uncoded Value uncategorized none none
BibliographicReferences References for relevant reports and documents that discuss this building.
TEXT  Uncoded Value uncategorized none none
Notes Additional notes or comments about the building and/or its owners/occupiers/builders.
TEXT  Uncoded Value uncategorized none none
DwellingType Dwelling type, at time of construction
TEXT  Uncoded Value uncategorized none none
NoRooms Number of rooms, if known.
DOUBLE  Uncoded Value uncategorized none none
NoOfFloors Number of floors, if known.
BIGINT  Uncoded Value uncategorized none none
Description Description of the building etc known from historical or archaeological sources.
TEXT  Uncoded Value uncategorized none none
Occupants The name(s) of the original occupant(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none
Builder The name(s) of the original builder(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none
HouseOwners The name(s) of the original owner(s) of the building, where known.
TEXT  Uncoded Value uncategorized none none
DemolitionDate The year the buliding was demolished. (Use of circa is OK.)
TEXT  Uncoded Value uncategorized none none
ConstructionDate The year the buliding was constructed. (Use of circa is OK.)
TEXT  Uncoded Value uncategorized none none
LotNumber The lot number within the Section or block.
TEXT  Uncoded Value uncategorized none none
Section The Section (or block) number on which the house is situated. This appears on official survey plans.
TEXT  Uncoded Value uncategorized none none
StreetName The name of the street.
TEXT  Uncoded Value uncategorized none none
StreetNo The number of the house.
TEXT  Uncoded Value uncategorized none none
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
FormerAddresses Former street addresses of this building.
TEXT  Uncoded Value uncategorized none none
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
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
SiteName The archaeological site on which the building was excavated (where relevant).
TEXT  Uncoded Value uncategorized none none
BuildingID ID number automatically allocated to each Building.
BIGINT  Uncoded Value uncategorized none none

Table Information: Core_Individuals

Column Name Data Type Type Category Coding Sheet Ontology
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
DateUpdated Date on which the Individual's record was last updated or modified using the Individuals Register.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the Individual's record in the People+Place database.
TEXT  Uncoded Value uncategorized none none
DateEntered Date on which the Individual's record was created in the People+Place database.
DATETIME  Uncoded Value uncategorized none none
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
Biography Include here any known biographical notes about the Individual's life.
TEXT  Uncoded Value uncategorized none none
Literate Whether or not the Individual was literate, if known.
TEXT  Uncoded Value uncategorized none none
Religion The religious denomination of the Individual and/or their family, if known.
TEXT  Uncoded Value uncategorized none none
EthnicGroup The Ethnic Grouping of the Individual and/or their family (eg, English, Scottish, Chinese), if known.
TEXT  Uncoded Value uncategorized none none
Birthplace Where the Individual was born, if known.
TEXT  Uncoded Value uncategorized none none
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
Children? Whether the Individual has children. If yes, give the number in the following format: 'Yes: 1'.
TEXT  Uncoded Value uncategorized none none
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
Sex Whether the Individual is male or female
TEXT  Uncoded Value uncategorized none none
Died The year the individual died, if known
TEXT  Uncoded Value uncategorized none none
Born The year the individual was born, if known
TEXT  Uncoded Value uncategorized none none
Occupation The Occupation(s) of the Individual, if known
TEXT  Uncoded Value uncategorized none none
OtherSurnames If the individual's surname has multiple spellings, enter the variations here.
TEXT  Uncoded Value uncategorized none none
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
MaidenName If the individual is a married woman, enter her maiden name here (if known)
TEXT  Uncoded Value uncategorized none none
Forename Individual's first name.
TEXT  Uncoded Value uncategorized none none
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
Title Individual's Title, eg Mr, Mrs or Miss (if known).
TEXT  Uncoded Value uncategorized none none
IndividualID ID number automatically allocated to each Individual.
BIGINT  Uncoded Value uncategorized none none

Table Information: DataI_Births

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

Table Information: DataI_Deaths

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

Table Information: DataI_Marriages

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

Table Information: DataIB_Directories

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy Login name of the person who modified the record using the Directories form.
TEXT  Uncoded Value uncategorized none none
DateUpdated Date the Listing was last updated or modified using the Directories form.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Listing was created.
DATETIME  Uncoded Value uncategorized none none
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
PageRef The page on which the Directory listing appears
TEXT  Uncoded Value uncategorized none none
Occupation The Occupation of the Individual exactly as it appears in the original listing, where given
TEXT  Uncoded Value uncategorized none none
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
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
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
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
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
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
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
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
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
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
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
DirectoriesRecordID ID number automatically allocated to each Directory Listing.
BIGINT  Uncoded Value uncategorized none none

Table Information: DataIB_Insolvency

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy Login name of the person who last updated or modified using the Insolvency form.
TEXT  Uncoded Value uncategorized none none
DateUpdated Date on which the Insolvency record was last updated or modified using the Insolvency form.
DATETIME  Uncoded Value uncategorized none none
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
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
Notes Additional notes relevant to the record.
TEXT  Uncoded Value uncategorized none none
Other value Total estimated value of the other items belonging to the Individual, as listed in the inventory.
TEXT  Uncoded Value uncategorized none none
Apparel Value Total estimated value of the Individual's clothing and apparel.
BIGINT  Uncoded Value uncategorized none none
Furniture Value Total estimated value of the Individual's furnishings.
BIGINT  Uncoded Value uncategorized none none
Owed Total of amounts owed to the Individual.
BIGINT  Uncoded Value uncategorized none none
In Debt Total debts that the Individual had accrued.
BIGINT  Uncoded Value uncategorized none none
Insolv Type Type of insolvency claim (eg voluntary or compulsory).
TEXT  Uncoded Value uncategorized none none
Inspector Name of the inspector who made the inventory, if given.
TEXT  Uncoded Value uncategorized none none
InventDate Date that the inventory of the Individual's possessions was taken.
DATETIME  Uncoded Value uncategorized none none
InsolvDate Date the Individual filed for insolvency.
DATETIME  Uncoded Value uncategorized none none
Occupation The Occupation of the Individual exactly as it appears in the original record.
TEXT  Uncoded Value uncategorized none none
Address The address of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none
First Name The forename of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none
Surname The Surname of the Individual exactly as it appears in the original record (ie including mispellings).
TEXT  Uncoded Value uncategorized none none
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
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
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
InsolvRecordNo The Insolvency File number as it appears on the original documents.
BIGINT  Uncoded Value uncategorized none none
InsolvencyID Unique ID number, automatically allocated to each Insolvency Record
BIGINT  Uncoded Value uncategorized none none

Table Information: DataIB_InsolvencyInv

Column Name Data Type Type Category Coding Sheet Ontology
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
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
Notes Additional notes relevant to the record.
TEXT  Uncoded Value uncategorized none none
Unclear Check box to note whether the notations were unclear and therefore the transcription is uncertain.
BOOLEAN  Uncoded Value uncategorized none none
Quantity Number of items
BIGINT  Uncoded Value uncategorized none none
Item Name of the item
TEXT  Uncoded Value uncategorized none none
Room Room in which the item was recorded
TEXT  Uncoded Value uncategorized none none
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
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
InventoryRecordNo ID number automatically allocated to each item in the Inventory.
BIGINT  Uncoded Value uncategorized none none
DateUpdated Date on which the Insolvency Inventory record was last updated or modified using the Insolvency form.
DATETIME  Uncoded Value uncategorized none none
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

Table Information: DataIB_ManuscriptNotes

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy Login name of the person who last updated or modified the record using the Manuscripts form.
TEXT  Uncoded Value uncategorized none none
DateUpdated Date the Manuscript record was last updated or modified using the Manuscripts form.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Manuscript record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none
Notes Additional Comments about the Manuscript record or allocation of Individual or Building IDs.
TEXT  Uncoded Value uncategorized none none
Detail The transcript or summary of the Manuscript record. Enclose direct quotes in quotation marks.
TEXT  Uncoded Value uncategorized none none
DateNotes Field to include details of approximate or estimated dates etc.
TEXT  Uncoded Value uncategorized none none
DateTo For records produced over a period of time, the date the record was last amended.
DATETIME  Uncoded Value uncategorized none none
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
PageTo The last page on which this Manuscript record appears.
BIGINT  Uncoded Value uncategorized none none
PageFrom The first or only page of the volume in which this Manuscript record appears.
BIGINT  Uncoded Value uncategorized none none
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
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
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
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
ManuscriptRecordID ID number automatically allocated to each Manuscript record
BIGINT  Uncoded Value uncategorized none none

Table Information: DataIB_Rates

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy Login name of the person who last updated or modified the record using the Rates form.
TEXT  Uncoded Value uncategorized none none
DateUpdated Date the Rates record was last updated or modified using the Rates form.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the record.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Rates record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none
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
Comments Comments made on the rates assessment book
TEXT  Uncoded Value uncategorized none none
Rating Nett value fixed by Court of Quarter Sessions
BIGINT  Uncoded Value uncategorized none none
NoOfRooms Number of rooms
BIGINT  Uncoded Value uncategorized none none
NoOfFloors Number of floors
BIGINT  Uncoded Value uncategorized none none
BuildingRoofingMaterials Type of roofing material (i.e. slate, shingles)
TEXT  Uncoded Value uncategorized none none
BuildingMaterial The building's primary fabric (i.e. brick, stone, timber)
TEXT  Uncoded Value uncategorized none none
BldgUse Primary use of the building (i.e. house, warehouse or shop)
TEXT  Uncoded Value uncategorized none none
Year Year of assessment
BIGINT  Uncoded Value uncategorized none none
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
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
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
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
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
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
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
IndividualName Name of Person Rated, as it appears on the original record (ie showing mis-spelling where relevant).
TEXT  Uncoded Value uncategorized none none
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
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
RateRecordID ID number automatically allocated to each Rates record.
BIGINT  Uncoded Value uncategorized none none

Table Information: LinkI_Family

Column Name Data Type Type Category Coding Sheet Ontology
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
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
EnteredBy Login name of the person who created the Family Link record in the People+Place database.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Family Link record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none
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
FamilyID Unique ID number allocated to each Family
BIGINT  Uncoded Value uncategorized none none
IndividualID ID number of the Individual linked to the Family
BIGINT  Uncoded Value uncategorized none none
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

Table Information: LinkI_OccupationGroup

Column Name Data Type Type Category Coding Sheet Ontology
Notes Add here any notes about the Occupation record
TEXT  Uncoded Value uncategorized none none
IndividualID Unique ID of the Individual
BIGINT  Uncoded Value uncategorized none none
Subclassification Eg "Metal Trades', 'Wharves'
TEXT  Uncoded Value uncategorized none none
Industry Eg 'Manufacturing', 'Shipping'
TEXT  Uncoded Value uncategorized none none
OccupationGroupName Eg 'Blacksmith', 'Stevedore'
TEXT  Uncoded Value uncategorized none none
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

Table Information: LinkI_Relationships

Column Name Data Type Type Category Coding Sheet Ontology
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
DateUpdated Date the Relationship Record was last updated or modified using the Relationships tab of the Individuals Register
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the Relationship Record in the People+Place database.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Relationship record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none
Notes Include here any notes about the Relationship or concerns, or justification, for the allocation of Individuals
TEXT  Uncoded Value uncategorized none none
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
RelationshipType Description of the relationship, ie wife, sister, brother-in-law
TEXT  Uncoded Value uncategorized none none
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
RelationshipID ID number automatically allocated to each Relationship
BIGINT  Uncoded Value uncategorized none none

Table Information: LinkIB_IndividualArtefacts

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

Table Information: LinkIB_IndividualContexts

Column Name Data Type Type Category Coding Sheet Ontology
Notes Add here any notes about the association between this Individual and the stratigraphic context.
TEXT  Uncoded Value uncategorized none none
ConfidenceLevel The degree of confidence with which this stratigraphic context has been associated with this Individual.
TEXT  Uncoded Value uncategorized none none
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
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
Site The site from which the stratigraphic context was recovered, as it appears in the EAMC Archaeology Database.
TEXT  Uncoded Value uncategorized none none
IndividualID ID number of the Individual associated with this stratigraphic context.
BIGINT  Uncoded Value uncategorized none none
IndContextID ID number automatically allocated to each Link between an Individual and a stratigraphic context.
BIGINT  Uncoded Value uncategorized none none

Table Information: LinkIB_OccupancyOwner

Column Name Data Type Type Category Coding Sheet Ontology
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
DateUpdated Date the Occupancy Link was last updated or modified using the Occupancy Link screen.
DATETIME  Uncoded Value uncategorized none none
EnteredBy Login name of the person who created the Occupancy Link in the People+Place database.
TEXT  Uncoded Value uncategorized none none
DateEntered Date the Occupancy Link record was entered into the People+Place database.
DATETIME  Uncoded Value uncategorized none none
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
Notes Add here any notes about this period of ownership/occupancy.
TEXT  Uncoded Value uncategorized none none
DateTo The last known year of occupation or ownership, according to current research.
BIGINT  Uncoded Value uncategorized none none
DateFrom The first known year of occupation or ownership, according to current research.
BIGINT  Uncoded Value uncategorized none none
OccupantType The type of occupation/ownership, eg 'Owner', 'Occupant'
TEXT  Uncoded Value uncategorized none none
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
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
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
OccupancyRecordID ID number automatically allocated to each recorded period of ownership or occupancy.
BIGINT  Uncoded Value uncategorized none none

Table Information: List_FamilyNames

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

Table Information: Switchboard Items

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

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

Keywords


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 ;

Individual & Institutional Roles

Sponsor(s): Sydney Harbour Foreshore Authority ; Heritage Victoria ; Godden Mackay Logan ; NSW Heritage Office ; City of Sydney ; Historic Houses Trust


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
Arizona State University The Andrew W. Mellon Foundation National Science Foundation National Endowment for the Humanities Society for American Archaeology Archaeological Institute of America