names

10 rows where case_id = 2518981

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5546511 2518981 2518981 plaintiff Towneshend Eleanor (legal representative) 595789 595789 Towneshend, Eleanor, of Reynham St Mary, widow of Touneshend, Roger, knight, Justice, executor of 0
5546512 2518981 2518981 plaintiff Clere Robert knight   Clere, Robert, knight 1
5546513 2518981 2518981 defendant Fyssher John yeoman 587172 587172 Fyssher, John, of Est Derham, yeoman 0
5546514 2518981 2518981 defendant at Assh William yeoman 898628 898628 at Assh, William, of Hardwyk juxta South Lenn, yeoman 1
5546515 2518981 2518981 defendant Watson George yeoman 592729 592729 Watson, George, of Asshill, yeoman 2
5546516 2518981 2518981 defendant Walker Thomas yeoman 587209 587209 Walker, Thomas, of Marham, yeoman 3
5546517 2518981 2518981 defendant Stampe John yeoman 839300 839300 Stampe, John, of tetyllyshale, yeoman 4
5546518 2518981 2518981 defendant Marham William yeoman 586346 586346 Marham, William, of Langham, yeoman 5
5546519 2518981 2518981 defendant Bune John yeoman 606657 606657 Bune, John, of Bynham, yeoman 6
5546520 2518981 2518981 defendant Falyatte Richard husbandman 610599 610599 Falyatte, Richard, of Bathele, husbandman 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);