names

53 rows where place_id = 600399

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640887 1907594 1907594 defendant Felowes Thomas husbandman 600399 600399 Felowes, Thomas, of Belbroughton, husbandman 0
3640888 1907594 1907594 defendant Felowes William husbandman 600399 600399 Felowes, William, of Belbroughton, husbandman 1
3683273 1920890 1920890 defendant Pachett John husbandman 600399 600399 Pachett, John, of Belbroughton, husbandman 2
3684989 1921442 1921442 defendant Crowe Hugh husbandman 600399 600399 Crowe, Hugh, of Belbroughton, husbandman 0
3699056 1925911 1925911 defendant Smyth John husbandman 600399 600399 Smyth, John, of Belbroughton, husbandman 0
3729512 1935475 1935475 defendant Colle Richard husbandman 600399 600399 Colle, Richard, of Belbroughton, husbandman 1
3751050 1942261 1942261 defendant Wheler John husbandman 600399 600399 Wheler, John, of Belbroughton, husbandman 0
3759115 1944838 1944838 defendant Wheler John smith 600399 600399 Wheler, John, of Belbroughton, smith 0
3759116 1944838 1944838 defendant Hortyll John husbandman 600399 600399 Hortyll, John, of Belbroughton, husbandman 1
3759117 1944838 1944838 defendant Robyns William husbandman 600399 600399 Robyns, William, of Belbroughton, husbandman 2
3764569 1946575 1946575 defendant Wheler John, senior husbandman 600399 600399 Wheler, John, senior, of Belbroughton, husbandman 2
3764570 1946575 1946575 defendant Wheler John, junior husbandman 600399 600399 Wheler, John, junior, of Belbroughton, husbandman 3
3778608 1951021 1951021 defendant Peerse William yeoman 600399 600399 Peerse, William, of Belbroughton, yeoman 0
3779778 1951408 1951408 defendant Perysson John yeoman 600399 600399 Perysson, John, of Belbroughton, yeoman 0
3779779 1951408 1951408 defendant Perysson William husbandman 600399 600399 Perysson, William, of Belbroughton, husbandman 1
3779780 1951408 1951408 defendant Robynson William husbandman 600399 600399 Robynson, William, of Belbroughton, husbandman 2
3781568 1951971 1951971 defendant Wheler John husbandman 600399 600399 Wheler, John, of Belbroughton, husbandman 0
3781569 1951971 1951971 defendant Wheler John smith 600399 600399 Wheler, John, of Belbroughton, smith 1
3781570 1951971 1951971 defendant Broke John cooper 600399 600399 Broke, John, of Belbroughton, cooper 2
3781571 1951971 1951971 defendant Robyns William husbandman 600399 600399 Robyns, William, of Belbroughton, husbandman 3
3783021 1952441 1952441 defendant Broke John cooper 600399 600399 Broke, John, of Belbroughton, cooper 0
3788082 1954063 1954063 defendant Smyth John husbandman 600399 600399 Smyth, John, of Belbroughton, husbandman 2
3788083 1954063 1954063 defendant Lowe Roger husbandman 600399 600399 Lowe, Roger, of Belbroughton, husbandman 3
3798262 1957353 1957353 defendant Wheler John   600399 600399 Wheler, John, of Belbroughton, smith, son of Wheler, John 0
3798263 1957353 1957353 defendant Hortull Humphrey husbandman 600399 600399 Hortull, Humphrey, of Belbroughton, husbandman 1
3798264 1957353 1957353 defendant Hortull John husbandman 600399 600399 Hortull, John, of Belbroughton, husbandman 2
3798265 1957353 1957353 defendant Underhill John husbandman 600399 600399 Underhill, John, of Belbroughton, husbandman 3
3798266 1957353 1957353 defendant Robyns William husbandman 600399 600399 Robyns, William, of Belbroughton, husbandman 4
3829009 1966957 1966957 defendant Lowe Roger yeoman 600399 600399 Lowe, Roger, of Belbroughton, yeoman 2
3833040 1968256 1968256 defendant Huntyngdon John husbandman 600399 600399 Huntyngdon, John, of Belbroughton, husbandman 1
3833043 1968257 1968257 defendant Huntyngdon John husbandman 600399 600399 Huntyngdon, John, of Belbroughton, husbandman 1
3843858 1971618 1971618 defendant Broke John, senior cooper 600399 600399 Broke, John, senior, of Belbroughton, cooper 0
3843859 1971618 1971618 defendant Broke John, junior cooper 600399 600399 Broke, John, junior, of Belbroughton, cooper 1
3901291 1990657 1990657 defendant Smyth Roger   600399 600399 Smyth, Roger, of Belbroughton, scythe smith 1
3959932 2010570 2010570 defendant Smythe Richard butcher 600399 600399 Smythe, Richard, of Belbroughton, butcher 3
4027257 2034396 2034396 defendant Penne John   600399 600399 Penne, John, of Belbroughton, scythe smith 0
4027258 2034396 2034396 defendant Fletcher William husbandman 600399 600399 Fletcher, William, of Belbroughton, husbandman 1
4027260 2034397 2034397 defendant Penne John   600399 600399 Penne, John, of Belbroughton, scythe smith 0
4027261 2034397 2034397 defendant Fletcher William husbandman or roper 600399 600399 Fletcher, William, of Belbroughton, husbandman or roper 1
4043298 2040072 2040072 plaintiff Plant John (legal representative) 600399 600399 Plant, John, of Belbroughton, sickle grinder, executors of 0
4053048 2043519 2043519 defendant Chaunte William roper 600399 600399 Chaunte, William, of Belbroughton, roper 4
4071806 2050215 2050215 defendant Waldren Richard yeoman 600399 600399 Waldren, Richard, of Belbroughton, yeoman 0
4071807 2050215 2050215 defendant Waldren Thomas   600399 600399 Waldren, Thomas, of Belbroughton, yeoman, his son 1
4128010 2070307 2070307 defendant Hortall William   600399 600399 Hortall, William, of Belbroughton, scythe smith 0
4128012 2070307 2070307 defendant Stokes William   600399 600399 Stokes, William, of Belbroughton, scythe smith 2
4132969 2072118 2072118 defendant Stokes William yeoman 600399 600399 Stokes, William, of Belbroughton, yeoman 0
4177666 2087663 2087663 defendant Stokes William   600399 600399 Stokes, William, of Belbroughton, scythe smith 1
4190537 2092248 2092248 defendant Pen Francis   600399 600399 Pen, Francis, of Belbroughton, scythe smith 1
4818735 2301947 2301947 defendant Hawe John husbandman 600399 600399 Hawe, John, of Belbroughton, husbandman 0
5338703 2456674 2456674 defendant Wasteley Henry laborer 600399 600399 Wasteley, Henry, of Belbroughton, laborer 0
5551138 2520362 2520362 plaintiff Coll Henry   600399 600399 Coll, Henry, of Belbroughton 0
5551140 2520363 2520363 plaintiff Coll Henry   600399 600399 Coll, Henry, of Belbroughton 0
5566254 2524728 2524728 defendant Cowper Thomas husbandman 600399 600399 Cowper, Thomas, of Belbroughton, 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);