names

109 rows where place_id = 587745

✎ 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
3592334 1865218 1865218 defendant Long John husbandman 587745 587745 Long, John, of Shymplyng, husbandman 0
3643283 1908324 1908324 defendant Shardlowe Thomas gent 587745 587745 Shardlowe, Thomas, of Shymplyng, gent 0
3665355 1915117 1915117 defendant Barell John husbandman 587745 587745 Barell, John, of Shymplyng, husbandman 0
3675312 1918321 1918321 defendant Lankashyre Robert yeoman 587745 587745 Lankashyre, Robert, of Shymplyng, yeoman 0
3675316 1918321 1918321 defendant Mahewe Richard husbandman 587745 587745 Mahewe, Richard, of Shymplyng, husbandman 4
3681827 1920419 1920419 defendant Barell John husbandman 587745 587745 Barell, John, of Shymplyng, husbandman 0
3688537 1922573 1922573 defendant Pratt John laborer 587745 587745 Pratt, John, of Shymplyng, laborer 5
3696104 1925005 1925005 defendant Seman Henry husbandman 587745 587745 Seman, Henry, of Shymplyng, husbandman 2
3696891 1925249 1925249 defendant Batemanson William chaplain 587745 587745 Batemanson, William, of Shymplyng, chaplain 3
3702706 1927118 1927118 defendant Batemanson William clerk 587745 587745 Batemanson, William, of Shymplyng, clerk 1
3704715 1927762 1927762 defendant Bateman William chaplain 587745 587745 Bateman, William, of Shymplyng, chaplain 0
3708202 1928859 1928859 defendant Barell John husbandman 587745 587745 Barell, John, of Shymplyng, husbandman 0
3708204 1928860 1928860 defendant Barell John husbandman 587745 587745 Barell, John, of Shymplyng, husbandman 0
3709356 1929223 1929223 defendant Auncell John husbandman 587745 587745 Auncell, John, of Shymplyng, husbandman 2
3736803 1937761 1937761 defendant Chyld Clement husbandman 587745 587745 Chyld, Clement, of Shymplyng, husbandman 0
3738043 1938114 1938114 defendant Auncell John husbandman 587745 587745 Auncell, John, of Shymplyng, husbandman 0
3739971 1938721 1938721 defendant Smythe John smith 587745 587745 Smythe, John, of Shymplyng, smith 0
3741152 1939094 1939094 defendant Corder William husbandman 587745 587745 Corder, William, of Shymplyng, husbandman 0
3744521 1940187 1940187 defendant Corder William husbandman 587745 587745 Corder, William, of Shymplyng, husbandman 3
3749859 1941869 1941869 defendant Waren Andrew husbandman 587745 587745 Waren, Andrew, of Shymplyng, husbandman 0
3760789 1945377 1945377 defendant Corder William husbandman 587745 587745 Corder, William, of Shymplyng, husbandman 3
3763460 1946204 1946204 defendant Crane Thomas pedder 587745 587745 Crane, Thomas, of Shymplyng, pedder 0
3764387 1946522 1946522 defendant Johnson alias Pyper William laborer 587745 587745 Johnson alias Pyper, William, of Shymplyng, laborer 0
3766340 1947126 1947126 defendant Goddard William husbandman 587745 587745 Goddard, William, of Shymplyng, husbandman 1
3780706 1951698 1951698 defendant Byrde John husbandman 587745 587745 Byrde, John, of Shymplyng, husbandman 3
3783296 1952527 1952527 defendant Shardlowe Thomas gent 587745 587745 Shardlowe, Thomas, of Shymplyng, gent 1
3784238 1952860 1952860 defendant Goddard William husbandman 587745 587745 Goddard, William, of Shymplyng, husbandman 0
3789312 1954476 1954476 defendant Broun John laborer 587745 587745 Broun, John, of Shymplyng, laborer 2
3791382 1955140 1955140 defendant Tebald John, junior husbandman 587745 587745 Tebald, John, junior, of Shymplyng, husbandman 1
3791815 1955287 1955287 defendant Erlond Thomas laborer 587745 587745 Erlond, Thomas, of Shymplyng, laborer 0
3796421 1956750 1956750 defendant Corder Thomas husbandman 587745 587745 Corder, Thomas, of Shymplyng, husbandman 1
3801302 1958333 1958333 defendant Tebald John husbandman 587745 587745 Tebald, John, of Shymplyng, husbandman 2
3806473 1959939 1959939 plaintiff Warde Thomas clerk 587745 587745 Warde, Thomas, of Shymplyng, clerk 0
3812491 1961794 1961794 defendant Johnson alias Pyper William husbandman 587745 587745 Johnson alias Pyper, William, of Shymplyng, husbandman 0
3817244 1963306 1963306 defendant Shardlowe Thomas gent 587745 587745 Shardlowe, Thomas, of Shymplyng, gent 0
3817251 1963307 1963307 defendant Shardlowe Thomas gent 587745 587745 Shardlowe, Thomas, of Shymplyng, gent 0
3828039 1966636 1966636 defendant Shardlowe Thomas gent 587745 587745 Shardlowe, Thomas, of Shymplyng, gent 0
3830316 1967375 1967375 defendant Crane Thomas pedder 587745 587745 Crane, Thomas, of Shymplyng, pedder 2
3831185 1967643 1967643 defendant Tebold John yeoman 587745 587745 Tebold, John, of Shymplyng, yeoman 1
3831204 1967647 1967647 defendant Tebold John yeoman 587745 587745 Tebold, John, of Shymplyng, yeoman 1
3833860 1968524 1968524 defendant Antyngham Nicholas husbandman 587745 587745 Antyngham, Nicholas, of Shymplyng, husbandman 0
3835312 1968983 1968983 defendant Colman William husbandman 587745 587745 Colman, William, of Shymplyng, husbandman 1
3837108 1969508 1969508 plaintiff Shardlowe Thomas esq 587745 587745 Shardlowe, Thomas, of Shymplyng, esq 0
3837109 1969508 1969508 defendant Tebold John yeoman 587745 587745 Tebold, John, of Shymplyng, yeoman 0
3846555 1972479 1972479 defendant Tebold John husbandman 587745 587745 Tebold, John, of Shymplyng, husbandman 3
3853825 1974829 1974829 defendant Corder Thomas husbandman 587745 587745 Corder, Thomas, of Shymplyng, husbandman 0
3867613 1979402 1979402 defendant Aldham John   587745 587745 Aldham, John, of Shymplyng 0
3874195 1981593 1981593 defendant Marteyn Thomas husbandman 587745 587745 Marteyn, Thomas, of Shymplyng, husbandman 0
3881716 1984135 1984135 defendant Crane Thomas pedder 587745 587745 Crane, Thomas, of Shymplyng, pedder 0
3898186 1989599 1989599 plaintiff Aldam John   587745 587745 Aldam, John, of Shymplyng 2
3901493 1990723 1990723 defendant Coppyng John husbandman 587745 587745 Coppyng, John, of Shymplyng, husbandman 1
3902374 1991025 1991025 defendant Hamsell John (legal representative) 587745 587745 Hamsell, John, of Shymplyng, husbandman, executor of 0
3927157 1999418 1999418 plaintiff Aldeham John   587745 587745 Aldeham, John, of Shymplyng 0
3943186 2004740 2004740 plaintiff Aldham John gent 587745 587745 Aldham, John, of Shymplyng, gent 0
3953529 2008306 2008306 defendant Aldred John clothier 587745 587745 Aldred, John, of Shymplyng, yeoman, or of Long Melford, clothier 0
3953533 2008307 2008307 defendant Aldred John clothier 587745 587745 Aldred, John, of Shymplyng, yeoman, or of Long Melford, clothier 0
3994155 2022660 2022660 defendant Tebold Henry yeoman 587745 587745 Tebold, Henry, of Shymplyng, yeoman 0
3994163 2022663 2022663 defendant Tebold Henry yeoman 587745 587745 Tebold, Henry, of Shymplyng, yeoman 0
4014579 2029935 2029935 defendant Tebolde Henry yeoman 587745 587745 Tebolde, Henry, of Shymplyng, yeoman 1
4017558 2030986 2030986 defendant Hatton John husbandman 587745 587745 Hatton, John, of Shymplyng, husbandman 0
4203471 2096767 2096767 defendant Luffkyn William clerk 587745 587745 Luffkyn, William, of Shymplyng, clerk 0
4442971 2182764 2182764 plaintiff Caly Roger   587745 587745 Caly, Roger, of Shymplyng 0
4443595 2182964 2182964 plaintiff Cayly Roger   587745 587745 Cayly, Roger, of Shymplyng 0
4546247 2214769 2214769 defendant Caly John   587745 587745 Caly, John, of Shymplyng 2
4546248 2214769 2214769 defendant Huberd William   587745 587745 Huberd, William, of Shymplyng 3
4565052 2220638 2220638 defendant Calie William   587745 587745 Calie, William, of Shymplyng, son of Roger 0
4565054 2220639 2220639 defendant Calne William   587745 587745 Calne, William, of Shymplyng, son of Roger 0
4599843 2231179 2231179 defendant Calye John   587745 587745 Calye, John, of Shymplyng 0
4627513 2239537 2239537 defendant Waryn John   587745 587745 Waryn, John, of Shymplyng 1
4634279 2241563 2241563 defendant Shymplyng William   587745 587745 Shymplyng, William, of Shymplyng 0
4639213 2242988 2242988 defendant Smyth William   587745 587745 Smyth, William, of Shymplyng 0
4654623 2247327 2247327 defendant Shymplyng William yeoman 587745 587745 Shymplyng, William, of Shymplyng, yeoman 0
4669414 2256142 2256142 defendant Shymplyng William   587745 587745 Shymplyng, William, of Shymplyng, franklin 1
4672425 2257028 2257028 defendant Hoberd William   587745 587745 Hoberd, William, of Shymplyng, husbandman, son of William 1
4676303 2258199 2258199 defendant Weyneld Simon, junior baker 587745 587745 Weyneld, Simon, junior, of Shymplyng, wedewere or widower, Hoket, John, of Melford, baker 2
4677394 2258546 2258546 defendant Bory Alice spinner 587745 587745 Bory, Alice, of Shymplyng, spinner 4
4677401 2258548 2258548 defendant Parker Nicholas yeoman 587745 587745 Parker, Nicholas, of Shymplyng, yeoman 0
4735271 2276178 2276178 defendant Barell John husbandman 587745 587745 Barell, John, of Shymplyng, husbandman 2
4748785 2280130 2280130 defendant Gyssyng Robert husbandman 587745 587745 Gyssyng, Robert, of Shymplyng, husbandman 0
4758747 2283091 2283091 defendant Batayle Thomas yeoman 587745 587745 Batayle, Thomas, of Shymplyng, yeoman 3
4758748 2283091 2283091 defendant Whatlok Robert farmer 587745 587745 Whatlok, Robert, of Shymplyng, farmer 4
4768460 2286110 2286110 defendant Halle John yeoman 587745 587745 Halle, John, of Shymplyng, yeoman 1
4795694 2294805 2294805 defendant Derlyng Thomas yeoman 587745 587745 Derlyng, Thomas, of Shymplyng, yeoman 2
4795695 2294805 2294805 defendant Pryk John yeoman 587745 587745 Pryk, John, of Shymplyng, yeoman 3
4805631 2297970 2297970 defendant Lord Robert husbandman 587745 587745 Lord, Robert, of Shymplyng, husbandman 0
4854690 2312834 2312834 defendant Podeney Richard husbandman 587745 587745 Podeney, Richard, of Shymplyng, husbandman 1
4854733 2312840 2312840 defendant Podeney Richard husbandman 587745 587745 Podeney, Richard, of Shymplyng, husbandman 1
4854782 2312847 2312847 defendant Batell Thomas husbandman 587745 587745 Batell, Thomas, of Shymplyng, husbandman 1
4862457 2315255 2315255 defendant Gyssyng Robert husbandman 587745 587745 Gyssyng, Robert, of Shymplyng, husbandman 4
4896525 2325584 2325584 defendant Batayll Thomas   587745 587745 Batayll, Thomas, of Shymplyng 0
4934869 2337307 2337307 defendant Batayle Thomas yeoman 587745 587745 Batayle, Thomas, of Shymplyng, yeoman 4
4977140 2350118 2350118 plaintiff Plummer Nicholas   587745 587745 Plummer, Nicholas, of Shymplyng 0
4995101 2355392 2355392 defendant Plummer Nicholas butcher 587745 587745 Plummer, Nicholas, of Shymplyng, butcher 0
5070628 2377713 2377713 defendant Busshop John gent 587745 587745 Busshop, John, of Shymplyng, gent 0
5095194 2385010 2385010 defendant Busshop John gent 587745 587745 Busshop, John, of Shymplyng, gent 0
5105496 2388053 2388053 defendant Craske Robert clerk 587745 587745 Craske, Robert, of Shymplyng, clerk 0
5135259 2396811 2396811 plaintiff Marchaunt Richard   587745 587745 (Marchaunt, Richard, of Shymplyng 1
5135260 2396811 2396811 plaintiff Cok John   587745 587745 Cok, John, of Shymplyng 2
5155397 2402730 2402730 plaintiff Marchaunt Richard   587745 587745 (Marchaunt, Richard, of Shymplyng 1
5155398 2402730 2402730 plaintiff Cok John   587745 587745 Cok, John, of Shymplyng 2

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