names

96 rows where place_id = 586223

✎ 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
3588202 1863965 1863965 defendant Wrasteler William yeoman 586223 586223 Wrasteler, William, of Walsale, yeoman 3
3598110 1867038 1867038 defendant Wever Roger weaver 586223 586223 Wever, Roger, of Walsale, weaver 1
3598111 1867038 1867038 defendant Hanes Richard ironmonger 586223 586223 Hanes, Richard, of Walsale, ironmonger 2
3611242 1871193 1871193 defendant Wright William smith 586223 586223 Wright, William, of Walsale, smith 0
3621694 1874324 1874324 defendant Brasier Roger brasier 586223 586223 Brasier, Roger, of Walsale, brasier 0
3621696 1874325 1874325 defendant Brasyer Roger brasier 586223 586223 Brasyer, Roger, of Walsale, brasier 0
4440352 2181895 2181895 defendant Taylour Robert   586223 586223 Taylour, Robert, of Walsale 0
4440353 2181895 2181895 defendant Wynde William   586223 586223 Wynde, William, of Walsale 1
4443177 2182827 2182827 defendant Fylot Richard   586223 586223 Fylot, Richard, of Walsale 1
4443179 2182827 2182827 defendant atte Sythe Robert   586223 586223 atte Sythe, Robert, of Walsale 3
4451354 2185392 2185392 defendant Galwey Stephen   586223 586223 Galwey, Stephen, of Walsale 1
4511497 2204040 2204040 defendant Dudley John   586223 586223 Dudley, John, of Walsale 0
4537881 2212132 2212132 defendant Marchall William   586223 586223 Marchall, William, of Walsale 1
4537882 2212132 2212132 defendant Oke William   586223 586223 Oke, William, of Walsale 2
4571565 2222685 2222685 defendant Brid Thomas   586223 586223 Brid, Thomas, of Walsale 1
4576381 2224126 2224126 plaintiff Broun John (legal representative) 586223 586223 Broun, John, of Walsale, executors of 0
4583741 2226328 2226328 plaintiff Fylkes John   586223 586223 Fylkes, John, of Walsale 0
4583743 2226329 2226329 plaintiff Fylkes John, sen   586223 586223 Fylkes, John, sen, of Walsale 0
4592085 2228882 2228882 defendant Onwyn Robert   586223 586223 Onwyn, Robert, of Walsale 0
4592087 2228882 2228882 defendant Smyth Thomas   586223 586223 Smyth, Thomas, of Walsale 2
4592088 2228882 2228882 defendant Normon William   586223 586223 Normon, William, of Walsale 3
4592089 2228882 2228882 defendant Reynold Joph   586223 586223 Reynold, Joph, of Walsale 4
4592090 2228882 2228882 defendant Taillour Robert   586223 586223 Taillour, Robert, of Walsale 5
4597399 2230430 2230430 plaintiff Shelfeld Robert ironmonger 586223 586223 Shelfeld, Robert, of Walsale, ironmonger 0
4632906 2241164 2241164 defendant Cole John   586223 586223 Cole, John, of Walsale 1
4641222 2243524 2243524 defendant Unwyn Roger   586223 586223 Unwyn, Roger, of Walsale 1
4644366 2244445 2244445 defendant Unwyn Robert   586223 586223 Unwyn, Robert, of Walsale 0
4648753 2245696 2245696 defendant Broun Thomas   586223 586223 Broun, Thomas, of Walsale 0
4648754 2245696 2245696 defendant White William   586223 586223 White, William, of Walsale 1
4648761 2245697 2245697 defendant Broun Thomas   586223 586223 Broun, Thomas, of Walsale 0
4648762 2245697 2245697 defendant White William   586223 586223 White, William, of Walsale 1
4648769 2245698 2245698 defendant Kent Richard   586223 586223 Kent, Richard, of Walsale 0
4648774 2245699 2245699 defendant Kent Richard   586223 586223 Kent, Richard, of Walsale 0
4722028 2272218 2272218 defendant Lydyate John at grasier 586223 586223 Lydyate, John at, of Walsale, grasier 0
4724835 2273064 2273064 defendant Lowe Richard husbandman 586223 586223 Lowe, Richard, of Walsale, husbandman 2
4724838 2273064 2273064 defendant Marchall John husbandman 586223 586223 Marchall, John, of Walsale, husbandman 5
4726320 2273514 2273514 defendant Baxster Richard ironmonger 586223 586223 Baxster, Richard, of Walsale, ironmonger 0
4726321 2273514 2273514 defendant Asmyd William chapman 586223 586223 Asmyd, William, of Walsale, chapman 1
4726324 2273515 2273515 defendant Prestwode William weaver 586223 586223 Prestwode, William, of Walsale, weaver 0
4745898 2279305 2279305 defendant Lowe Richard gent 586223 586223 Lowe, Richard, of Walsale, gent 0
4798430 2295694 2295694 defendant Lowe Richard chapman 586223 586223 Lowe, Richard, of Walsale, chapman 1
4798436 2295695 2295695 defendant Lowe Richard chapman 586223 586223 Lowe, Richard, of Walsale, chapman 1
4805633 2297971 2297971 defendant Shellefeld John   586223 586223 Shellefeld, John, of Walsale, franklin 0
4805634 2297971 2297971 defendant Marchall Roger yeoman 586223 586223 Marchall, Roger, of Walsale, yeoman 1
4805635 2297971 2297971 defendant Chamber John draper 586223 586223 Chamber, John, of Walsale, draper 2
4814739 2300727 2300727 defendant Fotus John butcher 586223 586223 Fotus, John, of Walsale, butcher 1
4814740 2300727 2300727 defendant Starnsmore Thomas carrier 586223 586223 Starnsmore, Thomas, of Walsale, carrier 2
4814742 2300727 2300727 defendant Hateley John butcher 586223 586223 Hateley, John, of Walsale, butcher 4
4814743 2300727 2300727 defendant Paunton Thomas carrier 586223 586223 Paunton, Thomas, of Walsale, carrier 5
4825912 2304137 2304137 defendant atte Lydyate John drover 586223 586223 atte Lydyate, John, of Walsale, drover 1
4828447 2304941 2304941 defendant Gunston John, sen yeoman 586223 586223 Gunston, John, sen, of Walsale, yeoman 4
4887012 2322785 2322785 defendant Stone Thomas nailer 586223 586223 Stone, Thomas, of Walsale, nailer 2
4923774 2333877 2333877 defendant Taillour William draper 586223 586223 Taillour, William, of Walsale, draper 4
4923776 2333877 2333877 defendant Mille Thomas   586223 586223 Mille, Thomas, of Walsale, coke or cook 6
4932893 2336678 2336678 defendant Brown William chapman 586223 586223 Brown, William, of Walsale, chapman 0
4952137 2342608 2342608 defendant Broun John chapman 586223 586223 Broun, John, of Walsale, chapman 1
4952142 2342609 2342609 defendant Broun John chapman 586223 586223 Broun, John, of Walsale, chapman 2
4958357 2344467 2344467 defendant Fotys Richard butcher 586223 586223 Fotys, Richard, of Walsale, butcher 1
4996684 2355863 2355863 defendant Kempsone William yeoman 586223 586223 Kempsone, William, of Walsale, yeoman 0
4996685 2355863 2355863 defendant Fykkes John   586223 586223 Fykkes, John, of Walsale, yeoman, son of William 1
4996687 2355864 2355864 defendant Kempsone William yeoman 586223 586223 Kempsone, William, of Walsale, yeoman 0
4996688 2355864 2355864 defendant Fylkes John yeoman 586223 586223 Fylkes, John, of Walsale, son of William, yeoman 1
5023415 2363754 2363754 defendant Dore William yeoman 586223 586223 Dore, William, of Walsale, yeoman 0
5026136 2364540 2364540 defendant Flaxhale Henry chapman 586223 586223 Flaxhale, Henry, of Walsale, chapman 0
5026138 2364541 2364541 defendant Flaxhale Henry chapman 586223 586223 Flaxhale, Henry, of Walsale, chapman 0
5033446 2366663 2366663 defendant Curteys Richard tailor 586223 586223 Curteys, Richard, of Walsale, tailor 1
5033447 2366663 2366663 defendant Pyper Richard, junior cordwainer 586223 586223 Pyper, Richard, junior, of Walsale, cordwainer 2
5033448 2366663 2366663 defendant Colman Thomas baker 586223 586223 Colman, Thomas, of Walsale, baker 3
5036800 2367640 2367640 defendant Taillour Robert cordwainer 586223 586223 Taillour, Robert, of Walsale, cordwainer 3
5069528 2377383 2377383 defendant Flaxhale Richard (legal representative) 586223 586223 Flaxhale, Richard, of Walsale, chapman, executor of 4
5069529 2377383 2377383 defendant Flaxhale Henry drover 586223 586223 Flaxhale, Henry, of Walsale, drover 5
5069986 2377517 2377517 defendant Flaxhale Richard (legal representative) 586223 586223 Flaxhale, Richard, of Walsale, chapman, executor of 4
5069987 2377517 2377517 defendant Flaxhale Henry drover 586223 586223 Flaxhale, Henry, of Walsale, drover 5
5084386 2381840 2381840 defendant Bocher Stephen butcher 586223 586223 Bocher, Stephen, of Walsale, butcher 3
5084387 2381840 2381840 defendant Couper William cordwainer 586223 586223 Couper, William, of Walsale, cordwainer 4
5088884 2383126 2383126 defendant Lybard Richard husbandman 586223 586223 Lybard, Richard, of Walsale, husbandman 0
5091797 2383983 2383983 defendant Rous John drover 586223 586223 Rous, John, of Walsale, drover 0
5091798 2383983 2383983 defendant Broun John yeoman 586223 586223 Broun, John, of Walsale, yeoman 1
5125102 2393814 2393814 defendant Wright John   586223 586223 Wright, John, of Walsale, wright 0
5178349 2409374 2409374 defendant Wright John   586223 586223 Wright, John, of Walsale, wright 0
5264641 2434695 2434695 defendant Staresmore Roger carrier 586223 586223 together with Staresmore, Roger, of Walsale, carrier 1
5317570 2450341 2450341 plaintiff Flaxhale Nicholas (legal representative) 586223 586223 Flaxhale, Nicholas, of Walsale, executor of 0
5328243 2453523 2453523 defendant Chyltryn Thomas carrier 586223 586223 Chyltryn, Thomas, of Walsale, carrier 1
5379702 2469236 2469236 defendant Daston Thomas husbandman 586223 586223 Daston, Thomas, of Walsale, husbandman 0
5464109 2494174 2494174 defendant Reynold William husbandman 586223 586223 Reynold, William, of Walsale, husbandman 3
5488230 2501378 2501378 defendant Patencham Elizabeth widow 586223 586223 Patencham, Elizabeth, of Walsale, widow 2
5488234 2501379 2501379 defendant Patencham Elizabeth widow 586223 586223 Patencham, Elizabeth, of Walsale, widow 2
5491759 2502434 2502434 defendant Wodeward John bellfounder 586223 586223 Wodeward, John, of Walsale, bellfounder 0
5495364 2503514 2503514 defendant Chaundeler Thomas yeoman 586223 586223 Chaundeler, Thomas, of Walsale, yeoman 1
5516028 2509861 2509861 defendant Weston John lorimer 586223 586223 Weston, John, of Walsale, lorimer 0
5516029 2509861 2509861 defendant Forde John, senior lorimer 586223 586223 Forde, John, senior, of Walsale, lorimer 1
5516031 2509861 2509861 defendant Marchall William barker 586223 586223 Marchall, William, of Walsale, barker 3
5516032 2509861 2509861 defendant Rondull William lorimer 586223 586223 Rondull, William, of Walsale, lorimer 4
5516033 2509861 2509861 defendant Sporyour William lorimer 586223 586223 Sporyour, William, of Walsale, lorimer 5
5516034 2509861 2509861 defendant Leveriche William lorimer 586223 586223 Leveriche, William, of Walsale, lorimer 6
5623067 2551151 2551151 defendant Taillour Henry le   586223 586223 Taillour, Henry le, of Walsale 3

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