names

29 rows where case_id = 2196351

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4486075 2196351 2196351 plaintiff Roos Beatrice formerly wife of Thomas de Roos, of Hamelak, knight   Roos, Beatrice, formerly wife of Thomas de Roos, of Hamelak, knight 0
4486076 2196351 2196351 defendant Hykkes John     Hykkes, John 0
4486077 2196351 2196351 defendant Pekerych John     Pekerych, John 1
4486078 2196351 2196351 defendant Pekerych Robert     Pekerych, Robert 2
4486079 2196351 2196351 defendant Peytenyn John     Peytenyn, John 3
4486080 2196351 2196351 defendant Taillour Lawrence     Taillour, Lawrence 4
4486081 2196351 2196351 defendant Eldman Robert     Eldman, Robert 5
4486082 2196351 2196351 defendant Kelle John     Kelle, John 6
4486083 2196351 2196351 defendant Wry--- Richard     Wry---, Richard 7
4486084 2196351 2196351 defendant St Mary John     St Mary, John 8
4486085 2196351 2196351 defendant Stalch Bartholomew     Stalch, Bartholomew 9
4486086 2196351 2196351 defendant Blithe Richard     Blithe, Richard 10
4486087 2196351 2196351 defendant Bulwere John     Bulwere, John 11
4486088 2196351 2196351 defendant Wyndesore Thomas     Wyndesore, Thomas 12
4486089 2196351 2196351 defendant Bathe Philip     Bathe, Philip 13
4486090 2196351 2196351 defendant Vyncent John     Vyncent, John 14
4486091 2196351 2196351 defendant Coupe Thomas     Coupe, Thomas 15
4486092 2196351 2196351 defendant Robyns Adam     Robyns, Adam 16
4486093 2196351 2196351 defendant (not given) William his son   William, his son 17
4486094 2196351 2196351 defendant Robert brother of William     Robert, brother of William 18
4486095 2196351 2196351 defendant Gym-- Robert     Gym--, Robert 19
4486096 2196351 2196351 defendant Roos Thomas     Roos, Thomas 20
4486097 2196351 2196351 defendant Smyth John     Smyth, John 21
4486098 2196351 2196351 defendant Shey Geoffrey     Shey, Geoffrey 22
4486099 2196351 2196351 defendant Smyth Simon     Smyth, Simon 23
4486100 2196351 2196351 defendant Peytevyn Adam     Peytevyn, Adam 24
4486101 2196351 2196351 defendant Julles John     Julles, John 25
4486102 2196351 2196351 defendant Kelle William     Kelle, William 26
4486103 2196351 2196351 defendant Crode John   618854 618854 Crode, John, of Salthous 27

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