names

32 rows where place_id = 609819

✎ 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
3680495 1919982 1919982 defendant Shattok John miller 609819 609819 Shattok, John, of Oke, miller 0
3709979 1929431 1929431 defendant Spere John husbandman 609819 609819 Spere, John, of Oke, husbandman 0
3805048 1959521 1959521 defendant Spere John husbandman 609819 609819 Spere, John, of Oke, husbandman 2
3917777 1996304 1996304 defendant Genynges John husbandman 609819 609819 Genynges, John, of Oke, husbandman 1
4015672 2030303 2030303 defendant Court Thomas husbandman 609819 609819 Court, Thomas, of Oke, husbandman 1
4039900 2038892 2038892 defendant Jenyns John yeoman 609819 609819 Jenyns, John, of Oke, yeoman 0
4060034 2045986 2045986 plaintiff Crocker John   609819 609819 Crocker, John, of Oke 0
4196562 2094343 2094343 defendant Gamlen James tanner 609819 609819 Gamlen, James, of Oke, tanner 2
4394721 2162820 2162820 defendant Rosseter John husbandman 609819 609819 Rosseter, John, of Oke, husbandman 0
4396228 2163312 2163312 defendant Roceter John   609819 609819 Roceter, John, of Oke, bachelor 0
4456781 2187127 2187127 defendant Andrewe Robert   609819 609819 Andrewe, Robert, of Oke 0
4558311 2218540 2218540 defendant Symmes Thomas   609819 609819 Symmes, Thomas, of Oke 4
4614956 2235689 2235689 defendant Strete William   609819 609819 Strete, William, of Oke 0
4672964 2257184 2257184 defendant Hogges Nicholas stocer 609819 609819 Hogges, Nicholas, of Oke, stocer 1
4672965 2257184 2257184 defendant Tomas-servant Symmes Wiliam stocer 609819 609819 Tomas-servant Symmes, Wiliam, of Oke, stocer 2
4736388 2276510 2276510 defendant Elyot Richard husbandman 609819 609819 Elyot, Richard, of Oke, husbandman 2
4772649 2287415 2287415 defendant Hakeworthy John husbandman 609819 609819 Hakeworthy, John, of Oke, husbandman 0
4808392 2298802 2298802 defendant Prynkelowe Thomas husbandman 609819 609819 Prynkelowe, Thomas, of Oke, husbandman 1
4808394 2298802 2298802 defendant Mere John husbandman 609819 609819 Mere, John, of Oke, husbandman 3
4840157 2308473 2308473 defendant Edward William   609819 609819 Edward, William, of Oke, parson of the parish church 0
4880973 2320959 2320959 defendant Hakeworthy John husbandman 609819 609819 Hakeworthy, John, of Oke, husbandman 0
4881302 2321054 2321054 defendant Archedale John husbandman 609819 609819 Archedale, John, of Oke, husbandman 1
4900750 2326872 2326872 defendant James Alice widow 609819 609819 James, Alice, of Oke, widow 1
4900751 2326872 2326872 defendant James John, junior husbandman 609819 609819 James, John, junior, of Oke, husbandman 2
5296008 2443822 2443822 defendant Wybbyll Richard husbandman 609819 609819 Wybbyll, Richard, of Oke, husbandman 0
5433217 2484900 2484900 defendant Shoys Henery tailor 609819 609819 Shoys, Henery, of Oke, tailor 1
5448651 2489496 2489496 defendant Shoys Henry tailor 609819 609819 Shoys, Henry, of Oke, tailor 1
5460930 2493219 2493219 defendant Schoys Henry tailor 609819 609819 Schoys, Henry, of Oke, tailor 1
5472531 2496751 2496751 defendant Schoys Henry tailor 609819 609819 Schoys, Henry, of Oke, tailor 1
5497469 2504184 2504184 defendant Skoyse Henry tailor 609819 609819 Skoyse, Henry, of Oke, tailor 1
5547431 2519262 2519262 defendant Oke Robert husbandman 609819 609819 Oke, Robert, of Oke, husbandman 0
5633100 2554357 2554357 defendant Strete William husbandman 609819 609819 Strete, William, of Oke, husbandman 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);