names

123 rows where place_id = 607836

✎ 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
3670989 1916899 1916899 defendant Reymer Thomas smith 607836 607836 (Reymer, Thomas, of Sloley, smith 3
3674642 1918120 1918120 defendant Reymer Thomas smith 607836 607836 Reymer, Thomas, of Sloley, smith 0
3686773 1922018 1922018 defendant Glaven Walter   607836 607836 Glaven, Walter, of Sloley, worsted weaver 0
3697004 1925289 1925289 plaintiff Sparhawke Adam (legal representative) 607836 607836 Sparhawke, Adam, of Sloley, executors of 0
3697007 1925289 1925289 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 3
3697085 1925309 1925309 plaintiff Sperhawke Adam alias Thomas (legal representative) 607836 607836 Sperhawke, Adam alias Thomas, of Sloley, executors of 0
3697088 1925309 1925309 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 3
3708239 1928872 1928872 defendant Bonde John   607836 607836 Bonde, John, of Sloley, worsted weaver 0
3709650 1929327 1929327 defendant Hardyngham Adam   607836 607836 Hardyngham, Adam, of Sloley, worsted weaver 0
3746520 1940823 1940823 defendant Walby John   607836 607836 Walby, John, of Sloley, worsted weaver 0
3753620 1943076 1943076 plaintiff Sparkanke Adam (legal representative) 607836 607836 Sparkanke, Adam, of Sloley, executors of 0
3757968 1944477 1944477 defendant Hardyngham Walter   607836 607836 Hardyngham, Walter, of Sloley, worsted weaver 0
3762947 1946043 1946043 defendant Hardyngham Adam yeoman 607836 607836 Hardyngham, Adam, of Sloley, yeoman 2
3763442 1946198 1946198 defendant Swanton Robert   607836 607836 Swanton, Robert, of Sloley, worsted weaver, administrators of 3
3763444 1946198 1946198 defendant Scottowe Katherine widow 607836 607836 Scottowe, Katherine, of Sloley, widow 5
3769293 1948050 1948050 defendant Hardyngham Adam   607836 607836 Hardyngham, Adam, of Sloley, worsted weaver 0
3770752 1948540 1948540 plaintiff Sparhauke Adam (legal representative) 607836 607836 Sparhauke, Adam, of Sloley, executors of 0
3781478 1951945 1951945 defendant Scothowe Robert (legal representative) 607836 607836 Scothowe, Robert, of Sloley, worsted weaver, administratrix of 0
3781479 1951945 1951945 defendant Scothowe Katherine widow 607836 607836 Scothowe, Katherine, of Sloley, widow 1
3782825 1952378 1952378 defendant Hardyngham Adam   607836 607836 Hardyngham, Adam, of Sloley, worsted weaver 0
3793835 1955938 1955938 defendant Echard John   607836 607836 Echard, John, of Sloley, worsted weaver 0
3799399 1957733 1957733 defendant Hardyngham Adam   607836 607836 Hardyngham, Adam, of Sloley, worsted weaver 0
3803398 1958964 1958964 defendant Hardyngham Adam   607836 607836 Hardyngham, Adam, of Sloley, worsted weaver 1
3804731 1959427 1959427 plaintiff Sparhawke Adam (legal representative) 607836 607836 Sparhawke, Adam, of Sloley, yeoman, executors of 0
3804733 1959427 1959427 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley 2
3810034 1961027 1961027 defendant Echard John   607836 607836 Echard, John, of Sloley, worsted weaver 0
3823305 1965203 1965203 plaintiff Trewe William (legal representative) 607836 607836 Trewe, William, of Sloley, clerk, executor of 0
3823307 1965203 1965203 defendant Gunby Richard gent 607836 607836 Gunby, Richard, of Sloley, gent 0
3823308 1965204 1965204 plaintiff Trewe William (legal representative) 607836 607836 Trewe, William, of Sloley, clerk, executor of 0
3834596 1968753 1968753 defendant Barker John tailor 607836 607836 Barker, John, of Sloley, tailor 3
3836044 1969186 1969186 defendant Trace Roger husbandman 607836 607836 Trace, Roger, of Sloley, husbandman 1
3836046 1969186 1969186 defendant Calowe Clement husbandman 607836 607836 Calowe, Clement, of Sloley, husbandman 3
3837561 1969657 1969657 plaintiff Sparhawke Adam (legal representative) 607836 607836 Sparhawke, Adam, of Sloley, executors of 0
3849355 1973395 1973395 defendant Foster Robert   607836 607836 Foster, Robert, of Sloley, of worsted weaver 2
3889995 1986890 1986890 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 0
3889998 1986891 1986891 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 0
3895460 1988693 1988693 plaintiff Sparhanke Adam (legal representative) 607836 607836 Sparhanke, Adam, of Sloley, executor of 0
3895461 1988693 1988693 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 1
3895464 1988694 1988694 plaintiff Sparhauke Adam (legal representative) 607836 607836 Sparhauke, Adam, of Sloley, executor of 0
3895465 1988694 1988694 plaintiff Hardyngham Thomas   607836 607836 Hardyngham, Thomas, of Sloley, worsted weaver 1
3918828 1996621 1996621 defendant Skolehous Richard reeder 607836 607836 Skolehous, Richard, of Sloley, reeder 0
3972446 2014939 2014939 defendant Pawden William husbandman 607836 607836 Pawden, William, of Sloley, husbandman 0
3996600 2023543 2023543 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 4
4017346 2030911 2030911 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 0
4026656 2034179 2034179 defendant Russell Andrew   607836 607836 Russell, Andrew, of Sloley, worsted weaver 0
4034293 2036932 2036932 defendant Rust Thomas barber 607836 607836 Rust, Thomas, of Sloley, barber 2
4058926 2045587 2045587 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 1
4067648 2048742 2048742 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 0
4078699 2052676 2052676 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 0
4108688 2063361 2063361 defendant Heche Thomas husbandman 607836 607836 Heche, Thomas, of Sloley, husbandman 0
4110819 2064125 2064125 defendant Haynes Robert husbandman 607836 607836 Haynes, Robert, of Sloley, husbandman 2
4112999 2064918 2064918 defendant Russell Andrew yeoman 607836 607836 Russell, Andrew, of Sloley, yeoman 0
4117747 2066640 2066640 defendant Myller Robert   607836 607836 Myller, Robert, of Sloley, worsted weaver 1
4139633 2074538 2074538 defendant Heach Thomas husbandman 607836 607836 Heach, Thomas, of Sloley, husbandman 1
4164432 2083078 2083078 defendant Heach Thomas husbandman 607836 607836 Heach, Thomas, of Sloley, husbandman 1
4208160 2098409 2098409 defendant Sponer Edmund husbandman 607836 607836 Sponer, Edmund, of Sloley, husbandman 0
4208161 2098409 2098409 defendant Ellys Stephen husbandman 607836 607836 Ellys, Stephen, of Sloley, husbandman 1
4208162 2098409 2098409 defendant Pestell Edward husbandman 607836 607836 Pestell, Edward, of Sloley, husbandman 2
4282103 2123641 2123641 defendant Galte George gent 607836 607836 Galte, George, of Sloley, gent 3
4387379 2160424 2160424 defendant Dyball Robert husbandman 607836 607836 Dyball, Robert, of Sloley, husbandman 1
4449057 2184647 2184647 defendant Glaveyn William   607836 607836 Glaveyn, William, of Sloley 0
4628777 2239928 2239928 defendant Sparwe Thomas   607836 607836 Sparwe, Thomas, of Sloley 5
4671282 2256670 2256670 defendant Magges Stephen   607836 607836 Magges, Stephen, of Sloley, worsted maker 5
4725871 2273378 2273378 defendant Prat William yeoman 607836 607836 Prat, William, of Sloley, bailiff of Bishop's Lenn, yeoman 1
4856987 2313566 2313566 defendant Sterlyng John, senior weaver 607836 607836 Sterlyng, John, senior, of Sloley, weaver 0
4901177 2326980 2326980 defendant Dey John husbandman 607836 607836 Dey, John, of Sloley, husbandman 6
4926345 2334665 2334665 defendant Depham Thomas clerk 607836 607836 Depham, Thomas, of Sloley, clerk 1
4928920 2335468 2335468 defendant Depeham Thomas clerk 607836 607836 Depeham, Thomas, of Sloley, clerk 0
4950145 2342011 2342011 defendant Norwyche Francis clerk 607836 607836 Norwyche, Francis, of Sloley, clerk 0
4973857 2349138 2349138 defendant Norwyche Thomas husbandman 607836 607836 Norwyche, Thomas, of Sloley, husbandman 1
4985847 2352683 2352683 plaintiff Alysaundyr John   607836 607836 Alysaundyr, John, of Sloley 0
4986436 2352871 2352871 defendant Glaven Walter yeoman 607836 607836 Glaven, Walter, of Sloley, yeoman 0
4998283 2356356 2356356 defendant Groos John esq 607836 607836 Groos, John, of Sloley, esq 0
4998286 2356357 2356357 defendant Groos Oliver esq 607836 607836 Groos, Oliver, of Sloley, esq 0
5000455 2357002 2357002 defendant Norwich Francis   607836 607836 Norwich, Francis, of Sloley, parson 0
5000456 2357002 2357002 defendant Norwich Thomas husbandman 607836 607836 Norwich,Thomas, of Sloley, husbandman 1
5040651 2368814 2368814 defendant Glaveyn Ralph husbandman 607836 607836 Glaveyn, Ralph, of Sloley, husbandman 0
5052045 2372223 2372223 defendant Groos John esq 607836 607836 Groos, John, of Sloley, esq 1
5053429 2372630 2372630 defendant Rogers John   607836 607836 Rogers, John, of Sloley, worsted weaver 2
5053431 2372630 2372630 defendant Rogers Ralph   607836 607836 Rogers, Ralph, of Sloley, worsted weaver 4
5057146 2373718 2373718 defendant Glaveyn John husbandman 607836 607836 Glaveyn, John, of Sloley, husbandman 2
5057147 2373718 2373718 defendant Glaveyn Walter husbandman 607836 607836 Glaveyn, Walter, of Sloley, husbandman 3
5072429 2378243 2378243 defendant Glaveyn John husbandman 607836 607836 Glaveyn, John, of Sloley, husbandman 1
5075040 2379036 2379036 defendant Beupre Thomas esq 607836 607836 Beupre, Thomas, of Sloley, esq 1
5079356 2380323 2380323 defendant Astele Thomas yeoman 607836 607836 Astele, Thomas, of Sloley, yeoman 0
5079357 2380323 2380323 defendant Prat Thomas tailor 607836 607836 Prat, Thomas, of Sloley, tailor 1
5079358 2380323 2380323 defendant White Thomas yeoman 607836 607836 White, Thomas, of Sloley, yeoman 2
5086443 2382431 2382431 defendant Hardyngham Thomas husbandman 607836 607836 Hardyngham, Thomas, of Sloley, husbandman 2
5093097 2384369 2384369 defendant Rogerys John   607836 607836 Rogerys, John, of Sloley, worsted weaver 2
5104429 2387722 2387722 defendant Astle Thomas tailor 607836 607836 Astle, Thomas, of Sloley, yeoman: P-, Thomas, of Sloley, tailor 0
5104430 2387722 2387722 defendant Whyte Thomas yeoman 607836 607836 Whyte, Thomas, of Sloley, yeoman 1
5109648 2389251 2389251 plaintiff Glaveyn John   607836 607836 (Glaveyn, John, of Sloley, son of Glaveyn, Nicholas 1
5109656 2389252 2389252 plaintiff Glaveyn John   607836 607836 (Glaveyn, John, of Sloley, son of Glaveyn, Nicholas 1
5126110 2394117 2394117 defendant Warde Robert husbandman 607836 607836 Warde, Robert, of Sloley, husbandman 9
5151491 2401586 2401586 defendant Cooke William shoemaker 607836 607836 Cooke, William, of Sloley, shoemaker 0
5169632 2406854 2406854 defendant Cooke William   607836 607836 Cooke, William, of Sloley, shoe maker 0
5237762 2426631 2426631 plaintiff Glaveyn John   607836 607836 Glaveyn, John, of Sloley, son of Glaveyn, Nicholas 0
5237766 2426632 2426632 plaintiff Glaveyn John, senior   607836 607836 Glaveyn, John, senior, of Sloley 0
5255060 2431697 2431697 defendant Glaveyn William (legal representative) 607836 607836 Glaveyn, William, of Sloley, yeoman, executor of 7
5255061 2431697 2431697 defendant Glaveyn Thomas husbandman 607836 607836 Glaveyn, Thomas, of Sloley, husbandman 8

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