names

147 rows where place_id = 587907

✎ 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
3592783 1865355 1865355 defendant Osbern Robert husbandman 587907 587907 Osbern, Robert, of Burne, husbandman 0
3592784 1865355 1865355 defendant Norman Simon husbandman 587907 587907 Norman, Simon, of Burne, husbandman 1
3592786 1865356 1865356 defendant Osbern Robert husbandman 587907 587907 Osbern, Robert, of Burne, husbandman 0
3592787 1865356 1865356 defendant Norman Simon husbandman 587907 587907 Norman, Simon, of Burne, husbandman 1
3630689 1904427 1904427 defendant Thompson William husbandman 587907 587907 Thompson, William, of Burne, husbandman 2
3631548 1904683 1904683 defendant Emlyn Henry husbandman 587907 587907 Emlyn, Henry, of Burne, husbandman 2
3636211 1906115 1906115 defendant Flecher Richard husbandman 587907 587907 Flecher, Richard, of Burne, husbandman 0
3647824 1909714 1909714 defendant Marmyon Thomas esq 587907 587907 Marmyon, Thomas, of Burne, esq 1
3655024 1911835 1911835 defendant Toterych John cordwainer 587907 587907 Toterych, John, of Burne, cordwainer 4
3655025 1911835 1911835 defendant Barbour Richard barber 587907 587907 Barbour, Richard, of Burne, barber 5
3691475 1923489 1923489 defendant Lamb William husbandman 587907 587907 Lamb, William, of Burne, husbandman 0
3693118 1924056 1924056 defendant Molleners William gent 587907 587907 Molleners, William, of Burne, gent 0
3693377 1924143 1924143 defendant Lamme William husbandman 587907 587907 Lamme, William, of Burne, husbandman 0
3708900 1929075 1929075 defendant Toterich John cordwainer 587907 587907 Toterich, John, of Burne, cordwainer 0
3719847 1932475 1932475 plaintiff Hekyngton Alice widow 587907 587907 Hekyngton, Alice, of Burne, widow 0
3737851 1938057 1938057 defendant Dane John yeoman 587907 587907 Dane, John, of Burne, yeoman 0
3743285 1939768 1939768 defendant Mounsforthe Richard husbandman 587907 587907 Mounsforthe, Richard, of Burne, husbandman 0
3777134 1950599 1950599 defendant Budle William husbandman 587907 587907 Budle, William, of Burne, husbandman 0
3783002 1952434 1952434 defendant Welles Robert dyer 587907 587907 Welles, Robert, of Burne, dyer 0
3786529 1953579 1953579 defendant Paxford Thomas yeoman 587907 587907 Paxford, Thomas, of Burne, yeoman 0
3797704 1957179 1957179 defendant Reve Martin husbandman 587907 587907 Reve, Martin, of Burne, or of Barnak, Nhants, husbandman 0
3804133 1959221 1959221 defendant Waterton Robert   587907 587907 Waterton, Robert, of Burne, knight 0
3804134 1959221 1959221 defendant Mitton Thomas yeoman 587907 587907 Mitton, Thomas, of Burne, yeoman 1
3815156 1962661 1962661 defendant Welles John husbandman 587907 587907 Welles, John, of Burne, husbandman 0
3824184 1965441 1965441 defendant Cropwell Thomas husbandman 587907 587907 Cropwell, Thomas, of Burne, husbandman 0
3830587 1967445 1967445 plaintiff Foster Adam gent 587907 587907 Foster, Adam, of Burne, gent 0
3832862 1968203 1968203 defendant Welles Robert dyer 587907 587907 Welles, Robert, of Burne, dyer 0
3845242 1972073 1972073 defendant Alen Thomas tailor 587907 587907 Alen, Thomas, of Burne, tailor 0
3851269 1973995 1973995 defendant Waterton Robert   587907 587907 Waterton, Robert, of Burne, knight 0
3853703 1974789 1974789 defendant Thomson Robert husbandman 587907 587907 Thomson, Robert, of Burne, husbandman 0
3857401 1975950 1975950 defendant Hartley Thomas husbandman 587907 587907 Hartley, Thomas, of Burne, husbandman 2
3870938 1980530 1980530 defendant Glotton Joan widow 587907 587907 Glotton, Joan, of Burne, widow 1
3876841 1982495 1982495 defendant Bysshop John glover 587907 587907 Bysshop, John, of Burne, glover 0
3879706 1983467 1983467 defendant Carter William butcher 587907 587907 Carter, William, of Burne, butcher 1
3880815 1983852 1983852 defendant Sharpp David husbandman 587907 587907 Sharpp, David, of Burne, husbandman 0
3886409 1985706 1985706 defendant Eldred Robert tanner 587907 587907 Eldred, Robert, of Burne, tanner 0
3888922 1986538 1986538 plaintiff Forster Adam gent 587907 587907 Forster, Adam, of Burne, gent 0
3896029 1988874 1988874 defendant Bonnyng William yeoman 587907 587907 Bonnyng, William, of Burne, yeoman 1
3902973 1991223 1991223 plaintiff Forster Adam gent 587907 587907 Forster, Adam, of Burne, gent 0
3914121 1995068 1995068 defendant Clerke Thomas mercer 587907 587907 Clerke, Thomas, of Burne, mercer 0
3914847 1995313 1995313 defendant Shypton Robert yeoman 587907 587907 Shypton, Robert, of Burne, yeoman 0
3914851 1995315 1995315 plaintiff Clerke Thomas mercer 587907 587907 Clerke, Thomas, of Burne, mercer 0
3914852 1995315 1995315 defendant Clerke Thomas mercer 587907 587907 Clerke, Thomas, of Burne, mercer 0
3923186 1998063 1998063 defendant Clerke Thomas mercer 587907 587907 Clerke, Thomas, of Burne, mercer 0
3924286 1998431 1998431 defendant Budley John smith 587907 587907 Budley, John, of Burne, smith 0
3932346 2001120 2001120 defendant Pennyngton Edward gent 587907 587907 Pennyngton, Edward, of Burne, gent 3
3932377 2001124 2001124 defendant Bysshop John glover 587907 587907 Bysshop, John, of Burne, glover 2
3932390 2001125 2001125 defendant Osburne James husbandman 587907 587907 Osburne, James, of Burne, husbandman 4
3932397 2001126 2001126 defendant Coy John dyer 587907 587907 Coy, John, of Burne, dyer 0
3970806 2014379 2014379 defendant Got William yeoman 587907 587907 Got, William, of Burne, yeoman 0
3970830 2014381 2014381 defendant Got William yeoman 587907 587907 Got, William, of Burne, yeoman 0
3970832 2014381 2014381 defendant Clayton Francis husbandman 587907 587907 Clayton, Francis, of Burne, husbandman 2
4028351 2034790 2034790 defendant Hassell William yeoman 587907 587907 Hassell, William, of Burne, yeoman 0
4028856 2034969 2034969 defendant Gylle Thomas yeoman 587907 587907 Gylle, Thomas, of Burne, yeoman 0
4033908 2036779 2036779 plaintiff Gyll Thomas yeoman 587907 587907 Gyll, Thomas, of Burne, yeoman 0
4033910 2036780 2036780 plaintiff Gyll Thomas yeoman 587907 587907 Gyll, Thomas, of Burne, yeoman 0
4033912 2036781 2036781 plaintiff Gyll Thomas yeoman 587907 587907 Gyll, Thomas, of Burne, yeoman 0
4033913 2036781 2036781 defendant Kyng Simon innholder 587907 587907 Kyng, Simon, of Burne, innholder 0
4033914 2036781 2036781 defendant Fyssher Richard yeoman 587907 587907 Fyssher, Richard, of Burne, yeoman 1
4064567 2047610 2047610 plaintiff Gyll Thomas (legal representative) 587907 587907 Gyll, Thomas, of Burne, yeoman, executor of 0
4064571 2047611 2047611 plaintiff Gyll Thomas (legal representative) 587907 587907 Gyll, Thomas, of Burne, yeoman, executor of 0
4064576 2047613 2047613 plaintiff Gylle Thomas (legal representative) 587907 587907 Gylle, Thomas, of Burne, yeoman, executor of 0
4064972 2047756 2047756 defendant Turnbull John husbandman 587907 587907 Turnbull, John, of Burne, husbandman 0
4087419 2055794 2055794 defendant Sothern Thomas husbandman 587907 587907 Sothern, Thomas, of Burne, husbandman 1
4125820 2069519 2069519 defendant Kynge Simon innholder 587907 587907 Kynge, Simon, of Burne, innholder 0
4125822 2069519 2069519 defendant Bartyllmewe Joan widow 587907 587907 Bartyllmewe, Joan, of Burne, widow 2
4213018 2100078 2100078 defendant Broune Ellen widow 587907 587907 Broune, Ellen, of Burne, widow 0
4223858 2103830 2103830 defendant Robynson Thomas husbandman 587907 587907 Robynson, Thomas, of Burne, husbandman 1
4228967 2105613 2105613 defendant Wintering William husbandman 587907 587907 Wintering, William, of Burne, husbandman 1
4229941 2105955 2105955 defendant More Edward gent 587907 587907 More, Edward, of Burne, gent 0
4234468 2107598 2107598 defendant More Edward yeoman 587907 587907 More, Edward, of Burne, yeoman 0
4234469 2107598 2107598 defendant Marshe William yeoman 587907 587907 Marshe, William, of Burne, yeoman 1
4238591 2109111 2109111 defendant More Edward gent 587907 587907 More, Edward, of Burne, gent 0
4267147 2118651 2118651 defendant Allen Edward butcher 587907 587907 Allen, Edward, of Burne, butcher 1
4267634 2118808 2118808 defendant Bayles Edward husbandman 587907 587907 Bayles, Edward, of Burne, husbandman 1
4274672 2121085 2121085 defendant Whitbie John butcher 587907 587907 Whitbie, John, of Burne, butcher 0
4277377 2122009 2122009 defendant More Gregory yeoman 587907 587907 More, Gregory, of Burne, yeoman 2
4279925 2122891 2122891 defendant Burkett Miles husbandman 587907 587907 Burkett, Miles, of Burne, husbandman 1
4283118 2123996 2123996 defendant Buddle Thomas butcher 587907 587907 Buddle, Thomas, of Burne, butcher 0
4283120 2123997 2123997 defendant Biddle Thomas butcher 587907 587907 Biddle, Thomas, of Burne, butcher 0
4285531 2124875 2124875 defendant More Edward gent 587907 587907 More, Edward, of Burne, gent 0
4285533 2124876 2124876 defendant More Edward gent 587907 587907 More, Edward, of Burne, gent 0
4290643 2126711 2126711 defendant Cheator Peter yeoman or laborer 587907 587907 Cheator, Peter, of Burne, yeoman or laborer 1
4290969 2126833 2126833 defendant Allen alias Barton Edward butcher 587907 587907 Allen alias Barton, Edward, of Burne, butcher 0
4292917 2127532 2127532 defendant Squyre Reginald draper 587907 587907 Squyre, Reginald, of Burne, draper 3
4337896 2142998 2142998 defendant Whitbie Thomas butcher 587907 587907 Whitbie, Thomas, of Burne, butcher 0
4337897 2142998 2142998 defendant Warde Gregory yeoman 587907 587907 Warde, Gregory, of Burne, yeoman 1
4342485 2144644 2144644 defendant Wilson Edward yeoman 587907 587907 Wilson, Edward, of Burne, yeoman 1
4343956 2145163 2145163 defendant Osborne Thomas husbandman 587907 587907 Osborne, Thomas, of Burne, husbandman 0
4345304 2145633 2145633 defendant Gallowaye Gregory husbandman 587907 587907 Gallowaye, Gregory, of Burne, husbandman 0
4346871 2146160 2146160 defendant Shawe William yeoman 587907 587907 Shawe, William, of Burne, yeoman 0
4346917 2146173 2146173 defendant Gallowaye Gregory husbandman 587907 587907 Gallowaye, Gregory, of Burne, husbandman 0
4355918 2149287 2149287 defendant More Edward gent 587907 587907 More, Edward, of Burne, gent 0
4357243 2149762 2149762 defendant Warde Gregory yeoman 587907 587907 Warde, Gregory, of Burne, yeoman 1
4359905 2150707 2150707 defendant Burton Thomas husbandman 587907 587907 Burton, Thomas, of Burne, husbandman 0
4360203 2150815 2150815 defendant Osborne William butcher 587907 587907 Osborne, William, of Burne, butcher 0
4360204 2150815 2150815 defendant Osborne Thomas husbandman 587907 587907 Osborne, Thomas, of Burne, husbandman 1
4361229 2151179 2151179 defendant Whittbye Thomas butcher 587907 587907 Whittbye, Thomas, of Burne, butcher 0
4361230 2151179 2151179 defendant Warde Gregory yeoman 587907 587907 Warde, Gregory, of Burne, yeoman 1
4361348 2151220 2151220 defendant Burton Thomas weaver 587907 587907 Burton, Thomas, of Burne, weaver 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);