names

41 rows where place_id = 598426

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632417 1904956 1904956 defendant Bronde Simon tailor 598426 598426 Bronde, Simon, of Wendlyng, tailor 0
3667821 1915877 1915877 defendant Neve Robert husbandman 598426 598426 Neve, Robert, of Wendlyng, husbandman 1
3716537 1931468 1931468 plaintiff Colyn John (legal representative) 598426 598426 Colyn, John, of Wendlyng, executor of 0
3732101 1936274 1936274 plaintiff Colyn John (legal representative) 598426 598426 Colyn, John, of Wendlyng, or of Skernyng, executor of 0
3912010 1994340 1994340 defendant Body John butcher 598426 598426 Body, John, of Wendlyng, butcher 2
3928021 1999708 1999708 defendant Hovell Robert yeoman 598426 598426 Hovell, Robert, of Wendlyng, yeoman 8
3936424 2002505 2002505 plaintiff Marham Thomas (legal representative) 598426 598426 Marham, Thomas, of Wendlyng, executrix of 0
3936428 2002506 2002506 plaintiff Marham Thomas (legal representative) 598426 598426 Marham, Thomas, of Wendlyng, executrix of 0
3939473 2003508 2003508 defendant Kytmer Nicholas carpenter 598426 598426 Kytmer, Nicholas, of Wendlyng, carpenter 1
3945135 2005393 2005393 defendant Borom Adam husbandman 598426 598426 Borom, Adam, of Wendlyng, husbandman 0
3993063 2022269 2022269 defendant Mynne William gent 598426 598426 Mynne, William, of Wendlyng, gent 0
4578978 2224907 2224907 defendant Brysle John   598426 598426 Brysle, John, of Wendlyng, abbot 0
4692093 2263057 2263057 defendant Heryngsawe Simon husbandman 598426 598426 Heryngsawe, Simon, of Wendlyng, husbandman 0
4692094 2263057 2263057 defendant Heye Edmund husbandman 598426 598426 Heye, Edmund, of Wendlyng, husbandman 1
4692095 2263057 2263057 defendant Heryngsawe John husbandman 598426 598426 Heryngsawe, John, of Wendlyng, husbandman 2
4692096 2263057 2263057 defendant Heye John husbandman 598426 598426 Heye, John, of Wendlyng, husbandman 3
4717121 2270684 2270684 defendant Greve Henry yeoman 598426 598426 Greve, Henry, of Wendlyng, yeoman 0
4856020 2313255 2313255 defendant Kentyng John shoemaker 598426 598426 Kentyng, John, of Wendlyng, shoemaker 0
4890930 2323911 2323911 plaintiff Codlyng Thomas, senior   598426 598426 Codlyng, Thomas, senior, of Wendlyng 0
4890931 2323911 2323911 plaintiff Codlyng Thomas   598426 598426 Codlyng, Thomas, of Wendlyng 1
4890932 2323911 2323911 plaintiff Codlyng John, junior   598426 598426 Codlyng, John, junior, of Wendlyng 2
5014382 2361067 2361067 defendant Copelond William yeoman 598426 598426 Copelond, William, of Wendlyng, yeoman 1
5014383 2361067 2361067 defendant Spencer Robert yeoman 598426 598426 Spencer, Robert, of Wendlyng, yeoman 2
5035118 2367134 2367134 defendant Copelond William yeoman 598426 598426 Copelond, William, of Wendlyng, yeoman 1
5035119 2367134 2367134 defendant Spencer Robert yeoman 598426 598426 Spencer, Robert, of Wendlyng, yeoman 2
5040815 2368868 2368868 defendant Coupelond John yeoman 598426 598426 Coupelond, John, of Wendlyng, yeoman 1
5105433 2388029 2388029 defendant Clerk Thomas thatcher 598426 598426 Clerk, Thomas, of Wendlyng, thatcher 1
5208082 2418096 2418096 defendant Fyssher John husbandman 598426 598426 Fyssher, John, of Wendlyng, husbandman 0
5319618 2450962 2450962 defendant Wryght John husbandman 598426 598426 Wryght, John, of Wendlyng, husbandman 0
5445569 2488571 2488571 plaintiff Ferrour John (legal representative) 598426 598426 Ferrour, John, of Wendlyng, executors of 0
5481329 2499359 2499359 plaintiff Ferrour John, junior (legal representative) 598426 598426 Ferrour, John, junior, of Wendlyng, executors of 0
5481338 2499360 2499360 plaintiff Ferrour John, junior (legal representative) 598426 598426 Ferrour, John, junior, of Wendlyng, executors of 0
5481344 2499361 2499361 plaintiff Ferrour John, junior (legal representative) 598426 598426 Ferrour, John, junior, of Wendlyng, executors of 0
5481362 2499364 2499364 plaintiff Ferrour John (legal representative) 598426 598426 Ferrour, John, of Wendlyng, executors of 0
5498807 2504582 2504582 defendant Yelverton Nicholas esq 598426 598426 Yelverton, Nicholas, of Wendlyng, esq 0
5498809 2504583 2504583 defendant Yelverton Nicholas esq 598426 598426 Yelverton, Nicholas, of Wendlyng, esq 0
5504040 2506180 2506180 defendant Byrde Robert husbandman 598426 598426 Byrde, Robert, of Wendlyng, husbandman 0
5516538 2510002 2510002 defendant Yelverton Nicholas gent 598426 598426 Yelverton, Nicholas, of Wendlyng, gent 0
5517295 2510247 2510247 defendant Yelverton Nicholas gent 598426 598426 Yelverton, Nicholas, of Wendlyng, gent 0
5608082 2537435 2537435 defendant Brounde Simon husbandman 598426 598426 Brounde, Simon, of Wendlyng, husbandman 0
5608088 2537436 2537436 defendant Cokden John tailor 598426 598426 Cokden, John, of Wendlyng, tailor 4

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