names

42 rows where place_id = 634732

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3820961 1964450 1964450 defendant Vaughan George vintner 634732 634732 Vaughan, George, of St Katherine by the Tower of London, vintner 0
3943206 2004746 2004746 plaintiff Alee William (legal representative) 634732 634732 Alee, William, of St Katherine by the Tower of London, gunner, executor of 0
3944353 2005123 2005123 defendant Hemmyng Robert yeoman 634732 634732 Hemmyng, Robert, of St Katherine by the Tower of London, yeoman 0
3944354 2005123 2005123 defendant Hemmyng Richard laborer 634732 634732 Hemmyng, Richard, of St Katherine by the Tower of London, laborer 1
3944355 2005123 2005123 defendant Starky John laborer 634732 634732 Starky, John, of St Katherine by the Tower of London, laborer 2
3944358 2005124 2005124 defendant Hemmyng Robert yeoman 634732 634732 Hemmyng, Robert, of St Katherine by the Tower of London, yeoman 1
3944359 2005124 2005124 defendant Starky John laborer 634732 634732 Starky, John, of St Katherine by the Tower of London, laborer 2
3948207 2006436 2006436 plaintiff Crokey Robert merchant 634732 634732 Crokey, Robert, of St Katherine by the Tower of London, merchant 0
3948216 2006439 2006439 plaintiff Crokhey Robert merchant 634732 634732 Crokhey, Robert, of St Katherine by the Tower of London, merchant 0
3949027 2006725 2006725 defendant Dey Peter mercer 634732 634732 Dey, Peter, of St Katherine by the Tower of London, mercer 2
3960009 2010600 2010600 defendant Davie Robert yeoman 634732 634732 Davie, Robert, of St Katherine by the Tower of London, yeoman 0
3962322 2011405 2011405 defendant Hemmyng Robert yeoman 634732 634732 Hemmyng, Robert, of St Katherine by the Tower of London, yeoman 1
3962323 2011405 2011405 defendant Starky John laborer 634732 634732 Starky, John, of St Katherine by the Tower of London, laborer 2
3989078 2020837 2020837 defendant Woodwell Richard hatmaker 634732 634732 Woodwell, Richard, of St Katherine by the Tower of London, hatmaker 0
3995666 2023193 2023193 plaintiff Crockhay Robert   634732 634732 Crockhay, Robert, of St Katherine by the Tower of London 0
4014842 2030022 2030022 defendant Barton John yeoman 634732 634732 Barton, John, of St Katherine by the Tower of London, yeoman 0
4016453 2030589 2030589 defendant Wood Alice widow 634732 634732 Wood, Alice, of St Katherine by the Tower of London, widow 1
4016455 2030589 2030589 defendant Stanley Alice widow 634732 634732 Stanley, Alice, of St Katherine by the Tower of London, widow 3
4018864 2031477 2031477 defendant Bull Stephen   634732 634732 Bull, Stephen, of St Katherine by the Tower of London, servant of the Queen 0
4048581 2041942 2041942 plaintiff Thomas William   634732 634732 Thomas, William, of St Katherine by the Tower of London, groom and servant of the Queen 0
4067494 2048686 2048686 defendant Horsse alias Justice John   634732 634732 Horsse alias Justice, John, of St Katherine by the Tower of London, hat maker 0
4112973 2064909 2064909 defendant Pyburne Marmaduke   634732 634732 Pyburne, Marmaduke, of St Katherine by the Tower of London, felt maker 0
4112974 2064909 2064909 defendant Newner John   634732 634732 Newner, John, of St Katherine by the Tower of London, felt maker 1
4114498 2065472 2065472 defendant Sendall Alice widow 634732 634732 Sendall, Alice, of St Katherine by the Tower of London, widow 1
4139455 2074472 2074472 defendant Bourne John baker 634732 634732 Bourne, John, of St Katherine by the Tower of London, baker 0
4141046 2075027 2075027 defendant Wylson Thomas beer brewer 634732 634732 Wylson, Thomas, of St Katherine by the Tower of London, beer brewer 3
4159703 2081461 2081461 defendant Borman Robert   634732 634732 Borman, Robert, of St Katherine by the Tower of London, hat maker 3
4160402 2081713 2081713 defendant Elmden Thomas yeoman 634732 634732 Elmden, Thomas, of St Katherine by the Tower of London, yeoman 0
4199940 2095528 2095528 defendant Williamson or Williams Thomas   634732 634732 Williamson or Williams, Thomas, of St Katherine by the Tower of London, felt maker, seneschal of St Katherine by the Tower of London ex parte 0
4253212 2114071 2114071 defendant Webbe William ironmonger 634732 634732 Webbe, William, of St Katherine by the Tower of London, chandler, ironmonger 0
4259952 2116299 2116299 defendant Bowreman Robert   634732 634732 Bowreman, Robert, of St Katherine by the Tower of London, felt maker 0
4266720 2118512 2118512 defendant Cowper William   634732 634732 Cowper, William, of St Katherine by the Tower of London, baker, administrators of 0
4266721 2118512 2118512 defendant Mackerethe Edwin baker 634732 634732 (Mackerethe, Edwin, of St Katherine by the Tower of London, baker 1
4279762 2122840 2122840 defendant Robert Thomas   634732 634732 Robert, Thomas, of St Katherine by the Tower of London, felt maker 0
4292791 2127484 2127484 defendant Lambe Thomas   634732 634732 Lambe, Thomas, of St Katherine by the Tower of London, felt maker 0
4300473 2130263 2130263 plaintiff Watson George butcher 634732 634732 Watson, George, of St Katherine by the Tower of London, butcher 0
4328934 2139990 2139990 defendant Johnes William chapman 634732 634732 Johnes, William, of St Katherine by the Tower of London, chapman 1
4363809 2152116 2152116 defendant Walbanck Thomas butcher 634732 634732 Walbanck, Thomas, of St Katherine by the Tower of London, butcher 1
4388550 2160812 2160812 defendant Hytchens Thomas baker 634732 634732 Hytchens, Thomas, of St Katherine by the Tower of London, or of Topton, Staffs, baker 2
4388961 2160940 2160940 defendant Scultus Mary widow 634732 634732 Scultus, Mary, of St Katherine by the Tower of London, widow 1
4396124 2163276 2163276 defendant Miller John   634732 634732 Miller, John, of St Katherine by the Tower of London, gun maker 3
4404746 2166153 2166153 defendant Morgan Lewis   634732 634732 Morgan, Lewis, of St Katherine by the Tower of London 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);