names

15 rows where case_id = 2349797

✎ 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
4976025 2349797 2349797 plaintiff Opton or Upton William     Opton or Upton, William 0
4976026 2349797 2349797 defendant Harryson John chapman 623300 623300 Harryson, John, of Skarburgh, Yorks, chapman 0
4976027 2349797 2349797 defendant Othestabill of Lincoln yeoman   Othestabill, of Lincoln, yeoman 1
4976028 2349797 2349797 defendant Cantelot Richard butcher 592846 592846 Cantelot, Richard, of Wygtoft, butcher 2
4976029 2349797 2349797 defendant Vynde Robert shipman 586286 586286 Vynde, Robert, of Boston, shipman 3
4976030 2349797 2349797 defendant Boteler Richard sherman 586286 586286 Boteler, Richard, of Boston, sherman 4
4976031 2349797 2349797 defendant Farpler Robert butcher 589461 589461 Farpler, Robert, of Louthe, butcher 5
4976032 2349797 2349797 defendant Spencer John gent 620728 620728 Spencer, John, of Grymolby, gent 6
4976033 2349797 2349797 defendant Edward Richard yeoman 586846 586846 Edward, Richard, of Lincoln, yeoman 7
4976034 2349797 2349797 defendant Doo William smith 829562 829562 Doo, William, of Bostoln, smith 8
4976035 2349797 2349797 defendant German Thomas husbandman 649539 649539 German, Thomas, of Gosberkirke, husbandman 9
4976036 2349797 2349797 defendant Abram Katherine widoew of Abram, Stephen, of Fosdyk, husbandman   Abram, Katherine, widoew of Abram, Stephen, of Fosdyk, husbandman 10
4976037 2349797 2349797 defendant Redware William   594818 594818 Redware, William, of Byker 11
4976038 2349797 2349797 defendant Werk John husbandman 586055 586055 Werk, John, of Westerkele, husbandman 12
4976039 2349797 2349797 defendant Quaderyng William f Stykeney, gent   Quaderyng, William, f Stykeney, gent 13

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