names

24 rows where case_id = 2187124

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4456709 2187124 2187124 plaintiff Osbern John     Osbern, John 0
4456710 2187124 2187124 defendant Bokerel John, junior     Bokerel, John, junior 0
4456711 2187124 2187124 defendant Bokerel Henry, senior     Bokerel, Henry, senior 1
4456712 2187124 2187124 defendant Bokerel John, senior     Bokerel, John, senior 2
4456713 2187124 2187124 defendant Gode Stephen     Gode, Stephen 3
4456714 2187124 2187124 defendant Edewell John chaplain   Edewell, John, chaplain 4
4456715 2187124 2187124 defendant Burnard John     Burnard, John 5
4456716 2187124 2187124 defendant Taillour Thomas formerly servant of John Popham   Taillour, Thomas, formerly servant of John Popham 6
4456717 2187124 2187124 defendant Oke John     Oke, John 7
4456718 2187124 2187124 defendant Taillour John   758794 758794 Taillour, John, of Abbotesle 8
4456719 2187124 2187124 defendant Frysel Richard butcher   Frysel, Richard, butcher 9
4456720 2187124 2187124 defendant Sanger John     Sanger, John 10
4456721 2187124 2187124 defendant Batyn William     Batyn, William 11
4456722 2187124 2187124 defendant Blakeheved John     Blakeheved, John 12
4456723 2187124 2187124 defendant Toukere Nicholas butcher   Toukere, Nicholas, butcher 13
4456724 2187124 2187124 defendant Popham John     together with Popham, John 14
4456725 2187124 2187124 defendant Popham Thomas     Popham, Thomas 15
4456726 2187124 2187124 defendant Pyk Richard     Pyk, Richard 16
4456727 2187124 2187124 defendant Wranbury Mathew     Wranbury, Mathew 17
4456728 2187124 2187124 defendant Caucy Hugh     Caucy, Hugh 18
4456729 2187124 2187124 defendant Hacche Henry     Hacche, Henry 19
4456730 2187124 2187124 defendant Pope Henry     Pope, Henry 20
4456731 2187124 2187124 defendant Bokerel Henry, junior     Bokerel, Henry, junior 21
4456732 2187124 2187124 defendant Myles Thomas     Myles, Thomas 22

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