names

24 rows where case_id = 2346282

✎ 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
4964457 2346282 2346282 plaintiff Clerk William yeoman or tanner 828151 828151 Clerk, William, of Bodrugan, yeoman or tanner 0
4964458 2346282 2346282 defendant Nanfan John esq 828152 828152 Nanfan, John, of Crethuell, esq 0
4964459 2346282 2346282 defendant Basset John esq 828153 828153 Basset, John, of Tehydym, esq 1
4964460 2346282 2346282 defendant Nicoll John gent 587114 587114 Nicoll, John, of Bodmyn, gent 2
4964461 2346282 2346282 defendant Lanhergy Thomas gent 587114 587114 Lanhergy, Thomas, of Bodmyn, gent 3
4964462 2346282 2346282 defendant Tregasowe Oliver gent 788745 788745 Tregasowe, Oliver, of Bodmalgan, gent 4
4964463 2346282 2346282 defendant Bere William gent 587114 587114 Bere, William, of Bodmyn, gent 5
4964464 2346282 2346282 defendant (not given) William prior of Bodmyn Priory   Bodmyn Priory, William, prior of 6
4964465 2346282 2346282 defendant Gantell William monk   Gantell, William, monk 7
4964466 2346282 2346282 defendant Bere Thomas gent 828154 828154 Bere, Thomas, of Brynne, gent 8
4964467 2346282 2346282 defendant Trethewy William gent 828155 828155 Trethewy, William, of St Martin juxta Estloo, gent 9
4964468 2346282 2346282 defendant Trethewy John clerk 828155 828155 Trethewy, John, of St Martin juxta Estloo, clerk 10
4964469 2346282 2346282 defendant Bonde Richard gent 828156 828156 Bonde, Richard, of Erthe juxta Asshe, gent 11
4964470 2346282 2346282 defendant Pya John clerk 761485 761485 Pya, John, of St Neot, clerk 12
4964471 2346282 2346282 defendant Vage Richard merchant 603088 603088 Vage, Richard, of Leskerd, merchant 13
4964472 2346282 2346282 defendant Nanvan James   828157 828157 Nanvan, James, of Bodmyn, genr 14
4964473 2346282 2346282 defendant Hicke John mercer 603088 603088 Hicke, John, of Leskerd, mercer 15
4964474 2346282 2346282 defendant Chyket Richard gent 759650 759650 Chyket, Richard, of Calyngton, gent 16
4964475 2346282 2346282 defendant Code Walter gent 587817 587817 Code, Walter, of Fowey, gent 17
4964476 2346282 2346282 defendant Trefrye Thomas gent 587817 587817 Trefrye, Thomas, of Fowey, gent 18
4964477 2346282 2346282 defendant Ude Thomas gent 828158 828158 Ude, Thomas, of Pengelly, Thomas, of Hustyng, gent 19
4964478 2346282 2346282 defendant Trewyket John gent 636962 636962 Trewyket, John, of Padystowe, gent 20
4964479 2346282 2346282 defendant Tregodek Thomas gent 585869 585869 Tregodek, Thomas, of London, gent 21
4964480 2346282 2346282 defendant Treyonran Roger gent 824867 824867 Treyonran, Roger, of Dryff, gent 22

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