names

72 rows where place_id = 586016

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587703 1863800 1863800 defendant Shawe Emma widow 586016 586016 Shawe, Emma, of Denby, widow 0
3587704 1863800 1863800 defendant Shawe John her son 586016 586016 Shawe, John, of Denby, husbandman, her son 1
3590013 1864517 1864517 defendant Lowe Lawrence gent 586016 586016 Lowe, Lawrence, of Denby, gent 0
3590014 1864517 1864517 defendant Lowe Humphrey gent 586016 586016 Lowe, Humphrey, of Denby, gent 1
3590015 1864517 1864517 defendant Ayssheton Alexander husbandman 586016 586016 Ayssheton, Alexander, of Denby, husbandman 2
3590016 1864517 1864517 defendant Tofte William laborer 586016 586016 Tofte, William, of Denby, laborer 3
3590017 1864517 1864517 defendant Wryght Richard husbandman 586016 586016 Wryght, Richard, of Denby, husbandman 4
3590018 1864517 1864517 defendant Wardesworth Nicholas tailor 586016 586016 Wardesworth, Nicholas, of Denby, tailor 5
3590019 1864517 1864517 defendant Cheteham Geoffrey cooper 586016 586016 Cheteham, Geoffrey, of Denby, cooper 6
3597670 1866897 1866897 defendant Lowe Humphrey   586016 586016 Lowe, Humphrey, of Denby, gent, son of Lawrence 2
3602224 1868360 1868360 defendant Butterworth Ewen yeoman 586016 586016 Butterworth, Ewen, of Denby, yeoman 1
3633206 1905199 1905199 defendant Lawe Humphrey esq 586016 586016 Lawe, Humphrey, of Denby, esq 0
3633207 1905199 1905199 defendant Wodde John yeoman 586016 586016 Wodde, John, of Denby, yeoman 1
3641321 1907737 1907737 defendant Burdett Nicholas esq 586016 586016 Burdett, Nicholas, of Denby, esq 0
3643231 1908315 1908315 defendant Swyft Richard yeoman 586016 586016 Swyft, Richard, of Denby, yeoman 5
3646964 1909451 1909451 defendant Lowe Denis gent 586016 586016 Lowe, Denis, of Denby, gent 0
3649726 1910284 1910284 defendant Swyft Richard yeoman 586016 586016 Swyft, Richard, of Denby, yeoman 5
3651746 1910899 1910899 defendant Garrett John yeoman 586016 586016 Garrett, John, of Denby, yeoman 0
3651747 1910899 1910899 defendant Badcok German yeoman 586016 586016 Badcok, German, of Denby, yeoman 1
3651748 1910899 1910899 defendant Badcok Geoffrey husbandman 586016 586016 Badcok, Geoffrey, of Denby, husbandman 2
3661875 1914002 1914002 defendant Garret John yeoman 586016 586016 Garret, John, of Denby, yeoman 0
3779098 1951188 1951188 defendant Burdet Richard esq 586016 586016 Burdet, Richard, of Denby, esq 0
3780120 1951507 1951507 defendant Lowe Vincent gent 586016 586016 Lowe, Vincent, of Denby, gent 0
3796191 1956676 1956676 defendant Burdet Richard esq 586016 586016 Burdet, Richard, of Denby, esq 0
3824906 1965668 1965668 defendant Sutton John husbandman 586016 586016 Sutton, John, of Denby, husbandman 0
3824907 1965668 1965668 defendant Badcoke German husbandman 586016 586016 Badcoke, German, of Denby, husbandman 1
3852984 1974555 1974555 defendant Wodcoke Edward husbandman 586016 586016 Wodcoke, Edward, of Denby, husbandman 1
3852985 1974555 1974555 defendant Turton William yeoman 586016 586016 Turton, William, of Denby, yeoman 2
3874827 1981799 1981799 defendant Turton William yeoman 586016 586016 Turton, William, of Denby, yeoman 1
3935137 2002061 2002061 defendant Lloyd Richard mercer 586016 586016 Lloyd, Richard, of Denby, mercer 1
3991005 2021546 2021546 defendant Lowe Francis (legal representative) 586016 586016 Lowe, Francis, of Denby, esq, administrator of 0
4002025 2025503 2025503 defendant Lowe George gent 586016 586016 Lowe, George, of Denby, gent 0
4192798 2093044 2093044 defendant Lowe George gent 586016 586016 Lowe, George, of Denby, gent 0
4206540 2097836 2097836 defendant Lowe Patrick esq 586016 586016 Lowe, Patrick, of Denby, esq, son of Jasper Lowe, of Derby, esq 1
4451940 2185590 2185590 defendant Elanore Henry   586016 586016 Elanore, Henry, of Denby 4
4523550 2207689 2207689 defendant Taillour Thomas   586016 586016 Taillour, Thomas, of Denby 0
4588058 2227663 2227663 defendant Doude Robert   586016 586016 Doude, Robert, of Denby 0
4659137 2248729 2248729 defendant Grene Richard husbandman 586016 586016 Grene, Richard, of Denby, husbandman 2
4734862 2276060 2276060 defendant Fuer John   586016 586016 Fuer, John, of Denby, nail maker 2
4735583 2276281 2276281 defendant Horsley Richard butcher 586016 586016 Horsley, Richard, of Denby, butcher 1
4776816 2288737 2288737 defendant Norman Henry nailer 586016 586016 Norman, Henry, of Denby, nailer 2
4812877 2300140 2300140 defendant Wordsyworth William yeoman 586016 586016 Wordsyworth, William, of Denby, yeoman 11
4812878 2300140 2300140 defendant Jenkynson John yeoman 586016 586016 Jenkynson, John, of Denby, yeoman 12
4818291 2301799 2301799 defendant Foliambe John yeoman 586016 586016 Foliambe, John, of Denby, yeoman 0
4820834 2302604 2302604 defendant Swymoge William gent 586016 586016 Swymoge, William, of Denby, gent 0
4820882 2302618 2302618 defendant Gelle John laborer 586016 586016 Gelle, John, of Denby, laborer 1
4820890 2302622 2302622 defendant Norman Henry yeoman 586016 586016 Norman, Henry, of Denby, yeoman 0
4820891 2302622 2302622 defendant Fyssher William laborer 586016 586016 Fyssher, William, of Denby, laborer 1
4820895 2302624 2302624 defendant Swynmore William gent 586016 586016 Swynmore, William, of Denby, gent 0
4833098 2306371 2306371 defendant Pygot Robert yeoman 586016 586016 Pygot, Robert, of Denby, yeoman 1
4844127 2309675 2309675 defendant Sotheryn John miller 586016 586016 Sotheryn, John, of Denby, miller 0
4855919 2313224 2313224 defendant Caunvyle John butcher 586016 586016 Caunvyle, John, of Denby, butcher 0
4859968 2314485 2314485 defendant Pygot Robert yeoman 586016 586016 together with Pygot, Robert, of Denby, yeoman 1
4859985 2314492 2314492 defendant Pygot Robert yeoman 586016 586016 Pygot, Robert, of Denby, yeoman 0
4913309 2330662 2330662 defendant Cartar Richard   586016 586016 Cartar, Richard, of Denby husbandman 1
4913313 2330663 2330663 defendant Cartar Richard   586016 586016 Cartar, Richard, of Denby husbandman 1
4955997 2343759 2343759 defendant Grendon John (legal representative) 586016 586016 Grendon, John, of Denby, executors of 1
4961645 2345448 2345448 defendant Walton John miller 586016 586016 Walton, John, of Denby, miller 2
4988239 2353453 2353453 defendant Gilderson John smith man 586016 586016 Gilderson, John, of Denby, smith man 0
4990617 2354106 2354106 defendant Couper William cooper 586016 586016 Couper, William, of Denby, cooper 1
5007648 2359138 2359138 defendant Saunderson William   586016 586016 Saunderson, William, of Denby, cart wright 0
5067288 2376726 2376726 defendant Shireshawe James yeoman 586016 586016 Shireshawe, James, of Denby, yeoman 0
5067289 2376726 2376726 defendant Foliambe John, senior husbandman 586016 586016 Foliambe, John, senior, of Denby, husbandman 1
5067290 2376726 2376726 defendant Shagh John, junior husbandman 586016 586016 Shagh, John, junior, of Denby, husbandman 2
5067291 2376726 2376726 defendant Harreson Robert husbandman 586016 586016 Harreson, Robert, of Denby, husbandman 3
5067292 2376726 2376726 defendant Shagh Robert husbandman 586016 586016 Shagh, Robert, of Denby, husbandman 4
5073215 2378477 2378477 defendant Caumbell Benedict husbandman 586016 586016 Caumbell, Benedict, of Denby, husbandman 0
5073219 2378477 2378477 defendant Caumbell John husbandman 586016 586016 Caumbell, John, of Denby, husbandman 4
5096118 2385307 2385307 defendant Vavysoure William gent 586016 586016 Vavysoure, William, of Denby, gent 0
5103820 2387542 2387542 defendant Sheffeld William chaplain 586016 586016 Sheffeld, William, of Denby, chaplain 1
5563804 2524021 2524021 defendant Lowe Thomas gent 586016 586016 Lowe, Thomas, of Denby, gent 1
5586847 2530923 2530923 defendant Latham John chapman 586016 586016 Latham, John, of Denby, chapman 3

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