names

39 rows where place_id = 596411

✎ 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
3624651 1875244 1875244 defendant Hunte John husbandman 596411 596411 Hunte, John, of Feckenham, husbandman 0
3913188 1994744 1994744 defendant Jarryson Simon tailor 596411 596411 Jarryson, Simon, of Feckenham, tailor 0
3968343 2013560 2013560 plaintiff Checkett Robert laborer 596411 596411 Checkett, Robert, of Feckenham, laborer 0
3968344 2013560 2013560 defendant Overton Edward husbandman 596411 596411 Overton, Edward, of Feckenham, husbandman 0
3968345 2013560 2013560 defendant Homan Michael husbandman 596411 596411 Homan, Michael, of Feckenham, husbandman 1
3991715 2021794 2021794 defendant Pylkynton Thomas smith 596411 596411 Pylkynton, Thomas, of Feckenham, smith 2
3997061 2023717 2023717 defendant Hobday Robert husbandman 596411 596411 Hobday, Robert, of Feckenham, husbandman 1
4048857 2042035 2042035 plaintiff Toll Henry yeoman 596411 596411 Toll, Henry, of Feckenham, yeoman 0
4051149 2042849 2042849 defendant Rutter Gilbert shoemaker 596411 596411 Rutter, Gilbert, of Feckenham, shoemaker 0
4051154 2042850 2042850 defendant Rutter Gilbert shoemaker 596411 596411 Rutter, Gilbert, of Feckenham, shoemaker 0
4067643 2048740 2048740 defendant Bolton John husbandman 596411 596411 Bolton, John, of Feckenham, husbandman 0
4081354 2053638 2053638 defendant Barcrofte Francis husbandman 596411 596411 Barcrofte, Francis, of Feckenham, husbandman 2
4091409 2057216 2057216 defendant Burton John carpenter 596411 596411 Burton, John, of Feckenham, carpenter 1
4091410 2057216 2057216 defendant Barcrofte Francis yeoman 596411 596411 Barcrofte, Francis, of Feckenham, yeoman 2
4144530 2076246 2076246 defendant Bounde John husbandman 596411 596411 Bounde, John, of Feckenham, husbandman 1
4145587 2076611 2076611 defendant Barcrofte Francis husbandman 596411 596411 Barcrofte, Francis, of Feckenham, husbandman 0
4149025 2077777 2077777 defendant Bonde John, senior yeoman 596411 596411 Bonde, John, senior, of Feckenham, yeoman 0
4230906 2106308 2106308 defendant Clerke John yeoman 596411 596411 Clerke, John, of Feckenham, yeoman 0
4233847 2107364 2107364 defendant Moyer Francis husbandman 596411 596411 Moyer, Francis, of Feckenham, husbandman 2
4284043 2124337 2124337 defendant Clerke John yeoman 596411 596411 Clerke, John, of Feckenham, yeoman 0
4285844 2124989 2124989 defendant Clarke John yeoman 596411 596411 Clarke, John, of Feckenham, yeoman 0
4326289 2139158 2139158 defendant Clerke John yeoman 596411 596411 Clerke, John, of Feckenham, yeoman 1
4326290 2139158 2139158 defendant Clerke Thomas chandler 596411 596411 Clerke, Thomas, of Feckenham, chandler 2
4326295 2139159 2139159 defendant Mascolde John yeoman 596411 596411 Mascolde, John, of Feckenham, yeoman 3
4326299 2139160 2139160 defendant Clerke John yeoman 596411 596411 Clerke, John, of Feckenham, yeoman 2
4339205 2143474 2143474 defendant Clarke John yeoman 596411 596411 Clarke, John, of Feckenham, yeoman 0
4362382 2151598 2151598 defendant Bonde John husbandman 596411 596411 Bonde, John, of Feckenham, husbandman 0
4390493 2161442 2161442 defendant Hanburye Walter gent 596411 596411 Hanburye, Walter, of Feckenham, gent 0
4390512 2161448 2161448 defendant Aston Robert yeoman 596411 596411 Aston, Robert, of Feckenham, yeoman 0
4390513 2161448 2161448 defendant Wyllys Ralph yeoman 596411 596411 Wyllys, Ralph, of Feckenham, yeoman 1
4390520 2161450 2161450 defendant Clarke Thomas chandler 596411 596411 Clarke, Thomas, of Feckenham, chandler 1
4396147 2163282 2163282 defendant Hand Roger husbandman 596411 596411 Hand, Roger, of Feckenham, husbandman 0
4396402 2163371 2163371 defendant Parker alias Torner Thomas yeoman 596411 596411 Parker alias Torner, Thomas, of Feckenham, or of Canbe, Staffs, yeoman 0
4397187 2163633 2163633 defendant Bonde John yeoman 596411 596411 Bonde, John, of Feckenham, yeoman 0
4397189 2163634 2163634 defendant Foster William miller 596411 596411 Foster, William, of Feckenham, yeoman, miller 0
4407887 2167204 2167204 defendant Clerke John yeoman 596411 596411 Clerke, John, of Feckenham, yeoman 0
4542859 2213656 2213656 defendant Dobyne Thomas   596411 596411 Dobyne, Thomas, of Feckenham 0
4763438 2284551 2284551 defendant Love Edmund husbandman 596411 596411 Love, Edmund, of Feckenham, husbandman 5
5617826 2549390 2549390 defendant atte Lone or Love Simon   596411 596411 atte Lone or Love, Simon, of Feckenham 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);