names

23 rows where case_id = 2244788

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4645613 2244788 2244788 plaintiff Norwych Robert     Norwych, Robert 0
4645614 2244788 2244788 defendant atte Thirne Thomas   596683 596683 atte Thirne, Thomas, of Berton 0
4645615 2244788 2244788 defendant Thurton William     Thurton, William 1
4645616 2244788 2244788 defendant Cryspyng Roger     Cryspyng, Roger 2
4645617 2244788 2244788 defendant Freman James     Freman, James 3
4645618 2244788 2244788 defendant Jackes Clement     Jackes, Clement 4
4645619 2244788 2244788 defendant Kirgate John     Kirgate, John 5
4645620 2244788 2244788 defendant Golles Richard     Golles, Richard 6
4645621 2244788 2244788 defendant Pyrt Thomas     Pyrt, Thomas 7
4645622 2244788 2244788 defendant Heddes Richard   588821 588821 Heddes, Richard, of Buxton 8
4645623 2244788 2244788 defendant Pyn John   588945 588945 Pyn, John, of Hempstede 9
4645624 2244788 2244788 defendant Kyng John     Kyng, John 10
4645625 2244788 2244788 defendant Boteler Thomas     Boteler, Thomas 11
4645626 2244788 2244788 defendant Andrewe John     Andrewe, John 12
4645627 2244788 2244788 defendant Pr_ John     Pr_, John 13
4645628 2244788 2244788 defendant Morle William clerk   Morle, William, clerk 14
4645629 2244788 2244788 defendant Bussh John     Bussh, John 15
4645630 2244788 2244788 defendant Caudeler John   609752 609752 Caudeler, John, of Beeston 16
4645631 2244788 2244788 defendant Symond Thomas     Symond, Thomas 17
4645632 2244788 2244788 defendant Pampyng William     Pampyng, William 18
4645633 2244788 2244788 defendant Cogill Ralph     Cogill, Ralph 19
4645634 2244788 2244788 defendant Bret John   586102 586102 Bret, John, of Hengham 20
4645635 2244788 2244788 defendant Cartere John shepherd   Cartere, John, shepherd 21

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