names

19 rows where case_id = 1993594

✎ 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
3909818 1993594 1993594 plaintiff Stanton Edward     Stanton, Edward 0
3909819 1993594 1993594 plaintiff Seygre Thomas     Seygre, Thomas 1
3909820 1993594 1993594 defendant Love William husbandman 593171 593171 Love, William, of Milton, husbandman 0
3909821 1993594 1993594 defendant Tylcok John husbandman 586682 586682 Tylcok, John, of Mylton, husbandman 1
3909822 1993594 1993594 defendant Thachere Richard husbandman 650029 650029 Thachere, Richard, of Tyngreff, husbandman 2
3909823 1993594 1993594 defendant Cowper William husbandman 650029 650029 Cowper, William, of Tyngreff, husbandman 3
3909824 1993594 1993594 defendant Lorde Henry husbandman 650029 650029 Lorde, Henry, of Tyngreff, husbandman 4
3909825 1993594 1993594 defendant Groune Stephen husbandman 650030 650030 Groune, Stephen, of Badysden, husbandman 5
3909826 1993594 1993594 defendant Everton Richard husbandman 650031 650031 Everton, Richard, of Badysdon, husbandman 6
3909827 1993594 1993594 defendant Ogull William husbandman 650032 650032 Ogull, William, of Badisdon, husbandman 7
3909828 1993594 1993594 defendant Vyncent Christopher husbandman 650031 650031 Vyncent, Christopher, of Badysdon, husbandman 8
3909829 1993594 1993594 defendant Felde Henry husbandman 650031 650031 Felde, Henry, of Badysdon, husbandman 9
3909830 1993594 1993594 defendant Mores John husbandman 650031 650031 Mores, John, of Badysdon, husbandman 10
3909831 1993594 1993594 defendant Welter William husbandman 649175 649175 Welter, William, of Tybworth, husbandman 11
3909832 1993594 1993594 defendant Jenyns William husbandman 630099 630099 Jenyns, William, of Pottysgrave, husbandman 12
3909833 1993594 1993594 defendant Gelyng John husbandman 650033 650033 Gelyng, John, of Okclyff, husbandman 13
3909834 1993594 1993594 defendant West John husbandman 650033 650033 West, John, of Okclyff, husbandman 14
3909835 1993594 1993594 defendant Potter John butcher 600773 600773 Potter, John, of Woburne, butcher 15
3909836 1993594 1993594 defendant West Edward husbandman 650033 650033 West, Edward, of Okclyff, husbandman 16

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