names

119 rows where place_id = 586158

✎ 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
3588049 1863914 1863914 defendant Lycham John husbandman 586158 586158 Lycham, John, of Shuldham, husbandman 2
3595123 1866106 1866106 plaintiff Lytcham Stephen   586158 586158 Lytcham, Stephen, of Shuldham 0
3595124 1866106 1866106 defendant Lytcham John husbandman 586158 586158 Lytcham, John, of Shuldham, husbandman 0
3596013 1866381 1866381 defendant Chapman Henry husbandman 586158 586158 Chapman, Henry, of Shuldham, husbandman 0
3596014 1866381 1866381 defendant Mathewe Walter husbandman 586158 586158 Mathewe, Walter, of Shuldham, husbandman 1
3596015 1866381 1866381 defendant estgate William husbandman 586158 586158 estgate, William, of Shuldham, husbandman 2
3601555 1868141 1868141 defendant Hecham John, junior husbandman 586158 586158 Hecham, John, junior, of Shuldham, husbandman 1
3603360 1868723 1868723 defendant Goos John chaplain 586158 586158 Goos, John,of Shuldham, chaplain 0
3603409 1868738 1868738 defendant Lytcham John husbandman 586158 586158 Lytcham, John, of Shuldham, husbandman 3
3607964 1870141 1870141 defendant Couper alias Zowne John husbandman 586158 586158 Couper alias Zowne, John, of Shuldham, husbandman 2
3607965 1870141 1870141 defendant Goos John chaplain or husbandman 586158 586158 Goos, John, of Shuldham, chaplain or husbandman 3
3612723 1871626 1871626 defendant Shuldham Thomas gent 586158 586158 Shuldham, Thomas, of Shuldham, gent 0
3613934 1872011 1872011 defendant Hanes William husbandman 586158 586158 Hanes, William, of Shuldham, husbandman 2
3621528 1874276 1874276 defendant Goos William yeoman 586158 586158 Goos, William, of Shuldham, yeoman 1
3626093 1903020 1903020 defendant Taverner Richard husbandman 586158 586158 Taverner, Richard, of Shuldham, husbandman 2
3644380 1908659 1908659 defendant Ussher Richard husbandman 586158 586158 Ussher, Richard, of Shuldham, husbandman 0
3658627 1912953 1912953 defendant Knapp John butcher 586158 586158 Knapp, John, of Shuldham, butcher 0
3658628 1912953 1912953 defendant Elden John husbandman 586158 586158 Elden, John, of shuldham, husbandman 1
3734460 1937021 1937021 defendant Rycers John (legal representative) 586158 586158 Rycers, John, of Shuldham, gent, executors of 0
3734461 1937021 1937021 defendant Bray Martin yeoman 586158 586158 (Bray, Martin, of Shuldham, yeoman 1
3748189 1941363 1941363 defendant Rychers John (legal representative) 586158 586158 Rychers, John, of Shuldham, gent, executrix of 0
3836064 1969192 1969192 defendant Honnys Paul miller 586158 586158 Honnys, Paul, of Shuldham, miller 0
3853807 1974823 1974823 defendant Harpeley William husbandman 586158 586158 Harpeley, William, of Shuldham, husbandman 0
3921856 1997654 1997654 plaintiff Puttrell William   586158 586158 Puttrell, William, of Shuldham 0
3930727 2000627 2000627 defendant Meledy Richard yeoman 586158 586158 Meledy, Richard, of Shuldham, yeoman 3
3932932 2001304 2001304 defendant Swayne Thomas smith 586158 586158 Swayne, Thomas, of Shuldham, smith 0
3938565 2003241 2003241 defendant Palmer Thomas husbandman 586158 586158 Palmer, Thomas, of Shuldham, husbandman 0
3947135 2006066 2006066 defendant Knape Richard yeoman 586158 586158 Knape, Richard, of Shuldham, yeoman 0
3954081 2008500 2008500 defendant Elden John husbandman 586158 586158 Elden, John, of Shuldham, husbandman 0
3954082 2008500 2008500 defendant Ryckes Thomas husbandman 586158 586158 Ryckes, Thomas, of Shuldham, husbandman 1
3954083 2008500 2008500 defendant Odailis John husbandman 586158 586158 Odailis, John, of Shuldham, husbandman 2
4080491 2053335 2053335 defendant Wilcok Richard yeoman 586158 586158 Wilcok, Richard, of Shuldham, yeoman 2
4084588 2054764 2054764 defendant Dalyson Bartholomew husbandman 586158 586158 Dalyson, Bartholomew, of Shuldham, husbandman 2
4270100 2119583 2119583 defendant Smyth Leonard gent 586158 586158 Smyth, Leonard, of Shuldham, gent 0
4460445 2188331 2188331 defendant Gibbe John chaplain 586158 586158 Gibbe, John, of Shuldham, chaplain 0
4463324 2189221 2189221 plaintiff Trussebut Nicholas   586158 586158 Trussebut, Nicholas, of Shuldham 0
4463325 2189221 2189221 defendant Gille William   586158 586158 Gille, William, of Shuldham 0
4463326 2189221 2189221 defendant Barbourn John   586158 586158 Barbourn, John, of Shuldham 1
4463327 2189222 2189222 plaintiff Trussebut Nicholas   586158 586158 Trussebut, Nicholas, of Shuldham 0
4464503 2189566 2189566 defendant Gile William   586158 586158 Gile, William, of Shuldham 1
4497771 2199948 2199948 plaintiff Trussebut Lawrence   586158 586158 Trussebut, Lawrence, of Shuldham 1
4506808 2202597 2202597 defendant Woderove Robert Jones-servant   586158 586158 Woderove, Robert Jones-servant, of Shuldham 1
4530810 2209925 2209925 defendant Toke John   586158 586158 Toke, John, of Shuldham 6
4538633 2212360 2212360 plaintiff Trussebut Lawrence   586158 586158 Trussebut, Lawrence, of Shuldham 0
4538638 2212362 2212362 plaintiff Trussebut Nicholas   586158 586158 Trussebut, Nicholas, of Shuldham 0
4600580 2231405 2231405 plaintiff Took Henry   586158 586158 Took, Henry, of Shuldham 0
4637580 2242542 2242542 defendant Salman William   586158 586158 Salman, William, of Shuldham 3
4639967 2243196 2243196 defendant Toke Henry   586158 586158 Toke, Henry, of Shuldham 3
4689098 2262150 2262150 defendant Trussebut William husbandman 586158 586158 Trussebut, William, of Shuldham, husbandman 0
4765654 2285250 2285250 defendant Dolour John husbandman 586158 586158 Dolour, John, of Shuldham, husbandman 0
4800363 2296294 2296294 defendant Nicolos William husbandman 586158 586158 Nicolos, William, of Shuldham, husbandman 0
4800364 2296294 2296294 defendant Wroo Stephen husbandman 586158 586158 Wroo, Stephen, of Shuldham, husbandman 1
4800365 2296294 2296294 defendant Calmark John   586158 586158 Calmark, John, of Shuldham, shepherd 2
4803225 2297200 2297200 defendant Toke Henry yeoman 586158 586158 Toke, Henry, of Shuldham, yeoman 0
4873073 2318532 2318532 defendant Brigfeld John husbandman 586158 586158 (Brigfeld, John, of Shuldham, husbandman 4
4924023 2333952 2333952 defendant Muryell Richard yeoman 586158 586158 Muryell, Richard, of Shuldham, yeoman 1
4924536 2334112 2334112 defendant Geyst Thomas clerk 586158 586158 with Geyst, Thomas, of Shuldham, clerk 4
5052703 2372403 2372403 defendant Elveden alias Barbour Robert, junior husbandman 586158 586158 Elveden alias Barbour, Robert, junior, of Shuldham, husbandman 0
5073648 2378601 2378601 defendant Elveden Robert, junior husbandman 586158 586158 Elveden, Robert, junior, of Shuldham, husbandman 0
5092696 2384242 2384242 defendant Wenham John yeoman 586158 586158 Wenham, John, of Shuldham, yeoman 0
5127690 2394582 2394582 defendant Olveden John tailor 586158 586158 Olveden, John, of Shuldham, tailor 0
5129975 2395255 2395255 defendant Wenham John husbandman 586158 586158 Wenham, John, of Shuldham, husbandman 2
5146735 2400185 2400185 defendant Elveden John tailor 586158 586158 Elveden, John, of Shuldham, tailor 0
5146737 2400186 2400186 defendant Elveden John tailor 586158 586158 Elveden, John, of Shuldham, tailor 0
5168229 2406420 2406420 defendant Wenham John husbandman 586158 586158 Wenham John, of Shuldham, husbandman 2
5230525 2424543 2424543 defendant Barbour Simon yeoman 586158 586158 Barbour, Simon, of Shuldham, yeoman 5
5239000 2426996 2426996 defendant Barbour Robert husbandman 586158 586158 Barbour, Robert, of Shuldham, husbandman 2
5261033 2433564 2433564 defendant Wenham John husbandman 586158 586158 Wenham, John, of Shuldham, husbandman 2
5269444 2436161 2436161 defendant Elsden alias Barbour alias Boteler Robert husbandman 586158 586158 Elsden alias Barbour alias Boteler, Robert, of Shuldham, husbandman 0
5279388 2439056 2439056 defendant Nele Richard pedder 586158 586158 Nele, Richard, of Shuldham, pedder 5
5293471 2443060 2443060 defendant Heggeman Nicholas miller 586158 586158 Heggeman, Nicholas, of Shuldham, miller 0
5293472 2443060 2443060 defendant Gayton William husbandman 586158 586158 Gayton, William, of Shuldham, husbandman 1
5302197 2445617 2445617 defendant Appysby Henry husbandman 586158 586158 Appysby, Henry, of Shuldham, husbandman 0
5304439 2446324 2446324 defendant Holme Thomas yeoman 586158 586158 Holme, Thomas, of Shuldham, yeoman 0
5341347 2457484 2457484 defendant Holme Thomas husbandman 586158 586158 Holme, Thomas, of Shuldham, husbandman 0
5341348 2457484 2457484 defendant Chapman Henry husbandman 586158 586158 Chapman, Henry, of Shuldham, husbandman 1
5343200 2458067 2458067 defendant Chapman Henry yeoman 586158 586158 Chapman, Henry, of Shuldham, yeoman 0
5369235 2465977 2465977 defendant Holme Thomas mercer 586158 586158 Holme, Thomas, of Shuldham, mercer 2
5375018 2467779 2467779 defendant Chapman Henry yeoman 586158 586158 Chapman, Henry, of Shuldham, yeoman 1
5375445 2467907 2467907 defendant Chapman Henry yeoman 586158 586158 Chapman, Henry, of Shuldham, yeoman 1
5376262 2468170 2468170 plaintiff (not given) Thomas prior of Saunton or Stanton 586158 586158 Saunton or Stanton, Thomas, of Shuldham, prior of the church of the Blessed Mary 0
5380140 2469369 2469369 defendant Bosse John husbandman 586158 586158 Bosse, John, of Shuldham, husbandman 3
5382380 2470018 2470018 defendant Chapman Henry yeoman 586158 586158 Chapman, Henry, of Shuldham, yeoman 1
5384211 2470570 2470570 defendant bosse John   586158 586158 bosse, John, of Shuldham 3
5391515 2472646 2472646 defendant Chepman Henry yeoman 586158 586158 Chepman, Henry, of Shuldham, yeoman 1
5394134 2473383 2473383 plaintiff Cantele Robert   586158 586158 Cantele, Robert, of Shuldham 1
5403940 2476200 2476200 defendant Mathewe Walter husbandman 586158 586158 Mathewe, Walter, of Shuldham, husbandman 0
5403941 2476200 2476200 defendant Chapman Henry husbandman 586158 586158 Chapman, Henry, of Shuldham, husbandman 1
5404532 2476369 2476369 defendant Chapman Henry yeoman 586158 586158 Chapman, Henry, of Shuldham, yeoman 1
5405431 2476634 2476634 plaintiff Santon Thomas   586158 586158 Santon, Thomas, of Shuldham, prior 0
5407269 2477141 2477141 plaintiff Cantele Robert   586158 586158 Cantele, Robert, of Shuldham 1
5409306 2477752 2477752 defendant Bosse John husbandman 586158 586158 Bosse, John, of Shuldham, husbandman 2
5417062 2480016 2480016 defendant Mathewe Walter husbandman 586158 586158 Mathewe, Walter, of Shuldham, husbandman 0
5417063 2480016 2480016 defendant Chapman Henry husbandman 586158 586158 Chapman, Henry, of Shuldham, husbandman 1
5417662 2480206 2480206 defendant Chapman Henry   586158 586158 Chapman, Henry, of Shuldham 1
5419506 2480754 2480754 plaintiff (not given) Thomas prior of Stanton 586158 586158 Stanton, Thomas, of Shuldham, prior of the house & church of the BM 0
5428107 2483351 2483351 defendant Goos John yeoman 586158 586158 Goos, John, of Shuldham, yeoman 0
5434155 2485171 2485171 defendant Mathewe Walter husbandman 586158 586158 Mathewe, Walter, of Shuldham, husbandman 0
5434156 2485171 2485171 defendant Chaman Henry husbandman 586158 586158 Chaman, Henry, of Shuldham, husbandman 1
5461790 2493470 2493470 defendant Mathewe Walter husbandman 586158 586158 Mathewe, Walter, of Shuldham, husbandman 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);