names

16 rows where case_id = 2171917

✎ 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
4422561 2171917 2171917 plaintiff English Thomas son of Robert   English, Thomas, son of Robert 0
4422562 2171917 2171917 defendant Blaykester Richard son of Thomas   Blaykester, Richard, son of Thomas 0
4422563 2171917 2171917 defendant Blaykester Margery     Margery, his wife 1
4422564 2171917 2171917 defendant English Ellis     English, Ellis 2
4422565 2171917 2171917 defendant Cole John son of Robert   Cole, John, son of Robert 3
4422566 2171917 2171917 defendant Godloth Robert son of Stephen   Godloth, Robert, son of Stephen 4
4422567 2171917 2171917 defendant Bole William son of Thomas   Bole, William, son of Thomas 5
4422568 2171917 2171917 defendant Smyth Margery     Smyth, Margery 6
4422569 2171917 2171917 defendant Mareschal John son of Richard   Mareschal, John, son of Richard 7
4422570 2171917 2171917 defendant Mareschal Joan     Joan, his wife 8
4422571 2171917 2171917 defendant Cranewell Reginald de   754719 754719 Cranewell, Reginald de, of Milnethorp 9
4422572 2171917 2171917 defendant Cranewell Alice     Alice, his wife 10
4422573 2171917 2171917 defendant Pykenette Roger     Pykenette, Roger 11
4422574 2171917 2171917 defendant Oky William     Oky, William 12
4422575 2171917 2171917 defendant Carter Robert   754720 754720 Carter, Robert, of Berewyk 13
4422576 2171917 2171917 defendant Carter Lucy     Lucy, his wife 14

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