names

15 rows where case_id = 2454247

✎ 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
5330614 2454247 2454247 plaintiff Bodrugan Henry knight   Bodrugan, Henry, knight 0
5330615 2454247 2454247 defendant Crabbe John smith 874160 874160 Crabbe, John, of Stretenham, smith 0
5330616 2454247 2454247 defendant Banden William tanner 588044 588044 Banden, William, of Truruburgh, tanner 1
5330617 2454247 2454247 defendant Oppy John cordwainer 588044 588044 Oppy, John, of Truruburgh, cordwainer 2
5330618 2454247 2454247 defendant Touker Henry tucker 588044 588044 Touker, Henry, of Truruburgh, tucker 3
5330619 2454247 2454247 defendant Cordelyon Walter miller 588044 588044 Cordelyon, Walter, of Truruburgh, miller 4
5330620 2454247 2454247 defendant Harecrakke William carpenter 874161 874161 Harecrakke, William, of Tregrous, carpenter 5
5330621 2454247 2454247 defendant Chyccys William husbandman 874162 874162 Chyccys, William, of Trecoys, St Feok, husbandman 6
5330622 2454247 2454247 defendant Uty John, junior yeoman 862298 862298 Uty, John, junior, of Treseys, yeoman 7
5330623 2454247 2454247 defendant Jagowe Oto husbandman 862298 862298 Jagowe, Oto, of Treseys, husbandman 8
5330624 2454247 2454247 defendant Jakkecok William husbandman 862298 862298 Jakkecok, William, of Treseys, husbandman 9
5330625 2454247 2454247 defendant William Oto yeoman 862298 862298 William, Oto, of Treseys, yeoman 10
5330626 2454247 2454247 defendant Treyehan Thomas   863714 863714 Treyehan, Thomas, of Retelek, franklin 11
5330627 2454247 2454247 defendant Luke John William husbandman 874164 874164 Luke, John William, of Tremodret Wartham, husbandman 12
5330628 2454247 2454247 defendant Tregean John   598344 598344 together with Tregean, John, of Roche, franklin 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);