names

144 rows where place_id = 588823

✎ 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
3595710 1866287 1866287 defendant Sherman Thomas sherman 588823 588823 Sherman, Thomas, of Snetesham, sherman 0
3595711 1866287 1866287 defendant Johnson Robert tailor 588823 588823 Johnson, Robert, of Snetesham, tailor 1
3602449 1868424 1868424 defendant Gogney John yeoman 588823 588823 Gogney, John, of Snetesham, yeoman 0
3633678 1905344 1905344 defendant Percy Stephen husbandman 588823 588823 Percy, Stephen, of Snetesham, husbandman 0
3633679 1905344 1905344 defendant Audeley John husbandman 588823 588823 Audeley, John, of Snetesham, husbandman 1
3634260 1905513 1905513 defendant Lawrens John yeoman 588823 588823 Lawrens, John, of Snetesham, yeoman 3
3645682 1909052 1909052 defendant Elyer or Glyer William chaplain 588823 588823 Elyer or Glyer, William, of Snetesham, chaplain 0
3680684 1920039 1920039 plaintiff Russell Henry   588823 588823 Russell, Henry, of Snetesham 0
3696929 1925260 1925260 plaintiff Smyth Robert   588823 588823 Smyth, Robert, of Snetesham 0
3720874 1932824 1932824 defendant Rolff Thomas yeoman 588823 588823 Rolff, Thomas, of Snetesham, yeoman 0
3740510 1938891 1938891 plaintiff Russell Henrym gent 588823 588823 Russell, Henrym, of Snetesham, gent 0
3741281 1939133 1939133 defendant Russell Henry gent 588823 588823 Russell, Henry, of Snetesham, gent 0
3826862 1966250 1966250 defendant Percy Stephen husbandman 588823 588823 Percy, Stephen, of Snetesham, husbandman 0
3826864 1966251 1966251 defendant Lamson William laborer 588823 588823 Lamson, William, of Snetesham, laborer 0
4057286 2044989 2044989 defendant Bradde James, junior husbandman 588823 588823 Bradde, James, junior, of Snetesham, husbandman 0
4151964 2078796 2078796 defendant Ryxe Nicholas husbandman 588823 588823 Ryxe, Nicholas, of Snetesham, husbandman 1
4388888 2160914 2160914 defendant Wrashe Thomas husbandman 588823 588823 Wrashe, Thomas, of Snetesham, husbandman 0
4444194 2183164 2183164 defendant Devenne William   588823 588823 Devenne, William, of snetesham thresher 0
4453953 2186255 2186255 plaintiff Loksmyth Roger   588823 588823 Loksmyth, Roger, of Snetesham 0
4456497 2187049 2187049 defendant Burgh John de   588823 588823 Burgh, John de, of Snetesham 1
4456888 2187166 2187166 defendant Wylymot Simon   588823 588823 Wylymot, Simon, of Snetesham 0
4465786 2189969 2189969 defendant Wilymot Simon   588823 588823 Wilymot, Simon, of Snetesham 0
4535782 2211470 2211470 defendant Loksmyth Roger   588823 588823 Loksmyth, Roger, of Snetesham 0
4535788 2211471 2211471 defendant Smyth Reginald   588823 588823 Smyth, Reginald, of Snetesham 3
4565604 2220812 2220812 defendant atte Morr Thomas   588823 588823 atte Morr, Thomas, of Snetesham 5
4586653 2227237 2227237 defendant Percy Thomas   588823 588823 Percy, Thomas, of Snetesham 0
4586654 2227238 2227238 plaintiff Hobbes Richard   588823 588823 Hobbes, Richard, of Snetesham 0
4586656 2227238 2227238 defendant atte Dam Margaret weaver 588823 588823 atte Dam, Margaret, of Snetesham, daughter of John, weaver 1
4593571 2229263 2229263 defendant Eton William   588823 588823 Eton, William, of Snetesham 0
4602797 2232089 2232089 defendant Chaffare William   588823 588823 Chaffare, William, of Snetesham 1
4605781 2232923 2232923 defendant Mason Nicholas   588823 588823 Mason, Nicholas, of Snetesham 0
4618191 2236697 2236697 plaintiff Skynnere Robert   588823 588823 Skynnere, Robert, of Snetesham 2
4633079 2241214 2241214 defendant Smyth John   588823 588823 Smyth, John, of Snetesham, formerly living in Dersyngham 0
4641652 2243660 2243660 defendant Dallay Thomas cooper 588823 588823 Dallay, Thomas, of Snetesham, cooper 0
4643827 2244290 2244290 plaintiff Langtoft John   588823 588823 Langtoft, John, of Snetesham 0
4649891 2245985 2245985 defendant Hoo Adam de   588823 588823 Hoo, Adam de, of Snetesham 0
4655653 2247651 2247651 defendant de Hoo Adam mercer 588823 588823 de Hoo, Adam, of Snetesham, mercer 2
4656723 2247995 2247995 defendant Calbras Richard farmer 588823 588823 Calbras, Richard, of Snetesham, farmer 0
4659143 2248731 2248731 defendant Percy Thomas yeoman 588823 588823 Percy, Thomas, of Snetesham, yeoman 0
4660976 2249257 2249257 defendant Hobbes John cordwainer 588823 588823 Hobbes, John, of Snetesham, cordwainer 2
4665409 2250657 2250657 plaintiff Hobbes Richard   588823 588823 Hobbes, Richard, of Snetesham 0
4665412 2250657 2250657 defendant Warner Richard warrener 588823 588823 Warner, Richard, of Snetesham, warrener 0
4674275 2257563 2257563 defendant Wesenham Thomas gent 588823 588823 Wesenham, Thomas, of Snetesham, gent 0
4676527 2258274 2258274 defendant Curteys John husbandman 588823 588823 Curteys, John, of Snetesham, husbandman 2
4677175 2258479 2258479 defendant Wyke John husbandman 588823 588823 Wyke, John, of Snetesham, husbandman 0
4686307 2261322 2261322 defendant Dersyngham William gent 588823 588823 Dersyngham, William, of Snetesham, gent 0
4686655 2261437 2261437 plaintiff Walter Nicholas   588823 588823 Walter, Nicholas, of Snetesham, vicar 1
4686656 2261437 2261437 defendant Hobbys John yeoman & son of Richard Hobbys 588823 588823 Hobbys, John, of Snetesham, yeoman & son of Richard Hobbys 0
4686658 2261438 2261438 plaintiff Walter Nicholas   588823 588823 Walter, Nicholas, of Snetesham, vicar on their own account 1
4686659 2261438 2261438 defendant Hobbys John yeoman & son of Richard 588823 588823 Hobbys, John, of Snetesham, yeoman & son of Richard 0
4687156 2261588 2261588 defendant Calbras Richard yeoman 588823 588823 Calbras, Richard, of Snetesham, yeoman 0
4687631 2261715 2261715 defendant Dullay Thomas cooper 588823 588823 Dullay, Thomas, of Snetesham, cooper 0
4687632 2261715 2261715 defendant Roo Thomas husbandman 588823 588823 Roo, Thomas, of Snetesham, husbandman 1
4687845 2261764 2261764 defendant Dokkyng John yeoman 588823 588823 Dokkyng, John, of Snetesham, yeoman 2
4689096 2262149 2262149 defendant Owyke John husbandman 588823 588823 Owyke, John, of Snetesham, husbandman 1
4695440 2264053 2264053 defendant Wysbech Thomas baker 588823 588823 Wysbech, Thomas, of Snetesham, baker 0
4695442 2264053 2264053 defendant Howard William husbandman 588823 588823 Howard, William, of Snetesham, husbandman 2
4695443 2264053 2264053 defendant Millere Thomas miller 588823 588823 Millere, Thomas, of Snetesham, miller 3
4695444 2264053 2264053 defendant Tippyng William laborer 588823 588823 Tippyng, William, of Snetesham, laborer 4
4695584 2264105 2264105 defendant Smyth Thomas husbandman 588823 588823 Smyth, Thomas, of Snetesham, husbandman 0
4709100 2268213 2268213 defendant Hobbes Thomas husbandman 588823 588823 Hobbes, Thomas, of Snetesham, husbandman 0
4709101 2268213 2268213 defendant Smyth John husbandman 588823 588823 Smyth, John, of Snetesham, husbandman 1
4709551 2268344 2268344 defendant Smyth John   588823 588823 Smyth, John, of Snetesham, chapman, now living in Dersyngham 0
4720553 2271764 2271764 defendant Hebbes Thomas husbandman 588823 588823 Hebbes, Thomas, of Snetesham, husbandman 1
4720559 2271765 2271765 defendant Smyth Thomas husbandman 588823 588823 Smyth, Thomas, of Snetesham, husbandman 0
4731346 2275005 2275005 defendant Wessenham Thomas yeoman 588823 588823 Wessenham, Thomas, of Snetesham, yeoman 0
4733628 2275696 2275696 defendant Hobbes Richard (legal representative) 588823 588823 Hobbes, Richard, of Snetesham, executors of 0
4733629 2275696 2275696 defendant Hobbes Thomas husbandman 588823 588823 (Hobbes, Thomas, of Snetesham, husbandman 1
4742382 2278265 2278265 defendant Dollay Thomas cooper 588823 588823 Dollay, Thomas, of Snetesham, cooper 3
4751134 2280809 2280809 defendant Dersyngham William gent 588823 588823 Dersyngham, William, of Snetesham, gent 0
4752029 2281086 2281086 defendant Dersyngham William yeoman 588823 588823 Dersyngham, William, of Snetesham, yeoman 0
4752030 2281086 2281086 defendant Smyth John yeoman 588823 588823 Smyth, John, of Snetesham, yeoman 1
4752249 2281127 2281127 defendant Dokkyng John husbandman 588823 588823 Dokkyng, John, of Snetesham, husbandman 2
4761257 2283868 2283868 defendant Dallyng John husbandman 588823 588823 Dallyng, John, of Snetesham, husbandman 0
4764991 2285026 2285026 defendant Mason Nicholas   588823 588823 Mason, Nicholas, of Snetesham, mason 0
4764992 2285026 2285026 defendant Dalleye Thomas cooper 588823 588823 Dalleye, Thomas, of Snetesham, cooper 1
4764993 2285026 2285026 defendant Potekyn Nicholas shipman 588823 588823 Potekyn, Nicholas, of Snetesham, shipman 2
4769266 2286365 2286365 defendant Hobbes Thomas husbandman 588823 588823 Hobbes, Thomas, of Snetesham, husbandman 2
4774579 2288036 2288036 defendant Smyth John yeoman 588823 588823 Smyth, John, of Snetesham, yeoman 1
4789093 2292645 2292645 defendant Mason Nicholas   588823 588823 Mason, Nicholas, of Snetesham, mason 0
4789094 2292645 2292645 defendant Dalleye Thomas cooper 588823 588823 Dalleye, Thomas, of Snetesham, cooper 1
4789095 2292645 2292645 defendant Potekyn Nicholas shipman 588823 588823 Potekyn, Nicholas, of Snetesham, shipman 2
4789688 2292842 2292842 defendant Smyth John yeoman 588823 588823 Smyth, John, of Snetesham, yeoman 2
4823783 2303524 2303524 defendant Dersyng William yeoman 588823 588823 Dersyng, William, of Snetesham, yeoman 1
4850320 2311555 2311555 defendant Wesenham Alice   588823 588823 Wesenham, Alice, of Snetesham, widow, formerly wife of John 4
4857171 2313627 2313627 defendant Shenkewyn John yeoman 588823 588823 Shenkewyn, John, of Snetesham, yeoman 1
4857176 2313628 2313628 defendant Shenkewyn John yeoman 588823 588823 Shenkewyn, John, of Snetesham, yeoman 3
4873070 2318532 2318532 defendant Wysbech Thomas husbandman 588823 588823 Wysbech, Thomas, of Snetesham, husbandman 1
4876903 2319745 2319745 defendant Burgh Stephen chapman 588823 588823 Burgh, Stephen, of Snetesham, chapman 2
4877873 2320037 2320037 defendant Dersyngham William yeoman 588823 588823 Dersyngham, William, of Snetesham, yeoman 0
4878595 2320249 2320249 defendant Dulley Thomas cooper 588823 588823 Dulley, Thomas, of Snetesham, cooper 3
4889691 2323568 2323568 defendant Darsyngham William husbandman 588823 588823 Darsyngham, William, of Snetesham, husbandman 0
4926449 2334692 2334692 plaintiff Qwyk John   588823 588823 Qwyk, John, of Snetesham 0
4958440 2344493 2344493 defendant Hakford Edmund yeoman 588823 588823 Hakford, Edmund, of Snetesham, yeoman 2
4989924 2353895 2353895 defendant Shenkewyn John butcher 588823 588823 Shenkewyn, John, of Snetesham, butcher 0
4992284 2354585 2354585 defendant Shomaker Richard shoemaker 588823 588823 Shomaker, Richard, of Snetesham, shoemaker 0
4992285 2354585 2354585 defendant Hakke Robert husbandman 588823 588823 Hakke, Robert, of Snetesham, husbandman 1
4992287 2354585 2354585 defendant Rust John   588823 588823 Rust, John, of snetesham, shepherd 3
5020814 2362984 2362984 defendant Hard John   588823 588823 Hard, John, of Snetesham, servant 0
5061729 2375104 2375104 plaintiff Hake Robert   588823 588823 Hake, Robert, of Snetesham 0

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