names

20 rows where case_id = 2183230

✎ 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
4444367 2183230 2183230 plaintiff Cok John     Cok, John 0
4444368 2183230 2183230 defendant Wyche John     Wyche, John 0
4444369 2183230 2183230 defendant Vele William     Vele, William 1
4444370 2183230 2183230 defendant Richeman William   756084 756084 Richeman, William, of Mershton 2
4444371 2183230 2183230 defendant Basket Walter     Basket, Walter 3
4444372 2183230 2183230 defendant Homere Morris     Homere, Morris 4
4444373 2183230 2183230 defendant Palmere Thomas   756084 756084 Palmere, Thomas, of Mershton 5
4444374 2183230 2183230 defendant Tailoour Henry   756084 756084 Tailoour, Henry, of Mershton 6
4444375 2183230 2183230 defendant Burcy John   754947 754947 Burcy, John, of Yevele 7
4444376 2183230 2183230 defendant Bagge Henry clerk   Bagge, Henry, clerk 8
4444377 2183230 2183230 defendant Adam John   756084 756084 Adam, John, of Mershton 9
4444378 2183230 2183230 defendant Cobbe John of atte Barre     Cobbe, John of atte Barre 10
4444379 2183230 2183230 defendant Maundevyle Richard     Maundevyle, Richard 11
4444380 2183230 2183230 defendant Carpenter Robert   757244 757244 Carpenter, Robert, of Modeford 12
4444381 2183230 2183230 defendant Dollyng William     Dollyng, William 13
4444382 2183230 2183230 defendant Beaufitz Lawrence     Beaufitz, Lawrence 14
4444383 2183230 2183230 defendant Marchal John     Marchal, John 15
4444384 2183230 2183230 defendant Danyel Robert     Danyel, Robert 16
4444385 2183230 2183230 defendant White John   757244 757244 White, John, of Modeford 17
4444386 2183230 2183230 defendant atte Hethe William   736091 736091 atte Hethe, William, of Branford 18

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