names

134 rows where place_id = 593454

✎ 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
3611903 1871385 1871385 defendant Glubbe Richard husbandman 593454 593454 Glubbe, Richard, of Tavystok, husbandman 0
3611904 1871385 1871385 defendant Launder John husbandman 593454 593454 Launder, John, of Tavystok, husbandman 1
3611905 1871385 1871385 defendant Langham Joan widow 593454 593454 Langham, Joan, of Tavystok, widow 2
3611906 1871385 1871385 defendant Parker Joan widow 593454 593454 Parker, Joan, of Tavystok, widow 3
3611907 1871385 1871385 defendant Wever Patrick husbandman 593454 593454 Wever, Patrick, of Tavystok, husbandman 4
3611908 1871385 1871385 defendant Paynter John husbandman 593454 593454 Paynter, John, of Tavystok, husbandman 5
3611909 1871385 1871385 defendant Brase Thomas dyer 593454 593454 Brase, Thomas, of Tavystok, dyer 6
3611910 1871385 1871385 defendant Sargeant William baker 593454 593454 Sargeant, William, of Tavystok, baker 7
3613414 1871843 1871843 defendant Toker John mercer 593454 593454 Toker, John, of Tavystok, mercer 0
3635571 1905928 1905928 defendant Tyrell John tucker 593454 593454 Tyrell, John, of Tavystok, tucker 2
3646205 1909206 1909206 defendant Foster Ralph yeoman 593454 593454 Foster, Ralph, of Tavystok, yeoman 1
3646206 1909206 1909206 defendant Foster John butcher 593454 593454 Foster, John, of Tavystok, butcher 2
3663472 1914501 1914501 defendant Amaden William, senior   593454 593454 Amaden, William, senior, of Tavystok 1
3674128 1917948 1917948 plaintiff Mayster William   593454 593454 Mayster, William, of Tavystok 4
3683605 1921004 1921004 plaintiff Webbe William (legal representative) 593454 593454 Webbe, William, of Tavystok, merchant, executors of 0
3690603 1923225 1923225 defendant Hert Thomas husbandman 593454 593454 Hert, Thomas, of Tavystok, husbandman 0
3704236 1927622 1927622 defendant Gardyner John yeoman 593454 593454 Gardyner, John, of Tavystok, yeoman 4
3706483 1928312 1928312 defendant Forster Ralph butcher 593454 593454 Forster, Ralph, of Tavystok, butcher 1
3706485 1928313 1928313 defendant Peke John butcher 593454 593454 Peke, John, of Tavystok, butcher 0
3715897 1931257 1931257 defendant Alyn Robert dyer 593454 593454 Alyn, Robert, of Tavystok, dyer 0
3715898 1931257 1931257 defendant Cole Walter butcher 593454 593454 Cole, Walter, of Tavystok, butcher 1
3715899 1931257 1931257 defendant Combe Edward dyer 593454 593454 Combe, Edward, of Tavystok, dyer 2
3723527 1933629 1933629 defendant Croppe Thomas fletcher 593454 593454 Croppe, Thomas, of Tavystok, fletcher 0
3723941 1933767 1933767 defendant Cole Walter butcher 593454 593454 Cole, Walter, of Tavystok, butcher 0
3738065 1938122 1938122 defendant Palmer Stephen carpenter 593454 593454 Palmer, Stephen, of Tavystok, carpenter 0
3739784 1938656 1938656 defendant Cole Walter butcher 593454 593454 Cole, Walter, of Tavystok, butcher 0
3740555 1938903 1938903 defendant Langedon alias Collander John laborer 593454 593454 Langedon alias Collander, John, of Tavystok, laborer 5
3740556 1938903 1938903 defendant Peyre John   593454 593454 Peyre, John, of Tavystok, groom 6
3740557 1938903 1938903 defendant Conyger William   593454 593454 Conyger, William, of Tavystok, groom 7
3744781 1940268 1940268 defendant Waren Richard tucker 593454 593454 Waren, Richard, of Tavystok, tucker 0
3747413 1941104 1941104 defendant Fitz John esq 593454 593454 Fitz, John, of Tavystok, esq 0
3752243 1942624 1942624 plaintiff Predyaux Richard   593454 593454 Predyaux, Richard, of Tavystok 0
3759699 1945024 1945024 defendant Ludgarde Robert husbandman 593454 593454 Ludgarde, Robert, of Tavystok, husbandman 0
3761165 1945495 1945495 defendant Conybeer William husbandman 593454 593454 Conybeer, William, of Tavystok, husbandman 0
3761188 1945503 1945503 defendant Fitz John esq 593454 593454 Fitz, John, of Tavystok, esq 0
3786683 1953629 1953629 plaintiff Predyaux Richard   593454 593454 Predyaux, Richard, of Tavystok 0
3815473 1962754 1962754 defendant Fitz John esq 593454 593454 Fitz, John, of Tavystok, esq 0
3815829 1962857 1962857 defendant Frankelyn John butcher 593454 593454 Frankelyn, John, of Tavystok, butcher 1
3819975 1964127 1964127 defendant Crope Thomas fletcher 593454 593454 Crope, Thomas, of Tavystok, fletcher 0
3820153 1964180 1964180 defendant Whytfeld John barber 593454 593454 Whytfeld, John, of Tavystok, barber 0
3822910 1965071 1965071 defendant Fitz John esq 593454 593454 Fitz, John, of Tavystok, esq 0
3829363 1967072 1967072 defendant Walsshe Nicholas tinner 593454 593454 Walsshe, Nicholas, of Tavystok, tinner 0
3840452 1970576 1970576 plaintiff Amadas William, senior   593454 593454 Amadas, William, senior, of Tavystok 0
3840453 1970576 1970576 defendant Foster John cordwainer 593454 593454 Foster, John, of Tavystok, cordwainer 0
4520835 2206859 2206859 defendant Cullyng Robert   593454 593454 Cullyng, Robert, of Tavystok, abbot 0
4549297 2215721 2215721 defendant Mason Walter   593454 593454 Mason, Walter, of Tavystok 1
4549298 2215721 2215721 defendant Grygge Philip   593454 593454 Grygge, Philip, of Tavystok 2
4549301 2215722 2215722 defendant Mason Walter   593454 593454 Mason, Walter, of Tavystok 1
4549302 2215722 2215722 defendant Grygge Philip   593454 593454 Grygge, Philip, of Tavystok 2
4787429 2292139 2292139 defendant Virgo John merchant 593454 593454 Virgo, John, of Tavystok, merchant 0
4798083 2295588 2295588 defendant Virgo John husbandman 593454 593454 Virgo, John, of Tavystok, husbandman 0
4855876 2313212 2313212 plaintiff Babell John   593454 593454 Babell, John, of Tavystok 0
4855877 2313212 2313212 defendant Lyer William husbandman 593454 593454 Lyer, William, of Tavystok, husbandman 0
4870342 2317700 2317700 defendant Babell John smith 593454 593454 Babell, John, of Tavystok, smith 0
4871357 2318010 2318010 defendant Bradle John dyer 593454 593454 Bradle, John, of Tavystok, dyer 0
4902107 2327268 2327268 defendant Bocher John chaplain 593454 593454 Bocher, John, of Tavystok, chaplain 0
4923312 2333717 2333717 plaintiff Mason John merchant 593454 593454 Mason, John, of Tavystok, merchant 0
4923748 2333870 2333870 plaintiff Mochell Pastus (legal representative) 593454 593454 Mochell, Pastus, of Tavystok, executrix of 0
4948623 2341550 2341550 plaintiff Mason John   593454 593454 Mason, John, of Tavystok 0
4952447 2342690 2342690 defendant Julkyn John gent 593454 593454 Julkyn, John, of Tavystok, gent 0
4957361 2344165 2344165 defendant Brise Richard husbandman 593454 593454 Brise, Richard, of Tavystok, husbandman 0
4964253 2346216 2346216 defendant Mason John mercer 593454 593454 Mason, John, of Tavystok, mercer 0
4964303 2346235 2346235 defendant Julkyn John gent 593454 593454 Julkyn, John, of Tavystok, gent 0
4969779 2347907 2347907 defendant Warder Walter yeoman 593454 593454 Warder, Walter, of Tavystok, yeoman 1
4969780 2347907 2347907 defendant Kyngeston William husbandman 593454 593454 Kyngeston, William, of Tavystok, husbandman 2
4969781 2347907 2347907 defendant Lanneskerforde John, senior husbandman 593454 593454 Lanneskerforde, John, senior, of Tavystok, husbandman 3
4975903 2349755 2349755 defendant Cadelegh John mercer 593454 593454 Cadelegh, John, of Tavystok, mercer 1
4975906 2349755 2349755 defendant Herston Thomas mercer 593454 593454 Herston, Thomas, of Tavystok, mercer 4
4981998 2351533 2351533 defendant Chamberlayn John yeoman 593454 593454 Chamberlayn, John, of Tavystok, yeoman 0
4986445 2352874 2352874 defendant Masfeld William weaver 593454 593454 Masfeld, William, of Tavystok, weaver 0
4986446 2352874 2352874 defendant Bocher John chaplain 593454 593454 Bocher, John, of Tavystok, chaplain 1
4986447 2352874 2352874 defendant Bater Richard fuller 593454 593454 Bater, Richard, of Tavystok, fuller 2
4991451 2354328 2354328 defendant Whityng William husbandman 593454 593454 Whityng, William, of Tavystok, husbandman 0
5016046 2361576 2361576 defendant Chamberleyn John   593454 593454 Chamberleyn, John, of Tavystok, bailiff 4
5027628 2364957 2364957 defendant Julkyn John merchant 593454 593454 Julkyn, John, of Tavystok, merchant 0
5048601 2371223 2371223 defendant Julkyn John gent 593454 593454 Julkyn, John, of Tavystok, gent 0
5057406 2373784 2373784 defendant Fitz John gent 593454 593454 Fitz, John, of Tavystok, gent 0
5060465 2374708 2374708 defendant Bodyer John yeoman 593454 593454 Bodyer, John, of Tavystok, yeoman 0
5066202 2376417 2376417 defendant Cadle John husbandman 593454 593454 Cadle, John, of Tavystok, husbandman 0
5071840 2378072 2378072 defendant Brune John, senior husbandman 593454 593454 Brune, John, senior, of Tavystok, husbandman 0
5071841 2378072 2378072 defendant Assheford William chapman 593454 593454 Assheford, William, of Tavystok, chapman 1
5080579 2380680 2380680 defendant Fitz John gent 593454 593454 Fitz, John, of Tavystok, gent 0
5084115 2381753 2381753 plaintiff Fresshpond William merchant 593454 593454 Fresshpond, William, of Tavystok, merchant 0
5105904 2388168 2388168 defendant Drake Thomas yeoman 593454 593454 Drake, Thomas, of Tavystok, yeoman 1
5105905 2388168 2388168 defendant Hill Richard yeoman 593454 593454 Hill, Richard, of Tavystok, yeoman 2
5114289 2390574 2390574 plaintiff Lucas Amise   593454 593454 Lucas, Amise, of Tavystok, widow of Lucas, William 0
5115111 2390840 2390840 defendant Frespound William merchant 593454 593454 Frespound, William, of Tavystok, merchant 0
5129911 2395237 2395237 defendant Onger John yeoman 593454 593454 Onger, John, of Tavystok, yeoman 0
5155504 2402769 2402769 defendant Frespond William merchant 593454 593454 Frespond, William, of Tavystok, merchant 0
5155507 2402770 2402770 defendant Frespond William merchant 593454 593454 Frespond, William, of Tavystok, merchant 0
5165300 2405596 2405596 defendant Helyar William plumber 593454 593454 Helyar, William, of Tavystok, plumber 0
5172112 2407562 2407562 defendant Frespond William merchant 593454 593454 Frespond, William, of Tavystok, merchant 0
5203597 2416805 2416805 defendant Freyspond William merchant 593454 593454 Freyspond, William, of Tavystok, merchant 2
5235842 2426064 2426064 plaintiff Drake John mercer 593454 593454 Drake, John, of Tavystok, mercer 0
5253322 2431141 2431141 defendant Maynard Walter   593454 593454 Maynard, Walter, of Tavystok, franklin 0
5253326 2431142 2431142 defendant Maynard Walter   593454 593454 Maynard, Walter, of Tavystok, franklin 0
5261442 2433689 2433689 defendant Knyght John yeoman 593454 593454 Knyght, John, of Tavystok, yeoman 0
5261443 2433689 2433689 defendant Berdyn Thomas yeoman 593454 593454 Berdyn, Thomas, of Tavystok, yeoman 1
5285884 2440888 2440888 defendant Fitz John gent 593454 593454 Fitz, John, of Tavystok, gent 1
5302158 2445602 2445602 defendant Swetyng John merchant 593454 593454 Swetyng, John, of Tavystok, merchant 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);