names

41 rows where place_id = 605415

✎ 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
3661544 1913885 1913885 defendant Grene Richard husbandman 605415 605415 Grene, Richard, of Kyrton in Holland, husbandman 0
3949835 2007019 2007019 defendant Fowle Robert yeoman 605415 605415 Fowle, Robert, of Kyrton in Holland, yeoman 0
3954483 2008637 2008637 plaintiff Lawnde William husbandman 605415 605415 Lawnde, William, of Kyrton in Holland, husbandman 0
3959909 2010561 2010561 defendant Jesson Francis husbandman 605415 605415 Jesson, Francis, of Kyrton in Holland, husbandman 0
3961246 2011028 2011028 defendant Conye Thomas husbandman 605415 605415 Conye, Thomas, of Kyrton in Holland, husbandman 0
3961247 2011028 2011028 defendant Conye John laborer 605415 605415 Conye, John, of Kyrton in Holland, laborer 1
3978418 2017036 2017036 defendant Snowdon Robert laborer 605415 605415 Snowdon, Robert, of Kyrton in Holland, laborer 4
3993360 2022366 2022366 defendant Longley Richard yeoman 605415 605415 Longley, Richard, of Kyrton in Holland, or of tattersall, yeoman 0
4043982 2040299 2040299 plaintiff Pury Thomas gent 605415 605415 Pury, Thomas, of Kyrton in Holland, gent 0
4065281 2047864 2047864 defendant Lungley Richard yeoman 605415 605415 Lungley, Richard, of Kyrton in Holland, yeoman 0
4078707 2052680 2052680 plaintiff Thewe Thomas yeoman 605415 605415 Thewe, Thomas, of Kyrton in Holland, yeoman 0
4081656 2053742 2053742 defendant Stafford Thomas weaver 605415 605415 Stafford, Thomas, of Kyrton in Holland, weaver 0
4090138 2056757 2056757 defendant Lawson Christopher laborer 605415 605415 Lawson, Christopher, of Kyrton in Holland, laborer 0
4090140 2056758 2056758 defendant Meres Anthony gent 605415 605415 Meres, Anthony, of Kyrton in Holland, gent 0
4095179 2058599 2058599 defendant Herdman Andrew husbandman 605415 605415 Herdman, Andrew, of Kyrton in Holland, husbandman 0
4095180 2058599 2058599 defendant Herdman Edward husbandman 605415 605415 Herdman, Edward, of Kyrton in Holland, husbandman 1
4100258 2060427 2060427 defendant Seyre Robert laborer 605415 605415 Seyre, Robert, of Kyrton in Holland, laborer 0
4100259 2060427 2060427 defendant Totofte Robert laborer 605415 605415 Totofte, Robert, of Kyrton in Holland, laborer 1
4112927 2064891 2064891 defendant Fowle Thomas yeoman 605415 605415 Fowle, Thomas, of Kyrton in Holland, yeoman 0
4116974 2066369 2066369 defendant Lawson Christopher laborer 605415 605415 Lawson, Christopher, of Kyrton in Holland, laborer 0
4117406 2066522 2066522 defendant Morrys John tailor 605415 605415 Morrys, John, of Kyrton in Holland, tailor 0
4120701 2067683 2067683 defendant Lodge Richard mercer 605415 605415 Lodge, Richard, of Kyrton in Holland, mercer 1
4128583 2070514 2070514 defendant Stevenson John gent 605415 605415 Stevenson, John, of Kyrton in Holland, gent 0
4135650 2073075 2073075 defendant Stephenson Thomas yeoman 605415 605415 Stephenson, Thomas, of Kyrton in Holland, yeoman 0
4137226 2073661 2073661 defendant Pyerson John husbandman 605415 605415 Pyerson, John, of Kyrton in Holland, husbandman 0
4138903 2074287 2074287 defendant Hagger Richard yeoman 605415 605415 Hagger, Richard, of Kyrton in Holland, yeoman 0
4138904 2074287 2074287 defendant Herdman alias Hermane Andrew husbandman 605415 605415 Herdman alias Hermane, Andrew, of Kyrton in Holland, husbandman 1
4138905 2074287 2074287 defendant Heyworth John sherman 605415 605415 Heyworth, John, of Kyrton in Holland, sherman 2
4138983 2074313 2074313 defendant Harryson Peter husbandman 605415 605415 Harryson, Peter, of Kyrton in Holland, husbandman 0
4163681 2082818 2082818 defendant Harryson Peter husbandman 605415 605415 Harryson, Peter, of Kyrton in Holland, husbandman 0
4163970 2082927 2082927 defendant Hurdman Edward yeoman 605415 605415 Hurdman, Edward, of Kyrton in Holland, yeoman 0
4173947 2086343 2086343 defendant Symson John husbandman 605415 605415 Symson, John, of Kyrton in Holland, husbandman 3
4173952 2086344 2086344 defendant Harrison Peter yeoman 605415 605415 Harrison, Peter, of Kyrton in Holland, yeoman 3
4235644 2108036 2108036 defendant Tunarde Richard yeoman 605415 605415 Tunarde, Richard, of Kyrton in Holland, yeoman 1
4240092 2109659 2109659 defendant Tonnard Humphrey yeoman 605415 605415 Tonnard, Humphrey, of Kyrton in Holland, yeoman 0
4240093 2109659 2109659 defendant Hood William husbandman 605415 605415 Hood, William, of Kyrton in Holland, husbandman 1
4244217 2111052 2111052 defendant Tunard Richard yeoman 605415 605415 Tunard, Richard, of Kyrton in Holland, yeoman 1
4282232 2123683 2123683 defendant Glascocke William husbandman 605415 605415 Glascocke, William, of Kyrton in Holland, husbandman 0
4292998 2127556 2127556 defendant Stoute Thomas husbandman 605415 605415 Stoute, Thomas, of Kyrton in Holland, husbandman 0
4368805 2153897 2153897 defendant Howson George yeoman 605415 605415 Howson, George, of Kyrton in Holland, yeoman 3
4380180 2158014 2158014 defendant Willson William yeoman 605415 605415 Willson, William, of Kyrton in Holland, yeoman 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);