names

16 rows where case_id = 2170011

✎ 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
4416386 2170011 2170011 plaintiff Middelton William de     Middelton, William de 0
4416387 2170011 2170011 defendant Bodrich Martin   613874 613874 Bodrich, Martin, of Hapesburgh 0
4416388 2170011 2170011 defendant Man Roger clerk   Man, Roger, clerk 1
4416389 2170011 2170011 defendant Tommes John     Tommes, John 2
4416390 2170011 2170011 defendant Tommes Robert     Tommes, Robert 3
4416391 2170011 2170011 defendant Iryng John   753876 753876 Iryng, John, of Little Byteryng 4
4416392 2170011 2170011 defendant Lexham John de     Lexham, John de 5
4416393 2170011 2170011 defendant Treye Geoffrey   681071 681071 Treye, Geoffrey, of Plumpstede 6
4416394 2170011 2170011 defendant Brunne John de     Brunne, John de 7
4416395 2170011 2170011 defendant Mellere Thomas de     Mellere, Thomas de 8
4416396 2170011 2170011 defendant atte Gannok Hamond     atte Gannok, Hamond 9
4416397 2170011 2170011 defendant Nene John le clerk   Nene, John le, clerk 10
4416398 2170011 2170011 defendant Baggard John ironmonger   Baggard, John, ironmonger 11
4416399 2170011 2170011 defendant Bretoun Henry     Bretoun, Henry 12
4416400 2170011 2170011 defendant atte Cros William     atte Cros, William 13
4416401 2170011 2170011 defendant Bray William clerk   Bray, William, clerk 14

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