names

22 rows where place_id = 598074

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631003 1904518 1904518 defendant Harryngton Thomas gent 598074 598074 Harryngton, Thomas, of Baddesworth, gent 0
4116690 2066264 2066264 defendant Sheppard Ralph yeoman 598074 598074 Sheppard, Ralph, of Baddesworth, yeoman 0
4116691 2066264 2066264 defendant Bankes Thomas yeoman 598074 598074 Bankes, Thomas, of Baddesworth, yeoman 1
4116692 2066264 2066264 defendant Broghton James yeoman 598074 598074 Broghton, James, of Baddesworth, yeoman 2
4183639 2089762 2089762 defendant Hirst William husbandman 598074 598074 Hirst, William, of Baddesworth, husbandman 2
4693090 2263345 2263345 plaintiff Bampton John de (legal representative) 598074 598074 Bampton, John de, of Baddesworth, parson, executor of 0
4704553 2266800 2266800 defendant Parkyn John   598074 598074 Parkyn, John, of Baddesworth, nail maker 0
4726158 2273468 2273468 defendant Watson Richard   598074 598074 Watson, Richard, of Baddesworth, wright 0
4726159 2273468 2273468 defendant Smyth Thomas smith 598074 598074 Smyth, Thomas, of Baddesworth, smith 1
4735156 2276142 2276142 defendant Dounes William weaver 598074 598074 Dounes, William, of Baddesworth, weaver 3
4745802 2279279 2279279 defendant Smyth Thomas smith 598074 598074 Smyth, Thomas, of Baddesworth, smith 1
4797904 2295528 2295528 defendant Chyvyngton Adam husbandman 598074 598074 Chyvyngton, Adam, of Baddesworth, husbandman 1
4801605 2296685 2296685 defendant Odde John laborer 598074 598074 Odde, John, of Baddesworth, laborer 0
4822630 2303155 2303155 defendant Chewynton Adam husbandman 598074 598074 Chewynton, Adam, of Baddesworth, husbandman 0
4901426 2327055 2327055 defendant Smyth John chaplain 598074 598074 Smyth, John, of Baddesworth, chaplain 3
5058655 2374151 2374151 defendant Coly John husbandman 598074 598074 Coly, John, of Baddesworth, husbandman 0
5058656 2374151 2374151 defendant Coly William husbandman 598074 598074 Coly, William, of Baddesworth, husbandman 1
5421857 2481473 2481473 defendant Banaster James clerk 598074 598074 Banaster, James, of Baddesworth, clerk 0
5436982 2485995 2485995 defendant Banaster James clerk 598074 598074 Banaster, James, of Baddesworth, clerk 0
5496696 2503932 2503932 defendant Vavasour William esq 598074 598074 Vavasour, William, of Baddesworth, esq 0
5496698 2503933 2503933 defendant Vavasour William esq 598074 598074 Vavasour, William, of Baddesworth, esq 0
5504935 2506460 2506460 defendant Eland Thomas gent 598074 598074 Eland, Thomas, of Baddesworth, gent 3

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