names

52 rows where place_id = 591008

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602997 1868604 1868604 defendant Bagger Thomas saddler 591008 591008 Bagger, Thomas, of Southwerke, saddler 0
3604757 1869152 1869152 defendant Pedicke Geoffrey yeoman 591008 591008 Pedicke, Geoffrey, of Southwerke, yeoman 0
3637597 1906569 1906569 defendant Barker James yeoman 591008 591008 Barker, James, of Southwerke, yeoman 0
3655551 1911996 1911996 plaintiff Branche William brewer 591008 591008 Branche, William, of Southwerke, brewer 0
3672842 1917518 1917518 defendant Crosse John brewer 591008 591008 Crosse, John, of Southwerke, brewer 0
3672844 1917519 1917519 defendant Crosse John brewer 591008 591008 Crosse, John, of Southwerke, brewer 0
3678479 1919325 1919325 defendant Coddyng John butcher 591008 591008 Coddyng, John, of Southwerke, butcher 0
3701247 1926632 1926632 defendant Philyp John capper 591008 591008 Philyp, John, of Southwerke, capper 1
3707270 1928563 1928563 plaintiff Begellinger Henry skinner 591008 591008 Begellinger, Henry, of Southwerke, skinner 2
3715876 1931250 1931250 defendant Tomlynson William armorer 591008 591008 Tomlynson, William, of Southwerke, armorer 0
3745185 1940400 1940400 defendant A Morgeyne Richard yeoman 591008 591008 A Morgeyne, Richard, of Southwerke, yeoman 0
3745186 1940400 1940400 defendant Atkynson John   591008 591008 Atkynson, John, of Southwerke, ale brewer 1
3745188 1940400 1940400 defendant Flode John yeoman 591008 591008 Flode, John, of Southwerke, yeoman 3
3748778 1941552 1941552 defendant Barons William   591008 591008 Barons, William, of Southwerke, tallow chandler 0
3751993 1942544 1942544 defendant Saunder William yeoman 591008 591008 Saunder, William, of Southwerke, yeoman 0
3754280 1943289 1943289 defendant Adams John haberdasher 591008 591008 Adams, John, of Southwerke, haberdasher 0
3754286 1943291 1943291 defendant Boty John hatmaker 591008 591008 Boty, John, of Southwerke, hatmaker 1
3775870 1950206 1950206 defendant Saierfeld John letherseller 591008 591008 Saierfeld, John, of Southwerke, letherseller 1
3775871 1950206 1950206 defendant Reynoldys John girdler 591008 591008 Reynoldys, John, of Southwerke, girdler 2
3779990 1951466 1951466 defendant Hone William cobbler 591008 591008 Hone, William, of Southwerke, cobbler 0
3779992 1951466 1951466 defendant Ewyne David laborer 591008 591008 Ewyne, David, of Southwerke, laborer 2
3780097 1951499 1951499 defendant Broke Joyce shoemaker 591008 591008 Broke, Joyce, of Southwerke, shoemaker 0
3793919 1955966 1955966 defendant Garetson Dirick joiner 591008 591008 Garetson, Dirick, of Southwerke, joiner 0
3801775 1958451 1958451 defendant Stanley Thomas clerk 591008 591008 Stanley, Thomas, of Southwerke, clerk 0
3809830 1960962 1960962 defendant Barnes Stephen chandler 591008 591008 Barnes, Stephen, of Southwerke, chandler 1
3816367 1963028 1963028 defendant Cokkys John, senior leather seller 591008 591008 Cokkys, John, senior, of Southwerke, leather seller 0
3837997 1969795 1969795 defendant Myskyn Henry leather dyer 591008 591008 Myskyn, Henry, of Southwerke, leather dyer 0
3841187 1970823 1970823 plaintiff Barwyk John tailor 591008 591008 Barwyk, John, of Southwerke, tailor 0
3841189 1970824 1970824 plaintiff Barwyk John tailor 591008 591008 Barwyk, John, of Southwerke, tailor 0
3844172 1971726 1971726 defendant Jonys Edward yeoman 591008 591008 Jonys, Edward, of Southwerke, yeoman 0
3849465 1973432 1973432 defendant Louse Peter waterman 591008 591008 Louse, Peter, of Southwerke, waterman 1
3850856 1973860 1973860 defendant Acton Robert gent 591008 591008 Acton, Robert, of Southwerke, gent 2
3852215 1974291 1974291 defendant Fox Cuthbert painter 591008 591008 Fox, Cuthbert, of Southwerke, painter 0
3853890 1974852 1974852 defendant Richardson William (legal representative) 591008 591008 Richardson, William, of Southwerke, goldsmith, executors of 0
3854416 1975018 1975018 defendant Lynne John currier 591008 591008 Lynne, John, of Southwerke, currier 0
3854417 1975018 1975018 defendant Whitehed Roger dyer 591008 591008 Whitehed, Roger, of Southwerke, dyer 1
3854418 1975018 1975018 defendant Alen John butcher 591008 591008 Alen, John, of Southwerke, butcher 2
3854419 1975018 1975018 defendant Conwey alias Whytehed John waterman 591008 591008 Conwey alias Whytehed, John, of Southwerke, waterman 3
3854420 1975018 1975018 defendant Symondon William vintner 591008 591008 Symondon, William, of Southwerke, vintner 4
3860147 1976891 1976891 defendant Nicholson James glazier 591008 591008 Nicholson, James, of Southwerke, glazier 0
3870789 1980478 1980478 plaintiff Acton Robert gent 591008 591008 Acton, Robert, of Southwerke, gent 0
3897407 1989347 1989347 defendant Acton Robert   591008 591008 Acton, Robert, of Southwerke, knight 1
3897792 1989464 1989464 defendant Norman John tailor 591008 591008 Norman, John, of Southwerke, tailor 1
3897807 1989468 1989468 defendant Ballyngeham Edward esq 591008 591008 Ballyngeham, Edward, of Southwerke, esq 1
3961593 2011153 2011153 defendant Smythe John brewer 591008 591008 Smythe, John, of Southwerke, brewer 0
4592004 2228854 2228854 defendant Forster Richard   591008 591008 Forster, Richard, of Southwerke 2
5122500 2393010 2393010 defendant Crosse William clerk 591008 591008 Crosse, William, of Southwerke, clerk 0
5216091 2420435 2420435 defendant Porter John brewer 591008 591008 Porter, John, of Southwerke, brewer 0
5348805 2459753 2459753 plaintiff Browe John (legal representative) 591008 591008 Browe, John, of Southwerke, administrator of 0
5510560 2508139 2508139 defendant Parker John scrivener 591008 591008 Parker, John, of Southwerke, scrivener 0
5554184 2521267 2521267 defendant Wryght Thomas tailor 591008 591008 Wryght, Thomas, of Southwerke, tailor 0
5575328 2527373 2527373 defendant Roche William smith 591008 591008 Roche, William, of Southwerke, smith 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);