names

34 rows where place_id = 601712

✎ 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
3646659 1909359 1909359 defendant Cullyer John, junior fisher 601712 601712 Cullyer, John, junior, of Tofte, fisher 1
3646660 1909359 1909359 defendant Busterd John, junior fisher 601712 601712 Busterd, John, junior, of Tofte, fisher 2
3646661 1909359 1909359 defendant Westmylls John fisher 601712 601712 Westmylls, John, of Tofte, fisher 3
3646662 1909359 1909359 defendant Baker Richard fisher 601712 601712 Baker, Richard, of Tofte, fisher 4
3682337 1920576 1920576 defendant Jakson Thomas, senior husbandman 601712 601712 Jakson, Thomas, senior, of Tofte, husbandman 0
3706190 1928223 1928223 defendant Basley George husbandman 601712 601712 Basley, George, of Tofte, husbandman 2
3837518 1969642 1969642 defendant Wykkys Robert husbandman 601712 601712 Wykkys, Robert, of Tofte, husbandman 2
3917422 1996185 1996185 defendant Andrewes John miller 601712 601712 Andrewes, John, of Tofte, miller 0
3943557 2004864 2004864 defendant Armiger Peter smith 601712 601712 Armiger, Peter, of Tofte, smith 0
4005029 2026583 2026583 plaintiff Kegell Robert yeoman 601712 601712 Kegell, Robert, of Tofte, yeoman 0
4011358 2028838 2028838 plaintiff Pirry or Pere John yeoman 601712 601712 Pirry or Pere, John, of Tofte, yeoman 0
4038637 2038458 2038458 plaintiff Leicester Ralph (legal representative) 601712 601712 Leicester, Ralph, of Tofte, knight, executor of 0
4038641 2038459 2038459 plaintiff Leicester Richard (legal representative) 601712 601712 Leicester, Richard, of Tofte, knight, executor of 0
4066581 2048342 2048342 defendant Goodwyn Thomas yeoman 601712 601712 Goodwyn, Thomas, of Tofte, yeoman 0
4078282 2052533 2052533 defendant Leake William husbandman 601712 601712 Leake, William, of Tofte, husbandman 3
4277332 2121995 2121995 defendant Yates William gent 601712 601712 Yates, William, of Tofte, gent 3
4374303 2155879 2155879 defendant Yates William yeoman 601712 601712 Yates, William, of Tofte, yeoman 2
4386218 2160070 2160070 defendant Bradshawe James gent 601712 601712 Bradshawe, James, of Tofte, gent 1
4518716 2206229 2206229 defendant Dorset John   601712 601712 Dorset, John, of Tofte 0
4702256 2266114 2266114 defendant Draper Thomas husbandman 601712 601712 Draper, Thomas, of Tofte, husbandman 0
4860915 2314772 2314772 defendant Basely Thomas husbandman 601712 601712 Basely, Thomas, of Tofte, husbandman 0
4932059 2336420 2336420 defendant Bernard Nicholas husbandman 601712 601712 Bernard, Nicholas, of Tofte, husbandman 0
4935548 2337512 2337512 defendant May Alexander laborer 601712 601712 May, Alexander, of Tofte, laborer 4
4956398 2343877 2343877 defendant Bernard Nicholas yeoman 601712 601712 Bernard, Nicholas, of Tofte, yeoman 1
5057029 2373681 2373681 defendant Claymond Roger, junior   601712 601712 Claymond, Roger, junior, of Tofte 3
5107861 2388736 2388736 defendant May Alexander husbandman 601712 601712 May, Alexander, of Tofte, husbandman 3
5107867 2388737 2388737 defendant May Alexander husbandman 601712 601712 May, Alexander, of Tofte, husbandman 3
5237233 2426473 2426473 defendant Pakke John husbandman 601712 601712 Pakke, John, of Tofte, husbandman 3
5291868 2442626 2442626 defendant Stroud James yeoman 601712 601712 Stroud, James, of Tofte, yeoman 4
5424755 2482362 2482362 defendant Neuman John yeoman 601712 601712 Neuman, John, of Tofte, yeoman 2
5456201 2491768 2491768 defendant Neuman John yeoman 601712 601712 Neuman, John, of Tofte, yeoman 1
5507668 2507302 2507302 defendant Walnot Robert husbandman 601712 601712 Walnot, Robert, of Tofte, husbandman 1
5556133 2521789 2521789 plaintiff Badley John   601712 601712 (Badley, John, of Tofte 1
5556139 2521790 2521790 plaintiff Badley John   601712 601712 (Badley, John, of Tofte 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);