names

9 rows where case_id = 2413628

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5192833 2413628 2413628 plaintiff Notyngham William     Notyngham, William 0
5192834 2413628 2413628 defendant Yonger John merchant   Yonger, John, merchant 0
5192835 2413628 2413628 defendant Redisdale John merchant   Redisdale, John, merchant 1
5192836 2413628 2413628 defendant Wetwant Edward merchant   Wetwant, Edward, merchant 2
5192837 2413628 2413628 defendant Mappas John merchant   Mappas, John, merchant 3
5192838 2413628 2413628 defendant Pykden Robert merchant   Pykden, Robert, merchant 4
5192839 2413628 2413628 defendant Roofe or Roose William merchant   Roofe or Roose, William, merchant 5
5192840 2413628 2413628 defendant Shrygley John gent 857963 857963 Shrygley, John, of Makkesfeld, Cheshire, gent 6
5192841 2413628 2413628 defendant Downes Geoffrey     Downes, Geoffrey, 7

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