names

39 rows where place_id = 594983

✎ 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
3618364 1873375 1873375 defendant Stephen John yeoman 594983 594983 Stephen, John, of Gestlyng, yeoman 0
3630961 1904504 1904504 defendant Assheburnham Thomas esq 594983 594983 Assheburnham, Thomas, of Gestlyng, esq 0
3630962 1904504 1904504 defendant Assheburnham John gent 594983 594983 Assheburnham, John, of Gestlyng, gent 1
3663181 1914403 1914403 defendant Ashebournham Thomas esq 594983 594983 Ashebournham, Thomas, of Gestlyng, esq 0
3663182 1914403 1914403 defendant Morymer William yeoman 594983 594983 Morymer, William, of Gestlyng, yeoman 1
3663183 1914403 1914403 defendant Busshell Robert laborer 594983 594983 Busshell, Robert, of Gestlyng, laborer 2
3663187 1914404 1914404 defendant Ashebournham Thomas esq 594983 594983 Ashebournham, Thomas, of Gestlyng, esq 0
3673554 1917755 1917755 defendant Assheburnham Thomas esq 594983 594983 Assheburnham, Thomas, of Gestlyng, esq 0
3677650 1919053 1919053 defendant Bacheler Robert yeoman 594983 594983 Bacheler, Robert, of Gestlyng, yeoman 0
3744986 1940339 1940339 defendant Marten William husbandman 594983 594983 Marten, William, of Gestlyng, husbandman 0
3744987 1940339 1940339 defendant Polglasse Richard husbandman 594983 594983 Polglasse, Richard, of Gestlyng, husbandman 1
3744988 1940339 1940339 defendant Floren John laborer 594983 594983 Floren, John, of Gestlyng, laborer 2
3744989 1940339 1940339 defendant Lovell John laborer 594983 594983 Lovell, John, of Gestlyng, laborer 3
3754736 1943441 1943441 defendant Stokys Henry gent 594983 594983 Stokys, Henry, of Gestlyng, gent 1
3772148 1948981 1948981 defendant Stokys Henry gent 594983 594983 Stokys, Henry, of Gestlyng, gent 0
3789537 1954553 1954553 defendant Lewcott John husbandman 594983 594983 Lewcott, John, of Gestlyng, husbandman 0
3809201 1960758 1960758 defendant Stokes Henry gent 594983 594983 Stokes, Henry, of Gestlyng, gent 0
3843075 1971358 1971358 defendant Bacheler John husbandman 594983 594983 Bacheler, John, of Gestlyng, husbandman 0
4467181 2190407 2190407 plaintiff atte Hall John, senior   594983 594983 atte Hall, John, senior, of Gestlyng 0
4542868 2213660 2213660 defendant Cogger Stephen   594983 594983 Cogger, Stephen, of Gestlyng 0
4542869 2213660 2213660 defendant Fynche John, sen   594983 594983 Fynche, John, sen, of Gestlyng 1
4571449 2222654 2222654 defendant Fyssh John   594983 594983 Fyssh, John, of Gestlyng 2
4776398 2288611 2288611 defendant Putlond Margery   594983 594983 Putlond, Margery, of Gestlyng, servant 1
4818702 2301935 2301935 defendant Alard Gervase husbandman 594983 594983 Alard, Gervase, of Gestlyng, husbandman 0
4818710 2301938 2301938 defendant Bakere Richard husbandman 594983 594983 Bakere, Richard, of Gestlyng, husbandman 0
4818716 2301941 2301941 defendant Alard Gervase husbandman 594983 594983 Alard, Gervase, of Gestlyng, husbandman 0
4821697 2302860 2302860 defendant Alard Gervase husbandman 594983 594983 Alard, Gervase, of Gestlyng, husbandman 1
4860946 2314783 2314783 defendant Miller Simon carpenter 594983 594983 Miller, Simon,of Gestlyng, carpenter 0
4872844 2318458 2318458 defendant Bakere Richard yeoman 594983 594983 Bakere, Richard, of Gestlyng, yeoman 0
4913414 2330693 2330693 defendant Lydham Thomas husbandman 594983 594983 Lydham, Thomas, of Gestlyng, husbandman 0
4975761 2349712 2349712 defendant Wytherese John laborer 594983 594983 Wytherese, John, of Gestlyng, laborer 0
4975763 2349713 2349713 defendant Wytharese John laborer 594983 594983 Wytharese, John, of Gestlyng, laborer 0
5038640 2368201 2368201 plaintiff Arnold Robert esq 594983 594983 Arnold, Robert, of Gestlyng, esq 0
5217619 2420890 2420890 defendant Alard Robert husbandman 594983 594983 Alard, Robert, of Gestlyng, husbandman 16
5217621 2420890 2420890 defendant Ponteys John husbandman 594983 594983 Ponteys, John, of Gestlyng, husbandman 18
5218486 2421139 2421139 defendant Riche Richard husbandman 594983 594983 Riche, Richard, of Gestlyng, husbandman 0
5321262 2451456 2451456 defendant Roche Richard husbandman 594983 594983 Roche, Richard, of Gestlyng, husbandman 0
5321266 2451457 2451457 defendant Ryche Richard husbandman 594983 594983 Ryche, Richard, of Gestlyng, husbandman 0
5539923 2516966 2516966 defendant Lunsford Robert husbandman 594983 594983 Lunsford, Robert, of Gestlyng, husbandman 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);