names

52 rows where place_id = 596031

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622821 1874669 1874669 defendant Sotyll Alice widow 596031 596031 Sotyll, Alice, of Everyngham, widow 1
3629031 1903957 1903957 plaintiff Constable Marmaduke   596031 596031 Constable, Marmaduke, of Everyngham, knight 0
3747533 1941143 1941143 plaintiff Constable Marmaduke   596031 596031 Constable, Marmaduke, of Everyngham, knight 3
3881333 1984021 1984021 plaintiff Constable Marmaduke   596031 596031 Constable, Marmaduke, of Everyngham, knight 1
3881336 1984022 1984022 plaintiff Constable Marmaduke   596031 596031 Constable, Marmaduke, of Everyngham, knight 1
4420857 2171420 2171420 plaintiff Brantyngham John de   596031 596031 (Brantyngham, John de, of Everyngham, parson 1
4420863 2171421 2171421 plaintiff Brantyngham John de   596031 596031 (Brantyngham, John de, of Everyngham, parson 1
4420876 2171424 2171424 plaintiff Brantyngham John   596031 596031 (Brantyngham, John, of Everyngham, parson 1
4614783 2235633 2235633 plaintiff Elton John   596031 596031 Elton, John, of Everyngham 0
4614786 2235634 2235634 plaintiff Elton John   596031 596031 Elton, John, of Everyngham 0
4724189 2272860 2272860 plaintiff Elton John   596031 596031 Elton, John, of Everyngham 0
4995185 2355410 2355410 defendant Wilton Robert husbandman 596031 596031 Wilton, Robert, of Everyngham, husbandman 4
5019983 2362726 2362726 defendant Ermet Richard yeoman 596031 596031 Ermet, Richard, of Everyngham, yeoman 0
5019984 2362726 2362726 defendant Ermet Thomas yeoman 596031 596031 Ermet, Thomas, of Everyngham, yeoman 1
5019985 2362726 2362726 defendant Ermet John yeoman 596031 596031 Ermet, John, of Everyngham, yeoman 2
5044235 2369905 2369905 defendant Mell or Moubray William milner 596031 596031 Mell or Moubray, William, of Everyngham, milner 2
5044236 2369905 2369905 defendant Holand John yeoman 596031 596031 Holand, John, of Everyngham, yeoman 3
5094023 2384651 2384651 plaintiff Ricall Robert (legal representative) 596031 596031 Ricall, Robert, of Everyngham, executors of 0
5110029 2389358 2389358 defendant Eles Robert esq 596031 596031 Eles, Robert, of Everyngham, esq 0
5110030 2389358 2389358 defendant Lee John clerk 596031 596031 Lee, John, of Everyngham, clerk 1
5110031 2389358 2389358 defendant Metham Henry gent 596031 596031 Metham, Henry, of Everyngham, gent 2
5110032 2389358 2389358 defendant Hotham Stephen   596031 596031 Hotham, Stephen, of Everyngham, franklin 3
5110033 2389358 2389358 defendant Atkynson William yeoman 596031 596031 Atkynson, William, of Everyngham, yeoman 4
5110034 2389358 2389358 defendant Armet Richard yeoman 596031 596031 Armet, Richard, of Everyngham, yeoman 5
5110035 2389358 2389358 defendant Barcroft Thomas yeoman 596031 596031 Barcroft, Thomas, of Everyngham, yeoman 6
5110036 2389358 2389358 defendant Barcroft Henry yeoman 596031 596031 Barcroft, Henry, of Everyngham, yeoman 7
5110037 2389358 2389358 defendant Colson Richard yeoman 596031 596031 Colson, Richard, of Everyngham, yeoman 8
5110038 2389358 2389358 defendant Holand John yeoman 596031 596031 Holand, John, of Everyngham, yeoman 9
5110039 2389358 2389358 defendant Kalowe Robert yeoman 596031 596031 Kalowe, Robert, of Everyngham, yeoman 10
5110040 2389358 2389358 defendant Syreson Oliver chaplain 596031 596031 Syreson, Oliver, of Everyngham, chaplain 11
5110041 2389358 2389358 defendant Atkynson Robert yeoman 596031 596031 Atkynson, Robert, of Everyngham, yeoman 12
5110042 2389358 2389358 defendant Perkynson John laborer 596031 596031 Perkynson, John, of Everyngham, laborer 13
5110043 2389358 2389358 defendant Santon John laborer 596031 596031 Santon, John, of Everyngham, laborer 14
5110044 2389358 2389358 defendant Atkynson Robert husbandman 596031 596031 Atkynson, Robert, of Everyngham, husbandman 15
5110045 2389358 2389358 defendant Spenser Thomas husbandman 596031 596031 Spenser, Thomas, of Everyngham, husbandman 16
5110046 2389358 2389358 defendant Skate John husbandman 596031 596031 Skate, John, of Everyngham, husbandman 17
5110047 2389358 2389358 defendant Grene Stephen husbandman 596031 596031 Grene, Stephen, of Everyngham, husbandman 18
5110048 2389358 2389358 defendant Tove Thomas husbandman 596031 596031 Tove, Thomas, of Everyngham, husbandman 19
5110049 2389358 2389358 defendant Smyth John husbandman 596031 596031 Smyth, John, of Everyngham, husbandman 20
5110050 2389358 2389358 defendant Wryght Robert husbandman 596031 596031 Wryght, Robert, of Everyngham, husbandman 21
5110051 2389358 2389358 defendant Atkynson Robert clerk 596031 596031 Atkynson, Robert, of Everyngham, clerk 22
5110052 2389358 2389358 defendant Atkynson Robert laborer 596031 596031 Atkynson, Robert, of Everyngham, laborer 23
5110053 2389358 2389358 defendant Hesell John husbandman 596031 596031 Hesell, John, of Everyngham, husbandman 24
5110054 2389358 2389358 defendant Rashell Robert husbandman 596031 596031 Rashell, Robert, of Everyngham, husbandman 25
5110055 2389358 2389358 defendant Grene John yeoman 596031 596031 Grene, John, of Everyngham, yeoman 26
5110056 2389358 2389358 defendant Armet Thomas husbandman 596031 596031 Armet, Thomas, of Everyngham, husbandman 27
5178760 2409509 2409509 defendant Barker Alice widow 596031 596031 Barker, Alice, of Everyngham, widow 0
5178762 2409510 2409510 defendant Barker Alice widow 596031 596031 Barker, Alice, of Everyngham, widow 0
5229376 2424203 2424203 defendant Westerdale Jomn yeoman 596031 596031 Westerdale, Jomn, of Everyngham, yeoman 2
5571248 2526150 2526150 defendant Boynton John chaplain 596031 596031 Boynton, John, of Everyngham, chaplain 0
5595321 2533484 2533484 defendant Boynton John clerk 596031 596031 Boynton, John, of Everyngham, clerk 0
5614703 2548397 2548397 defendant Somoundour Richard   596031 596031 Somoundour, Richard, of Everyngham 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);