names

33 rows where place_id = 616041

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609139 1870516 1870516 defendant Metham Thomas   616041 616041 Metham, Thomas, of Metham, knight 0
3712152 1930119 1930119 defendant Metham Thomas esq 616041 616041 Metham, Thomas, of Metham, esq 1
3727372 1934834 1934834 defendant Metham Thomas esq 616041 616041 Metham, Thomas, of Metham, esq 0
3766817 1947288 1947288 plaintiff Metham Thomas esq 616041 616041 Metham, Thomas, of Metham, esq 0
3801184 1958292 1958292 plaintiff Metham Rhomas esq 616041 616041 Metham, Rhomas, of Metham, esq 0
4164567 2083116 2083116 defendant Metham Thomas esq 616041 616041 Metham, Thomas, of Metham, esq 0
4817084 2301440 2301440 defendant Neweborne Robert yeoman 616041 616041 Neweborne, Robert, of Metham, yeoman 1
4817085 2301440 2301440 defendant Hunt Robert yeoman 616041 616041 Hunt, Robert, of Metham, yeoman 2
4855373 2313036 2313036 defendant Meteham Thomas esq 616041 616041 Meteham, Thomas, of Metham, esq 0
5012797 2360574 2360574 plaintiff Alanson John   616041 616041 Alanson, John, of Metham 0
5057269 2373742 2373742 defendant Metham Richard esq 616041 616041 Metham, Richard, of Metham, esq 2
5060913 2374836 2374836 defendant Lumhawys Oliver yeoman 616041 616041 Lumhawys, Oliver, of Metham, yeoman 2
5065160 2376116 2376116 defendant Assherst William yeoman 616041 616041 Assherst, William, of Metham, yeoman 0
5073756 2378638 2378638 defendant Metham Thomas gent 616041 616041 Metham, Thomas, of Metham, gent 3
5084514 2381882 2381882 defendant Lumhalkys Almery yeoman 616041 616041 Lumhalkys, Almery, of Metham, yeoman 1
5084520 2381883 2381883 defendant Lumhalkys Almery yeoman 616041 616041 Lumhalkys, Almery, of Metham, yeoman 1
5090796 2383699 2383699 plaintiff Matham Thomas esq 616041 616041 Matham, Thomas, of Metham, esq 1
5097436 2385682 2385682 defendant Metham Thomas   616041 616041 Metham, Thomas, of Metham knight 0
5097442 2385683 2385683 defendant Metham Thomas   616041 616041 Metham, Thomas, of Metham, knight 0
5101189 2386756 2386756 defendant Metham Richard esq 616041 616041 Metham, Richard, of Metham, esq 0
5184995 2411356 2411356 defendant Metham Thomas esq 616041 616041 Metham, Thomas, of Metham, esq 0
5184996 2411356 2411356 defendant Metham John esq 616041 616041 Metham, John, of Metham, esq 1
5257351 2432423 2432423 defendant Metham Thomas, senior   616041 616041 Metham, Thomas, senior, of Metham, knight 0
5282081 2439833 2439833 defendant Johnson Robert chaplain 616041 616041 Johnson, Robert, of Metham, chaplain 1
5528135 2513365 2513365 plaintiff Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5528138 2513366 2513366 plaintiff Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5528597 2513455 2513455 defendant Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5537225 2516127 2516127 defendant Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5537230 2516128 2516128 defendant Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5537235 2516129 2516129 defendant Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5537240 2516130 2516130 defendant Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5542448 2517762 2517762 plaintiff Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 0
5542451 2517763 2517763 plaintiff Metham Thomas (legal representative) 616041 616041 Metham, Thomas, of Metham, knight, executrix of 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);