names

16 rows where place_id = 652642

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3924928 1998656 1998656 defendant Smyth Robert husbandman 652642 652642 Smyth, Robert, of Newborne, husbandman 2
4137381 2073719 2073719 defendant Ledes Henry yeoman 652642 652642 Ledes, Henry, of Newborne, yeoman 0
4149280 2077874 2077874 defendant Silverne John yeoman 652642 652642 Silverne, John, of Newborne, yeoman 0
4202622 2096460 2096460 defendant Pryce William yeoman 652642 652642 Pryce, William, of Newborne, yeoman 1
4233101 2107085 2107085 defendant Hatche Reginald husbandman 652642 652642 Hatche, Reginald, of Newborne, husbandman 0
4239590 2109475 2109475 defendant Lambe Richard gent 652642 652642 Lambe, Richard, of Newborne, gent 0
4246026 2111648 2111648 defendant Gibbes Christopher   652642 652642 Gibbes, Christopher, of Newborne, sailor 2
4249176 2112709 2112709 defendant Damsell Thomas husbandman 652642 652642 Damsell, Thomas, of Newborne, husbandman 1
4262365 2117082 2117082 defendant Warren Thomas esq 652642 652642 Warren, Thomas, of Newborne, esq 0
4301326 2130583 2130583 defendant Lambe Richard gent 652642 652642 Lambe, Richard, of Newborne, gent 3
4333703 2141552 2141552 defendant Ufforde John husbandman 652642 652642 Ufforde, John, of Newborne, husbandman 3
4346243 2145940 2145940 defendant Grington or Erington Robert miller 652642 652642 Grington or Erington, Robert, of Newborne, miller 0
4377613 2157071 2157071 defendant Warren Thomas esq 652642 652642 Warren, Thomas, of Newborne, esq 0
4383295 2159127 2159127 defendant Damsell Thomas cooper 652642 652642 Damsell, Thomas, of Newborne, cooper 11
4404350 2166025 2166025 defendant Purpett John gent 652642 652642 Purpett, John, of Newborne, gent 0
5518802 2510713 2510713 defendant Cook William mariner 652642 652642 Cook, William, of Newborne, mariner 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);