names

19 rows where case_id = 2379555

✎ 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
5076777 2379555 2379555 plaintiff Beaumont John Viscount Beaumont   Beaumont, John, Viscount Beaumont 0
5076778 2379555 2379555 defendant Atkynson John yeoman 611336 611336 Atkynson, John, of Clynt, yeoman 0
5076779 2379555 2379555 defendant Haxeby Richard yeoman 843598 843598 Haxeby, Richard, of Hartwyth, yeoman 1
5076780 2379555 2379555 defendant Beystane or Beystave William husbandman 843599 843599 Beystane or Beystave, William, of Wyntesley, husbandman 2
5076781 2379555 2379555 defendant Plungland William husbandman 843600 843600 Plungland, William, of Hertwyth, husbandman 3
5076782 2379555 2379555 defendant de Hawyth William   843601 843601 de Hawyth, William, of Hertwyth, husbandan 4
5076783 2379555 2379555 defendant Steyll John laborer 827691 827691 Steyll, John, of Bysshopside, laborer 5
5076784 2379555 2379555 defendant Colyer Henry yeoman 827691 827691 Colyer, Henry, of Bysshopside, yeoman 6
5076785 2379555 2379555 defendant Lofthouse Thomas yeoman 720213 720213 Lofthouse, Thomas, of Morehouse, yeoman 7
5076786 2379555 2379555 defendant Benson Thomas yeoman 843602 843602 Benson, Thomas, of Bernegerhouse, yeoman 8
5076787 2379555 2379555 defendant Torpane or Toppane Richard yeoman 843603 843603 Torpane or Toppane, Richard, of Fawater, yeoman 9
5076788 2379555 2379555 defendant Parcour John yeoman 843604 843604 Parcour, John, of Hampstwayth, yeoman 10
5076789 2379555 2379555 defendant Haskewyth William husbandman 843598 843598 Haskewyth, William, of Hartwyth, husbandman 11
5076790 2379555 2379555 defendant Haweson John yeoman 843605 843605 Haweson, John, of Padleybrig, yeoman 12
5076791 2379555 2379555 defendant Hawson John tailor 843605 843605 Hawson, John, of Padleybrig, tailor 13
5076792 2379555 2379555 defendant Bayne William laborer 843606 843606 Bayne, William, of Blasthayhouse, laborer 14
5076793 2379555 2379555 defendant Ketywell William laborer 843605 843605 Ketywell, William, of Padleybrig, laborer 15
5076794 2379555 2379555 defendant Smyth Christopher laborer 827696 827696 Smyth, Christopher, of Yodenwath, laborer 16
5076795 2379555 2379555 defendant Smyth Miles laborer 827696 827696 Smyth, Miles, of Yodenwath, laborer 17

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