names

28 rows where case_id = 2438860

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5278618 2438860 2438860 plaintiff Bisshop John, junior gent 585936 585936 Bisshop, John, junior, of Norwich, or of Marsham, gent 0
5278619 2438860 2438860 defendant Abbys or Abbot Thomas carpenter 586471 586471 Abbys or Abbot, Thomas, of Aylesham, carpenter 0
5278620 2438860 2438860 defendant Pekette Thomas husbandman 587331 587331 Pekette, Thomas, of Causton, husbandman 1
5278621 2438860 2438860 defendant Hoddys Robert yeoman 586820 586820 Hoddys, Robert, of Swanton Abbot, yeoman 2
5278622 2438860 2438860 defendant Toneys John   586471 586471 Toneys, John, of Aylesham 3
5278623 2438860 2438860 defendant Randolf Edward chaplain 586471 586471 Randolf, Edward, of Aylesham, chaplain 4
5278624 2438860 2438860 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 5
5278625 2438860 2438860 defendant Merchaunt John clerk 587387 587387 Merchaunt, John, of Boton, clerk 6
5278626 2438860 2438860 defendant Baxster Richard husbandman 590405 590405 Baxster, Richard, of Martham, husbandman 7
5278627 2438860 2438860 defendant Mors John husbandman 587331 587331 Mors, John, of Causton, husbandman 8
5278628 2438860 2438860 defendant Jelyons William butcher 587331 587331 Jelyons, William, of Causton, butcher 9
5278629 2438860 2438860 defendant Barker John husbandman 624353 624353 Barker, John, of Blyclyng, husbandman 10
5278630 2438860 2438860 defendant Lekke John husbandman 605374 605374 Lekke, John, of Brynton, husbandman 11
5278631 2438860 2438860 defendant Lely John yeoman 587167 587167 Lely, John, of Parva Walsyngham, yeoman 12
5278632 2438860 2438860 defendant Oke Alexander laborer 602135 602135 Oke, Alexander, of Henyngham, laborer 13
5278633 2438860 2438860 defendant Parys John husbandman 606657 606657 Parys, John, of Bynham, husbandman 14
5278634 2438860 2438860 defendant Fuller Roger of Totyngton fuller   Fuller, Roger of Totyngton, fuller 15
5278635 2438860 2438860 defendant Speller John husbandman 593527 593527 Speller, John, of Saxlyngham, husbandman 16
5278636 2438860 2438860 defendant Carter Robert yeoman 592344 592344 Carter, Robert, of Holt, yeoman 17
5278637 2438860 2438860 defendant Bayly William laborer 586819 586819 Bayly, William, of Worsted, laborer 18
5278638 2438860 2438860 defendant Goche John yeoman 599855 599855 Goche, John, of Ravenyngham, yeoman 19
5278639 2438860 2438860 defendant Robert of Wodnorton husbandman   Robert, of Wodnorton, husbandman 20
5278640 2438860 2438860 defendant Iwyns John husbandman 826054 826054 Iwyns, John, of Berton juxta Smalbergh, husbandman 21
5278641 2438860 2438860 defendant Bo- Henry clerk 597384 597384 Bo-, Henry, of Parva Fraunsham, clerk 22
5278642 2438860 2438860 defendant Herffrey Peter husbandman   Herffrey, Peter, husbandman 23
5278643 2438860 2438860 defendant Charlys Henry husbandman 589340 589340 Charlys, Henry, of Est Todenham, husbandman 24
5278644 2438860 2438860 defendant Shaxston Nicholas   585936 585936 Shaxston, Nicholas, of Norwich, freemason 25
5278645 2438860 2438860 defendant Abell Robert husbandman 859786 859786 Abell, Robert, of Mulkeberton, husbandman 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);