names

82 rows where place_id = 588166

✎ 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
3593565 1865625 1865625 defendant Wrayth Robert husbandman 588166 588166 Wrayth, Robert, of Crofton, husbandman 0
3612756 1871640 1871640 defendant Wraith Robert husbandman 588166 588166 Wraith, Robert, of Crofton, husbandman 0
3619070 1873566 1873566 defendant Wayth Robert husbandman 588166 588166 Wayth, Robert, of Crofton, husbandman 0
3625711 1875579 1875579 defendant Wrayth Robert husbandman 588166 588166 Wrayth, Robert, of Crofton, husbandman 0
3682140 1920523 1920523 defendant Trygge Thomas yeoman 588166 588166 Trygge, Thomas, of Crofton, yeoman 1
3690253 1923111 1923111 defendant Flemyng Robert gent 588166 588166 Flemyng, Robert, of Crofton, gent 0
3692362 1923785 1923785 defendant Lagham John   588166 588166 Lagham, John, of Crofton, shepherd 0
3703300 1927305 1927305 defendant Dalton William gent 588166 588166 Dalton, William, of Crofton, gent 2
3714060 1930698 1930698 defendant Busshell Robert miller 588166 588166 Busshell, Robert, of Crofton, miller 0
3769935 1948254 1948254 defendant Person Richard miller 588166 588166 Person, Richard, of Crofton, miller 1
3797790 1957206 1957206 defendant Feld Christopher laborer 588166 588166 Feld, Christopher, of Crofton, laborer 4
3807407 1960222 1960222 defendant Bryskoo John esq 588166 588166 Bryskoo, John, of Crofton, Cumber, esq 2
3874876 1981819 1981819 defendant Bristow Robert esq 588166 588166 Bristow, Robert, of Crofton, esq 0
3908290 1993070 1993070 plaintiff Rawson Robert gent 588166 588166 Rawson, Robert, of Crofton, gent 0
3921979 1997695 1997695 defendant Birkhed Elizabeth widow 588166 588166 Birkhed, Elizabeth, of Crofton, widow 0
3921981 1997696 1997696 defendant Byrkhed Elizabeth widow 588166 588166 Byrkhed, Elizabeth, of Crofton, widow 0
4048452 2041895 2041895 plaintiff Tempest Thomas gent 588166 588166 Tempest, Thomas, of Crofton, gent 0
4048454 2041896 2041896 plaintiff Tempest Thomas gent 588166 588166 Tempest, Thomas, of Crofton, gent 0
4123487 2068703 2068703 defendant Woode Henry laborer 588166 588166 Woode, Henry, of Crofton, laborer 1
4143143 2075772 2075772 defendant Worsley Edward yeoman 588166 588166 Worsley, Edward, of Crofton, yeoman 3
4169920 2084975 2084975 defendant Rawson William gent 588166 588166 Rawson, William, of Crofton, gent 2
4310916 2133967 2133967 defendant Haighe William butcher 588166 588166 Haighe, William, of Crofton, butcher 0
4310917 2133967 2133967 defendant Shepperd John   588166 588166 Shepperd, John, of Crofton 1
4310918 2133967 2133967 defendant Lockwood John   588166 588166 Lockwood, John, of Crofton 2
4310919 2133967 2133967 defendant Sugden John   588166 588166 Sugden, John, of Crofton 3
4360966 2151095 2151095 defendant Briscoe Jane widow 588166 588166 Briscoe, Jane, of Crofton, widow 0
4397534 2163755 2163755 defendant Hodgson Miles gent 588166 588166 Hodgson, Miles, of Crofton, gent 0
4466010 2190028 2190028 plaintiff Wynterton William de   588166 588166 Wynterton, William de, of Crofton, parson 0
4502504 2201367 2201367 defendant Berewyk John   588166 588166 Berewyk, John, of Crofton 1
4536859 2211803 2211803 plaintiff Stor Henry (legal representative) 588166 588166 Stor, Henry, of Crofton, executors of 0
4576843 2224262 2224262 defendant atte Noke John   588166 588166 atte Noke, John, of Crofton 3
4603982 2232417 2232417 defendant Smyth John   588166 588166 Smyth, John, of Crofton 0
4663141 2249940 2249940 defendant Bette Thomas, junior husbandman 588166 588166 Bette, Thomas, junior, of Crofton, husbandman 0
4670281 2256410 2256410 defendant Bette Thomas husbandman 588166 588166 Bette, Thomas, of Crofton, husbandman 0
4702992 2266318 2266318 defendant Herod Robert husbandman 588166 588166 Herod, Robert, of Crofton, husbandman 1
4706132 2267294 2267294 defendant Atkyns Richard husbandman 588166 588166 Atkyns, Richard, of Crofton, husbandman 2
4731560 2275065 2275065 defendant Sudbery Richard   588166 588166 Sudbery, Richard, of Crofton, parson 3
4761790 2284030 2284030 defendant Odam William husbandman 588166 588166 Odam, William, of Crofton, husbandman 0
4785216 2291394 2291394 defendant Odam William husbandman 588166 588166 Odam, William, of Crofton, husbandman 0
4818037 2301719 2301719 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, esq 0
4824802 2303797 2303797 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, esq 1
4836762 2307465 2307465 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, esq 0
4844608 2309835 2309835 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, esq 0
4847442 2310703 2310703 defendant Hoord Simon husbandman 588166 588166 Hoord, Simon, of Crofton, husbandman 1
4858523 2314040 2314040 defendant Halifax John laborer 588166 588166 Halifax, John, of Crofton, laborer 0
4858524 2314040 2314040 defendant Halifax Thomas laborer 588166 588166 Halifax, Thomas, of Crofton, laborer 1
4858525 2314040 2314040 defendant Haward Richard laborer 588166 588166 Haward, Richard, of Crofton, laborer 2
4878785 2320302 2320302 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, esq 1
4896780 2325650 2325650 defendant Normanvile Edmund gent 588166 588166 Normanvile, Edmund, of Crofton, gent 0
4901480 2327067 2327067 defendant Normanvile Edmund gent 588166 588166 Normanvile, Edmund, of Crofton, gent 0
4941813 2339444 2339444 defendant Warcop Richard esq 588166 588166 Warcop, Richard, of Crofton, Cumber, esq 3
4957278 2344141 2344141 defendant Wynke William husbandman 588166 588166 Wynke, William, of Crofton, husbandman 0
4957280 2344141 2344141 defendant Flemmynge Thomas laborer 588166 588166 Flemmynge, Thomas, of Crofton, laborer 2
4972150 2348613 2348613 defendant Clerk alias Taillour John husbandman 588166 588166 Clerk alias Taillour, John, of Crofton, husbandman 2
4973604 2349058 2349058 defendant Huet John yeoman 588166 588166 Huet, John, of Crofton, yeoman 3
4992360 2354604 2354604 defendant Lyghthesell John yeoman 588166 588166 Lyghthesell, John, of Crofton, yeoman 3
4997276 2356038 2356038 defendant Herot John yeoman 588166 588166 Herot, John, of Crofton, yeoman 6
5000403 2356986 2356986 defendant Flemmyng Robert husbandman 588166 588166 together with Flemmyng, Robert, of Crofton, husbandman 1
5064496 2375922 2375922 plaintiff Laton Robert   588166 588166 Laton, Robert, of Crofton 0
5086944 2382566 2382566 defendant Assheton Hugh gent 588166 588166 Assheton, Hugh, of Crofton, gent 2
5223581 2422583 2422583 defendant Eland Thomas gent 588166 588166 Eland, Thomas, of Crofton, gent 0
5291248 2442444 2442444 defendant Assheton Hugh esq 588166 588166 Assheton, Hugh, of Crofton, esq 1
5306575 2446956 2446956 defendant Jankynson John chaplain 588166 588166 Jankynson, John, of Crofton, chaplain 3
5329889 2454010 2454010 defendant Wynk Robert yeoman 588166 588166 Wynk, Robert, of Crofton, yeoman 0
5329891 2454011 2454011 defendant Wynk Robert yeoman 588166 588166 Wynk, Robert, of Crofton, yeoman 0
5344910 2458568 2458568 defendant Wynk Richard husbandman 588166 588166 Wynk, Richard, of Crofton, husbandman 1
5344911 2458568 2458568 defendant Cartwryght Thomas husbabndman 588166 588166 Cartwryght, Thomas, of Crofton, husbabndman 2
5344915 2458569 2458569 defendant Wynk Richard husbandman 588166 588166 Wynk, Richard, of Crofton, husbandman 1
5344916 2458569 2458569 defendant Cartwryght Thomas husbandman 588166 588166 Cartwryght, Thomas, of Crofton, husbandman 2
5355986 2461955 2461955 defendant Kechill Ralph husbandman 588166 588166 Kechill, Ralph, of Crofton, husbandman 1
5364659 2464608 2464608 defendant Wilcok Edmund yeoman 588166 588166 Wilcok, Edmund, of Crofton, yeoman 0
5371478 2466662 2466662 defendant Maryetson Richard husbandman 588166 588166 Maryetson, Richard, of Crofton, husbandman 0
5378851 2468973 2468973 defendant Beste John yeoman 588166 588166 Beste, John, of Crofton, yeoman 1
5378852 2468973 2468973 defendant Frere Alexander husbandman 588166 588166 Frere, Alexander, of Crofton, husbandman 2
5378853 2468973 2468973 defendant Smyth Thomas husbandman 588166 588166 Smyth, Thomas, of Crofton, husbandman 3
5497125 2504078 2504078 defendant Emberton William husbandman 588166 588166 Emberton, William, of Crofton, husbandman 0
5519829 2511040 2511040 defendant Wroth Robert husbandman 588166 588166 Wroth, Robert, of Crofton, husbandman 1
5533243 2514946 2514946 defendant Crescy Richard chaplain 588166 588166 Crescy, Richard, of Crofton, chaplain 0
5540572 2517180 2517180 defendant Wrayth Robert husbandman 588166 588166 Wrayth, Robert, of Crofton, husbandman 1
5561981 2523486 2523486 defendant Jubbe Robert husbandman 588166 588166 Jubbe, Robert, of Crofton, husbandman 0
5588588 2531436 2531436 defendant Briscogh John gent 588166 588166 Briscogh, John, of Crofton, gent 0
5588590 2531437 2531437 defendant Briscogh John gent 588166 588166 Briscogh, John, of Crofton, gent 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);