names

97 rows where place_id = 589469

✎ 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
3597724 1866908 1866908 defendant Stansfeld Robert laborer 589469 589469 Stansfeld, Robert, of Stansfeld, laborer 6
3600017 1867659 1867659 defendant Stansfeld Geoffrey gent 589469 589469 Stansfeld, Geoffrey, of Stansfeld, gent 0
3601010 1867982 1867982 defendant Stansfeld Geoffrey gent 589469 589469 Stansfeld, Geoffrey, of Stansfeld, gent 0
3680732 1920054 1920054 defendant Thomas William clothier 589469 589469 Thomas, William, of Stansfeld, clothier 0
3681992 1920473 1920473 defendant Shakylton John sherman 589469 589469 Shakylton, John, of Stansfeld, sherman 0
3681993 1920473 1920473 defendant Mascroft Katherine spinster 589469 589469 Mascroft, Katherine, of Stansfeld, spinster 1
3681994 1920473 1920473 defendant Brigge Elizabeth spinster 589469 589469 Brigge, Elizabeth, of Stansfeld, spinster 2
3691903 1923629 1923629 defendant Stansfeld Lawrence gent 589469 589469 Stansfeld, Lawrence, of Stansfeld, gent 0
3691904 1923629 1923629 defendant Stansfeld Blanche widow of Stansfeld Thomas 589469 589469 Stansfeld, Blanche, of Stansfeld, widow of Stansfeld Thomas 1
3710755 1929684 1929684 defendant Higham John gent 589469 589469 Higham, John, of Stansfeld, gent 2
3710761 1929685 1929685 defendant Higham John gent 589469 589469 Higham, John, of Stansfeld, gent 2
3710765 1929686 1929686 defendant Higham John gent 589469 589469 Higham, John, of Stansfeld, gent 0
3719182 1932284 1932284 defendant Stansfeld James esq 589469 589469 Stansfeld, James, of Stansfeld, esq 0
3740101 1938763 1938763 defendant Bredgys John tailor 589469 589469 Bredgys, John, of Stansfeld, tailor 0
3774915 1949885 1949885 defendant Cadge Anne widow 589469 589469 Cadge, Anne, of Stansfeld, widow 1
3837320 1969582 1969582 defendant Andrewe William husbandman 589469 589469 Andrewe, William, of Stansfeld, husbandman 0
4060944 2046323 2046323 defendant Horsfall Richard laborer or clothier 589469 589469 Horsfall, Richard, of Stansfeld, laborer or clothier 1
4060945 2046323 2046323 defendant Pyckehaver John laborer or clothier 589469 589469 Pyckehaver, John, of Stansfeld, laborer or clothier 2
4071985 2050277 2050277 defendant Stansfeld James gent 589469 589469 Stansfeld, James, of Stansfeld, gent 3
4075795 2051644 2051644 defendant Stansfeld Lawrence yeoman 589469 589469 Stansfeld, Lawrence, of Stansfeld, yeoman 0
4075796 2051644 2051644 defendant Suttclyff John weaver 589469 589469 Suttclyff, John, of Stansfeld, weaver 1
4075798 2051644 2051644 defendant Peckes alias Crosley Robert laborer 589469 589469 Peckes alias Crosley, Robert, of Stansfeld, laborer 3
4075799 2051644 2051644 defendant Hargreves William laborer 589469 589469 Hargreves, William, of Stansfeld, laborer 4
4075800 2051644 2051644 defendant Lawton George laborer 589469 589469 Lawton, George, of Stansfeld, laborer 5
4112747 2064821 2064821 defendant Crabtrye Thomas clothier 589469 589469 Crabtrye, Thomas, of Stansfeld, clothier 1
4119122 2067129 2067129 defendant Borley Paul husbandman 589469 589469 Borley, Paul, of Stansfeld, husbandman 0
4127668 2070187 2070187 defendant Borley Paul husbandman 589469 589469 Borley, Paul, of Stansfeld, husbandman 0
4504837 2202055 2202055 defendant Turnour Thomas   589469 589469 Turnour, Thomas, of Stansfeld 0
4539384 2212577 2212577 defendant Taillour Thomas   589469 589469 Taillour, Thomas, of Stansfeld 0
4539385 2212577 2212577 defendant Rogull Robert   589469 589469 Rogull, Robert, of Stansfeld 1
4561789 2219621 2219621 defendant Mellere Rciahrd   589469 589469 Mellere, Rciahrd, of Stansfeld 0
4561790 2219621 2219621 defendant atte Melle Stephen   589469 589469 atte Melle, Stephen, of Stansfeld 1
4561792 2219622 2219622 defendant Mellere Richard   589469 589469 Mellere, Richard, of Stansfeld 0
4561793 2219622 2219622 defendant atte Melle or Mewe Stephen   589469 589469 atte Melle or Mewe, Stephen, of Stansfeld 1
4584460 2226555 2226555 defendant Alwarton Robert   589469 589469 Alwarton, Robert, of Stansfeld 0
4663124 2249932 2249932 defendant Bradley John clerk 589469 589469 Bradley, John, of Stansfeld, clerk 0
4667864 2255649 2255649 defendant Stansfeld John gent 589469 589469 Stansfeld, John, of Stansfeld, son of Ralph, gent 9
4673260 2257278 2257278 defendant Clerke Thomas husbandman & son of Hugh 589469 589469 Clerke, Thomas, of of Stansfeld, husbandman & son of Hugh 0
4705234 2267007 2267007 defendant Estwode William husbandman 589469 589469 Estwode, William, of Stansfeld, husbandman 1
4705235 2267007 2267007 defendant Brumlay John   589469 589469 Brumlay, John, of Stansfeld, servant 2
4758977 2283159 2283159 defendant Alwerton Robert yeoman 589469 589469 Alwerton, Robert, of Stansfeld, yeoman 0
4760384 2283602 2283602 plaintiff Gilmyn John   589469 589469 Gilmyn, John, of Stansfeld 3
4781078 2290091 2290091 defendant Alwerton Robert yeoman 589469 589469 Alwerton, Robert, of Stansfeld, yeoman 0
4812401 2299992 2299992 plaintiff Hach John husbandman 589469 589469 Hach, John, of Stansfeld, husbandman 0
4906424 2328596 2328596 defendant Stansfeld John clerk 589469 589469 Stansfeld, John, of Stansfeld, clerk 0
4928493 2335337 2335337 plaintiff Smyth John   589469 589469 Smyth, John, of Stansfeld 0
4928494 2335337 2335337 defendant Smyth John   589469 589469 Smyth, John, of Stansfeld 0
4936010 2337664 2337664 plaintiff Bochere Thomas husbandman 589469 589469 Bochere, Thomas, of Stansfeld, husbandman 0
4957597 2344246 2344246 defendant Goodale Walter laborer 589469 589469 Goodale, Walter, of Stansfeld, laborer 1
5019796 2362671 2362671 defendant Cole James laborer 589469 589469 Cole, James, of Stansfeld, laborer 0
5019799 2362672 2362672 plaintiff Hukton Robert   589469 589469 Hukton, Robert, of Stansfeld 2
5031192 2366002 2366002 defendant de Hole Thomas   589469 589469 de Hole, Thomas, of Stansfeld, wright 2
5031199 2366003 2366003 defendant Staunsfeld Ralph gent 589469 589469 together with Staunsfeld, Ralph, of Stansfeld, gent 3
5031200 2366003 2366003 defendant Staunsfeld Nicholas gent 589469 589469 Staunsfeld, Nicholas, of Stansfeld, gent 4
5031203 2366003 2366003 defendant Brig Henry husbandman 589469 589469 Brig, Henry, of Stansfeld, husbandman 7
5031204 2366003 2366003 defendant Brig Robert husbandman 589469 589469 Brig, Robert, of Stansfeld, husbandman 8
5031205 2366003 2366003 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 9
5031207 2366003 2366003 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 11
5031208 2366003 2366003 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 12
5031226 2366004 2366004 defendant Stansfeld Ralph gent 589469 589469 Stansfeld, Ralph, of Stansfeld, gent 0
5031228 2366004 2366004 defendant Stansfeld Nicholas gent 589469 589469 Stansfeld, Nicholas, of Stansfeld, gent 2
5031232 2366004 2366004 defendant Bryg Henry husbandman 589469 589469 Bryg, Henry, of Stansfeld, husbandman 6
5031233 2366004 2366004 defendant Bryg Robert husbandman 589469 589469 Bryg, Robert, of Stansfeld, husbandman 7
5031234 2366004 2366004 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 8
5031236 2366004 2366004 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 10
5031237 2366004 2366004 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 11
5031256 2366005 2366005 defendant Stansfeld Ralph gent 589469 589469 Stansfeld, Ralph, of Stansfeld, gent 0
5031258 2366005 2366005 defendant Stansfeld Nicholas gent 589469 589469 Stansfeld, Nicholas, of Stansfeld, gent 2
5031262 2366005 2366005 defendant Bryg Henry husbandman 589469 589469 Bryg, Henry, of Stansfeld, husbandman 6
5031263 2366005 2366005 defendant Bryg Robert husbandman 589469 589469 Bryg, Robert, of Stansfeld, husbandman 7
5031264 2366005 2366005 defendant Grenewode John miller 589469 589469 Grenewode, John, of Stansfeld, miller 8
5031266 2366005 2366005 defendant John son of Crosle Robert husbandman 589469 589469 John son of Crosle, Robert, of Stansfeld, husbandman 10
5031267 2366005 2366005 defendant Hole Thomas   589469 589469 Hole, Thomas, of Stansfeld, wright 11
5033439 2366662 2366662 defendant Cole Roger laborer 589469 589469 Cole, Roger, of Stansfeld, laborer 0
5033440 2366662 2366662 defendant Cole James laborer 589469 589469 Cole, James, of Stansfeld, laborer 1
5034150 2366854 2366854 defendant Turnour William yeoman 589469 589469 Turnour, William, of Stansfeld, yeoman 1
5034151 2366854 2366854 defendant Hopkynson John yeoman 589469 589469 Hopkynson, John, of Stansfeld, yeoman 2
5105299 2387994 2387994 defendant Norman John husbandman 589469 589469 Norman, John, of Stansfeld, husbandman 1
5225971 2423263 2423263 plaintiff Gylmyn John, junior   589469 589469 Gylmyn, John, junior, of Stansfeld 2
5226121 2423303 2423303 defendant Stansfeld Peter gent 589469 589469 Stansfeld, Peter, of Stansfeld, gent 0
5226123 2423304 2423304 defendant Stansfeld John gent 589469 589469 Stansfeld, John, of Stansfeld, gent 0
5226125 2423305 2423305 defendant Crossele Peer husbandman 589469 589469 Crossele, Peer, of Stansfeld, husbandman 0
5240277 2427365 2427365 defendant Bendisshe John   589469 589469 Bendisshe, John, of Stansfeld, ploughwright 0
5274674 2437670 2437670 defendant Cole James yeoman 589469 589469 Cole, James, of Stansfeld, yeoman 2
5292194 2442714 2442714 defendant Cole James yeoman 589469 589469 Cole, James, of Stansfeld, yeoman 1
5292197 2442714 2442714 defendant Frost Thomas laborer 589469 589469 Frost, Thomas, of Stansfeld, laborer 4
5331663 2454556 2454556 defendant Kedyton Thomas husbandman 589469 589469 Kedyton, Thomas, of Stansfeld, husbandman 0
5331664 2454556 2454556 defendant Kedyton John cooper 589469 589469 Kedyton, John, of Stansfeld, cooper 1
5331666 2454557 2454557 defendant Kedyton Thomas, senior husbandman 589469 589469 Kedyton, Thomas, senior, of Stansfeld, husbandman 0
5331667 2454557 2454557 defendant Kedyton John cooper 589469 589469 Kedyton, John, of Stansfeld, cooper 1
5350757 2460347 2460347 defendant Coggeshall Robert gent 589469 589469 Coggeshall, Robert, of Stansfeld, gent 0
5430372 2484019 2484019 defendant Hoo John husbandman 589469 589469 Hoo, John, of Stansfeld, husbandman 0
5430373 2484019 2484019 defendant Neve John husbandman 589469 589469 Neve, John, of Stansfeld, husbandman 1
5449516 2489746 2489746 defendant Stansfeld James gent 589469 589469 Stansfeld, James, of Stansfeld, gent 0
5553102 2520944 2520944 defendant Fuller John, junior husbandman 589469 589469 Fuller, John, junior, of Stansfeld, husbandman 0
5553104 2520945 2520945 defendant Fuller John, junior husbandman 589469 589469 Fuller, John, junior, of Stansfeld, husbandman 0
5583892 2530041 2530041 defendant Andrewe William husbandman 589469 589469 Andrewe, William, of Stansfeld, husbandman 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);