names

62 rows where place_id = 589358

✎ 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
3597364 1866796 1866796 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
3597366 1866797 1866797 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
3600253 1867726 1867726 defendant Hastelyn Richard yeoman 589358 589358 Hastelyn, Richard, of Crayford, Kent, yeoman 1
3723406 1933587 1933587 defendant Jobson Richard smith 589358 589358 Jobson, Richard, of Crayford, Kent, smith 5
3815548 1962778 1962778 defendant Hallam John smith 589358 589358 Hallam, John, of Crayford, Kent, smith 0
3835563 1969061 1969061 defendant Harman William esq 589358 589358 Harman, William, of Crayford, Kent, esq 0
3901771 1990815 1990815 defendant Goodwyn John gent 589358 589358 Goodwyn, John, of Crayford, Kent, gent 0
3915645 1995603 1995603 defendant Sewer William yeoman 589358 589358 Sewer, William, of Crayford, Kent, yeoman 0
3933873 2001625 2001625 plaintiff Hareman Thomas esq 589358 589358 Hareman, Thomas, of Crayford, Kent, esq 0
3939237 2003426 2003426 defendant Lynton Bartholomew gent 589358 589358 Lynton, Bartholomew, of Crayford, Kent, gent 1
4020162 2031933 2031933 defendant Rawlyns William yeoman 589358 589358 Rawlyns, William, of Crayford, Kent, yeoman 2
4056854 2044832 2044832 defendant Harman Avacius gent 589358 589358 Harman, Avacius, of Crayford, Kent, gent 2
4066171 2048193 2048193 defendant Harman Abacuk gent 589358 589358 Harman, Abacuk, of Crayford, Kent, gent 0
4088900 2056334 2056334 defendant Harman Abacuck gent 589358 589358 Harman, Abacuck, of Crayford, Kent, gent 0
4124254 2068965 2068965 defendant Pers Francis yeoman 589358 589358 Pers, Francis, of Crayford, Kent, yeoman 0
4134866 2072790 2072790 defendant Pers Francis yeoman 589358 589358 Pers, Francis, of Crayford, Kent, yeoman 0
4158651 2081100 2081100 defendant Harman Abacuck gent 589358 589358 Harman, Abacuck, of Crayford, Kent, gent 1
4194149 2093505 2093505 defendant Harman Abacuc esq 589358 589358 Harman, Abacuc, of Crayford, Kent, esq 0
4251211 2113381 2113381 defendant Harman Abacuck gent 589358 589358 Harman, Abacuck, of Crayford, Kent, gent 1
4292788 2127483 2127483 defendant Martyn John gent 589358 589358 Martyn, John, of Crayford, Kent, gent 0
4348130 2146593 2146593 defendant Piers Francis yeoman 589358 589358 Piers, Francis, of Crayford, Kent, yeoman 0
4348314 2146662 2146662 defendant Martyn John gent 589358 589358 Martyn, John, of Crayford, Kent, gent 0
4395285 2163002 2163002 defendant Pers Francis yeoman 589358 589358 Pers, Francis, of Crayford, Kent, yeoman 2
4400204 2164659 2164659 defendant Martyn John gent 589358 589358 Martyn, John, of Crayford, Kent, gent 0
4827883 2304776 2304776 defendant Kerby William gent 589358 589358 Kerby, William, of Crayford, Kent, gent 0
4834250 2306722 2306722 defendant Kerby William gent 589358 589358 Kerby, William, of Crayford, Kent, gent 0
4884434 2322032 2322032 defendant Bedenden Thomas yeoman 589358 589358 Bedenden, Thomas, of Crayford, Kent, yeoman 2
5054049 2372803 2372803 defendant Michell John baker 589358 589358 Michell, John, of Crayford, Kent, baker 3
5212936 2419522 2419522 defendant Elham Henry gent 589358 589358 Elham, Henry, of Crayford, Kent, gent 0
5223476 2422558 2422558 defendant Heuere or Henere Thomas gent 589358 589358 Heuere or Henere, Thomas, of Crayford, Kent, gent 0
5224244 2422763 2422763 defendant Bygges Thomas yeoman 589358 589358 Bygges, Thomas, of Crayford, Kent, yeoman 0
5224249 2422764 2422764 defendant Bygges Thomas yeoman 589358 589358 together with Bygges, Thomas, of Crayford, Kent, yeoman 1
5244296 2428517 2428517 defendant Bugge Thomas yeoman 589358 589358 Bugge, Thomas, of Crayford, Kent, yeoman 1
5292581 2442825 2442825 defendant Hart John, senior husbandman 589358 589358 Hart, John, senior, of Crayford, Kent, husbandman 4
5297623 2444309 2444309 defendant Bokelly Nicholas gent & crown valet for King Henry VI 589358 589358 Bokelly, Nicholas, of Crayford, Kent, gent & crown valet for King Henry VI 2
5323117 2451998 2451998 defendant Bulbek Richard husbandman 589358 589358 Bulbek, Richard, of Crayford, Kent, husbandman 1
5323272 2452042 2452042 defendant Hert John husbandman 589358 589358 Hert, John, of Crayford, Kent, husbandman 0
5340375 2457194 2457194 defendant Bulbek Richard, junior husbandman 589358 589358 Bulbek, Richard, junior, of Crayford, Kent, husbandman 0
5357862 2462527 2462527 defendant Tokke John clothman 589358 589358 Tokke, John, of Crayford, Kent, clothman 0
5357865 2462528 2462528 defendant Tokke John clothman 589358 589358 Tokke, John, of Crayford, Kent, clothman 0
5471711 2496489 2496489 defendant Nokes Geoffrey husbandman 589358 589358 Nokes, Geoffrey, of Crayford, Kent, husbandman 0
5497570 2504215 2504215 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
5500563 2505105 2505105 defendant Morton Cecilia widow 589358 589358 Morton, Cecilia, of Crayford, Kent, widow 4
5512366 2508729 2508729 defendant Rychewode Christopher yeoman 589358 589358 Rychewode, Christopher, of Crayford, Kent, yeoman 0
5527730 2513253 2513253 defendant Hastelyn Alice widow 589358 589358 Hastelyn, Alice, of Crayford, Kent, widow 0
5527736 2513254 2513254 defendant Bulbek Richard husbandman 589358 589358 Bulbek, Richard, of Crayford, Kent, husbandman 0
5527741 2513255 2513255 defendant Bulbek William husbandman 589358 589358 Bulbek, William, of Crayford, Kent, husbandman 0
5527757 2513258 2513258 defendant Ketylwell William husbandman 589358 589358 Ketylwell, William, of Crayford, Kent, husbandman 1
5527762 2513259 2513259 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
5527766 2513260 2513260 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
5527781 2513262 2513262 defendant Bulbeke William husbandman 589358 589358 Bulbeke, William, of Crayford, Kent, husbandman 1
5527786 2513263 2513263 defendant Tyse Mathew beer brewer 589358 589358 Tyse, Mathew, of Crayford, Kent, beer brewer 0
5527798 2513265 2513265 defendant Hastelyn Alice widow 589358 589358 Hastelyn, Alice, of Crayford, Kent, widow 0
5527808 2513267 2513267 defendant Tyse Mathew beer brewer 589358 589358 Tyse, Mathew, of Crayford, Kent, beer brewer 0
5530085 2513917 2513917 defendant Morton John gent 589358 589358 Morton, John, of Crayford, Kent, gent 1
5547269 2519214 2519214 defendant Jubbes Joan widow 589358 589358 Jubbes, Joan, of Crayford, Kent, widow 1
5565240 2524419 2524419 defendant Dawson Henry yeoman 589358 589358 Dawson, Henry, of Crayford, Kent, yeoman 0
5569312 2525583 2525583 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 1
5577013 2527854 2527854 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
5583138 2529799 2529799 defendant Marsshall John gent 589358 589358 Marsshall, John, of Crayford, Kent, gent 1
5600055 2534900 2534900 defendant Lane Thomas tanner 589358 589358 Lane, Thomas, of Crayford, Kent, tanner 0
5609093 2537750 2537750 defendant Ponynges Edward clerk & parson 589358 589358 Ponynges, Edward, of Crayford, Kent, clerk & parson 0

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);