names

58 rows where place_id = 595930

✎ 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
3622427 1874550 1874550 defendant Wryght Thomas clothmaker 595930 595930 Wryght, Thomas, of Groton, clothmaker 1
3690766 1923277 1923277 defendant Dogett Richard clothmaker 595930 595930 Dogett, Richard, of Groton, clothmaker 0
3690768 1923278 1923278 defendant Dogett Richard clothmaker 595930 595930 Dogett, Richard, of Groton, clothmaker 0
3696890 1925249 1925249 defendant Leman John husbandman 595930 595930 Leman, John, of Groton, husbandman 2
3705100 1927885 1927885 defendant Gale William clothmaker 595930 595930 Gale, William, of Groton, clothmaker 1
3705689 1928061 1928061 defendant Gale William, senior clothmaker 595930 595930 Gale, William, senior, of Groton, clothmaker 0
3710589 1929635 1929635 defendant Leman John husbandman 595930 595930 Leman, John, of Groton, husbandman 0
3712839 1930336 1930336 defendant Gale William clothmaker 595930 595930 Gale, William, of Groton, clothmaker 1
3720487 1932691 1932691 defendant Cocke Robert husbandman 595930 595930 Cocke, Robert, of Groton, husbandman 1
3733163 1936604 1936604 plaintiff Doggett Richard clothmaker 595930 595930 Doggett, Richard, of Groton, clothmaker 0
3733466 1936709 1936709 defendant Gale William clothmaker 595930 595930 Gale, William, of Groton, clothmaker 0
3741180 1939102 1939102 defendant Dogett Richard clothmaker 595930 595930 Dogett, Richard, of Groton, clothmaker 0
3760785 1945377 1945377 plaintiff Dogett Richard   595930 595930 Dogett, Richard, of Groton 0
3760792 1945379 1945379 plaintiff Dogget Richard clothier 595930 595930 Dogget, Richard, of Groton, clothier 0
3770490 1948453 1948453 defendant Doggett Richard clothmaker 595930 595930 Doggett, Richard, of Groton, clothmaker 0
3796039 1956623 1956623 plaintiff Dogett Richard clothier 595930 595930 Dogett, Richard, of Groton, clothier 0
3796042 1956624 1956624 plaintiff Dogett Richard clothmaker 595930 595930 Dogett, Richard, of Groton, clothmaker 0
3812585 1961824 1961824 defendant Gooche Thomas husbandman 595930 595930 Gooche, Thomas, of Groton, husbandman 0
3813178 1962033 1962033 plaintiff Dogett Richard clothmaker 595930 595930 Dogett, Richard, of Groton, clothmaker 0
3813183 1962034 1962034 plaintiff Dogett Richard clothman 595930 595930 Dogett, Richard, of Groton, clothman 0
3826619 1966172 1966172 defendant Tod William clothmaker 595930 595930 Tod, William, of Groton, clothmaker 1
3864722 1978397 1978397 defendant Goche William husbandman 595930 595930 Goche, William, of Groton, husbandman 0
3866025 1978869 1978869 defendant Slade John husbandman 595930 595930 Slade, John, of Groton, husbandman 1
3978838 2017180 2017180 plaintiff More William gent 595930 595930 More, William, of Groton, gent 0
4007381 2027421 2027421 defendant Newes Athur clothier 595930 595930 Newes, Athur, of Groton, clothier 0
4118154 2066776 2066776 defendant Coo John gent 595930 595930 Coo, John, of Groton, gent 2
4127066 2069971 2069971 defendant Sowter John clothier 595930 595930 Sowter, John, of Groton, clothier 0
4198477 2095018 2095018 defendant Sowter John clother 595930 595930 Sowter, John, of Groton, clother 0
4248761 2112571 2112571 defendant Faken Simon husbandman 595930 595930 Faken, Simon, of Groton, or of Polsted, husbandman 0
4309514 2133488 2133488 defendant Higham William husbandman or laborer 595930 595930 Higham, William, of Groton, husbandman or laborer 2
4312445 2134490 2134490 defendant Coaky or Cokye Richard bricklayer 595930 595930 Coaky or Cokye, Richard, of Groton, bricklayer 0
4432001 2174789 2174789 defendant Palham John de clerk 595930 595930 Palham, John de, of Groton, clerk 0
4801016 2296507 2296507 defendant Hillys John   595930 595930 Hillys, John, of Groton, wheelwright 0
4801017 2296507 2296507 defendant Nutte Robert fuller 595930 595930 Nutte, Robert, of Groton, fuller 1
4801018 2296507 2296507 defendant Webbe John fuller 595930 595930 Webbe, John, of Groton, fuller 2
4834231 2306716 2306716 defendant atte Mille John laborer 595930 595930 atte Mille, John, of Groton, laborer 4
5117692 2391610 2391610 defendant Coo John mercer 595930 595930 Coo, John, of Groton, mercer 0
5137730 2397548 2397548 defendant Coo John mercer 595930 595930 Coo, John, of Groton, mercer 3
5144709 2399608 2399608 defendant Coo John mercer 595930 595930 Coo, John, of Groton, mercer 4
5156809 2403151 2403151 defendant Hilles William   595930 595930 Hilles, William, of Groton, plough wright 0
5162965 2404896 2404896 plaintiff Waryn John   595930 595930 Waryn, John, of Groton 0
5168149 2406395 2406395 defendant Tayllour Robert husbandman 595930 595930 (Tayllour, Robert, of Groton, husbandman 1
5172871 2407798 2407798 defendant Hilles William   595930 595930 Hilles, William, of Groton, plough wright 0
5192699 2413601 2413601 defendant Hilles William   595930 595930 Hilles, William, of Groton, plough wright 0
5201930 2416330 2416330 defendant Coo John mercer 595930 595930 Coo, John, of Groton, mercer 3
5224498 2422836 2422836 defendant Coo John fuller 595930 595930 Coo, John, of Groton, fuller 1
5239842 2427227 2427227 defendant Coo John mercer 595930 595930 Coo, John, of Groton, mercer 4
5255828 2431946 2431946 defendant Ive John thatcher 595930 595930 Ive, John, of Groton, thatcher 0
5337368 2456247 2456247 defendant More John husbandman 595930 595930 More, John, of Groton, husbandman 1
5337797 2456382 2456382 defendant Howys John clerk 595930 595930 Howys, John, of Groton, clerk 0
5368054 2465630 2465630 defendant Wright John (legal representative) 595930 595930 Wright, John, of Groton, senior, executors of 0
5368055 2465630 2465630 defendant Wright Alice widow 595930 595930 (Wright, Alice, of Groton, widow 1
5368056 2465630 2465630 defendant Wright Thomas yeoman 595930 595930 Wright, Thomas, of Groton, yeoman 2
5512462 2508761 2508761 defendant Gale John, junior husbandman 595930 595930 Gale, John, junior, of Groton, husbandman 1
5518590 2510647 2510647 defendant Prowede John husbandman 595930 595930 Prowede, John,of Groton, husbandman 0
5543710 2518143 2518143 defendant Gale John clothmaker 595930 595930 Gale, John, of Groton, clothmaker 1
5589711 2531778 2531778 defendant Gale William husbandman 595930 595930 Gale, William, of Groton, husbandman 1
5590147 2531892 2531892 defendant Stretys John husbandman 595930 595930 Stretys, John, of Groton, husbandman 3

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