names

57 rows where place_id = 590715

✎ 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
3602071 1868310 1868310 defendant Hagh Otwell dyer 590715 590715 Hagh, Otwell, of Byngley, dyer 0
3602075 1868310 1868310 defendant Jope John yeoman 590715 590715 Jope, John, of Byngley, yeoman 4
3683591 1920999 1920999 defendant Beyn John yeoman 590715 590715 Beyn, John, of Byngley, yeoman 0
3799359 1957722 1957722 defendant Clyfford Anthony esq 590715 590715 Clyfford, Anthony, of Byngley, esq 0
3845086 1972018 1972018 defendant Eltoftys Anthony esq 590715 590715 Eltoftys, Anthony, of Byngley, esq 0
3875862 1982182 1982182 defendant Tomlynson John yeoman 590715 590715 Tomlynson, John, of Byngley, yeoman 0
3948885 2006675 2006675 defendant Woller John yeoman 590715 590715 Woller, John, of Byngley, yeoman 0
3952396 2007908 2007908 defendant Armitage Robert laborer 590715 590715 Armitage, Robert, of Byngley, laborer 0
4039727 2038822 2038822 defendant Farrand Arthur yeoman 590715 590715 Farrand, Arthur, of Byngley, yeoman 0
4039729 2038823 2038823 defendant Farrante Arthur yeoman 590715 590715 Farrante, Arthur, of Byngley, yeoman 0
4044322 2040425 2040425 defendant Rawson Henry yeoman 590715 590715 Rawson, Henry, of Byngley, yeoman 0
4049145 2042140 2042140 defendant Walker Thomas yeoman 590715 590715 Walker, Thomas, of Byngley, yeoman 0
4049147 2042141 2042141 defendant Wood Silvester yeoman 590715 590715 Wood, Silvester, of Byngley, yeoman 0
4098912 2059938 2059938 defendant Hardye Richard yeoman 590715 590715 Hardye, Richard, of Byngley, yeoman 1
4101712 2060919 2060919 defendant Kyghley Thomas husbandman 590715 590715 Kyghley, Thomas, of Byngley, husbandman 1
4101713 2060919 2060919 defendant Wood John laborer 590715 590715 Wood, John, of Byngley, laborer 2
4101714 2060919 2060919 defendant Hyll Edward yeoman 590715 590715 Hyll, Edward, of Byngley, yeoman 3
4139072 2074344 2074344 defendant Kyghley John yeoman 590715 590715 Kyghley, John, of Byngley, yeoman 0
4139073 2074344 2074344 defendant Smythe John yeoman 590715 590715 Smythe, John, of Byngley, yeoman 1
4139074 2074344 2074344 defendant Kighley Thomas yeoman 590715 590715 Kighley, Thomas, of Byngley, yeoman 2
4141035 2075023 2075023 defendant Wilkenson Thomas yeoman 590715 590715 Wilkenson, Thomas, of Byngley, yeoman 1
4161934 2082244 2082244 defendant Woller Walter yeoman 590715 590715 Woller, Walter, of Byngley, yeoman 0
4322722 2138015 2138015 defendant Rogerson Anthony yeoman 590715 590715 Rogerson, Anthony, of Byngley, yeoman 0
4453937 2186248 2186248 plaintiff Locok John   590715 590715 Locok, John, of Byngley 0
4462987 2189124 2189124 defendant Bucher Robert   590715 590715 Bucher, Robert, of Byngley 0
4567566 2221417 2221417 defendant Underwode Richard   590715 590715 Underwode, Richard, of Byngley 0
4680236 2259428 2259428 defendant Pykard John shoemaker 590715 590715 Pykard, John, of Byngley, shoemaker 0
4747723 2279843 2279843 defendant Colygnworth Hugh yeoman 590715 590715 Colygnworth, Hugh, of Byngley, yeoman 0
4747724 2279843 2279843 defendant Wode John de yeoman 590715 590715 Wode, John de, of Byngley, yeoman 1
4873743 2318727 2318727 defendant Walker William husbandman 590715 590715 Walker, William, of Byngley, husbandman 9
4873744 2318727 2318727 defendant Page Thomas fletcher 590715 590715 Page, Thomas, of Byngley, fletcher 10
4950583 2342144 2342144 defendant Been John yeoman 590715 590715 Been, John, of Byngley, yeoman 0
4951109 2342310 2342310 defendant Colyngworth Margaret widow of Colyngworth 590715 590715 Colyngworth, Margaret, of Byngley, widow of Colyngworth 1
4987317 2353156 2353156 defendant Walker William walker 590715 590715 Walker, William, of Byngley, walker 0
4999442 2356703 2356703 defendant Mylner Robert husbandman 590715 590715 Mylner, Robert, of Byngley, husbandman 2
5004102 2358088 2358088 defendant Bene John yeoman 590715 590715 Bene, John, of Byngley, yeoman 0
5009045 2359529 2359529 defendant (not given) John vicar of Hunt 590715 590715 Hunt, John, of Byngley, vicar of the parish church 3
5030544 2365804 2365804 defendant Bene John yeoman 590715 590715 Bene, John, of Byngley, yeoman 0
5058600 2374129 2374129 defendant Byngley Robert yeoman 590715 590715 Byngley, Robert, of Byngley, yeoman 0
5139003 2397899 2397899 defendant Andrewe Richard husbandman 590715 590715 Andrewe, Richard, of byngley, husbandman 5
5226998 2423548 2423548 defendant Thorneton Robert husbandman 590715 590715 Thorneton, Robert, of Byngley, husbandman 3
5272806 2437122 2437122 defendant Wode John smith 590715 590715 Wode, John, of Byngley, smith 1
5288175 2441560 2441560 defendant Wode John smith 590715 590715 Wode, John, of Byngley, smith 0
5298686 2444590 2444590 defendant Wod Thomas yeoman 590715 590715 Wod, Thomas, of Byngley, yeoman 1
5369215 2465972 2465972 defendant Page Robert laborer 590715 590715 Page, Robert, of Byngley, laborer 4
5403443 2476058 2476058 defendant Dughty Richard yeoman 590715 590715 Dughty, Richard, of Byngley, yeoman 1
5416514 2479857 2479857 defendant Dughty Richard yeoman 590715 590715 Dughty, Richard, of Byngley, yeoman 1
5433400 2484948 2484948 defendant Dughty Richard yeoman 590715 590715 Dughty, Richard, of Byngley, yeoman 1
5433405 2484949 2484949 defendant Dughty Richard yeoman 590715 590715 Dughty, Richard, of Byngley, yeoman 1
5511716 2508514 2508514 defendant Wales Edmund laborer 590715 590715 Wales, Edmund, of Byngley, laborer 1
5536165 2515804 2515804 defendant Kyghley Richard yeoman 590715 590715 Kyghley, Richard, of Byngley, yeoman 0
5536167 2515805 2515805 defendant Leythley Richard yeoman 590715 590715 Leythley, Richard, of Byngley, yeoman 0
5541366 2517415 2517415 defendant Long John clerk 590715 590715 Long, John, of Byngley, clerk 0
5550831 2520274 2520274 defendant Milner John husbandman 590715 590715 Milner, John, of Byngley, husbandman 3
5555250 2521540 2521540 defendant Bene Robert yeoman 590715 590715 Bene, Robert, of Byngley, yeoman 0
5555251 2521540 2521540 defendant Bene Christopher yeoman 590715 590715 Bene, Christopher, of Byngley, yeoman 1
5557067 2522025 2522025 defendant Litster Otwell dyer 590715 590715 Litster, Otwell, of Byngley, dyer 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);