names

22 rows where case_id = 2215817

✎ 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
4549592 2215817 2215817 plaintiff Coterell Margaret formerly wife of Thomas   Coterell, Margaret, formerly wife of Thomas 0
4549593 2215817 2215817 defendant Knolle Thomas     Knolle, Thomas 0
4549594 2215817 2215817 defendant Cl_ William     Cl_, William 1
4549595 2215817 2215817 defendant Redeheved John     Redeheved, John 2
4549596 2215817 2215817 defendant Baker William   595915 595915 Baker, William, of Hungerford 3
4549597 2215817 2215817 defendant Kemer John     Kemer, John 4
4549598 2215817 2215817 defendant Carpenter Michael     Carpenter, Michael 5
4549599 2215817 2215817 defendant Dyne Thomas     Dyne, Thomas 6
4549600 2215817 2215817 defendant Grede William tailor   Grede, William, tailor 7
4549601 2215817 2215817 defendant Boide John     Boide, John 8
4549602 2215817 2215817 defendant Noryce William     Noryce, William 9
4549603 2215817 2215817 defendant Webbe Robert     Webbe, Robert 10
4549604 2215817 2215817 defendant Webbe Thomas     Webbe, Thomas 11
4549605 2215817 2215817 defendant Fissher Robert     Fissher, Robert 12
4549606 2215817 2215817 defendant Burgate John     Burgate, John 13
4549607 2215817 2215817 defendant Goldyng William clerk   together with Goldyng, William, clerk 14
4549608 2215817 2215817 defendant Glovere Hugh     Glovere, Hugh 15
4549609 2215817 2215817 defendant Bouther Roger     Bouther, Roger 16
4549610 2215817 2215817 defendant atte Wyke John     atte Wyke, John 17
4549611 2215817 2215817 defendant Helme William     Helme, William 18
4549612 2215817 2215817 defendant Goldryng John     Goldryng, John 19
4549613 2215817 2215817 defendant Parker William     Parker, William 20

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