names

110 rows where place_id = 588310

✎ 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
3594067 1865786 1865786 defendant Frodsam William husbandman 588310 588310 Frodsam, William, of Byrmyngham, husbandman 0
3594070 1865787 1865787 defendant Frodsam William husbandman 588310 588310 Frodsam, William, of Byrmyngham, husbandman 0
3595560 1866248 1866248 defendant Bawderyk Humphrey yeoman 588310 588310 Bawderyk, Humphrey, of Byrmyngham, yeoman 0
3595574 1866249 1866249 defendant Bawderyk Humphrey yeoman 588310 588310 Bawderyk, Humphrey, of Byrmyngham, yeoman 0
3596307 1866474 1866474 defendant Swyft John   588310 588310 Swyft, John, of Byrmyngham, scythe maker 1
3602478 1868436 1868436 plaintiff Byrde Roger   588310 588310 Byrde, Roger, of Byrmyngham 0
3605392 1869353 1869353 defendant Bandrik Humphrey yeoman 588310 588310 Bandrik, Humphrey, of Byrmyngham, yeoman 1
3609151 1870521 1870521 defendant Byrmyngham Thomas (legal representative) 588310 588310 Byrmyngham, Thomas, of Byrmyngham, esq, executrix of 0
3625628 1875549 1875549 defendant Byrmyngham William gent 588310 588310 Byrmyngham, William, of Byrmyngham, gent 1
3642176 1908002 1908002 defendant Eliott John butcher 588310 588310 Eliott, John, of Byrmyngham, butcher 0
3644743 1908760 1908760 defendant Alen Cornelius spurrier 588310 588310 Alen, Cornelius, of Byrmyngham, spurrier 1
3644744 1908760 1908760 defendant Sherley Robert spurrier 588310 588310 Sherley, Robert, of Byrmyngham, spurrier 2
3644745 1908760 1908760 defendant Neell Henry spurrier 588310 588310 Neell, Henry, of Byrmyngham, spurrier 3
3650100 1910399 1910399 defendant Wyott William yeoman 588310 588310 Wyott, William, of Byrmyngham, yeoman 2
3656072 1912152 1912152 plaintiff Byrde Roger (legal representative) 588310 588310 Byrde, Roger, of Byrmyngham, grasier, executor of 0
3656073 1912152 1912152 plaintiff Cowper John kinsman 588310 588310 Cowper, John, of Byrmyngham, kinsman 1
3659111 1913109 1913109 defendant Mowers Robert laborer 588310 588310 Mowers, Robert, of Byrmyngham, laborer 0
3659114 1913110 1913110 defendant Mowers Robert laborer 588310 588310 Mowers, Robert, of Byrmyngham, laborer 0
3688191 1922456 1922456 defendant Gest John husbandman 588310 588310 Gest, John, of Byrmyngham, husbandman 0
3688192 1922456 1922456 defendant Stephyn Thomas cordwainer 588310 588310 Stephyn, Thomas, of Byrmyngham, cordwainer 1
3688193 1922456 1922456 defendant Mason Edward cordwainer 588310 588310 Mason, Edward, of Byrmyngham, cordwainer 2
3688194 1922456 1922456 defendant Typpett William innholder 588310 588310 Typpett, William, of Byrmyngham, innholder 3
3691211 1923412 1923412 defendant Hypkys John mercer 588310 588310 Hypkys, John, of Byrmyngham, mercer 0
3714603 1930863 1930863 defendant Furnyfall Richard brickmaker 588310 588310 Furnyfall, Richard, of Byrmyngham, brickmaker 0
3722502 1933298 1933298 defendant Tofte John husbandman 588310 588310 Tofte, John, of Byrmyngham, husbandman 1
3722513 1933300 1933300 defendant Toft John husbandman 588310 588310 Toft, John, of Byrmyngham, husbandman 2
3724253 1933871 1933871 defendant Sondels Thomas tailor 588310 588310 Sondels, Thomas, of Byrmyngham, tailor 3
3734316 1936969 1936969 defendant Butler William shoemaker 588310 588310 Butler, William, of Byrmyngham, shoemaker 0
3735976 1937490 1937490 defendant Byrmyngham Edward esq 588310 588310 Byrmyngham, Edward, of Byrmyngham, esq 0
3748392 1941428 1941428 defendant Feyrchyld Geoffrey lorimer 588310 588310 Feyrchyld, Geoffrey, of Byrmyngham, lorimer 0
3750971 1942229 1942229 defendant Byrmyngham Edward esq 588310 588310 Byrmyngham, Edward, of Byrmyngham, esq 0
3752592 1942740 1942740 plaintiff Redhyll Roger draper 588310 588310 Redhyll, Roger, of Byrmyngham, draper 0
3756980 1944161 1944161 defendant Cowper Henry mercer 588310 588310 Cowper, Henry, of Byrmyngham, mercer 0
3759187 1944861 1944861 defendant Shulton John grocer 588310 588310 Shulton, John, of Byrmyngham, grocer 0
3762084 1945784 1945784 defendant Heylam Cornelius spurrier 588310 588310 Heylam, Cornelius, of Byrmyngham, spurrier 0
3784856 1953056 1953056 defendant Russell William bowyer 588310 588310 Russell, William, of Byrmyngham, bowyer 1
3787191 1953784 1953784 defendant Waryng Thomas capper or barber 588310 588310 Waryng, Thomas, of Byrmyngham, capper or barber 0
3789858 1954655 1954655 defendant Short Richard fuller 588310 588310 Short, Richard, of Byrmyngham, fuller 2
3791448 1955163 1955163 defendant Trell William nailer 588310 588310 Trell, William, of Byrmyngham, nailer 0
3800026 1957934 1957934 defendant Typet William yeoman 588310 588310 Typet, William, of Byrmyngham, yeoman 0
3811421 1961468 1961468 defendant Waynewryghte Robert butcher 588310 588310 Waynewryghte, Robert, of Byrmyngham, butcher 0
3820098 1964163 1964163 defendant Hypkyns John mercer 588310 588310 Hypkyns, John, of Byrmyngham, mercer 0
3820100 1964164 1964164 defendant Hypkyns John mercer 588310 588310 Hypkyns, John, of Byrmyngham, mercer 0
3828890 1966915 1966915 defendant Hawkys William   588310 588310 Hawkys, William, of Byrmyngham, wheelwright 0
3843803 1971599 1971599 defendant Veysy John yeoman 588310 588310 Veysy, John, of Byrmyngham, yeoman 0
3890451 1987063 1987063 defendant Werde John baker 588310 588310 Werde, John, of Byrmyngham, baker 0
3897760 1989457 1989457 plaintiff Wygstyd John   588310 588310 Wygstyd, John, of Byrmyngham 0
3897761 1989457 1989457 plaintiff Garbett William   588310 588310 Garbett, William, of Byrmyngham 1
3901237 1990639 1990639 plaintiff Colchester Humphrey tanner 588310 588310 Colchester, Humphrey, of Byrmyngham, tanner 0
3901242 1990640 1990640 plaintiff Colchester Humphrey tanner 588310 588310 Colchester, Humphrey, of Byrmyngham, tanner 0
3901289 1990657 1990657 plaintiff Colmar William mercer 588310 588310 Colmar, William, of Byrmyngham, mercer 0
3901298 1990659 1990659 plaintiff Colmer William, junior mercer 588310 588310 Colmer, William, junior, of Byrmyngham, mercer 0
3901299 1990659 1990659 defendant Prestwoode Robert cordwainer 588310 588310 Prestwoode, Robert, of Byrmyngham, cordwainer 0
3901300 1990659 1990659 defendant Byssell Thomas weaver 588310 588310 Byssell, Thomas, of Byrmyngham, weaver 1
3901301 1990660 1990660 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3901303 1990661 1990661 plaintiff Colmer William, senior mercer 588310 588310 Colmer, William, senior, of Byrmyngham, mercer 0
3901307 1990661 1990661 defendant Byssell Thomas weaver 588310 588310 Byssell, Thomas, of Byrmyngham, weaver 3
3901308 1990662 1990662 plaintiff Colmer William, senior mercer 588310 588310 Colmer, William, senior, of Byrmyngham, mercer 0
3909304 1993407 1993407 plaintiff Shilton John mercer 588310 588310 Shilton, John, of Byrmyngham, mercer 0
3916842 1995999 1995999 defendant Colchester Humphrey tanner 588310 588310 Colchester, Humphrey, of Byrmyngham, tanner 1
3922496 1997841 1997841 defendant Venton Henry smith 588310 588310 Venton, Henry, of Byrmyngham, smith 0
3923202 1998070 1998070 defendant Baskervyle William gent 588310 588310 Baskervyle, William, of Byrmyngham, gent 0
3925084 1998705 1998705 defendant Byrcote Robert smith 588310 588310 Byrcote, Robert, of Byrmyngham, smith 0
3925085 1998705 1998705 defendant Bennet Robert smith 588310 588310 Bennet, Robert, of Byrmyngham, smith 1
3942838 2004608 2004608 defendant Whyttall Richard carpenter 588310 588310 Whyttall, Richard, of Byrmyngham, carpenter 0
3947653 2006241 2006241 plaintiff Colmer William   588310 588310 Colmer, William, of Byrmyngham 0
3947656 2006242 2006242 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947658 2006242 2006242 defendant Grymshawe John tailor 588310 588310 Grymshawe, John, of Byrmyngham, tailor 1
3947659 2006243 2006243 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947662 2006244 2006244 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947663 2006244 2006244 plaintiff Kynge William fuller 588310 588310 Kynge, William, of Byrmyngham, fuller 1
3947667 2006245 2006245 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947668 2006245 2006245 plaintiff Smyth Thomas mercer 588310 588310 Smyth, Thomas, of Byrmyngham, mercer 1
3947670 2006246 2006246 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947671 2006246 2006246 plaintiff Smyth Thomas mercer 588310 588310 Smyth, Thomas, of Byrmyngham, mercer 1
3947673 2006247 2006247 plaintiff Colmer William mercer 588310 588310 Colmer, William, of Byrmyngham, mercer 0
3947674 2006247 2006247 plaintiff Smyth Thomas mercer 588310 588310 Smyth, Thomas, of Byrmyngham, mercer 1
3955709 2009070 2009070 plaintiff Michell William yeoman 588310 588310 Michell, William, of Byrmyngham, yeoman 0
3955711 2009071 2009071 plaintiff Michell William yeoman 588310 588310 Michell, William, of Byrmyngham, yeoman 0
3955713 2009072 2009072 plaintiff Michell William yeoman 588310 588310 Michell, William, of Byrmyngham, yeoman 0
3955714 2009072 2009072 plaintiff Butler Thomas mercer 588310 588310 Butler, Thomas, of Byrmyngham, mercer 1
3955715 2009072 2009072 plaintiff Bothe William yeoman 588310 588310 Bothe, William, of Byrmyngham, yeoman 2
3994694 2022853 2022853 defendant Rastell John draper 588310 588310 Rastell, John, of Byrmyngham, draper 2
4079504 2052969 2052969 defendant Foxe John cutler 588310 588310 Foxe, John, of Byrmyngham, cutler 0
4095037 2058553 2058553 defendant Howlett John   588310 588310 Howlett, John, of Byrmyngham, apothecary 0
4133481 2072302 2072302 defendant Bradley Edmund yeoman 588310 588310 Bradley, Edmund, of Byrmyngham, yeoman 0
4137647 2073818 2073818 defendant Kyng William ironmonger 588310 588310 Kyng, William, of Byrmyngham, ironmonger 0
4137649 2073819 2073819 defendant Kynge William ironmonger 588310 588310 Kynge, William, of Byrmyngham, ironmonger 0
4144500 2076239 2076239 defendant Prene William   588310 588310 Prene, William, of Byrmyngham, scythe smith 1
4289779 2126405 2126405 defendant Leather Richard cutler 588310 588310 Leather, Richard, of Byrmyngham, cutler 2
4429194 2173939 2173939 plaintiff Tytyto Richard   588310 588310 Tytyto, Richard, of Byrmyngham, son of William 0
4435263 2175787 2175787 plaintiff Moul Joan le daughter of Roger 588310 588310 Moul, Joan le, of Byrmyngham, daughter of Roger 0
4457673 2187409 2187409 plaintiff Philipp John   588310 588310 Philipp, John, of Byrmyngham 0
4629389 2240121 2240121 defendant Verebrigee John   588310 588310 Verebrigee, John, of Byrmyngham 0
4953786 2343093 2343093 defendant Tymyn John ironmonger 588310 588310 Tymyn, John, of Byrmyngham, ironmonger 0
5022736 2363562 2363562 defendant Byrmyngham Joan   588310 588310 Byrmyngham, Joan, of Byrmyngham, widow of Byrmyngham, William, of Byrmyngham, knight 0
5025478 2364351 2364351 defendant Bernard alias of the Ewery John barber 588310 588310 Bernard alias of the Ewery, John, of Byrmyngham, barber 0
5035751 2367311 2367311 defendant Forster Robert walker 588310 588310 Forster, Robert, of Byrmyngham, walker 3
5229511 2424244 2424244 defendant Pypwall Roger yeoman 588310 588310 Pypwall, Roger, of Byrmyngham, yeoman 4
5243143 2428195 2428195 defendant Pepwall Roger yeoman 588310 588310 Pepwall, Roger, of Byrmyngham, 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);