names

268 rows where place_id = 587494

✎ 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
3591566 1864988 1864988 defendant Baker John baker 587494 587494 Baker, John, of Webley, baker 0
3599719 1867556 1867556 defendant Badam John, senior yeoman 587494 587494 Badam, John, senior, of Webley, yeoman 1
3599722 1867557 1867557 defendant Badam or Adam John, senior husbandman 587494 587494 Badam or Adam, John, senior, of Webley, husbandman 1
3615770 1872574 1872574 defendant Worceter John chapman 587494 587494 (Worceter, John, of Webley, chapman 1
3618134 1873296 1873296 defendant Lesman Hugh dyer 587494 587494 Lesman, Hugh, of Webley, dyer 0
3625367 1875475 1875475 defendant Ball John butcher 587494 587494 Ball, John, of Webley, butcher 0
3626841 1903247 1903247 defendant Seysse John husbandman 587494 587494 Seysse, John, of Webley, husbandman 0
3628391 1903745 1903745 defendant Carpynter John carpenter 587494 587494 Carpynter, John, of Webley, carpenter 0
3631200 1904584 1904584 defendant Baker John, senior baker 587494 587494 Baker, John, senior, of Webley, baker 0
3631201 1904584 1904584 defendant Seyse Richard husbandman 587494 587494 Seyse, Richard, of Webley, husbandman 1
3632917 1905111 1905111 defendant Code Richard husbandman 587494 587494 Code, Richard, of Webley, husbandman 3
3636023 1906061 1906061 defendant Donne Richard husbandman 587494 587494 Donne, Richard, of Webley, husbandman 0
3636024 1906061 1906061 defendant Lyffe Richard husbandman 587494 587494 Lyffe, Richard, of Webley, husbandman 1
3636025 1906061 1906061 defendant Kynersley John baker 587494 587494 Kynersley, John, of Webley, baker 2
3638172 1906755 1906755 defendant Blether Thmas tanner 587494 587494 Blether, Thmas, of Webley, tanner 2
3638527 1906864 1906864 defendant Seyso Richard husbandman 587494 587494 Seyso, Richard, of Webley, husbandman 0
3642393 1908065 1908065 defendant Carpenter John husbandman 587494 587494 Carpenter, John, of Webley, husbandman 2
3647290 1909537 1909537 defendant Carpenter John husbandman 587494 587494 Carpenter, John, of Webley, husbandman 0
3647291 1909537 1909537 defendant Bole John husbandman 587494 587494 Bole, John, of Webley, husbandman 1
3655597 1912013 1912013 defendant bocher John butcher 587494 587494 bocher, John, of Webley, butcher 1
3679795 1919746 1919746 defendant ap Owen William yeoman 587494 587494 ap Owen, William, of Webley, yeoman 0
3686017 1921786 1921786 defendant Badam Agnes widow 587494 587494 Badam, Agnes, of Webley, widow 0
3689660 1922924 1922924 defendant Bulkyn Thomas yeoman 587494 587494 Bulkyn, Thomas, of Webley, yeoman 0
3709287 1929201 1929201 defendant ap Owen William shipman or chapman 587494 587494 ap Owen, William, of Webley, shipman or chapman 0
3709288 1929201 1929201 defendant Done Richard husbandman 587494 587494 Done, Richard, of Webley, husbandman 1
3711983 1930065 1930065 defendant Garrewey Thomas yeoman 587494 587494 Garrewey, Thomas, of Webley, yeoman 3
3718294 1932007 1932007 defendant Baker John baker 587494 587494 Baker, John, of Webley, baker 0
3720571 1932715 1932715 defendant Caldycot James cordwainer 587494 587494 Caldycot, James, of Webley, cordwainer 0
3735083 1937214 1937214 defendant Garewey Thomas yeoman 587494 587494 Garewey, Thomas, of Webley, yeoman 1
3755031 1943522 1943522 defendant Fleccher Thomas tanner 587494 587494 Fleccher, Thomas, of Webley, tanner 0
3789544 1954556 1954556 defendant Hopkyns John husbandman 587494 587494 Hopkyns, John, of Webley, husbandman, husbandman 0
3789554 1954560 1954560 defendant Worcett alias Alye Richard yeoman 587494 587494 Worcett alias Alye, Richard, of Webley, yeoman 0
3791199 1955080 1955080 defendant Parsons Richard yeoman 587494 587494 Parsons, Richard, of Webley, yeoman 1
3799091 1957625 1957625 defendant Mascowe alias Mascolde Thomas chapman 587494 587494 Mascowe alias Mascolde, Thomas, of Webley, chapman 1
3816600 1963092 1963092 defendant Mascolde Thomas chapman 587494 587494 Mascolde, Thomas, of Webley, chapman 0
3820291 1964220 1964220 defendant Garrewey Thomas yeoman 587494 587494 Garrewey, Thomas, of Webley, yeoman 1
3822859 1965057 1965057 plaintiff Tompkyns James chapman 587494 587494 Tompkyns, James, of Webley, chapman 1
3825688 1965888 1965888 defendant Mascold Thomas chapman 587494 587494 Mascold, Thomas, of Webley, chapman 1
3835523 1969049 1969049 defendant Mascold Thomas mercer 587494 587494 Mascold, Thomas, of Webley, mercer 2
3835526 1969050 1969050 defendant Garrewey James mercer 587494 587494 Garrewey, James, of Webley, mercer 0
3835527 1969050 1969050 defendant Callycote James shoemaker 587494 587494 Callycote, James, of Webley, shoemaker 1
3838366 1969920 1969920 plaintiff Tompkyns James   587494 587494 Tompkyns, James, of Webley 0
3849411 1973414 1973414 defendant ap Yevan Hugh tiler 587494 587494 ap Yevan, Hugh, of Webley, tiler 0
3849412 1973414 1973414 defendant Jenkyns Richard husbandman 587494 587494 Jenkyns, Richard, of Webley, husbandman 1
3849413 1973414 1973414 defendant Childe Thomas weaver 587494 587494 Childe, Thomas, of Webley, weaver 2
3868902 1979840 1979840 plaintiff Tomkyns James   587494 587494 Tomkyns, James, of Webley 0
3868905 1979841 1979841 plaintiff Tomkyns James chapman 587494 587494 Tomkyns, James, of Webley, chapman 0
3868906 1979841 1979841 defendant Mascoll Thomas chapman 587494 587494 Mascoll, Thomas, of Webley, chapman 0
3868907 1979841 1979841 defendant Lewis John baker 587494 587494 Lewis, John, of Webley, baker 1
3868908 1979841 1979841 defendant Lye Richard gent 587494 587494 Lye, Richard, of Webley, gent 2
3882731 1984488 1984488 defendant Mascoll Thomas chapman 587494 587494 Mascoll, Thomas, of Webley, chapman 0
3882732 1984488 1984488 defendant Lewys John baker 587494 587494 Lewys, John, of Webley, baker 1
3882733 1984488 1984488 defendant Lie Richard gent 587494 587494 Lie, Richard, of Webley, gent 2
3898265 1989628 1989628 defendant Lewes John husbandman 587494 587494 Lewes, John, of Webley, husbandman 1
3929600 2000249 2000249 defendant Rade John husbandman 587494 587494 Rade, John, of Webley, husbandman 3
3929601 2000249 2000249 defendant ap David Jenkyn husbandman 587494 587494 ap David, Jenkyn, of Webley, husbandman 4
3929606 2000251 2000251 defendant Hoell Thomas husbandman 587494 587494 Hoell, Thomas, of Webley, husbandman 1
3931334 2000773 2000773 defendant Mascall Thomas yeoman 587494 587494 Mascall, Thomas, of Webley, yeoman 0
3932823 2001276 2001276 defendant Rede John husbandman 587494 587494 Rede, John, of Webley, husbandman 17
3932848 2001276 2001276 defendant Lewys John yeoman 587494 587494 Lewys, John, of Webley, yeoman 42
3935422 2002158 2002158 defendant Patye Edmund butcher 587494 587494 Patye, Edmund, of Webley, butcher 0
3952499 2007942 2007942 defendant More Richard cordwainer 587494 587494 More, Richard, of Webley, cordwainer 0
3953431 2008272 2008272 defendant Wyett Humphrey tailor 587494 587494 Wyett, Humphrey, of Webley, tailor 0
3965771 2012643 2012643 defendant Wynney Thomas yeoman 587494 587494 Wynney, Thomas, of Webley, yeoman 1
3965774 2012643 2012643 defendant Chelde Thomas yeoman 587494 587494 Chelde, Thomas, of Webley, yeoman 4
3980078 2017637 2017637 defendant Childe Roger yeoman 587494 587494 Childe, Roger, of Webley, yeoman 0
3980556 2017810 2017810 defendant ap Thomas Robert butcher 587494 587494 ap Thomas, Robert, of Webley, butcher 0
3984935 2019370 2019370 plaintiff Tomkyns James (legal representative) 587494 587494 Tomkyns, James, of Webley, esq, executor of 0
3987172 2020158 2020158 defendant Parker Henry cordwainer 587494 587494 Parker, Henry, of Webley, cordwainer 0
3987173 2020158 2020158 defendant Rawlyng William husbandman 587494 587494 Rawlyng, William, of Webley, husbandman 1
3987445 2020257 2020257 defendant ap Guillim or William Lewis tailor 587494 587494 ap Guillim or William, Lewis, of Webley, tailor 0
3987453 2020258 2020258 defendant William Lewis tailor 587494 587494 William, Lewis, of Webley, tailor 4
3987454 2020258 2020258 defendant Kynnersley Lancelot clerk 587494 587494 Kynnersley, Lancelot, of Webley, clerk 5
3996925 2023668 2023668 defendant Penell Richard husbandman 587494 587494 Penell, Richard, of Webley, husbandman 0
4003357 2025962 2025962 defendant Carpynter Thomas yeoman 587494 587494 Carpynter, Thomas, of Webley, yeoman 0
4003358 2025962 2025962 defendant Wyett Humphrey yeoman 587494 587494 Wyett, Humphrey, of Webley, yeoman 1
4008495 2027809 2027809 defendant Pennell Richard husbandman 587494 587494 Pennell, Richard, of Webley, husbandman 0
4008497 2027809 2027809 defendant Carpenter Thomas yeoman 587494 587494 Carpenter, Thomas, of Webley, yeoman 2
4008500 2027810 2027810 defendant Pennell Richard husbandman 587494 587494 Pennell, Richard, of Webley, husbandman 0
4008502 2027810 2027810 defendant Carpenter Thomas yeoman 587494 587494 Carpenter, Thomas, of Webley, yeoman 2
4008504 2027811 2027811 plaintiff Monyngton George mercer 587494 587494 Monyngton, George, of Webley, gent, mercer 0
4008509 2027812 2027812 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, mercer, gent 0
4008510 2027812 2027812 defendant Baylye Henry salter 587494 587494 Baylye, Henry, of Webley, salter 0
4008514 2027813 2027813 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, mercer, gent 0
4008523 2027814 2027814 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, mercer, gent 0
4023224 2033015 2033015 defendant Abrydge Roland gent 587494 587494 Abrydge, Roland, of Webley, gent 2
4023415 2033085 2033085 defendant ap Owen John husbandman 587494 587494 ap Owen, John, of Webley, husbandman 1
4032439 2036252 2036252 defendant Baylye Henry yeoman 587494 587494 (Baylye, Henry, of Webley, yeoman 15
4040624 2039144 2039144 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, gent 0
4040629 2039145 2039145 plaintiff Monyngton George mercer 587494 587494 Monyngton, George, of Webley, gent, mercer 0
4046065 2041031 2041031 plaintiff Shepam Thomas gent 587494 587494 Shepam, Thomas, of Webley, gent 0
4052158 2043189 2043189 defendant ap Guyllyam alias Taylor Lewis yeoman 587494 587494 ap Guyllyam alias Taylor, Lewis, of Webley, yeoman 0
4053587 2043656 2043656 defendant Tomkyns James yeoman 587494 587494 Tomkyns, James, of Webley, yeoman 0
4067335 2048620 2048620 defendant Wyett Humphrey yeoman 587494 587494 Wyett, Humphrey, of Webley, yeoman 0
4067870 2048819 2048819 defendant Chylde Thomas yeoman 587494 587494 Chylde, Thomas, of Webley, yeoman 0
4071053 2049948 2049948 plaintiff Mone Edmund yeoman 587494 587494 Mone, Edmund, of Webley, yeoman 0
4071076 2049956 2049956 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, gent 0
4071078 2049957 2049957 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, gent 0
4071080 2049958 2049958 plaintiff Monyngton George gent 587494 587494 Monyngton, George, of Webley, gent 0
4071082 2049959 2049959 plaintiff Monyngton George   587494 587494 Monyngton, George, of Webley, gent, "my brother" 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);