names

88 rows where place_id = 586549

✎ 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
3589007 1864212 1864212 defendant Henton Robert yeoman 586549 586549 Henton, Robert, of Hoton, yeoman 0
3599584 1867506 1867506 defendant Gregill John husbandman 586549 586549 Gregill, John, of Hoton, husbandman 2
3617596 1873125 1873125 defendant Hatter Robert husbandman 586549 586549 Hatter, Robert, of Hoton, husbandman 0
4299643 2129963 2129963 defendant Burden Miles yeoman 586549 586549 Burden, Miles, of Hoton, yeoman 0
4440194 2181856 2181856 defendant Lodull William de   586549 586549 Lodull, William de, of Hoton 0
4440195 2181856 2181856 defendant Shayle Alexander   586549 586549 Shayle, Alexander, of Hoton 1
4440197 2181856 2181856 defendant Scot John   586549 586549 Scot, John, of Hoton 3
4440198 2181856 2181856 defendant Shayle John   586549 586549 Shayle, John, of Hoton 4
4440199 2181856 2181856 defendant Nutshawe John   586549 586549 Nutshawe, John, of Hoton 5
4440200 2181856 2181856 defendant Shephird Richard   586549 586549 Shephird, Richard, of Hoton 6
4450433 2185097 2185097 defendant atte Lane Thomas   586549 586549 atte Lane, Thomas, of Hoton 0
4450435 2185098 2185098 defendant atte Lane Thomas   586549 586549 atte Lane, Thomas, of Hoton 0
4452837 2185899 2185899 defendant Pyr-- John   586549 586549 Pyr--, John, of Hoton 0
4453052 2185963 2185963 defendant Geffrayson Richard   586549 586549 Geffrayson, Richard, of Hoton 5
4453959 2186256 2186256 defendant Milner John   586549 586549 Milner, John, of Hoton 3
4457044 2187217 2187217 defendant Emsdun Alexander   586549 586549 Emsdun, Alexander, of Hoton 1
4457045 2187217 2187217 defendant Baron Thomas   586549 586549 Baron, Thomas, of Hoton 2
4457046 2187217 2187217 defendant Nutshawe Thomas   586549 586549 Nutshawe, Thomas, of Hoton 3
4457047 2187217 2187217 defendant Nutshawe John   586549 586549 Nutshawe, John, of Hoton 4
4457048 2187217 2187217 defendant Bo--stals William   586549 586549 Bo--stals, William, of Hoton 5
4470305 2191360 2191360 defendant Dest William   586549 586549 Dest, William, of Hoton 0
4473765 2192439 2192439 defendant Hoggeson William   586549 586549 Hoggeson, William, of Hoton 0
4474239 2192595 2192595 defendant Lovell William   586549 586549 Lovell, William, of Hoton 1
4481232 2194810 2194810 defendant Douf Richard   586549 586549 Douf, Richard, of Hoton 5
4481233 2194810 2194810 defendant Smythson John   586549 586549 Smythson, John, of Hoton 6
4499875 2200593 2200593 defendant Lanley John   586549 586549 Lanley, John, of Hoton under Haghe, parson 0
4501416 2201046 2201046 defendant Hesyll John   586549 586549 Hesyll, John, of Hoton 0
4501418 2201047 2201047 defendant Hesyll John   586549 586549 Hesyll, John, of Hoton 0
4522145 2207271 2207271 defendant Gebonson John   586549 586549 Gebonson, John, of Hoton 1
4527473 2208872 2208872 defendant Chapman Nicholas   586549 586549 Chapman, Nicholas, of Hoton 1
4537234 2211918 2211918 defendant Walter Thomas   586549 586549 Walter, Thomas, of Hoton 2
4539122 2212498 2212498 defendant del Bek John   586549 586549 del Bek, John, of Hoton 29
4539346 2212563 2212563 defendant Hare John   586549 586549 Hare, John, of Hoton 10
4553846 2217125 2217125 defendant Casteleyn Thomas   586549 586549 Casteleyn, Thomas, of Hoton 0
4553847 2217125 2217125 defendant Caumpe Thomas   586549 586549 Caumpe, Thomas, of Hoton 1
4556644 2218011 2218011 defendant Wynteworth William de (legal representative) 586549 586549 Wynteworth, William de, of Hoton, administratrix of 0
4602218 2231911 2231911 defendant Bridsall William   586549 586549 Bridsall, William, of Hoton 0
4606363 2233106 2233106 defendant Aldrych William   586549 586549 Aldrych, William, of Hoton 0
4616523 2236164 2236164 defendant Smyth Nicholas   586549 586549 Smyth, Nicholas, of Hoton 0
4616524 2236164 2236164 defendant Tomson Robert   586549 586549 Tomson, Robert, of Hoton 1
4618651 2236843 2236843 defendant Gretham Thomas   586549 586549 Gretham, Thomas, of Hoton 1
4618652 2236843 2236843 defendant Smythton Richard   586549 586549 Smythton, Richard, of Hoton 2
4618653 2236843 2236843 defendant Yanwyth Robert de   586549 586549 Yanwyth, Robert de, of Hoton 3
4618654 2236843 2236843 defendant Mustard John   586549 586549 Mustard, John, of Hoton 4
4618655 2236843 2236843 defendant Otryngton John   586549 586549 Otryngton, John, of Hoton 5
4626151 2239137 2239137 defendant Ruddok John   586549 586549 Ruddok, John, of Hoton, vicar 0
4651460 2246461 2246461 defendant Canon Robert yeoman 586549 586549 Canon, Robert, of Hoton, yeoman 0
4652529 2246743 2246743 defendant Hardewyke William   586549 586549 Hardewyke, William, of Hoton, shepherd 0
4671158 2256642 2256642 defendant Bregore Henry yeoman 586549 586549 Bregore, Henry, of Hoton, yeoman 2
4679044 2259054 2259054 defendant Arlossh Robert yeoman 586549 586549 Arlossh, Robert, of Hoton, yeoman 2
4681957 2259971 2259971 defendant Seton William   586549 586549 with Seton, William, of Hoton, mason 1
4706182 2267310 2267310 defendant Mawer Thomas husbandman 586549 586549 Mawer, Thomas, of Hoton, husbandman 1
4706183 2267310 2267310 defendant Hosyll John husbandman 586549 586549 Hosyll, John, of Hoton, husbandman 2
4708563 2268048 2268048 defendant Ilford Richard husbandman 586549 586549 Ilford, Richard, of Hoton, husbandman 0
4708564 2268048 2268048 defendant Canon Henry husbandman 586549 586549 Canon, Henry, of Hoton, husbandman 1
4725348 2273219 2273219 defendant Abbot Simon   586549 586549 Abbot, Simon, of Hoton, parson of the parish church 0
4736854 2276656 2276656 plaintiff Smyth William   586549 586549 (Smyth, William, of Hoton 1
4776574 2288666 2288666 defendant Grene John husbandman 586549 586549 Grene, John, of Hoton, husbandman 4
4848684 2311058 2311058 defendant Canon Robert yeoman 586549 586549 Canon, Robert, of Hoton, yeoman 0
4850480 2311608 2311608 defendant Lecheney William   586549 586549 Lecheney, William, of Hoton, vicar 0
4856493 2313410 2313410 defendant Alfryth John yeoman 586549 586549 Alfryth, John, of Hoton, yeoman 0
4879336 2320466 2320466 defendant del Bek Thomas yeoman 586549 586549 del Bek, Thomas, of Hoton, yeoman 4
4883247 2321687 2321687 defendant de Bek Robert, senior yeoman 586549 586549 de Bek, Robert, senior, of Hoton, yeoman 0
4893823 2324766 2324766 defendant Neweton William clerk 586549 586549 Neweton, William, of Hoton, Cumber, clerk 0
4925087 2334277 2334277 defendant Bekke Robert, senior yeoman 586549 586549 Bekke, Robert, senior, of Hoton, yeoman 1
4929598 2335670 2335670 defendant Slee John yeoman 586549 586549 Slee, John, of Hoton, yeoman 3
4972786 2348797 2348797 defendant de Bek Robert, senior yeoman 586549 586549 de Bek, Robert, senior, of Hoton, yeoman 1
4977974 2350377 2350377 defendant Alverych John, senior husbandman 586549 586549 Alverych, John, senior, of Hoton, husbandman 0
4995147 2355402 2355402 defendant Michell John, sen yeoman 586549 586549 Michell, John, sen, of Hoton, yeoman 0
5002596 2357671 2357671 defendant Alverche John husbandman 586549 586549 Alverche, John, of Hoton, husbandman 0
5091542 2383916 2383916 defendant Godryll alias Hutton James husbandman 586549 586549 Godryll alias Hutton, James, of Hoton, husbandman 1
5195145 2414326 2414326 defendant Hogonson William Lancs, husbandman 586549 586549 Hogonson William, of Hoton, Lancs, husbandman 2
5244116 2428469 2428469 defendant Halweryche John, junior husbandman 586549 586549 Halweryche, John, junior, of Hoton, husbandman 0
5277916 2438629 2438629 defendant Bacheler Thomas yeoman 586549 586549 Bacheler, Thomas, of Hoton, yeoman 0
5324772 2452485 2452485 defendant Lorkyn James husbandman 586549 586549 Lorkyn, James, of Hoton, husbandman 4
5486771 2500944 2500944 defendant Hatter Robert husbandman 586549 586549 Hatter, Robert, of Hoton, husbandman 2
5492460 2502659 2502659 defendant Hatter Robert yeoman 586549 586549 Hatter, Robert, of Hoton, yeoman 3
5516114 2509889 2509889 defendant Sprot John husbandman 586549 586549 Sprot, John, of Hoton, husbandman 1
5516206 2509904 2509904 defendant Sprot John husbandman 586549 586549 Sprot, John, of Hoton, husbandman 1
5521005 2511392 2511392 defendant Best Robert yeoman 586549 586549 Best, Robert, of Hoton, yeoman 0
5560206 2522946 2522946 defendant Gifford John yeoman 586549 586549 Gifford, John, of Hoton, yeoman 0
5597740 2534190 2534190 defendant Denton John miller 586549 586549 Denton, John, of Hoton, miller 0
5597741 2534190 2534190 defendant Barkar Henry husbandman 586549 586549 Barkar, Henry, of Hoton, husbandman 1
5599428 2534707 2534707 defendant Saunder William husbandman 586549 586549 Saunder, William, of Hoton, husbandman 0
5623636 2551330 2551330 plaintiff Marton William   586549 586549 Marton, William, of Hoton 1
5629766 2553304 2553304 defendant Canon William   586549 586549 Canon, William, of Hoton 1
5629767 2553304 2553304 defendant Johnson Robert yeoman 586549 586549 Johnson, Robert, of Hoton, yeoman 2
5629768 2553304 2553304 defendant Nutshawe John yeoman 586549 586549 Nutshawe, John, of Hoton, yeoman 3

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