names

14 rows where case_id = 2204261

✎ 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
4512201 2204261 2204261 plaintiff Bony or Bovy Stephen     Bony or Bovy, Stephen 0
4512202 2204261 2204261 defendant Fulbrok Thomas     Fulbrok, Thomas 0
4512203 2204261 2204261 defendant Dira Roger     Dira, Roger 1
4512204 2204261 2204261 defendant Botiller Thomas     Botiller, Thomas 2
4512205 2204261 2204261 defendant Dira Thomas     Dira, Thomas 3
4512206 2204261 2204261 defendant Penda Henry   600402 600402 Penda, Henry, of Kyngesbrigge 4
4512207 2204261 2204261 defendant Dira John     Dira, John 5
4512208 2204261 2204261 defendant Botton Walter     Botton, Walter 6
4512209 2204261 2204261 defendant Bonet Thomas     Bonet, Thomas 7
4512210 2204261 2204261 defendant Botton Robert     Botton, Robert 8
4512211 2204261 2204261 defendant Stondyngcoler Walter     Stondyngcoler, Walter 9
4512212 2204261 2204261 defendant Andrewe Thomas     Andrewe, Thomas 10
4512213 2204261 2204261 defendant Trehauke William     Trehauke, William 11
4512214 2204261 2204261 defendant Trehauke Agnes     Agnes, his wife 12

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