names

57 rows where place_id = 599394

✎ 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
3636588 1906234 1906234 defendant Eliot Richard yeoman 599394 599394 Eliot, Richard, of Newland, yeoman 3
3663587 1914542 1914542 defendant Carre Batrtholomew gent 599394 599394 Carre, Batrtholomew, of Newland, gent 0
3680950 1920123 1920123 defendant Markeham William husbandman 599394 599394 Markeham, William, of Newland, husbandman 0
3680951 1920123 1920123 defendant Rissholm Richard husbandman 599394 599394 Rissholm, Richard, of Newland, husbandman 1
3680952 1920123 1920123 defendant Taillour Robert husbandman 599394 599394 Taillour, Robert, of Newland, husbandman 2
3699198 1925963 1925963 defendant Sex alias Ludwat Thomas husbandman 599394 599394 Sex alias Ludwat, Thomas, of Newland, husbandman 0
3717650 1931817 1931817 defendant Dyngell Richard husbandman 599394 599394 Dyngell, Richard, of Newland, husbandman 0
3717651 1931817 1931817 defendant Dyngell John husbandman 599394 599394 Dyngell, John, of Newland, husbandman 1
3731618 1936116 1936116 defendant Halman William yeoman 599394 599394 Halman, William, of Newland, yeoman 0
3767086 1947362 1947362 defendant Carr Thomas gent 599394 599394 Carr, Thomas, of Newland, gent 4
3798048 1957288 1957288 defendant Gillam Robert husbandman 599394 599394 Gillam, Robert, of Newland, husbandman 0
3801394 1958361 1958361 defendant Carre Thomas gent 599394 599394 Carre, Thomas, of Newland, gent 3
3834273 1968664 1968664 defendant Seymer John yeoman 599394 599394 Seymer, John, of Newland, yeoman 0
3834299 1968671 1968671 defendant Norton Edward yeoman 599394 599394 Norton, Edward, of Newland, yeoman 2
3834342 1968684 1968684 defendant Norton Edward yeoman 599394 599394 Norton, Edward, of Newland, yeoman 2
3834346 1968685 1968685 defendant Norton Edward yeoman 599394 599394 Norton, Edward, of Newland, yeoman 2
3845615 1972171 1972171 defendant Hande Thomas butcher 599394 599394 Hande, Thomas, of Newland, butcher 0
3866681 1979089 1979089 defendant Hall William yeoman 599394 599394 Hall, William, of Newland, yeoman 3
3899259 1989963 1989963 defendant Sympson alias Boronhed John yeoman 599394 599394 Sympson alias Boronhed, John, of Newland, yeoman 0
3959543 2010430 2010430 defendant Ellye John yeoman 599394 599394 Ellye, John, of Newland, yeoman 1
3959544 2010430 2010430 defendant Nayler James yeoman 599394 599394 Nayler, James, of Newland, yeoman 2
3980005 2017612 2017612 defendant Trymyngham John yeoman 599394 599394 Trymyngham, John, of Newland, yeoman 1
4014187 2029800 2029800 defendant Bruton William yeoman 599394 599394 Bruton, William, of Newland, yeoman 0
4038061 2038255 2038255 defendant Rasshall Robert, senior yeoman 599394 599394 Rasshall, Robert, senior, of Newland, yeoman 0
4038062 2038255 2038255 defendant Rasshall Robert, junior yeoman 599394 599394 Rasshall, Robert, junior, of Newland, yeoman 1
4051862 2043086 2043086 defendant Worgan Robert husbandman 599394 599394 Worgan, Robert, of Newland, husbandman 0
4061924 2046663 2046663 defendant Dowle John husbandman 599394 599394 Dowle, John, of Newland, husbandman 0
4061925 2046663 2046663 defendant Nayler John yeoman 599394 599394 Nayler, John, of Newland, yeoman 1
4061926 2046663 2046663 defendant Marshe Henry yeoman 599394 599394 Marshe, Henry, of Newland, yeoman 2
4062796 2046994 2046994 defendant Clerke George   599394 599394 Clerke, George, of Newland, Yorks clerk 2
4088405 2056149 2056149 plaintiff Cartwright William yeoman 599394 599394 Cartwright, William, of Newland, yeoman 0
4104107 2061742 2061742 defendant Bonde John yeoman 599394 599394 Bonde, John, of Newland, yeoman 0
4105233 2062148 2062148 plaintiff Nelson John yeoman 599394 599394 Nelson, John, of Newland, yeoman 0
4105235 2062149 2062149 plaintiff Nelson John yeoman 599394 599394 Nelson, John, of Newland, yeoman 0
4113194 2064987 2064987 defendant Fynche Henry gent 599394 599394 Fynche, Henry, of Newland, or of Tenham, gent 0
4149946 2078111 2078111 defendant Smythe alias Pearse Thomas husbandman 599394 599394 Smythe alias Pearse, Thomas, of Newland, husbandman 0
4220686 2102735 2102735 defendant Smythe Henry husbandman 599394 599394 Smythe, Henry, of Newland, husbandman 0
4228909 2105592 2105592 defendant Thriston Edward yeoman 599394 599394 Thriston, Edward, of Newland, yeoman 0
4238255 2108988 2108988 defendant Brooke William husbandman 599394 599394 Brooke, William, of Newland, husbandman 2
4242273 2110410 2110410 defendant Skelton Peter gent 599394 599394 Skelton, Peter, of Newland, gent 0
4246705 2111874 2111874 defendant Brocke William husbandman 599394 599394 Brocke, William, of Newland, husbandman 2
4309900 2133618 2133618 defendant Nelson William, junior yeoman 599394 599394 Nelson, William, junior, of Newland, yeoman 0
4313274 2134751 2134751 defendant Trevarthen Christopher gent 599394 599394 Trevarthen, Christopher, of Newland, gent 1
4362682 2151712 2151712 defendant Price Thomas butcher 599394 599394 Price, Thomas, of Newland, butcher 1
4385587 2159863 2159863 defendant Woore Thomas yeoman 599394 599394 Woore, Thomas, of Newland, yeoman 3
4388071 2160638 2160638 defendant Lewus John Jevan laborer 599394 599394 Lewus, John Jevan, of Newland, laborer 2
4388072 2160638 2160638 defendant Lewis Philip laborer 599394 599394 Lewis, Philip, of Newland, laborer 3
4388076 2160639 2160639 defendant Lewis John Jevan laborer 599394 599394 Lewis, John Jevan, of Newland, laborer 2
4388077 2160639 2160639 defendant Lewis Philip laborer 599394 599394 Lewis, Philip, of Newland, laborer 3
4405384 2166380 2166380 defendant Nelson William, senior yeoman 599394 599394 Nelson, William, senior, of Newland, yeoman 0
4411644 2168492 2168492 defendant Clark John carpenter 599394 599394 Clark, John, of Newland, carpenter 0
4411645 2168492 2168492 defendant Good Edmund yeoman 599394 599394 Good, Edmund, of Newland, yeoman 1
4600401 2231351 2231351 defendant Jonkynson William   599394 599394 Jonkynson, William, of newland 0
4798127 2295607 2295607 defendant Wyrale John smith holder 599394 599394 Wyrale, John, of Newland, smith holder 0
5027732 2364988 2364988 defendant Watkyn John tucker 599394 599394 Watkyn, John, of Newland, tucker 0
5594440 2533239 2533239 defendant Elly Thomas yeoman 599394 599394 Elly, Thomas, of Newland, yeoman 2
5627458 2552557 2552557 defendant Warde Thomas husbandman 599394 599394 Warde, Thomas, of Newland, husbandman 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);