names

68 rows where place_id = 601374

✎ 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
3645083 1908870 1908870 defendant Tornour Thomas potter 601374 601374 Tornour, Thomas, of Botesdale, potter 2
3967117 2013124 2013124 defendant Larke Anthony blacksmith 601374 601374 Larke, Anthony, of Botesdale, blacksmith 1
3967160 2013138 2013138 defendant Tompson Robert draper 601374 601374 Tompson, Robert, of Botesdale, draper 2
3977232 2016606 2016606 defendant Thompson Richard draper 601374 601374 Thompson, Richard, of Botesdale, draper 0
4000206 2024842 2024842 defendant Fyssher Henry clothier 601374 601374 Fyssher, Henry, of Botesdale, clothier 0
4001131 2025182 2025182 defendant Peeke Henry yeoman 601374 601374 Peeke, Henry, of Botesdale, or of Redgrave, yeoman 0
4001132 2025182 2025182 defendant Brette John tanner 601374 601374 Brette, John, of Botesdale, tanner 1
4209876 2099015 2099015 defendant Mycklefelde George sawyer 601374 601374 Mycklefelde, George, of Botesdale, sawyer 0
4287006 2125405 2125405 defendant Cooke John Suff, yeoman 601374 601374 Cooke John, of Botesdale, Suff, yeoman 3
4376628 2156709 2156709 defendant Cooke John husbandman 601374 601374 Cooke, John, of Botesdale, husbandman 1
4384980 2159667 2159667 defendant Stalworthye Edward yeoman 601374 601374 Stalworthye, Edward, of Botesdale, yeoman 0
4384981 2159667 2159667 defendant Person Grace widow 601374 601374 Person, Grace, of Botesdale, widow 1
4456926 2187178 2187178 defendant Spycer John   601374 601374 Spycer, John, of Botesdale 2
4461144 2188563 2188563 defendant Spyver John   601374 601374 Spyver, John, of Botesdale 2
4580075 2225256 2225256 defendant Slawe John   601374 601374 Slawe, John, of Botesdale 1
4602164 2231897 2231897 defendant Munchesye Thomas   601374 601374 Munchesye, Thomas, of Botesdale 0
4640841 2243420 2243420 defendant Lardener John   601374 601374 Lardener, John, of Botesdale 0
4642693 2243978 2243978 defendant Henham John   601374 601374 Henham, John, of Botesdale 5
4658488 2248534 2248534 defendant Spycer Walter yeoman 601374 601374 Spycer, Walter, of Botesdale, yeoman 0
4669177 2256065 2256065 defendant Breton Robert   601374 601374 Breton, Robert, of Botesdale, pedlar 2
4768036 2285971 2285971 plaintiff Mikylwode Henry   601374 601374 Mikylwode, Henry, of Botesdale 0
4773219 2287592 2287592 defendant Lardener John yeoman 601374 601374 Lardener, John, of Botesdale, yeoman 0
4792203 2293650 2293650 plaintiff Mekilwode Henry   601374 601374 Mekilwode, Henry, of Botesdale 0
4840908 2308693 2308693 plaintiff Hunte Robert   601374 601374 Hunte, Robert, of Botesdale 0
4866174 2316392 2316392 defendant Wayce William panier maker 601374 601374 Wayce, William, of Botesdale, panier maker 0
4878248 2320149 2320149 defendant Hacon John tailor 601374 601374 Hacon, John, of Botesdale, tailor 0
4912320 2330354 2330354 defendant Walpole Edmund husbandman 601374 601374 Walpole, Edmund, of Botesdale, husbandman 1
4922873 2333569 2333569 defendant Turnour Robert turner 601374 601374 Turnour, Robert, of Botesdale, turner 1
4976591 2349957 2349957 defendant Sewale John weaver 601374 601374 Sewale, John, of Botesdale, weaver 7
5035924 2367363 2367363 defendant Goldfynch Thomas yeoman 601374 601374 Goldfynch, Thomas, of Botesdale, yeoman 0
5053121 2372529 2372529 defendant Norton Robert, senior husbandman 601374 601374 Norton, Robert, senior, of Botesdale, husbandman 0
5093495 2384497 2384497 defendant Barkere John yeoman 601374 601374 Barkere, John, of Botesdale, or of Cranewyse, Norf, yeoman 1
5100785 2386652 2386652 defendant Dobbes Robert carver 601374 601374 Dobbes, Robert, of Botesdale, carver 6
5103897 2387566 2387566 defendant Slawe Maud widow 601374 601374 Slawe, Maud, of Botesdale, widow 0
5127195 2394432 2394432 defendant Slawe Matilda (legal representative) 601374 601374 Slawe, Matilda, of Botesdale, widow, executors of 0
5127196 2394432 2394432 defendant Anower Robert dyer 601374 601374 (Anower, Robert, of Botesdale, dyer 1
5144851 2399645 2399645 defendant Whightfoot John husbandman 601374 601374 Whightfoot, John, of Botesdale, husbandman 3
5146025 2399960 2399960 defendant Slawe Maud (legal representative) 601374 601374 Slawe, Maud, of Botesdale, widow, executors of 0
5146026 2399960 2399960 defendant Anowr Robert dyer 601374 601374 (Anowr, Robert, of Botesdale, dyer 1
5150725 2401356 2401356 defendant Buk Alexander yeoman 601374 601374 Buk, Alexander, of Botesdale, yeoman 2
5151268 2401518 2401518 defendant Leche Robert tanner 601374 601374 Leche, Robert, of Botesdale, tanner 3
5165532 2405663 2405663 defendant Whightfoot John husbandman 601374 601374 Whightfoot, John, of Botesdale, husbandman 3
5179679 2409794 2409794 defendant Whightfoot John husbandman 601374 601374 Whightfoot, John, of Botesdale, husbandman 3
5179684 2409795 2409795 defendant Whightfot John husbandman 601374 601374 Whightfot, John, of Botesdale, husbandman 3
5184036 2411064 2411064 defendant Alysaundre Thomas tailor 601374 601374 Alysaundre, Thomas, of Botesdale, tailor 1
5184222 2411129 2411129 defendant Dassh Peter yeoman 601374 601374 Dassh, Peter, of Botesdale, yeoman 0
5184223 2411129 2411129 defendant Buk Alexander yeoman 601374 601374 Buk, Alexander, of Botesdale, yeoman 1
5185134 2411398 2411398 defendant Dasshe Peter yeoman 601374 601374 Dasshe, Peter, of Botesdale, yeoman 0
5185602 2411540 2411540 defendant Buk Alexander yeoman 601374 601374 Buk, Alexander, of Botesdale, yeoman 2
5204109 2416954 2416954 defendant Alysayndre Thomas tailor 601374 601374 Alysayndre, Thomas, of Botesdale, tailor 1
5204230 2416993 2416993 defendant Dassh Peter yeoman 601374 601374 Dassh, Peter, of Botesdale, yeoman 0
5204231 2416993 2416993 defendant Buk Alexander yeoman 601374 601374 Buk, Alexander, of Botesdale, yeoman 1
5214287 2419912 2419912 defendant Slawe Maud   601374 601374 Slawe, Maud, of Botesdale, widow, executorsof 0
5214703 2420029 2420029 defendant Buk Alexander yeoman 601374 601374 Buk, Alexander, of Botesdale, yeoman 0
5216720 2420624 2420624 defendant Alisaundre Thomas tailor 601374 601374 Alisaundre, Thomas, of Botesdale, tailor 1
5255722 2431906 2431906 defendant Irlond John butcher 601374 601374 Irlond, John, of Botesdale, butcher 1
5302114 2445588 2445588 defendant Hose Thomas butcher 601374 601374 Hose, Thomas, of Botesdale, butcher 0
5302117 2445589 2445589 defendant Hose Thomas butcher 601374 601374 Hose, Thomas, of Botesdale, butcher 0
5306678 2446985 2446985 defendant Wellys Edward fuller 601374 601374 Wellys, Edward, of Botesdale, fuller 2
5482501 2499710 2499710 plaintiff Hawkyn or Hakon John   601374 601374 Hawkyn or Hakon, John, of Botesdale, yeoman, administrators of 0
5482502 2499710 2499710 plaintiff Goche Robert   601374 601374 (Goche, Robert, of Botesdale 1
5511513 2508448 2508448 defendant Hoo James chandler 601374 601374 Hoo, James, of Botesdale, chandler 0
5539373 2516801 2516801 defendant Aleyn Ralph husbandman 601374 601374 Aleyn, Ralph, of Botesdale, husbandman 0
5541244 2517380 2517380 defendant Goche Robert yeoman 601374 601374 Goche, Robert, of Botesdale, yeoman 6
5541245 2517380 2517380 defendant Starff William yeoman 601374 601374 Starff, William, of Botesdale, yeoman 7
5543526 2518088 2518088 defendant Barbour William husbandman 601374 601374 Barbour, William, of Botesdale, husbandman 0
5543529 2518089 2518089 defendant Drory Edmund husbandman 601374 601374 Drory, Edmund, of Botesdale, husbandman 0
5543583 2518098 2518098 defendant Nele John, junior armorer 601374 601374 Nele, John, junior, of Botesdale, armorer 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);