names

56 rows where place_id = 591796

✎ 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
3605599 1869416 1869416 defendant Bondon Ralph husbandman 591796 591796 Bondon, Ralph, of Morchard Bishop, husbandman 0
3627055 1903323 1903323 defendant More Edward yeoman 591796 591796 More, Edward, of Morchard Bishop, yeoman 0
3627056 1903323 1903323 defendant Cornewe Thomas tailor 591796 591796 Cornewe, Thomas, of Morchard Bishop, tailor 1
3630465 1904361 1904361 defendant Carswyll Edward yeoman of the crown 591796 591796 Carswyll, Edward, of Morchard Bishop, gent, yeoman of the crown 3
3631316 1904604 1904604 defendant Browneston William yeoman 591796 591796 Browneston, William, of Morchard Bishop, yeoman 0
3639885 1907287 1907287 defendant Bowedon Robert yeoman 591796 591796 Bowedon, Robert, of Morchard Bishop, yeoman 2
3639886 1907287 1907287 defendant Towker Thomas yeoman 591796 591796 Towker, Thomas, of Morchard Bishop, yeoman 3
3639887 1907287 1907287 defendant Rowland Robert yeoman 591796 591796 Rowland, Robert, of Morchard Bishop, yeoman 4
3700212 1926299 1926299 defendant More Edward yeoman 591796 591796 More, Edward, of Morchard Bishop, yeoman 0
3706809 1928413 1928413 defendant Wyot Alexander yeoman 591796 591796 Wyot, Alexander, of Morchard Bishop, yeoman 1
3709090 1929142 1929142 defendant Squyer William yeoman 591796 591796 Squyer, William, of Morchard Bishop, yeoman 0
3712937 1930366 1930366 defendant Blakeden alias Bowdon Robert carpenter 591796 591796 Blakeden alias Bowdon, Robert, of Morchard Bishop, carpenter 0
3717948 1931914 1931914 defendant Wyott Alexander yeoman 591796 591796 Wyott, Alexander, of Morchard Bishop, yeoman 0
3728371 1935117 1935117 defendant Blakedon Robert carpenter 591796 591796 Blakedon, Robert, of Morchard Bishop, carpenter 0
3743707 1939913 1939913 defendant Blakedon alias Bowdon Robert carpenter 591796 591796 Blakedon alias Bowdon, Robert, of Morchard Bishop, carpenter 0
3756494 1944005 1944005 defendant More Edward yeoman 591796 591796 More, Edward, of Morchard Bishop, yeoman 0
3792135 1955393 1955393 defendant More Edward yeoman 591796 591796 More, Edward, of Morchard Bishop, yeoman 0
3797977 1957265 1957265 defendant Whyte Richard husbandman 591796 591796 Whyte, Richard, of Morchard Bishop, husbandman 2
3799159 1957646 1957646 defendant More Edward yeoman 591796 591796 More, Edward, of Morchard Bishop, yeoman 3
3845887 1972269 1972269 defendant Ford William husbandman 591796 591796 Ford, William, of Morchard Bishop, husbandman 0
3855959 1975486 1975486 defendant Sherlond Walter husbandman 591796 591796 Sherlond, Walter, of Morchard Bishop, husbandman 0
3858755 1976413 1976413 plaintiff Bromston William   591796 591796 Bromston, William, of Morchard Bishop 0
3869890 1980173 1980173 defendant Sherlond Walter husbandman 591796 591796 Sherlond, Walter, of Morchard Bishop, husbandman 0
3876393 1982351 1982351 defendant Wyat Alexander yeoman 591796 591796 Wyat, Alexander, of Morchard Bishop, yeoman 1
3880848 1983864 1983864 defendant Buson Richard husbandman 591796 591796 Buson, Richard, of Morchard Bishop, husbandman 0
3881618 1984112 1984112 defendant Toker Robert husbandman 591796 591796 Toker, Robert, of Morchard Bishop, husbandman 0
3891675 1987470 1987470 defendant Bromscomb William   591796 591796 Bromscomb, William, of Morchard Bishop, franklin 0
3911614 1994206 1994206 defendant Toker Robert husbandman 591796 591796 Toker, Robert, of Morchard Bishop, husbandman 0
3933914 2001640 2001640 defendant Grygge Henry   591796 591796 Grygge, Henry, of Morchard Bishop, mason 0
3933915 2001640 2001640 defendant Oxenbeare John butcher 591796 591796 Oxenbeare, John, of Morchard Bishop, butcher 1
3933916 2001640 2001640 defendant Prouse Peter husbandman 591796 591796 Prouse, Peter, of Morchard Bishop, husbandman 2
3963893 2011977 2011977 defendant Chilcott William yeoman 591796 591796 Chilcott, William, of Morchard Bishop, yeoman 0
3964707 2012263 2012263 defendant Chylcott William yeoman 591796 591796 Chylcott, William, of Morchard Bishop, yeoman 0
3982064 2018344 2018344 plaintiff Rowland Thomas tucker 591796 591796 Rowland, Thomas, of Morchard Bishop, tucker 0
4054401 2043963 2043963 defendant Ponde Philip husbandman 591796 591796 Ponde, Philip, of Morchard Bishop, husbandman 1
4054402 2043963 2043963 defendant Smorte John husbandman 591796 591796 Smorte, John, of Morchard Bishop, husbandman 2
4072405 2050434 2050434 defendant Venner Hugh butcher 591796 591796 Venner, Hugh, of Morchard Bishop, butcher 1
4285535 2124877 2124877 defendant Beare Roger clerk 591796 591796 Beare, Roger, of Morchard Bishop, clerk 0
4317999 2136407 2136407 defendant Brounscombe Henry husbandman 591796 591796 Brounscombe, Henry, of Morchard Bishop, husbandman 0
4358793 2150308 2150308 defendant Pounde Philip husbandman 591796 591796 Pounde, Philip, of Morchard Bishop, husbandman 1
4708010 2267877 2267877 defendant Bury Walter gent 591796 591796 Bury, Walter, of Morchard Bishop, gent 0
4727657 2273891 2273891 defendant More Robert laborer 591796 591796 More, Robert, of Morchard Bishop, laborer 4
4786530 2291836 2291836 defendant Bury Walter gent 591796 591796 Bury, Walter, of Morchard Bishop, gent 0
4946623 2340942 2340942 defendant Milford Thomas husbandman 591796 591796 Milford, Thomas, of Morchard Bishop, husbandman 0
5007886 2359196 2359196 defendant Eston John, sen gent 591796 591796 Eston, John, sen, of Morchard Bishop, gent 0
5032912 2366513 2366513 defendant Cade John husbandman 591796 591796 Cade, John, of Morchard Bishop, husbandman 3
5064217 2375840 2375840 defendant Shybbroke Henry husbandman 591796 591796 Shybbroke, Henry, of Morchard Bishop, husbandman 0
5523484 2512173 2512173 defendant White John husbandman 591796 591796 White, John, of Morchard Bishop, husbandman 2
5541637 2517491 2517491 defendant Bondon or Boudon Randolph husbandman 591796 591796 Bondon or Boudon, Randolph, of Morchard Bishop, husbandman 0
5555729 2521669 2521669 defendant Gater John husbandman 591796 591796 Gater, John, of Morchard Bishop, husbandman 1
5564762 2524280 2524280 defendant Toly Robert husbandman 591796 591796 Toly, Robert, of Morchard Bishop, husbandman 1
5564763 2524280 2524280 defendant White Richard weaver 591796 591796 White, Richard, of Morchard Bishop, weaver 2
5571096 2526107 2526107 defendant Howe John husbandman 591796 591796 Howe, John, of Morchard Bishop, husbandman 2
5590916 2532135 2532135 defendant Wasam William chaplain 591796 591796 Wasam, William, of Morchard Bishop, chaplain 1
5599167 2534618 2534618 defendant Blakedan Robert husbandman 591796 591796 Blakedan, Robert, of Morchard Bishop, husbandman 0
5632246 2554112 2554112 defendant Sperke Elias carpenter 591796 591796 Sperke, Elias, of Morchard Bishop, carpenter 0

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