names

67 rows where place_id = 591598

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604935 1869207 1869207 defendant Smyth John husbandman 591598 591598 Smyth, John, of Sotherey, husbandman 0
3604936 1869207 1869207 defendant Nochon John husbandman 591598 591598 Nochon, John, of Sotherey, husbandman 1
3604937 1869207 1869207 defendant Bolymer John husbandman 591598 591598 Bolymer, John, of Sotherey, husbandman 2
3604938 1869207 1869207 defendant Grene John husbandman 591598 591598 Grene, John, of Sotherey, husbandman 3
3604939 1869207 1869207 defendant Bovys or Bonys Robert husbandman 591598 591598 Bovys or Bonys, Robert, of Sotherey, husbandman 4
3633680 1905344 1905344 defendant Fyssher John husbandman 591598 591598 Fyssher, John, of Sotherey, husbandman 2
3668048 1915946 1915946 defendant Hergrey William husbandman 591598 591598 Hergrey, William, of Sotherey, husbandman 2
3668049 1915946 1915946 defendant Drewe Thomas husbandman 591598 591598 Drewe, Thomas, of Sotherey, husbandman 3
3668050 1915946 1915946 defendant Whyte Walter husbandman 591598 591598 Whyte, Walter, of Sotherey, husbandman 4
3698711 1925813 1925813 defendant Robertson John, senior husbandman 591598 591598 Robertson, John, senior, of Sotherey, husbandman 0
3698712 1925813 1925813 defendant Robertson John, junior husbandman 591598 591598 Robertson, John, junior, of Sotherey, husbandman 1
3698713 1925813 1925813 defendant Wattys Richard husbandman 591598 591598 Wattys, Richard, of Sotherey, husbandman 2
3698714 1925813 1925813 defendant Skott Thomas husbandman 591598 591598 Skott, Thomas, of Sotherey, husbandman 3
3706769 1928402 1928402 defendant Pygott Thomas waterman 591598 591598 Pygott, Thomas, of Sotherey, waterman 1
3710541 1929618 1929618 defendant Whyte Walter husbandman 591598 591598 Whyte, Walter, of Sotherey, husbandman 1
3712873 1930345 1930345 defendant Drew Thomas laborer 591598 591598 Drew, Thomas, of Sotherey, laborer 0
3712874 1930345 1930345 defendant Bygot Thomas waterman 591598 591598 Bygot, Thomas, of Sotherey, waterman 1
3712875 1930345 1930345 defendant Crosse Thomas waterman 591598 591598 Crosse, Thomas, of Sotherey, waterman 2
3712876 1930345 1930345 defendant Robynson John, junior   591598 591598 Robynson, John, junior, of Sotherey 3
3712877 1930345 1930345 defendant Sherford Alice widow 591598 591598 Sherford, Alice, of Sotherey, widow 4
3724774 1934033 1934033 defendant Smyth Robert husbandman 591598 591598 Smyth, Robert, of Sotherey, husbandman 0
3728104 1935050 1935050 defendant Melton Robert husbandman 591598 591598 Melton, Robert, of Sotherey, husbandman 0
3728105 1935050 1935050 defendant Robynson John husbandman 591598 591598 Robynson, John, of Sotherey, husbandman 1
3728106 1935050 1935050 defendant Hardgrave William, junior husbandman 591598 591598 Hardgrave, William, junior, of Sotherey, husbandman 2
3728107 1935050 1935050 defendant Mayson John laborer 591598 591598 Mayson, John, of Sotherey, laborer 3
3741088 1939076 1939076 defendant Bygott Thomas waterman 591598 591598 Bygott, Thomas, of Sotherey, waterman 1
3741089 1939076 1939076 defendant Smyth Robert husbandman 591598 591598 Smyth, Robert, of Sotherey, husbandman 2
3741090 1939076 1939076 defendant Amyson John husbandman 591598 591598 Amyson, John, of Sotherey, husbandman 3
3766745 1947260 1947260 defendant Reynold William husbandman 591598 591598 Reynold, William, of Sotherey, husbandman 1
3766746 1947260 1947260 defendant Merston Thomas husbandman 591598 591598 Merston, Thomas, of Sotherey, husbandman 2
3780492 1951631 1951631 defendant Pygote Thomas husbandman 591598 591598 Pygote, Thomas, of Sotherey, husbandman 1
3784601 1952970 1952970 defendant Marson Thomas husbandman 591598 591598 Marson, Thomas, of Sotherey, husbandman 0
3823540 1965264 1965264 defendant Melton Robert husbandman 591598 591598 Melton, Robert, of Sotherey, husbandman 0
3844309 1971771 1971771 defendant Suttylbye Thomas laborer 591598 591598 Suttylbye, Thomas, of Sotherey, laborer 0
3845227 1972068 1972068 defendant Sherfurth William husbandman 591598 591598 Sherfurth, William, of Sotherey, husbandman 0
3845228 1972068 1972068 defendant Sherfurth John husbandman 591598 591598 Sherfurth, John, of Sotherey, husbandman 1
3846325 1972404 1972404 defendant Hargrave William husbandman 591598 591598 Hargrave, William, of Sotherey, husbandman 0
3886238 1985650 1985650 defendant Wylsy Robert clerk 591598 591598 Wylsy, Robert, of Sotherey, clerk 0
3887225 1985994 1985994 defendant Wylsey Robert clerk 591598 591598 Wylsey, Robert, of Sotherey, clerk 0
3904828 1991878 1991878 defendant Wyrley Robert clerk 591598 591598 Wyrley, Robert, of Sotherey, clerk 1
3974336 2015594 2015594 defendant Kebyll Edmund husbandman 591598 591598 Kebyll, Edmund, of Sotherey, husbandman 0
3974338 2015595 2015595 defendant Kebill Edmund yeoman 591598 591598 Kebill, Edmund, of Sotherey, yeoman 0
3975284 2015924 2015924 defendant Keble Edmund yeoman 591598 591598 Keble, Edmund, of Sotherey, yeoman 1
3979827 2017540 2017540 defendant Glewe alias Thomlyn John husbandman 591598 591598 Glewe alias Thomlyn, John, of Sotherey, husbandman 2
3979828 2017540 2017540 defendant Hargrave John husbandman 591598 591598 Hargrave, John, of Sotherey, husbandman 3
3995858 2023267 2023267 defendant Kelle John yeoman 591598 591598 Kelle, John, of Sotherey, yeoman 0
4084590 2054765 2054765 defendant Idell Lionell clerk 591598 591598 Idell, Lionell, of Sotherey, clerk 0
4175919 2087054 2087054 defendant Jaxson John husbandman 591598 591598 Jaxson, John, of Sotherey, husbandman 1
4202839 2096538 2096538 defendant Jaxson John husbandman 591598 591598 Jaxson, John, of Sotherey, husbandman 0
4285746 2124955 2124955 defendant Bruett Richard husbandman 591598 591598 Bruett, Richard, of Sotherey, husbandman 0
4587697 2227559 2227559 defendant Collesson Thomas   591598 591598 Collesson, Thomas, of Sotherey 0
4643369 2244165 2244165 defendant Colson Thomas   591598 591598 Colson, Thomas, of Sotherey 3
4781591 2290255 2290255 defendant Cachero John clerk 591598 591598 Cachero, John, of Sotherey, clerk 0
4817550 2301579 2301579 defendant Swyft John laborer 591598 591598 Swyft, John, of Sotherey, laborer 1
5220463 2421682 2421682 defendant Beele Peter husbandman 591598 591598 Beele, Peter, of Sotherey, husbandman 0
5278209 2438723 2438723 defendant Blake Peter gent 591598 591598 Blake, Peter, of Sotherey, gent 1
5278212 2438724 2438724 defendant Blake Peter gent 591598 591598 Blake, Peter, of Sotherey, gent 1
5375019 2467779 2467779 defendant Essex William husbandman 591598 591598 Essex, William, of Sotherey, husbandman 2
5377088 2468423 2468423 defendant Tounsend John yeoman 591598 591598 Tounsend, John, of Sotherey, yeoman 0
5377089 2468423 2468423 defendant Colson John husbandman 591598 591598 Colson, John, of Sotherey, husbandman 1
5382381 2470018 2470018 defendant Essex William husbandman 591598 591598 Essex, William, of Sotherey, husbandman 2
5391516 2472646 2472646 defendant Essex William husbandman 591598 591598 Essex, William, of Sotherey, husbandman 2
5404533 2476369 2476369 defendant Essex William husbandman 591598 591598 Essex, William, of Sotherey, husbandman 2
5417663 2480206 2480206 defendant Essex William husbandman 591598 591598 Essex, William, of Sotherey, husbandman 2
5423651 2482038 2482038 defendant Nogdon John husbandman 591598 591598 Nogdon, John, of Sotherey, husbandman Froste, Thomas, of Helgey, Norf, husbandman 2
5423652 2482038 2482038 defendant Bondys Robert husbandman 591598 591598 Bondys, Robert, of Sotherey, husbandman 3
5555571 2521625 2521625 defendant Reynold Stephen husbandman 591598 591598 Reynold, Stephen, of Sotherey, husbandman 1

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