names

17 rows where case_id = 1913289

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659697 1913289 1913289 plaintiff Gryffyn Thomas     Gryffyn, Thomas 0
3659698 1913289 1913289 plaintiff Osborn Morris     Osborn, Morris 1
3659699 1913289 1913289 plaintiff Salysbury Richard     Salysbury, Richard 2
3659700 1913289 1913289 plaintiff Bedyll William     Bedyll, William 3
3659701 1913289 1913289 plaintiff Ragland William Marbury, Richard   Ragland, William, Marbury, Richard 4
3659702 1913289 1913289 plaintiff Cheselden William     Cheselden, William 5
3659703 1913289 1913289 plaintiff Rose Miles     Rose, Miles 6
3659704 1913289 1913289 plaintiff Saunders Thomas     Saunders, Thomas 7
3659705 1913289 1913289 plaintiff Whettwell John     Whettwell, John 8
3659706 1913289 1913289 plaintiff Flecton Robert     Flecton, Robert 9
3659707 1913289 1913289 defendant Morley Bartrahus yeoman 594662 594662 Morley, Bartrahus, of Farnedon, yeoman 0
3659708 1913289 1913289 defendant Hall Robert yeoman 604917 604917 Hall, Robert, of Farmedon, yeoman 1
3659709 1913289 1913289 defendant Smyth Nicholas of Farmedon husbandman   Smyth, Nicholas of Farmedon, husbandman 2
3659710 1913289 1913289 defendant Chester Richard husbandman 604917 604917 Chester, Richard, of Farmedon, husbandman 3
3659711 1913289 1913289 defendant Chester William husbandman 604917 604917 Chester, William, of Farmedon, husbandman 4
3659712 1913289 1913289 defendant Aleyn Robert husbandman 604917 604917 Aleyn, Robert, of Farmedon, husbandman 5
3659713 1913289 1913289 defendant Marston Ralph husbandman 604917 604917 Marston, Ralph, of Farmedon, husbandman 6

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