names

51 rows where place_id = 607349

✎ 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
3668871 1916196 1916196 defendant Hall John husbandman 607349 607349 Hall, John, of Gargrave, husbandman 1
3668872 1916196 1916196 defendant Fontans William husbandman 607349 607349 Fontans, William, of Gargrave, husbandman 2
3685434 1921595 1921595 defendant Thomson William husbandman 607349 607349 Thomson, William, of Gargrave, husbandman 0
3685435 1921595 1921595 defendant Hall John, senior husbandman 607349 607349 Hall, John, senior, of Gargrave, husbandman 1
3685436 1921595 1921595 defendant Fontans William husbandman 607349 607349 Fontans, William, of Gargrave, husbandman 2
3687417 1922242 1922242 defendant Swier William yeoman 607349 607349 Swier, William, of Gargrave, yeoman 0
3732858 1936505 1936505 defendant Uttyng John yeoman 607349 607349 Uttyng, John, of Gargrave, yeoman 0
3812834 1961913 1961913 defendant Hall Elizabeth widow 607349 607349 Hall, Elizabeth, of Gargrave, widow 0
3822991 1965099 1965099 defendant Richardson William yeoman 607349 607349 Richardson, William, of Gargrave, yeoman 0
3868843 1979819 1979819 defendant Richardson Peter husbandman 607349 607349 Richardson, Peter, of Gargrave, husbandman 4
3906422 1992440 1992440 plaintiff Marton Christopher gent 607349 607349 Marton, Christopher, of Gargrave, gent 0
3906424 1992440 1992440 defendant Androo Hugh yeoman 607349 607349 Androo, Hugh, of Gargrave, yeoman 1
3906695 1992532 1992532 defendant Shutte Thomas smith 607349 607349 Shutte, Thomas, of Gargrave, smith 0
3918881 1996637 1996637 plaintiff Jakson Mathew   607349 607349 Jakson, Mathew, of Gargrave 0
3919359 1996807 1996807 defendant Shutte Thomas smith 607349 607349 Shutte, Thomas, of Gargrave, smith 0
3963966 2012004 2012004 defendant Smythson John husbandman 607349 607349 Smythson, John, of Gargrave, husbandman 0
3983227 2018773 2018773 defendant Smythson John husbandman 607349 607349 Smythson, John, of Gargrave, husbandman 0
3983228 2018773 2018773 defendant Ibeson John husbandman 607349 607349 Ibeson, John, of Gargrave, husbandman 1
3983229 2018773 2018773 defendant Holgayte Richard husbandman 607349 607349 Holgayte, Richard, of Gargrave, husbandman 2
4051405 2042924 2042924 defendant Lowde Christopher husbandman 607349 607349 Lowde, Christopher, of Gargrave, husbandman 2
4051406 2042924 2042924 defendant Iveson John husbandman 607349 607349 Iveson, John, of Gargrave, husbandman 3
4051407 2042924 2042924 defendant Richardson John laborer 607349 607349 Richardson, John, of Gargrave, laborer 4
4086422 2055425 2055425 defendant Lowde Christopher yeoman 607349 607349 Lowde, Christopher, of Gargrave, yeoman 0
4146449 2076908 2076908 defendant Thompson Thomas husbandman 607349 607349 Thompson, Thomas, of Gargrave, husbandman 0
4146450 2076908 2076908 defendant Merkendall Robert husbandman 607349 607349 Merkendall, Robert, of Gargrave, husbandman 1
4188230 2091385 2091385 defendant Elstoke Richard   607349 607349 Elstoke, Richard, of Gargrave, Yoeks chapman 0
4254522 2114502 2114502 defendant Judson Thomas husbandman 607349 607349 Judson, Thomas, of Gargrave, husbandman 0
4262456 2117109 2117109 defendant Litster Lawrence gent 607349 607349 Litster, Lawrence, of Gargrave, gent 3
4262461 2117110 2117110 defendant Litster Lawrence gent 607349 607349 Litster, Lawrence, of Gargrave, gent 3
4383494 2159188 2159188 defendant Hall Christopher yeoman 607349 607349 Hall, Christopher, of Gargrave, yeoman 0
4383495 2159188 2159188 defendant Hall Richard yeoman 607349 607349 Hall, Richard, of Gargrave, yeoman 1
4383496 2159188 2159188 defendant Atkinson Edward yeoman 607349 607349 Atkinson, Edward, of Gargrave, yeoman 2
4392880 2162231 2162231 defendant Lowde John yeoman 607349 607349 Lowde, John, of Gargrave, yeoman 2
4405656 2166461 2166461 defendant Walbe William husbandman 607349 607349 Walbe, William, of Gargrave, husbandman 0
4405657 2166461 2166461 defendant Walbe Robert husbandman 607349 607349 Walbe, Robert, of Gargrave, husbandman 1
4412015 2168610 2168610 defendant Swyer Robert yeoman 607349 607349 Swyer, Robert, of Gargrave, yeoman 1
4532633 2210473 2210473 plaintiff Pye John   607349 607349 Pye, John, of Gargrave 0
4556320 2217917 2217917 defendant Lytster William   607349 607349 Lytster, William, of Gargrave 1
4650599 2246195 2246195 defendant Litster William   607349 607349 Litster, William, of Gargrave 3
4677592 2258605 2258605 defendant Walschawe Adam gent 607349 607349 Walschawe, Adam, of Gargrave, gent 2
4677605 2258610 2258610 defendant Wynterburn Richard de husbandman 607349 607349 Wynterburn, Richard de, of Gargrave, husbandman 0
4677606 2258610 2258610 defendant Preston William de husbandman 607349 607349 Preston, William de, of Gargrave, husbandman 1
4972089 2348590 2348590 defendant Watson William yeoman 607349 607349 Watson, William, of Gargrave, yeoman 0
4972090 2348590 2348590 defendant Hardy Richard yeoman 607349 607349 Hardy, Richard, of Gargrave, yeoman 1
5164443 2405334 2405334 defendant Acastre John chaplain 607349 607349 Acastre, John, of Gargrave, chaplain 3
5177665 2409163 2409163 defendant Acastre John chaplain 607349 607349 Acastre, John, of Gargrave, chaplain 3
5182268 2410568 2410568 defendant Thomson John husbandman 607349 607349 Thomson, John, of Gargrave, husbandman 0
5200972 2416046 2416046 defendant Acastre John chaplain 607349 607349 Acastre, John, of Gargrave, chaplain 3
5367284 2465421 2465421 defendant Acastre Thomas yeoman 607349 607349 Acastre, Thomas, of Gargrave, yeoman 6
5367292 2465422 2465422 defendant Acastre Thomas yeoman 607349 607349 Acastre, Thomas, of Gargrave, yeoman 6
5588962 2531557 2531557 defendant Walsall John husbandman 607349 607349 Walsall, John, of Gargrave, husbandman 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);