names

13 rows where case_id = 2283657

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4760586 2283657 2283657 plaintiff Culwen Christopher knight   Culwen, Christopher, knight 0
4760587 2283657 2283657 defendant Bullok John yeoman 760887 760887 Bullok, John, of Gillesland, yeoman 0
4760588 2283657 2283657 defendant Hoggesson Thomas yeoman 798207 798207 Hoggesson, Thomas, of Blenerhayset, yeoman 1
4760589 2283657 2283657 defendant Raper Thomas husbandman 791617 791617 Raper, Thomas, of Brounfeld, husbandman 2
4760590 2283657 2283657 defendant Barton John yeoman 753950 753950 together with Barton, John, of Holm, yeoman 3
4760591 2283657 2283657 defendant Berwys Stephen   753950 753950 Berwys, Stephen, of Holm, franklin 4
4760592 2283657 2283657 defendant Launder John yeoman 597715 597715 Launder, John, of Wygton, yeoman 5
4760593 2283657 2283657 defendant Slake Thomas husbandman 597715 597715 Slake, Thomas, of Wygton, husbandman 6
4760594 2283657 2283657 defendant Bakster John yeoman 593911 593911 Bakster, John, of Penreth, yeoman 7
4760595 2283657 2283657 defendant Tyndale Rowland yeoman 760887 760887 Tyndale, Rowland, of Gillesland, yeoman 8
4760596 2283657 2283657 defendant Tennmam Thoams yeoman 760887 760887 Tennmam, Thoams, of Gillesland, yeoman 9
4760597 2283657 2283657 defendant Patonson Robert yeoman 798209 798209 Patonson, Robert, of Skaylby, yeoman 10
4760598 2283657 2283657 defendant Whelpdale John yeoman 760887 760887 Whelpdale, John, of Gillesland, yeoman 11

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