names

41 rows where place_id = 661179

✎ 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
3959509 2010417 2010417 defendant Coxworthye Richard husbandman 661179 661179 Coxworthye, Richard, of Payngton, husbandman 0
4237668 2108769 2108769 defendant Kinge John husbandman 661179 661179 Kinge, John, of Payngton, husbandman 0
4237669 2108769 2108769 defendant Churchward James husbandman 661179 661179 Churchward, James, of Payngton, husbandman 1
4965977 2346752 2346752 defendant Smyth William cooper 661179 661179 Smyth, William, of Payngton, cooper 0
4965980 2346753 2346753 defendant Jent Nicholas mariner 661179 661179 Jent, Nicholas, of Payngton, mariner 1
4965981 2346753 2346753 defendant Smyth William cooper 661179 661179 together with Smyth, William, of Payngton, cooper 2
4968805 2347640 2347640 defendant Compe Peter husbandman 661179 661179 Compe, Peter, of Payngton, husbandman 0
4968806 2347640 2347640 defendant Compe Richard husbandman 661179 661179 Compe, Richard, of Payngton, husbandman 1
4968807 2347640 2347640 defendant Compe Robert husbandman 661179 661179 Compe, Robert, of Payngton, husbandman 2
4968808 2347640 2347640 defendant Mugge Peter husbandman 661179 661179 Mugge, Peter, of Payngton, husbandman 3
4968809 2347640 2347640 defendant Mugge John, senior husbandman 661179 661179 Mugge, John, senior, of Payngton, husbandman 4
4968810 2347640 2347640 defendant Mugge John, junior husbandman 661179 661179 Mugge, John, junior, of Payngton, husbandman 5
4968811 2347640 2347640 defendant Petyr John, senior husbandman 661179 661179 Petyr, John, senior, of Payngton, husbandman 6
4968812 2347640 2347640 defendant Petyr John, junior husbandman 661179 661179 Petyr, John, junior, of Payngton, husbandman 7
4968813 2347640 2347640 defendant Petyr Richard husbandman 661179 661179 Petyr, Richard, of Payngton, husbandman 8
4968814 2347640 2347640 defendant Hayward Michael husbandman 661179 661179 Hayward, Michael, of Payngton, husbandman 9
5035177 2367152 2367152 defendant Smyth Richard merchant 661179 661179 Smyth, Richard, of Payngton, merchant 2
5064775 2376005 2376005 defendant Smyth Richard tailor 661179 661179 Smyth, Richard, of Payngton, tailor 1
5113467 2390328 2390328 defendant Petir Richard yeoman 661179 661179 Petir, Richard, of Payngton, yeoman 0
5113468 2390328 2390328 defendant Phylyp William yeoman 661179 661179 Phylyp, William, of Payngton, yeoman 1
5132970 2396135 2396135 defendant Pomeray Henry esq 661179 661179 Pomeray, Henry, of Payngton, esq 0
5132976 2396136 2396136 defendant Harry Thomas yeoman 661179 661179 Harry, Thomas, of Payngton, yeoman 4
5132977 2396136 2396136 defendant Langlegh Florence husbandman 661179 661179 Langlegh, Florence, of Payngton, husbandman 5
5132985 2396136 2396136 defendant Broke John husbandman 661179 661179 Broke, John, of Payngton, husbandman 13
5132986 2396136 2396136 defendant Tolke John laborer 661179 661179 Tolke, John, of Payngton, laborer 14
5152782 2401954 2401954 defendant Pomeray Henry esq 661179 661179 Pomeray, Henry, of Payngton, esq 0
5158102 2403492 2403492 defendant Holeway John gent 661179 661179 Holeway, John, of Payngton, gent 0
5158103 2403492 2403492 defendant Cranford William husbandman 661179 661179 Cranford, William, of Payngton, husbandman 1
5158104 2403492 2403492 defendant Germyn John mariner 661179 661179 Germyn, John, of Payngton, mariner 2
5158105 2403492 2403492 defendant Amys Richard yeoman 661179 661179 Amys, Richard, of Payngton, yeoman 3
5158106 2403492 2403492 defendant Walsshe Nicholas yeoman 661179 661179 Walsshe, Nicholas, of Payngton, yeoman 4
5158108 2403492 2403492 defendant Bokell John yeoman 661179 661179 Bokell, John, of Payngton, yeoman 6
5158109 2403492 2403492 defendant Salle Henry husbandman 661179 661179 Salle, Henry, of Payngton, husbandman 7
5158110 2403492 2403492 defendant Preter William laborer 661179 661179 Preter, William, of Payngton, laborer 8
5158112 2403492 2403492 defendant Cane or Cave Nicholas husbandman 661179 661179 Cane or Cave, Nicholas, of Payngton, husbandman 10
5158113 2403492 2403492 defendant Broun Denis laborer 661179 661179 Broun, Denis, of Payngton, laborer 11
5327705 2453354 2453354 defendant Fyntwyll William mariner 661179 661179 Fyntwyll, William, of Payngton, mariner 0
5327706 2453354 2453354 defendant Benet Robert mariner 661179 661179 Benet, Robert, of Payngton, mariner 1
5327707 2453354 2453354 defendant Trevylyan John mariner 661179 661179 Trevylyan, John, of Payngton, mariner 2
5327708 2453354 2453354 defendant Touker Robert tucker 661179 661179 Touker, Robert, of Payngton, tucker 3
5327710 2453355 2453355 defendant Fyntwyll William mariner 661179 661179 Fyntwyll, William, of Payngton, mariner 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);