names

72 rows where place_id = 590440

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601213 1868042 1868042 defendant Shipwright Richard husbandman 590440 590440 Shipwright, Richard, of Wigtoft, husbandman 1
3601214 1868042 1868042 defendant Welby Richard yeoman 590440 590440 Welby, Richard, of Wigtoft, yeoman 2
3620600 1874019 1874019 defendant Hoggeson John laborer 590440 590440 Hoggeson, John, of Wigtoft, laborer 0
3655425 1911957 1911957 defendant Bele James husbandman 590440 590440 Bele, James, of Wigtoft, husbandman 0
3655429 1911958 1911958 defendant Bele Thomas yeoman 590440 590440 Bele, Thomas, of Wigtoft, yeoman 0
3655433 1911959 1911959 defendant Bele John husbandman 590440 590440 Bele, John, of Wigtoft, husbandman 0
3655437 1911960 1911960 defendant Greyve John husbandman 590440 590440 Greyve, John, of Wigtoft, husbandman 0
3659171 1913125 1913125 defendant Briges Lawrence husbandman 590440 590440 Briges, Lawrence, of Wigtoft, husbandman 2
3659175 1913126 1913126 defendant Shepard Robert husbandman 590440 590440 Shepard, Robert, of Wigtoft, husbandman 1
3659791 1913315 1913315 defendant Shepard Robert husbandman 590440 590440 Shepard, Robert, of Wigtoft, husbandman 2
3659795 1913316 1913316 defendant Shepard Robert husbandman 590440 590440 Shepard, Robert, of Wigtoft, husbandman 2
3673295 1917663 1917663 defendant Benet Thomas gent 590440 590440 Benet, Thomas, of Wigtoft, gent 0
3684776 1921376 1921376 defendant Hough Thomas gent 590440 590440 Hough, Thomas, of Wigtoft, gent 0
3686784 1922022 1922022 defendant Hubberd Henry laborer 590440 590440 Hubberd, Henry, of Wigtoft, laborer 1
3686786 1922023 1922023 defendant Hubberd Henry laborer 590440 590440 Hubberd, Henry, of Wigtoft, laborer 0
3686787 1922023 1922023 defendant Halgh Thomas gent 590440 590440 Halgh, Thomas, of Wigtoft, gent 1
3692216 1923732 1923732 defendant Halgh Thomas gent 590440 590440 (Halgh, Thomas, of Wigtoft, gent 1
3692217 1923732 1923732 defendant Staunton John clerk 590440 590440 Staunton, John, of Wigtoft, clerk 2
3746364 1940781 1940781 defendant Benett William husbandman 590440 590440 Benett, William, of Wigtoft, husbandman 0
3753796 1943128 1943128 defendant Hunt Roger   590440 590440 Hunt, Roger, of Wigtoft 0
3754204 1943262 1943262 defendant Bele Robert husbandman 590440 590440 Bele, Robert, of Wigtoft, husbandman 0
3757320 1944269 1944269 defendant Cole William husbandman 590440 590440 Cole, William, of Wigtoft, husbandman 0
3757322 1944270 1944270 defendant Cooke William husbandman 590440 590440 Cooke, William, of Wigtoft, husbandman 0
3759203 1944865 1944865 defendant Storkys William husbandman 590440 590440 Storkys, William, of Wigtoft, husbandman 1
3763186 1946121 1946121 defendant Obrey Hugh husbandman 590440 590440 Obrey, Hugh, of Wigtoft, husbandman 0
3763190 1946123 1946123 defendant Westfeld Thomas husbandman 590440 590440 Westfeld, Thomas, of Wigtoft, husbandman 0
3775229 1949986 1949986 defendant Brigge Robert husbandman 590440 590440 Brigge, Robert, of Wigtoft, husbandman 0
3793437 1955813 1955813 defendant Bawne William husbandman 590440 590440 Bawne, William, of Wigtoft, husbandman 0
3798038 1957284 1957284 defendant Crier James laborer 590440 590440 Crier, James, of Wigtoft, laborer 4
3806462 1959934 1959934 defendant Lawes Margaret widow 590440 590440 Lawes, Margaret, of Wigtoft, widow 0
3806463 1959934 1959934 defendant Lawes Alan husbandman 590440 590440 Lawes, Alan, of Wigtoft, husbandman 1
3809602 1960890 1960890 defendant Bele Robert husbandman 590440 590440 Bele, Robert, of Wigtoft, husbandman 0
3809603 1960890 1960890 defendant Bele James husbandman 590440 590440 Bele, James, of Wigtoft, husbandman 1
3839610 1970312 1970312 defendant Lincoln William yeoman 590440 590440 Lincoln, William, of Wigtoft, yeoman 0
3864530 1978337 1978337 plaintiff Lincoln William gent 590440 590440 Lincoln, William, of Wigtoft, gent 0
3864533 1978337 1978337 defendant Nevell John yeoman 590440 590440 Nevell, John, of Wigtoft, yeoman 2
3903985 1991572 1991572 defendant Proctour John husbandman 590440 590440 Proctour, John, of Wigtoft, husbandman 0
3907346 1992746 1992746 defendant Pakee Nicholas butcher 590440 590440 Pakee, Nicholas, of Wigtoft, butcher 1
3911184 1994068 1994068 defendant Greswell John husbandman 590440 590440 Greswell, John, of Wigtoft, husbandman 2
3911188 1994069 1994069 defendant Greswell John husbandman 590440 590440 Greswell, John, of Wigtoft, husbandman 2
3921164 1997430 1997430 defendant Shepard John husbandman 590440 590440 Shepard, John, of Wigtoft, husbandman 0
3921165 1997430 1997430 defendant Welburne Thomas husbandman 590440 590440 Welburne, Thomas, of Wigtoft, husbandman 1
3927235 1999445 1999445 defendant Halgh Nicholas gent 590440 590440 Halgh, Nicholas, of Wigtoft, gent 0
3948772 2006639 2006639 defendant Mason William yeoman 590440 590440 Mason, William, of Wigtoft, yeoman 0
3972028 2014773 2014773 defendant Halgh Nicholas gent 590440 590440 Halgh, Nicholas, of Wigtoft, gent 2
3998628 2024245 2024245 defendant Harryson Roger yeoman 590440 590440 Harryson, Roger, of Wigtoft, yeoman 0
3998630 2024246 2024246 defendant Harryson Roger yeoman 590440 590440 Harryson, Roger, of Wigtoft, yeoman 0
3998632 2024247 2024247 defendant Harryson Roger yeoman 590440 590440 Harryson, Roger, of Wigtoft, yeoman 0
4003641 2026067 2026067 plaintiff Howson William yeoman 590440 590440 Howson, William, of Wigtoft, yeoman 0
4173937 2086341 2086341 defendant Burbag Thomas husbandman 590440 590440 Burbag, Thomas, of Wigtoft, husbandman 2
4178999 2088132 2088132 defendant Walgate Richard yeoman 590440 590440 Walgate, Richard, of Wigtoft, yeoman 0
4437529 2176494 2176494 defendant Heryng Alexander   590440 590440 Heryng, Alexander, of Wigtoft 0
4437530 2176494 2176494 defendant Sourale Alice   590440 590440 Sourale, Alice, of Wigtoft, formerly wife of Simon 1
4437534 2176495 2176495 defendant Heryng Alexander   590440 590440 Heryng, Alexander, of Wigtoft 0
4437535 2176495 2176495 defendant Sourale Alice   590440 590440 Sourale, Alice, of Wigtoft, formerly wife of Simon 1
4445603 2183578 2183578 defendant Marchaunt John   590440 590440 Marchaunt, John, of Wigtoft 0
4557875 2218394 2218394 defendant Pony John   590440 590440 Pony, John, of Wigtoft 1
4636789 2242322 2242322 defendant Bailly Nicholas   590440 590440 Bailly, Nicholas, of Wigtoft 0
4649915 2245993 2245993 defendant Makke John   590440 590440 Makke, John, of Wigtoft 0
4651100 2246344 2246344 defendant Ebny Thomas husbandman 590440 590440 Ebny, Thomas, of Wigtoft, husbandman 1
4688368 2261928 2261928 defendant Banne or Baune Robert husbandman 590440 590440 Banne or Baune, Robert, of Wigtoft, husbandman 1
5282512 2439943 2439943 defendant Dolitell William husbandman 590440 590440 Dolitell, William, of Wigtoft, husbandman 3
5446688 2488904 2488904 defendant Hoggeson Henry   590440 590440 Hoggeson, Henry, of Wigtoft 0
5579786 2528758 2528758 defendant Magelyn William gent 590440 590440 Magelyn, William, of Wigtoft, gent 0
5579788 2528758 2528758 defendant Thomson Christopher laborer 590440 590440 Thomson, Christopher, of Wigtoft, laborer 2
5584073 2530093 2530093 defendant Beell Thomas husbandman 590440 590440 Beell, Thomas, of Wigtoft, husbandman 0
5587747 2531186 2531186 defendant Magelyn William gent 590440 590440 Magelyn, William, of Wigtoft, gent 0
5587749 2531186 2531186 defendant Thomson Christopher laborer 590440 590440 Thomson, Christopher, of Wigtoft, laborer 2
5600899 2535170 2535170 defendant Hun William husbandman 590440 590440 Hun, William, of Wigtoft, husbandman 0
5600900 2535170 2535170 defendant Hun Robert husbandman 590440 590440 Hun, Robert, of Wigtoft, husbandman 1
5602100 2535552 2535552 defendant Anderton John laborer 590440 590440 Anderton, John, of Wigtoft, laborer 0
5602102 2535553 2535553 defendant Anderton John laborer 590440 590440 Anderton, John, of Wigtoft, laborer 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);