names

117 rows where place_id = 586678

✎ 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
3589353 1864310 1864310 defendant Blaksale Robert husbandman 586678 586678 Blaksale, Robert, of Hardyngham, husbandman 5
3591705 1865024 1865024 defendant Busshe Ralph husbandman 586678 586678 Busshe, Ralph, of Hardyngham, husbandman 1
3643514 1908401 1908401 defendant Barker Richard chaplain 586678 586678 Barker, Richard, of Hardyngham, chaplain 2
3672380 1917365 1917365 defendant Dowsyng John husbandman 586678 586678 Dowsyng, John, of Hardyngham, husbandman 1
3672386 1917366 1917366 defendant Thwaytis Anthony gent 586678 586678 Thwaytis, Anthony, of Hardyngham, gent 0
3672387 1917366 1917366 defendant FitzHerbert Agnes widow 586678 586678 FitzHerbert, Agnes, of Hardyngham, widow 1
3682717 1920697 1920697 plaintiff Thwaytes John (legal representative) 586678 586678 Thwaytes, John, of Hardyngham, esq, executors of 0
3703258 1927290 1927290 defendant Bawdewyn John husbandman 586678 586678 Bawdewyn, John, of Hardyngham, husbandman 0
3707700 1928704 1928704 defendant Martyns Thomas miller 586678 586678 Martyns, Thomas, of Hardyngham, miller 2
3726929 1934688 1934688 defendant Pycher William yeoman 586678 586678 Pycher, William, of Hardyngham, yeoman 0
3729656 1935527 1935527 defendant Love Andrew husbandman 586678 586678 Love, Andrew, of Hardyngham, husbandman 0
3741588 1939238 1939238 defendant Pycher William yeoman 586678 586678 Pycher, William, of Hardyngham, yeoman 3
3741590 1939239 1939239 defendant Pycher William yeoman 586678 586678 Pycher, William, of Hardyngham, yeoman 0
3746921 1940954 1940954 defendant Pycher William yeoman 586678 586678 Pycher, William, of Hardyngham, yeoman 0
3760357 1945243 1945243 defendant Pycher William husbandman 586678 586678 Pycher, William, of Hardyngham, husbandman 0
3764172 1946445 1946445 defendant Thwayt Anthony esq 586678 586678 Thwayt, Anthony, of Hardyngham, esq 1
3768774 1947884 1947884 defendant Crese Richard husbandman 586678 586678 Crese, Richard, of Hardyngham, husbandman 2
3776765 1950478 1950478 defendant Pycher William husbandman 586678 586678 Pycher, William, of Hardyngham, husbandman 1
3782160 1952173 1952173 defendant Thwayte Anthony esq 586678 586678 Thwayte, Anthony, of Hardyngham, esq 0
3786573 1953595 1953595 plaintiff Porter Bartholomew singleman 586678 586678 Porter, Bartholomew, of Hardyngham, singleman 0
3795551 1956489 1956489 defendant Dyver John husbandman 586678 586678 Dyver, John, of Hardyngham, husbandman 5
3827703 1966529 1966529 defendant Picher Joan widow 586678 586678 Picher, Joan, of Hardyngham, widow 0
3832275 1968009 1968009 defendant Pecher William (legal representative) 586678 586678 Pecher, William, of Hardyngham, husbandman, administratrix of 0
3832276 1968009 1968009 defendant Pecher Joan widow 586678 586678 Pecher, Joan, of Hardyngham, widow 1
3836286 1969258 1969258 defendant Pycher William (legal representative) 586678 586678 Pycher, William, of Hardyngham, yeoman, executrix of 3
3836287 1969258 1969258 defendant Pycher Joan widow 586678 586678 Pycher, Joan, of Hardyngham, widow 4
3836292 1969259 1969259 defendant Pycher William (legal representative) 586678 586678 Pycher, William, of Hardyngham, yeoman, executrix of 3
3836293 1969259 1969259 defendant Pycher Joan widow 586678 586678 Pycher, Joan, of Hardyngham, widow 4
3866488 1979020 1979020 defendant Woode Richard   586678 586678 Woode, Richard, of Hardyngham, ploughwright 0
3902426 1991042 1991042 defendant Langley John husbandman 586678 586678 Langley, John, of Hardyngham, husbandman 1
3904809 1991871 1991871 defendant Twhatys Anthony esq 586678 586678 Twhatys, Anthony, of Hardyngham, esq 0
3915750 1995645 1995645 defendant Woode Richard husbandman 586678 586678 Woode, Richard, of Hardyngham, husbandman 0
3919697 1996924 1996924 defendant Thwaytes Anthony esq 586678 586678 Thwaytes, Anthony, of Hardyngham, esq 0
3936414 2002500 2002500 defendant Towneshend Lawrence yeoman 586678 586678 Towneshend, Lawrence, of Hardyngham, yeoman 0
3978757 2017147 2017147 defendant Twayte Edward clerk 586678 586678 (Twayte, Edward, of Hardyngham, clerk 1
4000200 2024839 2024839 defendant Cusshyn Edward   586678 586678 Cusshyn, Edward, of Hardyngham, wheelwright 0
4009101 2028022 2028022 defendant Crane William yeoman 586678 586678 Crane, William, of Hardyngham, yeoman 1
4026124 2033987 2033987 plaintiff Burman William yeoman 586678 586678 Burman, William, of Hardyngham, yeoman 0
4049141 2042139 2042139 defendant Busshe John husbandman 586678 586678 Busshe, John, of Hardyngham, husbandman 0
4049142 2042139 2042139 defendant Busshe Ralph laborer 586678 586678 Busshe, Ralph, of Hardyngham, laborer 1
4049143 2042139 2042139 defendant Garthe Robert husbandman 586678 586678 Garthe, Robert, of Hardyngham, husbandman 2
4053269 2043548 2043548 defendant Lyngey Walter tailor 586678 586678 Lyngey, Walter, of Hardyngham, tailor 9
4055802 2044456 2044456 defendant Dennys George miller 586678 586678 Dennys, George, of Hardyngham, miller 1
4071112 2049973 2049973 defendant Cusshyn Edward   586678 586678 Cusshyn, Edward, of Hardyngham, wheelwright 0
4079786 2053070 2053070 defendant Burman William husbandman 586678 586678 Burman, William, of Hardyngham, husbandman 1
4087590 2055856 2055856 defendant Robynson Richard sherman 586678 586678 Robynson, Richard, of Hardyngham, sherman 0
4147760 2077357 2077357 defendant Lynggye Walter yeoman 586678 586678 Lynggye, Walter, of Hardyngham, yeoman 0
4150152 2078188 2078188 defendant Thwayt Anthony gent 586678 586678 Thwayt, Anthony, of Hardyngham, gent 0
4155707 2080078 2080078 defendant Lyngeye Walter yeoman 586678 586678 Lyngeye, Walter, of Hardyngham, yeoman 0
4155708 2080078 2080078 defendant Jermyn Ralph yeoman 586678 586678 Jermyn, Ralph, of Hardyngham, yeoman 1
4155709 2080078 2080078 defendant Batham William, senior yeoman 586678 586678 Batham, William, senior, of Hardyngham, yeoman 2
4193695 2093363 2093363 defendant Barraclow Walter   586678 586678 Barraclow, Walter, of Hardyngham, wheelwright 0
4196602 2094358 2094358 defendant Newman Edmund tanner 586678 586678 Newman, Edmund, of Hardyngham, or of Hengham, tanner 2
4198631 2095079 2095079 defendant Newman Edmund tanner 586678 586678 Newman, Edmund, of Hardyngham, tanner 1
4222041 2103201 2103201 defendant Jarmyn Ralph yeoman 586678 586678 Jarmyn, Ralph, of Hardyngham, yeoman 0
4222042 2103201 2103201 defendant Bushe Thomas yeoman 586678 586678 Bushe, Thomas, of Hardyngham, yeoman 1
4593243 2229183 2229183 defendant Russhel John   586678 586678 Russhel, John, of Hardyngham 6
4754355 2281741 2281741 defendant Causton John miller 586678 586678 Causton, John, of Hardyngham, miller 1
4754994 2281946 2281946 defendant Brygge Henry yeoman 586678 586678 Brygge, Henry, of Hardyngham, yeoman 0
4771836 2287168 2287168 plaintiff Skyllyng John (legal representative) 586678 586678 Skyllyng, John, of Hardyngham, executors of 0
4797030 2295234 2295234 plaintiff Skillyng John (legal representative) 586678 586678 Skillyng, John, of Hardyngham, executors of 0
4984446 2352281 2352281 defendant Dowenyng Thomas husbandman 586678 586678 Dowenyng, Thomas, of Hardyngham, husbandman 0
5020723 2362957 2362957 defendant Maltby William laborer 586678 586678 Maltby, William, of Hardyngham, laborer 2
5036055 2367400 2367400 defendant Malteby William husbandman 586678 586678 Malteby, William, of Hardyngham, husbandman 6
5038736 2368232 2368232 defendant Donny Thomas husbandman 586678 586678 Donny, Thomas, of Hardyngham, husbandman 0
5040876 2368889 2368889 defendant Bret John husbandman 586678 586678 Bret, John, of Hardyngham, husbandman 0
5050461 2371760 2371760 defendant Donny Thomas husbandman 586678 586678 Donny, Thomas, of Hardyngham, husbandman 0
5062435 2375330 2375330 defendant Douny Thomas husbandman 586678 586678 Douny, Thomas, of Hardyngham, husbandman 3
5064241 2375850 2375850 defendant Puttok John husbandman 586678 586678 Puttok, John, of Hardyngham, husbandman 1
5069127 2377260 2377260 plaintiff Pyttok John   586678 586678 Pyttok, John, of Hardyngham 0
5082531 2381280 2381280 plaintiff Doweny Thomas   586678 586678 Doweny, Thomas, of Hardyngham 0
5082532 2381280 2381280 plaintiff atte Hirne John chaplain 586678 586678 atte Hirne, John, of Hardyngham, chaplain 1
5085557 2382170 2382170 defendant Malby William husbandman 586678 586678 Malby, William, of Hardyngham, husbandman 0
5107574 2388646 2388646 defendant Pyttok John husbandman 586678 586678 Pyttok, John, of Hardyngham, husbandman 0
5107575 2388646 2388646 defendant Cok William laborer 586678 586678 Cok, William, of Hardyngham, laborer 1
5107576 2388646 2388646 defendant Den John laborer 586678 586678 Den, John, of Hardyngham, laborer 2
5131522 2395701 2395701 defendant Downyng Thomas husbandman 586678 586678 Downyng, Thomas, of Hardyngham, husbandman 0
5135745 2396967 2396967 defendant Downy (illegible) husbandman 586678 586678 Downy, ---, of Hardyngham, husbandman 0
5150981 2401425 2401425 defendant Downyng Thomas husbandman 586678 586678 Downyng, Thomas, of Hardyngham, husbandman 0
5173976 2408087 2408087 defendant Martyn Thomas husbandman 586678 586678 Martyn, Thomas, of Hardyngham, husbandman 1
5175175 2408431 2408431 defendant Downy Thomas husbandman 586678 586678 Downy, Thomas, of Hardyngham, husbandman 3
5194246 2414049 2414049 defendant Martyn Thomas husbandman 586678 586678 Martyn, Thomas, of Hardyngham, husbandman 1
5196236 2414651 2414651 defendant Downy Thomas husbandman 586678 586678 Downy, Thomas, of Hardyngham, husbandman 3
5205004 2417215 2417215 defendant Downyng Thomas husbandman 586678 586678 Downyng, Thomas, of Hardyngham, husbandman 0
5217103 2420742 2420742 defendant Grene John husbandman 586678 586678 Grene, John, of Hardyngham, husbandman 1
5225928 2423254 2423254 defendant Grene John husbandman 586678 586678 Grene, John, of Hardyngham, husbandman 4
5237375 2426516 2426516 defendant Malby William husbandman 586678 586678 Malby, William, of Hardyngham, husbandman 1
5241967 2427847 2427847 defendant Gylberd John, junior husbandman 586678 586678 Gylberd, John, junior, of Hardyngham, husbandman 2
5263159 2434222 2434222 defendant Hogon John husbandman 586678 586678 Hogon, John, of Hardyngham, husbandman 0
5279348 2439050 2439050 defendant Downyng John chaplain 586678 586678 Downyng, John, of Hardyngham, chaplain 0
5289557 2441946 2441946 defendant Dounnyng William laborer 586678 586678 Dounnyng, William, of Hardyngham, laborer 2
5305850 2446744 2446744 defendant Kusshyn William husbandman 586678 586678 Kusshyn, William, of Hardyngham, husbandman 1
5311212 2448379 2448379 defendant Doweynyg William yeoman 586678 586678 Doweynyg, William, of Hardyngham, yeoman 2
5321743 2451576 2451576 defendant Dowenyng William singleman 586678 586678 Dowenyng, William, of Hardyngham, husbandman, singleman 0
5347799 2459464 2459464 plaintiff Cusshyn Thomas yeoman 586678 586678 Cusshyn, Thomas, of Hardyngham, yeoman 1
5347800 2459464 2459464 plaintiff Cusshyn John, junior   586678 586678 Cusshyn, John, junior, of Hardyngham 2
5351125 2460455 2460455 defendant Smyth John yeoman 586678 586678 Smyth, John, of Hardyngham, yeoman 6
5351131 2460456 2460456 defendant Wechecok John husbandman 586678 586678 Wechecok, John, of Hardyngham, husbandman 2
5351135 2460457 2460457 defendant Wethecok John husbandman 586678 586678 Wethecok, John, of Hardyngham, husbandman 2
5390155 2472246 2472246 defendant Cusshen Thomas yeoman 586678 586678 Cusshen, Thomas, of Hardyngham, yeoman 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);