names

197 rows where place_id = 586431

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588713 1864113 1864113 defendant Lehe Hugh clerk 586431 586431 Lehe, Hugh, of Lychefeld, Staffs, clerk 0
3593332 1865547 1865547 defendant Strangwysshe George clerk 586431 586431 Strangwysshe, George, of Lychefeld, Staffs, clerk 0
3596475 1866527 1866527 defendant Byrmyngham William mercer 586431 586431 Byrmyngham, William, of Lychefeld, Staffs, mercer 0
3605335 1869335 1869335 defendant Strethey John gent 586431 586431 Strethey, John, of Lychefeld, Staffs, gent 0
3606852 1869809 1869809 defendant Faulke Thomas dyer 586431 586431 Faulke, Thomas, of Lychefeld, Staffs, dyer 1
3607288 1869941 1869941 defendant Whiret Robert chapman 586431 586431 Whiret, Robert, of Lychefeld, Staffs, chapman 4
3613565 1871890 1871890 defendant Reynold William chapman 586431 586431 Reynold, William, of Lychefeld, Staffs, chapman 3
3617380 1873055 1873055 defendant Derby Edward fishmonger 586431 586431 Derby, Edward, of Lychefeld, Staffs, fishmonger 0
3629327 1904031 1904031 defendant Egerton Richard clerk 586431 586431 Egerton, Richard, of Lychefeld, Staffs, clerk 0
3637537 1906551 1906551 defendant Calton Edward clerk 586431 586431 Calton, Edward, of Lychefeld, Staffs, clerk 3
3655811 1912075 1912075 defendant Clerke William taverner 586431 586431 Clerke, William, of Lychefeld, Staffs, taverner 0
3655815 1912075 1912075 defendant Dyson John yeoman 586431 586431 Dyson, John, of Lychefeld, Staffs, yeoman 4
3678226 1919243 1919243 defendant Churchyard Thomas chapman 586431 586431 Churchyard, Thomas, of Lychefeld, Staffs, chapman 2
3685443 1921597 1921597 defendant Cronyng John dyer 586431 586431 Cronyng, John, of Lychefeld, Staffs, dyer 0
3710985 1929750 1929750 defendant Penyfather John chapman 586431 586431 Penyfather, John, of Lychefeld, Staffs, chapman 1
3710993 1929751 1929751 defendant Penyfather John chapman 586431 586431 Penyfather, John, of Lychefeld, Staffs, chapman 1
3741386 1939173 1939173 defendant Collyns John merchant 586431 586431 Collyns, John, of Lychefeld, Staffs, merchant 1
3768711 1947861 1947861 defendant Penyfather Richard chapman 586431 586431 Penyfather, Richard, of Lychefeld, Staffs, chapman 0
3769870 1948230 1948230 defendant Dyconson William yeoman 586431 586431 Dyconson, William, of Lychefeld, Staffs, yeoman 0
3777284 1950641 1950641 defendant Sylvester James painter 586431 586431 Sylvester, James, of Lychefeld, Staffs, painter 0
3792632 1955556 1955556 defendant Borderyke John mercer 586431 586431 Borderyke, John, of Lychefeld, Staffs, mercer 2
3792638 1955557 1955557 defendant Broderyke John mercer 586431 586431 Broderyke, John, of Lychefeld, Staffs, mercer 2
3817624 1963416 1963416 defendant Godfrey Thomas carver 586431 586431 Godfrey, Thomas, of Lychefeld, Staffs, carver 1
3836517 1969327 1969327 defendant Lane Agnes widow 586431 586431 Lane, Agnes, of Lychefeld, Staffs, widow 0
3839193 1970184 1970184 defendant Alkyns Thomas mercer 586431 586431 Alkyns, Thomas, of Lychefeld, Staffs, mercer 0
3840375 1970554 1970554 defendant Alkyn Thomas chapman 586431 586431 Alkyn, Thomas, of Lychefeld, Staffs, chapman 0
3842194 1971106 1971106 defendant Alkyn Thomas mercer 586431 586431 Alkyn, Thomas, of Lychefeld, Staffs, mercer 0
3849824 1973530 1973530 defendant Halkyn Thomas chapman 586431 586431 Halkyn, Thomas, of Lychefeld, Staffs, chapman 1
3850845 1973857 1973857 defendant Repyngton John chaplain 586431 586431 Repyngton, John, of Lychefeld, Staffs, chaplain 0
3850848 1973858 1973858 defendant Repyngton John chaplain 586431 586431 Repyngton, John, of Lychefeld, Staffs, chaplain 0
3859112 1976538 1976538 defendant Hayward Hugh yeoman or brazier 586431 586431 Hayward, Hugh, of Lychefeld, Staffs, yeoman or brazier 1
3862517 1977659 1977659 defendant Turner Ralph draper 586431 586431 Turner, Ralph, of Lychefeld, Staffs, draper 2
3869675 1980101 1980101 defendant Collyns John chapman 586431 586431 Collyns, John, of Lychefeld, Staffs, chapman 2
3878484 1983049 1983049 plaintiff Leeke John yeoman 586431 586431 Leeke, John, of Lychefeld, Staffs, yeoman 0
3883177 1984636 1984636 defendant Sheille William innholder 586431 586431 Sheille, William, of Lychefeld, Staffs, innholder 0
3883182 1984637 1984637 defendant Sheylle William innholder 586431 586431 Sheylle, William, of Lychefeld, Staffs, innholder 0
3890479 1987072 1987072 defendant Stretehey Edward clerk 586431 586431 Stretehey, Edward, of Lychefeld, Staffs, clerk 0
3890792 1987187 1987187 defendant (not given) Ralph vicar of Snede 586431 586431 Snede, Ralph, of Lychefeld, Staffs, vicar of Rye 0
3891971 1987566 1987566 defendant Hawkyns Thomas mercer 586431 586431 Hawkyns, Thomas, of Lychefeld, Staffs, mercer 0
3909269 1993392 1993392 plaintiff Shelley William innholder 586431 586431 Shelley, William, of Lychefeld, Staffs, innholder 0
3911445 1994143 1994143 defendant Hawkyns Thomas mercer 586431 586431 Hawkyns, Thomas, of Lychefeld, Staffs, mercer 0
3912512 1994515 1994515 defendant Mogg Thomas (legal representative) 586431 586431 Mogg, Thomas, of Lychefeld, Staffs, yeoman, executrix of 0
3926665 1999251 1999251 defendant Tusdale Robert butcher 586431 586431 Tusdale, Robert, of Lychefeld, Staffs, butcher 4
3957277 2009608 2009608 defendant Ilysse William gent 586431 586431 Ilysse, William, of Lychefeld, Staffs, gent 4
3964344 2012133 2012133 defendant Hamersley William chapman 586431 586431 Hamersley, William, of Lychefeld, Staffs, chapman 0
4007757 2027558 2027558 plaintiff Mastergent Richard mercer 586431 586431 Mastergent, Richard, of Lychefeld, Staffs, mercer 0
4078526 2052617 2052617 defendant Hassall John clerk or mercer 586431 586431 Hassall, John, of Lychefeld, Staffs, clerk or mercer 3
4085094 2054951 2054951 defendant Baylye John yeoman 586431 586431 Baylye, John, of Lychefeld, Staffs, yeoman 1
4474746 2192768 2192768 defendant Hamstede Thomas   586431 586431 Hamstede, Thomas, of Lychefeld, Staffs 0
4621469 2237709 2237709 defendant Cole William   586431 586431 Cole, William, of Lychefeld, Staffs 0
4655893 2247720 2247720 defendant Trowell John weaver 586431 586431 Trowell, John, of Lychefeld, Staffs, weaver 0
4655895 2247721 2247721 defendant Trowell John weaver 586431 586431 Trowell, John, of Lychefeld, Staffs, weaver 0
4655897 2247722 2247722 defendant Trowell John weaver 586431 586431 Trowell, John, of Lychefeld, Staffs, weaver 0
4666834 2255352 2255352 defendant Buffet John fishmonger 586431 586431 Buffet, John, of Lychefeld, Staffs, fishmonger 1
4680089 2259383 2259383 defendant Keele William de butcher 586431 586431 Keele, William de, of Lychefeld, Staffs, butcher 0
4728268 2274086 2274086 defendant Byrchoure Robert chaplain 586431 586431 Byrchoure, Robert, of Lychefeld, Staffs, chaplain 0
4730087 2274611 2274611 defendant Chapman Henry chapman 586431 586431 Chapman, Henry, of Lychefeld, Staffs, chapman 0
4730089 2274612 2274612 defendant Chapman Henry chapman 586431 586431 Chapman, Henry, of Lychefeld, Staffs, chapman 0
4748104 2279956 2279956 defendant Walsham Andrew chapman 586431 586431 Walsham, Andrew, of Lychefeld, Staffs, chapman 0
4748557 2280079 2280079 defendant Gardyner Nicholas chapman 586431 586431 Gardyner, Nicholas, of Lychefeld, Staffs, chapman 4
4777654 2289008 2289008 defendant Taverner John taverner 586431 586431 Taverner, John, of Lychefeld, Staffs, taverner 1
4791329 2293382 2293382 defendant Walsham Andrew chapman 586431 586431 Walsham, Andrew, of Lychefeld, Staffs, chapman 0
4814070 2300504 2300504 defendant Hewet John gent 586431 586431 Hewet, John, of Lychefeld, Staffs, gent 5
4816770 2301343 2301343 defendant Drewe William   586431 586431 Drewe, William, of Lychefeld, Staffs, brass worker 3
4866539 2316496 2316496 defendant Fyssher William fisher 586431 586431 Fyssher, William, of Lychefeld, Staffs, fisher 3
4868460 2317108 2317108 defendant Shepherd Robert chapman 586431 586431 Shepherd, Robert, of Lychefeld, Staffs, chapman 0
4887004 2322784 2322784 defendant de Enton Henry ostler 586431 586431 de Enton, Henry, of Lychefeld, Staffs, ostler 1
4905340 2328262 2328262 defendant Shippard Robert yeoman 586431 586431 Shippard, Robert, of Lychefeld, Staffs, yeoman 1
4933727 2336926 2336926 defendant Joly John clerk 586431 586431 Joly, John, of Lychefeld, Staffs, clerk 0
4945545 2340584 2340584 defendant Hygate John clerk 586431 586431 Hygate, John, of Lychefeld, Staffs, clerk 0
4967065 2347084 2347084 defendant Joly John clerk 586431 586431 Joly, John, of Lychefeld, Staffs, clerk 0
4970655 2348160 2348160 defendant Draper Walter draper 586431 586431 Draper, Walter, of Lychefeld, Staffs, draper 0
4971078 2348289 2348289 defendant Orme William gent 586431 586431 Orme, William, of Lychefeld, Staffs, gent 3
4985800 2352668 2352668 defendant Fyssher Robert husbandman 586431 586431 Fyssher, Robert, of Lychefeld, Staffs, husbandman 0
4988771 2353597 2353597 defendant Pynner John   586431 586431 Pynner, John, of Lychefeld, Staffs, pin maker 2
5000320 2356967 2356967 defendant Legh Roger (legal representative) 586431 586431 Legh, Roger, of Lychefeld, Staffs, chapman, executrix of 0
5000321 2356967 2356967 defendant Legh Alice widow 586431 586431 Legh, Alice, of Lychefeld, Staffs, widow 1
5000347 2356970 2356970 defendant Legh Alice widow 586431 586431 Legh, Alice, of Lychefeld, Staffs, widow 1
5013456 2360772 2360772 defendant Burnell Thomas chapman 586431 586431 Burnell, Thomas, of Lychefeld, Staffs, chapman 0
5016721 2361781 2361781 defendant Halle William yeoman 586431 586431 Halle, William, of Lychefeld, Staffs, yeoman 0
5022228 2363394 2363394 defendant Brymsall William cordwainer 586431 586431 Brymsall, William, of Lychefeld, Staffs, cordwainer 0
5028536 2365220 2365220 defendant Garlek William yeoman 586431 586431 Garlek, William, of Lychefeld, Staffs, yeoman 1
5035278 2367179 2367179 defendant Lee Ellen widow 586431 586431 Lee, Ellen, of Lychefeld, Staffs, widow 0
5056346 2373471 2373471 defendant Heuster Richard dyer 586431 586431 Heuster, Richard, of Lychefeld, Staffs, dyer 0
5056350 2373472 2373472 defendant Heuster Richard dyer 586431 586431 Heuster, Richard, of Lychefeld, Staffs, dyer 0
5056441 2373503 2373503 defendant Fyssher Robert fisher 586431 586431 Fyssher, Robert, of Lychefeld, Staffs, fisher 0
5067286 2376725 2376725 defendant Swan Thomas mercer 586431 586431 Swan, Thomas, of Lychefeld, Staffs, mercer 4
5072294 2378200 2378200 defendant Dacon John shingler 586431 586431 Dacon, John, of Lychefeld, Staffs, shingler 3
5072299 2378201 2378201 defendant Decon John shingler 586431 586431 Decon, John, of Lychefeld, Staffs, shingler 3
5089139 2383197 2383197 defendant Rydell John clerk 586431 586431 Rydell, John, of Lychefeld, Staffs, clerk 0
5093107 2384373 2384373 defendant Wall Roger clerk 586431 586431 (Wall, Roger, of Lychefeld, Staffs, clerk 1
5095113 2384988 2384988 defendant Madyr Ralph chapman 586431 586431 Madyr, Ralph, of Lychefeld, Staffs, chapman 0
5099395 2386252 2386252 defendant Breton John gent 586431 586431 Breton, John, of Lychefeld, Staffs, gent 0
5100410 2386560 2386560 defendant Lache Hugh clerk 586431 586431 (Lache, Hugh, of Lychefeld, Staffs, clerk 1
5100414 2386561 2386561 defendant Lache Hugh clerk 586431 586431 (Lache, Hugh, of Lychefeld, Staffs, clerk 1
5105548 2388071 2388071 defendant Maderer Ralph yeoman 586431 586431 Maderer, Ralph, of Lychefeld, Staffs, yeoman 1
5105581 2388083 2388083 defendant Maderer Ralph yeoman 586431 586431 Maderer, Ralph, of Lychefeld, Staffs, yeoman 1
5112742 2390117 2390117 defendant Maderer Ralph merchant 586431 586431 Maderer, Ralph, of Lychefeld, Staffs, merchant 1
5112747 2390118 2390118 defendant Maderer Ralph merchant 586431 586431 Maderer, Ralph, of Lychefeld, Staffs, merchant 1
5114359 2390596 2390596 defendant Huchecokkes John butcher 586431 586431 Huchecokkes, John, of Lychefeld, Staffs, butcher 0

Next page

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