names

16 rows where place_id = 614310

✎ 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
3703029 1927221 1927221 defendant Sympson John yeoman 614310 614310 Sympson, John, of Brendon, yeoman 0
3703030 1927221 1927221 defendant Sympson David yeoman 614310 614310 Sympson, David, of Brendon, yeoman 1
3703031 1927221 1927221 defendant Mores John yeoman 614310 614310 Mores, John, of Brendon, yeoman 2
3703032 1927221 1927221 defendant Holsworthy David yeoman 614310 614310 Holsworthy, David, of Brendon, yeoman 3
3703033 1927221 1927221 defendant Olyver Thomas yeoman 614310 614310 Olyver, Thomas, of Brendon, yeoman 4
3707914 1928772 1928772 defendant Wyndiall Bartholomew tanner 614310 614310 Wyndiall, Bartholomew, of Brendon, tanner 2
3711493 1929903 1929903 defendant Sympson John yeoman 614310 614310 Sympson, John, of Brendon, yeoman 0
3766139 1947061 1947061 plaintiff Lyghtfote William   614310 614310 Lyghtfote, William, of Brendon 0
3803226 1958912 1958912 defendant Collyn Richard husbandman 614310 614310 Collyn, Richard, of Brendon, husbandman 0
3803227 1958912 1958912 defendant Wylcok Edmund laborer 614310 614310 Wylcok, Edmund, of Brendon, laborer 1
3822852 1965054 1965054 defendant Popham William yeoman 614310 614310 Popham, William, of Brendon, yeoman 1
3822855 1965055 1965055 defendant Popham William yeoman 614310 614310 Popham, William, of Brendon, yeoman 1
4468941 2190962 2190962 defendant Heryng Luke   614310 614310 Heryng, Luke, of Brendon 3
4482143 2195124 2195124 defendant Coton William   614310 614310 Coton, William, of Brendon 0
4822922 2303252 2303252 plaintiff Sperlyng Andrew esq 614310 614310 Sperlyng, Andrew, of Brendon, esq, on his own account 0
5502653 2505747 2505747 defendant Eustace John husbandman 614310 614310 Eustace, John, of Brendon, husbandman 1

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