names

25 rows where case_id = 2189711

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4464972 2189711 2189711 plaintiff White John     White, John 0
4464973 2189711 2189711 defendant Tubbe Thomas   586820 586820 Tubbe, Thomas, of Swanton 0
4464974 2189711 2189711 defendant Lesyngham Walter de     Lesyngham, Walter de 1
4464975 2189711 2189711 defendant Dennys Peter   586820 586820 Dennys, Peter, of Swanton 2
4464976 2189711 2189711 defendant Couper Roger   652592 652592 Couper, Roger, of Skeyton 3
4464977 2189711 2189711 defendant Icye Geoffrey     Icye, Geoffrey 4
4464978 2189711 2189711 defendant Buntyng Geoffrey     Buntyng, Geoffrey 5
4464979 2189711 2189711 defendant Kyng Geoffrey   759865 759865 Kyng, Geoffrey, of Great Hobbes 6
4464980 2189711 2189711 defendant Multon John de     Multon, John de 7
4464981 2189711 2189711 defendant Pampyng Clement     Pampyng, Clement 8
4464982 2189711 2189711 defendant Legard Adam   759866 759866 Legard, Adam, of Cokessale 9
4464983 2189711 2189711 defendant atte Welle Geoffrey     atte Welle, Geoffrey 10
4464984 2189711 2189711 defendant del Stones robert     del Stones, robert 11
4464985 2189711 2189711 defendant Dyngle Gilbert   587449 587449 Dyngle, Gilbert, of Felmyngham 12
4464986 2189711 2189711 defendant Bette Henry     Bette, Henry 13
4464987 2189711 2189711 defendant Pekke Nicholas     Pekke, Nicholas 14
4464988 2189711 2189711 defendant Balle John     Balle, John 15
4464989 2189711 2189711 defendant Alvyngham John     Alvyngham, John 16
4464990 2189711 2189711 defendant atte Brigg John     atte Brigg, John 17
4464991 2189711 2189711 defendant Kerdyston Clement de     Kerdyston, Clement de 18
4464992 2189711 2189711 defendant Rygald William     Rygald, William 19
4464993 2189711 2189711 defendant Godefrey Thomas     Godefrey, Thomas 20
4464994 2189711 2189711 defendant atte Welle Stephen     atte Welle, Stephen 21
4464995 2189711 2189711 defendant Shirref Thomas     Shirref, Thomas 22
4464996 2189711 2189711 defendant Kyng John   587166 587166 Kyng, John, of Salle, son of Richard 23

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