names

103 rows where place_id = 592223

✎ 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
3606981 1869846 1869846 defendant Smyth Thomas raffman 592223 592223 Smyth, Thomas, of North Todenham, raffman 0
3617076 1872964 1872964 defendant Farewell William yeoman 592223 592223 Farewell, William, of North Todenham, yeoman 1
3622580 1874597 1874597 defendant Stevenys Thomas husbandman 592223 592223 Stevenys, Thomas, of North Todenham, husbandman 0
3688706 1922628 1922628 plaintiff Denys William, senior   592223 592223 Denys, William, senior, of North Todenham 0
3703518 1927374 1927374 plaintiff Denys William, senior   592223 592223 Denys, William, senior, of North Todenham 0
3752548 1942724 1942724 defendant Salton Richard husbandman 592223 592223 Salton, Richard, of North Todenham, husbandman 0
3760899 1945414 1945414 defendant Dennys Will (legal representative) 592223 592223 Dennys, Will, of North Todenham, yeoman, executors of 0
3769303 1948053 1948053 defendant Salton Richard husbandman 592223 592223 Salton, Richard, of North Todenham, husbandman 0
3779029 1951165 1951165 defendant Denys William (legal representative) 592223 592223 Denys, William, of North Todenham, yeoman, executors of 0
3917751 1996292 1996292 defendant Peers Thomas yeoman 592223 592223 Peers, Thomas, of North Todenham, yeoman 0
3924762 1998600 1998600 defendant Braunche John husbandman 592223 592223 Braunche, John, of North Todenham, husbandman 0
4502887 2201477 2201477 defendant Pancok John   592223 592223 Pancok, John, of North Todenham 1
4630798 2240522 2240522 defendant Thaxstere Richard   592223 592223 Thaxstere, Richard, of North Todenham 3
4732633 2275383 2275383 defendant Harneys or Harveys Richard (legal representative) 592223 592223 Harneys or Harveys, Richard, of North Todenham, executrix of 0
4732634 2275383 2275383 defendant Harneys or Harveys Katherine widow 592223 592223 Harneys or Harveys, Katherine, of North Todenham, widow 1
4767516 2285818 2285818 defendant Baroun Walter yeoman 592223 592223 Baroun, Walter, of North Todenham, yeoman 1
4798311 2295660 2295660 defendant Boteller William (legal representative) 592223 592223 Boteller, William, of North Todenham, esq, executors of 0
4798313 2295660 2295660 defendant Boteller Joan widow 592223 592223 together with Boteller, Joan, of North Todenham, widow 2
4892205 2324308 2324308 defendant Collys Thomas yeoman 592223 592223 Collys, Thomas, of North Todenham, yeoman 0
4914132 2330932 2330932 defendant Lek Robert husbandman 592223 592223 Lek, Robert, of North todenham, husbandman 0
4946157 2340782 2340782 defendant Draper William husbandman 592223 592223 Draper, William, of North Todenham, husbandman 0
4946158 2340782 2340782 defendant Gerard Richard husbandman 592223 592223 Gerard, Richard, of North Todenham, husbandman 1
4950009 2341972 2341972 defendant Wryght Robert chaplain 592223 592223 Wryght, Robert, of North Todenham, chaplain 6
4953345 2342965 2342965 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
4953346 2342965 2342965 defendant Styward Richard husbandman 592223 592223 Styward, Richard, of North Todenham, husbandman 1
4953347 2342965 2342965 defendant Marett Joan   592223 592223 Marett, Joan, of North Todenham, widow of Marett, Richard 2
4958015 2344365 2344365 defendant Clubbe William husbandman 592223 592223 Clubbe, William, of North Todenham, husbandman 0
4962133 2345578 2345578 defendant Norwyche Robert husbandman 592223 592223 Norwyche, Robert, of North Todenham, husbandman 0
5033730 2366744 2366744 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
5043770 2369764 2369764 plaintiff Gerard Richard fishmonger 592223 592223 Gerard, Richard, of North Todenham, fishmonger 0
5044345 2369940 2369940 defendant Draper William yeoman 592223 592223 Draper, William, of North Todenham, yeoman 0
5051487 2372058 2372058 defendant Gogneye Roger yeoman 592223 592223 Gogneye, Roger, of North Todenham, yeoman 0
5052619 2372374 2372374 defendant Gogney John barker 592223 592223 Gogney, John, of North Todenham, barker 0
5055357 2373188 2373188 defendant Gerard Ralph yeoman 592223 592223 Gerard, Ralph, of North Todenham, yeoman 0
5055358 2373188 2373188 defendant Wryght Adam   592223 592223 Wryght, Adam, of North Todenham, servant 1
5061868 2375145 2375145 defendant Gogeney Henry husbandman 592223 592223 Gogeney, Henry, of North Todenham, husbandman 1
5061869 2375145 2375145 defendant Drake John chaplain 592223 592223 Drake, John, of North Todenham, chaplain 2
5062028 2375200 2375200 defendant Gogney John yeoman 592223 592223 Gogney, John, of North Todenham, yeoman 0
5062110 2375223 2375223 defendant Draper Margaret widow 592223 592223 Draper, Margaret, of North Todenham, widow 1
5074726 2378946 2378946 defendant Blakhed Thomas husbandman 592223 592223 Blakhed, Thomas, of North Todenham, husbandman 1
5080359 2380619 2380619 plaintiff Watyr Richard   592223 592223 Watyr, Richard, of North Todenham 1
5080360 2380619 2380619 defendant Bron John husbandman 592223 592223 Bron, John, of North Todenham, husbandman 0
5080361 2380619 2380619 defendant Bron Walter husbandman 592223 592223 Bron, Walter, of North Todenham, husbandman 1
5084914 2381996 2381996 defendant Leek Thomas husbandman 592223 592223 Leek, Thomas, of North Todenham, husbandman 0
5084919 2381997 2381997 defendant Harneys or Harveys Richard husbandman 592223 592223 Harneys or Harveys, Richard, of North Todenham, husbandman 0
5086074 2382318 2382318 defendant Gogney John yeoman 592223 592223 Gogney, John, of North Todenham, yeoman 0
5091056 2383779 2383779 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
5102751 2387219 2387219 defendant Bron Thomas husbandman 592223 592223 Bron, Thomas, of North Todenham, husbandman 0
5119751 2392216 2392216 defendant Gerard Richard husbandman 592223 592223 Gerard, Richard, of North Todenham, husbandman 2
5131408 2395675 2395675 defendant Blakhod Thomas husbandman 592223 592223 Blakhod, Thomas, of North Todenham, husbandman 0
5131409 2395675 2395675 defendant Styward Richard yeoman 592223 592223 Styward, Richard, of North Todenham, yeoman 1
5139847 2398130 2398130 defendant Peyntour William hsibandman 592223 592223 Peyntour, William, of North Todenham, hsibandman 0
5170003 2406962 2406962 defendant Gogeney Henry smith 592223 592223 Gogeney, Henry, of North Todenham, smith 0
5187331 2412020 2412020 defendant Gogeney Henry husbandman 592223 592223 Gogeney, Henry, of North Todenham, husbandman 0
5209738 2418587 2418587 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
5215469 2420248 2420248 defendant Broun Thomas   592223 592223 Broun, Thomas, of North Todenham, husbandman, son of Broun, John 0
5235235 2425884 2425884 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
5241904 2427829 2427829 defendant Gerard Richard yeoman 592223 592223 Gerard, Richard, of North Todenham, yeoman 0
5257925 2432601 2432601 defendant Harveys William chaplain 592223 592223 Harveys, William, of North Todenham, chaplain 0
5277871 2438616 2438616 defendant Gryme John husbandman 592223 592223 Gryme, John, of North Todenham, husbandman 0
5277872 2438616 2438616 defendant Gogeney Henry husbandman 592223 592223 Gogeney, Henry, of North Todenham, husbandman 1
5288916 2441764 2441764 defendant Harnesse Richard husbandman 592223 592223 Harnesse, Richard, of North Todenham, husbandman 0
5313854 2449167 2449167 defendant Felawe James laborer 592223 592223 Felawe, James, of North Todenham, laborer 2
5313863 2449168 2449168 defendant Felawe James laborer 592223 592223 Felawe, James, of North Todenham, laborer 5
5317451 2450305 2450305 defendant Harveys Richard husbandman 592223 592223 Harveys, Richard, of North Todenham, husbandman 0
5322721 2451872 2451872 defendant Leke Walter husbandman 592223 592223 Leke, Walter, of North Todenham, husbandman 1
5323553 2452125 2452125 defendant Lek Walter husbandman 592223 592223 Lek, Walter, of North Todenham, husbandman 2
5323555 2452125 2452125 defendant Castelton John laborer 592223 592223 Castelton, John, of North Todenham, laborer 4
5324385 2452380 2452380 defendant Wacy William husbandman 592223 592223 Wacy, William, of North Todenham, husbandman 0
5330528 2454217 2454217 defendant Blachede Thomas pedder 592223 592223 Blachede, Thomas, of North Todenham, pedder 2
5345830 2458834 2458834 defendant Leek Walter husbandman 592223 592223 Leek, Walter, of North Todenham, husbandman 4
5345839 2458835 2458835 defendant Leek Walter husbandman 592223 592223 Leek, Walter, of North Todenham, husbandman 4
5347714 2459439 2459439 defendant Bange John yeoman 592223 592223 Bange, John, of North Todenham, yeoman 0
5353134 2461059 2461059 defendant Bange John yeoman 592223 592223 Bange, John, of North Todenham, yeoman 1
5378686 2468918 2468918 defendant Leek Walter husbandman 592223 592223 Leek, Walter, of North Todenham, husbandman 1
5378689 2468918 2468918 defendant Northgate alias Felawe John laborer 592223 592223 Northgate alias Felawe, John, of North Todenham, laborer 4
5388481 2471758 2471758 plaintiff Gyrlyng William   592223 592223 Gyrlyng, William, of North Todenham 0
5388482 2471758 2471758 defendant Gogeney Henry yeoman 592223 592223 Gogeney, Henry, of North Todenham, yeoman 0
5401080 2475373 2475373 plaintiff Gyrlyng William   592223 592223 Gyrlyng, William, of North Todenham 0
5401081 2475373 2475373 defendant Gogeney Henry yeoman 592223 592223 Gogeney, Henry, of North Todenham, yeoman 0
5401082 2475374 2475374 plaintiff Gyrlyng William   592223 592223 Gyrlyng, William, of North Todenham 0
5401083 2475374 2475374 defendant Gogeney Henry yeoman 592223 592223 Gogeney, Henry, of North Todenham, yeoman 0
5414105 2479154 2479154 plaintiff Gyrlyng William   592223 592223 Gyrlyng, William, of North Todenham 0
5414106 2479154 2479154 defendant Gogeney Henry yeoman 592223 592223 Gogeney, Henry, of North Todenham, yeoman 0
5416549 2479868 2479868 defendant Leke Walter husbandman 592223 592223 Leke, Walter, of North Todenham, husbandman 0
5433459 2484967 2484967 defendant Leke Walter husbandman 592223 592223 Leke, Walter, of North Todenham, husbandman 0
5463311 2493938 2493938 defendant Garrard Richard, sen (legal representative) 592223 592223 Garrard, Richard, sen, of North Todenham, yeoman, executor of 0
5471365 2496376 2496376 defendant Bang John yeoman 592223 592223 Bang, John, of North Todenham, yeoman 1
5482608 2499739 2499739 defendant Bang John yeoman 592223 592223 Bang, John, of North Todenham, yeoman 0
5482611 2499740 2499740 defendant Bang John yeoman 592223 592223 Bang, John, of North Todenham, yeoman 0
5495180 2503454 2503454 defendant Felawe James husbandman 592223 592223 Felawe, James, of North Todenham, husbandman 2
5496646 2503914 2503914 defendant Fraunsham John butcher 592223 592223 Fraunsham, John, of North Todenham, butcher 2
5499020 2504643 2504643 defendant Bangges John yeoman 592223 592223 Bangges, John, of North Todenham, yeoman 0
5505949 2506783 2506783 defendant Farewell William husbandman 592223 592223 Farewell, William, of North Todenham, husbandman 0
5514955 2509516 2509516 defendant Bange John yeoman 592223 592223 Bange, John, of North Todenham, yeoman 0
5520443 2511214 2511214 defendant Smyth Thomas yeoman 592223 592223 Smyth, Thomas, of North Todenham, yeoman 1
5536176 2515809 2515809 defendant Droury Thomas thatcher 592223 592223 Droury, Thomas, of North Todenham, thatcher 0
5567382 2525039 2525039 defendant Smyth Joan widow 592223 592223 Smyth, Joan, of North Todenham, widow 0
5577583 2528054 2528054 defendant Drory Thomas husbandman 592223 592223 Drory, Thomas, of North Todenham, husbandman 0
5582401 2529569 2529569 defendant Clerk Andrew yeoman 592223 592223 Clerk, Andrew, of North Todenham, yeoman 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);