names

40 rows where place_id = 597723

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629605 1904114 1904114 defendant Huys William dyer 597723 597723 Huys, William, of Homyngton, dyer 0
3638724 1906926 1906926 defendant Bromwyche Thomas gent 597723 597723 Bromwyche, Thomas, of Homyngton, gent 0
3891935 1987554 1987554 defendant Boston William husbandman 597723 597723 Boston, William, of Homyngton, husbandman 0
3906202 1992364 1992364 defendant Boston William husbandman 597723 597723 Boston, William, of Homyngton, husbandman 0
3906203 1992364 1992364 defendant Brasfyld William husbandman 597723 597723 Brasfyld, William, of Homyngton, husbandman 1
3906204 1992364 1992364 defendant Boston Thomas husbandman 597723 597723 Boston, Thomas, of Homyngton, husbandman 2
3906208 1992365 1992365 defendant Boston William husbandman 597723 597723 Boston, William, of Homyngton, husbandman 0
4264462 2117753 2117753 defendant Humfrye Elizabeth widow 597723 597723 Humfrye, Elizabeth, of Homyngton, widow 1
4264516 2117773 2117773 defendant Humfrye Elizabeth widow 597723 597723 Humfrye, Elizabeth, of Homyngton, widow 1
4267717 2118833 2118833 defendant Humfrey Elizabeth widow 597723 597723 Humfrey, Elizabeth, of Homyngton, widow 1
4537329 2211943 2211943 defendant Hayward John   597723 597723 Hayward, John, of Homyngton 0
4703432 2266455 2266455 defendant Rolf John husbandman 597723 597723 Rolf, John, of Homyngton, husbandman 0
4725689 2273322 2273322 defendant Graunge Walter husbandman 597723 597723 Graunge, Walter, of Homyngton, husbandman 0
4745154 2279087 2279087 defendant Wyke Alice widow & formerly wife of Stephen Wyke 597723 597723 Wyke, Alice, of Homyngton, widow & formerly wife of Stephen Wyke 1
4830324 2305520 2305520 defendant Spark William husbandman 597723 597723 Spark, William, of Homyngton, husbandman 5
4846808 2310510 2310510 defendant Martyn John husbandman 597723 597723 Martyn, John, of Homyngton, husbandman 0
4886256 2322564 2322564 defendant Hayward Thomas husbandman 597723 597723 Hayward, Thomas, of Homyngton, husbandman 0
4899167 2326381 2326381 defendant Stuyll John husbandman 597723 597723 Stuyll, John, of Homyngton, husbandman 1
4918332 2332252 2332252 defendant Baker John husbandman 597723 597723 Baker, John, of Homyngton, husbandman 0
5329793 2453985 2453985 defendant Newyth John clerk 597723 597723 Newyth, John, of Homyngton, clerk 2
5329794 2453985 2453985 defendant Edmay Thomas husbandman 597723 597723 Edmay, Thomas, of Homyngton, husbandman 3
5329795 2453985 2453985 defendant Edmay John husbandman 597723 597723 Edmay, John, of Homyngton, husbandman 4
5329796 2453985 2453985 defendant Taillour William husbandman 597723 597723 Taillour, William, of Homyngton, husbandman 5
5329797 2453985 2453985 defendant Haukyns Thomas husbandman 597723 597723 Haukyns, Thomas, of Homyngton, husbandman 6
5329798 2453985 2453985 defendant Childe John, senior husbandman 597723 597723 Childe, John, senior, of Homyngton, husbandman 7
5329799 2453985 2453985 defendant Braundys John husbandman 597723 597723 Braundys, John, of Homyngton, husbandman 8
5329800 2453985 2453985 defendant Smyth Thomas husbandman 597723 597723 Smyth, Thomas, of Homyngton, husbandman 9
5329801 2453985 2453985 defendant Parkys Richard husbandman 597723 597723 Parkys, Richard, of Homyngton, husbandman 10
5329802 2453985 2453985 defendant Walton Roger husbandman 597723 597723 Walton, Roger, of Homyngton, husbandman 11
5329807 2453986 2453986 defendant Newyth John clerk 597723 597723 Newyth, John, of Homyngton, clerk 2
5329808 2453986 2453986 defendant Edmay Thomas husbandman 597723 597723 Edmay, Thomas, of Homyngton, husbandman 3
5329809 2453986 2453986 defendant Edmay John husbandman 597723 597723 Edmay, John, of Homyngton, husbandman 4
5329810 2453986 2453986 defendant Taillour William husbandman 597723 597723 Taillour, William, of Homyngton, husbandman 5
5329811 2453986 2453986 defendant Haukyns Thomas husbandman 597723 597723 Haukyns, Thomas, of Homyngton, husbandman 6
5329812 2453986 2453986 defendant Childe John, senior husbandman 597723 597723 Childe, John, senior, of Homyngton, husbandman 7
5329813 2453986 2453986 defendant Braundys John husbandman 597723 597723 Braundys, John, of Homyngton, husbandman 8
5329814 2453986 2453986 defendant Smyth Thomas husbandman 597723 597723 Smyth, Thomas, of Homyngton, husbandman 9
5329815 2453986 2453986 defendant Parkys Richard husbandman 597723 597723 Parkys, Richard, of Homyngton, husbandman 10
5329816 2453986 2453986 defendant Walton Roger husbandman 597723 597723 Walton, Roger, of Homyngton, husbandman 11
5363949 2464377 2464377 defendant Kybbell John husbandman 597723 597723 Kybbell, John, of Homyngton, husbandman 0

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