names

14 rows where case_id = 2500339

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5484660 2500339 2500339 plaintiff Nanfan Richard esq   Nanfan, Richard, esq 0
5484661 2500339 2500339 defendant Flamak Richard gent 643253 643253 Flamak, Richard, of Bocarn the Over, gent 0
5484662 2500339 2500339 defendant Trelyner John   892194 892194 Trelyner, John, of Trelyner juxta Tregollas, franklin 1
5484663 2500339 2500339 defendant Laurence Thomas husbandman 892195 892195 Laurence, Thomas, of Trevans, Wythiell, husbandman 2
5484664 2500339 2500339 defendant Harry Robert husbandman 813630 813630 Harry, Robert, of Retyre, husbandman 3
5484665 2500339 2500339 defendant Hancok Odo yeoman 587114 587114 Hancok, Odo, of Bodmyn, yeoman 4
5484666 2500339 2500339 defendant Gay William husbandman 892010 892010 Gay, William, of Trewynt, Blyslond, husbandman 5
5484667 2500339 2500339 defendant Jove Michael chaplain 809329 809329 Jove, Michael, of St Vuell, chaplain 6
5484668 2500339 2500339 defendant Smyth John husbandman 587468 587468 Smyth, John, of St Keveran, husbandman 7
5484669 2500339 2500339 defendant Gebyn John husbandman 616833 616833 Gebyn, John, of St Martyn, husbandman 8
5484670 2500339 2500339 defendant Kelwa John   892196 892196 Kelwa, John, of Coldraynek juxta Bodway, franklin 9
5484671 2500339 2500339 defendant Stoner Richard yeoman 586165 586165 Stoner, Richard, of Fowy, yeoman 10
5484672 2500339 2500339 defendant Norton Henry husbandman 892197 892197 Norton, Henry, of Trevans, St Mangan, husbandman 11
5484673 2500339 2500339 defendant Blakney Owen yeoman 828151 828151 Blakney, Owen, of Bodrugan, yeoman 12

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