names

28 rows where case_id = 1915464

✎ 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
3666479 1915464 1915464 plaintiff Tynmouth John prior of the monastery of St Mary & St Oswin in   Tynmouth, John, prior of the monastery of St Mary & St Oswin in 0
3666480 1915464 1915464 defendant Ogle Henry gent 606774 606774 Ogle, Henry, of Kyrklawe, gent 0
3666481 1915464 1915464 defendant Ogle John gent 606775 606775 Ogle, John, of Shawden, gent 1
3666482 1915464 1915464 defendant Parke Gilbert gent 606776 606776 Parke, Gilbert, of Warton, gent 2
3666483 1915464 1915464 defendant Carre Robert gent 603666 603666 Carre, Robert, of Wytton, gent 3
3666484 1915464 1915464 defendant Ogle John, junior gent 606777 606777 Ogle, John, junior, of Shapyngton, gent 4
3666485 1915464 1915464 defendant Reffle Ralph gent 606769 606769 Reffle, Ralph, of Eglyngeham within the liberty of Tynmouth, gent 5
3666486 1915464 1915464 defendant Calvert John yeoman 606778 606778 Calvert, John, of Eglyngeham with the Liberty of Tynmouth, yeoman 6
3666487 1915464 1915464 defendant Bewik William yeoman 606779 606779 Bewik, William, of Eglyngeham, yeoman 7
3666488 1915464 1915464 defendant rysley Edward   606779 606779 rysley, Edward, of Eglyngeham 8
3666489 1915464 1915464 defendant More Richard yeoman 586675 586675 More, Richard, of Brandon, yeoman 9
3666490 1915464 1915464 defendant More William yeoman 586675 586675 More, William, of Brandon, yeoman 10
3666491 1915464 1915464 defendant Herryson Richard yeoman 586675 586675 Herryson, Richard, of Brandon, yeoman, More, Richard, junior, of Brandon, yeoman 11
3666492 1915464 1915464 defendant Haryson John yeoman 586675 586675 Haryson, John, of Brandon, yeoman 12
3666493 1915464 1915464 defendant Harryson William yeoman 586675 586675 Harryson, William, of Brandon, yeoman 13
3666494 1915464 1915464 defendant Grene Richard yeoman 586675 586675 Grene, Richard, of Brandon, yeoman 14
3666495 1915464 1915464 defendant Hall John yeoman 606781 606781 Hall, John, of Harrop, yeoman 15
3666496 1915464 1915464 defendant Hall William yeoman 606781 606781 Hall, William, of Harrop, yeoman 16
3666497 1915464 1915464 defendant Hall Roger yeoman 606781 606781 Hall, Roger, of Harrop, yeoman 17
3666498 1915464 1915464 defendant Hall Thomas yeoman 606781 606781 Hall, Thomas, of Harrop, yeoman 18
3666499 1915464 1915464 defendant Hudd William yeoman 606781 606781 Hudd, William, of Harrop, yeoman 19
3666500 1915464 1915464 defendant Hanney William yoeman 606781 606781 Hanney, William, of Harrop, yoeman 20
3666501 1915464 1915464 defendant Daglesse Robert yeoman 606781 606781 Daglesse, Robert, of Harrop, yeoman 21
3666502 1915464 1915464 defendant Fletcher alias Harryson James yeoman 606781 606781 Fletcher alias Harryson, James, of Harrop, yeoman 22
3666503 1915464 1915464 defendant Alenson Robert yeoman 606781 606781 Alenson, Robert, of Harrop, yeoman 23
3666504 1915464 1915464 defendant Ferror Robert yeoman 606781 606781 Ferror, Robert, of Harrop, yeoman 24
3666505 1915464 1915464 defendant Armere Alexander yeoman 606781 606781 Armere, Alexander, of Harrop, yeoman 25
3666506 1915464 1915464 defendant Donnfyre or Dounsyre John yeoman 606781 606781 Donnfyre or Dounsyre, John, of Harrop, yeoman 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);