names

17 rows where case_id = 2456614

✎ 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
5338502 2456614 2456614 plaintiff Legh Reginald     Legh, Reginald 0
5338503 2456614 2456614 defendant Middelton William yeoman 826155 826155 Middelton, William, of Herdwykwall, yeoman 0
5338504 2456614 2456614 defendant Middelton Ralph yeoman 826155 826155 Middelton, Ralph, of Herdwykwall, yeoman 1
5338505 2456614 2456614 defendant Middelton Robert chaplain 826155 826155 Middelton, Robert, of Herdwykwall, chaplain 2
5338506 2456614 2456614 defendant Nedam Hugh yeoman 792818 792818 Nedam, Hugh, of Wormyll, yeoman 3
5338507 2456614 2456614 defendant Rorour Thomas laborer 586966 586966 Rorour, Thomas, of Tunstede, laborer 4
5338508 2456614 2456614 defendant Rotour James laborer 586966 586966 Rotour, James, of Tunstede, laborer 5
5338509 2456614 2456614 defendant Longdon Thomas laborer 634017 634017 Longdon, Thomas, of Tydyswall, laborer 6
5338510 2456614 2456614 defendant Torre John laborer 804699 804699 Torre, John, of Bondon, laborer 7
5338511 2456614 2456614 defendant Kyrke Edmund laborer 804699 804699 Kyrke, Edmund, of Bondon, laborer 8
5338512 2456614 2456614 defendant Bondon Thomas yeoman 804699 804699 Bondon, Thomas, of Bondon, yeoman 9
5338513 2456614 2456614 defendant Ayre Nicholas yeoman 634850 634850 Ayre, Nicholas, of Castilton, yeoman 10
5338514 2456614 2456614 defendant Ayre Roger yeoman 593236 593236 Ayre, Roger, of Bradwall, yeoman 11
5338515 2456614 2456614 defendant Warde Thomas laborer 804699 804699 Warde, Thomas, of Bondon, laborer 12
5338516 2456614 2456614 defendant Jacson George laborer 845015 845015 Jacson, George, of Herdwyke, laborer 13
5338517 2456614 2456614 defendant Molt William laborer 804699 804699 Molt, William, of Bondon, laborer 14
5338518 2456614 2456614 defendant Molt Thomas laborer 804699 804699 Molt, Thomas, of Bondon, laborer 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);