names

60 rows where place_id = 601851

✎ 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
3647282 1909535 1909535 defendant Percy Stephen husbandman 601851 601851 Percy, Stephen, of Snetysham, husbandman 0
3647283 1909535 1909535 defendant Awdeley John husbandman 601851 601851 Awdeley, John, of Snetysham, husbandman 1
3689566 1922893 1922893 defendant Russell Henry gent 601851 601851 Russell, Henry, of Snetysham, gent 0
3690558 1923213 1923213 plaintiff Graunt Thomas yeoman 601851 601851 Graunt, Thomas, of Snetysham, yeoman 0
3740139 1938775 1938775 defendant Sander John husbandman 601851 601851 Sander, John, of Snetysham, husbandman 2
3777629 1950753 1950753 defendant Ralff Thomas (legal representative) 601851 601851 Ralff, Thomas, of Snetysham, yeoman, executor of 1
3777630 1950753 1950753 defendant Smyth Robert yeoman 601851 601851 Smyth, Robert, of Snetysham, yeoman 2
3867904 1979497 1979497 defendant Reve Thomas husbandman 601851 601851 (Reve, Thomas, of Snetysham, husbandman 1
3873506 1981354 1981354 defendant Gawnte Robert husbandman 601851 601851 Gawnte, Robert, of Snetysham, husbandman 0
3927677 1999593 1999593 defendant Cook William husbandman 601851 601851 Cook, William, of Snetysham, husbandman 1
3944497 2005176 2005176 defendant Buntyng Robert gent 601851 601851 Buntyng, Robert, of Snetysham, gent 2
4054885 2044138 2044138 defendant Bradd James, junior yeoman 601851 601851 Bradd, James, junior, of Snetysham, yeoman 0
4262641 2117174 2117174 defendant Cremer alias Skryme John yeoman 601851 601851 Cremer alias Skryme, John, of Snetysham, yeoman 2
4505767 2202313 2202313 defendant Roo John   601851 601851 Roo, John, of Snetysham 4
4808678 2298880 2298880 defendant Wesenham John yeoman 601851 601851 Wesenham, John, of Snetysham, yeoman 3
4838850 2308081 2308081 defendant Shankewyn John butcher 601851 601851 Shankewyn, John, of Snetysham, butcher 1
4876904 2319745 2319745 defendant Wylot Roger husbandman 601851 601851 Wylot, Roger, of Snetysham, husbandman 3
4895378 2325215 2325215 defendant Hakke Robert husbandman 601851 601851 Hakke, Robert, of Snetysham, husbandman 0
4902442 2327377 2327377 defendant Couper Roger husbandman 601851 601851 Couper, Roger, of Snetysham, husbandman 0
4937853 2338220 2338220 defendant Shenkewyn John butcher 601851 601851 Shenkewyn, John, of Snetysham, butcher 0
4997639 2356148 2356148 defendant Wesenham Alice   601851 601851 Wesenham, Alice, of Snetysham, widow, relict of John Wesenham, of Snetysham 0
5040460 2368752 2368752 defendant Hakke Robert husbandman 601851 601851 Hakke, Robert, of Snetysham, husbandman 0
5040461 2368752 2368752 defendant Sutton Richard tailor 601851 601851 Sutton, Richard, of Snetysham, tailor 1
5042120 2369249 2369249 defendant Hakke Robert husbandman 601851 601851 Hakke, Robert, of Snetysham, husbandman 0
5046972 2370719 2370719 plaintiff Newegate William   601851 601851 Newegate, William, of Snetysham 0
5047033 2370736 2370736 defendant Nugate William yeoman 601851 601851 Nugate, William, of Snetysham, yeoman 0
5048588 2371220 2371220 plaintiff Roo Joan   601851 601851 Roo, Joan, of Snetysham 0
5048589 2371220 2371220 defendant Smyth Thomas chapman 601851 601851 Smyth, Thomas, of Snetysham, chapman 0
5059566 2374430 2374430 defendant Neuton Thomas husbandman 601851 601851 Neuton, Thomas, of Snetysham, husbandman 1
5090062 2383464 2383464 defendant Pygge Geoffrey chapman 601851 601851 Pygge, Geoffrey, of Snetysham, chapman 2
5188015 2412201 2412201 defendant Lovell Robert weaver 601851 601851 Lovell, Robert, of Snetysham, weaver 0
5261995 2433863 2433863 defendant Mannyng Thomas yeoman 601851 601851 Mannyng, Thomas, of Snetysham, yeoman 0
5261996 2433863 2433863 defendant Reve John yeoman 601851 601851 Reve, John, of Snetysham, yeoman 1
5281578 2439678 2439678 defendant Mannyng Thomas yeoman 601851 601851 Mannyng, Thomas, of Snetysham, yeoman 0
5281579 2439678 2439678 defendant Clare Thomas husbandman 601851 601851 Clare, Thomas, of Snetysham, husbandman 1
5283823 2440304 2440304 defendant Saunderson Alexander yeoman 601851 601851 Saunderson, Alexander, of Snetysham, yeoman 1
5283824 2440304 2440304 defendant Clerk William yeoman 601851 601851 Clerk, William, of Snetysham, yeoman 2
5283830 2440306 2440306 defendant Saunderson Alexander husbandman 601851 601851 Saunderson, Alexander, of Snetysham, husbandman 0
5291859 2442624 2442624 defendant Clerk Edmund husbandman 601851 601851 Clerk, Edmund, of Snetysham, husbandman 1
5295135 2443567 2443567 defendant Mannyng Thomas yeoman 601851 601851 Mannyng, Thomas, of Snetysham, yeoman 2
5298399 2444506 2444506 defendant Penale Robert husbandman 601851 601851 Penale, Robert, of Snetysham, husbandman 0
5298401 2444507 2444507 defendant Penale Robert husbandman 601851 601851 Penale, Robert, of Snetysham, husbandman 0
5307443 2447236 2447236 defendant Warham Thomas yeoman 601851 601851 Warham, Thomas, of Snetysham, yeoman 1
5313113 2448955 2448955 defendant Wraske Roger   601851 601851 Wraske, Roger, of Snetysham, shepherd 3
5314887 2449501 2449501 defendant Saunderson Alexander husbandman 601851 601851 Saunderson, Alexander, of Snetysham, husbandman 0
5361595 2463648 2463648 defendant Lowe John yeoman 601851 601851 Lowe, John, of Snetysham, yeoman 0
5361603 2463652 2463652 defendant Lowe John yeoman 601851 601851 Lowe, John, of Snetysham, yeoman 0
5406229 2476855 2476855 defendant Lowe John yeoman 601851 601851 Lowe, John, of Snetysham, yeoman 4
5406258 2476861 2476861 defendant Dowesyng Nicholas husbandman 601851 601851 Dowesyng, Nicholas, of Snetysham, husbandman 1
5419296 2480696 2480696 defendant Dowesyng Nicholas husbandman 601851 601851 Dowesyng, Nicholas, of Snetysham, husbandman 1
5466496 2494916 2494916 defendant Dowesyng Nicholas gent 601851 601851 Dowesyng, Nicholas, of Snetysham, gent 3
5518710 2510687 2510687 defendant Audele or Andele John yeoman 601851 601851 Audele or Andele, John, of Snetysham, yeoman 0
5520324 2511174 2511174 defendant Walwyk Margery widow 601851 601851 Walwyk, Margery, of Snetysham, widow 1
5530211 2513954 2513954 defendant Audeley John husbandman 601851 601851 Audeley, John, of Snetysham, husbandman 1
5531098 2514244 2514244 defendant Percey Richard husbandman 601851 601851 Percey, Richard, of Snetysham, husbandman 0
5556021 2521756 2521756 defendant Gorydney Robert husbandman 601851 601851 Gorydney, Robert, of Snetysham, husbandman 0
5556022 2521756 2521756 defendant Ewe William husbandman 601851 601851 Ewe, William, of Snetysham, husbandman 1
5565796 2524592 2524592 defendant Howson Robert yeoman 601851 601851 Howson, Robert, of Snetysham, yeoman 0
5567818 2525166 2525166 defendant Bacon Thomas husbandman 601851 601851 Bacon, Thomas, of Snetysham, husbandman 0
5608128 2537448 2537448 defendant Rolff Thomas yeoman 601851 601851 Rolff, Thomas, of Snetysham, yeoman 1

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