names

25 rows where case_id = 2246782

✎ 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
4652659 2246782 2246782 plaintiff Ballard Gregory esq   Ballard, Gregory, esq 0
4652660 2246782 2246782 defendant Denys John husbandman 605491 605491 Denys, John, of Harowe, Middx, husbandman 0
4652661 2246782 2246782 defendant Reddynge John husbandman 601768 601768 Reddynge, John, of Harowe, husbandman 1
4652662 2246782 2246782 defendant Waps Gilbert husbandman 601768 601768 Waps, Gilbert, of Harowe, husbandman 2
4652663 2246782 2246782 defendant Alfrich John husbandman 601768 601768 Alfrich, John, of Harowe, husbandman 3
4652664 2246782 2246782 defendant Pyryman Richard husbandman 601768 601768 Pyryman, Richard, of Harowe, husbandman 4
4652665 2246782 2246782 defendant Edelyne John husbandman 601768 601768 Edelyne, John, of Harowe, husbandman 5
4652666 2246782 2246782 defendant Yerdherst William husbandman 778069 778069 Yerdherst, William, of Maghfeld, Sussex, husbandman 6
4652667 2246782 2246782 defendant Denys William husbandman 601768 601768 Denys, William, of Harowe, husbandman 7
4652668 2246782 2246782 defendant Horlok Nicholas husbandman 601768 601768 Horlok, Nicholas, of Harowe, husbandman 8
4652669 2246782 2246782 defendant Rowehed John husbandman 601768 601768 Rowehed, John, of Harowe, husbandman 9
4652670 2246782 2246782 defendant Payn John husbandman 601768 601768 Payn, John, of Harowe, husbandman 10
4652671 2246782 2246782 defendant Vynch John husbandman 601768 601768 Vynch, John, of Harowe, husbandman 11
4652672 2246782 2246782 defendant Phylypp alias Mauncer John husbandman 778217 778217 Phylypp alias Mauncer, John, of Aldyngbourne, Sussex, husbandman 12
4652673 2246782 2246782 defendant Baylly William husbandman 778218 778218 Baylly, William, of Aldyngbourne, husbandman 13
4652674 2246782 2246782 defendant Do- Nicholas husbandman 778218 778218 Do-, Nicholas, of Aldyngbourne, husbandman 14
4652675 2246782 2246782 defendant Wake William husbandman 778218 778218 Wake, William, of Aldyngbourne, husbandman 15
4652676 2246782 2246782 defendant Halle Stephen husbandman 778218 778218 Halle, Stephen, of Aldyngbourne, husbandman 16
4652677 2246782 2246782 defendant Bastard John husbandman 778218 778218 Bastard, John, of Aldyngbourne, husbandman 17
4652678 2246782 2246782 defendant Smyth William husbandman 778219 778219 Smyth, William, of Eastergate, Sussex, husbandman 18
4652679 2246782 2246782 defendant Sealtere Richard gent 592217 592217 Sealtere, Richard, of Chichester, Sussex, gent 19
4652680 2246782 2246782 defendant Bakere John (legal representative) 596634 596634 Bakere, John, of Mundham, executors of 20
4652681 2246782 2246782 defendant Tylye Henry husbandman 615593 615593 (Tylye, Henry, of Bosham, Sussex, husbandman 21
4652682 2246782 2246782 defendant Balman Philip husbandman 588084 588084 Balman, Philip, of Chichester, husbandman 22
4652683 2246782 2246782 defendant Balman Denise widow of John   Denise his wife, widow of John 23

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