names

21 rows where place_id = 638061

✎ 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
3834254 1968656 1968656 defendant Cholmeley Richard (legal representative) 638061 638061 Cholmeley, Richard, of Cotyngham, Yorks, knight, executors of 0
3840325 1970542 1970542 defendant Dyxson John, junior chapman 638061 638061 Dyxson, John, junior, of Cotyngham, Yorks, chapman 1
4646842 2245141 2245141 plaintiff Robynsson Thomas   638061 638061 Robynsson, Thomas, of Cotyngham, Yorks 0
4825666 2304067 2304067 defendant Leke William gent 638061 638061 Leke, William, of Cotyngham, Yorks, gent 0
4834283 2306734 2306734 plaintiff Cotyngham William gent 638061 638061 Cotyngham, William, of Cotyngham, Yorks, gent 0
4836573 2307410 2307410 defendant Thomson Robert chapman 638061 638061 Thomson, Robert, of Cotyngham, Yorks, chapman 1
4878026 2320081 2320081 defendant Leek William gent 638061 638061 Leek, William, of Cotyngham, Yorks, gent 2
4930547 2335957 2335957 defendant Mauleverer William gent 638061 638061 Mauleverer, William, of Cotyngham, Yorks, gent 0
4930549 2335958 2335958 defendant Mauleverer William gent 638061 638061 Mauleverer, William, of Cotyngham, Yorks, gent 0
4945428 2340549 2340549 defendant Mauleverer William gent 638061 638061 Mauleverer, William, of Cotyngham, Yorks, gent 0
4945430 2340550 2340550 defendant Mauleverer William gent 638061 638061 Mauleverer, William, of Cotyngham, Yorks, gent 0
5114023 2390490 2390490 defendant Nevill John   638061 638061 Nevill, John, of Cotyngham, Yorks, knight 1
5131943 2395827 2395827 defendant Chaumbr John yeoman 638061 638061 Chaumbr, John, of Cotyngham, Yorks, yeoman 1
5153577 2402197 2402197 defendant Hochonson William butcher 638061 638061 Hochonson, William, of Cotyngham, Yorks, butcher 2
5189014 2412516 2412516 defendant Hochonson William butcher 638061 638061 Hochonson, William, of Cotyngham, Yorks, butcher 2
5254700 2431585 2431585 defendant Watson Robert yeoman 638061 638061 Watson, Robert, of Cotyngham, Yorks, yeoman 0
5269155 2436079 2436079 defendant Dobbes Robert clerk 638061 638061 Dobbes, Robert, of Cotyngham, Yorks, clerk 0
5282678 2439998 2439998 defendant Rysom Roger husbandman 638061 638061 Rysom, Roger, of Cotyngham, Yorks, husbandman 0
5437271 2486088 2486088 defendant Hancok Richard shoemaker 638061 638061 Hancok, Richard, of Cotyngham, Yorks, shoemaker 1
5602594 2535705 2535705 defendant Cholmley Richard   638061 638061 Cholmley, Richard, of Cotyngham, Yorks, knight 6
5611964 2547474 2547474 defendant Takel William   638061 638061 Takel, William, of Cotyngham, Yorks 3

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