names

71 rows where place_id = 592885

✎ 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
3609264 1870559 1870559 defendant Wylkynson William yeoman 592885 592885 Wylkynson, William, of Eland, yeoman 1
3629319 1904028 1904028 defendant Wilkynson John gent 592885 592885 Wilkynson, John, of Eland, gent 1
3663127 1914380 1914380 defendant Wilkynson John gent 592885 592885 Wilkynson, John, of Eland, gent 0
3682700 1920692 1920692 defendant Cley John yeoman 592885 592885 Cley, John, of Eland, yeoman 1
3682716 1920696 1920696 defendant Cley John yeoman 592885 592885 Cley, John, of Eland, yeoman 1
3712735 1930298 1930298 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 1
3724466 1933938 1933938 defendant Romsden Geoffrey yeoman 592885 592885 Romsden, Geoffrey, of Eland, yeoman 1
3740720 1938961 1938961 defendant Elyston Richard yeoman 592885 592885 Elyston, Richard, of Eland, yeoman 0
3762469 1945905 1945905 plaintiff Gledehill Edmund   592885 592885 Gledehill, Edmund, of Eland 0
3766766 1947268 1947268 defendant Wylkynson Thomas clothier 592885 592885 Wylkynson, Thomas, of Eland, clothier 0
3794153 1956040 1956040 defendant Cosyn John yeoman 592885 592885 Cosyn, John, of Eland, yeoman 0
3797781 1957204 1957204 defendant Wylkynson John barker 592885 592885 Wylkynson, John, of Eland, barker 1
3803764 1959091 1959091 plaintiff Romsden Robert clothier 592885 592885 Romsden, Robert, of Eland, clothier 0
3810684 1961239 1961239 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 0
3817305 1963323 1963323 defendant Wylkynson Thomas gent 592885 592885 Wylkynson, Thomas, of Eland, gent 3
3822895 1965066 1965066 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 0
3822896 1965066 1965066 defendant Wylkynson Thomas gent 592885 592885 Wylkynson, Thomas, of Eland, gent 1
3830831 1967525 1967525 defendant Sayvell Henry gent 592885 592885 Sayvell, Henry, of Eland, gent 0
3830834 1967526 1967526 defendant Sayvell Henry gent 592885 592885 Sayvell, Henry, of Eland, gent 0
3831133 1967623 1967623 defendant Sayvell Henry gent 592885 592885 Sayvell, Henry, of Eland, gent 0
3838820 1970067 1970067 defendant Cofyn John yeoman 592885 592885 Cofyn, John, of Eland, yeoman 0
3838821 1970067 1970067 defendant Walker John yeoman 592885 592885 Walker, John, of Eland, yeoman 1
3870100 1980243 1980243 defendant Sayvell Henry gent 592885 592885 Sayvell, Henry, of Eland, gent 0
3895999 1988867 1988867 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 1
3896000 1988867 1988867 defendant Wylkynson Robert yeoman 592885 592885 Wylkynson, Robert, of Eland, yeoman 2
3896006 1988868 1988868 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 1
3896007 1988868 1988868 defendant Wylkynson Robert yeoman 592885 592885 Wylkynson, Robert, of Eland, yeoman 2
3896013 1988869 1988869 defendant Wylkynson John gent 592885 592885 Wylkynson, John, of Eland, gent 1
3896014 1988869 1988869 defendant Wylkynson Robert yeoman 592885 592885 Wylkynson, Robert, of Eland, yeoman 2
3897823 1989475 1989475 plaintiff Wylkynson Thomas   592885 592885 Wylkynson, Thomas, of Eland 0
3909020 1993314 1993314 defendant Fox Robert laborer 592885 592885 Fox, Robert, of Eland, laborer 0
3909041 1993322 1993322 defendant Fox Robert laborer 592885 592885 Fox, Robert, of Eland, laborer 0
3928164 1999755 1999755 defendant Horsfall Robert clothier 592885 592885 Horsfall, Robert, of Eland, clothier 2
3966882 2013049 2013049 defendant Gleydhill William yeoman 592885 592885 Gleydhill, William, of Eland, yeoman 0
3966883 2013049 2013049 defendant Crowther John yeoman 592885 592885 Crowther, John, of Eland, yeoman 1
3969450 2013922 2013922 plaintiff Cossen John clothier 592885 592885 Cossen, John, of Eland, clothier 0
3969451 2013922 2013922 defendant Baystowe Robert clothier 592885 592885 Baystowe, Robert, of Eland, clothier 0
4074413 2051154 2051154 defendant Savyll Robert gent 592885 592885 Savyll, Robert, of Eland, gent 0
4210385 2099191 2099191 defendant Haighe Edmund clothier 592885 592885 Haighe, Edmund, of Eland, clothier 0
4315903 2135672 2135672 defendant Midleton George esq 592885 592885 Midleton, George, of Eland, or of Leighton, Lancs, esq 0
4372791 2155345 2155345 defendant Thornton Thomas husbandman 592885 592885 Thornton, Thomas, of Eland, husbandman 0
4459696 2188089 2188089 plaintiff Samull John   592885 592885 Samull, John, of Eland, knight 0
4459863 2188140 2188140 plaintiff Sayvill John   592885 592885 Sayvill, John, of Eland, knight 0
4459865 2188141 2188141 plaintiff Sayvill John   592885 592885 Sayvill, John, of Eland, knight 0
4459867 2188142 2188142 plaintiff Sayvill John   592885 592885 Sayvill, John, of Eland, knight 0
4459870 2188143 2188143 plaintiff Sayvill John   592885 592885 Sayvill, John, of Eland, knight 0
4486655 2196538 2196538 plaintiff Savill John   592885 592885 Savill, John, of Eland, knight 0
4534548 2211078 2211078 plaintiff Sayvell John (legal representative) 592885 592885 Sayvell, John, of Eland, knight, executors of 0
4564489 2220460 2220460 plaintiff Sayvell John (legal representative) 592885 592885 Sayvell, John, of Eland, knight, executors of 0
4596989 2230302 2230302 plaintiff Sayvell John (legal representative) 592885 592885 Sayvell, John, of Eland, the father, knight, executors of 0
4602254 2231921 2231921 defendant Denton John   592885 592885 Denton, John, of Eland 4
4602260 2231922 2231922 defendant Denton John   592885 592885 Denton, John, of Eland 4
4709293 2268277 2268277 defendant del Clay John laborer 592885 592885 del Clay, John, of Eland, laborer 0
4992729 2354707 2354707 defendant Palden Thomas shoemaker 592885 592885 Palden, Thomas, of Eland, shoemaker 0
4992730 2354707 2354707 defendant del Fryth Robert yeoman 592885 592885 del Fryth, Robert, of Eland, yeoman 1
4992733 2354708 2354708 defendant del Fryth Robert yeoman 592885 592885 del Fryth, Robert, of Eland, yeoman 1
5002493 2357640 2357640 defendant Harbotill John esq 592885 592885 Harbotill, John, of Eland, esq 0
5019762 2362658 2362658 defendant Palden Thomas shoemaker 592885 592885 Palden, Thomas, of Eland, shoemaker 0
5019763 2362658 2362658 defendant Del Fryth Robert yeoman 592885 592885 Del Fryth, Robert, of Eland, yeoman 1
5023515 2363786 2363786 defendant Mylner John yeoman 592885 592885 Mylner, John, of Eland, yeoman 0
5028223 2365128 2365128 defendant Milner Thomas yeoman 592885 592885 Milner, Thomas, of Eland, yeoman 1
5072051 2378132 2378132 plaintiff Sundyrland Richard yeoman 592885 592885 Sundyrland, Richard, of Eland, yeoman 0
5360130 2463209 2463209 defendant Saywell John   592885 592885 Saywell, John, of Eland, gent, son of Saywell, Thomas, of Holyngege 0
5360131 2463209 2463209 defendant Saywell Nicholas   592885 592885 Saywell, Nicholas, of Eland, gent, son of Saywell, Thomas 1
5396556 2474104 2474104 defendant Hole John   592885 592885 Hole, John, of Eland, shoe maker 0
5489990 2501894 2501894 defendant Gledehill Robert chaplain 592885 592885 Gledehill, Robert, of Eland, chaplain 1
5510188 2508023 2508023 defendant Layburn Robert chaplain 592885 592885 Layburn, Robert, of Eland, chaplain 0
5557152 2522051 2522051 defendant Gledehill John yeoman 592885 592885 Gledehill, John, of Eland, yeoman 0
5562482 2523625 2523625 defendant Sayvell Nicholas gent 592885 592885 Sayvell, Nicholas, of Eland, gent 1
5567313 2525017 2525017 defendant Jepson Robert yeoman 592885 592885 Jepson, Robert, of Eland, yeoman 1
5591707 2532392 2532392 defendant Bodderode Richard sherman 592885 592885 Bodderode, Richard, of Eland, sherman 1

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