names

112 rows where place_id = 586347

✎ 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
3588496 1864047 1864047 defendant Chybold William brewer 586347 586347 Chybold, William, of West Ham, Essex, brewer 0
3619872 1873790 1873790 defendant Hatton Richard husbandman 586347 586347 Hatton, Richard, of West Ham, Essex, husbandman 0
3619876 1873791 1873791 defendant Hatton Richard husbandman 586347 586347 Hatton, Richard, of West Ham, Essex, husbandman 0
3621789 1874353 1874353 defendant Lynet or Lyvet Robert tanner 586347 586347 Lynet or Lyvet, Robert, of West Ham, Essex, tanner 1
3930239 2000463 2000463 defendant Stanton Richard gent 586347 586347 Stanton, Richard, of West Ham, Essex, gent 0
3930565 2000565 2000565 defendant Shawe Thomas merchant tailor 586347 586347 Shawe, Thomas, of West Ham, Essex, merchant tailor 0
3948726 2006622 2006622 defendant Mewtas Henry gent 586347 586347 Mewtas, Henry, of West Ham, Essex, gent 1
3948730 2006623 2006623 defendant Mewtas Henry gent 586347 586347 Mewtas, Henry, of West Ham, Essex, gent 1
3949312 2006829 2006829 defendant Smyth Stephen clothworker 586347 586347 Smyth, Stephen, of West Ham, Essex, clothworker 1
3954035 2008481 2008481 defendant Smyth Stephen yeoman 586347 586347 Smyth, Stephen, of West Ham, essex, yeoman 0
3973545 2015317 2015317 plaintiff Gybbes Thomas mariner 586347 586347 Gybbes, Thomas, of West Ham, Essex, mariner 0
3977575 2016727 2016727 defendant Freman John yeoman 586347 586347 Freman, John, of West Ham, Essex, yeoman 0
4004219 2026285 2026285 defendant Mewtys Henry esq 586347 586347 Mewtys, Henry, of West Ham, Essex, esq 0
4005821 2026853 2026853 defendant Meawtys Henry esq 586347 586347 Meawtys, Henry, of West Ham, Essex, esq 8
4012155 2029072 2029072 defendant Bentley Richard gent 586347 586347 Bentley, Richard, of West Ham, Essex, gent 0
4023473 2033103 2033103 defendant Scotte Andrew tanner 586347 586347 Scotte, Andrew, of West Ham, Essex, tanner 0
4044082 2040336 2040336 defendant Howarde Henry esq 586347 586347 Howarde, Henry, of West Ham, Essex, esq 0
4044084 2040337 2040337 defendant Howarde Henry esq 586347 586347 Howarde, Henry, of West Ham, Essex, esq 0
4052703 2043397 2043397 defendant Newman William tanner 586347 586347 Newman, William, of West Ham, Essex, tanner 0
4054472 2043989 2043989 defendant Cutler Nicholas gent 586347 586347 Cutler, Nicholas, of West Ham, Essex, gent 0
4057091 2044921 2044921 plaintiff Bruge Anthony gent 586347 586347 Bruge, Anthony, of West Ham, Essex, gent 0
4076064 2051736 2051736 defendant Crompton Francis yeoman 586347 586347 Crompton, Francis, of West Ham, Essex, yeoman 0
4109716 2063732 2063732 defendant Staunton John gent 586347 586347 Staunton, John, of West Ham, Essex, gent 0
4124322 2068991 2068991 defendant Drowte John gent 586347 586347 Drowte, John, of West Ham, Essex, gent 2
4138256 2074050 2074050 defendant Mewtes Hercules gent 586347 586347 Mewtes, Hercules, of West Ham, Essex, gent 0
4169106 2084694 2084694 defendant Edlyne William yeoman 586347 586347 Edlyne, William, of West Ham, Essex, yeoman 0
4211457 2099561 2099561 defendant Middelton John yeoman 586347 586347 Middelton, John, of West Ham, Essex, yeoman 0
4261031 2116654 2116654 defendant Johnson Hamlin innholder 586347 586347 Johnson, Hamlin, of West Ham, Essex, innholder 0
4272239 2120284 2120284 defendant Johnson Hamlyn innholder 586347 586347 Johnson, Hamlyn, of West Ham, Essex, innholder 0
4287434 2125558 2125558 defendant Leedes Miles yeoman 586347 586347 Leedes, Miles, of West Ham, Essex, yeoman 0
4287436 2125559 2125559 defendant Pragle Richard yeoman 586347 586347 Pragle, Richard, of West Ham, Essex, yeoman 0
4291747 2127125 2127125 defendant Townsend William yeoman 586347 586347 Townsend, William, of West Ham, Essex, yeoman 3
4300399 2130244 2130244 defendant Townsend William yeoman 586347 586347 Townsend, William, of West Ham, Essex, yeoman 3
4335898 2142286 2142286 defendant Mewtys Hercules (legal representative) 586347 586347 Mewtys, Hercules, of West Ham, Essex, esq, executrix of 0
4341555 2144323 2144323 defendant Ovenden Richard gent 586347 586347 Ovenden, Richard, of West Ham, Essex, gent 1
4373624 2155637 2155637 defendant Brouncker Henry esq 586347 586347 Brouncker, Henry, of West Ham, Essex, esq 0
4395157 2162968 2162968 defendant Smyth Richard gent 586347 586347 Smyth, Richard, of West Ham, Essex, gent 0
4396297 2163336 2163336 defendant Myller John mariner 586347 586347 Myller, John, of West Ham, Essex, mariner 1
4402579 2165449 2165449 defendant Tyman Adam yeoman 586347 586347 Tyman, Adam, of West Ham, Essex, yeoman 1
4824645 2303756 2303756 defendant Tressther Richard husbandman 586347 586347 Tressther, Richard, of West Ham, Essex, husbandman 3
4824654 2303757 2303757 defendant Tressther Richard husbandman 586347 586347 Tressther, Richard, of West Ham, Essex, husbandman 3
4824663 2303758 2303758 defendant Tressther Richard husbandman 586347 586347 Tressther, Richard, of West Ham, Essex, husbandman 3
4829104 2305144 2305144 defendant Reynold Peter carpenter 586347 586347 Reynold, Peter, of West Ham, Essex, carpenter 1
4979150 2350721 2350721 defendant Lorchyn John fisher 586347 586347 Lorchyn, John, of West Ham, Essex, fisher 0
5046252 2370511 2370511 defendant William John   586347 586347 William, John, of West Ham, Essex, servant 0
5075309 2379113 2379113 defendant Algore John fisher 586347 586347 Algore, John, of West Ham, Essex, fisher 0
5077297 2379711 2379711 defendant Catesby alias Heggeman John husbandman 586347 586347 Catesby alias Heggeman, John, of West Ham, Essex, husbandman 1
5088167 2382914 2382914 defendant Danyell John fisher 586347 586347 Danyell, John, of West Ham, Essex, fisher 0
5114073 2390511 2390511 defendant Robynson William laborer 586347 586347 Robynson, William, of West Ham, Essex, laborer 1
5127108 2394406 2394406 defendant Heggeman Thomas husbandman 586347 586347 Heggeman, Thomas, of West Ham, Essex, husbandman 2
5132407 2395974 2395974 defendant Do--wych John yeoman 586347 586347 Do--wych, John, of West Ham, Essex, yeoman 4
5142692 2398988 2398988 defendant Algor Tytlok John fisher 586347 586347 Algor Tytlok, John, of West Ham, Essex, fisher 0
5143304 2399178 2399178 defendant Flecher Nicholas yeoman 586347 586347 Flecher, Nicholas, of West Ham, Essex, yeoman 1
5143307 2399179 2399179 defendant Fletcher Nicholas yeoman 586347 586347 Fletcher, Nicholas, of West Ham, Essex, yeoman 1
5152163 2401769 2401769 defendant Donwych John yeoman 586347 586347 Donwych, John, of West Ham, Essex, yeoman 4
5164078 2405227 2405227 defendant Algore Tittok John fishmonger 586347 586347 Algore Tittok, John, of West Ham, Essex, fishmonger 0
5164085 2405228 2405228 defendant Algore Tyttok John, sen fishmonger & husbandman 586347 586347 Algore Tyttok, John, sen, of West Ham, Essex, fishmonger & husbandman 0
5164595 2405377 2405377 defendant Fleccher Nicholas yeoman 586347 586347 Fleccher, Nicholas, of West Ham, Essex, yeoman 0
5167110 2406113 2406113 defendant Danyell Richard husbandman 586347 586347 Danyell, Richard, of West Ham, Essex, husbandman 0
5170036 2406972 2406972 defendant Donwich John yeoman 586347 586347 Donwich, John, of West Ham, Essex, yeoman 0
5170038 2406973 2406973 defendant Donwich John yeoman 586347 586347 Donwich, John, of West Ham, Essex, yeoman 0
5187379 2412035 2412035 defendant Donwich John yeoman 586347 586347 Donwich, John, of West Ham, Essex, yeoman 0
5205577 2417377 2417377 defendant Donwych John yeoman 586347 586347 Donwych, John, of West Ham, Essex, yeoman 0
5215684 2420311 2420311 defendant Frend Thomas husbandman 586347 586347 Frend, Thomas, of West Ham, Essex, husbandman 0
5222400 2422261 2422261 defendant Mynnes Richard waterman 586347 586347 Mynnes, Richard, of West Ham, Essex, waterman 1
5273249 2437244 2437244 defendant Lewys John husbandman 586347 586347 Lewys, John, of West Ham, Essex, husbandman 1
5287378 2441332 2441332 defendant Burgeys John miller 586347 586347 Burgeys, John, of West Ham, Essex, miller 0
5287381 2441333 2441333 defendant Burgeys John miller 586347 586347 Burgeys, John, of West Ham, Essex, miller 0
5289702 2441990 2441990 defendant Anyse or Avyse John fisher 586347 586347 Anyse or Avyse, John, of West Ham, Essex, fisher 0
5292319 2442754 2442754 defendant Estbroke William, junior husbandman 586347 586347 Estbroke, William, junior, of West Ham, Essex, husbandman 0
5292323 2442755 2442755 defendant Estbroke William, junior husbandman 586347 586347 Estbroke, William, junior, of West Ham, Essex, husbandman 0
5300902 2445228 2445228 defendant Frende Thomas laborer 586347 586347 Frende, Thomas, of West Ham, Essex, laborer 3
5300908 2445229 2445229 defendant Frende Thomas laborer 586347 586347 Frende, Thomas, of West Ham, Essex, laborer 3
5312561 2448789 2448789 defendant Benyngton Henry yeoman 586347 586347 Benyngton, Henry, of West Ham, Essex, yeoman 0
5322154 2451697 2451697 defendant Whitehed William husbandman 586347 586347 Whitehed, William, of West Ham, Essex, husbandman 1
5337850 2456402 2456402 defendant Burgeys John miller 586347 586347 Burgeys, John, of West Ham, Essex, miller 0
5352272 2460811 2460811 defendant Baldwyn William yeoman 586347 586347 Baldwyn, William, of West Ham, Essex, yeoman 0
5355118 2461669 2461669 defendant Baldewyn William, senior husbandman 586347 586347 Baldewyn, William, senior, of West Ham, Essex, husbandman 2
5365749 2464944 2464944 defendant Shawe William husbandman 586347 586347 Shawe, William, of West Ham, Essex, husbandman 2
5371726 2466745 2466745 defendant Baldewyn William, senior husbandman 586347 586347 Baldewyn, William, senior, of West Ham, Essex, husbandman 0
5371730 2466746 2466746 defendant Baldewyn William, senior husbandman 586347 586347 Baldewyn, William, senior, of West Ham, Essex, husbandman 0
5374501 2467628 2467628 defendant Jeny Hugh yeoman 586347 586347 Jeny, Hugh, of West Ham, Essex, yeoman 0
5380860 2469582 2469582 defendant Baldwyn William yeoman 586347 586347 Baldwyn, William, of West Ham, Essex, yeoman 1
5382261 2469985 2469985 defendant Jeny Hugh yeoman 586347 586347 Jeny, Hugh, of West Ham, Essex, yeoman 0
5382266 2469986 2469986 defendant Chiboll William brewer 586347 586347 Chiboll, William, of West Ham, Essex, brewer 0
5391174 2472554 2472554 defendant Jeny Hugh yeoman 586347 586347 Jeny, Hugh, of West Ham, Essex, yeoman 0
5391179 2472555 2472555 defendant Chybboll John brewer 586347 586347 Chybboll, John, of West Ham, Essex, brewer 0
5426787 2482954 2482954 defendant Marchall Humphrey carpenter 586347 586347 Marchall, Humphrey, of West Ham, Essex, carpenter 0
5435704 2485616 2485616 defendant Jenyns John yeoman 586347 586347 Jenyns, John, of West Ham, Essex, yeoman 0
5437105 2486035 2486035 defendant Marshall Humphrey carpenter 586347 586347 Marshall, Humphrey, of West Ham, Essex, carpenter 1
5442185 2487581 2487581 defendant Cheboll William brewer 586347 586347 Cheboll, William, of West Ham, Essex, brewer 0
5451579 2490347 2490347 defendant Marshall Humphrey carpenter 586347 586347 Marshall, Humphrey, of West Ham, Essex, carpenter 1
5451585 2490348 2490348 defendant Marshall Humphrey carpenter 586347 586347 Marshall, Humphrey, of West Ham, Essex, carpenter 1
5454918 2491388 2491388 defendant Cheboll William brewer 586347 586347 Cheboll, William, of West Ham, Essex, brewer 0
5454920 2491389 2491389 defendant Cheboll William brewer 586347 586347 Cheboll, William, of West Ham, Essex, brewer 0
5459169 2492643 2492643 defendant Chyboll William brewer 586347 586347 Chyboll, William, of West Ham, Essex, brewer 0
5462071 2493549 2493549 defendant Baldewyn William, sen husbandman 586347 586347 Baldewyn, William, sen, of West Ham, Essex, husbandman 0
5462078 2493550 2493550 defendant Glastok John grasier 586347 586347 Glastok, John, of West Ham, Essex, grasier 0
5462080 2493550 2493550 defendant Rote John husbandman 586347 586347 Rote, John, of West Ham, Essex, husbandman 2
5466765 2495008 2495008 defendant Cheboll William brewer 586347 586347 Cheboll, William, of West Ham, Essex, brewer 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);