names

182 rows where place_id = 586259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588293 1863992 1863992 defendant Kymer John merchant 586259 586259 Kymer, John, of Pole, merchant 0
3594482 1865903 1865903 plaintiff Kymer John   586259 586259 Kymer, John, of Pole 0
3614281 1872130 1872130 defendant Kymer John gent 586259 586259 Kymer, John, of Pole, gent 3
3635869 1906017 1906017 defendant Bussher Thomas husbandman 586259 586259 Bussher, Thomas, of Pole, husbandman 2
3638643 1906902 1906902 defendant Croke John merchant 586259 586259 Croke, John, of Pole, merchant 0
3651970 1910962 1910962 defendant Townesend Henry   586259 586259 Townesend, Henry, of Pole, fish driver 0
3675808 1918467 1918467 defendant Thomlynson John yeoman 586259 586259 Thomlynson, John, of Pole, yeoman 0
3679978 1919802 1919802 defendant Forde William, junior husbandman 586259 586259 Forde, William, junior, of Pole, husbandman 1
3738503 1938249 1938249 defendant Elys John merchant 586259 586259 Elys, John, of Pole, merchant 0
3752073 1942571 1942571 defendant Swetenaham Robert yeoman 586259 586259 Swetenaham, Robert, of Pole, yeoman 0
3758715 1944720 1944720 defendant Chylde William husbandman 586259 586259 Chylde, William, of Pole, husbandman 1
3763047 1946074 1946074 defendant Pope Oliver husbandman 586259 586259 Pope, Oliver, of Pole, husbandman 0
3763048 1946074 1946074 defendant Gryllys Thomas husbandman 586259 586259 Gryllys, Thomas, of Pole, husbandman 1
3772321 1949029 1949029 defendant Benett Thomas mariner 586259 586259 Benett, Thomas, of Pole, mariner 3
3772322 1949029 1949029 defendant Ball William fisher 586259 586259 Ball, William, of Pole, fisher 4
3772323 1949029 1949029 defendant Ball John, junior fisher 586259 586259 Ball, John, junior, of Pole, fisher 5
3790947 1955002 1955002 plaintiff Stokker John   586259 586259 Stokker, John, of Pole 1
3793456 1955819 1955819 defendant Wakham Robert yeoman 586259 586259 Wakham, Robert, of Pole, yeoman 0
3830559 1967434 1967434 plaintiff Ford John, senior husbandman 586259 586259 Ford, John, senior, of Pole, husbandman 0
3866782 1979127 1979127 plaintiff Rede Morgan   586259 586259 Rede, Morgan, of Pole 0
3866954 1979186 1979186 defendant Corser alias ap Mathewe Richard shoemaker 586259 586259 Corser alias ap Mathewe, Richard, of Pole, shoemaker 0
3867667 1979421 1979421 defendant Baldewyn Henry husbandman 586259 586259 Baldewyn, Henry, of Pole, husbandman 2
3867668 1979421 1979421 defendant Sparowe Richard husbandman 586259 586259 Sparowe, Richard, of Pole, husbandman 3
3867669 1979421 1979421 defendant Rastell John clerk 586259 586259 Rastell, John, of Pole, clerk 4
3880328 1983676 1983676 plaintiff Phelyppes Richard esq 586259 586259 Phelyppes, Richard, of Pole, esq 0
3880789 1983841 1983841 defendant Rastall John clerk 586259 586259 Rastall, John, of Pole, clerk 0
3881600 1984108 1984108 defendant Rastall John clerk 586259 586259 Rastall, John, of Pole, clerk 0
3883830 1984859 1984859 plaintiff Whyte Thomas merchant 586259 586259 Whyte, Thomas, of Pole, merchant 0
3888438 1986396 1986396 plaintiff Ellys John merchant 586259 586259 Ellys, John, of Pole, merchant 0
3892296 1987674 1987674 defendant Wattys Alexander mercer 586259 586259 Wattys, Alexander, of Pole, mercer 1
3892298 1987675 1987675 plaintiff Mesurer James merchant 586259 586259 Mesurer, James, of Pole, merchant 0
3897376 1989339 1989339 defendant Ellys John merchant 586259 586259 Ellys, John, of Pole, merchant 0
3897380 1989340 1989340 defendant Elys John merchant 586259 586259 Elys, John, of Pole, merchant 0
3908402 1993106 1993106 defendant Rastell John clerk 586259 586259 Rastell, John, of Pole, clerk 0
3927889 1999666 1999666 defendant ap Mor Robert yeoman 586259 586259 ap Mor, Robert, of Pole, yeoman 1
3934385 2001793 2001793 defendant Perne John husbandman 586259 586259 Perne, John, of Pole, husbandman 1
3935268 2002106 2002106 defendant Mene or Mone Walter yeoman 586259 586259 Mene or Mone, Walter, of Pole, yeoman 0
3963806 2011943 2011943 defendant Malard Richard butcher 586259 586259 Malard, Richard, of Pole, butcher 0
3968862 2013737 2013737 defendant Hancocke Thomas merchant 586259 586259 Hancocke, Thomas, of Pole, merchant 1
3981940 2018303 2018303 plaintiff Rolson John   586259 586259 Rolson, John, of Pole 0
3989656 2021046 2021046 defendant Wolrydge Thomas   586259 586259 Wolrydge, Thomas, of Pole 0
3989657 2021046 2021046 defendant Wolrydge Henry   586259 586259 Wolrydge, Henry, of Pole 1
3989658 2021046 2021046 defendant Wolrydge John   586259 586259 Wolrydge, John, of Pole 2
4061777 2046612 2046612 defendant ap Howell Griffin butcher 586259 586259 ap Howell, Griffin, of Pole, butcher 1
4061778 2046612 2046612 defendant Morris William tiler 586259 586259 Morris, William, of Pole, tiler 2
4395659 2163135 2163135 defendant Jones Richard (legal representative) 586259 586259 Jones, Richard, of Pole, husbandman, executors of 0
4443187 2182829 2182829 defendant Vaghan Gervase   586259 586259 Vaghan, Gervase, of Pole 1
4443188 2182829 2182829 defendant Yonge Thomas   586259 586259 Yonge, Thomas, of Pole 2
4502514 2201370 2201370 defendant Can--- John   586259 586259 Can---, John, of Pole 1
4529905 2209642 2209642 defendant Canewey Thomas   586259 586259 Canewey, Thomas, of Pole 0
4543907 2213997 2213997 defendant Whyght William   586259 586259 Whyght, William, of Pole 0
4553043 2216893 2216893 defendant Fyrs John   586259 586259 Fyrs, John, of Pole 0
4565431 2220757 2220757 defendant Andru Robert   586259 586259 Andru, Robert, of Pole 0
4565436 2220758 2220758 defendant Paye Henry   586259 586259 Paye, Henry, of Pole 1
4595893 2229971 2229971 defendant Hay Robert   586259 586259 Hay, Robert, of Pole 0
4614211 2235457 2235457 plaintiff Draper Eyne_   586259 586259 Draper, Eyne_, of Pole 0
4619885 2237198 2237198 defendant Moulham William   586259 586259 Moulham, William, of Pole 1
4620800 2237488 2237488 defendant Glover John   586259 586259 Glover, John, of Pole 0
4688223 2261885 2261885 defendant Power William   586259 586259 Power, William, of Pole, franklin 0
4736434 2276528 2276528 defendant Power William husbandman 586259 586259 Power, William, of Pole, husbandman 0
4779399 2289540 2289540 defendant Cole John   586259 586259 Cole, John, of Pole, franklin 0
4788979 2292607 2292607 plaintiff Leche Thomas   586259 586259 (Leche, Thomas, of Pole 1
4873889 2318774 2318774 defendant Pyke John butcher 586259 586259 Pyke, John, of Pole, butcher 1
4873896 2318775 2318775 defendant Sage Thomas butcher 586259 586259 Sage, Thomas, of Pole, butcher 2
4880806 2320903 2320903 defendant Rede Robert dyer 586259 586259 Rede, Robert, of Pole, dyer 0
4890179 2323698 2323698 defendant Sore John husbandman 586259 586259 Sore, John, of Pole, husbandman 1
4901986 2327223 2327223 defendant Chate John fisher 586259 586259 Chate, John, of Pole, fisher 0
4901996 2327227 2327227 defendant Houchyns Robert chapman 586259 586259 Houchyns, Robert, of Pole, chapman 2
4907352 2328862 2328862 defendant Man John shipman 586259 586259 Man, John, of Pole, shipman 0
4948670 2341567 2341567 defendant Raweson John laborer 586259 586259 Raweson, John, of Pole, laborer 2
4950639 2342164 2342164 defendant Man John mariner 586259 586259 Man, John, of Pole, mariner 2
4950670 2342173 2342173 defendant Mower John mariner 586259 586259 Mower, John, of Pole, mariner 1
4950671 2342173 2342173 defendant Skynner John (legal representative) 586259 586259 Skynner, John, of Pole, merchant, executors of 2
4950672 2342173 2342173 defendant White William mercer 586259 586259 (White, William, of Pole, mercer 3
4950676 2342174 2342174 defendant Webbe Thomas mariner 586259 586259 Webbe, Thomas, of Pole, mariner 1
4951618 2342462 2342462 defendant Warner William (legal representative) 586259 586259 Warner, William, of Pole, executors of 0
4953486 2343010 2343010 defendant Bocher Thomas butcher 586259 586259 Bocher, Thomas, of Pole, butcher 3
4955541 2343617 2343617 defendant Webbe John merchant 586259 586259 Webbe, John, of Pole, merchant 3
4955547 2343618 2343618 defendant Webbe Thomas merchant 586259 586259 Webbe, Thomas, of Pole, merchant 3
4966817 2346998 2346998 defendant Person John mariner 586259 586259 Person, John, of Pole, mariner 3
4978080 2350408 2350408 defendant Moulham Isabel widow 586259 586259 Moulham, Isabel, of Pole, widow 1
4978081 2350408 2350408 defendant Briton William laborer 586259 586259 Briton, William, of Pole, laborer 2
4978082 2350408 2350408 defendant Taillour William tailor 586259 586259 Taillour, William, of Pole, tailor 3
5008415 2359352 2359352 plaintiff Symon John   586259 586259 Symon, John, of Pole 0
5030094 2365674 2365674 defendant Webbe Thomas mariner 586259 586259 Webbe, Thomas, of Pole, mariner 0
5034976 2367088 2367088 plaintiff Symon John   586259 586259 Symon, John, of Pole 0
5035211 2367162 2367162 defendant Bole Thomas mariner 586259 586259 Bole, Thomas, of Pole, mariner 2
5067997 2376929 2376929 defendant Webbe Joan widow 586259 586259 Webbe, Joan, of Pole, widow 1
5067998 2376929 2376929 defendant Man John (legal representative) 586259 586259 Man, John, of Pole, mariner, executrix of 2
5067999 2376929 2376929 defendant Man Alice widow 586259 586259 Man, Alice, of Pole, widow 3
5091962 2384027 2384027 defendant Bromley Thomas chapman 586259 586259 Bromley, Thomas, of Pole, chapman 1
5095867 2385218 2385218 plaintiff Spadard John   586259 586259 Spadard, John, of Pole 0
5095868 2385218 2385218 defendant Smedmore John, senior gent 586259 586259 Smedmore, John, senior, of Pole, gent 0
5095869 2385218 2385218 defendant Smedmore John, junior mariner 586259 586259 Smedmore, John, junior, of Pole, mariner 1
5095870 2385218 2385218 defendant Lepeman John mariner 586259 586259 Lepeman, John, of Pole, mariner 2
5109289 2389143 2389143 plaintiff Fyndhave or Fyndhane Nicholas butcher 586259 586259 Fyndhave or Fyndhane, Nicholas, of Pole, butcher 0
5112392 2390010 2390010 defendant Lambart Robert merchant 586259 586259 Lambart, Robert, of Pole, merchant 0
5112605 2390071 2390071 plaintiff Ivye Roger esq 586259 586259 Ivye, Roger, of Pole, esq 0
5112606 2390071 2390071 defendant Smedmore John gent 586259 586259 Smedmore, John, of Pole, gent 0
5116887 2391366 2391366 defendant Coton Richard merchant 586259 586259 Coton, Richard, of Pole, merchant 1

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