names

37 rows where place_id = 594383

✎ 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
3615881 1872606 1872606 plaintiff Coveney William yeoman 594383 594383 Coveney, William, of West Farlegh, yeoman 0
3652475 1911105 1911105 defendant Reve Thomas   594383 594383 Reve, Thomas, of West Farlegh, hard hewer 0
3659845 1913334 1913334 defendant Harenden Richard (legal representative) 594383 594383 Harenden, Richard, of West Farlegh, gent, executrix of 0
3659846 1913334 1913334 defendant Harenden Margery widow 594383 594383 Harenden, Margery, of West Farlegh, widow 1
3660331 1913492 1913492 defendant Iden Robert gent 594383 594383 Iden, Robert, of West Farlegh, gent 0
3707989 1928793 1928793 defendant Croft Richard clerk 594383 594383 Croft, Richard, of West Farlegh, clerk 1
3745277 1940431 1940431 defendant Eden Robert gent 594383 594383 Eden, Robert, of West Farlegh, gent 0
3745278 1940431 1940431 defendant Baker Richard yeoman 594383 594383 Baker, Richard, of West Farlegh, yeoman 1
3753760 1943118 1943118 defendant Coveney Thomas (legal representative) 594383 594383 Coveney, Thomas, of West Farlegh, yeoman, executor of 0
3753761 1943118 1943118 defendant Coveney John yeoman 594383 594383 Coveney, John, of West Farlegh, yeoman 1
3785825 1953354 1953354 defendant Iden Robert gent 594383 594383 Iden, Robert, of West Farlegh, gent 0
3817066 1963251 1963251 defendant Reve Thomas, senior (legal representative) 594383 594383 Reve, Thomas, senior, of West Farlegh, mason, executor of 0
3817067 1963251 1963251 defendant Recorde Robert yeoman 594383 594383 Recorde, Robert, of West Farlegh, yeoman 1
4414074 2169305 2169305 plaintiff Clerk Richard le   594383 594383 Clerk, Richard le, of West Farlegh 0
4421181 2171519 2171519 plaintiff Clerk Richard le   594383 594383 Clerk, Richard le, of West Farlegh 0
4521248 2206993 2206993 defendant Peyntour John   594383 594383 Peyntour, John, of West Farlegh, vicar 0
4567822 2221508 2221508 defendant Tere John   594383 594383 Tere, John, of West Farlegh 0
4652148 2246610 2246610 defendant Poucy or Poncy Richard   594383 594383 Poucy or Poncy, Richard, of West Farlegh, mason 3
4658438 2248519 2248519 defendant atte Nasshe William ploughman 594383 594383 atte Nasshe, William, of West Farlegh, ploughman 0
4730525 2274746 2274746 defendant Rasyll John carpenter 594383 594383 Rasyll, John, of West Farlegh, carpenter 0
4851307 2311855 2311855 defendant Houte or Honte William husbandman 594383 594383 Houte or Honte, William, of West Farlegh, husbandman 0
4851309 2311856 2311856 defendant Honte or Houte William husbandman 594383 594383 Honte or Houte, William, of West Farlegh, husbandman 0
4866084 2316364 2316364 defendant Knyght Adam laborer 594383 594383 Knyght, Adam, of West Farlegh, laborer 0
4928545 2335356 2335356 defendant Symon John smith 594383 594383 Symon, John, of West Farlegh, smith 0
5106311 2388286 2388286 defendant Beket Robert laborer 594383 594383 Beket, Robert, of West Farlegh, laborer 0
5159745 2403951 2403951 defendant Maylyn William husbandman 594383 594383 Maylyn, William, of West Farlegh, husbandman 3
5174725 2408309 2408309 defendant Maylyn William husbandman 594383 594383 Maylyn, William, of West Farlegh, husbandman 3
5233552 2425406 2425406 defendant Doweney Thomas smith 594383 594383 Doweney, Thomas, of West Farlegh, smith 2
5233557 2425407 2425407 defendant Dowener Thomas smith 594383 594383 Dowener, Thomas, of West Farlegh, smith 1
5356568 2462123 2462123 defendant Nassh John husbandman 594383 594383 Nassh, John, of West Farlegh, husbandman 1
5375881 2468048 2468048 defendant Culter Clement husbandman 594383 594383 Culter, Clement, of West Farlegh, husbandman 4
5433172 2484886 2484886 defendant Jurdan Margery widow 594383 594383 Jurdan, Margery, of West Farlegh, widow 3
5448999 2489593 2489593 defendant Jurdan Margery widow 594383 594383 Jurdan, Margery, of West Farlegh, widow 3
5461176 2493290 2493290 defendant Jurdan Margaret widow 594383 594383 Jurdan, Margaret, of West Farlegh, widow 3
5484267 2500219 2500219 defendant Jurdan Margery widow 594383 594383 Jurdan, Margery, of West Farlegh, widow 5
5491634 2502388 2502388 defendant Coveney Thomas husbandman 594383 594383 Coveney, Thomas, of West Farlegh, husbandman 0
5509188 2507731 2507731 defendant Buntfloure Thomas   594383 594383 Buntfloure, Thomas, of West Farlegh 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);