names

15 rows where case_id = 2454249

✎ 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
5330638 2454249 2454249 plaintiff Bodrugan Henry knight   Bodrugan, Henry, knight 0
5330639 2454249 2454249 defendant Tregean John   598344 598344 Tregean, John, of Roche, franklin 0
5330640 2454249 2454249 defendant Crabbe John smith 874169 874169 Crabbe, John, of Strennham, smith 1
5330641 2454249 2454249 defendant Banden or Bauen William tanner 588044 588044 Banden or Bauen, William, of Truruburgh, tanner 2
5330642 2454249 2454249 defendant Oppy John cordwainer 588044 588044 Oppy, John, of Truruburgh, cordwainer 3
5330643 2454249 2454249 defendant Touker Henry tucker 588044 588044 Touker, Henry, of Truruburgh, tucker 4
5330644 2454249 2454249 defendant Cordelyon Walter miller 588044 588044 Cordelyon, Walter, of Truruburgh, miller 5
5330645 2454249 2454249 defendant Haredrakke William carpenter 874161 874161 Haredrakke, William, of Tregrous, carpenter 6
5330646 2454249 2454249 defendant Chycoys William husbandman 874170 874170 Chycoys, William, of Trevoys, St Feok, husbandman 7
5330647 2454249 2454249 defendant Uty John, junior yeoman 862298 862298 Uty, John, junior, of Treseys, yeoman 8
5330648 2454249 2454249 defendant Jegowe Oto husbandman 862298 862298 Jegowe, Oto, of Treseys, husbandman 9
5330649 2454249 2454249 defendant Jakkecok William husbandman 862298 862298 Jakkecok, William, of Treseys, husbandman 10
5330650 2454249 2454249 defendant William Oto yeoman 862298 862298 William, Oto, of Treseys, yeoman 11
5330651 2454249 2454249 defendant Treyehan Thomas   863714 863714 Treyehan, Thomas, of Retelek, franklin 12
5330652 2454249 2454249 defendant Luky John William husbandman 874171 874171 Luky, John William, of Tremodret Wartha, husbandman 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);