names

26 rows where case_id = 1934557

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3726512 1934557 1934557 plaintiff Thymolby John knight   Thymolby, John, knight 0
3726513 1934557 1934557 defendant Kaye Ellen prioress of Styxwold Priory   Kaye, Ellen, prioress of Styxwold Priory 0
3726514 1934557 1934557 defendant Robynson John   618809 618809 Robynson, John, of Styxwold 1
3726515 1934557 1934557 defendant Besyng Robert     Besyng, Robert 2
3726516 1934557 1934557 defendant Swyne William     Swyne, William 3
3726517 1934557 1934557 defendant Cramlynton Anthony     Cramlynton, Anthony 4
3726518 1934557 1934557 defendant Stage John     Stage, John 5
3726519 1934557 1934557 defendant Robynson Thomas     Robynson, Thomas 6
3726520 1934557 1934557 defendant Wylson George     Wylson, George 7
3726521 1934557 1934557 defendant Bawdewyn Thomas     Bawdewyn, Thomas 8
3726522 1934557 1934557 defendant Anson William     Anson, William 9
3726523 1934557 1934557 defendant Shalis Thomas     Shalis, Thomas 10
3726524 1934557 1934557 defendant Dawson Thomas     Dawson, Thomas 11
3726525 1934557 1934557 defendant Dawson Alexander     Dawson, Alexander 12
3726526 1934557 1934557 defendant Johnson William     Johnson, William 13
3726527 1934557 1934557 defendant Yorke Thomas     Yorke, Thomas 14
3726528 1934557 1934557 defendant Gybson John     Gybson, John 15
3726529 1934557 1934557 defendant Bell William     Bell, William 16
3726530 1934557 1934557 defendant Pereson William     Pereson, William 17
3726531 1934557 1934557 defendant Borell William     Borell, William 18
3726532 1934557 1934557 defendant Sellers John     Sellers, John 19
3726533 1934557 1934557 defendant Madeson Richard     Madeson, Richard 20
3726534 1934557 1934557 defendant Roger Thomas     Roger, Thomas 21
3726535 1934557 1934557 defendant Colyngwode William     Colyngwode, William 22
3726536 1934557 1934557 defendant Taillour John     Taillour, John 23
3726537 1934557 1934557 defendant Pye John husbandman 618809 618809 Pye, John, of Styxwold, husbandman 24

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