names

44 rows where place_id = 607013

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667332 1915720 1915720 defendant Claghton William clothier 607013 607013 Claghton, William, of Pudsey, clothier 0
3673391 1917697 1917697 defendant Thakewray Robert yeoman 607013 607013 Thakewray, Robert, of Pudsey, yeoman 3
3703614 1927408 1927408 defendant Thornhill William husbandman 607013 607013 Thornhill, William, of Pudsey, husbandman 0
3722176 1933195 1933195 defendant Jenkynson Richard yeoman 607013 607013 Jenkynson, Richard, of Pudsey, yeoman 0
3722177 1933195 1933195 defendant Ferro William laborer 607013 607013 Ferro, William, of Pudsey, laborer 1
3722178 1933195 1933195 defendant Marsshall John tailor 607013 607013 Marsshall, John, of Pudsey, tailor 2
3722179 1933195 1933195 defendant Gaunt Richard husbandman 607013 607013 Gaunt, Richard, of Pudsey, husbandman 3
3722180 1933195 1933195 defendant Walker Richard husbandman 607013 607013 Walker, Richard, of Pudsey, husbandman 4
3749963 1941907 1941907 defendant Stede Thomas sherman 607013 607013 Stede, Thomas, of Pudsey, sherman 0
3749965 1941908 1941908 defendant Walcarre Robert husbandman 607013 607013 Walcarre, Robert, of Pudsey, husbandman 0
3749966 1941908 1941908 defendant Gaunt Richard laborer 607013 607013 Gaunt, Richard, of Pudsey, laborer 1
3749967 1941908 1941908 defendant Farre William laborer 607013 607013 Farre, William, of Pudsey, laborer 2
3811187 1961395 1961395 defendant Waterworth Robert cutler 607013 607013 Waterworth, Robert, of Pudsey, cutler 0
3817493 1963382 1963382 defendant Jenkynson Richard yeoman 607013 607013 Jenkynson, Richard, of Pudsey, yeoman 0
3956382 2009294 2009294 defendant Mylner John gent 607013 607013 Mylner, John, of Pudsey, gent 0
3971441 2014571 2014571 defendant Smythe Thomas husbandman 607013 607013 Smythe, Thomas, of Pudsey, husbandman 0
4000703 2025020 2025020 defendant Michell William husbandman 607013 607013 Michell, William, of Pudsey, husbandman 3
4003867 2026149 2026149 plaintiff Hunter William yeoman 607013 607013 Hunter, William, of Pudsey, yeoman 0
4071604 2050139 2050139 defendant Stansfeld Hugh yeoman 607013 607013 Stansfeld, Hugh, of Pudsey, yeoman 0
4145793 2076681 2076681 defendant Lumby William husbandman 607013 607013 Lumby, William, of Pudsey, husbandman 0
4145795 2076682 2076682 defendant Michell Peter laborer 607013 607013 Michell, Peter, of Pudsey, laborer 0
4154771 2079763 2079763 defendant Jenkynson James chapman 607013 607013 Jenkynson, James, of Pudsey, or of Fulsse, Yorks, chapman 0
4181719 2089087 2089087 defendant Hill Ralph clothier 607013 607013 Hill, Ralph, of Pudsey, clothier 2
4228485 2105447 2105447 defendant Gawnt John yeoman 607013 607013 Gawnt, John, of Pudsey, yeoman 0
4228486 2105447 2105447 defendant Hoile George yeoman 607013 607013 Hoile, George, of Pudsey, yeoman 1
4228487 2105447 2105447 defendant Jenkinson Richard yeoman 607013 607013 Jenkinson, Richard, of Pudsey, yeoman 2
4271712 2120120 2120120 defendant Hunter John yeoman 607013 607013 Hunter, John, of Pudsey, yeoman 0
4317972 2136397 2136397 defendant Hunter Richard yeoman 607013 607013 Hunter, Richard, of Pudsey, yeoman 1
4317973 2136397 2136397 defendant Hunter John yeoman 607013 607013 Hunter, John, of Pudsey, yeoman 2
4335463 2142133 2142133 defendant Hunter Richard yeoman 607013 607013 Hunter, Richard, of Pudsey, yeoman 0
4349810 2147192 2147192 defendant Hill William butcher 607013 607013 Hill, William, of Pudsey, butcher 0
4526483 2208565 2208565 defendant Symson John   607013 607013 Symson, John, of Pudsey 0
5023065 2363653 2363653 defendant Rotheley Thomas yeoman 607013 607013 Rotheley, Thomas, of Pudsey, yeoman 1
5023067 2363653 2363653 defendant Rotheley William husbandman 607013 607013 Rotheley, William, of Pudsey, husbandman 3
5023068 2363653 2363653 defendant Lumbe Simon yeoman 607013 607013 Lumbe, Simon, of Pudsey, yeoman 4
5106428 2388314 2388314 defendant Gybson John draper 607013 607013 Gybson, John, of Pudsey, draper 0
5310337 2448123 2448123 defendant Ley John husbandman 607013 607013 Ley, John, of Pudsey, husbandman 2
5431973 2484532 2484532 defendant Nethirwodde John smith 607013 607013 Nethirwodde, John, of Pudsey, smith 2
5448200 2489355 2489355 defendant Netherwode John smith 607013 607013 Netherwode, John, of Pudsey, smith 2
5448206 2489356 2489356 defendant Nethyrwode John smith 607013 607013 Nethyrwode, John, of Pudsey, smith 2
5479289 2498822 2498822 defendant Sympson William yeoman 607013 607013 Sympson, William, of Pudsey, yeoman 1
5479294 2498823 2498823 defendant Sympson William yeoman 607013 607013 Sympson, William, of Pudsey, yeoman 1
5542555 2517796 2517796 defendant Gibson William yeoman 607013 607013 Gibson, William, of Pudsey, yeoman 0
5542557 2517797 2517797 defendant Gibson William yeoman 607013 607013 Gibson, William, of Pudsey, yeoman 0

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