names

21 rows where case_id = 2524949

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5567031 2524949 2524949 plaintiff Cutte John knight, under-treasurer   Cutte, John, knight, under-treasurer 0
5567032 2524949 2524949 plaintiff Dudley Edmund esq   Dudley, Edmund, esq 1
5567033 2524949 2524949 defendant Tey William gent 586470 586470 Tey, William, of Colchester, gent 0
5567034 2524949 2524949 defendant Glantham or Glanton Thomas gent 589935 589935 Glantham or Glanton, Thomas, of Shenfeld, Essex, gent 1
5567035 2524949 2524949 defendant Kynnaston Thomas esq 586697 586697 Kynnaston, Thomas, of Shrewsbury, esq 2
5567036 2524949 2524949 defendant Thornes Roger esq 586697 586697 Thornes, Roger, of Shrewsbury, esq 3
5567037 2524949 2524949 defendant Blount Thomas   613775 613775 Blount, Thomas, of Kynlet, Salop, knight 4
5567038 2524949 2524949 defendant Curwen Thomas   764825 764825 Curwen, Thomas, of Wyrkyngton, Cumber, knight 5
5567039 2524949 2524949 defendant Moy Christopher gent 585933 585933 Moy, Christopher, of Great Yarmouth, gent 6
5567040 2524949 2524949 defendant Percy Leo esq 794322 794322 Percy, Leo, of Flixburgh, Lincs, esq 7
5567041 2524949 2524949 defendant Williams Thomas gent 693446 693446 Williams, Thomas, of Gyllough, Herefs, gent 8
5567042 2524949 2524949 defendant Gudrell David gent 900862 900862 Gudrell, David, of Woymesbridge, Herefs, gent 9
5567043 2524949 2524949 defendant Taillour William yeoman 900863 900863 Taillour, William, of Bishops Lydyerd, Soms, yeoman 10
5567044 2524949 2524949 defendant Rydley Nicholas esq 900864 900864 Rydley, Nicholas, of Willemonswike, Northumb, esq 11
5567045 2524949 2524949 defendant Lee William gent 601552 601552 Lee, William, of Richemond, Yorks, gent 12
5567046 2524949 2524949 defendant Tyrry Christopher goldsmith 585869 585869 Tyrry, Christopher, of London, goldsmith 13
5567047 2524949 2524949 defendant Pennyngton William gent 596906 596906 Pennyngton, William, of Newton, Cumber, gent 14
5567048 2524949 2524949 defendant Corbet John esq 621378 621378 Corbet, John, of Lee, Salop, esq 15
5567049 2524949 2524949 defendant Stancombe John gent 900865 900865 Stancombe, John, of Wynston, Glos, gent 16
5567050 2524949 2524949 defendant Olyver John chaplain 900866 900866 Olyver, John, of Cherdlynch, Soms, chaplain 17
5567051 2524949 2524949 defendant Curwen John clerk 900867 900867 Curwen, John, of Gretheam, Durham, clerk 18

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