names

22 rows where case_id = 2381610

✎ 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
5083626 2381610 2381610 plaintiff FitzHarry Thomas     FitzHarry, Thomas 0
5083627 2381610 2381610 defendant Lyngen John gent 587058 587058 Lyngen, John, of Sutton, gent 0
5083628 2381610 2381610 defendant Lyngen Richard gent 587058 587058 Lyngen, Richard, of Sutton, gent 1
5083629 2381610 2381610 defendant Lye Robert yeoman 587058 587058 Lye, Robert, of Sutton, yeoman 2
5083630 2381610 2381610 defendant Taillour Geoffrey tailor 587058 587058 Taillour, Geoffrey, of Sutton, tailor 3
5083631 2381610 2381610 defendant Underwode Thomas laborer 587058 587058 Underwode, Thomas, of Sutton, laborer 4
5083632 2381610 2381610 defendant Underwode Walter husbandman 587058 587058 Underwode, Walter, of Sutton, husbandman 5
5083633 2381610 2381610 defendant ap Jenkyn John yeoman 844417 844417 ap Jenkyn, John, of Luyd, yeoman 6
5083634 2381610 2381610 defendant Evongehope or Enongehope John of Mawereden cahaplain   Evongehope or Enongehope John, of Mawereden, cahaplain 7
5083635 2381610 2381610 defendant Pole Roger yeoman 793999 793999 Pole, Roger, of Shobbedon, yeoman 8
5083636 2381610 2381610 defendant Nevyll Roger yeoman 755727 755727 Nevyll, Roger, of Covenhope, yeoman 9
5083637 2381610 2381610 defendant Wase Thomas yeoman 844418 844418 Wase, Thomas, of Shirrelegh, yeoman 10
5083638 2381610 2381610 defendant Brace John yeoman 844419 844419 Brace, John, of Shirrelgh, yeoman 11
5083639 2381610 2381610 defendant Barbour Hugh yeoman 818626 818626 Barbour, Hugh, of Bruggenorth, Salop, yeoman 12
5083640 2381610 2381610 defendant Bodye John yeoman 844420 844420 Bodye, John, of Yeatton, March of Wales, yeoman 13
5083641 2381610 2381610 defendant Baily John husbandman 844421 844421 Baily, John, of Aylemystre, March of Wales, husbandman 14
5083642 2381610 2381610 defendant Wode John husbandman 778325 778325 Wode, John, of Aylemystre, husbandman 15
5083643 2381610 2381610 defendant Eynons or Gynons Hugh yeoman 778325 778325 Eynons or Gynons, Hugh, of Aylemystre, yeoman 16
5083644 2381610 2381610 defendant Pytte John yeoman 778325 778325 Pytte, John, of Aylemystre, yeoman 17
5083645 2381610 2381610 defendant Brome Richard yeoman 844422 844422 Brome, Richard, of Lyngen, March of Wales, yeoman 18
5083646 2381610 2381610 defendant Tuder Philip yeoman 647597 647597 Tuder, Philip, of Lyngen, yeoman 19
5083647 2381610 2381610 defendant Brene or Breve Richard yeoman 647597 647597 Brene or Breve, Richard, of Lyngen, yeoman 20

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