names

89 rows where place_id = 597088

✎ 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
3627256 1903371 1903371 plaintiff Blakhed John   597088 597088 Blakhed, John, of Tryng 0
3627258 1903371 1903371 defendant Bocher William husbandman 597088 597088 Bocher, William, of Tryng, husbandman 1
3627259 1903372 1903372 plaintiff Blakhed John mercer 597088 597088 Blakhed, John, of Tryng, mercer 0
3627262 1903372 1903372 defendant Rampton William husbandman 597088 597088 Rampton, William, of Tryng, husbandman 2
3634653 1905637 1905637 defendant Mawdelyn John smith 597088 597088 Mawdelyn, John, of Tryng, smith 0
3637023 1906377 1906377 defendant Clerk John husbandman 597088 597088 Clerk, John, of Tryng, husbandman 1
3637174 1906426 1906426 defendant Gardyner Thomas butcher 597088 597088 Gardyner, Thomas, of Tryng, butcher 4
3642988 1908256 1908256 defendant Hyll Thomas husbandman 597088 597088 Hyll, Thomas, of Tryng, husbandman 0
3642989 1908256 1908256 defendant Foster John fuller 597088 597088 Foster, John, of Tryng, fuller 1
3648220 1909841 1909841 defendant Marlond John smith 597088 597088 Marlond, John, of Tryng, smith 1
3669566 1916419 1916419 plaintiff Blakhed John (legal representative) 597088 597088 Blakhed, John, of Tryng, mercer, executors of 0
3669576 1916421 1916421 plaintiff Blakhed Thomas   597088 597088 Blakhed, Thomas, of Tryng 0
3674340 1918019 1918019 defendant Blakhed Thomas mercer 597088 597088 Blakhed, Thomas, of Tryng, mercer 0
3701062 1926581 1926581 defendant Cumber Nicholas yeoman 597088 597088 Cumber, Nicholas, of Tryng, yeoman 0
3701064 1926581 1926581 defendant Hyll Thomas husbandman 597088 597088 Hyll, Thomas, of Tryng, husbandman 2
3701069 1926582 1926582 defendant Wellys Richard husbandman 597088 597088 Wellys, Richard, of Tryng, husbandman 0
3701070 1926582 1926582 defendant Startowt Henry husbandman 597088 597088 Startowt, Henry, of Tryng, husbandman 1
3701071 1926582 1926582 defendant Whitchurch Adrian husbandman 597088 597088 Whitchurch, Adrian, of Tryng, husbandman 2
3703555 1927387 1927387 plaintiff Dey William   597088 597088 Dey, William, of Tryng 0
3703556 1927387 1927387 defendant Colyn John husbandman 597088 597088 Colyn, John, of Tryng, husbandman 0
3703557 1927387 1927387 defendant Lock William husbandman 597088 597088 Lock, William, of Tryng, husbandman 1
3706301 1928258 1928258 defendant Colyns John maltman 597088 597088 Colyns, John, of Tryng, maltman 0
3706321 1928264 1928264 defendant Deye William yeoman 597088 597088 Deye, William, of Tryng, yeoman 1
3724804 1934042 1934042 defendant Grover Miles gent 597088 597088 Grover, Miles, of Tryng, gent 0
3732792 1936485 1936485 defendant Hechecoke William husbandman 597088 597088 Hechecoke, William, of Tryng, husbandman 1
3734036 1936893 1936893 defendant Wyggenton Thomas husbandman 597088 597088 Wyggenton, Thomas, of Tryng, husbandman 0
3734956 1937168 1937168 defendant Comber Nicholas innholder 597088 597088 Comber, Nicholas, of Tryng, innholder 2
3734957 1937168 1937168 defendant Pratte Richard laborer 597088 597088 Pratte, Richard, of Tryng, laborer 3
3750133 1941956 1941956 defendant Seman Edward fuller 597088 597088 Seman, Edward, of Tryng, fuller 0
3750134 1941956 1941956 defendant Seman Richard pulter 597088 597088 Seman, Richard, of Tryng, pulter 1
3751974 1942536 1942536 defendant Semand Richard fishmonger 597088 597088 Semand, Richard, of Tryng, fishmonger 1
3755146 1943560 1943560 defendant Tryng Richard husbandman 597088 597088 Tryng, Richard, of Tryng, husbandman 0
3755149 1943560 1943560 defendant Weymont John laborer 597088 597088 Weymont, John, of Tryng, laborer 3
3761862 1945718 1945718 defendant Wygynton Thomas laborer 597088 597088 Wygynton, Thomas, of Tryng, laborer 0
3761863 1945718 1945718 defendant Dagenall William husbandman 597088 597088 Dagenall, William, of Tryng, husbandman 1
3765321 1946817 1946817 defendant Colle William cooper 597088 597088 Colle, William, of Tryng, cooper 0
3765754 1946954 1946954 defendant Cumber Nicholas turner or baker 597088 597088 Cumber, Nicholas, of Tryng, turner or baker 0
3779001 1951154 1951154 defendant Hycchecok John husbandman 597088 597088 Hycchecok, John, of Tryng, husbandman 0
3797744 1957192 1957192 defendant Wrenne Thomas husbandman 597088 597088 Wrenne, Thomas, of Tryng, husbandman 0
3797842 1957221 1957221 defendant Hyll Thomas husbandman 597088 597088 Hyll, Thomas, of Tryng, husbandman 0
3797843 1957221 1957221 defendant Calvarn Thomas tailor 597088 597088 Calvarn, Thomas, of Tryng, tailor 1
3797845 1957221 1957221 defendant Hychecoke John husbandman 597088 597088 Hychecoke, John, of Tryng, husbandman 3
3803884 1959129 1959129 defendant Hill Thomas husbandman 597088 597088 Hill, Thomas, of Tryng, husbandman 0
3803893 1959130 1959130 defendant Wygenton Thomas husbandman 597088 597088 Wygenton, Thomas, of Tryng, husbandman 0
3813123 1962016 1962016 defendant Langley Richard husbandman 597088 597088 Langley, Richard, of Tryng, husbandman 0
3817898 1963515 1963515 defendant Cumber Nicholas turner 597088 597088 Cumber, Nicholas, of Tryng, turner 0
3817899 1963515 1963515 defendant Davers John butcher 597088 597088 Davers, John, of Tryng, butcher 1
3817900 1963515 1963515 defendant Whytchurch Andrew husbandman 597088 597088 Whytchurch, Andrew, of Tryng, husbandman 2
3824651 1965586 1965586 defendant Norton John miller 597088 597088 Norton, John,of Tryng, miller 0
3855444 1975345 1975345 defendant Dey William (legal representative) 597088 597088 Dey, William, of Tryng, yeoman, executrix of 0
3855445 1975345 1975345 defendant Dey Alice widow 597088 597088 Dey, Alice, of Tryng, widow 1
3920973 1997363 1997363 defendant Robyns alias Myller John husbandman 597088 597088 Robyns alias Myller, John, of Tryng, husbandman 1
3920977 1997364 1997364 defendant Robyns alias Myller John husbandman 597088 597088 Robyns alias Myller, John, of Tryng, husbandman 1
3925778 1998938 1998938 defendant Lanmote or Laumote John clerk 597088 597088 Lanmote or Laumote, John, of Tryng, clerk 0
3952318 2007881 2007881 defendant Herde John (legal representative) 597088 597088 Herde, John, of Tryng, yeoman, executrix of 0
3952319 2007881 2007881 defendant Herde Alice widow 597088 597088 Herde, Alice, of Tryng, widow 1
3954283 2008572 2008572 defendant Plumer William husbandman 597088 597088 Plumer, William, of Tryng, husbandman 0
4148794 2077698 2077698 defendant Grace William yeoman 597088 597088 Grace, William, of Tryng, yeoman 0
4471212 2191658 2191658 defendant Colles William   597088 597088 Colles, William, of Tryng 1
4539207 2212519 2212519 defendant Quynton John   597088 597088 Quynton, John, of Tryng 0
4637188 2242429 2242429 defendant Heryng John   597088 597088 Heryng, John, of Tryng 2
4782041 2290384 2290384 defendant Sewall Ralph yeoman 597088 597088 Sewall, Ralph, of Tryng, yeoman 0
4782127 2290410 2290410 defendant Cok George husbandman 597088 597088 Cok, George, of Tryng, husbandman 0
5029662 2365544 2365544 defendant Oitlyff or Oiclyff William butcher 597088 597088 Oitlyff or Oiclyff, William, of Tryng, butcher 0
5077570 2379788 2379788 defendant Bokemastre Richard husbandman 597088 597088 Bokemastre, Richard, of Tryng, husbandman 2
5096340 2385360 2385360 defendant Bodyn John (legal representative) 597088 597088 Bodyn, John, of Tryng, husbandman, executors of 3
5096341 2385360 2385360 defendant Bodyn Thomas husbandman 597088 597088 (Bodyn, Thomas, of Tryng, husbandman 4
5096342 2385360 2385360 defendant Atkyn Richard glover 597088 597088 Atkyn, Richard, of Tryng, glover 5
5123589 2393356 2393356 defendant Sende Thomas, senior yeoman 597088 597088 Sende, Thomas, senior, of Tryng, yeoman 0
5123590 2393356 2393356 defendant Sende Thomas, junior yeoman 597088 597088 Sende, Thomas, junior, of Tryng, yeoman 1
5225842 2423232 2423232 defendant Choppyn Richard husbandman 597088 597088 Choppyn, Richard, of Tryng, husbandman 0
5267871 2435716 2435716 defendant Barlowe John gent 597088 597088 Barlowe, John, of Tryng, gent 0
5268247 2435837 2435837 defendant Barlowe John gent 597088 597088 Barlowe, John, of Tryng, gent 0
5379190 2469088 2469088 defendant Grey William smith 597088 597088 Grey, William, of Tryng, smith 0
5446695 2488906 2488906 defendant Dryver William laborer 597088 597088 Dryver, William, of Tryng, laborer 0
5459289 2492686 2492686 defendant Dryver William laborer 597088 597088 Dryver, William, of Tryng, laborer 0
5506599 2506975 2506975 defendant Gardener John yeoman 597088 597088 Gardener, John, of Tryng, yeoman 4
5513249 2508995 2508995 plaintiff North alias Personage John husbandman 597088 597088 North alias Personage, John, of Tryng, husbandman 0
5525105 2512441 2512441 defendant Dryver William laborer 597088 597088 Dryver, William, of Tryng, laborer 0
5525106 2512441 2512441 defendant Donston William butcher 597088 597088 Donston, William, of Tryng, butcher 1
5528428 2513425 2513425 defendant Dunston William butcher 597088 597088 Dunston, William, of tryng, butcher 0
5537450 2516208 2516208 defendant Sergeaunt William husbandman 597088 597088 Sergeaunt, William, of Tryng, husbandman 1
5546218 2518886 2518886 defendant Blakhed John yeoman 597088 597088 Blakhed, John, of Tryng, yeoman 0
5546219 2518886 2518886 defendant Lok John laborer 597088 597088 Lok, John, of Tryng, laborer 1
5580954 2529118 2529118 defendant Crosse George gent 597088 597088 Crosse, George, of Tryng, gent 0
5594770 2533337 2533337 defendant Hyll Thomas maltman 597088 597088 Hyll, Thomas, of Tryng, maltman 1
5597040 2533986 2533986 defendant Seman John maltman 597088 597088 Seman, John, of Tryng, maltman 0
5599301 2534663 2534663 defendant Barkley Richard weaver 597088 597088 Barkley, Richard, of Tryng, weaver 2
5609275 2537802 2537802 defendant Stokton Richard, junior   597088 597088 Stokton, Richard, junior, of Tryng 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);