names

90 rows where place_id = 594086

✎ 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
3614511 1872186 1872186 defendant Yevan or Yenan William chapman 594086 594086 (Yevan or Yenan, William, of Wolverhampton, Staffs, chapman 2
3617708 1873161 1873161 defendant Jurdan Richard chapman 594086 594086 Jurdan, Richard, of Wolverhampton, Staffs, chapman 3
3625800 1875607 1875607 defendant Walle Robert weaver 594086 594086 Walle, Robert, of Wolverhampton, Staffs, weaver 1
3668275 1916023 1916023 defendant Taunckys alias Tunck Humphrey mercer 594086 594086 Taunckys alias Tunck, Humphrey, of Wolverhampton, Staffs, mercer 0
3674542 1918091 1918091 plaintiff Gravener John gent 594086 594086 Gravener, John, of Wolverhampton, Staffs, gent 0
3687845 1922362 1922362 defendant Haryngton John innholder 594086 594086 Haryngton, John, of Wolverhampton, Staffs, innholder 0
3700512 1926402 1926402 defendant Moldisley or Moysley Cornelius gent 594086 594086 Moldisley or Moysley, Cornelius, of Wolverhampton, Staffs, gent 0
3722988 1933454 1933454 defendant Wall Nicholas yeoman 594086 594086 Wall, Nicholas, of Wolverhampton, Staffs, yeoman 2
3723076 1933485 1933485 defendant Wall Nicholas yeoman 594086 594086 Wall, Nicholas, of Wolverhampton, Staffs, yeoman 0
3738731 1938320 1938320 defendant Barton Ralph draper 594086 594086 Barton, Ralph, of Wolverhampton, Staffs, draper 0
3747503 1941134 1941134 defendant Bedyll Alice widow 594086 594086 Bedyll, Alice, of Wolverhampton, Staffs, widow 3
3753035 1942885 1942885 defendant Whytmer Robert merchant 594086 594086 Whytmer, Robert, of Wolverhampton, Staffs, merchant 1
3798134 1957312 1957312 defendant Luson James merchant 594086 594086 Luson, James, of Wolverhampton, Staffs, merchant 1
3802940 1958816 1958816 defendant Heylen Nicholas merchant of the staple 594086 594086 Heylen, Nicholas, of Wolverhampton, Staffs, merchant of the staple 0
3803730 1959081 1959081 defendant Rydley Richard gent 594086 594086 Rydley, Richard, of Wolverhampton, Staffs, gent 0
3809358 1960811 1960811 defendant Heylyn Nicholas merchant of the staple 594086 594086 Heylyn, Nicholas, of Wolverhampton, Staffs, merchant of the staple 0
3809753 1960940 1960940 defendant Heylyn Nicholas merchant of the staple 594086 594086 Heylyn, Nicholas, of Wolverhampton, Staffs, merchant of the staple 0
3815523 1962770 1962770 defendant Luson James merchant 594086 594086 Luson, James, of Wolverhampton, Staffs, merchant 1
3818387 1963649 1963649 defendant Falance William tanner 594086 594086 Falance, William, of Wolverhampton, Staffs, tanner 1
3833772 1968496 1968496 defendant Lewson Thomas gent 594086 594086 Lewson, Thomas, of Wolverhampton, Staffs, gent 0
3833783 1968498 1968498 defendant Lewson Thomas gent 594086 594086 Lewson, Thomas, of Wolverhampton, Staffs, gent 0
3852843 1974498 1974498 defendant Nevytt Thomas mercer 594086 594086 Nevytt, Thomas, of Wolverhampton, Staffs, mercer 0
3867358 1979315 1979315 defendant Nevyll Thomas chapman 594086 594086 Nevyll, Thomas, of Wolverhampton, Staffs, chapman 3
3867364 1979316 1979316 defendant Nevyll Thomas chapman 594086 594086 Nevyll, Thomas, of Wolverhampton, Staffs, chapman 3
3886081 1985595 1985595 defendant Broughton Richard chapman 594086 594086 Broughton, Richard, of Wolverhampton, Staffs, chapman 0
3891049 1987272 1987272 defendant Brocketoune Richard mercer 594086 594086 Brocketoune, Richard, of Wolverhampton, Staffs, mercer 0
3894715 1988438 1988438 defendant Byng James mercer 594086 594086 Byng, James, of Wolverhampton, Staffs, mercer 0
3901446 1990707 1990707 defendant Brotton Richard mercer 594086 594086 Brotton, Richard, of Wolverhampton, Staffs, mercer 0
3902387 1991030 1991030 defendant Roston Lewis yeoman 594086 594086 Roston, Lewis, of Wolverhampton, Staffs, yeoman 0
3907239 1992712 1992712 defendant Luson Thomas gent 594086 594086 Luson, Thomas, of Wolverhampton, Staffs, gent 2
3908001 1992968 1992968 defendant Rydley Richard gent 594086 594086 Rydley, Richard, of Wolverhampton, Staffs, gent 1
3909113 1993347 1993347 defendant Howelat John chapman 594086 594086 Howelat, John, of Wolverhampton, Staffs, chapman 3
3921009 1997374 1997374 defendant Muggall Elizabeth widow 594086 594086 Muggall, Elizabeth, of Wolverhampton, Staffs, widow 3
3936575 2002557 2002557 defendant Waynewright Ralph chapman 594086 594086 Waynewright, Ralph, of Wolverhampton, Staffs, chapman 0
3942644 2004548 2004548 defendant Howlett John yeoman 594086 594086 Howlett, John, of Wolverhampton, Staffs, yeoman. Wollyston, William, of Nether Penne, Staffs, yeoman 0
3946027 2005685 2005685 defendant Hygenson William yeoman 594086 594086 Hygenson, William, of Wolverhampton, Staffs, yeoman 2
3947917 2006335 2006335 defendant Waynwryght Richard yeoman or drover 594086 594086 Waynwryght, Richard, of Wolverhampton, Staffs, yeoman or drover 1
3950040 2007097 2007097 defendant Knocker Thomas chapman 594086 594086 Knocker, Thomas, of Wolverhampton, Staffs, chapman 0
3954666 2008698 2008698 plaintiff Leveson Thomas gent 594086 594086 Leveson, Thomas, of Wolverhampton, Staffs, gent 0
3956045 2009183 2009183 defendant Taylour John weaver 594086 594086 Taylour, John, of Wolverhampton, Staffs, weaver 0
3961059 2010961 2010961 defendant Knocker Thomas chapman 594086 594086 Knocker, Thomas, of Wolverhampton, Staffs, chapman 0
3962108 2011328 2011328 defendant Leveson Thomas esq 594086 594086 Leveson, Thomas, of Wolverhampton, Staffs, esq 0
3977396 2016665 2016665 plaintiff Graston or Grafton Ralph vintner 594086 594086 Graston or Grafton, Ralph, of Wolverhampton, Staffs, vintner 1
3981373 2018105 2018105 defendant Brome John cutler 594086 594086 Brome, John, of Wolverhampton, Staffs, cutler 0
4048233 2041807 2041807 defendant Grene William gent 594086 594086 Grene, William, of Wolverhampton, Staffs, gent 0
4050228 2042512 2042512 defendant Leveson John esq 594086 594086 Leveson, John, of Wolverhampton, Staffs, esq 6
4050235 2042513 2042513 defendant Leveston John esq 594086 594086 Leveston, John, of Wolverhampton, Staffs, esq 5
4059302 2045722 2045722 defendant Coxe Richard gent 594086 594086 Coxe, Richard, of Wolverhampton, Staffs, gent 2
4067994 2048860 2048860 defendant Pyrrye John tailor 594086 594086 Pyrrye, John, of Wolverhampton, Staffs, tailor 0
4090008 2056709 2056709 defendant Tarte Thomas mercer 594086 594086 Tarte, Thomas, of Wolverhampton, Staffs, mercer 0
4091156 2057126 2057126 defendant Tarte Thomas mercer 594086 594086 Tarte, Thomas, of Wolverhampton, Staffs, mercer 0
4111148 2064241 2064241 defendant Waynwright William laborer 594086 594086 Waynwright, William, of Wolverhampton, Staffs, laborer 2
4112228 2064631 2064631 defendant Tarte Thomas chapman 594086 594086 Tarte, Thomas, of Wolverhampton, Staffs, chapman 2
4131187 2071474 2071474 defendant Grafton James gent 594086 594086 Grafton, James, of of Wolverhampton, Staffs, gent 0
4227070 2104942 2104942 defendant Gyfford Richard gent 594086 594086 Gyfford, Richard, of Wolverhampton, Staffs, gent 0
4255015 2114670 2114670 defendant Gyfford Richard gent 594086 594086 Gyfford, Richard, of Wolverhampton, Staffs, gent 0
4262089 2116994 2116994 defendant Mason William fishmonger 594086 594086 Mason, William, of Wolverhampton, Staffs, fishmonger 2
4266478 2118436 2118436 defendant Greene William gent 594086 594086 Greene, William, of Wolverhampton, Staffs, gent 1
4273000 2120530 2120530 defendant Mason William fishmonger 594086 594086 Mason, William, of Wolverhampton, Staffs, fishmonger 2
4374261 2155863 2155863 defendant Wottesley or Wrotesley Thomas gent 594086 594086 Wottesley or Wrotesley, Thomas, of Wolverhampton, Staffs, gent 0
4377033 2156858 2156858 defendant Burton James clerk 594086 594086 Burton, James, of Wolverhampton, Staffs, clerk 0
4380106 2157988 2157988 defendant Heathe William miller 594086 594086 Heathe, William, of Wolverhampton, Staffs, miller 2
4410206 2168015 2168015 defendant Mason Thomas yeoman 594086 594086 Mason, Thomas, of Wolverhampton, Staffs, yeoman 0
4689994 2262422 2262422 defendant Wynde Clement clerk 594086 594086 Wynde, Clement, of Wolverhampton, Staffs, clerk 3
4746085 2279353 2279353 defendant Jurdan Clement husbandman 594086 594086 Jurdan, Clement, of Wolverhampton, Staffs, husbandman 0
4758084 2282901 2282901 defendant Broun Robert baker 594086 594086 Broun, Robert, of Wolverhampton, Staffs, baker 1
4879207 2320433 2320433 defendant Coke William chapman 594086 594086 Coke, William, of Wolverhampton, Staffs, chapman 0
4895420 2325230 2325230 defendant Benet Thomas mercer 594086 594086 Benet, Thomas, of Wolverhampton, Staffs, mercer 3
4995840 2355602 2355602 defendant Tolle Reginald gent 594086 594086 Tolle, Reginald, of Wolverhampton, Staffs, gent 1
5010689 2359992 2359992 defendant Leuesson Nicholas gent 594086 594086 Leuesson, Nicholas, of Wolverhampton, Staffs, gent 1
5010731 2359998 2359998 defendant Waryng Nicholas esq 594086 594086 Waryng, Nicholas, of Wolverhampton, Staffs, esq 0
5010771 2360004 2360004 defendant Waryng Nicholas esq 594086 594086 Waryng, Nicholas, of Wolverhampton, Staffs, esq 0
5029271 2365438 2365438 defendant Burnell Thomas hardwareman 594086 594086 Burnell, Thomas, of Wolverhampton, Staffs, hardwareman 2
5232895 2425206 2425206 defendant Leson Isabel widow 594086 594086 Leson, Isabel, of Wolverhampton, Staffs, widow 0
5232897 2425207 2425207 defendant Leson Isabel widow 594086 594086 Leson, Isabel, of Wolverhampton, Staffs, widow 0
5345728 2458809 2458809 defendant Thomson John chapman 594086 594086 Thomson, John, of Wolverhampton, Staffs, chapman 0
5345751 2458811 2458811 defendant Marchall Joan widow 594086 594086 Marchall, Joan, of Wolverhampton, Staffs, widow 10
5521379 2511503 2511503 defendant Yewan William chapman 594086 594086 Yewan, William, of Wolverhampton, Staffs, chapman 0
5535839 2515714 2515714 defendant Bynge William tanner 594086 594086 Bynge, William, of Wolverhampton, Staffs, tanner 2
5539430 2516820 2516820 defendant Evans Robert merchant 594086 594086 Evans, Robert, of Wolverhampton, Staffs, merchant 2
5552124 2520665 2520665 defendant Evans Richard merchant of the staple 594086 594086 Evans, Richard, of Wolverhampton, Staffs, merchant of the staple 0
5552129 2520666 2520666 defendant Marche Thomas yeoman 594086 594086 Marche, Thomas, of Wolverhampton, Staffs, yeoman 0
5556008 2521752 2521752 defendant Evans Richard merchant of the staple 594086 594086 Evans, Richard, of Wolverhampton, Staffs, merchant of the staple 0
5556010 2521753 2521753 defendant FitzHerbert John gent 594086 594086 FitzHerbert, John, of Wolverhampton, Staffs, gent 0
5563774 2524014 2524014 defendant Lyveson Walter gent 594086 594086 Lyveson, Walter, of Wolverhampton, Staffs, gent 0
5564970 2524341 2524341 defendant Ridley Nicholas gent 594086 594086 Ridley, Nicholas, of Wolverhampton, Staffs, gent 0
5574670 2527153 2527153 plaintiff Rydley Owen (legal representative) 594086 594086 Rydley, Owen, of Wolverhampton, Staffs, merchant, administrator of 0
5578916 2528475 2528475 defendant Bynger William yeoman 594086 594086 Bynger, William, of Wolverhampton, Staffs, yeoman 0
5600870 2535158 2535158 defendant Honyman Thomas husbandman 594086 594086 Honyman, Thomas, of Wolverhampton, Staffs, husbandman 0
5623879 2551417 2551417 defendant Goter John drover 594086 594086 Goter, John, of Wolverhampton, Staffs, drover 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);