names

70 rows where place_id = 587222

✎ 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
3590799 1864761 1864761 defendant Toft Richard yeoman 587222 587222 Toft, Richard, of Stodeley, yeoman 1
3601729 1868196 1868196 defendant Calwodeley Humphrey esq 587222 587222 Calwodeley, Humphrey, of Stodeley, esq 0
3607851 1870105 1870105 defendant Yerdeley Richard yeoman 587222 587222 Yerdeley, Richard, of Stodeley, yeoman 1
3624895 1875322 1875322 defendant Bevere William husbandman 587222 587222 Bevere, William, of Stodeley, husbandman 0
3655288 1911913 1911913 defendant Kendall John gent 587222 587222 Kendall, John, of Stodeley, gent 0
3658192 1912815 1912815 defendant Tomkynson William husbandman 587222 587222 Tomkynson, William, of Stodeley, husbandman 4
3667350 1915725 1915725 defendant Olyver Nicholas husbandman 587222 587222 Olyver, Nicholas, of Stodeley, husbandman 2
3678888 1919465 1919465 plaintiff Olyver Nicholas yeoman 587222 587222 Olyver, Nicholas, of Stodeley, yeoman 0
3700813 1926504 1926504 defendant Malory John   587222 587222 Malory, John, of Stodeley, knight 0
3700814 1926504 1926504 defendant Malory William esq 587222 587222 Malory, William, of Stodeley, esq 1
3700821 1926505 1926505 defendant Malory John   587222 587222 Malory, John, of Stodeley, knight 0
3700822 1926505 1926505 defendant Malory William esq 587222 587222 Malory, William, of Stodeley, esq 1
3700829 1926506 1926506 defendant Malory John   587222 587222 Malory, John, of Stodeley, knight 0
3700830 1926506 1926506 defendant Malory William esq 587222 587222 Malory, William, of Stodeley, esq 1
3729731 1935553 1935553 defendant Maliory John esq 587222 587222 Maliory, John, of Stodeley, esq 0
3729741 1935556 1935556 defendant Maliory William   587222 587222 Maliory, William, of Stodeley, knight 0
3749524 1941763 1941763 defendant Wattys William husbandman 587222 587222 Wattys, William, of Stodeley, husbandman 0
3860941 1977148 1977148 defendant Ede Simon husbandman 587222 587222 Ede, Simon, of Stodeley, husbandman 0
3888392 1986378 1986378 defendant Robyns Robert husbandman 587222 587222 Robyns, Robert, of Stodeley, husbandman 2
4052454 2043298 2043298 defendant Payne John husbandman 587222 587222 Payne, John, of Stodeley, husbandman 0
4218070 2101817 2101817 defendant Browghton George gent 587222 587222 Browghton, George, of Stodeley, gent 0
4493323 2198615 2198615 defendant Shoter Robert   587222 587222 Shoter, Robert, of Stodeley 0
4529401 2209481 2209481 defendant Stabyul Thomas   587222 587222 Stabyul, Thomas, of Stodeley 4
4535981 2211532 2211532 defendant Deyster William   587222 587222 Deyster, William, of Stodeley 0
4547096 2215025 2215025 defendant Dawe William   587222 587222 Dawe, William, of Stodeley 3
4549482 2215783 2215783 defendant Howes Thomas   587222 587222 Howes, Thomas, of Stodeley 1
4549486 2215784 2215784 defendant Hwes Thomas   587222 587222 Hwes, Thomas, of Stodeley 1
4562071 2219701 2219701 defendant Graunger Ralph   587222 587222 Graunger, Ralph, of Stodeley 0
4594856 2229646 2229646 plaintiff Puddyng William   587222 587222 Puddyng, William, of Stodeley 0
4597538 2230475 2230475 defendant Smyth John   587222 587222 Smyth, John, of Stodeley 0
4601514 2231697 2231697 defendant Wodecok William   587222 587222 Wodecok, William, of Stodeley 0
4603759 2232361 2232361 defendant Shepherd William   587222 587222 Shepherd, William, of Stodeley 4
4613537 2235252 2235252 defendant Stodeley Walter   587222 587222 Stodeley, Walter, of Stodeley 2
4640038 2243213 2243213 defendant Stodeley Walter   587222 587222 Stodeley, Walter, of Stodeley 1
4650758 2246243 2246243 defendant Huchyns William   587222 587222 Huchyns, William, of Stodeley 0
4707806 2267809 2267809 defendant Tempest Nicholas gent 587222 587222 Tempest, Nicholas, of Stodeley, gent 0
4709242 2268258 2268258 defendant Fosse John   587222 587222 Fosse, John, of Stodeley, plough wright 0
4743731 2278696 2278696 defendant Quynteyn John husbandman 587222 587222 Quynteyn, John, of Stodeley, husbandman 1
4799589 2296051 2296051 defendant Yerdeley Thomas husbandman 587222 587222 Yerdeley, Thomas, of Stodeley, husbandman 0
4799593 2296052 2296052 defendant Smyth Richard husbandman 587222 587222 Smyth, Richard, of Stodeley, husbandman 2
4829784 2305361 2305361 defendant Puddyng William husbandman 587222 587222 Puddyng, William, of Stodeley, husbandman 4
4829790 2305362 2305362 defendant Puddyng William husbandman 587222 587222 Puddyng, William, of Stodeley, husbandman 3
4836350 2307343 2307343 defendant Pudyng William husbandman 587222 587222 Pudyng, William, of Stodeley, husbandman 5
4868552 2317138 2317138 defendant Pudyng William husbandman 587222 587222 Pudyng, William, of Stodeley, husbandman 5
4972055 2348577 2348577 defendant Sachevile Waren husbandman 587222 587222 together with Sachevile, Waren, of Stodeley, husbandman 1
4973491 2349018 2349018 defendant Mason John yeoman 587222 587222 Mason, John, of Stodeley, yeoman 0
5009876 2359766 2359766 plaintiff Upton Richard   587222 587222 Upton, Richard, of Stodeley, prior 0
5026192 2364553 2364553 defendant Rygge William husbandman 587222 587222 Rygge, William, of Stodeley, husbandman 2
5228405 2423915 2423915 defendant Strayne John butcher 587222 587222 Strayne, John, of Stodeley, butcher 0
5285232 2440704 2440704 defendant Yerdeley John husbandman 587222 587222 Yerdeley, John, of Stodeley, husbandman 1
5307431 2447233 2447233 defendant Swayne John husbandman 587222 587222 Swayne, John, of Stodeley, husbandman 0
5307432 2447233 2447233 defendant Benson Roger laborer 587222 587222 Benson, Roger, of Stodeley, laborer 1
5307433 2447233 2447233 defendant Benson William laborer 587222 587222 Benson, William, of Stodeley, laborer 2
5328474 2453590 2453590 defendant Yerde John yeoman 587222 587222 Yerde, John, of Stodeley, yeoman 0
5377542 2468561 2468561 defendant (not given) Thomas prior of Wodde 587222 587222 Wodde, Thomas, of Stodeley, prior of the House & Church of Blessed Mary 0
5377544 2468561 2468561 defendant Russheton Alexander gent 587222 587222 Russheton, Alexander, of Stodeley, gent 2
5377545 2468561 2468561 defendant Persons Richard yeoman 587222 587222 Persons, Richard, of Stodeley, yeoman 3
5377546 2468561 2468561 defendant Smyth Richard husbandman 587222 587222 Smyth, Richard, of Stodeley, husbandman 4
5377548 2468561 2468561 defendant Yardeley Adam husbandman 587222 587222 Yardeley, Adam, of Stodeley, husbandman 6
5377551 2468561 2468561 defendant Wever David weaver 587222 587222 Wever, David, of Stodeley, weaver 9
5456766 2491942 2491942 defendant (not given) Thomas prior of Awood 587222 587222 Awood, Thomas, of Stodeley, prior of the house of the BM 0
5465616 2494627 2494627 plaintiff (not given) Thomas a prior of Wode 587222 587222 Wode, Thomas a, of Stodeley, prior of the house & church of the BM 0
5465617 2494627 2494627 defendant Ede Richard carpenter 587222 587222 Ede, Richard, of Stodeley, carpenter 0
5468671 2495563 2495563 defendant (not given) Thomas prior of Awod 587222 587222 Awod, Thomas, of Stodeley, prior of the house or church of the BM 0
5489488 2501741 2501741 defendant Bulke Roger husbandman 587222 587222 Bulke, Roger, of Stodeley, husbandman 1
5513264 2508997 2508997 defendant Bet Robert husbandman 587222 587222 Bet, Robert, of Stodeley, husbandman 7
5513265 2508997 2508997 defendant Sawyer Roger husbandman 587222 587222 Sawyer, Roger, of Stodeley, husbandman 8
5542353 2517732 2517732 defendant Ede Richard carpenter 587222 587222 Ede, Richard, of Stodeley, carpenter 0
5557132 2522043 2522043 defendant Edee Richard yeoman 587222 587222 Edee, Richard, of Stodeley, yeoman 0
5568758 2525411 2525411 defendant Bulky Richard husbandman 587222 587222 Bulky, Richard, of Stodeley, 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);