upload image

WikiTree Sourcer, Household Table Styles

Privacy Level: Open (White)
Date: [unknown] [unknown]
Location: [unknown]
Surnames/tags: wikitree_sourcer table
Profile manager: Rob Pavey private message [send private message]
This page has been accessed 159 times.

Contents

Household table styles

This page gives examples of different ways that household tables from census records can be presented on WikiTree profiles. Most of these can be automatically generated from the census record by WikiTree Sourcer. A few custom cases that required editing the table are given at the end.

Styles generated by WikiTree Sourcer

There are a lot of settings in WikiTree Sourcer for tables:

Sourcer options for Household Tables

The various combinations create thousands of possible styles. Here are few of the more popular ones.

Tables with borders

Default style with border and background color for heading and bold for selected person:

Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Default plus 100% width. Using this all the time makes all tables on the profile the same width:

Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Table with caption:

1881 Census of England: 7 Chippenham Rd, Paddington, London
Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Tables with no borders

Borderless table with heading:

Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Borderless with no heading:

Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Borderless with caption, bold centered heading and background color for selected:

1881 Census of England: 7 Chippenham Rd, Paddington, London
Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Borderless with bold non-centered heading. Only name highlighted for selected person:

Name Relation Status Sex Age Occupation Birth Place
Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Borderless with no table padding but extra horizontal spacing. This looks pretty similar to list form but the columns line up. It is more compact that the above form in read mode but is ugly looking in edit mode due to the use of & nbsp ; for the horizontal spacing:

Frederick Pavey    Head    Married    M    48    Cabinet Maker    Plymouth
Eliza Pavey    Wife    Married    F    47       Brighton
Alice Pavey    Daughter       F    21    Florist    Bayswater
Alfred Pavey    Son    Married    M    19    Conservatory Fitter (Build)    Middlesex, England
Jane Pavey    Daughter    Married    F    24       Hertfordshire, England
Beatrice Pavey    Granddaughter       F    17    Servant    Middlesex, England
Kate Pavey    Granddaughter       F    4       Middlesex, England
Fredk. Pavey    Grandson       M    1       Middlesex, England
Ellen Cook    Visitor    Widowed    F    39    Cook    Scotland
Annie Wilkins    Visitor       F    15    Servant    Brighton


Lists

Indented, with selected person in bold:

Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
Eliza Pavey Wife Married F 47 Brighton
Alice Pavey Daughter F 21 Florist Bayswater
Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
Jane Pavey Daughter Married F 24 Hertfordshire, England
Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
Kate Pavey Granddaughter F 4 Middlesex, England
Fredk. Pavey Grandson M 1 Middlesex, England
Ellen Cook Visitor Widowed F 39 Cook Scotland
Annie Wilkins Visitor F 15 Servant Brighton

Numbered:

  1. Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
  2. Eliza Pavey Wife Married F 47 Brighton
  3. Alice Pavey Daughter F 21 Florist Bayswater
  4. Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
  5. Jane Pavey Daughter Married F 24 Hertfordshire, England
  6. Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
  7. Kate Pavey Granddaughter F 4 Middlesex, England
  8. Fredk. Pavey Grandson M 1 Middlesex, England
  9. Ellen Cook Visitor Widowed F 39 Cook Scotland
  10. Annie Wilkins Visitor F 15 Servant Brighton

Bulleted:

  • Frederick Pavey Head Married M 48 Cabinet Maker Plymouth
  • Eliza Pavey Wife Married F 47 Brighton
  • Alice Pavey Daughter F 21 Florist Bayswater
  • Alfred Pavey Son Married M 19 Conservatory Fitter (Build) Middlesex, England
  • Jane Pavey Daughter Married F 24 Hertfordshire, England
  • Beatrice Pavey Granddaughter F 17 Servant Middlesex, England
  • Kate Pavey Granddaughter F 4 Middlesex, England
  • Fredk. Pavey Grandson M 1 Middlesex, England
  • Ellen Cook Visitor Widowed F 39 Cook Scotland
  • Annie Wilkins Visitor F 15 Servant Brighton


Sentences

Including relationships and ages. Using "included". Oxford comma:

The household included Frederick Pavey 48, wife Eliza Pavey 47, daughter Alice Pavey 21, son Alfred Pavey 19, daughter Jane Pavey 24, granddaughter Beatrice Pavey 17, granddaughter Kate Pavey 4, grandson Fredk. Pavey 1, visitor Ellen Cook 39, and visitor Annie Wilkins 15.

Not including relationships. Using "enumerated". No oxford comma.

The household was enumerated as Frederick Pavey 48, Eliza Pavey 47, Alice Pavey 21, Alfred Pavey 19, Jane Pavey 24, Beatrice Pavey 17, Kate Pavey 4, Fredk. Pavey 1, Ellen Cook 39 and Annie Wilkins 15.

Not including relationships or ages. Using "consisted of". No "and".

The household consisted of Frederick Pavey, Eliza Pavey, Alice Pavey, Alfred Pavey, Jane Pavey, Beatrice Pavey, Kate Pavey, Fredk. Pavey, Ellen Cook, Annie Wilkins.

No preamble:

Frederick Pavey, Eliza Pavey, Alice Pavey, Alfred Pavey, Jane Pavey, Beatrice Pavey, Kate Pavey, Fredk. Pavey, Ellen Cook, Annie Wilkins.

Limiting the number of rows in large households

Sometimes there are a large number of people in a household. For institutions like schools or prisons it can be in the hundreds. Typically we do not want to create a table with that many people in it. So Sourcer has options to limit the maximum number of rows in the table.

Sourcer options for max size of tables

For example this record has 21 entries and is for a house with a schoolmaster and his family plus a lot of school pupils who are boarders:

Name Relation Status Sex Age Occupation Birth Place
Edward G Williams Head M 39 Crewkerne, Somerset, England
... ... ... ... ... ... ...
Donovan R Williams Son M 1 Winchester, Hampshire, England
Arthur Eli Pavey Boarder M 15 London, Middlesex, England
Sidney J Thomas Boarder M 14 London, Middlesex, England
... ... ... ... ... ... ...

Custom styles

These require some manual editing of the table after generating.

Show additional data

In the 1911 census of England and Wales there are additional fields for married women giving the number of years of the current marriage and the number of children born alive and how many have died. This could be added to the table in a variety of ways.

With borders:[1]

Name Relation Status Sex Age Occupation Birth Place
Harry Alfred Pavey Head Married M 58 Picture Frame Maker Plymouth, Devon, England
Amelia Elizabeth Pavey Wife Married F 60 London, United Kingdom
Completed years of current marriage: 40, Children born alive: 11, still living: 7, died: 4
Harry Alfred Pavey Son Single M 33 Ships Steward London, Kent, England
Ralph Edgar Pavey Son Single M 19 Wharehouse Assistant London, Kent, England

Or alternatively:[2]

1911 Census of England: 110 Highgate Hill, Upper Holloway N, Islington, London, England
Name Relation Status Sex Age Occupation Birth Place
Harry Alfred Pavey Head Married M 58 Picture Frame Maker Plymouth, Devon, England
Amelia Elizabeth Pavey Wife Married F 60 London, United Kingdom
40 years married, 11 children born, 4 died, 7 living
Harry Alfred Pavey Son Single M 33 Ships Steward London, Kent, England
Ralph Edgar Pavey Son Single M 19 Wharehouse Assistant London, Kent, England

Or even with sub headings:[3]

Name Relation Status Sex Age Occupation Birth Place
Harry Alfred Pavey Head Married M 58 Picture Frame Maker Plymouth, Devon, England
Amelia Elizabeth Pavey Wife Married F 60 London, United Kingdom
Years married Children born Still living Died
40 11 7 4
Harry Alfred Pavey Son Single M 33 Ships Steward London, Kent, England
Ralph Edgar Pavey Son Single M 19 Wharehouse Assistant London, Kent, England


Show multiple households

Sometimes there are several members of the same family at the same address but recorded as separate households. The tables can be combined with a blank row between the households which creates a double line, like this:

In the 1871 census George (age 63) and his wife Maria (53) and her mother plus their youngest son Edwin Thomas were living at 40 Dale Road, Kentish Town. They were at the same address as the family of Maria's daughter Georgiana Maria Hall who was currently married to John Hill.[4]

Name Relation Status Sex Age Occupation Birth Place
George Chantler Lodger Married M 63 Piano Forte Hammer Carver Sussex England
Maria Chantler Wife Married F 53 Surrey England
Ann Hall Mother Widow F 84 Norfolk England
Thomas Chantler Son M 20 Kent England
John Hill Head Married M 33 Engine Fireman Worcestershire England
Maria Hill Wife Married F 33 Surrey England
John Hill Son M 13 Kent England
Richard Hill Son M 9 St Pancras, Middlesex, England
Rosa I Hill Daughter F 7/12 St Pancras, Middlesex, England


Details of the markup used

The footnotes below show the markup used for the custom examples.

  1. ↑ 1911 census with marriage details (borders): 
    {| border="1" cellpadding="4" width="100%"
|- bgcolor=#E1F0B4
| Name || Relation || Status || Sex || Age || Occupation || Birth Place
|-
| Harry Alfred Pavey || Head || Married || M || 58 || Picture Frame Maker || Plymouth, Devon, England
|-
| '''Amelia Elizabeth Pavey''' || '''Wife''' || '''Married''' || '''F''' || '''60''' ||  || '''London, United Kingdom'''
|-
| colspan="7" align="center" | '''Completed years of current marriage: 40, Children born alive: 11, still living: 7, died: 4'''
|-
| Harry Alfred Pavey || Son || Single || M || 33 || Ships Steward || London, Kent, England
|-
| Ralph Edgar Pavey || Son || Single || M || 19 || Wharehouse Assistant || London, Kent, England
|}
  2. ↑ 1911 census with marriage details (no borders): 
    {| cellpadding="4"
|+ 1911 Census of England: 110 Highgate Hill, Upper Holloway N, Islington, London, England
! Name || Relation || Status || Sex || Age || Occupation || Birth Place
|-
| Harry Alfred Pavey || Head || Married || M || 58 || Picture Frame Maker || Plymouth, Devon, England
|-
| '''Amelia Elizabeth Pavey''' || '''Wife''' || '''Married''' || '''F''' || '''60''' ||  || '''London, United Kingdom'''
|-
| colspan="7" align="center" | '''40 years married, 11 children born, 4 died, 7 living'''
|-
| Harry Alfred Pavey || Son || Single || M || 33 || Ships Steward || London, Kent, England
|-
| Ralph Edgar Pavey || Son || Single || M || 19 || Wharehouse Assistant || London, Kent, England
|}
  3. ↑ 1911 census with marriage details (sub headings): 
    {| border="1" cellpadding="4" width="100%"
|- bgcolor=#E1F0B4
| Name || Relation || Status || Sex || Age || Occupation || Birth Place
|-
| Harry Alfred Pavey || Head || Married || M || 58 || Picture Frame Maker || Plymouth, Devon, England
|-
| '''Amelia Elizabeth Pavey''' || '''Wife''' || '''Married''' || '''F''' || '''60''' ||  || '''London, United Kingdom'''
|-
| colspan="2" | || ''Years married'' || colspan="2" | ''Children born'' || ''Still living'' || ''Died''
|-
| colspan="2" | || '''40''' || colspan="2" | '''11''' || '''7''' || '''4'''
|-
| Harry Alfred Pavey || Son || Single || M || 33 || Ships Steward || London, Kent, England
|-
| Ralph Edgar Pavey || Son || Single || M || 19 || Wharehouse Assistant || London, Kent, England
|}
  4. ↑ Multiple households: 
    {| border="1" cellpadding="4" width="100%"
|- bgcolor=#E1F0B4
| Name || Relation || Status || Sex || Age || Occupation || Birth Place
|-
| '''George Chantler''' || '''Lodger''' || '''Married''' || '''M''' || '''63''' || '''Piano Forte : Hammer Carver''' || '''Sussex England'''
|-
| Maria Chantler || Wife || Married || F || 53 ||  || Surrey England
|-
| Ann Hall || Mother || Widow || F || 84 ||  || Norfolk England
|-
| Thomas Chantler || Son ||  || M || 20 ||  || Kent England
|-
|  || ||  || || ||  || 
|-
| John Hill || Head || Married || M || 33 || Engine Fireman || Worcestershire England
|-
| Maria Hill || Wife || Married || F || 33 ||  || Surrey England
|-
| John Hill || Son ||  || M || 13 ||  || Kent England
|-
| Richard Hill || Son ||  || M || 9 ||  || St Pancras, Middlesex, England
|-
| Rosa I Hill || Daughter ||  || F || 7/12 ||  || St Pancras, Middlesex, England
|}




Collaboration
  • Login to edit this profile and add images.
  • Private Messages: Send a private message to the Profile Manager. (Best when privacy is an issue.)
  • Public Comments: Login to post. (Best for messages specifically directed to those editing this profile. Limit 20 per day.)


Comments

Leave a message for others who see this profile.
There are no comments yet.
Login to post a comment.