names

281 rows where place_id = 598512

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632824 1905079 1905079 defendant Taillour John husbandman 598512 598512 Taillour, John, of Horton, husbandman 1
3632825 1905079 1905079 defendant Taillour Richard husbandman 598512 598512 Taillour, Richard, of Horton, husbandman 2
3636017 1906060 1906060 defendant Arney Thomas gent 598512 598512 Arney, Thomas, of Horton, gent 0
3642243 1908022 1908022 defendant Best John husbandman 598512 598512 Best, John, of Horton, husbandman 2
3645459 1908986 1908986 defendant Odyham John, senior husbandman 598512 598512 Odyham, John, senior, of Horton, husbandman 2
3645460 1908986 1908986 defendant Odyham John, junior husbandman 598512 598512 Odyham, John, junior, of Horton, husbandman 3
3645469 1908987 1908987 defendant Odyham John, senior husbandman 598512 598512 Odyham, John, senior, of Horton, husbandman 5
3645470 1908987 1908987 defendant Odyham John, junior husbandman 598512 598512 Odyham, John, junior, of Horton, husbandman 6
3647358 1909561 1909561 defendant Legh Thomas husbandman 598512 598512 Legh, Thomas, of Horton, husbandman 0
3647359 1909561 1909561 defendant Smyth John husbandman 598512 598512 Smyth, John, of Horton, husbandman 1
3647362 1909562 1909562 defendant Legh Thomas husbandman 598512 598512 Legh, Thomas, of Horton, husbandman 0
3647363 1909562 1909562 defendant Smyth John husbandman 598512 598512 Smyth, John, of Horton, husbandman 1
3647367 1909563 1909563 defendant Legh Thomas husbandman 598512 598512 Legh, Thomas, of Horton, husbandman 1
3647368 1909563 1909563 defendant Smyth John husbandman 598512 598512 Smyth, John, of Horton, husbandman 2
3655399 1911947 1911947 defendant Terlee William husbandman 598512 598512 Terlee, William, of Horton, husbandman 0
3675138 1918252 1918252 defendant Falthorp Robert yeoman 598512 598512 Falthorp, Robert, of Horton, yeoman 1
3686376 1921897 1921897 defendant Egge Christopher yeoman 598512 598512 Egge, Christopher, of Horton, yeoman 0
3686377 1921897 1921897 defendant Wolsonholme William husbandman 598512 598512 Wolsonholme, William, of Horton, husbandman 1
3686378 1921897 1921897 defendant Smyth Richard husbandman 598512 598512 Smyth, Richard, of Horton, husbandman 2
3686379 1921897 1921897 defendant Bront John husbandman 598512 598512 Bront, John, of Horton, husbandman 3
3696733 1925204 1925204 defendant Edwardys John yeoman 598512 598512 Edwardys, John, of Horton, yeoman 0
3701653 1926758 1926758 defendant Best Richard husbandman 598512 598512 Best, Richard, of Horton, husbandman 0
3701654 1926758 1926758 defendant Nott or Nett John laborer 598512 598512 Nott or Nett, John, of Horton, laborer 1
3701655 1926758 1926758 defendant Paterson Andrew laborer 598512 598512 Paterson, Andrew, of Horton, laborer 2
3710439 1929583 1929583 defendant Edward John yeoman 598512 598512 Edward, John, of Horton, yeoman 0
3718562 1932082 1932082 defendant Gyrdeler John husbandman 598512 598512 Gyrdeler, John, of Horton, husbandman 0
3744466 1940173 1940173 plaintiff Balnett John yeoman 598512 598512 Balnett, John, of Horton, yeoman 0
3751166 1942290 1942290 defendant Wode Thomas yeoman 598512 598512 Wode, Thomas, of Horton, yeoman 0
3764730 1946633 1946633 defendant Arney Richard yeoman 598512 598512 Arney, Richard, of Horton, yeoman 0
3764733 1946633 1946633 defendant Tyler Thomas yeoman 598512 598512 Tyler, Thomas, of Horton, yeoman 3
3766710 1947249 1947249 defendant Daccombe John gent 598512 598512 Daccombe, John, of Horton, gent 0
3771778 1948874 1948874 defendant Kyngescote William gent 598512 598512 Kyngescote, William, of Horton, gent 2
3800000 1957923 1957923 defendant Clarke Robert yeoman 598512 598512 Clarke, Robert, of Horton, yeoman 3
3812646 1961845 1961845 defendant Peryns John husbandman 598512 598512 Peryns, John, of Horton, husbandman 0
3821489 1964616 1964616 defendant Smyth Richard yeoman 598512 598512 Smyth, Richard, of Horton, yeoman 0
3821490 1964616 1964616 defendant Wolssenam Thomas husbandman 598512 598512 Wolssenam, Thomas, of Horton, husbandman 1
3821491 1964616 1964616 defendant Bradwell William husbandman 598512 598512 Bradwell, William, of Horton, husbandman 2
3821650 1964656 1964656 defendant Garlik Thomas husbandman 598512 598512 Garlik, Thomas, of Horton, husbandman 0
3822551 1964956 1964956 defendant Reve Joan widow 598512 598512 Reve, Joan, of Horton, widow 0
3830004 1967279 1967279 defendant Heth Richard husbandman 598512 598512 Heth, Richard, of Horton, husbandman 0
3832141 1967962 1967962 defendant Barrett Robert laborer 598512 598512 Barrett, Robert, of Horton, laborer 1
3834544 1968741 1968741 defendant Miller Richard yeoman 598512 598512 Miller, Richard, of Horton, yeoman 1
3841026 1970764 1970764 defendant Johnson John husbandman 598512 598512 Johnson, John, of Horton, husbandman 1
3849331 1973388 1973388 defendant Miller Richard husbandman 598512 598512 Miller, Richard, of Horton, husbandman 0
3850115 1973626 1973626 defendant Miller Richard yeoman 598512 598512 Miller, Richard, of Horton, yeoman 1
3852658 1974438 1974438 plaintiff Rodley Edward merchant 598512 598512 Rodley, Edward, of Horton, merchant 0
3862381 1977610 1977610 defendant Newenton John husbandman 598512 598512 Newenton, John, of Horton, husbandman 0
3865002 1978495 1978495 defendant Miller Richard yeoman 598512 598512 Miller, Richard, of Horton, yeoman 1
3878649 1983106 1983106 defendant Garleke Thomas yeoman 598512 598512 Garleke, Thomas, of Horton, yeoman 0
3878651 1983107 1983107 defendant Garleke Thomas yeoman 598512 598512 Garleke, Thomas, of Horton, yeoman 0
3891445 1987406 1987406 defendant Lawkeland Robert laborer 598512 598512 Lawkeland, Robert, of Horton, laborer 2
3892207 1987643 1987643 defendant Miller Richard yeoman 598512 598512 Miller, Richard, of Horton, yeoman 1
3897571 1989399 1989399 defendant Bothe Matthew yeoman 598512 598512 Bothe, Matthew, of Horton, yeoman 3
3898209 1989609 1989609 defendant Mone John (legal representative) 598512 598512 Mone, John, of Horton, yeoman, executors of 0
3898213 1989610 1989610 defendant Mone John (legal representative) 598512 598512 Mone, John, of Horton, yeoman, executors of 0
3898797 1989800 1989800 defendant Chatterton John yeoman 598512 598512 Chatterton, John, of Horton, yeoman 0
3902498 1991067 1991067 plaintiff Edwardes John   598512 598512 Edwardes, John, of Horton 0
3905108 1991972 1991972 plaintiff Karlyk Thomas   598512 598512 Karlyk, Thomas, of Horton 1
3929444 2000192 2000192 defendant Wharton Thomas husbandman 598512 598512 Wharton, Thomas, of Horton, husbandman 0
3931811 2000944 2000944 plaintiff Edwardes John yeoman 598512 598512 Edwardes, John, of Horton, yeoman 0
3946128 2005722 2005722 defendant Savacre John husbandman 598512 598512 Savacre, John, of Horton, husbandman 0
3946129 2005722 2005722 defendant Davys William husbandman 598512 598512 Davys, William, of Horton, husbandman 1
3946130 2005722 2005722 defendant Jankyn Howell laborer 598512 598512 Jankyn, Howell, of Horton, laborer 2
3968094 2013465 2013465 defendant Powell William yeoman 598512 598512 Powell, William, of Horton, yeoman 0
3972387 2014914 2014914 defendant Skynner Christopher husbandman 598512 598512 Skynner, Christopher, of Horton, Cumber, husbandman 1
3989888 2021136 2021136 defendant Morley John blacksmith 598512 598512 Morley, John, of Horton, blacksmith 0
3990032 2021188 2021188 defendant Shippulbotham James butcher 598512 598512 Shippulbotham, James, of Horton, butcher 0
3990033 2021188 2021188 defendant Smyth William husbandman 598512 598512 Smyth, William, of Horton, husbandman 1
3990034 2021188 2021188 defendant Smyth Richard husbandman 598512 598512 Smyth, Richard, of Horton, husbandman 2
3990036 2021188 2021188 defendant Fenton Thomas husbandman 598512 598512 Fenton, Thomas, of Horton, husbandman 4
4047543 2041573 2041573 defendant Walton Edward yeoman 598512 598512 Walton, Edward, of Horton, yeoman 0
4056527 2044720 2044720 defendant Laborne Thomas blacksmith 598512 598512 Laborne, Thomas, of Horton, blacksmith 2
4056543 2044724 2044724 defendant Laborne Thomas blacksmith 598512 598512 Laborne, Thomas, of Horton, blacksmith 2
4098911 2059938 2059938 defendant Lawe Robert yeoman 598512 598512 Lawe, Robert, of Horton, yeoman 0
4128428 2070460 2070460 defendant Emotte John clothier 598512 598512 Emotte, John, of Horton, clothier 1
4128481 2070476 2070476 defendant Lewes William yeoman 598512 598512 Lewes, William, of Horton, yeoman 1
4128482 2070476 2070476 defendant Dreakatt William yeoman 598512 598512 Dreakatt, William, of Horton, yeoman 2
4129238 2070759 2070759 defendant Allysander Edward husbandman 598512 598512 Allysander, Edward, of Horton, husbandman 1
4129619 2070899 2070899 defendant Hayne Richard yeoman 598512 598512 Hayne, Richard, of Horton, yeoman 0
4140379 2074804 2074804 defendant Neale Richard yeoman 598512 598512 Neale, Richard, of Horton, yeoman 0
4151856 2078761 2078761 defendant Emott or Ematte John clothier 598512 598512 Emott or Ematte, John, of Horton, clothier 1
4160603 2081784 2081784 defendant Ryley Nicholas husbandman 598512 598512 Ryley, Nicholas, of Horton, husbandman 0
4161946 2082249 2082249 defendant Unnyon John gent 598512 598512 Unnyon, John, of Horton, gent 0
4162736 2082523 2082523 defendant Malkyn John, junior yeoman 598512 598512 Malkyn, John, junior, of Horton, yeoman 0
4164476 2083093 2083093 defendant Walton Edward husbandman 598512 598512 Walton, Edward, of Horton, husbandman 1
4174733 2086632 2086632 defendant Nowell Christopher yeoman 598512 598512 Nowell, Christopher, of Horton, yeoman 3
4176373 2087213 2087213 defendant Ematt John clothier 598512 598512 Ematt, John, of Horton, clothier 0
4184325 2090019 2090019 defendant Malkyn John yeoman 598512 598512 Malkyn, John, of Horton, yeoman 1
4199605 2095413 2095413 defendant Ematt John clothier 598512 598512 Ematt, John, of Horton, clothier 0
4211508 2099582 2099582 defendant Sayntbarbe Thomas gent 598512 598512 Sayntbarbe, Thomas, of Horton, gent 0
4211509 2099582 2099582 defendant Deane James yeoman 598512 598512 Deane, James, of Horton, yeoman 1
4211510 2099582 2099582 defendant Hooper Edward yeoman 598512 598512 Hooper, Edward, of Horton, yeoman 2
4211511 2099582 2099582 defendant Parker John, senior husbandman 598512 598512 Parker, John, senior, of Horton, husbandman 3
4211512 2099582 2099582 defendant Nott Thomas husbandman 598512 598512 Nott, Thomas, of Horton, husbandman 4
4219408 2102289 2102289 defendant Gerrard William gent 598512 598512 Gerrard, William, of Horton, gent 0
4219410 2102289 2102289 defendant Hull John yeoman 598512 598512 Hull, John, of Horton, yeoman 2
4219411 2102289 2102289 defendant Garton William yeoman 598512 598512 Garton, William, of Horton, yeoman 3
4290299 2126583 2126583 defendant Edge Richard husbandman 598512 598512 Edge, Richard, of Horton, husbandman 0
4298174 2129447 2129447 defendant Tanner William husbandman 598512 598512 Tanner, William, of Horton, husbandman 0
4308489 2133124 2133124 defendant Hunte Agnes widow 598512 598512 Hunte, Agnes, of Horton, widow 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);