names

100 rows where place_id = 586338

✎ 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
3588458 1864037 1864037 defendant Carles John husbandman 586338 586338 Carles, John, of Tadyngton, husbandman 0
3606886 1869818 1869818 defendant Drane Stephen yeoman 586338 586338 Drane, Stephen, of Tadyngton, yeoman 0
3616521 1872804 1872804 plaintiff Drane Stephen   586338 586338 Drane, Stephen, of Tadyngton 0
3632290 1904918 1904918 defendant Carles John husbandman 586338 586338 Carles, John, of Tadyngton, husbandman 0
3633135 1905175 1905175 defendant Hogges Roger husbandman 586338 586338 Hogges, Roger, of Tadyngton, husbandman 0
3643004 1908259 1908259 defendant Phelpottys William husbandman 586338 586338 Phelpottys, William, of Tadyngton, husbandman 3
3644577 1908719 1908719 defendant Carleys Thomas yeoman 586338 586338 Carleys, Thomas, of Tadyngton, yeoman 0
3644587 1908720 1908720 defendant Carleys Thomas yeoman 586338 586338 Carleys, Thomas, of Tadyngton, yeoman 0
3644602 1908722 1908722 defendant Earleys Thomas yeoman 586338 586338 Earleys, Thomas, of Tadyngton, yeoman 0
3652742 1911177 1911177 defendant Warner Robert husbandman 586338 586338 Warner, Robert, of Tadyngton, husbandman 4
3658930 1913055 1913055 defendant Newton John husbandman 586338 586338 Newton, John, of Tadyngton, husbandman 0
3658931 1913055 1913055 defendant Newton William laborer 586338 586338 Newton, William, of Tadyngton, laborer 1
3668745 1916159 1916159 defendant Phelpotte William husbandman 586338 586338 Phelpotte, William, of Tadyngton, husbandman 0
3674922 1918186 1918186 defendant Hanlyns Thomas husbandman 586338 586338 Hanlyns, Thomas, of Tadyngton, husbandman 0
3679530 1919667 1919667 defendant Hawlyns Thomas, junior husbandman 586338 586338 Hawlyns, Thomas, junior, of Tadyngton, husbandman 3
3693095 1924047 1924047 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 0
3694041 1924341 1924341 defendant Garold Richard husbandman 586338 586338 Garold, Richard, of Tadyngton, husbandman 0
3694042 1924341 1924341 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 1
3695202 1924720 1924720 defendant Hogge Richard husbandman 586338 586338 Hogge, Richard, of Tadyngton, husbandman 3
3700701 1926470 1926470 defendant Cook Thomas husbandman 586338 586338 Cook, Thomas, of Tadyngton, husbandman 0
3701328 1926660 1926660 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 0
3701329 1926660 1926660 defendant Hawlyns Thomas husbandman 586338 586338 Hawlyns, Thomas, of Tadyngton, husbandman 1
3701333 1926661 1926661 defendant Garold Richard husbandman 586338 586338 Garold, Richard, of Tadyngton, husbandman 0
3718037 1931936 1931936 defendant Garold Richard husbandman 586338 586338 Garold, Richard, of Tadyngton, husbandman 0
3730165 1935660 1935660 defendant Philpottys John clerk 586338 586338 Philpottys, John, of Tadyngton, clerk 0
3730166 1935660 1935660 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 1
3734472 1937026 1937026 defendant Hoggys Elizabeth widow 586338 586338 Hoggys, Elizabeth, of Tadyngton, widow 0
3734473 1937026 1937026 defendant Turnour Nicholas husbandman 586338 586338 Turnour, Nicholas, of Tadyngton, husbandman 1
3734475 1937026 1937026 defendant Ravynhyll John husbandman 586338 586338 Ravynhyll, John, of Tadyngton, husbandman 3
3752004 1942549 1942549 defendant Hereford John husbandman 586338 586338 Hereford, John, of Tadyngton, husbandman 0
3755212 1943583 1943583 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 0
3770968 1948605 1948605 defendant Phelpottys William husbandman 586338 586338 Phelpottys, William, of Tadyngton, husbandman 0
3786253 1953498 1953498 defendant A Norbery John husbandman 586338 586338 A Norbery, John, of Tadyngton, husbandman 1
3786254 1953498 1953498 defendant Godsalf Richard husbandman 586338 586338 Godsalf, Richard, of Tadyngton, husbandman 2
3786255 1953498 1953498 defendant Richard Ralph laborer 586338 586338 Richard, Ralph, of Tadyngton, laborer 3
3786256 1953498 1953498 defendant Hogyes William husbandman 586338 586338 Hogyes, William, of Tadyngton, husbandman 4
3786265 1953500 1953500 defendant Herford John husbandman 586338 586338 Herford, John, of Tadyngton, husbandman 1
3786266 1953500 1953500 defendant Tayler William laborer 586338 586338 Tayler, William, of Tadyngton, laborer 2
3798881 1957566 1957566 defendant Tayllour William laborer 586338 586338 Tayllour, William, of Tadyngton, laborer 0
3798882 1957566 1957566 defendant Tayllour Margaret spinster 586338 586338 Tayllour, Margaret, of Tadyngton, spinster 1
3798883 1957566 1957566 defendant Monmothe Richard laborer 586338 586338 Monmothe, Richard, of Tadyngton, laborer 2
3802636 1958720 1958720 defendant Spycer Walter yeoman 586338 586338 Spycer, Walter, of Tadyngton, yeoman 0
3844911 1971951 1971951 defendant Bell John   586338 586338 Bell, John, of Tadyngton, pedlar 1
3844912 1971951 1971951 defendant Wilson Richard   586338 586338 Wilson, Richard, of Tadyngton, pedlar 2
3849159 1973333 1973333 defendant Feld William yeoman 586338 586338 Feld, William, of Tadyngton, yeoman 0
3849160 1973333 1973333 defendant Feld Thomas laborer 586338 586338 Feld, Thomas, of Tadyngton, laborer 1
3849161 1973333 1973333 defendant Powdras John husbandman 586338 586338 Powdras, John, of Tadyngton, husbandman 2
3849163 1973334 1973334 defendant Pewdras John husbandman 586338 586338 Pewdras, John, of Tadyngton, husbandman 0
3849164 1973334 1973334 defendant Feld William yeoman 586338 586338 Feld, William, of Tadyngton, yeoman 1
3849165 1973334 1973334 defendant Feld Thomas laborer 586338 586338 Feld, Thomas, of Tadyngton, laborer 2
3858984 1976498 1976498 defendant Morley Richard husbandman 586338 586338 Morley, Richard, of Tadyngton, husbandman 0
3858985 1976498 1976498 defendant Powydres William husbandman 586338 586338 Powydres, William, of Tadyngton, husbandman 1
3858986 1976498 1976498 defendant Hogge Thomas husbandman 586338 586338 Hogge, Thomas, of Tadyngton, husbandman 2
3900031 1990230 1990230 defendant Broke Richard wheeler 586338 586338 Broke, Richard, of Tadyngton, wheeler 1
3999733 2024663 2024663 defendant Morley Peter husbandman 586338 586338 Morley, Peter, of Tadyngton, husbandman 5
4058950 2045596 2045596 defendant Morley Peter husbandman 586338 586338 Morley, Peter, of Tadyngton, husbandman 0
4070029 2049569 2049569 defendant Godshall or Agodsowe John yeoman 586338 586338 Godshall or Agodsowe, John, of Tadyngton, yeoman 1
4293400 2127702 2127702 defendant Hawle Robert miner 586338 586338 Hawle, Robert, of Tadyngton, miner 1
4360772 2151024 2151024 defendant Hodge John miner 586338 586338 Hodge, John, of Tadyngton, miner 1
4386655 2160212 2160212 defendant Gillam Edward gent 586338 586338 Gillam, Edward, of Tadyngton, gent 2
4451938 2185590 2185590 defendant Cay Henry   586338 586338 Cay, Henry, of Tadyngton 2
4465847 2189986 2189986 defendant Hope John de   586338 586338 Hope, John de, of Tadyngton 1
4578385 2224728 2224728 defendant Roland Roger de   586338 586338 Roland, Roger de, of Tadyngton 0
4701629 2265902 2265902 defendant Rogerson Wilkson John husbandman 586338 586338 Rogerson Wilkson, John, of Tadyngton, husbandman 0
4769792 2286525 2286525 defendant Brompton Henry husbandman 586338 586338 Brompton, Henry, of Tadyngton, husbandman 1
4789567 2292808 2292808 defendant Brampton Henry husbandman 586338 586338 Brampton, Henry, of Tadyngton, husbandman 0
4847264 2310645 2310645 defendant Aylmere John husbandman 586338 586338 Aylmere, John, of Tadyngton, husbandman 0
4848418 2310979 2310979 defendant Elysson Jakysson Robert husbandman 586338 586338 Elysson Jakysson, Robert, of Tadyngton, husbandman 1
4851937 2312041 2312041 defendant Gedhed Roger husbandman 586338 586338 Gedhed, Roger, of Tadyngton, husbandman 0
4869443 2317411 2317411 defendant Aylmere John husbandman 586338 586338 Aylmere, John, of Tadyngton, husbandman 0
4878254 2320150 2320150 defendant Tomlynson Roger husbandman 586338 586338 Tomlynson, Roger, of Tadyngton, husbandman 3
4897074 2325740 2325740 defendant Buyrdsel John husbandman 586338 586338 Buyrdsel, John, of Tadyngton, husbandman 0
4944943 2340407 2340407 defendant None Richard husbandman 586338 586338 (None, Richard, of Tadyngton, husbandman 1
4959044 2344670 2344670 defendant Jones alias Wayte Edward husbandman 586338 586338 Jones alias Wayte, Edward, of Tadyngton, husbandman 0
4996478 2355802 2355802 defendant Henbarowe Richard husbandman 586338 586338 Henbarowe, Richard, of Tadyngton, husbandman 3
5005310 2358455 2358455 defendant Worlych John yeoman 586338 586338 Worlych, John, of Tadyngton, yeoman 0
5005311 2358455 2358455 defendant Chetilbere William husbandman 586338 586338 Chetilbere, William, of Tadyngton, husbandman 1
5005321 2358457 2358457 defendant Ailmer John yeoman 586338 586338 Ailmer, John, of Tadyngton, yeoman 0
5018584 2362321 2362321 defendant Wolshawe Richard husbandman 586338 586338 Wolshawe, Richard, of Tadyngton, husbandman 1
5018585 2362321 2362321 defendant Wolshawe Thomas, junior husbandman 586338 586338 Wolshawe, Thomas, junior, of Tadyngton, husbandman 2
5021237 2363111 2363111 defendant Monger John husbandman 586338 586338 Monger, John, of Tadyngton, husbandman 0
5060102 2374589 2374589 defendant Tagge Roger husbandman 586338 586338 Tagge, Roger, of Tadyngton, husbandman 0
5211169 2418993 2418993 defendant Aylmer William gent 586338 586338 together with Aylmer, William, of Tadyngton, gent 1
5300811 2445200 2445200 defendant Nycholl John yeoman 586338 586338 Nycholl, John, of Tadyngton, yeoman 1
5319838 2451026 2451026 defendant Nicholl John   586338 586338 Nicholl, John, of Tadyngton 2
5379941 2469311 2469311 defendant Bore Alan husbandman 586338 586338 Bore, Alan, of Tadyngton, husbandman 1
5384429 2470632 2470632 defendant Nycoll John   586338 586338 Nycoll, John, of Tadyngton, 1
5466511 2494922 2494922 defendant Phelpott John clerk & vicar 586338 586338 Phelpott, John, of Tadyngton, clerk & vicar 3
5497370 2504152 2504152 defendant Carles John yeoman 586338 586338 Carles, John, of Tadyngton, yeoman 0
5497372 2504153 2504153 defendant Carles John yeoman 586338 586338 Carles, John, of Tadyngton, yeoman 0
5517226 2510223 2510223 defendant Phelpottys John clerk 586338 586338 Phelpottys, John, of Tadyngton, clerk 0
5517227 2510223 2510223 defendant Hooches John husbandman 586338 586338 Hooches, John, of Tadyngton, husbandman 1
5517228 2510223 2510223 defendant Ravynhull Roger husbandman 586338 586338 Ravynhull, Roger, of Tadyngton, husbandman 2
5517229 2510223 2510223 defendant Ravynhull Robert husbandman 586338 586338 Ravynhull, Robert, of Tadyngton, husbandman 3
5559527 2522746 2522746 defendant Coo Thomas yeoman 586338 586338 Coo, Thomas, of Tadyngton, yeoman 2
5577355 2527976 2527976 defendant Philpottys William husbandman 586338 586338 Philpottys, William, of Tadyngton, husbandman 1
5594060 2533123 2533123 defendant Coke Thomas husbandman 586338 586338 Coke, Thomas, of Tadyngton, husbandman 0
5595502 2533541 2533541 defendant Aylmer Roger (legal representative) 586338 586338 Aylmer, Roger, of Tadyngton, esq, executor of 0
5621263 2550537 2550537 defendant Swanhille Henry   586338 586338 Swanhille, Henry, of Tadyngton 0
5621525 2550631 2550631 plaintiff Swannyld Henry   586338 586338 Swannyld, Henry, of Tadyngton 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);