names

12 rows where case_id = 2206133

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4518405 2206133 2206133 plaintiff Despenser Philip le knight   Despenser, Philip le, knight 0
4518406 2206133 2206133 plaintiff Roos James de knight   Roos, James de, knight 1
4518407 2206133 2206133 plaintiff Meres John de   739739 739739 Meres, John de, of Kirketon 2
4518408 2206133 2206133 plaintiff Welby Roger de   588071 588071 Welby, Roger de, of Multon 3
4518409 2206133 2206133 plaintiff Thornton John de   670400 670400 Thornton, John de, of Spalding 4
4518410 2206133 2206133 plaintiff Wolmere Richard   765563 765563 Wolmere, Richard, of Swyndesheved 5
4518411 2206133 2206133 plaintiff Askeby William chaplain   Askeby, William, chaplain 6
4518412 2206133 2206133 defendant Thurgar Oliver     Thurgar, Oliver 0
4518413 2206133 2206133 defendant Halmer Gilbert     Halmer, Gilbert 1
4518414 2206133 2206133 defendant Halmer Helen     Helen, his wife 2
4518415 2206133 2206133 defendant Litwhite Thomas     Litwhite, Thomas 3
4518416 2206133 2206133 defendant Litwhite Julia     Julia, his wife 4

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