names

54 rows where place_id = 593161

✎ 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
3610746 1871026 1871026 defendant Saward John husbandman 593161 593161 Saward, John, of Felsted, husbandman 0
3629593 1904112 1904112 plaintiff Danyell John   593161 593161 Danyell, John, of Felsted 0
3629597 1904113 1904113 plaintiff Danyell John   593161 593161 Danyell, John, of Felsted 0
3661654 1913922 1913922 defendant Brygge Roger husbandman 593161 593161 Brygge, Roger, of Felsted, husbandman 0
3662003 1914047 1914047 defendant Cole Peter laborer 593161 593161 Cole, Peter, of Felsted, laborer 1
3706935 1928454 1928454 defendant Stace John carpenter 593161 593161 Stace, John, of Felsted, carpenter 1
3708665 1929010 1929010 defendant Holmested John yeoman 593161 593161 Holmested, John, of Felsted, yeoman 0
3710796 1929692 1929692 defendant Wystok or Wyscok Robert husbandman 593161 593161 Wystok or Wyscok, Robert, of Felsted, husbandman 3
3907576 1992824 1992824 defendant Drane Thomas husbandman 593161 593161 Drane, Thomas, of Felsted, husbandman 0
3962954 2011641 2011641 plaintiff Wood Margery widow 593161 593161 Wood, Margery, of Felsted, widow 0
3966613 2012959 2012959 plaintiff Bredge Thomas, senior (legal representative) 593161 593161 Bredge, Thomas, senior, of Felsted, yeoman, executors of 0
3972043 2014779 2014779 defendant Clarke John husbandman 593161 593161 Clarke, John, of Felsted, husbandman 0
3981614 2018182 2018182 plaintiff Reede John yeoman 593161 593161 Reede, John, of Felsted, yeoman 0
4038757 2038487 2038487 defendant Strangman William esq 593161 593161 together with Strangman, William, of Felsted, esq 1
4038759 2038488 2038488 defendant Strangman William esq 593161 593161 Strangman, William, of Felsted, esq 0
4051552 2042972 2042972 plaintiff Wiseman John (legal representative) 593161 593161 Wiseman, John, of Felsted, esq, executors of 0
4052367 2043268 2043268 plaintiff Wyseman John (legal representative) 593161 593161 Wyseman, John, of Felsted, esq, executors of 0
4222138 2103234 2103234 defendant Dowtye William yeoman 593161 593161 Dowtye, William, of Felsted, yeoman 2
4235170 2107861 2107861 defendant Perrye Thomas husbandman 593161 593161 Perrye, Thomas, of Felsted, husbandman 0
4505454 2202234 2202234 defendant Frenssh Walter   593161 593161 Frenssh, Walter, of Felsted, senior 3
4511347 2203994 2203994 defendant Frenssh Richard   593161 593161 Frenssh, Richard, of Felsted 1
4571429 2222649 2222649 defendant tyler John   593161 593161 tyler, John, of Felsted 6
4623818 2238425 2238425 defendant Archer John   593161 593161 Archer, John, of Felsted 0
4627012 2239398 2239398 defendant Archer John   593161 593161 Archer, John, of Felsted 0
4643702 2244258 2244258 defendant Kent John   593161 593161 Kent, John, of Felsted 1
4668635 2255902 2255902 defendant Oxeney Richard yeoman 593161 593161 Oxeney, Richard, of Felsted, yeoman 0
4668636 2255902 2255902 defendant (illegible) William laborer 593161 593161 -----, William, of Felsted, laborer 1
4735070 2276117 2276117 defendant Whelere John   593161 593161 Whelere, John, of Felsted, wheel wright 0
4763371 2284531 2284531 defendant Kent John yeoman 593161 593161 Kent, John, of Felsted, yeoman 0
4926820 2334813 2334813 defendant Parker Richard gent 593161 593161 Parker, Richard, of Felsted, gent 0
5005261 2358437 2358437 defendant Haukyn William husbandman 593161 593161 Haukyn, William, of Felsted, husbandman 0
5214454 2419961 2419961 defendant Roberd John, senior husbandman 593161 593161 Roberd, John, senior, of Felsted, husbandman 0
5214466 2419963 2419963 defendant Roberd John, junior laborer 593161 593161 Roberd, John, junior, of Felsted, laborer 0
5276266 2438127 2438127 defendant Bury John gent 593161 593161 Bury, John, of Felsted, gent 0
5295645 2443716 2443716 defendant Bury John gent 593161 593161 Bury, John, of Felsted, gent 0
5343777 2458240 2458240 defendant Waltham John yeoman 593161 593161 Waltham, John, of Felsted, yeoman 0
5343779 2458241 2458241 defendant Waltham John yeoman 593161 593161 Waltham, John, of Felsted, yeoman 0
5376045 2468100 2468100 defendant Broke Robert husbandman 593161 593161 Broke, Robert, of Felsted, husbandman 3
5406889 2477034 2477034 defendant Wode John husbandman 593161 593161 (Wode, John, of Felsted, husbandman 1
5486974 2501000 2501000 defendant Bery Robert gent 593161 593161 Bery, Robert, of Felsted, gent 1
5545202 2518597 2518597 defendant Wode John smith 593161 593161 Wode, John, of Felsted, smith 4
5583359 2529868 2529868 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 1
5583735 2529988 2529988 defendant Mershe Thomas butcher 593161 593161 Mershe, Thomas, of Felsted, butcher 0
5583737 2529988 2529988 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 2
5583739 2529989 2529989 defendant Mersshe Thomas butcher 593161 593161 Mersshe, Thomas, of Felsted, butcher 0
5583741 2529989 2529989 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 2
5583743 2529990 2529990 defendant Mersshe Thomas butcher 593161 593161 Mersshe, Thomas, of Felsted, butcher 0
5583745 2529990 2529990 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 2
5583747 2529991 2529991 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 0
5583748 2529991 2529991 defendant Mershe Thomas butcher 593161 593161 Mershe, Thomas, of Felsted, butcher 1
5583751 2529992 2529992 defendant Olmested Richard yeoman 593161 593161 Olmested, Richard, of Felsted, yeoman 0
5583752 2529992 2529992 defendant Mershe Thomas butcher 593161 593161 Mershe, Thomas, of Felsted, butcher 1
5605863 2536725 2536725 defendant Popley Anne widow 593161 593161 Popley, Anne, of Felsted, widow 2
5621316 2550555 2550555 defendant Ryly John   593161 593161 Ryly, John, of Felsted 1

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