names

141 rows where place_id = 600260

✎ 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
3630343 1904330 1904330 defendant Evers Ralph   600260 600260 Evers, Ralph, of Eyton, knight 4
3640332 1907407 1907407 defendant Evers William esq 600260 600260 Evers, William, of Eyton, esq 4
3656770 1912371 1912371 defendant Eyton William gent 600260 600260 Eyton, William, of Eyton, gent 1
3664284 1914782 1914782 defendant Middelton James gent 600260 600260 Middelton, James, of Eyton, gent 0
3664317 1914791 1914791 defendant Myddelton James gent 600260 600260 Myddelton, James, of Eyton, gent 0
3664326 1914792 1914792 defendant Myddelton James gent 600260 600260 Myddelton, James, of Eyton, gent 0
3675998 1918530 1918530 defendant Milward Robert yeoman 600260 600260 Milward, Robert, of Eyton, yeoman 1
3676836 1918794 1918794 defendant Gough Richard husbandman 600260 600260 Gough, Richard, of Eyton, husbandman 0
3684097 1921161 1921161 defendant Gibson John yeoman 600260 600260 Gibson, John, of Eyton, yeoman 2
3687648 1922306 1922306 defendant Mountford Thomas husbandman 600260 600260 Mountford, Thomas, of Eyton, husbandman 2
3713798 1930615 1930615 defendant Middelton James gent 600260 600260 Middelton, James, of Eyton, gent 1
3763923 1946359 1946359 defendant Alen Hugh maltman 600260 600260 Alen, Hugh, of Eyton, maltman 0
3773900 1949549 1949549 defendant Eyton Henry esq 600260 600260 Eyton, Henry, of Eyton under Wylmore, esq 0
3773902 1949550 1949550 defendant Eyton Henry esq 600260 600260 Eyton, Henry, of Eyton, esq 0
3775829 1950189 1950189 defendant Sebroke William husbandman 600260 600260 Sebroke, William, of Eyton, husbandman 0
3784552 1952955 1952955 defendant Conlyff William yeoman 600260 600260 Conlyff, William, of Eyton, yeoman 0
3784560 1952958 1952958 defendant Conlyff William yeoman 600260 600260 Conlyff, William, of Eyton, yeoman 0
3784562 1952959 1952959 defendant Conlyff William yeoman 600260 600260 Conlyff, William, of Eyton, yeoman 0
3795036 1956311 1956311 defendant Cowdale Thomas miller 600260 600260 Cowdale, Thomas, of Eyton, miller 0
3800642 1958114 1958114 defendant Bawgh Griffin yeoman 600260 600260 Bawgh, Griffin, of Eyton, yeoman 0
3800643 1958114 1958114 defendant Tailour Thomas husbandman 600260 600260 Tailour, Thomas, of Eyton, husbandman 1
3800644 1958114 1958114 defendant Wyllyams John, senior husbandman 600260 600260 Wyllyams, John, senior, of Eyton, husbandman 2
3800645 1958114 1958114 defendant Wyllyams John, junior husbandman 600260 600260 Wyllyams, John, junior, of Eyton, husbandman 3
3809812 1960957 1960957 plaintiff Blaknall Henry clerk 600260 600260 Blaknall, Henry, of Eyton, clerk 0
3829775 1967206 1967206 defendant Lodygnton John   600260 600260 Lodygnton, John, of Eyton, yeoman, bailiff of Barford Hundred 1
3845474 1972142 1972142 defendant Aleyn Thomas yeoman 600260 600260 Aleyn, Thomas, of Eyton, yeoman 1
3845475 1972142 1972142 defendant Sherrat John husbandman 600260 600260 Sherrat, John, of Eyton, husbandman 2
3845476 1972142 1972142 defendant Underwood John husbandman 600260 600260 Underwood, John, of Eyton, husbandman 3
3845477 1972142 1972142 defendant Shutt Robert husbandman 600260 600260 Shutt, Robert, of Eyton, husbandman 4
3845478 1972142 1972142 defendant Cooke John husbandman 600260 600260 Cooke, John, of Eyton, husbandman 5
3845479 1972142 1972142 defendant Parker Thomas, junior laborer 600260 600260 Parker, Thomas, junior, of Eyton, laborer 6
3847105 1972646 1972646 defendant Bray Edmund   600260 600260 Bray, Edmund, of Eyton, knight, Lord Bray 0
3847108 1972647 1972647 defendant Bray Edmund   600260 600260 Bray, Edmund, of Eyton, knight, Lord Bray 0
3847111 1972648 1972648 defendant Bray Edmund   600260 600260 Bray, Edmund, of Eyton, knight, Lord Bray 0
3847114 1972649 1972649 defendant Bray Edmund   600260 600260 Bray, Edmund, of Eyton, knight, Lord Bray 0
3860812 1977108 1977108 defendant Grace Thomas husbandman 600260 600260 Grace, Thomas, of Eyton, husbandman 0
3872775 1981108 1981108 defendant Cutlett Cuthbert husbandman 600260 600260 Cutlett, Cuthbert, of Eyton, husbandman 0
3875077 1981896 1981896 defendant Grace Thomas husbandman 600260 600260 Grace, Thomas, of Eyton, husbandman 0
3879524 1983406 1983406 plaintiff Mylward Robert   600260 600260 Mylward, Robert, of Eyton 0
3887096 1985947 1985947 defendant Stokton Thomas gent 600260 600260 Stokton, Thomas, of Eyton, gent 0
3890749 1987172 1987172 defendant Mylys John, junior husbandman 600260 600260 Mylys, John, junior, of Eyton, husbandman 4
3894360 1988330 1988330 defendant Felp William husbandman 600260 600260 Felp, William, of Eyton, husbandman 0
3908751 1993222 1993222 defendant Halknytt Thomas gent 600260 600260 Halknytt, Thomas, of Eyton, gent 0
3929175 2000098 2000098 defendant Jenkyns John husbandman 600260 600260 Jenkyns, John, of Eyton, husbandman 0
3962448 2011456 2011456 defendant George Thomas husbandman 600260 600260 George, Thomas, of Eyton, husbandman 0
3962449 2011456 2011456 defendant George John husbandman 600260 600260 George, John, of Eyton, husbandman 1
3966375 2012869 2012869 plaintiff Bourchoppe Edmund yeoman 600260 600260 Bourchoppe, Edmund, of Eyton, yeoman 0
3970713 2014345 2014345 defendant George John husbandman 600260 600260 George, John, of Eyton, husbandman 0
4000223 2024849 2024849 defendant Bray Reginald, junior gent 600260 600260 Bray, Reginald, junior, of Eyton, gent 0
4004479 2026378 2026378 defendant Burrehoppe Edmund yeoman 600260 600260 Burrehoppe, Edmund, of Eyton, yeoman 0
4004480 2026378 2026378 defendant Connoppe William yeoman 600260 600260 Connoppe, William, of Eyton, yeoman 1
4004483 2026379 2026379 defendant Barrehoppe Edmund yeoman 600260 600260 Barrehoppe, Edmund, of Eyton, yeoman 0
4004484 2026379 2026379 defendant Connappe William yeoman 600260 600260 Connappe, William, of Eyton, yeoman 1
4009165 2028047 2028047 defendant Connoppe William husbandman 600260 600260 Connoppe, William, of Eyton, husbandman 0
4009167 2028048 2028048 defendant Conopp William husbandman 600260 600260 Conopp, William, of Eyton, husbandman 0
4010765 2028628 2028628 defendant Conoppe Eilliam yeoman 600260 600260 Conoppe, Eilliam, of Eyton, yeoman 0
4016198 2030491 2030491 defendant Connoppe John, senior yeoman 600260 600260 Connoppe, John, senior, of Eyton, yeoman 0
4016199 2030491 2030491 defendant Connoppe Robert yeoman 600260 600260 Connoppe, Robert, of Eyton, yeoman 1
4016200 2030491 2030491 defendant Connoppe William yeoman 600260 600260 Connoppe, William, of Eyton, yeoman 2
4016201 2030491 2030491 defendant Po Thomas husbandman 600260 600260 Po, Thomas, of Eyton, husbandman 3
4020768 2032154 2032154 defendant Jenk Thomas laborer 600260 600260 Jenk, Thomas, of Eyton, laborer 6
4033806 2036740 2036740 defendant Connopp William yeoman 600260 600260 Connopp, William, of Eyton, yeoman 0
4166989 2083956 2083956 defendant Connoppe William yeoman 600260 600260 Connoppe, William, of Eyton, yeoman 0
4191754 2092673 2092673 defendant Conopp William yeoman 600260 600260 Conopp, William, of Eyton, yeoman 1
4191755 2092673 2092673 defendant Conopp Thomas   600260 600260 Conopp, Thomas, of Eyton, husbandman, his son 2
4223146 2103584 2103584 defendant Burre Richard husbandman 600260 600260 Burre, Richard, of Eyton, husbandman 0
4271149 2119926 2119926 defendant Eyton James   600260 600260 Eyton, James, of Eyton, esq, administrators of 2
4286628 2125264 2125264 defendant Bukmaster John yeoman 600260 600260 Bukmaster, John, of Eyton, yeoman 0
4322027 2137785 2137785 defendant Steventon Thomas yeoman 600260 600260 Steventon, Thomas, of Eyton, yeoman 0
4331055 2140684 2140684 defendant Genkyns John yeoman 600260 600260 Genkyns, John, of Eyton, yeoman 0
4350505 2147439 2147439 defendant Williams John yeoman 600260 600260 Williams, John, of Eyton, yeoman 2
4426782 2173193 2173193 defendant Rogers William   600260 600260 Rogers, William, of Eyton 0
4441415 2182256 2182256 plaintiff Boteler John   600260 600260 Boteler, John, of Eyton 0
4441416 2182256 2182256 defendant Roter John   600260 600260 Roter, John, of Eyton 0
4441417 2182257 2182257 plaintiff Boteler John   600260 600260 Boteler, John, of Eyton 0
4442143 2182472 2182472 defendant Botyler John   600260 600260 Botyler, John, of Eyton 0
4458529 2187718 2187718 defendant Smyth Richard chaplain 600260 600260 Smyth, Richard, of Eyton, chaplain 1
4507159 2202707 2202707 plaintiff Walkere Richard chaplain 600260 600260 Walkere, Richard, of Eyton, chaplain, on his own account 0
4507160 2202707 2202707 defendant Smyth Joh   600260 600260 Smyth, Joh, of Eyton, vicar 0
4546616 2214867 2214867 defendant Gwymyon Margery   600260 600260 Gwymyon, Margery, of Eyton, formerly wife of David 0
4572432 2222918 2222918 plaintiff atte Broke William   600260 600260 atte Broke, William, of Eyton 0
4572435 2222919 2222919 plaintiff atte Broke William   600260 600260 atte Broke, William, of Eyton 0
4585297 2226825 2226825 plaintiff Hakelyt Richard   600260 600260 Hakelyt, Richard, of Eyton 0
4720237 2271672 2271672 defendant Wattisson William husbandman 600260 600260 Wattisson, William, of Eyton, husbandman 1
4720238 2271672 2271672 defendant Wytherlye Richard husbandman 600260 600260 Wytherlye, Richard, of Eyton, husbandman 2
4720239 2271672 2271672 defendant Walsheman Grovough laborer 600260 600260 Walsheman, Grovough, of Eyton, laborer 3
4724385 2272923 2272923 defendant Eyton John husbandman 600260 600260 Eyton, John, of Eyton, husbandman 0
4735085 2276122 2276122 defendant Eyton John husbandman 600260 600260 Eyton, John, of Eyton, husbandman 0
4738489 2277129 2277129 defendant Hoke William husbandman 600260 600260 Hoke, William, of Eyton, husbandman 3
4740434 2277717 2277717 defendant Rawelyns William yeoman 600260 600260 Rawelyns, William, of Eyton, yeoman 3
4753864 2281587 2281587 defendant Hoke William husbandman 600260 600260 Hoke, William, of Eyton, husbandman 0
4754398 2281756 2281756 defendant Rogers John husbandman 600260 600260 Rogers, John, of Eyton, husbandman 1
4760025 2283473 2283473 defendant Milnere John miller 600260 600260 Milnere, John, of Eyton, miller 0
4762207 2284159 2284159 defendant Wycherley Richard husbandman 600260 600260 Wycherley, Richard, of Eyton, husbandman 1
4775208 2288240 2288240 defendant Hoke William husbandman 600260 600260 Hoke, William, of Eyton, husbandman 0
4785223 2291397 2291397 defendant Hanmasshe John husbandman 600260 600260 Hanmasshe, John, of Eyton, husbandman 0
4814045 2300498 2300498 defendant Eyton Hicholas gent 600260 600260 Eyton, Hicholas, of Eyton, gent 4
4814051 2300500 2300500 defendant Eyton Nicholas gent 600260 600260 Eyton, Nicholas, of Eyton, gent 1
4820158 2302377 2302377 defendant Keller William husbandman 600260 600260 Keller, William, of Eyton, husbandman 4
4857994 2313867 2313867 defendant Robyns William, senior husbandman 600260 600260 Robyns, William, senior, of Eyton, husbandman 2

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