names

58 rows where place_id = 587330

✎ 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
3591103 1864841 1864841 defendant Coldyche Edmund shoemaker 587330 587330 Coldyche, Edmund, of Thorneham, shoemaker 1
3591105 1864841 1864841 defendant Coldyk John shoemaker 587330 587330 Coldyk, John, of Thorneham, shoemaker 3
3597246 1866760 1866760 defendant Culter Nicholas husbandman 587330 587330 Culter, Nicholas, of Thorneham, husbandman 7
3616726 1872861 1872861 defendant Culter Nicholas husbandman 587330 587330 Culter, Nicholas, of Thorneham, husbandman 0
3616728 1872862 1872862 defendant Culter Nicholas husbandman 587330 587330 Culter, Nicholas, of Thorneham, husbandman 0
3616729 1872862 1872862 defendant Fate John laborer 587330 587330 Fate, John, of Thorneham, laborer 1
3616733 1872863 1872863 defendant Culter Nicholas husbandman 587330 587330 Culter, Nicholas, of Thorneham, husbandman 2
3634214 1905501 1905501 defendant Pokyll John husbandman 587330 587330 Pokyll, John, of Thorneham, husbandman 0
3809795 1960951 1960951 defendant Stele Robert husbandman 587330 587330 Stele, Robert, of Thorneham, husbandman 0
3851673 1974110 1974110 defendant Baker Thomas   587330 587330 Baker, Thomas, of Thorneham, shepherd 0
3871729 1980782 1980782 defendant Jamson Katherine spinster 587330 587330 Jamson, Katherine, of Thorneham, spinster 0
3906933 1992607 1992607 plaintiff Myller John yeoman 587330 587330 Myller, John, of Thorneham, yeoman 0
3928732 1999946 1999946 defendant Dyxson John yeoman 587330 587330 Dyxson, John, of Thorneham, yeoman 1
3944194 2005074 2005074 defendant Goodwyn Valentine merchant 587330 587330 Goodwyn, Valentine, of Thorneham, merchant 0
3952572 2007969 2007969 defendant Stone John yeoman 587330 587330 Stone, John, of Thorneham, yeoman 0
3960308 2010699 2010699 defendant Jervys Robert husbandman 587330 587330 Jervys, Robert, of Thorneham, husbandman 0
3970175 2014167 2014167 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 0
3972994 2015128 2015128 defendant Yonge John husbandman 587330 587330 Yonge, John, of Thorneham, husbandman 0
3972995 2015128 2015128 defendant Ede John husbandman 587330 587330 Ede, John, of Thorneham, husbandman 1
3972996 2015128 2015128 defendant Richardson Thomas husbandman 587330 587330 Richardson, Thomas, of Thorneham, husbandman 2
3972997 2015128 2015128 defendant Waterden Simon husbandman 587330 587330 Waterden, Simon, of Thorneham, husbandman 3
3978162 2016942 2016942 defendant Stone John yeoman 587330 587330 Stone, John, of Thorneham, yeoman 0
3983497 2018871 2018871 defendant Goodwyn Valentine merchant 587330 587330 Goodwyn, Valentine, of Thorneham, merchant 0
4004404 2026354 2026354 defendant Bryd John knacker 587330 587330 Bryd, John, of Thorneham, knacker 2
4029805 2035303 2035303 defendant Ferrar John   587330 587330 Ferrar, John, of Thorneham tailor 2
4033281 2036558 2036558 defendant Bynley George mercer 587330 587330 Bynley, George, of Thorneham, mercer 0
4089534 2056544 2056544 defendant Browne John glover 587330 587330 Browne, John, of Thorneham, glover 1
4099032 2059980 2059980 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 0
4099189 2060035 2060035 defendant Smothynge Thomas yeoman 587330 587330 Smothynge, Thomas, of Thorneham, yeoman 0
4111231 2064266 2064266 defendant Olyver Edward tailor 587330 587330 Olyver, Edward, of Thorneham, gent, tailor 0
4111232 2064266 2064266 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 1
4152970 2079145 2079145 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 0
4155920 2080148 2080148 defendant Curckwood Ingram shoemaker 587330 587330 Curckwood, Ingram, of Thorneham, shoemaker 2
4161851 2082212 2082212 defendant Goodwyn Valentine yeoman 587330 587330 Goodwyn, Valentine, of Thorneham, yeoman 1
4205662 2097531 2097531 defendant Olyver Edward tailor 587330 587330 Olyver, Edward, of Thorneham, tailor 0
4209953 2099044 2099044 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 1
4217043 2101456 2101456 defendant Olyver Edward yeoman 587330 587330 Olyver, Edward, of Thorneham, yeoman 0
4217044 2101456 2101456 defendant Yonge Richard husbandman 587330 587330 Yonge, Richard, of Thorneham, husbandman 1
4217045 2101456 2101456 defendant Yonge Thomas husbandman 587330 587330 Yonge, Thomas, of Thorneham, husbandman 2
4290590 2126691 2126691 defendant Goodwyn Valentikne gent 587330 587330 Goodwyn, Valentikne, of Thorneham, gent 0
4309445 2133465 2133465 defendant Wylson William clerk 587330 587330 Wylson, William, of Thorneham, clerk 3
4317179 2136121 2136121 defendant Oliver Edward yeoman 587330 587330 Oliver, Edward, of Thorneham, yeoman 0
4317180 2136121 2136121 defendant Gade or Eade John yeoman 587330 587330 Gade or Eade, John, of Thorneham, yeoman 1
4321970 2137768 2137768 defendant Olyve or Clyfe Edward yeoman 587330 587330 Olyve or Clyfe, Edward, of Thorneham, yeoman 3
4323337 2138224 2138224 defendant Wylson William clerk 587330 587330 Wylson, William, of Thorneham, clerk 2
4332775 2141243 2141243 defendant Sparke Robert tanner 587330 587330 Sparke, Robert, of Thorneham, tanner 3
4382633 2158898 2158898 defendant Todd Robert clerk 587330 587330 Todd, Robert, of Thorneham, clerk 1
4382636 2158898 2158898 defendant Yonge Cecily widow 587330 587330 Yonge, Cecily, of Thorneham, widow 4
4406575 2166764 2166764 defendant Goodwyn Valentine gent 587330 587330 Goodwyn, Valentine, of Thorneham, gent 1
4639064 2242944 2242944 plaintiff Clerk John   587330 587330 Clerk, John, of Thorneham 0
4847459 2310706 2310706 defendant Funne Thomas   587330 587330 Funne, Thomas, of Thorneham, bailiff 1
4875148 2319181 2319181 defendant Funne Thomas   587330 587330 Funne, Thomas, of Thorneham, bailiff 1
5037754 2367916 2367916 defendant Pyx John yeoman 587330 587330 Pyx, John, of Thorneham, yeoman 0
5223935 2422684 2422684 defendant Fyssher John yeoman 587330 587330 Fyssher, John, of Thorneham, yeoman 0
5489521 2501747 2501747 defendant Culter Nicholas husbandman 587330 587330 Culter, Nicholas, of Thorneham, husbandman 1
5551664 2520526 2520526 defendant Edward Thomas yeoman 587330 587330 Edward, Thomas, of Thorneham, yeoman 2
5560753 2523111 2523111 defendant Wyseman John esq 587330 587330 Wyseman, John, of Thorneham, esq 0
5575925 2527548 2527548 defendant Wyseman John esq 587330 587330 Wyseman, John, of Thorneham, esq 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);