names

174 rows where place_id = 654403

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667238 1915689 1915689 plaintiff Wilford Edmund (legal representative) 654403 654403 Wilford, Edmund, of Lichfield, prebendary of Wolney below the cathedral church of Lichfeld, executors of 0
3667242 1915690 1915690 plaintiff Wilford Edmund (legal representative) 654403 654403 Wilford, Edmund, of Lichfield, prebendary of Wolney below the cathedral church of Lichfeld, executors of 0
3931847 2000949 2000949 plaintiff Stonyng Gregory   654403 654403 Stonyng, Gregory, of Lichfield, Bachelor of Civil Law 1
3932251 2001093 2001093 plaintiff Fletcher Richard   654403 654403 Fletcher, Richard, of Lichfield 0
3950137 2007130 2007130 defendant Cleyton Nicholas clerk 654403 654403 Cleyton, Nicholas, of Lichfield, clerk 0
3991496 2021714 2021714 defendant Maistergent Richard draper 654403 654403 Maistergent, Richard, of Lichfield, draper 0
4007750 2027556 2027556 plaintiff Mastergent Richard   654403 654403 Mastergent, Richard, of Lichfield 0
4016388 2030561 2030561 defendant Colt Thomas clerk 654403 654403 Colt, Thomas, of Lichfield, clerk 0
4049917 2042401 2042401 defendant Boult Thomas clerk 654403 654403 Boult, Thomas, of Lichfield, clerk 0
4066594 2048348 2048348 defendant Bagshawe George vintner 654403 654403 Bagshawe, George, of Lichfield, vintner 0
4083548 2054390 2054390 defendant Slyn John chapman 654403 654403 Slyn, John, of Lichfield, chapman 0
4083998 2054553 2054553 defendant Bird Nicholas baker 654403 654403 Bird, Nicholas, of Lichfield, baker 0
4098966 2059954 2059954 defendant Dawes George baker 654403 654403 Dawes, George, of Lichfield, baker 1
4103685 2061595 2061595 defendant Johnson John capper 654403 654403 Johnson, John, of Lichfield, capper 2
4108722 2063374 2063374 defendant Ilsley Thomas gent 654403 654403 Ilsley, Thomas, of Lichfield, gent 1
4108723 2063374 2063374 defendant Dawes George baker 654403 654403 Dawes, George, of Lichfield, baker 2
4120839 2067740 2067740 defendant Hawk Kenelm yeoman 654403 654403 Hawk, Kenelm, of Lichfield, yeoman 0
4126135 2069638 2069638 defendant Bailye John capper 654403 654403 Bailye, John, of Lichfield, capper 0
4147606 2077304 2077304 defendant Weston Richard gent 654403 654403 Weston, Richard, of Lichfield, gent 0
4147607 2077304 2077304 defendant More John capper 654403 654403 More, John, of Lichfield, capper 1
4149398 2077917 2077917 defendant Bagshawe George innholder 654403 654403 Bagshawe, George, of Lichfield, yeoman, innholder 0
4149814 2078063 2078063 defendant Weston James gent 654403 654403 Weston, James, of Lichfield, gent 0
4155035 2079851 2079851 defendant Parkyns Roger tanner 654403 654403 Parkyns, Roger, of Lichfield, tanner 0
4159726 2081470 2081470 defendant Becon John gent 654403 654403 Becon, John, of Lichfield, gent 0
4173685 2086250 2086250 defendant Plysted Thomas esq 654403 654403 Plysted, Thomas, of Lichfield, esq 0
4174665 2086608 2086608 defendant Weston James gent 654403 654403 Weston, James, of Lichfield, gent 0
4186347 2090711 2090711 defendant Babyngton Zachary   654403 654403 Babyngton, Zachary, of Lichfield, gent, chancelor 0
4186348 2090711 2090711 defendant Ayre Thomas gent 654403 654403 Ayre, Thomas, of Lichfield, gent 1
4186571 2090786 2090786 defendant Streathay Philip gent 654403 654403 Streathay, Philip, of Lichfield, gent 0
4187601 2091166 2091166 defendant Omersley William vintner 654403 654403 Omersley, William, of Lichfield, vintner 0
4191647 2092635 2092635 defendant Babyngton Zachary   654403 654403 Babyngton, Zachary, of Lichfield, esq, Chancellor of Lichfield, Staffs 1
4191648 2092635 2092635 defendant Rowlson Richard gent 654403 654403 Rowlson, Richard, of Lichfield, gent 2
4205129 2097341 2097341 defendant Rede John draper 654403 654403 Rede, John, of Lichfield, draper 0
4207367 2098130 2098130 defendant Babyngton Mathew gent 654403 654403 Babyngton, Mathew, of Lichfield, gent 0
4207952 2098341 2098341 defendant Babington Zachary gent 654403 654403 Babington, Zachary, of Lichfield, gent 0
4221645 2103059 2103059 defendant Harsall Thomas butcher 654403 654403 Harsall, Thomas, of Lichfield, butcher 0
4222787 2103460 2103460 defendant Berdesley William saddler 654403 654403 Berdesley, William, of Lichfield, saddler 0
4226416 2104710 2104710 defendant Clowes Germanus husbandman 654403 654403 Clowes, Germanus, of Lichfield, husbandman 1
4258560 2115830 2115830 defendant Babyngton Zachary   654403 654403 Babyngton, Zachary, of Lichfield, gent, Chancellor of Lichfield, Staffs 0
4271500 2120048 2120048 defendant Slany Richard clerk 654403 654403 Slany, Richard, of Lichfield, clerk 0
4285814 2124978 2124978 defendant Dyett John clerk 654403 654403 Dyett, John, of Lichfield, clerk 0
4316040 2135723 2135723 defendant Illesley George yeoman 654403 654403 Illesley, George, of Lichfield, yeoman 0
4322375 2137897 2137897 defendant Berdesley William saddler 654403 654403 Berdesley, William, of Lichfield, saddler 0
4324732 2138664 2138664 defendant Hurleston Richard gent 654403 654403 Hurleston, Richard, of Lichfield, gent 2
4326591 2139253 2139253 defendant Androwes Francis saltpeterman 654403 654403 Androwes, Francis, of Lichfield, saltpeterman 1
4328345 2139797 2139797 defendant Offeild William   654403 654403 Offeild, William, of Lichfield, yeoman, sergeant 0
4330185 2140397 2140397 defendant Pilkyngton Oliver yeoman 654403 654403 Pilkyngton, Oliver, of Lichfield, yeoman 0
4334524 2141820 2141820 defendant Freceston James tailor 654403 654403 Freceston, James, of Lichfield, tailor 1
4336057 2142346 2142346 defendant Marshall or Martiall Thomas draper 654403 654403 Marshall or Martiall, Thomas, of Lichfield, draper 0
4342877 2144782 2144782 defendant Byddulpe Thomas yeoman 654403 654403 Byddulpe, Thomas, of Lichfield, yeoman 0
4349559 2147107 2147107 defendant Johnson Jerome mercer 654403 654403 Johnson, Jerome, of Lichfield, mercer 0
4349560 2147107 2147107 defendant Lowe Humphrey gent 654403 654403 Lowe, Humphrey, of Lichfield, gent 1
4353161 2148334 2148334 defendant Hawcrofte William innholder 654403 654403 Hawcrofte, William, of Lichfield, innholder 0
4356151 2149373 2149373 defendant Hawcrett William innholder 654403 654403 Hawcrett, William, of Lichfield, innholder 0
4356709 2149575 2149575 defendant Babington Zachary clerk 654403 654403 Babington, Zachary, of Lichfield, clerk 0
4362360 2151592 2151592 defendant Walford Nicholas yeoman 654403 654403 (Walford, Nicholas, of Lichfield, yeoman 1
4362361 2151592 2151592 defendant Newton William yeoman 654403 654403 Newton, William, of Lichfield, yeoman 2
4382088 2158696 2158696 defendant Johnson Jeremiah chapman 654403 654403 Johnson, Jeremiah, of Lichfield, chapman 0
4388425 2160765 2160765 defendant Beardesley William saddler 654403 654403 Beardesley, William, of Lichfield, saddler 0
4391197 2161673 2161673 defendant Rawlinson Leonard chapman 654403 654403 Rawlinson, Leonard, of Lichfield, chapman 0
4405979 2166564 2166564 defendant Babington Zachary gent 654403 654403 Babington, Zachary, of Lichfield, gent 0
4414879 2169554 2169554 defendant Turvill Ralph (legal representative) 654403 654403 Turvill, Ralph, of Lichfield, master, clerk & formerly canon in the church, executors of 0
4439432 2181597 2181597 plaintiff Taverner Adomarus   654403 654403 Taverner, Adomarus, of Lichfield 3
4441421 2182259 2182259 plaintiff Botelesham Nicholas de master & canon 654403 654403 Botelesham, Nicholas de, of Lichfield, master & canon 0
4443669 2182987 2182987 plaintiff Chaloner Roger   654403 654403 Chaloner, Roger, of Lichfield 0
4450426 2185095 2185095 plaintiff (not given) Henry vicar of Swan 654403 654403 Swan, Henry, of Lichfield, perpetual vicar of the cathedral church 1
4465614 2189920 2189920 defendant Bormleye Henry   654403 654403 Bormleye, Henry, of Lichfield 0
4474878 2192810 2192810 defendant Browe Ralph   654403 654403 Browe, Ralph, of Lichfield 0
4490858 2197838 2197838 defendant Swyft Roger   654403 654403 Swyft, Roger, of Lichfield 4
4491002 2197880 2197880 defendant Colshull Robert de   654403 654403 Colshull, Robert de, of Lichfield 0
4491580 2198051 2198051 plaintiff Wisse John   654403 654403 Wisse, John, of Lichfield 0
4512493 2204350 2204350 plaintiff Bower Richard   654403 654403 Bower, Richard, of Lichfield 0
4516870 2205679 2205679 defendant Hampsted John   654403 654403 Hampsted, John, of Lichfield 3
4529929 2209651 2209651 defendant del Hurst Robert   654403 654403 del Hurst, Robert, of Lichfield 0
4529931 2209652 2209652 defendant del Hurst Robert   654403 654403 del Hurst, Robert, of Lichfield 0
4538616 2212355 2212355 plaintiff Trumper John   654403 654403 Trumper, John, of Lichfield 0
4542071 2213412 2213412 plaintiff Wysse Thomas   654403 654403 Wysse, Thomas, of Lichfield 0
4561016 2219397 2219397 defendant Rous John   654403 654403 Rous, John, of Lichfield 3
4562333 2219780 2219780 defendant Reynaldes John chapman 654403 654403 Reynaldes, John, of Lichfield, chapman 0
4568849 2221840 2221840 defendant Rydware Robert   654403 654403 Rydware, Robert, of Lichfield, son of Roger 2
4594041 2229399 2229399 plaintiff Pety John   654403 654403 Pety, John, of Lichfield 0
4594042 2229399 2229399 defendant Othehurst Robert   654403 654403 Othehurst, Robert, of Lichfield 0
4597092 2230335 2230335 plaintiff (not given) Thomas prior of Seggesley 654403 654403 Seggesley, Thomas, of Lichfield, prior of the hospital of St John Baptist 0
4612570 2234998 2234998 defendant Dewesbury William   654403 654403 Dewesbury, William, of Lichfield 0
4619949 2237220 2237220 defendant Porter Thomas   654403 654403 Porter, Thomas, of Lichfield 1
4623445 2238307 2238307 plaintiff Merford Robert chaplain cantor in the cathedral church 654403 654403 Merford, Robert, of Lichfield, chaplain cantor in the cathedral church 0
4628929 2239979 2239979 defendant Rous John   654403 654403 Rous, John, of Lichfield 1
4636171 2242146 2242146 defendant Cole William mercer 654403 654403 Cole, William, of Lichfield, mercer 0
4637901 2242622 2242622 defendant Aylesbury Thomas   654403 654403 Aylesbury, Thomas, of Lichfield 2
4641009 2243465 2243465 defendant Worsley Richard   654403 654403 Worsley, Richard, of Lichfield 1
4643996 2244342 2244342 defendant Chaumbre Richard   654403 654403 Chaumbre, Richard, of Lichfield 4
4645445 2244735 2244735 defendant del Hurst Robert   654403 654403 del Hurst, Robert, of Lichfield 0
4645514 2244757 2244757 defendant del Hurst Robert   654403 654403 del Hurst, Robert, of Lichfield 0
4645515 2244757 2244757 defendant atte Yate John   654403 654403 atte Yate, John, of Lichfield 1
4645516 2244757 2244757 defendant Shermon William   654403 654403 Shermon, William, of Lichfield 2
4645517 2244757 2244757 defendant Fourbour Robert   654403 654403 Fourbour, Robert, of Lichfield 3
4645520 2244758 2244758 defendant Wolsley Richard hewster 654403 654403 Wolsley, Richard, of Lichfield, hewster 1
4647658 2245370 2245370 plaintiff Skynner Richard   654403 654403 Skynner, Richard, of Lichfield 0
4648253 2245550 2245550 defendant Bromley William   654403 654403 Bromley, William, of Lichfield 3
4650310 2246108 2246108 defendant Huyntes Thomas   654403 654403 Huyntes, Thomas, of Lichfield 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);