names

15 rows where case_id = 2205319

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4515648 2205319 2205319 plaintiff Clere John     Clere, John 0
4515649 2205319 2205319 defendant Cok William   642210 642210 Cok, William, of Lyrlyng 0
4515650 2205319 2205319 defendant Dunthorn Richard     Dunthorn, Richard 1
4515651 2205319 2205319 defendant Ferour Robert   586428 586428 Ferour, Robert, of Wilby 2
4515652 2205319 2205319 defendant Thweyt Edmund     Thweyt, Edmund 3
4515653 2205319 2205319 defendant Neve Thomas     Neve, Thomas 4
4515654 2205319 2205319 defendant Payn Peter     Payn, Peter 5
4515655 2205319 2205319 defendant Wesoul John     Wesoul, John 6
4515656 2205319 2205319 defendant Hargham Alan de     Hargham, Alan de 7
4515657 2205319 2205319 defendant Rokele John     Rokele, John 8
4515658 2205319 2205319 defendant Kelyng John     Kelyng, John 9
4515659 2205319 2205319 defendant atte Brigge Roger     atte Brigge, Roger 10
4515660 2205319 2205319 defendant Brigham William     Brigham, William 11
4515661 2205319 2205319 defendant Sayeve Richard     Sayeve, Richard 12
4515662 2205319 2205319 defendant Trypelot John     Trypelot, John 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);