names

311 rows where place_id = 590415

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601140 1868019 1868019 defendant Childeston John yeoman 590415 590415 Childeston, John, of Mildenhale, yeoman 3
3603063 1868624 1868624 defendant Bronewyn Robert husbandman 590415 590415 Bronewyn, Robert, of Mildenhale, husbandman 4
3603557 1868783 1868783 defendant Meyre John barker 590415 590415 Meyre, John, of Mildenhale, barker 1
3604430 1869054 1869054 defendant Cheston Richard laborer 590415 590415 Cheston, Richard, of Mildenhale, laborer 1
3606637 1869749 1869749 defendant Man Richard butcher 590415 590415 Man, Richard, of Mildenhale, butcher 0
3611526 1871275 1871275 defendant Garnysshe John husbandman 590415 590415 Garnysshe, John, of Mildenhale, husbandman 0
3616418 1872770 1872770 defendant Kent Robert husbandman 590415 590415 Kent, Robert, of Mildenhale, husbandman 0
3621800 1874356 1874356 defendant Rysyng Robert shoemaker 590415 590415 Rysyng, Robert, of Mildenhale, shoemaker 2
3635759 1905984 1905984 defendant Barltelott alias Felde John miller 590415 590415 Barltelott alias Felde, John, of Mildenhale, miller 0
3637948 1906688 1906688 defendant Mone Thomas husbandman 590415 590415 Mone, Thomas, of Mildenhale, husbandman 0
3638273 1906789 1906789 defendant Motte Thomas husbandman 590415 590415 Motte, Thomas, of Mildenhale, husbandman 4
3650104 1910401 1910401 defendant Norman William husbandman 590415 590415 Norman, William, of Mildenhale, husbandman 0
3654573 1911693 1911693 plaintiff Bakhot John   590415 590415 Bakhot, John, of Mildenhale 0
3675688 1918428 1918428 defendant Bartlot John husbandman 590415 590415 Bartlot, John, of Mildenhale, husbandman 0
3675689 1918428 1918428 defendant Bartlot Richard husbandman 590415 590415 Bartlot, Richard, of Mildenhale, husbandman 1
3678484 1919327 1919327 defendant Polyngton Richard painter 590415 590415 Polyngton, Richard, of Mildenhale, painter 0
3683599 1921002 1921002 defendant Clerke Edward tailor 590415 590415 Clerke, Edward, of Mildenhale, tailor 1
3687688 1922317 1922317 defendant Welys Nicholas tailor 590415 590415 Welys, Nicholas, of Mildenhale, tailor 0
3691353 1923456 1923456 defendant Stokyng Thomas husbandman 590415 590415 Stokyng, Thomas, of Mildenhale, husbandman 0
3694203 1924391 1924391 defendant Bartlott John husbandman 590415 590415 Bartlott, John, of Mildenhale, husbandman 1
3709237 1929185 1929185 defendant Cole Richard tanner 590415 590415 Cole, Richard, of Mildenhale, tanner 0
3724265 1933876 1933876 defendant Talmage Hugh gent 590415 590415 Talmage, Hugh, of Mildenhale, gent 0
3739538 1938577 1938577 defendant Warlyngton John sherman 590415 590415 Warlyngton, John, of Mildenhale, sherman 0
3764480 1946554 1946554 defendant Hull Thomas (legal representative) 590415 590415 Hull, Thomas, of Mildenhale, merchant, executors of 0
3764481 1946554 1946554 defendant Palton Nicholas yeoman 590415 590415 (Palton, Nicholas, of Mildenhale, yeoman 1
3764482 1946554 1946554 defendant Larke Thomas yeoman 590415 590415 Larke, Thomas, of Mildenhale, yeoman 2
3775936 1950223 1950223 defendant Warburton John yeoman 590415 590415 Warburton, John, of Mildenhale, yeoman 0
3784026 1952782 1952782 defendant Warburton John gent 590415 590415 Warburton, John, of Mildenhale, gent 1
3784029 1952783 1952783 defendant Warburton John gent 590415 590415 Warburton, John, of Mildenhale, gent 0
3787259 1953810 1953810 defendant Geson William sherman 590415 590415 Geson, William, of Mildenhale, sherman 0
3787393 1953850 1953850 defendant Bakhott John (legal representative) 590415 590415 Bakhott, John, of Mildenhale, gent, executors of 0
3787394 1953850 1953850 defendant Warburton John yeoman 590415 590415 (Warburton, John, of Mildenhale, yeoman 1
3793052 1955685 1955685 defendant Cutler John smith 590415 590415 Cutler, John, of Mildenhale, smith 2
3802850 1958787 1958787 defendant Hall William butcher 590415 590415 Hall, William, of Mildenhale, butcher 0
3818048 1963556 1963556 defendant Warburton John gent 590415 590415 Warburton, John, of Mildenhale, gent 0
3839850 1970396 1970396 defendant Larke Thomas yeoman 590415 590415 Larke, Thomas, of Mildenhale, yeoman 0
3851864 1974175 1974175 defendant Dobson Thomas dyer 590415 590415 Dobson, Thomas, of Mildenhale, dyer 0
3866398 1978993 1978993 defendant Larke Thomas yeoman 590415 590415 Larke, Thomas, of Mildenhale, yeoman 0
3866401 1978993 1978993 defendant Duffeld Thomas husbandman 590415 590415 Duffeld, Thomas, of Mildenhale, husbandman 3
3888246 1986328 1986328 plaintiff Duffeld Robert tanner 590415 590415 Duffeld, Robert, of Mildenhale, tanner 0
3888247 1986328 1986328 defendant Cole Richard tanner 590415 590415 Cole, Richard, of Mildenhale, tanner 0
3923485 1998163 1998163 plaintiff Sokerman Andrew (legal representative) 590415 590415 Sokerman, Andrew, of Mildenhale, executors of 0
3923490 1998163 1998163 defendant Eblewhygth Richard husbandman 590415 590415 Eblewhygth, Richard, of Mildenhale, husbandman 2
3984871 2019344 2019344 plaintiff Thurston Robert tanner 590415 590415 Thurston, Robert, of Mildenhale, tanner 0
3984875 2019345 2019345 plaintiff Thurston Robert tanner 590415 590415 Thurston, Robert, of Mildenhale, tanner 0
3992897 2022213 2022213 defendant Pope William esq 590415 590415 Pope, William, of Mildenhale, esq 0
4417958 2170491 2170491 plaintiff Terefeld William de   590415 590415 Terefeld, William de, of Mildenhale 0
4418334 2170616 2170616 defendant Taillour Adam le   590415 590415 Taillour, Adam le, of Mildenhale 0
4428801 2173807 2173807 defendant Godewyne John   590415 590415 Godewyne, John, of Mildenhale 0
4428803 2173808 2173808 defendant Cook Richard   590415 590415 Cook, Richard, of Mildenhale 0
4428804 2173809 2173809 plaintiff Terefeld William de   590415 590415 Terefeld, William de, of Mildenhale 0
4428805 2173809 2173809 defendant Fisshere William le   590415 590415 Fisshere, William le, of Mildenhale, son of Henry 0
4433569 2175263 2175263 defendant Claver William   590415 590415 Claver, William, of Mildenhale 0
4440408 2181911 2181911 defendant Lystere John   590415 590415 Lystere, John, of Mildenhale 1
4447699 2184202 2184202 defendant Clerk Thomas   590415 590415 Clerk, Thomas, of Mildenhale 1
4449495 2184789 2184789 defendant Fornesete William de (legal representative) 590415 590415 Fornesete, William de, of Mildenhale, vicar, executor of 0
4449972 2184946 2184946 plaintiff Gundele Alice   590415 590415 Gundele, Alice, of Mildenhale 0
4449973 2184946 2184946 defendant Tymeworthe Simon   590415 590415 Tymeworthe, Simon, of Mildenhale 0
4457547 2187372 2187372 plaintiff Petryck Nicholas   590415 590415 Petryck, Nicholas, of Mildenhale 0
4460985 2188508 2188508 plaintiff Soper William   590415 590415 Soper, William, of Mildenhale 0
4460987 2188509 2188509 plaintiff Soper William   590415 590415 Soper, William, of Mildenhale 0
4507353 2202762 2202762 defendant Playford Edmund   590415 590415 Playford, Edmund, of Mildenhale 4
4521664 2207106 2207106 plaintiff Genot Thomas   590415 590415 Genot, Thomas, of Mildenhale 0
4543539 2213870 2213870 plaintiff atte More John   590415 590415 atte More, John, of Mildenhale 0
4563573 2220172 2220172 defendant Fleccher Robert   590415 590415 Fleccher, Robert, of Mildenhale 14
4565699 2220836 2220836 plaintiff Sopere William   590415 590415 Sopere, William, of Mildenhale 0
4565700 2220836 2220836 plaintiff Ged William   590415 590415 Ged, William, of Mildenhale 1
4565701 2220836 2220836 defendant Penne Robert smith 590415 590415 Penne, Robert, of Mildenhale, smith 0
4581981 2225806 2225806 defendant Skynnere Nicholas   590415 590415 Skynnere, Nicholas, of Mildenhale 0
4581982 2225806 2225806 defendant Permounter John   590415 590415 Permounter, John, of Mildenhale 1
4581991 2225806 2225806 defendant Tynworth William   590415 590415 Tynworth, William, of Mildenhale 10
4581994 2225807 2225807 defendant Skynnere Nicholas   590415 590415 Skynnere, Nicholas, of Mildenhale 0
4581995 2225807 2225807 defendant Permounter John   590415 590415 Permounter, John, of Mildenhale 1
4582004 2225807 2225807 defendant Tymworth William   590415 590415 Tymworth, William, of Mildenhale 10
4582107 2225839 2225839 defendant Cowehierde John   590415 590415 Cowehierde, John, of Mildenhale 5
4582108 2225839 2225839 defendant Boteler William   590415 590415 Boteler, William, of Mildenhale 6
4589225 2228011 2228011 defendant Prat Walter   590415 590415 Prat, Walter, of Mildenhale 2
4618122 2236678 2236678 defendant Tymworth William   590415 590415 Tymworth, William, of Mildenhale 1
4619196 2237002 2237002 plaintiff Hethe Thomas   590415 590415 Hethe, Thomas, of Mildenhale 0
4626171 2239144 2239144 plaintiff Pope Robert   590415 590415 Pope, Robert, of Mildenhale 0
4626181 2239145 2239145 plaintiff Pope Robert   590415 590415 Pope, Robert, of Mildenhale 0
4629116 2240032 2240032 plaintiff Slygh Thomas   590415 590415 Slygh, Thomas, of Mildenhale 0
4629117 2240032 2240032 defendant Frere John   590415 590415 Frere, John, of Mildenhale 0
4630246 2240370 2240370 defendant Fraunceys Thomas   590415 590415 Fraunceys, Thomas, of Mildenhale 1
4636567 2242266 2242266 defendant Waryn John   590415 590415 Waryn, John, of Mildenhale 0
4636568 2242266 2242266 defendant Turnour Thomas   590415 590415 Turnour, Thomas, of Mildenhale 1
4636569 2242266 2242266 defendant Cordewener Gilbert   590415 590415 Cordewener, Gilbert, of Mildenhale 2
4636570 2242266 2242266 defendant Hancok Thomas   590415 590415 Hancok, Thomas, of Mildenhale 3
4636571 2242266 2242266 defendant Mey Thomas   590415 590415 Mey, Thomas, of Mildenhale 4
4636572 2242266 2242266 defendant Gynke Thomas   590415 590415 Gynke, Thomas, of Mildenhale 5
4636573 2242266 2242266 defendant Koo Thomas   590415 590415 Koo, Thomas, of Mildenhale 6
4636870 2242349 2242349 defendant Massa_ Richard   590415 590415 Massa_, Richard, of Mildenhale 2
4640700 2243387 2243387 defendant Smyth Thomas   590415 590415 Smyth, Thomas, of Mildenhale 1
4642816 2244010 2244010 plaintiff Hethe Thomas   590415 590415 Hethe, Thomas, of Mildenhale 0
4646749 2245117 2245117 defendant Heth Thomas   590415 590415 Heth, Thomas, of Mildenhale 0
4648646 2245658 2245658 defendant Strete William   590415 590415 Strete, William, of Mildenhale 0
4652440 2246712 2246712 plaintiff Backet John, senior   590415 590415 Backet, John, senior, of Mildenhale 0
4662910 2249862 2249862 plaintiff Galyon William   590415 590415 Galyon, William, of Mildenhale 0
4664415 2250350 2250350 plaintiff Haras John   590415 590415 Haras, John, of Mildenhale 0
4664418 2250351 2250351 plaintiff Haras John   590415 590415 Haras, John, of Mildenhale 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);