names

19 rows where case_id = 2219481

✎ 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
4561267 2219481 2219481 plaintiff Parnyng Robert knight   Parnyng, Robert, knight 0
4561268 2219481 2219481 defendant del Blamyre Roger     del Blamyre, Roger 0
4561269 2219481 2219481 defendant Jonson Wikynson William, of Haukesdale   Jonson, Wikynson, William, of Haukesdale 1
4561270 2219481 2219481 defendant Patonson Richard   769744 769744 Patonson, Richard, of Taghton 2
4561271 2219481 2219481 defendant del Feld John   598688 598688 del Feld, John, of Unthank 3
4561272 2219481 2219481 defendant Nicolson John   769745 769745 Nicolson, John, of Gaytscales 4
4561273 2219481 2219481 defendant Hird John   770401 770401 Hird, John, of Blakhall, son of John 5
4561274 2219481 2219481 defendant Wa_ John, sen     Wa_, John, sen 6
4561275 2219481 2219481 defendant Bacon John jun   Bacon, John, jun 7
4561276 2219481 2219481 defendant Ravynwyk Thomas de     Ravynwyk, Thomas de 8
4561277 2219481 2219481 defendant Sourby Thomas son of Alan   Sourby, Thomas, son of Alan 9
4561278 2219481 2219481 defendant Hudson Thomas   633448 633448 Hudson, Thomas, of Ivegill 10
4561279 2219481 2219481 defendant Elison Geoffrey   633448 633448 Elison, Geoffrey, of Ivegill 11
4561280 2219481 2219481 defendant Baker Thomas   633448 633448 Baker, Thomas, of Ivegill 12
4561281 2219481 2219481 defendant Ledyn Wiliam   598688 598688 Ledyn, Wiliam, of Unthank 13
4561282 2219481 2219481 defendant Ravyll William   598688 598688 Ravyll, William, of Unthank 14
4561283 2219481 2219481 defendant Fynglane Roger de     Fynglane, Roger de 15
4561284 2219481 2219481 defendant Jonson Thomas     Jonson, Thomas 16
4561285 2219481 2219481 defendant Broune John   769747 769747 Broune, John, of Bachardby 17

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