names

53 rows where place_id = 591071

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603230 1868679 1868679 defendant Sparke John carpenter 591071 591071 Sparke, John, of Hokwold, carpenter 0
3625725 1875584 1875584 defendant Hadderwyke William husbandman 591071 591071 Hadderwyke, William, of Hokwold, husbandman 0
3625762 1875596 1875596 defendant Chesylton John husbandman 591071 591071 Chesylton, John, of Hokwold, husbandman 0
3625763 1875596 1875596 defendant Hoke William husbandman 591071 591071 Hoke, William, of Hokwold, husbandman 1
3626898 1903264 1903264 defendant Drynkmylke Thomas husbandman 591071 591071 Drynkmylke, Thomas, of Hokwold, husbandman 1
3626899 1903264 1903264 defendant Smyth Edmund husbandman 591071 591071 Smyth, Edmund, of Hokwold, husbandman 2
3626900 1903264 1903264 defendant Style William husbandman 591071 591071 Style, William, of Hokwold, husbandman 3
3637868 1906661 1906661 defendant Lambe Thomas husbandman 591071 591071 Lambe, Thomas, of Hokwold, husbandman 0
3637870 1906661 1906661 defendant Drynkemylke Thomas husbandman 591071 591071 Drynkemylke, Thomas, of Hokwold, husbandman 2
3637871 1906661 1906661 defendant Dykeman John husbandman 591071 591071 Dykeman, John, of Hokwold, husbandman 3
3637872 1906661 1906661 defendant Dykeman Mathew husbandman 591071 591071 Dykeman, Mathew, of Hokwold, husbandman 4
3637874 1906661 1906661 defendant Style John husbandman 591071 591071 Style, John, of Hokwold, husbandman 6
3637875 1906661 1906661 defendant Brese Thomas tailor 591071 591071 Brese, Thomas, of Hokwold, tailor 7
3637877 1906662 1906662 defendant Lambe Thomas husbandman 591071 591071 Lambe, Thomas, of Hokwold, husbandman 0
3637879 1906662 1906662 defendant Drynkemylke Thomas husbandman 591071 591071 Drynkemylke, Thomas, of Hokwold, husbandman 2
3637880 1906662 1906662 defendant Dykeman John husbandman 591071 591071 Dykeman, John, of Hokwold, husbandman 3
3637881 1906662 1906662 defendant Dykeman Mathew husbandman 591071 591071 Dykeman, Mathew, of Hokwold, husbandman 4
3637882 1906662 1906662 defendant Style John husbandman 591071 591071 Style, John, of Hokwold, husbandman 5
3637883 1906662 1906662 defendant Brese Thomas tailor 591071 591071 Brese, Thomas, of Hokwold, tailor 6
3659008 1913081 1913081 defendant at Mere Robert husbandman 591071 591071 at Mere, Robert, of Hokwold, husbandman 1
3661008 1913717 1913717 defendant Mathewe Philip yeoman 591071 591071 Mathewe, Philip, of Hokwold, yeoman 0
3666020 1915309 1915309 defendant at Mere Robert husbandman 591071 591071 at Mere, Robert, of Hokwold, husbandman 0
3703747 1927451 1927451 defendant Dykman John husbandman 591071 591071 Dykman, John, of Hokwold, husbandman 0
3756528 1944018 1944018 defendant Steveson Ralph husbandman 591071 591071 Steveson, Ralph, of Hokwold, husbandman 1
3760958 1945433 1945433 defendant Dykman John   591071 591071 Dykman, John, of Hokwold, parish clerk 2
3797749 1957194 1957194 defendant Dowe Christopher yeoman 591071 591071 Dowe, Christopher, of Hokwold, yeoman 0
3797750 1957194 1957194 defendant Houghton Thomas clerk 591071 591071 Houghton, Thomas, of Hokwold, clerk 1
3797751 1957194 1957194 defendant Mathewe Philip husbandman 591071 591071 Mathewe, Philip, of Hokwold, husbandman 2
3801780 1958453 1958453 defendant Tendale Thomas esq 591071 591071 Tendale, Thomas, of Hokwold, esq 0
3801781 1958453 1958453 defendant Houghton Thomas chaplain 591071 591071 Houghton, Thomas, of Hokwold, chaplain 1
3801782 1958453 1958453 defendant Dowe Christopher husbandman 591071 591071 Dowe, Christopher, of Hokwold, husbandman 2
3801783 1958453 1958453 defendant Mathewe John husbandman 591071 591071 Mathewe, John, of Hokwold, husbandman 3
3808263 1960458 1960458 defendant Tyllour Ralph gent 591071 591071 Tyllour, Ralph, of Hokwold, gent 0
3834481 1968730 1968730 defendant Tendale John esq 591071 591071 Tendale, John, of Hokwold, esq 0
3834482 1968730 1968730 defendant Tendale Thomas esq 591071 591071 Tendale, Thomas, of Hokwold, esq 1
3834483 1968730 1968730 defendant Houghton Thomas chaplain 591071 591071 Houghton, Thomas, of Hokwold, chaplain 2
3847734 1972863 1972863 defendant Bull John gent 591071 591071 Bull, John, of Hokwold, gent 0
3912817 1994619 1994619 defendant Lincoln Thomas husbandman 591071 591071 Lincoln, Thomas, of Hokwold, husbandman 0
3918303 1996458 1996458 defendant Dykman Peter husbandman 591071 591071 Dykman, Peter, of Hokwold, husbandman 0
3925021 1998685 1998685 defendant Tyndall Thomas esq 591071 591071 Tyndall, Thomas, of Hokwold, esq 0
4893541 2324681 2324681 defendant Coke John husbandman 591071 591071 Coke, John, of Hokwold, husbandman 0
4930184 2335845 2335845 defendant Troys Thomas husbandman 591071 591071 Troys, Thomas, of Hokwold, husbandman 0
5076963 2379608 2379608 defendant Aleyn John (legal representative) 591071 591071 Aleyn, John, of Hokwold, gent, executors of 0
5076965 2379608 2379608 defendant Styward Thomas husbandman 591071 591071 together with Styward, Thomas, of Hokwold, husbandman 2
5076969 2379609 2379609 defendant Aleyn John (legal representative) 591071 591071 Aleyn, John, of Hokwold, gent, executors of 0
5076970 2379609 2379609 defendant Styward Thomas husbandman 591071 591071 (Styward, Thomas, of Hokwold, husbandman 1
5087174 2382628 2382628 defendant Walpoll William husbandman 591071 591071 Walpoll, William, of Hokwold, husbandman 0
5487250 2501084 2501084 defendant Coke John clerk 591071 591071 Coke, John, of Hokwold, clerk 0
5487251 2501084 2501084 defendant Fynche John yeoman 591071 591071 Fynche, John, of Hokwold, yeoman 1
5538040 2516384 2516384 defendant Bole Peter yeoman 591071 591071 (Bole, Peter, of Hokwold, yeoman 8
5550353 2520123 2520123 defendant Smyth Edmund husbandman 591071 591071 Smyth, Edmund, of Hokwold, husbandman 0
5575185 2527326 2527326 defendant Bull Peter (legal representative) 591071 591071 Bull, Peter, of Hokwold, yeoman, executor of 0
5575186 2527326 2527326 defendant Bull John husbandman 591071 591071 Bull, John, of Hokwold, husbandman 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);