names

194 rows where place_id = 603903

✎ 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
3656148 1912174 1912174 defendant Fayrewey Robert clothman 603903 603903 Fayrewey, Robert, of Cranbrook, clothman 3
3656883 1912409 1912409 defendant Courthope Richard clothier 603903 603903 Courthope, Richard, of Cranbrook, clothier 0
3657635 1912648 1912648 defendant Batherst Lawrence weaver 603903 603903 Batherst, Lawrence, of Cranbrook, weaver 0
3658016 1912761 1912761 plaintiff Draver Stephen yeoman 603903 603903 Draver, Stephen, of Cranbrook, yeoman 0
3663346 1914459 1914459 defendant Parker Geoffrey clothmaker 603903 603903 Parker, Geoffrey, of Cranbrook, clothmaker 2
3665807 1915246 1915246 defendant Frankleyn John weaver 603903 603903 Frankleyn, John, of Cranbrook, weaver 1
3666402 1915442 1915442 defendant Carter Reginald   603903 603903 Carter, Reginald, of Cranbrook, cloth maker 3
3937573 2002900 2002900 defendant Syman John husbandman 603903 603903 Syman, John, of Cranbrook, husbandman 2
3941191 2004057 2004057 plaintiff Draver William gent 603903 603903 Draver, William, of Cranbrook, gent 1
4017239 2030872 2030872 plaintiff Taylour Richard clothier 603903 603903 Taylour, Richard, of Cranbrook, clothier 0
4435144 2175757 2175757 defendant Morys John   603903 603903 Morys, John, of Cranbrook 1
4438425 2181307 2181307 defendant Harcherigge Thomas   603903 603903 Harcherigge, Thomas, of Cranbrook 8
4471258 2191676 2191676 plaintiff Cardere Richard   603903 603903 Cardere, Richard, of Cranbrook 0
4493733 2198738 2198738 defendant Dyn Thomas   603903 603903 Dyn, Thomas, of Cranbrook 2
4509662 2203501 2203501 plaintiff atte Wode John   603903 603903 atte Wode, John, of Cranbrook 0
4514728 2205021 2205021 defendant Partrich William   603903 603903 Partrich, William, of Cranbrook 6
4520920 2206882 2206882 plaintiff Fraunceys John   603903 603903 Fraunceys, John, of Cranbrook 0
4526820 2208666 2208666 defendant Berlyng Alexander shoemaker 603903 603903 Berlyng, Alexander, of Cranbrook, shoemaker 0
4545262 2214439 2214439 defendant Penylonde John   603903 603903 Penylonde, John, of Cranbrook 0
4548327 2215421 2215421 defendant Broman Robert   603903 603903 Broman, Robert, of Cranbrook 1
4548337 2215421 2215421 defendant Sefeld Simon   603903 603903 Sefeld, Simon, of Cranbrook 11
4548338 2215421 2215421 defendant Heselend Henry   603903 603903 Heselend, Henry, of Cranbrook 12
4551158 2216304 2216304 defendant Bien John, sen   603903 603903 Bien, John, sen, of Cranbrook 0
4557777 2218361 2218361 plaintiff Leche John   603903 603903 Leche, John, of Cranbrook 0
4575095 2223732 2223732 defendant Waterman Thomas   603903 603903 Waterman, Thomas, of Cranbrook 1
4575096 2223732 2223732 defendant Hesylden John   603903 603903 Hesylden, John, of Cranbrook 2
4590870 2228495 2228495 plaintiff May Thomas   603903 603903 May, Thomas, of Cranbrook 0
4590871 2228495 2228495 defendant atte Wode John   603903 603903 atte Wode, John, of Cranbrook, son of John 0
4590872 2228496 2228496 plaintiff May Thomas   603903 603903 May, Thomas, of Cranbrook 0
4590873 2228496 2228496 defendant atte Wode John   603903 603903 atte Wode, John, of Cranbrook, son of John, of Haukhurst 0
4610324 2234314 2234314 plaintiff Cardere Richard   603903 603903 Cardere, Richard, of Cranbrook 0
4619707 2237149 2237149 defendant Betenham John, sen   603903 603903 Betenham, John, sen, of Cranbrook 0
4629980 2240299 2240299 defendant Eldyndenn Thomas   603903 603903 Eldyndenn, Thomas, of Cranbrook 0
4632200 2240953 2240953 plaintiff Turnethort John (legal representative) 603903 603903 Turnethort, John, of Cranbrook, executor of 0
4632202 2240953 2240953 defendant Whitheryngden John   603903 603903 Whitheryngden, John, of Cranbrook 0
4641053 2243473 2243473 defendant Cardere Richard   603903 603903 Cardere, Richard, of Cranbrook 1
4646356 2244999 2244999 defendant Amys Simon   603903 603903 Amys, Simon, of Cranbrook 0
4692622 2263209 2263209 defendant Ryngemer Robert butcher 603903 603903 Ryngemer, Robert, of Cranbrook, butcher 0
4692623 2263209 2263209 defendant Gateman William laborer 603903 603903 Gateman, William, of Cranbrook, laborer 1
4692710 2263229 2263229 defendant Tylthe William husbandman 603903 603903 Tylthe, William, of Cranbrook, husbandman 0
4692715 2263232 2263232 plaintiff atte Wode John   603903 603903 atte Wode, John, of Cranbrook 0
4694472 2263765 2263765 defendant Reve or Rene William laborer 603903 603903 Reve or Rene, William, of Cranbrook, laborer 0
4694475 2263766 2263766 defendant Chitynden Laurence laborer 603903 603903 Chitynden, Laurence, of Cranbrook, laborer 0
4694921 2263901 2263901 defendant Tylye Morris butcher 603903 603903 Tylye, Morris, of Cranbrook, butcher 0
4697334 2264647 2264647 defendant Tylthe William yeoman 603903 603903 Tylthe, William, of Cranbrook, yeoman 0
4699799 2265382 2265382 defendant Dosy John laborer 603903 603903 Dosy, John, of Cranbrook, laborer 0
4699801 2265383 2265383 defendant Dosy John laborer 603903 603903 Dosy, John, of Cranbrook, laborer 0
4702230 2266106 2266106 defendant Dosy John laborer 603903 603903 Dosy, John, of Cranbrook, laborer 3
4705263 2267016 2267016 defendant fitz Piers Thomas yeoman 603903 603903 fitz Piers, Thomas, of of Cranbrook, yeoman 0
4708587 2268058 2268058 defendant Broman Robert yeoman 603903 603903 Broman, Robert, of Cranbrook, yeoman 0
4712989 2269380 2269380 defendant Fyshook Nicholas butcher 603903 603903 Fyshook, Nicholas, of Cranbrook, butcher 0
4722250 2272280 2272280 defendant Tilthe William yeoman 603903 603903 Tilthe, William, of Cranbrook, yeoman 0
4729660 2274487 2274487 defendant atte Wode John husbandman 603903 603903 atte Wode, John, of Cranbrook, husbandman 0
4729661 2274487 2274487 defendant atte Wode Simon husbandman 603903 603903 atte Wode, Simon, of Cranbrook, husbandman 1
4729662 2274487 2274487 defendant atte Wode Christine widow 603903 603903 atte Wode, Christine, of Cranbrook, widow 2
4729663 2274487 2274487 defendant Nettere Geoffrey husbandman 603903 603903 Nettere, Geoffrey, of Cranbrook, husbandman 3
4735487 2276246 2276246 plaintiff Stace John   603903 603903 Stace, John, of Cranbrook 0
4735661 2276302 2276302 defendant Stevenys Walter clerk 603903 603903 Stevenys, Walter, of Cranbrook, clerk 0
4738946 2277270 2277270 defendant Tylthe William husbandman 603903 603903 Tylthe, William, of Cranbrook, husbandman 0
4740717 2277803 2277803 defendant Beaghynden John husbandman 603903 603903 Beaghynden, John, of Cranbrook, husbandman 2
4749023 2280198 2280198 defendant Tylthe William   603903 603903 Tylthe, William, of Cranbrook, franklin 0
4752500 2281191 2281191 defendant Sharp Margaret widow & formerly wife of William Sharp 603903 603903 Sharp, Margaret, of Cranbrook, widow & formerly wife of William Sharp 3
4757790 2282813 2282813 plaintiff Brodebregge William husbandman 603903 603903 Brodebregge, William, of Cranbrook, husbandman 0
4759367 2283272 2283272 defendant Beaghynden James yeoman 603903 603903 Beaghynden, James, of Cranbrook, yeoman 1
4762211 2284160 2284160 defendant Curtynden Thomas   603903 603903 Curtynden, Thomas, of Cranbrook, wheel wright 2
4764890 2284999 2284999 defendant Harcheregge Thomas husbandman 603903 603903 Harcheregge, Thomas, of Cranbrook, husbandman 0
4764891 2284999 2284999 defendant Badecok John laborer 603903 603903 Badecok, John, of Cranbrook, laborer 1
4764892 2284999 2284999 defendant Raumelde William laborer 603903 603903 Raumelde, William, of Cranbrook, laborer 2
4766585 2285541 2285541 defendant atte Wode Simon husbandman 603903 603903 atte Wode, Simon, of Cranbrook, husbandman 1
4766586 2285541 2285541 defendant atte Wode Christine widow 603903 603903 atte Wode, Christine, of Cranbrook, widow 2
4766587 2285541 2285541 defendant Nettere Geoffrey husbandman 603903 603903 Nettere, Geoffrey, of Cranbrook, husbandman 3
4768397 2286086 2286086 defendant Tylthe William   603903 603903 Tylthe, William, of Cranbrook, franklin 0
4775521 2288336 2288336 defendant Tylthe William husbandman 603903 603903 Tylthe, William, of Cranbrook, husbandman 0
4778833 2289353 2289353 defendant Carder Stephen chapman 603903 603903 Carder, Stephen, of Cranbrook, chapman 1
4821753 2302881 2302881 plaintiff Salt William   603903 603903 Salt, William, of Cranbrook 0
4830144 2305469 2305469 defendant Broke John husbandman 603903 603903 Broke, John, of Cranbrook, husbandman 0
4834174 2306698 2306698 defendant Hert Henry   603903 603903 Hert, Henry, of Cranbrook, servant 0
4846896 2310538 2310538 defendant atte Welle Walter butcher 603903 603903 atte Welle, Walter, of Cranbrook, butcher 0
4847202 2310624 2310624 plaintiff Robard John   603903 603903 Robard, John, of Cranbrook 0
4847213 2310628 2310628 defendant atte Wode John husbandman 603903 603903 atte Wode, John, of Cranbrook, husbandman 0
4887372 2322887 2322887 plaintiff Robertt John   603903 603903 Robertt, John, of Cranbrook 0
4892850 2324495 2324495 plaintiff Robert John   603903 603903 Robert, John, of Cranbrook 0
4987411 2353188 2353188 defendant Haselden John husbandman 603903 603903 Haselden, John, of Cranbrook, husbandman 0
5005275 2358444 2358444 defendant Turk William husbandman 603903 603903 Turk, William, of Cranbrook, husbandman 0
5005276 2358445 2358445 plaintiff Roberd John   603903 603903 Roberd, John, of Cranbrook 0
5048445 2371172 2371172 plaintiff Roberd John, senior draper 603903 603903 Roberd, John, senior, of Cranbrook, draper 0
5126022 2394097 2394097 plaintiff Bettenham Stephen yeoman 603903 603903 Bettenham, Stephen, of Cranbrook, yeoman 0
5126024 2394097 2394097 defendant Rycard John butcher 603903 603903 Rycard, John, of Cranbrook, butcher 1
5138320 2397718 2397718 plaintiff Robard John   603903 603903 Robard, John, of Cranbrook 0
5138322 2397719 2397719 plaintiff Robard John, senior   603903 603903 Robard, John, senior, of Cranbrook 0
5144645 2399592 2399592 plaintiff Bettenham Stephen yeoman 603903 603903 Bettenham, Stephen, of Cranbrook, yeoman 0
5144647 2399592 2399592 defendant Ricard John butcher 603903 603903 Ricard, John, of Cranbrook, butcher 1
5144648 2399593 2399593 plaintiff Bettenham Stephen yeoman 603903 603903 Bettenham, Stephen, of Cranbrook, yeoman 0
5144650 2399593 2399593 defendant Ricard John butcher 603903 603903 Ricard, John, of Cranbrook, butcher 1
5147881 2400522 2400522 defendant Barby William dyer 603903 603903 Barby, William, of Cranbrook, dyer 0
5152697 2401929 2401929 defendant Munde Robert husbandman 603903 603903 Munde, Robert, of Cranbrook, husbandman 1
5156420 2403030 2403030 defendant Ocley John   603903 603903 Ocley, John, of Cranbrook, inland fish seller 0
5159110 2403780 2403780 plaintiff Robard John, sen   603903 603903 Robard, John, sen, of Cranbrook 0
5159112 2403781 2403781 plaintiff Robard John, sen   603903 603903 Robard, John, sen, of Cranbrook 0
5159115 2403783 2403783 plaintiff Robert John   603903 603903 Robert, John, of Cranbrook 0

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