names

51 rows where place_id = 593453

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611897 1871382 1871382 defendant Helmesley John husbandman 593453 593453 Helmesley, John, of Smeton, husbandman 0
3611899 1871383 1871383 defendant Vyncent Christopher gent 593453 593453 Vyncent, Christopher, of Smeton, gent 0
3697349 1925390 1925390 defendant Twayte Marmaduke esq 593453 593453 Twayte, Marmaduke, of Smeton, esq 0
3707582 1928667 1928667 defendant Vyncent William esq 593453 593453 Vyncent, William, of Smeton, esq 0
3722082 1933167 1933167 defendant Vyncent William esq 593453 593453 Vyncent, William, of Smeton, esq 0
3751418 1942359 1942359 defendant Ellys John husbandman 593453 593453 Ellys, John, of Smeton, husbandman 0
3879665 1983455 1983455 defendant Johnson William husbandman 593453 593453 Johnson, William, of Smeton, husbandman 0
3879666 1983455 1983455 defendant Glebhall Edmund husbandman 593453 593453 Glebhall, Edmund, of Smeton, husbandman 1
3951154 2007471 2007471 defendant Bolte John yeoman 593453 593453 Bolte, John, of Smeton, yeoman 0
3951156 2007472 2007472 defendant Gascoigne John esq 593453 593453 Gascoigne, John, of Smeton, esq 0
3979302 2017346 2017346 defendant Vincent Marmaduke esq 593453 593453 Vincent, Marmaduke, of Smeton, esq 0
3984765 2019307 2019307 defendant Vyncent Marmaduke esq 593453 593453 Vyncent, Marmaduke, of Smeton, esq 0
4064795 2047693 2047693 defendant Warcoppe Edward gent 593453 593453 Warcoppe, Edward, of Smeton, gent 0
4086395 2055412 2055412 defendant Vyncent Marmaduke esq 593453 593453 Vyncent, Marmaduke, of Smeton, esq 0
4104474 2061884 2061884 defendant Vyncent William gent 593453 593453 Vyncent, William, of Smeton, gent 0
4183280 2089634 2089634 defendant Sawmon or Salmon William yeoman 593453 593453 Sawmon or Salmon, William, of Smeton, yeoman 0
4206903 2097957 2097957 defendant Sawman or Salmon William yeoman 593453 593453 Sawman or Salmon, William, of Smeton, yeoman 0
4430917 2174430 2174430 defendant White Robert   593453 593453 White, Robert, of Smeton 3
4535240 2211287 2211287 plaintiff Shore Robert   593453 593453 Shore, Robert, of Smeton 0
4608599 2233793 2233793 defendant Carter John   593453 593453 Carter, John, of Smeton 0
4739813 2277528 2277528 defendant Boton William husbandman 593453 593453 Boton, William, of Smeton, husbandman 4
4774823 2288117 2288117 defendant Hesyll John husbandman 593453 593453 Hesyll, John, of Smeton, husbandman 3
4775028 2288185 2288185 defendant Marchand John husbandman 593453 593453 Marchand, John, of Smeton, husbandman 3
4779313 2289510 2289510 defendant Loweson John husbandman 593453 593453 Loweson, John, of Smeton, husbandman 1
4781306 2290167 2290167 defendant Milner William miller 593453 593453 Milner, William, of Smeton, miller 0
4781307 2290167 2290167 defendant Lonson John husbandman 593453 593453 Lonson, John, of Smeton, husbandman 1
4797689 2295458 2295458 defendant Neuton John   593453 593453 Neuton, John, of Smeton, parish clerk 3
4797712 2295464 2295464 defendant Lonson John husbandman 593453 593453 Lonson, John, of Smeton, husbandman 0
4797713 2295464 2295464 defendant Blenkansop Thomas smith 593453 593453 Blenkansop, Thomas, of Smeton, smith 1
4883120 2321645 2321645 defendant Blenkynsope John husbandman 593453 593453 Blenkynsope, John, of Smeton, husbandman 2
4886724 2322706 2322706 defendant Saunderson Thomas   593453 593453 Saunderson, Thomas, of Smeton, Yorksm tailor 0
4933394 2336833 2336833 defendant Hautwesyll Nicholas   593453 593453 Hautwesyll, Nicholas, of Smeton, parson 0
4983357 2351928 2351928 defendant Lubenham Thomas husbandman 593453 593453 Lubenham, Thomas, of Smeton, husbandman 1
4999455 2356707 2356707 defendant Whitby William (legal representative) 593453 593453 Whitby, William, of Smeton, executor of 0
5033928 2366795 2366795 defendant Walker William yeoman 593453 593453 Walker, William, of Smeton, yeoman 0
5033929 2366795 2366795 defendant Helmesley John husbandman 593453 593453 Helmesley, John, of Smeton, husbandman 1
5033930 2366795 2366795 defendant Horseley William husbandman 593453 593453 Horseley, William, of Smeton, husbandman 2
5069315 2377311 2377311 defendant Jay William husbandman 593453 593453 Jay, William, of Smeton, husbandman 0
5096173 2385318 2385318 defendant Vyncent Roger gent 593453 593453 Vyncent, Roger, of Smeton, gent 0
5122519 2393016 2393016 defendant White Thomas husbandman 593453 593453 White, Thomas, of Smeton, husbandman 0
5122520 2393016 2393016 defendant Couper John husbandman 593453 593453 Couper, John, of Smeton, husbandman 1
5122521 2393016 2393016 defendant Horyworth Thomas smith 593453 593453 Horyworth, Thomas, of Smeton, smith 2
5186768 2411876 2411876 defendant Kyng William laborer 593453 593453 Kyng, William, of Smeton, laborer 3
5189927 2412796 2412796 defendant Boulmer William husbandman 593453 593453 Boulmer, William, of Smeton, husbandman 0
5189933 2412797 2412797 defendant Boulmer William husbandman 593453 593453 Boulmer, William, of Smeton, husbandman 0
5290840 2442330 2442330 defendant Tyler Christopher husbandman 593453 593453 Tyler, Christopher, of Smeton, husbandman 2
5298177 2444484 2444484 defendant Ryggeley Robert husbandman 593453 593453 Ryggeley, Robert, of Smeton, husbandman 0
5305441 2446632 2446632 defendant Bryce William husbandman 593453 593453 Bryce, William, of Smeton, husbandman 0
5312707 2448838 2448838 defendant Ryggeley Robert husbandman 593453 593453 Ryggeley, Robert, of Smeton, husbandman 0
5312708 2448838 2448838 defendant Forster John, junior husbandman 593453 593453 Forster, John, junior, of Smeton, husbandman 1
5500666 2505135 2505135 defendant Vyncent Christopher gent 593453 593453 Vyncent, Christopher, of Smeton, gent 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);