names

89 rows where place_id = 610396

✎ 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
3683344 1920914 1920914 defendant Jarman John draper 610396 610396 Jarman, John, of Tychefeld, draper 0
3796994 1956939 1956939 defendant Wodall Thomas yeoman 610396 610396 Wodall, Thomas, of Tychefeld, yeoman 0
3841808 1971020 1971020 defendant Hulle Ralph smith 610396 610396 Hulle, Ralph, of Tychefeld, smith 2
3848404 1973076 1973076 defendant Hawkesworth James gent 610396 610396 Hawkesworth, James, of Tychefeld, gent 0
3935695 2002247 2002247 plaintiff Osborne Thomas   610396 610396 Osborne, Thomas, of Tychefeld, 1
3937552 2002894 2002894 plaintiff Osborn Richard (legal representative) 610396 610396 Osborn, Richard, of Tychefeld, executor of 0
3937833 2002986 2002986 defendant Drewe Thomas gent 610396 610396 Drewe, Thomas, of Tychefeld, gent 0
4440025 2181803 2181803 defendant Turnour William   610396 610396 Turnour, William, of Tychefeld 0
4471319 2191695 2191695 defendant Yonge Richard   610396 610396 Yonge, Richard, of Tychefeld 1
4494514 2198975 2198975 defendant Bekot John (legal representative) 610396 610396 Bekot, John, of Tychefeld, executors of 0
4509640 2203493 2203493 defendant Boucher Peter   610396 610396 Boucher, Peter, of Tychefeld 0
4533165 2210639 2210639 defendant Wermond Richard   610396 610396 Wermond, Richard, of Tychefeld 0
4563116 2220031 2220031 defendant Sorpby Anabel   610396 610396 Sorpby, Anabel, of Tychefeld 0
4602269 2231925 2231925 plaintiff Wayte John (legal representative) 610396 610396 Wayte, John, of Tychefeld, esq, executors of 0
4606947 2233282 2233282 plaintiff Batayle Richard   610396 610396 Batayle, Richard, of Tychefeld 0
4683144 2260343 2260343 defendant Symondes William shipman 610396 610396 Symondes, William, of Tychefeld, shipman 0
4689420 2262249 2262249 defendant Warenner Thomas yeoman 610396 610396 Warenner, Thomas, of Tychefeld, yeoman 4
4746851 2279581 2279581 defendant Huntyngfeld John shoemaker 610396 610396 Huntyngfeld, John, of Tychefeld, shoemaker 2
4751550 2280939 2280939 defendant Hoyvyle Peter baker 610396 610396 Hoyvyle, Peter, of Tychefeld, baker 0
4751551 2280939 2280939 defendant Gordon Thomas laborer 610396 610396 Gordon, Thomas, of Tychefeld, laborer 1
4753156 2281368 2281368 defendant Godynewe John butcher 610396 610396 Godynewe, John, of Tychefeld, butcher 0
4765063 2285049 2285049 defendant Symond William shipman 610396 610396 Symond, William, of Tychefeld, shipman 0
4765166 2285085 2285085 defendant Huntyngfeld John   610396 610396 Huntyngfeld, John, of Tychefeld, shoe maker 1
4778357 2289211 2289211 defendant Coupere alias Carpenter John merchant 610396 610396 Coupere alias Carpenter, John, of Tychefeld, merchant 1
4794217 2294327 2294327 defendant Breredyng Margaret widow 610396 610396 Breredyng, Margaret, of Tychefeld, widow 0
4799198 2295930 2295930 defendant Gay Thomas husbandman 610396 610396 Gay, Thomas, of Tychefeld, husbandman 0
4851543 2311917 2311917 defendant atte Mille Richard   610396 610396 atte Mille, Richard, of Tychefeld, mill ward 0
4880416 2320784 2320784 defendant Harry Richard   610396 610396 Harry, Richard, of Tychefeld, servant 0
4880417 2320784 2320784 defendant Mosse John   610396 610396 Mosse, John, of Tychefeld, servant 1
4886229 2322554 2322554 defendant Hoyvyle Thomas husbandman 610396 610396 Hoyvyle, Thomas, of Tychefeld, husbandman 1
4904414 2327994 2327994 defendant Aynell John yeoman 610396 610396 Aynell, John, of Tychefeld, yeoman 0
4905809 2328419 2328419 defendant Hayward Richard husbandman 610396 610396 Hayward, Richard, of Tychefeld, husbandman 0
4945637 2340614 2340614 defendant Pery John laborer 610396 610396 Pery, John, of Tychefeld, laborer 0
4956734 2343968 2343968 defendant Barber William merchant 610396 610396 Barber, William, of Tychefeld, merchant 0
5004337 2358164 2358164 defendant Netelere John sawyer 610396 610396 Netelere, John, of Tychefeld, sawyer 0
5013929 2360927 2360927 defendant Osmunde Richard husbandman 610396 610396 Osmunde, Richard, of Tychefeld, husbandman 1
5015952 2361556 2361556 defendant Houghles Richard butcher 610396 610396 Houghles, Richard, of Tychefeld, butcher 1
5019064 2362468 2362468 defendant Gerdeford John hosier 610396 610396 Gerdeford, John, of Tychefeld, hosier 0
5022318 2363422 2363422 defendant Sylde William merchant 610396 610396 Sylde, William, of Tychefeld, merchant 0
5037563 2367861 2367861 defendant Wodecok Stephen merchant 610396 610396 Wodecok, Stephen, of Tychefeld, merchant 0
5037564 2367861 2367861 defendant Wodecok Johon hosier 610396 610396 Wodecok, Johon, of Tychefeld, hosier 1
5044322 2369934 2369934 defendant Gerveis John clerk 610396 610396 Gerveis, John, of Tychefeld, clerk 0
5044323 2369934 2369934 defendant Giles William yeoman 610396 610396 Giles, William, of Tychefeld, yeoman 1
5044324 2369934 2369934 defendant Godeale Richard yeoman 610396 610396 Godeale, Richard, of Tychefeld, yeoman 2
5044325 2369934 2369934 defendant Andrewe Thomas yeoman 610396 610396 Andrewe, Thomas, of Tychefeld, yeoman 3
5044326 2369934 2369934 defendant Reede Richard yeoman 610396 610396 Reede, Richard, of Tychefeld, yeoman 4
5048170 2371081 2371081 defendant Savyn Nicholas mercer 610396 610396 Savyn, Nicholas, of Tychefeld, mercer 1
5055538 2373236 2373236 defendant Parkyn Thomas husbandman 610396 610396 Parkyn, Thomas, of Tychefeld, husbandman 3
5080317 2380605 2380605 defendant Stoure Stephen husbandman 610396 610396 Stoure, Stephen, of Tychefeld, husbandman 0
5080318 2380605 2380605 defendant Morys Thomas husbandman 610396 610396 Morys, Thomas, of Tychefeld, husbandman 1
5080319 2380605 2380605 defendant Benysshe Robert husbandman 610396 610396 Benysshe, Robert, of Tychefeld, husbandman 2
5083983 2381710 2381710 defendant Ilond Joh butcher 610396 610396 Ilond, Joh, of Tychefeld, butcher 2
5095768 2385185 2385185 defendant Norton Richard merchant 610396 610396 Norton, Richard, of Tychefeld, merchant 0
5096653 2385456 2385456 defendant Stone John yeoman 610396 610396 Stone, John, of Tychefeld, yeoman 0
5122211 2392918 2392918 defendant Stonar John yeoman 610396 610396 Stonar, John, of Tychefeld, yeoman 0
5122212 2392918 2392918 defendant Stonhard John yeoman 610396 610396 Stonhard, John, of Tychefeld, yeoman 1
5144577 2399574 2399574 defendant Colyng William yeoman 610396 610396 Colyng, William, of Tychefeld, yeoman 1
5164500 2405349 2405349 defendant Stoure Stephen husbandman 610396 610396 Stoure, Stephen, of Tychefeld, husbandman 0
5165366 2405618 2405618 defendant Coltyng William yeoman 610396 610396 Coltyng, William, of Tychefeld, yeoman 1
5174079 2408118 2408118 defendant Stoure Stephen husbandman 610396 610396 Stoure, Stephen, of Tychefeld, husbandman 0
5178794 2409519 2409519 defendant Coltyng William yeoman 610396 610396 Coltyng, William, of Tychefeld, yeoman 1
5182444 2410621 2410621 plaintiff Stodeley Richard   610396 610396 Stodeley, Richard, of Tychefeld 1
5185236 2411429 2411429 defendant Styler Thomas merchant 610396 610396 Styler, Thomas, of Tychefeld, merchant 0
5194479 2414113 2414113 defendant Stoure Stephen husbandman 610396 610396 Stoure, Stephen, of Tychefeld, husbandman 0
5203388 2416753 2416753 plaintiff Stodeley Richard   610396 610396 Stodeley, Richard, of Tychefeld 1
5204717 2417124 2417124 defendant Styler Thomas merchant 610396 610396 Styler, Thomas, of Tychefeld, merchant 0
5208762 2418285 2418285 defendant Stoure Stephen husbandman 610396 610396 Stoure, Stephen, of Tychefeld, husbandman 0
5233740 2425456 2425456 plaintiff Clewer John merchant 610396 610396 Clewer, John, of Tychefeld, merchant 0
5263438 2434314 2434314 defendant Golley Richard husbandman 610396 610396 Golley, Richard, of Tychefeld, husbandman 1
5271760 2436839 2436839 defendant Nele John butcher 610396 610396 Nele, John, of Tychefeld, butcher 0
5297888 2444390 2444390 plaintiff Austyn William   610396 610396 Austyn, William, of Tychefeld, abbot of the monastery of the BM 0
5297889 2444390 2444390 defendant Devenes Thomas yeoman 610396 610396 Devenes, Thomas, of Tychefeld, yeoman 0
5297890 2444390 2444390 defendant Turpyn John yeoman 610396 610396 Turpyn, John, of Tychefeld, yeoman 1
5300535 2445125 2445125 plaintiff Clewer John   610396 610396 Clewer, John, of Tychefeld 0
5303803 2446134 2446134 defendant Torry William husbandman 610396 610396 Torry, William, of Tychefeld, husbandman 0
5303805 2446135 2446135 defendant Torry William husbandman 610396 610396 Torry, William, of Tychefeld, husbandman 0
5310187 2448081 2448081 defendant Berdolf John yeoman 610396 610396 Berdolf, John, of Tychefeld, yeoman 0
5313454 2449055 2449055 defendant Corveser Hugh cordwainer 610396 610396 Corveser, Hugh, of Tychefeld, cordwainer 1
5318444 2450609 2450609 defendant Deyll John husbandman 610396 610396 Deyll, John, of Tychefeld, husbandman 0
5356388 2462064 2462064 defendant Cheseman William tailor 610396 610396 Cheseman, William, of Tychefeld, tailor 2
5357226 2462321 2462321 defendant Sabyn John mercer 610396 610396 Sabyn, John, of Tychefeld, mercer 1
5357227 2462321 2462321 defendant Cook John weaver 610396 610396 Cook, John, of Tychefeld, weaver 2
5484531 2500292 2500292 defendant Poyntell William yeoman 610396 610396 Poyntell, William, of Tychefeld, yeoman 3
5502453 2505686 2505686 defendant Jaye Thomas yeoman 610396 610396 Jaye, Thomas, of Tychefeld, yeoman 0
5541604 2517482 2517482 defendant Sabyn John merchant 610396 610396 Sabyn, John, of Tychefeld, merchant 0
5541605 2517482 2517482 defendant A Dene Thomas husbandman 610396 610396 A Dene, Thomas, of Tychefeld, husbandman 1
5541606 2517482 2517482 defendant Bocher John fuller 610396 610396 Bocher, John, of Tychefeld, fuller 2
5542757 2517855 2517855 defendant Whyte Richard clothier 610396 610396 Whyte, Richard, of Tychefeld, clothier 0
5542758 2517855 2517855 defendant Bulle John   610396 610396 Bulle, John, of Tychefeld, shipwright 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);