names

399 rows where place_id = 586093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587921 1863872 1863872 defendant Cawthorn Robert eyoman 586093 586093 Cawthorn, Robert, of Selby, eyoman 0
3590456 1864661 1864661 defendant Bolton Richard laborer 586093 586093 Bolton, Richard, of Selby, laborer 0
3592137 1865158 1865158 defendant Plesaunce Walter gent 586093 586093 Plesaunce, Walter, of Selby, gent 1
3592971 1865425 1865425 defendant Ebbyson Thomas barber 586093 586093 Ebbyson, Thomas, of Selby, barber 0
3593676 1865660 1865660 defendant Michell George laborer 586093 586093 Michell, George, of Selby, laborer 0
3593677 1865660 1865660 defendant Stabell Thomas laborer 586093 586093 Stabell, Thomas, of Selby, laborer 1
3594290 1865850 1865850 defendant Peerson John yeoman 586093 586093 Peerson, John, of Selby, yeoman 2
3594291 1865850 1865850 defendant Peerson Robert laborer 586093 586093 Peerson, Robert, of Selby, laborer 3
3594756 1865984 1865984 defendant Shepard William butcher 586093 586093 Shepard, William, of Selby, butcher 0
3620263 1873917 1873917 defendant Smyth Thomas butcher 586093 586093 Smyth, Thomas, of Selby, butcher 1
3630604 1904400 1904400 defendant Scarlet William yeoman 586093 586093 Scarlet, William, of Selby, yeoman 0
3674205 1917970 1917970 defendant Flowre John carpenter 586093 586093 Flowre, John, of Selby, carpenter 0
3674599 1918107 1918107 plaintiff Grene John shoemaker 586093 586093 Grene, John, of Selby, shoemaker 0
3714573 1930855 1930855 defendant Shipman Thomas butcher 586093 586093 Shipman, Thomas, of Selby, butcher 0
3728890 1935285 1935285 defendant Flemyng Reginald butcher 586093 586093 Flemyng, Reginald, of Selby, butcher 0
3728891 1935285 1935285 defendant Browne Thomas husbandman 586093 586093 Browne, Thomas, of Selby, husbandman 1
3749798 1941847 1941847 defendant Cokson Amery gent 586093 586093 Cokson, Amery, of Selby, gent 0
3753093 1942906 1942906 defendant Broune Thomas husbandman 586093 586093 Broune, Thomas, of Selby, husbandman 0
3753097 1942907 1942907 defendant Goldell Richard   586093 586093 Goldell, Richard, of Selby, wax chandler 0
3753103 1942910 1942910 defendant Goldell William   586093 586093 Goldell, William, of Selby, wax chandler 0
3767718 1947540 1947540 defendant Peyke Richard merchant 586093 586093 Peyke, Richard, of Selby, merchant 0
3785412 1953225 1953225 defendant Peyke Robert merchant 586093 586093 Peyke, Robert, of Selby, merchant 0
3818538 1963699 1963699 plaintiff Maunsell John gent 586093 586093 Maunsell, John, of Selby, gent 0
3821811 1964711 1964711 defendant Fanthorppe Robert mariner 586093 586093 Fanthorppe, Robert, of Selby, mariner 0
3829660 1967167 1967167 defendant Barton Thomas gent 586093 586093 Barton, Thomas, of Selby, gent 4
3838876 1970086 1970086 defendant Boysse Thomas plumber 586093 586093 Boysse, Thomas, of Selby, plumber 0
3853701 1974788 1974788 defendant Wellys John slater 586093 586093 Wellys, John, of Selby, slater 4
3868531 1979717 1979717 plaintiff Symson Edward chapman 586093 586093 Symson, Edward, of Selby, chapman 0
3881992 1984237 1984237 defendant Flowre Thomas tanner 586093 586093 Flowre, Thomas, of Selby, tanner 0
3899476 1990041 1990041 plaintiff Beverley Thomas gent 586093 586093 Beverley, Thomas, of Selby, gent 0
3904810 1991872 1991872 plaintiff Hudspyth John   586093 586093 Hudspyth, John, of Selby 0
3928209 1999771 1999771 defendant Middleton Robert yeoman 586093 586093 Middleton, Robert, of Selby, yeoman 0
3928210 1999771 1999771 defendant Preston John yeoman 586093 586093 Preston, John, of Selby, yeoman 1
3969232 2013849 2013849 defendant Beverley William gent 586093 586093 Beverley, William, of Selby, gent 0
4055166 2044240 2044240 plaintiff Beckwyth Roger esq 586093 586093 Beckwyth, Roger, of Selby, esq 0
4099866 2060278 2060278 defendant Hulton George gent 586093 586093 Hulton, George, of Selby, gent 0
4099870 2060279 2060279 defendant Hulton George gent 586093 586093 Hulton, George, of Selby,, gent 0
4118131 2066769 2066769 defendant Thomyson Richard husbandman 586093 586093 Thomyson, Richard, of Selby, husbandman 0
4118132 2066769 2066769 defendant Thorneton Richard yeoman 586093 586093 Thorneton, Richard, of Selby, yeoman 1
4118134 2066770 2066770 defendant Thomyson Richard husbandman 586093 586093 Thomyson, Richard, of Selby, husbandman 0
4118135 2066770 2066770 defendant Thorneton Richard yeoman 586093 586093 Thorneton, Richard, of Selby, yeoman 1
4119698 2067332 2067332 defendant Graunte Tristram   586093 586093 Graunte, Tristram, of Selby, ship carpenter 0
4119700 2067332 2067332 defendant Shawe John laborer 586093 586093 Shawe, John, of Selby, laborer 2
4190391 2092175 2092175 defendant Thorlelande Roger   586093 586093 Thorlelande, Roger, of Selby esq 1
4196122 2094191 2094191 defendant Ingland William yeoman 586093 586093 Ingland, William, of Selby, yeoman 0
4250660 2113203 2113203 defendant Wait Richard yeoman 586093 586093 Wait, Richard, of Selby, yeoman 2
4255106 2114701 2114701 defendant Breyfeyt James yeoman 586093 586093 Breyfeyt, James, of Selby, yeoman 1
4336338 2142447 2142447 defendant Ardington Robert gent 586093 586093 Ardington, Robert, of Selby, gent 1
4346823 2146141 2146141 defendant Harbred William yeoman 586093 586093 Harbred, William, of Selby, yeoman 1
4360846 2151046 2151046 defendant Wawde Miles butcher 586093 586093 Wawde, Miles, of Selby, butcher 0
4382075 2158689 2158689 defendant Potter Henry tanner 586093 586093 Potter, Henry, of Selby, tanner 0
4382403 2158815 2158815 defendant Nuttall John yeoman 586093 586093 Nuttall, John, of Selby, yeoman 0
4399058 2164268 2164268 defendant Arthington Robert gent 586093 586093 Arthington, Robert, of Selby, gent 1
4410990 2168265 2168265 defendant Ashington Robert gent 586093 586093 Ashington, Robert, of Selby, gent 3
4446968 2183968 2183968 plaintiff Drax Richard de   586093 586093 Drax, Richard de, of Selby, on his own account 0
4447494 2184129 2184129 defendant Smyth Alice   586093 586093 Smyth, Alice, of Selby 2
4457686 2187413 2187413 plaintiff Pierson Thomas   586093 586093 Pierson, Thomas, of Selby, son of John, kinsman & heir of William Gely, of Selby 0
4457687 2187413 2187413 defendant Gely Beatrice   586093 586093 Gely, Beatrice, of Selby, formerly wife of William Gely 0
4482061 2195101 2195101 plaintiff Martyn John   586093 586093 Martyn, John, of Selby 0
4485215 2196079 2196079 defendant Dod John   586093 586093 Dod, John, of Selby 0
4495168 2199174 2199174 defendant Frere Richard   586093 586093 Frere, Richard, of Selby 0
4495697 2199334 2199334 plaintiff Cawode Robert   586093 586093 Cawode, Robert, of Selby 0
4498722 2200236 2200236 plaintiff Garner Robert   586093 586093 Garner, Robert, of Selby 0
4498726 2200237 2200237 plaintiff Garner Robert   586093 586093 Garner, Robert, of Selby 0
4501298 2201009 2201009 defendant Bridder Nicholas   586093 586093 Bridder, Nicholas, of Selby 3
4503384 2201629 2201629 plaintiff Pedeman Robert   586093 586093 Pedeman, Robert, of Selby 0
4511504 2204043 2204043 defendant Frankysshe William tailor 586093 586093 Frankysshe, William, of Selby, tailor 0
4514192 2204855 2204855 defendant Got John mariner 586093 586093 Got, John, of Selby, mariner 6
4518099 2206033 2206033 defendant Cawod Robert   586093 586093 Cawod, Robert, of Selby 5
4519764 2206540 2206540 plaintiff Estryk John   586093 586093 Estryk, John, of Selby 0
4519765 2206540 2206540 defendant Birder John   586093 586093 Birder, John, of Selby 0
4520654 2206808 2206808 defendant Cawode Robert   586093 586093 Cawode, Robert, of Selby 0
4533443 2210728 2210728 defendant Kyrkeby Roger   586093 586093 Kyrkeby, Roger, of Selby 0
4537348 2211950 2211950 defendant Hare John plumber 586093 586093 Hare, John, of Selby, plumber 0
4539434 2212588 2212588 defendant Dodde John butcher 586093 586093 Dodde, John, of Selby, butcher 2
4544068 2214059 2214059 plaintiff Barbour (illegible)   586093 586093 Barbour, _, of Selby 0
4544069 2214059 2214059 defendant Conyngston James chaplain 586093 586093 Conyngston, James, of Selby, chaplain 0
4544920 2214330 2214330 plaintiff Belvas William   586093 586093 Belvas, William, of Selby 0
4550925 2216226 2216226 defendant Ferrour William   586093 586093 Ferrour, William, of Selby 0
4550972 2216240 2216240 defendant Roper John   586093 586093 Roper, John, of Selby 0
4554230 2217251 2217251 plaintiff Grayngham Robert   586093 586093 Grayngham, Robert, of Selby 0
4564841 2220570 2220570 defendant Barker Richard   586093 586093 Barker, Richard, of Selby 1
4564860 2220570 2220570 defendant Skate of Slate Henry   586093 586093 Skate of Slate, Henry, of Selby 20
4568682 2221787 2221787 plaintiff Wallay John   586093 586093 Wallay, John, of Selby 0
4573401 2223211 2223211 defendant Keile William   586093 586093 Keile, William, of Selby 0
4575868 2223941 2223941 defendant Copyn John   586093 586093 Copyn, John, of Selby 1
4577680 2224525 2224525 defendant Fox Robert   586093 586093 Fox, Robert, of Selby 0
4578394 2224730 2224730 defendant Cawode Thomas   586093 586093 Cawode, Thomas, of Selby 0
4579208 2224979 2224979 defendant Marschall William   586093 586093 Marschall, William, of Selby 1
4592789 2229083 2229083 defendant Warener Robert   586093 586093 Warener, Robert, of Selby 0
4602120 2231886 2231886 defendant Bolton Margery   586093 586093 Bolton, Margery, of Selby 1
4602123 2231886 2231886 defendant Welles Nicholas butcher 586093 586093 Welles, Nicholas, of Selby, butcher 4
4609807 2234159 2234159 defendant Warnere Robert   586093 586093 Warnere, Robert, of Selby 0
4609952 2234203 2234203 plaintiff Bylton John chaplain 586093 586093 Bylton, John, of Selby, chaplain 0
4609998 2234215 2234215 defendant Grayngham Robert   586093 586093 Grayngham, Robert, of Selby 0
4614265 2235473 2235473 defendant Hoperton John   586093 586093 Hoperton, John, of Selby 0
4619365 2237051 2237051 plaintiff Hiprun John de (legal representative) 586093 586093 Hiprun, John de, of Selby, executors of 0
4619366 2237051 2237051 plaintiff Ussher Agens daughter of Thomas 586093 586093 (Ussher, Agens, of Selby, daughter of Thomas 1
4619685 2237141 2237141 defendant Grayngham Robert   586093 586093 Grayngham, Robert, of Selby 0
4621026 2237561 2237561 plaintiff Kirkeby Roger de   586093 586093 Kirkeby, Roger de, of Selby 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);