names

78 rows where place_id = 588029

✎ 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
3593140 1865481 1865481 defendant Haddon John yeoman 588029 588029 Haddon, John, of Westhale, yeoman 0
3604319 1869014 1869014 defendant Holbek Geoffrey husbandman 588029 588029 Holbek, Geoffrey, of Westhale, husbandman 1
3605435 1869366 1869366 defendant Caus Thomas gent 588029 588029 Caus, Thomas, of Westhale, gent 0
3690227 1923102 1923102 defendant Girlyng John husbandman 588029 588029 Girlyng, John, of Westhale, husbandman 1
3690232 1923104 1923104 defendant Gyrlyng John husbandman 588029 588029 Gyrlyng, John, of Westhale, husbandman 0
3705058 1927872 1927872 defendant Poley William gent 588029 588029 Poley, William, of Westhale, gent 0
3709797 1929379 1929379 defendant Gile Robert   588029 588029 Gile, Robert, of Westhale, husbandman, single man 0
3709799 1929380 1929380 defendant Gyle Robert husbandman 588029 588029 Gyle, Robert, of Westhale, husbandman 0
3755370 1943631 1943631 defendant Fyldhouse William clerk 588029 588029 Fyldhouse, William, of Westhale, clerk 0
3770610 1948491 1948491 defendant Forman Simon husbandman 588029 588029 Forman, Simon, of Westhale, husbandman 0
3773132 1949300 1949300 defendant Feldhouse William clerk 588029 588029 Feldhouse, William, of Westhale, clerk 0
3814378 1962411 1962411 defendant Wulward John husbandman 588029 588029 Wulward, John, of Westhale, husbandman 0
3815269 1962691 1962691 defendant Feltham William husbandman 588029 588029 Feltham, William, of Westhale, husbandman 0
3818262 1963625 1963625 defendant Barett William yeoman or gent 588029 588029 Barett, William, of Westhale, yeoman or gent 0
3841682 1970981 1970981 defendant Salhous John husbandman 588029 588029 Salhous, John, of Westhale, husbandman 0
3841683 1970981 1970981 defendant Benett Robert husbandman 588029 588029 Benett, Robert, of Westhale, husbandman 1
3841689 1970982 1970982 defendant Mychell Richard husbandman 588029 588029 Mychell, Richard, of Westhale, husbandman 1
3841690 1970982 1970982 defendant Adams John husbandman 588029 588029 Adams, John, of Westhale, husbandman 2
3841691 1970983 1970983 plaintiff Bohun Nicholas esq 588029 588029 Bohun, Nicholas, of Westhale, esq 0
3861272 1977239 1977239 defendant Boham Nicholas gent 588029 588029 Boham, Nicholas, of Westhale, gent 1
3866134 1978903 1978903 defendant Bohun Nicholas gent 588029 588029 Bohun, Nicholas, of Westhale, gent 0
3866138 1978904 1978904 defendant Bohun Nicholas gent 588029 588029 Bohun, Nicholas, of Westhale, gent 0
3888702 1986478 1986478 defendant Bece Nicholas husbandman 588029 588029 Bece, Nicholas, of Westhale, husbandman 1
3913204 1994748 1994748 plaintiff Barrett William, senior gent 588029 588029 Barrett, William, senior, of Westhale, gent 0
3914861 1995319 1995319 defendant Calver David husbandman 588029 588029 Calver, David, of Westhale, husbandman 0
3915595 1995584 1995584 defendant Parce Edward husbandman 588029 588029 Parce, Edward, of Westhale, husbandman 1
3922515 1997845 1997845 defendant Bohun Nicholas gent 588029 588029 Bohun, Nicholas, of Westhale, gent 0
3922516 1997845 1997845 defendant Harman Margaret widow 588029 588029 Harman, Margaret, of Westhale, widow 1
3922517 1997845 1997845 defendant Cryspe Thomas   588029 588029 Cryspe, Thomas, of Westhale, wheel wright 2
3924405 1998474 1998474 defendant Bohun Nicholas esq 588029 588029 Bohun, Nicholas, of Westhale, esq 0
3946198 2005749 2005749 plaintiff Burghwarde Ralph   588029 588029 Burghwarde, Ralph, of Westhale, administrators of 0
3958678 2010109 2010109 defendant Holbeck Thomas husbandman 588029 588029 Holbeck, Thomas, of Westhale, yeoman, or of Gyselham, husbandman 0
4476524 2193323 2193323 defendant Howes John   588029 588029 Howes, John, of Westhale 0
4476525 2193323 2193323 defendant Graundon Thomas   588029 588029 Graundon, Thomas, of Westhale 1
4479728 2194320 2194320 defendant Andrewe Thomas   588029 588029 Andrewe, Thomas, of Westhale 0
4548925 2215595 2215595 defendant Love Henry   588029 588029 Love, Henry, of Westhale 2
4548930 2215596 2215596 defendant Love Henry   588029 588029 Love, Henry, of Westhale 2
4724892 2273079 2273079 defendant Savage William husbandman 588029 588029 Savage, William, of Westhale, husbandman 0
4754132 2281671 2281671 defendant Reve John smith 588029 588029 Reve, John, of Westhale, smith 0
4768262 2286043 2286043 defendant Smyth John yeoman 588029 588029 Smyth, John, of Westhale, yeoman 3
4958512 2344515 2344515 defendant Thoureld William husbandman 588029 588029 Thoureld, William, of Westhale, husbandman 2
4994893 2355324 2355324 defendant Frenssh alias Lane William husbandman 588029 588029 Frenssh alias Lane, William, of Westhale, husbandman 2
5003616 2357949 2357949 defendant Martyn Walter clerk 588029 588029 Martyn, Walter, of Westhale, clerk 0
5003617 2357949 2357949 defendant Ferman John laborer 588029 588029 Ferman, John, of Westhale, laborer 1
5003618 2357949 2357949 defendant Ferman Walter laborer 588029 588029 Ferman, Walter, of Westhale, laborer 2
5012242 2360430 2360430 defendant Phy_on Stephen husbandman 588029 588029 Phy_on, Stephen, of Westhale, husbandman 1
5018311 2362241 2362241 plaintiff Cone or Cove Thomas   588029 588029 Cone or Cove, Thomas, of Westhale 0
5018313 2362241 2362241 plaintiff Barwer Richard   588029 588029 Barwer, Richard, of Westhale 2
5038473 2368145 2368145 defendant Benet John yeoman 588029 588029 Benet, John, of Westhale, yeoman 0
5093470 2384491 2384491 plaintiff Croft or Croftys Thomas esq 588029 588029 Croft or Croftys, Thomas, of Westhale, esq 2
5100796 2386652 2386652 defendant Lote Thomas husbandman 588029 588029 Lote, Thomas, of Westhale, husbandman 17
5125432 2393922 2393922 defendant Love John husbandman 588029 588029 Love, John, of Westhale, husbandman 0
5133121 2396170 2396170 defendant Benet John yeoman 588029 588029 Benet, John, of Westhale, yeoman 1
5134257 2396515 2396515 defendant Lece Thomas husbandman 588029 588029 Lece, Thomas, of Westhale, husbandman 2
5134263 2396516 2396516 defendant Lece Thomas husbandman 588029 588029 Lece, Thomas, of Westhale, husbandman 2
5144064 2399412 2399412 defendant Lone or Love John husbandman 588029 588029 Lone or Love, John, of Westhale, husbandman 0
5144066 2399413 2399413 defendant Love John husbandman 588029 588029 Love, John, of Westhale, husbandman 0
5147475 2400408 2400408 defendant Keybll John thatcher 588029 588029 Keybll, John, of Westhale, thatcher 2
5147480 2400409 2400409 defendant Keybll John thatcher 588029 588029 Keybll, John, of Westhale, thatcher 2
5152936 2401998 2401998 defendant Benet John yeoman 588029 588029 Benet, John, of Westhale, yeoman 1
5154170 2402377 2402377 defendant Hervy John yeoman 588029 588029 Hervy, John, of Westhale, yeoman 1
5154171 2402377 2402377 defendant Lete Thomas husbandman 588029 588029 Lete, Thomas, of Westhale, husbandman 2
5170514 2407101 2407101 defendant Benet John yeoman 588029 588029 Benet, John, of Westhale, yeoman 1
5171323 2407339 2407339 defendant Hervy John yeoman 588029 588029 Hervy, John, of Westhale, yeoman 1
5171324 2407339 2407339 defendant Lece Thomas husbandman 588029 588029 Lece, Thomas, of Westhale, husbandman 2
5239673 2427190 2427190 defendant Benet John yeoman 588029 588029 Benet, John, of Westhale, yeoman 2
5304287 2446286 2446286 defendant Tayllour Geoffrey yeoman 588029 588029 Tayllour, Geoffrey, of Westhale, yeoman 1
5323475 2452100 2452100 defendant Seman James thatcher 588029 588029 Seman, James, of Westhale, thatcher 2
5340744 2457304 2457304 defendant Cone or Cove Robert carpenter 588029 588029 Cone or Cove, Robert, of Westhale, carpenter 3
5347032 2459228 2459228 defendant Kelyat Robert   588029 588029 Kelyat, Robert, of Westhale, court holder 0
5349413 2459950 2459950 defendant Bryghtyeve John gent 588029 588029 Bryghtyeve, John, of Westhale, gent 0
5376561 2468269 2468269 defendant Seman James husbandman 588029 588029 Seman, James, of Westhale, husbandman 0
5402853 2475895 2475895 defendant Taillour Geoffrey husbandman 588029 588029 Taillour, Geoffrey, of Westhale, husbandman 0
5402854 2475895 2475895 defendant Taillour Thomas husbandman 588029 588029 Taillour, Thomas, of Westhale, husbandman 1
5425132 2482479 2482479 defendant Bryghtyove John gent 588029 588029 Bryghtyove, John, of Westhale, gent 0
5540089 2517024 2517024 defendant Payne Thomas yeoman 588029 588029 Payne, Thomas, of Westhale, yeoman 2
5540095 2517025 2517025 defendant Payne Thomas yeoman 588029 588029 Payne, Thomas, of Westhale, yeoman 2
5558374 2522400 2522400 defendant Cause Thomas gent 588029 588029 Cause, Thomas, of Westhale, gent 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);