names

258 rows where place_id = 589341

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597288 1866773 1866773 defendant Tournour Hugh weaver 589341 589341 Tournour, Hugh, of Tenterden, weaver 0
3602095 1868318 1868318 defendant Parker Hugh yeoman 589341 589341 Parker, Hugh, of Tenterden, yeoman 0
3604828 1869177 1869177 defendant Turnour Hugh husbandman 589341 589341 Turnour, Hugh, of Tenterden, husbandman 0
3622069 1874441 1874441 defendant Turnour Hugh clothmaker 589341 589341 Turnour, Hugh, of Tenterden, clothmaker 4
3622833 1874672 1874672 defendant Iden Thomas clothman 589341 589341 Iden, Thomas, of Tenterden, clothman 2
3624335 1875145 1875145 defendant Iden Thomas clothmaker 589341 589341 Iden, Thomas, of Tenterden, clothmaker 0
3679354 1919604 1919604 defendant Leyn alias Oleyn Cornelius   589341 589341 Leyn alias Oleyn, Cornelius, of Tenterden, surgeon 0
3683008 1920798 1920798 defendant Gage John esq 589341 589341 Gage, John, of Tenterden, esq 1
3748847 1941576 1941576 defendant Mede Stephen tanner 589341 589341 Mede, Stephen, of Tenterden, tanner 1
3785036 1953102 1953102 defendant Parker John yeoman 589341 589341 Parker, John, of Tenterden, yeoman 0
3826329 1966083 1966083 plaintiff Austen John   589341 589341 Austen, John, of Tenterden 0
3832680 1968147 1968147 plaintiff Hyllys William   589341 589341 Hyllys, William, of Tenterden 0
3839078 1970143 1970143 defendant Philips John yeoman 589341 589341 Philips, John, of Tenterden, yeoman 0
3840789 1970686 1970686 plaintiff Austen John   589341 589341 Austen, John, of Tenterden 0
3840790 1970686 1970686 defendant Parker John yeoman 589341 589341 Parker, John, of Tenterden, yeoman 0
3848375 1973069 1973069 plaintiff Hyllys William   589341 589341 Hyllys, William, of Tenterden 0
3850176 1973644 1973644 defendant Morleyn John butcher 589341 589341 Morleyn, John, of Tenterden, butcher 2
3858543 1976339 1976339 plaintiff Brambyll Andrew   589341 589341 Brambyll, Andrew, of Tenterden 0
3860135 1976888 1976888 plaintiff Cowper Stephen tanner 589341 589341 Cowper, Stephen, of Tenterden, tanner 0
3863617 1978019 1978019 defendant Brekenden William yeoman 589341 589341 Brekenden, William, of Tenterden, yeoman 1
3867472 1979355 1979355 defendant Hope Richard yeoman 589341 589341 Hope, Richard, of Tenterden, yeoman 0
3877756 1982799 1982799 plaintiff Hyllys William   589341 589341 Hyllys, William, of Tenterden 0
3907794 1992892 1992892 defendant Smyth George shoemaker 589341 589341 Smyth, George, of Tenterden, shoemaker 0
3916651 1995942 1995942 defendant Coppyng James shoemaker 589341 589341 Coppyng, James, of Tenterden, shoemaker 0
3919380 1996813 1996813 defendant Fordman Robert chapman 589341 589341 Fordman, Robert, of Tenterden, chapman 0
3919382 1996813 1996813 defendant Baker Peter clerk 589341 589341 Baker, Peter, of Tenterden, clerk 2
3919383 1996813 1996813 defendant Baker Christopher chapman 589341 589341 Baker, Christopher, of Tenterden, chapman 3
3961255 2011032 2011032 defendant Bodell William yeoman 589341 589341 Bodell, William, of Tenterden, yeoman 0
3965546 2012561 2012561 defendant Phylype Edward gent 589341 589341 Phylype, Edward, of Tenterden, gent 0
3973745 2015393 2015393 plaintiff Hales Edward esq 589341 589341 Hales, Edward, of Tenterden, esq 0
3978181 2016950 2016950 defendant Austen Thomas brewer 589341 589341 Austen, Thomas, of Tenterden, brewer 0
3991480 2021706 2021706 defendant Perse Robert brewer 589341 589341 Perse, Robert, of Tenterden, brewer 0
4052681 2043389 2043389 defendant Awsten William yeoman 589341 589341 Awsten, William, of Tenterden, yeoman 1
4053898 2043772 2043772 plaintiff Asten John (legal representative) 589341 589341 Asten, John, of Tenterden, yeoman, executor of 0
4072414 2050438 2050438 defendant Haffenden George yeoman 589341 589341 Haffenden, George, of Tenterden, yeoman 1
4073223 2050714 2050714 defendant Glover James yeoman 589341 589341 Glover, James, of Tenterden, yeoman 0
4073224 2050714 2050714 defendant Glover Thomas husbandman 589341 589341 Glover, Thomas, of Tenterden, husbandman 1
4073989 2050985 2050985 defendant Goodale John husbandman 589341 589341 Goodale, John, of Tenterden, husbandman 0
4081417 2053663 2053663 plaintiff Whytefeld John yeoman 589341 589341 Whytefeld, John, of Tenterden, yeoman 0
4081420 2053664 2053664 plaintiff Whytefeld John yeoman 589341 589341 Whytefeld, John, of Tenterden, yeoman 0
4083264 2054302 2054302 defendant Austen Mathew tailor 589341 589341 Austen, Mathew, of Tenterden, tailor 0
4102254 2061099 2061099 defendant Burgeys Thomas yeoman 589341 589341 Burgeys, Thomas, of Tenterden, yeoman 1
4205125 2097340 2097340 defendant Awsten Mathew tailor 589341 589341 Awsten, Mathew, of Tenterden, tailor 2
4223876 2103837 2103837 defendant Fuller William yeoman 589341 589341 Fuller, William, of Tenterden, yeoman 1
4226219 2104641 2104641 defendant Curtyse William gent 589341 589341 Curtyse, William, of Tenterden, gent 0
4226220 2104641 2104641 defendant Hawle Robert husbandman 589341 589341 Hawle Robert, of Tenterden, husbandman 1
4226221 2104641 2104641 defendant Daye Thomas yeoman 589341 589341 Daye, Thomas, of Tenterden, yeoman 2
4249377 2112775 2112775 defendant Fuller William yeoman 589341 589341 Fuller, William, of Tenterden, yeoman 1
4253557 2114179 2114179 defendant Curtyse William gent 589341 589341 Curtyse, William, of Tenterden, gent 0
4253558 2114179 2114179 defendant Hawle Robert husbandman 589341 589341 Hawle, Robert, of Tenterden, husbandman 1
4253559 2114179 2114179 defendant Daye Thomas yeoman 589341 589341 Daye, Thomas, of Tenterden, yeoman 2
4258051 2115663 2115663 defendant Cusshman Alexander gent 589341 589341 Cusshman, Alexander, of Tenterden, or of Cranebrooke, Kent, gent 1
4316600 2135924 2135924 defendant Goodchilde Lewis carpenter 589341 589341 Goodchilde, Lewis, of Tenterden, carpenter 0
4316602 2135925 2135925 defendant Taunton Peter yeoman 589341 589341 Taunton Peter, of Tenterden, yeoman 0
4316604 2135926 2135926 defendant Taunton Peter yeoman 589341 589341 Taunton, Peter, of Tenterden, yeoman 0
4323853 2138390 2138390 defendant Austen Edward tailor 589341 589341 Austen, Edward, of Tenterden, tailor 0
4332403 2141128 2141128 defendant Pyxe William clothier 589341 589341 Pyxe, William, of Tenterden, clothier 0
4359550 2150574 2150574 defendant Keete or Kett Wolfram husbandman 589341 589341 Keete or Kett, Wolfram, of Tenterden, husbandman 0
4359552 2150575 2150575 defendant Keete Wolfram husbandman 589341 589341 Keete, Wolfram, of Tenterden, husbandman 0
4364134 2152227 2152227 defendant Jervis Edward yeoman 589341 589341 Jervis, Edward, of Tenterden, yeoman 0
4364172 2152242 2152242 defendant Jervis Edward yeoman 589341 589341 Jervis, Edward, of Tenterden, yeoman 0
4390886 2161566 2161566 defendant Jervys Edward yeoman 589341 589341 Jervys, Edward, of Tenterden, yeoman 0
4461284 2188614 2188614 defendant Frynton William   589341 589341 Frynton, William, of Tenterden 0
4511166 2203942 2203942 defendant Borman Thomas   589341 589341 Borman, Thomas, of Tenterden 0
4522740 2207448 2207448 defendant Gateman Philip   589341 589341 Gateman, Philip, of Tenterden 0
4540994 2213090 2213090 plaintiff William Thomas   589341 589341 William, Thomas, of Tenterden 0
4543646 2213908 2213908 defendant Chivelyng Thomas   589341 589341 Chivelyng, Thomas, of Tenterden 0
4573725 2223298 2223298 defendant Gymote Robert   589341 589341 Gymote, Robert, of Tenterden 0
4576546 2224175 2224175 defendant Hethenden Philip   589341 589341 Hethenden, Philip, of Tenterden 1
4577347 2224429 2224429 defendant Rolf Simon   589341 589341 Rolf, Simon, of Tenterden 4
4577362 2224434 2224434 defendant Rolf Simon   589341 589341 Rolf, Simon, of Tenterden 0
4577497 2224476 2224476 defendant atte Helle John   589341 589341 atte Helle, John, of Tenterden 0
4588271 2227723 2227723 defendant Teghelere Thomas   589341 589341 Teghelere, Thomas, of Tenterden 1
4590550 2228402 2228402 defendant Werthe William   589341 589341 Werthe, William, of Tenterden 0
4590551 2228402 2228402 defendant Werthe John brother of William 589341 589341 Werthe, John, of Tenterden, brother of William 1
4605805 2232930 2232930 defendant Hunte John   589341 589341 Hunte, John, of Tenterden 0
4606320 2233091 2233091 defendant Dobill John   589341 589341 Dobill, John, of Tenterden 0
4619080 2236962 2236962 defendant Ryngebell Thomas tanner 589341 589341 Ryngebell, Thomas, of Tenterden, tanner 0
4619442 2237072 2237072 defendant Carpenter Stephen   589341 589341 Carpenter, Stephen, of Tenterden 0
4635388 2241903 2241903 plaintiff Yve Alice   589341 589341 Yve, Alice, of Tenterden, formerly wife of Thomas Ive, sen 1
4635392 2241904 2241904 plaintiff Yve Alice mother of William Ive 589341 589341 Yve, Alice, of Tenterden, formerly wife of William: Yve, Alice, mother of William Ive 1
4638493 2242798 2242798 defendant Rolfe John   589341 589341 Rolfe, John, of Tenterden 3
4639793 2243142 2243142 plaintiff Crosby Richard   589341 589341 Crosby, Richard, of Tenterden 0
4641579 2243639 2243639 plaintiff Fynch Robert   589341 589341 Fynch, Robert, of Tenterden 0
4642223 2243844 2243844 defendant Dobyll John   589341 589341 Dobyll, John, of Tenterden 0
4652464 2246721 2246721 defendant Dobyll John   589341 589341 Dobyll, John, of Tenterden 0
4660848 2249219 2249219 defendant Stevens William   589341 589341 Stevens, William, of Tenterden 0
4665230 2250614 2250614 plaintiff Hethynden Robert   589341 589341 Hethynden, Robert, of Tenterden 0
4665231 2250614 2250614 defendant Bray Thomas yeoman 589341 589341 Bray, Thomas, of Tenterden, yeoman 0
4665232 2250615 2250615 plaintiff Hethynden Robert   589341 589341 Hethynden, Robert, of Tenterden 0
4665233 2250615 2250615 defendant Lacok Robert esq 589341 589341 Lacok, Robert, of Tenterden, esq 0
4665234 2250616 2250616 plaintiff Hethyngden Robert   589341 589341 Hethyngden, Robert, of Tenterden 0
4665235 2250616 2250616 defendant Bray Thomas yeoman 589341 589341 Bray, Thomas, of Tenterden, yeoman 0
4666373 2250958 2250958 plaintiff Ive William (legal representative) 589341 589341 Ive, William, of Tenterden, executrix of 0
4666376 2250959 2250959 plaintiff Ive William (legal representative) 589341 589341 Ive, William, of Tenterden, executrix of 0
4677785 2258671 2258671 defendant Denet Thomas laborer 589341 589341 Denet, Thomas, of Tenterden, laborer 1
4690931 2262693 2262693 defendant Doune Thomas carpenter 589341 589341 Doune, Thomas, of Tenterden, carpenter 0
4691665 2262927 2262927 defendant Blosine or Blosme William husbandman 589341 589341 Blosine or Blosme, William, of Tenterden, husbandman 0
4696086 2264258 2264258 defendant Doun Thomas laborer 589341 589341 Doun, Thomas, of Tenterden, laborer 0
4706564 2267430 2267430 defendant Stonden John butcher 589341 589341 Stonden, John, of Tenterden, butcher 2

Next page

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