names

75 rows where place_id = 596050

✎ 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
3589313 1864300 1864300 defendant Fabyan Robert (legal representative) 596050 596050 Fabyan, Robert, of Coggeshale, Essex, clothman, executrix of 0
3592469 1865260 1865260 defendant Clerk Thomas (legal representative) 596050 596050 Clerk, Thomas, of Coggeshale, Essex, fuller, executors of 1
3622900 1874692 1874692 defendant Parker John sherman 596050 596050 Parker, John, of Coggeshale, Essex, sherman 0
4445846 2183644 2183644 plaintiff Sewale John   596050 596050 Sewale, John, of Coggeshale, Essex 1
4507038 2202672 2202672 defendant Strogyll John dyer 596050 596050 Strogyll, John, of Coggeshale, Essex, dyer 0
4508518 2203138 2203138 defendant Stoure Thomas   596050 596050 Stoure, Thomas, of Coggeshale, Essex 0
4557581 2218306 2218306 defendant Sewale Robert esq 596050 596050 Sewale, Robert, of Coggeshale, Essex, esq 0
4557586 2218307 2218307 defendant Sewale Robert esq 596050 596050 Sewale, Robert, of Coggeshale, Essex, esq 0
4568191 2221622 2221622 defendant Sewale Robert esq 596050 596050 Sewale, Robert, of Coggeshale, Essex, esq 0
4576330 2224104 2224104 defendant Belle Hugh dyer 596050 596050 Belle, Hugh, of Coggeshale, Essex, dyer 0
4697489 2264701 2264701 defendant Sayer Thomas dyer 596050 596050 Sayer, Thomas, of Coggeshale, Essex, dyer 2
4758264 2282961 2282961 defendant Dacre Robert esq 596050 596050 Dacre, Robert, of Coggeshale, Essex, esq 1
4845428 2310082 2310082 defendant Werk William mercer 596050 596050 Werk, William, of Coggeshale, Essex, mercer 0
4889183 2323403 2323403 defendant Leighton Robert husbandman 596050 596050 Leighton, Robert, of Coggeshale, Essex, husbandman 2
4890654 2323833 2323833 defendant Leyghton Robert husbandman 596050 596050 Leyghton, Robert, of Coggeshale, Essex, husbandman 2
4897149 2325766 2325766 defendant Leyghton Robert husbandman 596050 596050 Leyghton, Robert, of Coggeshale, Essex, husbandman 2
4906035 2328484 2328484 defendant Fabyan John merchant 596050 596050 (Fabyan, John, of Coggeshale, Essex, merchant 1
4906194 2328529 2328529 defendant Leghton Robert husbandman 596050 596050 Leghton, Robert, of Coggeshale, Essex, husbandman 2
4952708 2342767 2342767 defendant Sharpe Richard chapman 596050 596050 Sharpe, Richard, of Coggeshale, Essex, chapman 2
4980982 2351245 2351245 defendant Polstede William pedder 596050 596050 Polstede, William, of Coggeshale, Essex, pedder 1
5011561 2360245 2360245 defendant Blunster William dyer 596050 596050 Blunster, William, of Coggeshale, Essex, dyer 3
5011606 2360253 2360253 defendant Blunster William dyer 596050 596050 Blunster, William, of Coggeshale, Essex, dyer 3
5020540 2362897 2362897 defendant Werk William chapman 596050 596050 Werk, William, of Coggeshale, Essex, chapman 0
5023873 2363893 2363893 defendant Reydon John fuller 596050 596050 Reydon, John, of Coggeshale, Essex, fuller 0
5105155 2387946 2387946 defendant Whyte William weaver 596050 596050 Whyte, William, of Coggeshale, Essex, weaver 0
5105161 2387948 2387948 defendant Wyborgh or Wyborowe William weaver 596050 596050 Wyborgh or Wyborowe, William, of Coggeshale, Essex, weaver 0
5105191 2387957 2387957 defendant Lamberd John, senior weaver 596050 596050 Lamberd, John, senior, of Coggeshale, Essex, weaver 3
5105196 2387958 2387958 defendant Lamberd John, senior weaver 596050 596050 Lamberd, John, senior, of Coggeshale, Essex, weaver 3
5183245 2410841 2410841 defendant Oldehall William draper 596050 596050 Oldehall, William, of Coggeshale, Essex, draper 0
5183247 2410842 2410842 defendant Oldehall William draper 596050 596050 Oldehall, William, of Coggeshale, Essex, draper 0
5196078 2414600 2414600 defendant Graveley Thomas fishmonger 596050 596050 Graveley, Thomas, of Coggeshale, Essex, fishmonger 4
5203793 2416860 2416860 defendant Oldehall William draper 596050 596050 Oldehall, William, of Coggeshale, Essex, draper 0
5203795 2416861 2416861 defendant Oldehall William draper 596050 596050 Oldehall, William, of Coggeshale, Essex, draper 0
5209521 2418522 2418522 defendant Graveley Thomas fishmonger 596050 596050 Graveley, Thomas, of Coggeshale, Essex, fishmonger 4
5262407 2433985 2433985 defendant Doreward William esq 596050 596050 Doreward, William, of Coggeshale, Essex, esq 0
5262408 2433986 2433986 plaintiff Oldhalle William merchant 596050 596050 Oldhalle, William, of Coggeshale, Essex, merchant 0
5264921 2434787 2434787 defendant Oldhall William draper 596050 596050 Oldhall, William, of Coggeshale, Essex, draper 2
5266239 2435195 2435195 defendant Mereld Robert yeoman 596050 596050 (Mereld, Robert, of Coggeshale, Essex, yeoman 1
5272273 2436962 2436962 defendant Doreward William esq 596050 596050 Doreward, William, of Coggeshale, Essex, esq 0
5275019 2437774 2437774 defendant Durward William esq 596050 596050 Durward, William, of Coggeshale, Essex, esq 0
5286059 2440931 2440931 defendant Swetyng John dyer 596050 596050 Swetyng, John, of Coggeshale, Essex, dyer 0
5288007 2441504 2441504 defendant Swetyng John clothman 596050 596050 Swetyng, John, of Coggeshale, Essex, clothman 0
5297942 2444409 2444409 defendant Scarlet William clothmaker 596050 596050 Scarlet, William, of Coggeshale, Essex, clothmaker 0
5307537 2447266 2447266 defendant Barbour John clothman 596050 596050 Barbour, John, of Coggeshale, Essex, clothman 1
5308493 2447575 2447575 defendant Durward William esq 596050 596050 Durward, William, of Coggeshale, Essex, esq 0
5308803 2447672 2447672 defendant Aunsell John smith 596050 596050 Aunsell, John, of Coggeshale, Essex, smith 0
5315562 2449721 2449721 defendant Swetyng William clothmaker 596050 596050 Swetyng, William, of Coggeshale, Essex, clothmaker 0
5319656 2450973 2450973 defendant Scarlet William clothman 596050 596050 Scarlet, William, of Coggeshale, Essex, clothman 0
5325887 2452828 2452828 defendant Scarlet William clothier 596050 596050 Scarlet, William, of Coggeshale, Essex, clothier 0
5332101 2454678 2454678 plaintiff Chapman John, junior weaver 596050 596050 Chapman, John, junior, of Coggeshale, Essex, weaver 0
5342737 2457927 2457927 plaintiff Sharp Nicholas (legal representative) 596050 596050 Sharp, Nicholas, of Coggeshale, Essex, esq, executors of 0
5351810 2460668 2460668 defendant Auncell John smith 596050 596050 Auncell, John, of Coggeshale, Essex, smith 2
5396055 2473959 2473959 defendant Clerk Thomas   596050 596050 Clerk, Thomas, of Coggeshale, Essex, cloth man 1
5396057 2473960 2473960 defendant Clerk Thomas   596050 596050 Clerk, Thomas, of Coggeshale, Essex, cloth man 0
5398058 2474512 2474512 defendant Clerk John, senior fuller 596050 596050 Clerk, John, senior, of Coggeshale, Essex, fuller 0
5398060 2474513 2474513 defendant Clerk John, senior fuller 596050 596050 Clerk, John, senior, of Coggeshale, Essex, fuller 0
5409346 2477766 2477766 defendant Clerk Thomas clothman 596050 596050 Clerk, Thomas, of Coggeshale, Essex, clothman 0
5411199 2478308 2478308 defendant Clerk John, sen fuller 596050 596050 Clerk, John, sen, of Coggeshale, Essex, fuller 0
5411201 2478309 2478309 defendant Clerk John, sen fuller 596050 596050 Clerk, John, sen, of Coggeshale, Essex, fuller 0
5429861 2483873 2483873 defendant Clerke John clothman 596050 596050 Clerke, John, of Coggeshale, Essex, clothman 0
5443671 2488028 2488028 defendant Clerke John, senior clothman 596050 596050 Clerke, John, senior, of Coggeshale, Essex, clothman 0
5445492 2488549 2488549 defendant Clerk John clothman 596050 596050 Clerk, John, of Coggeshale, Essex, clothman 0
5453419 2490912 2490912 defendant Clerk John, senior clothman 596050 596050 Clerk, John, senior, of Coggeshale, Essex, clothman 0
5454004 2491089 2491089 defendant Clarke John, sen clothman 596050 596050 Clarke, John, sen, of Coggeshale, Essex, clothman 0
5459344 2492705 2492705 defendant Clerke John, sen clothman 596050 596050 Clerke, John, sen, of Coggeshale, Essex, clothman 0
5465892 2494717 2494717 defendant Clarke John, sen clothman 596050 596050 Clarke, John, sen, of Coggeshale, Essex, clothman 0
5465895 2494718 2494718 defendant Clerke John, sen clothman 596050 596050 Clerke, John, sen, of Coggeshale, Essex, clothman 0
5476838 2498077 2498077 defendant Clerk John clothman 596050 596050 Clerk, John, of Coggeshale, Essex, clothman 0
5482257 2499637 2499637 defendant Clerk John clothman 596050 596050 Clerk, John,of Coggeshale, Essex, clothman 0
5505984 2506794 2506794 defendant Fabyan Robert clothman 596050 596050 Fabyan, Robert, of Coggeshale, Essex, clothman 0
5514303 2509324 2509324 defendant Poll Andrew clothmaker 596050 596050 Poll, Andrew, of Coggeshale, Essex, clothmaker 0
5521432 2511519 2511519 plaintiff Clerke John, senior fuller 596050 596050 Clerke, John, senior, of Coggeshale, Essex, fuller 0
5521434 2511520 2511520 plaintiff Clerke John, senior fuller 596050 596050 Clerke, John, senior, of Coggeshale, Essex, fuller 0
5542968 2517920 2517920 defendant Olney Thomas gent 596050 596050 Olney, Thomas, of Coggeshale, Essex, gent 0
5542970 2517921 2517921 defendant Olney Thomas gent 596050 596050 Olney, Thomas, of Coggeshale, Essex, gent 0

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