names

19 rows where place_id = 596837

✎ 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
3626362 1903104 1903104 defendant Mennard Thomas yeoman 596837 596837 Mennard, Thomas, of Lamerton, Devon, yeoman 0
3688307 1922496 1922496 defendant Toker Stephen yeoman 596837 596837 Toker, Stephen, of Lamerton, Devon, yeoman 0
3726119 1934433 1934433 defendant Sprye Robert chaplain 596837 596837 Sprye, Robert, of Lamerton, Devon, chaplain 0
3743677 1939904 1939904 defendant Toker Stephen yeoman 596837 596837 Toker, Stephen, of Lamerton, Devon, yeoman 0
3773552 1949438 1949438 defendant Randall William yeoman 596837 596837 Randall, William, of Lamerton, Devon, yeoman 6
3787451 1953867 1953867 defendant Sachefeld William, junior gent and Thomasine his wife 596837 596837 Sachefeld, William, junior, of Lamerton, Devon, gent, son of Sachefeld, William, of Lamerton, gent and Thomasine his wife 0
3787456 1953868 1953868 defendant Sachefeld William, junior gent and Thomasine his wife 596837 596837 Sachefeld, William, junior, of Lamerton, Devon, gent, son of Sachefeld, William, of Lamerton, gent and Thomasine his wife 0
3821163 1964512 1964512 defendant Sachefyld William, junior gent 596837 596837 Sachefyld, William, junior, of Lamerton, Devon, gent 0
3835437 1969022 1969022 defendant Sachefeld William yeoman 596837 596837 Sachefeld, William, of Lamerton, Devon, yeoman 0
3867064 1979223 1979223 defendant Sachefeld William gent 596837 596837 Sachefeld, William, of Lamerton, Devon, gent 0
3867070 1979224 1979224 defendant Sachefeld William, senior gent 596837 596837 Sachefeld, William, senior, of Lamerton, Devon, gent 1
3881005 1983916 1983916 defendant Sachefeld William, senior gent 596837 596837 Sachefeld, William, senior, of Lamerton, Devon, gent 2
3881011 1983917 1983917 defendant Sachefeld William gent 596837 596837 Sachefeld, William, of Lamerton, Devon, gent 2
4400845 2164874 2164874 defendant Southcott Philip gent 596837 596837 Southcott, Philip, of Lamerton, Devon, gent 1
4851712 2311970 2311970 defendant Drake William, sen husbandman 596837 596837 Drake, William, sen, of Lamerton, Devon, husbandman 0
4851715 2311971 2311971 defendant Drake William, sen husbandman 596837 596837 Drake, William, sen, of Lamerton, Devon, husbandman 0
5055206 2373136 2373136 defendant Ruby John husbandman 596837 596837 Ruby, John, of Lamerton, Devon, husbandman 0
5055687 2373270 2373270 defendant Ruby John husbandman 596837 596837 Ruby, John, of Lamerton, Devon, husbandman 0
5517007 2510150 2510150 defendant Tremayn John gent 596837 596837 Tremayn, John, of Lamerton, Devon, gent 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);