names

43 rows where place_id = 590602

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601755 1868206 1868206 defendant Kettilburn William yeoman 590602 590602 Kettilburn, William, of Gryngley, yeoman 1
3724295 1933885 1933885 defendant Blakeden John clerk 590602 590602 Blakeden, John, of Gryngley, clerk 0
3724296 1933885 1933885 defendant Chanche John clerk 590602 590602 Chanche, John, of Gryngley, clerk 1
3724297 1933885 1933885 defendant Fyxer Ellen widow 590602 590602 Fyxer, Ellen, of Gryngley, widow 2
3724298 1933885 1933885 defendant Johnson John husbandman 590602 590602 Johnson, John, of Gryngley, husbandman 3
3734920 1937160 1937160 defendant Johnson Robert husbandman 590602 590602 Johnson, Robert, of Gryngley, husbandman 0
3824098 1965410 1965410 defendant Kechen John miller 590602 590602 Kechen, John, of Gryngley, miller 0
3856327 1975597 1975597 defendant Knagys Elizabeth widow 590602 590602 Knagys, Elizabeth, of Gryngley, widow 0
3856328 1975597 1975597 defendant Knagys John yeoman 590602 590602 Knagys, John, of Gryngley, yeoman 1
3861306 1977252 1977252 defendant Byngley John husbandman 590602 590602 Byngley, John, of Gryngley, husbandman 2
3901974 1990889 1990889 defendant Walsham Thomas husbandman 590602 590602 Walsham, Thomas, of Gryngley, husbandman 0
3901975 1990889 1990889 defendant Wanley William laborer 590602 590602 Wanley, William, of Gryngley, laborer 1
3901976 1990889 1990889 defendant Gray William   590602 590602 Gray, William, of Gryngley, surgeon 2
3913037 1994691 1994691 defendant Godley Thomas yeoman 590602 590602 Godley, Thomas, of Gryngley, yeoman 0
3913039 1994691 1994691 defendant Stuffyn John yeoman 590602 590602 Stuffyn, John, of Gryngley, yeoman 2
3913043 1994692 1994692 defendant Godley Katherine widow 590602 590602 Godley, Katherine, of Gryngley, widow 1
3915633 1995599 1995599 defendant Walscham William husbandman 590602 590602 Walscham, William, of Gryngley, husbandman 0
4110146 2063891 2063891 defendant Buttrie Robert yeoman 590602 590602 Buttrie, Robert, of Gryngley, yeoman 1
4642457 2243917 2243917 defendant Hert Simon   590602 590602 Hert, Simon, of Gryngley 2
4685517 2261064 2261064 defendant Foster William   590602 590602 Foster, William, of Gryngley, bailiff 3
4700886 2265679 2265679 defendant Forster William husbandman 590602 590602 Forster, William, of Gryngley, husbandman 0
4719271 2271375 2271375 defendant Lancastre John yeoman 590602 590602 Lancastre, John, of Gryngley, yeoman 0
4745037 2279061 2279061 defendant Forster William husbandman 590602 590602 Forster, William, of Gryngley, husbandman 1
4762414 2284230 2284230 defendant Forster William husbandman 590602 590602 Forster, William, of Gryngley, husbandman 0
4785992 2291658 2291658 defendant Forster William husbandman 590602 590602 Forster, William, of Gryngley, husbandman 0
4835632 2307136 2307136 defendant Normanton John husbandman 590602 590602 Normanton, John, of Gryngley, husbandman 1
4835634 2307136 2307136 defendant Peresson Richard husbandman 590602 590602 Peresson, Richard, of Gryngley, husbandman 3
4853893 2312627 2312627 plaintiff Wyllyamson Thomas yeoman 590602 590602 Wyllyamson, Thomas, of Gryngley, yeoman 0
4853894 2312627 2312627 plaintiff Calverley Nicholas yeoman 590602 590602 Calverley, Nicholas, of Gryngley, yeoman 1
4889953 2323643 2323643 defendant Forsett Robert yeoman 590602 590602 Forsett, Robert, of Gryngley, yeoman 0
4932123 2336442 2336442 defendant Clerk Thomas milner 590602 590602 Clerk, Thomas, of Gryngley, milner 2
5074069 2378736 2378736 defendant Wryght Henry   590602 590602 Wryght, Henry, of Gryngley, wright 0
5081510 2380969 2380969 defendant Wodward John clerk 590602 590602 Wodward, John, of Gryngley, clerk 1
5081511 2380969 2380969 defendant Mayr William husbandman 590602 590602 Mayr, William, of Gryngley, husbandman 2
5081512 2380969 2380969 defendant Walsham Robert husbandman 590602 590602 Walsham, Robert, of Gryngley, husbandman 3
5081513 2380969 2380969 defendant Walsham Thomas husbandman 590602 590602 Walsham, Thomas, of Gryngley, husbandman 4
5081514 2380969 2380969 defendant Garner Henry husbandman 590602 590602 Garner, Henry, of Gryngley, husbandman 5
5336397 2455954 2455954 defendant Drayton Robert husbadman 590602 590602 Drayton, Robert, of Gryngley, husbadman 1
5496687 2503929 2503929 defendant Chauntrell Thomas husbandman 590602 590602 Chauntrell, Thomas, of Gryngley, husbandman 1
5541727 2517524 2517524 defendant Bird Nicholas yeoman 590602 590602 Bird, Nicholas, of gryngley, yeoman 0
5567682 2525121 2525121 defendant Brydde Nicholas yeoman 590602 590602 Brydde, Nicholas, of Gryngley, yeoman 2
5568641 2525378 2525378 defendant Brydde Nicholas yeoman 590602 590602 Brydde, Nicholas, of Gryngley, yeoman 0
5587169 2531015 2531015 defendant Byrde Nicholas   590602 590602 Byrde, Nicholas, of Gryngley, yeoman, bailiff of Bassetlowe 2

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);