names

15 rows where case_id = 2402039

✎ 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
5153056 2402039 2402039 plaintiff Hothom John knight   Hothom, John, knight 0
5153057 2402039 2402039 defendant Wady Robert yeoman 757540 757540 Wady, Robert, of Ottelay, yeoman 0
5153058 2402039 2402039 defendant White William   796289 796289 White, William, of Ilkelay, vicar 1
5153059 2402039 2402039 defendant Aylemer John, sen yeoman 622834 622834 Aylemer, John, sen, of Westhall, yeoman 2
5153060 2402039 2402039 defendant Aylemer John jun, yeoman   Aylemer, John, jun, yeoman 3
5153061 2402039 2402039 defendant Wolhous William yeoman 850721 850721 Wolhous, William, of Keghlay, yeoman 4
5153062 2402039 2402039 defendant Rodes William yeoman 757540 757540 Rodes, William, of Ottelay, yeoman 5
5153063 2402039 2402039 defendant Cravyn Thomas yeoman 757540 757540 Cravyn, Thomas, of Ottelay, yeoman 6
5153064 2402039 2402039 defendant Frithbank John yeoman 595215 595215 Frithbank, John, of Tokwyth, yeoman 7
5153065 2402039 2402039 defendant Ayssh William smith 757540 757540 Ayssh, William, of Ottelay, smith 8
5153066 2402039 2402039 defendant Keton James yeoman 764906 764906 Keton, James, of Repon, yeoman 9
5153067 2402039 2402039 defendant Keton James gent 764906 764906 Keton, James, of Repon, gent 10
5153068 2402039 2402039 defendant Todde William chapman 764906 764906 Todde, William, of Repon, chapman 11
5153069 2402039 2402039 defendant Todde William chapman 589310 589310 Todde, William, of Ripon, chapman 12
5153070 2402039 2402039 defendant Taillour Thomas yeoman 812153 812153 Taillour, Thomas, of Salley, yeoman 13

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