names

213 rows where place_id = 589052

✎ 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
3596382 1866502 1866502 defendant Arthure John esq 589052 589052 Arthure, John, of Clopton, esq 0
3596383 1866502 1866502 defendant Holcombe John yeoman 589052 589052 Holcombe, John, of Clopton, yeoman 1
3596384 1866502 1866502 defendant Deken John yeoman 589052 589052 Deken, John, of Clopton, yeoman 2
3596385 1866502 1866502 defendant Sybbeley Thomas yeoman 589052 589052 Sybbeley, Thomas, of Clopton, yeoman 3
3596386 1866502 1866502 defendant Skypton Richard yeoman 589052 589052 Skypton, Richard, of Clopton, yeoman 4
3597087 1866711 1866711 defendant Smyth Robert husbandman 589052 589052 Smyth, Robert, of Clopton, husbandman 4
3597088 1866711 1866711 defendant Goreham Thomas husbandman 589052 589052 Goreham, Thomas, of Clopton, husbandman 5
3606106 1869578 1869578 defendant Lewgore William yeoman 589052 589052 Lewgore, William, of Clopton, yeoman 1
3606111 1869579 1869579 defendant Lewgore William yeoman 589052 589052 Lewgore, William, of Clopton, yeoman 1
3610017 1870804 1870804 defendant Lengore William yeoman 589052 589052 Lengore, William, of Clopton, yeoman 0
3612163 1871448 1871448 defendant Lengore William yeoman 589052 589052 Lengore, William, of Clopton, yeoman 0
3612164 1871448 1871448 defendant Lengore John laborer 589052 589052 Lengore, John, of Clopton, laborer 1
3612642 1871592 1871592 defendant Lengore William yeoman 589052 589052 Lengore, William, of Clopton, yeoman 0
3612643 1871592 1871592 defendant Lengore John laborer 589052 589052 Lengore, John, of Clopton, laborer 1
3624040 1875050 1875050 defendant Arthure John esq 589052 589052 Arthure, John, of Clopton, esq 2
3624048 1875051 1875051 defendant Arthure John esq 589052 589052 Arthure, John, of Clopton, esq 0
3625432 1875491 1875491 defendant Arthure John gent 589052 589052 Arthure, John, of Clopton, gent 0
3625452 1875498 1875498 defendant Arthure John gent 589052 589052 Arthure, John, of Clopton, gent 0
3638224 1906776 1906776 defendant Smyth William   589052 589052 Smyth, William, of Clopton, minstrel 0
3644670 1908740 1908740 defendant Androwes John husbandman 589052 589052 Androwes, John, of Clopton, husbandman 0
3646870 1909419 1909419 defendant Smyth William husbandman 589052 589052 Smyth, William, of Clopton, husbandman 2
3648265 1909856 1909856 defendant Spicer William clerk 589052 589052 Spicer, William, of Clopton, clerk 0
3648267 1909857 1909857 defendant Spicer William clerk 589052 589052 Spicer, William, of Clopton, clerk 0
3651639 1910872 1910872 defendant Smyth William yeoman 589052 589052 Smyth, William, of Clopton, yeoman 2
3658901 1913043 1913043 defendant Bond John husbandman 589052 589052 Bond, John, of Clopton, husbandman 0
3658903 1913044 1913044 defendant Bond John husbandman 589052 589052 Bond, John, of Clopton, husbandman 0
3664101 1914724 1914724 defendant Smyth William   589052 589052 Smyth, William, of Clopton, minstrel 2
3718949 1932206 1932206 defendant Artur Thomas gent 589052 589052 Artur, Thomas, of Clopton, gent 2
3748363 1941417 1941417 defendant Aleyn John husbandman 589052 589052 Aleyn, John, of Clopton, husbandman 4
3764041 1946399 1946399 defendant Smyth William yeoman 589052 589052 Smyth, William, of Clopton, yeoman 0
3779796 1951413 1951413 defendant Smyth William   589052 589052 Smyth, William, of Clopton, minstrel 0
3810929 1961319 1961319 defendant Dudley William gent 589052 589052 Dudley, William, of Clopton, gent 2
3810930 1961319 1961319 defendant Dudley Robert gent 589052 589052 Dudley, Robert, of Clopton, gent 3
3833467 1968398 1968398 defendant Hamond Humphrey husbandman 589052 589052 Hamond, Humphrey, of Clopton, husbandman 2
3862467 1977642 1977642 defendant Ellenger John husbandman 589052 589052 Ellenger, John, of Clopton, husbandman 0
3862468 1977642 1977642 defendant Ellenger Thomas laborer 589052 589052 Ellenger, Thomas, of Clopton, laborer 1
3862469 1977642 1977642 defendant Dryver John husbandman 589052 589052 Dryver, John, of Clopton, husbandman 2
3864503 1978328 1978328 defendant Crystmas Richard husbandman 589052 589052 Crystmas, Richard, of Clopton, husbandman 2
3886509 1985742 1985742 defendant Pelles Robert husbandman 589052 589052 Pelles, Robert, of Clopton, husbandman 0
3886510 1985742 1985742 defendant Jenkenson Thomas clerk 589052 589052 Jenkenson, Thomas, of Clopton, clerk 1
3902786 1991161 1991161 defendant Chaundler Robert husbandman 589052 589052 Chaundler, Robert, of Clopton, husbandman 3
3912004 1994339 1994339 defendant Cristmes Thomas husbandman 589052 589052 Cristmes, Thomas, of Clopton, husbandman 0
3943602 2004878 2004878 plaintiff Arthur Thomas (legal representative) 589052 589052 Arthur, Thomas, of Clopton, esq, executor of 0
4024704 2033517 2033517 plaintiff Bonvyle Richard esq 589052 589052 Bonvyle, Richard, of Clopton, esq 0
4078302 2052540 2052540 defendant Arthur Thomas esq 589052 589052 Arthur, Thomas, of Clopton, gent, son of Thomas Arthur, of Clopton, esq 0
4166930 2083932 2083932 defendant Curtys Thomas husbandman 589052 589052 Curtys, Thomas, of Clopton, husbandman 0
4195618 2094018 2094018 defendant Bonvyll Richard esq 589052 589052 Bonvyll, Richard, of Clopton, esq 0
4236802 2108448 2108448 defendant Bett Edmund yeoman 589052 589052 Bett, Edmund, of Clopton, yeoman 1
4245914 2111613 2111613 defendant Burriatt John husbandman 589052 589052 Burriatt, John, of Clopton, husbandman 0
4282199 2123674 2123674 defendant Dobbes Robert husbandman 589052 589052 Dobbes, Robert, of Clopton, husbandman 1
4282200 2123674 2123674 defendant Kinge John yeoman 589052 589052 Kinge, John, of Clopton, yeoman 2
4307292 2132688 2132688 defendant Clopton William   589052 589052 Clopton, William, of Clopton, esq, administrstrix of 0
4390061 2161296 2161296 defendant Bonde Robert yeoman 589052 589052 Bonde, Robert, of Clopton, yeoman 2
4419126 2170849 2170849 plaintiff atte Ree William   589052 589052 atte Ree, William, of Clopton, son of Hugh 0
4456112 2186936 2186936 defendant Thomas John   589052 589052 Thomas, John, of Clopton, son of John 0
4456113 2186936 2186936 defendant Derby Henry   589052 589052 Derby, Henry, of Clopton 1
4461570 2188695 2188695 defendant Burche John   589052 589052 Burche, John, of Clopton 1
4461573 2188696 2188696 defendant Burche John   589052 589052 Burche, John, of Clopton 1
4471152 2191636 2191636 defendant Glanvyle John   589052 589052 Glanvyle, John, of Clopton 3
4479784 2194340 2194340 defendant Burrych John   589052 589052 Burrych, John, of Clopton 2
4479791 2194341 2194341 defendant Burrych John   589052 589052 Burrych, John, of Clopton 4
4482946 2195363 2195363 defendant Thorp William de   589052 589052 Thorp, William de, of Clopton 0
4482947 2195363 2195363 defendant Makeseye William   589052 589052 Makeseye, William, of Clopton 1
4482948 2195363 2195363 defendant Clerk Richard   589052 589052 Clerk, Richard, of Clopton 2
4482949 2195363 2195363 defendant Makeseye Thomas   589052 589052 Makeseye, Thomas, of Clopton 3
4500005 2200641 2200641 defendant Freman John   589052 589052 Freman, John, of Clopton 0
4502137 2201264 2201264 defendant Asselyn William   589052 589052 Asselyn, William, of Clopton 0
4502138 2201264 2201264 defendant Lane William   589052 589052 Lane, William, of Clopton 1
4503991 2201805 2201805 defendant Basset John   589052 589052 Basset, John, of Clopton 1
4532996 2210591 2210591 defendant Freman John   589052 589052 Freman, John, of Clopton 0
4547373 2215110 2215110 plaintiff Butte John   589052 589052 Butte, John, of Clopton 0
4555864 2217775 2217775 defendant Forest Richard   589052 589052 Forest, Richard, of Clopton 0
4555867 2217776 2217776 defendant Forest Richard   589052 589052 Forest, Richard, of Clopton 0
4563079 2220020 2220020 defendant Basset John   589052 589052 Basset, John, of Clopton 4
4572090 2222829 2222829 defendant Basset John   589052 589052 Basset, John, of Clopton 0
4572091 2222829 2222829 defendant Bernewelle John   589052 589052 Bernewelle, John, of Clopton 1
4597755 2230549 2230549 defendant Knobat John ploughman 589052 589052 Knobat, John, of Clopton, ploughman 1
4597758 2230550 2230550 defendant Knobat John ploughman 589052 589052 Knobat, John, of Clopton, ploughman 1
4602355 2231953 2231953 defendant Scot John esq 589052 589052 Scot, John, of Clopton, esq 0
4625189 2238844 2238844 defendant Mellere John   589052 589052 Mellere, John, of Clopton 0
4636037 2242102 2242102 defendant Serle Thomas   589052 589052 Serle, Thomas, of Clopton 0
4647661 2245371 2245371 defendant Mellere John   589052 589052 Mellere, John, of Clopton 0
4653748 2247093 2247093 defendant Bye John berks, laborer 589052 589052 Bye John, of Clopton, berks, laborer 10
4653768 2247096 2247096 defendant Bye John laborer 589052 589052 Bye, John, of Clopton, laborer 4
4661446 2249408 2249408 defendant Basset John husbandman 589052 589052 Basset, John, of Clopton, husbandman 0
4663333 2250003 2250003 defendant Cod John husbandman 589052 589052 Cod, John, of Clopton, husbandman 0
4668439 2255841 2255841 defendant Chaters John dyer 589052 589052 Chaters, John, of Clopton, dyer 0
4670921 2256580 2256580 defendant Ryol John toker or fuller of cloth 589052 589052 Ryol, John, of Clopton, toker or fuller of cloth 3
4670922 2256580 2256580 defendant Palmer John butcher 589052 589052 Palmer, John, of Clopton, butcher 4
4670923 2256580 2256580 defendant Berwyk Robert butcher 589052 589052 Berwyk, Robert, of Clopton, butcher 5
4671865 2256845 2256845 defendant Skyttyssh Henry carpenter 589052 589052 Skyttyssh, Henry, of Clopton, carpenter 0
4687013 2261545 2261545 defendant Chasere John husbandman 589052 589052 Chasere, John, of Clopton, husbandman 3
4689699 2262341 2262341 defendant Clauton John ploughman 589052 589052 Clauton, John, of Clopton, ploughman 0
4689700 2262341 2262341 defendant Cod John   589052 589052 Cod, John, of Clopton, bailiff 1
4693240 2263386 2263386 defendant atate Wode John   589052 589052 atate Wode, John, of Clopton 2
4696707 2264447 2264447 defendant Haddon John chaplain 589052 589052 Haddon, John, of Clopton, chaplain 0
4701987 2266031 2266031 plaintiff Graunt John   589052 589052 Graunt, John, of Clopton 0
4706729 2267488 2267488 defendant Polstede John husbandman 589052 589052 Polstede, John, of Clopton, husbandman 0
4710497 2268641 2268641 defendant Sergeaunt John husbandman 589052 589052 Sergeaunt, John, of Clopton, husbandman 0
4715993 2270312 2270312 defendant Priour John husbandman 589052 589052 Priour, John, of Clopton, husbandman 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);