names

23 rows where case_id = 1933070

✎ 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
3721666 1933070 1933070 plaintiff Lovell Thomas knight   Lovell, Thomas, knight, executors of 0
3721667 1933070 1933070 plaintiff Paston William knight   (Paston, William, knight 1
3721668 1933070 1933070 plaintiff Lovell Francis     Lovell, Francis 2
3721669 1933070 1933070 plaintiff Carleton John     Carleton, John 3
3721670 1933070 1933070 defendant Harryngton James   617872 617872 Harryngton, James, of London, dean of York Cathedral 0
3721671 1933070 1933070 defendant Copley Edmund gent 592299 592299 Copley, Edmund, of Doncaster, gent 1
3721672 1933070 1933070 defendant Calverley Walter     Calverley, Walter 2
3721673 1933070 1933070 defendant Salmon John     Salmon, John 3
3721674 1933070 1933070 defendant Hartwell Richard     Hartwell, Richard 4
3721675 1933070 1933070 defendant Harman William     Harman, William 5
3721676 1933070 1933070 defendant Serle Robert     Serle, Robert 6
3721677 1933070 1933070 defendant Carre John     Carre, John 7
3721678 1933070 1933070 defendant Clopton Hugh     Clopton, Hugh 8
3721679 1933070 1933070 defendant Clopton William     Clopton, William 9
3721680 1933070 1933070 defendant Grevell Edward     Grevell, Edward 10
3721681 1933070 1933070 defendant Hamden John     Hamden, John 11
3721682 1933070 1933070 defendant Stoner Walter     Stoner, Walter 12
3721683 1933070 1933070 defendant Stoner Thomas     Stoner, Thomas 13
3721684 1933070 1933070 defendant Holford George     Holford, George 14
3721685 1933070 1933070 defendant Maire John     Maire, John 15
3721686 1933070 1933070 defendant Danyell Peter     Danyell, Peter 16
3721687 1933070 1933070 defendant Lee Thomas     Lee, Thomas 17
3721688 1933070 1933070 defendant Wrenche John     Wrenche, John 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);