names

17 rows where case_id = 2310824

✎ 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
4847885 2310824 2310824 plaintiff Salisbury Richard earl of   Salisbury, Richard, earl of 0
4847886 2310824 2310824 defendant Goman Nicholas     Goman, Nicholas 0
4847887 2310824 2310824 defendant Goman Richard     Goman, Richard 1
4847888 2310824 2310824 defendant Sperlyng Henry     Sperlyng, Henry 2
4847889 2310824 2310824 defendant Sander John     Sander, John 3
4847890 2310824 2310824 defendant Aleyn William     Aleyn, William 4
4847891 2310824 2310824 defendant Gill William     Gill, William 5
4847892 2310824 2310824 defendant Austeyn John     Austeyn, John 6
4847893 2310824 2310824 defendant Rove William     Rove, William 7
4847894 2310824 2310824 defendant Hodell John jun   Hodell, John, jun 8
4847895 2310824 2310824 defendant Osward Nichold     Osward, Nichold, 9
4847896 2310824 2310824 defendant Brasiar Wm     Brasiar, Wm 10
4847897 2310824 2310824 defendant Rymme (illegible)     Rymme, _ 11
4847898 2310824 2310824 defendant Sandrych Robert   594912 594912 Sandrych, Robert, of Aldenham 12
4847899 2310824 2310824 defendant Brewer Thomas   594912 594912 Brewer, Thomas, of Aldenham 13
4847900 2310824 2310824 defendant Beaumont Richard   587082 587082 Beaumont, Richard, of Watford 14
4847901 2310824 2310824 defendant all of Busshey except where stated otherwise     all of Busshey, except where stated otherwise 15

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