names

18 rows where case_id = 2462596

✎ 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
5358078 2462596 2462596 plaintiff Page Richard     Page, Richard 0
5358079 2462596 2462596 defendant Bolyngton John clerk 590873 590873 Bolyngton, John, of Normanton, clerk 0
5358080 2462596 2462596 defendant Revell Robert yeoman 590026 590026 Revell, Robert, of Higham, yeoman 1
5358081 2462596 2462596 defendant Revell Hugh yeoman 639667 639667 Revell, Hugh, of Shirland, yeoman 2
5358082 2462596 2462596 defendant Bolyngton Thomas yeoman 639667 639667 Bolyngton, Thomas, of Shirland, yeoman 3
5358083 2462596 2462596 defendant Mes Thomas yeoman 590026 590026 Mes, Thomas, of Higham, yeoman 4
5358084 2462596 2462596 defendant Andrewe Robert   877258 877258 Andrewe, Robert, of Higham, bloomsmith 5
5358085 2462596 2462596 defendant Lane Robert husbandman 590026 590026 Lane, Robert, of Higham, husbandman 6
5358086 2462596 2462596 defendant Deen Thomas laborer 877259 877259 Deen, Thomas, of Shipland, laborer 7
5358087 2462596 2462596 defendant Wheleman Richard weaver 590026 590026 Wheleman, Richard, of Higham, weaver 8
5358088 2462596 2462596 defendant Milner William laborer 590026 590026 Milner, William, of Higham, laborer 9
5358089 2462596 2462596 defendant Bothom John of Whetebarowe yeoman   Bothom, John of Whetebarowe, yeoman 10
5358090 2462596 2462596 defendant Gascoigne Thomas laborer 592772 592772 Gascoigne, Thomas, of Hugham, laborer 11
5358091 2462596 2462596 defendant Peek Robert shoemaker 590026 590026 Peek, Robert, of Higham, shoemaker 12
5358092 2462596 2462596 defendant Sydall Robert laborer 877260 877260 Sydall, Robert, of Leforthe, North Wynfeld, laborer 13
5358093 2462596 2462596 defendant Stele John laborer 590026 590026 Stele, John, of Higham, laborer 14
5358094 2462596 2462596 defendant Peek Thomas shoemaker 590026 590026 Peek, Thomas, of Higham, shoemaker 15
5358095 2462596 2462596 defendant Derwent Richard tailor 590026 590026 Derwent, Richard, of Higham, tailor 16

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