names

100 rows where place_id = 607450

✎ 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
3669311 1916340 1916340 defendant Dyke John mercer 607450 607450 Dyke, John, of Stoke juxta Clare, mercer 0
3672507 1917403 1917403 defendant Argent Robert saddler 607450 607450 Argent, Robert, of Stoke juxta Clare, saddler 1
3672508 1917403 1917403 defendant Awger John smith 607450 607450 Awger, John, of Stoke juxta Clare, smith 2
3673086 1917589 1917589 defendant Turnour Hugh husbandman 607450 607450 Turnour, Hugh, of Stoke juxta Clare, husbandman 0
3677573 1919026 1919026 defendant Alby alias Brewster Thomas, senior husbandman 607450 607450 Alby alias Brewster, Thomas, senior, of Stoke juxta Clare, husbandman 1
3686403 1921900 1921900 defendant Fokys John husbandman 607450 607450 Fokys, John, of Stoke juxta Clare, husbandman 2
3698567 1925770 1925770 defendant Mylle John smith 607450 607450 Mylle, John, of Stoke juxta Clare, smith 1
3707709 1928706 1928706 defendant White John yeoman 607450 607450 White, John, of Stoke juxta Clare, yeoman 1
3744518 1940187 1940187 defendant Norfolke Hugh husbandman 607450 607450 Norfolke, Hugh, of Stoke juxta Clare, husbandman 0
3744519 1940187 1940187 defendant Browster Thomas husbandman 607450 607450 Browster, Thomas, of Stoke juxta Clare, husbandman 1
3747000 1940981 1940981 defendant Coote Robert tailor 607450 607450 Coote, Robert, of Stoke juxta Clare, tailor 0
3757260 1944253 1944253 defendant Lovell William yeoman 607450 607450 (Lovell, William, of Stoke juxta Clare, yeoman 1
3760519 1945294 1945294 defendant Merellys Roger miller 607450 607450 Merellys, Roger, of Stoke juxta Clare, miller 0
3767761 1947554 1947554 defendant Alby alias Brewster Thomas husbandman 607450 607450 Alby alias Brewster, Thomas, of Stoke juxta Clare, husbandman 1
3773152 1949310 1949310 defendant Radclyff Charles yeoman 607450 607450 Radclyff, Charles, of Stoke juxta Clare, yeoman 0
3774860 1949866 1949866 plaintiff Barker John, senior yeoman 607450 607450 Barker, John, senior, of Stoke juxta Clare, yeoman 0
3774861 1949866 1949866 defendant Norffolke Hugh   607450 607450 Norffolke, Hugh, of Stoke juxta Clare, tallow chandler 0
3776327 1950343 1950343 defendant Norffolk Hugh husbandman 607450 607450 Norffolk, Hugh, of Stoke juxta Clare, husbandman 0
3776328 1950343 1950343 defendant Wylkynson John husbandman 607450 607450 Wylkynson, John, of Stoke juxta Clare, husbandman 1
3778591 1951016 1951016 defendant Merellys Roger miller 607450 607450 Merellys, Roger, of Stoke juxta Clare, miller 0
3788716 1954274 1954274 defendant Brygge Thomas butcher 607450 607450 Brygge, Thomas, of Stoke juxta Clare, butcher 2
3795631 1956517 1956517 defendant Lovell William yeoman 607450 607450 Lovell, William, of Stoke juxta Clare, yeoman 0
3806851 1960049 1960049 defendant Carleton John carpenter 607450 607450 Carleton, John, of Stoke juxta Clare, carpenter 1
3809059 1960717 1960717 plaintiff Barker John, senior yeoman 607450 607450 Barker, John, senior, of Stoke juxta Clare, yeoman 0
3809060 1960717 1960717 defendant Alby alias Browster Thomas husbandman 607450 607450 Alby alias Browster, Thomas, of Stoke juxta Clare, husbandman 0
3809061 1960718 1960718 plaintiff Barker John, senior yeoman 607450 607450 Barker, John, senior, of Stoke juxta Clare, yeoman 0
3809062 1960718 1960718 defendant Alby alias Browster Thomas husbandman 607450 607450 Alby alias Browster, Thomas, of Stoke juxta Clare, husbandman 0
3812871 1961922 1961922 defendant Cote Robert tailor 607450 607450 Cote, Robert, of Stoke juxta Clare, tailor 0
3814122 1962320 1962320 defendant Argent George shoemaker 607450 607450 Argent, George, of Stoke juxta Clare, shoemaker 2
3840927 1970729 1970729 defendant Sampson Nicholas yeoman 607450 607450 Sampson, Nicholas, of Stoke juxta Clare, yeoman 0
3855074 1975216 1975216 defendant Brewster Thomas husbandman 607450 607450 Brewster, Thomas, of Stoke juxta Clare, husbandman 1
3857815 1976083 1976083 defendant Carleton John carpenter 607450 607450 Carleton, John, of Stoke juxta Clare, carpenter 0
3860427 1976981 1976981 defendant Alby Thomas, junior husbandman 607450 607450 Alby, Thomas, junior, of Stoke juxta Clare, husbandman 0
3866727 1979106 1979106 defendant Carleton John carpenter 607450 607450 Carleton, John, of Stoke juxta Clare, carpenter 0
3869538 1980054 1980054 defendant Ayley John smith 607450 607450 Ayley, John, of Stoke juxta Clare, smith 3
3870052 1980225 1980225 defendant Westby Thomas clerk 607450 607450 Westby, Thomas, of Stoke juxta Clare, clerk 0
3870055 1980226 1980226 defendant Westby Thomas clerk 607450 607450 Westby, Thomas, of Stoke juxta Clare, clerk 0
3872802 1981115 1981115 defendant Bultell John husbandman 607450 607450 Bultell, John, of Stoke juxta Clare, husbandman 1
3872803 1981115 1981115 defendant Dode Richard innkeeper 607450 607450 Dode, Richard, of Stoke juxta Clare, innkeeper 2
3872804 1981115 1981115 defendant Fuller John yeoman 607450 607450 Fuller, John, of Stoke juxta Clare, yeoman 3
3872805 1981115 1981115 defendant Reder Thomas husbandman 607450 607450 Reder, Thomas, of Stoke juxta Clare, husbandman 4
3881985 1984234 1984234 defendant Brewster Thomas laborer 607450 607450 Brewster, Thomas, of Stoke juxta Clare, laborer 1
3889954 1986877 1986877 defendant Case William tailor 607450 607450 Case, William, of Stoke juxta Clare, tailor 0
3889958 1986878 1986878 defendant Case William tailor 607450 607450 Case, William, of Stoke juxta Clare, tailor 0
3893474 1988044 1988044 defendant Marteyn John carpenter 607450 607450 Marteyn, John, of Stoke juxta Clare, carpenter 0
3906745 1992549 1992549 defendant Alby John laborer 607450 607450 Alby, John, of Stoke juxta Clare, laborer 3
3907462 1992789 1992789 defendant Whythed Thomas clerk 607450 607450 Whythed, Thomas, of Stoke juxta Clare, clerk 1
3913975 1995019 1995019 defendant Rose Henry laborer 607450 607450 Rose, Henry, of Stoke juxta Clare, laborer 5
3948080 2006395 2006395 defendant Bredge John (legal representative) 607450 607450 Bredge, John, of Stoke juxta Clare, yeoman, executors of 0
3948081 2006395 2006395 defendant Kynge Richard yeoman 607450 607450 (Kynge, Richard, of Stoke juxta Clare, yeoman 1
3948083 2006396 2006396 defendant Bridge John (legal representative) 607450 607450 Bridge, John, of Stoke juxta Clare, yeoman, executors of 0
3948084 2006396 2006396 defendant Kynge Richard yeoman 607450 607450 (Kynge, Richard, of Stoke juxta Clare, yeoman 1
3962150 2011343 2011343 defendant Barrell Richard laborer 607450 607450 Barrell, Richard, of Stoke juxta Clare, laborer 2
4073684 2050879 2050879 defendant Fytche Richard yeoman 607450 607450 Fytche, Richard, of Stoke juxta Clare, yeoman 0
4179136 2088176 2088176 defendant Danyell John gent 607450 607450 Danyell, John, of Stoke juxta Clare, gent 0
4220294 2102604 2102604 defendant Dike John yeoman 607450 607450 Dike, John, of Stoke juxta Clare, yeoman 0
4229219 2105703 2105703 defendant Dyke John yeoman 607450 607450 Dyke, John, of Stoke juxta Clare, yeoman 0
4238587 2109110 2109110 defendant Deeke John yeoman 607450 607450 Deeke, John, of Stoke juxta Clare, yeoman 0
4264054 2117631 2117631 defendant Dyke John yeoman 607450 607450 Dyke, John, of Stoke juxta Clare, yeoman 0
4276447 2121705 2121705 defendant Turnor Robert gent 607450 607450 Turnor, Robert, of Stoke juxta Clare, gent 0
4280045 2122930 2122930 defendant Parker Thomas yeoman 607450 607450 Parker, Thomas, of Stoke juxta Clare, or of Glensforde, yeoman 0
4291268 2126947 2126947 defendant Porter Thomas (legal representative) 607450 607450 Porter, Thomas, of Stoke juxta Clare, yeoman, executor of 0
4294954 2128281 2128281 defendant Deke John yeoman 607450 607450 Deke, John, of Stoke juxta Clare, yeoman 0
4301176 2130529 2130529 defendant Turnor Ralph gent 607450 607450 Turnor, Ralph, of Stoke juxta Clare, gent 1
4302817 2131105 2131105 defendant Argent Richard husbandman 607450 607450 Argent, Richard, of Stoke juxta Clare, husbandman 1
4307872 2132893 2132893 defendant Bridge Reginald yeoman 607450 607450 Bridge, Reginald, of Stoke juxta Clare, yeoman 2
4351595 2147797 2147797 defendant Parbye Thomas (legal representative) 607450 607450 Parbye, Thomas, of Stoke juxta Clare, husbandman, executors of 0
4391090 2161640 2161640 defendant Newman Robert husbandman 607450 607450 Newman Robert, of Stoke juxta Clare, husbandman 0
4658139 2248423 2248423 defendant Robat John husbandman 607450 607450 Robat, John, of Stoke juxta Clare, husbandman 0
4784250 2291072 2291072 defendant Perbron Henry clerk 607450 607450 Perbron, Henry, of Stoke juxta Clare, clerk 0
4856292 2313340 2313340 defendant Martyn John husbandman 607450 607450 Martyn, John, of Stoke juxta Clare, husbandman 0
4857515 2313738 2313738 defendant Mannok Thomas ploughman 607450 607450 Mannok, Thomas, of Stoke juxta Clare, ploughman 0
4859454 2314333 2314333 defendant Fox John weaver 607450 607450 Fox, John, of Stoke juxta Clare, weaver 0
4859455 2314333 2314333 defendant Wheler Thomas yeoman 607450 607450 Wheler, Thomas, of Stoke juxta Clare, yeoman 1
4876351 2319564 2319564 defendant Assheby Robert husbandman 607450 607450 Assheby, Robert, of Stoke juxta Clare, husbandman 0
4889560 2323529 2323529 defendant Bryde alias Bredon Thomas yeoman 607450 607450 (Bryde alias Bredon, Thomas, of Stoke juxta Clare, yeoman 1
4944864 2340382 2340382 defendant Gylles Nicholas clerk 607450 607450 Gylles, Nicholas, of Stoke juxta Clare, clerk 0
4944876 2340387 2340387 defendant Gylles Nicholas clerk 607450 607450 Gylles, Nicholas, of Stoke juxta Clare, clerk 0
5024173 2363983 2363983 defendant Lenne John husbandman 607450 607450 Lenne, John, of Stoke juxta Clare, husbandman 1
5024174 2363983 2363983 defendant Andrewe William husbandman 607450 607450 Andrewe, William, of Stoke juxta Clare, husbandman 2
5032011 2366236 2366236 defendant Smyth John clerk 607450 607450 Smyth, John, of Stoke juxta Clare, clerk 0
5089516 2383307 2383307 defendant Pert John laborer 607450 607450 Pert, John, of Stoke juxta Clare, laborer 0
5089517 2383307 2383307 defendant Bregges Thomas husbandman 607450 607450 Bregges, Thomas, of Stoke juxta Clare, husbandman 1
5094292 2384736 2384736 defendant Grymston John, senior yeoman 607450 607450 Grymston, John, senior, of Stoke juxta Clare, yeoman 0
5098211 2385906 2385906 defendant Pert John laborer 607450 607450 Pert, John, of Stoke juxta Clare, laborer 0
5098212 2385906 2385906 defendant Breggys Thomas husbandman 607450 607450 Breggys, Thomas, of Stoke juxta Clare, husbandman 1
5256285 2432088 2432088 defendant Cote John gent 607450 607450 Cote, John, of Stoke juxta Clare, gent 0
5267535 2435607 2435607 defendant Whyte Richard husbandman 607450 607450 Whyte, Richard, of Stoke juxta Clare, husbandman 2
5278081 2438680 2438680 defendant Neuton Robert gent 607450 607450 Neuton, Robert, of Stoke juxta Clare, gent 0
5278539 2438833 2438833 defendant Neuton Robert gent 607450 607450 Neuton, Robert, of Stoke juxta Clare, gent 0
5278541 2438834 2438834 defendant Neuton Robert gent 607450 607450 Neuton, Robert, of Stoke juxta Clare, gent 0
5331039 2454349 2454349 defendant Breuster John husbandman 607450 607450 Breuster, John, of Stoke juxta Clare, husbandman 0
5331040 2454349 2454349 defendant Boteler Thomas tailor 607450 607450 Boteler, Thomas, of Stoke juxta Clare, tailor 1
5331041 2454349 2454349 defendant Chapman John laborer 607450 607450 Chapman, John, of Stoke juxta Clare, laborer 2
5331042 2454349 2454349 defendant Herry John thatcher 607450 607450 Herry, John, of Stoke juxta Clare, thatcher 3
5494820 2503341 2503341 defendant Helvy or Helny William yeoman 607450 607450 Helvy or Helny, William, of Stoke juxta Clare, yeoman 0
5550837 2520276 2520276 plaintiff Claver or Claner Robert   607450 607450 Claver or Claner, Robert, of Stoke juxta Clare 0
5559004 2522589 2522589 defendant Aylye John smith 607450 607450 Aylye, John, of Stoke juxta Clare, smith 0
5596054 2533680 2533680 defendant Dyke Thomas, junior mercer 607450 607450 Dyke, Thomas, junior, of Stoke juxta Clare, mercer 0
5596141 2533709 2533709 defendant Ayley John smith 607450 607450 Ayley, John, of Stoke juxta Clare, smith 1

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