names

84 rows where place_id = 678404

✎ 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
3664978 1914990 1914990 defendant Fydeler Simons   678404 678404 Fydeler, Simons, of Leeds yeoman 0
3968525 2013624 2013624 defendant Symson Richard   678404 678404 Symson, Richard, of Leeds, linen draper or chapman 1
4031212 2035833 2035833 defendant Bunbye Thomas clothier 678404 678404 Bunbye, Thomas, of Leeds, clothier 0
4031213 2035833 2035833 defendant Browne Robert clothier 678404 678404 Browne, Robert, of Leeds, clothier 1
4033528 2036646 2036646 defendant Allen Alexander draper 678404 678404 Allen, Alexander, of Leeds, draper 3
4033529 2036646 2036646 defendant Fawkyngham John gent 678404 678404 Fawkyngham, John, of Leeds, gent 4
4033530 2036646 2036646 defendant Ambler Thomas clothier 678404 678404 Ambler, Thomas, of Leeds, clothier 5
4042945 2039952 2039952 defendant Sympson William clothier 678404 678404 Sympson, William, of Leeds, clothier 1
4047588 2041587 2041587 defendant Jeffrey William clothier 678404 678404 Jeffrey, William, of Leeds, clothier 1
4047589 2041587 2041587 defendant Beane Robert clothier 678404 678404 Beane, Robert, of Leeds, clothier 2
4064156 2047456 2047456 defendant Leadbetter Christopher husbandman 678404 678404 Leadbetter, Christopher, of Leeds, husbandman 0
4066127 2048173 2048173 defendant Kendall Thomas shoemaker 678404 678404 Kendall, Thomas, of Leeds, shoemaker 2
4070316 2049677 2049677 defendant Myers Thomas laborer 678404 678404 Myers, Thomas, of Leeds, laborer 0
4070317 2049677 2049677 defendant Smyth Hugh laborer 678404 678404 Smyth, Hugh, of Leeds, laborer 1
4070318 2049677 2049677 defendant Stable   laborer 678404 678404 Stable, , of Leeds, laborer 2
4224985 2104207 2104207 defendant Waters James butcher 678404 678404 Waters, James, of Leeds, butcher 2
4292647 2127434 2127434 defendant Styles Robert yeoman 678404 678404 Styles, Robert, of Leeds, yeoman 0
4293559 2127758 2127758 defendant Ambler George yeoman 678404 678404 Ambler, George, of Leeds, yeoman 0
4296835 2128967 2128967 defendant Ambler George yeoman 678404 678404 Ambler, George, of Leeds, yeoman 0
4312243 2134418 2134418 defendant Ambler George   678404 678404 Ambler, George, of Leeds gent 2
4316873 2136018 2136018 defendant Wayde Richard clothier 678404 678404 Wayde, Richard, of Leeds, clothier 2
4316874 2136018 2136018 defendant Rodley William clothier 678404 678404 Rodley, William, of Leeds, clothier 3
4320435 2137245 2137245 defendant Tenche Randolph dyer 678404 678404 Tenche, Randolph, of Leeds, dyer 0
4322119 2137815 2137815 defendant Cochenbury Thomas tailor 678404 678404 Cochenbury, Thomas, of Leeds, tailor 1
4322445 2137919 2137919 defendant Metcalfe alias Walker John chapman 678404 678404 Metcalfe alias Walker, John, of Leeds, chapman 0
4388019 2160622 2160622 defendant Mawson John yeoman 678404 678404 Mawson, John, of Leeds, yeoman 1
4397710 2163811 2163811 defendant Oldrede Richard chapman 678404 678404 Oldrede, Richard, of Leeds, chapman 0
4400384 2164723 2164723 defendant Gregg Robert clothier 678404 678404 Gregg, Robert, of leeds, clothier 2
4406254 2166656 2166656 defendant Foster George yeoman 678404 678404 Foster, George, of Leeds, yeoman 0
4406776 2166835 2166835 defendant Walker John chapman 678404 678404 Walker, John, of Leeds, chapman 0
4415590 2169755 2169755 defendant Wayt Thomas   678404 678404 Wayt, Thomas, of Leeds 0
4529939 2209656 2209656 plaintiff Neuton John de   678404 678404 Neuton, John de, of Leeds 0
4548181 2215371 2215371 defendant German Henry   678404 678404 German, Henry, of Leeds 0
4564966 2220610 2220610 defendant Kilnesse John   678404 678404 Kilnesse, John, of Leeds 0
4574102 2223424 2223424 defendant Swerdesliper William   678404 678404 Swerdesliper, William, of Leeds 0
4586848 2227286 2227286 defendant Scrivayn Thomas   678404 678404 Scrivayn, Thomas, of Leeds 0
4698738 2265088 2265088 defendant Rome Peter gent 678404 678404 Rome, Peter, of Leeds, gent 0
4698864 2265127 2265127 plaintiff Dene John smith 678404 678404 Dene, John, of Leeds, smith 0
4698867 2265127 2265127 defendant Cok Robert   678404 678404 Cok, Robert, of Leeds , tanner, Keneworth, of Harrietsham, inland fish seller 2
4698868 2265128 2265128 plaintiff Dene John   678404 678404 Dene, John, of Leeds 0
4701963 2266022 2266022 defendant Rome Peter gent 678404 678404 Rome, Peter, of Leeds, gent 0
4715774 2270252 2270252 defendant Fourneys John yeoman 678404 678404 Fourneys, John, of Leeds, yeoman 0
4737966 2276980 2276980 defendant Fournes John yeoman 678404 678404 Fournes, John, of Leeds, yeoman 1
4755696 2282164 2282164 defendant Wode Thomas draper 678404 678404 Wode, Thomas, of Leeds, draper 1
4763465 2284558 2284558 defendant Passelewe Robert esq 678404 678404 Passelewe, Robert, of Leeds, esq 2
4807068 2298409 2298409 defendant Surynden John   678404 678404 Surynden, John, of Leeds, Kent, prior 0
4815242 2300878 2300878 defendant Mundevyle Robert yeoman 678404 678404 Mundevyle, Robert, of Leeds, yeoman 3
4820045 2302345 2302345 defendant Mundevyle John (legal representative) 678404 678404 Mundevyle, John, of Leeds, executors of 1
4820769 2302571 2302571 defendant Brigge John yeoman 678404 678404 Brigge, John, of Leeds, yeoman 1
4821602 2302839 2302839 defendant Mundevyll John husbandman 678404 678404 Mundevyll, John, of Leeds, husbandman 1
4824565 2303734 2303734 defendant Allerstones John dyer 678404 678404 Allerstones, John, of Leeds, dyer 1
4829020 2305118 2305118 defendant Newenham John husbandman 678404 678404 Newenham, John, of Leeds, husbandman 0
4830411 2305545 2305545 defendant Sklatter Richard slater 678404 678404 Sklatter, Richard, of Leeds, slater 2
4841403 2308846 2308846 defendant Denby John gent 678404 678404 Denby, John, of Leeds, gent 2
4841404 2308846 2308846 defendant Nicolson Robert gent 678404 678404 Nicolson, Robert, of Leeds, gent 3
4841408 2308847 2308847 defendant Denby John gent 678404 678404 Denby, John, of Leeds, gent 2
4841409 2308847 2308847 defendant Nicholson Robert gent 678404 678404 Nicholson, Robert, of Leeds, gent 3
4841918 2309006 2309006 defendant Moundevyle Robert chapman 678404 678404 Moundevyle, Robert, of Leeds, chapman 3
4929588 2335668 2335668 plaintiff Surynden John   678404 678404 Surynden, John, of Leeds, Kent, prior 0
5042412 2369338 2369338 defendant Ive Thomas laborer 678404 678404 Ive, Thomas, of Leeds, laborer 2
5042416 2369339 2369339 defendant Ive Thomas laborer 678404 678404 Ive, Thomas, of Leeds, laborer 2
5134430 2396565 2396565 defendant Fox John smith 678404 678404 Fox, John, of Leeds, smith 0
5134431 2396565 2396565 defendant Wygton John chaplain 678404 678404 Wygton, John, of Leeds, chaplain 1
5135978 2397034 2397034 defendant Frode James husbandman 678404 678404 Frode, James, of Leeds, husbandman 0
5135979 2397034 2397034 defendant Had-- Thomas husbandman 678404 678404 Had--, Thomas, of Leeds, husbandman 1
5141223 2398557 2398557 plaintiff Tyndesheved alias Tyndehed Thomas walker 678404 678404 Tyndesheved alias Tyndehed, Thomas, of Leeds, walker 0
5154305 2402418 2402418 defendant Fox John smith 678404 678404 Fox, John, of Leeds, smith 0
5154306 2402418 2402418 defendant Wygton John chaplain 678404 678404 Wygton, John, of Leeds, chaplain 1
5171416 2407366 2407366 defendant Fox Thomas smith 678404 678404 Fox, Thomas, of Leeds, smith 0
5171417 2407366 2407366 defendant Wyton John chaplain 678404 678404 Wyton, John, of Leeds, chaplain 1
5177198 2409024 2409024 defendant Tymbyll Henry yeoman 678404 678404 Tymbyll, Henry, of Leeds, yeoman 0
5189830 2412771 2412771 defendant Wygton John chaplain 678404 678404 Wygton, John, of Leeds, chaplain 0
5189832 2412772 2412772 defendant Fox Thomas smith 678404 678404 Fox, Thomas, of Leeds, smith 0
5198625 2415358 2415358 plaintiff Tyndesheved Thomas (legal representative) 678404 678404 Tyndesheved, Thomas, of Leeds, walker, executors of 0
5198629 2415358 2415358 defendant Tymbill Henry yeoman 678404 678404 Tymbill, Henry, of Leeds, yeoman 0
5207278 2417869 2417869 plaintiff Mason John   678404 678404 Mason, John, of Leeds 0
5368314 2465706 2465706 defendant Goudeherst Robert   678404 678404 Goudeherst, Robert, of Leeds, Kent, prior 0
5368322 2465708 2465708 defendant Goudeherst Robert   678404 678404 Goudeherst, Robert, of Leeds, Kent, prior 0
5368684 2465799 2465799 defendant Walker John weaver 678404 678404 Walker, John, of Leeds, weaver 1
5368689 2465800 2465800 defendant Walker Thomas weaver 678404 678404 Walker, Thomas, of Leeds, weaver 0
5368690 2465800 2465800 defendant Walker John weaver 678404 678404 Walker, John, of Leeds, weaver 1
5398596 2474659 2474659 defendant Emson Thomas yeoman 678404 678404 Emson, Thomas, of Leeds, yeoman 0
5398598 2474660 2474660 defendant Emson Thomas yeoman 678404 678404 Emson, Thomas, of Leeds, yeoman 0
5398600 2474661 2474661 defendant Emson Thomas yeoman 678404 678404 Emson, Thomas, of Leeds, yeoman 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);