names

86 rows where place_id = 608698

✎ 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
3674976 1918205 1918205 plaintiff Hacche Henry yeoman 608698 608698 Hacche, Henry, of Faversham, Kent, yeoman 0
3796363 1956728 1956728 defendant Hony John shoemaker 608698 608698 Hony, John, of Faversham, Kent, shoemaker 0
3884606 1985124 1985124 defendant Scott William yeoman 608698 608698 Scott, William, of Faversham, Kent, yeoman 1
3933766 2001588 2001588 defendant Marden Elizabeth widow 608698 608698 Marden, Elizabeth, of Faversham, Kent, widow 2
3937758 2002960 2002960 defendant Bennytt William grazier 608698 608698 Bennytt, William, of Faversham, Kent, grazier 0
3937761 2002961 2002961 defendant Dennytt William grasier 608698 608698 Dennytt, William, of Faversham, Kent, grasier 0
3940831 2003938 2003938 defendant Mote alias Mott Stephen gent 608698 608698 Mote alias Mott, Stephen, of Faversham, Kent, gent 0
3940834 2003939 2003939 defendant Motte Stephen gent 608698 608698 Motte, Stephen, of Faversham, Kent, gent 0
3942154 2004395 2004395 defendant Father John gent 608698 608698 Father, John, of Faversham, Kent, gent 0
3942157 2004396 2004396 defendant Fathers John gent 608698 608698 Fathers, John, of Faversham, Kent, gent 0
3969364 2013889 2013889 defendant Taylor William yeoman 608698 608698 Taylor, William, of Faversham, Kent, yeoman 2
4475425 2192991 2192991 defendant Dyer John   608698 608698 Dyer, John, of Faversham, Kent 3
4540451 2212913 2212913 plaintiff Wepere John   608698 608698 Wepere, John, of Faversham, Kent 0
4569713 2222111 2222111 defendant Botour John   608698 608698 Botour, John, of Faversham, Kent 1
4576746 2224237 2224237 defendant Bryse Thomas   608698 608698 Bryse, Thomas, of Faversham, Kent 0
4609580 2234094 2234094 defendant Brite William   608698 608698 Brite, William, of Faversham, Kent 5
4642762 2243996 2243996 defendant Staunton John   608698 608698 Staunton, John, of Faversham, Kent 3
4643267 2244137 2244137 defendant Bryncle John   608698 608698 Bryncle, John, of Faversham, Kent 4
4675533 2257958 2257958 defendant Wade William husbandman 608698 608698 Wade, William, of Faversham, Kent, husbandman 3
4683350 2260396 2260396 defendant Childemelle Thomas spicer 608698 608698 Childemelle, Thomas, of Faversham, Kent, spicer 2
4697972 2264859 2264859 defendant Paye Henry gent 608698 608698 Paye, Henry, of Faversham, Kent, gent 0
4703629 2266514 2266514 defendant Peke John tanner 608698 608698 Peke, John, of Faversham, Kent, tanner 0
4703631 2266515 2266515 defendant Poke John tanner 608698 608698 Poke, John, of Faversham, Kent, tanner 0
4728369 2274110 2274110 defendant Barbour William barber 608698 608698 (Barbour, William, of Faversham, Kent, barber 4
4730493 2274736 2274736 defendant Preston Peter   608698 608698 Preston, Peter, of Faversham, Kent, wool man 0
4730496 2274737 2274737 defendant Preston Peter   608698 608698 Preston, Peter, of Faversham, Kent, wool man 0
4732147 2275238 2275238 defendant Barry Lawrence clerk 608698 608698 Barry, Lawrence, of Faversham, Kent, clerk 0
4738921 2277264 2277264 defendant atte Fen Robert husbandman 608698 608698 atte Fen, Robert, of Faversham, Kent, husbandman 1
4758356 2282986 2282986 defendant Breesse William chapman 608698 608698 Breesse, William, of Faversham, Kent, chapman 1
4763116 2284444 2284444 defendant Browene William chapman 608698 608698 Browene, William, of Faversham, Kent, chapman 2
4768333 2286068 2286068 defendant Stanes Thomas hosier 608698 608698 Stanes, Thomas, of Faversham, Kent, hosier 0
4805295 2297858 2297858 defendant Barbour William merchant 608698 608698 Barbour, William, of Faversham, Kent, merchant 0
4805297 2297859 2297859 defendant Barbour William merchant 608698 608698 Barbour, William, of Faversham, Kent, merchant 0
4817613 2301596 2301596 defendant Eston John mercer 608698 608698 Eston, John, of Faversham, Kent, mercer 4
4817622 2301598 2301598 defendant Eston John mercer 608698 608698 Eston, John, of Faversham, Kent, mercer 4
4848369 2310960 2310960 defendant Dowene John gent 608698 608698 Dowene, John, of Faversham, Kent, gent 1
4883329 2321709 2321709 defendant Middelton John yeoman 608698 608698 Middelton, John, of Faversham, Kent, yeoman 3
4889155 2323396 2323396 defendant Middelton John yeoman 608698 608698 Middelton, John, of Faversham, Kent, yeoman 2
4908351 2329166 2329166 defendant Kyng Robert chapman 608698 608698 Kyng, Robert, of Faversham, Kent, chapman 2
4911654 2330147 2330147 defendant Dryland Richard gent 608698 608698 Dryland, Richard, of Faversham, Kent, gent 0
4912628 2330453 2330453 defendant St Clere John gent 608698 608698 St Clere, John, of Faversham, Kent, gent 0
4919000 2332455 2332455 defendant St Clier Richard (legal representative) 608698 608698 St Clier, Richard, of Faversham, Kent, merchant, executrix of 0
4925373 2334370 2334370 defendant St Clere (illegible) gent 608698 608698 St Clere, ---, of Faversham, Kent, gent 3
4925581 2334436 2334436 defendant St Clere (illegible) gent 608698 608698 St Clere, ---, of Faversham, Kent, gent 3
4926171 2334612 2334612 defendant Beeld Alexander chandler 608698 608698 Beeld, Alexander, of Faversham, Kent, chandler 4
4926177 2334613 2334613 defendant Beeld Alexander chandler 608698 608698 Beeld, Alexander, of Faversham, Kent, chandler 4
4929637 2335684 2335684 defendant St Clere John gent 608698 608698 St Clere, John, of Faversham, Kent, gent 0
4992683 2354693 2354693 defendant Clyfton Thomas yeoman 608698 608698 Clyfton, Thomas, of Faversham, Kent, yeoman 4
4996848 2355914 2355914 defendant Drylond Richard esq 608698 608698 Drylond, Richard, of Faversham, Kent, esq 1
5005158 2358407 2358407 plaintiff Brygge John mercer 608698 608698 Brygge, John, of Faversham, Kent, mercer 1
5005161 2358407 2358407 defendant Clyfton Thomas yeoman 608698 608698 Clyfton, Thomas, of Faversham, Kent, yeoman 2
5005905 2358628 2358628 defendant Masham Nicholas gent 608698 608698 Masham, Nicholas, of Faversham, Kent, gent 0
5041122 2368966 2368966 defendant atte Well William butcher 608698 608698 atte Well, William, of Faversham, Kent, butcher 0
5041780 2369143 2369143 defendant Drylond Richard esq 608698 608698 Drylond, Richard, of Faversham, Kent, esq 0
5131870 2395805 2395805 defendant Hereward Thomas baker 608698 608698 Hereward, Thomas, of Faversham, Kent, baker 0
5134402 2396557 2396557 defendant Pyke Margaret widow 608698 608698 Pyke, Margaret, of Faversham, Kent, widow 3
5138086 2397646 2397646 defendant Sergeant William merchant 608698 608698 Sergeant, William, of Faversham, Kent, merchant 1
5143239 2399160 2399160 defendant Chicche Valentine esq 608698 608698 Chicche, Valentine, of Faversham, Kent, esq 0
5151402 2401560 2401560 defendant Herward Thomas baker 608698 608698 Herward, Thomas, of Faversham, Kent, baker 0
5151407 2401561 2401561 defendant Herward Thomas baker 608698 608698 Herward, Thomas, of Faversham, Kent, baker 0
5158776 2403690 2403690 defendant Sergeant William merchant 608698 608698 Sergeant, William, of Faversham, Kent, merchant 1
5169552 2406831 2406831 defendant Herward Thomas baker 608698 608698 Herward, Thomas, of Faversham, Kent, baker 0
5192891 2413644 2413644 defendant Ulphe John chapman 608698 608698 Ulphe, John, of Faversham, Kent, chapman 1
5197516 2415013 2415013 defendant Mouter Baldwin   608698 608698 Mouter, Baldwin, of Faversham, Kent, dutch man 4
5210174 2418703 2418703 defendant Monter Baldwin dutchman 608698 608698 Monter, Baldwin, of Faversham, Kent, dutchman 4
5247731 2429484 2429484 defendant Ulfe John grocer 608698 608698 Ulfe, John, of Faversham, Kent, grocer 0
5276691 2438263 2438263 defendant Seyntle or St Le Thomas gent 608698 608698 Seyntle or St Le, Thomas, of Faversham, Kent, gent 2
5276696 2438264 2438264 defendant Seyntle or St Le Thomas gent 608698 608698 Seyntle or St Le, Thomas, of Faversham, Kent, gent 2
5303940 2446182 2446182 defendant Eueas John gent 608698 608698 Eueas, John, of Faversham, Kent, gent 0
5305916 2446754 2446754 defendant Knyght Stephen gent 608698 608698 Knyght, Stephen, of Faversham, Kent, gent 3
5373427 2467284 2467284 defendant Malpasse Robert chapman 608698 608698 Malpasse, Robert, of Faversham, Kent, chapman 0
5391264 2472579 2472579 defendant Gadlyng Robert carpenter 608698 608698 Gadlyng, Robert, of Faversham, Kent, carpenter 1
5394607 2473518 2473518 defendant Badnore John glover 608698 608698 Badnore, John, of Faversham, Kent, glover 1
5400044 2475094 2475094 defendant Benete Thomas gent 608698 608698 Benete, Thomas, of Faversham, Kent, gent 0
5400447 2475197 2475197 defendant Benete Thomas gent 608698 608698 Benete, Thomas, of Faversham, Kent, gent 0
5403290 2476018 2476018 defendant Malpasse Robert chapman 608698 608698 Malpasse, Robert, of Faversham, Kent, chapman 0
5404461 2476345 2476345 defendant Anotton John sheer man 608698 608698 Anotton, John, of Faversham, Kent, sheer man 3
5416309 2479798 2479798 defendant Malpasse Robert chapman 608698 608698 Malpasse, Robert, of Faversham, Kent, chapman 0
5417599 2480181 2480181 defendant Anorten John sheerman 608698 608698 Anorten, John, of Faversham, Kent, sheerman 3
5433046 2484850 2484850 defendant Malpase Robert chapman 608698 608698 Malpase, Robert, of Faversham, Kent, chapman 0
5433052 2484851 2484851 defendant Malpasse Robert chapman 608698 608698 Malpasse, Robert, of Faversham, Kent, chapman 0
5437144 2486042 2486042 defendant Sparrowe Thomas tailor 608698 608698 Sparrowe, Thomas, of Faversham, Kent, tailor 3
5439750 2486831 2486831 defendant Legge William ironmonger 608698 608698 Legge, William, of Faversham, Kent, ironmonger 0
5453708 2491005 2491005 defendant Leggye William ironmonger 608698 608698 Leggye, William, of Faversham, Kent, ironmonger 0
5465319 2494534 2494534 defendant Legge John ironmonger 608698 608698 Legge, John, of Faversham, Kent, ironmonger 0
5476818 2498069 2498069 defendant Legge John ironmonger 608698 608698 Legge, John, of Faversham, Kent, ironmonger 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);