names

67 rows where place_id = 587278

✎ 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
3590972 1864804 1864804 defendant Nodder Edmund husbandman 587278 587278 Nodder, Edmund, of Calton, husbandman 1
3590973 1864804 1864804 defendant Hyne Richard husbandman 587278 587278 Hyne, Richard, of Calton, husbandman 2
3590974 1864804 1864804 defendant Hall Richard husbandman 587278 587278 Hall, Richard, of Calton, husbandman 3
3590975 1864804 1864804 defendant Hyne John husbandman 587278 587278 Hyne, John, of Calton, husbandman 4
3590976 1864804 1864804 defendant Nesfeld John husbandman 587278 587278 Nesfeld, John, of Calton, husbandman 5
3590977 1864804 1864804 defendant Nayler William husbandman 587278 587278 Nayler, William, of Calton, husbandman 6
3590978 1864804 1864804 defendant Husband Robert husbandman 587278 587278 Husband, Robert, of Calton, husbandman 7
3590979 1864804 1864804 defendant Jakson Thomas husbandman 587278 587278 Jakson, Thomas, of Calton, husbandman 8
3590980 1864804 1864804 defendant Jakson Richard husbandman 587278 587278 Jakson, Richard, of Calton, husbandman 9
3590981 1864804 1864804 defendant Todde Christopher husbandman 587278 587278 Todde, Christopher, of Calton, husbandman 10
3661318 1913816 1913816 defendant Tewer Thomas yeoman 587278 587278 Tewer, Thomas, of Calton, yeoman 0
3670074 1916586 1916586 defendant Lorde John husbandman 587278 587278 Lorde, John, of Calton, husbandman 0
3707883 1928765 1928765 defendant Turnour Roger husbandman 587278 587278 Turnour, Roger, of Calton, husbandman 2
3707884 1928765 1928765 defendant Harryson Ralph husbandman 587278 587278 Harryson, Ralph, of Calton, husbandman 3
3707885 1928765 1928765 defendant Smyth Richard laborer 587278 587278 Smyth, Richard, of Calton, laborer 4
3707886 1928765 1928765 defendant Clerke William laborer 587278 587278 Clerke, William, of Calton, laborer 5
3707887 1928765 1928765 defendant Phylyp Ralph husbandman 587278 587278 Phylyp, Ralph, of Calton, husbandman 6
3707888 1928765 1928765 defendant Phylypp Thomas husbandman 587278 587278 Phylypp, Thomas, of Calton, husbandman 7
3707889 1928765 1928765 defendant Smyth William, junior laborer 587278 587278 Smyth, William, junior, of Calton, laborer 8
3707890 1928765 1928765 defendant Turnour Henry weaver 587278 587278 Turnour, Henry, of Calton, weaver 9
3707891 1928765 1928765 defendant Broun Robert husbandman 587278 587278 Broun, Robert, of Calton, husbandman 10
3843710 1971565 1971565 defendant Clerke William husbandman 587278 587278 Clerke, William, of Calton, husbandman 0
3843711 1971565 1971565 defendant Smyth Richard laborer 587278 587278 Smyth, Richard, of Calton, laborer 1
3891328 1987367 1987367 plaintiff Lambert John   587278 587278 Lambert, John, of Calton 0
3919362 1996808 1996808 defendant Nesfeld Lancelot gent 587278 587278 Nesfeld, Lancelot, of Calton, gent 0
3935577 2002211 2002211 plaintiff Lambart John   587278 587278 Lambart, John, of Calton, senior 0
3935581 2002213 2002213 plaintiff Lambart John, senior esq 587278 587278 Lambart, John, senior, of Calton, esq 0
3935596 2002218 2002218 plaintiff Lambert John, senior   587278 587278 Lambert, John, senior, of Calton 0
3935598 2002219 2002219 plaintiff Lambert John, senior esq 587278 587278 Lambert, John, senior, of Calton, esq 0
4019373 2031662 2031662 defendant Lambert John esq 587278 587278 Lambert, John, of Calton, esq 0
4280658 2123138 2123138 defendant Norfforth John yeoman 587278 587278 Norfforth, John, of Calton, yeoman 2
4384503 2159505 2159505 defendant Smyth Thomas, junior husbandman 587278 587278 Smyth, Thomas, junior, of Calton, husbandman 2
4384504 2159505 2159505 defendant Smyth alias Bonysyer Thomas husbandman 587278 587278 Smyth alias Bonysyer, Thomas, of Calton, husbandman 3
4413177 2168993 2168993 plaintiff atte Mor John (legal representative) 587278 587278 atte Mor, John, of Calton, executors of 0
4413182 2168994 2168994 plaintiff atte Mor John (legal representative) 587278 587278 atte Mor, John, of Calton, executors of 0
4439443 2181600 2181600 plaintiff Bailly Hugh le   587278 587278 Bailly, Hugh le, of Calton 0
4450189 2185017 2185017 plaintiff Halle John   587278 587278 Halle, John, of Calton 0
4476107 2193198 2193198 defendant Mallom William de   587278 587278 Mallom, William de, of Calton 0
4488149 2197008 2197008 defendant Geffeesson Thomas   587278 587278 Geffeesson, Thomas, of Calton 11
4551309 2216347 2216347 defendant Neuton John de   587278 587278 Neuton, John de, of Calton 1
4566359 2221049 2221049 defendant Clerk William   587278 587278 Clerk, William, of Calton 0
4575633 2223890 2223890 defendant Bradbury John   587278 587278 Bradbury, John, of Calton 0
4583287 2226197 2226197 defendant Dandysson John   587278 587278 Dandysson, John, of Calton 6
4652504 2246734 2246734 plaintiff Bailli Robert   587278 587278 Bailli, Robert, of Calton 0
4659807 2248918 2248918 defendant Perwyche John yeoman 587278 587278 Perwyche, John, of Calton, yeoman 0
4681619 2259863 2259863 defendant Lorde Roger yeoman 587278 587278 Lorde, Roger, of Calton, yeoman 1
4681620 2259863 2259863 defendant Belchere Roger yeoman 587278 587278 Belchere, Roger, of Calton, yeoman 2
4689491 2262269 2262269 defendant Hiketon William husbandman 587278 587278 Hiketon, William, of Calton, husbandman 1
4701107 2265753 2265753 defendant Wastnesse John husbandman 587278 587278 Wastnesse, John, of Calton, husbandman 0
4727942 2273982 2273982 defendant Mallom William de esq 587278 587278 Mallom, William de, of Calton, esq 0
4742709 2278376 2278376 defendant Higgedon William yeoman 587278 587278 Higgedon, William, of Calton, yeoman 0
4745091 2279073 2279073 defendant Sergeantson Thomas yeoman 587278 587278 Sergeantson, Thomas, of Calton, yeoman 10
4754523 2281795 2281795 defendant Preston Henry yeoman 587278 587278 Preston, Henry, of Calton, yeoman 2
4766782 2285604 2285604 defendant Calton Thomas, sen yeoman 587278 587278 Calton, Thomas, sen, of Calton, yeoman 0
4770741 2286828 2286828 defendant Mallom Thomas gent 587278 587278 Mallom, Thomas, of Calton, gent 0
4770743 2286828 2286828 defendant Mallom William (legal representative) 587278 587278 Mallom, William, of Calton, executors of 2
4770745 2286828 2286828 defendant Mallom William de gent 587278 587278 Mallom, William de, of Calton, gent 4
4811034 2299563 2299563 defendant Mallom Thomas gent 587278 587278 Mallom, Thomas, of Calton, gent 0
4864666 2315917 2315917 defendant Mallom Thomas gent 587278 587278 Mallom, Thomas, of Calton, gent 0
4874966 2319118 2319118 defendant Tomkynson Robert husbandman 587278 587278 Tomkynson, Robert, of Calton, husbandman 0
5014077 2360972 2360972 defendant Smyth John husbandman 587278 587278 Smyth, John, of Calton, husbandman 2
5051037 2371918 2371918 defendant Harryson Robert laborer 587278 587278 Harryson, Robert, of Calton, laborer 5
5134101 2396470 2396470 defendant Atcok Robert husbandman 587278 587278 Atcok, Robert, of Calton, husbandman 3
5154017 2402335 2402335 defendant Atcok Robert husbandman 587278 587278 Atcok, Robert, of Calton, husbandman 3
5171257 2407314 2407314 defendant Atcok Robert husbandman 587278 587278 Atcok, Robert, of Calton, husbandman 3
5200404 2415880 2415880 defendant Harry Robert husbandman 587278 587278 Harry, Robert, of Calton, husbandman 3
5262998 2434168 2434168 defendant Lees Roger chaplain 587278 587278 Lees, Roger, of Calton, chaplain 10

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