names

18 rows where case_id = 2226482

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4584229 2226482 2226482 plaintiff Gilde Helen (legal representative) 765951 765951 Gilde, Helen, of Wadenho, executors of 0
4584230 2226482 2226482 plaintiff Mouton John     (Mouton, John 1
4584231 2226482 2226482 plaintiff Wadenho Richard de son of Stephen   Wadenho, Richard de, son of Stephen 2
4584232 2226482 2226482 defendant Eyre Roger   763690 763690 Eyre, Roger, of Tychemerssh 0
4584233 2226482 2226482 defendant Carbonell William   768170 768170 Carbonell, William, of Achirche 1
4584234 2226482 2226482 defendant Grenham Walter clerk   Grenham, Walter, clerk 2
4584235 2226482 2226482 defendant Reynold Athelman   703392 703392 Reynold, Athelman, of Pilton 3
4584236 2226482 2226482 defendant Fyn Margaret     Fyn, Margaret 4
4584237 2226482 2226482 defendant Warde John   769269 769269 Warde, John, of Lyveden 5
4584238 2226482 2226482 defendant Wryght Henry   765951 765951 Wryght, Henry, of Wadenho 6
4584239 2226482 2226482 defendant Balle Richard   765951 765951 Balle, Richard, of Wadenho 7
4584240 2226482 2226482 defendant Prest William   765951 765951 Prest, William, of Wadenho 8
4584241 2226482 2226482 defendant Tomelyn John   755749 755749 Tomelyn, John, of Lufwyk 9
4584242 2226482 2226482 defendant Hadley Thomas clerk 588081 588081 Hadley, Thomas, of Cambridge, clerk 10
4584243 2226482 2226482 defendant Feldyng Margaret   586459 586459 Feldyng, Margaret, of Stoke 11
4584244 2226482 2226482 defendant Drayton John   770869 770869 Drayton, John, of Luffwyk 12
4584245 2226482 2226482 defendant Molkous William   610927 610927 Molkous, William, of Ryngested 13
4584246 2226482 2226482 defendant Shepherd Henry   771988 771988 Shepherd, Henry, of Aldewynkyl 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);