names

29 rows where place_id = 646854

✎ 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
3893160 1987953 1987953 defendant Bessakle Thomas yeoman 646854 646854 Bessakle, Thomas, of Fysshelake, yeoman 0
3893161 1987953 1987953 defendant Trymmyngham John yeoman 646854 646854 Trymmyngham, John, of Fysshelake, yeoman 1
3893162 1987953 1987953 defendant Butler John yeoman 646854 646854 Butler, John, of Fysshelake, yeoman 2
3907490 1992799 1992799 defendant Tremyngham John yeoman 646854 646854 Tremyngham, John, of Fysshelake, yeoman 0
3907492 1992800 1992800 defendant Tremyngham John yeoman 646854 646854 Tremyngham, John, of Fysshelake, yeoman 0
3944524 2005184 2005184 defendant Parker Mathew yeoman 646854 646854 Parker, Mathew, of Fysshelake, yeoman 0
3949978 2007073 2007073 defendant Newsom John husbandman 646854 646854 Newsom, John, of Fysshelake, husbandman 0
3979998 2017609 2017609 defendant Birdesall Thomas husbandman 646854 646854 Birdesall, Thomas, of Fysshelake, husbandman 0
3980000 2017610 2017610 defendant Johnson Henry clerk 646854 646854 Johnson, Henry, of Fysshelake, clerk 0
3980004 2017612 2017612 defendant Trymyngham William yeoman 646854 646854 Trymyngham, William, of Fysshelake, yeoman 0
3985155 2019445 2019445 defendant Parkyn Cuthbert laborer 646854 646854 Parkyn, Cuthbert, of Fysshelake, laborer 0
4010532 2028541 2028541 plaintiff Parkyn Thomas gent 646854 646854 Parkyn, Thomas, of Fysshelake, gent 0
4010535 2028542 2028542 defendant Bryan John husbandman 646854 646854 Bryan, John, of Fysshelake, husbandman 0
4603348 2232242 2232242 defendant Rogayte Richard   646854 646854 Rogayte, Richard, of Fysshelake 0
4740355 2277690 2277690 defendant Grave or Grane John shipman 646854 646854 Grave or Grane, John, of Fysshelake, shipman 0
4786778 2291919 2291919 defendant Helewys Robert flesshewer or butcher 646854 646854 Helewys, Robert, of Fysshelake, flesshewer or butcher 2
4787502 2292163 2292163 defendant Helewys Robert flesshewer or butcher 646854 646854 Helewys, Robert, of Fysshelake, flesshewer or butcher 1
4801612 2296688 2296688 plaintiff Wryght Richard husbandman 646854 646854 Wryght, Richard, of Fysshelake, husbandman 0
4874942 2319109 2319109 defendant Clerk William husbandman 646854 646854 Clerk, William, of Fysshelake, husbandman 0
4947208 2341116 2341116 defendant Busk John turner 646854 646854 (Busk, John, of Fysshelake, turner 1
4999586 2356752 2356752 defendant Duffeld John husbandman 646854 646854 Duffeld, John, of Fysshelake, husbandman 1
5129084 2394990 2394990 defendant Wright John yeoman 646854 646854 Wright, John, of Fysshelake, yeoman 0
5140802 2398425 2398425 defendant Coke John husbandman 646854 646854 Coke, John, of Fysshelake, husbandman 0
5236070 2426132 2426132 defendant Wate Richard gent 646854 646854 Wate, Richard, of Fysshelake, gent 1
5368143 2465663 2465663 defendant Barnby John gent 646854 646854 Barnby, John, of Fysshelake, gent 0
5398812 2474720 2474720 defendant Barnby John gent 646854 646854 Barnby, John, of Fysshelake, gent 0
5469629 2495836 2495836 defendant Barnby John gent 646854 646854 Barnby, John, of Fysshelake, gent 0
5482395 2499676 2499676 defendant Smyth John yeoman 646854 646854 Smyth, John, of Fysshelake, yeoman 0
5568304 2525274 2525274 defendant Hoolrudde Thomas husbandman 646854 646854 Hoolrudde, Thomas, of Fysshelake, husbandman 1

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