names

47 rows where place_id = 611875

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690481 1923189 1923189 defendant Hede John yeoman 611875 611875 Hede, John, of Saltwode, yeoman 0
3806528 1959955 1959955 defendant Whyte Thomas yeoman 611875 611875 Whyte, Thomas, of Saltwode, yeoman 2
4498458 2200168 2200168 plaintiff Fraunceys John   611875 611875 Fraunceys, John, of Saltwode, parson 0
4520957 2206891 2206891 plaintiff Fraynceys John clerk & parson 611875 611875 Fraynceys, John, of Saltwode, master, clerk & parson 0
4549514 2215794 2215794 defendant Meysham John   611875 611875 Meysham, John, of Saltwode 0
4549516 2215795 2215795 defendant Meysham John   611875 611875 Meysham, John, of Saltwode 0
4552892 2216848 2216848 plaintiff Fraunceys John clerk & parson 611875 611875 Fraunceys, John, of Saltwode, clerk & parson 0
4591188 2228602 2228602 plaintiff Meysham John   611875 611875 Meysham, John, of Saltwode 0
4603433 2232264 2232264 defendant Meysham John   611875 611875 Meysham, John, of Saltwode 0
4610253 2234291 2234291 defendant Bergrove John   611875 611875 Bergrove, John, of Saltwode 0
4623248 2238244 2238244 defendant Tulk Simon   611875 611875 Tulk, Simon, of Saltwode 4
4623552 2238343 2238343 plaintiff Meysham John   611875 611875 Meysham, John, of Saltwode 0
4623554 2238344 2238344 plaintiff Meysham John   611875 611875 Meysham, John, of Saltwode 0
4651070 2246335 2246335 defendant Hope John laborer 611875 611875 Hope, John, of Saltwode, laborer 1
4651639 2246501 2246501 defendant Andrewe Simon husbandman 611875 611875 Andrewe, Simon, of Saltwode, husbandman 8
4651640 2246501 2246501 defendant atte Stone Richard husbandman 611875 611875 atte Stone, Richard, of Saltwode, husbandman 9
4651815 2246513 2246513 defendant Andrewe Simoin husbandman 611875 611875 Andrewe, Simoin, of Saltwode, husbandman 9
4651816 2246513 2246513 defendant atte Stone Richard husbandman 611875 611875 atte Stone, Richard, of Saltwode, husbandman 10
4652202 2246630 2246630 defendant Tukk Simon   611875 611875 Tukk, Simon, of Saltwode 0
4656036 2247770 2247770 defendant Baldewyne John husbandman 611875 611875 Baldewyne, John, of Saltwode, husbandman 0
4656953 2248065 2248065 defendant Pecchyng William baker 611875 611875 Pecchyng, William, of Saltwode, baker 12
4666762 2255334 2255334 defendant Edenham Matthew clerk 611875 611875 Edenham, Matthew, of Saltwode, clerk 0
4671067 2256617 2256617 defendant atte Stone Richard husbandman 611875 611875 atte Stone, Richard, of Saltwode, husbandman 2
4671068 2256617 2256617 defendant Andrewe Simon husbandman 611875 611875 Andrewe, Simon, of Saltwode, husbandman 3
4675858 2258058 2258058 defendant Colyn Thomas   611875 611875 Colyn, Thomas, of Saltwode, bailiff 0
4680961 2259671 2259671 defendant Tulk Simon butcher 611875 611875 Tulk, Simon, of Saltwode, butcher 2
4708283 2267964 2267964 defendant Tulk Simon fuller 611875 611875 Tulk, Simon, of Saltwode, fuller 18
4709771 2268413 2268413 defendant Wyth Eudo clerk 611875 611875 Wyth, Eudo, of Saltwode, clerk 0
4731728 2275118 2275118 defendant Baldewyne John   611875 611875 Baldewyne, John, of Saltwode, wax chandler 0
4731746 2275118 2275118 defendant Tulk Simon fuller 611875 611875 Tulk, Simon, of Saltwode, fuller 18
4734344 2275912 2275912 defendant Cogger John thresher 611875 611875 Cogger, John, of Saltwode, thresher 0
4750884 2280741 2280741 defendant Andrewe Simon husbandman 611875 611875 Andrewe, Simon, of Saltwode, husbandman 0
4750888 2280741 2280741 defendant Rowe William farmer 611875 611875 Rowe, William, of Saltwode, farmer 4
4790368 2293069 2293069 defendant Colyn Thomas husbandman 611875 611875 Colyn, Thomas, of Saltwode, husbandman 0
4832436 2306179 2306179 defendant Colyn Thomas husbandman 611875 611875 Colyn, Thomas, of Saltwode, husbandman 3
4855756 2313175 2313175 defendant Cromewell William chaplain 611875 611875 Cromewell, William, of Saltwode, chaplain 3
4860124 2314534 2314534 defendant Colyn Thomas husbandman 611875 611875 Colyn, Thomas, of Saltwode, husbandman 3
4875818 2319400 2319400 defendant Colyn Thomas yeoman 611875 611875 Colyn, Thomas, of Saltwode, yeoman 0
4934769 2337271 2337271 defendant Brokhill Nicholas gent 611875 611875 Brokhill, Nicholas, of Saltwode, gent 0
4986654 2352941 2352941 defendant Brokholl Nicholas gent 611875 611875 Brokholl, Nicholas, of Saltwode, gent 0
5108458 2388910 2388910 defendant Stokke Simon husbandman 611875 611875 Stokke, Simon, of Saltwode, husbandman 1
5238295 2426783 2426783 defendant Stokke John husbandman 611875 611875 Stokke, John, of Saltwode, husbandman 1
5316688 2450078 2450078 defendant Sellyng John esq 611875 611875 Sellyng, John, of Saltwode, esq 0
5333877 2455206 2455206 defendant Sellyng John esq 611875 611875 Sellyng, John, of Saltwode, esq 0
5393713 2473263 2473263 defendant Jenkyn William butcher 611875 611875 Jenkyn, William, of Saltwode, butcher 1
5610820 2547106 2547106 defendant Petyt John   611875 611875 Petyt, John, of Saltwode, lime burner 0
5625468 2551910 2551910 defendant Tulk Simon butcher 611875 611875 Tulk, Simon, of Saltwode, butcher 2

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