names

74 rows where place_id = 591960

✎ 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
3606128 1869584 1869584 defendant Botellar Thomas fuller 591960 591960 Botellar, Thomas, of Halstede, Essex, fuller 1
3613566 1871890 1871890 defendant Rydnall Andrew chapman 591960 591960 Rydnall, Andrew, of Halstede, Essex, chapman 4
3698693 1925807 1925807 defendant Bert Michael merchant of Florence 591960 591960 Bert, Michael, of Halstede, Essex, merchant of Florence 0
3987894 2020415 2020415 defendant Marten William clothier 591960 591960 Marten, William, of Halstede, Essex, clothier 1
4073437 2050786 2050786 defendant Graye Thomas chapman 591960 591960 Graye, Thomas, of Halstede, Essex, chapman 0
4086352 2055394 2055394 defendant Hunwyke Thomas, junior yeoman 591960 591960 Hunwyke, Thomas, junior, of Halstede, Essex, yeoman 0
4187815 2091240 2091240 defendant Allyn John yeoman 591960 591960 Allyn, John, of Halstede, Essex, yeoman 2
4683511 2260444 2260444 defendant Page John yeoman 591960 591960 Page, John, of Halstede, Essex, yeoman 1
4689247 2262198 2262198 defendant Pykston John husbandman 591960 591960 Pykston, John, of Halstede, Essex, husbandman 0
4693663 2263517 2263517 defendant Stoure Adam   591960 591960 Stoure, Adam, of Halstede, Essex, attorney 3
4706223 2267326 2267326 defendant Stoure Adam gent 591960 591960 Stoure, Adam, of Halstede, Essex, gent 0
4710840 2268746 2268746 defendant Taverner John yeoman 591960 591960 Taverner, John, of Halstede, Essex, yeoman 0
4712107 2269097 2269097 defendant fitz Nichole Richard gent 591960 591960 fitz Nichole, Richard, of Halstede, Essex, gent 7
4712176 2269119 2269119 defendant Store Adam gent 591960 591960 Store, Adam, of Halstede, Essex, gent 0
4718265 2271048 2271048 defendant Pychard John yeoman 591960 591960 Pychard, John, of Halstede, Essex, yeoman 0
4727196 2273767 2273767 defendant Stoure Adam   591960 591960 Stoure, Adam, of Halstede, Essex, attorney 0
4727974 2273995 2273995 defendant Dyere John   591960 591960 Dyere, John, of Halstede, Essex, syere or carrier 0
4743766 2278705 2278705 defendant Gauge John fuller 591960 591960 Gauge, John, of Halstede, Essex, fuller 3
4761845 2284048 2284048 defendant Fullery Thomas spicer 591960 591960 Fullery, Thomas, of Halstede, Essex, spicer 0
4762919 2284385 2284385 defendant Gauge John tailor 591960 591960 Gauge, John, of Halstede, Essex, tailor 0
4767373 2285783 2285783 defendant Fuller Thomas chapman 591960 591960 Fuller, Thomas, of Halstede, Essex, chapman 0
4772893 2287493 2287493 defendant Store Adam gent 591960 591960 Store, Adam, of Halstede, Essex, gent 0
4798218 2295638 2295638 defendant Foulere John chapman 591960 591960 Foulere, John, of Halstede, Essex, chapman 1
4798909 2295832 2295832 defendant Wheler Roger husbandman 591960 591960 Wheler, Roger, of Halstede, Essex, husbandman 1
4798917 2295833 2295833 defendant Wheler Roger husbandman 591960 591960 Wheler, Roger, of Halstede, Essex, husbandman 1
4806743 2298319 2298319 defendant Taillour Thomas tailor 591960 591960 Taillour, Thomas, of Halstede, Essex, tailor 2
4885079 2322225 2322225 defendant Page John yeoman 591960 591960 Page, John, of Halstede, Essex, yeoman 0
4905913 2328453 2328453 defendant Skylfull Richard gent 591960 591960 Skylfull, Richard, of Halstede, Essex, gent 0
4956491 2343900 2343900 defendant Draper Richard skinner 591960 591960 Draper, Richard, of Halstede, Essex, skinner 0
4956494 2343901 2343901 defendant Draper Richard skinner 591960 591960 Draper, Richard, of Halstede, Essex, skinner 0
4989101 2353676 2353676 defendant Botiller Thomas husbandman 591960 591960 Botiller, Thomas, of Halstede, Essex, husbandman 2
4991714 2354404 2354404 defendant Pecherd John husbandman 591960 591960 Pecherd, John, of Halstede, Essex, husbandman 1
5046100 2370461 2370461 defendant Mannyng Richard, junior husbandman 591960 591960 Mannyng, Richard, junior, of Halstede, Essex, husbandman 0
5061328 2374971 2374971 defendant Mannyng Richard barker 591960 591960 Mannyng, Richard, of Halstede, Essex, barker 3
5077925 2379878 2379878 defendant Pichard John yeoman 591960 591960 Pichard, John, of Halstede, Essex, yeoman 4
5117387 2391518 2391518 defendant Smyth John smith 591960 591960 Smyth, John, of Halstede, Essex, smith 1
5117391 2391519 2391519 defendant Smyth John smith 591960 591960 Smyth, John, of Halstede, Essex, smith 1
5178662 2409474 2409474 defendant Worthy John gent 591960 591960 Worthy, John, of Halstede, Essex, gent 0
5180137 2409932 2409932 defendant Chapman William   591960 591960 Chapman, William, of Halstede, Essex, friary clerk 0
5180142 2409934 2409934 defendant Chapman William   591960 591960 Chapman, William, of Halstede, Essex, friary clerk 0
5187897 2412169 2412169 defendant Gawge Robert husbandman 591960 591960 Gawge, Robert, of Halstede, Essex, husbandman 3
5202251 2416422 2416422 defendant Chapman William   591960 591960 Chapman, William, of Halstede, Essex, friary clerk 0
5202254 2416423 2416423 defendant Chapman William   591960 591960 Chapman, William, of Halstede, Essex, friary clerk 0
5207048 2417798 2417798 defendant Fuller Thomas husbandman 591960 591960 Fuller, Thomas, of Halstede, Essex, husbandman 0
5208413 2418187 2418187 defendant Warner John gent 591960 591960 Warner, John, of Halstede, Essex, gent 0
5208416 2418188 2418188 defendant Warner John gent 591960 591960 Warner, John, of Halstede, Essex, gent 0
5212087 2419275 2419275 defendant Drax or Dray Thomas gent 591960 591960 Drax or Dray, Thomas, of Halstede, Essex, gent 0
5212089 2419276 2419276 defendant Drax Thomas gent 591960 591960 Drax, Thomas, of Halstede, Essex, gent 0
5220254 2421621 2421621 defendant Worthy John gent 591960 591960 Worthy, John, of Halstede, Essex, gent 1
5223748 2422629 2422629 defendant Brynyton John yeoman 591960 591960 Brynyton, John, of Halstede, Essex, yeoman 0
5228127 2423833 2423833 defendant Worthy John gent 591960 591960 Worthy, John, of Halstede, Essex, gent 0
5237126 2426444 2426444 defendant Drakes Thomas gent 591960 591960 Drakes, Thomas, of Halstede, Essex, gent 0
5237132 2426445 2426445 defendant Drakes Thomas gent 591960 591960 Drakes, Thomas, of Halstede, Essex, gent 0
5240748 2427503 2427503 defendant Pychard John yeoman 591960 591960 Pychard, John, of Halstede, Essex, yeoman 0
5240753 2427504 2427504 defendant Pygot Robert tailor 591960 591960 Pygot, Robert, of Halstede, Essex, tailor 1
5256550 2432167 2432167 plaintiff Drakys Thomas gent 591960 591960 Drakys, Thomas, of Halstede, Essex, gent 0
5268462 2435897 2435897 defendant Bagger Thomas yeoman 591960 591960 Bagger, Thomas, of Halstede, Essex, yeoman 4
5308117 2447453 2447453 defendant Rewes Nicholas clerk 591960 591960 Rewes, Nicholas, of Halstede, Essex, clerk 1
5309168 2447781 2447781 defendant Harward William   591960 591960 Harward, William, of Halstede, Essex 0
5309170 2447781 2447781 defendant Lamberd Thomas draper 591960 591960 Lamberd, Thomas, of Halstede, Essex, draper 2
5325883 2452827 2452827 defendant Symmes William chapman 591960 591960 Symmes, William, of Halstede, Essex, chapman 2
5357427 2462389 2462389 defendant May John smith 591960 591960 (May, John, of Halstede, Essex, smith 6
5395763 2473870 2473870 defendant Dasch John laborer 591960 591960 Dasch, John, of Halstede, Essex, laborer 0
5395769 2473873 2473873 defendant Dasth John laborer 591960 591960 Dasth, John, of Halstede, Essex, laborer 0
5410732 2478154 2478154 defendant Pesall William (legal representative) 591960 591960 Pesall, William, of Halstede, Essex, esq, executor of 4
5424802 2482375 2482375 defendant Pesall William (legal representative) 591960 591960 Pesall, William, of Halstede, Essex, esq, executor of 4
5424809 2482376 2482376 defendant Pestill William (legal representative) 591960 591960 Pestill, William, of Halstede, Essex, esq, executor of 4
5424813 2482377 2482377 defendant Pestill William (legal representative) 591960 591960 Pestill, William, of Halstede, Essex, esq, executor of 1
5442115 2487558 2487558 defendant Dasch John laborer 591960 591960 Dasch, John, of Halstede, Essex, laborer 0
5454855 2491370 2491370 defendant Dasch John laborer 591960 591960 Dasch, John, of Halstede, Essex, laborer 0
5468015 2495376 2495376 defendant Pestill William (legal representative) 591960 591960 Pestill, William, of Halstede, Essex, esq, executor of 1
5483983 2500144 2500144 defendant Sumys William mercer 591960 591960 Sumys, William, of Halstede, Essex, mercer 2
5489335 2501699 2501699 defendant Alyot John yeoman 591960 591960 Alyot, John, of Halstede, Essex, yeoman 0
5543482 2518078 2518078 defendant Davy John yeoman 591960 591960 Davy, John, of Halstede, Essex, 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);