names

65 rows where place_id = 593633

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612653 1871597 1871597 defendant Yong Walter mariner 593633 593633 Yong, Walter, of Est Budlegh, mariner 0
3676778 1918773 1918773 defendant Coyle Robert chaplain 593633 593633 Coyle, Robert, of Est Budlegh, chaplain 0
3829863 1967232 1967232 defendant Kenewode Henry tucker 593633 593633 Kenewode, Henry, of Est Budlegh, tucker 2
3875502 1982048 1982048 defendant Brase William yeoman 593633 593633 Brase, William, of Est Budlegh, yeoman 2
3923027 1998008 1998008 defendant Rondell John husbandman 593633 593633 Rondell, John, of Est Budlegh, husbandman 0
4982012 2351538 2351538 defendant Neucombe Robert   593633 593633 Neucombe, Robert, of Est Budlegh, bailiff 2
5237663 2426598 2426598 defendant Toker John shipman 593633 593633 Toker, John, of Est Budlegh, shipman 0
5237664 2426598 2426598 defendant Wade William shipman 593633 593633 Wade, William, of Est Budlegh, shipman 1
5239665 2427187 2427187 defendant Brode John husbandman 593633 593633 Brode, John, of Est Budlegh, husbandman 0
5264094 2434527 2434527 defendant Pede John seaman 593633 593633 Pede, John, of Est Budlegh, seaman 0
5264096 2434528 2434528 defendant Pede John seaman 593633 593633 Pede, John, of Est Budlegh, seaman 0
5264432 2434632 2434632 defendant Moryn Richard husbandman 593633 593633 Moryn, Richard, of Est Budlegh, husbandman 0
5301978 2445545 2445545 defendant Kympe Henry mariner 593633 593633 Kympe, Henry, of East Budlegh, mariner 1
5322781 2451891 2451891 defendant Webber Henry (legal representative) 593633 593633 Webber, Henry, of Est Budlegh, husbandman, executors of 0
5322782 2451891 2451891 defendant Benet William weaver 593633 593633 (Benet, William, of Est Budlegh, weaver 1
5331457 2454487 2454487 defendant Canon John, junior fisher 593633 593633 Canon, John, junior, of Est Budlegh, fisher 0
5333263 2455021 2455021 defendant Pynsent John fisher 593633 593633 Pynsent, John, of Est Budlegh, fisher 0
5334229 2455306 2455306 defendant Walys William yeoman 593633 593633 Walys, William, of Est Budlegh, yeoman 0
5341687 2457594 2457594 defendant Lucas Walter mariner 593633 593633 Lucas, Walter, of Est Budlegh, mariner 0
5346901 2459188 2459188 defendant Chanon Simon tucker 593633 593633 Chanon, Simon, of Est Budlegh, tucker 1
5346904 2459189 2459189 defendant Chanon Simon tucker 593633 593633 Chanon, Simon, of Est Budlegh, tucker 1
5351940 2460710 2460710 defendant Seyntclere John gent 593633 593633 Seyntclere, John, of Est Budlegh, gent 0
5352128 2460772 2460772 defendant Morys John fisher 593633 593633 Morys, John, of Est Budlegh, fisher 0
5356309 2462046 2462046 defendant Revell or Renell John fisher 593633 593633 Revell or Renell, John, of Est Budlegh, fisher 7
5359811 2463107 2463107 defendant Seyntclere John gent 593633 593633 Seyntclere, John, of Est Budlegh, gent 0
5360288 2463255 2463255 defendant Benet John tailor 593633 593633 Benet, John, of Est Budlegh, tailor 0
5360289 2463255 2463255 defendant Nycoll Thomas butcher 593633 593633 Nycoll, Thomas, of Est Budlegh, butcher 1
5360290 2463255 2463255 defendant Peryman Mathew laborer 593633 593633 Peryman, Mathew, of Est Budlegh, laborer 2
5360291 2463255 2463255 defendant Lenne Luke husbandman 593633 593633 Lenne, Luke, of Est Budlegh, husbandman 3
5360294 2463256 2463256 defendant Benet John tailor 593633 593633 Benet, John, of Est Budlegh, tailor 0
5360295 2463256 2463256 defendant Nycoll Thomas butcher 593633 593633 Nycoll, Thomas, of Est Budlegh, butcher 1
5360296 2463256 2463256 defendant Peryman Mathew laborer 593633 593633 Peryman, Mathew, of Est Budlegh, laborer 2
5360297 2463256 2463256 defendant Lenne Luke husbandman 593633 593633 Lenne, Luke, of Est Budlegh, husbandman 3
5360366 2463278 2463278 defendant Benet William yeoman 593633 593633 Benet, William, of Est Budlegh, yeoman 0
5360367 2463278 2463278 defendant Benet John tailor 593633 593633 Benet, John, of Est Budlegh, tailor 1
5360368 2463278 2463278 defendant Lenne Luke yeoman 593633 593633 Lenne, Luke, of Est Budlegh, yeoman 2
5360369 2463278 2463278 defendant Peryman Mathew yeoman 593633 593633 Peryman, Mathew, of Est Budlegh, yeoman 3
5360370 2463278 2463278 defendant Chanon Simon   593633 593633 Chanon, Simon, of Est Budlegh, groom 4
5360373 2463279 2463279 defendant Benet William yeoman 593633 593633 Benet, William, of Est Budlegh, yeoman 0
5360374 2463279 2463279 defendant Lenne Luke yeoman 593633 593633 Lenne, Luke, of Est Budlegh, yeoman 1
5360375 2463279 2463279 defendant Peryman Mathew yeoman 593633 593633 Peryman, Mathew, of Est Budlegh, yeoman 2
5360376 2463279 2463279 defendant Chanon Simon   593633 593633 Chanon, Simon, of Est Budlegh, groom 3
5360380 2463280 2463280 defendant Benet William yeoman 593633 593633 together with Benet, William, of Est Budlegh, yeoman 1
5360381 2463280 2463280 defendant Benet John tailor 593633 593633 Benet, John, of Est Budlegh, tailor 2
5360382 2463280 2463280 defendant Lenne Luke yeoman 593633 593633 Lenne, Luke, of Est Budlegh, yeoman 3
5360383 2463280 2463280 defendant Peryman Mathew yeoman 593633 593633 Peryman, Mathew, of Est Budlegh, yeoman 4
5360384 2463280 2463280 defendant Chanon simon   593633 593633 Chanon, simon, of Est Budlegh, groom 5
5399651 2474986 2474986 defendant Nycoll Thoma butcher 593633 593633 Nycoll, Thoma, of East Budlegh, butcher 0
5399652 2474986 2474986 defendant Burgeys Richard husbandman 593633 593633 Burgeys, Richard, of East Budlegh, husbandman 1
5399655 2474987 2474987 defendant Nycoll Thomas butcher 593633 593633 Nycoll, Thomas, of East Budlegh, butcher 0
5399656 2474987 2474987 defendant Burgeys Richard husbandman 593633 593633 Burgeys, Richard, of East Budlegh, husbandman 1
5411132 2478287 2478287 defendant Moren Richard husbandman 593633 593633 Moren, Richard, of East Budlegh, husbandman 0
5412689 2478743 2478743 defendant Nicholl Thomas butcher 593633 593633 Nicholl, Thomas, of East Budlegh, butcher 0
5412690 2478743 2478743 defendant Burgeys Richard husbandman 593633 593633 Burgeys, Richard, of East Budlegh, husbandman 1
5412693 2478744 2478744 defendant Nycoll Thomas butcher 593633 593633 Nycoll, Thomas, of East Budlegh, butcher 0
5412694 2478744 2478744 defendant burgeys Richard husbandman 593633 593633 burgeys, Richard, of East Budlegh, husbandman 1
5435237 2485471 2485471 defendant Raynold John clerk 593633 593633 Raynold, John, of East Budlegh, clerk 0
5436216 2485770 2485770 defendant Nele Robert laborer 593633 593633 Nele, Robert, of East Budlegh, laborer 0
5450299 2489973 2489973 defendant Reynold John clerk 593633 593633 Reynold, John, of East Budlegh, clerk 1
5450793 2490126 2490126 defendant Chanon John husbandman 593633 593633 Chanon, John, of East Budlegh, husbandman 0
5450973 2490181 2490181 defendant Nele Robert   593633 593633 Nele, Robert, of East Budlegh 0
5462450 2493672 2493672 defendant Raynold John clerk 593633 593633 Raynold, John, of East Budlegh, clerk 0
5473991 2497195 2497195 defendant and Reynold John clerk 593633 593633 and Reynold, John, of East Budlegh, clerk 1
5474411 2497327 2497327 defendant Perey John husbandman 593633 593633 Perey, John, of East Budlegh, husbandman 0
5532920 2514837 2514837 defendant Veyse John yeoman 593633 593633 Veyse, John, of Est Budlegh, yeoman 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);