names

13 rows where case_id = 2390041

✎ 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
5112500 2390041 2390041 plaintiff Ingelby Joan widow of Ingelby, William, knight   Ingelby, Joan, widow of Ingelby, William, knight 0
5112501 2390041 2390041 defendant Aungevyn Charles gent 847778 847778 Aungevyn, Charles, of Calthorp juxta Covenham, gent 0
5112502 2390041 2390041 defendant Pykard Richard yeoman 847778 847778 together with Pykard, Richard, of Calthorp juxta Covenham, yeoman 1
5112503 2390041 2390041 defendant Pykard Christopher yeoman 847778 847778 Pykard, Christopher, of Calthorp juxta Covenham, yeoman 2
5112504 2390041 2390041 defendant Palmer Stephen yeoman 611344 611344 Palmer, Stephen, of Alvyngham, yeoman 3
5112505 2390041 2390041 defendant Dey William shoemaker 589461 589461 Dey, William, of Louthe, shoemaker 4
5112506 2390041 2390041 defendant Tikesbery John tailor 589461 589461 Tikesbery, John, of Louthe, tailor 5
5112507 2390041 2390041 defendant Pykhaver William shoemaker 589461 589461 Pykhaver, William, of Louthe, shoemaker 6
5112508 2390041 2390041 defendant Glasyer John glasier 589461 589461 Glasyer, John, of Louthe, glasier 7
5112509 2390041 2390041 defendant Ireland John husbandman 650415 650415 Ireland, John, of Parva Grymesby, husbandman 8
5112510 2390041 2390041 defendant Eman Richard yeoman 614280 614280 Eman, Richard, of Utterby, yeoman 9
5112511 2390041 2390041 defendant Lyncolne William husbandman 847779 847779 Lyncolne, William, of North Ormesby, husbandman 10
5112512 2390041 2390041 defendant Dent Henry   606113 606113 Dent, Henry, of Covenham, wright 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);