names

21 rows where case_id = 2189950

✎ 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
4465715 2189950 2189950 plaintiff Wykes John     Wykes, John 0
4465716 2189950 2189950 defendant Walsham John   587331 587331 Walsham, John, of Causton 0
4465717 2189950 2189950 defendant Taillour Roger   589042 589042 Taillour, Roger, of Heydon 1
4465718 2189950 2189950 defendant Alvyngham John de     Alvyngham, John de 2
4465719 2189950 2189950 defendant Brond Edmund     Brond, Edmund 3
4465720 2189950 2189950 defendant Rayby John     Rayby, John 4
4465721 2189950 2189950 defendant Kettesson John     Kettesson, John 5
4465722 2189950 2189950 defendant Rose Thoams   587387 587387 Rose, Thoams, of Boton 6
4465723 2189950 2189950 defendant Shillyng Henry     Shillyng, Henry 7
4465724 2189950 2189950 defendant Sauser John   587387 587387 Sauser, John, of Boton 8
4465725 2189950 2189950 defendant Alyen Richard     Alyen, Richard 9
4465726 2189950 2189950 defendant Bocher William     Bocher, William 10
4465727 2189950 2189950 defendant Engelond Bartholomew     Engelond, Bartholomew 11
4465728 2189950 2189950 defendant Fox Gilbert     Fox, Gilbert 12
4465729 2189950 2189950 defendant Tuppyn John     Tuppyn, John 13
4465730 2189950 2189950 defendant Barkere William   587836 587836 Barkere, William, of Folsham 14
4465731 2189950 2189950 defendant atte Mooe Thomas   587836 587836 atte Mooe, Thomas, of Folsham 15
4465732 2189950 2189950 defendant Fecard John smith 587836 587836 Fecard, John, of Folsham, smith 16
4465733 2189950 2189950 defendant Heynes Thomas     Heynes, Thomas 17
4465734 2189950 2189950 defendant Hanteyn William     Hanteyn, William 18
4465735 2189950 2189950 defendant Rycald William     Rycald, William 19

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