names

47 rows where place_id = 591492

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604560 1869090 1869090 defendant Bewle John, junior gent 591492 591492 Bewle, John, junior, of Woldham, gent 0
3613702 1871934 1871934 plaintiff Forest John   591492 591492 Forest, John, of Woldham 1
3623597 1874912 1874912 defendant Michell Thomas husbandman 591492 591492 Michell, Thomas, of Woldham, husbandman 0
3623599 1874913 1874913 defendant Michell Thomas husbandman 591492 591492 Michell, Thomas, of Woldham, husbandman 0
3818975 1963829 1963829 defendant Potkyn John, senior husbandman 591492 591492 Potkyn, John, senior, of Woldham, husbandman 0
3818976 1963829 1963829 defendant Goldok Thomas husbandman 591492 591492 Goldok, Thomas, of Woldham, husbandman 1
3818977 1963829 1963829 defendant Potkyn John, junior husbandman 591492 591492 Potkyn, John, junior, of Woldham, husbandman 2
3819024 1963841 1963841 defendant Potkyn John, senior husbandman 591492 591492 Potkyn, John, senior, of Woldham, husbandman 0
3819026 1963841 1963841 defendant Potkyn John, junior husbandman 591492 591492 Potkyn, John, junior, of Woldham, husbandman 2
4063639 2047286 2047286 plaintiff Goldocke Robert yeoman 591492 591492 Goldocke, Robert, of Woldham, yeoman 0
4496030 2199435 2199435 defendant Savage William   591492 591492 Savage, William, of Woldham 0
4515170 2205161 2205161 plaintiff Chaumberleyn Thomas   591492 591492 Chaumberleyn, Thomas, of Woldham 0
4650982 2246308 2246308 defendant atte Grove Geoffrey husbandman 591492 591492 atte Grove, Geoffrey, of Woldham, husbandman 0
4653654 2247070 2247070 defendant atte Grove Feoffrey husbandman 591492 591492 atte Grove, Feoffrey, of Woldham, husbandman 0
4711239 2268866 2268866 defendant Botiller Thomas laborer 591492 591492 Botiller, Thomas, of Woldham, laborer 1
4917609 2332021 2332021 plaintiff Gerold John   591492 591492 Gerold, John, of Woldham 0
4917611 2332022 2332022 plaintiff Gerold John   591492 591492 Gerold, John, of Woldham 0
4917612 2332022 2332022 defendant Gerold John   591492 591492 Gerold, John, of Woldham 0
4917613 2332023 2332023 plaintiff Gerold John   591492 591492 Gerold, John, of Woldham 0
4921370 2333192 2333192 plaintiff Towe Thomas   591492 591492 Towe, Thomas, of Woldham, parson 4
5014411 2361078 2361078 defendant Karlton Thomas chaplain 591492 591492 Karlton, Thomas, of Woldham, chaplain 0
5014415 2361080 2361080 defendant Karlton Thomas chaplain 591492 591492 Karlton, Thomas, of Woldham, chaplain 0
5014416 2361080 2361080 defendant Newebald Roger yeoman 591492 591492 Newebald, Roger, of Woldham, yeoman 1
5014418 2361081 2361081 defendant Karlton Thomas chaplain 591492 591492 Karlton, Thomas, of Woldham, chaplain 0
5014419 2361081 2361081 defendant Newebald Roger yeoman 591492 591492 Newebald, Roger, of Woldham, yeoman 1
5052557 2372356 2372356 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5057173 2373725 2373725 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5058397 2374058 2374058 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5066805 2376598 2376598 defendant Slegge Stephen gent 591492 591492 together with Slegge, Stephen, of Woldham, gent 1
5075642 2379214 2379214 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5080389 2380625 2380625 defendant Slegge Stephen gent 591492 591492 together with Slegge, Stephen, of Woldham, gent 10
5080392 2380626 2380626 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5162100 2404648 2404648 defendant Forest Henry   591492 591492 Forest, Henry, of Woldham, gent, son & heir of John Forest 0
5176168 2408719 2408719 defendant Forest Henry   591492 591492 Forest, Henry, of Woldham, gent, son & heir of John Forest 0
5195532 2414443 2414443 defendant Foreste Henry gent 591492 591492 Foreste, Henry, of Woldham, gent 0
5198315 2415256 2415256 defendant Forest Henry   591492 591492 Forest, Henry, of Woldham, gent, son & heir of John Forest of Woldham 0
5210486 2418800 2418800 defendant Forest Henry   591492 591492 Forest, Henry, of Woldham, gent, son & heir of John 0
5227431 2423651 2423651 defendant Forest Henry   591492 591492 Forest, Henry, of Woldham, gent, son of Forest, John, of Woldham 0
5347263 2459311 2459311 defendant Nycolson William husbandman 591492 591492 Nycolson, William, of Woldham, husbandman 2
5487376 2501118 2501118 defendant Ware Robert yeoman 591492 591492 Ware, Robert, of Woldham, yeoman 0
5520096 2511111 2511111 defendant A Dene Thomas husbandman 591492 591492 A Dene, Thomas, of Woldham, husbandman 6
5520102 2511112 2511112 defendant A Thorp Henry husbandman 591492 591492 A Thorp, Henry, of Woldham, husbandman 2
5520106 2511112 2511112 defendant A Dene Thomas husbandman 591492 591492 A Dene, Thomas, of Woldham, husbandman 6
5520436 2511212 2511212 defendant Page William gent 591492 591492 Page, William, of Woldham, gent 0
5527250 2513100 2513100 defendant Michell Thomas husbandman 591492 591492 Michell, Thomas, of Woldham, husbandman 4
5530597 2514085 2514085 defendant A Dene Thomas yeoman 591492 591492 A Dene, Thomas, of Woldham, yeoman 0
5538610 2516558 2516558 defendant Bewele John gent 591492 591492 Bewele, John, of Woldham, 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);