names

232 rows where place_id = 587788

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592435 1865248 1865248 defendant Lumbard Thomas butcher 587788 587788 Lumbard, Thomas, of Ledbury, butcher 0
3592437 1865249 1865249 defendant Lumbard Thomas butcher 587788 587788 Lumbard, Thomas, of Ledbury, butcher 0
3604230 1868988 1868988 defendant Colyer Hugh husbandman 587788 587788 Colyer, Hugh, of Ledbury, husbandman 0
3604231 1868988 1868988 defendant Lumbard John husbandman 587788 587788 Lumbard, John, of Ledbury, husbandman 1
3604236 1868989 1868989 defendant Lumbard Thomas butcher 587788 587788 Lumbard, Thomas, of Ledbury, butcher 0
3604237 1868989 1868989 defendant Lumbard William yeoman 587788 587788 Lumbard, William, of Ledbury, yeoman 1
3604238 1868989 1868989 defendant Byrcheley John husbandman 587788 587788 Byrcheley, John, of Ledbury, husbandman 2
3606249 1869621 1869621 defendant Lumbard Thomas butcher 587788 587788 Lumbard, Thomas, of Ledbury, butcher 0
3619761 1873754 1873754 defendant Geram Thomas tailor 587788 587788 Geram, Thomas, of Ledbury, tailor 3
3620162 1873883 1873883 defendant Geram Thomas tailor 587788 587788 Geram, Thomas, of Ledbury, tailor 3
3621940 1874406 1874406 defendant Serche Richard butcher 587788 587788 Serche, Richard, of Ledbury, butcher 0
3628388 1903744 1903744 defendant Bradford John husbandman 587788 587788 Bradford, John, of Ledbury, husbandman 1
3642368 1908060 1908060 defendant Bradford John husbandman 587788 587788 Bradford, John, of Ledbury, husbandman 1
3675919 1918506 1918506 defendant Hyll alias Spycer Thomas mercer 587788 587788 Hyll alias Spycer, Thomas, of Ledbury, mercer 0
3685024 1921458 1921458 defendant Gutto Thomas yeoman 587788 587788 Gutto, Thomas, of Ledbury, yeoman 0
3687071 1922130 1922130 defendant Beryton Thomas tailor 587788 587788 Beryton, Thomas, of Ledbury, tailor 0
3687867 1922368 1922368 defendant Keyse Thomas husbandman 587788 587788 Keyse, Thomas, of Ledbury, husbandman 0
3690707 1923261 1923261 defendant Lormer Thomas husbandman 587788 587788 Lormer, Thomas, of Ledbury, husbandman 0
3728648 1935197 1935197 defendant Vuet Thomas gent 587788 587788 Vuet, Thomas, of Ledbury, gent 0
3729635 1935518 1935518 defendant Syblyes Henry husbandman 587788 587788 Syblyes, Henry, of Ledbury, husbandman 1
3736257 1937579 1937579 defendant Tailour Richard husbandman 587788 587788 Tailour, Richard, of Ledbury, husbandman 1
3755057 1943531 1943531 defendant Benett Roger yeoman 587788 587788 Benett, Roger, of Ledbury, yeoman 2
3757316 1944267 1944267 defendant Wore John husbandman 587788 587788 Wore, John, of Ledbury, husbandman 1
3764012 1946387 1946387 defendant Willyes Thomas butcher 587788 587788 Willyes, Thomas, of Ledbury, butcher 1
3777432 1950690 1950690 defendant Hyll Thomas husbandman 587788 587788 Hyll, Thomas, of Ledbury, husbandman 0
3777434 1950691 1950691 defendant Spycer Thomas mercer 587788 587788 Spycer, Thomas, of Ledbury, mercer 0
3788356 1954158 1954158 defendant Adkoke John barber 587788 587788 Adkoke, John, of Ledbury, barber 0
3788357 1954158 1954158 defendant Keyse Thomas husbandman 587788 587788 Keyse, Thomas, of Ledbury, husbandman 1
3788359 1954158 1954158 defendant Ferett John husbandman 587788 587788 Ferett, John, of Ledbury, husbandman 3
3799241 1957676 1957676 defendant Seblys Henry husbandman 587788 587788 Seblys, Henry, of Ledbury, husbandman 2
3821662 1964661 1964661 defendant Tayler James husbandman 587788 587788 Tayler, James, of Ledbury, husbandman 0
3868428 1979678 1979678 defendant Glover Gilbert glover 587788 587788 Glover, Gilbert, of Ledbury, glover 0
3869317 1979979 1979979 defendant Pole John husbandman 587788 587788 Pole, John, of Ledbury, husbandman 0
3881926 1984212 1984212 defendant Walker Robert husbandman 587788 587788 Walker, Robert, of Ledbury, husbandman 0
3896092 1988895 1988895 defendant Hayward Edward yeoman 587788 587788 Hayward, Edward, of Ledbury, yeoman 0
3906001 1992292 1992292 defendant Skynner William husbandman 587788 587788 Skynner, William, of Ledbury, husbandman 3
3939644 2003566 2003566 defendant Bucknyll John mercer 587788 587788 (Bucknyll, John, of Ledbury, mercer 1
3943481 2004836 2004836 defendant Horlam Thomas husbandman 587788 587788 Horlam, Thomas, of Ledbury, husbandman 0
3943483 2004837 2004837 defendant Okey John butcher 587788 587788 Okey, John, of Ledbury, butcher 0
3945152 2005398 2005398 defendant Buckenhyll John yeoman 587788 587788 Buckenhyll, John, of Ledbury, yeoman 0
3950643 2007299 2007299 plaintiff Gatley Thomas tailor 587788 587788 Gatley, Thomas, of Ledbury, tailor 0
3961183 2011005 2011005 defendant Snokley William yeoman 587788 587788 Snokley, William, of Ledbury, yeoman 0
3977155 2016579 2016579 plaintiff Lawrence William   587788 587788 Lawrence, William, of Ledbury 0
3987346 2020224 2020224 defendant Skynner John yeoman 587788 587788 Skynner, John, of Ledbury, yeoman 0
3987347 2020224 2020224 defendant Lorymer John yeoman 587788 587788 Lorymer, John, of Ledbury, yeoman 1
3987348 2020224 2020224 defendant Clerke Henry yeoman 587788 587788 Clerke, Henry, of Ledbury, yeoman 2
3987350 2020225 2020225 defendant Skynner John yeoman 587788 587788 Skynner, John, of Ledbury, yeoman 0
3987351 2020225 2020225 defendant Lorymer John yeoman 587788 587788 Lorymer, John, of Ledbury, yeoman 1
3987352 2020225 2020225 defendant Clerke Henry yeoman 587788 587788 Clerke, Henry, of Ledbury, yeoman 2
3998005 2024046 2024046 plaintiff Estons Evan tailor 587788 587788 Estons, Evan, of Ledbury, tailor 0
4004818 2026501 2026501 defendant Dyke John yeoman 587788 587788 Dyke, John, of Ledbury, yeoman 0
4004820 2026502 2026502 defendant Dyke John yeoman 587788 587788 Dyke, John, of Ledbury, yeoman 0
4024054 2033304 2033304 defendant Drewe Richard tailor 587788 587788 Drewe, Richard, of Ledbury, tailor 0
4029662 2035247 2035247 defendant Duke John mercer 587788 587788 Duke, John, of Ledbury, mercer 0
4029664 2035248 2035248 defendant Dyke John mercer 587788 587788 Dyke, John, of Ledbury, mercer 0
4030725 2035652 2035652 plaintiff Elton William   587788 587788 Elton, William, of Ledbury, yeoman, administrators of 0
4030727 2035652 2035652 defendant Fyrrett Thomas (legal representative) 587788 587788 Fyrrett, Thomas, of Ledbury, husbandman, executrix of 0
4030728 2035652 2035652 defendant Fyrrett Christian widow 587788 587788 Fyrrett, Christian, of Ledbury, widow 1
4031069 2035784 2035784 plaintiff Farmer Edward tanner 587788 587788 Farmer, Edward, of Ledbury, tanner 0
4036599 2037772 2037772 defendant Wyllys Hugh yeoman 587788 587788 Wyllys, Hugh, of Ledbury, yeoman 1
4039024 2038580 2038580 plaintiff Lorymer John smith 587788 587788 Lorymer, John, of Ledbury, smith 0
4041653 2039508 2039508 plaintiff Northen John cordwainer 587788 587788 Northen, John, of Ledbury, cordwainer 0
4041654 2039508 2039508 defendant Clynton John gent 587788 587788 Clynton, John, of Ledbury, gent 0
4043632 2040181 2040181 defendant Harford Richard yeoman 587788 587788 Harford, Richard, of Ledbury, yeoman 0
4043633 2040181 2040181 defendant Harford George yeoman 587788 587788 Harford, George, of Ledbury, yeoman 1
4043634 2040181 2040181 defendant Comedowe William yeoman 587788 587788 Comedowe, William, of Ledbury, yeoman 2
4045056 2040686 2040686 defendant Fyrrett John yeoman 587788 587788 Fyrrett, John, of Ledbury, yeoman 0
4048529 2041925 2041925 defendant Dyke John mercer 587788 587788 Dyke, John, of Ledbury, mercer 0
4049503 2042267 2042267 plaintiff Unet or Vuet Thomas gent 587788 587788 Unet or Vuet, Thomas, of Ledbury, gent 0
4052314 2043249 2043249 defendant Lawrence William gent 587788 587788 Lawrence, William, of Ledbury, gent 0
4055313 2044300 2044300 plaintiff Bennys Simon mercer 587788 587788 Bennys, Simon, of Ledbury, mercer 0
4055902 2044493 2044493 plaintiff Bonde John yeoman 587788 587788 Bonde, John, of Ledbury, yeoman 0
4061715 2046589 2046589 defendant Bonde James yeoman 587788 587788 Bonde, James, of Ledbury, yeoman 0
4070027 2049569 2049569 plaintiff Maddocke Richard tanner 587788 587788 Maddocke, Richard, of Ledbury, tanner 0
4070041 2049573 2049573 plaintiff Madocke Richard tanner 587788 587788 Madocke, Richard, of Ledbury, tanner 0
4072130 2050332 2050332 plaintiff Nurthen or Nurden William tanner 587788 587788 Nurthen or Nurden, William, of Ledbury, tanner 0
4072242 2050372 2050372 defendant Rawlyns James butcher 587788 587788 Rawlyns, James, of Ledbury, butcher 0
4085287 2055018 2055018 defendant Isoke Walter husbandman 587788 587788 Isoke, Walter, of Ledbury, husbandman 1
4098339 2059734 2059734 defendant Stocke William clerk 587788 587788 Stocke, William, of Ledbury, clerk 0
4111543 2064375 2064375 defendant Jones Thomas gent 587788 587788 Jones, Thomas, of Ledbury, or of Wolhope, gent 0
4120334 2067548 2067548 defendant Wylton John gent 587788 587788 Wylton, John, of Ledbury, or of Dymocke, Glos, gent 2
4143402 2075856 2075856 defendant Wylton John gent 587788 587788 Wylton, John, of Ledbury, or of Dymmocke, Glos, gent 2
4146081 2076780 2076780 defendant Elton Anthony gent 587788 587788 Elton, Anthony, of Ledbury, gent 1
4146087 2076781 2076781 defendant Elton Anthony gent 587788 587788 Elton, Anthony, of Ledbury, gent 3
4154279 2079591 2079591 defendant Stone Simon   587788 587788 Stone, Simon, of Ledbury, husbandman, his son 1
4170945 2085319 2085319 defendant Hall Richard husbandman 587788 587788 Hall, Richard, of Ledbury, husbandman 3
4170950 2085320 2085320 defendant Hall Richard husbandman 587788 587788 Hall, Richard, of Ledbury, husbandman 3
4174060 2086379 2086379 defendant Mayle Philip miller 587788 587788 Mayle, Philip, of Ledbury, miller 0
4175529 2086912 2086912 defendant Parry Simon gent 587788 587788 Parry, Simon, of Ledbury, gent 3
4182670 2089420 2089420 defendant Elton Anthony gent 587788 587788 Elton, Anthony, of Ledbury, gent 0
4184735 2090169 2090169 defendant Hall Richard yeoman 587788 587788 Hall, Richard, of Ledbury, yeoman 0
4184736 2090169 2090169 defendant Hall Thomas smith 587788 587788 Hall, Thomas, of Ledbury, smith 1
4214671 2100636 2100636 defendant Bound John yeoman 587788 587788 Bound, John, of Ledbury, yeoman 2
4218530 2101979 2101979 defendant Hall William yeoman 587788 587788 Hall, William, of Ledbury, yeoman 1
4227609 2105143 2105143 defendant Parry James gent 587788 587788 Parry, James, of Ledbury, gent 0
4227610 2105143 2105143 defendant Parry Lewis gent 587788 587788 Parry, Lewis, of Ledbury, gent 1
4227611 2105143 2105143 defendant Phelipps David yeoman 587788 587788 Phelipps, David, of Ledbury, yeoman 2
4227660 2105158 2105158 defendant Hall William yeoman 587788 587788 Hall, William, of Ledbury, yeoman 1
4235220 2107879 2107879 defendant Stone Simon yeoman 587788 587788 Stone, Simon, of Ledbury, yeoman 1
4237270 2108623 2108623 defendant Barnard Edmund yeoman 587788 587788 Barnard, Edmund, of Ledbury, yeoman 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);