names

114 rows where place_id = 594892

✎ 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
3597870 1866955 1866955 defendant Brayne Thomas   594892 594892 Brayne, Thomas, of Elham, parish clerk 0
3618028 1873259 1873259 defendant Brayn Thomas yeoman 594892 594892 Brayn, Thomas, of Elham, yeoman 0
3626985 1903298 1903298 defendant Goldefynch John husbandman 594892 594892 Goldefynch, John, of Elham, husbandman 0
3626986 1903298 1903298 defendant Jancok Edward husbandman 594892 594892 Jancok, Edward, of Elham, husbandman 1
3668163 1915988 1915988 defendant at Wodde Thomas husbandman 594892 594892 at Wodde, Thomas, of Elham, husbandman: at Neve, John, junior, of Barham, husbandman 3
3702317 1926984 1926984 defendant Osborn Thomas smith 594892 594892 Osborn, Thomas, of Elham, smith 1
3756547 1944026 1944026 defendant Atwode Thomas yeoman 594892 594892 Atwode, Thomas, of Elham, yeoman 0
3771971 1948926 1948926 defendant Broke Henry husbandman 594892 594892 Broke, Henry, of Elham, husbandman 2
3783249 1952514 1952514 defendant Wolette Roger yeoman 594892 594892 Wolette, Roger, of Elham, yeoman 2
3799761 1957845 1957845 defendant Wolett Roger yeoman 594892 594892 Wolett, Roger, of Elham, yeoman 2
3815217 1962676 1962676 defendant Osbern James yeoman 594892 594892 Osbern, James, of Elham, yeoman 1
3817200 1963294 1963294 defendant Wollett Roger yeoman 594892 594892 Wollett, Roger, of Elham, yeoman 2
3939941 2003659 2003659 defendant Ladde Thomas husbandman 594892 594892 Ladde, Thomas, of Elham, husbandman 2
4024153 2033342 2033342 defendant Paynter Thomas gent 594892 594892 Paynter, Thomas, of Elham, gent 2
4049237 2042171 2042171 defendant Osborne Oswald tailor 594892 594892 Osborne, Oswald, of Elham, tailor 0
4065725 2048035 2048035 defendant Foode Christopher husbandman 594892 594892 Foode, Christopher, of Elham, husbandman 2
4072137 2050334 2050334 defendant Johnson Nicholas yeoman 594892 594892 Johnson, Nicholas, of Elham, yeoman 0
4230402 2106126 2106126 defendant Blowne Thomas tailor 594892 594892 Blowne, Thomas, of Elham, tailor 0
4338499 2143217 2143217 defendant Gybbon or Gybbyn Robert shoemkaer 594892 594892 Gybbon or Gybbyn, Robert, of Elham, shoemkaer 0
4338501 2143218 2143218 defendant Gybbon Robert shoemaker 594892 594892 Gybbon, Robert, of Elham, shoemaker 0
4361783 2151372 2151372 defendant Gybbon Robert shoemaker 594892 594892 Gybbon, Robert, of Elham, shoemaker 0
4361785 2151373 2151373 defendant Gybbon Robert shoemaker 594892 594892 Gybbon, Robert, of Elham, shoemaker 0
4368820 2153902 2153902 defendant Down William smith 594892 594892 Down, William, of Elham, smith 0
4432234 2174864 2174864 defendant Millere Osbert   594892 594892 Millere, Osbert, of Elham 4
4484044 2195701 2195701 defendant Adam John butcher 594892 594892 Adam, John, of Elham, butcher 0
4493737 2198739 2198739 defendant Colle Thomas   594892 594892 Colle, Thomas, of Elham 2
4493738 2198739 2198739 defendant Durant John   594892 594892 Durant, John, of Elham 3
4507782 2202893 2202893 defendant Stokham Robert   594892 594892 Stokham, Robert, of Elham 0
4544825 2214300 2214300 defendant Bable Thomas   594892 594892 Bable, Thomas, of Elham 0
4544826 2214300 2214300 defendant atte Wode Roger   594892 594892 atte Wode, Roger, of Elham 1
4544827 2214300 2214300 defendant Bateys John carpenter 594892 594892 Bateys, John, of Elham, carpenter 2
4550448 2216084 2216084 defendant Whistapill John shoemaker 594892 594892 Whistapill, John, of Elham, shoemaker 3
4569613 2222075 2222075 defendant Peverell Robert   594892 594892 Peverell, Robert, of Elham 0
4573913 2223358 2223358 defendant Gylys John   594892 594892 Gylys, John, of Elham 0
4650487 2246162 2246162 defendant Symme Thomas   594892 594892 Symme, Thomas, of Elham 0
4655063 2247466 2247466 defendant Gyffard Lawrence laborer 594892 594892 Gyffard, Lawrence, of Elham, laborer 0
4655065 2247467 2247467 defendant Pottere Richard laborer 594892 594892 Pottere, Richard, of Elham, laborer 0
4656654 2247975 2247975 defendant Stokham Thomas ploughman 594892 594892 Stokham, Thomas, of Elham, ploughman 4
4696698 2264444 2264444 defendant Courtgate John husbandman 594892 594892 Courtgate, John, of Elham, husbandman 3
4705210 2266999 2266999 defendant Gyles Thomas laborer 594892 594892 Gyles, Thomas, of Elham, laborer 0
4705211 2266999 2266999 defendant Gyles William   594892 594892 Gyles, William, of Elham, laborer, son & heir of John Gyles, son of John Gyles, of Elham 1
4762731 2284324 2284324 defendant Bolle Thomas husbandman 594892 594892 Bolle, Thomas, of Elham, husbandman 0
4762733 2284325 2284325 defendant Bolle Thomas husbandman 594892 594892 Bolle, Thomas, of Elham, husbandman 0
4763023 2284419 2284419 defendant Bolle Thomas husbandman 594892 594892 Bolle, Thomas, of Elham, husbandman 0
4771181 2286969 2286969 defendant Bolle Thomas husbandman 594892 594892 Bolle, Thomas, of Elham, husbandman 2
4782675 2290596 2290596 defendant Orgrove John butcher 594892 594892 Orgrove, John, of Elham, butcher 0
4796043 2294912 2294912 defendant Bolle Thomas husbandman 594892 594892 Bolle, Thomas, of Elham, husbandman 2
4800796 2296438 2296438 defendant Howe William barber 594892 594892 Howe, William, of Elham, barber 0
4808906 2298958 2298958 defendant Courtgate William laborer 594892 594892 Courtgate, William, of Elham, laborer 0
4816543 2301266 2301266 defendant Horton Thomas fuller 594892 594892 Horton, Thomas, of Elham, fuller 1
4843639 2309533 2309533 defendant Sherene or Shereve Robert husbandman 594892 594892 Sherene or Shereve, Robert, of Elham, husbandman 2
4843640 2309533 2309533 defendant Shereve Richard husbandman 594892 594892 Shereve, Richard, of Elham, husbandman 3
4845158 2309997 2309997 defendant Brempton William laborer 594892 594892 Brempton, William, of Elham, laborer 0
4845160 2309998 2309998 defendant Osbarn Simon husbandman 594892 594892 Osbarn, Simon, of Elham, husbandman 0
4845161 2309998 2309998 defendant Ladde John husbandman 594892 594892 Ladde, John, of Elham, husbandman 1
4845162 2309998 2309998 defendant Brompton William husbandman 594892 594892 Brompton, William, of Elham, husbandman 2
4852833 2312304 2312304 defendant Brompton William husbandman 594892 594892 Brompton, William, of Elham, husbandman 0
4872732 2318423 2318423 defendant Brompton William laborer 594892 594892 Brompton, William, of Elham, laborer 0
4877320 2319863 2319863 defendant Barbour Thomas   594892 594892 Barbour, Thomas, of Elham 0
4877328 2319866 2319866 defendant Osbarn John   594892 594892 Osbarn, John, of Elham 0
4892638 2324425 2324425 defendant Waffron John butcher 594892 594892 Waffron, John, of Elham, butcher 0
4907049 2328781 2328781 defendant atte Dane Henry husbandman 594892 594892 atte Dane, Henry, of Elham, husbandman 2
4919668 2332658 2332658 defendant Coppe William husbandman 594892 594892 Coppe, William, of Elham, husbandman 0
4932126 2336443 2336443 defendant Hynkele Roger yeoman 594892 594892 Hynkele, Roger, of Elham, yeoman 0
4956349 2343863 2343863 defendant Mot John husbandman 594892 594892 Mot, John, of Elham, husbandman 0
5011853 2360318 2360318 plaintiff Wreght Nicholas husbandman 594892 594892 Wreght, Nicholas, of Elham, husbandman 0
5034392 2366918 2366918 defendant Ruddok Stephen husbandman 594892 594892 Ruddok, Stephen, of Elham, husbandman 0
5036974 2367682 2367682 defendant Hynkele Roger yeoman 594892 594892 Hynkele, Roger, of Elham, yeoman 0
5095009 2384953 2384953 defendant atte Doune John husbandman 594892 594892 atte Doune, John, of Elham, husbandman 1
5105979 2388188 2388188 defendant Horne John butcher 594892 594892 Horne, John, of Elham, butcher 0
5105991 2388191 2388191 defendant Fox William husbandman 594892 594892 Fox, William, of Elham, husbandman 4
5131166 2395606 2395606 defendant Salkyn Thomas, senior husbandman 594892 594892 Salkyn, Thomas, senior, of Elham, husbandman 0
5131167 2395606 2395606 defendant Salkyn John tailor 594892 594892 Salkyn, John, of Elham, tailor 1
5131168 2395606 2395606 defendant Salkyn John, junior husbandman 594892 594892 Salkyn, John, junior, of Elham, husbandman 2
5131169 2395606 2395606 defendant Salkyn Thomas, junior   594892 594892 Salkyn, Thomas, junior, of Elham, repyr or fish seller 3
5131170 2395606 2395606 defendant Salkyn Henry husbandman 594892 594892 Salkyn, Henry, of Elham, husbandman 4
5179232 2409664 2409664 defendant German Thomas yeoman 594892 594892 German, Thomas, of Elham, yeoman 0
5193704 2413888 2413888 defendant Lad John yeoman 594892 594892 Lad, John, of Elham, yeoman 0
5193705 2413888 2413888 defendant Houchon Thomas   594892 594892 Houchon, Thomas, of Elham, shoe maker 1
5224025 2422710 2422710 defendant Hechon Thomas cordwainer 594892 594892 Hechon, Thomas, of Elham, cordwainer 0
5294927 2443509 2443509 defendant Gilbert Gilbert husbandman 594892 594892 Gilbert, Gilbert, of Elham, baker, Osberne, John, of Elham, husbandman 0
5294928 2443509 2443509 defendant Parker Thomas laborer 594892 594892 Parker, Thomas, of Elham, laborer 1
5294929 2443509 2443509 defendant Parker John laborer 594892 594892 Parker, John, of Elham, laborer 2
5308886 2447699 2447699 defendant Lent John, sen chapman 594892 594892 Lent, John, sen, of Elham, chapman 3
5323906 2452232 2452232 defendant Gybbert Robert baker 594892 594892 Gybbert, Robert, of Elham, baker 0
5323907 2452232 2452232 defendant Ladde Nicholas yeoman 594892 594892 Ladde, Nicholas, of Elham, yeoman 1
5323908 2452232 2452232 defendant Thorold Thomas yeoman 594892 594892 Thorold, Thomas, of Elham, yeoman 2
5323913 2452233 2452233 defendant Gylbert Roger baker 594892 594892 Gylbert, Roger, of Elham, baker 0
5323914 2452233 2452233 defendant Ladde Nicholas yeoman 594892 594892 Ladde, Nicholas, of Elham, yeoman 1
5323915 2452233 2452233 defendant Thorold Thomas yeoman 594892 594892 Thorold, Thomas, of Elham, yeoman 2
5328942 2453734 2453734 defendant Eynder or Gynder John husbandman 594892 594892 Eynder or Gynder, John, of Elham, husbandman 0
5328962 2453741 2453741 defendant A Dane William smith 594892 594892 A Dane, William, of Elham, smith 0
5329470 2453880 2453880 plaintiff at Hothe or at Hethe William (legal representative) 594892 594892 at Hothe or at Hethe, William, of Elham, executor of 0
5329472 2453880 2453880 defendant atte Wode John, senior husbandman 594892 594892 atte Wode, John, senior, of Elham, husbandman 0
5345246 2458684 2458684 defendant Coksell Richard husbandman 594892 594892 Coksell, Richard, of Elham, husbandman 0
5396168 2473991 2473991 defendant Salkyn Henry husbandman 594892 594892 Salkyn, Henry, of Elham, husbandman 0
5423073 2481856 2481856 defendant Salkyn Henry husbandman 594892 594892 Salkyn, Henry, of Elham, husbandman 0
5463345 2493944 2493944 defendant Broke William smith 594892 594892 Broke, William, of Elham, smith 7
5465935 2494738 2494738 defendant Broke William smith 594892 594892 Broke, William, of Elham, smith 5
5474899 2497474 2497474 defendant Rigden Thomas yeoman 594892 594892 Rigden, Thomas, of Elham, yeoman 5

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