names

184 rows where place_id = 780768

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4668649 2255907 2255907 defendant Caudray William   780768 780768 Caudray, William, of Worcester, Worcs, apothecary 0
4669603 2256203 2256203 defendant Eston John husbandman 780768 780768 (Eston, John, of Worcester, Worcs, husbandman 1
4670836 2256557 2256557 defendant More John chapman 780768 780768 More, John, of Worcester, Worcs, chapman 4
4671215 2256653 2256653 defendant Tonge William loder 780768 780768 Tonge, William, of Worcester, Worcs, loder 2
4672650 2257087 2257087 defendant Peverell Thomas   780768 780768 Peverell, Thomas, of Worcester, Worcs, bishop 0
4681237 2259758 2259758 defendant Prat Thomas yeoman 780768 780768 Prat, Thomas, of Worcester, Worcs, yeoman 0
4685129 2260951 2260951 defendant Whitehed John husbandman 780768 780768 Whitehed, John, of Worcester, Worcs, husbandman 0
4693907 2263597 2263597 defendant Ludlowe John chapman 780768 780768 Ludlowe, John, of Worcester, Worcs, chapman 0
4698919 2265140 2265140 defendant Ludlowe John chapman 780768 780768 Ludlowe, John, of Worcester, Worcs, chapman 0
4702178 2266090 2266090 defendant Banham John merchant 780768 780768 Banham, John, of Worcester, Worcs, merchant 0
4707635 2267750 2267750 defendant Banard Gregory vintner 780768 780768 Banard, Gregory, of Worcester, Worcs, vintner 0
4708755 2268109 2268109 defendant Stoke John husbandman 780768 780768 Stoke, John, of Worcester, Worcs, husbandman 0
4725650 2273307 2273307 defendant Jonettye John esq 780768 780768 Jonettye, John, of Worcester, Worcs, esq 0
4734006 2275822 2275822 defendant Parker John chapman 780768 780768 Parker, John, of Worcester, Worcs, chapman 0
4734009 2275823 2275823 defendant Dier Richard dyer 780768 780768 Dier, Richard, of Worcester, Worcs, dyer 1
4734549 2275973 2275973 defendant Sutton Nicholas tailor 780768 780768 Sutton, Nicholas, of Worcester, Worcs, tailor 0
4738359 2277093 2277093 defendant Parkere John fuller 780768 780768 Parkere, John, of Worcester, Worcs, fuller 2
4740372 2277695 2277695 defendant Frowyn Thomas   780768 780768 Frowyn, Thomas, of Worcester, Worcs, husbandman, Isabel, his wife, formerly wife of Testator 1
4740384 2277699 2277699 defendant Grafton Richard   780768 780768 Grafton, Richard, of Worcester, Worcs, preceptor of St Wulstan 0
4740386 2277700 2277700 defendant Grafton Richard   780768 780768 Grafton, Richard, of Worcester, Worcs, preceptor of St Wulstan's 0
4746092 2279355 2279355 defendant Jenettes John gent 780768 780768 Jenettes, John, of Worcester, Worcs, gent 0
4748359 2280027 2280027 defendant Taillour Nicholas chapman 780768 780768 Taillour, Nicholas, of Worcester, Worcs, chapman 1
4748365 2280028 2280028 defendant Taillour Nicholas chapman 780768 780768 Taillour, Nicholas, of Worcester, Worcs, chapman 1
4748622 2280093 2280093 defendant Lodelowe John merchant 780768 780768 Lodelowe, John, of Worcester, Worcs, merchant 2
4749775 2280412 2280412 defendant Jonettis John gent 780768 780768 Jonettis, John, of Worcester, Worcs, gent 4
4749941 2280455 2280455 defendant Jonetis John gent 780768 780768 Jonetis, John, of Worcester, Worcs, gent 4
4752108 2281098 2281098 defendant Styward Alice widow & formerly wife of Testator 780768 780768 Styward, Alice, of Worcester, Worcs, widow & formerly wife of Testator 1
4756159 2282301 2282301 defendant Warde William chapman 780768 780768 Warde, William, of Worcester, Worcs, chapman 0
4756161 2282302 2282302 defendant Warde William chapman 780768 780768 Warde, William, of Worcester, Worcs, chapman 0
4756169 2282306 2282306 defendant Broune Richard butcher 780768 780768 Broune, Richard, of Worcester, Worcs, butcher 0
4763435 2284551 2284551 defendant Barette Richard husbandman 780768 780768 Barette, Richard, of Worcester, Worcs, husbandman 2
4770222 2286661 2286661 defendant More John chapman 780768 780768 More, John, of Worcester, Worcs, chapman 0
4772965 2287516 2287516 defendant Meyr John dyer 780768 780768 Meyr, John, of Worcester, Worcs, dyer 0
4803839 2297378 2297378 defendant Stokes Nicholas merchant 780768 780768 Stokes, Nicholas, of Worcester, Worcs, merchant 0
4803843 2297379 2297379 defendant Stokes Nicholas merchant 780768 780768 Stokes, Nicholas, of Worcester, Worcs, merchant 0
4806677 2298298 2298298 defendant Smyth John troweman 780768 780768 Smyth, John, of Worcester, Worcs, troweman 2
4810202 2299336 2299336 defendant Walker Walter chapman 780768 780768 Walker, Walter, of Worcester, Worcs, chapman 1
4810548 2299444 2299444 defendant Staunton John yeoman 780768 780768 Staunton, John, of Worcester, Worcs, yeoman 0
4812743 2300100 2300100 defendant Mercer John dyer 780768 780768 Mercer, John, of Worcester, Worcs, dyer 2
4814992 2300798 2300798 defendant Ludlowe John merchant 780768 780768 Ludlowe, John, of Worcester, Worcs, merchant 4
4817334 2301510 2301510 defendant Pratt Thomas gent 780768 780768 Pratt, Thomas, of Worcester, Worcs, gent 0
4819296 2302112 2302112 defendant Jonettys John gent 780768 780768 Jonettys, John, of Worcester, Worcs, gent 4
4819312 2302116 2302116 defendant Jonettys John gent 780768 780768 Jonettys, John, of Worcester, Worcs, gent 4
4821879 2302918 2302918 defendant Ludlowe John merchant 780768 780768 Ludlowe, John, of Worcester, Worcs, merchant 0
4823633 2303484 2303484 defendant Frere Geoffrey chapman 780768 780768 Frere, Geoffrey, of Worcester, Worcs, chapman 2
4824444 2303695 2303695 defendant Monk John ironworker 780768 780768 Monk, John, of Worcester, Worcs, ironworker 2
4827102 2304522 2304522 defendant Hopkyns Nicholas brewer 780768 780768 Hopkyns, Nicholas, of Worcester, Worcs, brewer 0
4837245 2307594 2307594 defendant Coghton William barber 780768 780768 Coghton, William, of Worcester, Worcs, barber 0
4840888 2308688 2308688 defendant Walshale Robert   780768 780768 Walshale, Robert, of Worcester, Worcs, spice man 0
4840894 2308689 2308689 defendant Walshale Robert spicer 780768 780768 Walshale, Robert, of Worcester, Worcs, spicer 0
4843157 2309387 2309387 defendant Bele William clerk 780768 780768 Bele, William, of Worcester, Worcs, clerk 0
4843979 2309631 2309631 defendant Cronettes John gent 780768 780768 Cronettes, John, of Worcester, Worcs, gent 2
4844007 2309636 2309636 defendant Jonettes John gent 780768 780768 Jonettes, John, of Worcester, Worcs, gent 2
4844850 2309914 2309914 defendant atte Wode John esq 780768 780768 atte Wode, John, of Worcester, Worcs, esq 0
4854109 2312695 2312695 defendant Markusfeld Thomas merchant 780768 780768 Markusfeld, Thomas, of Worcester, Worcs, merchant 1
4917954 2332131 2332131 defendant fitz Elys Robert gent 780768 780768 fitz Elys, Robert, of Worcester, Worcs, gent 3
4917961 2332132 2332132 defendant fitz Elys Robert gent 780768 780768 fitz Elys, Robert, of Worcester, Worcs, gent 3
4920299 2332862 2332862 defendant Clyff William gent 780768 780768 Clyff, William, of Worcester, Worcs, gent 0
4921239 2333158 2333158 defendant Clyf William gent 780768 780768 Clyf, William, of Worcester, Worcs, gent 1
4921920 2333260 2333260 defendant Wybbe Thomas esq 780768 780768 Wybbe, Thomas, of Worcester, Worcs, esq 0
4925937 2334544 2334544 defendant Wesshborn Norman esq 780768 780768 Wesshborn, Norman, of Worcester, Worcs, esq 0
4926444 2334690 2334690 defendant Hille John yeoman 780768 780768 with Hille, John, of Worcester, Worcs, yeoman 1
4926447 2334691 2334691 defendant Hille John yeoman 780768 780768 Hille, John, of Worcester, Worcs, yeoman 0
4931606 2336271 2336271 defendant Polleyn Robert gent 780768 780768 Polleyn, Robert, of Worcester, Worcs, gent 0
4985489 2352577 2352577 defendant Walsale Thomas chapman 780768 780768 Walsale, Thomas, of Worcester, Worcs, chapman 0
4993309 2354871 2354871 defendant Walshale Thomas chapman 780768 780768 Walshale, Thomas, of Worcester, Worcs, chapman 3
4993314 2354872 2354872 defendant Walshale Thomas chapman 780768 780768 Walshale, Thomas, of Worcester, Worcs, chapman 3
5001435 2357305 2357305 defendant Aston Nicholas ostler 780768 780768 Aston, Nicholas, of Worcester, Worcs, ostler 0
5007877 2359194 2359194 defendant Trygge Denise widow 780768 780768 Trygge, Denise, of Worcester, Worcs, widow 1
5008048 2359242 2359242 defendant Bowede Robert chapman 780768 780768 Bowede, Robert, of Worcester, Worcs, chapman 0
5010832 2360021 2360021 defendant Dun William butcher 780768 780768 Dun, William, of Worcester, Worcs, butcher 0
5011560 2360245 2360245 defendant Walsall Thomas mercer 780768 780768 Walsall, Thomas, of Worcester, Worcs, mercer 2
5011605 2360253 2360253 defendant Walsall Thomas mercer 780768 780768 Walsall, Thomas, of Worcester, Worcs, mercer 2
5038708 2368224 2368224 defendant Neweman Robert   780768 780768 Neweman, Robert, of Worcester, Worcs, mason 0
5039194 2368364 2368364 defendant Forthey Matilda widow 780768 780768 Forthey, Matilda, of Worcester, Worcs, widow 0
5039564 2368480 2368480 defendant Beudeley William carpenter 780768 780768 Beudeley, William, of Worcester, Worcs, carpenter 2
5039685 2368512 2368512 defendant Dodyng Nicholas dyer 780768 780768 Dodyng, Nicholas, of Worcester, Worcs, dyer 2
5039689 2368513 2368513 defendant Dodyng Nicholas dyer 780768 780768 Dodyng, Nicholas, of Worcester, Worcs, dyer 2
5042997 2369520 2369520 defendant Hewelet Thomas clerk 780768 780768 Hewelet, Thomas, of Worcester, Worcs, clerk 0
5044657 2370032 2370032 defendant Dodyng Thomas gent 780768 780768 Dodyng, Thomas, of Worcester, Worcs, gent 1
5044660 2370033 2370033 defendant Dodyng Thomas gent 780768 780768 Dodyng, Thomas, of Worcester, Worcs, gent 1
5046299 2370524 2370524 defendant Brewer James brewer 780768 780768 (Brewer, James, of Worcester, Worcs, brewer 4
5048798 2371276 2371276 defendant Watys John grasier 780768 780768 Watys, John, of Worcester, Worcs, grasier 1
5050371 2371734 2371734 defendant Knotte John gent 780768 780768 Knotte, John, of Worcester, Worcs, gent 1
5146050 2399969 2399969 defendant Bray Richard   780768 780768 Bray, Richard, of Worcester, Worcs, surgeon 1
5146935 2400245 2400245 defendant Whateley Thomas butcher 780768 780768 Whateley, Thomas, of Worcester, Worcs, butcher 0
5147178 2400313 2400313 defendant Hale Thomas walker 780768 780768 Hale, Thomas, of Worcester, Worcs, walker 0
5148884 2400798 2400798 defendant Howeton Richard chapman 780768 780768 Howeton, Richard, of Worcester, Worcs, chapman 0
5155032 2402626 2402626 defendant Clyff William gent 780768 780768 Clyff, William, of Worcester, Worcs, gent 4
5166840 2406030 2406030 defendant Whateley Thomas butcher 780768 780768 Whateley, Thomas, of Worcester, Worcs, butcher 0
5166974 2406073 2406073 defendant Hale Thomas walker 780768 780768 Hale, Thomas, of Worcester, Worcs, walker 0
5171826 2407478 2407478 defendant Clyff William gent 780768 780768 Clyff, William, of Worcester, Worcs, gent 4
5180027 2409893 2409893 defendant Coke John hosier 780768 780768 Coke, John, of Worcester, Worcs, hosier 0
5181946 2410470 2410470 defendant Whateley Thomas butcher 780768 780768 Whateley, Thomas, of Worcester, Worcs, butcher 0
5181948 2410471 2410471 defendant Whateley Thomas butcher 780768 780768 Whateley, Thomas, of Worcester, Worcs, butcher 0
5182167 2410536 2410536 defendant Hale Thomas   780768 780768 Hale, Thomas, of Worcester, Worcs, walerk 0
5182169 2410537 2410537 defendant Hale Thomas walker 780768 780768 Hale, Thomas, of Worcester, Worcs, walker 0
5185646 2411552 2411552 defendant Holshep John tanner 780768 780768 Holshep, John, of Worcester, Worcs, tanner 3
5188003 2412198 2412198 defendant Howeton Richard yeoman 780768 780768 Howeton, Richard, of Worcester, Worcs, yeoman 0
5190571 2412988 2412988 defendant Clyff William gent 780768 780768 Clyff, William, of Worcester, Worcs, gent 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);