names

57 rows where place_id = 768907

✎ 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
4553293 2216962 2216962 defendant Ledys Robert de   768907 768907 Ledys, Robert de, of Kyngeston upon Hull, Yorks 0
4578335 2224714 2224714 defendant Grymmesby Simon   768907 768907 Grymmesby, Simon, of Kyngeston upon Hull, Yorks 0
4642371 2243891 2243891 defendant Ponde William   768907 768907 Ponde, William, of Kyngeston upon Hull, Yorks 1
4673810 2257432 2257432 defendant Rotse John gent 768907 768907 Rotse, John, of Kyngeston upon Hull, Yorks, gent 0
4677149 2258469 2258469 defendant Tutbery John merchant 768907 768907 Tutbery, John, of Kyngeston upon Hull, Yorks, merchant 0
4678216 2258796 2258796 defendant Pound William merchant 768907 768907 Pound, William, of Kyngeston upon Hull, Yorks, merchant 0
4682184 2260050 2260050 defendant Heseham John merchant 768907 768907 Heseham, John, of Kyngeston upon Hull, Yorks, merchant 0
4700635 2265607 2265607 defendant Redemar Thomas merchant 768907 768907 Redemar, Thomas, of Kyngeston upon Hull, Yorks, merchant 1
4716666 2270533 2270533 defendant Tuttebury Lawrence merchant 768907 768907 Tuttebury, Lawrence, of Kyngeston upon Hull, Yorks, merchant 0
4724748 2273038 2273038 defendant Redemar Thomas merchant 768907 768907 Redemar, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
4740562 2277753 2277753 defendant London Simon de chapman 768907 768907 London, Simon de, of Kyngeston upon Hull, Yorks, chapman 1
4743805 2278717 2278717 defendant Northebe William merchant 768907 768907 Northebe, William, of Kyngeston upon Hull, Yorks, merchant 1
4744048 2278784 2278784 defendant Rogse John merchant 768907 768907 Rogse, John, of Kyngeston upon Hull, Yorks, merchant 0
4751153 2280815 2280815 defendant Stayneton Thomas merchant 768907 768907 Stayneton, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
4755269 2282035 2282035 defendant Tuttebury Laurence merchant 768907 768907 Tuttebury, Laurence, of Kyngeston upon Hull, Yorks, merchant 1
4756278 2282334 2282334 defendant Yetlay William armourer 768907 768907 Yetlay, William, of Kyngeston upon Hull, Yorks, armourer 0
4761271 2283873 2283873 defendant Aldewyke John chapman 768907 768907 Aldewyke, John, of Kyngeston upon Hull, Yorks, chapman 0
4763123 2284447 2284447 defendant Shakeles Robert   768907 768907 Shakeles, Robert, of Kyngeston upon Hull, Yorks, mechant 0
4765576 2285223 2285223 defendant Kendale Robert tailor 768907 768907 Kendale, Robert, of Kyngeston upon Hull, Yorks, tailor 0
4771488 2287063 2287063 defendant Donyngton John merchant 768907 768907 Donyngton, John, of Kyngeston upon Hull, Yorks, merchant 0
4805044 2297782 2297782 defendant Bolton Richard merchant 768907 768907 Bolton, Richard, of Kyngeston upon Hull, Yorks, merchant 0
4808768 2298911 2298911 plaintiff Dauson Thomas tailor 768907 768907 Dauson, Thomas, of Kyngeston upon Hull, Yorks, tailor 0
4813123 2300223 2300223 defendant Rotse John merchant 768907 768907 Rotse, John, of Kyngeston upon Hull, Yorks, merchant 0
4814154 2300529 2300529 defendant Grymesby John esq 768907 768907 Grymesby, John, of Kyngeston upon Hull, Yorks, esq 0
4815207 2300867 2300867 defendant Frekulton Robert merchant 768907 768907 Frekulton, Robert, of Kyngeston upon Hull, Yorks, merchant 2
4817973 2301702 2301702 defendant Heseham John merchant 768907 768907 Heseham, John, of Kyngeston upon Hull, Yorks, merchant 1
4819199 2302084 2302084 defendant Pound Walter mercer 768907 768907 Pound, Walter, of Kyngeston upon Hull, Yorks, mercer 0
4822889 2303242 2303242 defendant Grymesby John merchant 768907 768907 Grymesby, John, of Kyngeston upon Hull, Yorks, merchant 1
4828415 2304930 2304930 defendant Charters John smith 768907 768907 Charters, John, of Kyngeston upon Hull, Yorks, smith 0
4837831 2307764 2307764 defendant Grymesby John esq 768907 768907 Grymesby, John, of Kyngeston upon Hull, Yorks, esq 0
4839041 2308139 2308139 defendant Grymesby John esq 768907 768907 Grymesby, John, of Kyngeston upon Hull, Yorks, esq 0
4840280 2308506 2308506 defendant Grymesby John esq 768907 768907 Grymesby, John, of Kyngeston upon Hull, Yorks, esq 0
4840697 2308628 2308628 defendant Grymmesby John gent 768907 768907 Grymmesby, John, of Kyngeston upon Hull, Yorks, gent 0
4841375 2308837 2308837 defendant Wylflet John vintner 768907 768907 Wylflet, John, of Kyngeston upon Hull, Yorks, vintner 0
4841377 2308838 2308838 defendant Wylflet John vintner 768907 768907 Wylflet, John, of Kyngeston upon Hull, Yorks, vintner 0
4842101 2309064 2309064 defendant Waynflete Nicholas sheerman 768907 768907 Waynflete, Nicholas, of Kyngeston upon Hull, Yorks, sheerman 0
4846106 2310288 2310288 defendant Lounde Isabel widow 768907 768907 Lounde, Isabel, of Kyngeston upon Hull, Yorks, widow 3
4846109 2310289 2310289 defendant Waynflete Nicholas sheer man 768907 768907 Waynflete, Nicholas, of Kyngeston upon Hull, Yorks, sheer man 0
4849436 2311298 2311298 defendant Thorp Robert vintner 768907 768907 Thorp, Robert, of Kyngeston upon Hull, Yorks, vintner 0
4850966 2311752 2311752 defendant Styton John gent 768907 768907 Styton, John, of Kyngeston upon Hull, Yorks, gent 0
4913496 2330717 2330717 defendant Taverner John shipman 768907 768907 Taverner, John, of Kyngeston upon Hull, Yorks, shipman 1
4914269 2330975 2330975 defendant Arnald John chapman 768907 768907 Arnald, John, of Kyngeston upon Hull, Yorks, chapman 0
4915039 2331208 2331208 defendant Elys Thomas merchant 768907 768907 Elys, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
4915712 2331413 2331413 defendant Mirwyn Thomas merchant 768907 768907 Mirwyn, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
4918015 2332150 2332150 defendant Cryse Richard yeoman 768907 768907 Cryse, Richard, of Kyngeston upon Hull, Yorks, yeoman 0
4919739 2332676 2332676 defendant Haddelsey Robert merchant 768907 768907 Haddelsey, Robert, of Kyngeston upon Hull, Yorks, merchant 0
4922538 2333465 2333465 defendant Saunderson Thomas merchant 768907 768907 Saunderson, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
4922562 2333473 2333473 defendant Mason William chapman 768907 768907 Mason, William, of Kyngeston upon Hull, Yorks, chapman 0
4924921 2334223 2334223 defendant Bedford John merchant 768907 768907 Bedford, John, of Kyngeston upon Hull, Yorks, merchant 1
4932350 2336515 2336515 defendant Clyderhowe Richard (legal representative) 768907 768907 Clyderhowe, Richard, of Kyngeston upon Hull, Yorks, merchant, administrator of 0
4932351 2336515 2336515 defendant Clyderhowe Hugh merchant 768907 768907 Clyderhowe, Hugh, of Kyngeston upon Hull, Yorks, merchant 1
4933239 2336786 2336786 defendant Clodeshowe Hugh merchant 768907 768907 Clodeshowe, Hugh, of Kyngeston upon Hull, Yorks, merchant 0
4992936 2354769 2354769 defendant Gufe or Guse John shipman 768907 768907 Gufe or Guse, John, of Kyngeston upon Hull, Yorks, shipman 3
4992942 2354771 2354771 defendant Guse John shipman 768907 768907 Guse, John, of Kyngeston upon Hull, Yorks, shipman 0
5000535 2357027 2357027 defendant Ely Thomas merchant 768907 768907 Ely, Thomas, of Kyngeston upon Hull, Yorks, merchant 0
5470648 2496140 2496140 defendant Walkre Robert merchant 768907 768907 Walkre, Robert, of Kyngeston upon Hull, Yorks, merchant 0
5471227 2496332 2496332 defendant Waller Robert merchant 768907 768907 Waller, Robert, of Kyngeston upon Hull, Yorks, merchant 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);