names

110 rows where place_id = 588765

✎ 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
3595500 1866227 1866227 defendant Merde Thomas husbandman 588765 588765 Merde, Thomas, of Hadnam, husbandman 0
3595696 1866282 1866282 defendant Bocher alias Glover John husbandman 588765 588765 Bocher alias Glover, John, of Hadnam, husbandman 1
3626798 1903229 1903229 defendant Barnard Alice widow 588765 588765 Barnard, Alice, of Hadnam, widow 0
3669735 1916480 1916480 defendant Fryday Richard husbandman 588765 588765 Fryday, Richard, of Hadnam, husbandman 0
3671183 1916958 1916958 defendant Davy Thomas husbandman 588765 588765 Davy, Thomas, of Hadnam, husbandman 1
3677238 1918926 1918926 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 3
3677348 1918964 1918964 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3679506 1919660 1919660 defendant Martyn Richard husbandman 588765 588765 Martyn, Richard, of Hadnam, husbandman 2
3685102 1921485 1921485 defendant Barnard William husbandman 588765 588765 Barnard, William, of Hadnam, husbandman 0
3686525 1921936 1921936 defendant Bernard William husbandman 588765 588765 Bernard, William, of Hadnam, husbandman 0
3687855 1922365 1922365 defendant Barnard William husbandman 588765 588765 Barnard, William, of Hadnam, husbandman 0
3687858 1922366 1922366 defendant Goode Richard husbandman 588765 588765 Goode, Richard, of Hadnam, husbandman 1
3693676 1924215 1924215 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 0
3693678 1924215 1924215 defendant Benett John husbandman 588765 588765 Benett, John, of Hadnam, husbandman 2
3697683 1925497 1925497 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3700288 1926327 1926327 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 1
3709168 1929164 1929164 plaintiff Playtour William   588765 588765 Playtour, William, of Hadnam 0
3709169 1929164 1929164 defendant Barnard William, senior husbandman 588765 588765 Barnard, William, senior, of Hadnam, husbandman 0
3713825 1930622 1930622 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 0
3714404 1930801 1930801 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3722403 1933270 1933270 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 2
3722404 1933270 1933270 defendant Chapman John husbandman 588765 588765 Chapman, John, of Hadnam, husbandman 3
3722415 1933270 1933270 defendant More William husbandman 588765 588765 More, William, of Hadnam, husbandman 14
3733183 1936610 1936610 defendant Barnard William husbandman 588765 588765 Barnard, William, of Hadnam, husbandman 0
3733184 1936610 1936610 defendant Marten Richard laborer 588765 588765 Marten, Richard, of Hadnam, laborer 1
3744768 1940263 1940263 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3746230 1940730 1940730 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3757229 1944245 1944245 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3757580 1944350 1944350 defendant Gelley John gent 588765 588765 Gelley, John, of Hadnam, gent 0
3757581 1944350 1944350 defendant Eversegge William tailor 588765 588765 Eversegge, William, of Hadnam, tailor 1
3757585 1944351 1944351 defendant Gelley John gent 588765 588765 Gelley, John, of Hadnam, gent 0
3757586 1944351 1944351 defendant Eversegge William tailor 588765 588765 Eversegge, William, of Hadnam, tailor 1
3769740 1948189 1948189 defendant Benet John husbandman 588765 588765 Benet, John, of Hadnam, husbandman 1
3793149 1955717 1955717 defendant Gelley John gent 588765 588765 Gelley, John, of Hadnam, gent 0
3793150 1955717 1955717 defendant Eversegge William tailor 588765 588765 Eversegge, William, of Hadnam, tailor 1
3796074 1956635 1956635 defendant Symond Owen laborer 588765 588765 Symond, Owen, of Hadnam, laborer 0
3797382 1957068 1957068 defendant Barnard alias Barnett Richard yeoman 588765 588765 Barnard alias Barnett, Richard, of Hadnam, yeoman 0
3797383 1957069 1957069 plaintiff Gelly John gent 588765 588765 Gelly, John, of Hadnam, gent 0
3797384 1957069 1957069 plaintiff Eversegge William tailor 588765 588765 Eversegge, William, of Hadnam, tailor 1
3797389 1957070 1957070 defendant Barnard alias Barnet William yeoman 588765 588765 Barnard alias Barnet, William, of Hadnam, yeoman 0
3797391 1957071 1957071 defendant Barnard alias Barnet William yeoman 588765 588765 Barnard alias Barnet, William, of Hadnam, yeoman 0
3797392 1957071 1957071 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 1
3814487 1962446 1962446 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3818436 1963664 1963664 defendant Dorront John husbandman 588765 588765 Dorront, John, of Hadnam, husbandman 1
3821470 1964609 1964609 defendant Benett John yeoman 588765 588765 Benett, John, of Hadnam, yeoman 0
3830801 1967515 1967515 defendant Huntley Henry yeoman 588765 588765 Huntley, Henry, of Hadnam, yeoman 0
3830802 1967515 1967515 defendant Bennett John husbandman 588765 588765 Bennett, John, of Hadnam, husbandman 1
3852940 1974539 1974539 defendant Benet John husbandman 588765 588765 Benet, John, of Hadnam, husbandman 0
3867376 1979321 1979321 defendant Benett John husbandman 588765 588765 Benett, John, of Hadnam, husbandman 0
3867378 1979322 1979322 defendant Benett John husbandman 588765 588765 Benett, John, of Hadnam, husbandman 0
3891437 1987403 1987403 defendant Astell Edward gent 588765 588765 Astell, Edward, of Hadnam, gent 0
3891773 1987504 1987504 defendant Barnard Richard yeoman 588765 588765 Barnard, Richard, of Hadnam, yeoman 0
3892175 1987637 1987637 defendant Cotte John husbandman 588765 588765 Cotte, John, of Hadnam, husbandman 1
3893639 1988100 1988100 defendant Chesse Richard clerk 588765 588765 Chesse, Richard, of Hadnam, clerk 0
3896602 1989072 1989072 defendant Astell Edward gent 588765 588765 Astell, Edward, of Hadnam, gent 0
3897064 1989237 1989237 defendant Lawrence John husbandman 588765 588765 Lawrence, John, of Hadnam, husbandman 2
3904513 1991757 1991757 defendant Vener Richard butcher 588765 588765 Vener, Richard, of Hadnam, butcher 0
3905668 1992170 1992170 defendant Astell Edward gent 588765 588765 Astell, Edward, of Hadnam, gent 0
3906039 1992308 1992308 defendant Bernard Richard yeoman 588765 588765 Bernard, Richard, of Hadnam, yeoman 0
3906443 1992448 1992448 defendant Brown Thomas yeoman 588765 588765 Brown, Thomas, of Hadnam, yeoman 0
3972404 2014920 2014920 defendant Woodbridge John husbandman 588765 588765 Woodbridge, John, of Hadnam, husbandman 0
4034443 2036990 2036990 defendant Syred William clerk 588765 588765 Syred, William, of Hadnam, clerk 1
4152425 2078957 2078957 defendant Fytche John gent 588765 588765 Fytche, John, of Hadnam, gent 0
4218430 2101947 2101947 defendant Ratclyff James yeoman 588765 588765 Ratclyff, James, of Hadnam, yeoman 0
4222356 2103309 2103309 defendant Ratclyff James yeoman 588765 588765 Ratclyff, James, of Hadnam, or of Chipping Wickham, yeoman 0
4295504 2128477 2128477 defendant Rowell Richard laborer 588765 588765 Rowell, Richard, of Hadnam, laborer 1
4357329 2149792 2149792 defendant Peirce Richard yeoman 588765 588765 Peirce, Richard, of Hadnam, yeoman 0
4886325 2322582 2322582 defendant Malyn Robert husbandman 588765 588765 Malyn, Robert, of Hadnam, husbandman 0
4886326 2322582 2322582 defendant Chesteleyn John husbandman 588765 588765 Chesteleyn, John, of Hadnam, husbandman 1
4886327 2322582 2322582 defendant Forster Robert husbandman 588765 588765 Forster, Robert, of Hadnam, husbandman 2
4892390 2324359 2324359 plaintiff Lucy John   588765 588765 Lucy, John, of Hadnam 0
4905751 2328399 2328399 plaintiff Lucy John   588765 588765 Lucy, John, of Hadnam 0
4958363 2344468 2344468 defendant Meryweder Richard husbandman 588765 588765 Meryweder, Richard, of Hadnam, husbandman 1
4970728 2348187 2348187 defendant Pelle William husbandman 588765 588765 Pelle, William, of Hadnam, husbandman 0
5079862 2380455 2380455 defendant Alys Thomas, junior yeoman 588765 588765 Alys, Thomas, junior, of Hadnam, yeoman 0
5079864 2380456 2380456 defendant Berner William, senior husbandman 588765 588765 Berner, William, senior, of Hadnam, husbandman 0
5222229 2422207 2422207 defendant Fryday Giles husbandman 588765 588765 Fryday, Giles, of Hadnam, husbandman 0
5222231 2422208 2422208 defendant Fryday Giles husbandman 588765 588765 Fryday, Giles, of Hadnam, husbandman 0
5333804 2455182 2455182 defendant Wyndout John, junior husbandman 588765 588765 Wyndout, John, junior, of Hadnam, husbandman 1
5335827 2455780 2455780 defendant Myng Richard husbandman 588765 588765 Myng, Richard, of Hadnam, husbandman 0
5403037 2475948 2475948 defendant Bernard John, junior husbandman 588765 588765 Bernard, John, junior, of Hadnam, husbandman 3
5403038 2475948 2475948 defendant Parkee William laborer 588765 588765 Parkee, William, of Hadnam, laborer 4
5403039 2475948 2475948 defendant Rodbrigge Thomas husbandman 588765 588765 Rodbrigge, Thomas, of Hadnam, husbandman 5
5403040 2475948 2475948 defendant Lane Robert laborer 588765 588765 Lane, Robert, of Hadnam, laborer 6
5413951 2479102 2479102 defendant Cole Richard husbandman 588765 588765 Cole, Richard, of Hadnam, husbandman 4
5416042 2479729 2479729 defendant Barnard Richard   588765 588765 Barnard, Richard, of Hadnam 2
5416044 2479729 2479729 defendant Parkee William   588765 588765 Parkee, William, of Hadnam 4
5416045 2479729 2479729 defendant Wodebrigge Thomas husbandman 588765 588765 Wodebrigge, Thomas, of Hadnam, husbandman 5
5416046 2479729 2479729 defendant Lane Robert   588765 588765 Lane, Robert, of Hadnam 6
5432698 2484743 2484743 defendant Wodbrigge Thomas husbandman 588765 588765 Wodbrigge, Thomas, of Hadnam, husbandman 4
5432699 2484743 2484743 defendant Lane Robert laborer 588765 588765 Lane, Robert, of Hadnam, laborer 5
5483451 2499997 2499997 defendant Whittok Richard husbandman 588765 588765 Whittok, Richard, of Hadnam, husbandman 0
5502252 2505628 2505628 defendant Myng William husbandman 588765 588765 Myng, William, of Hadnam, husbandman 0
5558508 2522436 2522436 defendant Marten Richard husbandman 588765 588765 Marten, Richard, of Hadnam, husbandman 3
5563303 2523863 2523863 defendant Marten Richard husbandman 588765 588765 Marten, Richard, of Hadnam, husbandman 2
5564070 2524106 2524106 defendant Myng William husbandman 588765 588765 Myng, William, of Hadnam, husbandman 0
5569470 2525634 2525634 defendant Bernard William husbandman 588765 588765 Bernard, William, of Hadnam, husbandman 0
5573349 2526763 2526763 defendant Radclyff James (legal representative) 588765 588765 Radclyff, James, of Hadnam, beer brewer, executors of 0
5573352 2526763 2526763 defendant Tayllour alias Harres Robert husbandman 588765 588765 Tayllour alias Harres, Robert, of Hadnam, husbandman 3
5573353 2526763 2526763 defendant Hardyng John husbandman 588765 588765 Hardyng, John, of Hadnam, husbandman 4

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