names

15 rows where case_id = 2240501

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4630692 2240501 2240501 plaintiff Sturmer Henry     Sturmer, Henry 0
4630693 2240501 2240501 defendant Jankyn John   600289 600289 Jankyn, John, of Lenne 0
4630694 2240501 2240501 defendant Smyth John   625456 625456 Smyth, John, of Anmere 1
4630695 2240501 2240501 defendant Wyncle Thomas   586882 586882 Wyncle, Thomas, of Betele 2
4630696 2240501 2240501 defendant Breydere Richard   596089 596089 Breydere, Richard, of Keteleston 3
4630697 2240501 2240501 defendant Franceys John   681414 681414 Franceys, John, of Brom 4
4630698 2240501 2240501 defendant Caudeler John     Caudeler, John 5
4630699 2240501 2240501 defendant Cok Thomas clerk   Cok, Thomas, clerk 6
4630700 2240501 2240501 defendant Codon Peter     Codon, Peter 7
4630701 2240501 2240501 defendant Cullyng William   587166 587166 Cullyng, William, of Salle 8
4630702 2240501 2240501 defendant Gunnes Richard   652592 652592 Gunnes, Richard, of Skeyton 9
4630703 2240501 2240501 defendant Turpyn Thomas     Turpyn, Thomas 10
4630704 2240501 2240501 defendant Creyk John   600289 600289 Creyk, John, of Lenne 11
4630705 2240501 2240501 defendant Fullere Geoffrey     Fullere, Geoffrey 12
4630706 2240501 2240501 defendant Robbe Henry   598213 598213 Robbe, Henry, of Walsyngham 13

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