names

49 rows where place_id = 609852

✎ 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
3680675 1920036 1920036 defendant Vye John tailor 609852 609852 Vye, John, of Stowell, tailor 0
3681727 1920381 1920381 defendant Westwood John yeoman 609852 609852 Westwood, John, of Stowell, yeoman 1
3726233 1934472 1934472 defendant Pendylton Thomas clerk 609852 609852 Pendylton, Thomas, of Stowell, clerk 4
3726239 1934473 1934473 defendant Pendylton Thomas clerk 609852 609852 Pendylton, Thomas, of Stowell, clerk 4
3726245 1934474 1934474 defendant Pendylton Thomas clerk 609852 609852 Pendylton, Thomas, of Stowell, clerk 4
3745946 1940639 1940639 defendant Porteland Walter yeoman 609852 609852 Porteland, Walter, of Stowell, yeoman 1
3764122 1946428 1946428 plaintiff Hody William   609852 609852 Hody, William, of Stowell 0
3764423 1946535 1946535 defendant Thame Thomas gent 609852 609852 Thame, Thomas, of Stowell, gent 0
3766029 1947040 1947040 defendant Hody William esq 609852 609852 Hody, William, of Stowell, esq 0
3776483 1950398 1950398 defendant Chawent Thomas husbandman 609852 609852 Chawent, Thomas, of Stowell, husbandman 0
3776984 1950548 1950548 defendant Portlond Walter yeoman 609852 609852 Portlond, Walter, of Stowell, yeoman 1
3782474 1952261 1952261 defendant Tame Thomas gent 609852 609852 Tame, Thomas, of Stowell, gent 0
3893560 1988073 1988073 defendant Hodye William esq 609852 609852 Hodye, William, of Stowell, esq 0
3942752 2004580 2004580 defendant Pyne Augustus husbandman 609852 609852 Pyne, Augustus, of Stowell, husbandman 0
4002724 2025740 2025740 defendant Same Edward yeoman 609852 609852 Same, Edward, of Stowell, yeoman 0
4005304 2026676 2026676 defendant Same Edward husbandman 609852 609852 Same, Edward, of Stowell, or of Well, husbandman 0
4202147 2096294 2096294 defendant Popull William husbandman 609852 609852 Popull, William, of Stowell, husbandman 1
4203989 2096947 2096947 defendant Stone William yeoman 609852 609852 Stone, William, of Stowell, yeoman 1
4290448 2126643 2126643 defendant Sherwell Charles weaver 609852 609852 Sherwell, Charles, of Stowell, weaver 0
4309367 2133433 2133433 defendant Churche Michael husbandman 609852 609852 Churche, Michael, of Stowell, husbandman 3
4312745 2134589 2134589 defendant Lacye Richard (legal representative) 609852 609852 Lacye, Richard, of Stowell, husbandman, administratrix of 0
4312746 2134589 2134589 defendant Lacye Edith widow 609852 609852 Lacye, Edith, of Stowell, widow 1
4320656 2137315 2137315 defendant Mason Thomas husbandman 609852 609852 Mason, Thomas, of Stowell, husbandman 0
4396083 2163265 2163265 defendant Sherwood Charles husbandman 609852 609852 Sherwood, Charles, of Stowell, husbandman 0
4403773 2165835 2165835 defendant Sherwell Charles weaver 609852 609852 Sherwell, Charles, of Stowell, weaver 0
4405914 2166540 2166540 defendant Miles John yeoman 609852 609852 Miles, John, of Stowell, yeoman 2
4423651 2172241 2172241 defendant Martel Adam   609852 609852 Martel, Adam, of Stowell 0
4720849 2271852 2271852 defendant Shete John husbandman 609852 609852 Shete, John, of Stowell, husbandman 1
4741694 2278063 2278063 defendant Kyng Richard huxbandman 609852 609852 Kyng, Richard, of Stowell, huxbandman 4
4744040 2278780 2278780 defendant Redhed Richard husbandman 609852 609852 Redhed, Richard, of Stowell, husbandman 0
4910242 2329719 2329719 plaintiff Benger John   609852 609852 Benger, John, of Stowell, franklin 13
4912821 2330506 2330506 plaintiff Benger John   609852 609852 Benger, John, of Stowell, franklin 2
4997417 2356075 2356075 defendant Chubbe Walter husbandman 609852 609852 Chubbe, Walter, of Stowell, husbandman 3
5116479 2391251 2391251 defendant Wever William yeoman 609852 609852 Wever, William, of Stowell, yeoman 0
5161017 2404326 2404326 defendant Mille Nicholas husbandman 609852 609852 Mille, Nicholas, of Stowell, husbandman 0
5161018 2404326 2404326 defendant Pounfray Walter husbandman 609852 609852 Pounfray, Walter, of Stowell, husbandman 1
5161019 2404326 2404326 defendant Fypayne Walter husbandman 609852 609852 Fypayne, Walter, of Stowell, husbandman 2
5161020 2404326 2404326 defendant Warman Thomas husbandman 609852 609852 Warman, Thomas, of Stowell, husbandman 3
5161021 2404326 2404326 defendant Hunt Walter husbandman 609852 609852 Hunt, Walter, of Stowell, husbandman 4
5300182 2445019 2445019 plaintiff Catesby John   609852 609852 Catesby, John, of Stowell 0
5314666 2449421 2449421 defendant Bakeralias Robyns William yeoman 609852 609852 Bakeralias Robyns, William, of Stowell, yeoman 0
5314667 2449421 2449421 defendant Malpas Thomas clerk 609852 609852 Malpas, Thomas, of Stowell, clerk 1
5372357 2466949 2466949 defendant Payne James clerk 609852 609852 Payne, James, of Stowell, clerk 0
5372358 2466949 2466949 defendant Illary Patrick husbandman 609852 609852 Illary, Patrick, of Stowell, husbandman 1
5483966 2500140 2500140 defendant Kyng John husbandman 609852 609852 Kyng, John, of Stowell, husbandman 1
5483967 2500140 2500140 defendant Kyng Richard husbandman 609852 609852 Kyng, Richard, of Stowell, husbandman 2
5483968 2500140 2500140 defendant Kyng Thomas   609852 609852 Kyng, Thomas, of Stowell, groom 3
5603801 2536057 2536057 plaintiff Plumpton John gent 609852 609852 Plumpton, John, of Stowell, gent 0
5625492 2551917 2551917 defendant Harrys William ploughman 609852 609852 Harrys, William, of Stowell, ploughman 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);