names

106 rows where place_id = 588847

✎ 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
3595768 1866308 1866308 defendant Sampson John, senior husbandman 588847 588847 Sampson, John, senior, of Congham, husbandman 2
3595769 1866308 1866308 defendant Sampson John, junior husbandman 588847 588847 Sampson, John, junior, of Congham, husbandman 3
3606524 1869712 1869712 defendant Pyngyll Robert husbandman 588847 588847 Pyngyll, Robert, of Congham, husbandman 3
3630817 1904460 1904460 defendant Elwyn Thomas gent 588847 588847 Elwyn, Thomas, of Congham, gent 1
3663905 1914653 1914653 defendant Cooke Thomas clerk 588847 588847 Cooke, Thomas, of Congham, clerk 0
3713044 1930405 1930405 defendant Crathorn William husbandman 588847 588847 Crathorn, William, of Congham, husbandman 0
3722036 1933155 1933155 defendant Gyllam William plumber 588847 588847 Gyllam, William, of Congham, plumber 0
3762127 1945797 1945797 defendant Gaunt Thomas yeoman 588847 588847 Gaunt, Thomas, of Congham, yeoman 0
3785283 1953184 1953184 defendant Fysshe Adam husbandman 588847 588847 Fysshe, Adam, of Congham, husbandman 0
3834086 1968601 1968601 plaintiff Melyson Hugh husbandman 588847 588847 Melyson, Hugh, of Congham, husbandman 0
3846739 1972535 1972535 defendant Frysch Adam husbandman 588847 588847 Frysch, Adam, of Congham, husbandman 4
3846748 1972536 1972536 defendant Fryth Adam husbandman 588847 588847 Fryth, Adam, of Congham, husbandman 4
3863028 1977834 1977834 defendant Horner Roger clerk 588847 588847 Horner, Roger, of Congham, clerk 0
3881474 1984069 1984069 defendant Tankerley John chaplain 588847 588847 Tankerley, John, of Congham, chaplain 1
3881532 1984084 1984084 defendant Barber John laborer 588847 588847 Barber, John, of Congham, laborer 2
3944779 2005272 2005272 defendant Mynnes John   588847 588847 Mynnes, John, of Congham, shepherd 0
3944781 2005273 2005273 defendant Wrytyngton William husbandman 588847 588847 Wrytyngton, William, of Congham, husbandman 0
3947826 2006302 2006302 defendant Browne Thomas   588847 588847 Browne, Thomas, of Congham, shepherd 0
3956384 2009295 2009295 defendant Broun Thomas   588847 588847 Broun, Thomas, of Congham, shepherd 0
3956385 2009295 2009295 defendant Wace Robert husbandman 588847 588847 Wace, Robert, of Congham, husbandman 1
3960169 2010658 2010658 defendant Gyrlyngton George (legal representative) 588847 588847 Gyrlyngton, George, of Congham, executors of 1
3960170 2010658 2010658 defendant Newell Richard yeoman 588847 588847 (Newell, Richard, of Congham, yeoman 2
3976659 2016413 2016413 defendant Harryson Thomas yeoman 588847 588847 Harryson, Thomas, of Congham, yeoman 0
3989757 2021080 2021080 defendant Darington Oliver yeoman 588847 588847 Darington, Oliver, of Congham, yeoman 0
3989758 2021080 2021080 defendant Bell John yeoman 588847 588847 Bell, John, of Congham, yeoman 1
3997038 2023708 2023708 defendant Race Thomas   588847 588847 Race, Thomas, of Congham, shepherd 0
4001851 2025435 2025435 defendant Armytage Nicholas husbandman 588847 588847 Armytage, Nicholas, of Congham, husbandman 0
4054902 2044145 2044145 defendant Bell Lancelot yeoman 588847 588847 Bell, Lancelot, of Congham, yeoman 0
4094415 2058342 2058342 defendant Bell Lancelot yeoman 588847 588847 Bell, Lancelot, of Congham, yeoman 3
4094418 2058343 2058343 defendant Bell Lancelot yeoman 588847 588847 Bell, Lancelot, of Congham, yeoman 1
4095370 2058666 2058666 defendant Burton Miles husbandman 588847 588847 Burton, Miles, of Congham, husbandman 0
4095373 2058667 2058667 defendant Burton Miles husbandman 588847 588847 Burton, Miles, of Congham, husbandman 0
4101745 2060934 2060934 defendant Armytage Nicholas yeoman 588847 588847 Armytage, Nicholas, of Congham, yeoman 0
4111400 2064323 2064323 defendant Mordant Henry gent 588847 588847 Mordant, Henry, of Congham, gent 0
4111403 2064324 2064324 defendant Mordant Henry gent 588847 588847 Mordant, Henry, of Congham, gent 0
4157797 2080800 2080800 defendant Mordant Edmund gent 588847 588847 Mordant, Edmund, of Congham, gent 0
4164834 2083212 2083212 defendant Charleton Edward yeoman 588847 588847 Charleton, Edward, of Congham, yeoman 0
4176548 2087275 2087275 defendant Mordant Henry gent 588847 588847 Mordant, Henry, of Congham, gent 1
4181081 2088857 2088857 defendant Browne Thomas yeoman 588847 588847 Browne, Thomas, of Congham, yeoman 0
4204472 2097111 2097111 defendant Spylman Francis widow 588847 588847 Spylman, Francis, of Congham, widow 0
4204473 2097111 2097111 defendant Saunders Francis gent 588847 588847 Saunders, Francis, of Congham, gent 1
4204474 2097111 2097111 defendant Spylman Henry gent 588847 588847 Spylman, Henry, of Congham, gent 2
4209072 2098721 2098721 defendant Mordaunt Edmund gent 588847 588847 Mordaunt, Edmund, of Congham, gent 0
4209767 2098973 2098973 defendant Mordaunt Edmund gent 588847 588847 Mordaunt, Edmund, of Congham, gent 0
4209768 2098973 2098973 defendant Armitage Nicholas yeoman 588847 588847 Armitage, Nicholas, of Congham, yeoman 1
4213569 2100264 2100264 defendant Spylman Henry gent 588847 588847 Spylman, Henry, of Congham, gent 0
4213814 2100349 2100349 defendant Bell Lancelot yeoman 588847 588847 Bell, Lancelot, of Congham, yeoman 0
4276013 2121557 2121557 defendant Gee John miller 588847 588847 Gee, John, of Congham, miller 2
4291051 2126864 2126864 defendant Chaddocke Nicholas yeoman 588847 588847 Chaddocke, Nicholas, of Congham, yeoman 3
4311877 2134289 2134289 defendant Heringe Henry husbandman 588847 588847 Heringe, Henry, of Congham, husbandman 0
4311878 2134289 2134289 defendant Garner William husbandman 588847 588847 Garner, William, of Congham, husbandman 1
4313818 2134940 2134940 defendant Gyrlyng Margaret widow 588847 588847 Gyrlyng, Margaret, of Congham, widow 0
4354124 2148668 2148668 defendant Parkyns John   588847 588847 Parkyns, John, of Congham, shepherd 2
4393797 2162528 2162528 defendant Dewhurst James clerk 588847 588847 Dewhurst, James, of Congham, clerk 0
4798479 2295705 2295705 defendant Prouberd James yeoman 588847 588847 Prouberd, James, of Congham, yeoman 3
4813343 2300289 2300289 defendant Bryd John yeoman 588847 588847 Bryd, John, of Congham, yeoman 0
4875993 2319452 2319452 defendant Webstere Simon   588847 588847 Webstere, Simon, of Congham weaver 1
4877726 2319995 2319995 defendant de Congham Thomas husbandman 588847 588847 de Congham, Thomas, of Congham, husbandman 0
4877727 2319995 2319995 defendant Bryd John yeoman 588847 588847 Bryd, John, of Congham, yeoman 1
4881836 2321218 2321218 defendant Bryd Edmund husbandman 588847 588847 Bryd, Edmund, of Congham, husbandman 0
4881837 2321218 2321218 defendant Taverner Walter husbandman 588847 588847 Taverner, Walter, of Congham, husbandman 1
4881838 2321218 2321218 defendant Pyggyll William husbandman 588847 588847 Pyggyll, William, of Congham, husbandman 2
4945562 2340589 2340589 defendant Bakhous Ralph laborer 588847 588847 Bakhous, Ralph, of Congham, laborer 0
4956711 2343961 2343961 defendant Bakhous Ralph laborer 588847 588847 Bakhous, Ralph, of Congham, laborer 0
4958475 2344505 2344505 defendant Rougham Adam clerk 588847 588847 Rougham, Adam, of Congham, clerk 0
4958476 2344505 2344505 defendant Bryd John yeoman 588847 588847 Bryd, John, of Congham, yeoman 1
4958477 2344505 2344505 defendant Dan Thomas yeoman 588847 588847 Dan, Thomas, of Congham, yeoman 2
4959792 2344892 2344892 defendant Congham Thomas yeoman 588847 588847 Congham, Thomas, of Congham, yeoman 1
4963339 2345943 2345943 defendant Lambard John husbandman 588847 588847 Lambard, John, of Congham, husbandman 1
4982671 2351729 2351729 defendant Bryd John husbandman 588847 588847 Bryd, John, of Congham, husbandman 1
4982672 2351729 2351729 defendant Congham Thomas husbandman 588847 588847 Congham, Thomas, of Congham, husbandman 2
5019253 2362524 2362524 defendant Chappys Richard esq 588847 588847 Chappys, Richard, of Congham, esq 0
5068182 2376987 2376987 defendant Danne Thomas yeoman 588847 588847 Danne, Thomas, of Congham, yeoman 0
5068183 2376987 2376987 defendant Prowberd James yeoman 588847 588847 Prowberd, James, of Congham, yeoman 1
5077111 2379654 2379654 defendant Garlond John husbandman 588847 588847 Garlond, John, of Congham, husbandman 1
5077112 2379654 2379654 defendant Pynghill John yeoman 588847 588847 Pynghill, John, of Congham, yeoman 2
5093042 2384355 2384355 defendant Deynes William yeoman 588847 588847 Deynes, William, of Congham, yeoman 0
5097125 2385593 2385593 defendant Garlond John husbandman 588847 588847 Garlond, John, of Congham, husbandman 0
5100349 2386545 2386545 defendant Deynes William husbandman 588847 588847 Deynes, William, of Congham, husbandman 6
5100350 2386545 2386545 defendant Proweberd John husbandman 588847 588847 Proweberd, John, of Congham, husbandman 7
5103872 2387556 2387556 defendant Wayte Richard husbandman 588847 588847 (Wayte, Richard, of Congham, husbandman 1
5122265 2392936 2392936 defendant Barker William yeoman 588847 588847 Barker, William, of Congham, yeoman 0
5140973 2398479 2398479 defendant Pyngell Robert husbandman 588847 588847 Pyngell, Robert, of Congham, husbandman 0
5325018 2452563 2452563 defendant Congham Edmund husbandman 588847 588847 Congham, Edmund, of Congham, husbandman 4
5351008 2460426 2460426 defendant Proberd John husbandman 588847 588847 Proberd, John, of Congham, husbandman 2
5356009 2461963 2461963 defendant Pyngyll Robert husbandman 588847 588847 Pyngyll, Robert, of Congham, husbandman 1
5370169 2466254 2466254 defendant Pyngell Robert husbandman 588847 588847 Pyngell, Robert, of Congham, husbandman 4
5393021 2473074 2473074 defendant Pyveryll Robert husbandman 588847 588847 Pyveryll, Robert, of Congham, husbandman 4
5425703 2482659 2482659 defendant Lambertt William yeoman 588847 588847 Lambertt, William, of Congham, yeoman 0
5425705 2482659 2482659 defendant Wayte Richard husbandman 588847 588847 Wayte, Richard, of Congham, husbandman 2
5430772 2484144 2484144 defendant Kelyng Robert   588847 588847 Kelyng, Robert, of Congham, shepherd 3
5478216 2498511 2498511 defendant Pyngyll Robert husbandman 588847 588847 Pyngyll, Robert, of Congham, husbandman 0
5491525 2502348 2502348 defendant Pynggyll Robert husbandman 588847 588847 Pynggyll, Robert, of Congham, husbandman 3
5498421 2504486 2504486 defendant Pyngyll Robert husbandman 588847 588847 Pyngyll, Robert, of Congham, husbandman 0
5498422 2504486 2504486 defendant Geywode Hugh husbandman 588847 588847 Geywode, Hugh, of Congham, husbandman 1
5529985 2513884 2513884 defendant Wayt Richard husbandman 588847 588847 Wayt, Richard, of Congham, husbandman 3
5560723 2523103 2523103 defendant Cok Henry yeoman 588847 588847 Cok, Henry, of Congham, yeoman 1
5567559 2525085 2525085 defendant Ruste Thomas mercer or clerk 588847 588847 Ruste, Thomas, of Congham, mercer or clerk 1
5577254 2527939 2527939 plaintiff Wayte Richard (legal representative) 588847 588847 Wayte, Richard, of Congham, executors of 0
5577258 2527940 2527940 plaintiff Wayte Richard (legal representative) 588847 588847 Wayte, Richard, of Congham, executors of 0

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