names

34 rows where place_id = 591521

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604646 1869115 1869115 defendant Quadryng Alexander esq 591521 591521 Quadryng, Alexander, of Thakstede, Essex, esq 0
3625079 1875379 1875379 defendant Neweman Henry grocer 591521 591521 Neweman, Henry, of Thakstede, Essex, grocer 1
4490404 2197701 2197701 defendant Kent John   591521 591521 Kent, John, of Thakstede, Essex 0
4490441 2197707 2197707 defendant Kent John   591521 591521 Kent, John, of Thakstede, Essex 0
4644960 2244596 2244596 defendant Saweston John cutler 591521 591521 Saweston, John, of Thakstede, Essex, cutler 0
4644962 2244597 2244597 defendant Saweston John cutler 591521 591521 Saweston, John, of Thakstede, Essex, cutler 0
4649978 2246010 2246010 defendant Hadstoke John   591521 591521 Hadstoke, John, of Thakstede, Essex 4
4664177 2250283 2250283 defendant Reynald William goldsmith 591521 591521 Reynald, William, of Thakstede, Essex, goldsmith 1
4681678 2259879 2259879 defendant Hasilbrook John   591521 591521 Hasilbrook, John, of Thakstede, Essex, sether(? 1
4700740 2265631 2265631 defendant Beenge John gent 591521 591521 Beenge, John, of Thakstede, Essex, gent 0
4767374 2285783 2285783 defendant Jankyn Ralph cutler 591521 591521 Jankyn, Ralph, of Thakstede, Essex, cutler 1
4820142 2302375 2302375 defendant Asser John chapman 591521 591521 Asser, John, of Thakstede, Essex, chapman 0
4826026 2304177 2304177 defendant Edwyne John cutler 591521 591521 Edwyne, John, of Thakstede, Essex, cutler 1
4843580 2309513 2309513 defendant Godhewene Thomas chapman 591521 591521 Godhewene, Thomas, of Thakstede, Essex, chapman 3
4843586 2309514 2309514 defendant Godhewene Thomas chapman 591521 591521 Godhewene, Thomas, of Thakstede, Essex, chapman 3
4852063 2312075 2312075 defendant Rynger John smith 591521 591521 Rynger, John, of Thakstede, Essex, smith 1
4865649 2316220 2316220 defendant Hoo John   591521 591521 Hoo, John, of Thakstede, Essex, bladesmith 2
4865654 2316221 2316221 defendant Hoo John   591521 591521 Hoo, John, of Thakstede, Essex, bladesmith 1
4953366 2342971 2342971 defendant Rede Thomas merchant 591521 591521 Rede, Thomas, of Thakstede, Essex, skinner, Porter, John, of Thalstede, merchant 0
4953368 2342972 2342972 defendant Rede Thomas skinner 591521 591521 Rede, Thomas, of Thakstede, Essex, skinner 0
4957837 2344315 2344315 defendant Bernerd Richard cutler 591521 591521 Bernerd, Richard, of Thakstede, Essex, cutler 0
5093297 2384436 2384436 defendant Henham John   591521 591521 Henham, John, of Thakstede, Essex, bladesmith 0
5116519 2391265 2391265 defendant Fryday Thomas haberdasher 591521 591521 Fryday, Thomas, of Thakstede, Essex, cutler, or of Exeter, haberdasher 0
5116521 2391266 2391266 defendant Fryday Thomas haberdasher 591521 591521 Fryday, Thomas, of Thakstede, Essex, cutler, or of Exeter, haberdasher 0
5118876 2391953 2391953 defendant FitzRychard John chapman 591521 591521 FitzRychard, John, of Thakstede, Essex, chapman 0
5173670 2407995 2407995 defendant Gateward John smith 591521 591521 Gateward, John, of Thakstede, Essex, smith 3
5173679 2407996 2407996 defendant Gateward John smith 591521 591521 Gateward, John, of Thakstede, Essex, smith 2
5193749 2413896 2413896 defendant Gateward John smith 591521 591521 Gateward, John, of Thakstede, Essex, smith 2
5301045 2445268 2445268 defendant Stubbard John yeoman 591521 591521 Stubbard, John, of Thakstede, Essex, yeoman 1
5328586 2453628 2453628 defendant Gace William chapman 591521 591521 Gace, William, of Thakstede, Essex, chapman 1
5379316 2469122 2469122 defendant Quidryng Alexander gent 591521 591521 Quidryng, Alexander, of Thakstede, Essex, gent 2
5438773 2486520 2486520 defendant Kyng John smith 591521 591521 Kyng, John, of Thakstede, Essex, smith 2
5509406 2507791 2507791 defendant Strong John smith 591521 591521 Strong, John, of Thakstede, Essex, smith 0
5626264 2552184 2552184 defendant Bayly John dyer 591521 591521 Bayly, John, of Thakstede, Essex, dyer 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);