names

17 rows where case_id = 2433452

✎ 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
5260608 2433452 2433452 plaintiff Leukenore Roger knight   Leukenore, Roger, knight 0
5260609 2433452 2433452 defendant Sayer Richard mercer 621884 621884 Sayer, Richard, of Lyndefeld, mercer 0
5260610 2433452 2433452 defendant Underhill Thomas butcher 621884 621884 Underhill, Thomas, of Lyndefeld, butcher 1
5260611 2433452 2433452 defendant Potter William smith 621884 621884 Potter, William, of Lyndefeld, smith 2
5260612 2433452 2433452 defendant Gere Richard weaver 621884 621884 Gere, Richard, of Lyndefeld, weaver 3
5260613 2433452 2433452 defendant Gere Tomas fuller 621884 621884 Gere, Tomas, of Lyndefeld, fuller 4
5260614 2433452 2433452 defendant Warde Robert tailor 585869 585869 Warde, Robert, of London, tailor 5
5260615 2433452 2433452 defendant Newenham Richard husbandman 598464 598464 Newenham, Richard, of Erdyngton, husbandman 6
5260616 2433452 2433452 defendant Kynge John, senior husbandman 621884 621884 Kynge, John, senior, of Lyndefeld, husbandman 7
5260617 2433452 2433452 defendant Kynge John, junior   621884 621884 Kynge, John, junior, of Lyndefeld, groom 8
5260618 2433452 2433452 defendant Atherstede John tanner 609737 609737 Atherstede, John, of Wyvelesfeld, tanner 9
5260619 2433452 2433452 defendant Penyfold Richard weaver 865388 865388 Penyfold, Richard, of Masefeld, weaver 10
5260620 2433452 2433452 defendant Basshe Peter glover 886186 886186 Basshe, Peter, of Notley, glover 11
5260621 2433452 2433452 defendant Attre John laborer 609737 609737 Attre, John, of Wyvelesfeld, laborer 12
5260622 2433452 2433452 defendant Constoke William panier maker 865388 865388 Constoke, William, of Masefeld, panier maker 13
5260623 2433452 2433452 defendant Parys Thomas miller 588259 588259 Parys, Thomas, of Flecchyng, miller 14
5260624 2433452 2433452 defendant Acok Richsard husbandman 588259 588259 Acok, Richsard, of Flecchyng, 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);