names

17 rows where case_id = 2458449

✎ 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
5344473 2458449 2458449 plaintiff Trewynnard William     Trewynnard, William 0
5344474 2458449 2458449 defendant Drogon John laborer 593908 593908 Drogon, John, of Penrynburgh, laborer 0
5344475 2458449 2458449 defendant Kyllygrewe Thomas   875749 875749 Kyllygrewe, Thomas, of Arwennek, gewnt 1
5344476 2458449 2458449 defendant Kyllygrewe Thomas gent 593908 593908 Kyllygrewe, Thomas, of Penrynburgh, gent 2
5344477 2458449 2458449 defendant Fallasse Noel Herry weaver 593908 593908 Fallasse, Noel Herry, of Penrynburgh, weaver 3
5344478 2458449 2458449 defendant Janyn Henry weaver 593908 593908 Janyn, Henry, of Penrynburgh,weaver 4
5344479 2458449 2458449 defendant Bertolomewe John tucker 593908 593908 Bertolomewe, John, of Penrynburgh, tucker 5
5344480 2458449 2458449 defendant Rawe Thomas cpordwainer 593908 593908 Rawe, Thomas, of Penrynburgh, cpordwainer 6
5344481 2458449 2458449 defendant Nicholbedyll William or Arwennek, laborer   Nicholbedyll, William, or Arwennek, laborer 7
5344482 2458449 2458449 defendant Jobbe John tucker 875750 875750 Jobbe, John, of Spernan, tucker 8
5344483 2458449 2458449 defendant Denryan John   875751 875751 Denryan, John, of Denryan, franklin 9
5344484 2458449 2458449 defendant Kestell Richard tailor 593908 593908 Kestell, Richard, of Penrynburgh, tailor 10
5344485 2458449 2458449 defendant John William tailor 593908 593908 John, William, of Penrynburgh, tailor 11
5344486 2458449 2458449 defendant Skynne David Perys laborer 593908 593908 Skynne, David Perys, of Penrynburgh, laborer 12
5344487 2458449 2458449 defendant Seyntaubyn William tailor 593908 593908 Seyntaubyn, William, of Penrynburgh, tailor 13
5344488 2458449 2458449 defendant Vicary Reginald yeoman 875752 875752 Vicary, Reginald, of Reskymer, yeoman 14
5344489 2458449 2458449 defendant Croune Richard laborer 875752 875752 Croune, Richard, of Reskymer, laborer 15

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