names

256 rows where place_id = 595396

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620304 1873930 1873930 defendant Duffeld Thomas gent 595396 595396 Duffeld, Thomas, of Emneth, gent 0
3622346 1874525 1874525 defendant Symson Nicholas husbandman 595396 595396 Symson, Nicholas, of Emneth, husbandman 0
3622347 1874525 1874525 defendant Symson Thomas husbandman 595396 595396 Symson, Thomas, of Emneth, husbandman 1
3624054 1875053 1875053 defendant Hogard Henry   595396 595396 Hogard, Henry, of Emneth, knight 0
3627288 1903382 1903382 defendant Smyth James butcher 595396 595396 Smyth, James, of Emneth, butcher 0
3640291 1907398 1907398 defendant Ingram Reginald husbandman 595396 595396 Ingram, Reginald, of Emneth, husbandman 0
3667843 1915884 1915884 defendant Spencer George husbandman 595396 595396 Spencer, George, of Emneth, husbandman 1
3670919 1916872 1916872 defendant Hopkynson Ropbert yeoman 595396 595396 Hopkynson, Ropbert, of Emneth, yeoman 0
3683016 1920800 1920800 defendant Jakson Nicholas husbandman 595396 595396 Jakson, Nicholas, of Emneth, husbandman 0
3685578 1921641 1921641 defendant Hopkynson Robert yeoman 595396 595396 Hopkynson, Robert, of Emneth, yeoman 0
3693945 1924310 1924310 defendant Drabbe John chaplain 595396 595396 Drabbe, John, of Emneth, chaplain 0
3733944 1936864 1936864 defendant Wallpole William husbandman 595396 595396 Wallpole, William, of Emneth, husbandman 0
3733945 1936864 1936864 defendant Bocher George butcher 595396 595396 Bocher, George, of Emneth, butcher 1
3778781 1951080 1951080 defendant Ogard Andrew (legal representative) 595396 595396 Ogard, Andrew, of Emneth, gent, executrix of 0
3780274 1951560 1951560 defendant Jakson Nicholas yeoman 595396 595396 Jakson, Nicholas, of Emneth, yeoman 0
3797155 1956994 1956994 defendant Jakson Nicholas yeoman 595396 595396 Jakson, Nicholas, of Emneth, yeoman 0
3831402 1967710 1967710 defendant Jakson Nicholas (legal representative) 595396 595396 Jakson, Nicholas, of Emneth, husbandman, executors of 0
3846804 1972551 1972551 defendant Jakson Nicholas (legal representative) 595396 595396 Jakson, Nicholas, of Emneth, husbandman, executors of 0
3856693 1975722 1975722 defendant Sherman John husbandman 595396 595396 Sherman, John, of Emneth, husbandman 0
3871741 1980785 1980785 defendant Wulfram alias Seffoule John husbandman 595396 595396 Wulfram alias Seffoule, John, of Emneth, husbandman 0
3905580 1992135 1992135 defendant Wetherfeld John husbandman 595396 595396 Wetherfeld, John, of Emneth, husbandman 0
3928045 1999714 1999714 defendant Frierman Richard   595396 595396 Frierman, Richard, of Emneth 0
3944533 2005188 2005188 defendant Tomlynson Thomas husbandman 595396 595396 Tomlynson, Thomas, of Emneth, husbandman 0
3944566 2005198 2005198 defendant Tomplynson Francis husbandman 595396 595396 Tomplynson, Francis, of Emneth, husbandman 0
3944567 2005198 2005198 defendant Tomlynson Nicholas husbandman 595396 595396 Tomlynson, Nicholas, of Emneth, husbandman 1
3947693 2006254 2006254 defendant Elsey Richard tailor 595396 595396 Elsey, Richard, of Emneth, tailor 0
3950190 2007150 2007150 defendant Hewar Thomas gent 595396 595396 Hewar, Thomas, of Emneth, gent 0
3958214 2009946 2009946 defendant Franklyn William gent 595396 595396 Franklyn, William, of Emneth, gent 0
3960990 2010939 2010939 defendant Bateley Nicholas yeoman 595396 595396 Bateley, Nicholas, of Emneth, yeoman 0
3965433 2012522 2012522 plaintiff Batelley Nicholas   595396 595396 Batelley, Nicholas, of Emneth 0
3965437 2012523 2012523 defendant Etherton Christopher laborer 595396 595396 Etherton, Christopher, of Emneth, laborer 0
3970772 2014369 2014369 plaintiff Dorman Roger   595396 595396 Dorman, Roger, of Emneth 0
3972195 2014835 2014835 defendant Wood Ambrose weaver 595396 595396 Wood, Ambrose, of Emneth, weaver 4
3972200 2014837 2014837 defendant Damett Stephen husbandman 595396 595396 Damett, Stephen, of Emneth, husbandman 0
3982279 2018431 2018431 defendant Bateley Nicholas yeoman 595396 595396 Bateley, Nicholas, of Emneth, yeoman 0
3990689 2021423 2021423 defendant Maye Thomas yeoman 595396 595396 Maye, Thomas, of Emneth, yeoman 0
3990691 2021424 2021424 defendant Maye Thomas yeoman 595396 595396 Maye, Thomas, of Emneth, yeoman 0
3990692 2021424 2021424 defendant Lambe William husbandman 595396 595396 Lambe, William, of Emneth, husbandman 1
3999431 2024558 2024558 defendant Kynge John thatcher 595396 595396 Kynge, John, of Emneth, thatcher 0
3999432 2024558 2024558 defendant Bounes John husbandman 595396 595396 Bounes, John, of Emneth, husbandman 1
4001259 2025230 2025230 defendant Carter John husbandman 595396 595396 Carter, John, of Emneth, husbandman 1
4001260 2025230 2025230 defendant Wardell Robert husbandman 595396 595396 Wardell, Robert, of Emneth, husbandman 2
4001261 2025230 2025230 defendant Thacker Richard husbandman 595396 595396 Thacker, Richard, of Emneth, husbandman 3
4001264 2025231 2025231 defendant Carter John husbandman 595396 595396 Carter, John, of Emneth, husbandman 1
4001265 2025231 2025231 defendant Wardell Robert husbandman 595396 595396 Wardell, Robert, of Emneth, husbandman 2
4001266 2025231 2025231 defendant Thaxster Richard husbandman 595396 595396 Thaxster, Richard, of Emneth, husbandman 3
4009831 2028292 2028292 defendant Archer Francis husbandman 595396 595396 Archer, Francis, of Emneth, husbandman 0
4009833 2028293 2028293 defendant Haunde Gregory laborer 595396 595396 Haunde, Gregory, of Emneth, laborer 0
4021314 2032348 2032348 defendant Garnett William husbandman 595396 595396 Garnett, William, of Emneth, husbandman 2
4024785 2033546 2033546 defendant Smyth William husbandman 595396 595396 Smyth, William, of Emneth, or of Newton, Isle of Ely, Cams, husbandman 1
4034075 2036846 2036846 defendant Franklyn John gent 595396 595396 Franklyn, John, of Emneth, or of Kings Lenne, gent 0
4034077 2036847 2036847 defendant Franklyn William gent 595396 595396 Franklyn, William, of Emneth, or of Kings Lenne, gent 0
4034079 2036848 2036848 defendant Norsse or Nurse Richard yeoman 595396 595396 Norsse or Nurse, Richard, of Emneth, yeoman 0
4035184 2037261 2037261 plaintiff Hewar Wenefrid widow 595396 595396 Wenefrid his wife, alias Wenefrid Ogard, of Emneth, widow 1
4035187 2037262 2037262 plaintiff Hewar Wenefrid widow 595396 595396 Wenefrid his wife, alias Wenefrid Ogarde, of Emneth, widow 1
4041739 2039527 2039527 defendant Archer Francis husbandman 595396 595396 Archer, Francis, of Emneth, husbandman 0
4048505 2041918 2041918 defendant Smyth Robert laborer 595396 595396 Smyth, Robert, of Emneth, laborer 0
4048506 2041918 2041918 defendant Sumpter Richard laborer 595396 595396 Sumpter, Richard, of Emneth, laborer 1
4052166 2043193 2043193 defendant Nurs Richard husbandman 595396 595396 Nurs, Richard, of Emneth, husbandman 0
4055414 2044332 2044332 defendant Hall William gent 595396 595396 Hall, William, of Emneth, gent 2
4080911 2053487 2053487 defendant Norsse Richard husbandman 595396 595396 Norsse, Richard, of Emneth, husbandman 0
4098128 2059657 2059657 defendant Lawrence Henry gent 595396 595396 Lawrence, Henry, of Emneth, or of Croyde, Cams, gent 0
4115809 2065939 2065939 defendant Hall William gent 595396 595396 Hall, William, of Emneth, gent 0
4116498 2066189 2066189 defendant Nors Richard husbandman 595396 595396 Nors, Richard, of Emneth, husbandman 0
4120110 2067480 2067480 defendant Ode Thomas gent 595396 595396 Ode, Thomas, of Emneth, gent 0
4137684 2073833 2073833 defendant Bowbrydge Edmund yeoman 595396 595396 Bowbrydge, Edmund, of Emneth, yeoman 0
4140308 2074778 2074778 defendant Wardall Robert husbandman 595396 595396 Wardall, Robert, of Emneth, husbandman 0
4143707 2075956 2075956 defendant Peters John husbandman 595396 595396 Peters, John, of Emneth, husbandman 0
4146154 2076804 2076804 defendant Warter Edmund yeoman 595396 595396 Warter, Edmund, of Emneth, yeoman 0
4146156 2076805 2076805 defendant Bullarde Thomas yeoman 595396 595396 Bullarde, Thomas, of Emneth, yeoman 0
4146157 2076805 2076805 defendant Waters Edmund yeoman 595396 595396 Waters, Edmund, of Emneth, yeoman 1
4156580 2080377 2080377 defendant Warter Edmund yeoman 595396 595396 Warter, Edmund, of Emneth, yeoman 0
4174831 2086666 2086666 defendant Bolton Robert husbandman 595396 595396 Bolton, Robert, of Emneth, husbandman 0
4201115 2095939 2095939 defendant Warter Edmund yeoman 595396 595396 Warter, Edmund, of Emneth, yeoman 0
4215406 2100884 2100884 defendant Hall Prudence widow 595396 595396 Hall, Prudence, of Emneth, widow 3
4218093 2101826 2101826 defendant Butler Henry gent 595396 595396 Butler, Henry, of Emneth, or of Witchingham Magna, gent 0
4249790 2112911 2112911 defendant Hall Prudence widow 595396 595396 Hall, Prudence, of Emneth, widow 1
4264445 2117748 2117748 defendant Butler Henry gent 595396 595396 Butler, Henry, of Emneth, or of West Walton, gent 1
4276754 2121804 2121804 defendant Franklyn Eldred gent 595396 595396 Franklyn, Eldred, of Emneth, gent 0
4276755 2121804 2121804 defendant Warbottom Humphrey gent 595396 595396 Warbottom, Humphrey, of Emneth, gent 1
4280516 2123093 2123093 defendant Wolmer Nicholas husbandman 595396 595396 Wolmer, Nicholas, of Emneth, husbandman 0
4280517 2123093 2123093 defendant Nicholson George yeoman 595396 595396 Nicholson, George, of Emneth, yeoman 1
4280724 2123163 2123163 defendant Brettinge Thomas clerk 595396 595396 Brettinge, Thomas, of Emneth, clerk 0
4281216 2123339 2123339 defendant Hall John husbandman 595396 595396 Hall, John, of Emneth, husbandman 0
4339277 2143502 2143502 defendant Wolmer Nicholas husbandman 595396 595396 Wolmer, Nicholas, of Emneth, husbandman 2
4340032 2143780 2143780 defendant Lawrence Robert gent 595396 595396 Lawrence, Robert, of Emneth, gent 0
4400235 2164670 2164670 defendant Samuell Robert husbandman 595396 595396 Samuell, Robert, of Emneth, husbandman 0
4411815 2168545 2168545 defendant Warbottom Humphrey gent 595396 595396 Warbottom, Humphrey, of Emneth, gent 3
4530751 2209908 2209908 defendant Dunton Thomas   595396 595396 Dunton, Thomas, of Emneth 0
4544162 2214089 2214089 defendant Lawesson John   595396 595396 Lawesson, John, of Emneth 0
4557881 2218397 2218397 defendant Peresson Nicholas   595396 595396 Peresson, Nicholas, of Emneth 0
4567162 2221291 2221291 plaintiff Taillour John   595396 595396 Taillour, John, of Emneth 0
4567163 2221291 2221291 defendant Doraunt John   595396 595396 Doraunt, John, of Emneth 0
4567164 2221291 2221291 defendant Calthorp John   595396 595396 Calthorp, John, of Emneth 1
4567165 2221291 2221291 defendant Bakere Richard   595396 595396 Bakere, Richard, of Emneth 2
4573421 2223217 2223217 defendant Cattesson John   595396 595396 Cattesson, John, of Emneth 1
4601251 2231625 2231625 defendant Albalt Richard chaplain 595396 595396 Albalt, Richard, of Emneth, chaplain 0
4706355 2267370 2267370 defendant Warde Robert husbandman 595396 595396 Warde, Robert, of Emneth, husbandman 0
4707416 2267697 2267697 defendant Preston William husbandman 595396 595396 Preston, William, of Emneth, husbandman 2
4733555 2275671 2275671 plaintiff Renkyn Thomas   595396 595396 Renkyn, Thomas, of Emneth 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);