names

59 rows where place_id = 621124

✎ 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
3739692 1938627 1938627 plaintiff Pope Henry gent 621124 621124 Pope, Henry, of Mildenhall, gent 0
3843213 1971410 1971410 defendant Larke Thomas yeoman 621124 621124 Larke, Thomas, of Mildenhall, yeoman 0
3843215 1971410 1971410 defendant Dale Ralph husbandman 621124 621124 Dale, Ralph, of Mildenhall, husbandman 2
3843216 1971410 1971410 defendant Gesen Thomas husbandman 621124 621124 Gesen, Thomas, of Mildenhall, husbandman 3
3849605 1973465 1973465 defendant Garrard John husbandman 621124 621124 Garrard, John, of Mildenhall, husbandman 3
3909936 1993629 1993629 defendant Fuller Robert, junior husbandman 621124 621124 Fuller, Robert, junior, of Mildenhall, husbandman 1
3919843 1996972 1996972 defendant Ebblewhite Robert tinker 621124 621124 Ebblewhite, Robert, of Mildenhall, tinker 0
3938559 2003238 2003238 defendant Sokerman Robert mercer 621124 621124 Sokerman, Robert, of Mildenhall, mercer 0
3966198 2012806 2012806 defendant Wallett Robert butcher 621124 621124 Wallett, Robert, of Mildenhall, butcher 0
3968566 2013641 2013641 defendant Costyn Robert   621124 621124 Costyn, Robert, of Mildenhall, lime burner 0
3969459 2013925 2013925 defendant Pope William gent 621124 621124 Pope, William, of Mildenhall, gent 0
3969460 2013925 2013925 defendant Wyng Thomas laborer 621124 621124 Wyng, Thomas, of Mildenhall, laborer 1
3969461 2013925 2013925 defendant Fyce William laborer 621124 621124 Fyce, William, of Mildenhall, laborer 2
3977489 2016698 2016698 defendant Sockerman or Soocker William yeoman 621124 621124 Sockerman or Soocker, William, of Mildenhall, yeoman 0
3993711 2022497 2022497 defendant Pope Henry gent 621124 621124 Pope, Henry, of Mildenhall, gent 0
4078075 2052461 2052461 defendant Marshall Clara widow 621124 621124 Marshall, Clara, of Mildenhall, widow 0
4078076 2052461 2052461 defendant Geson Anthony husbandman 621124 621124 Geson, Anthony, of Mildenhall, husbandman 1
4078077 2052462 2052462 plaintiff Suckerman Simon   621124 621124 Suckerman, Simon, of Mildenhall 0
4078078 2052462 2052462 defendant Brigge or Bugge William husbandman 621124 621124 Brigge or Bugge, William, of Mildenhall, husbandman 0
4078079 2052462 2052462 defendant Marshall John husbandman 621124 621124 Marshall, John, of Mildenhall, husbandman 1
4078801 2052713 2052713 defendant Bugge Robert yeoman 621124 621124 Bugge, Robert, of Mildenhall, yeoman 1
4089251 2056441 2056441 defendant Suckerman Simon yeoman 621124 621124 Suckerman, Simon, of Mildenhall, yeoman 0
4089252 2056441 2056441 defendant Braddicke Anthony laborer 621124 621124 Braddicke, Anthony, of Mildenhall, laborer 1
4111029 2064193 2064193 defendant Cole John   621124 621124 Cole, John, of Mildenhall, ploughwright 2
4124162 2068931 2068931 defendant Suckerman Simon, junior   621124 621124 Suckerman, Simon, junior, of Mildenhall, gent, hos son 1
4134289 2072590 2072590 defendant Grene Christopher innholder 621124 621124 Grene, Christopher, of Mildenhall, innholder 0
4138471 2074125 2074125 defendant Cootes Thomas yeoman 621124 621124 Cootes, Thomas, of Mildenhall, yeoman 0
4138516 2074141 2074141 defendant Coootes Thomas yeoman 621124 621124 Coootes, Thomas, of Mildenhall, yeoman 0
4152237 2078893 2078893 defendant Folk Martin husbandman 621124 621124 Folk, Martin, of Mildenhall, husbandman 0
4152238 2078893 2078893 defendant Eve John husbandman 621124 621124 Eve, John, of Mildenhall, husbandman 1
4158693 2081113 2081113 defendant Pechye John yeoman 621124 621124 Pechye, John, of Mildenhall, yeoman 0
4171380 2085454 2085454 defendant Man Thomas yeoman 621124 621124 (Man, Thomas, of Mildenhall, yeoman 1
4171381 2085454 2085454 defendant Tirrell Katherine spinster 621124 621124 Katherine Tirrell, of Mildenhall, spinster 2
4171382 2085454 2085454 defendant Tyrrell Mary spinster 621124 621124 Mary Tyrrell, of Mildenhall, spinster, executors of William Tyrrell, coadministrator with Thomas 3
4178860 2088083 2088083 defendant Pope William gent 621124 621124 Pope, William, of Mildenhall, gent 0
4199947 2095531 2095531 defendant Folkes Martin husbandman 621124 621124 Folkes, Martin, of Mildenhall, husbandman, Eve, John, of Mildenhall, husbandman 0
4227501 2105101 2105101 defendant Gathercolde George yeoman 621124 621124 Gathercolde, George, of Mildenhall, yeoman 0
4232163 2106751 2106751 defendant Place William yeoman 621124 621124 Place, William, of Mildenhall, yeoman 1
4236847 2108466 2108466 defendant Currey Robert yeoman 621124 621124 Currey, Robert, of Mildenhall, yeoman 0
4242846 2110599 2110599 defendant Grene Christopher yeoman 621124 621124 Grene, Christopher, of Mildenhall, yeoman 0
4251445 2113464 2113464 defendant Freston Robert husbandman 621124 621124 Freston, Robert, of Mildenhall, husbandman 0
4253198 2114065 2114065 defendant Clarke Robert yeoman 621124 621124 Clarke, Robert, of Mildenhall, yeoman 1
4255781 2114906 2114906 defendant Freston Robert husbandman 621124 621124 Freston, Robert, of Mildenhall, husbandman 0
4255782 2114906 2114906 defendant Reve John husbandman 621124 621124 Reve, John, of Mildenhall, husbandman 1
4272129 2120243 2120243 defendant Wright Edmund   621124 621124 Wright, Edmund, of Mildenhall butcher 1
4303775 2131448 2131448 defendant Grene Christopher yeoman 621124 621124 Grene, Christopher, of Mildenhall, yeoman 0
4316163 2135765 2135765 defendant Reve John husbandman 621124 621124 Reve, John, of Mildenhall, husbandman 0
4318660 2136635 2136635 defendant Gathercole George yeoman 621124 621124 Gathercole, George, of Mildenhall, yeoman 0
4332324 2141102 2141102 defendant Morley Ralph yeoman 621124 621124 Morley, Ralph, of Mildenhall, yeoman 2
4332325 2141102 2141102 defendant Catheroole Richard yeoman 621124 621124 Catheroole, Richard, of Mildenhall, yeoman 3
4336355 2142452 2142452 defendant Suckerman Simon gent 621124 621124 Suckerman, Simon, of Mildenhall, gent 0
4339841 2143707 2143707 defendant Evans Robert tanner 621124 621124 Evans, Robert, of Mildenhall, tanner 0
4353696 2148512 2148512 defendant Suckerman Simon gent 621124 621124 Suckerman, Simon, of Mildenhall, gent 0
4555461 2217643 2217643 defendant Lambhorne Guy   621124 621124 Lambhorne, Guy, of Mildenhall 3
4763008 2284416 2284416 plaintiff Gennot John   621124 621124 Gennot, John, of Mildenhall 0
4772553 2287385 2287385 defendant Abell Thomas   621124 621124 Abell, Thomas, of Mildenhall, holy water clerk 0
4824131 2303623 2303623 defendant Bryghtwold John, senior husbandman 621124 621124 Bryghtwold, John, senior, of Mildenhall, husbandman 0
5444333 2488211 2488211 defendant Kene Robert husbandman 621124 621124 Kene, Robert, of Mildenhall, husbandman 1
5558861 2522543 2522543 defendant Dobson Robert dyer 621124 621124 Dobson, Robert, of Mildenhall, dyer 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);