names

12 rows where case_id = 2259874

✎ 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
4681652 2259874 2259874 plaintiff Michell Geoffrey (legal representative)   Michell, Geoffrey, executors of 0
4681653 2259874 2259874 plaintiff Michell Eleanor formerly wife of Testator   (Michell, Eleanor, formerly wife of Testator 1
4681654 2259874 2259874 plaintiff Teye Robert de esq   Teye, Robert de, esq 2
4681655 2259874 2259874 plaintiff Ewell John     Ewell, John 3
4681656 2259874 2259874 defendant Byle Thomas yeoman 783344 783344 Byle, Thomas, of Assshewell, Herts, yeoman 0
4681657 2259874 2259874 defendant Gardener Richard husbandman 630896 630896 Gardener, Richard, of Ixnyng, Suff, husbandman 1
4681658 2259874 2259874 defendant Aty or Acy John husbandman 783345 783345 Aty or Acy, John, of Hasilworth, Suff, husbandman 2
4681659 2259874 2259874 defendant Lady Richard yeoman 783346 783346 Lady, Richard, of Breat Cormerde, Suff, yeoman 3
4681660 2259874 2259874 defendant Wayte Walter yeoman 761061 761061 Wayte, Walter, of Pebemerssh, yeoman 4
4681661 2259874 2259874 defendant Sparhauk Richard yeoman 755808 755808 Sparhauk, Richard, of Alphameston, yeoman 5
4681662 2259874 2259874 defendant Chener John yeoman 783347 783347 Chener, John, of Lammemrssh, yeoman 6
4681663 2259874 2259874 defendant Nowers Thomas yeoman 591651 591651 Nowers, Thomas, of Bures St Mary, yeoman 7

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