names

27 rows where case_id = 2188780

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4461870 2188780 2188780 plaintiff Strecche John knight   Strecche, John, knight 0
4461871 2188780 2188780 defendant Eggesdele William     Eggesdele, William 0
4461872 2188780 2188780 defendant Derte William     Derte, William 1
4461873 2188780 2188780 defendant Chalvendon Walter     Chalvendon, Walter 2
4461874 2188780 2188780 defendant Deygh William   588557 588557 Deygh, William, of Tyverton 3
4461875 2188780 2188780 defendant Hunte Thomas     Hunte, Thomas 4
4461876 2188780 2188780 defendant Byllyng Thomas     Byllyng, Thomas 5
4461877 2188780 2188780 defendant Shirward William     Shirward, William 6
4461878 2188780 2188780 defendant Cropp John   615552 615552 Cropp, John, of Devon 7
4461879 2188780 2188780 defendant Bron Thomas     Bron, Thomas 8
4461880 2188780 2188780 defendant Leom John     Leom, John 9
4461881 2188780 2188780 defendant Irlond John     Irlond, John 10
4461882 2188780 2188780 defendant Focel Richard     Focel, Richard 11
4461883 2188780 2188780 defendant Gosse Walter     Gosse, Walter 12
4461884 2188780 2188780 defendant Aston John     Aston, John 13
4461885 2188780 2188780 defendant Ryke Robert     Ryke, Robert 14
4461886 2188780 2188780 defendant Eggecombe Richard     Eggecombe, Richard 15
4461887 2188780 2188780 defendant Knylman Adam     Knylman, Adam 16
4461888 2188780 2188780 defendant Blyuch William     Blyuch, William 17
4461889 2188780 2188780 defendant Kyndon John     Kyndon, John 18
4461890 2188780 2188780 defendant Wyke William     Wyke, William 19
4461891 2188780 2188780 defendant Carbill John     Carbill, John 20
4461892 2188780 2188780 defendant William Richard     William, Richard 21
4461893 2188780 2188780 defendant Wake John     Wake, John 22
4461894 2188780 2188780 defendant Payn William   615552 615552 Payn, William, of Devon 23
4461895 2188780 2188780 defendant Drayton Roger     Drayton, Roger 24
4461896 2188780 2188780 defendant Fougheler John     Fougheler, John 25

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