names

204 rows where place_id = 590106

✎ 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
3599934 1867634 1867634 defendant Buntyng William husbandman 590106 590106 Buntyng, William, of South Walsham, husbandman 2
3604312 1869013 1869013 defendant Ecclys William butcher 590106 590106 Ecclys, William, of South Walsham, butcher 0
3604381 1869037 1869037 defendant Ecclys William butcher 590106 590106 Ecclys, William, of South Walsham, butcher 0
3619479 1873656 1873656 defendant Ecclys William butcher 590106 590106 Ecclys, William, of South Walsham, butcher 0
3622932 1874701 1874701 defendant Eccles William butcher 590106 590106 Eccles, William, of South Walsham, butcher 0
3623798 1874976 1874976 plaintiff Speyn Thomas yeoman 590106 590106 Speyn, Thomas, of South Walsham, yeoman 0
3625717 1875581 1875581 defendant Kebyte Oliver husbandman 590106 590106 Kebyte, Oliver, of South Walsham, husbandman 0
3632585 1905009 1905009 defendant Speyn Christopher husbandman 590106 590106 Speyn, Christopher, of South Walsham, husbandman 1
3645727 1909067 1909067 defendant Speyn Christopher husbandman 590106 590106 Speyn, Christopher, of South Walsham, husbandman 1
3645988 1909138 1909138 defendant Speyn Christopher husbandman 590106 590106 Speyn, Christopher, of South Walsham, husbandman 1
3660255 1913469 1913469 defendant Croke John husbandman 590106 590106 Croke, John, of South Walsham, husbandman 4
3660261 1913470 1913470 defendant Croke John husbandman 590106 590106 Croke, John, of South Walsham, husbandman 4
3668461 1916088 1916088 defendant Cokke John   590106 590106 Cokke, John, of South Walsham, worsted weaver 1
3668741 1916158 1916158 defendant Cobbe John, senior husbandman 590106 590106 Cobbe, John, senior, of South Walsham, husbandman 0
3668742 1916158 1916158 defendant Cobbe John, junior husbandman 590106 590106 Cobbe, John, junior, of South Walsham, husbandman 1
3672836 1917515 1917515 defendant Cobbe John husbandman 590106 590106 Cobbe, John, of South Walsham, husbandman 1
3680188 1919876 1919876 defendant Wyllys John smith 590106 590106 Wyllys, John, of South Walsham, smith 1
3681412 1920273 1920273 defendant Bray William husbandman 590106 590106 Bray, William, of South Walsham, husbandman 0
3681415 1920273 1920273 defendant Buntyng John husbandman 590106 590106 Buntyng, John, of South Walsham, husbandman 3
3682488 1920626 1920626 defendant Rownce John husbandman 590106 590106 Rownce, John, of South Walsham, husbandman 0
3719148 1932273 1932273 defendant Bubbyn John husbandman 590106 590106 Bubbyn, John, of South Walsham, husbandman 0
3719151 1932274 1932274 defendant Speyne Christopher husbandman 590106 590106 Speyne, Christopher, of South Walsham, husbandman 0
3729267 1935405 1935405 defendant Creke Richard husbandman 590106 590106 Creke, Richard, of South Walsham, husbandman 0
3740196 1938790 1938790 defendant Goddyng Thomas yeoman 590106 590106 Goddyng, Thomas, of South Walsham, yeoman 0
3752584 1942736 1942736 defendant Goddyng Thomas yeoman 590106 590106 Goddyng, Thomas, of South Walsham, yeoman 0
3758462 1944641 1944641 defendant Goddyng Thomas gent 590106 590106 Goddyng, Thomas, of South Walsham, gent 1
3759355 1944915 1944915 defendant Galte John husbandman 590106 590106 Galte, John, of South Walsham, husbandman 0
3759356 1944915 1944915 defendant Cubite Ralph yeoman 590106 590106 Cubite, Ralph, of South Walsham, yeoman 1
3759357 1944915 1944915 defendant Speyn Christopher yeoman 590106 590106 Speyn, Christopher, of South Walsham, yeoman 2
3763439 1946198 1946198 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3763440 1946198 1946198 defendant Bray William husbandman 590106 590106 Bray, William, of South Walsham, husbandman 1
3769363 1948073 1948073 defendant Goddyng Thomas yeoman 590106 590106 Goddyng, Thomas, of South Walsham, yeoman 0
3778004 1950831 1950831 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3778217 1950894 1950894 defendant Sherpe Robert husbandman 590106 590106 Sherpe, Robert, of South Walsham, husbandman 3
3780660 1951679 1951679 plaintiff Goddyng Thomas   590106 590106 Goddyng, Thomas, of South Walsham 0
3780744 1951713 1951713 defendant Sharp Robert husbandman 590106 590106 Sharp, Robert, of South Walsham, husbandman 0
3798349 1957382 1957382 defendant Goddyng John husbandman 590106 590106 Goddyng, John, of South Walsham, husbandman 1
3827829 1966569 1966569 defendant Johnson Thomas husbandman 590106 590106 Johnson, Thomas, of South Walsham, husbandman 0
3840960 1970741 1970741 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3844814 1971922 1971922 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3844815 1971922 1971922 defendant Chamber George   590106 590106 Chamber, George, of South Walsham, worsted weaver 1
3844817 1971922 1971922 defendant Bray William husbandman 590106 590106 Bray, William, of South Walsham, husbandman 3
3853658 1974774 1974774 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3859677 1976735 1976735 defendant Tattyshalle John smith 590106 590106 Tattyshalle, John, of South Walsham, smith 0
3861228 1977229 1977229 defendant Bysshopp Adam husbandman 590106 590106 Bysshopp, Adam, of South Walsham, husbandman 1
3862081 1977505 1977505 defendant Tatsall John smith 590106 590106 Tatsall, John, of South Walsham, smith 0
3862720 1977724 1977724 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3862721 1977724 1977724 defendant Cobbe Thomas husbandman 590106 590106 Cobbe, Thomas, of South Walsham, husbandman 1
3862722 1977724 1977724 defendant Shipdam John husbandman 590106 590106 Shipdam, John, of South Walsham, husbandman 2
3871566 1980731 1980731 defendant Speyn Christopher yeoman 590106 590106 Speyn, Christopher, of South Walsham, yeoman, Chayme, William, of South Walsham, yeoman 1
3874178 1981586 1981586 defendant Skeyton Richard butcher 590106 590106 Skeyton, Richard, of South Walsham, butcher 0
3874179 1981586 1981586 defendant Kybyt George husbandman 590106 590106 Kybyt, George, of South Walsham, husbandman 1
3876922 1982520 1982520 defendant Shipdam John husbandman 590106 590106 Shipdam, John, of South Walsham, husbandman 0
3880976 1983907 1983907 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3880979 1983908 1983908 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 0
3882348 1984355 1984355 defendant Bysshopp Adam husbandman 590106 590106 Bysshopp, Adam, of South Walsham, husbandman 1
3887045 1985931 1985931 plaintiff Clerke Thomas yeoman 590106 590106 Clerke, Thomas, of South Walsham, yeoman 0
3915755 1995647 1995647 defendant Sharpe Robert husbandman 590106 590106 Sharpe, Robert, of South Walsham, husbandman 1
3921041 1997386 1997386 defendant Cobbe Richard yeoman 590106 590106 Cobbe, Richard, of South Walsham, yeoman 1
3947906 2006332 2006332 defendant Grene John tailor 590106 590106 Grene John, of South Walsham, tailor 0
3991793 2021816 2021816 defendant Cooke Thomas yeoman 590106 590106 Cooke, Thomas, of South Walsham, yeoman 0
3994285 2022709 2022709 plaintiff Cobbe John   590106 590106 Cobbe, John, of South Walsham 0
3994287 2022710 2022710 plaintiff Cobbe John   590106 590106 Cobbe, John, of South Walsham 0
4046135 2041056 2041056 defendant Gylley William husbandman 590106 590106 Gylley, William, of South Walsham, husbandman 0
4047682 2041618 2041618 defendant Piele Robert tailor 590106 590106 Piele, Robert, of South Walsham, tailor 2
4058051 2045260 2045260 defendant Benslyn or Benslyng John yeoman 590106 590106 Benslyn or Benslyng, John, of South Walsham, yeoman 0
4075084 2051391 2051391 defendant Cobbe John husbandman 590106 590106 Cobbe, John, of South Walsham, husbandman 1
4079014 2052793 2052793 defendant Gyllye William yeoman 590106 590106 Gyllye, William, of South Walsham, yeoman 0
4079015 2052793 2052793 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 1
4079020 2052795 2052795 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 0
4079787 2053070 2053070 defendant Barnard Edmund laborer 590106 590106 Barnard, Edmund, of South Walsham, laborer 2
4085350 2055041 2055041 defendant Cooke Thomas husbandman 590106 590106 Cooke, Thomas, of South Walsham, husbandman 3
4085794 2055193 2055193 defendant Cocke Thomas yeoman 590106 590106 Cocke, Thomas, of South Walsham, yeoman 0
4085796 2055194 2055194 defendant Cocke Thomas yeoman 590106 590106 Cocke, Thomas, of South Walsham, yeoman 0
4113420 2065072 2065072 defendant Graunger Benedict yeoman 590106 590106 Graunger, Benedict, of South Walsham, yeoman 0
4114290 2065394 2065394 defendant Machyll edward gent 590106 590106 Machyll, edward, of South Walsham, gent 0
4115546 2065847 2065847 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 0
4117023 2066390 2066390 defendant Cobbe Robert yeoman 590106 590106 Cobbe, Robert, of South Walsham, yeoman 0
4117024 2066390 2066390 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 1
4117141 2066436 2066436 defendant Cobbe Robert yeoman 590106 590106 Cobbe, Robert, of South Walsham, yeoman 0
4117142 2066436 2066436 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 1
4117733 2066636 2066636 plaintiff Wood Nathaniel   590106 590106 Wood, Nathaniel, of South Walsham, clerk, administrators of 0
4117735 2066636 2066636 defendant Underwood Richard gent 590106 590106 Underwood, Richard, of South Walsham, gent 0
4117736 2066637 2066637 plaintiff Wood Nethamalus   590106 590106 Wood, Nethamalus, of South Walsham, clerk, administrators of 0
4117738 2066637 2066637 defendant Robynson John clerk 590106 590106 Robynson, John, of South Walsham, clerk 0
4135728 2073106 2073106 defendant Machell Edward gent 590106 590106 Machell, Edward, of South Walsham, gent 0
4135730 2073107 2073107 defendant Machell Edward gent 590106 590106 Machell, Edward, of South Walsham, gent 0
4196832 2094440 2094440 defendant Wygg John husbandman 590106 590106 Wygg, John, of South Walsham, husbandman 0
4199542 2095390 2095390 defendant Machell Edward gent 590106 590106 Machell, Edward, of South Walsham, gent 0
4249568 2112842 2112842 defendant Jonson alias Apurgney John husbandman 590106 590106 Jonson alias Apurgney, John, of South Walsham, husbandman 0
4251456 2113468 2113468 defendant Gryme John yeoman 590106 590106 Gryme, John, of South Walsham, yeoman 0
4252273 2113753 2113753 defendant Brand Thomas husbandman 590106 590106 Brand, Thomas, of South Walsham, husbandman 0
4284708 2124580 2124580 defendant Smythe Richard husbandman 590106 590106 Smythe, Richard, of South Walsham, husbandman 0
4284709 2124580 2124580 defendant Syball William husbandman 590106 590106 Syball, William, of South Walsham, husbandman 1
4284963 2124671 2124671 defendant Englisshe Christopher husbandman 590106 590106 Englisshe, Christopher, of South Walsham, husbandman 1
4290057 2126508 2126508 defendant Smyth Richard, senior fisherman 590106 590106 Smyth, Richard, senior, of South Walsham, fisherman 0
4290783 2126761 2126761 defendant Cobb Richard husbandman 590106 590106 Cobb, Richard, of South Walsham, husbandman 0
4290784 2126761 2126761 defendant Cobb William husbandman 590106 590106 Cobb, William, of South Walsham, husbandman 1
4310531 2133837 2133837 defendant Tobie Thomas husbandman 590106 590106 Tobie, Thomas, of South Walsham, husbandman 0
4310532 2133837 2133837 defendant Davie John, senior blacksmith 590106 590106 Davie, John, senior, of South Walsham, blacksmith 1

Next page

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