names

29 rows where case_id = 2246783

✎ 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
4652684 2246783 2246783 plaintiff Ballard Gregory esq   Ballard, Gregory, esq 0
4652685 2246783 2246783 defendant Webbe William husbandman 605491 605491 Webbe, William, of Harowe, Middx, husbandman 0
4652686 2246783 2246783 defendant Asselyn Hugh husbandman 601768 601768 Asselyn, Hugh, of Harowe, husbandman 1
4652687 2246783 2246783 defendant Donner Richard husbandman 601768 601768 Donner, Richard, of Harowe, husbandman 2
4652688 2246783 2246783 defendant Redyng Thomas husbandman 601768 601768 Redyng, Thomas, of Harowe, husbandman 3
4652689 2246783 2246783 defendant Nele John husbandman 601768 601768 Nele, John, of Harowe, husbandman 4
4652690 2246783 2246783 defendant Bouryng John husbandman 601768 601768 Bouryng, John, of Harowe, husbandman 5
4652691 2246783 2246783 defendant Godyng John husbandman 601768 601768 Godyng, John, of Harowe, husbandman 6
4652692 2246783 2246783 defendant Jonet Geoffrey husbandman 778221 778221 Jonet, Geoffrey, of Bixhill, Kent, husbandman 7
4652693 2246783 2246783 defendant Jonet Roger husbandman 778222 778222 Jonet, Roger, of Bixhill, husbandman 8
4652694 2246783 2246783 defendant Jonet Richard husbandman 778222 778222 Jonet, Richard, of Bixhill, husbandman 9
4652695 2246783 2246783 defendant Jonet Stephen husbandman 778222 778222 Jonet, Stephen, of Bixhill, husbandman 10
4652696 2246783 2246783 defendant Elden John husbandman 778223 778223 Elden, John, of Esshe, Kent, husbandman 11
4652697 2246783 2246783 defendant Hamond Thomas husbandman 769344 769344 Hamond, Thomas, of Esshe, husbandman 12
4652698 2246783 2246783 defendant Antony Hugh husbandman 769344 769344 Antony, Hugh, of Esshe, husbandman 13
4652699 2246783 2246783 defendant Bertyn William husbandman 769344 769344 Bertyn, William, of Esshe, husbandman 14
4652700 2246783 2246783 defendant Rogger Thomas husbandman 611538 611538 Rogger, Thomas, of Brabourne, Kent, husbandman 15
4652701 2246783 2246783 defendant Kynet Henry husbandman 617541 617541 Kynet, Henry, of Aldyngton, Kent, husbandman 16
4652702 2246783 2246783 defendant Kempe Hugh husbandman 778087 778087 Kempe, Hugh, of Saltwode, Kent, husbandman 17
4652703 2246783 2246783 defendant Bokkeham John husbandman 589988 589988 Bokkeham, John, of Aldyngton, husbandman 18
4652704 2246783 2246783 defendant Godyn Benedict husbandman 589988 589988 Godyn, Benedict, of Aldyngton, husbandman 19
4652705 2246783 2246783 defendant B- John husbandman 778224 778224 B-, John, of Pecham, Kent, husbandman 20
4652706 2246783 2246783 defendant atte Helle Simon husbandman 589520 589520 atte Helle, Simon, of Pecham, husbandman 21
4652707 2246783 2246783 defendant Cok John husbandman 674219 674219 Cok, John, of Godmerston, Kent, husbandman 22
4652708 2246783 2246783 defendant Wade Thomas husbandman 589520 589520 Wade, Thomas, of Pecham, husbandman 23
4652709 2246783 2246783 defendant atte Ree Richard husbandman 588529 588529 atte Ree, Richard, of Eltham, Kent, husbandman 24
4652710 2246783 2246783 defendant Wayte Johnm of Eltham husbandman   Wayte, Johnm of Eltham, husbandman 25
4652711 2246783 2246783 defendant Neweman John miller 591868 591868 Neweman, John, of Eltham, miller 26
4652712 2246783 2246783 defendant Morton Thomas husbandman 778225 778225 Morton, Thomas, of Bixle, Kent, husbandman 27

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