names

155 rows where place_id = 592846

✎ 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
3609149 1870520 1870520 defendant Alege Richard yeoman 592846 592846 Alege, Richard, of Wygtoft, yeoman 0
3610735 1871022 1871022 defendant Poynton William husbandman 592846 592846 Poynton, William, of Wygtoft, husbandman 1
3611114 1871151 1871151 defendant Kelet Richard husbandman 592846 592846 Kelet, Richard, of Wygtoft, husbandman 0
3615626 1872529 1872529 defendant Bryg John, senior yeoman 592846 592846 Bryg, John, senior, of Wygtoft, yeoman 0
3617747 1873176 1873176 defendant Etgose Thomas husbandman 592846 592846 Etgose, Thomas, of Wygtoft, husbandman 0
3620907 1874102 1874102 defendant Almond John husbandman 592846 592846 Almond, John, of Wygtoft, husbandman 0
3624310 1875137 1875137 defendant Brigge Lawrence yeoman 592846 592846 Brigge, Lawrence, of Wygtoft, yeoman 0
3624311 1875137 1875137 defendant Austen John yeoman 592846 592846 Austen, John, of Wygtoft, yeoman 1
3639682 1907220 1907220 defendant Lawes John husbandman 592846 592846 Lawes, John, of Wygtoft, husbandman 0
3639683 1907220 1907220 defendant Bowater Richard chaplain 592846 592846 Bowater, Richard, of Wygtoft, chaplain 1
3639684 1907220 1907220 defendant Campe Richard weaver 592846 592846 Campe, Richard, of Wygtoft, weaver 2
3639685 1907220 1907220 defendant Derot William husbandman 592846 592846 Derot, William, of Wygtoft, husbandman 3
3639686 1907220 1907220 defendant Bett Thomas husbandman 592846 592846 Bett, Thomas, of Wygtoft, husbandman 4
3670522 1916743 1916743 defendant Benet Thomas gent 592846 592846 Benet, Thomas, of Wygtoft, gent 0
3676058 1918547 1918547 defendant Dyconson Thomas laborer 592846 592846 Dyconson, Thomas, of Wygtoft, laborer 0
3686783 1922022 1922022 defendant Halgh Thomas gent 592846 592846 Halgh, Thomas, of Wygtoft, gent 0
3725769 1934347 1934347 defendant Lawes John, junior husbandman 592846 592846 Lawes, John, junior, of Wygtoft, husbandman 0
3728940 1935297 1935297 defendant Tomson John husbandman 592846 592846 Tomson, John, of Wygtoft, husbandman 0
3736430 1937638 1937638 defendant Bawn William husbandman 592846 592846 Bawn, William, of Wygtoft, husbandman 1
3736432 1937638 1937638 defendant Toller William husbandman 592846 592846 Toller, William, of Wygtoft, husbandman 3
3750479 1942063 1942063 defendant Toly John husbandman 592846 592846 Toly, John, of Wygtoft, husbandman 0
3750480 1942063 1942063 defendant Toly Lambert smith 592846 592846 Toly, Lambert, of Wygtoft, smith 1
3763188 1946122 1946122 defendant Obrey Hugh husbandman 592846 592846 Obrey, Hugh, of Wygtoft, husbandman 0
3776138 1950280 1950280 defendant Toly John husbandman 592846 592846 Toly, John, of Wygtoft, husbandman 0
3784282 1952873 1952873 defendant Toly John husbandman 592846 592846 Toly, John, of Wygtoft, husbandman 0
3857147 1975865 1975865 defendant Kyme Robert yeoman 592846 592846 Kyme, Robert, of Wygtoft, yeoman 0
3863687 1978041 1978041 defendant Sherforthe Thomas husbandman 592846 592846 Sherforthe, Thomas, of Wygtoft, husbandman 0
3864526 1978336 1978336 defendant Lawes Alan husbandman 592846 592846 Lawes, Alan, of Wygtoft, husbandman 0
3864527 1978336 1978336 defendant Echard Thomas husbandman 592846 592846 Echard, Thomas, of Wygtoft, husbandman 1
3864528 1978336 1978336 defendant Man John husbandman 592846 592846 Man, John, of Wygtoft, husbandman 2
3864529 1978336 1978336 defendant Man Joan spinster 592846 592846 Man, Joan, of Wygtoft, spinster 3
3864752 1978407 1978407 defendant Wolmer Christopher gent 592846 592846 Wolmer, Christopher, of Wygtoft, gent 0
3984978 2019386 2019386 plaintiff Tonarde Humphrey yeoman 592846 592846 Tonarde, Humphrey, of Wygtoft, yeoman 0
3992750 2022158 2022158 defendant Hawese William husbandman 592846 592846 Hawese, William, of Wygtoft, husbandman 0
4001291 2025240 2025240 defendant Harryson Roger yeoman 592846 592846 Harryson, Roger, of Wygtoft, yeoman 3
4003639 2026066 2026066 defendant Atkynson George, senior   592846 592846 Atkynson, George, senior, of Wygtoft 0
4003640 2026066 2026066 defendant Hawes William husbandman 592846 592846 Hawes, William, of Wygtoft, husbandman 1
4426190 2172995 2172995 defendant Casterton William de   592846 592846 Casterton, William de, of Wygtoft 1
4426191 2172995 2172995 defendant del Feld Hugh   592846 592846 del Feld, Hugh, of Wygtoft 2
4480679 2194623 2194623 defendant Feld Robert de   592846 592846 Feld, Robert de, of Wygtoft 0
4481688 2194971 2194971 plaintiff Mageleyn William   592846 592846 Mageleyn, William, of Wygtoft 0
4481690 2194972 2194972 plaintiff Magelyn William   592846 592846 Magelyn, William, of Wygtoft 0
4496349 2199531 2199531 defendant Felde John de   592846 592846 Felde, John de, of Wygtoft, son of Richard de Felde 1
4542902 2213673 2213673 plaintiff Anabull John   592846 592846 Anabull, John, of Wygtoft, vicar 0
4547070 2215018 2215018 defendant Pevy John   592846 592846 Pevy, John, of wygtoft 0
4552982 2216877 2216877 defendant Peny John   592846 592846 Peny, John, of Wygtoft 3
4569774 2222126 2222126 defendant Magelyn William   592846 592846 Magelyn, William, of Wygtoft 0
4599747 2231141 2231141 defendant Lambson John   592846 592846 Lambson, John, of Wygtoft 0
4653122 2246913 2246913 defendant Barneby John husbandman 592846 592846 Barneby, John, of Wygtoft, husbandman 0
4694071 2263647 2263647 defendant Devesse Roger husbandman 592846 592846 Devesse, Roger, of Wygtoft, husbandman 1
4695483 2264068 2264068 defendant Honne John   592846 592846 Honne, John, of Wygtoft, salt weller 2
4719143 2271336 2271336 defendant Anable John   592846 592846 Anable, John, of Wygtoft, vicar 0
4719144 2271336 2271336 defendant Heryng Robert husbandman 592846 592846 Heryng, Robert, of Wygtoft, husbandman 1
4741141 2277914 2277914 defendant Denys Roger husbandman 592846 592846 Denys, Roger, of Wygtoft, husbandman 1
4773328 2287632 2287632 defendant Tylney John husbandman 592846 592846 Tylney, John, of Wygtoft, husbandman 0
4786684 2291890 2291890 defendant Grave John husbandman 592846 592846 Grave, John, of Wygtoft, husbandman 0
4803506 2297284 2297284 defendant Barry John husbandman 592846 592846 Barry, John, of Wygtoft, husbandman 1
4803507 2297284 2297284 defendant Looke William husbandman 592846 592846 Looke, William, of Wygtoft, husbandman 2
4816447 2301235 2301235 plaintiff Magelyne William (legal representative) 592846 592846 Magelyne, William, of Wygtoft, merchant, executors of 0
4820537 2302492 2302492 defendant Carter Robert   592846 592846 Carter, Robert, of Wygtoft, salt weller 1
4824431 2303693 2303693 defendant Adam John, junior husbandman 592846 592846 Adam, John, junior, of Wygtoft, husbandman 1
4832699 2306245 2306245 defendant Magelon John gent 592846 592846 Magelon, John, of Wygtoft, gent 0
4835876 2307204 2307204 defendant Magelyn John husbandman 592846 592846 Magelyn, John, of Wygtoft, husbandman 1
4839018 2308133 2308133 defendant Myles Thomas butcher 592846 592846 Myles, Thomas, of Wygtoft, butcher 1
4850044 2311477 2311477 defendant Tilney John husbandman 592846 592846 Tilney, John, of Wygtoft, husbandman 5
4857362 2313689 2313689 defendant Hochonson William husbandman 592846 592846 Hochonson, William, of Wygtoft, husbandman 0
4863252 2315477 2315477 defendant Magelyn John husbandman 592846 592846 Magelyn, John, of Wygtoft, husbandman 1
4870832 2317856 2317856 defendant Tylney John husbandman 592846 592846 Tylney, John, of Wygtoft, husbandman 3
4876767 2319707 2319707 defendant Tylney John husbandman 592846 592846 Tylney, John, of Wygtoft, husbandman 0
4890413 2323767 2323767 defendant Barre John husbandman 592846 592846 Barre, John, of Wygtoft, husbandman 1
4913303 2330660 2330660 defendant Brigg John husbandman 592846 592846 Brigg, John, of Wygtoft, husbandman 3
4917560 2332007 2332007 defendant Flete William chaplain 592846 592846 Flete, William, of Wygtoft, chaplain 0
4956722 2343964 2343964 defendant Brigge John gent 592846 592846 Brigge, John, of Wygtoft, gent 1
4960897 2345222 2345222 defendant Magelyn John gent 592846 592846 Magelyn, John, of Wygtoft, gent 0
4976028 2349797 2349797 defendant Cantelot Richard butcher 592846 592846 Cantelot, Richard, of Wygtoft, butcher 2
4977612 2350270 2350270 defendant Worme John salter 592846 592846 Worme, John, of Wygtoft, salter 0
4985014 2352449 2352449 defendant Felde Nicholas husbandman 592846 592846 Felde, Nicholas, of Wygtoft, husbandman 2
4993443 2354907 2354907 defendant Shepherd Thomas laborer 592846 592846 Shepherd, Thomas, of Wygtoft, laborer 0
5012178 2360409 2360409 defendant Magelyn John esq 592846 592846 Magelyn, John, of Wygtoft, esq 2
5014542 2361117 2361117 defendant Magelyn John gent 592846 592846 Magelyn, John, of Wygtoft, gent 0
5020577 2362907 2362907 defendant Magelyne John esq 592846 592846 Magelyne, John, of Wygtoft, esq 0
5021850 2363282 2363282 defendant Cole Richard   592846 592846 Cole, Richard, of Wygtoft, cartwright 0
5022140 2363365 2363365 defendant Codbene Robert saltweller 592846 592846 Codbene, Robert, of Wygtoft, saltweller 0
5022183 2363379 2363379 defendant Lombson Walter husbandman 592846 592846 Lombson, Walter, of Wygtoft, husbandman 0
5025042 2364225 2364225 defendant Pynder John (legal representative) 592846 592846 Pynder, John, of Wygtoft, husbandman, executor of 0
5025043 2364225 2364225 defendant Alegge Thomas gent 592846 592846 Alegge, Thomas, of Wygtoft, gent 1
5029538 2365508 2365508 defendant Bawne Robert husbandman 592846 592846 Bawne, Robert, of Wygtoft, husbandman 1
5038016 2368003 2368003 defendant Magelyn John esq 592846 592846 Magelyn, John, of Wygtoft, esq 2
5038024 2368004 2368004 defendant Magelyn John esq 592846 592846 Magelyn, John, of Wygtoft, esq 2
5042816 2369459 2369459 defendant Magelyn John esq 592846 592846 Magelyn, John, of Wygtoft, esq 0
5066797 2376596 2376596 defendant Aleche Thomas yeoman 592846 592846 Aleche, Thomas, of Wygtoft, yeoman 0
5082500 2381268 2381268 defendant Crosse John chaplain 592846 592846 Crosse, John, of Wygtoft, chaplain 0
5082502 2381269 2381269 defendant Crosse John chaplain 592846 592846 Crosse, John, of Wygtoft, chaplain 0
5082849 2381375 2381375 defendant Felde Nicholas husbandman 592846 592846 Felde, Nicholas, of Wygtoft, husbandman 3
5097091 2385582 2385582 defendant Hoton John husbandman 592846 592846 Hoton, John, of Wygtoft, husbandman 2
5104502 2387743 2387743 defendant Felde Nicholas husbandman 592846 592846 Felde, Nicholas, of Wygtoft, husbandman 2
5121402 2392692 2392692 defendant Magelyn William gent 592846 592846 Magelyn, William, of Wygtoft, gent 0
5122365 2392969 2392969 defendant Magelyn William gent 592846 592846 Magelyn, William, of Wygtoft, gent 1
5122366 2392969 2392969 defendant Lambert William laborer 592846 592846 Lambert, William, of Wygtoft, laborer 2
5122367 2392969 2392969 defendant Marsshall Thomas laborer 592846 592846 Marsshall, Thomas, of Wygtoft, laborer 3

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