names

76 rows where place_id = 595951

✎ 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
3622500 1874574 1874574 defendant Tynker John yeoman 595951 595951 Tynker, John, of Bodham, yeoman 1
3760195 1945191 1945191 defendant Dobydoo William   595951 595951 Dobydoo, William, of Bodham, shepherd 0
3786475 1953561 1953561 defendant Noote John husbandman 595951 595951 Noote, John, of Bodham, husbandman 3
3885917 1985546 1985546 plaintiff Botour Thomas   595951 595951 Botour, Thomas, of Bodham 0
4012910 2029348 2029348 plaintiff Reeston John weaver 595951 595951 Reeston, John, of Bodham, weaver 0
4046081 2041038 2041038 plaintiff Shepherd Nicholas grocer 595951 595951 Shepherd, Nicholas, of Bodham, or of Norwich, grocer 0
4046082 2041038 2041038 defendant Warde William husbandman 595951 595951 Warde, William, of Bodham, husbandman 0
4132154 2071812 2071812 defendant Clarke Robert husbandman 595951 595951 Clarke, Robert, of Bodham, husbandman 3
4146002 2076755 2076755 defendant Whyght Thomas yeoman 595951 595951 Whyght, Thomas, of Bodham, yeoman 0
4146003 2076755 2076755 defendant Elward Thomas husbandman 595951 595951 Elward, Thomas, of Bodham, husbandman 1
4147169 2077148 2077148 defendant Whight Thomas, senior yeoman 595951 595951 Whight, Thomas, senior, of Bodham, yeoman 1
4150435 2078282 2078282 defendant Sheppard Robert husbandman 595951 595951 Sheppard, Robert, of Bodham, husbandman 1
4155926 2080149 2080149 defendant Whight Thomas, senior yeoman 595951 595951 Whight, Thomas, senior, of Bodham, yeoman 3
4162005 2082268 2082268 defendant Barker William yeoman 595951 595951 Barker, William, of Bodham, yeoman 3
4166469 2083771 2083771 defendant Rowse George gent 595951 595951 Rowse, George, of Bodham, gent 1
4170829 2085286 2085286 defendant Shepperd Robert husbandman 595951 595951 Shepperd, Robert, of Bodham, husbandman 3
4214010 2100421 2100421 defendant Tynker James husbandman or yeoman 595951 595951 Tynker, James, of Bodham, husbandman or yeoman 0
4221951 2103171 2103171 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 2
4231793 2106617 2106617 defendant Bucker Thomas   595951 595951 Bucker, Thomas, of Bodham, mason 0
4247636 2112190 2112190 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 2
4259888 2116277 2116277 defendant Makefeld Thomas husbandman 595951 595951 Makefeld, Thomas, of Bodham, husbandman 3
4259889 2116277 2116277 defendant Makefeld Joan widow 595951 595951 Makefeld, Joan, of Bodham, widow 4
4282371 2123733 2123733 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 0
4290340 2126599 2126599 defendant Tynker James husbandman 595951 595951 Tynker, James, of Bodham, husbandman 3
4297069 2129051 2129051 defendant Smyth James clerk 595951 595951 Smyth, James, of Bodham, clerk 0
4328017 2139690 2139690 defendant Harman John cooper 595951 595951 Harman, John, of Bodham, cooper 2
4330587 2140524 2140524 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 2
4331705 2140902 2140902 defendant Smyth James clerk 595951 595951 Smyth, James, of Bodham, clerk 0
4331982 2140991 2140991 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 1
4332524 2141167 2141167 defendant Buttell John yeoman 595951 595951 Buttell, John, of Bodham, yeoman 0
4332525 2141167 2141167 defendant Englisshe Edmund yeoman 595951 595951 Englisshe, Edmund, of Bodham, yeoman 1
4346743 2146114 2146114 defendant Smyth James clerk 595951 595951 Smyth, James, of Bodham, clerk 0
4346745 2146114 2146114 defendant Erle John husbandman 595951 595951 Erle, John, of Bodham, husbandman 2
4349056 2146930 2146930 defendant Erle John yeoman 595951 595951 Erle, John, of Bodham, yeoman 2
4349057 2146930 2146930 defendant Englyshe Edmund husbandman 595951 595951 Englyshe, Edmund, of Bodham, husbandman 3
4383049 2159044 2159044 defendant Sheppard William yeoman 595951 595951 Sheppard, William, of Bodham, yeoman 1
4386626 2160203 2160203 defendant Howsego Richard husbandman 595951 595951 Howsego, Richard, of Bodham, husbandman 2
4389656 2161169 2161169 defendant Thomyson Henry husbandman 595951 595951 Thomyson, Henry, of Bodham, husbandman 0
4392049 2161969 2161969 defendant Franck Simon yeoman 595951 595951 Franck, Simon, of Bodham, yeoman 1
4392051 2161969 2161969 defendant Stevens Margaret widow 595951 595951 Stevens, Margaret, of Bodham, widow 3
4392072 2161976 2161976 defendant Franck Simon yeoman 595951 595951 Franck, Simon, of Bodham, yeoman 1
4392074 2161976 2161976 defendant Englishe Edmund husbandman 595951 595951 Englishe, Edmund, of Bodham, husbandman 3
4547269 2215079 2215079 defendant atte Boure Roger   595951 595951 atte Boure, Roger, of Bodham, son of John 0
4547270 2215080 2215080 plaintiff Burwode Robert   595951 595951 Burwode, Robert, of Bodham 0
4576972 2224306 2224306 defendant atte Boure Roger   595951 595951 atte Boure, Roger, of Bodham 0
4918155 2332199 2332199 defendant Cook Simon husbandman 595951 595951 Cook, Simon, of Bodham, husbandman 0
4933232 2336783 2336783 defendant atte Wod Roger   595951 595951 atte Wod, Roger, of Bodham, servant 0
4933308 2336809 2336809 plaintiff Wytthyngham James   595951 595951 Wytthyngham, James, of Bodham, mason 0
4963916 2346118 2346118 defendant Bowre Edward yeoman 595951 595951 Bowre, Edward, of Bodham, yeoman 0
4969630 2347865 2347865 defendant Boure Edward   595951 595951 Boure, Edward, of Bodham, mason 0
4992439 2354623 2354623 defendant Frarie William yeoman 595951 595951 Frarie, William, of Bodham, yeoman 1
5006401 2358771 2358771 defendant Boure Roger husbandman 595951 595951 Boure, Roger, of Bodham, husbandman 0
5006402 2358771 2358771 defendant Boure Edward   595951 595951 Boure, Edward, of Bodham, mason 1
5104846 2387853 2387853 defendant Boure Edward yeoman 595951 595951 Boure, Edward, of Bodham, yeoman 0
5189673 2412724 2412724 defendant Ode Benedict   595951 595951 Ode, Benedict, of Bodham, mason 2
5189675 2412724 2412724 defendant Shepherd John husbandman 595951 595951 Shepherd, John, of Bodham, husbandman 4
5206594 2417662 2417662 defendant Ode Benedict   595951 595951 Ode, Benedict, of Bodham, mason 2
5230920 2424652 2424652 plaintiff Benet Nicholas clerk 595951 595951 Benet, Nicholas, of Bodham, clerk 0
5230925 2424653 2424653 plaintiff Benet Nicholas clerk 595951 595951 Benet, Nicholas, of Bodham, clerk 0
5249478 2429959 2429959 defendant Benet Nicholas clerk 595951 595951 Benet, Nicholas, of Bodham, clerk 0
5304114 2446239 2446239 defendant Skendylby Henry clerk 595951 595951 Skendylby, Henry, of Bodham, clerk 0
5314496 2449365 2449365 defendant Skendylby Roger butcher 595951 595951 Skendylby, Roger, of Bodham, butcher 0
5334064 2455254 2455254 defendant Skendelby Roger husbandman 595951 595951 Skendelby, Roger, of Bodham, husbandman 0
5334065 2455254 2455254 defendant Brethenham Thomas husbandman 595951 595951 Brethenham, Thomas, of Bodham, husbandman 1
5362697 2463982 2463982 plaintiff Tynker John   595951 595951 Tynker, John, of Bodham 0
5370390 2466325 2466325 defendant Goos Thomas husbandman 595951 595951 Goos, Thomas, of Bodham, husbandman 2
5400819 2475298 2475298 defendant Goos Thomas husbandman 595951 595951 Goos, Thomas, of Bodham, husbandman 1
5405847 2476747 2476747 plaintiff Shepherd William   595951 595951 Shepherd, William, of Bodham 0
5476430 2497954 2497954 plaintiff Tynker John   595951 595951 Tynker, John, of Bodham 0
5487956 2501286 2501286 plaintiff Tynker John   595951 595951 Tynker, John, of Bodham 0
5518667 2510671 2510671 defendant Tynker John yeoman 595951 595951 Tynker, John, of Bodham, yeoman 0
5525858 2512679 2512679 defendant Breyngham Henry husbandman 595951 595951 Breyngham, Henry, of Bodham, husbandman 1
5540161 2517048 2517048 defendant Tynker John (legal representative) 595951 595951 Tynker, John, of Bodham, yeoman, executors of 0
5540163 2517048 2517048 defendant Tynker Simon husbandman 595951 595951 Tynker, Simon, of Bodham, husbandman 2
5540164 2517048 2517048 defendant Tynker Robert husbandman 595951 595951 Tynker, Robert, of Bodham, husbandman 3
5608826 2537662 2537662 defendant Goos Thomas husbandman 595951 595951 Goos, Thomas, of Bodham, husbandman 2

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