names

145 rows where place_id = 590430

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601185 1868035 1868035 plaintiff Broun Robert   590430 590430 Broun, Robert, of Lichfeld 3
3602230 1868363 1868363 plaintiff Brown Robert merchant 590430 590430 Brown, Robert, of Lichfeld, merchant 0
3621698 1874325 1874325 defendant Beryhull John yeoman 590430 590430 Beryhull, John, of Lichfeld, yeoman 2
3625388 1875482 1875482 defendant Fletcher Robert tailor 590430 590430 Fletcher, Robert, of Lichfeld, tailor 0
3625389 1875482 1875482 defendant Wyrall John butcher 590430 590430 Wyrall, John, of Lichfeld, butcher 1
3691162 1923398 1923398 defendant Fryth John dyer 590430 590430 Fryth, John, of Lichfeld, dyer 2
3691163 1923398 1923398 defendant Crownyng John dyer 590430 590430 Crownyng, John, of Lichfeld, dyer 3
3691164 1923398 1923398 defendant Gunysdale Gilbert yeoman 590430 590430 Gunysdale, Gilbert, of Lichfeld, yeoman 4
3750170 1941970 1941970 plaintiff Lane Agnes dyer 590430 590430 Lane, Agnes, of Lichfeld, dyer 0
3756853 1944116 1944116 defendant Cronage John dyer 590430 590430 Cronage, John, of Lichfeld, dyer 1
3756854 1944116 1944116 defendant Dale John plumber 590430 590430 Dale, John, of Lichfeld, plumber 2
3765499 1946875 1946875 plaintiff Lane Agnes dyer 590430 590430 Lane, Agnes, of Lichfeld, dyer 0
3775643 1950130 1950130 plaintiff Borton Robert   590430 590430 Borton, Robert, of Lichfeld, notary 0
3775755 1950168 1950168 defendant Cristerson William tailor 590430 590430 Cristerson, William, of Lichfeld, tailor 1
3779536 1951325 1951325 defendant Skynner John skinner 590430 590430 Skynner, John, of Lichfeld, skinner 1
3874277 1981619 1981619 defendant Leeke John yeoman 590430 590430 Leeke, John, of Lichfeld, yeoman 0
3889347 1986669 1986669 defendant Clerke John   590430 590430 Clerke, John, of Lichfeld, "sayer" 1
3898798 1989800 1989800 defendant Shawe William capper 590430 590430 Shawe, William, of Lichfeld, capper 1
3923825 1998276 1998276 plaintiff Stonylond Richard yeoman 590430 590430 Stonylond, Richard, of Lichfeld, yeoman 0
3946040 2005690 2005690 defendant Rope Richard innholder 590430 590430 Rope, Richard, of Lichfeld, innholder 0
3947652 2006240 2006240 defendant Greysebroke Hugh blacksmith 590430 590430 Greysebroke, Hugh, of Lichfeld, blacksmith 1
3962559 2011496 2011496 defendant Slene or Sleve John fishmonger 590430 590430 Slene or Sleve, John, of Lichfeld, fishmonger 0
3964539 2012198 2012198 defendant Boulte Thomas clerk 590430 590430 Boulte, Thomas, of Lichfeld, clerk 0
3965382 2012508 2012508 defendant Blythe Geoffrey gent 590430 590430 Blythe, Geoffrey, of Lichfeld, gent 0
3968076 2013458 2013458 defendant Bellyster William yeoman 590430 590430 Bellyster, William, of Lichfeld, yeoman 3
3968206 2013506 2013506 plaintiff Chaderton John gent 590430 590430 Chaderton, John, of Lichfeld, gent 0
3968208 2013507 2013507 plaintiff Chaderton John gent 590430 590430 Chaderton, John, of Lichfeld, gent 0
3968210 2013508 2013508 plaintiff Chaderton John gent 590430 590430 Chaderton, John, of Lichfeld, gent 0
3968723 2013693 2013693 defendant Bolte Thomas clerk 590430 590430 Bolte, Thomas, of Lichfeld, clerk 0
3968914 2013752 2013752 defendant Bollarde John yeoman 590430 590430 Bollarde, John, of Lichfeld, yeoman 7
3968951 2013758 2013758 defendant Ballard John yeoman 590430 590430 Ballard, John, of Lichfeld, yeoman 11
3968952 2013758 2013758 defendant Ballard Gregory yeoman 590430 590430 Ballard, Gregory, of Lichfeld, yeoman 12
3969812 2014048 2014048 defendant Bolt Thomas clerk 590430 590430 Bolt, Thomas, of Lichfeld, clerk 0
3969982 2014098 2014098 plaintiff Crycheley James draper 590430 590430 Crycheley, James, of Lichfeld, draper 0
3969984 2014098 2014098 defendant Jennyns Simon dyer 590430 590430 Jennyns, Simon, of Lichfeld, dyer 1
3969985 2014098 2014098 defendant Hyll Thomas mercer 590430 590430 Hyll, Thomas, of Lichfeld, mercer 2
3969986 2014099 2014099 plaintiff Crycheley James draper 590430 590430 Crycheley, James, of Lichfeld, draper 0
3969989 2014099 2014099 defendant Jennyns Simon dyer 590430 590430 Jennyns, Simon, of Lichfeld, dyer 2
3969990 2014099 2014099 defendant Hyll Thomas mercer 590430 590430 Hyll, Thomas, of Lichfeld, mercer 3
3970255 2014193 2014193 defendant Plumer alias Hale Robert   590430 590430 Plumer alias Hale, Robert, of Lichfeld, surgeon 0
3970260 2014194 2014194 defendant Plumer alias Hale Robert   590430 590430 Plumer alias Hale, Robert, of Lichfeld, surgeon 0
3971079 2014438 2014438 defendant Hamersley William draper 590430 590430 Hamersley, William, of Lichfeld, draper 0
3971929 2014741 2014741 defendant Bolte Thomas clerk 590430 590430 Bolte, Thomas, of Lichfeld, clerk 0
3975495 2015997 2015997 defendant Danyell John draper 590430 590430 Danyell, John, of Lichfeld, draper 0
3975497 2015997 2015997 defendant Crecheley James draper 590430 590430 Crecheley, James, of Lichfeld, draper 2
3978071 2016906 2016906 defendant Swyfte John weaver 590430 590430 Swyfte, John, of Lichfeld, weaver 1
3978237 2016971 2016971 plaintiff Mastergent Richard mercer 590430 590430 Mastergent, Richard, of Lichfeld, mercer 0
3978239 2016972 2016972 plaintiff Mastergent Richard mercer 590430 590430 Mastergent, Richard, of Lichfeld, mercer 0
3982318 2018450 2018450 plaintiff Sale William clerk 590430 590430 Sale, William, of Lichfeld, clerk 0
3983640 2018918 2018918 defendant Kelynge John laborer 590430 590430 Kelynge, John, of Lichfeld, laborer 0
3983812 2018984 2018984 defendant Langton John gent 590430 590430 Langton, John, of Lichfeld, gent 0
3983813 2018984 2018984 defendant Langton Anne widow 590430 590430 Langton, Anne, of Lichfeld, widow 1
3983816 2018985 2018985 defendant Langton John gent 590430 590430 Langton, John, of Lichfeld, gent 0
3983817 2018985 2018985 defendant Langton Anne widow 590430 590430 Langton, Anne, of Lichfeld, widow 1
3988045 2020469 2020469 defendant Hawkes Kenelm innholder 590430 590430 Hawkes, Kenelm, of Lichfeld, innholder 0
3994451 2022770 2022770 plaintiff Colbarn Edward (legal representative) 590430 590430 Colbarn, Edward, of Lichfeld, gent, executor of 0
3994458 2022771 2022771 plaintiff Colbarn Edward (legal representative) 590430 590430 Colbarn, Edward, of Lichfeld, gent, executor of 0
3994473 2022772 2022772 plaintiff Colbarn Edward (legal representative) 590430 590430 Colbarn, Edward, of Lichfeld, gent, executor of 0
3994477 2022773 2022773 plaintiff Colbarn Edward (legal representative) 590430 590430 Colbarn, Edward, of Lichfeld, gent, executor of 0
4010108 2028382 2028382 defendant Blythe Geoffrey gent 590430 590430 Blythe, Geoffrey, of Lichfeld, gent 0
4015583 2030270 2030270 defendant Mastergent Thomas merchant 590430 590430 Mastergent, Thomas, of Lichfeld, merchant 0
4015584 2030270 2030270 defendant Snepe Michael smith 590430 590430 Snepe, Michael, of Lichfeld, smith 1
4015585 2030270 2030270 defendant Okes Hugh cordwainer 590430 590430 Okes, Hugh, of Lichfeld, cordwainer 2
4033680 2036695 2036695 defendant Wilson Hugh baker 590430 590430 Wilson, Hugh, of Lichfeld, baker 0
4033681 2036695 2036695 defendant Barbor Richard yeoman 590430 590430 together with Barbor, Richard, of Lichfeld, yeoman 1
4034494 2037008 2037008 defendant Plomer Robert yeoman 590430 590430 Plomer, Robert, of Lichfeld, yeoman 0
4036138 2037606 2037606 defendant Martyn John bookbinder 590430 590430 Martyn, John, of Lichfeld, bookbinder 0
4036140 2037607 2037607 defendant Mastergent Richard mercer 590430 590430 Mastergent, Richard, of Lichfeld, mercer 0
4037248 2037986 2037986 defendant Ilsley Humphrey gent 590430 590430 Ilsley, Humphrey, of Lichfeld, gent 1
4037251 2037987 2037987 defendant Ilsley Humphrey gent 590430 590430 Ilsley, Humphrey, of Lichfeld, gent 1
4038282 2038328 2038328 defendant Weston James gent 590430 590430 Weston, James, of Lichfeld, gent 0
4039419 2038724 2038724 plaintiff Maddocke Humphrey mercer 590430 590430 Maddocke, Humphrey, of Lichfeld, mercer 0
4050933 2042778 2042778 plaintiff Weston James gent 590430 590430 Weston, James, of Lichfeld, gent 0
4050939 2042779 2042779 plaintiff Weston James gent 590430 590430 Weston, James, of Lichfeld, gent 0
4057706 2045140 2045140 defendant Davys Richard tucker or walker 590430 590430 Davys, Richard, of Lichfeld, tucker or walker 0
4057708 2045141 2045141 defendant Davys William clerk 590430 590430 Davys, William, of Lichfeld, clerk 0
4057805 2045176 2045176 defendant Mastergent Thomas mercer 590430 590430 Mastergent, Thomas, of Lichfeld, mercer 0
4063832 2047347 2047347 defendant Plummer Isabel widow 590430 590430 Plummer, Isabel, of Lichfeld, widow 0
4063833 2047347 2047347 defendant Howmes George capper 590430 590430 Howmes, George, of Lichfeld, capper 1
4072276 2050386 2050386 plaintiff Omersley William   590430 590430 Omersley, William, of Lichfeld 0
4075717 2051621 2051621 defendant Shipton Thomas glover 590430 590430 Shipton, Thomas, of Lichfeld, glover 1
4083999 2054553 2054553 defendant Byrde John baker 590430 590430 Byrde, John, of Lichfeld, baker 1
4084000 2054553 2054553 defendant Addames John laborer 590430 590430 Addames, John, of Lichfeld, laborer 2
4146502 2076927 2076927 defendant Beacon John gent 590430 590430 Beacon, John, of Lichfeld, gent 0
4161125 2081966 2081966 defendant Miller Richard gent 590430 590430 Miller, Richard, of Lichfeld, gent 0
4186015 2090597 2090597 defendant Bagshoe George innholder 590430 590430 Bagshoe, George, of Lichfeld, innholder 0
4186017 2090598 2090598 defendant Bagshoe George innholder 590430 590430 Bagshoe, George, of Lichfeld, innholder 0
4186018 2090598 2090598 defendant Bagshoe John   590430 590430 Bagshoe, John, of Lichfeld, clerk, Master of Arts, prebendary of Lichfield Cathedral 1
4186019 2090598 2090598 defendant Bagshoe Christopher   590430 590430 Bagshoe, Christopher, of Lichfeld, clerk, Master of Arts, prebendary of Lichfield Cathedral 2
4186020 2090598 2090598 defendant Holcrofte William joiner 590430 590430 Holcrofte, William, of Lichfeld, joiner 3
4327222 2139431 2139431 defendant Clowes German yeoman 590430 590430 Clowes, German, of Lichfeld, yeoman 0
4331203 2140734 2140734 defendant Yate Peter carpenter 590430 590430 Yate, Peter, of Lichfeld, carpenter 3
4418985 2170803 2170803 plaintiff Aston Richard de clerk 590430 590430 Aston, Richard de, of Lichfeld, clerk 0
4466083 2190051 2190051 plaintiff Wysse John   590430 590430 Wysse, John, of Lichfeld, on his own account 0
4525034 2208170 2208170 plaintiff Hurst Robert   590430 590430 Hurst, Robert, of Lichfeld 0
4539857 2212729 2212729 plaintiff Walton Richard de, sen   590430 590430 Walton, Richard de, sen, of Lichfeld 0
4553810 2217116 2217116 defendant Prynce John   590430 590430 Prynce, John, of Lichfeld 0
4612576 2235000 2235000 defendant del Chaumbre Richard   590430 590430 del Chaumbre, Richard, of Lichfeld 2
4746320 2279420 2279420 plaintiff Hauley or Hanley Nicholas chaplain & sacristan of the cathedral 590430 590430 Hauley or Hanley, Nicholas, of Lichfeld, chaplain & sacristan of the cathedral 0
4871997 2318217 2318217 defendant Strangulford John mercer 590430 590430 Strangulford, John, of Lichfeld, mercer 1

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