names

23 rows where case_id = 2187027

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4456394 2187027 2187027 plaintiff Northmor John, senior   588557 588557 Northmor, John, senior, of Tyverton, administrators of 0
4456395 2187027 2187027 plaintiff Mildenhale John     (Mildenhale, John 1
4456396 2187027 2187027 plaintiff Mildenhale Joan     Joan, his wife 2
4456397 2187027 2187027 defendant Dernhous Thomas   758749 758749 Dernhous, Thomas, of Tottenhas 0
4456398 2187027 2187027 defendant Chapel Robert   758750 758750 Chapel, Robert, of Tenmouthe or Teighmouth 1
4456399 2187027 2187027 defendant Ponystrang Peter   594621 594621 Ponystrang, Peter, of Plymouth 2
4456400 2187027 2187027 defendant Haysford Roger   758751 758751 Haysford, Roger, of Abbiston 3
4456401 2187027 2187027 defendant de la War Robert   594621 594621 de la War, Robert, of Plymouth 4
4456402 2187027 2187027 defendant Senyng Richard     Senyng, Richard 5
4456403 2187027 2187027 defendant Drok Robert   597192 597192 Drok, Robert, of Crokhorn, parson 6
4456404 2187027 2187027 defendant Pruwys Stephen   618516 618516 Pruwys, Stephen, of Otery 7
4456405 2187027 2187027 defendant Nyweman Thomas   588045 588045 Nyweman, Thomas, of Exton 8
4456406 2187027 2187027 defendant Spicer Thomas   586368 586368 Spicer, Thomas, of Taunton 9
4456407 2187027 2187027 defendant Say William     Say, William 10
4456408 2187027 2187027 defendant Say Joan     Joan, his wife 11
4456409 2187027 2187027 defendant Halle John   623547 623547 Halle, John, of Toppysham 12
4456410 2187027 2187027 defendant Hall John   758753 758753 Hall, John, of Thopesham 13
4456411 2187027 2187027 defendant Northemore John, junior     Northemore, John, junior 14
4456412 2187027 2187027 defendant Garland John servant   Garland, John, servant 15
4456413 2187027 2187027 defendant Courteney Peter     Courteney, Peter 16
4456414 2187027 2187027 defendant Pepelton John   758754 758754 Pepelton, John, of Excestre or Exeter 17
4456415 2187027 2187027 defendant Jul John   657472 657472 Jul, John, of Chagforde 18
4456416 2187027 2187027 defendant Ralegh John   758755 758755 Ralegh, John, of Colton Raly, knight 19

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