names

133 rows where place_id = 591127

✎ 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
3603417 1868739 1868739 defendant Skulton Robert husbandman 591127 591127 Skulton, Robert, of Elsyng, husbandman 6
3612441 1871521 1871521 defendant Chamberleyn John laborer 591127 591127 Chamberleyn, John, of Elsyng, laborer 0
3614905 1872315 1872315 defendant Hochepound William yeoman 591127 591127 Hochepound, William, of Elsyng, yeoman 1
3616366 1872757 1872757 defendant Lemman John glover 591127 591127 Lemman, John, of Elsyng, glover 1
3619105 1873578 1873578 plaintiff Hogepooll William   591127 591127 Hogepooll, William, of Elsyng 0
3631812 1904756 1904756 defendant Hodgepound John husbandman 591127 591127 Hodgepound, John, of Elsyng, husbandman 0
3639182 1907069 1907069 defendant Arnold Thomas miller 591127 591127 Arnold, Thomas, of Elsyng, miller 0
3639183 1907069 1907069 defendant Halewell William husbandman 591127 591127 Halewell, William, of Elsyng, husbandman 1
3688396 1922528 1922528 defendant Leman William husbandman 591127 591127 Leman, William, of Elsyng, husbandman 0
3699900 1926197 1926197 defendant Codlyn Thomas husbandman 591127 591127 Codlyn, Thomas, of Elsyng, husbandman 0
3702962 1927196 1927196 defendant Watson Richard tanner 591127 591127 Watson, Richard, of Elsyng, tanner 2
3715804 1931230 1931230 plaintiff Canon John   591127 591127 Canon, John, of Elsyng 0
3715805 1931230 1931230 defendant Bullyng Thomas husbandman 591127 591127 Bullyng, Thomas, of Elsyng, husbandman 0
3724962 1934095 1934095 defendant Lemon William husbandman 591127 591127 Lemon, William, of Elsyng, husbandman 2
3763311 1946158 1946158 defendant Scoulton John husbandman 591127 591127 Scoulton, John, of Elsyng, husbandman 1
3763524 1946228 1946228 defendant Londdysdale John tailor 591127 591127 Londdysdale, John, of Elsyng, tailor 0
3763525 1946228 1946228 defendant Scoulton John husbandman 591127 591127 Scoulton, John, of Elsyng, husbandman 1
3764110 1946422 1946422 defendant Skulton John husbandman 591127 591127 Skulton, John, of Elsyng, husbandman 0
3766279 1947103 1947103 defendant Caldecote Roger chaplain 591127 591127 Caldecote, Roger, of Elsyng, chaplain 0
3775931 1950222 1950222 defendant Leman William husbandman 591127 591127 Leman, William, of Elsyng, husbandman 1
3778455 1950976 1950976 defendant Sculton John husbandman 591127 591127 Sculton, John, of Elsyng, husbandman 0
3781344 1951908 1951908 defendant Godlyn John husbandman 591127 591127 Godlyn, John, of Elsyng, husbandman 0
3792380 1955478 1955478 defendant Lemman John husbandman 591127 591127 Lemman, John, of Elsyng, husbandman 0
3792382 1955478 1955478 defendant Melton Robert laborer 591127 591127 Melton, Robert, of Elsyng, laborer 2
3792383 1955478 1955478 defendant Lemman William husbandman 591127 591127 Lemman, William, of Elsyng, husbandman 3
3797948 1957255 1957255 defendant Alyson William husbandman 591127 591127 Alyson, William, of Elsyng, husbandman 4
3809527 1960863 1960863 defendant Wylson Henry miller 591127 591127 Wylson, Henry, of Elsyng, miller 1
3821879 1964732 1964732 plaintiff Skulkon John   591127 591127 Skulkon, John, of Elsyng 0
3821881 1964733 1964733 plaintiff Skulkon John   591127 591127 Skulkon, John, of Elsyng 0
3825172 1965738 1965738 defendant Skulton John husbandman 591127 591127 Skulton, John, of Elsyng, husbandman 0
3825620 1965865 1965865 defendant Blomfeld William yeoman 591127 591127 Blomfeld, William, of Elsyng, yeoman 2
3830761 1967504 1967504 defendant Sculton William husbandman 591127 591127 Sculton, William, of Elsyng, husbandman 0
3843054 1971354 1971354 defendant Caldecote Roger clerk 591127 591127 Caldecote, Roger, of Elsyng, clerk 1
3848850 1973232 1973232 defendant Calcott Roger clerk 591127 591127 Calcott, Roger, of Elsyng, clerk 1
3866572 1979046 1979046 defendant Calcott Roger clerk 591127 591127 Calcott, Roger, of Elsyng, clerk 0
3873070 1981209 1981209 plaintiff Budman John   591127 591127 Budman, John, of Elsyng, collar maker 0
3876122 1982263 1982263 defendant Hastyng Hugh, senior gent 591127 591127 Hastyng, Hugh, senior, of Elsyng, gent 1
3876123 1982263 1982263 defendant Oliver Roger glover 591127 591127 Oliver, Roger, of Elsyng, glover 2
3891646 1987460 1987460 defendant Hoode Thomas   591127 591127 Hoode, Thomas, of Elsyng, worsted weaver 0
3915821 1995671 1995671 defendant Halywell William husbandman 591127 591127 Halywell, William, of Elsyng, husbandman 0
3921469 1997524 1997524 defendant Hewett John   591127 591127 Hewett, John, of Elsyng, worsted weaver 0
3922840 1997940 1997940 defendant Aleyn Thomas carpenter 591127 591127 Aleyn, Thomas, of Elsyng, carpenter 0
3937142 2002754 2002754 defendant Ryck George husbandman 591127 591127 Ryck, George, of Elsyng, husbandman 8
3952030 2007774 2007774 defendant Erle Thomas glover 591127 591127 Erle, Thomas, of Elsyng, glover 2
3957955 2009846 2009846 defendant Sponer Robert smith 591127 591127 Sponer, Robert, of Elsyng, smith 1
3977888 2016840 2016840 plaintiff Machall John carpenter 591127 591127 Machall, John, of Elsyng, carpenter 0
3995033 2022971 2022971 plaintiff Coplande Thomas yeoman 591127 591127 Coplande, Thomas, of Elsyng, or of Hardyngham, yeoman 0
3995037 2022971 2022971 defendant Cockfeld Thomas husbandman 591127 591127 Cockfeld, Thomas, of Elsyng, husbandman 3
4015000 2030072 2030072 defendant Dey Robert husbandman 591127 591127 Dey, Robert, of Elsyng, husbandman 8
4049331 2042207 2042207 defendant Cullyn John shoemaker 591127 591127 Cullyn, John, of Elsyng, shoemaker 1
4065794 2048061 2048061 defendant Howchyn Edmund tailor 591127 591127 Howchyn, Edmund, of Elsyng, tailor 1
4081308 2053625 2053625 defendant Ellys Robert husbandman 591127 591127 Ellys, Robert, of Elsyng, husbandman 0
4163001 2082596 2082596 defendant Cookes or Cock Felix yeoman 591127 591127 Cookes or Cock, Felix, of Elsyng, or of Lyng, yeoman 0
4175051 2086739 2086739 defendant Beste John gent 591127 591127 Beste, John, of Elsyng, gent 0
4204467 2097109 2097109 defendant Marshall John husbandman 591127 591127 Marshall, John, of Elsyng, husbandman 0
4323966 2138425 2138425 defendant Bond Edward husbandman 591127 591127 Bond, Edward, of Elsyng, husbandman 0
4463877 2189380 2189380 defendant Glovere John   591127 591127 Glovere, John, of Elsyng 0
4662738 2249804 2249804 plaintiff Fulcher William   591127 591127 Fulcher, William, of Elsyng 0
4666256 2250917 2250917 defendant atte Welle Robert yeoman 591127 591127 atte Welle, Robert, of Elsyng, yeoman 3
4679517 2259209 2259209 defendant Howe Thomas laborer 591127 591127 Howe, Thomas, of Elsyng, laborer 2
4707842 2267822 2267822 defendant Asshe William miller 591127 591127 Asshe, William, of Elsyng, miller 0
4737503 2276843 2276843 defendant Baker John butcher 591127 591127 Baker, John, of Elsyng, butcher 0
4743971 2278762 2278762 defendant Ridout John clerk 591127 591127 (Ridout, John, of Elsyng, clerk 4
4743972 2278762 2278762 defendant Fyssher John yeoman 591127 591127 Fyssher, John, of Elsyng, yeoman 5
4751456 2280907 2280907 defendant Spaceman Thomas yeoman 591127 591127 Spaceman, Thomas, of Elsyng, yeoman 5
4866702 2316548 2316548 defendant Hastynges Edward   591127 591127 Hastynges, Edward, of Elsyng, knight 0
4866703 2316548 2316548 defendant Hastynges John esq 591127 591127 Hastynges, John, of Elsyng, esq 1
4888499 2323200 2323200 defendant Abot Stephen yeoman 591127 591127 Abot, Stephen, of Elsyng, yeoman 1
4943925 2340066 2340066 defendant Abbot Stephen smith 591127 591127 Abbot, Stephen, of Elsyng, smith 2
5002891 2357750 2357750 defendant Pace John husbandman 591127 591127 Pace, John, of Elsyng, husbandman 0
5039430 2368442 2368442 defendant Cok John butcher 591127 591127 Cok, John, of Elsyng, butcher 0
5117379 2391516 2391516 defendant Costantyn John miller 591127 591127 Costantyn, John, of Elsyng, miller 1
5146551 2400129 2400129 defendant wygenale Mathew master & parson 591127 591127 wygenale, Mathew, of Elsyng, master & parson 2
5146564 2400132 2400132 defendant Hastyngys John esq 591127 591127 Hastyngys, John, of Elsyng, esq 0
5166643 2405966 2405966 defendant Hastyngys John esq 591127 591127 Hastyngys, John, of Elsyng, esq 0
5180153 2409938 2409938 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 0
5180154 2409938 2409938 defendant Wright Adam yeoman 591127 591127 Wright, Adam, of Elsyng, yeoman 1
5181520 2410336 2410336 defendant Hastyngys John esq 591127 591127 Hastyngys, John, of Elsyng, esq 0
5181525 2410337 2410337 defendant Hastyngys John esq 591127 591127 Hastyngys, John, of Elsyng, esq 0
5202268 2416429 2416429 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 0
5202269 2416429 2416429 defendant Wright Adam yeoman 591127 591127 Wright, Adam, of Elsyng, yeoman 1
5229850 2424350 2424350 defendant Wykys John yeoman 591127 591127 Wykys, John, of Elsyng, yeoman 0
5229851 2424350 2424350 defendant Ketyl Adam   591127 591127 Ketyl, Adam, of Elsyng 1
5230062 2424409 2424409 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 0
5230063 2424409 2424409 defendant Ketyll Adam, junior yeoman 591127 591127 Ketyll, Adam, junior, of Elsyng, yeoman 1
5230344 2424490 2424490 defendant Abbot Geoffrey smith 591127 591127 Abbot, Geoffrey, of Elsyng, smith 2
5234472 2425673 2425673 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 0
5238862 2426955 2426955 defendant Magges William husbandman 591127 591127 Magges, William, of Elsyng, husbandman 1
5239168 2427045 2427045 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 0
5239169 2427045 2427045 defendant Sampson John clerk 591127 591127 Sampson, John, of Elsyng, clerk 1
5242916 2428129 2428129 defendant Wylkys John yeoman 591127 591127 Wylkys, John, of Elsyng, yeoman 1
5242917 2428129 2428129 defendant Welle Thomas husbandman 591127 591127 Welle, Thomas, of Elsyng, husbandman 2
5254427 2431511 2431511 defendant atte Welle Thomas   591127 591127 atte Welle, Thomas, of Elsyng, husbandman, administrators of 3
5254428 2431511 2431511 defendant atte Welle Maud widow 591127 591127 (atte Welle, Maud, of Elsyng, widow 4
5254429 2431511 2431511 defendant atte Welle Thomas yeoman 591127 591127 atte Welle, Thomas, of Elsyng, yeoman 5
5254541 2431542 2431542 defendant Wyles John yeoman 591127 591127 Wyles, John, of Elsyng, yeoman 4
5261895 2433827 2433827 defendant Skulton Edmund husbandman 591127 591127 Skulton, Edmund, of Elsyng, husbandman 0
5261896 2433827 2433827 defendant Wykes John yeoman 591127 591127 Wykes, John, of Elsyng, yeoman 1
5269440 2436159 2436159 defendant Blythe Lawrence   591127 591127 Blythe, Lawrence, of Elsyng, parson 0
5300015 2444968 2444968 defendant Wygenale Mathew master & parson of the church 591127 591127 Wygenale, Mathew, of Elsyng, master & parson of the church 1

Next page

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