names

13 rows where case_id = 2349934

✎ 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
4976492 2349934 2349934 plaintiff Passemer Robert     Passemer, Robert 0
4976493 2349934 2349934 defendant Jonson Thomas husbandman 633805 633805 Jonson, Thomas, of Barwell, husbandman 0
4976494 2349934 2349934 defendant Bray Thomas husbandman 633805 633805 Bray, Thomas, of Barwell, husbandman 1
4976495 2349934 2349934 defendant Grene Hugh   633805 633805 Grene, Hugh, of Barwell 2
4976496 2349934 2349934 defendant Randyll William husbandman 633805 633805 Randyll, William, of Barwell, husbandman 3
4976497 2349934 2349934 defendant Smyth John husbandman 633805 633805 Smyth, John, of Barwell, husbandman 4
4976498 2349934 2349934 defendant Smyth Thomas husbandman 633805 633805 Smyth, Thomas, of Barwell, husbandman 5
4976499 2349934 2349934 defendant atte Asshe John husbandman 633805 633805 atte Asshe, John, of Barwell, husbandman 6
4976500 2349934 2349934 defendant Bradley John husbandman 633805 633805 Bradley, John, of Barwell, husbandman 7
4976501 2349934 2349934 defendant Barleston Henry husbandman 633805 633805 Barleston, Henry, of Barwell, husbandman 8
4976502 2349934 2349934 defendant Boyer Roger husbandman 633805 633805 Boyer, Roger, of Barwell, husbandman 9
4976503 2349934 2349934 defendant Colleston John yeoman 633805 633805 Colleston, John, of Barwell, yeoman 10
4976504 2349934 2349934 defendant Gegge John husbandman 633805 633805 Gegge, John, of Barwell, husbandman 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);