names

38 rows where place_id = 679824

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4037814 2038177 2038177 defendant Brayne Goditha widow 679824 679824 Brayne, Goditha, of St James, widow 0
4152978 2079148 2079148 defendant Allen John weaver 679824 679824 Allen, John, of St James, weaver 0
4152979 2079148 2079148 defendant Hensam Hugh tucker 679824 679824 Hensam, Hugh, of St James, tucker 1
4152983 2079149 2079149 defendant Scorrie or Scorrier Nicholas weaver 679824 679824 Scorrie or Scorrier, Nicholas, of St James, weaver 0
4169903 2084968 2084968 defendant Hilson alias Burge John butcher 679824 679824 Hilson alias Burge, John, of St James, butcher 0
4208567 2098547 2098547 defendant Hardinge George weaver 679824 679824 Hardinge, George, of St James, weaver 0
4208568 2098547 2098547 defendant Gredycote Henry tanner 679824 679824 Gredycote, Henry, of St James, tanner 1
4208569 2098547 2098547 defendant Stoddon Philip tucker 679824 679824 Stoddon, Philip, of St James, tucker 2
4208570 2098547 2098547 defendant Hopkins William tucker 679824 679824 Hopkins, William, of St James, tucker 3
4226971 2104907 2104907 defendant Simons Roger victualer 679824 679824 Simons, Roger, of St James, victualer 0
4226972 2104907 2104907 defendant Collard William weaver 679824 679824 Collard William, of St James, weaver 1
4231844 2106635 2106635 defendant Vyvyan Anne widow 679824 679824 Vyvyan, Anne, of St James, or of Shaftsbury, widow 0
4241504 2110140 2110140 defendant Bydbanck Robert yeoman 679824 679824 Bydbanck, Robert, of St James, yeoman 0
4260242 2116389 2116389 defendant Seamor Nicholas husbandman 679824 679824 Seamor, Nicholas, of St James, husbandman 0
4268179 2118975 2118975 defendant Symons Roger victualer 679824 679824 Symons, Roger, of St James, victualer 0
4281549 2123452 2123452 defendant Shepperd John tucker 679824 679824 Shepperd, John, of St James, tucker 0
4284894 2124646 2124646 defendant Smyth Roger husbandman 679824 679824 Smyth, Roger, of St James, husbandman 0
4286483 2125207 2125207 defendant Younge Thomas   679824 679824 Younge, Thomas, of St James, "sleamaker" 0
4286485 2125207 2125207 defendant Kingeskerrye John clothier 679824 679824 Kingeskerrye , John, of St James, clothier 2
4301995 2130823 2130823 defendant Hyll Edward clothier 679824 679824 Hyll, Edward, of St James, clothier 0
4302686 2131057 2131057 defendant Crosse John clothier 679824 679824 Crosse, John, of St James, clothier 0
4306604 2132447 2132447 defendant Jones Jenkin   679824 679824 Jones, Jenkin, of St James, felt maker 0
4312150 2134389 2134389 defendant Hill Edward clothier 679824 679824 Hill, Edward, of St James, clothier 0
4317804 2136339 2136339 defendant Awdrie or Odry Thomas brewer 679824 679824 Awdrie or Odry, Thomas, of St James, brewer 0
4321790 2137708 2137708 defendant Lowe James husbandman 679824 679824 Lowe, James, of St James, husbandman 0
4325605 2138939 2138939 defendant Pickeringe Thomas clerk 679824 679824 Pickeringe, Thomas, of St James, clerk 0
4333592 2141517 2141517 defendant Pickeringe Thomas clerk 679824 679824 Pickeringe, Thomas, of St James, clerk 0
4364001 2152183 2152183 defendant Blocke Francis dyer 679824 679824 Blocke, Francis, of St James, dyer 0
4366566 2153091 2153091 defendant Pickringe Thomas   679824 679824 Pickringe, Thomas, of St James clerk 0
4366567 2153091 2153091 defendant Pickringe George   679824 679824 Pickringe, George, of St James, groom 1
4366568 2153091 2153091 defendant Chaplyn Roger gent 679824 679824 Chaplyn, Roger, of St James, gent 2
4367470 2153419 2153419 defendant Pyckeringe Thomas clerk 679824 679824 Pyckeringe, Thomas, of St James, clerk 0
4367471 2153419 2153419 defendant Pyckerynge George   679824 679824 Pyckerynge, George, of St James, groom 1
4367472 2153419 2153419 defendant Chaplyn Roger gent 679824 679824 Chaplyn, Roger, of St James, gent 2
4368586 2153815 2153815 defendant Combe Nicholas husbandman 679824 679824 Combe, Nicholas, of St James, or of North Corie, brewer, husbandman 0
4412090 2168637 2168637 defendant Blocke Francis dyer 679824 679824 Blocke, Francis, of St James, dyer 1
4419339 2170931 2170931 defendant Estebrok William   679824 679824 Estebrok, William, of St James, by Winchester, parson 0
4813228 2300252 2300252 defendant Martyn Robert husbandman 679824 679824 with Martyn, Robert, of St James, husbandman 1

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