names

119 rows where place_id = 586875

✎ 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
3589868 1864472 1864472 defendant Wymbyll William miller 586875 586875 Wymbyll, William, of Wroteham, miller 1
3659982 1913381 1913381 defendant Asen William husbandman 586875 586875 Asen, William, of Wroteham, husbandman 0
3672827 1917513 1917513 defendant Coke Thomas butcher 586875 586875 Coke, Thomas, of Wroteham, butcher 0
3672828 1917513 1917513 defendant Hastlyn William husbandman 586875 586875 Hastlyn, William, of Wroteham, husbandman 1
3672829 1917513 1917513 defendant Wybarns Edward yeoman 586875 586875 Wybarns, Edward, of Wroteham, yeoman 2
3672830 1917513 1917513 defendant Lorkyn George laborer 586875 586875 Lorkyn, George, of Wroteham, laborer 3
3680357 1919935 1919935 plaintiff Richardson Robert yeoman 586875 586875 Richardson, Robert, of Wroteham, yeoman 0
3718603 1932095 1932095 defendant Colyn Robert, senior   586875 586875 Colyn, Robert, senior, of Wroteham 0
3735142 1937228 1937228 defendant Chowne John, senior yeoman 586875 586875 Chowne, John, senior, of Wroteham, yeoman 0
3735143 1937228 1937228 defendant Chowne John, junior yeoman 586875 586875 Chowne, John, junior, of Wroteham, yeoman 1
3735144 1937228 1937228 defendant Hubbard Thomas carpenter 586875 586875 Hubbard, Thomas, of Wroteham, carpenter 2
3744676 1940230 1940230 defendant Dykson Robert chaplain 586875 586875 Dykson, Robert, of Wroteham, chaplain 0
3744677 1940230 1940230 defendant Holcombe John chaplain 586875 586875 Holcombe, John, of Wroteham, chaplain 1
3754331 1943310 1943310 defendant Mosse William husbandman 586875 586875 Mosse, William, of Wroteham, husbandman 0
3759793 1945057 1945057 defendant Hale Nicholas (legal representative) 586875 586875 Hale, Nicholas, of Wroteham, carpenter, executor of 0
3761512 1945611 1945611 defendant Hale William laborer 586875 586875 Hale, William, of Wroteham, laborer 0
3771430 1948756 1948756 defendant Haselyn William yeoman 586875 586875 Haselyn, William, of Wroteham, yeoman 0
3774693 1949816 1949816 defendant A Fenne William husbandman 586875 586875 A Fenne, William, of Wroteham, husbandman 0
3778915 1951122 1951122 defendant Saunder Christopher yeoman 586875 586875 Saunder, Christopher, of Wroteham, yeoman 0
3781671 1952008 1952008 defendant Bets John cooper 586875 586875 Bets, John, of Wroteham, cooper 0
3789291 1954469 1954469 defendant Dogge Richard yeoman 586875 586875 Dogge, Richard, of Wroteham, yeoman 0
3795827 1956563 1956563 defendant Foster Richard miller 586875 586875 Foster, Richard, of Wroteham, miller 0
3819222 1963898 1963898 plaintiff Myller Richard (legal representative) 586875 586875 Myller, Richard, of Wroteham, executrix of 0
3860188 1976901 1976901 defendant Chownyng Christopher husbandman 586875 586875 Chownyng, Christopher, of Wroteham, husbandman 0
3864227 1978228 1978228 defendant Gravesden John husbandman 586875 586875 Gravesden, John, of Wroteham, husbandman 0
3878300 1982991 1982991 defendant Granesden John husbandman 586875 586875 Granesden, John, of Wroteham, husbandman 0
3982997 2018695 2018695 defendant Flexman John laborer 586875 586875 Flexman, John, of Wroteham, laborer 0
3982998 2018695 2018695 defendant Bysshoppe Robert carpenter 586875 586875 Bysshoppe, Robert, of Wroteham, carpenter 1
4014952 2030064 2030064 plaintiff Skynner Daniel gent 586875 586875 Skynner, Daniel, of Wroteham, gent 0
4046333 2041133 2041133 plaintiff Skynner Daniel gent 586875 586875 Skynner, Daniel, of Wroteham, gent 0
4120123 2067484 2067484 defendant Woodgate Edward clothier 586875 586875 Woodgate, Edward, of Wroteham, clothier 0
4165012 2083270 2083270 defendant Brysenden Thomas miller 586875 586875 Brysenden, Thomas, of Wroteham, miller 0
4165013 2083270 2083270 defendant Usmer John yeoman 586875 586875 Usmer, John, of Wroteham, yeoman 1
4311647 2134216 2134216 defendant Lorkyn John yeoman 586875 586875 Lorkyn, John, of Wroteham, yeoman 0
4321062 2137462 2137462 defendant Post or Pese Leonard husbandman 586875 586875 Post or Pese, Leonard, of Wroteham, husbandman 3
4374682 2156007 2156007 defendant Brissenden Robert laborer 586875 586875 Brissenden, Robert, of Wroteham, laborer 2
4591509 2228702 2228702 defendant Lambyn Peter   586875 586875 Lambyn, Peter, of Wroteham 0
4646975 2245176 2245176 defendant Barbour Thomas   586875 586875 Barbour, Thomas, of Wroteham 0
4658064 2248400 2248400 defendant Bowyere John husbandman 586875 586875 Bowyere, John, of Wroteham, husbandman 0
4703193 2266379 2266379 plaintiff Haytes Joan   586875 586875 Haytes, Joan, of Wroteham 0
4703194 2266379 2266379 defendant Tery John brother of William 586875 586875 Tery, John, of Wroteham, brother of William 0
4703195 2266379 2266379 defendant Tery Isabel widow 586875 586875 Tery, Isabel, of Wroteham, widow 1
4759213 2283224 2283224 defendant Turk John smith 586875 586875 Turk, John, of Wroteham, smith 1
4766315 2285459 2285459 defendant Barbour Thomas husbandman 586875 586875 Barbour, Thomas, of Wroteham, husbandman 0
4766316 2285459 2285459 defendant Wronge Stephen smith 586875 586875 Wronge, Stephen, of Wroteham, smith 1
4787870 2292272 2292272 defendant Stokes William farmer 586875 586875 Stokes, William, of Wroteham, farmer 0
4798561 2295729 2295729 defendant Rogger Walter husbandman 586875 586875 Rogger, Walter, of Wroteham, husbandman 0
4856029 2313258 2313258 defendant Michell Simon wheeler 586875 586875 Michell, Simon, of Wroteham, wheeler 0
4856030 2313258 2313258 defendant se Asshe Nicholas husbandman 586875 586875 se Asshe, Nicholas, of Wroteham, husbandman 1
4909163 2329409 2329409 defendant Chepstede John husbandman 586875 586875 Chepstede, John, of Wroteham, husbandman 0
4917882 2332105 2332105 defendant Hobyll or Hovyll Walter fuller 586875 586875 Hobyll or Hovyll, Walter, of Wroteham, fuller 0
4923512 2333786 2333786 defendant atte Hale John carpenter 586875 586875 atte Hale, John, of Wroteham, carpenter 4
4938724 2338498 2338498 plaintiff Clerk Walter yeoman 586875 586875 Clerk, Walter, of Wroteham, yeoman 0
4938726 2338499 2338499 plaintiff Clerk Walter yeoman 586875 586875 Clerk, Walter, of Wroteham, yeoman 0
4963929 2346122 2346122 defendant Pode Thomas chandler 586875 586875 Pode, Thomas, of Wroteham, chandler 0
5030504 2365792 2365792 defendant Taillour alias Grenehill Daniel tanner 586875 586875 Taillour alias Grenehill, Daniel, of Wroteham, tanner 0
5159022 2403757 2403757 defendant Hobill Walter fuller 586875 586875 Hobill, Walter, of Wroteham, fuller 1
5159198 2403806 2403806 defendant Laver John yeoman 586875 586875 Laver, John, of Wroteham, yeoman 0
5195228 2414350 2414350 defendant Cotear Henry husbandman 586875 586875 Cotear, Henry, of Wroteham, husbandman 3
5197654 2415052 2415052 defendant Godewyn John husbandman 586875 586875 Godewyn, John, of Wroteham, husbandman 1
5209167 2418409 2418409 defendant Cotear Henry husbandman 586875 586875 Cotear, Henry, of Wroteham, husbandman 3
5218368 2421105 2421105 defendant Stokys Walter laborer 586875 586875 Stokys, Walter, of Wroteham, laborer 0
5218369 2421105 2421105 defendant Croft Thomas baker 586875 586875 Croft, Thomas, of Wroteham, baker 1
5218372 2421105 2421105 defendant Croft John laborer 586875 586875 Croft, John, of Wroteham, laborer 4
5223635 2422598 2422598 defendant Hayte John carpenter 586875 586875 Hayte, John, of Wroteham, carpenter 4
5238339 2426801 2426801 defendant Gudwyn John husbandman 586875 586875 Gudwyn, John, of Wroteham, husbandman 0
5238340 2426801 2426801 defendant Miller Thomas husbandman 586875 586875 Miller, Thomas, of Wroteham, husbandman 1
5238346 2426803 2426803 defendant Dey Thomas smith 586875 586875 Dey, Thomas, of Wroteham, smith 0
5238347 2426803 2426803 defendant Stoke Walter husbandman 586875 586875 Stoke, Walter, of Wroteham, husbandman 1
5265949 2435105 2435105 defendant Cappe John husbandman 586875 586875 Cappe, John, of Wroteham, husbandman 0
5280670 2439420 2439420 defendant Ifeld William smith 586875 586875 Ifeld, William, of Wroteham, smith 2
5300726 2445181 2445181 defendant Godewyn John yeoman 586875 586875 Godewyn, John, of Wroteham, yeoman 0
5300728 2445181 2445181 defendant Chambre William tailor 586875 586875 Chambre, William, of Wroteham, tailor 2
5300729 2445181 2445181 defendant Nysell Thomas yeoman 586875 586875 Nysell, Thomas, of Wroteham, yeoman 3
5300730 2445181 2445181 defendant Wybarn John tanner 586875 586875 Wybarn, John, of Wroteham, tanner 4
5302421 2445691 2445691 defendant Grene Robert butcher 586875 586875 Grene, Robert, of Wroteham, butcher 0
5319701 2450988 2450988 defendant Wykes John smith 586875 586875 Wykes, John, of Wroteham, smith 4
5335516 2455695 2455695 defendant Godfrey Alice widow 586875 586875 Godfrey, Alice, of Wroteham, widow 0
5361154 2463517 2463517 defendant Fuller John laborer 586875 586875 Fuller, John, of Wroteham, laborer 2
5361767 2463711 2463711 defendant Crouche Peter smith 586875 586875 Crouche, Peter, of Wroteham, smith 0
5385669 2470972 2470972 plaintiff Chamber William tailor 586875 586875 Chamber, William, of Wroteham, tailor 0
5385869 2471032 2471032 defendant Woulreth John husbandman 586875 586875 Woulreth, John, of Wroteham, husbandman 1
5385935 2471050 2471050 plaintiff Clerke Alice   586875 586875 Clerke, Alice, of Wroteham 0
5398066 2474515 2474515 defendant Woulrech John husbandman 586875 586875 Woulrech, John, of Wroteham, husbandman 0
5398138 2474535 2474535 plaintiff Clerke Alice widow 586875 586875 Clerke, Alice, of Wroteham, widow 0
5408339 2477466 2477466 defendant Monke Henry husbandman 586875 586875 Monke, Henry, of Wroteham, husbandman 0
5409891 2477928 2477928 defendant Monke Henry husbandman 586875 586875 Monke, Henry, of Wroteham, husbandman 0
5411133 2478288 2478288 plaintiff Chowne John (legal representative) 586875 586875 Chowne, John, of Wroteham, executors of 0
5411206 2478311 2478311 plaintiff Clerk Alice widow 586875 586875 Clerk, Alice, of Wroteham, widow 0
5416810 2479944 2479944 defendant Fuller John husbandman 586875 586875 Fuller, John, of Wroteham, husbandman 0
5423540 2482005 2482005 defendant Monke Henry husbandman 586875 586875 Monke, Henry, of Wroteham, husbandman 0
5423546 2482006 2482006 defendant Monke Henry husbandman 586875 586875 Monke, Henry, of Wroteham, husbandman 0
5425366 2482561 2482561 plaintiff Clerk Alice widow 586875 586875 Clerk, Alice, of Wroteham, widow 0
5440426 2487040 2487040 defendant Kyng Walter carpenter 586875 586875 Kyng, Walter, of Wroteham, carpenter 0
5440427 2487040 2487040 defendant Bultham Thomas yeoman 586875 586875 Bultham, Thomas, of Wroteham, yeoman 1
5443890 2488091 2488091 plaintiff Clerk Alice widow 586875 586875 Clerk, Alice, of Wroteham, widow 0
5456611 2491901 2491901 plaintiff Clerk Alice widow 586875 586875 Clerk, Alice, of Wroteham, widow 0
5463665 2494048 2494048 defendant Baker William   586875 586875 Baker, William, of Wroteham, parish clerk 0
5463666 2494048 2494048 defendant Sawyer William laborer 586875 586875 Sawyer, William, of Wroteham, laborer 1
5463667 2494048 2494048 defendant Moreys John laborer 586875 586875 Moreys, John, of Wroteham, laborer 2

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