names

32 rows where place_id = 610362

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3683158 1920849 1920849 defendant Wygley Thomas husbandman 610362 610362 Wygley, Thomas, of Workesworth, husbandman 0
3894738 1988444 1988444 defendant Deane James yeoman 610362 610362 Deane, James, of Workesworth, yeoman 0
3908997 1993303 1993303 defendant Deane James yeoman 610362 610362 Deane, James, of Workesworth, yeoman 0
3928753 1999954 1999954 defendant Blount William yeoman 610362 610362 Blount, William, of Workesworth, yeoman 3
3967207 2013158 2013158 defendant Haryson Thomas yeoman 610362 610362 Haryson, Thomas, of Workesworth, yeoman 1
3972685 2015021 2015021 defendant Mason Robert husbandman 610362 610362 Mason, Robert, of Workesworth, husbandman 2
3977645 2016751 2016751 defendant Stere Robert yeoman 610362 610362 Stere, Robert, of Workesworth, yeoman 0
3977646 2016751 2016751 defendant Harryson Thomas yeoman 610362 610362 Harryson, Thomas, of Workesworth, yeoman 1
3990050 2021194 2021194 defendant Cantrell Thomas, junior yeoman 610362 610362 Cantrell, Thomas, junior, of Workesworth, yeoman 0
4050950 2042782 2042782 defendant Donyclyff William laborer 610362 610362 Donyclyff, William, of Workesworth, laborer 0
4050951 2042782 2042782 defendant Hall Thomas saddler 610362 610362 together with Hall, Thomas, of Workesworth, saddler 1
4050954 2042783 2042783 defendant Donyclyff William laborer 610362 610362 together with Donyclyff, William, of Workesworth, laborer 1
4056044 2044546 2044546 defendant Wygley John gent 610362 610362 Wygley, John, of Workesworth, gent 0
4061647 2046562 2046562 defendant Wigley John yeoman 610362 610362 Wigley, John, of Workesworth, yeoman 2
4069665 2049434 2049434 defendant Haryson Thomas yeoman 610362 610362 Haryson, Thomas, of Workesworth, yeoman 0
4097419 2059401 2059401 defendant Harryson Thomas yeoman 610362 610362 Harryson, Thomas, of Workesworth, yeoman 0
4097421 2059402 2059402 defendant Harryson Thomas yeoman 610362 610362 Harryson, Thomas, of Workesworth, yeoman 0
4141988 2075369 2075369 defendant Cantrell Thomas, junior butcher 610362 610362 Cantrell, Thomas, junior, of Workesworth, butcher 0
4145613 2076620 2076620 defendant Cantrell Thomas, senior butcher 610362 610362 Cantrell, Thomas, senior, of Workesworth, butcher 0
4145614 2076620 2076620 defendant Cantrell Thomas, junior butcher 610362 610362 Cantrell, Thomas, junior, of Workesworth, butcher 1
4170521 2085185 2085185 defendant Cantrell Thomas butcher 610362 610362 Cantrell, Thomas, of Workesworth, butcher 0
4192810 2093048 2093048 defendant Wygley John gent 610362 610362 Wygley, John, of Workesworth, gent 0
4214529 2100590 2100590 defendant Allen Edward yeoman 610362 610362 Allen, Edward, of Workesworth, or of Wattfyld, yeoman 0
4214530 2100590 2100590 defendant Walker William yeoman 610362 610362 Walker, William, of Workesworth, yeoman 1
4214531 2100590 2100590 defendant Allen Thomas yeoman 610362 610362 Allen, Thomas, of Workesworth, or of Alderoslee, yeoman 2
4221454 2102995 2102995 defendant Spendle Richard husbandman 610362 610362 Spendle, Richard, of Workesworth, husbandman 0
4221456 2102996 2102996 defendant Spendle Richard husbandman 610362 610362 Spendle, Richard, of Workesworth, husbandman 0
4322356 2137891 2137891 defendant Allen John husbandman 610362 610362 Allen, John, of Workesworth, or of Arrowsley, Derbs, husbandman 0
4375679 2156362 2156362 defendant Allen Edward yeoman 610362 610362 Allen, Edward, of Workesworth, or of Watfeild, yeoman 0
4400580 2164785 2164785 defendant More John husbandman 610362 610362 More, John, of Workesworth, husbandman 2
4817761 2301639 2301639 defendant atte Heye John husbandman 610362 610362 atte Heye, John, of Workesworth, husbandman 1
5384455 2470639 2470639 defendant Pereson John smith 610362 610362 Pereson, John, of Workesworth, smith 2

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