names

19 rows where case_id = 2367192

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5035317 2367192 2367192 plaintiff Thelkelde Henry knight   Thelkelde, Henry, knight 0
5035318 2367192 2367192 defendant Wyllen Thomas yeoman 791255 791255 Wyllen, Thomas, of Meburne Mande, yeoman 0
5035319 2367192 2367192 defendant Wylkynson William yeoman 791255 791255 Wylkynson, William, of Meburne Mande, yeoman 1
5035320 2367192 2367192 defendant Derbye William yeoman 791255 791255 Derbye, William, of Meburne Mande, yeoman 2
5035321 2367192 2367192 defendant Fyrneys Thomas yeoman 791255 791255 Fyrneys, Thomas, of Meburne Mande, yeoman 3
5035322 2367192 2367192 defendant Tomlynson Richard yeoman 791255 791255 Tomlynson, Richard, of Meburne Mande, yeoman 4
5035323 2367192 2367192 defendant Hugyll Thomas yeoman 791255 791255 Hugyll, Thomas, of Meburne Mande, yeoman 5
5035324 2367192 2367192 defendant Herryson John yeoman 791255 791255 Herryson, John, of Meburne Mande, yeoman 6
5035325 2367192 2367192 defendant Herryson Thomas yeoman 791255 791255 Herryson, Thomas, of Meburne Mande, yeoman 7
5035326 2367192 2367192 defendant Lyone John yeoman 791255 791255 Lyone, John, of Meburne Mande, yeoman 8
5035327 2367192 2367192 defendant Derwentwater William yeoman 791255 791255 Derwentwater, William, of Meburne Mande, yeoman 9
5035328 2367192 2367192 defendant Elwald Robert yeoman 791255 791255 Elwald, Robert, of Meburne Mande, yeoman 10
5035329 2367192 2367192 defendant Smyth Robert yeoman 791255 791255 Smyth, Robert, of Meburne Mande, yeoman 11
5035330 2367192 2367192 defendant Fayrhare John yeoman 791255 791255 Fayrhare, John, of Meburne Mande, yeoman 12
5035331 2367192 2367192 defendant Watson William yeoman 791255 791255 Watson, William, of Meburne Mande, yeoman 13
5035332 2367192 2367192 defendant Fournes John yeoman 791255 791255 Fournes, John, of Meburne Mande, yeoman 14
5035333 2367192 2367192 defendant Wylson John yeoman 791255 791255 Wylson, John, of Meburne Mande, yeoman 15
5035334 2367192 2367192 defendant Hogyll John yeoman 791255 791255 Hogyll, John, of Meburne Mande, yeoman 16
5035335 2367192 2367192 defendant Smyth Thomas yeoman 791255 791255 Smyth, Thomas, of Meburne Mande, yeoman 17

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