names

45 rows where place_id = 652088

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3921571 1997557 1997557 defendant Albrouth Thomas husbandman 652088 652088 Albrouth, Thomas, of Sutton in the Marsh, husbandman 0
4129197 2070743 2070743 defendant Wilkes John yeoman 652088 652088 Wilkes, John, of Sutton in the Marsh, yeoman 0
4139510 2074493 2074493 defendant Launder Thomas yeoman 652088 652088 Launder, Thomas, of Sutton in the Marsh, yeoman 3
4151807 2078746 2078746 defendant Bust William yeoman 652088 652088 Bust, William, of Sutton in the Marsh, yeoman 0
4172457 2085829 2085829 defendant Bust William yeoman 652088 652088 Bust, William, of Sutton in the Marsh, yeoman 0
4184853 2090211 2090211 defendant Watson Francis clerk 652088 652088 Watson, Francis, of Sutton in the Marsh, clerk 0
4185954 2090576 2090576 defendant Watson Francis clerk 652088 652088 Watson, Francis, of Sutton in the Marsh, clerk 0
4186711 2090843 2090843 defendant Kyrk Lionel yeoman 652088 652088 Kyrk, Lionel, of Sutton in the Marsh, yeoman 0
4186714 2090844 2090844 defendant Kyrke Lionel yeoman 652088 652088 Kyrke, Lionel, of Sutton in the Marsh, yeoman 0
4189942 2091986 2091986 defendant Cooke William husbandman 652088 652088 Cooke, William, of Sutton in the Marsh, husbandman 0
4189943 2091986 2091986 defendant Seerbye William husbandman 652088 652088 Seerbye, William, of Sutton in the Marsh, husbandman 1
4189944 2091986 2091986 defendant Seerbye Richard husbandman 652088 652088 Seerbye, Richard, of Sutton in the Marsh, husbandman 2
4280472 2123078 2123078 defendant Hesell Humphrey miller 652088 652088 Hesell, Humphrey, of Sutton in the Marsh, miller 0
4280473 2123078 2123078 defendant Hesell William husbandman 652088 652088 Hesell, William, of Sutton in the Marsh, husbandman 1
4283017 2123962 2123962 defendant Launder Thomas yeoman 652088 652088 Launder, Thomas, of Sutton in the Marsh, yeoman 0
4283022 2123963 2123963 defendant Launder Thomas yeoman 652088 652088 Launder, Thomas, of Sutton in the Marsh, yeoman 0
4345619 2145736 2145736 defendant Lecke Richard yeoman 652088 652088 Lecke, Richard, of Sutton in the Marsh, yeoman 0
4358530 2150220 2150220 defendant Launder Thomas yeoman 652088 652088 Launder, Thomas, of Sutton in the Marsh, yeoman 0
4521048 2206921 2206921 defendant Sutton Robert de   652088 652088 Sutton, Robert de, of Sutton in the Marsh 0
4753172 2281375 2281375 defendant Roulandson Alan husbandman 652088 652088 Roulandson, Alan, of Sutton in the Marsh, husbandman 0
4829135 2305152 2305152 defendant Rowelandson Alan husbandman 652088 652088 Rowelandson, Alan, of Sutton in the Marsh, husbandman 0
4829136 2305152 2305152 defendant Grayseson John husbandman 652088 652088 Grayseson, John, of Sutton in the Marsh, husbandman 1
4829139 2305153 2305153 defendant Rowelandson Alan husbandman 652088 652088 Rowelandson, Alan, of Sutton in the Marsh, husbandman 0
4829140 2305153 2305153 defendant Grayseson John husbandman 652088 652088 together with Grayseson, John, of Sutton in the Marsh, husbandman 1
4993008 2354793 2354793 defendant Grayson William husbandman 652088 652088 Grayson, William, of Sutton in the Marsh, husbandman 0
5187115 2411960 2411960 defendant Stigge John chaplain 652088 652088 Stigge, John, of Sutton in the Marsh, chaplain 0
5275822 2437999 2437999 defendant Raweland William husbandman 652088 652088 Raweland, William, of Sutton in the Marsh, husbandman 0
5275823 2437999 2437999 defendant Raweland Robert husbandman 652088 652088 Raweland, Robert, of Sutton in the Marsh, husbandman 1
5278394 2438787 2438787 defendant Rooke William husbandman 652088 652088 Rooke, William, of Sutton in the Marsh, husbandman 1
5372514 2467001 2467001 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the Marsh, husbandman 1
5372517 2467002 2467002 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the marsh, husbandman 1
5403804 2476161 2476161 defendant West William husbandman 652088 652088 West, William, of Sutton in the Marsh, husbandman 0
5415507 2479579 2479579 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the Marsh, husbandman 1
5421764 2481446 2481446 defendant Scotte William clerk 652088 652088 Scotte, William, of Sutton in the Marsh, clerk 0
5421765 2481446 2481446 defendant Scotte Thomas husbandman 652088 652088 Scotte, Thomas, of Sutton in the Marsh, husbandman 1
5431843 2484491 2484491 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the Marsh, husbandman 1
5431846 2484492 2484492 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the Marsh, husbandman 1
5431849 2484493 2484493 defendant Gote William husbandman 652088 652088 Gote, William, of Sutton in the Marsh, husbandman 1
5435923 2485686 2485686 defendant Grayson William husbandman 652088 652088 Grayson,William, of Sutton in the Marsh, husbandman 1
5441605 2487407 2487407 defendant Scotte Thomas   652088 652088 Scotte, Thomas, of Sutton in the Marsh 1
5450809 2490131 2490131 defendant Grayson William husbandman 652088 652088 Grayson, William, of Sutton in the Marsh, husbandman 1
5450948 2490174 2490174 defendant Rouland Robert husbandman 652088 652088 Rouland,Robert, of Sutton in the Marsh, husbandman 0
5462923 2493821 2493821 defendant Grayson William husbandman 652088 652088 Grayson, William, of Sutton in the Marsh, husbandman 1
5463079 2493869 2493869 defendant Rouland Robert husbandman 652088 652088 Rouland, Robert, of Sutton in the Marsh, husbandman 0
5474461 2497344 2497344 defendant Grayson William husbandman 652088 652088 Grayson, William, of Sutton in the Marsh, 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);