names

15 rows where case_id = 2220637

✎ 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
4565036 2220637 2220637 plaintiff (not given) Thomas abbot of Shrewsbury   Shrewsbury, Thomas, abbot of 0
4565037 2220637 2220637 defendant Skryveyn John     Skryveyn, John 0
4565038 2220637 2220637 defendant Perle John jun   Perle, John, jun 1
4565039 2220637 2220637 defendant Omfreston Philip     Omfreston, Philip 2
4565040 2220637 2220637 defendant Staff Richard weaver   Staff, Richard, weaver 3
4565041 2220637 2220637 defendant Prynce Richard fleccher   Prynce, Richard, fleccher 4
4565042 2220637 2220637 defendant Betton John de son of Thomas   Betton, John de, son of Thomas 5
4565043 2220637 2220637 defendant Flecchere Howel     Flecchere, Howel 6
4565044 2220637 2220637 defendant Says Edmund   586697 586697 Says, Edmund, of Shrewsbury 7
4565045 2220637 2220637 defendant Botte Thomas   617616 617616 Botte, Thomas, of Aldefeld 8
4565046 2220637 2220637 defendant Baillyf Roger   770152 770152 Baillyf, Roger, of Froddesley 9
4565047 2220637 2220637 defendant Russheton William   770152 770152 Russheton, William, of Froddesley 10
4565048 2220637 2220637 defendant Pycart Roger     Pycart, Roger 11
4565049 2220637 2220637 defendant Lepere David   770152 770152 Lepere, David, of Froddesley 12
4565050 2220637 2220637 defendant Colle John   770152 770152 Colle, John, of Froddesley 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);