names

65 rows where place_id = 595909

✎ 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
3588551 1864061 1864061 defendant Plemton Thomas   595909 595909 Plemton, Thomas, of Bodman, mason 1
3622356 1874528 1874528 defendant Hardy John cordwainer 595909 595909 Hardy, John, of Bodman, cordwainer 0
3627140 1903346 1903346 defendant Laurence Thomas carpenter 595909 595909 Laurence, Thomas, of Bodman, carpenter 1
3629439 1904064 1904064 defendant Ambrey Peter yeoman 595909 595909 Ambrey, Peter, of Bodman, yeoman 2
3644372 1908657 1908657 defendant Trowte William chapman 595909 595909 Trowte, William, of Bodman, chapman 2
3666531 1915472 1915472 defendant Bant Peter   595909 595909 Bant, Peter, of Bodman, hardware man 0
3666533 1915472 1915472 defendant Hancok Thomas glover 595909 595909 Hancok, Thomas, of Bodman, glover 2
3669288 1916331 1916331 defendant Seke John   595909 595909 Seke, John, of Bodman 2
3669290 1916331 1916331 defendant Kelly William laborer 595909 595909 Kelly, William, of Bodman, laborer 4
3678048 1919178 1919178 defendant Blygh John merchant 595909 595909 Blygh, John, of Bodman, merchant 0
3693971 1924317 1924317 defendant Burgh John merchant 595909 595909 Burgh, John, of Bodman, merchant 0
3730230 1935682 1935682 defendant Jerman John glover 595909 595909 Jerman, John, of Bodman, glover 0
3733614 1936758 1936758 defendant Opy Nicholas gent 595909 595909 Opy, Nicholas, of Bodman, gent 0
3733615 1936758 1936758 defendant Kyllygrewe Alexander gent 595909 595909 Kyllygrewe, Alexander, of Bodman, gent 1
3733618 1936758 1936758 defendant Powly Nicholas laborer 595909 595909 Powly, Nicholas, of Bodman, laborer 4
3761276 1945530 1945530 defendant Oppy Robert gent 595909 595909 Oppy, Robert, of Bodman, gent 2
3820037 1964146 1964146 defendant Harrys Nicholas, junior tanner 595909 595909 Harrys, Nicholas, junior, of Bodman, tanner 0
3820038 1964146 1964146 defendant Wakeham John laborer 595909 595909 Wakeham, John, of Bodman, laborer 1
3820404 1964262 1964262 defendant Wyde Robert cordwainer 595909 595909 Wyde, Robert, of Bodman, cordwainer 0
3820658 1964348 1964348 defendant Kelley Maurice laborer 595909 595909 Kelley, Maurice, of Bodman, laborer 1
3820659 1964348 1964348 defendant Bolke John laborer 595909 595909 Bolke, John, of Bodman, laborer 2
3820660 1964348 1964348 defendant Lanem Thomas laborer 595909 595909 Lanem Thomas, of Bodman, laborer 3
3824765 1965619 1965619 defendant Esam Walter husbandman 595909 595909 Esam, Walter, of Bodman, husbandman 0
3899918 1990189 1990189 defendant Poynter John   595909 595909 Poynter, John, of Bodman, "helyar" 0
3906449 1992451 1992451 defendant Whyte John   595909 595909 Whyte, John, of Bodman, "bellatory" 0
3907228 1992709 1992709 defendant Opy Thomas yeoman 595909 595909 Opy, Thomas, of Bodman, yeoman 0
3911878 1994299 1994299 defendant Spy Thomas yeoman 595909 595909 Spy, Thomas, of Bodman, yeoman 0
3911879 1994299 1994299 defendant Best Thomas laborer 595909 595909 Best, Thomas, of Bodman, laborer 1
3911880 1994299 1994299 defendant Rycheman Richard tanner 595909 595909 Rycheman, Richard, of Bodman, tanner 2
3914426 1995169 1995169 defendant Northby William tanner 595909 595909 Northby, William, of Bodman, tanner 0
3920637 1997251 1997251 plaintiff Mychell Ralph   595909 595909 Mychell, Ralph, of Bodman 0
3924459 1998494 1998494 defendant John alias Sturgyn Robert merchant 595909 595909 John alias Sturgyn, Robert, of Bodman, merchant 1
3928620 1999911 1999911 defendant Opy Thomas yeoman 595909 595909 Opy, Thomas, of Bodman, yeoman 0
3928621 1999911 1999911 defendant Curant or Turant Richard yeoman 595909 595909 Curant or Turant, Richard, of Bodman, yeoman 1
3942446 2004485 2004485 defendant Trelawny Richard   595909 595909 Trelawny, Richard, of Bodman, shoe maker 0
3942447 2004485 2004485 defendant Michell Thomas smith 595909 595909 Michell, Thomas, of Bodman, smith 1
3942448 2004485 2004485 defendant Corser Adam   595909 595909 Corser, Adam, of Bodman, shoe maker 2
3990755 2021449 2021449 defendant Bowyer Nicholas yeoman 595909 595909 Bowyer, Nicholas, of Bodman, yeoman 0
4180274 2088578 2088578 defendant Busee William joiner 595909 595909 Busee, William, of Bodman, joiner 1
4185784 2090525 2090525 defendant Cundy Richard chapman 595909 595909 Cundy, Richard, of Bodman, chapman 1
4203588 2096809 2096809 defendant Busto or Busco William joiner 595909 595909 Busto or Busco, William, of Bodman, joiner 1
4996408 2355784 2355784 plaintiff Halle William de (legal representative) 595909 595909 Halle, William de, of Bodman, burgess, executor of 0
4996415 2355786 2355786 plaintiff Halle William (legal representative) 595909 595909 Halle, William, of Bodman, burgess, executor of 0
4998175 2356322 2356322 defendant Wydell John goldsmith 595909 595909 Wydell, John, of Bodman, goldsmith 0
5141630 2398663 2398663 defendant Laury John   595909 595909 Laury, John, of Bodman, shoe maker 4
5141636 2398664 2398664 defendant Laury John   595909 595909 Laury, John, of Bodman, shoe maker 4
5233923 2425510 2425510 defendant Andrewe William tailor 595909 595909 Andrewe, William, of Bodman, tailor 0
5269959 2436322 2436322 defendant Treloderowe John smith 595909 595909 Treloderowe, John, of Bodman, smith 0
5296843 2444065 2444065 defendant Trewarthyan John weaver 595909 595909 (Trewarthyan, John, of Bodman, weaver 1
5321796 2451592 2451592 defendant Cok William merchant 595909 595909 Cok, William, of Bodman, merchant 0
5344346 2458413 2458413 plaintiff Tomma John   595909 595909 Tomma, John, of Bodman, "brasynter" or brasier 0
5353293 2461104 2461104 defendant Bodynyell Ralph stainer 595909 595909 Bodynyell, Ralph, of Bodman, stainer 1
5353295 2461104 2461104 defendant Stroute John dyer 595909 595909 Stroute, John, of Bodman, dyer 3
5356962 2462240 2462240 defendant Cok William yeoman 595909 595909 Cok, William, of Bodman, yeoman 0
5370146 2466246 2466246 defendant Hogge John weaver 595909 595909 Hogge, John, of Bodman, weaver 2
5379236 2469100 2469100 defendant Raulyn John   595909 595909 Raulyn, John, of Bodman yeoman 1
5394843 2473594 2473594 defendant Raulyn John yeoman 595909 595909 Raulyn, John, of Bodman, yeoman 1
5407824 2477316 2477316 defendant Raulyn John yeoman 595909 595909 Raulyn, John, of Bodman, yeoman 1
5480156 2499049 2499049 defendant Hancok John, senior tiler 595909 595909 Hancok, John, senior, of Bodman, tiler 0
5482760 2499789 2499789 defendant Stokkys Richard yeoman 595909 595909 Stokkys, Richard, of Bodman, yeoman 3
5550101 2520065 2520065 defendant Wodecoke John yeoman 595909 595909 Wodecoke, John, of Bodman, yeoman 2
5557419 2522131 2522131 defendant Wattys Thomas mercer 595909 595909 Wattys, Thomas, of Bodman, mercer 1
5603602 2536000 2536000 defendant Hardwareman alias Bant Peter yeoman 595909 595909 Hardwareman alias Bant, Peter, of Bodman, yeoman 0
5632968 2554316 2554316 defendant Talek William chapman 595909 595909 Talek, William, of Bodman, chapman 4
5632974 2554317 2554317 defendant Talek William chapman 595909 595909 Talek, William, of Bodman, chapman 4

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