names

66 rows where place_id = 587746

✎ 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
3592335 1865218 1865218 defendant Calle Thomas husbandman 587746 587746 Calle, Thomas, of Parva Waldyngfeld, husbandman 1
3597215 1866753 1866753 defendant Candeler Andrew butcher 587746 587746 Candeler, Andrew, of Parva Waldyngfeld, butcher 2
3622230 1874487 1874487 defendant Calle Thomas yeoman 587746 587746 Calle, Thomas, of Parva Waldyngfeld, yeoman 1
3671667 1917126 1917126 plaintiff Colman John, senior (legal representative) 587746 587746 Colman, John, senior, of Parva Waldyngfeld, clothmaker, executors of 0
3731761 1936164 1936164 defendant Gorse Thomas husbandman 587746 587746 Gorse, Thomas, of Parva Waldyngfeld, husbandman 0
3733245 1936631 1936631 defendant Petnam Richard fuller 587746 587746 Petnam, Richard, of Parva Waldyngfeld, fuller 2
3740533 1938898 1938898 defendant Rudlond Ralph clothmaker 587746 587746 Rudlond, Ralph, of Parva Waldyngfeld, clothmaker 1
3807910 1960362 1960362 plaintiff Wyncoll Roger clothmaker 587746 587746 Wyncoll, Roger, of Parva Waldyngfeld, clothmaker 0
3807911 1960362 1960362 defendant Holyer John draper 587746 587746 Holyer, John, of Parva Waldyngfeld, draper 0
3807913 1960363 1960363 defendant Holier John draper 587746 587746 Holier, John, of Parva Waldyngfeld, draper 0
3809495 1960850 1960850 defendant Wyncoll Roger clothier 587746 587746 Wyncoll, Roger, of Parva Waldyngfeld, clothier 0
3830239 1967351 1967351 defendant Gosse William husbandman 587746 587746 Gosse, William, of Parva Waldyngfeld, husbandman 1
3901285 1990656 1990656 plaintiff Colman Katherine (legal representative) 587746 587746 Colman, Katherine, of Parva Waldyngfeld, widow, executor of 0
3991836 2021833 2021833 defendant Harrys William husbandman 587746 587746 Harrys, William, of Parva Waldyngfeld, husbandman 2
4789084 2292642 2292642 defendant Sheldrake John fuller 587746 587746 Sheldrake, John, of Parva Waldyngfeld, fuller 0
4789638 2292828 2292828 defendant Hakon Nicholas clerk 587746 587746 Hakon, Nicholas, of Parva Waldyngfeld, clerk 0
4886642 2322687 2322687 defendant de Bury John fuller 587746 587746 de Bury, John, of Parva Waldyngfeld, fuller 0
4891819 2324182 2324182 defendant Heyward John husbandman 587746 587746 Heyward, John, of Parva Waldyngfeld, husbandman 5
4905777 2328409 2328409 plaintiff Ive John   587746 587746 Ive, John, of Parva Waldyngfeld 0
4945160 2340467 2340467 defendant Ine or Ive John fuller 587746 587746 Ine or Ive, John, of Parva Waldyngfeld, fuller 0
4945161 2340467 2340467 defendant Heyward John fuller 587746 587746 Heyward John, of Parva Waldyngfeld, fuller 1
4953799 2343096 2343096 plaintiff Smyth Nicholas   587746 587746 Smyth, Nicholas, of Parva Waldyngfeld 0
4984086 2352172 2352172 defendant Sheldrake John fuller 587746 587746 Sheldrake, John, of Parva Waldyngfeld, fuller 2
5018444 2362278 2362278 defendant Heyward John, senior husbandman 587746 587746 Heyward, John, senior, of Parva Waldyngfeld, husbandman 0
5062863 2375426 2375426 defendant Colman Richard fuller 587746 587746 Colman, Richard, of Parva Waldyngfeld, fuller 0
5062864 2375426 2375426 defendant Rukkedewe Thomas husbandman 587746 587746 Rukkedewe, Thomas, of Parva Waldyngfeld, husbandman 1
5062866 2375427 2375427 defendant Sheldrake John husbandman 587746 587746 Sheldrake, John, of Parva Waldyngfeld, husbandman 0
5062867 2375427 2375427 defendant Heyward John ploughman 587746 587746 Heyward, John, of Parva Waldyngfeld, ploughman 1
5245172 2428748 2428748 defendant Brian John weaver 587746 587746 Brian, John, of Parva Waldyngfeld, weaver 0
5252231 2430808 2430808 defendant Calle John husbandman 587746 587746 Calle, John, of Parva Waldyngfeld, husbandman 0
5252232 2430808 2430808 defendant Balle Richard tailor 587746 587746 Balle, Richard, of Parva Waldyngfeld, tailor 1
5260221 2433322 2433322 defendant Ive William yeoman 587746 587746 Ive, William, of Parva Waldyngfeld, yeoman 0
5277778 2438586 2438586 defendant Ive William clothmaker 587746 587746 Ive, William, of Parva Waldyngfeld, clothmaker 0
5277825 2438599 2438599 defendant Breyon Constantine fuller 587746 587746 Breyon, Constantine, of Parva Waldyngfeld, fuller 0
5280740 2439442 2439442 defendant Overe Richard smith 587746 587746 Overe, Richard, of Parva Waldyngfeld, smith 1
5283066 2440108 2440108 defendant Bryan Thomas   587746 587746 Bryan, Thomas, of Parva Waldyngfeld 4
5286525 2441067 2441067 defendant Ive William fuller 587746 587746 Ive, William, of Parva Waldyngfeld, fuller 0
5286528 2441068 2441068 defendant Ive William fuller 587746 587746 Ive, William, of Parva Waldyngfeld, fuller 0
5286531 2441069 2441069 defendant Ive William fuller 587746 587746 Ive, William, of Parva Waldyngfeld, fuller 0
5287209 2441278 2441278 defendant Calle John husbandman 587746 587746 Calle, John, of Parva Waldyngfeld, husbandman 3
5289362 2441891 2441891 defendant Ine or Ive William fuller 587746 587746 Ine or Ive, William, of Parva Waldyngfeld, fuller 2
5291652 2442565 2442565 defendant Ine or Ive William yeoman 587746 587746 Ine or Ive, William, of Parva Waldyngfeld, yeoman 2
5292504 2442804 2442804 defendant Russell Thomas husbandman 587746 587746 Russell, Thomas, of Parva Waldyngfeld, husbandman 0
5293718 2443124 2443124 defendant Calle John yeoman 587746 587746 Calle, John, of Parva Waldyngfeld, yeoman 2
5296165 2443870 2443870 defendant Rose Robert laborer 587746 587746 Rose, Robert, of Parva Waldyngfeld, laborer 3
5296171 2443871 2443871 defendant Rose Robert laborer 587746 587746 Rose, Robert, of Parva Waldyngfeld, laborer 3
5321839 2451604 2451604 defendant Calle John, senior husbandman 587746 587746 Calle, John, senior, of Parva Waldyngfeld, husbandman 0
5334062 2455253 2455253 defendant Rysyng Richard, junior gent 587746 587746 Rysyng, Richard, junior, of Parva Waldyngfeld, gent 0
5348291 2459605 2459605 defendant Rysyng Eichard gent 587746 587746 Rysyng, Eichard, of Parva Waldyngfeld, gent 0
5348377 2459636 2459636 defendant Waynflet John weaver 587746 587746 Waynflet, John, of Parva Waldyngfeld, weaver 0
5348380 2459637 2459637 defendant Waynflet John weaver 587746 587746 Waynflet, John, of Parva Waldyngfeld, weaver 0
5349180 2459869 2459869 defendant Calle John yeoman 587746 587746 Calle, John, of Parva Waldyngfeld, yeoman 1
5349363 2459930 2459930 defendant Rysyng Richard   587746 587746 Rysyng, Richard, of Parva Waldyngfeld 0
5352662 2460923 2460923 defendant Baker John farmer 587746 587746 Baker, John, of Parva Waldyngfeld, husbandman, or of Edwardiston, farmer 1
5506963 2507094 2507094 defendant Candeler John butcher 587746 587746 Candeler, John, of Parva Waldyngfeld, butcher 0
5507504 2507241 2507241 defendant Candeler Andrew butcher 587746 587746 Candeler, Andrew, of Parva Waldyngfeld, butcher 2
5509323 2507767 2507767 defendant Damsell Walter   587746 587746 Damsell, Walter, of Parva Waldyngfeld, pirish clerk 0
5514037 2509240 2509240 defendant Pratte Robert laborer 587746 587746 Pratte, Robert, of Parva Waldyngfeld, laborer 1
5515428 2509671 2509671 defendant Pertrigge John, senior husbandman 587746 587746 Pertrigge, John, senior, of Parva Waldyngfeld, husbandman 0
5515429 2509671 2509671 defendant Pertrigge John, junior husbandman 587746 587746 Pertrigge, John, junior, of Parva Waldyngfeld, husbandman 1
5515431 2509672 2509672 defendant Pertrygge John, junior husbandman 587746 587746 Pertrygge, John, junior, of Parva Waldyngfeld, husbandman 0
5515433 2509673 2509673 defendant Pertrygge John, junior husbandman 587746 587746 Pertrygge, John, junior, of Parva Waldyngfeld, husbandman 0
5525317 2512510 2512510 defendant Rysyng Richard esq 587746 587746 Rysyng, Richard, of Parva Waldyngfeld, esq 0
5526102 2512739 2512739 defendant Calle Thomas husbandman 587746 587746 Calle, Thomas, of Parva Waldyngfeld, husbandman 0
5536293 2515841 2515841 defendant Akerman John yeoman 587746 587746 Akerman, John, of Parva Waldyngfeld, yeoman 2
5589327 2531665 2531665 defendant Ree Richard, senior smith 587746 587746 Ree, Richard, senior, of Parva Waldyngfeld, smith 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);