names

238 rows where place_id = 591737

✎ 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
3605388 1869352 1869352 defendant Bandryk Humphrey yeoman 591737 591737 Bandryk, Humphrey, of Birmingham, yeoman 0
3656069 1912151 1912151 plaintiff Byrde Roger (legal representative) 591737 591737 Byrde, Roger, of Birmingham, grasier, executor of 0
3679160 1919549 1919549 defendant Wygysted John butcher 591737 591737 Wygysted, John,of Birmingham, butcher 0
3794098 1956020 1956020 defendant Wygstede John butcher 591737 591737 Wygstede, John, of Birmingham, butcher 0
3810399 1961142 1961142 defendant Lynde Oliver mercer 591737 591737 Lynde, Oliver, of Birmingham, mercer 0
3928974 2000028 2000028 defendant Saunders alias Rychardson Reginald butcher 591737 591737 Saunders alias Rychardson, Reginald, of Birmingham, butcher 1
3955705 2009069 2009069 plaintiff Michell William yeoman 591737 591737 Michell, William, of Birmingham, yeoman 0
3955706 2009069 2009069 plaintiff Butler Thomas mercer 591737 591737 Butler, Thomas, of Birmingham, mercer 1
3955707 2009069 2009069 plaintiff Bother William yeoman 591737 591737 Bother, William, of Birmingham, yeoman 2
3963952 2011998 2011998 defendant Mylner Thomas shoemaker 591737 591737 Mylner, Thomas, of Birmingham, shoemaker 5
3969029 2013785 2013785 defendant Richardes alias Saunders Reginald butcher 591737 591737 Richardes alias Saunders, Reginald, of Birmingham, butcher 0
3969122 2013812 2013812 plaintiff Colmor William (legal representative) 591737 591737 Colmor, William, of Birmingham, mercer, executors of 0
3969128 2013813 2013813 plaintiff Colmor William (legal representative) 591737 591737 Colmor, William, of Birmingham, mercer, executors of 0
3969132 2013814 2013814 plaintiff Colmor William (legal representative) 591737 591737 Colmor, William, of Birmingham, mercer, executors of 0
3969137 2013815 2013815 plaintiff Colmor William (legal representative) 591737 591737 Colmor, William, of Birmingham, mercer, executors of 0
3969141 2013816 2013816 plaintiff Colmor William (legal representative) 591737 591737 Colmor, William, of Birmingham, mercer, executors of 0
3975148 2015872 2015872 defendant Rastell John draper 591737 591737 Rastell, John, of Birmingham, draper 0
3976767 2016441 2016441 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3976771 2016442 2016442 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3976773 2016443 2016443 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3976776 2016444 2016444 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3976778 2016445 2016445 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3976780 2016446 2016446 plaintiff Kynge William fuller 591737 591737 Kynge, William, of Birmingham, fuller 0
3981376 2018107 2018107 plaintiff Rastell Thomas draper 591737 591737 Rastell, Thomas, of Birmingham, draper 0
3994666 2022846 2022846 plaintiff Colmer William mercer 591737 591737 Colmer, William, of Birmingham, mercer 0
3994670 2022847 2022847 plaintiff Colmer William mercer 591737 591737 Colmer, William, of Birmingham, mercer 0
3994688 2022852 2022852 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
3994691 2022853 2022853 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
3994695 2022854 2022854 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4005618 2026786 2026786 plaintiff Kynge William fuller or "jarnvager" 591737 591737 Kynge, William, of Birmingham, fuller or "jarnvager" 0
4005621 2026787 2026787 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4005626 2026788 2026788 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4015159 2030114 2030114 plaintiff Smalbroke Richard yeoman 591737 591737 Smalbroke, Richard, of Birmingham, yeoman 0
4015162 2030115 2030115 plaintiff Smalbroke Richard yeoman 591737 591737 Smalbroke, Richard, of Birmingham, yeoman 0
4018869 2031479 2031479 defendant Jackson James sherman 591737 591737 Jackson, James, of Birmingham,, sherman 1
4019068 2031559 2031559 plaintiff Warde John yeoman 591737 591737 Warde, John, of Birmingham, yeoman 0
4019069 2031559 2031559 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 1
4019443 2031686 2031686 defendant Sylke Simon tailor 591737 591737 Sylke, Simon, of Birmingham, tailor 0
4021234 2032315 2032315 defendant Waterson John yeoman 591737 591737 Waterson, John, of Birmingham, yeoman 0
4021236 2032316 2032316 defendant Waterson John yeoman 591737 591737 Waterson, John, of Birmingham, yeoman 0
4025412 2033746 2033746 defendant Richard or Rychardes Reginald butcher 591737 591737 Richard or Rychardes, Reginald, of Birmingham, butcher 0
4028130 2034713 2034713 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4038016 2038242 2038242 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4038018 2038243 2038243 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4038020 2038244 2038244 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4038024 2038245 2038245 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4044254 2040399 2040399 plaintiff Rastell John draper 591737 591737 Rastell, John, of Birmingham, draper 0
4048231 2041806 2041806 defendant Spurryer Thomas butcher 591737 591737 Spurryer, Thomas, of Birmingham, butcher 0
4049274 2042187 2042187 plaintiff Tunck Edward butcher 591737 591737 Tunck, Edward, of Birmingham, butcher 0
4050133 2042478 2042478 defendant Sergyant Thomas baker 591737 591737 Sergyant, Thomas, of Birmingham, baker 0
4050134 2042479 2042479 plaintiff Warde John yeoman 591737 591737 Warde, John, of Birmingham, yeoman 0
4050135 2042479 2042479 plaintiff Collymore William mercer 591737 591737 Collymore, William, of Birmingham, mercer 1
4055210 2044258 2044258 defendant Elesmore William tanner 591737 591737 Elesmore, William, of Birmingham, tanner 0
4055211 2044258 2044258 defendant Shorte Thomas shoemaker 591737 591737 Shorte, Thomas, of Birmingham, shoemaker 1
4057614 2045105 2045105 defendant Godson Henry butcher 591737 591737 Godson, Henry, of Birmingham, butcher 0
4059291 2045719 2045719 defendant Selman Thomas gent 591737 591737 Selman, Thomas, of Birmingham, gent 0
4059292 2045720 2045720 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4059297 2045721 2045721 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4059299 2045722 2045722 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4059304 2045723 2045723 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 0
4061839 2046631 2046631 plaintiff Elesmore William tanner 591737 591737 Elesmore, William, of Birmingham, tanner 0
4061841 2046631 2046631 defendant Godson Henry butcher 591737 591737 Godson, Henry, of Birmingham, butcher 1
4067062 2048518 2048518 defendant Godson Henry butcher 591737 591737 Godson, Henry, of Birmingham, butcher 0
4067063 2048518 2048518 defendant Paynton Thomas butcher 591737 591737 Paynton, Thomas, of Birmingham, butcher 1
4068651 2049076 2049076 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4068653 2049077 2049077 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4068657 2049078 2049078 plaintiff Kynge William ironmonger 591737 591737 Kynge, William, of Birmingham, ironmonger 0
4071622 2050146 2050146 plaintiff Mylwarde John ironmonger 591737 591737 Mylwarde, John, of Birmingham, ironmonger 0
4071626 2050147 2050147 defendant Rychard Roger   591737 591737 Rychard, Roger, of Birmingham, butcher, his son 1
4074464 2051171 2051171 defendant Foxe John cutler 591737 591737 Foxe, John, of Birmingham, cutler 1
4076494 2051890 2051890 plaintiff Shylton John mercer 591737 591737 Shylton, John, of Birmingham, mercer 0
4076495 2051890 2051890 plaintiff Colmore William mercer 591737 591737 Colmore, William, of Birmingham, mercer 1
4076497 2051890 2051890 defendant Selman Thomas gent 591737 591737 Selman, Thomas, of Birmingham, gent 1
4076738 2051968 2051968 defendant Shorte Thomas shoemaker 591737 591737 Shorte, Thomas, of Birmingham, shoemaker 0
4078277 2052532 2052532 defendant Rastell John draper 591737 591737 Rastell, John, of Birmingham, draper 0
4078523 2052617 2052617 defendant Byrche Henry mercer 591737 591737 Byrche, Henry, of Birmingham, mercer 0
4079503 2052969 2052969 plaintiff Tunck Edward butcher 591737 591737 Tunck, Edward, of Birmingham, butcher 0
4081785 2053791 2053791 plaintiff Wilward John cutler 591737 591737 Wilward, John, of Birmingham, yeoman, cutler 0
4083584 2054403 2054403 defendant Carr Richard carrier 591737 591737 Carr, Richard, of Birmingham, carrier 0
4087911 2055967 2055967 defendant Grene Thomas gent 591737 591737 Grene, Thomas, of Birmingham, or of Magna Bowlas, Salop, gent 0
4087912 2055967 2055967 defendant Bekker William butcher 591737 591737 Bekker, William, of Birmingham, butcher 1
4087913 2055967 2055967 defendant Burton Daniel butcher 591737 591737 Burton, Daniel, of Birmingham, butcher 2
4087914 2055967 2055967 defendant Hyggyns Walter butcher 591737 591737 Hyggyns, Walter, of Birmingham, butcher 3
4091054 2057090 2057090 defendant Rychard Roger butcher 591737 591737 Rychard, Roger, of Birmingham, butcher 1
4093682 2058065 2058065 defendant Rychard alias Raynold Roger butcher 591737 591737 Rychard alias Raynold, Roger, of Birmingham, butcher 0
4101183 2060733 2060733 defendant Bedforde John baker 591737 591737 Bedforde, John, of Birmingham, baker 0
4101184 2060733 2060733 defendant Bennett John butcher 591737 591737 Bennett, John, of Birmingham, butcher 1
4101291 2060767 2060767 defendant Swyfte Thomas husbandman 591737 591737 Swyfte, Thomas, of Birmingham, or of Hansworthe, Staffs, husbandman 0
4101293 2060767 2060767 defendant Richard Humphrey   591737 591737 Richard, Humphrey, of Birmingham, husbandman, or of Horborne, Staffs, wheelwright 2
4102017 2061030 2061030 defendant Richard alias Raynold Roger butcher 591737 591737 Richard alias Raynold, Roger, of Birmingham, butcher 2
4104963 2062050 2062050 defendant Smalebrooke Thomas mercer 591737 591737 Smalebrooke, Thomas, of Birmingham, mercer 0
4105953 2062422 2062422 defendant Byrche John cordwainer 591737 591737 Byrche, John, of Birmingham, cordwainer 0
4109790 2063760 2063760 defendant Richard Roger butcher 591737 591737 Richard, Roger, of Birmingham, butcher 1
4109797 2063762 2063762 defendant Kyne William yeoman 591737 591737 Kyne, William, of Birmingham, yeoman 0
4109798 2063762 2063762 defendant Vuett or Unett Gilbert tanner 591737 591737 Vuett or Unett, Gilbert, of Birmingham, tanner 1
4109801 2063763 2063763 defendant Vuett or Unett Gilbert tanner 591737 591737 Vuett or Unett, Gilbert, of Birmingham, tanner 1
4110733 2064097 2064097 defendant Kynge William yeoman 591737 591737 Kynge, William, of Birmingham, yeoman 0
4110734 2064097 2064097 defendant Ryder alias Rydehowse Richard laborer 591737 591737 Ryder alias Rydehowse, Richard, of Birmingham, laborer 1
4110815 2064124 2064124 defendant Richardes Roger butcher 591737 591737 Richardes, Roger, of Birmingham, butcher 0
4111083 2064217 2064217 defendant Richard Reginald butcher 591737 591737 Richard, Reginald, of Birmingham, butcher 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);