names

34 rows where place_id = 589591

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598082 1867027 1867027 defendant Dudman John yeoman 589591 589591 Dudman, John, of Rykhall, yeoman 1
5108177 2388829 2388829 defendant Morlay Roger yeoman 589591 589591 Morlay, Roger, of Rykhall, yeoman 0
5108178 2388829 2388829 defendant Bolton John yeoman 589591 589591 Bolton, John, of Rykhall, yeoman 1
5108179 2388829 2388829 defendant Malynson John husbandman 589591 589591 Malynson, John, of Rykhall, husbandman 2
5108180 2388829 2388829 defendant Malynson Robert husbandman 589591 589591 Malynson, Robert, of Rykhall, husbandman 3
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
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
5145740 2399898 2399898 defendant Clerk John shoemaker 589591 589591 Clerk, John, of Rykhall, shoemaker 3
5343033 2458007 2458007 defendant Chapman John husbandman 589591 589591 Chapman, John, of Rykhall, husbandman 4

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