names

213 rows where place_id = 586396

✎ 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
3588617 1864084 1864084 defendant Howe William laborer 586396 586396 Howe, William, of Yaxham, laborer 1
3606890 1869820 1869820 defendant Codlyng Richard yeoman 586396 586396 Codlyng, Richard, of Yaxham, yeoman 0
3624543 1875213 1875213 defendant Codlyng Richard yeoman 586396 586396 Codlyng, Richard, of Yaxham, yeoman 0
3624544 1875213 1875213 defendant Helde Robert husbandman 586396 586396 Helde, Robert, of Yaxham, husbandman 1
3635228 1905809 1905809 defendant Browne John clerk 586396 586396 Browne, John, of Yaxham, clerk 0
3638229 1906777 1906777 defendant Mowse John husbandman 586396 586396 Mowse, John, of Yaxham, husbandman 3
3639588 1907192 1907192 defendant Stracok John husbandman 586396 586396 Stracok, John, of Yaxham, husbandman 0
3648854 1910030 1910030 defendant Mere William husbandman 586396 586396 Mere, William, of Yaxham, husbandman 1
3666056 1915323 1915323 defendant Nape Robert husbandman 586396 586396 Nape, Robert, of Yaxham, husbandman 0
3667486 1915772 1915772 defendant Nepe Robert   586396 586396 Nepe, Robert, of Yaxham, hayre maker, or hair cloth maker 3
3676405 1918666 1918666 defendant Stokys James husbandman 586396 586396 Stokys, James, of Yaxham, husbandman 0
3699875 1926188 1926188 plaintiff Aggys John   586396 586396 Aggys, John, of Yaxham 0
3699876 1926188 1926188 defendant Stracok William singleman 586396 586396 Stracok, William, of Yaxham, singleman 0
3705764 1928083 1928083 defendant Stracok William yeoman 586396 586396 Stracok, William, of Yaxham, yeoman 0
3709614 1929315 1929315 defendant Stokys Humphrey husbandman 586396 586396 Stokys, Humphrey, of Yaxham, husbandman 2
3709615 1929315 1929315 defendant Stokys John husbandman 586396 586396 Stokys, John, of Yaxham, husbandman 3
3709622 1929317 1929317 defendant Stokis Humphrey husbandman 586396 586396 Stokis, Humphrey, of Yaxham, husbandman 3
3709623 1929317 1929317 defendant Stokis John husbandman 586396 586396 Stokis, John, of Yaxham, husbandman 4
3715205 1931049 1931049 defendant Gyrlyng Richard hairman 586396 586396 Gyrlyng, Richard, of Yaxham, hairman 1
3716776 1931537 1931537 defendant Stracok Margaret widow 586396 586396 (Stracok, Margaret, of Yaxham, widow 1
3716777 1931537 1931537 defendant Stracok William yeoman 586396 586396 Stracok, William, of Yaxham, yeoman 2
3716781 1931538 1931538 defendant Stracok Margaret widow 586396 586396 Stracok, Margaret, of Yaxham, widow 1
3727471 1934868 1934868 defendant Stokys John   586396 586396 Stokys, John, of Yaxham, hair maker 3
3734342 1936979 1936979 defendant Stracok John husbandman 586396 586396 Stracok, John, of Yaxham, husbandman 0
3734343 1936979 1936979 defendant Mewse John husbandman 586396 586396 Mewse, John, of Yaxham, husbandman 1
3734344 1936979 1936979 defendant Mewse Robert husbandman 586396 586396 Mewse, Robert, of Yaxham, husbandman 2
3734828 1937136 1937136 defendant Gyrlyng Richard husbandman 586396 586396 Gyrlyng, Richard, of Yaxham, husbandman 3
3740564 1938905 1938905 defendant Stokkys Humphrey husbandman 586396 586396 Stokkys, Humphrey, of Yaxham, husbandman 2
3762475 1945907 1945907 defendant Stracok John   586396 586396 Stracok, John, of Yaxham, husbandman, administrators of 0
3762476 1945907 1945907 defendant Stracok William husbandman 586396 586396 (Stracok, William, of Yaxham, husbandman 1
3762477 1945907 1945907 defendant Stracok Margaret widow 586396 586396 Stracok, Margaret, of Yaxham, widow 2
3769964 1948262 1948262 defendant Stokys John husbandman 586396 586396 Stokys, John, of Yaxham, husbandman 2
3769965 1948262 1948262 defendant Stokys Humphrey husbandman 586396 586396 Stokys, Humphrey, of Yaxham, husbandman 3
3780920 1951764 1951764 defendant Stokye Humphrey   586396 586396 Stokye, Humphrey, of Yaxham, hair maker 2
3780953 1951777 1951777 defendant Stokys Humphrey   586396 586396 Stokys, Humphrey, of Yaxham, hair maker 1
3789354 1954491 1954491 defendant Baker Robert yeoman 586396 586396 Baker, Robert, of Yaxham, yeoman 0
3814985 1962607 1962607 defendant Nepe Robert hairman 586396 586396 Nepe, Robert, of Yaxham, hairman 4
3833316 1968348 1968348 plaintiff Lawes John   586396 586396 Lawes, John, of Yaxham 0
3845420 1972129 1972129 defendant Eglyn Thomas husbandman 586396 586396 Eglyn, Thomas, of Yaxham, husbandman 1
3845431 1972131 1972131 defendant Eglyn Thomas husbandman 586396 586396 Eglyn, Thomas, of Yaxham, husbandman 1
3857523 1975988 1975988 defendant Baker Robert husbandman 586396 586396 Baker, Robert, of Yaxham, husbandman 0
3862726 1977726 1977726 defendant Beeston Robert husbandman 586396 586396 Beeston, Robert, of Yaxham, husbandman 0
3869330 1979985 1979985 defendant Straycok John husbandman 586396 586396 Straycok, John, of Yaxham, husbandman 0
3887594 1986100 1986100 defendant Peper John husbandman 586396 586396 Peper, John, of Yaxham, husbandman 2
3887600 1986101 1986101 defendant Pepyr John husbandman 586396 586396 Pepyr, John, of Yaxham, husbandman 2
3895210 1988606 1988606 defendant Peper John husbandman 586396 586396 Peper, John, of Yaxham, husbandman 0
3895214 1988607 1988607 defendant Peper John husbandman 586396 586396 Peper, John, of Yaxham, husbandman 0
3896646 1989089 1989089 defendant Baker Robert husbandman 586396 586396 Baker, Robert, of Yaxham, husbandman 4
3900569 1990421 1990421 defendant Peper John yeoman 586396 586396 Peper, John, of Yaxham, yeoman 1
3903571 1991423 1991423 defendant Alom Richard husbandman 586396 586396 Alom, Richard, of Yaxham, husbandman 0
3910978 1993996 1993996 defendant Baker Robert husbandman 586396 586396 Baker, Robert, of Yaxham, husbandman 2
3914472 1995181 1995181 defendant Pepper John husbandman 586396 586396 Pepper, John, of Yaxham, husbandman 4
3923269 1998094 1998094 defendant Peper John husbandman 586396 586396 Peper, John, of Yaxham, husbandman 0
3958662 2010104 2010104 defendant Alee Richard weaver 586396 586396 Alee, Richard, of Yaxham, weaver 3
3970047 2014120 2014120 plaintiff Curle William   586396 586396 Curle, William, of Yaxham 0
3970048 2014120 2014120 defendant Mowtyng Edmund yeoman 586396 586396 Mowtyng, Edmund, of Yaxham, yeoman 0
3970049 2014120 2014120 defendant Baker Henry husbandman 586396 586396 Baker, Henry, of Yaxham, husbandman 1
3975795 2016095 2016095 defendant Mowtyng Edmund yeoman 586396 586396 Mowtyng, Edmund, of Yaxham, yeoman 1
3978311 2016998 2016998 plaintiff Maydwell John clerk 586396 586396 Maydwell, John, of Yaxham, clerk 0
3989722 2021069 2021069 defendant Browne William clerk 586396 586396 Browne, William, of Yaxham, clerk 3
3992019 2021912 2021912 plaintiff Brydges John glover 586396 586396 Brydges, John, of Yaxham, glover 0
4006502 2027105 2027105 defendant Pylche John cooper 586396 586396 Pylche, John, of Yaxham, cooper 3
4015044 2030075 2030075 defendant Vyncent John husbandman 586396 586396 Vyncent, John, of Yaxham, husbandman 5
4023561 2033135 2033135 defendant Costerton Lawrence shoemaker 586396 586396 Costerton, Lawrence, of Yaxham, shoemaker 2
4031258 2035852 2035852 defendant Lovell Thomas, junior yeoman 586396 586396 Lovell, Thomas, junior, of Yaxham, yeoman 0
4053270 2043548 2043548 defendant Dynne John husbandman 586396 586396 Dynne, John, of Yaxham, husbandman 10
4062932 2047042 2047042 defendant Dave Hugh husbandman 586396 586396 Dave, Hugh, of Yaxham, husbandman 3
4098651 2059849 2059849 defendant Brett John husbandman 586396 586396 Brett, John, of Yaxham, husbandman 0
4112707 2064805 2064805 defendant Gyle Thomas husbandman 586396 586396 Gyle, Thomas, of Yaxham, husbandman 0
4113339 2065040 2065040 defendant Madwell John clerk 586396 586396 Madwell, John, of Yaxham, clerk 0
4136187 2073287 2073287 defendant Deane Thomas tailor 586396 586396 Deane, Thomas, of Yaxham, tailor 1
4154409 2079634 2079634 defendant Agges Robert husbandman 586396 586396 Agges, Robert, of Yaxham, husbandman 0
4154410 2079634 2079634 defendant Agges Thomas husbandman 586396 586396 Agges, Thomas, of Yaxham, husbandman 1
4205922 2097614 2097614 defendant Durrant John husbandman 586396 586396 Durrant, John, of Yaxham, husbandman 0
4214353 2100527 2100527 defendant Baker William laborer 586396 586396 Baker, William, of Yaxham, laborer 1
4219391 2102282 2102282 defendant Holton Robert weaver 586396 586396 Holton, Robert, of Yaxham, weaver 0
4220230 2102579 2102579 defendant Allen Simon husbandman 586396 586396 Allen, Simon, of Yaxham, husbandman 2
4220668 2102728 2102728 defendant Hendry John miller 586396 586396 Hendry, John, of Yaxham, miller 0
4229174 2105685 2105685 defendant Allen Simon husbandman 586396 586396 Allen, Simon, of Yaxham, husbandman 2
4230009 2105984 2105984 defendant Stapleford Thomas   586396 586396 Stapleford, Thomas, of Yaxham, worsted weaver 0
4236703 2108410 2108410 defendant Gurney Arthur gent 586396 586396 Gurney, Arthur, of Yaxham, gent 0
4240829 2109916 2109916 defendant Baker William laborer 586396 586396 Baker, William, of Yaxham, laborer 1
4257342 2115431 2115431 defendant Dynn John husbandman 586396 586396 Dynn, John, of Yaxham, husbandman 1
4257344 2115431 2115431 defendant Aldred Thomas cordwainer 586396 586396 Aldred, Thomas, of Yaxham, cordwainer 3
4260000 2116314 2116314 defendant Skynner alias Eldred Robert butcher 586396 586396 Skynner alias Eldred, Robert, of Yaxham, butcher 3
4272911 2120503 2120503 defendant Hardye Thomas gent 586396 586396 Hardye, Thomas, of Yaxham, gent 0
4330877 2140626 2140626 defendant Allen Simon yeoman 586396 586396 Allen, Simon, of Yaxham, yeoman 0
4348881 2146871 2146871 defendant Allen Simon husbandman 586396 586396 Allen, Simon, of Yaxham, husbandman 0
4348883 2146872 2146872 defendant Woodes Thomas yeoman 586396 586396 Woodes, Thomas, of Yaxham, yeoman 0
4356406 2149468 2149468 defendant Gurney Arthur gent 586396 586396 Gurney, Arthur, of Yaxham, or of Southwark St George, gent 0
4388709 2160858 2160858 defendant Claxton Elizabeth widow 586396 586396 Claxton, Elizabeth, of Yaxham, widow 1
4391514 2161774 2161774 defendant Dynne John husbandman 586396 586396 Dynne, John, of Yaxham, husbandman 0
4391515 2161774 2161774 defendant Agges John   586396 586396 Agges, John, of Yaxham, mason 1
4400398 2164729 2164729 defendant Swattock Robert yeoman 586396 586396 Swattock, Robert, of Yaxham, yeoman 1
4403555 2165762 2165762 defendant Baker Robert husbandman 586396 586396 Baker, Robert, of Yaxham, husbandman 3
4452670 2185843 2185843 plaintiff Kicher John   586396 586396 Kicher, John, of Yaxham 0
4452672 2185843 2185843 defendant Agge Robert   586396 586396 Agge, Robert, of Yaxham 1
4455010 2186571 2186571 defendant Edyman Edmund   586396 586396 Edyman, Edmund, of Yaxham 1
4455011 2186571 2186571 defendant Peyntour Edmund   586396 586396 Peyntour, Edmund, of Yaxham 2
4460689 2188402 2188402 defendant Curveys John   586396 586396 Curveys, John, of Yaxham 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);