names

66 rows where place_id = 621323

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3740781 1938973 1938973 defendant Beverley Thomas gent 621323 621323 Beverley, Thomas, of Selby, Yorks, gent 2
3829659 1967167 1967167 defendant Hamond Anthony gent 621323 621323 Hamond, Anthony, of Selby, Yorks, gent 3
3883514 1984757 1984757 defendant Harryson Robert ferryman 621323 621323 Harryson, Robert, of Selby, Yorks, ferryman 0
3883516 1984758 1984758 defendant Cokson Amor gent 621323 621323 Cokson, Amor, of Selby, Yorks, gent 0
3896638 1989087 1989087 defendant Haryson Robert yeoman 621323 621323 Haryson, Robert, of Selby, Yorks, yeoman 0
3930916 2000679 2000679 defendant Greneacre Ralph gent 621323 621323 Greneacre, Ralph, of Selby, Yorks, gent 0
3936560 2002551 2002551 defendant Stryngar Thomas yeoman 621323 621323 Stryngar, Thomas, of Selby, Yorks, yeoman 2
3979294 2017343 2017343 defendant Langley James yeoman 621323 621323 Langley, James, of Selby, Yorks, yeoman 0
3994090 2022636 2022636 defendant Beverley William gent 621323 621323 Beverley, William, of Selby, Yorks, gent 1
4012375 2029147 2029147 defendant Beverley William gent 621323 621323 Beverley, William, of Selby, Yorks, gent 0
4114820 2065587 2065587 defendant Goldall Richard merchant 621323 621323 Goldall, Richard, of Selby, Yorks, merchant 0
4261073 2116670 2116670 defendant Leigh William gent 621323 621323 Leigh, William, of Selby, Yorks, gent 0
4308046 2132961 2132961 defendant Akehed or Akeid Thomas chapman 621323 621323 Akehed or Akeid, Thomas, of Selby, Yorks, chapman 1
4341981 2144475 2144475 defendant Fisher John chapman 621323 621323 Fisher, John, of Selby, Yorks, chapman 1
4365608 2152763 2152763 defendant Fysher John chapman 621323 621323 Fysher, John, of Selby, Yorks, chapman 1
4400139 2164637 2164637 defendant Inchbould John chapman 621323 621323 Inchbould, John, of Selby, Yorks, chapman 1
4401163 2164985 2164985 defendant Morley James gent 621323 621323 Morley, James, of Selby, Yorks, gent 0
4681834 2259930 2259930 defendant Barbour Robert barber 621323 621323 Barbour, Robert, of Selby, Yorks, barber 0
4684531 2260766 2260766 plaintiff Pygot William   621323 621323 Pygot, William, of Selby, Yorks, abbot 0
4721026 2271912 2271912 defendant Craven Thomas gent 621323 621323 Craven, Thomas, of Selby, Yorks, gent 2
4751471 2280913 2280913 defendant Cravyn John   621323 621323 Cravyn, John, of Selby, Yorks, servant, of John Graa 1
4827215 2304562 2304562 defendant Charite Richard mercer 621323 621323 Charite, Richard, of Selby, Yorks, mercer 0
4882515 2321441 2321441 defendant Williamson alias Cheryte Richard chapman 621323 621323 Williamson alias Cheryte, Richard, of Selby, Yorks, chapman 0
4908584 2329241 2329241 defendant Bolton Thomas chapman 621323 621323 Bolton, Thomas, of Selby, Yorks, chapman 0
4908590 2329242 2329242 defendant Bolton Thomas chapman 621323 621323 Bolton, Thomas, of Selby, Yorks, chapman 0
4928958 2335483 2335483 defendant Brerehawe William gent 621323 621323 Brerehawe, William, of Selby, Yorks, gent 0
4933480 2336858 2336858 defendant Byset Thomas plasterer 621323 621323 Byset, Thomas, of Selby, Yorks, plasterer 3
4937299 2338031 2338031 defendant Elesson or Glesson William yeoman 621323 621323 Elesson or Glesson, William, of Selby, Yorks, yeoman 0
4937301 2338032 2338032 defendant Elesson or Glesson William yeoman 621323 621323 Elesson or Glesson, William, of Selby, Yorks, yeoman 0
4955701 2343672 2343672 defendant Panston or Pauston Walter merchant 621323 621323 Panston or Pauston, Walter, of Selby, Yorks, merchant 0
4955708 2343673 2343673 defendant Pauston or Panston Walter merchant 621323 621323 Pauston or Panston, Walter, of Selby, Yorks, merchant 0
4973643 2349070 2349070 defendant Charite Richard yeoman 621323 621323 Charite, Richard, of Selby, Yorks, yeoman 0
4979107 2350708 2350708 defendant Robert John gent 621323 621323 Robert, John, of Selby, Yorks, gent 0
5020343 2362833 2362833 defendant Barton William tailor 621323 621323 Barton, William, of Selby, Yorks, tailor 0
5027745 2364992 2364992 defendant Comberton John yeoman 621323 621323 Comberton, John, of Selby, Yorks, yeoman 0
5078905 2380176 2380176 defendant Saympill John merchant 621323 621323 Saympill, John, of Selby, Yorks, merchant 0
5078909 2380177 2380177 defendant Saympyll John merchant 621323 621323 Saympyll, John, of Selby, Yorks, merchant 0
5147458 2400403 2400403 defendant Dounyng William dyer 621323 621323 Dounyng, William, of Selby, Yorks, dyer 0
5162391 2404727 2404727 defendant Bolton Thomas chapman 621323 621323 Bolton, Thomas, of Selby, Yorks, chapman 0
5167162 2406130 2406130 defendant Donnynge William dyer 621323 621323 Donnynge, William, of Selby, Yorks, dyer 0
5182449 2410622 2410622 defendant Dounyng William dyer 621323 621323 Dounyng, William, of Selby, Yorks, dyer 0
5198634 2415359 2415359 defendant Bolton Thomas chapman 621323 621323 Bolton, Thomas, of Selby, Yorks, chapman 0
5215078 2420134 2420134 defendant Bolton Thomas chapman 621323 621323 Bolton, Thomas, of Selby, Yorks, chapman 0
5224650 2422879 2422879 defendant Paston William chapman 621323 621323 Paston, William, of Selby, Yorks, chapman 2
5232466 2425073 2425073 defendant Bryan Robert mercer 621323 621323 Bryan, Robert, of Selby, Yorks, mercer 0
5232470 2425074 2425074 defendant Bryan Robert mercer 621323 621323 Bryan, Robert, of Selby, Yorks, mercer 0
5256988 2432315 2432315 defendant Haxby Robert gent 621323 621323 Haxby, Robert, of Selby, Yorks, or of Maxby, Nhants, gent 0
5288065 2441525 2441525 defendant Palston William   621323 621323 Palston, William, of Selby, Yorks 2
5298014 2444431 2444431 defendant Crofton Robert husbandman 621323 621323 Crofton, Robert, of Selby, Yorks, husbandman 4
5305322 2446597 2446597 defendant Palston William merchant 621323 621323 Palston, William, of Selby, Yorks, merchant 0
5321012 2451377 2451377 defendant Broun John, senior yeoman 621323 621323 Broun, John, senior, of Selby, Yorks, yeoman 0
5326502 2453012 2453012 defendant Paweston William chapman 621323 621323 Paweston, William, of Selby, Yorks, chapman 0
5334444 2455374 2455374 defendant Plesauns Walter gent 621323 621323 Plesauns, Walter, of Selby, Yorks, gent 1
5348293 2459606 2459606 defendant Lacy John gent 621323 621323 Lacy, John, of Selby, Yorks, gent 0
5379092 2469056 2469056 defendant Burton Robert   621323 621323 Burton, Robert, of Selby, Yorks, of Fyppyn Parke, Crown Valet 0
5379096 2469057 2469057 defendant Burton Robert   621323 621323 Burton, Robert, of Selby, Yorks, of Fyppyn Parke, Crown Valet 0
5390826 2472441 2472441 defendant Chace Thomas gent 621323 621323 Chace, Thomas, of Selby, Yorks, gent 2
5430641 2484102 2484102 defendant Moundevill John yeoman 621323 621323 Moundevill, John, of Selby, Yorks, yeoman 0
5447285 2489076 2489076 defendant Moundevill John yeoman 621323 621323 Moundevill, John, of Selby, Yorks, yeoman 0
5459752 2492840 2492840 defendant Moundevyll John yeoman 621323 621323 Moundevyll, John, of Selby, Yorks, yeoman 0
5476970 2498117 2498117 defendant Burton Robert yeoman & King Edward's crown valet 621323 621323 Burton, Robert, of Selby, Yorks, yeoman & King Edward's crown valet 0
5501997 2505547 2505547 defendant Aderby Ralph yeoman 621323 621323 Aderby, Ralph, of Selby, Yorks, yeoman 0
5541986 2517619 2517619 defendant Gilson William gent 621323 621323 Gilson, William, of Selby, Yorks, gent 0
5542195 2517689 2517689 defendant Tote Henry yeoman 621323 621323 Tote, Henry, of Selby, Yorks, yeoman 2
5556359 2521855 2521855 defendant Storke John merchant of the staple 621323 621323 Storke, John, of Selby, Yorks, merchant of the staple 1
5556387 2521856 2521856 defendant Storke John merchant of the staple 621323 621323 Storke, John, of Selby, Yorks, merchant of the staple 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);