names

14 rows where case_id = 2317977

✎ 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
4871218 2317977 2317977 plaintiff Merwode Henry     Merwode, Henry 0
4871219 2317977 2317977 defendant Eston John, senior gent 815388 815388 Eston, John, senior, of Bysshopys Morchard, gent 0
4871220 2317977 2317977 defendant Eston John, junior gent 815388 815388 Eston, John, junior, of Bysshopys Morchard, gent 1
4871221 2317977 2317977 defendant Eston Robert gent 815388 815388 Eston, Robert, of Bysshopys Morchard, gent 2
4871222 2317977 2317977 defendant Peryn William husbandman 815389 815389 Peryn, William, of West Doune, husbandman 3
4871223 2317977 2317977 defendant Lytell John husbandman 815389 815389 Lytell, John, of West Doune, husbandman 4
4871224 2317977 2317977 defendant Alyn Richard   815389 815389 Alyn, Richard, of West Doune, holy water clerk 5
4871225 2317977 2317977 defendant Howe John husbandman 593030 593030 Howe, John, of Wemworthy, husbandman 6
4871226 2317977 2317977 defendant Rede Philip husbandman 593030 593030 Rede, Philip, of Wemworthy, husbandman 7
4871227 2317977 2317977 defendant Wodeman Robert laborer 815391 815391 Wodeman, Robert, of St Mary Doune, laborer 8
4871228 2317977 2317977 defendant Lake Henry carpenter 815392 815392 Lake, Henry, of Brysshford, carpenter 9
4871229 2317977 2317977 defendant Flogyn William husbandman 815393 815393 Flogyn, William, of Ryngysasshe, husbandman 10
4871230 2317977 2317977 defendant Beare Thomas husbandman 815394 815394 Beare, Thomas, of Rouwes Asshe, husbandman 11
4871231 2317977 2317977 defendant Toker John of Wemworthy husbandman   Toker, John of Wemworthy, husbandman 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);