names

14 rows where case_id = 2424062

✎ 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
5228908 2424062 2424062 plaintiff Witer John clerk   Witer, John, clerk 0
5228909 2424062 2424062 defendant Partryk William yeoman 861776 861776 Partryk, William, of Swanlond, Kyngeston on Hull, yeoman 0
5228910 2424062 2424062 defendant Plummer Robert yeoman 586070 586070 Plummer, Robert, of Beverley, yeoman 1
5228911 2424062 2424062 defendant Watson John yeoman 595431 595431 Watson, John, of North Cave, yeoman 2
5228912 2424062 2424062 defendant Boucher John husbandman 595431 595431 Boucher, John, of North Cave, husbandman 3
5228913 2424062 2424062 defendant Tailliour Thomas husbandman 595431 595431 Tailliour, Thomas, of North Cave, husbandman 4
5228914 2424062 2424062 defendant Hardy John husbandman 773053 773053 Hardy, John, of Dreweton, husbandman 5
5228915 2424062 2424062 defendant Jakson William husbandman 861777 861777 Jakson, William, of Wighton under the Wald, husbandman 6
5228916 2424062 2424062 defendant Neweland John husbandman 861777 861777 Neweland, John, of Wighton under the Wald, husbandman 7
5228917 2424062 2424062 defendant Raweson Thomas husbandman 861777 861777 Raweson, Thomas, of Wighton under the Wald, husbandman 8
5228918 2424062 2424062 defendant Kune William yeoman 595431 595431 together with Kune, William, of North Cave, yeoman 9
5228919 2424062 2424062 defendant del Hill William husbandman 595431 595431 del Hill, William, of North Cave, husbandman 10
5228920 2424062 2424062 defendant Wright Robert husbandman 595431 595431 Wright, Robert, of North Cave, husbandman 11
5228921 2424062 2424062 defendant Warner Thomas husbandman 595431 595431 Warner, Thomas, of North Cave, husbandman 12

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