names

150 rows where place_id = 586023

✎ 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
3587721 1863807 1863807 defendant Stapilton Thomas yeoman 586023 586023 Stapilton, Thomas, of Laughton, yeoman 0
3587722 1863807 1863807 defendant Haryet John yeoman 586023 586023 Haryet, John, of Laughton, yeoman 1
3587723 1863807 1863807 defendant Pudsey Richard yeoman 586023 586023 Pudsey, Richard, of Laughton, yeoman 2
3587724 1863807 1863807 defendant Vynehawe Thomas laborer 586023 586023 Vynehawe, Thomas, of Laughton, laborer 3
3587725 1863807 1863807 defendant Adborough John laborer 586023 586023 Adborough, John, of Laughton, laborer 4
3613204 1871785 1871785 defendant Waghorn John husbandman 586023 586023 Waghorn, John, of Laughton, husbandman 0
3613205 1871785 1871785 defendant Tanner John husbandman 586023 586023 Tanner, John, of Laughton, husbandman 1
3622938 1874702 1874702 defendant Thomas John yeoman 586023 586023 Thomas, John, of Laughton, yeoman 0
3624362 1875154 1875154 defendant Whever John laborer 586023 586023 Whever, John, of Laughton, laborer 2
3625300 1875450 1875450 defendant Lunsford William gent 586023 586023 Lunsford, William, of Laughton, gent 0
3647953 1909758 1909758 defendant Petybon Richard yeoman or tanner 586023 586023 Petybon, Richard, of Laughton, yeoman or tanner 0
3663522 1914518 1914518 defendant Colyns Robert husbandman 586023 586023 Colyns, Robert, of Laughton, husbandman 0
3679371 1919611 1919611 defendant Marsshe John husbandman 586023 586023 Marsshe, John,of Laughton, husbandman 0
3696498 1925133 1925133 defendant (not given) Thomas rector of Totheby 586023 586023 Totheby, Thomas, of Laughton, rector of Langton 0
3698588 1925775 1925775 defendant Hoke Richard yeoman 586023 586023 Hoke, Richard, of Laughton, yeoman 0
3698589 1925775 1925775 defendant Wygsell Thomas yeoman 586023 586023 Wygsell, Thomas, of Laughton, yeoman 1
3718101 1931951 1931951 defendant Chamber Thomas gent 586023 586023 Chamber, Thomas, of Laughton, gent 1
3758477 1944646 1944646 defendant Puppe Peter husbandman 586023 586023 Puppe, Peter, of Laughton, husbandman 2
3759088 1944828 1944828 plaintiff Chamber Thomas gent 586023 586023 Chamber, Thomas, of Laughton, gent 0
3759089 1944828 1944828 defendant Colyns Robert husbandman 586023 586023 Colyns, Robert, of Laughton, husbandman 0
3768875 1947914 1947914 defendant Chamber Thomas gent 586023 586023 Chamber, Thomas, of Laughton, gent 0
3776503 1950404 1950404 defendant Puppe Peter husbandman 586023 586023 Puppe, Peter, of Laughton, husbandman 2
3778865 1951104 1951104 defendant Colyn Robert husbandman 586023 586023 Colyn, Robert, of Laughton, husbandman 0
3779835 1951426 1951426 defendant Ryddylstone William gent 586023 586023 Ryddylstone, William, of Laughton, gent 0
3840571 1970613 1970613 defendant Pratt Thomas husbandman 586023 586023 Pratt, Thomas, of Laughton, husbandman 0
3854381 1975008 1975008 defendant Toller William husbandman 586023 586023 Toller, William, of Laughton, husbandman 0
3876619 1982427 1982427 plaintiff Coote Roger husbandman 586023 586023 Coote, Roger, of Laughton, husbandman 3
3956754 2009430 2009430 defendant More John yeoman 586023 586023 More, John, of Laughton, yeoman 1
3956755 2009430 2009430 defendant Keyle George yeoman 586023 586023 Keyle, George, of Laughton, yeoman 2
3956756 2009430 2009430 defendant Boterell John yeoman 586023 586023 Boterell, John, of Laughton, yeoman 3
4065583 2047981 2047981 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4065584 2047981 2047981 defendant Pupp John yeoman 586023 586023 Pupp, John, of Laughton, yeoman 1
4065586 2047982 2047982 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4065587 2047982 2047982 defendant Pupp John yeoman 586023 586023 Pupp, John, of Laughton, yeoman 1
4074792 2051284 2051284 defendant Lacye Robert yeoman 586023 586023 Lacye, Robert, of Laughton, yeoman 0
4081119 2053559 2053559 defendant Pancras William turner 586023 586023 Pancras, William, of Laughton, turner 1
4089577 2056561 2056561 defendant Maydyson or Madyson Christopher gent 586023 586023 Maydyson or Madyson, Christopher, of Laughton, gent 0
4094334 2058312 2058312 defendant Ruddington William husbandman 586023 586023 Ruddington, William, of Laughton, husbandman 1
4097800 2059546 2059546 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4097802 2059547 2059547 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4111034 2064195 2064195 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4111036 2064196 2064196 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4114901 2065616 2065616 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4114903 2065617 2065617 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4129858 2070989 2070989 defendant Catte John (legal representative) 586023 586023 Catte, John, of Laughton, yeoman, administratrix of 0
4129859 2070989 2070989 defendant Catte Margaret widow 586023 586023 Catte, Margaret, of Laughton, widow 1
4130001 2071034 2071034 defendant Laughton John gent 586023 586023 Laughton, John, of Laughton, gent 1
4132117 2071799 2071799 defendant Weneham John yeoman 586023 586023 Weneham, John, of Laughton, yeoman 0
4140277 2074766 2074766 defendant Jervys Edward husbandman 586023 586023 Jervys, Edward, of Laughton, husbandman 0
4140278 2074766 2074766 defendant Orton Richard husbandman 586023 586023 Orton, Richard, of Laughton, husbandman 1
4146128 2076794 2076794 defendant Catte John (legal representative) 586023 586023 Catte, John, of Laughton, yeoman, administratrix of 0
4165121 2083309 2083309 defendant Jervis Edward husbandman 586023 586023 Jervis, Edward, of Laughton, husbandman 0
4165122 2083309 2083309 defendant Orton Richard husbandman 586023 586023 Orton, Richard, of Laughton, husbandman 1
4165360 2083392 2083392 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4171576 2085525 2085525 defendant Pupp John yeoman 586023 586023 Pupp, John, of Laughton, yeoman 1
4171578 2085526 2085526 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4171581 2085527 2085527 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4172138 2085716 2085716 defendant Weneham John gent 586023 586023 Weneham, John, of Laughton, gent 0
4177543 2087622 2087622 defendant Weneham John gent 586023 586023 Weneham, John, of Laughton, gent 0
4181633 2089061 2089061 defendant Hylles Edward yeoman 586023 586023 Hylles, Edward, of Laughton, yeoman 0
4187879 2091259 2091259 defendant Fitzwilliams Augustine gent 586023 586023 Fitzwilliams, Augustine, of Laughton, gent 2
4187882 2091260 2091260 defendant Fitzwilliams Austin gent 586023 586023 Fitzwilliams, Austin, of Laughton, gent 1
4209824 2098996 2098996 defendant Wenham John gent 586023 586023 Wenham, John, of Laughton, gent 0
4225040 2104228 2104228 defendant Newnam William carpenter 586023 586023 Newnam, William, of Laughton, or of Eatonbridge, Kent, carpenter 0
4235716 2108059 2108059 defendant Wenham John yeoman 586023 586023 Wenham, John, of Laughton, yeoman 0
4296549 2128866 2128866 defendant Dighton William gent 586023 586023 Dighton, William, of Laughton, gent 2
4304844 2131829 2131829 defendant Cooke George butcher 586023 586023 Cooke, George, of Laughton, butcher 0
4350006 2147261 2147261 defendant Laughton John, senior gent 586023 586023 Laughton, John, senior, of Laughton, gent 0
4375672 2156359 2156359 defendant Halle Richard yeoman 586023 586023 Halle, Richard, of Laughton, yeoman 1
4379454 2157733 2157733 defendant Steveinge or Stephin William yeoman 586023 586023 Steveinge or Stephin, William, of Laughton, yeoman 0
4545396 2214484 2214484 defendant Sibly Philip   586023 586023 Sibly, Philip, of Laughton 0
4569005 2221889 2221889 defendant West William   586023 586023 West, William, of Laughton, parson 0
4683745 2260518 2260518 defendant Weston William clerk 586023 586023 Weston, William, of Laughton, clerk 0
4690405 2262558 2262558 defendant Shermon Richard ploughman 586023 586023 Shermon, Richard, of Laughton, ploughman 0
4690406 2262558 2262558 defendant Smyth John smith 586023 586023 Smyth, John, of Laughton, smith 1
4691317 2262806 2262806 defendant Wygeyn Richard   586023 586023 Wygeyn, Richard, of Laughton, bailiff 0
4719529 2271448 2271448 defendant Elyn John   586023 586023 Elyn, John, of Laughton 0
4727764 2273926 2273926 defendant Hunt William   586023 586023 Hunt, William, of Laughton, mason 0
4762078 2284124 2284124 defendant Pelham John   586023 586023 Pelham, John, of Laughton, knight 0
4773412 2287658 2287658 defendant Draper John yeoman 586023 586023 Draper, John, of Laughton, yeoman 0
4784960 2291308 2291308 defendant Pelham John   586023 586023 Pelham, John, of Laughton, knight 0
4855763 2313177 2313177 defendant Edward James clerk 586023 586023 Edward, James, of Laughton, clerk 1
4864994 2316029 2316029 defendant Pelham Joan   586023 586023 Pelham, Joan, of Laughton, widow of Pelham, John, senior, knight 0
4864996 2316029 2316029 defendant Chamber Thomas yeoman 586023 586023 Chamber, Thomas, of Laughton, yeoman 2
4872418 2318336 2318336 defendant Sherman Richard husbandman 586023 586023 Sherman, Richard, of Laughton, husbandman 2
4927846 2335144 2335144 defendant Boton John husbandman 586023 586023 Boton, John, of Laughton, husbandman 0
4933516 2336867 2336867 defendant atte Bregge Henry husbandman 586023 586023 atte Bregge, Henry, of Laughton, husbandman 2
4933517 2336867 2336867 defendant atte Bregge John, senior husbandman 586023 586023 atte Bregge, John, senior, of Laughton, husbandman 3
4933518 2336867 2336867 defendant atte Bregge John, junior husbandman 586023 586023 atte Bregge, John, junior, of Laughton, husbandman 4
4933523 2336868 2336868 defendant atte Bregge Henry, senior husbandman 586023 586023 atte Bregge, Henry, senior, of Laughton, husbandman 2
4933538 2336871 2336871 plaintiff Zouch alias Pelham John (legal representative) 586023 586023 Zouch alias Pelham, John, of Laughton, Lord of the Manor, executor of 0
4933543 2336872 2336872 plaintiff Zouch alias Pelham John (legal representative) 586023 586023 Zouch alias Pelham, John, of Laughton, Lord of the Manor, executor of 0
4933549 2336873 2336873 plaintiff Zouch alias Pelham John (legal representative) 586023 586023 Zouch alias Pelham, John, of Laughton, Lord of the Manor, executor of 0
4933556 2336874 2336874 plaintiff Zouch alias Pelham John   586023 586023 Zouch alias Pelham, John, of Laughton, Lord of the Manor 0
4958779 2344595 2344595 defendant atte Bregge Henry, senior husbandman 586023 586023 atte Bregge, Henry, senior, of Laughton, husbandman 0
5029129 2365396 2365396 defendant Blythe William (legal representative) 586023 586023 Blythe, William, of Laughton, husbandman, executor of 1
5058211 2374011 2374011 defendant Boton John husbandman 586023 586023 Boton, John, of Laughton, husbandman 0
5084026 2381724 2381724 defendant Thomas Thomas yeoman 586023 586023 Thomas, Thomas, of Laughton, yeoman 0
5105053 2387910 2387910 defendant Thomas Thomas yeoman 586023 586023 Thomas, Thomas, of Laughton, yeoman 0
5114276 2390569 2390569 defendant Swane Simon husbandman 586023 586023 Swane, Simon, of Laughton, 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);