names

101 rows where place_id = 590798

✎ 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
3602354 1868396 1868396 defendant Qwarles John mercer 590798 590798 Qwarles, John, of Gresham, mercer 2
3702960 1927196 1927196 defendant Fuller John   590798 590798 Fuller, John, of Gresham, wool chapman 0
3707084 1928503 1928503 defendant Flaxman Robert butcher 590798 590798 Flaxman, Robert, of Gresham, butcher 1
3716723 1931522 1931522 defendant Fuller John   590798 590798 Fuller, John, of Gresham, wool chapman 0
3719734 1932438 1932438 defendant Plomer John miller 590798 590798 Plomer, John, of Gresham, miller 2
3724371 1933910 1933910 defendant Dukke Robert husbandman 590798 590798 Dukke, Robert, of Gresham, husbandman 1
3763857 1946339 1946339 defendant Flaxman Robert butcher 590798 590798 Flaxman, Robert, of Gresham, butcher 0
3766507 1947183 1947183 defendant Sayer John yeoman 590798 590798 Sayer, John, of Gresham, yeoman 0
3816050 1962920 1962920 defendant Flaxman Robert butcher 590798 590798 Flaxman, Robert, of Gresham, butcher 1
3828199 1966688 1966688 defendant Flaxman Robert butcher 590798 590798 Flaxman, Robert, of Gresham, butcher 2
3837940 1969779 1969779 defendant Plomer John miller 590798 590798 Plomer, John, of Gresham, miller 2
3859764 1976766 1976766 defendant Poret Thomas husbandman 590798 590798 Poret, Thomas, of Gresham, husbandman 0
3862026 1977486 1977486 defendant Flaxman Robert butcher 590798 590798 Flaxman, Robert, of Gresham, butcher 0
3862027 1977486 1977486 defendant Porrett Thomas tailor 590798 590798 Porrett, Thomas, of Gresham, tailor 1
3863795 1978065 1978065 defendant Flexman Robert butcher 590798 590798 Flexman, Robert, of Gresham, butcher 1
3864889 1978458 1978458 defendant Pynnys Thomas husbandman 590798 590798 Pynnys, Thomas, of Gresham, husbandman 1
3883930 1984894 1984894 defendant Feton Peter yeoman 590798 590798 Feton, Peter, of gresham, yeoman 1
3884016 1984923 1984923 defendant Feton Peter yeoman 590798 590798 Feton, Peter, of Gresham, yeoman 1
3886636 1985783 1985783 defendant Andrews Thomas merchant 590798 590798 Andrews, Thomas, of Gresham, merchant 0
3903315 1991333 1991333 plaintiff Fyttyn Peter yeoman 590798 590798 Fyttyn, Peter, of Gresham, yeoman 0
3903316 1991333 1991333 defendant Wyke William   590798 590798 Wyke, William, of Gresham, coverlet maker 0
3913355 1994802 1994802 defendant Cristmas Robert husbandman 590798 590798 Cristmas, Robert, of Gresham, husbandman 2
3920654 1997256 1997256 defendant Andrewse Thomas merchant 590798 590798 Andrewse, Thomas, of Gresham, merchant 0
3947529 2006206 2006206 defendant Bawchyn William husbandman 590798 590798 Bawchyn, William, of Gresham, husbandman 3
3951772 2007680 2007680 defendant Porrett Richard yeoman 590798 590798 Porrett, Richard, of Gresham, yeoman 0
3952640 2007993 2007993 defendant Andrewes Thomas merchant 590798 590798 Andrewes, Thomas, of Gresham, merchant 0
3985311 2019503 2019503 defendant Bollande Robert husbandman 590798 590798 Bollande, Robert, of Gresham, husbandman 1
3987908 2020421 2020421 defendant Fuller Clement yeoman 590798 590798 Fuller, Clement, of Gresham, yeoman 0
3987910 2020422 2020422 defendant Fuller John husbandman 590798 590798 Fuller, John, of Gresham, husbandman 0
4004959 2026555 2026555 defendant Fuller Clement mercer 590798 590798 Fuller, Clement, of Gresham, mercer 0
4164292 2083032 2083032 defendant Sutor John miller 590798 590798 Sutor, John, of Gresham, or of Saxlingham, miller 0
4173147 2086064 2086064 defendant Godbold Robert singleman 590798 590798 Godbold, Robert, of Gresham, yeoman, singleman 0
4180038 2088496 2088496 defendant Deane John yeoman 590798 590798 Deane, John, of Gresham, yeoman 0
4182130 2089227 2089227 defendant Deane John yeoman 590798 590798 Deane, John, of Gresham, yeoman 0
4229867 2105929 2105929 defendant Smyth Thomas miller 590798 590798 Smyth, Thomas, of Gresham, miller 1
4263293 2117389 2117389 defendant Heaselopp John husbandman 590798 590798 Heaselopp, John, of Gresham, husbandman 1
4324122 2138473 2138473 defendant Atwood John gent 590798 590798 Atwood, John, of Gresham, or of South Reppes, gent 1
4331986 2140992 2140992 defendant Attwoode John yeoman 590798 590798 Attwoode, John, of Gresham, yeoman 2
4331990 2140993 2140993 defendant Ransome Thomas grocer 590798 590798 Ransome, Thomas, of Gresham, grocer 2
4342777 2144748 2144748 defendant Watson Henry husbandman 590798 590798 Watson, Henry, of Gresham, husbandman 0
4727506 2273845 2273845 defendant Russell Thomas husbandman 590798 590798 Russell, Thomas, of Gresham, husbandman 1
4844129 2309676 2309676 defendant Leverych Robert   590798 590798 Leverych, Robert, of Gresham, chaplain, administrators of 0
4844131 2309676 2309676 defendant Capron William draper 590798 590798 Capron, William, of Gresham, draper 2
4858161 2313921 2313921 defendant Pykto Roger husbandman 590798 590798 Pykto, Roger, of Gresham, husbandman 4
4861888 2315094 2315094 defendant Capron William draper 590798 590798 Capron, William, of Gresham, draper 0
4861890 2315095 2315095 defendant Capron William draper 590798 590798 Capron, William, of Gresham, draper 0
5005486 2358507 2358507 defendant Beston John yeoman 590798 590798 Beston, John, of Gresham, yeoman 0
5104647 2387797 2387797 plaintiff Cat James   590798 590798 Cat, James, of Gresham 0
5110220 2389396 2389396 plaintiff Quarles Thomas   590798 590798 Quarles, Thomas, of Gresham 1
5118543 2391854 2391854 defendant Beeston John   590798 590798 Beeston, John, of Gresham, mason 1
5134952 2396724 2396724 defendant Miller Robert clerk & parson 590798 590798 Miller, Robert, of Gresham, clerk & parson 2
5141451 2398615 2398615 defendant Boston John yeoman 590798 590798 Boston, John, of Gresham, yeoman 1
5155083 2402637 2402637 defendant Miller Robert clerk & parson 590798 590798 Miller, Robert, of Gresham, clerk & parson 1
5162580 2404776 2404776 defendant Boston John yeoman 590798 590798 Boston, John, of Gresham, yeoman 1
5207021 2417790 2417790 defendant Miller Robert clerk & parson 590798 590798 Miller, Robert, of Gresham, clerk & parson 1
5232333 2425034 2425034 defendant Qwarles Thomas (legal representative) 590798 590798 Qwarles, Thomas, of Gresham, executors of 4
5232375 2425039 2425039 defendant Quarles Thomas (legal representative) 590798 590798 Quarles, Thomas, of Gresham, mercer, executors of 4
5232376 2425039 2425039 defendant Qwarles Agnes widow 590798 590798 (Qwarles, Agnes, of Gresham, widow 5
5232377 2425039 2425039 defendant Quarles John yeoman 590798 590798 Quarles, John, of Gresham, yeoman 6
5237548 2426566 2426566 defendant Qwarles Thomas (legal representative) 590798 590798 Qwarles, Thomas, of Gresham, mercer, executors of 0
5238980 2426992 2426992 defendant Barker Richard yeoman 590798 590798 Barker, Richard, of Gresham, yeoman 2
5245417 2428813 2428813 plaintiff Qwarles Thomas (legal representative) 590798 590798 Qwarles, Thomas, of Gresham, executors of 0
5252807 2430988 2430988 defendant Miller Robert clerk 590798 590798 Miller, Robert, of Gresham, clerk 0
5252809 2430989 2430989 defendant Miller Robert clerk 590798 590798 Miller, Robert, of Gresham, clerk 0
5264511 2434654 2434654 defendant Kelle John   590798 590798 Kelle, John, of Gresham, shipwright 0
5268363 2435873 2435873 defendant (illegible) William   590798 590798 ----, William, of Gresham, parson 0
5268366 2435874 2435874 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 1
5272037 2436903 2436903 defendant Beeston Thomas   590798 590798 Beeston, Thomas, of Gresham, mason 0
5273113 2437207 2437207 defendant Quarles John mercer 590798 590798 Quarles, John, of Gresham, mercer 4
5275418 2437879 2437879 plaintiff Smyth William   590798 590798 Smyth, William, of Gresham 0
5275419 2437879 2437879 plaintiff Palmer John   590798 590798 Palmer, John, of Gresham 1
5282147 2439847 2439847 defendant Stanton John clerk 590798 590798 Stanton, John, of Gresham, clerk 9
5282159 2439848 2439848 defendant Stanton John clerk 590798 590798 Stanton, John, of Gresham, clerk 10
5288840 2441745 2441745 defendant Quarles John mercer 590798 590798 Quarles, John, of Gresham, mercer 4
5297913 2444397 2444397 defendant Stanton John clerk & rector 590798 590798 Stanton, John, of Gresham, clerk & rector 2
5300070 2444987 2444987 plaintiff Capron John   590798 590798 Capron, John, of Gresham 0
5314661 2449419 2449419 plaintiff Capron John draper 590798 590798 Capron, John, of Gresham, draper 0
5314663 2449420 2449420 plaintiff Capron John draper 590798 590798 Capron, John, of Gresham, draper 0
5324420 2452388 2452388 defendant Beston Thomas   590798 590798 Beston, Thomas, of Gresham, mason 0
5331879 2454615 2454615 plaintiff Capron John   590798 590798 Capron, John, of Gresham 0
5333538 2455104 2455104 defendant Beston John   590798 590798 Beston, John, of Gresham, mason 0
5358715 2462787 2462787 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5374939 2467756 2467756 defendant Purdon Reginald laborer 590798 590798 Purdon, Reginald, of Gresham, laborer 1
5469262 2495738 2495738 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5480574 2499165 2499165 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5480587 2499166 2499166 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5484810 2500380 2500380 defendant Qwarles John yeoman 590798 590798 Qwarles, John, of Gresham, yeoman 0
5493273 2502896 2502896 defendant Quarles John mercer 590798 590798 Quarles, John, of Gresham, mercer 0
5493276 2502897 2502897 defendant Quarles John mercer 590798 590798 Quarles, John, of Gresham, mercer 0
5494548 2503255 2503255 defendant Rysby Thomas carpenter 590798 590798 Rysby, Thomas, of Gresham, carpenter 3
5495357 2503511 2503511 defendant Cat James courtholder 590798 590798 Cat, James, of Gresham, gent, courtholder 0
5500831 2505191 2505191 defendant Quarles John mercer 590798 590798 Quarles, John, of Gresham, mercer 1
5527632 2513220 2513220 defendant Sandwiche John barker 590798 590798 Sandwiche, John, of Gresham, barker 0
5529698 2513793 2513793 defendant Sandewyche John yeoman 590798 590798 Sandewyche, John, of Gresham, yeoman 0
5532083 2514577 2514577 defendant Sandwyche John husbandman 590798 590798 Sandwyche, John, of Gresham, husbandman 0
5555526 2521616 2521616 defendant Capron John yeoman 590798 590798 (Capron, John, of Gresham, yeoman 4
5562900 2523740 2523740 defendant Turnour William raffman 590798 590798 Turnour, William, of Gresham, raffman 0
5574979 2527255 2527255 defendant Turnour William husbandman 590798 590798 Turnour, William, of Gresham, husbandman 0
5593671 2533006 2533006 defendant Clerk Thomas clerk 590798 590798 Clerk, Thomas, of Gresham, clerk 1
5595666 2533565 2533565 defendant Dukke Robert butcher 590798 590798 Dukke, Robert, of Gresham, butcher 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);