names

155 rows where place_id = 586568

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589054 1864225 1864225 defendant Bate William laborer 586568 586568 Bate, William, of Rotherham, laborer 0
3589055 1864225 1864225 defendant Davy John yeoman 586568 586568 Davy, John, of Rotherham, yeoman 1
3599128 1867364 1867364 defendant Lylly Richard yeoman 586568 586568 Lylly, Richard, of Rotherham, yeoman 1
3646549 1909322 1909322 plaintiff Hardy William pewetrer 586568 586568 Hardy, William, of Rotherham, pewetrer 1
3646551 1909322 1909322 defendant Gurry Edward yeoman 586568 586568 Gurry, Edward, of Rotherham, yeoman 1
3646554 1909323 1909323 defendant Gurry William yeoman 586568 586568 Gurry, William, of Rotherham, yeoman 0
3646555 1909323 1909323 defendant Gurry Edward yeoman 586568 586568 Gurry, Edward, of Rotherham, yeoman 1
3653871 1911475 1911475 defendant Hertley Robert chapman 586568 586568 Hertley, Robert, of Rotherham, chapman 0
3662969 1914330 1914330 plaintiff Nikson Peter yeoman 586568 586568 Nikson, Peter, of Rotherham, yeoman 0
3695653 1924871 1924871 defendant Brodehurst George ironmonger 586568 586568 Brodehurst, George, of Rotherham, ironmonger 0
3729311 1935419 1935419 defendant Triket Thomas dyer 586568 586568 Triket, Thomas, of Rotherham, dyer 1
3735880 1937461 1937461 defendant Wilson Robert butcher 586568 586568 Wilson, Robert, of Rotherham, butcher 0
3739940 1938709 1938709 defendant Batteley Thomas innholder 586568 586568 Batteley, Thomas, of Rotherham, innholder 0
3743558 1939861 1939861 defendant Wodcok Thomas yeoman 586568 586568 Wodcok, Thomas, of Rotherham, yeoman 0
3749248 1941692 1941692 defendant Okes William yeoman 586568 586568 Okes, William, of Rotherham, yeoman 0
3764097 1946417 1946417 defendant Okes William yeoman 586568 586568 Okes, William, of Rotherham, yeoman 0
3764299 1946495 1946495 defendant Cutt John nailer 586568 586568 Cutt, John, of Rotherham, nailer 0
3793576 1955853 1955853 plaintiff Brodeherst Nicholas   586568 586568 Brodeherst, Nicholas, of Rotherham 0
3801304 1958334 1958334 defendant Lille Robert yeoman 586568 586568 Lille, Robert, of Rotherham, yeoman 0
3802121 1958558 1958558 plaintiff Oke Richard   586568 586568 Oke, Richard, of Rotherham 0
3805286 1959600 1959600 plaintiff Swyfte Robert merchant 586568 586568 Swyfte, Robert, of Rotherham, merchant 0
3838019 1969802 1969802 plaintiff Swyft Robert   586568 586568 Swyft, Robert, of Rotherham 0
3838035 1969808 1969808 plaintiff Swyfte Robert merchant 586568 586568 Swyfte, Robert, of Rotherham, merchant 0
3852449 1974373 1974373 defendant Wilson Robert butcher 586568 586568 Wilson, Robert, of Rotherham, butcher 0
3853468 1974710 1974710 defendant Bekett Robert butcher 586568 586568 Bekett, Robert, of Rotherham, butcher 1
3853469 1974710 1974710 defendant Wylson Robert butcher 586568 586568 Wylson, Robert, of Rotherham, butcher 2
3853470 1974710 1974710 defendant Sheperd Thomas butcher 586568 586568 Sheperd, Thomas, of Rotherham, butcher 3
3853471 1974710 1974710 defendant Coke John butcher 586568 586568 Coke, John, of Rotherham, butcher 4
3853643 1974768 1974768 plaintiff Raulynson Richard mercer 586568 586568 Raulynson, Richard, of Rotherham, mercer 1
3854114 1974924 1974924 plaintiff Swyfte Robert merchant 586568 586568 Swyfte, Robert, of Rotherham, merchant 0
3854116 1974925 1974925 plaintiff Swyfte Robert merchant 586568 586568 Swyfte, Robert, of Rotherham, merchant 0
3856310 1975592 1975592 defendant Wilson Robert butcher 586568 586568 Wilson, Robert, of Rotherham, butcher 0
3909606 1993518 1993518 defendant Walker Stephen smith 586568 586568 Walker, Stephen, of Rotherham, smith 3
3910200 1993726 1993726 plaintiff Swyfte Robert merchant 586568 586568 Swyfte, Robert, of Rotherham, merchant 0
3939958 2003664 2003664 defendant Snell Thomas   586568 586568 Snell, Thomas, of Rotherham, steel master 1
3942859 2004616 2004616 defendant Watson William smith 586568 586568 Watson, William, of Rotherham, smith 0
3959804 2010522 2010522 defendant Cutler James dagger maker 586568 586568 Cutler, James, of Rotherham, dagger maker 0
3959806 2010522 2010522 defendant Robynson alias Dolphyn Giles laborer 586568 586568 Robynson alias Dolphyn, Giles, of Rotherham, laborer 2
3984262 2019137 2019137 plaintiff Swyfte William esq 586568 586568 Swyfte, William, of Rotherham, esq 0
3990236 2021262 2021262 defendant Elyson Thomas butcher 586568 586568 Elyson, Thomas, of Rotherham, butcher 1
4004309 2026322 2026322 defendant Wombwell Ralph gent 586568 586568 Wombwell, Ralph, of Rotherham, gent 0
4014076 2029765 2029765 defendant Cosyn Alexander tanner 586568 586568 Cosyn, Alexander, of Rotherham, tanner 0
4016839 2030720 2030720 plaintiff Swifte William (legal representative) 586568 586568 Swifte, William, of Rotherham, esq, executor of 0
4048044 2041742 2041742 plaintiff Swifte William (legal representative) 586568 586568 Swifte, William, of Rotherham, esq, executor of 0
4057591 2045095 2045095 plaintiff Byllame Christopher draper 586568 586568 Byllame, Christopher, of Rotherham, draper 0
4060066 2045998 2045998 defendant Hyllyngworthe Richard yeoman 586568 586568 Hyllyngworthe, Richard, of Rotherham, yeoman 0
4064164 2047456 2047456 defendant Oke Jasper innkeeper 586568 586568 Oke, Jasper, of Rotherham, innkeeper 8
4064638 2047636 2047636 plaintiff Hadfeilde Nicholas yeoman 586568 586568 Hadfeilde, Nicholas, of Rotherham, yeoman 0
4064639 2047636 2047636 defendant Oke Jasper innholder 586568 586568 Oke, Jasper, of Rotherham, innholder 0
4081096 2053552 2053552 plaintiff West William   586568 586568 West, William, of Rotherham, gent, attorney of the bench, of Inner Temple, London 0
4081098 2053552 2053552 defendant Grexon Thomas gent 586568 586568 Grexon, Thomas, of Rotherham, gent 1
4081153 2053570 2053570 defendant Radforth Henry joiner 586568 586568 Radforth, Henry, of Rotherham, joiner 0
4085649 2055139 2055139 defendant Grexon Thomas gent 586568 586568 Grexon, Thomas, of Rotherham, gent 0
4087839 2055943 2055943 defendant Gregson Thomas gent 586568 586568 Gregson, Thomas, of Rotherham, gent 0
4099779 2060242 2060242 defendant Oke Jasper innholder 586568 586568 Oke, Jasper, of Rotherham, innholder 1
4106886 2062754 2062754 defendant Tayler Richard yeoman 586568 586568 Tayler, Richard, of Rotherham, yeoman 4
4109013 2063480 2063480 defendant Leake Richard cordwainer 586568 586568 Leake, Richard, of Rotherham, cordwainer 0
4109014 2063480 2063480 defendant Fysher William cordwainer 586568 586568 Fysher, William, of Rotherham, cordwainer 1
4110965 2064171 2064171 defendant Leake Richard cordwainer 586568 586568 Leake, Richard, of Rotherham, cordwainer 1
4110966 2064171 2064171 defendant Oke Jasper innholder 586568 586568 Oke, Jasper, of Rotherham, innholder 2
4112166 2064610 2064610 defendant Clayton William yeoman 586568 586568 Clayton, William, of Rotherham, yeoman 0
4112167 2064610 2064610 defendant Walker Christopher tailor 586568 586568 Walker, Christopher, of Rotherham, tailor 1
4112168 2064610 2064610 defendant Gray John tailor 586568 586568 Gray, John, of Rotherham, tailor 2
4112169 2064610 2064610 defendant Swaythe Elizabeth widow 586568 586568 Swaythe, Elizabeth, of Rotherham, widow 3
4112179 2064612 2064612 defendant Goodyson John tailor 586568 586568 Goodyson, John, of Rotherham, tailor 3
4122280 2068275 2068275 defendant Blande Henry joiner 586568 586568 Blande, Henry, of Rotherham, joiner 0
4123665 2068766 2068766 defendant Kendall Robert cordwainer 586568 586568 Kendall, Robert, of Rotherham, cordwainer 0
4124326 2068992 2068992 defendant Lyster alias Dolphyn Thomas cutler 586568 586568 Lyster alias Dolphyn, Thomas, of Rotherham, cutler 1
4128488 2070479 2070479 defendant Antrum Edward   586568 586568 Antrum, Edward, of Rotherham, parchment maker 0
4130374 2071176 2071176 defendant Cutler John sheather 586568 586568 Cutler, John, of Rotherham, sheather 0
4134070 2072513 2072513 defendant Bylclyffe Robert innholder 586568 586568 Bylclyffe, Robert, of Rotherham, innholder 0
4134071 2072513 2072513 defendant Holmes Richard   586568 586568 Holmes, Richard, of Rotherham, linen weaver 1
4138723 2074217 2074217 defendant Goodladde Francis joiner 586568 586568 Goodladde, Francis, of Rotherham, joiner 0
4138724 2074217 2074217 defendant Yaram John joiner 586568 586568 Yaram, John, of Rotherham, joiner 1
4140361 2074795 2074795 defendant Blake Thomas laborer 586568 586568 Blake, Thomas, of Rotherham, laborer 3
4141336 2075130 2075130 defendant Marshall Richard shoemaker 586568 586568 Marshall, Richard, of Rotherham, shoemaker 0
4141337 2075130 2075130 defendant Marshall George dyer 586568 586568 Marshall, George, of Rotherham, dyer 1
4141338 2075130 2075130 defendant Senyor Peter laborer 586568 586568 Senyor, Peter, of Rotherham, laborer 2
4168941 2084631 2084631 defendant Wollen Ralph glover 586568 586568 Wollen, Ralph, of Rotherham, glover 0
4168942 2084631 2084631 defendant Steyd John glover 586568 586568 Steyd, John, of Rotherham, glover 1
4176887 2087386 2087386 defendant Kendall Robert shoemaker 586568 586568 Kendall, Robert, of Rotherham, shoemaker 0
4179772 2088399 2088399 defendant Pytt Henry   586568 586568 Pytt, Henry, of Rotherham, freemason 1
4181517 2089015 2089015 defendant Goodladd Francis joiner 586568 586568 Goodladd, Francis, of Rotherham, joiner 0
4181518 2089015 2089015 defendant Kendall Robert shoemaker 586568 586568 Kendall, Robert, of Rotherham, shoemaker 1
4181519 2089015 2089015 defendant Lister Thomas cutler 586568 586568 Lister, Thomas, of Rotherham, cutler 2
4186760 2090859 2090859 plaintiff Swyft William (legal representative) 586568 586568 Swyft, William, of Rotherham, esq, executor of 0
4186764 2090860 2090860 plaintiff Swyft William (legal representative) 586568 586568 Swyft, William, of Rotherham, esq, executor of 0
4187691 2091197 2091197 defendant Cutlove William chapman 586568 586568 Cutlove, William, of Rotherham, chapman 1
4210531 2099239 2099239 defendant Goodladd Francis joiner 586568 586568 Goodladd, Francis, of Rotherham, joiner 0
4215104 2100784 2100784 defendant Benson Thomas cordwainer 586568 586568 Benson, Thomas, of Rotherham, cordwainer 2
4215518 2100923 2100923 defendant Carleton Thomas tailor 586568 586568 Carleton, Thomas, of Rotherham, tailor 0
4224266 2103974 2103974 defendant Warde Thomas draper 586568 586568 Warde, Thomas, of Rotherham, draper 0
4224272 2103975 2103975 defendant Warde Thomas draper 586568 586568 Warde, Thomas, of Rotherham, draper 0
4225111 2104252 2104252 defendant Bankes Thomas (legal representative) 586568 586568 Bankes, Thomas, of Rotherham, tanner, executors of 0
4225112 2104252 2104252 defendant Warde Edward   586568 586568 (Warde, Edward, of Rotherham, shear smith 1
4238688 2109149 2109149 defendant Perker Robert gent 586568 586568 Perker, Robert, of Rotherham, or of Maddow Hall, Yorks, gent 0
4251119 2113353 2113353 defendant Dickenson Thomas pewterer 586568 586568 Dickenson, Thomas, of Rotherham, pewterer 0
4266433 2118420 2118420 defendant Jopson Thomas clerk 586568 586568 Jopson, Thomas, of Rotherham, or of Barenburghe, clerk 0
4495036 2199139 2199139 plaintiff Bugge Robert   586568 586568 Bugge, Robert, of Rotherham 0
4643538 2244211 2244211 defendant Bakester John draper 586568 586568 Bakester, John, of Rotherham, draper 0

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