names

17 rows where case_id = 2532569

✎ 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
5592242 2532569 2532569 plaintiff Warcop Robert esq   Warcop, Robert, esq 0
5592243 2532569 2532569 defendant Berton Robert gent 903683 903683 Berton, Robert, of Hormeside, gent 0
5592244 2532569 2532569 defendant Berton William gent 903683 903683 Berton, William, of Hormeside, gent 1
5592245 2532569 2532569 defendant Cokden John yeoman 903683 903683 Cokden, John, of Hormeside, yeoman 2
5592246 2532569 2532569 defendant Walker Thomas husbandman 903683 903683 Walker, Thomas, of Hormeside, husbandman 3
5592247 2532569 2532569 defendant Lamberd William husbandman 903683 903683 Lamberd, William, of Hormeside, husbandman 4
5592248 2532569 2532569 defendant Robynson John husbandman 665160 665160 Robynson, John, of Sandfurth, husbandman 5
5592249 2532569 2532569 defendant Bolland Robert husbandman 665160 665160 Bolland, Robert, of Sandfurth, husbandman 6
5592250 2532569 2532569 defendant Scayff Roland yeoman 903684 903684 Scayff, Roland, of Assby Graunge, yeoman 7
5592251 2532569 2532569 defendant Colleyn John husbandman 815701 815701 Colleyn, John, of Parva Musgrave, husbandman 8
5592252 2532569 2532569 defendant Bete Thomas husbandman 815701 815701 Bete, Thomas, of Parva Musgrave, husbandman 9
5592253 2532569 2532569 defendant Baily William husbandman 815701 815701 Baily, William, of Parva Musgrave, husbandman 10
5592254 2532569 2532569 defendant Robynson Richard husbandman 612970 612970 Robynson, Richard, of Blatern, husbandman 11
5592255 2532569 2532569 defendant Hugill Joan widow 903685 903685 Hugill, Joan, of Plilan, widow 12
5592256 2532569 2532569 defendant Martyndale William laborer 903686 903686 Martyndale, William, of Plulan, laborer 13
5592257 2532569 2532569 defendant Flek John husbandman 589876 589876 Flek, John, of Branton, husbandman 14
5592258 2532569 2532569 defendant Robynson Alexander husbandman 589876 589876 Robynson, Alexander, of Branton, husbandman 15

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