names

31 rows where place_id = 614681

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3704932 1927834 1927834 defendant Coke Thomas husbandman 614681 614681 Coke, Thomas, of Morewynstowe, husbandman 0
3723986 1933785 1933785 defendant Broke Henry husbandman 614681 614681 Broke, Henry, of Morewynstowe, husbandman 0
3723987 1933785 1933785 defendant Crokker Richard husbandman 614681 614681 Crokker, Richard, of Morewynstowe, husbandman 1
3723988 1933785 1933785 defendant Russell Thomas husbandman 614681 614681 Russell, Thomas, of Morewynstowe, husbandman 2
3768958 1947944 1947944 defendant Prust Simon husbandman 614681 614681 Prust, Simon, of Morewynstowe, husbandman 0
3786756 1953654 1953654 defendant Prust Simon husbandman 614681 614681 Prust, Simon, of Morewynstowe, husbandman 0
3849924 1973563 1973563 defendant Pyne Nicholas husbandman 614681 614681 Pyne, Nicholas, of Morewynstowe, husbandman 0
3849926 1973563 1973563 defendant Ley John yeoman 614681 614681 Ley, John, of Morewynstowe, yeoman 2
3893827 1988157 1988157 defendant Crocker Richard, senior husbandman 614681 614681 Crocker, Richard, senior, of Morewynstowe, husbandman 1
3893828 1988157 1988157 defendant Crocker Richard, junior husbandman 614681 614681 Crocker, Richard, junior, of Morewynstowe, husbandman 2
3893850 1988165 1988165 defendant Escotte William husbandman 614681 614681 Escotte, William, of Morewynstowe, husbandman 0
3893851 1988165 1988165 defendant Cooke Thomas butcher 614681 614681 Cooke, Thomas, of Morewynstowe, butcher 1
3893852 1988165 1988165 defendant Cooke John butcher 614681 614681 Cooke, John, of Morewynstowe, butcher 2
3908086 1993002 1993002 defendant Estotte William butcher 614681 614681 Estotte, William, of Morewynstowe, butcher 0
3908087 1993002 1993002 defendant Coke John butcher 614681 614681 Coke, John, of Morewynstowe, butcher 1
3927284 1999464 1999464 defendant Mannyng Nicholas gent 614681 614681 Mannyng, Nicholas, of Morewynstowe, gent 0
3927285 1999464 1999464 defendant Mannyng Agnes spinster 614681 614681 Mannyng, Agnes, of Morewynstowe, spinster 1
3983693 2018939 2018939 defendant Langdon Robert gent 614681 614681 Langdon, Robert, of Morewynstowe, gent 0
3983696 2018941 2018941 plaintiff Standberry William   614681 614681 Standberry, William, of Morewynstowe 0
3983697 2018941 2018941 defendant Langdon Robert gent 614681 614681 Langdon, Robert, of Morewynstowe, gent 0
4025391 2033740 2033740 plaintiff Brode John (legal representative) 614681 614681 Brode, John, of Morewynstowe, executors of 0
4048923 2042058 2042058 defendant Trebesper William gent 614681 614681 Trebesper, William, of Morewynstowe, gent 4
4169886 2084964 2084964 defendant Bennam John husbandman 614681 614681 Bennam, John, of Morewynstowe, husbandman 0
4169887 2084964 2084964 defendant Shepperd Jerome yeoman 614681 614681 Shepperd, Jerome, of Morewynstowe, yeoman 1
4169888 2084964 2084964 defendant Clarke Jona widow 614681 614681 Clarke, Jona, of Morewynstowe, widow 2
4227349 2105047 2105047 defendant Syncocke John husbandman 614681 614681 Syncocke, John, of Morewynstowe, husbandman 0
4335655 2142202 2142202 defendant Blackdon John gent 614681 614681 Blackdon, John, of Morewynstowe, gent 0
4565504 2220782 2220782 defendant Pyne Robert   614681 614681 Pyne, Robert, of Morewynstowe 1
4565505 2220782 2220782 defendant Pyne Margaret   614681 614681 Pyne, Margaret, of Morewynstowe 2
5019776 2362663 2362663 defendant Bounde John laborer 614681 614681 Bounde, John, of Morewynstowe, laborer 1
5077722 2379832 2379832 defendant Jule Roger yeoman 614681 614681 Jule, Roger, of Morewynstowe, yeoman 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);