names

16 rows where case_id = 2213522

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4542429 2213522 2213522 plaintiff Zouche William la   592621 592621 Zouche, William la, of Haryngworth, knight 0
4542430 2213522 2213522 defendant Plomere John     Plomere, John 0
4542431 2213522 2213522 defendant Birche John     Birche, John 1
4542432 2213522 2213522 defendant Meire Roger   767716 767716 Meire, Roger, of Hanewode 2
4542433 2213522 2213522 defendant Tadys John     Tadys, John 3
4542434 2213522 2213522 defendant (not given) John his brother   John, his brother 4
4542435 2213522 2213522 defendant Hagur Richard   586697 586697 Hagur, Richard, of Shrewsbury 5
4542436 2213522 2213522 defendant Richardson William   767717 767717 Richardson, William, of Pollile 6
4542437 2213522 2213522 defendant Hewester William   586697 586697 Hewester, William, of Shrewsbury 7
4542438 2213522 2213522 defendant Coneway John   586697 586697 Coneway, John, of Shrewsbury 8
4542439 2213522 2213522 defendant Richardson William     Richardson, William 9
4542440 2213522 2213522 defendant Gamel John     Gamel, John 10
4542441 2213522 2213522 defendant Jones Thomas     Jones, Thomas 11
4542442 2213522 2213522 defendant Grene John     Grene, John 12
4542443 2213522 2213522 defendant Wesenam William     Wesenam, William 13
4542444 2213522 2213522 defendant Desselowe Thomas hewster   together with Desselowe, Thomas, hewster 14

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