names

97 rows where place_id = 599116

✎ 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
3635358 1905853 1905853 defendant Hartley Robert mercer 599116 599116 Hartley, Robert, of Rotheram, mercer 0
3636632 1906249 1906249 defendant Clerk Thomas clerk 599116 599116 Clerk, Thomas, of Rotheram, clerk 0
3638434 1906842 1906842 defendant Paydley Roger merchant 599116 599116 Paydley, Roger, of Rotheram, merchant 0
3658247 1912834 1912834 defendant Cutler William yeoman 599116 599116 Cutler, William, of Rotheram, yeoman 0
3662970 1914330 1914330 defendant Milnes John laborer 599116 599116 Milnes, John, of Rotheram, laborer 0
3664194 1914750 1914750 defendant Nikson Peter   599116 599116 Nikson, Peter, of Rotheram, "shether" or a bladesmith 0
3682305 1920565 1920565 plaintiff Swift Robert   599116 599116 Swift, Robert, of Rotheram 0
3694563 1924504 1924504 plaintiff Oke William   599116 599116 Oke, William, of Rotheram 0
3694565 1924504 1924504 defendant Chambur John yeoman 599116 599116 (Chambur, John, of Rotheram, yeoman 1
3694717 1924552 1924552 defendant Wilson Robert butcher 599116 599116 Wilson, Robert, of Rotheram, butcher 0
3701521 1926726 1926726 plaintiff Brodhirst Nicholas (legal representative) 599116 599116 Brodhirst, Nicholas, of Rotheram, hardwareman, executors of 0
3708667 1929011 1929011 plaintiff Palmer George (legal representative) 599116 599116 Palmer, George, of Rotheram, executors of 0
3708670 1929011 1929011 defendant Wilson Robert butcher 599116 599116 Wilson, Robert, of Rotheram, butcher 0
3709536 1929290 1929290 defendant Broderest George ironmonger 599116 599116 Broderest, George, of Rotheram, ironmonger 0
3712352 1930181 1930181 defendant Padley Roger chapman 599116 599116 Padley, Roger, of Rotheram, chapman 0
3712720 1930294 1930294 defendant Cresewell Henry innholder 599116 599116 Cresewell, Henry, of Rotheram, innholder 0
3713313 1930475 1930475 defendant Birkynshawe John pewterer 599116 599116 Birkynshawe, John, of Rotheram, pewterer 0
3730618 1935810 1935810 defendant Haryngton William butcher 599116 599116 Haryngton, William, of Rotheram, butcher 0
3782032 1952130 1952130 defendant Okes William yeoman 599116 599116 Okes, William, of Rotheram, yeoman 0
3790155 1954739 1954739 defendant Gyll Thomas dyer 599116 599116 Gyll, Thomas, of Rotheram, dyer 0
3800224 1957990 1957990 defendant Yole Thomas cordwainer 599116 599116 Yole, Thomas, of Rotheram, cordwainer 3
3805274 1959595 1959595 plaintiff Swyft Robert merchant 599116 599116 Swyft, Robert, of Rotheram, merchant 0
3813714 1962201 1962201 defendant Yole John carpenter 599116 599116 Yole, John, of Rotheram, carpenter 2
3834826 1968831 1968831 defendant Oke Ellen widow 599116 599116 Oke, Ellen, of Rotheram, widow 0
3838025 1969805 1969805 plaintiff Swyfte Robert   599116 599116 Swyfte, Robert, of Rotheram 0
3838027 1969806 1969806 plaintiff Swyfte Robert merchant 599116 599116 Swyfte, Robert, of Rotheram, merchant 0
3838032 1969807 1969807 plaintiff Swyfte Robert merchant 599116 599116 Swyfte, Robert, of Rotheram, merchant 0
3854108 1974921 1974921 plaintiff Swyfte Robert   599116 599116 Swyfte, Robert, of Rotheram 0
3854110 1974922 1974922 plaintiff Swyfte Robert merchant 599116 599116 Swyfte, Robert, of Rotheram, merchant 0
3854112 1974923 1974923 plaintiff Swyfte Robert merchant 599116 599116 Swyfte, Robert, of Rotheram, merchant 0
3901681 1990788 1990788 defendant Sylvester Richard shoemaker 599116 599116 Sylvester, Richard, of Rotheram, shoemaker 1
3925616 1998879 1998879 defendant Yowle John yeoman 599116 599116 Yowle, John, of Rotheram, yeoman 3
3925617 1998879 1998879 defendant Boswell Thomas yeoman 599116 599116 Boswell, Thomas,of Rotheram, yeoman 4
3945599 2005537 2005537 defendant Dawson William yeoman 599116 599116 Dawson, William, of Rotheram, yeoman 0
3945600 2005537 2005537 defendant Dawson John yeoman 599116 599116 Dawson, John, of Rotheram, yeoman 1
3948660 2006593 2006593 plaintiff Dawson Thomas (legal representative) 599116 599116 Dawson, Thomas, of Rotheram, executrix of 0
3950541 2007270 2007270 defendant Dawson William yeoman 599116 599116 Dawson, William, of Rotheram, yeoman 0
3958229 2009951 2009951 defendant Slacke Richard husbandman 599116 599116 Slacke, Richard, of Rotheram, husbandman 1
3962941 2011636 2011636 defendant Rysheforde Christopher hardwareman 599116 599116 Rysheforde, Christopher, of Rotheram, hardwareman 1
3962942 2011636 2011636 defendant Wilson Robert butcher 599116 599116 Wilson, Robert, of Rotheram, butcher 2
3962943 2011636 2011636 defendant Bate Robert butcher 599116 599116 Bate, Robert, of Rotheram, butcher 3
3973564 2015324 2015324 defendant Lethely Roger yeoman 599116 599116 Lethely, Roger, of Rotheram, yeoman 0
4012793 2029298 2029298 defendant Wombwell Ralph yeoman 599116 599116 Wombwell, Ralph, of Rotheram, yeoman 1
4012794 2029298 2029298 defendant Oke Jasper innholder 599116 599116 Oke, Jasper, of Rotheram, innholder 2
4020171 2031936 2031936 defendant Clayton William yeoman 599116 599116 Clayton, William, of Rotheram, yeoman 0
4079195 2052864 2052864 plaintiff Towneley Charles gent 599116 599116 Towneley, Charles, of Rotheram, gent 0
4163197 2082660 2082660 plaintiff Swyfte William (legal representative) 599116 599116 Swyfte, William, of Rotheram, esq, executor of 0
4179714 2088378 2088378 defendant Lister Thomas cutler 599116 599116 Lister, Thomas, of Rotheram, cutler 0
4179715 2088378 2088378 defendant Holmes John shoemaker 599116 599116 Holmes, John, of Rotheram, shoemaker 1
4212422 2099893 2099893 defendant Blythe William   599116 599116 Blythe, William, of Rotheram, Yorks chapman 0
4218501 2101969 2101969 defendant Dickenson Thomas pewterer 599116 599116 Dickenson, Thomas, of Rotheram, pewterer 0
4218503 2101969 2101969 defendant Antrum Edward   599116 599116 Antrum, Edward, of Rotheram, parchment maker 2
4218504 2101969 2101969 defendant Okes Jasper innholder 599116 599116 Okes, Jasper, of Rotheram, innholder 3
4222004 2103188 2103188 defendant Parker Robert gent 599116 599116 Parker, Robert, of Rotheram, or of Mddowe Hall, Yorks, gent 2
4238684 2109147 2109147 defendant Parker Robert gent 599116 599116 Parker, Robert, of Rotheram, or of Maddowe Hall, Yorks, gent 0
4260159 2116362 2116362 defendant Pennell William yeoman 599116 599116 Pennell, William, of Rotheram, yeoman 0
4260160 2116362 2116362 defendant Pennell Hugh yeoman 599116 599116 Pennell, Hugh, of Rotheram, yeoman 1
4271562 2120070 2120070 defendant Pennell William yeoman 599116 599116 Pennell, William, of Rotheram, yeoman 0
4271563 2120070 2120070 defendant Pennell Hugh yeoman 599116 599116 Pennell, Hugh, of Rotheram, yeoman 1
4300899 2130421 2130421 defendant Bridge John yeoman 599116 599116 Bridge, John, of Rotheram, yeoman 0
4308175 2133007 2133007 defendant Inman Thomas mercer 599116 599116 Inman, Thomas, of Rotheram, mercer 0
4311801 2134264 2134264 defendant Wilkinson Lawrwnce cutler 599116 599116 Wilkinson, Lawrwnce, of Rotheram, cutler 2
4311898 2134298 2134298 defendant Bridge John yeoman 599116 599116 Bridge, John, of Rotheram, yeoman 0
4321327 2137550 2137550 defendant Gyles John cutler 599116 599116 Gyles, John, of Rotheram, cutler 1
4322683 2137999 2137999 defendant Benson Edward husbandman 599116 599116 Benson, Edward, of Rotheram, husbandman 1
4322684 2137999 2137999 defendant Hewes Robert husbandman 599116 599116 Hewes, Robert, of Rotheram, husbandman 2
4386254 2160080 2160080 defendant Benson Barnard saddler 599116 599116 Benson, Barnard, of Rotheram, saddler 0
4386257 2160080 2160080 defendant Wastnes Thomas   599116 599116 Wastnes, Thomas, of Rotheram 3
4388302 2160717 2160717 defendant Jopson Thomas clerk 599116 599116 Jopson, Thomas, of Rotheram, clerk 0
4397522 2163751 2163751 defendant Hallidey Michael yeoman 599116 599116 Hallidey, Michael, of Rotheram, yeoman 0
4403251 2165659 2165659 defendant Shawe Robert yeoman 599116 599116 Shawe, Robert, of Rotheram, yeoman 1
4411024 2168273 2168273 defendant Jeson Thomas clerk 599116 599116 Jeson, Thomas, of Rotheram, clerk 2
4827080 2304514 2304514 defendant Hill Robert butcher 599116 599116 Hill, Robert, of Rotheram, butcher 0
4980625 2351143 2351143 defendant Russell Thomas yeoman 599116 599116 Russell, Thomas, of Rotheram, yeoman 0
5127396 2394495 2394495 defendant Wilcok Richard yeoman 599116 599116 Wilcok, Richard, of Rotheram, yeoman 0
5371526 2466680 2466680 defendant Cutler alias Dogeson Robert   599116 599116 Cutler alias Dogeson, Robert, of Rotheram, blade smith 0
5383800 2470451 2470451 defendant Sadley Richard mercer 599116 599116 Sadley, Richard, of Rotheram, mercer 1
5390128 2472237 2472237 defendant Creswell Joan widow 599116 599116 Creswell, Joan, of Rotheram, widow 0
5395634 2473832 2473832 defendant Padley Richard mercer 599116 599116 Padley, Richard, of Rotheram, mercer 1
5408935 2477633 2477633 defendant Padley Richard mercer 599116 599116 Padley, Richard, of Rotheram, mercer 1
5422267 2481609 2481609 defendant Padley Richard mercer 599116 599116 Padley, Richard, of Rotheram, mercer 1
5489999 2501896 2501896 defendant Wilson Thomas cordwainer 599116 599116 Wilson, Thomas, of Rotheram, cordwainer 4
5493219 2502881 2502881 defendant Dogeson Richard cutler 599116 599116 Dogeson, Richard, of Rotheram, cutler 0
5493220 2502881 2502881 defendant Mellour Edmund cutler 599116 599116 Mellour, Edmund, of Rotheram, cutler 1
5499409 2504763 2504763 defendant Padley Richard chapman 599116 599116 Padley, Richard, of Rotheram, chapman 3
5499414 2504764 2504764 defendant Padley Richard chapman 599116 599116 Padley, Richard, of Rotheram, chapman 3
5516407 2509966 2509966 defendant Yorkshire John butcher 599116 599116 Yorkshire, John, of Rotheram, butcher 1
5516408 2509966 2509966 defendant Wade John laborer 599116 599116 Wade, John, of Rotheram, laborer 2
5516409 2509966 2509966 defendant Odeson John shoemaker 599116 599116 Odeson, John, of Rotheram, shoemaker 3
5527372 2513139 2513139 defendant Wilkokys Robert yeoman 599116 599116 Wilkokys, Robert, of Rotheram, yeoman 0
5541945 2517602 2517602 defendant Wilcokkys Isabel widow 599116 599116 Wilcokkys, Isabel, of Rotheram, widow 0
5541947 2517603 2517603 defendant Wylcokkys Isabel widow 599116 599116 Wylcokkys, Isabel, of Rotheram, widow 0
5561836 2523449 2523449 defendant Elryngton William yeoman 599116 599116 Elryngton, William, of Rotheram, yeoman 0
5591104 2532197 2532197 plaintiff Strafforth John tanner 599116 599116 Strafforth, John, of Rotheram, tanner 0
5606463 2536909 2536909 defendant Carnbull Henry clerk 599116 599116 Carnbull, Henry, of Rotheram, clerk 2
5607696 2537306 2537306 defendant Bate Robert butcher 599116 599116 Bate, Robert, of Rotheram, butcher 3
5607697 2537306 2537306 defendant Haryngton John butcher 599116 599116 Haryngton, John, of Rotheram, butcher 4

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