names

52 rows where place_id = 587458

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591469 1864956 1864956 defendant Baldrey William clothmaker 587458 587458 Baldrey, William, of Stowemarket, Suff, clothmaker 4
3620001 1873827 1873827 defendant Roysshbroke Walter dyer 587458 587458 Roysshbroke, Walter, of Stowemarket, Suff, dyer 0
3685469 1921607 1921607 defendant Rosser Robert clothmaker 587458 587458 Rosser, Robert, of Stowemarket, Suff, clothmaker 0
3742165 1939416 1939416 defendant Thorp John husbandman 587458 587458 Thorp, John, of Stowemarket, Suff, husbandman 0
3743161 1939723 1939723 defendant Glawmefeld Robert gent 587458 587458 Glawmefeld, Robert, of Stowemarket, Suff, gent 0
3810280 1961105 1961105 defendant Robyns John yeoman 587458 587458 Robyns, John, of Stowemarket, Suff, yeoman 0
3825102 1965720 1965720 defendant Kytson Robert clerk 587458 587458 Kytson, Robert, of Stowemarket, Suff, clerk 1
4082096 2053891 2053891 defendant Cixon or Dixon Thomas   587458 587458 Cixon or Dixon, Thomas, of Stowemarket, Suff, carpet weaver 0
4401813 2165204 2165204 defendant Cooke John clothier 587458 587458 Cooke, John, of Stowemarket, Suff, clothier 1
4691764 2262956 2262956 defendant Hotoft John gent 587458 587458 Hotoft, John, of Stowemarket, Suff, gent 3
4744901 2279024 2279024 defendant Dallyng Thomas chapman 587458 587458 Dallyng, Thomas, of StoweMarket, Suff, chapman 0
4751748 2281000 2281000 defendant Spycer John yeoman 587458 587458 Spycer, John, of Stowemarket, Suff, yeoman 0
4799571 2296047 2296047 defendant Ingham Thomas dyer 587458 587458 Ingham, Thomas, of Stowemarket, Suff, dyer 0
4844370 2309751 2309751 defendant Ade John draper 587458 587458 Ade, John, of Stowemarket, Suff, draper 0
4845731 2310177 2310177 defendant Ady John chapman 587458 587458 Ady, John, of Stowemarket, Suff, chapman 0
4861209 2314871 2314871 defendant Lanne or Laune William gent 587458 587458 Lanne or Laune, William, of Stowemarket, Suff, gent 1
4865798 2316272 2316272 defendant Kyng William merchant 587458 587458 Kyng, William, of Stowemarket, Suff, merchant 0
4865801 2316273 2316273 defendant Kyng William merchant 587458 587458 Kyng, William, of Stowemarket, Suff, merchant 0
4880215 2320725 2320725 defendant Thorp John gent 587458 587458 Thorp, John, of Stowemarket, Suff, gent 1
4880221 2320726 2320726 defendant Thorp John gent 587458 587458 Thorp, John, of Stowemarket, Suff, gent 1
4903324 2327649 2327649 defendant Ingham Thomas dyer 587458 587458 Ingham, Thomas, of Stowemarket, Suff, dyer 0
4903334 2327652 2327652 defendant Ingham Thomas dyer 587458 587458 Ingham, Thomas, of Stowemarket, Suff, dyer 0
4913571 2330741 2330741 defendant Mannyng William dyer 587458 587458 Mannyng, William, of Stowemarket, Suff, dyer 0
4945933 2340714 2340714 defendant Ballyng Thomas mercer 587458 587458 Ballyng, Thomas, of Stowemarket, Suff, mercer 0
4946574 2340924 2340924 defendant Taston Thomas dyer 587458 587458 Taston, Thomas, of Stowemarket, Suff, dyer 0
4950108 2342000 2342000 defendant Wodeward Thomas fuller 587458 587458 Wodeward, Thomas, of Stowemarket, Suff, fuller 0
4969059 2347710 2347710 defendant Asshe Thomas yeoman 587458 587458 Asshe, Thomas, of Stowemarket, Suff, yeoman 2
4969709 2347886 2347886 defendant Hawle Ivo spicer 587458 587458 Hawle, Ivo, of Stowemarket, Suff, spicer 1
5002735 2357710 2357710 defendant Wage John chapman 587458 587458 Wage, John, of Stowemarket, Suff, chapman 1
5010244 2359861 2359861 defendant Mannyng William yeoman 587458 587458 Mannyng, William, of Stowemarket, Suff, yeoman 2
5087383 2382691 2382691 defendant Neve John yeoman 587458 587458 Neve, John, of Stowemarket, Suff, yeoman 0
5096511 2385412 2385412 defendant Vyncent Robert raffman or ash maker 587458 587458 Vyncent, Robert, of Stowemarket, Suff, raffman or ash maker 0
5110295 2389416 2389416 defendant Mey Richard dyer 587458 587458 Mey, Richard, of Stowemarket, Suff, dyer 1
5128375 2394775 2394775 defendant Dego John carpenter 587458 587458 Dego, John, of Stowemarket, suff, carpenter 2
5206257 2417564 2417564 defendant Hotoft Robert gent 587458 587458 Hotoft, Robert, of Stowemarket, Suff, gent 0
5214137 2419860 2419860 defendant Thistilden Robert dyer 587458 587458 Thistilden, Robert, of Stowemarket, Suff, dyer 0
5223327 2422518 2422518 defendant Hotoft Robert gent 587458 587458 Hotoft, Robert, of Stowemarket, Suff, gent 0
5229063 2424110 2424110 defendant Batayle William clerk 587458 587458 Batayle, William, of Stowemarket, Suff, clerk 0
5240186 2427334 2427334 defendant Hotoft Robert gent 587458 587458 Hotoft, Robert, of Stowemarket, Suff, gent 0
5260932 2433541 2433541 defendant Wode Thomas husbandman 587458 587458 Wode, Thomas, of Stowemarket, Suff, husbandman 0
5271767 2436840 2436840 defendant Shalforth John dyer 587458 587458 Shalforth, John, of Stowemarket, Suff, dyer 1
5283078 2440112 2440112 defendant Shalforth John dyer 587458 587458 Shalforth, John, of Stowemarket, Suff, dyer 1
5339748 2457007 2457007 defendant Hotot Robert (legal representative) 587458 587458 Hotot, Robert, of Stowemarket, Suff, gent, administrator of 0
5359456 2462995 2462995 defendant Marchall John dyer 587458 587458 Marchall, John, of Stowemarket, Suff, dyer 0
5377426 2468525 2468525 defendant Rysshbroke Walter   587458 587458 Rysshbroke, Walter, of Stowemarket, Suff, cloth maker 1
5427110 2483047 2483047 defendant Hyll Thomas clerk 587458 587458 Hyll, Thomas, of Stowemarket, Suff, clerk 0
5430638 2484101 2484101 defendant Polsted John husbandman 587458 587458 Polsted, John, of Stowemarket, Suff, husbandman 4
5480541 2499151 2499151 defendant Orgonmaker alias Clerk Robert   587458 587458 Orgonmaker alias Clerk, Robert, of Stowemarket, Suff, organ maker 2
5485671 2500614 2500614 defendant Russhebroke Walter clothmaker 587458 587458 Russhebroke, Walter, of Stowemarket, Suff, clothmaker 4
5485900 2500673 2500673 defendant Garard John clothmaker 587458 587458 Garard, John, of Stowemarket, Suff, clothmaker 0
5504841 2506434 2506434 defendant Smyth William yeoman 587458 587458 Smyth, William, of Stowemarket, Suff, yeoman 3
5523321 2512124 2512124 defendant Russhebroke Walter clothmaker 587458 587458 Russhebroke, Walter, of Stowemarket, Suff, clothmaker 0

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