names

171 rows where place_id = 603983

✎ 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
3656461 1912268 1912268 defendant Walden Richard butcher 603983 603983 Walden, Richard, of Little Walsyngham, butcher 0
3656625 1912326 1912326 defendant Sydney Thomas gent 603983 603983 Sydney, Thomas, of Little Walsyngham, gent 0
3656626 1912326 1912326 defendant Gisburgh George mercer 603983 603983 Gisburgh, George, of Little Walsyngham, mercer 1
3659295 1913164 1913164 defendant Anges or Auges Robert smith 603983 603983 Anges or Auges, Robert, of Little Walsyngham, smith 0
3659832 1913329 1913329 defendant Angos Robert smith 603983 603983 Angos, Robert, of Little Walsyngham, smith 0
3660253 1913469 1913469 defendant Stone Margaret widow 603983 603983 Stone, Margaret, of Little Walsyngham, widow 2
3660259 1913470 1913470 defendant Stone Margaret widow 603983 603983 Stone, Margaret, of Little Walsyngham, widow 2
3660954 1913698 1913698 defendant Smyth John mercer 603983 603983 Smyth, John, of Little Walsyngham, mercer 0
3660959 1913699 1913699 defendant Matsale Thomas, junior mercer 603983 603983 Matsale, Thomas, junior, of Little Walsyngham, mercer 1
3660961 1913700 1913700 defendant Matsalle Thomas, senior mercer 603983 603983 Matsalle, Thomas, senior, of Little Walsyngham, mercer 0
3660965 1913701 1913701 defendant Matsale Thomas, junior mercer 603983 603983 Matsale, Thomas, junior, of Little Walsyngham, mercer 1
3665248 1915085 1915085 defendant Marston John   603983 603983 Marston, John, of Little Walsyngham, rough mason 0
3929384 2000174 2000174 defendant Vaughan John yeoman 603983 603983 Vaughan, John, of Little Walsyngham, yeoman 1
3936398 2002496 2002496 defendant Sheryngham Edmund (legal representative) 603983 603983 Sheryngham, Edmund, of Little Walsyngham, butcher, executors of 0
3936399 2002496 2002496 defendant Vaughan John yeoman 603983 603983 (Vaughan, John, of Little Walsyngham, yeoman 1
3938295 2003146 2003146 defendant Vaughan John yeoman 603983 603983 Vaughan, John, of Little Walsyngham, yeoman 0
4521109 2206943 2206943 plaintiff Fuller Geoffrey   603983 603983 Fuller, Geoffrey, of Little Walsyngham 0
4521121 2206946 2206946 plaintiff Fullere Geoffrey   603983 603983 Fullere, Geoffrey, of Little Walsyngham 0
4534956 2211212 2211212 defendant Catour John   603983 603983 Catour, John, of Little Walsyngham 0
4535391 2211340 2211340 defendant Lente Thomas   603983 603983 Lente, Thomas, of Little Walsyngham 0
4535392 2211340 2211340 defendant Olyver John   603983 603983 Olyver, John, of Little Walsyngham 1
4571639 2222706 2222706 defendant Goldsmyth John   603983 603983 Goldsmyth, John, of Little Walsyngham 5
4578801 2224853 2224853 defendant Cley Thomas   603983 603983 Cley, Thomas, of Little Walsyngham 2
4590107 2228271 2228271 defendant Barbour William   603983 603983 Barbour, William, of Little Walsyngham 0
4594223 2229459 2229459 defendant Gobet Richard   603983 603983 Gobet, Richard, of Little Walsyngham 0
4602455 2231988 2231988 defendant Walpol John butcher 603983 603983 Walpol, John, of Little Walsyngham, butcher 4
4614344 2235498 2235498 defendant Schedere Edmund   603983 603983 Schedere, Edmund, of Little Walsyngham 1
4620923 2237526 2237526 defendant Broune Thomas taverner 603983 603983 Broune, Thomas, of Little Walsyngham, taverner 0
4622069 2237882 2237882 plaintiff Lexham John   603983 603983 Lexham, John, of Little Walsyngham 0
4628613 2239874 2239874 plaintiff Seem William (legal representative) 603983 603983 Seem, William, of Little Walsyngham, executors of 0
4628616 2239874 2239874 defendant Roule Walter (legal representative) 603983 603983 Roule, Walter, of Little Walsyngham, executrix of 0
4640399 2243308 2243308 defendant Barbour William   603983 603983 Barbour, William, of Little Walsyngham 0
4640400 2243308 2243308 defendant Shedere Edmund   603983 603983 Shedere, Edmund, of Little Walsyngham 1
4640403 2243309 2243309 plaintiff Stocke Margaret   603983 603983 Stocke, Margaret, of Little Walsyngham 1
4640404 2243309 2243309 plaintiff Lynge John   603983 603983 Lynge, John, of Little Walsyngham 2
4672387 2257016 2257016 plaintiff Coddyng Roger   603983 603983 Coddyng, Roger, of Little Walsyngham 0
4672388 2257016 2257016 plaintiff Benet Hugh   603983 603983 Benet, Hugh, of Little Walsyngham 1
4672389 2257016 2257016 defendant Barbour William yeoman 603983 603983 Barbour, William, of Little Walsyngham, yeoman 0
4683191 2260358 2260358 plaintiff Lyng John   603983 603983 Lyng, John, of Little Walsyngham 1
4683192 2260358 2260358 defendant Broun Thomas taverner 603983 603983 Broun, Thomas, of Little Walsyngham, taverner 0
4686927 2261518 2261518 plaintiff Spicer Ralph   603983 603983 Spicer, Ralph, of Little Walsyngham, on his own account 0
4686929 2261518 2261518 defendant Delgate Henry husbandman 603983 603983 Delgate, Henry, of Little Walsyngham, husbandman 1
4764669 2284937 2284937 defendant Netbreyder Richard   603983 603983 Netbreyder, Richard, of Little Walsyngham, cook 1
4806533 2298257 2298257 plaintiff Caudeler Nicholas   603983 603983 Caudeler, Nicholas, of Little Walsyngham 0
4809268 2299072 2299072 defendant Sadeler William yeoman 603983 603983 Sadeler, William, of Little Walsyngham, yeoman 1
4826023 2304176 2304176 defendant Sadeler William yeoman 603983 603983 Sadeler, William, of Little Walsyngham, yeoman 0
4833600 2306517 2306517 defendant Parker William husbandman 603983 603983 Parker, William, of Little Walsyngham, husbandman 1
4908384 2329177 2329177 plaintiff Smyth William   603983 603983 Smyth, William, of Little Walsyngham 1
4922295 2333391 2333391 plaintiff Bradle Simon yeoman 603983 603983 Bradle, Simon, of Little Walsyngham, yeoman 1
4927402 2335003 2335003 defendant Snoryng Geoffrey yeoman 603983 603983 Snoryng, Geoffrey, of Little Walsyngham, yeoman 1
4927407 2335004 2335004 defendant Snoryng Geoffrey yeoman 603983 603983 Snoryng, Geoffrey, of Little Walsyngham, yeoman 1
4992772 2354721 2354721 plaintiff Denham Geoffrey   603983 603983 Denham, Geoffrey, of Little Walsyngham 0
4996132 2355701 2355701 defendant Chaumberleyn Richard husbandman 603983 603983 Chaumberleyn, Richard, of Little Walsyngham, husbandman 0
4996256 2355736 2355736 defendant Eldrych Sewalus   603983 603983 Eldrych, Sewalus, of Little Walsyngham, wax chandler 1
4998392 2356396 2356396 plaintiff Jiles Robert mercer 603983 603983 Jiles, Robert, of Little Walsyngham, mercer 0
4999052 2356595 2356595 defendant Denham Geoffrey mercer 603983 603983 Denham, Geoffrey, of Little Walsyngham, mercer 0
4999060 2356597 2356597 defendant Denham William mercer 603983 603983 Denham, William, of Little Walsyngham, mercer 0
5001641 2357372 2357372 defendant Snoryng Geoffrey yeoman 603983 603983 Snoryng, Geoffrey, of Little Walsyngham, yeoman 0
5012044 2360371 2360371 defendant Roo James husbandman 603983 603983 Roo, James, of Little Walsyngham, husbandman 5
5038580 2368184 2368184 defendant Hawker Robert (legal representative) 603983 603983 Hawker, Robert, of Little Walsyngham, hosier, executors of 0
5038582 2368184 2368184 defendant Hawker Katherine widow 603983 603983 Hawker, Katherine, of Little Walsyngham, widow 2
5040007 2368609 2368609 plaintiff Bradley alias Cook Simon (legal representative) 603983 603983 Bradley alias Cook, Simon, of Little Walsyngham, yeoman, executors of 0
5040017 2368611 2368611 plaintiff Bradley Simon (legal representative) 603983 603983 Bradley, Simon, of Little Walsyngham, executors of 0
5040018 2368611 2368611 plaintiff Bradley Marmgaret   603983 603983 (Bradley, Marmgaret, of Little Walsyngham, formerly wife of Testator 1
5040029 2368615 2368615 defendant Kendale John yeoman 603983 603983 Kendale, John, of Little Walsyngham, yeoman 0
5047148 2370767 2370767 defendant Iryng Thomas smith 603983 603983 Iryng, Thomas, of Little Walsyngham, smith 4
5049387 2371452 2371452 plaintiff Southwelle John chaplain 603983 603983 Southwelle, John, of Little Walsyngham, chaplain 0
5126768 2394307 2394307 plaintiff Brigge Margaret (legal representative) 603983 603983 Brigge, Margaret, of Little Walsyngham, widow, executors of 0
5126771 2394307 2394307 defendant Spycer Nicholas husbandman 603983 603983 Spycer, Nicholas, of Little Walsyngham, husbandman 0
5131979 2395838 2395838 defendant Pollard John   603983 603983 Pollard, John, of Little Walsyngham, shoe maker 0
5134885 2396706 2396706 defendant Proubert James yeoman 603983 603983 Proubert, James, of Little Walsyngham, yeoman 2
5137525 2397488 2397488 defendant Myot Robert yeoman 603983 603983 Myot, Robert, of Little Walsyngham, yeoman 2
5139086 2397923 2397923 defendant Massy Walter husbandman 603983 603983 Massy, Walter, of Little Walsyngham, husbandman 0
5139087 2397923 2397923 defendant Doraunt John yeoman 603983 603983 Doraunt, John, of Little Walsyngham, yeoman 1
5140241 2398246 2398246 defendant Massy Walter husbandman 603983 603983 Massy, Walter, of Little Walsyngham, husbandman 0
5152542 2401881 2401881 defendant Agges William mercer 603983 603983 Agges, William, of Little Walsyngham, mercer 0
5154882 2402588 2402588 plaintiff Lovell Thomas   603983 603983 Lovell, Thomas, of Little Walsyngham 0
5154926 2402599 2402599 defendant Proubert James yeoman 603983 603983 Proubert, James, of Little Walsyngham, yeoman 0
5158175 2403511 2403511 defendant Myot Robert yeoman 603983 603983 Myot, Robert, of Little Walsyngham, yeoman 0
5159953 2404009 2404009 defendant Massy Walter yeoman 603983 603983 Massy, Walter, of Little Walsyngham, yeoman 0
5159954 2404009 2404009 defendant Doraunt John yeoman 603983 603983 Doraunt, John, of Little Walsyngham, yeoman 1
5159956 2404010 2404010 defendant Massy Walter yeoman 603983 603983 Massy, Walter, of Little Walsyngham, yeoman 0
5159957 2404010 2404010 defendant Doraunt John yeoman 603983 603983 Doraunt, John, of Little Walsyngham, yeoman 1
5159958 2404010 2404010 defendant Petyte John yeoman 603983 603983 Petyte, John, of Little Walsyngham, yeoman 2
5161349 2404414 2404414 defendant Massy Walter yeoman 603983 603983 Massy, Walter, of Little Walsyngham, yeoman 0
5170115 2406989 2406989 defendant Agges William mercer 603983 603983 Agges, William, of Little Walsyngham, mercer 0
5171588 2407410 2407410 defendant Lexham Humphrey mercer 603983 603983 Lexham, Humphrey, of Little Walsyngham, mercer 0
5175772 2408597 2408597 defendant Massy Walter yeoman 603983 603983 Massy, Walter, of Little Walsyngham, yeoman 0
5190106 2412851 2412851 defendant Lexham Humphrey meyrcer 603983 603983 Lexham, Humphrey, of Little Walsyngham, meyrcer 0
5190110 2412852 2412852 defendant Lexham Humphrey meyrcer 603983 603983 Lexham, Humphrey, of Little Walsyngham, meyrcer 0
5197311 2414952 2414952 defendant Massy Walter yeoman 603983 603983 Massy, Walter, of Little Walsyngham, yeoman 0
5268087 2435782 2435782 defendant Goddyng Godfrey husbandman 603983 603983 Goddyng, Godfrey, of Little Walsyngham, husbandman 0
5270231 2436394 2436394 defendant Osbern John gent 603983 603983 Osbern, John, of Little Walsyngham, gent 0
5271945 2436877 2436877 defendant Osbern John gent 603983 603983 Osbern, John, of Little Walsyngham, gent 0
5271946 2436877 2436877 defendant Denham Geoffrey mercer 603983 603983 Denham, Geoffrey, of Little Walsyngham, mercer 1
5274614 2437656 2437656 defendant Halle Idonea widow 603983 603983 Halle, Idonea, of Little Walsyngham, widow 2
5274628 2437659 2437659 defendant Palle William fishman 603983 603983 Palle, William, of Little Walsyngham, fishman 1
5297607 2444304 2444304 defendant Caudeler Nicholas yeoman 603983 603983 Caudeler, Nicholas, of Little Walsyngham, yeoman 1
5301118 2445291 2445291 defendant Wede or Wode Robert mercer 603983 603983 Wede or Wode, Robert, of Little Walsyngham, mercer 0
5301119 2445291 2445291 defendant Kentston Robert   603983 603983 Kentston, Robert, of Little Walsyngham, tallow chandler 1

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