names

58 rows where place_id = 632200

✎ 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
3805277 1959595 1959595 defendant Nicolles John yeoman 632200 632200 Nicolles, John, of Wakefelde, yeoman 2
3891296 1987355 1987355 defendant Oxenfelde John clothman 632200 632200 Oxenfelde, John, of Wakefelde, clothman 1
3931649 2000881 2000881 defendant Kay Robert yeoman 632200 632200 Kay, Robert, of Wakefelde, yeoman 0
3965970 2012717 2012717 plaintiff Blackborne John chapman 632200 632200 Blackborne, John, of Wakefelde, chapman 0
3965971 2012717 2012717 defendant Cocke alias Callyce Thomas yeoman 632200 632200 Cocke alias Callyce, Thomas, of Wakefelde, yeoman 0
3965972 2012718 2012718 plaintiff Blackborne John chapman 632200 632200 Blackborne, John, of Wakefelde, chapman 0
3965973 2012718 2012718 defendant Michell Nicholas mercer 632200 632200 Michell, Nicholas, of Wakefelde, mercer 0
3968174 2013495 2013495 defendant Bromeheade William tailor 632200 632200 Bromeheade, William, of Wakefelde, tailor 1
3976097 2016209 2016209 plaintiff Jobson alias Blak Alan chapman 632200 632200 Jobson alias Blak, Alan, of Wakefelde, chapman 0
3976099 2016209 2016209 defendant Bonnye John dyer 632200 632200 Bonnye, John, of Wakefelde, yeoman, dyer 1
3978811 2017168 2017168 defendant Michell Nicholas merchant 632200 632200 Michell, Nicholas, of Wakefelde, merchant 0
3982477 2018508 2018508 defendant Bavoyt Richard yeoman 632200 632200 Bavoyt, Richard, of Wakefelde, yeoman 0
3989448 2020964 2020964 defendant Jackson Roland gent 632200 632200 Jackson, Roland, of Wakefelde, gent 0
3993387 2022375 2022375 defendant Grayeslocke Thomas yeoman 632200 632200 Grayeslocke, Thomas, of Wakefelde, yeoman 3
4002825 2025777 2025777 defendant Fyssher George shoemaker 632200 632200 Fyssher, George, of Wakefelde, shoemaker 0
4002826 2025777 2025777 defendant Kaye Robert innholder 632200 632200 Kaye, Robert, of Wakefelde, innholder 1
4010840 2028652 2028652 plaintiff Pecke Nicholas gent 632200 632200 Pecke, Nicholas, of Wakefelde, gent 0
4010843 2028653 2028653 plaintiff Pecke Nicholas gent 632200 632200 Pecke, Nicholas, of Wakefelde, gent 0
4014149 2029789 2029789 defendant Blackburne John draper 632200 632200 Blackburne, John, of Wakefelde, draper 0
4046628 2041247 2041247 plaintiff Smyth Robert draper 632200 632200 Smyth, Robert, of Wakefelde, draper 0
4049978 2042422 2042422 defendant Kaye Robert, junior yeoman 632200 632200 Kaye, Robert, junior, of Wakefelde, yeoman 0
4058207 2045317 2045317 defendant Wharton Thomas mercer 632200 632200 Wharton, Thomas, of Wakefelde, mercer 1
4066119 2048171 2048171 defendant Hynde William shoemaker 632200 632200 Hynde, William, of Wakefelde, shoemaker 0
4068073 2048887 2048887 defendant Prynce John laborer 632200 632200 Prynce, John, of Wakefelde, laborer 1
4068074 2048887 2048887 defendant Grene John laborer 632200 632200 Grene, John, of Wakefelde, laborer 2
4068075 2048887 2048887 defendant Andrewe Richard laborer 632200 632200 Andrewe, Richard, of Wakefelde, laborer 3
4071969 2050273 2050273 plaintiff Noble Alan chapman 632200 632200 Noble, Alan, of Wakefelde, chapman 0
4077833 2052371 2052371 defendant Jopson Thomas gent 632200 632200 Jopson, Thomas, of Wakefelde, gent 0
4091727 2057331 2057331 plaintiff Dawson John yeoman 632200 632200 Dawson, John, of Wakefelde, yeoman 0
4099920 2060299 2060299 defendant Roodes James yeoman 632200 632200 Roodes, James, of Wakefelde, yeoman 1
4106051 2062455 2062455 defendant Loggayne or Logan John merchant 632200 632200 Loggayne or Logan, John, of Wakefelde, or of Kingston on Hull, merchant 0
4110994 2064181 2064181 defendant Hearde Robert draper 632200 632200 Hearde, Robert, of Wakefelde, draper 1
4110996 2064181 2064181 defendant Wharton Thomas vintner 632200 632200 Wharton, Thomas, of Wakefelde, vintner 3
4123423 2068680 2068680 defendant Spencer Richard hardwareman 632200 632200 Spencer, Richard, of Wakefelde, cutler, or of Woodstocke, Oxon, hardwareman 0
4126869 2069902 2069902 defendant Benson John yeoman 632200 632200 Benson, John, of Wakefelde, yeoman 3
4144213 2076135 2076135 defendant Smythe Randolph drover 632200 632200 Smythe, Randolph, of Wakefelde, or of Salcotte Furley, Essex, drover 0
4144214 2076135 2076135 defendant Bateson Richard innholder 632200 632200 Bateson, Richard, of Wakefelde, or of Mulsham, Chelmesford, Essex, innholder 1
4144215 2076135 2076135 defendant Wylkyn Richard yeoman 632200 632200 Wylkyn, Richard, of Wakefelde, or of Abridge, Lamborne, Essex, yeoman 2
4144476 2076230 2076230 defendant Bossevyle William gent 632200 632200 Bossevyle, William, of Wakefelde, or of Elton, Notts, gent 0
4149696 2078018 2078018 defendant Chewe William nailer 632200 632200 Chewe, William, of Wakefelde, laborer, or of Atherton, Lancs, nailer 0
4149697 2078018 2078018 defendant Hyndley William nailer 632200 632200 Hyndley, William, of Wakefelde, laborer, or of Atherton, nailer 1
4150838 2078426 2078426 defendant Wilkynson Robert yeoman 632200 632200 Wilkynson, Robert, of Wakefelde, yeoman 0
4154037 2079505 2079505 defendant Howse James   632200 632200 Howse, James, of Wakefelde, or of Watton, Norf, woollen draper 0
4154039 2079505 2079505 defendant Thirston Robert draper 632200 632200 Thirston, Robert, of Wakefelde, or of Wysbytche, Cams, draper 2
4154040 2079505 2079505 defendant Fawcette Henry saddler 632200 632200 Fawcette, Henry, of Wakefelde, or of Wysbytche, saddler 3
4155996 2080172 2080172 defendant Morgan Thomas draper 632200 632200 Morgan, Thomas, of Wakefelde, or of Rowell, Nhants, draper 0
4161197 2081994 2081994 defendant Higgine John yeoman 632200 632200 Higgine, John, of Wakefelde, yeoman 0
4161778 2082187 2082187 defendant Fairefote John clothier 632200 632200 Fairefote, John, of Wakefelde, clothier 0
4164278 2083028 2083028 defendant Hamer Ralph husbandman 632200 632200 Hamer, Ralph, of Wakefelde, or of Rachdale, Lancs, husbandman 0
4164279 2083028 2083028 defendant Howorthe James husbandman 632200 632200 Howorthe, James, of Wakefelde, or of Rachdale, husbandman 1
4165171 2083329 2083329 defendant Lumme Brian innholder 632200 632200 Lumme, Brian, of Wakefelde, innholder 0
4176933 2087404 2087404 defendant Milne William husbandman 632200 632200 Milne, William, of Wakefelde, or of Steede, Lancs, husbandman 0
4223626 2103752 2103752 defendant Northen William yeoman 632200 632200 Northen, William, of Wakefelde, shear grinder, yeoman 0
4280684 2123147 2123147 defendant Lawryman Robert smith 632200 632200 Lawryman, Robert, of Wakefelde, smith 0
4895921 2325389 2325389 defendant Litster Richard chapman 632200 632200 Litster, Richard, of Wakefelde, chapman 0
5072267 2378194 2378194 defendant Payntour Thomas husbandman 632200 632200 Payntour, Thomas, of Wakefelde, husbandman 0
5563921 2524059 2524059 defendant Whithill Edmund sherman 632200 632200 Whithill, Edmund, of Wakefelde, sherman 0
5563922 2524059 2524059 defendant Wade William weaver 632200 632200 Wade, William, of Wakefelde, weaver 1

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