names

20 rows where case_id = 1940078

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3744170 1940078 1940078 plaintiff Arundell Roger esq   Arundell, Roger, esq 0
3744171 1940078 1940078 defendant Auston Robert husbandman 621903 621903 Auston, Robert, of Patstowe, husbandman 0
3744172 1940078 1940078 defendant Ratallek John husbandman 621903 621903 Ratallek, John, of Patstowe, husbandman 1
3744173 1940078 1940078 defendant Noyle George husbandman 621903 621903 Noyle, George, of Patstowe, husbandman 2
3744174 1940078 1940078 defendant Ronell Thomas Jacke husbandman 621903 621903 Ronell, Thomas Jacke, of Patstowe, husbandman 3
3744175 1940078 1940078 defendant Kneboon John husbandman 621903 621903 Kneboon, John, of Patstowe, husbandman 4
3744176 1940078 1940078 defendant Martyn Robert husbandman 621904 621904 Martyn, Robert, of St Ervyn, husbandman 5
3744177 1940078 1940078 defendant Jenkyn Stephen husbandman 621904 621904 Jenkyn, Stephen, of St Ervyn, husbandman 6
3744178 1940078 1940078 defendant Harbytreyeneck thomas husbandman 621904 621904 Harbytreyeneck, thomas, of St Ervyn, husbandman 7
3744179 1940078 1940078 defendant trewynnowe Peter     trewynnowe, Peter 8
3744180 1940078 1940078 defendant Trevedon Thomas     Trevedon, Thomas 9
3744181 1940078 1940078 defendant Treboythock Sampson James     Treboythock, Sampson James 10
3744182 1940078 1940078 defendant Edward Robert     Edward, Robert 11
3744183 1940078 1940078 defendant Geward German     Geward, German 12
3744184 1940078 1940078 defendant Saynt Ervyn John     Saynt Ervyn, John 13
3744185 1940078 1940078 defendant Rawlyn Sampson     Rawlyn, Sampson 14
3744186 1940078 1940078 defendant John Clement     John, Clement 15
3744187 1940078 1940078 defendant Mychell Benedict     Mychell, Benedict 16
3744188 1940078 1940078 defendant Eve John     Eve, John 17
3744189 1940078 1940078 defendant Tregoia Thomas     Tregoia, Thomas 18

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