names

17 rows where case_id = 2547865

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5613059 2547865 2547865 plaintiff Coly John (legal representative) 586848 586848 Coly, John, of Northampton, executors of 0
5613060 2547865 2547865 plaintiff Fox John     (Fox, John 1
5613061 2547865 2547865 plaintiff Lucy wife of John Fox     Lucy, wife of John Fox 2
5613062 2547865 2547865 defendant Mallore John   586085 586085 Mallore, John, of Welton, knight 0
5613063 2547865 2547865 defendant Mallore Giles   905931 905931 Mallore, Giles, of Lichebarwe or Litchborough 1
5613064 2547865 2547865 defendant Bonaventure John     Bonaventure, John 2
5613065 2547865 2547865 defendant Haured William     Haured, William 3
5613066 2547865 2547865 defendant Inworth Thomas   594606 594606 Inworth, Thomas, of Whitfeld 4
5613067 2547865 2547865 defendant Burneby George     Burneby, George 5
5613068 2547865 2547865 defendant Ardern Giles de knight   Ardern, Giles de, knight 6
5613069 2547865 2547865 defendant Sevry Thomas de Catesby     Sevry, Thomas de Catesby 7
5613070 2547865 2547865 defendant Ounetby Richard parson of the church, in   Ounetby, Richard, parson of the church, in 8
5613071 2547865 2547865 defendant Golofre Robert   760558 760558 Golofre, Robert, of Tyryngham 9
5613072 2547865 2547865 defendant Slayck Thomas     Slayck, Thomas 10
5613073 2547865 2547865 defendant Wiliene Thomas vicar of the church, in   Wiliene, Thomas, vicar of the church, in 11
5613074 2547865 2547865 defendant Basset Thomas clerk   Basset, Thomas, clerk 12
5613075 2547865 2547865 defendant Fraunk John Julia, his wife   Fraunk, John, Julia, his wife 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);