names

20 rows where case_id = 2455408

✎ 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
5334560 2455408 2455408 plaintiff FitzAlan William Earl of Arundell   FitzAlan, William, Earl of Arundell 0
5334561 2455408 2455408 defendant Ryman William gent 591570 591570 Ryman, William, of Slyndon, gent 0
5334562 2455408 2455408 defendant Whyghtrynge William gent 874633 874633 Whyghtrynge, William, of Ambirle, gent 1
5334563 2455408 2455408 defendant Gyfford John prior of Calceto Priory   Gyfford, John, prior of Calceto Priory 2
5334564 2455408 2455408 defendant Hunte Richard yeoman 674403 674403 Hunte, Richard, of Southstoke, yeoman 3
5334565 2455408 2455408 defendant Taylour John laborer 674403 674403 Taylour, John, of Southstoke, laborer 4
5334566 2455408 2455408 defendant Blake Thomas laborer 874633 874633 Blake, Thomas, of Ambirle, laborer 5
5334567 2455408 2455408 defendant Walssh William husbandman 874634 874634 Walssh, William, of Bigbeuer, husbandman 6
5334568 2455408 2455408 defendant Wode John laborer 874635 874635 Wode, John, of Est Lovent, laborer 7
5334569 2455408 2455408 defendant Ferrour Richard laborer 588084 588084 Ferrour, Richard, of Chichester, laborer 8
5334570 2455408 2455408 defendant Sawyer John aborer 588084 588084 Sawyer, John, of Chichester, aborer 9
5334571 2455408 2455408 defendant Smuth William husbandman 590528 590528 Smuth, William, of Cokkyng, husbandman 10
5334572 2455408 2455408 defendant Herkele William, junior yeoman 651448 651448 Herkele, William, junior, of Westden, yeoman 11
5334573 2455408 2455408 defendant Herkele Henry laborer 798388 798388 Herkele, Henry, of Sengylton, laborer 12
5334574 2455408 2455408 defendant Walter Henry laborer 792054 792054 Walter, Henry, of Grosham, laborer 13
5334575 2455408 2455408 defendant Clerke Richard husbandman 598123 598123 Clerke, Richard, of Pulbergh, husbandman 14
5334576 2455408 2455408 defendant Underwode Thomas husbandman 598123 598123 Underwode, Thomas, of Pulbergh, husbandman 15
5334577 2455408 2455408 defendant Mascall Thomas husbandman 598123 598123 Mascall, Thomas, of Pulbergh, husbandman 16
5334578 2455408 2455408 defendant Adammes Richard husbandman 620614 620614 Adammes, Richard, of Stopham, husbandman 17
5334579 2455408 2455408 defendant Cachelone or Cachelove John yeoman 587191 587191 Cachelone or Cachelove, John, of Arundell, yeoman 18

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