names

93 rows where place_id = 599886

✎ 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
3638666 1906906 1906906 defendant Danyell William (legal representative) 599886 599886 Danyell, William, of Cosham, executors of 0
3638667 1906906 1906906 defendant Hulker John husbandman 599886 599886 (Hulker, John, of Cosham, husbandman 1
3648647 1909963 1909963 defendant Frenche William tailor 599886 599886 Frenche, William, of Cosham, tailor 0
3648650 1909964 1909964 defendant Frenche William tailor 599886 599886 Frenche, William, of Cosham, tailor 0
3677445 1918998 1918998 defendant Mytton John husbandman 599886 599886 Mytton, John, of Cosham, husbandman 0
3706013 1928172 1928172 defendant Hulberd John, junior husbandman 599886 599886 Hulberd, John, junior, of Cosham, husbandman 0
3731547 1936092 1936092 defendant Butler Nicholas husbandman 599886 599886 Butler, Nicholas, of Cosham, husbandman 0
3768828 1947897 1947897 defendant Hull Ralph smith 599886 599886 Hull, Ralph, of Cosham, smith 2
3771684 1948843 1948843 defendant Long William butcher 599886 599886 Long, William, of Cosham, butcher 0
3791446 1955162 1955162 defendant Smyth Philip, junior clothier 599886 599886 Smyth, Philip, junior, of Cosham, clothier 0
3792199 1955413 1955413 defendant Nowell Richard husbandman 599886 599886 Nowell, Richard, of Cosham, husbandman 0
3817265 1963311 1963311 defendant Nowell John husbandman 599886 599886 Nowell, John, of Cosham, husbandman 0
3820398 1964259 1964259 defendant Carpynter William husbandman 599886 599886 Carpynter, William, of Cosham, husbandman 1
3822694 1965000 1965000 defendant Holbred John clothier 599886 599886 Holbred, John, of Cosham, clothier 0
3884229 1984989 1984989 defendant Nowell John butcher 599886 599886 Nowell, John, of Cosham, butcher 3
3899719 1990120 1990120 plaintiff Bonham John   599886 599886 Bonham, John, of Cosham 0
3989897 2021141 2021141 plaintiff Baylye Joan single woman 599886 599886 Baylye, Joan, of Cosham, single woman 0
4336503 2142502 2142502 defendant Keynes William yeoman 599886 599886 Keynes, William, of Cosham, yeoman 0
4372311 2155161 2155161 defendant Hall William yeoman 599886 599886 Hall, William, of Cosham, yeoman 0
4400261 2164679 2164679 defendant Hall William yeoman 599886 599886 Hall, William, of Cosham, yeoman 0
4492089 2198216 2198216 defendant Craan Richard tailor 599886 599886 Craan, Richard, of Cosham, tailor 0
4530937 2209967 2209967 defendant Smyth Simon   599886 599886 (Smyth, Simon, of Cosham 1
4602520 2232005 2232005 defendant Averay John   599886 599886 Averay, John, of Cosham 1
4645361 2244715 2244715 defendant Jope John smith 599886 599886 Jope, John, of Cosham, smith 0
4668125 2255739 2255739 plaintiff Baret Simon   599886 599886 Baret, Simon, of Cosham 0
4687458 2261671 2261671 defendant Peyntour John yeoman 599886 599886 Peyntour, John, of Cosham, yeoman 0
4687460 2261672 2261672 defendant Peyntour John yeoman 599886 599886 Peyntour, John, of Cosham, yeoman 0
4703360 2266429 2266429 defendant Torreman John, sen husbandman 599886 599886 Torreman, John, sen, of Cosham, husbandman 2
4718660 2271176 2271176 defendant Shop Joan   599886 599886 Shop, Joan, of Cosham, widow, formerly wife of William 0
4724562 2272979 2272979 defendant Chubbe Thomas laborer 599886 599886 Chubbe, Thomas, of Cosham, laborer 0
4724563 2272979 2272979 defendant atte Mere Gilbert laborer 599886 599886 atte Mere, Gilbert, of Cosham, laborer 1
4753454 2281457 2281457 defendant North Richard yeoman 599886 599886 North, Richard, of Cosham, yeoman 0
4796221 2294967 2294967 defendant Doke Andrew husbandman 599886 599886 Doke, Andrew, of Cosham, husbandman 0
4798973 2295851 2295851 defendant Catour William fisher 599886 599886 Catour, William, of Cosham, fisher 2
4798974 2295851 2295851 defendant Mason William clerk 599886 599886 Mason, William, of Cosham, clerk 3
4816741 2301333 2301333 defendant Hore Robert husbandman 599886 599886 Hore, Robert, of Cosham, husbandman 0
4816742 2301333 2301333 defendant Hore William   599886 599886 Hore, William, of Cosham, mason, Brode, William, of Cosham, mason 1
4816743 2301333 2301333 defendant Parker William parker 599886 599886 Parker, William, of Cosham, parker 2
4836346 2307343 2307343 defendant Hore William   599886 599886 Hore, William, of Cosham, mason 1
4836347 2307343 2307343 defendant Harper John weaver 599886 599886 Harper, John, of Cosham, weaver 2
4836358 2307345 2307345 defendant Spycer John weaver 599886 599886 Spycer, John, of Cosham, weaver 4
4851460 2311902 2311902 defendant Bey John husbandman 599886 599886 Bey, John, of Cosham, husbandman 0
4868536 2317133 2317133 defendant Spycer John weaver 599886 599886 Spycer, John, of Cosham, weaver 4
4868548 2317138 2317138 defendant Hore William   599886 599886 together with Hore, William, of Cosham, mason 1
4868549 2317138 2317138 defendant Harper John weaver 599886 599886 Harper, John, of Cosham, weaver 2
4872531 2318368 2318368 defendant Baly Robert chaplain 599886 599886 Baly, Robert, of Cosham, chaplain 0
4872536 2318368 2318368 defendant Hore William   599886 599886 Hore, William, of Cosham, mason 5
4872537 2318368 2318368 defendant Mason Thomas   599886 599886 Mason, Thomas, of Cosham, mason 6
4872538 2318368 2318368 defendant Mason John   599886 599886 Mason, John, of Cosham, mason 7
4872540 2318369 2318369 defendant Duyk John   599886 599886 Duyk, John, of Cosham, mason 0
4872541 2318369 2318369 defendant Duyk Walter laborer 599886 599886 Duyk, Walter, of Cosham, laborer 1
4872542 2318369 2318369 defendant Danyell Nicholas husbandman 599886 599886 Danyell, Nicholas, of Cosham, husbandman 2
4872543 2318369 2318369 defendant Danyell William laborer 599886 599886 Danyell, William, of Cosham, laborer 3
4872544 2318369 2318369 defendant Gybbys William husbandman 599886 599886 Gybbys, William, of Cosham, husbandman 4
4882616 2321475 2321475 defendant Hore William   599886 599886 Hore, William, of Cosham, mason 0
4886305 2322576 2322576 defendant Carter Richard   599886 599886 Carter, Richard, of Cosham, parish clerk 3
4887361 2322882 2322882 defendant Spicer John weaver 599886 599886 Spicer, John, of Cosham, weaver 0
4889572 2323534 2323534 defendant Baldewyn Thomas husbandman 599886 599886 Baldewyn, Thomas, of Cosham, husbandman 0
4899115 2326365 2326365 defendant Wymer Thomas   599886 599886 Wymer, Thomas, of Cosham, mason 0
4905813 2328421 2328421 defendant Wynter Thomas   599886 599886 Wynter, Thomas, of Cosham, mason 0
4906677 2328674 2328674 defendant Neweman John husbandman 599886 599886 Neweman, John, of Cosham, husbandman 0
4906678 2328674 2328674 defendant Yatton John husbandman 599886 599886 Yatton, John, of Cosham, husbandman 1
4924565 2334118 2334118 defendant Spicer John weaver 599886 599886 Spicer, John, of Cosham, weaver 0
4934774 2337273 2337273 defendant Pyppyng John husbandman 599886 599886 Pyppyng, John, of Cosham, husbandman 0
4939755 2338820 2338820 defendant Artur William   599886 599886 Artur, William, of Cosham, servant 0
4945780 2340668 2340668 defendant Kyng John   599886 599886 Kyng, John, of Cosham, bailiff 0
4949754 2341914 2341914 defendant Spicer John weaver 599886 599886 Spicer, John, of Cosham, weaver 0
4952131 2342606 2342606 plaintiff Hancok John   599886 599886 Hancok, John, of Cosham 2
4975854 2349742 2349742 defendant Spicer John, senior husbandman 599886 599886 Spicer, John, senior, of Cosham, husbandman 0
4975855 2349742 2349742 defendant Spicer John, junior husbandman 599886 599886 Spicer, John, junior, of Cosham, husbandman 1
4984040 2352159 2352159 defendant Baldewyn Thomas husbandman 599886 599886 Baldewyn, Thomas, of Cosham, husbandman 0
4989097 2353675 2353675 defendant Duke Walter husbandman 599886 599886 Duke, Walter, of Cosham, husbandman 2
5016255 2361642 2361642 defendant Buryman John   599886 599886 Buryman, John, of Cosham, mason 0
5086134 2382339 2382339 defendant Page William   599886 599886 Page, William, of Cosham, franklin 3
5088616 2383047 2383047 defendant Adulham William husbandman 599886 599886 Adulham, William, of Cosham, husbandman 1
5097969 2385836 2385836 defendant Mey alias Clerk John, junior husbandman 599886 599886 Mey alias Clerk, John, junior, of Cosham, husbandman 0
5097971 2385836 2385836 defendant Mey Joan widow 599886 599886 Mey, Joan, of Cosham, widow 2
5106778 2388408 2388408 defendant Webbe Thomas chaplain 599886 599886 Webbe, Thomas, of Cosham, chaplain 2
5141078 2398513 2398513 defendant Carnesed John, senior husbandman 599886 599886 Carnesed, John, senior, of Cosham, husbandman 0
5200254 2415835 2415835 defendant Mason William husbandman 599886 599886 Mason, William, of Cosham, husbandman 0
5200255 2415835 2415835 defendant Duke John husbandman 599886 599886 Duke, John, of Cosham, husbandman 1
5200256 2415835 2415835 defendant Boyes John, sen husbandman 599886 599886 Boyes, John, sen, of Cosham, husbandman 2
5200257 2415835 2415835 defendant Bartelot Richard butcher 599886 599886 Bartelot, Richard, of Cosham, butcher 3
5210537 2418818 2418818 defendant Caynes John, sen husbandman 599886 599886 Caynes, John, sen, of Cosham, husbandman 0
5256838 2432268 2432268 defendant Notte John gent 599886 599886 Notte, John, of Cosham, gent 0
5305155 2446548 2446548 defendant Champion William husbandman 599886 599886 Champion, William, of Cosham, husbandman 0
5561366 2523302 2523302 defendant Hancok William butcher 599886 599886 Hancok, William, of Cosham, butcher 2
5610205 2546906 2546906 plaintiff atte Putte Richard   599886 599886 atte Putte, Richard, of Cosham 0
5610206 2546906 2546906 defendant Galekmonger John   599886 599886 Galekmonger, John, of Cosham, son of Roger 0
5611009 2547161 2547161 defendant Hayward John (legal representative) 599886 599886 Hayward, John, of Cosham, executors of 0
5627297 2552505 2552505 defendant Russell Richard husbandman 599886 599886 Russell, Richard, of Cosham, husbandman 0
5630194 2553449 2553449 defendant Russell Richard, senior husbandman 599886 599886 Russell, Richard, senior, of Cosham, husbandman 0
5631411 2553826 2553826 defendant Smyth William smith 599886 599886 Smyth, William, of Cosham, smith 1

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