names

34 rows where place_id = 642211

✎ 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
3866533 1979037 1979037 defendant Cole John husbandman 642211 642211 Cole, John, of Wyke St Mary, husbandman 0
3893825 1988157 1988157 plaintiff Preste Simon   642211 642211 Preste, Simon, of Wyke St Mary 0
3925746 1998926 1998926 defendant Alee James yeoman 642211 642211 Alee, James, of Wyke St Mary, yeoman 0
3943593 2004875 2004875 defendant Danne John glover 642211 642211 Danne, John, of Wyke St Mary, glover 1
4441250 2182195 2182195 plaintiff Bolham Richard   642211 642211 Bolham, Richard, of Wyke St Mary, formerly parson 0
4746370 2279436 2279436 defendant Cleve Richard husbandman 642211 642211 Cleve, Richard, of Wyke St Mary, husbandman 0
4802736 2297039 2297039 defendant Mourton Thomas tailor 642211 642211 Mourton, Thomas, of Wyke St Mary, tailor 0
4823824 2303532 2303532 defendant Smyth Richard yeoman 642211 642211 Smyth, Richard, of Wyke St Mary, yeoman 2
4879471 2320509 2320509 defendant Morton Thomas yeoman 642211 642211 Morton, Thomas, of Wyke St Mary, yeoman 0
4890150 2323693 2323693 defendant Mourton Thomas tailor 642211 642211 Mourton, Thomas, of Wyke St Mary, tailor 0
4890151 2323693 2323693 defendant Legh Richard husbandman 642211 642211 Legh, Richard, of Wyke St Mary, husbandman 1
4890152 2323693 2323693 defendant Gourge John, junior   642211 642211 Gourge, John, junior, of Wyke St Mary, servant 2
4890153 2323693 2323693 defendant Wylle Stephen husbandman 642211 642211 Wylle, Stephen, of Wyke St Mary, husbandman 3
4890154 2323693 2323693 defendant Thomas Waren husbandman 642211 642211 Thomas, Waren, of Wyke St Mary, husbandman 4
4907137 2328795 2328795 defendant Millrhous William husbandman 642211 642211 Millrhous, William, of Wyke St Mary, husbandman 2
4907138 2328795 2328795 defendant Smyth Roger husbandman 642211 642211 Smyth, Roger, of Wyke St Mary, husbandman 3
5058832 2374206 2374206 defendant Lye John husbandman 642211 642211 Lye, John, of Wyke St Mary, husbandman 1
5058835 2374207 2374207 defendant Lye John husbandman 642211 642211 Lye, John, of Wyke St Mary, husbandman 1
5058837 2374208 2374208 defendant Lie John husbandman 642211 642211 Lie, John, of Wyke St Mary, husbandman 0
5116977 2391391 2391391 defendant Smyth Roger husbandman 642211 642211 Smyth, Roger, of Wyke St Mary, husbandman 1
5116981 2391392 2391392 defendant Smyth Roger husbandman 642211 642211 Smyth, Roger, of Wyke St Mary, husbandman 1
5126336 2394184 2394184 defendant Haywode Walter husbandman 642211 642211 Haywode, Walter, of Wyke St Mary, husbandman 0
5126337 2394184 2394184 defendant Morton Thomas husbandman 642211 642211 Morton, Thomas, of Wyke St Mary, husbandman 1
5126338 2394184 2394184 defendant Clyfton William   642211 642211 Clyfton, William, of Wyke St Mary 2
5126339 2394184 2394184 defendant Wandre Roger   642211 642211 Wandre, Roger, of Wyke St Mary, 3
5229107 2424120 2424120 defendant Dowe Robert smith 642211 642211 Dowe, Robert, of Wyke St Mary, smith 2
5229108 2424120 2424120 defendant Brauford John chaplain 642211 642211 Brauford, John, of Wyke St Mary, chaplain 3
5296702 2444023 2444023 defendant Wase William clerk 642211 642211 Wase, William, of Wyke St Mary, clerk 1
5304127 2446243 2446243 defendant Belamy John laborer 642211 642211 Belamy, John, of Wyke St Mary, laborer 1
5335139 2455579 2455579 defendant Brusy John gent 642211 642211 Brusy, John, of Wyke St Mary, gent 0
5373503 2467309 2467309 defendant Bonefaunt William husbandman 642211 642211 Bonefaunt, William, of Wyke St Mary, husbandman 4
5490218 2501959 2501959 defendant Lyghe William gent 642211 642211 Lyghe, William, of Wyke St Mary, gent 0
5501910 2505520 2505520 defendant Clyfton Richard husbandman 642211 642211 Clyfton, Richard, of Wyke St Mary, husbandman 0
5631762 2553947 2553947 defendant Leygh Thomas husbandman 642211 642211 Leygh, Thomas, of Wyke St Mary, husbandman 1

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