names

17 rows where case_id = 2318727

✎ 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
4873733 2318727 2318727 plaintiff Plompton William knight   Plompton, William, knight 0
4873734 2318727 2318727 defendant Wryght John husbandman 815718 815718 Wryght, John, of Denholme, Bradford, husbandman 0
4873735 2318727 2318727 defendant del More Robert husbandman 586349 586349 del More, Robert, of Bradford, husbandman 1
4873736 2318727 2318727 defendant Thornton Robert husbandman 588253 588253 Thornton, Robert, of Clayton, husbandman 2
4873737 2318727 2318727 defendant Scoles Richard yeoman 757540 757540 Scoles, Richard, of Ottelay, yeoman 3
4873738 2318727 2318727 defendant Dade John tailor 757540 757540 Dade, John, of Ottelay, tailor 4
4873739 2318727 2318727 defendant Wade John tailor 757540 757540 Wade, John, of Ottelay, tailor 5
4873740 2318727 2318727 defendant Wade Richard butcher 757540 757540 Wade, Richard, of Ottelay, butcher 6
4873741 2318727 2318727 defendant Dade Robert smith 596384 596384 Dade, Robert, of Newehall, smith 7
4873742 2318727 2318727 defendant Page William yeoman 813167 813167 Page, William, of Presthorp, yeoman 8
4873743 2318727 2318727 defendant Walker William husbandman 590715 590715 Walker, William, of Byngley, husbandman 9
4873744 2318727 2318727 defendant Page Thomas fletcher 590715 590715 Page, Thomas, of Byngley, fletcher 10
4873745 2318727 2318727 defendant Laulyn or Lanlyn John yeoman 815719 815719 Laulyn or Lanlyn, John, of Hutlaye, yeoman 11
4873746 2318727 2318727 defendant Northowes Thomas yeoman 589200 589200 Northowes, Thomas, of Knaresburgh, yeoman 12
4873747 2318727 2318727 defendant Wade Thomas yeoman 589200 589200 Wade, Thomas, of Knaresburgh, yeoman 13
4873748 2318727 2318727 defendant del Syke William husbandman 625429 625429 del Syke, William, of Leys, husbandman 14
4873749 2318727 2318727 defendant Pillesworth Nicholas yeoman 714003 714003 Pillesworth, Nicholas, of Pannall, yeoman 15

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