names

47 rows where place_id = 585946

✎ 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
3587550 1863755 1863755 defendant Pompe Thomas waterman 585946 585946 Pompe, Thomas, of Lygh, waterman 0
3599575 1867504 1867504 defendant Gefferey Thomas waterman 585946 585946 Gefferey, Thomas, of Lygh, waterman 0
3605110 1869263 1869263 defendant Yong Simon carpenter 585946 585946 Yong, Simon, of Lygh, carpenter 0
3650442 1910507 1910507 defendant Smyth Thomas husbandman 585946 585946 Smyth, Thomas, of Lygh, husbandman 0
3650443 1910507 1910507 defendant Cotyll John husbandman 585946 585946 Cotyll, John, of Lygh, husbandman 1
3650444 1910507 1910507 defendant Toller John husbandman 585946 585946 Toller, John, of Lygh, husbandman 2
3671591 1917100 1917100 defendant Knevet Charles esq 585946 585946 Knevet, Charles, of Lygh, esq 0
3687862 1922367 1922367 defendant Colles William yeoman 585946 585946 Colles, William, of Lygh, yeoman 0
3687864 1922367 1922367 defendant Denne John husbandman 585946 585946 Denne, John, of Lygh, husbandman 2
3687865 1922367 1922367 defendant Smyth John husbandman 585946 585946 Smyth, John, of Lygh, husbandman 3
3692989 1924009 1924009 plaintiff Lewkenore Humphrey esq 585946 585946 Lewkenore, Humphrey, of Lygh, esq 0
3734264 1936956 1936956 defendant Breton John clerk 585946 585946 Breton, John, of Lygh, clerk 1
3748045 1941309 1941309 defendant Breten John clerk 585946 585946 Breten, John, of Lygh, clerk 1
3756027 1943841 1943841 plaintiff Acton Thomas (legal representative) 585946 585946 Acton, Thomas, of Lygh, gent, executrix of 0
3759742 1945039 1945039 defendant Alford Robert butcher 585946 585946 Alford, Robert, of Lygh, butcher 1
3773658 1949479 1949479 defendant Nycholas William husbandman 585946 585946 Nycholas, William, of Lygh, husbandman 1
3773659 1949479 1949479 defendant Johnson William husbandman 585946 585946 Johnson, William, of Lygh, husbandman 2
3907614 1992838 1992838 defendant Wolford John clothier 585946 585946 Wolford, John, of Lygh under Mendepe, clothier 0
4059890 2045933 2045933 defendant Freman Richard yeoman 585946 585946 Freman, Richard, of Lygh, yeoman 1
4108793 2063398 2063398 defendant Chetborne John yeoman 585946 585946 Chetborne, John, of Lygh, yeoman 0
4199832 2095493 2095493 plaintiff Welles Robert yeoman 585946 585946 Welles, Robert, of Lygh, yeoman 1
4310365 2133779 2133779 defendant Lansdale George weaver 585946 585946 Lansdale, George, of Lygh, weaver 0
4741231 2277935 2277935 defendant Hobbe William husbandman 585946 585946 Hobbe, William, of Lygh, husbandman 0
4820198 2302389 2302389 defendant Morden Margaret widow & formerly wife of Thomas Morden 585946 585946 Morden, Margaret, of Lygh, widow & formerly wife of Thomas Morden 0
4908222 2329122 2329122 defendant Styler Richard husbandman 585946 585946 Styler, Richard, of Lygh, husbandman 2
4922995 2333610 2333610 defendant Iryssh William   585946 585946 Iryssh, William, of Lygh, servant 4
4959313 2344752 2344752 defendant atte Feld alias Myllward William husbandman 585946 585946 atte Feld alias Myllward, William, of Lygh, husbandman 0
5034359 2366908 2366908 plaintiff Stephens John   585946 585946 Stephens, John, of Lygh 0
5056607 2373548 2373548 defendant Trelaye Nicholas husbandman 585946 585946 Trelaye, Nicholas, of Lygh, husbandman 0
5085572 2382175 2382175 defendant Hampton John shipman 585946 585946 Hampton, John, of Lygh, shipman 0
5121615 2392748 2392748 defendant Rose Robert husbandman 585946 585946 Rose, Robert, of Lygh, husbandman 2
5121616 2392748 2392748 defendant Rose Richard husbandman 585946 585946 Rose, Richard, of Lygh, husbandman 3
5243399 2428264 2428264 defendant Hubert Thomas husbandman 585946 585946 Hubert, Thomas, of Lygh, husbandman 2
5243400 2428264 2428264 defendant Cromale John husbandman 585946 585946 Cromale, John, of Lygh, husbandman 3
5243401 2428264 2428264 defendant Hunt Thomas husbandman 585946 585946 Hunt, Thomas, of Lygh, husbandman 4
5262181 2433920 2433920 defendant Swayne Thomas   585946 585946 Swayne, Thomas, of Lygh, mason 3
5334273 2455320 2455320 defendant Gybbe William husbandman 585946 585946 Gybbe, William, of Lygh, husbandman 0
5352939 2461008 2461008 defendant Trotteswell Thomas yeoman 585946 585946 Trotteswell, Thomas, of Lygh, yeoman 0
5363760 2464318 2464318 defendant Salman William husbandman 585946 585946 Salman, William, of Lygh, husbandman 0
5390970 2472483 2472483 defendant Leyston Roger clerk 585946 585946 Leyston, Roger, of Lygh, clerk 0
5403930 2476197 2476197 defendant Leyson Ryan   585946 585946 Leyson, Ryan, of Lygh 0
5469631 2495837 2495837 defendant Baker Stephen yeoman 585946 585946 Baker, Stephen, of Lygh under Mendip, yeoman 0
5469633 2495838 2495838 defendant Baker Stephen yeoman 585946 585946 Baker, Stephen, of Lygh under Mendip, yeoman 0
5498163 2504401 2504401 defendant Baker Richard, senior husbandman 585946 585946 Baker, Richard, senior, of Lygh, husbandman 0
5520685 2511293 2511293 defendant Knyght John husbandman 585946 585946 Knyght, John, of Lygh, husbandman 3
5563365 2523882 2523882 defendant Hille Robert husbandman 585946 585946 Hille, Robert, of Lygh, husbandman 0
5602454 2535661 2535661 plaintiff Meryfeld Nicholas clothmaker 585946 585946 Meryfeld, Nicholas, of Lygh under Mendepe, clothmaker 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);