names

70 rows where place_id = 589328

✎ 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
3597239 1866760 1866760 defendant Marler Richard husbandman 589328 589328 Marler, Richard, of Lynstede, husbandman 0
3785478 1953247 1953247 defendant Motte Geoffrey husbandman 589328 589328 Motte, Geoffrey, of Lynstede, husbandman 3
3791681 1955243 1955243 defendant Everard Ralph esq 589328 589328 Everard, Ralph, of Lynstede, esq 2
3808841 1960645 1960645 defendant Everard Ralph esq 589328 589328 Everard, Ralph, of Lynstede, esq 2
4529443 2209487 2209487 defendant Longe Henry   589328 589328 Longe, Henry, of Lynstede 0
4611438 2234639 2234639 defendant Baret Geoffrey   589328 589328 Baret, Geoffrey, of Lynstede 0
4616472 2236146 2236146 defendant Cotyng John   589328 589328 Cotyng, John, of Lynstede 3
4651066 2246334 2246334 defendant Gold Thomas chaplain 589328 589328 Gold, Thomas, of Lynstede, chaplain 4
4661488 2249421 2249421 defendant de Hawe Roger scrivener 589328 589328 de Hawe, Roger, of Lynstede, scrivener 0
4731334 2275000 2275000 defendant Elyot John yeoman 589328 589328 Elyot, John, of Lynstede, yeoman 0
4747389 2279740 2279740 defendant Letecote William husbandman 589328 589328 Letecote, William, of Lynstede, husbandman 0
4762662 2284302 2284302 defendant Wynston Thomas carpenter 589328 589328 Wynston, Thomas, of Lynstede, carpenter 2
4762663 2284302 2284302 defendant Olney William laborer 589328 589328 Olney, William, of Lynstede, laborer 3
4823328 2303382 2303382 defendant Cook William yeoman 589328 589328 Cook, William, of Lynstede, yeoman 0
4880995 2320968 2320968 defendant Wynston Thomas carpenter 589328 589328 Wynston, Thomas, of Lynstede, carpenter 2
4923726 2333860 2333860 defendant Bedyll John weaver 589328 589328 Bedyll, John, of Lynstede, weaver 2
4956584 2343923 2343923 defendant Cotyng Richard husbandman 589328 589328 Cotyng, Richard, of Lynstede, husbandman 3
4959581 2344824 2344824 defendant Dodman Richard weaver 589328 589328 Dodman, Richard, of Lynstede, weaver 0
4960878 2345215 2345215 defendant Dudman Richard weaver 589328 589328 Dudman, Richard, of Lynstede, weaver 5
4974194 2349238 2349238 defendant Dodman Richard husbandman 589328 589328 Dodman, Richard, of Lynstede, husbandman 2
4997559 2356122 2356122 defendant Dodman Richard weaver 589328 589328 Dodman, Richard, of Lynstede, weaver 2
4997560 2356122 2356122 defendant Arnold Thomas laborer 589328 589328 Arnold, Thomas, of Lynstede, laborer 3
4997693 2356165 2356165 defendant Maylyve John husbandman 589328 589328 Maylyve, John, of Lynstede, husbandman 0
5002159 2357536 2357536 defendant Hamme Ralph laborer 589328 589328 Hamme, Ralph, of Lynstede, laborer 0
5020428 2362860 2362860 defendant Best Thomas husbandman 589328 589328 Best, Thomas, of Lynstede, husbandman 0
5030623 2365827 2365827 defendant Cotelond Thomas husbandman 589328 589328 Cotelond, Thomas, of Lynstede, husbandman 1
5035001 2367096 2367096 defendant Baker Robert laborer 589328 589328 Baker, Robert, of Lynstede, laborer 0
5054090 2372817 2372817 defendant Maylyff Thomas husbandman 589328 589328 Maylyff, Thomas, of Lynstede, husbandman 3
5057608 2373843 2373843 defendant Bedyll Richard yeoman 589328 589328 Bedyll, Richard, of Lynstede, yeoman 2
5057618 2373846 2373846 defendant Maylyf Thomas laborer 589328 589328 Maylyf, Thomas, of Lynstede, laborer 1
5060176 2374616 2374616 defendant Dodman Richard husbandman 589328 589328 Dodman, Richard, of Lynstede, husbandman 0
5060216 2374626 2374626 defendant Cotyng Richard husbandman 589328 589328 Cotyng, Richard, of Lynstede, husbandman 1
5067337 2376739 2376739 defendant Grenestrete Adam   589328 589328 Grenestrete, Adam, of Lynstede, administrators of 0
5067338 2376739 2376739 defendant Grenestrete Godelena widow 589328 589328 (Grenestrete, Godelena, of Lynstede, widow 1
5067339 2376739 2376739 defendant Grenestrete Richard laborer 589328 589328 Grenestrete, Richard, of Lynstede, laborer 2
5076245 2379397 2379397 defendant Keneworth Thomas husbandman 589328 589328 Keneworth, Thomas, of Lynstede, husbandman 0
5076247 2379398 2379398 defendant Keneworth Thomas husbandman 589328 589328 Keneworth, Thomas, of Lynstede, husbandman 0
5080831 2380757 2380757 defendant Bedyll Richard husbandman 589328 589328 Bedyll, Richard, of Lynstede, husbandman 2
5082784 2381356 2381356 defendant Appulderfeld Thomas gent 589328 589328 Appulderfeld, Thomas, of Lynstede, gent 0
5083768 2381648 2381648 defendant Bryan John laborer 589328 589328 Bryan, John, of Lynstede, laborer 0
5103547 2387463 2387463 defendant Cheseman John cordwainer 589328 589328 Cheseman, John, of Lynstede, cordwainer 2
5107459 2388610 2388610 defendant Hamme Ralph husbandman 589328 589328 Hamme, Ralph, of Lynstede, husbandman 0
5114815 2390746 2390746 defendant Frogenhale Thomas gent 589328 589328 Frogenhale, Thomas, of Lynstede, gent 0
5135682 2396946 2396946 defendant Dowene John tailor 589328 589328 Dowene, John, of Lynstede, tailor 0
5143561 2399252 2399252 defendant Rokke William yeoman 589328 589328 (Rokke, William, of Lynstede, yeoman 1
5145712 2399889 2399889 defendant Wynston Adam husbandman 589328 589328 Wynston, Adam, of Lynstede, husbandman 1
5147739 2400480 2400480 plaintiff Coliere John   589328 589328 Coliere, John, of Lynstede, husbandman, administrators of 0
5147777 2400492 2400492 plaintiff Colyere John, sen   589328 589328 Colyere, John, sen, of Lynstede, husbandman, and of Lenham, administrators of 0
5166055 2405815 2405815 defendant Wynston Adam husbandman 589328 589328 Wynston, Adam, of Lynstede, husbandman 3
5167332 2406181 2406181 plaintiff Colyer John   589328 589328 Colyer, John, of Lynstede, husbandman, administrators of 0
5175021 2408388 2408388 defendant Goldman Richard husbandman 589328 589328 Goldman, Richard, of Lynstede, husbandman 2
5188256 2412277 2412277 defendant Bedell John laborer 589328 589328 Bedell, John, of Lynstede, laborer 0
5196016 2414582 2414582 defendant Goldman Richard husbandman 589328 589328 Goldman, Richard, of Lynstede, husbandman 2
5196020 2414583 2414583 defendant Goldman Richard husbandman 589328 589328 Goldman, Richard, of Lynstede, husbandman 2
5196166 2414624 2414624 defendant Goldman Richard husbandman 589328 589328 Goldman, Richard, of Lynstede, husbandman 2
5203575 2416799 2416799 plaintiff Colyere John, sen   589328 589328 Colyere, John, sen, of Lynstede, administrators of 0
5205960 2417477 2417477 defendant Bedell John laborer 589328 589328 Bedell, John, of Lynstede, laborer 0
5209484 2418513 2418513 defendant Goldman Richard husbandman 589328 589328 Goldman, Richard, of Lynstede, husbandman 2
5233512 2425393 2425393 defendant Dudman Richard laborer 589328 589328 Dudman, Richard, of Lynstede, laborer 0
5245871 2428955 2428955 defendant Bedell Richard hubandman 589328 589328 Bedell, Richard, of Lynstede, hubandman 0
5264930 2434791 2434791 defendant Everard Henry yeoman 589328 589328 Everard, Henry, of Lynstede, yeoman 0
5264932 2434791 2434791 defendant Mulsforth Henry lborer 589328 589328 Mulsforth, Henry, of Lynstede, lborer 2
5329990 2454050 2454050 plaintiff Bartlemewe William   589328 589328 Bartlemewe, William, of Lynstede 0
5330958 2454322 2454322 defendant Sennycolas Thomas gent 589328 589328 Sennycolas, Thomas, of Lynstede, gent 0
5330960 2454323 2454323 defendant Sennycolas Thomas gent 589328 589328 Sennycolas, Thomas, of Lynstede, gent 0
5444416 2488234 2488234 defendant Stokker John laborer 589328 589328 Stokker, John, of Lynstede, laborer 1
5477964 2498433 2498433 defendant Seyntnycolas Thomas gent 589328 589328 together with Seyntnycolas, Thomas, of Lynstede, gent 3
5477968 2498434 2498434 defendant Seyntnycolas Thomas gent 589328 589328 Seyntnycolas, Thomas, of Lynstede, gent 0
5488041 2501313 2501313 defendant Seynt Nycolas Thomas gent 589328 589328 Seynt Nycolas, Thomas, of Lynstede, gent 0
5504298 2506259 2506259 defendant Ayherst John yeoman 589328 589328 Ayherst, John, of Lynstede, yeoman 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);