names

76 rows where place_id = 588466

✎ 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
3594585 1865938 1865938 defendant Harryes Thomas husbandman 588466 588466 Harryes, Thomas, of Cleve, husbandman 0
3615202 1872400 1872400 defendant Gyell John butcher 588466 588466 Gyell, John, of Cleve, butcher 3
3656662 1912334 1912334 defendant Clarke John   588466 588466 Clarke, John, of cleve glover 5
3656685 1912341 1912341 defendant Clerk John glover 588466 588466 Clerk, John, of Cleve, glover 5
3721424 1933008 1933008 defendant Palmer Thomas husbandman 588466 588466 Palmer, Thomas, of Cleve Prior, husbandman 0
3734077 1936908 1936908 defendant Phyllippes Leonard husbandman 588466 588466 Phyllippes, Leonard, of Cleve Prior, husbandman 0
3752886 1942826 1942826 defendant Herbornn John husbandman 588466 588466 Herbornn, John, of Cleve Prior, husbandman 0
3800683 1958125 1958125 defendant Stok Thomas clerk 588466 588466 Stok, Thomas, of Cleve, clerk 1
3809891 1960978 1960978 defendant Phillippes Leonard husbandman 588466 588466 Phillippes, Leonard, of Cleve Prior, husbandman 0
3864781 1978416 1978416 defendant Nycholas Humphrey husbandman 588466 588466 Nycholas, Humphrey, of Cleve, husbandman 2
3921733 1997612 1997612 defendant Stone George yeoman 588466 588466 Stone, George, of Cleve, yeoman 0
3974750 2015736 2015736 defendant Ball Robert tailor 588466 588466 Ball, Robert, of Cleve, tailor 0
4006911 2027246 2027246 defendant Bytott Abell   588466 588466 Bytott, Abell, of Cleve, surgeon 0
4119324 2067206 2067206 defendant Hollowaye William husbandman 588466 588466 Hollowaye, William, of Cleve Pepper, husbandman 2
4189678 2091886 2091886 defendant Pyff Richard husbandman 588466 588466 Pyff, Richard, of Cleve, husbandman 1
4372313 2155162 2155162 defendant Smyth William husbandman 588466 588466 Smyth, William, of Cleve, or of Woodmancote, husbandman 0
4482919 2195356 2195356 plaintiff Horn John   588466 588466 Horn, John, of Cleve 3
4662236 2249662 2249662 defendant Tommes John   588466 588466 Tommes, John, of Cleve, shepherd 1
4703146 2266363 2266363 defendant Alyan Thomas husbandman 588466 588466 Alyan, Thomas, of Cleve, husbandman 0
4742283 2278232 2278232 defendant Forde John baker 588466 588466 Forde, John, of Cleve, baker 0
4763640 2284615 2284615 defendant Say John laborer 588466 588466 Say, John, of Cleve, laborer 1
4763641 2284615 2284615 defendant Hamond William laborer 588466 588466 Hamond, William, of Cleve, laborer 2
4806318 2298187 2298187 plaintiff Cardoun John   588466 588466 Cardoun, John, of Cleve 0
4818859 2301983 2301983 defendant Aspele Richard (legal representative) 588466 588466 Aspele, Richard, of Cleve, executors of 0
4884916 2322179 2322179 defendant Rede John husbandman 588466 588466 Rede, John, of Cleve, husbandman 0
4890365 2323757 2323757 defendant Mason Thomas husbandman 588466 588466 Mason, Thomas, of Cleve, husbandman 0
4890366 2323757 2323757 defendant Pondere William miller 588466 588466 Pondere, William, of Cleve, miller 1
4890367 2323757 2323757 defendant Bocher Thomas butcher 588466 588466 Bocher, Thomas, of Cleve, butcher 2
4901072 2326962 2326962 plaintiff Durant Nicholas   588466 588466 Durant, Nicholas, of Cleve 0
4925642 2334454 2334454 defendant Snowe Geoffrey miller 588466 588466 Snowe, Geoffrey, of Cleve, miller 0
4925643 2334454 2334454 defendant Bocher Thomas laborer 588466 588466 Bocher, Thomas, of cleve, laborer 1
4925645 2334454 2334454 defendant Dare John tanner 588466 588466 Dare, John, of Cleve, tanner 3
5044743 2370062 2370062 defendant Poleyn John husbandman 588466 588466 Poleyn, John, of Cleve, husbandman 1
5044744 2370062 2370062 defendant Elys Richard husbandman 588466 588466 Elys, Richard, of Cleve, husbandman 2
5044745 2370062 2370062 defendant atte Rede Benedict husbandman 588466 588466 atte Rede, Benedict, of Cleve, husbandman 3
5068085 2376959 2376959 defendant Fyssher John butcher 588466 588466 Fyssher, John, of Cleve, butcher 1
5068561 2377086 2377086 plaintiff Poleyn John   588466 588466 Poleyn, John, of Cleve 0
5070030 2377530 2377530 defendant Prentys Richard yeoman 588466 588466 Prentys, Richard, of Cleve, yeoman 0
5081483 2380961 2380961 defendant Catter Richard yeoman 588466 588466 Catter, Richard, of Cleve, yeoman 0
5110173 2389385 2389385 plaintiff Cruste John shipman 588466 588466 Cruste, John, of Cleve, shipman 1
5117344 2391505 2391505 defendant Carter William butcher 588466 588466 Carter, William, of Cleve, butcher 1
5193913 2413946 2413946 defendant Catter Richard yeoman 588466 588466 Catter, Richard, of Cleve, yeoman 1
5224591 2422861 2422861 defendant Perdour John husbandman 588466 588466 Perdour, John, of Cleve, husbandman 0
5227833 2423755 2423755 defendant London William husbandman 588466 588466 London, William, of Cleve, husbandman 1
5237680 2426603 2426603 defendant Cok Thomas baker 588466 588466 Cok, Thomas, of Cleve, baker 1
5244666 2428620 2428620 defendant Boteler alias Runham John husbandman 588466 588466 Boteler alias Runham, John, of Cleve, husbandman 1
5244667 2428620 2428620 defendant Harry John husbandman 588466 588466 Harry, John, of Cleve, husbandman 2
5245786 2428932 2428932 defendant Waryn John chaplain 588466 588466 Waryn, John, of Cleve, chaplain 0
5247300 2429364 2429364 defendant Dulle Thomas husbandman 588466 588466 Dulle, Thomas, of Cleve, husbandman 0
5280615 2439403 2439403 defendant Wever Richard yeoman 588466 588466 Wever, Richard, of Cleve, yeoman 2
5291384 2442482 2442482 plaintiff Poleyn John   588466 588466 Poleyn, John, of Cleve 0
5320523 2451225 2451225 defendant Lyffyngcote Thomas gent 588466 588466 Lyffyngcote, Thomas, of Cleve, gent 0
5327397 2453265 2453265 defendant Gyell or Eyell John butcher 588466 588466 Gyell or Eyell, John, of Cleve, butcher 4
5360183 2463227 2463227 defendant Dalham John husbandman 588466 588466 Dalham, John, of Cleve, husbandman 0
5374210 2467534 2467534 defendant Hewet John husbandman 588466 588466 Hewet, John, of Cleve, husbandman 1
5376356 2468202 2468202 defendant Manfeld Thomas laborer 588466 588466 Manfeld, Thomas, of Cleve, laborer 2
5376357 2468202 2468202 defendant Hardyng William laborer 588466 588466 Hardyng, William, of Cleve, laborer 3
5376358 2468202 2468202 defendant Hardyng Edmund laborer 588466 588466 Hardyng, Edmund, of Cleve, laborer 4
5376359 2468202 2468202 defendant Hardyng Richard laborer 588466 588466 Hardyng, Richard, of Cleve, laborer 5
5376360 2468202 2468202 defendant Herbard Richard laborer 588466 588466 Herbard, Richard, of Cleve, laborer 6
5391977 2472783 2472783 defendant Turnour John husbandman 588466 588466 Turnour, John, of Cleve, husbandman 3
5405162 2476556 2476556 defendant Turnour John husbandman 588466 588466 Turnour, John, of Cleve, husbandman 3
5417982 2480304 2480304 defendant Turnour John husbandman 588466 588466 Turnour, John, of Cleve, husbandman 2
5425370 2482562 2482562 defendant Smyth Henry husbandman 588466 588466 Smyth, Henry, of Cleve, husbandman 0
5436211 2485769 2485769 defendant Godfrey Richard yeoman 588466 588466 Godfrey, Richard, of Cleve, yeoman 0
5436213 2485769 2485769 defendant _eyn John husbandman 588466 588466 _eyn, John, of Cleve, husbandman 2
5450968 2490180 2490180 defendant Godfrey Richard yeoman 588466 588466 Godfrey, Richard, of Cleve, yeoman 0
5459832 2492870 2492870 defendant Sonsawe Thomas husbandman 588466 588466 Sonsawe, Thomas, of Cleve, husbandman 0
5459835 2492871 2492871 defendant Sousawe Thomas husbandman 588466 588466 Sousawe, Thomas, of Cleve, husbandman 0
5487648 2501195 2501195 defendant Clevem Thomas Westbury, tailor 588466 588466 Clevem Thomas, of Cleve, Westbury, tailor 2
5500724 2505158 2505158 defendant Page John gent 588466 588466 Page, John, of Cleve juxta Rochester, gent 0
5500725 2505158 2505158 defendant Peryot Thomas yeoman 588466 588466 Peryot, Thomas, of Cleve juxta Rochester, yeoman 1
5555475 2521603 2521603 defendant Engo William yeoman 588466 588466 Engo, William, of Cleve, yeoman 0
5588087 2531286 2531286 defendant Mychell Roger husbandman 588466 588466 Mychell, Roger, of Cleve, husbandman 0
5603317 2535924 2535924 defendant Michell Roger husbandman 588466 588466 Michell, Roger, of Cleve, husbandman 0
5605140 2536479 2536479 defendant Rolfe John husbandman 588466 588466 Rolfe, John, of Cleve, husbandman 3

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