names

62 rows where place_id = 589258

✎ 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
3597042 1866698 1866698 defendant Smyth Thomas carver 589258 589258 Smyth, Thomas, of Redgrave, carver 3
3633168 1905186 1905186 defendant Nunne Edmund miller 589258 589258 Nunne, Edmund, of Redgrave, miller 1
3633169 1905186 1905186 defendant Cherche John   589258 589258 Cherche, John, of Redgrave, wheelwright 2
3634193 1905496 1905496 defendant Brodhed Ralph chaplain 589258 589258 Brodhed, Ralph, of Redgrave, chaplain 0
3649936 1910346 1910346 defendant Stegyll William husbandman 589258 589258 Stegyll, William, of Redgrave, husbandman 1
3723597 1933653 1933653 defendant Deye John husbandman 589258 589258 Deye, John, of Redgrave, husbandman 2
3852044 1974230 1974230 defendant Saunders Edward husbandman 589258 589258 Saunders, Edward, of Redgrave, husbandman 0
3861682 1977367 1977367 defendant Hobert Thomas husbandman 589258 589258 Hobert, Thomas, of Redgrave, husbandman 0
3874196 1981593 1981593 defendant Sawndyr Edward husbandman 589258 589258 Sawndyr, Edward, of Redgrave, husbandman 1
3887038 1985928 1985928 defendant Broun Thomas husbandman 589258 589258 Broun, Thomas, of Redgrave, husbandman 0
3889278 1986651 1986651 defendant Dale William clerk 589258 589258 Dale, William, of Redgrave, clerk 0
3911106 1994042 1994042 defendant Browne Thomas husbandman 589258 589258 Browne, Thomas, of Redgrave, husbandman 1
3911107 1994042 1994042 defendant Hobard Thomas yeoman 589258 589258 Hobard, Thomas, of Redgrave, yeoman 2
3945001 2005344 2005344 defendant Bucknam Thomas husbandman 589258 589258 Bucknam, Thomas, of Redgrave, husbandman 2
3982583 2018543 2018543 defendant Peke Henry yeoman 589258 589258 Peke, Henry, of Redgrave, yeoman 3
3998216 2024109 2024109 plaintiff Fale James yeoman 589258 589258 Fale, James, of Redgrave, yeoman 0
4016853 2030725 2030725 defendant Seaman William yeoman 589258 589258 (Seaman, William, of Redgrave, yeoman 1
4020054 2031902 2031902 defendant Syngleton Charles gent 589258 589258 Syngleton, Charles, of Redgrave, gent 1
4065664 2048008 2048008 defendant Smyth Richard husbandman 589258 589258 Smyth, Richard, of Redgrave, husbandman 0
4078202 2052507 2052507 defendant Shepperde John husbandman 589258 589258 Shepperde, John, of Redgrave, husbandman 2
4134451 2072652 2072652 defendant Bacon Nicholas   589258 589258 Bacon, Nicholas, of Redgrave, knight, sheriff of Suff 0
4163204 2082661 2082661 defendant Rowte Thomas   589258 589258 Rowte, Thomas, of Redgrave, linen weaver 2
4163208 2082662 2082662 defendant Rowte Thomas   589258 589258 Rowte, Thomas, of Redgrave, linen weaver 2
4198051 2094866 2094866 defendant Dale William carpenter 589258 589258 Dale, William, of Redgrave, carpenter 1
4198236 2094930 2094930 defendant Shepperd Thomas tanner 589258 589258 Shepperd, Thomas, of Redgrave, tanner 0
4205841 2097589 2097589 defendant Bacon Nicholas   589258 589258 Bacon, Nicholas, of Redgrave, knight, sheriff of Suff 0
4240912 2109946 2109946 defendant Smyth Henry yeoman 589258 589258 Smyth, Henry, of Redgrave, yeoman 1
4332712 2141225 2141225 defendant Honyward Thomas yeoman 589258 589258 Honyward, Thomas, of Redgrave, yeoman 1
4366330 2152998 2152998 defendant Hallyett Robert gent 589258 589258 Hallyett, Robert, of Redgrave, gent 0
4396684 2163456 2163456 defendant Sheppard Henry weaver 589258 589258 Sheppard, Henry, of Redgrave, weaver 1
4399402 2164389 2164389 defendant Saunder William   589258 589258 Saunder, William, of Redgrave, linen weaver, his brother 1
4400447 2164745 2164745 defendant Edward John blacksmith 589258 589258 Edward, John, of Redgrave, blacksmith 0
4400449 2164745 2164745 defendant Martyn William glover 589258 589258 Martyn, William, of Redgrave, glover 2
4404327 2166018 2166018 defendant Fowle Thomas yeoman 589258 589258 Fowle, Thomas, of Redgrave, yeoman 0
4407615 2167113 2167113 defendant Fowle Thomas clerk 589258 589258 Fowle, Thomas, of Redgrave, clerk 1
4517845 2205967 2205967 defendant Smyth John   589258 589258 Smyth, John, of Redgrave 3
4565274 2220711 2220711 defendant Smyth John   589258 589258 Smyth, John, of Redgrave 1
4607997 2233619 2233619 defendant Braun Roger   589258 589258 Braun, Roger, of Redgrave 6
4753305 2281414 2281414 defendant Wyston Thomas   589258 589258 Wyston, Thomas, of Redgrave, parson 0
4753313 2281416 2281416 defendant Wyston Thomas de   589258 589258 Wyston, Thomas de, of Redgrave, parson 0
4884054 2321925 2321925 defendant Bierde John   589258 589258 Bierde, John, of Redgrave, "days" 1
4906935 2328750 2328750 defendant Bierde John   589258 589258 Bierde, John, of Redgrave, "daye" 1
4945997 2340737 2340737 defendant Clerk Adam husbandman 589258 589258 Clerk, Adam, of Redgrave, husbandman 0
4945998 2340737 2340737 defendant Clerk Robert laborer 589258 589258 Clerk, Robert, of Redgrave, laborer 1
4945999 2340737 2340737 defendant Chace John   589258 589258 Chace, John, of Redgrave, shepherd 2
5013553 2360805 2360805 defendant Bokenham Hugh husbandman 589258 589258 Bokenham, Hugh, of Redgrave, husbandman 0
5013554 2360805 2360805 defendant Bokenham John laborer 589258 589258 Bokenham, John, of Redgrave, laborer 1
5013555 2360805 2360805 defendant Bokenham Richard   589258 589258 Bokenham, Richard, of Redgrave, servant 2
5055716 2373278 2373278 defendant Goldfynch William butcher 589258 589258 Goldfynch, William, of Redgrave, butcher 3
5059524 2374420 2374420 defendant Hoo John butcher 589258 589258 Hoo, John, of Redgrave, butcher 2
5068544 2377084 2377084 defendant Undirwode Hugh clerk 589258 589258 Undirwode, Hugh, of Redgrave, clerk 0
5068545 2377084 2377084 defendant Buk Alexander yeoman 589258 589258 Buk, Alexander, of Redgrave, yeoman 1
5088275 2382946 2382946 defendant Reder Richard husbandman 589258 589258 Reder, Richard, of Redgrave, husbandman 0
5286354 2441009 2441009 defendant Buk Alexander yeoman 589258 589258 Buk, Alexander, of Redgrave, yeoman 3
5354547 2461496 2461496 defendant Fyssher Richard husbandman 589258 589258 Fyssher, Richard, of Redgrave, husbandman 1
5519091 2510815 2510815 defendant Baron John   589258 589258 Baron, John, of Redgrave, wheel wright 0
5523230 2512095 2512095 defendant Wanton Edmund husbandman 589258 589258 Wanton, Edmund, of Redgrave, husbandman 2
5555421 2521589 2521589 defendant Chyrche John   589258 589258 Chyrche, John, of Redgrave, wheelwright 0
5555428 2521591 2521591 defendant Nunne Edmund miller 589258 589258 Nunne, Edmund, of Redgrave, miller 0
5568876 2525447 2525447 defendant Stegell William husbandman 589258 589258 Stegell, William, of Redgrave, husbandman 1
5573387 2526773 2526773 defendant Chirch John husbandman 589258 589258 Chirch, John, of Redgrave, husbandman 0
5580441 2528967 2528967 defendant Dale William clerk 589258 589258 Dale, William, of Redgrave, clerk 1

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);