names

21 rows where case_id = 2519734

✎ 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
5548953 2519734 2519734 plaintiff Baynard Philip     Baynard, Philip 0
5548954 2519734 2519734 defendant Seymour Elizabeth widow 898882 898882 Seymour, Elizabeth, of Wolsale, widow 0
5548955 2519734 2519734 defendant Kyrton Edward husbandman 644747 644747 Kyrton, Edward, of Burbache, husbandman 1
5548956 2519734 2519734 defendant Dodford Thomas     Dodford, Thomas 2
5548957 2519734 2519734 defendant Shorlett William     Shorlett, William 3
5548958 2519734 2519734 defendant Pars John     Pars, John 4
5548959 2519734 2519734 defendant Kyng Thomas     Kyng, Thomas 5
5548960 2519734 2519734 defendant Haukyns William     Haukyns, William 6
5548961 2519734 2519734 defendant Kyrton John     Kyrton, John 7
5548962 2519734 2519734 defendant Trope Thomas     Trope, Thomas 8
5548963 2519734 2519734 defendant Bonke William     Bonke, William 9
5548964 2519734 2519734 defendant Smyth Richard     Smyth, Richard 10
5548965 2519734 2519734 defendant Swayne William     Swayne, William 11
5548966 2519734 2519734 defendant Kyrton John, junior     Kyrton, John, junior 12
5548967 2519734 2519734 defendant Balle Stephen     Balle, Stephen 13
5548968 2519734 2519734 defendant Brounesdon Thomas     Brounesdon, Thomas 14
5548969 2519734 2519734 defendant Tounesende Simon     Tounesende, Simon 15
5548970 2519734 2519734 defendant Bannyng William     Bannyng, William 16
5548971 2519734 2519734 defendant Soly Thomas     Soly, Thomas 17
5548972 2519734 2519734 defendant Gregori Thomas     Gregori, Thomas 18
5548973 2519734 2519734 defendant Kyrton William all of Burbache, husbandmen   Kyrton, William, all of Burbache, husbandmen 19

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