names

25 rows where case_id = 2246781

✎ 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
4652634 2246781 2246781 plaintiff Ballard Gregory esq   Ballard, Gregory, esq 0
4652635 2246781 2246781 defendant Denys John husbandman 605491 605491 Denys, John, of Harowe, Middx, husbandman 0
4652636 2246781 2246781 defendant Readynge John husbandman 601768 601768 Readynge, John, of Harowe, husbandman 1
4652637 2246781 2246781 defendant Waps Gilbert husbandman 601768 601768 Waps, Gilbert, of Harowe, husbandman 2
4652638 2246781 2246781 defendant Alfrich John husbandman 601768 601768 Alfrich, John, of Harowe, husbandman 3
4652639 2246781 2246781 defendant Pyryman Richard husbandman 601768 601768 Pyryman, Richard, of Harowe, husbandman 4
4652640 2246781 2246781 defendant Edelyne John husbandman 601768 601768 Edelyne, John, of Harowe, husbandman 5
4652641 2246781 2246781 defendant Yerdherst William husbandman 778069 778069 Yerdherst, William, of Maghfeld, Sussex, husbandman 6
4652642 2246781 2246781 defendant Denys William husbandman 601768 601768 Denys, William, of Harowe, husbandman 7
4652643 2246781 2246781 defendant Horlok Nicholas husbandman 601768 601768 Horlok, Nicholas, of Harowe, husbandman 8
4652644 2246781 2246781 defendant Rowehed John husbandman 601768 601768 Rowehed, John, of Harowe, husbandman 9
4652645 2246781 2246781 defendant Payn John husbandman 601768 601768 Payn, John, of Harowe, husbandman 10
4652646 2246781 2246781 defendant Vynch John husbandman 601768 601768 Vynch, John, of Harowe, husbandman 11
4652647 2246781 2246781 defendant Phylypp alias Mauncer John husbandman 778217 778217 Phylypp alias Mauncer, John, of Aldyngbourne, Sussex, husbandman 12
4652648 2246781 2246781 defendant Baylly William husbandman 778218 778218 Baylly, William, of Aldyngbourne, husbandman 13
4652649 2246781 2246781 defendant Dobbe Nicholas husbandman 778218 778218 Dobbe, Nicholas, of Aldyngbourne, husbandman 14
4652650 2246781 2246781 defendant Wake William husbandman 778218 778218 Wake, William, of Aldyngbourne, husbandman 15
4652651 2246781 2246781 defendant Halle Stephen husbandman 778218 778218 Halle, Stephen, of Aldyngbourne, husbandman 16
4652652 2246781 2246781 defendant Bastard John husbandman 778218 778218 Bastard, John, of Aldyngbourne, husbandman 17
4652653 2246781 2246781 defendant Smyth William husbandman 778219 778219 Smyth, William, of Eastergate, Sussex, husbandman 18
4652654 2246781 2246781 defendant Sealtere Richard gent 592217 592217 Sealtere, Richard, of Chichester, Sussex, gent 19
4652655 2246781 2246781 defendant Bakere John (legal representative) 596634 596634 Bakere, John, of Mundham, executors of 20
4652656 2246781 2246781 defendant Tylye Henry husbandman 615593 615593 (Tylye, Henry, of Bosham, Sussex, husbandman 21
4652657 2246781 2246781 defendant Balman Philip husbandman 588084 588084 Balman, Philip, of Chichester, husbandman 22
4652658 2246781 2246781 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);