names

52 rows where place_id = 661575

✎ 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
3961379 2011075 2011075 defendant Reade William yeoman 661575 661575 Reade, William, of Eaton, yeoman 0
3989408 2020951 2020951 plaintiff Barker John Master of Arts 661575 661575 Barker, John, of Eaton, Master of Arts 0
4039213 2038650 2038650 defendant Clerke John husbandman 661575 661575 Clerke, John, of Eaton, husbandman 0
4039214 2038650 2038650 defendant Palmer John tailor 661575 661575 together with Palmer, John, of Eaton, tailor 1
4039216 2038651 2038651 defendant Palmer John tailor 661575 661575 Palmer, John, of Eaton, tailor 0
4040789 2039198 2039198 defendant Cocke James, junior yeoman 661575 661575 Cocke, James, junior, of Eaton, yeoman 0
4040790 2039198 2039198 defendant Esquyer James yeoman 661575 661575 Esquyer, James, of Eaton, yeoman 1
4048179 2041787 2041787 defendant Symond Richard yeoman 661575 661575 Symond, Richard, of Eaton, yeoman 0
4057382 2045021 2045021 defendant Hamons Thomas   661575 661575 Hamons, Thomas, of Eaton, yeoman, his son 1
4064778 2047687 2047687 defendant Camell Edward yeoman 661575 661575 Camell, Edward, of Eaton, yeoman 0
4064781 2047688 2047688 defendant Caymell Edward yeoman 661575 661575 Caymell, Edward, of Eaton, yeoman 0
4064890 2047727 2047727 defendant Broughton Lancelot (legal representative) 661575 661575 Broughton, Lancelot, of Eaton, gent, executors of 1
4075270 2051460 2051460 defendant Davyes Thomas yeoman 661575 661575 Davyes, Thomas, of Eaton, or of Hackton, Herefs, yeoman 0
4078544 2052624 2052624 defendant Haberley Richard yeoman 661575 661575 Haberley, Richard, of Eaton, yeoman 1
4085664 2055145 2055145 defendant Fuller Richard yeoman 661575 661575 Fuller, Richard, of Eaton, yeoman 0
4090459 2056870 2056870 defendant Wigarne Richard yeoman 661575 661575 Wigarne, Richard, of Eaton, yeoman 0
4091993 2057431 2057431 defendant Candler William husbandman 661575 661575 Candler, William, of Eaton, husbandman 3
4097488 2059428 2059428 defendant Eaton Kenneric gent 661575 661575 (Eaton, Kenneric, of Eaton, gent 2
4097489 2059428 2059428 defendant Dodde William gent 661575 661575 Dodde, William, of Eaton, gent 3
4097490 2059428 2059428 defendant Mathewe John gent 661575 661575 Mathewe, John, of Eaton, gent 4
4101986 2061019 2061019 defendant Baker Thomas yeoman 661575 661575 Baker, Thomas, of Eaton, yeoman 0
4101987 2061019 2061019 defendant Porter John yeoman 661575 661575 Porter, John, of Eaton, yeoman 1
4113996 2065286 2065286 defendant Habberley Richard yeoman 661575 661575 Habberley, Richard, of Eaton, yeoman 2
4126220 2069669 2069669 defendant Kyppys Thomas yeoman 661575 661575 Kyppys, Thomas, of Eaton, yeoman 0
4133070 2072157 2072157 defendant Fuller Richard yeoman 661575 661575 Fuller, Richard, of Eaton, yeoman 0
4133071 2072157 2072157 defendant Fuller Henry yeoman 661575 661575 Fuller, Henry, of Eaton, yeoman 1
4152254 2078898 2078898 defendant Browne Robert weaver 661575 661575 Browne, Robert, of Eaton, weaver 3
4154401 2079630 2079630 defendant Hackelnett Thomas esq 661575 661575 Hackelnett, Thomas, of Eaton juxta Leominster, esq 0
4154403 2079631 2079631 defendant Hackett or Hackeluett Thomas esq 661575 661575 Hackett or Hackeluett, Thomas, of Eaton juxta Leonminster, esq 0
4161313 2082037 2082037 defendant Hyett Thomas gent 661575 661575 (Hyett, Thomas, of Eaton, gent 1
4173012 2086015 2086015 defendant Grynwoodde William husbandman 661575 661575 Grynwoodde, William, of Eaton, husbandman 1
4200448 2095714 2095714 defendant Weover William yeoman 661575 661575 Weover, William, of Eaton, yeoman 1
4215664 2100977 2100977 defendant Austen William husbandman 661575 661575 Austen, William, of Eaton, husbandman 0
4215665 2100977 2100977 defendant Austen Katherine widow 661575 661575 Austen, Katherine, of Eaton, widow 1
4216441 2101245 2101245 defendant Houlte Thomas husbandman 661575 661575 Houlte, Thomas, of Eaton, husbandman 0
4216442 2101245 2101245 defendant Jervis John husbandman 661575 661575 Jervis, John, of Eaton, husbandman 1
4218991 2102137 2102137 defendant Burre Richard husbandman 661575 661575 Burre, Richard, of Eaton, husbandman 0
4220116 2102536 2102536 defendant Baylye Edward yeoman 661575 661575 Baylye, Edward, of Eaton, yeoman 2
4225488 2104382 2104382 defendant Bootye Francis cooper 661575 661575 Bootye, Francis, of Eaton, cooper 1
4230772 2106261 2106261 defendant Baker Thomas husbandman 661575 661575 Baker, Thomas, of Eaton, husbandman 0
4231797 2106618 2106618 defendant Davis Thomas yeoman 661575 661575 Davis, Thomas, of Eaton, yeoman 0
4264369 2117727 2117727 defendant Hall Charles gent 661575 661575 Hall, Charles, of Eaton, or of Felling, Durham, gent 0
4271019 2119881 2119881 defendant Austen William husbandman 661575 661575 Austen, William, of Eaton, husbandman 2
4271659 2120104 2120104 defendant Baker Thomas yeoman 661575 661575 Baker, Thomas, of Eaton, yeoman 1
4302483 2130988 2130988 defendant Blacknall John yeoman 661575 661575 Blacknall, John, of Eaton, yeoman 0
4311942 2134312 2134312 defendant Blacknall John yeoman 661575 661575 Blacknall, John, of Eaton, yeoman 0
4344845 2145476 2145476 defendant Tudge William smith 661575 661575 Tudge, William, of Eaton, smith 0
4354840 2148913 2148913 defendant Crofte Alexander gent 661575 661575 Crofte, Alexander, of Eaton, Lempster, gent 3
4365350 2152671 2152671 defendant Hartell Richard yeoman 661575 661575 Hartell, Richard, of Eaton, yeoman 0
4370033 2154339 2154339 defendant Bullocke John yeoman 661575 661575 Bullocke, John, of Eaton, yeoman 0
4406245 2166654 2166654 defendant Wood Nicholas baker 661575 661575 Wood, Nicholas, of Eaton, baker 0
4761612 2283978 2283978 defendant Jonson Richard husbandman 661575 661575 Jonson, Richard, of Eaton, husbandman 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);