names

99 rows where place_id = 591013

✎ 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
3603010 1868609 1868609 defendant Bukton Robert gent 591013 591013 Bukton, Robert, of Staynton, gent 0
3603011 1868609 1868609 defendant Bukton John gent 591013 591013 Bukton, John, of Staynton, gent 1
3603014 1868610 1868610 defendant Bukton Robert gent 591013 591013 Bukton, Robert, of Staynton, gent 0
3603015 1868610 1868610 defendant Bukton John gent 591013 591013 Bukton, John, of Staynton, gent 1
3603018 1868611 1868611 defendant Bukton Robert gent 591013 591013 Bukton, Robert, of Staynton, gent 0
3603019 1868611 1868611 defendant Bukton John gent 591013 591013 Bukton, John, of Staynton, gent 1
3671546 1917083 1917083 defendant Justice Thomas husbandman 591013 591013 Justice, Thomas, of Staynton, husbandman 0
3791325 1955120 1955120 defendant Barrey Richard yeoman 591013 591013 Barrey, Richard, of Staynton, yeoman 3
3928630 1999914 1999914 defendant Ryder Stephen yeoman 591013 591013 Ryder, Stephen, of Staynton, yeoman 0
3928631 1999914 1999914 defendant Ryder Henry   591013 591013 Ryder, Henry, of Staynton, husbandman, son of Stephen 1
3935995 2002356 2002356 defendant Dawson John husbandman 591013 591013 Dawson, John, of Staynton, husbandman 0
3935996 2002356 2002356 defendant Eskott John husbandman 591013 591013 Eskott, John, of Staynton, husbandman 1
3935997 2002356 2002356 defendant Mattyson Alexander husbandman 591013 591013 Mattyson, Alexander, of Staynton, husbandman 2
3935998 2002356 2002356 defendant Knotte Robert husbandman 591013 591013 Knotte, Robert, of Staynton, husbandman 3
3935999 2002356 2002356 defendant Mattyson Christopher husbandman 591013 591013 Mattyson, Christopher, of Staynton, husbandman 4
3936000 2002356 2002356 defendant Tomson William husbandman 591013 591013 Tomson, William, of Staynton, husbandman 5
3936001 2002356 2002356 defendant Hodgeson John husbandman 591013 591013 Hodgeson, John, of Staynton, husbandman 6
3945564 2005524 2005524 defendant Robynson John, senior husbandman 591013 591013 Robynson, John, senior, of Staynton, husbandman 1
3945565 2005524 2005524 defendant Robynson John, junior husbandman 591013 591013 Robynson, John, junior, of Staynton, husbandman 2
3999687 2024652 2024652 defendant Grene Thomas gent 591013 591013 Grene, Thomas, of Staynton, gent 0
4078431 2052582 2052582 defendant Poyser John husbandman 591013 591013 Poyser, John, of Staynton, husbandman 0
4082072 2053885 2053885 plaintiff Woodroff Robert yeoman 591013 591013 Woodroff, Robert, of Staynton, yeoman 0
4119432 2067242 2067242 defendant Croft Thomas (legal representative) 591013 591013 Croft, Thomas, of Staynton, yeoman, executors of 0
4119433 2067242 2067242 defendant Burton William yeoman 591013 591013 (Burton, William, of Staynton, yeoman 1
4135430 2072990 2072990 defendant Boswell William gent 591013 591013 Boswell, William, of Staynton, gent 1
4139244 2074404 2074404 defendant Bosvile William yeoman 591013 591013 Bosvile, William, of Staynton, yeoman 0
4139245 2074404 2074404 defendant Cutluse Brian yeoman 591013 591013 Cutluse, Brian, of Staynton, yeoman 1
4162336 2082386 2082386 defendant Croft Thomas (legal representative) 591013 591013 Croft, Thomas, of Staynton, yeoman, executors of 3
4204020 2096958 2096958 defendant Haryson George yeoman 591013 591013 Haryson, George, of Staynton, yeoman 0
4313421 2134804 2134804 defendant Hawkesworth Nicholas yeoman 591013 591013 Hawkesworth, Nicholas, of Staynton, yeoman 2
4315801 2135636 2135636 defendant Nelson Ellen widow 591013 591013 Nelson, Ellen, of Staynton, widow 1
4315806 2135637 2135637 defendant Nelson Ellen widow 591013 591013 Nelson, Ellen, of Staynton, widow 1
4316938 2136041 2136041 defendant Higgen Mabel widow 591013 591013 Higgen, Mabel, of Staynton, widow 0
4316939 2136041 2136041 defendant Shawe Agnes widow 591013 591013 Shawe, Agnes, of Staynton, widow 1
4361773 2151369 2151369 defendant Nelson Thomas husbandman 591013 591013 Nelson, Thomas, of Staynton, husbandman 1
4374512 2155946 2155946 defendant Metcalf Peter husbandman 591013 591013 Metcalf, Peter, of Staynton, husbandman 2
4374513 2155946 2155946 defendant Robynson Jane widow 591013 591013 Robynson, Jane, of Staynton, widow 3
4439677 2181678 2181678 defendant Madure John   591013 591013 Madure, John, of Staynton 0
4443146 2182818 2182818 defendant Boget John   591013 591013 Boget, John, of Staynton 0
4446346 2183775 2183775 defendant Arnoldson Richard   591013 591013 Arnoldson, Richard, of Staynton 0
4446347 2183775 2183775 defendant Arnaldson John   591013 591013 Arnaldson, John, of Staynton 1
4453219 2186015 2186015 defendant Colunson John   591013 591013 Colunson, John, of Staynton 1
4459716 2188093 2188093 defendant Arnaldson John   591013 591013 Arnaldson, John, of Staynton 1
4459746 2188101 2188101 defendant Arnaldson John   591013 591013 Arnaldson, John, of Staynton 1
4464123 2189449 2189449 defendant Vikerson Robert   591013 591013 Vikerson, Robert, of Staynton 0
4498802 2200259 2200259 defendant (illegible) Walter   591013 591013 ---, Walter, of Staynton 1
4505712 2202296 2202296 defendant Hyne or Hyve Thomas   591013 591013 Hyne or Hyve, Thomas, of Staynton 0
4524904 2208132 2208132 defendant Mortheynglay William   591013 591013 Mortheynglay, William, of Staynton, vicar 1
4561244 2219478 2219478 defendant Lowry Nicholas   591013 591013 Lowry, Nicholas, of Staynton 0
4561245 2219478 2219478 defendant Mare Thomas   591013 591013 Mare, Thomas, of Staynton 1
4561246 2219478 2219478 defendant Jakson Adam   591013 591013 Jakson, Adam, of Staynton 2
4561247 2219478 2219478 defendant Cape John   591013 591013 Cape, John, of Staynton 3
4561248 2219478 2219478 defendant Maye William   591013 591013 Maye, William, of Staynton 4
4561249 2219478 2219478 defendant Cowyse Robert   591013 591013 Cowyse, Robert, of Staynton 5
4562651 2219878 2219878 defendant Taillour Roger   591013 591013 Taillour, Roger, of Staynton 0
4599157 2230948 2230948 defendant Adamson John   591013 591013 Adamson, John, of Staynton 8
4610396 2234329 2234329 defendant Jonson Robert   591013 591013 Jonson, Robert, of Staynton 1
4650001 2246017 2246017 defendant Gluwe John   591013 591013 Gluwe, John, of Staynton 1
4725545 2273279 2273279 defendant Kynge John husbandman 591013 591013 Kynge, John, of Staynton, husbandman 4
4725546 2273279 2273279 defendant Blewe John   591013 591013 Blewe, John, of Staynton, plough wright 5
4725547 2273279 2273279 defendant Dande or Daude John husbandman 591013 591013 Dande or Daude, John, of Staynton, husbandman 6
4725548 2273279 2273279 defendant Forster Richard husbandman 591013 591013 Forster, Richard, of Staynton, husbandman 7
4725549 2273279 2273279 defendant Bried Robert   591013 591013 Bried, Robert, of Staynton, shepherd 8
4738998 2277287 2277287 defendant Killyngholme John laborer 591013 591013 Killyngholme, John, of Staynton, laborer 1
4746325 2279421 2279421 defendant Mathewe John laborer 591013 591013 Mathewe, John, of Staynton, laborer 1
4760555 2283653 2283653 defendant Hakson John yeoman 591013 591013 Hakson John, of Staynton, yeoman 2
4760557 2283653 2283653 defendant Lowre Nicholas husbandman 591013 591013 Lowre, Nicholas, of Staynton, husbandman 4
4760558 2283653 2283653 defendant Boureste John yeoman 591013 591013 Boureste, John, of Staynton, yeoman 5
4760559 2283653 2283653 defendant Penreth Robert yeoman 591013 591013 Penreth, Robert, of Staynton, yeoman 6
4783709 2290929 2290929 defendant Grisedale Richard yeoman 591013 591013 Grisedale, Richard, of Staynton, yeoman 0
4818425 2301844 2301844 defendant Bekke Thomas yeoman 591013 591013 Bekke, Thomas, of Staynton, yeoman 0
4827075 2304512 2304512 defendant Tuthill Thomas gent 591013 591013 Tuthill, Thomas, of Staynton, gent 0
4862245 2315202 2315202 defendant de Lancastre Roger gent 591013 591013 de Lancastre, Roger, of Staynton, gent 0
4864062 2315734 2315734 defendant Sharparowe Thomas yeoman 591013 591013 Sharparowe, Thomas, of Staynton, yeoman 2
4869420 2317404 2317404 defendant Milner John yeoman 591013 591013 Milner, John, of Staynton, yeoman 0
4869421 2317404 2317404 defendant Mylner Robert miller 591013 591013 Mylner, Robert, of Staynton, miller 1
4936524 2337809 2337809 defendant Eston Roger yeoman 591013 591013 Eston, Roger, of Staynton, yeoman 2
4978990 2350672 2350672 defendant Wilson Richard husbandman 591013 591013 Wilson, Richard, of Staynton, Cumber, husbandman 5
5014817 2361210 2361210 defendant Eseby William husbandman 591013 591013 Eseby, William, of Staynton, husbandman 2
5038851 2368262 2368262 defendant Beke Richard yeoman 591013 591013 Beke, Richard, of Staynton, yeoman 0
5039927 2368586 2368586 defendant Eseby William yeoman 591013 591013 Eseby, William, of Staynton, yeoman 2
5050588 2371802 2371802 defendant Smyth William husbandman 591013 591013 Smyth, William, of Staynton, husbandman 0
5067823 2376877 2376877 defendant Staynton Robert husbandman 591013 591013 Staynton, Robert, of Staynton, husbandman 2
5090631 2383643 2383643 defendant Harlesay John yeoman 591013 591013 Harlesay, John, of Staynton, yeoman 0
5113299 2390283 2390283 plaintiff Kyng Richard   591013 591013 Kyng, Richard, of Staynton 1
5246995 2429284 2429284 defendant Kyng Roger husbandman 591013 591013 Kyng, Roger, of Staynton, husbandman 3
5295010 2443530 2443530 defendant Bukton William esq 591013 591013 Bukton, William, of Staynton, esq 1
5309914 2448001 2448001 defendant Bukton William esq 591013 591013 Bukton, William, of Staynton, esq 0
5311150 2448364 2448364 defendant Hargate Robert clerk 591013 591013 Hargate, Robert, of Staynton, clerk 0
5311151 2448364 2448364 defendant Armthorp Thomas husbandman 591013 591013 Armthorp, Thomas, of Staynton, husbandman 1
5311152 2448364 2448364 defendant Merydewe Robert husbandman 591013 591013 Merydewe, Robert, of Staynton, husbandman 2
5311153 2448364 2448364 defendant Pycard William husbandman 591013 591013 Pycard, William, of Staynton, husbandman 3
5311154 2448364 2448364 defendant Sweket William husbandman 591013 591013 Sweket, William, of Staynton, husbandman 4
5311155 2448364 2448364 defendant Scoton Richard husbandman 591013 591013 Scoton, Richard, of Staynton, husbandman 5
5311156 2448364 2448364 defendant T_mende John husbandman 591013 591013 T_mende, John, of Staynton, husbandman 6
5401377 2475459 2475459 defendant Stillyngton Thomas laborer 591013 591013 Stillyngton, Thomas, of Staynton, laborer 1
5510614 2508157 2508157 defendant Hall John husbandman 591013 591013 Hall, John, of Staynton, husbandman 0
5612399 2547624 2547624 defendant Boget John   591013 591013 Boget, John, of Staynton 0
5628544 2552897 2552897 defendant Willesson William   591013 591013 Willesson, William, of Staynton 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);