names

17 rows where case_id = 2217968

✎ 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
4556479 2217968 2217968 plaintiff Hungerford Walter knight   Hungerford, Walter, knight 0
4556480 2217968 2217968 defendant Byde Robert clerk   Byde, Robert, clerk 0
4556481 2217968 2217968 defendant Jakelet Robert     Jakelet, Robert 1
4556482 2217968 2217968 defendant Spencer William   595915 595915 Spencer, William, of Hungerford, servant of the vicar 2
4556483 2217968 2217968 defendant Taillour William   613691 613691 Taillour, William, of Anbury 3
4556484 2217968 2217968 defendant Ody William   593968 593968 Ody, William, of Calne 4
4556485 2217968 2217968 defendant Smyth Philip   769245 769245 Smyth, Philip, of Chusynbury 5
4556486 2217968 2217968 defendant Clerk John   769246 769246 Clerk, John, of Up Havene 6
4556487 2217968 2217968 defendant Alclyf William     Alclyf, William 7
4556488 2217968 2217968 defendant Coupere Robert   757082 757082 Coupere, Robert, of Marlebergh 8
4556489 2217968 2217968 defendant (not given) John his son   John, his son 9
4556490 2217968 2217968 defendant Tarrant William jun   Tarrant, William, jun 10
4556491 2217968 2217968 defendant Tarrant Thomas servant of William   Tarrant, Thomas, servant of William 11
4556492 2217968 2217968 defendant Skynnere John     Skynnere, John 12
4556493 2217968 2217968 defendant Byde William servant of John Byde   Byde, William, servant of John Byde 13
4556494 2217968 2217968 defendant Mey George     Mey, George 14
4556495 2217968 2217968 defendant Mey John     Mey, John 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);