names

51 rows where place_id = 614844

✎ 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
3705829 1928104 1928104 defendant Nasshe John yeoman 614844 614844 Nasshe, John, of Malden, yeoman 0
3710473 1929594 1929594 defendant Some Thomas butcher 614844 614844 Some, Thomas, of Malden, butcher 0
3755604 1943710 1943710 defendant Heygate John yeoman 614844 614844 Heygate, John, of Malden, yeoman 0
3798280 1957358 1957358 defendant Stone John mariner 614844 614844 Stone, John, of Malden, mariner 1
3816244 1962989 1962989 defendant Cotton William husbandman 614844 614844 Cotton, William, of Malden, husbandman 0
3828618 1966829 1966829 defendant Sharp John tailor 614844 614844 Sharp, John, of Malden, tailor 0
3832157 1967968 1967968 defendant Tayler alias Hardyng Humphrey yeoman 614844 614844 Tayler alias Hardyng, Humphrey, of Malden, yeoman 0
3837771 1969728 1969728 defendant Bedell Robert butcher 614844 614844 Bedell, Robert, of Malden, butcher 1
3841100 1970791 1970791 defendant Gate John yeoman 614844 614844 Gate, John, of Malden, yeoman 1
3850650 1973793 1973793 defendant Baker William yeoman 614844 614844 Baker, William, of Malden, yeoman 1
3850651 1973793 1973793 defendant Smyth John yeoman 614844 614844 Smyth, John, of Malden, yeoman 2
3971638 2014642 2014642 defendant West Thomas, senior yeoman 614844 614844 West, Thomas, senior, of Malden, yeoman 0
3993744 2022514 2022514 plaintiff Chicheley Richard   614844 614844 Chicheley, Richard, of Malden, "bagier" or badger 0
3993745 2022514 2022514 defendant West Thomas, senior gent 614844 614844 West, Thomas, senior, of Malden, gent 0
3993746 2022515 2022515 plaintiff Chicheley Richard badger 614844 614844 Chicheley, Richard, of Malden, badger 0
3993747 2022515 2022515 defendant West Thomas, senior gent 614844 614844 West, Thomas, senior, of Malden, gent 0
4011003 2028711 2028711 defendant Garard John yeoman or smith 614844 614844 Garard, John, of Malden, yeoman or smith 3
4234464 2107596 2107596 defendant Feelde Edmund   614844 614844 Feelde, Edmund, of Malden, husbandman, son of Andrew 0
4281795 2123536 2123536 defendant Pyke Edward merchant 614844 614844 Pyke, Edward, of Malden, merchant 0
4296198 2128739 2128739 defendant Woodwoes Roger husbandman 614844 614844 Woodwoes, Roger, of Malden, husbandman 1
4314212 2135079 2135079 defendant Bantoft William yeoman 614844 614844 Bantoft, William, of Malden, yeoman 0
4314213 2135079 2135079 defendant Martyn John yeoman 614844 614844 Martyn, John, of Malden, yeoman 1
4314214 2135079 2135079 defendant Henshawe Michael gent 614844 614844 Henshawe, Michael, of Malden, gent 2
4314216 2135079 2135079 defendant Wade Dominic yeoman 614844 614844 Wade, Dominic, of Malden, yeoman 4
4318305 2136510 2136510 defendant Barnes Thomas yeoman 614844 614844 Barnes, Thomas, of Malden, yeoman 0
4355172 2149029 2149029 defendant Pope Robert yeoman 614844 614844 Pope, Robert, of Malden, yeoman 0
4365504 2152728 2152728 defendant Constable Jerome yeoman 614844 614844 Constable, Jerome, of Malden, yeoman 0
4390281 2161371 2161371 defendant Goodwyn William husbandman 614844 614844 Goodwyn, William, of Malden, husbandman 1
4393462 2162414 2162414 defendant Courtnoll John yeoman 614844 614844 Courtnoll, John, of Malden, yeoman 1
4397134 2163612 2163612 defendant Pasfeild George yeoman 614844 614844 Pasfeild, George, of Malden, yeoman 0
4458125 2187573 2187573 defendant Marchaunt John   614844 614844 Marchaunt, John, of Malden 0
4492581 2198381 2198381 defendant Crakebon John   614844 614844 Crakebon, John, of Malden 0
4510170 2203666 2203666 plaintiff Barbour Henry   614844 614844 Barbour, Henry, of Malden 0
4523928 2207817 2207817 defendant Herde Thomas butcher 614844 614844 Herde, Thomas, of Malden, butcher 0
4743640 2278668 2278668 defendant Westcote Thomas   614844 614844 Westcote, Thomas, of Malden, mason 0
4790254 2293035 2293035 defendant Richard John husbandman 614844 614844 Richard, John, of Malden, husbandman 0
4796180 2294956 2294956 defendant Godwyn John glover 614844 614844 Godwyn, John, of Malden, glover 1
4810992 2299553 2299553 defendant Bertelot Alice widow 614844 614844 Bertelot, Alice, of Malden, widow 1
4845808 2310200 2310200 defendant Burgeys John merchant 614844 614844 Burgeys, John, of Malden, merchant 0
4852543 2312217 2312217 defendant Smyth John shipman 614844 614844 Smyth, John, of Malden, shipman 0
4852544 2312217 2312217 defendant Feryng John husbandman 614844 614844 Feryng, John, of Malden, husbandman 1
4883640 2321796 2321796 defendant Bowes Thomas (legal representative) 614844 614844 Bowes, Thomas, of Malden, chapman, executors of 3
4889204 2323410 2323410 defendant Bowes Thomas (legal representative) 614844 614844 Bowes, Thomas, of Malden, chapman, executors of 3
4980061 2350987 2350987 defendant Pepyr John husbandman 614844 614844 Pepyr, John, of Malden, husbandman 1
5046869 2370683 2370683 defendant Whitebrede John husbandman 614844 614844 Whitebrede, John, of Malden, husbandman 0
5103338 2387406 2387406 defendant Wode John butcher 614844 614844 Wode, John,of Malden, butcher 2
5243611 2428325 2428325 defendant Gocke Thomas butcher 614844 614844 Gocke, Thomas, of Malden, butcher 3
5262984 2434166 2434166 defendant Rokes Reginald gent 614844 614844 Rokes, Reginald, of Malden, gent 0
5370535 2466369 2466369 defendant Lyne Henry husbandman 614844 614844 Lyne, Henry, of Malden, husbandman 0
5595922 2533634 2533634 defendant Samuell John, junior yeoman 614844 614844 Samuell, John, junior, of Malden, yeoman 8
5613132 2547886 2547886 defendant Dewe Thomas   614844 614844 Dewe, Thomas, of Malden 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);