names

28 rows where case_id = 2521855

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5556357 2521855 2521855 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 0
5556358 2521855 2521855 defendant Canell Richard merchant of the staple 586383 586383 Canell, Richard, of Stamford, Lincs, merchant of the staple 0
5556359 2521855 2521855 defendant Storke John merchant of the staple 621323 621323 Storke, John, of Selby, Yorks, merchant of the staple 1
5556360 2521855 2521855 defendant Walweyn Roger gent 899737 899737 Walweyn, Roger, of Bedwardyn St John, Worcs, gent 2
5556361 2521855 2521855 defendant Andrewes Richard gent 585869 585869 Andrewes, Richard, of London, gent 3
5556362 2521855 2521855 defendant Hulton William gent 585869 585869 Hulton, William, of London, gent 4
5556363 2521855 2521855 defendant Ede John baker 586115 586115 Ede, John, of Lamport, Soms, baker 5
5556364 2521855 2521855 defendant Heron John gent 586111 586111 Heron, John, of Lamport, gent 6
5556365 2521855 2521855 defendant Mason Thomas     Mason, Thomas 7
5556366 2521855 2521855 defendant Lysle Henry     Lysle, Henry 8
5556367 2521855 2521855 defendant Bellyngham Roger     Bellyngham, Roger 9
5556368 2521855 2521855 defendant Suthworth John     Suthworth, John 10
5556369 2521855 2521855 defendant Messynden John     Messynden, John 11
5556370 2521855 2521855 defendant Vycars William     Vycars, William 12
5556371 2521855 2521855 defendant Sherard William     Sherard, William 13
5556372 2521855 2521855 defendant Husse Robert     Husse, Robert 14
5556373 2521855 2521855 defendant Penyngton Adam     Penyngton, Adam 15
5556374 2521855 2521855 defendant Basset William     Basset, William 16
5556375 2521855 2521855 defendant Ascough Christopher     Ascough, Christopher 17
5556376 2521855 2521855 defendant Gylpyn Richard     Gylpyn, Richard 18
5556377 2521855 2521855 defendant Troughton Robert     Troughton, Robert 19
5556378 2521855 2521855 defendant Ascough Roger     Ascough, Roger 20
5556379 2521855 2521855 defendant Ascouth Thomas     Ascouth, Thomas 21
5556380 2521855 2521855 defendant Page Richard     Page, Richard 22
5556381 2521855 2521855 defendant Dounhale Thomas     Dounhale, Thomas 23
5556382 2521855 2521855 defendant Kyrkby Thomas     Kyrkby, Thomas 24
5556383 2521855 2521855 defendant Savell John     Savell, John 25
5556384 2521855 2521855 defendant Calverley William     Calverley, William 26

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