names

30 rows where case_id = 2388830

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5108181 2388830 2388830 plaintiff Eure William knight   Eure, William, knight 0
5108182 2388830 2388830 defendant Morlay Roger yeoman 589591 589591 Morlay, Roger, of Rykhall, yeoman 0
5108183 2388830 2388830 defendant Lathom Thomas husbandman 589591 589591 Lathom, Thomas, of Rykhall, husbandman 1
5108184 2388830 2388830 defendant Smythbarn Thomas weaver 589591 589591 Smythbarn, Thomas, of Rykhall, weaver 2
5108185 2388830 2388830 defendant Hawes Thomas husbandman 589591 589591 Hawes, Thomas, of Rykhall, husbandman 3
5108186 2388830 2388830 defendant Thomson Robert husbandman 589591 589591 Thomson, Robert, of Rykhall, husbandman 4
5108187 2388830 2388830 defendant Davy William husbandman 589591 589591 Davy, William, of Rykhall, husbandman 5
5108188 2388830 2388830 defendant Claybruke Robert husbandman 589591 589591 Claybruke, Robert, of Rykhall, husbandman 6
5108189 2388830 2388830 defendant Redes Robert husbandman 589591 589591 Redes, Robert, of Rykhall, husbandman 7
5108190 2388830 2388830 defendant Chyldyong John cordwainer 589591 589591 Chyldyong, John, of Rykhall, cordwainer 8
5108191 2388830 2388830 defendant Lang Hugh tailor 589591 589591 Lang, Hugh, of Rykhall, tailor 9
5108192 2388830 2388830 defendant Gyve Robert chandler 589591 589591 Gyve, Robert, of Rykhall, chandler 10
5108193 2388830 2388830 defendant Merfeld Thomas cordwainer 589591 589591 Merfeld, Thomas, of Rykhall, cordwainer 11
5108194 2388830 2388830 defendant Selby John husbandman 589591 589591 Selby, John, of Rykhall, husbandman 12
5108195 2388830 2388830 defendant Selby Richrd husbandman 589591 589591 Selby, Richrd, of Rykhall, husbandman 13
5108196 2388830 2388830 defendant Hemper William weaver 589591 589591 Hemper, William, of Rykhall, weaver 14
5108197 2388830 2388830 defendant Potage Thomas husbandman 589591 589591 Potage, Thomas, of Rykhall, husbandman 15
5108198 2388830 2388830 defendant Potage John husbandman 589591 589591 Potage, John, of Rykhall, husbandman 16
5108199 2388830 2388830 defendant Potage William husbandman 589591 589591 Potage, William, of Rykhall, husbandman 17
5108200 2388830 2388830 defendant Childerlowe John husbandman 589591 589591 Childerlowe, John, of Rykhall, husbandman 18
5108201 2388830 2388830 defendant Laverok William husbandman 589591 589591 Laverok, William, of Rykhall, husbandman 19
5108202 2388830 2388830 defendant Harpham William barker 589591 589591 Harpham, William, of Rykhall, barker 20
5108203 2388830 2388830 defendant Malynson John husbandman 589591 589591 Malynson, John, of Rykhall, husbandman 21
5108204 2388830 2388830 defendant Malynson Robert     Malynson, Robert 22
5108205 2388830 2388830 defendant of Rykhall   husbandman   of Rykhall, husbandman 23
5108206 2388830 2388830 defendant Lare John   589591 589591 Lare, John, of Rykhall, cartwright 24
5108207 2388830 2388830 defendant Esyngwall Thomas weaver 589591 589591 Esyngwall, Thomas, of Rykhall, weaver 25
5108208 2388830 2388830 defendant Rughford William husbandman 589591 589591 Rughford, William, of Rykhall, husbandman 26
5108209 2388830 2388830 defendant Gaunt Thomas laborer 589591 589591 Gaunt, Thomas, of Rykhall, laborer 27
5108210 2388830 2388830 defendant Chapman John husbandman 589591 589591 Chapman, John, of Rykhall, husbandman 28

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