names

100 rows where place_id = 594190

✎ 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
3615009 1872338 1872338 defendant Arblaster Thomas gent or clothman 594190 594190 Arblaster, Thomas, of Stoke Neylond, Suff, gent or clothman 0
3618011 1873253 1873253 defendant Hewet John, junior clothmaker 594190 594190 Hewet, John, junior, of Stoke Neylond, Suff, clothmaker 0
3622414 1874546 1874546 defendant Bolle William yeoman 594190 594190 Bolle, William, of Stoke Neylond, Suff, yeoman 1
3623611 1874917 1874917 defendant Arblaster Thomas gent 594190 594190 Arblaster, Thomas, of Stoke Neylond, Suff, gent 0
3631987 1904819 1904819 defendant Stannesby Roger clothmaker 594190 594190 Stannesby, Roger, of Stoke Neylond, Suff, clothmaker 0
3663646 1914561 1914561 defendant Hamond Gregory clerk 594190 594190 Hamond, Gregory, of Stoke Neylond, Suff, clerk 1
3666028 1915312 1915312 defendant Colman John yeoman 594190 594190 Colman, John, of Stoke Neylond, Suff, yeoman 1
3685356 1921574 1921574 defendant Hewett Christine widow 594190 594190 Hewett, Christine, of Stoke Neylond, Suff, widow 4
3685362 1921575 1921575 defendant Hewet Christine widow 594190 594190 Hewet, Christine, of Stoke Neylond, Suff, widow 4
3703358 1927324 1927324 defendant Hewett John merchant 594190 594190 Hewett, John, of Stoke Neylond, Suff, merchant 0
3774834 1949857 1949857 defendant Hedge William clerk 594190 594190 Hedge, William, of Stoke Neylond, Suff, clerk 1
3784190 1952841 1952841 defendant Scottyng William woolman 594190 594190 Scottyng, William, of Stoke Neylond, Suff, woolman 0
3842048 1971067 1971067 defendant Austen John clothier 594190 594190 Austen, John, of Stoke Neylond, Suff, clothier 1
3870209 1980283 1980283 defendant Rutter Christopher clothmaker 594190 594190 Rutter, Christopher, of Stoke Neylond, Suff, clothmaker 0
3884007 1984921 1984921 defendant Rutter Chrisopher clothmaker 594190 594190 Rutter, Chrisopher, of Stoke Neylond, Suff, clothmaker 0
3942967 2004654 2004654 defendant Mall John clothier 594190 594190 Mall, John, of Stoke Neylond, Suff, clothier 0
4573766 2223313 2223313 defendant Leyre John   594190 594190 Leyre, John, of Stoke Neylond, Suff 0
4576334 2224105 2224105 defendant Mannok John   594190 594190 Mannok, John, of Stoke Neylond, Suff 0
4647432 2245309 2245309 defendant Stedeman Thomas   594190 594190 Stedeman, Thomas, of Stoke Neylond, Suff 0
4679455 2259190 2259190 defendant Leyre John   594190 594190 Leyre, John, of Stoke Neylond, Suff, attorney 0
4690408 2262559 2262559 defendant Wethermerssh John gent 594190 594190 Wethermerssh, John, of Stoke Neylond, Suff, gent 0
4693589 2263496 2263496 defendant Wythermersshe John gent 594190 594190 Wythermersshe, John, of Stoke Neylond, Suff, gent 2
4725116 2273153 2273153 defendant Smyth William tailor 594190 594190 Smyth, William, of Stoke Neylond, Suff, tailor 0
4726933 2273689 2273689 defendant Skynner John husbandman 594190 594190 Skynner, John, of Stoke Neylond, Suff, husbandman 0
4731382 2275015 2275015 defendant Leyr John gent 594190 594190 Leyr, John, of Stoke Neylond, Suff, gent 0
4752183 2281113 2281113 defendant Sterre John draper 594190 594190 Sterre, John, of Stoke Neylond, Suff, draper 2
4773114 2287561 2287561 defendant Sterre John chapman 594190 594190 Sterre, John, of Stoke Neylond, Suff, chapman 0
4786359 2291778 2291778 defendant Waltham Thomas   594190 594190 Waltham, Thomas, of Stoke Neylond, Suff, mason 0
4797365 2295348 2295348 defendant Sterre John chapman 594190 594190 Sterre, John, of Stoke Neylond, Suff, chapman 0
4871517 2318060 2318060 defendant Cappe John mercer 594190 594190 Cappe, John, of Stoke Neylond, Suff, mercer 0
4968615 2347579 2347579 defendant Cappe John mercer 594190 594190 Cappe, John, of Stoke Neylond, Suff, mercer 0
5087768 2382806 2382806 defendant Baker Thomas weaver 594190 594190 Baker, Thomas, of Stoke Neylond, Suff, weaver 3
5087774 2382807 2382807 defendant Baker Thomas weaver 594190 594190 Baker, Thomas, of Stoke Neylond, Suff, weaver 3
5093821 2384593 2384593 defendant Debenham Richard weaver 594190 594190 Debenham, Richard, of Stoke Neylond, Suff, weaver 0
5093825 2384594 2384594 defendant Debenham Richard weaver 594190 594190 Debenham, Richard, of Stoke Neylond, Suff, weaver 0
5115842 2391059 2391059 defendant Hamond William clothmaker 594190 594190 Hamond, William, of Stoke Neylond, Suff, clothmaker 4
5115848 2391060 2391060 defendant Hamond William clothmaker 594190 594190 Hamond, William, of Stoke Neylond, Suff, clothmaker 4
5137047 2397349 2397349 defendant Reve John woder of a dyer or cultivator of woad 594190 594190 Reve, John, of Stoke Neylond, Suff, woder of a dyer or cultivator of woad 1
5153416 2402152 2402152 plaintiff Ive William weaver 594190 594190 Ive, William, of Stoke Neylond, Suff, weaver 0
5153418 2402153 2402153 plaintiff Ive William weaver 594190 594190 Ive, William, of Stoke Neylond, Suff, weaver 0
5153572 2402196 2402196 defendant Warde Thomas sheerman 594190 594190 Warde, Thomas, of Stoke Neylond, Suff, sheerman 0
5170918 2407216 2407216 defendant Warde Thomas sherman 594190 594190 Warde, Thomas, of Stoke Neylond, Suff, sherman 0
5188867 2412476 2412476 plaintiff Ive Thomas weaver 594190 594190 Ive, Thomas, of Stoke Neylond, Suff, weaver 0
5189002 2412514 2412514 defendant Warde Thomas sheerman 594190 594190 Warde, Thomas, of Stoke Neylond, Suff, sheerman 0
5221412 2421961 2421961 defendant Gylys Robert yeoman 594190 594190 Gylys, Robert, of Stoke Neylond, Suff, yeoman 2
5236614 2426293 2426293 defendant Petewyn Thomas yeoman 594190 594190 Petewyn, Thomas, of Stoke Neylond, Suff, yeoman 0
5237236 2426474 2426474 defendant Wright John barber 594190 594190 Wright, John, of Stoke Neylond, Suff, barber 0
5237239 2426475 2426475 defendant Brynkeley William clothmaker 594190 594190 Brynkeley, William, of Stoke Neylond, Suff, clothmaker 1
5255561 2431857 2431857 defendant Balstone John chapman 594190 594190 Balstone, John, of Stoke Neylond, Suff, chapman 0
5276679 2438260 2438260 defendant Spede Thomas clothman 594190 594190 Spede, Thomas, of Stoke Neylond, Suff, clothman 0
5276710 2438270 2438270 plaintiff Wortham John yeoman 594190 594190 Wortham, John, of Stoke Neylond, Suff, yeoman 0
5294487 2443367 2443367 defendant Barbour John clothmaker 594190 594190 Barbour, John, of Stoke Neylond, Suff, clothmaker 2
5295404 2443646 2443646 defendant Byrband Robert esq 594190 594190 Byrband, Robert, of Stoke Neylond, Suff, esq 2
5311328 2448418 2448418 plaintiff Wurtham John yeoman 594190 594190 Wurtham, John, of Stoke Neylond, Suff, yeoman 0
5315314 2449636 2449636 defendant Balston John yeoman 594190 594190 Balston, John, of Stoke Neylond, Suff, yeoman 1
5316585 2450045 2450045 defendant Mannok Robert husbandman 594190 594190 Mannok, Robert, of Stoke Neylond, Suff, husbandman 3
5325838 2452811 2452811 defendant Balston John, junior clothmaker 594190 594190 Balston, John, junior, of Stoke Neylond, Suff, clothmaker 1
5326529 2453019 2453019 defendant Serceaunt Robert chapman 594190 594190 (Serceaunt, Robert, of Stoke Neylond, Suff, chapman 1
5326536 2453020 2453020 defendant Sergeaunt Robert chapman 594190 594190 (Sergeaunt, Robert, of Stoke Neylond, Suff, chapman 1
5337703 2456350 2456350 defendant Gyrlyng John husbandman 594190 594190 Gyrlyng, John, of Stoke Neylond, Suff, husbandman 1
5347545 2459389 2459389 defendant Balston William yeoman 594190 594190 Balston, William, of Stoke Neylond, Suff, yeoman 0
5347548 2459390 2459390 defendant Balston William yeoman 594190 594190 Balston, William, of Stoke Neylond, Suff, yeoman 0
5349845 2460087 2460087 defendant Balston John, senior yeoman 594190 594190 Balston, John, senior, of Stoke Neylond, Suff, yeoman 1
5358569 2462738 2462738 defendant Sergeant John clothman 594190 594190 Sergeant, John, of Stoke Neylond, Suff, clothman 7
5359457 2462995 2462995 defendant Broune Geoffrey clothmaker 594190 594190 Broune, Geoffrey, of Stoke Neylond, Suff, clothmaker 1
5359468 2462997 2462997 defendant Bolthod William dyer 594190 594190 Bolthod, William, of Stoke Neylond, Suff, dyer 2
5359474 2462998 2462998 defendant Bolthod William dyer 594190 594190 Bolthod, William, of Stoke Neylond, Suff, dyer 2
5404633 2476399 2476399 defendant Sparlynge John smith 594190 594190 Sparlynge, John, of Stoke Neylond, Suff, smith 1
5407119 2477096 2477096 defendant Terry Robert   594190 594190 Terry, Robert, of Stoke Neylond, Suff, cloth maker 0
5417780 2480242 2480242 defendant Sparlynge John smith 594190 594190 Sparlynge, John, of Stoke Neylond, Suff, smith 1
5419338 2480704 2480704 defendant Clerke Robert clothier 594190 594190 Clerke, Robert, of Stoke Neylond, Suff, clothier 2
5422696 2481739 2481739 defendant Mannok Robert husbandman 594190 594190 Mannok, Robert, of Stoke Neylond, Suff, husbandman 0
5428994 2483592 2483592 defendant Boltwode William dyer 594190 594190 Boltwode, William, of Stoke Neylond, Suff, dyer 0
5429860 2483873 2483873 plaintiff Hamond Joan widow 594190 594190 Hamond, Joan, of Stoke Neylond, Suff, widow 0
5435265 2485478 2485478 defendant Sparlynge John smith 594190 594190 Sparlynge, John, of Stoke Neylond, Suff, smith 1
5437484 2486152 2486152 defendant Clerke Robert clothman 594190 594190 Clerke, Robert, of Stoke Neylond, Suff, clothman 2
5437490 2486153 2486153 defendant Clerke Robert clothman 594190 594190 Clerke, Robert, of Stoke Neylond, Suff, clothman 2
5450325 2489982 2489982 defendant Spark John smith 594190 594190 Spark, John, of Stoke Neylond, Suff, smith 1
5459335 2492701 2492701 defendant Bolthode William woodman 594190 594190 Bolthode, William, of Stoke Neylond, Suff, woodman 2
5462476 2493681 2493681 defendant Sparlynge John smith 594190 594190 Sparlynge, John, of Stoke Neylond, Suff, smith 1
5464894 2494413 2494413 defendant Terry Robert clothmaker 594190 594190 Terry, Robert, of Stoke Neylond, Suff, clothmaker 0
5474021 2497204 2497204 defendant Sparlynge John smith 594190 594190 Sparlynge, John, of Stoke Neylond, Suff, smith 0
5482256 2499637 2499637 plaintiff Hamond Joan widow 594190 594190 Hamond, Joan, of Stoke Neylond, Suff, widow 0
5485870 2500667 2500667 defendant Boltwode Thomas weaver 594190 594190 Boltwode, Thomas, of Stoke Neylond, Suff, weaver 0
5485876 2500668 2500668 defendant Breggys Robert clothmaker 594190 594190 Breggys, Robert, of Stoke Neylond, Suff, clothmaker 1
5488051 2501316 2501316 defendant Debenham John weaver 594190 594190 Debenham, John, of Stoke Neylond, Suff, weaver 0
5494675 2503296 2503296 defendant Boltwood William dyer 594190 594190 Boltwood, William, of Stoke Neylond, Suff, dyer 0
5496115 2503735 2503735 defendant Swayn Thomas clerk 594190 594190 Swayn, Thomas, of Stoke Neylond, Suff, clerk 0
5496118 2503736 2503736 defendant Swayn Thomas clerk 594190 594190 Swayn, Thomas, of Stoke Neylond, Suff, clerk 0
5501275 2505335 2505335 defendant Profyt Thomas, junior gent 594190 594190 Profyt, Thomas, junior, of Stoke Neylond, Suff, gent 0
5505968 2506788 2506788 defendant Wellok John miller 594190 594190 Wellok, John, of Stoke Neylond, Suff, miller 3
5512541 2508781 2508781 defendant Man Walter chapman 594190 594190 Man, Walter, of Stoke Neylond, Suff, chapman 1
5521293 2511477 2511477 defendant Barker Joan widow 594190 594190 Barker, Joan, of Stoke Neylond, Suff, widow 3
5536451 2515888 2515888 defendant White William smith 594190 594190 (White, William, of Stoke Neylond, Suff, smith 1
5536454 2515889 2515889 defendant Whyte William smith 594190 594190 (Whyte, William, of Stoke Neylond, Suff, smith 1
5543288 2518018 2518018 defendant Hewet John clothmaker 594190 594190 Hewet, John, of Stoke Neylond, Suff, clothmaker 0
5564759 2524279 2524279 defendant Arblaster Thomas gent 594190 594190 Arblaster, Thomas, of Stoke Neylond, Suff, gent 0
5594113 2533135 2533135 defendant Hewyet John clothmaker 594190 594190 Hewyet, John, of Stoke Neylond, Suff, clothmaker 1
5597172 2534021 2534021 defendant Lyster William chaplain 594190 594190 Lyster, William, of Stoke Neylond, Suff, chaplain 0
5609492 2537865 2537865 defendant Terre Robert tailor 594190 594190 Terre, Robert, of Stoke Neylond, Suff, tailor 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);