names

43 rows where place_id = 590637

✎ 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
3601854 1868235 1868235 plaintiff Berwyk William (legal representative) 590637 590637 Berwyk, William, of Sandall, yeoman, executors of 0
3601857 1868235 1868235 defendant Haldenby Robert gent 590637 590637 Haldenby, Robert, of Sandall, gent 0
3636639 1906251 1906251 defendant Wilbore Thomas yeoman 590637 590637 Wilbore, Thomas, of Sandall, yeoman 0
3647842 1909721 1909721 defendant Taillour John yeoman 590637 590637 Taillour, John, of Sandall, yeoman 0
3680001 1919809 1919809 defendant Tayllour John husbandman 590637 590637 Tayllour, John, of Sandall, husbandman 3
3728367 1935115 1935115 defendant Ryvere John yeoman 590637 590637 Ryvere, John, of Sandall, yeoman 0
3807307 1960185 1960185 defendant Taillour John husbandman 590637 590637 Taillour, John, of Sandall, husbandman 0
3902996 1991232 1991232 defendant Forton Thomas husbandman 590637 590637 Forton, Thomas, of Sandall, husbandman 0
3928824 1999978 1999978 defendant Bone Stephen yeoman 590637 590637 Bone, Stephen, of Sandall, yeoman 0
3956513 2009345 2009345 plaintiff Normanvell John clerk 590637 590637 Normanvell, John, of Sandall, clerk 0
3979438 2017397 2017397 plaintiff Normabell John clerk 590637 590637 Normabell, John, of Sandall, clerk 0
3979658 2017482 2017482 defendant Woode Robert clerk 590637 590637 Woode, Robert, of Sandall, or of Wygsell, Sussex, clerk 0
4137653 2073821 2073821 defendant Murgatroyde Richard   590637 590637 Murgatroyde, Richard, of Sandall, linen weaver 0
4150840 2078426 2078426 defendant Turton Nicholas clothier 590637 590637 Turton, Nicholas, of Sandall, clothier 2
4187359 2091080 2091080 defendant Bouthe Henry smith 590637 590637 Bouthe, Henry, of Sandall, smith 0
4293962 2127915 2127915 defendant Wightman James shoemaker 590637 590637 Wightman, James, of Sandall, shoemaker 0
4312047 2134353 2134353 defendant Wightman James shoemaker 590637 590637 Wightman, James, of Sandall, shoemaker 0
4631120 2240631 2240631 defendant Thwayt Thomas   590637 590637 Thwayt, Thomas, of Sandall 2
4805652 2297975 2297975 defendant Eles Henry husbandman 590637 590637 with Eles, Henry, of Sandall, husbandman 4
4844830 2309908 2309908 defendant Sireson John yeoman 590637 590637 Sireson, John, of Sandall, yeoman 0
4844831 2309908 2309908 defendant Taillour Richard tailor 590637 590637 Taillour, Richard, of Sandall, tailor 1
4844833 2309909 2309909 defendant Syreson John yeoman 590637 590637 Syreson, John, of Sandall, yeoman 0
4844834 2309909 2309909 defendant Taillour Richard tailor 590637 590637 Taillour, Richard, of Sandall, tailor 1
4851951 2312043 2312043 defendant Brygonell John husbandman 590637 590637 Brygonell, John, of Sandall, husbandman 3
4854562 2312810 2312810 defendant Norton John   590637 590637 Norton, John, of Sandall 1
4854563 2312810 2312810 defendant Ploweman William   590637 590637 Ploweman, William, of Sandall 2
4854564 2312810 2312810 defendant Bute William   590637 590637 Bute, William, of Sandall 3
4887579 2322957 2322957 defendant Norton William husbandman 590637 590637 Norton, William, of Sandall, husbandman 0
4887580 2322957 2322957 defendant Hopkynson John husbandman 590637 590637 Hopkynson, John, of Sandall, husbandman 1
4887581 2322957 2322957 defendant Walker Richard husbandman 590637 590637 Walker, Richard, of Sandall, husbandman 2
4887582 2322957 2322957 defendant Taillour Richard husbandman 590637 590637 Taillour, Richard, of Sandall, husbandman 3
4887583 2322957 2322957 defendant Ploghman William husbandman 590637 590637 Ploghman, William, of Sandall, husbandman 4
4887584 2322957 2322957 defendant Pose William husbandman 590637 590637 Pose, William, of Sandall, husbandman 5
4887585 2322957 2322957 defendant Porter John husbandman 590637 590637 Porter, John, of Sandall, husbandman 6
4887675 2322975 2322975 defendant Letilwode John chaplain 590637 590637 Letilwode, John, of Sandall, chaplain 1
4971006 2348268 2348268 defendant Wilson William, junior husbandman 590637 590637 Wilson, William, junior, of Sandall, husbandman 1
5006622 2358836 2358836 defendant Skelton John clerk 590637 590637 Skelton, John, of Sandall, clerk 0
5022580 2363509 2363509 defendant Hanson Robert husbandman 590637 590637 Hanson, Robert, of Sandall, husbandman 1
5044784 2370076 2370076 defendant Pullayn Agnes   590637 590637 Pullayn, Agnes, of Sandall, servant 1
5056068 2373387 2373387 defendant Cooke Thomas husbandman 590637 590637 Cooke, Thomas, of Sandall, husbandman 10
5200981 2416048 2416048 defendant Grene John husbandman 590637 590637 Grene, John, of Sandall, husbandman 0
5561978 2523485 2523485 defendant Lyle Richard husbandman 590637 590637 Lyle, Richard, of Sandall, husbandman 0
5603614 2536004 2536004 defendant Wakefeld John gent 590637 590637 Wakefeld, John, of Sandall, gent 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);