names

95 rows where place_id = 588170

✎ 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
3593573 1865627 1865627 defendant Cheltyr John butcher 588170 588170 Cheltyr, John, of Wangford, butcher 0
3593574 1865627 1865627 defendant Veysy Thomas husbandman 588170 588170 Veysy, Thomas, of Wangford, husbandman 1
3593580 1865629 1865629 defendant Cheltyr John butcher 588170 588170 Cheltyr, John, of Wangford, butcher 0
3593581 1865629 1865629 defendant Beysy Thomas husbandman 588170 588170 Beysy, Thomas, of Wangford, husbandman 1
3594117 1865802 1865802 defendant Lely William   588170 588170 Lely, William, of Wangford, cook 2
3594118 1865802 1865802 defendant Ensull or Enfull Robert laborer 588170 588170 Ensull or Enfull, Robert, of Wangford, laborer 3
3594119 1865802 1865802 defendant Lory Roger husbandman 588170 588170 Lory, Roger, of Wangford, husbandman 4
3596135 1866420 1866420 defendant Cheltour John butcher 588170 588170 Cheltour, John, of Wangford, butcher 0
3596136 1866420 1866420 defendant Veyse Thomas husbandman 588170 588170 Veyse, Thomas, of Wangford, husbandman 1
3599003 1867322 1867322 defendant Chylter John butcher 588170 588170 Chylter, John, of Wangford, butcher 0
3606227 1869615 1869615 defendant Coprose John (legal representative) 588170 588170 Coprose, John, of Wangford, executor of 6
3606228 1869615 1869615 defendant Glover John (legal representative) 588170 588170 (Glover, John, of Wangford, executor of 7
3606229 1869615 1869615 defendant Coprose Peter husbandman 588170 588170 Coprose, Peter, of Wangford, husbandman 8
3692805 1923940 1923940 defendant Hansard John gent 588170 588170 Hansard, John, of Wangford, gent 2
3698328 1925696 1925696 defendant Hansard John gent 588170 588170 Hansard, John, of Wangford, gent 1
3705675 1928057 1928057 defendant Peerson John butcher 588170 588170 Peerson, John, of Wangford, butcher 0
3746070 1940676 1940676 defendant Beke John miller 588170 588170 Beke, John, of Wangford, miller 0
3775245 1949992 1949992 defendant Lek Reginald husbandman 588170 588170 Lek, Reginald, of Wangford, husbandman 2
3775824 1950188 1950188 defendant Nicholasson William shoemaker 588170 588170 Nicholasson, William, of Wangford, shoemaker 0
3790104 1954722 1954722 defendant Leek Reginald husbandman 588170 588170 Leek, Reginald, of Wangford, husbandman 0
3970004 2014104 2014104 plaintiff Cryspe William yeoman 588170 588170 Cryspe, William, of Wangford, yeoman 0
3970007 2014105 2014105 plaintiff Cryspe William yeoman 588170 588170 Cryspe, William, of Wangford, yeoman 0
3970009 2014105 2014105 defendant Nyxson Godfrey husbandman 588170 588170 Nyxson, Godfrey, of Wangford, husbandman 1
3979615 2017468 2017468 defendant Cryspe William yeoman 588170 588170 Cryspe, William, of Wangford, yeoman 1
3990912 2021512 2021512 defendant Barber John husbandman 588170 588170 Barber, John, of Wangford, husbandman 1
4001624 2025361 2025361 plaintiff Harman James yeoman 588170 588170 Harman, James, of Wangford, yeoman 0
4035830 2037487 2037487 defendant Leece Thomas yeoman 588170 588170 Leece, Thomas, of Wangford, yeoman 1
4035838 2037489 2037489 defendant Leete Thomas yeoman 588170 588170 Leete, Thomas, of Wangford, yeoman 1
4071533 2050112 2050112 defendant Haylock John yeoman 588170 588170 Haylock, John, of Wangford, yeoman 2
4168162 2084350 2084350 defendant Baseley John yeoman 588170 588170 Baseley, John, of Wangford, yeoman 2
4191449 2092577 2092577 defendant Curtys Thomas cordwainer 588170 588170 Curtys, Thomas, of Wangford, cordwainer 0
4219575 2102350 2102350 defendant Denton John yeoman 588170 588170 Denton, John, of Wangford, or of Lawshall, yeoman 0
4236303 2108268 2108268 defendant Belamy Edmund yeoman 588170 588170 Belamy, Edmund, of Wangford, yeoman 1
4243030 2110660 2110660 defendant Hayward John husbandman 588170 588170 Hayward, John, of Wangford, husbandman 3
4244835 2111262 2111262 defendant Belamy Edmund yeoman 588170 588170 Belamy, Edmund, of Wangford, yeoman 1
4333219 2141397 2141397 defendant Coat William yeoman 588170 588170 Coat, William, of Wangford, yeoman 0
4333220 2141397 2141397 defendant Barrett Richard yeoman 588170 588170 Barrett, Richard, of Wangford, yeoman 1
4333221 2141397 2141397 defendant Hovell or Houell William yeoman 588170 588170 Hovell or Houell, William, of Wangford, yeoman 2
4333222 2141397 2141397 defendant Hovell or Houell Thomas yeoman 588170 588170 Hovell or Houell, Thomas, of Wangford, yeoman 3
4384693 2159566 2159566 defendant Sewell William yeoman 588170 588170 Sewell, William, of Wangford, yeoman 1
4384694 2159566 2159566 defendant Towler Robert yeoman 588170 588170 Towler, Robert, of Wangford, yeoman 2
4393211 2162336 2162336 defendant Francklyn John clerk 588170 588170 Francklyn, John, of Wangford, clerk 0
4616717 2236229 2236229 defendant Peper William   588170 588170 Peper, William, of Wangford, wheelwright 0
4716968 2270639 2270639 defendant Totewey Henry chaplain 588170 588170 Totewey, Henry, of Wangford, chaplain 0
4865146 2316073 2316073 defendant Gerveys William baker 588170 588170 Gerveys, William, of Wangford, baker 1
5019553 2362605 2362605 defendant Totweye Alexander yeoman 588170 588170 Totweye, Alexander, of Wangford, yeoman 1
5028692 2365268 2365268 defendant Ducheman Peter laborer 588170 588170 Ducheman, Peter, of Wangford, laborer 0
5039653 2368504 2368504 plaintiff Bokenham John   588170 588170 Bokenham, John, of Wangford 0
5119964 2392276 2392276 defendant Gylyot William husbandman 588170 588170 Gylyot, William, of Wangford, husbandman 3
5119965 2392276 2392276 defendant Bokenham John husbandman 588170 588170 Bokenham, John, of Wangford, husbandman 4
5152882 2401984 2401984 defendant Gelyot William yeoman 588170 588170 Gelyot, William, of Wangford, yeoman 0
5170476 2407093 2407093 defendant Gelyot William yeoman 588170 588170 Gelyot, William, of Wangford, yeoman 0
5197810 2415098 2415098 defendant Gelyot William husbandman 588170 588170 Gelyot, William, of Wangford, husbandman 0
5210294 2418737 2418737 defendant Gelyot William husbandman 588170 588170 Gelyot, William, of Wangford, husbandman 0
5216042 2420423 2420423 defendant Toteweye John husbandman 588170 588170 Toteweye, John, of Wangford, husbandman 2
5226221 2423332 2423332 defendant Giliot William chapman 588170 588170 Giliot, William, of Wangford, chapman 0
5236672 2426309 2426309 defendant Totewey John husbandman 588170 588170 Totewey, John, of Wangford, husbandman 5
5248379 2429658 2429658 defendant Glover John yeoman 588170 588170 Glover, John, of Wangford, yeoman 4
5248793 2429766 2429766 defendant Coperose John baker 588170 588170 Coperose, John, of Wangford, baker 0
5250194 2430174 2430174 defendant Haylotte Thomas laborer 588170 588170 Haylotte, Thomas, of Wangford, laborer 0
5277006 2438357 2438357 defendant Pynteney Benedict smith 588170 588170 Pynteney, Benedict, of Wangford, smith 0
5291287 2442455 2442455 defendant Pyntoney Benedict smith 588170 588170 Pyntoney, Benedict, of Wangford, smith 0
5331046 2454351 2454351 defendant Ulveston Elizabeth widow 588170 588170 Ulveston, Elizabeth, of Wangford, widow 0
5368237 2465690 2465690 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 3
5381036 2469631 2469631 defendant Totewey John husbandman 588170 588170 Totewey, John, of Wangford, husbandman 3
5402256 2475716 2475716 defendant Chambyr Thomas butcher 588170 588170 Chambyr, Thomas, of Wangford, butcher 2
5402735 2475858 2475858 defendant Wyndyng Thomas miller 588170 588170 Wyndyng, Thomas, of Wangford, miller 0
5402931 2475919 2475919 defendant Barker Richard yeoman 588170 588170 Barker, Richard, of Wangford, yeoman 0
5408173 2477419 2477419 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 0
5415634 2479618 2479618 defendant Wyndlyng Thomas milner 588170 588170 Wyndlyng, Thomas, of Wangford, milner 0
5416688 2479909 2479909 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 1
5421352 2481319 2481319 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 0
5427759 2483263 2483263 defendant Totewey John husbandman 588170 588170 Totewey, John, of Wangford, husbandman 3
5427766 2483264 2483264 defendant Totewey John husbandman 588170 588170 Totewey, John, of Wangford, husbandman 3
5427772 2483265 2483265 defendant Totewey John husbandman 588170 588170 Totewey, John, of Wangford, husbandman 2
5432029 2484547 2484547 defendant Wyndlyng Thomas miller 588170 588170 Wyndlyng, Thomas, of Wangford, miller 0
5432031 2484548 2484548 defendant Wyndlyng Thomas miller 588170 588170 Wyndlyng, Thomas, of Wangford, miller 0
5433585 2485008 2485008 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 1
5461419 2493368 2493368 defendant Barker Richard husbandman 588170 588170 Barker, Richard, of Wangford, husbandman 0
5485322 2500527 2500527 defendant Smalwode John husbandman 588170 588170 Smalwode, John, of Wangford, husbandman 3
5503971 2506152 2506152 defendant Barker John husbandman 588170 588170 Barker, John, of Wangford, husbandman 0
5510076 2507989 2507989 defendant Skut William yeoman 588170 588170 Skut, William, of Wangford, yeoman 0
5510077 2507989 2507989 defendant Aldryche William yeoman 588170 588170 Aldryche, William, of Wangford, yeoman 1
5510078 2507989 2507989 defendant Cotewan Geoffrey yeoman 588170 588170 Cotewan, Geoffrey, of Wangford, yeoman 2
5510079 2507989 2507989 defendant Totweye John   588170 588170 Totweye, John, of Wangford, plough wright 3
5520922 2511364 2511364 defendant Rytwade John glover 588170 588170 Rytwade, John, of Wangford, glover 1
5520924 2511364 2511364 defendant Leny or Levy William husbandman 588170 588170 Leny or Levy, William, of Wangford, husbandman 3
5523092 2512049 2512049 defendant Totewey Alexander husbandman 588170 588170 Totewey, Alexander, of Wangford, husbandman 0
5523094 2512049 2512049 defendant Totewey William shoemaker 588170 588170 Totewey, William, of Wangford, shoemaker 2
5529392 2513706 2513706 defendant Cokerose Peter husbandman 588170 588170 Cokerose, Peter, of Wangford, husbandman 0
5537994 2516374 2516374 defendant Caundysshe Richard gent 588170 588170 Caundysshe, Richard, of Wangford, gent 0
5554818 2521409 2521409 defendant Veysy William yeoman 588170 588170 Veysy, William, of Wangford, yeoman 0
5554819 2521409 2521409 defendant Roberdes William yeoman 588170 588170 Roberdes, William, of Wangford, yeoman 1
5554820 2521409 2521409 defendant Davy William gent 588170 588170 Davy, William, of Wangford, gent 2
5583315 2529853 2529853 defendant Davy William yeoman 588170 588170 Davy, William, of Wangford, yeoman 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);