names

161 rows where place_id = 586573

✎ 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
3589075 1864230 1864230 plaintiff Brokehouse Edmund grasier 586573 586573 Brokehouse, Edmund, of Barnesley, grasier 0
3589084 1864233 1864233 plaintiff Brokhous Edmund grocer 586573 586573 Brokhous, Edmund, of Barnesley, grocer 0
3589086 1864234 1864234 plaintiff Brokhous Edmund grocer 586573 586573 Brokhous, Edmund, of Barnesley, grocer 0
3633318 1905235 1905235 defendant Roggers Thomas yeoman 586573 586573 Roggers, Thomas, of Barnesley, yeoman 0
3669861 1916518 1916518 defendant Wode William laborer 586573 586573 Wode, William, of Barnesley, laborer 0
3669862 1916518 1916518 defendant Robert Thomas husbandman 586573 586573 Robert, Thomas, of Barnesley, husbandman 1
3669863 1916518 1916518 defendant Key John laborer 586573 586573 Key, John, of Barnesley, laborer 2
3685971 1921770 1921770 defendant Wolfe William draper 586573 586573 Wolfe, William, of Barnesley, draper 0
3699294 1925994 1925994 defendant Byrkynshawe William glover 586573 586573 Byrkynshawe, William, of Barnesley, glover 0
3730257 1935691 1935691 defendant Halywell Thomas yeoman 586573 586573 Halywell, Thomas, of Barnesley, yeoman 2
3759077 1944824 1944824 defendant Swynden Robert baker 586573 586573 Swynden, Robert, of Barnesley, baker 1
3810592 1961210 1961210 defendant Blanke William butcher 586573 586573 Blanke, William, of Barnesley, butcher 1
3817367 1963342 1963342 defendant Molyner Alexander innholder 586573 586573 Molyner, Alexander, of Barnesley, innholder 1
3825436 1965808 1965808 defendant Nicalls Richard yeoman 586573 586573 Nicalls, Richard, of Barnesley, yeoman 0
3833847 1968519 1968519 defendant Hudeswell William smith 586573 586573 Hudeswell, William, of Barnesley, smith 1
3854115 1974924 1974924 defendant Carre William smith 586573 586573 Carre, William, of Barnesley, smith 0
3854117 1974925 1974925 defendant Elys Thomas yeoman 586573 586573 Elys, Thomas, of Barnesley, yeoman 0
3976495 2016355 2016355 defendant Senyor George butcher 586573 586573 Senyor, George, of Barnesley, butcher 0
4000540 2024963 2024963 defendant Darbyshere Edward tailor 586573 586573 Darbyshere, Edward, of Barnesley, tailor 0
4006478 2027095 2027095 plaintiff Lewes Alexander roper 586573 586573 Lewes, Alexander, of Barnesley, roper 0
4006479 2027095 2027095 defendant Senyor George butcher 586573 586573 Senyor, George, of Barnesley, butcher 0
4008747 2027888 2027888 defendant Rogers Christopher yeoman 586573 586573 Rogers, Christopher, of Barnesley, yeoman 0
4022485 2032765 2032765 defendant Rogers Christopher yeoman 586573 586573 Rogers, Christopher, of Barnesley, yeoman 0
4024630 2033488 2033488 defendant Woodworth William yeoman 586573 586573 Woodworth, William, of Barnesley, yeoman 2
4024631 2033488 2033488 defendant Burgon John yeoman 586573 586573 Burgon, John, of Barnesley, yeoman 3
4024632 2033488 2033488 defendant Taylor Richard yeoman 586573 586573 Taylor, Richard, of Barnesley, yeoman 4
4024633 2033488 2033488 defendant Bawmeforth Thomas yeoman 586573 586573 Bawmeforth, Thomas, of Barnesley, yeoman 5
4041581 2039483 2039483 defendant Northsowe Richard tanner 586573 586573 Northsowe, Richard, of Barnesley, tanner 5
4041590 2039484 2039484 defendant Northsowe Richard tanner 586573 586573 Northsowe, Richard, of Barnesley, tanner 5
4045845 2040960 2040960 defendant Taylour Richard clothier 586573 586573 Taylour, Richard, of Barnesley, clothier 0
4045846 2040960 2040960 defendant Byrkenshawer Richard glover 586573 586573 Byrkenshawer, Richard, of Barnesley, glover 1
4051656 2043014 2043014 defendant Bell John yeoman 586573 586573 Bell, John, of Barnesley, yeoman 1
4051663 2043015 2043015 defendant Bell John yeoman 586573 586573 Bell, John, of Barnesley, yeoman 1
4052224 2043217 2043217 defendant Burges John yeoman 586573 586573 Burges, John, of Barnesley, yeoman 0
4060002 2045974 2045974 defendant Wynley William shoemaker 586573 586573 Wynley, William, of Barnesley, shoemaker 0
4060004 2045974 2045974 defendant Thwait William gent 586573 586573 together with Thwait, William, of Barnesley, gent 2
4060005 2045974 2045974 defendant Baylye Robert yeoman 586573 586573 Baylye, Robert, of Barnesley, yeoman 3
4062032 2046705 2046705 defendant Rysheworth William vintner 586573 586573 Rysheworth, William, of Barnesley, vintner 0
4077475 2052234 2052234 defendant Twynehoe Edith widow 586573 586573 Twynehoe, Edith, of Barnesley, widow 0
4077477 2052235 2052235 defendant Twynhoe Edith widow 586573 586573 Twynhoe, Edith, of Barnesley, widow 0
4084449 2054713 2054713 defendant Senyor George butcher 586573 586573 Senyor, George, of Barnesley, butcher 0
4084511 2054737 2054737 defendant Barnes Philip husbandman 586573 586573 Barnes, Philip, of Barnesley, husbandman 0
4091887 2057393 2057393 defendant Howell Alexander slater 586573 586573 Howell, Alexander, of Barnesley, slater 2
4098456 2059776 2059776 defendant Heape John shoemaker 586573 586573 Heape, John, of Barnesley, shoemaker 0
4103100 2061398 2061398 defendant Smyth Charles butcher 586573 586573 Smyth, Charles, of Barnesley, butcher 0
4106884 2062754 2062754 defendant Grene Ralph yeoman 586573 586573 Grene, Ralph, of Barnesley, yeoman 2
4126573 2069788 2069788 defendant Woode Nicholas yeoman 586573 586573 Woode, Nicholas, of Barnesley, yeoman 0
4138912 2074289 2074289 defendant Bollande Elizabeth widow 586573 586573 Bollande, Elizabeth, of Barnesley, widow 3
4143442 2075867 2075867 defendant Wood Nicholas clothier 586573 586573 Wood, Nicholas, of Barnesley, clothier 3
4145151 2076465 2076465 defendant Nanfant John husbandman 586573 586573 Nanfant, John, of Barnesley, husbandman 0
4153215 2079222 2079222 defendant Sheffeld John yeoman 586573 586573 Sheffeld, John, of Barnesley, yeoman 0
4159306 2081325 2081325 defendant Heape John cordwainer 586573 586573 Heape, John, of Barnesley, cordwainer 0
4159307 2081325 2081325 defendant Bower Robert   586573 586573 Bower, Robert, of Barnesley, wire drawer 1
4160475 2081737 2081737 defendant Boyne Richard husbandman 586573 586573 Boyne, Richard, of Barnesley, husbandman 0
4160476 2081737 2081737 defendant Lockwoode Alexander husbandman 586573 586573 Lockwoode, Alexander, of Barnesley, or of Dodworthe, husbandman 1
4163262 2082680 2082680 defendant Spyvye John mercer 586573 586573 Spyvye, John, of Barnesley, mercer 0
4163263 2082680 2082680 defendant Spyvye William mercer 586573 586573 Spyvye, William, of Barnesley, mercer 1
4183887 2089858 2089858 defendant Thryste John fishmonger 586573 586573 Thryste, John, of Barnesley, fishmonger 1
4185027 2090272 2090272 defendant Norfolke Barnard husbandman or yeoman 586573 586573 Norfolke, Barnard, of Barnesley, husbandman or yeoman 0
4186252 2090676 2090676 defendant Bayllye Robert yeoman 586573 586573 Bayllye, Robert, of Barnesley, yeoman 0
4186253 2090676 2090676 defendant Bradley John tailor 586573 586573 Bradley, John, of Barnesley, yeoman, tailor 1
4193404 2093259 2093259 defendant Baron Philip yeoman 586573 586573 Baron, Philip, of Barnesley, Wymborne Mynster, Dorset, yeoman 1
4198955 2095191 2095191 defendant Rogers Christopher yeoman 586573 586573 Rogers, Christopher, of Barnesley, yeoman 0
4200600 2095771 2095771 defendant Burges Thomas yeoman 586573 586573 Burges, Thomas, of Barnesley, yeoman 0
4200601 2095771 2095771 defendant Wood Nicholas yeoman 586573 586573 Wood, Nicholas, of Barnesley, yeoman 1
4213130 2100117 2100117 defendant Thwaytes William gent 586573 586573 Thwaytes, William, of Barnesley, gent 0
4213131 2100117 2100117 defendant Blytheman John gent 586573 586573 Blytheman, John, of Barnesley, gent 1
4214558 2100598 2100598 defendant Rishworth Alexander yeoman 586573 586573 Rishworth, Alexander, of Barnesley, yeoman 0
4220134 2102543 2102543 defendant Rishworth Alexander gent 586573 586573 Rishworth, Alexander, of Barnesley, gent 0
4223669 2103764 2103764 defendant Heape John yeoman 586573 586573 Heape, John, of Barnesley, yeoman 0
4223670 2103764 2103764 defendant Bower Robert yeoman 586573 586573 Bower, Robert, of Barnesley, yeoman 1
4225263 2104303 2104303 defendant Vickers John dyer 586573 586573 Vickers, John, of Barnesley, dyer 0
4229099 2105660 2105660 defendant Thwaytes Richard gent 586573 586573 Thwaytes, Richard, of Barnesley, gent 2
4229100 2105660 2105660 defendant Spyvye Elizabeth widow 586573 586573 Spyvye, Elizabeth, of Barnesley, widow 3
4249250 2112733 2112733 defendant Ryshworth Alexander gent 586573 586573 Ryshworth, Alexander, of Barnesley, gent 0
4249269 2112738 2112738 defendant Ryshworth Alexander gent 586573 586573 Ryshworth, Alexander, of Barnesley, gent 1
4264198 2117674 2117674 defendant Rushworth Alexander yeoman 586573 586573 Rushworth, Alexander, of Barnesley, yeoman 0
4264211 2117679 2117679 defendant Rushworth Alexander yeoman 586573 586573 Rushworth, Alexander, of Barnesley, yeoman 0
4304194 2131599 2131599 defendant Barnes Philip yeoman 586573 586573 Barnes, Philip, of Barnesley, Wymborne Mynster, yeoman 0
4307362 2132710 2132710 defendant Barnes Philip yeoman 586573 586573 Barnes, Philip, of Barnesley, yeoman 0
4359326 2150496 2150496 defendant Byns John yeoman 586573 586573 Byns, John, of Barnesley, yeoman 0
4363399 2151983 2151983 defendant Moris Richard clerk 586573 586573 Moris, Richard, of Barnesley, clerk 0
4364788 2152459 2152459 defendant Wadley Humphrey husbandman 586573 586573 Wadley, Humphrey, of Barnesley, husbandman 1
4376076 2156507 2156507 defendant Blomer Henry gent 586573 586573 Blomer, Henry, of Barnesley, gent 0
4376078 2156508 2156508 defendant Blomer Henry gent 586573 586573 Blomer, Henry, of Barnesley, gent 0
4384559 2159525 2159525 defendant Robinson Thomas pointer 586573 586573 Robinson, Thomas, of Barnesley, pointer 0
4384560 2159525 2159525 defendant Robinson George pointer 586573 586573 Robinson, George, of Barnesley, pointer 1
4386791 2160251 2160251 defendant Wood Nicholas   586573 586573 Wood, Nicholas, of Barnesley, wire drawer 3
4389964 2161267 2161267 defendant Rishworth Alexander yeoman 586573 586573 Rishworth, Alexander, of Barnesley, yeoman 0
4389966 2161268 2161268 defendant Burges William yeoman 586573 586573 Burges, William, of Barnesley, yeoman 0
4389967 2161268 2161268 defendant Browne Thomas   586573 586573 Browne, Thomas, of Barnesley, wire drawer 1
4389968 2161268 2161268 defendant Heape John shoemaker 586573 586573 Heape, John, of Barnesley, shoemaker 2
4389970 2161269 2161269 defendant Heape John shoemaker 586573 586573 Heape, John, of Barnesley, shoemaker 0
4389971 2161269 2161269 defendant Browne Thomas   586573 586573 Browne, Thomas, of Barnesley, wire drawer 1
4389973 2161269 2161269 defendant Sturke Alexander clothier 586573 586573 Sturke, Alexander, of Barnesley, clothier 3
4390471 2161431 2161431 defendant Bodnam Thomas husbandman 586573 586573 Bodnam, Thomas, of Barnesley, husbandman 1
4390479 2161435 2161435 defendant Speche Henry miller 586573 586573 Speche, Henry, of Barnesley, miller 0
4392078 2161978 2161978 defendant Bourchier Charles gent 586573 586573 Bourchier, Charles, of Barnesley, gent 0
4393956 2162580 2162580 defendant Pettie Henry glasier 586573 586573 Pettie, Henry, of Barnesley, glasier 0
4400758 2164841 2164841 defendant Wood Nicholas yeoman 586573 586573 Wood, Nicholas, of Barnesley, yeoman 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);