names

39 rows where place_id = 589649

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598289 1867096 1867096 defendant Wellys James husbandman 589649 589649 Wellys, James, of Lyston, Essex, husbandman 1
3610659 1871003 1871003 defendant Smyth William yeoman 589649 589649 Smyth, William, of Lyston, Essex, yeoman 0
3664688 1914908 1914908 plaintiff Saye Thomas (legal representative) 589649 589649 Saye, Thomas, of Lyston, Essex, administrator of 0
3665240 1915083 1915083 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3665244 1915084 1915084 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3698562 1925768 1925768 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3698564 1925769 1925769 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3745071 1940365 1940365 defendant Clopton William gent 589649 589649 Clopton, William, of Lyston, Essex, gent 0
3777560 1950734 1950734 defendant Pepyn William yeoman 589649 589649 Pepyn, William, of Lyston, Essex, yeoman 0
3795186 1956361 1956361 defendant Maykyn William husbandman 589649 589649 Maykyn, William, of Lyston, Essex, husbandman 2
3806343 1959899 1959899 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3824008 1965385 1965385 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
3841914 1971040 1971040 defendant Clopton William gent 589649 589649 Clopton, William, of Lyston, Essex, gent 1
3858438 1976298 1976298 defendant Clopton William gent 589649 589649 Clopton, William, of Lyston, Essex, gent 0
4146652 2076981 2076981 defendant Clopton William   589649 589649 Clopton, William, of Lyston, Essex, esq, son of William Clopton 0
4159290 2081319 2081319 defendant Dycke Thomas (legal representative) 589649 589649 Dycke, Thomas, of Lyston, Essex, yeoman, executor of 2
4183057 2089557 2089557 defendant Dycke Thomas (legal representative) 589649 589649 Dycke, Thomas, of Lyston, Essex, yeoman, executor of 0
4191608 2092624 2092624 defendant Clopton Wlliam esq 589649 589649 Clopton, Wlliam, of Lyston, Essex, esq 1
4233766 2107334 2107334 defendant Lowther William clerk 589649 589649 Lowther, William, of Lyston, Essex, clerk 1
4236963 2108506 2108506 defendant Lowther William clerk 589649 589649 Lowther, William, of Lyston, Essex, clerk 0
4250504 2113157 2113157 defendant Clopton William, senior esq 589649 589649 Clopton, William, senior, of Lyston, Essex, esq 0
4264748 2117851 2117851 defendant Clopton William, senior esq 589649 589649 Clopton, William, senior, of Lyston, Essex, esq 0
4278516 2122420 2122420 defendant Lowther William clerk 589649 589649 Lowther, William, of Lyston, Essex, clerk 0
4339383 2143543 2143543 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
4339386 2143544 2143544 defendant Clopton William esq 589649 589649 Clopton, William, of Lyston, Essex, esq 0
4347906 2146520 2146520 defendant Hume John yeoman 589649 589649 Hume, John, of Lyston, Essex, yeoman 1
4347911 2146521 2146521 defendant Rogers Edward husbandman 589649 589649 Rogers, Edward, of Lyston, Essex, husbandman 2
4348844 2146858 2146858 defendant Clopton William, senior esq 589649 589649 Clopton, William, senior, of Lyston, Essex, esq 0
5139645 2398070 2398070 defendant Pylbergh Stephen   589649 589649 Pylbergh, Stephen, of Lyston, Essex, parson 0
5160557 2404178 2404178 defendant Pilbergh Stephen   589649 589649 Pilbergh, Stephen, of Lyston, Essex, parson 0
5184217 2411127 2411127 defendant Wynde Henry yeoman 589649 589649 Wynde, Henry, of Lyston, Essex, yeoman 0
5196402 2414700 2414700 defendant Wynd Henry husbandman 589649 589649 Wynd, Henry, of Lyston, Essex, husbandman 2
5204225 2416991 2416991 defendant Wynde Henry yeoman 589649 589649 Wynde, Henry, of Lyston, Essex, yeoman 0
5209627 2418554 2418554 defendant Wynd Henry husbandman 589649 589649 Wynd, Henry, of Lyston, Essex, husbandman 2
5217460 2420845 2420845 defendant Prynse William merchant 589649 589649 Prynse, William, of Lyston, Essex, merchant 0
5359927 2463145 2463145 defendant Smyth alias Couper William yeoman 589649 589649 Smyth alias Couper, William, of Lyston, Essex, yeoman 0
5451243 2490251 2490251 defendant Howarde John miller 589649 589649 Howarde, John, of Lyston, Essex, miller 0
5599956 2534868 2534868 defendant Reve John husbandman 589649 589649 Reve, John, of Lyston, Essex, husbandman 0
5607894 2537374 2537374 plaintiff Wye Thomas (legal representative) 589649 589649 Wye, Thomas, of Lyston, Essex, esq, administrator of 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);