names

59 rows where place_id = 664352

✎ 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
3947883 2006324 2006324 defendant Garneys or Garveys Richard gent 664352 664352 Garneys or Garveys, Richard, of Mendlesham, or of Boyland Hall, gent 0
3972535 2014970 2014970 plaintiff Garneys or Garveys Richard gent 664352 664352 Garneys or Garveys, Richard, of Mendlesham, gent 0
4037714 2038140 2038140 defendant Aldows Thomas draper 664352 664352 Aldows, Thomas, of Mendlesham, draper 3
4066360 2048262 2048262 defendant Gunnelde Thomas shoemaker 664352 664352 Gunnelde, Thomas, of Mendlesham, shoemaker 0
4066361 2048262 2048262 defendant Gunnelde James tailor 664352 664352 Gunnelde, James, of Mendlesham, tailor 1
4066362 2048262 2048262 defendant Godderd Charles yeoman 664352 664352 Godderd, Charles, of Mendlesham, yeoman 2
4086985 2055637 2055637 defendant Whyting Thomas husbandman 664352 664352 Whyting, Thomas, of Mendlesham, husbandman 0
4121205 2067879 2067879 defendant Damont Thomas yeoman 664352 664352 Damont, Thomas, of Mendlesham, yeoman 1
4138210 2074034 2074034 defendant Cockerell Richard thatcher 664352 664352 Cockerell, Richard, of Mendlesham, thatcher 3
4148788 2077696 2077696 defendant Jower Robert turner 664352 664352 Jower, Robert, of Mendlesham, turner 2
4221028 2102850 2102850 defendant Blomefeild John yeoman 664352 664352 Blomefeild, John, of Mendlesham, yeoman 0
4232487 2106868 2106868 defendant Salmon Robert yeoman 664352 664352 Salmon, Robert, of Mendlesham, yeoman 3
4233812 2107351 2107351 defendant Seaman Thomas yeoman 664352 664352 Seaman, Thomas, of Mendlesham, yeoman 2
4274640 2121073 2121073 defendant Beale Jerome yeoman 664352 664352 Beale, Jerome, of Mendlesham, yeoman 0
4323712 2138344 2138344 defendant Blomefeild John yeoman 664352 664352 Blomefeild, John, of Mendlesham, yeoman 1
4325603 2138938 2138938 defendant Rigges Edward clerk 664352 664352 Rigges, Edward, of Mendlesham, clerk 0
4332563 2141179 2141179 defendant Blomfeld John, junior tanner 664352 664352 Blomfeld, John, junior, of Mendlesham, tanner 0
4338002 2143032 2143032 defendant Freman Edmund yeoman 664352 664352 Freman, Edmund, of Mendlesham, yeoman 0
4339570 2143608 2143608 defendant Morwell Thomas cooper 664352 664352 Morwell, Thomas, of Mendlesham, cooper 0
4343671 2145065 2145065 defendant Partriche George husbandman 664352 664352 Partriche, George, of Mendlesham, husbandman 3
4386124 2160042 2160042 defendant Denney Robert gent 664352 664352 Denney, Robert, of Mendlesham, gent 0
4386125 2160042 2160042 defendant Rysbye John husbandman 664352 664352 Rysbye, John, of Mendlesham, husbandman 1
4386126 2160042 2160042 defendant Garrard Robert yeoman 664352 664352 Garrard, Robert, of Mendlesham, yeoman 2
4394592 2162780 2162780 defendant Freman Edmund yeoman 664352 664352 Freman, Edmund, of Mendlesham, yeoman 0
4411632 2168487 2168487 defendant Stollerye Edward yeoman 664352 664352 Stollerye, Edward, of Mendlesham, or of Bodesdale, Suff, yeoman 0
4479438 2194225 2194225 plaintiff Hyrde Robert   664352 664352 Hyrde, Robert, of Mendlesham, vicar 0
4485130 2196054 2196054 plaintiff Provale John   664352 664352 Provale, John, of Mendlesham 0
4520569 2206784 2206784 defendant Laverok Giles   664352 664352 Laverok, Giles, of Mendlesham 0
4520578 2206785 2206785 defendant Laverok Giles   664352 664352 Laverok, Giles, of Mendlesham 2
4583599 2226292 2226292 defendant Breton John   664352 664352 Breton, John, of Mendlesham, brass worker 1
4596234 2230073 2230073 defendant Fraunsum Stephen   664352 664352 Fraunsum, Stephen, of Mendlesham, pedlar 1
4642689 2243978 2243978 defendant Ky Thomas   664352 664352 Ky, Thomas, of Mendlesham 1
4645230 2244675 2244675 defendant Godewon John   664352 664352 Godewon, John, of Mendlesham 6
4697195 2264603 2264603 defendant Cutte Thomas butcher 664352 664352 Cutte, Thomas, of Mendlesham, butcher 0
4742832 2278411 2278411 defendant Chapman John husbandman 664352 664352 Chapman, John, of Mendlesham, husbandman 2
4744576 2278936 2278936 defendant (not given) William vicar of Fuller 664352 664352 Fuller, William, of Mendlesham, parson & vicar of Earls Stonham 0
4759382 2283275 2283275 defendant Kye Thomas dyer 664352 664352 Kye, Thomas, of Mendlesham, dyer 1
4761440 2283921 2283921 defendant Lorde Robert husbandman 664352 664352 Lorde, Robert, of Mendlesham, husbandman 1
4915790 2331438 2331438 defendant Dunche Robert, junior yeoman 664352 664352 Dunche, Robert, junior, of Mendlesham, yeoman 0
5124166 2393527 2393527 defendant Dunkon Thomas stainer 664352 664352 Dunkon, Thomas, of Mendlesham, stainer 0
5124167 2393527 2393527 defendant Mannyng Robert yeoman 664352 664352 Mannyng, Robert, of Mendlesham, yeoman 1
5124168 2393527 2393527 defendant Pychere Edmund yeoman 664352 664352 Pychere, Edmund, of Mendlesham, yeoman 2
5140869 2398444 2398444 defendant Dunkoon Thomas husbandman 664352 664352 Dunkoon, Thomas, of Mendlesham, husbandman 0
5140870 2398444 2398444 defendant Bussh eoffrey husbandman 664352 664352 Bussh, eoffrey, of Mendlesham, husbandman 1
5162019 2404624 2404624 defendant Dunkoon Thomas husbandman 664352 664352 Dunkoon, Thomas, of Mendlesham, husbandman 0
5162020 2404624 2404624 defendant Bussh Geoffrey husbandman 664352 664352 Bussh, Geoffrey, of Mendlesham, husbandman 1
5176255 2408742 2408742 defendant Dunkoon Thomas husbandman 664352 664352 Dunkoon, Thomas, of Mendlesham, husbandman 0
5176256 2408742 2408742 defendant Bussh Geoffrey husbandman 664352 664352 Bussh, Geoffrey, of Mendlesham, husbandman 1
5178493 2409419 2409419 defendant Mannyng Robert husbandman 664352 664352 Mannyng, Robert, of Mendlesham, husbandman 2
5184037 2411064 2411064 defendant Dunkon Thomas yeoman 664352 664352 Dunkon, Thomas, of Mendlesham, yeoman 2
5198174 2415210 2415210 defendant Dunkoon Thomas husbandman 664352 664352 Dunkoon, Thomas, of Mendlesham, husbandman 0
5198175 2415210 2415210 defendant Bussh Geoffrey husbandman 664352 664352 Bussh, Geoffrey, of Mendlesham, husbandman 1
5201481 2416190 2416190 defendant Mannyng Robert husbandman 664352 664352 Mannyng, Robert, of Mendlesham, husbandman 2
5204110 2416954 2416954 defendant Dunkon Thomas yeoman 664352 664352 Dunkon, Thomas, of Mendlesham, yeoman 2
5210406 2418776 2418776 defendant Dunkoon Thomas husbandman 664352 664352 Dunkoon, Thomas, of Mendlesham, husbandman 0
5210407 2418776 2418776 defendant Busshe Geoffrey husbandman 664352 664352 Busshe, Geoffrey, of Mendlesham, husbandman 1
5249114 2429861 2429861 defendant Barker Thomas mercer 664352 664352 Barker, Thomas, of Mendlesham, mercer 0
5249115 2429861 2429861 defendant Goslyn John mercer 664352 664352 Goslyn, John, of Mendlesham, mercer 1
5331765 2454581 2454581 defendant Route Richard shoemaker 664352 664352 Route, Richard, of Mendlesham, shoemaker 4

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