names

15 rows where case_id = 2351831

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4983033 2351831 2351831 plaintiff Vampage John     Vampage, John 0
4983034 2351831 2351831 defendant Tomson Thomas of Arterath yeoman   Tomson, Thomas of Arterath, yeoman 0
4983035 2351831 2351831 defendant Sourdall Robert yeoman 830438 830438 Sourdall, Robert, of Arterath, yeoman 1
4983036 2351831 2351831 defendant Sourdall Thomas yeoman 830438 830438 Sourdall, Thomas, of Arterath, yeoman 2
4983037 2351831 2351831 defendant Thomson Roland yeoman 830438 830438 Thomson, Roland, of Arterath, yeoman 3
4983038 2351831 2351831 defendant Kay Adam yeoman 830438 830438 Kay, Adam, of Arterath, yeoman 4
4983039 2351831 2351831 defendant Milner John yeoman 830438 830438 Milner, John, of Arterath, yeoman 5
4983040 2351831 2351831 defendant Hobson William yeoman 781953 781953 Hobson, William, of Wederell, yeoman 6
4983041 2351831 2351831 defendant Gyll John, senior yeoman 595515 595515 Gyll, John, senior, of Fenton, yeoman 7
4983042 2351831 2351831 defendant Gyll John, junior yeoman 595515 595515 Gyll, John, junior, of Fenton, yeoman 8
4983043 2351831 2351831 defendant Darman Robert yeoman 781953 781953 Darman, Robert, of Wederell, yeoman 9
4983044 2351831 2351831 defendant Stevenson Gilbert yeoman 781953 781953 Stevenson, Gilbert, of Wederell, yeoman 10
4983045 2351831 2351831 defendant Bonthom or Bouthom Robert yeoman 781953 781953 Bonthom or Bouthom, Robert, of Wederell, yeoman 11
4983046 2351831 2351831 defendant Gervaux John yeoman 781953 781953 Gervaux, John, of Wederell, yeoman 12
4983047 2351831 2351831 defendant Patanson John yeoman 781953 781953 Patanson, John, of Wederell, yeoman 13

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