names

152 rows where place_id = 594529

✎ 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
3616498 1872797 1872797 defendant Paty John clerk 594529 594529 Paty, John, of Bodenham, clerk 0
3616499 1872797 1872797 defendant Roukehorne or Ronkehorne Nicholas thatcher 594529 594529 Roukehorne or Ronkehorne, Nicholas, of Bodenham, thatcher 1
3616500 1872797 1872797 defendant Philippis John laborer 594529 594529 Philippis, John, of Bodenham, laborer 2
3619145 1873591 1873591 defendant Roukehorne or Ronkehorne Nicholas fletcher 594529 594529 Roukehorne or Ronkehorne, Nicholas, of Bodenham, fletcher 1
3619146 1873591 1873591 defendant Purshill John tailor 594529 594529 Purshill, John, of Bodenham, tailor 2
3642002 1907948 1907948 defendant hare John husbandman 594529 594529 hare, John, of Bodenham, husbandman 3
3646281 1909227 1909227 defendant Holand Walter tailor 594529 594529 Holand, Walter, of Bodenham, tailor 0
3646307 1909236 1909236 defendant Holand Walter tailor 594529 594529 Holand, Walter, of Bodenham, tailor 0
3689182 1922781 1922781 defendant Newton Morgan yeoman 594529 594529 Newton, Morgan, of Bodenham, yeoman 0
3689183 1922781 1922781 defendant Newton Richard yeoman 594529 594529 Newton, Richard, of Bodenham, yeoman 1
3699330 1926007 1926007 defendant Stapull John husbandman 594529 594529 Stapull, John, of Bodenham, husbandman 0
3712017 1930076 1930076 defendant Newton David husbandman 594529 594529 Newton, David, of Bodenham, husbandman 0
3720321 1932636 1932636 defendant Newton Richard yeoman 594529 594529 Newton, Richard, of Bodenham, yeoman 1
3726301 1934496 1934496 defendant Newton Richard, junior yeoman 594529 594529 Newton, Richard, junior, of Bodenham, yeoman 0
3726304 1934496 1934496 defendant ap Prae Richard laborer 594529 594529 ap Prae, Richard, of of Bodenham, laborer 3
3729336 1935429 1935429 defendant Baker William husbandman 594529 594529 Baker, William, of Bodenham, husbandman 0
3742033 1939375 1939375 defendant Newton Richard yeoman 594529 594529 Newton, Richard, of Bodenham, yeoman 4
3744806 1940275 1940275 defendant Wyllyms James yeoman 594529 594529 Wyllyms, James, of Bodenham, yeoman 0
3750328 1942019 1942019 defendant Holande James yeoman 594529 594529 Holande, James, of Bodenham, yeoman 0
3755056 1943531 1943531 defendant Newton Morgan yeoman 594529 594529 Newton, Morgan, of Bodenham, yeoman 1
3755058 1943531 1943531 defendant Haynes William husbandman 594529 594529 Haynes, William, of Bodenham, husbandman 3
3755060 1943532 1943532 defendant Newton Morgan yeoman 594529 594529 Newton, Morgan, of Bodenham, yeoman 0
3762079 1945782 1945782 defendant Wysse Walter laborer 594529 594529 Wysse, Walter, of Bodenham, laborer 0
3762356 1945867 1945867 defendant Holande     594529 594529 Holande, , of Bodenham 0
3765803 1946968 1946968 defendant Holande James yeoman 594529 594529 Holande, James, of Bodenham, yeoman 0
3780201 1951533 1951533 defendant Morgan David tailor 594529 594529 Morgan, David, of Bodenham, tailor 0
3780202 1951533 1951533 defendant Edwardys Richard husbandman 594529 594529 Edwardys, Richard, of Bodenham, husbandman 1
3780519 1951636 1951636 defendant Holande Thomas husbandman 594529 594529 Holande, Thomas, of Bodenham, husbandman 1
3790746 1954930 1954930 defendant Holande James yeoman 594529 594529 Holande, James, of Bodenham, yeoman 1
3790747 1954930 1954930 defendant Holande Thomas husbandman 594529 594529 Holande, Thomas, of Bodenham, husbandman 2
3791365 1955136 1955136 defendant ap Rees Hugh husbandman 594529 594529 ap Rees, Hugh, of Bodenham, husbandman 1
3839293 1970218 1970218 defendant Heynes William husbandman 594529 594529 Heynes, William, of Bodenham, husbandman 0
3852172 1974277 1974277 defendant Heynes William husbandman 594529 594529 Heynes, William, of Bodenham, husbandman 0
3856870 1975778 1975778 defendant Hewis Thomas chaplain 594529 594529 Hewis, Thomas, of Bodenham, chaplain 2
3858068 1976175 1976175 defendant Bagge George clerk 594529 594529 Bagge, George, of Bodenham, clerk 1
3858913 1976471 1976471 defendant ap Rees Hugh husbandman 594529 594529 ap Rees, Hugh, of Bodenham, husbandman 0
3858914 1976471 1976471 defendant Heynes William husbandman 594529 594529 Heynes, William, of Bodenham, husbandman 1
3883596 1984783 1984783 defendant Clerke James yeoman 594529 594529 Clerke, James, of Bodenham, yeoman 0
3932838 2001276 2001276 defendant Ryse William husbandman 594529 594529 Ryse, William, of Bodenham, husbandman 32
3932839 2001276 2001276 defendant Ryle John husbandman 594529 594529 Ryle, John, of Bodenham, husbandman 33
3937931 2003019 2003019 defendant Rees William yeoman 594529 594529 Rees, William,of Bodenham, yeoman 1
3943442 2004822 2004822 defendant Evans Richard yeoman 594529 594529 Evans, Richard, of Bodenham, yeoman 0
3943443 2004822 2004822 defendant Edward Eichard laborer 594529 594529 Edward, Eichard, of Bodenham, laborer 1
3943444 2004822 2004822 defendant Willes Willliam laborer 594529 594529 Willes, Willliam, of Bodenham, laborer 2
3964942 2012345 2012345 defendant Wedge Roger yeoman 594529 594529 Wedge, Roger, of Bodenham, yeoman 0
3964943 2012345 2012345 defendant Slade Edward husbandman 594529 594529 Slade, Edward, of Bodenham, husbandman 1
3983023 2018706 2018706 plaintiff Slade William laborer 594529 594529 Slade, William, of Bodenham, laborer 0
4051568 2042979 2042979 defendant Ball John husbandman 594529 594529 Ball, John, of Bodenham, husbandman 0
4066057 2048147 2048147 defendant Pyvynche John yeoman 594529 594529 Pyvynche, John, of Bodenham, yeoman 0
4111838 2064486 2064486 defendant Aunsell Thomas yeoman 594529 594529 Aunsell, Thomas, of Bodenham, yeoman 0
4112716 2064809 2064809 defendant Went Richard   594529 594529 Went, Richard, of Bodenham, yeoman, son of John 0
4159379 2081348 2081348 defendant Ball John yeoman 594529 594529 Ball, John, of Bodenham, yeoman 2
4172529 2085855 2085855 defendant Edward Richard yeoman 594529 594529 Edward, Richard, of Bodenham, yeoman 0
4172530 2085855 2085855 defendant Gysham William yeoman 594529 594529 Gysham, William, of Bodenham, yeoman 1
4172531 2085855 2085855 defendant Gysam Thomas yeoman 594529 594529 Gysam, Thomas, of Bodenham, yeoman 2
4172532 2085855 2085855 defendant Grafton John laborer 594529 594529 Grafton, John, of Bodenham, laborer 3
4172533 2085855 2085855 defendant Thomas Richard laborer 594529 594529 Thomas, Richard, of Bodenham, laborer 4
4172534 2085855 2085855 defendant Taylor Alexander laborer 594529 594529 Taylor, Alexander, of Bodenham, laborer 5
4172535 2085855 2085855 defendant ap Hoell Lewis laborer 594529 594529 ap Hoell, Lewis, of Bodenham, laborer 6
4172536 2085855 2085855 defendant Witt Richard laborer 594529 594529 Witt, Richard, of Bodenham, laborer 7
4172537 2085855 2085855 defendant Aunsell Thomas laborer 594529 594529 Aunsell, Thomas, of Bodenham, laborer 8
4172538 2085855 2085855 defendant Whettston Henry laborer 594529 594529 Whettston, Henry, of Bodenham, laborer 9
4172954 2085993 2085993 defendant Hill Elizabeth widow 594529 594529 Hill, Elizabeth, of Bodenham, widow 0
4172955 2085993 2085993 defendant Hill Roger husbandman 594529 594529 Hill, Roger, of Bodenham, husbandman 1
4221398 2102983 2102983 defendant Hill Roger yeoman 594529 594529 Hill, Roger, of Bodenham, yeoman 1
4230097 2106017 2106017 defendant Hill Roger yeoman 594529 594529 Hill, Roger, of Bodenham, yeoman 1
4291667 2127095 2127095 defendant Smyth Roger yeoman 594529 594529 Smyth Roger, of Bodenham, yeoman 3
4305950 2132220 2132220 defendant Craswall Thomas yeoman 594529 594529 Craswall, Thomas, of Bodenham, yeoman 1
4307798 2132867 2132867 defendant Playne John   594529 594529 Playne, John, of Bodenham, freemason 0
4310943 2133974 2133974 defendant Caldowe Thomas tailor 594529 594529 Caldowe, Thomas, of Bodenham, tailor 3
4315564 2135553 2135553 defendant Beale Thomas, senior husbandman 594529 594529 Beale, Thomas, senior, of Bodenham, husbandman 0
4315565 2135553 2135553 defendant Beale Thomas, junior husbandman 594529 594529 Beale, Thomas, junior, of Bodenham, husbandman 1
4320702 2137335 2137335 defendant Playne John   594529 594529 Playne, John, of Bodenham, freemason 0
4322956 2138092 2138092 defendant Playne John   594529 594529 Playne, John, of Bodenham, mason 3
4327440 2139499 2139499 defendant Wente Richard yeoman 594529 594529 Wente, Richard, of Bodenham, yeoman 2
4331245 2140747 2140747 defendant Yevans David yeoman 594529 594529 Yevans, David, of Bodenham, yeoman 1
4331298 2140763 2140763 defendant Matye Nicholas yeoman 594529 594529 Matye, Nicholas, of Bodenham, yeoman 0
4331299 2140763 2140763 defendant Farmor Thomas yeoman 594529 594529 Farmor, Thomas, of Bodenham, yeoman 1
4374152 2155828 2155828 defendant Beale Thomas, senior yeoman 594529 594529 Beale, Thomas, senior, of Bodenham, yeoman 0
4374154 2155829 2155829 defendant Beale Thomas, junior yeoman 594529 594529 Beale, Thomas, junior, of Bodenham, yeoman 0
4374158 2155831 2155831 defendant Bealle Thomas, junior yeoman 594529 594529 Bealle, Thomas, junior, of Bodenham, yeoman 0
4383938 2159333 2159333 defendant Hill John tailor 594529 594529 Hill, John, of Bodenham, tailor 0
4384917 2159647 2159647 defendant Griffithes alias Gyottes Thomas weaver 594529 594529 Griffithes alias Gyottes, Thomas, of Bodenham, weaver 0
4384918 2159647 2159647 defendant Collas or Coltts Philip laborer 594529 594529 Collas or Coltts, Philip, of Bodenham, laborer 1
4385317 2159780 2159780 defendant Whetston Alexander yeoman 594529 594529 Whetston, Alexander, of Bodenham, yeoman 0
4424168 2172409 2172409 defendant Colles John   594529 594529 Colles, John, of Bodenham 0
4424170 2172409 2172409 defendant Bradefeld Richard de   594529 594529 Bradefeld, Richard de, of Bodenham, vicar 2
4456684 2187115 2187115 defendant Spenser William   594529 594529 Spenser, William, of Bodenham 0
4473306 2192310 2192310 defendant Loveday Thomas   594529 594529 Loveday, Thomas, of Bodenham 1
4539928 2212754 2212754 defendant Illam John   594529 594529 Illam, John, of Bodenham 0
4550883 2216210 2216210 defendant Hakele William   594529 594529 Hakele, William, of Bodenham 5
4619471 2237081 2237081 defendant Love Henry   594529 594529 Love, Henry, of Bodenham 0
4645004 2244611 2244611 defendant Illyngere John   594529 594529 Illyngere, John, of Bodenham 2
4655958 2247741 2247741 defendant Wyn Richard gent 594529 594529 Wyn, Richard, of Bodenham, gent 0
4670739 2256526 2256526 defendant Wyn Richard husbandman 594529 594529 Wyn, Richard, of Bodenham, husbandman 0
4670740 2256526 2256526 defendant Loveday Thomas husbandman 594529 594529 Loveday, Thomas, of Bodenham, husbandman 1
4673717 2257408 2257408 defendant Hayward Richard husbandman 594529 594529 Hayward, Richard, of Bodenham, husbandman 0
4673718 2257408 2257408 defendant Nowonne Hugh   594529 594529 Nowonne, Hugh, of Bodenham, mason 1
4673719 2257408 2257408 defendant Hayward Walter husbandman 594529 594529 Hayward, Walter, of Bodenham, husbandman 2
4673720 2257408 2257408 defendant Nowonne Richard husbandman 594529 594529 Nowonne, Richard, of Bodenham, husbandman 3

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);