names

13 rows where case_id = 2551654

✎ 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
5624671 2551654 2551654 plaintiff Lescrop Henry knight   Lescrop, Henry, knight 0
5624672 2551654 2551654 defendant Wollay Thomas mercer 586887 586887 Wollay, Thomas, of Wakefeld, mercer 0
5624673 2551654 2551654 defendant Metheley William husbandman 622940 622940 Metheley, William, of Horbury, husbandman 1
5624674 2551654 2551654 defendant John son of William Norton parker of Roundhaghe yeoman   John son of William Norton, parker of Roundhaghe, yeoman 2
5624675 2551654 2551654 defendant Ardeslawe William laborer 586887 586887 Ardeslawe, William, of Wakefeld, laborer 3
5624676 2551654 2551654 defendant John Barker Jonesservant Amyas of Shitlyngton laborer   John Barker Jonesservant Amyas, of Shitlyngton, laborer 4
5624677 2551654 2551654 defendant (not given) Thomas son of John Santemere, yeoman   Thomas son of John Santemere, of Wodkirke, yeoman 5
5624678 2551654 2551654 defendant Nayler John yeoman 601728 601728 Nayler, John, of Osset, yeoman 6
5624679 2551654 2551654 defendant Elys Thomas husbandman 805216 805216 Elys, Thomas, of Thorp on the Hill, husbandman 7
5624680 2551654 2551654 defendant Machon John fletcher 590216 590216 Machon, John, of Dewesbury, fletcher 8
5624681 2551654 2551654 defendant Wallot Henry husbandman 598218 598218 Wallot, Henry, of Stanley, husbandman 9
5624682 2551654 2551654 defendant (not given) John son of John Manyngham, yeoman   John son of John Manyngham, of Normanton, yeoman 10
5624683 2551654 2551654 defendant Alyen John, junior nailer 601728 601728 Alyen, John, junior, of Osset, nailer 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);