names

30 rows where place_id = 591045

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603136 1868645 1868645 defendant Gyllam John butcher 591045 591045 Gyllam, John, of West Pekham, butcher 0
3630753 1904443 1904443 defendant Tuttesham John gent 591045 591045 Tuttesham, John, of West Pekham, gent 0
3699549 1926091 1926091 defendant Tuttesham Richard gent 591045 591045 Tuttesham, Richard, of West Pekham, gent 0
3731704 1936145 1936145 defendant Tuttesham Richard gent 591045 591045 Tuttesham, Richard, of West Pekham, gent 0
3731706 1936145 1936145 defendant Calowey John laborer 591045 591045 Calowey, John, of West Pekham, laborer 2
3742483 1939519 1939519 defendant Usmere John husbandman 591045 591045 Usmere, John, of West Pekham, husbandman 0
3742485 1939520 1939520 defendant Whelar Richard   591045 591045 Whelar, Richard, of West Pekham, knight 0
3742486 1939520 1939520 defendant Edmond John carpenter 591045 591045 Edmond, John, of West Pekham, carpenter 1
3744420 1940157 1940157 plaintiff Baker Richard, senior   591045 591045 Baker, Richard, senior, of West Pekham 0
3744422 1940157 1940157 defendant Emond John carpenter 591045 591045 Emond, John, of West Pekham, carpenter 1
3767331 1947427 1947427 defendant Tuttesham Richard   591045 591045 Tuttesham, Richard, of West Pekham 1
3771939 1948917 1948917 defendant Mayster John thatcher 591045 591045 Mayster, John, of West Pekham, thatcher 0
3771940 1948917 1948917 defendant Fyssher John yeoman 591045 591045 Fyssher, John, of West Pekham, yeoman 1
3771941 1948917 1948917 defendant Rede William laborer 591045 591045 Rede, William, of West Pekham, laborer 2
3772086 1948961 1948961 defendant Totesham Richard gent 591045 591045 Totesham, Richard, of West Pekham, gent 0
3772345 1949036 1949036 defendant Deye William yeoman 591045 591045 Deye, William, of West Pekham, yeoman 0
3789796 1954640 1954640 defendant Nele Robert husbandman 591045 591045 Nele, Robert, of West Pekham, husbandman 0
3821366 1964576 1964576 defendant Manton Robert joiner 591045 591045 Manton, Robert, of West Pekham, joiner 0
3845967 1972295 1972295 defendant Crottenden John (legal representative) 591045 591045 Crottenden, John, of West Pekham, yeoman, executrix of 0
3845968 1972295 1972295 defendant Crottenden Dorothy widow 591045 591045 Crottenden, Dorothy, of West Pekham, widow 1
3924881 1998639 1998639 defendant Bartylmewe William husbandman 591045 591045 Bartylmewe, William, of West Pekham, husbandman 2
4884209 2321970 2321970 defendant Godewyne Hugh yeoman 591045 591045 (Godewyne, Hugh, of West Pekham, yeoman 1
4951361 2342388 2342388 defendant Mayster Henry laborer 591045 591045 Mayster, Henry, of West Pekham, laborer 0
5423548 2482006 2482006 defendant Tunbregge Hugh yeoman 591045 591045 Tunbregge, Hugh, of West Pekham, yeoman 2
5507054 2507114 2507114 defendant Godyng Richard husbandman 591045 591045 Godyng, Richard, of West Pekham, husbandman 1
5565000 2524350 2524350 defendant Tuttesham John gent 591045 591045 Tuttesham, John, of West Pekham, gent 0
5565002 2524350 2524350 defendant Lymden John clothmaker 591045 591045 Lymden, John, of West Pekham, clothmaker 2
5587347 2531070 2531070 defendant Lymden John clothmaker 591045 591045 Lymden, John, of West Pekham, clothmaker 0
5607376 2537203 2537203 defendant Walker Hugh clerk 591045 591045 Walker, Hugh, of West Pekham, clerk 1
5607377 2537203 2537203 defendant Master Robert husbandman 591045 591045 Master, Robert, of West Pekham, husbandman 2

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