names

95 rows where place_id = 586524

✎ 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
3588948 1864193 1864193 defendant Rokysby Osbert yeoman 586524 586524 Rokysby, Osbert, of Swanton Morley, yeoman 9
3621330 1874212 1874212 defendant Trendyll Robert husbandman 586524 586524 Trendyll, Robert, of Swanton Morley, husbandman 0
3621334 1874213 1874213 defendant Trendyll Robert husbandman 586524 586524 Trendyll, Robert, of Swanton Morley, husbandman 0
3633720 1905355 1905355 defendant Parson John yeoman 586524 586524 Parson, John, of Swanton Morley, yeoman 2
3648243 1909848 1909848 defendant Pakeman Thomas yeoman 586524 586524 Pakeman, Thomas, of Swanton Morley, yeoman 1
3705638 1928044 1928044 defendant Brome Thomas husbandman 586524 586524 Brome, Thomas, of Swanton Morley, husbandman 3
3715808 1931230 1931230 defendant Pyllett Walter husbandman 586524 586524 Pyllett, Walter, of Swanton Morley, husbandman 3
3715809 1931230 1931230 defendant Thurston Brian laborer 586524 586524 Thurston, Brian, of Swanton Morley, laborer 4
3725984 1934399 1934399 defendant Parson John husbandman 586524 586524 Parson, John, of Swanton Morley, husbandman 0
3741868 1939321 1939321 defendant Waldyn John, senior husbandman 586524 586524 Waldyn, John, senior, of Swanton Morley, husbandman 0
3766525 1947189 1947189 defendant Roper John (legal representative) 586524 586524 Roper, John, of Swanton Morley, executors of 0
3766527 1947189 1947189 defendant Roper Thomas husbandman 586524 586524 Roper, Thomas, of Swanton Morley, husbandman 2
3830122 1967320 1967320 defendant Clerke William husbandman 586524 586524 Clerke, William, of Swanton Morley, husbandman 3
3831093 1967609 1967609 defendant Dey William engraver 586524 586524 Dey, William, of Swanton Morley, engraver 3
3838837 1970072 1970072 defendant Cane Walter   586524 586524 Cane, Walter, of Swanton Morley, hair weaver 0
3844166 1971724 1971724 defendant Clerk William husbandman 586524 586524 Clerk, William, of Swanton Morley, husbandman 2
3846433 1972438 1972438 defendant Dey William engraver 586524 586524 Dey, William, of Swanton Morley, engraver 0
3849851 1973539 1973539 defendant Davy John tailor 586524 586524 Davy, John, of Swanton Morley, tailor 1
3860141 1976889 1976889 defendant Tenny William shoemaker 586524 586524 Tenny, William, of Swanton Morley, shoemaker 1
3861130 1977201 1977201 defendant Clerk William   586524 586524 Clerk, William, of Swanton Morley, shepherd 0
3861131 1977201 1977201 defendant Clerke Robert husbandman 586524 586524 Clerke, Robert, of Swanton Morley, husbandman 1
3861132 1977201 1977201 defendant Clerk James husbandman 586524 586524 Clerk, James, of Swanton Morley, husbandman 2
3866048 1978876 1978876 defendant Crane Simon yeoman 586524 586524 Crane, Simon, of Swanton Morley, yeoman 2
3874326 1981639 1981639 defendant Dey Richard husbandman 586524 586524 Dey, Richard, of Swanton Morley, husbandman 0
3875374 1982010 1982010 defendant Bungey Thomas husbandman 586524 586524 Bungey, Thomas, of Swanton Morley, husbandman 0
3879252 1983311 1983311 defendant Dey Richard husbandman 586524 586524 Dey, Richard, of Swanton Morley, husbandman 0
3885464 1985394 1985394 defendant Dolton William tailor 586524 586524 Dolton, William, of Swanton Morley, tailor 1
3886224 1985645 1985645 defendant Alynson James blacksmith 586524 586524 Alynson, James, of Swanton Morley, blacksmith 0
3887586 1986098 1986098 defendant Vaughan John yeoman 586524 586524 Vaughan, John, of Swanton Morley, yeoman 2
3887592 1986100 1986100 defendant Vaugham Thomas yeoman 586524 586524 Vaugham, Thomas, of Swanton Morley, yeoman 0
3887598 1986101 1986101 defendant Vaughan Thomas yeoman 586524 586524 Vaughan, Thomas, of Swanton Morley, yeoman 0
3888280 1986341 1986341 plaintiff Durrant John   586524 586524 Durrant, John, of Swanton Morley 0
3888762 1986494 1986494 defendant Deye Richard yeoman 586524 586524 Deye, Richard, of Swanton Morley, yeoman 1
3888763 1986494 1986494 defendant Deye William yeoman 586524 586524 Deye, William, of Swanton Morley, yeoman 2
3888773 1986496 1986496 defendant Emlyn Thomas laborer 586524 586524 Emlyn, Thomas, of Swanton Morley, laborer 1
3890447 1987062 1987062 defendant Mowsdale Robert miller 586524 586524 Mowsdale, Robert, of Swanton Morley, miller 0
3890448 1987062 1987062 defendant Vaugham Thomas yeoman 586524 586524 Vaugham, Thomas, of Swanton Morley, yeoman 1
3892338 1987688 1987688 defendant Warn John miller 586524 586524 Warn, John, of Swanton Morley, miller 2
3893761 1988131 1988131 defendant Danham Thomas yeoman 586524 586524 Danham, Thomas, of Swanton Morley, yeoman 3
3895322 1988642 1988642 defendant Dalton William tailor 586524 586524 Dalton, William, of Swanton Morley, tailor 1
3897599 1989409 1989409 defendant Deye Richard husbandman 586524 586524 Deye, Richard, of Swanton Morley, husbandman 0
3898044 1989553 1989553 defendant Moswedale Robert yeoman 586524 586524 Moswedale, Robert, of Swanton Morley, yeoman 0
3902366 1991024 1991024 plaintiff Durrant John   586524 586524 Durrant, John, of Swanton Morley 0
3902371 1991025 1991025 plaintiff Durrant Thomas (legal representative) 586524 586524 Durrant, Thomas, of Swanton Morley, executors of 0
3907778 1992886 1992886 defendant Woodhowse John husbandman 586524 586524 Woodhowse, John, of Swanton Morley, husbandman 0
3907779 1992886 1992886 defendant Parburgh John husbandman 586524 586524 Parburgh, John, of Swanton Morley, husbandman 1
3907780 1992886 1992886 defendant Hogekyn John husbandman 586524 586524 Hogekyn, John, of Swanton Morley, husbandman 2
3910658 1993881 1993881 defendant Teny John shoemaker 586524 586524 Teny, John, of Swanton Morley, shoemaker 3
3911302 1994097 1994097 defendant Mowsdale Robert miller 586524 586524 Mowsdale, Robert, of Swanton Morley, miller 0
3950631 2007293 2007293 plaintiff Gaskon Simon yeoman 586524 586524 Gaskon, Simon, of Swanton Morley, yeoman 0
3958087 2009895 2009895 defendant Clerke William tailor 586524 586524 Clerke, William, of Swanton Morley, tailor 0
3963102 2011692 2011692 defendant Small Richard husbandman 586524 586524 Small, Richard, of Swanton Morley, husbandman 0
3983576 2018894 2018894 defendant Marlyngvyle William gent 586524 586524 Marlyngvyle, William, of Swanton Morley, gent 0
3985837 2019698 2019698 defendant Wyghtman George yeoman 586524 586524 Wyghtman, George, of Swanton Morley, yeoman 0
3997273 2023796 2023796 defendant Clarke William carpenter 586524 586524 Clarke, William, of Swanton Morley, carpenter 0
3997274 2023796 2023796 defendant Chapman Thomas (legal representative) 586524 586524 Chapman, Thomas, of Swanton Morley, blacksmith, executors of 1
3997275 2023796 2023796 defendant Peper Ralph blacksmith 586524 586524 (Peper, Ralph, of Swanton Morley, blacksmith 2
4028096 2034699 2034699 defendant Walker Henry gent 586524 586524 Walker, Henry, of Swanton Morley, gent 0
4049330 2042207 2042207 defendant Varden William shoemaker 586524 586524 Varden, William, of Swanton Morley, shoemaker 0
4085160 2054976 2054976 defendant Clarke William husbandman 586524 586524 Clarke, William, of Swanton Morley, husbandman 1
4092573 2057651 2057651 defendant Clarke William husbandman 586524 586524 Clarke, William, of Swanton Morley, husbandman 0
4097542 2059449 2059449 defendant Clarke William tailor 586524 586524 Clarke, William, of Swanton Morley, tailor 2
4200152 2095607 2095607 defendant Wright Thomas tailor 586524 586524 Wright, Thomas, of Swanton Morley, tailor 0
4222969 2103524 2103524 defendant Pereson Thomas husbandman 586524 586524 Pereson, Thomas, of Swanton Morley, husbandman 1
4243747 2110891 2110891 defendant Goodinge James yeoman 586524 586524 Goodinge, James, of Swanton Morley, yeoman 2
4244951 2111296 2111296 defendant Wharton Henry yeoman 586524 586524 Wharton, Henry, of Swanton Morley, yeoman 2
4244955 2111297 2111297 defendant Wharton Henry yeoman 586524 586524 Wharton, Henry, of Swanton Morley, yeoman 2
4287411 2125549 2125549 defendant Secker Thomas husbandman 586524 586524 Secker, Thomas, of Swanton Morley, husbandman 0
4321976 2137770 2137770 defendant Secker Thomas husbandman 586524 586524 Secker, Thomas, of Swanton Morley, husbandman 2
4387816 2160561 2160561 defendant Goodwyn James yeoman 586524 586524 Goodwyn, James, of Swanton Morley, yeoman 2
4668819 2255955 2255955 plaintiff Bernard John   586524 586524 Bernard, John, of Swanton Morley 0
4932219 2336476 2336476 defendant Canon John, junior   586524 586524 Canon, John, junior, of Swanton Morley 3
5012208 2360418 2360418 defendant Kyng Thmas husbandman 586524 586524 Kyng, Thmas, of Swanton Morley, husbandman 0
5066447 2376492 2376492 defendant Bernard William yeoman 586524 586524 Bernard, William, of Swanton Morley, yeoman 0
5066453 2376494 2376494 defendant Hamond Thomas husbandman 586524 586524 Hamond, Thomas, of Swanton Morley, husbandman 0
5066454 2376494 2376494 defendant Grantham William husbandman 586524 586524 Grantham, William, of Swanton Morley, husbandman 1
5066455 2376494 2376494 defendant Coweper Richard husbandman 586524 586524 Coweper, Richard, of Swanton Morley, husbandman 2
5066456 2376494 2376494 defendant atte Hyll John alias Canon husbandman 586524 586524 atte Hyll, John alias Canon, of Swanton Morley, husbandman 3
5093642 2384536 2384536 defendant Barret Thomas yeoman 586524 586524 Barret, Thomas, of Swanton Morley, yeoman 1
5145611 2399859 2399859 defendant Davy John husbandman 586524 586524 Davy, John, of Swanton Morley, husbandman 0
5180157 2409938 2409938 defendant Davy John husbandman 586524 586524 Davy, John, of Swanton Morley, husbandman 4
5202272 2416429 2416429 defendant Davy John husbandman 586524 586524 Davy, John, of Swanton Morley, husbandman 4
5292202 2442716 2442716 defendant Welle Clement smith 586524 586524 Welle, Clement, of Swanton Morley, smith 0
5329868 2454003 2454003 plaintiff Baret Thomas (legal representative) 586524 586524 Baret, Thomas, of Swanton Morley, executors of 0
5475345 2497618 2497618 defendant Trendyll Robert yeoman 586524 586524 Trendyll, Robert, of Swanton Morley, yeoman 0
5507639 2507291 2507291 defendant Legyate alias Feke James chaplain 586524 586524 Legyate alias Feke, James, of Swanton Morley, chaplain 0
5531397 2514340 2514340 defendant Fayry Thomas husbandman 586524 586524 Fayry, Thomas, of Swanton Morley, husbandman 3
5536175 2515809 2515809 plaintiff Burwassh Thomas   586524 586524 Burwassh, Thomas, of Swanton Morley 0
5552023 2520633 2520633 defendant Parson John husbandman 586524 586524 Parson, John, of Swanton Morley, husbandman 1
5561320 2523290 2523290 defendant Pernell Robert husbandman 586524 586524 Pernell, Robert, of Swanton Morley, husbandman 0
5566781 2524879 2524879 defendant Parson John husbandman 586524 586524 Parson, John, of Swanton Morley, husbandman 0
5568871 2525445 2525445 defendant Wyghtman Thomas yeoman 586524 586524 Wyghtman, Thomas, of Swanton Morley, yeoman 2
5568873 2525446 2525446 defendant Pakeman Thomas gent 586524 586524 Pakeman, Thomas, of Swanton Morley, gent 0
5579986 2528820 2528820 defendant Pakeman Thomas   586524 586524 Pakeman, Thomas, of Swanton Morley, notary 0
5581872 2529408 2529408 defendant Whightman John husbandman 586524 586524 Whightman, John, of Swanton Morley, husbandman 2

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