names

66 rows where place_id = 602135

✎ 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
3648597 1909951 1909951 defendant Stevyns Henry husbandman 602135 602135 Stevyns, Henry, of Henyngham, husbandman 2
3648599 1909951 1909951 defendant Fulk Robert husbandman 602135 602135 Fulk, Robert, of Henyngham, husbandman 4
3672489 1917397 1917397 defendant Fyssher William tailor 602135 602135 Fyssher, William, of Henyngham, tailor 0
3678143 1919214 1919214 defendant Waffyn William   602135 602135 Waffyn, William, of Henyngham, tallow chandler 0
3679448 1919637 1919637 defendant Sadeler Thomas saddler 602135 602135 Sadeler, Thomas, of Henyngham, saddler 1
3781458 1951938 1951938 defendant More Thomas fletcher 602135 602135 More, Thomas, of Henyngham, fletcher 0
3781460 1951939 1951939 defendant More Thomas fletcher 602135 602135 More, Thomas, of Henyngham, fletcher 0
3888711 1986481 1986481 defendant Baldwyn John draper 602135 602135 Baldwyn, John, of Henyngham, draper 0
3924592 1998540 1998540 defendant Howlyn alias Tayllor John husbandman 602135 602135 Howlyn alias Tayllor, John, of Henyngham, husbandman 1
3952600 2007981 2007981 defendant Rooe John yeoman 602135 602135 Rooe, John, of Henyngham, yeoman 0
3974423 2015628 2015628 plaintiff Payne John   602135 602135 Payne, John, of Henyngham 1
3979086 2017271 2017271 defendant Sparrowe John husbandman 602135 602135 Sparrowe, John, of Henyngham, husbandman 0
4017342 2030910 2030910 plaintiff Thetford Christopher gent 602135 602135 Thetford, Christopher, of Henyngham, gent 0
4017344 2030910 2030910 defendant Hollynge alias Taylor John husbandman 602135 602135 Hollynge alias Taylor, John, of Henyngham, husbandman 1
4067022 2048503 2048503 defendant Watson Thomas yeoman 602135 602135 Watson, Thomas, of Henyngham, yeoman 0
4307750 2132849 2132849 defendant Cowper John chapman 602135 602135 Cowper, John, of Henyngham, chapman 3
4443533 2182944 2182944 plaintiff Cat William   602135 602135 Cat, William, of Henyngham 0
4607428 2233432 2233432 defendant Talyour Richard   602135 602135 Talyour, Richard, of Henyngham 0
4655838 2247704 2247704 defendant Wykham John ploughman 602135 602135 Wykham, John, of Henyngham, ploughman 2
4661077 2249289 2249289 defendant Godewyn John yeoman 602135 602135 Godewyn, John, of Henyngham, yeoman 1
4687590 2261704 2261704 defendant T----- Richard mercer 602135 602135 T-----, Richard, of Henyngham, mercer 0
4687592 2261705 2261705 defendant Taillour Richard mercer 602135 602135 Taillour, Richard, of Henyngham, mercer 0
4749585 2280362 2280362 defendant Rove Eustace   602135 602135 Rove, Eustace, of Henyngham, franklin 3
4752799 2281273 2281273 defendant Hoton Alice widow & formerly wife of William Hoton 602135 602135 Hoton, Alice, of Henyngham, widow & formerly wife of William Hoton 1
4818340 2301819 2301819 defendant Godewyn Henry husbandman 602135 602135 Godewyn, Henry, of Henyngham, husbandman 2
4839594 2308302 2308302 defendant Hendrys Adam yeoman 602135 602135 Hendrys, Adam, of Henyngham, yeoman 0
4858033 2313882 2313882 defendant Tommes Richard chaplain 602135 602135 Tommes, Richard, of Henyngham, chaplain 0
4863152 2315453 2315453 defendant Bacon alias Attylbrigge John yeoman 602135 602135 Bacon alias Attylbrigge, John, of Henyngham, yeoman 3
4911034 2329962 2329962 defendant Martynes John   602135 602135 Martynes, John, of Henyngham 0
4958669 2344560 2344560 defendant Titeshale John   602135 602135 Titeshale, John, of Henyngham 0
4961990 2345543 2345543 defendant Smyth William chaplain 602135 602135 Smyth, William, of Henyngham, chaplain 0
4977910 2350354 2350354 defendant Torell John chaplain 602135 602135 Torell, John, of Henyngham, chaplain 0
5023902 2363903 2363903 defendant Tyveteshale John gent 602135 602135 Tyveteshale, John, of Henyngham, gent 0
5067069 2376674 2376674 defendant Noloth John laborer 602135 602135 Noloth, John, of Henyngham, laborer 0
5083377 2381524 2381524 defendant Kerston John laborer 602135 602135 Kerston, John, of Henyngham, laborer 0
5102747 2387218 2387218 defendant Thetford William gent 602135 602135 Thetford, William, of Henyngham, gent 0
5102748 2387218 2387218 defendant Ryder John gent 602135 602135 Ryder, John, of Henyngham, gent 1
5124993 2393785 2393785 defendant Goodwyn Henry husbandman 602135 602135 Goodwyn, Henry, of Henyngham, husbandman 1
5124994 2393785 2393785 defendant Potter Alexander husbandman 602135 602135 Potter, Alexander, of Henyngham, husbandman 2
5258306 2432716 2432716 defendant Ryder John gent 602135 602135 Ryder, John, of Henyngham, gent 2
5266254 2435198 2435198 defendant Richardson Henry husbandman 602135 602135 Richardson, Henry, of Henyngham, husbandman 0
5267384 2435564 2435564 defendant Noloth John husbandman 602135 602135 Noloth, John, of Henyngham, husbandman 4
5278632 2438860 2438860 defendant Oke Alexander laborer 602135 602135 Oke, Alexander, of Henyngham, laborer 13
5321503 2451523 2451523 defendant Okys Alexander husbandman 602135 602135 Okys, Alexander, of Henyngham, husbandman 1
5331726 2454576 2454576 defendant Thetford John gent 602135 602135 Thetford, John, of Henyngham, gent 0
5331727 2454576 2454576 defendant Smyth Robert husbandman 602135 602135 Smyth, Robert, of Henyngham, husbandman 1
5331729 2454576 2454576 defendant Tytteshale Robert husbandman 602135 602135 Tytteshale, Robert, of Henyngham, husbandman 3
5331730 2454576 2454576 defendant Gedney Thomas husbandman 602135 602135 Gedney, Thomas, of Henyngham, husbandman 4
5341710 2457599 2457599 defendant Scrope Thomas   602135 602135 Scrope, Thomas, of Henyngham, clerk, Bishop of Dromore 0
5348224 2459592 2459592 defendant Potter Alexander husbandman 602135 602135 Potter, Alexander, of Henyngham, husbandman 0
5348285 2459603 2459603 defendant Thetford John gent 602135 602135 Thetford, John, of Henyngham, gent 0
5349990 2460126 2460126 defendant Okys Alexander husbandman 602135 602135 Okys, Alexander, of Henyngham, husbandman 2
5353585 2461193 2461193 defendant Ryder John gent 602135 602135 Ryder, John, of Henyngham, gent 1
5353586 2461193 2461193 defendant Ryder William gent 602135 602135 Ryder, William, of Henyngham, gent 2
5363060 2464096 2464096 defendant Lubbok John husbandman 602135 602135 Lubbok, John, of Henyngham, husbandman 0
5384423 2470631 2470631 defendant Crotthe William husbandman 602135 602135 Crotthe, William, of Henyngham, husbandman 1
5396798 2474170 2474170 defendant Okys Alexander   602135 602135 Okys, Alexander, of Henyngham 26
5410041 2477962 2477962 defendant Okys Alexander husbandman 602135 602135 Okys, Alexander, of Henyngham, husbandman 24
5442905 2487789 2487789 defendant Thetford John   602135 602135 Thetford, John, of Henyngham 0
5492011 2502517 2502517 defendant Martyn John husbandman 602135 602135 Martyn, John, of Henyngham, husbandman 0
5492012 2502517 2502517 defendant Crotche William husbandman 602135 602135 Crotche, William, of Henyngham, husbandman 1
5528827 2513537 2513537 defendant Pooley William gent 602135 602135 Pooley, William, of Henyngham, gent 2
5533334 2514975 2514975 defendant Gelyn John husbandman 602135 602135 Gelyn, John, of Henyngham, husbandman 1
5558257 2522365 2522365 defendant Shynkwyn Henry yeoman 602135 602135 Shynkwyn, Henry, of Henyngham, yeoman 1
5558260 2522366 2522366 defendant Shynkwyn Henry yeoman 602135 602135 Shynkwyn, Henry, of Henyngham, yeoman 1
5633804 2554569 2554569 plaintiff Tollere Hubert   602135 602135 Tollere, Hubert, of Henyngham 0

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