names

21 rows where case_id = 2195519

✎ 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
4483462 2195519 2195519 plaintiff Norton Richard de     Norton, Richard de, on his own account 0
4483463 2195519 2195519 defendant Henryson John     Henryson, John 0
4483464 2195519 2195519 defendant Joy Richard     Joy, Richard 1
4483465 2195519 2195519 defendant Myrewra Walter     Myrewra, Walter 2
4483466 2195519 2195519 defendant Freman Thomas     Freman, Thomas 3
4483467 2195519 2195519 defendant Cooke Robert     Cooke, Robert 4
4483468 2195519 2195519 defendant Wryght John     Wryght, John 5
4483469 2195519 2195519 defendant Kerby Robert de     Kerby, Robert de 6
4483470 2195519 2195519 defendant del Brigge Stephen     del Brigge, Stephen 7
4483471 2195519 2195519 defendant del Well Robert     del Well, Robert 8
4483472 2195519 2195519 defendant Pulter William     Pulter, William 9
4483473 2195519 2195519 defendant Watson John     Watson, John 10
4483474 2195519 2195519 defendant Madour John     Madour, John 11
4483475 2195519 2195519 defendant Balderby John de     Balderby, John de 12
4483476 2195519 2195519 defendant Cooke Nicholas     Cooke, Nicholas 13
4483477 2195519 2195519 defendant Broune William     Broune, William 14
4483478 2195519 2195519 defendant Layburne William de     Layburne, William de 15
4483479 2195519 2195519 defendant Smelt William     Smelt, William 16
4483480 2195519 2195519 defendant Bowes Simon de     Bowes, Simon de 17
4483481 2195519 2195519 defendant Feryman Thomas     Feryman, Thomas 18
4483482 2195519 2195519 defendant Lambe Richard   761977 761977 Lambe, Richard, of Pykhall 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);