names

54 rows where place_id = 604993

✎ 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
3659975 1913379 1913379 defendant Kent John husbandman 604993 604993 Kent, John, of Clapham, husbandman 2
3692219 1923733 1923733 defendant Cokeyn Robert gent 604993 604993 Cokeyn, Robert, of Clapham, gent 0
3707238 1928555 1928555 plaintiff Legh Roger gent 604993 604993 Legh, Roger, of Clapham, gent 0
3707245 1928556 1928556 plaintiff Legh Roger gent 604993 604993 Legh, Roger, of Clapham, gent 0
3736434 1937639 1937639 defendant Legh Roger gent 604993 604993 Legh, Roger, of Clapham, gent 0
3749684 1941812 1941812 defendant Legh Roger gent 604993 604993 Legh, Roger, of Clapham, gent 0
3765747 1946952 1946952 defendant Caryswell Richard husbandman 604993 604993 Caryswell, Richard, of Clapham, husbandman 2
3766892 1947311 1947311 defendant Wilcok alias Wilson William husbandman 604993 604993 Wilcok alias Wilson, William, of Clapham, husbandman 0
3768562 1947812 1947812 defendant Hogeson Robert husbandman 604993 604993 Hogeson, Robert, of Clapham, husbandman 2
3901009 1990565 1990565 defendant Clapham Robert gent 604993 604993 Clapham, Robert, of Clapham, gent 0
3961898 2011255 2011255 defendant Wassher Edward yeoman 604993 604993 Wassher, Edward, of Clapham, yeoman 0
3986018 2019768 2019768 plaintiff Wayte Anthony (legal representative) 604993 604993 Wayte, Anthony, of Clapham, gent, executrix of 0
4026549 2034147 2034147 defendant Clapham William gent 604993 604993 Clapham, William, of Clapham, gent 3
4026554 2034148 2034148 defendant Clapham William gent 604993 604993 Clapham, William, of Clapham, gent 3
4180618 2088705 2088705 defendant Prockter Stephen clerk 604993 604993 Prockter, Stephen, of Clapham, clerk 0
4180619 2088705 2088705 defendant Procter William husbandman 604993 604993 Procter, William, of Clapham, husbandman 1
4230458 2106146 2106146 defendant Procter Alexander husbandman 604993 604993 Procter, Alexander, of Clapham, husbandman 1
4338734 2143300 2143300 defendant Lynsey George husbandman 604993 604993 Lynsey, George, of Clapham, husbandman 0
4340877 2144081 2144081 defendant Robinson Thomas gent 604993 604993 Robinson, Thomas, of Clapham, gent 1
4349393 2147051 2147051 defendant Lynsley George yeoman 604993 604993 Lynsley, George, of Clapham, yeoman 0
4364413 2152330 2152330 defendant Robinson Thomas gent 604993 604993 Robinson, Thomas, of Clapham, gent 1
4387924 2160591 2160591 defendant Lynsey George husbandman 604993 604993 Lynsey, George, of Clapham, husbandman 0
4412401 2168737 2168737 defendant Holden William yeoman 604993 604993 Holden, William, of Clapham, yeoman 0
4421131 2171501 2171501 defendant Batisson William   604993 604993 Batisson, William, of Clapham 2
4423033 2172062 2172062 defendant Rous Adam   604993 604993 Rous, Adam, of Clapham, son of John 0
4423034 2172062 2172062 defendant Rous John   604993 604993 Rous, John, of Clapham, son of John 1
4537999 2212165 2212165 defendant Dowebyggyng John de   604993 604993 Dowebyggyng, John de, of Clapham 2
4548137 2215355 2215355 defendant Lamborn Richard   604993 604993 Lamborn, Richard, of Clapham 0
4548140 2215356 2215356 defendant Lamborn Richard   604993 604993 together with Lamborn, Richard, of Clapham 1
4578300 2224707 2224707 plaintiff Clapham Robert de   604993 604993 Clapham, Robert de, of Clapham 0
4578302 2224707 2224707 defendant Burgh William de   604993 604993 Burgh, William de, of Clapham 0
4578303 2224707 2224707 defendant Geldhird William   604993 604993 Geldhird, William, of Clapham 1
4578304 2224707 2224707 defendant Laweson Thomas   604993 604993 Laweson, Thomas, of Clapham 2
4586947 2227319 2227319 defendant Alan Adam   604993 604993 Alan, Adam, of Clapham 0
4586948 2227319 2227319 defendant Alan John   604993 604993 Alan, John, of Clapham 1
4602592 2232029 2232029 defendant Harper Thomas   604993 604993 Harper, Thomas, of Clapham 1
4602594 2232029 2232029 defendant Cristenmas Richard   604993 604993 Cristenmas, Richard, of Clapham 3
4700952 2265701 2265701 defendant Crokesson Thomas yeoman 604993 604993 Crokesson, Thomas, of Clapham, yeoman 0
4766538 2285524 2285524 defendant Clapham John gent 604993 604993 Clapham, John, of Clapham, gent 1
4839547 2308290 2308290 defendant Clapham Thomas yeoman 604993 604993 Clapham, Thomas, of Clapham, yeoman 1
4839551 2308290 2308290 defendant Richardson William yeoman 604993 604993 Richardson, William, of Clapham, yeoman 5
4867473 2316794 2316794 defendant Tabeler Roger husbandman 604993 604993 Tabeler, Roger, of Clapham, husbandman 0
4874631 2319008 2319008 defendant Johnson Thomas yeoman 604993 604993 Johnson, Thomas, of Clapham, yeoman 5
4874632 2319008 2319008 defendant Wodeward John yeoman 604993 604993 Wodeward, John, of Clapham, yeoman 6
4926686 2334764 2334764 defendant Jamson Henry yeoman 604993 604993 Jamson, Henry, of Clapham, yeoman 6
5082456 2381252 2381252 defendant Clapham Alexander yeoman 604993 604993 Clapham, Alexander, of Clapham, yeoman 0
5082464 2381255 2381255 defendant Clapham Alexander yeoman 604993 604993 Clapham, Alexander, of Clapham, yeoman 0
5311444 2448451 2448451 defendant atte Well Richard husbandman 604993 604993 atte Well, Richard, of Clapham, husbandman 0
5335742 2455754 2455754 defendant Wylkynson William husbandman 604993 604993 Wylkynson, William, of Clapham, husbandman 4
5335743 2455754 2455754 defendant Hunter William   604993 604993 Hunter, William, of Clapham, mason 5
5563662 2523981 2523981 defendant Proctour Thomas yeoman 604993 604993 Proctour, Thomas, of Clapham, yeoman 2
5574689 2527158 2527158 defendant Tye Thomas husbandman 604993 604993 Tye, Thomas, of Clapham, husbandman 2
5576882 2527814 2527814 defendant Richardson William yeoman 604993 604993 Richardson, William, of Clapham, yeoman 0
5607799 2537345 2537345 defendant Ireland William gent 604993 604993 Ireland, William, of Clapham, gent 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);