names

209 rows where place_id = 589013

✎ 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
3596267 1866461 1866461 defendant Blekelyng Leonard clerk 589013 589013 Blekelyng, Leonard, of Bury, clerk 0
3629136 1903985 1903985 plaintiff Copynger Walter (legal representative) 589013 589013 Copynger, Walter, of Bury, clothmaker, executor of 0
3629140 1903986 1903986 plaintiff Copynger Walter (legal representative) 589013 589013 Copynger, Walter, of Bury, clothmaker, executor of 0
3634727 1905656 1905656 plaintiff Moryell John   589013 589013 Moryell, John, of Bury 0
3669583 1916423 1916423 plaintiff Blakman Robert mercer 589013 589013 Blakman, Robert, of Bury, mercer 0
3689090 1922748 1922748 plaintiff Eden Thomas gent 589013 589013 Eden, Thomas, of Bury, gent 0
3716199 1931360 1931360 plaintiff Clere Thomas (legal representative) 589013 589013 Clere, Thomas, of Bury, mercer, executors of 0
3723034 1933473 1933473 defendant Morrys John (legal representative) 589013 589013 Morrys, John, of Bury Nerber, executors of 0
3723036 1933473 1933473 defendant Morrys Christine widow 589013 589013 Morrys, Christine, of Bury Nerber, widow 2
3738913 1938376 1938376 defendant Morrys John (legal representative) 589013 589013 Morrys, John, of Bury Nerber, executrix of 0
3738914 1938376 1938376 defendant Morrys Christine widow 589013 589013 Morrys, Christine, of Bury Nerber, widow 1
3761478 1945601 1945601 defendant Hogeson William yeoman 589013 589013 Hogeson, William, of Bury, yeoman 2
3764765 1946645 1946645 defendant Pyper Thomas yeoman 589013 589013 Pyper, Thomas, of Bury, yeoman 0
3767839 1947579 1947579 defendant Morys John (legal representative) 589013 589013 Morys, John, of Bury Nerber, executor of 0
3767840 1947579 1947579 defendant Morys William husbandman 589013 589013 Morys, William, of Bury Nerber, husbandman 1
3782070 1952146 1952146 plaintiff Hogg John mercer 589013 589013 Hogg, John, of Bury, mercer 0
3796532 1956789 1956789 plaintiff Evanson Thomas bowyer 589013 589013 Evanson, Thomas, of Bury, bowyer 0
3821736 1964684 1964684 plaintiff Sharpe Robert chandler 589013 589013 Sharpe, Robert, of Bury, chandler 0
3833788 1968500 1968500 plaintiff Maas William (legal representative) 589013 589013 Maas, William, of Bury, parchment maker, executor of 0
3833791 1968501 1968501 plaintiff Maas William (legal representative) 589013 589013 Maas, William, of Bury, parchment maker, executor of 0
3848483 1973106 1973106 defendant Baker Robert clothmaker 589013 589013 Baker, Robert, of Bury, clothmaker 0
3863731 1978050 1978050 defendant Baker Robert clothmaker 589013 589013 Baker, Robert, of Bury, clothmaker 0
3868212 1979603 1979603 plaintiff Stede John   589013 589013 Stede, John, of Bury 0
3876191 1982282 1982282 defendant Rood John clothmaker 589013 589013 Rood, John, of Bury, clothmaker 2
3880397 1983700 1983700 plaintiff Poley William gent 589013 589013 Poley, William, of Bury, gent 0
3890191 1986960 1986960 plaintiff Hayward Katherine widow 589013 589013 Hayward, Katherine, of Bury, widow 0
3902357 1991021 1991021 plaintiff Dunstroppe alias Erwyn William goldsmith 589013 589013 Dunstroppe alias Erwyn, William ,of Bury, goldsmith 0
3907754 1992878 1992878 plaintiff Andrewes Thomas yeoman 589013 589013 (Andrewes, Thomas, of Bury, yeoman 1
3907755 1992878 1992878 plaintiff Chesten William tanner 589013 589013 Chesten, William, of Bury, tanner 2
3910290 1993759 1993759 plaintiff Tassell William gent 589013 589013 Tassell, William, of Bury, gent 0
3929506 2000217 2000217 plaintiff Cage Thomas clothier 589013 589013 Cage, Thomas, of Bury, clothier 0
3930554 2000562 2000562 defendant Sawnder Edward husbandman 589013 589013 Sawnder, Edward, of Bury, husbandman 1
3945953 2005662 2005662 plaintiff Browse Thomas sherman 589013 589013 Browse, Thomas, of Bury, sherman 0
3961374 2011073 2011073 defendant Wetheridge John husbandman 589013 589013 Wetheridge, John, of Bury Narber, husbandman 0
4020102 2031912 2031912 plaintiff Whight John mercer 589013 589013 Whight, John, of Bury, mercer 0
4033628 2036677 2036677 plaintiff Grome Robert gent 589013 589013 Grome, Robert, of Bury, gent 0
4058620 2045472 2045472 defendant Hyggens Edward gent 589013 589013 Hyggens, Edward, of Bury, gent 1
4066317 2048242 2048242 defendant Frevell Jasper gent 589013 589013 Frevell, Jasper, of Bury, gent 3
4374010 2155775 2155775 defendant Harmewood Richard   589013 589013 Harmewood, Richard, of Bury, laborer, "wareburner" 1
4439373 2181582 2181582 defendant Nurfere Andrew   589013 589013 Nurfere, Andrew, of Bury 1
4442639 2182647 2182647 defendant Drankes Richard   589013 589013 Drankes, Richard, of Bury 2
4444484 2183255 2183255 plaintiff Cokes Roger   589013 589013 Cokes, Roger, of Bury 0
4444485 2183255 2183255 defendant Danniel Robert   589013 589013 Danniel, Robert, of Bury 0
4446624 2183860 2183860 defendant Pursere Andrew   589013 589013 Pursere, Andrew, of Bury 1
4447469 2184121 2184121 defendant Tylere Thomas   589013 589013 Tylere, Thomas, of Bury 0
4449218 2184704 2184704 defendant Clerk John   589013 589013 Clerk, John, of Bury 0
4449221 2184705 2184705 defendant Barbour Rciahrd   589013 589013 Barbour, Rciahrd, of Bury 1
4454255 2186349 2186349 defendant Gent Robert mercer 589013 589013 Gent, Robert, of Bury, mercer 0
4455631 2186771 2186771 defendant Goderd Thomas   589013 589013 Goderd, Thomas, of Bury 3
4455733 2186804 2186804 defendant Bury John de   589013 589013 Bury, John de, of Bury 0
4455735 2186805 2186805 defendant Bury John de   589013 589013 Bury, John de, of Bury 0
4455754 2186814 2186814 defendant Bury John de   589013 589013 Bury, John de, of Bury 0
4455756 2186815 2186815 defendant Bury John de   589013 589013 Bury, John de, of Bury 0
4459399 2187991 2187991 defendant Herdeman Thomas   589013 589013 Herdeman, Thomas, of Bury 1
4459404 2187992 2187992 defendant Herdeman Thomas   589013 589013 Herdeman, Thomas, of Bury 1
4460163 2188236 2188236 defendant Gryffyn Nicholas   589013 589013 Gryffyn, Nicholas, of Bury 1
4463660 2189333 2189333 defendant Auncell Robert   589013 589013 Auncell, Robert, of Bury 2
4463666 2189333 2189333 defendant Taverner Edmund   589013 589013 Taverner, Edmund, of Bury 8
4463672 2189334 2189334 defendant Auncell Robert   589013 589013 Auncell, Robert, of Bury 2
4463678 2189334 2189334 defendant Taverner Edmund   589013 589013 Taverner, Edmund, of Bury 8
4463759 2189348 2189348 defendant Auncell Robert   589013 589013 Auncell, Robert, of Bury 2
4463765 2189348 2189348 defendant Taverner Edmund   589013 589013 Taverner, Edmund, of Bury 8
4469040 2190984 2190984 defendant Lucas Edmund   589013 589013 Lucas, Edmund, of Bury 0
4469657 2191177 2191177 plaintiff Bote Thomas   589013 589013 Bote, Thomas, of Bury 0
4470082 2191293 2191293 defendant Clerk Thomas   589013 589013 Clerk, Thomas, of Bury, belyetere or bell founder 0
4473194 2192279 2192279 defendant Dale John woodman 589013 589013 Dale, John, of Bury, woodman 1
4477196 2193535 2193535 defendant Sharp William taverner 589013 589013 Sharp, William, of Bury, taverner 0
4478628 2193981 2193981 defendant Bate John   589013 589013 Bate, John, of Bury, mason 0
4492693 2198416 2198416 defendant Waterward Adam   589013 589013 Waterward, Adam, of Bury 1
4493865 2198774 2198774 defendant Botre Robert   589013 589013 Botre, Robert, of Bury 2
4494053 2198827 2198827 plaintiff Alfred Richard   589013 589013 Alfred, Richard, of Bury, on his own account 1
4494067 2198833 2198833 plaintiff Berton Henry   589013 589013 Berton, Henry, of Bury, on his own account 0
4494068 2198833 2198833 defendant Whetebred John chaplain 589013 589013 Whetebred, John, of Bury, chaplain 0
4494069 2198834 2198834 plaintiff Berton Henry   589013 589013 Berton, Henry, of Bury, on his own account 0
4494070 2198834 2198834 defendant Whetebred John chaplain 589013 589013 Whetebred, John, of Bury, chaplain 0
4495042 2199140 2199140 defendant Bolneye William   589013 589013 Bolneye, William, of bury 3
4501430 2201051 2201051 defendant Taverner Richard   589013 589013 Taverner, Richard, of Bury 1
4510188 2203672 2203672 defendant Nicole Thomas   589013 589013 Nicole, Thomas, of Bury 0
4515416 2205236 2205236 plaintiff Messenger John   589013 589013 Messenger, John, of Bury, parson 2
4525775 2208365 2208365 defendant Tylere William   589013 589013 Tylere, William, of Bury 2
4525780 2208366 2208366 defendant Tylere William   589013 589013 Tylere, William, of Bury 2
4525909 2208403 2208403 defendant Lystere Nicholas   589013 589013 Lystere, Nicholas, of Bury 0
4526079 2208453 2208453 defendant Lystere Nicholas   589013 589013 Lystere, Nicholas, of Bury 0
4526675 2208624 2208624 defendant Bollemaker Thomas   589013 589013 Bollemaker, Thomas, of Bury 0
4533186 2210644 2210644 defendant Bonecold John   589013 589013 Bonecold, John, of Bury 6
4533189 2210644 2210644 defendant Ormesby Agnes chandler 589013 589013 Ormesby, Agnes, of Bury, chandler 9
4533190 2210644 2210644 defendant Threisshere Thomas   589013 589013 Threisshere, Thomas, of Bury 10
4533191 2210644 2210644 defendant Redere William   589013 589013 Redere, William, of Bury 11
4533192 2210644 2210644 defendant Redere John   589013 589013 Redere, John, of Bury, servant of William 12
4543523 2213864 2213864 plaintiff atte Mille Edmund shoemaker 589013 589013 atte Mille, Edmund, of Bury, shoemaker 0
4543525 2213865 2213865 plaintiff atte Mille Edmund shoemaker 589013 589013 atte Mille, Edmund, of Bury, shoemaker 0
4548576 2215493 2215493 defendant Brigges John   589013 589013 Brigges, John, of Bury 0
4548822 2215568 2215568 defendant Turgys Robert   589013 589013 Turgys, Robert, of Bury 1
4548828 2215569 2215569 defendant Turgys Robert   589013 589013 Turgys, Robert, of Bury 1
4550641 2216143 2216143 defendant Taverner Edmund   589013 589013 Taverner, Edmund, of Bury 0
4554860 2217447 2217447 defendant Welles Maud de   589013 589013 Welles, Maud de, of Bury 3
4554869 2217450 2217450 defendant Wellles Maud de   589013 589013 Wellles, Maud de, of Bury 3
4555051 2217507 2217507 plaintiff Hauk John   589013 589013 Hauk, John, of Bury 0
4559883 2219043 2219043 defendant Ratlesdene John   589013 589013 Ratlesdene, John, of Bury, mason 0
4581963 2225804 2225804 defendant Skynnere John   589013 589013 Skynnere, John, of Bury 4

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