names

30 rows where place_id = 600777

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642465 1908087 1908087 defendant Dade Roger tanner 600777 600777 Dade, Roger, of Weybred, Suff, tanner 0
3673231 1917642 1917642 defendant Algour Thomas   600777 600777 Algour, Thomas, of Weybred, Suff, wheelwright 1
3686771 1922017 1922017 defendant Algor Thomas   600777 600777 Algor, Thomas, of Weybred, Suff, wheelwright 0
3738161 1938149 1938149 defendant Dade Roger tanner 600777 600777 Dade, Roger, of Weybred, Suff, tanner 0
3850522 1973751 1973751 defendant Butte John butcher 600777 600777 Butte, John, of Weybred, Suff, butcher 2
3920354 1997149 1997149 defendant Whytnaham Henry miller 600777 600777 Whytnaham, Henry, of Weybred, Suff, miller 0
4001017 2025138 2025138 defendant Algar Thomas potter 600777 600777 Algar, Thomas, of Weybred, Suff, potter 0
4054970 2044172 2044172 defendant Calthorpe William esq 600777 600777 Calthorpe, William, of Weybred, Suff, esq 0
4120688 2067678 2067678 defendant Calthorpe William esq 600777 600777 Calthorpe, William, of Weybred, Suff, esq 0
4127530 2070138 2070138 defendant Mylles Thomas potter 600777 600777 Mylles, Thomas, of Weybred, Suff, potter 0
4147579 2077295 2077295 defendant Godfrey John yeoman 600777 600777 Godfrey, John, of Weybred, Suff, yeoman 1
4172168 2085726 2085726 defendant Alger Nicholas potter 600777 600777 Alger, Nicholas, of Weybred, Suff, potter 0
4186614 2090803 2090803 defendant Calthorpe William esq 600777 600777 Calthorpe, William, of Weybred, Suff, esq 0
4192061 2092783 2092783 defendant Calthrop William esq 600777 600777 Calthrop, William, of Weybred, Suff, esq 0
4192063 2092784 2092784 defendant Calthrop William esq 600777 600777 Calthrop, William, of Weybred, Suff, esq 0
4202486 2096410 2096410 defendant Godfrey John, junior husbandman 600777 600777 Godfrey, John, junior, of Weybred, Suff, husbandman 0
4218061 2101814 2101814 defendant Meane at Mill Thomas yeoman 600777 600777 Meane at Mill, Thomas, of Weybred, Suff, yeoman 0
4275831 2121496 2121496 defendant Anger Nicholas yeoman 600777 600777 Anger, Nicholas, of Weybred, Suff, yeoman 3
4284574 2124532 2124532 defendant Gawdye Thomas, junior   600777 600777 Gawdye, Thomas, junior, of Weybred, Suff, gent, son of Thomas Gawdye, senior 0
4287076 2125432 2125432 defendant Brabon John yeoman 600777 600777 Brabon, John, of Weybred, Suff, yeoman 0
4289358 2126254 2126254 defendant Bryant William miller 600777 600777 Bryant, William, of Weybred, Suff, miller 0
4335047 2141993 2141993 defendant Styles James yeoman 600777 600777 Styles, James, of Weybred, Suff, yeoman 0
4340926 2144101 2144101 defendant Botewright John yeoman 600777 600777 Botewright, John, of Weybred, Suff, yeoman 3
4348913 2146882 2146882 defendant Wales Robert yeoman 600777 600777 Wales, Robert, of Weybred, Suff, yeoman 2
4360059 2150760 2150760 defendant Gawdye Owen gent 600777 600777 Gawdye, Owen, of Weybred, Suff, gent 0
4385975 2159999 2159999 defendant Gawdye Owen gent 600777 600777 Gawdye, Owen, of Weybred, Suff, gent 0
4826692 2304382 2304382 defendant Morys William yeoman 600777 600777 Morys, William, of Weybred, Suff, yeoman 1
4841125 2308758 2308758 defendant Eggefeld John husbandman 600777 600777 Eggefeld, John, of Weybred, Suff, husbandman 0
4954587 2343331 2343331 defendant Tyler alias Morys John husbandman 600777 600777 Tyler alias Morys, John, of Weybred, Suff, husbandman 0
5595654 2533563 2533563 defendant Dade Nicholas chaplain 600777 600777 Dade, Nicholas, of Weybred, Suff, chaplain 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);