names

128 rows where place_id = 612968

✎ 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
3695883 1924948 1924948 plaintiff Roberdys Richard clerk 612968 612968 Roberdys, Richard, of Yorkshire, clerk 0
3899240 1989955 1989955 defendant Oxenfeld Robert (legal representative) 612968 612968 Oxenfeld, Robert, of Yorkshire, clothier, administrator of 0
3901125 1990601 1990601 defendant Parker George gent 612968 612968 Parker, George, of Yorkshire, gent 0
3950139 2007131 2007131 plaintiff Foxcroft Thomas clothier 612968 612968 Foxcroft, Thomas, of Yorkshire, clothier 0
3962202 2011362 2011362 defendant Chawmbers William chapman 612968 612968 Chawmbers, William, of Yorkshire, chapman 1
4107516 2062975 2062975 defendant Bradshawe Thomas weaver 612968 612968 Bradshawe, Thomas, of Yorkshire, weaver 0
4126634 2069811 2069811 defendant Potter Anne widow 612968 612968 Anne his wife, formerly Anne Saunde, of Yorkshire, widow 1
4127406 2070091 2070091 defendant Nicolson Nicholas husbandman 612968 612968 Nicolson, Nicholas, of Yorkshire, husbandman 3
4137056 2073604 2073604 defendant Newsam John yeoman 612968 612968 Newsam, John, of Yorkshire, yeoman 0
4207382 2098135 2098135 defendant Foxe Peter yeoman 612968 612968 Foxe, Peter, of Yorkshire, yeoman 2
4233139 2107099 2107099 defendant Manne Thomas gent 612968 612968 Manne, Thomas, of Yorkshire, gent 2
4274171 2120910 2120910 defendant Smalewood John gent 612968 612968 Smalewood, John, of Yorkshire, gent 1
4337990 2143029 2143029 defendant Conyers Richard gent 612968 612968 Conyers, Richard, of Yorkshire, gent 2
4349092 2146942 2146942 defendant Dawson Thomas skinner 612968 612968 Dawson, Thomas, of Yorkshire, or of London, skinner 0
4403963 2165895 2165895 defendant Legg John gent 612968 612968 Legg, John, of Yorkshire, gent 2
4428875 2173832 2173832 plaintiff Thoresby Thomas de   612968 612968 Thoresby, Thomas de, of Yorkshire 0
4428877 2173833 2173833 plaintiff Thoresby Thomas de   612968 612968 Thoresby, Thomas de, of Yorkshire 0
4436942 2176295 2176295 plaintiff Thoresby Thomas de   612968 612968 Thoresby, Thomas de, of Yorkshire 0
4436944 2176296 2176296 plaintiff Thoresby Thomas de   612968 612968 Thoresby, Thomas de, of Yorkshire 0
4440903 2182075 2182075 defendant Rylay John de   612968 612968 Rylay, John de, of Yorkshire, son of Robert 0
4441276 2182205 2182205 defendant Staynton Thomas de   612968 612968 Staynton, Thomas de, of Yorkshire 0
4447607 2184171 2184171 defendant Elys John   612968 612968 Elys, John, of Yorkshire 0
4452228 2185679 2185679 defendant Doigneton John   612968 612968 Doigneton, John, of Yorkshire 1
4452564 2185805 2185805 defendant Walker William   612968 612968 Walker, William, of Yorkshire 0
4456794 2187132 2187132 plaintiff Osmunderle Peter   612968 612968 Osmunderle, Peter, of Yorkshire 0
4460017 2188190 2188190 defendant Chauncey William   612968 612968 Chauncey, William, of Yorkshire 0
4464648 2189610 2189610 defendant fitz Henry Thomas   612968 612968 fitz Henry, Thomas, of Yorkshire, knight 0
4469823 2191232 2191232 defendant Depeden John   612968 612968 Depeden, John, of Yorkshire, knight 6
4469833 2191233 2191233 defendant Depen John   612968 612968 Depen, John, of Yorkshire, knight 4
4498751 2200242 2200242 defendant Ar-- John   612968 612968 Ar--, John, of Yorkshire 4
4504766 2202032 2202032 defendant Croke John   612968 612968 Croke, John, of Yorkshire 2
4510622 2203779 2203779 defendant Wrysell John chapman 612968 612968 Wrysell, John, of Yorkshire, chapman 3
4510629 2203780 2203780 defendant Wrysell John chapman 612968 612968 Wrysell, John, of Yorkshire, chapman 3
4513117 2204535 2204535 defendant Swelyngton William esq 612968 612968 Swelyngton, William, of Yorkshire, esq 2
4513123 2204536 2204536 defendant Swelyngton William esq 612968 612968 Swelyngton, William, of Yorkshire, esq 2
4513125 2204536 2204536 defendant Elys Robert esq 612968 612968 Elys, Robert, of Yorkshire, esq 4
4513133 2204538 2204538 defendant Dannaye John   612968 612968 Dannaye, John, of Yorkshire 0
4518188 2206062 2206062 plaintiff del Fall Stephen (legal representative) 612968 612968 del Fall, Stephen, of Yorkshire, administratrix of 0
4518227 2206075 2206075 defendant Matheuson Robert   612968 612968 Matheuson, Robert, of Yorkshire 0
4523611 2207710 2207710 defendant Haldenby Thomas   612968 612968 Haldenby, Thomas, of Yorkshire 0
4523613 2207711 2207711 defendant Haldneby Thomas   612968 612968 Haldneby, Thomas, of Yorkshire 0
4523901 2207807 2207807 defendant Sheffeld Thomas   612968 612968 Sheffeld, Thomas, of Yorkshire 2
4526975 2208718 2208718 defendant Daly John   612968 612968 Daly, John, of Yorkshire 1
4534008 2210905 2210905 defendant Chestre Thomas   612968 612968 Chestre, Thomas, of Yorkshire 0
4543118 2213731 2213731 defendant Relegh Hugh de   612968 612968 Relegh, Hugh de, of Yorkshire 13
4543119 2213731 2213731 defendant Fylcok Thomas   612968 612968 Fylcok, Thomas, of Yorkshire 14
4543175 2213748 2213748 defendant Bretby John   612968 612968 Bretby, John, of Yorkshire 0
4545153 2214402 2214402 defendant Monkton John esq 612968 612968 Monkton, John, of Yorkshire, esq 0
4545155 2214403 2214403 defendant Monkton John esq 612968 612968 Monkton, John, of Yorkshire, esq 0
4547584 2215179 2215179 defendant Malerbe Joan   612968 612968 Malerbe, Joan, of Yorkshire 5
4548667 2215526 2215526 defendant Etton John   612968 612968 Etton, John, of Yorkshire, knight 3
4548678 2215528 2215528 defendant Etton John   612968 612968 Etton, John, of Yorkshire, knight 4
4550515 2216104 2216104 defendant Goldysbourgh Richard   612968 612968 Goldysbourgh, Richard, of Yorkshire, knight 0
4550522 2216105 2216105 defendant Goldysburgh Richard   612968 612968 Goldysburgh, Richard, of Yorkshire, knight 0
4574831 2223654 2223654 defendant Bayok Ralph   612968 612968 Bayok, Ralph, of Yorkshire 0
4582545 2225984 2225984 defendant Williamyssone John   612968 612968 Williamyssone, John, of Yorkshire 4
4586245 2227119 2227119 defendant Fleteham John   612968 612968 Fleteham, John, of Yorkshire 5
4586254 2227120 2227120 defendant Fletcham John   612968 612968 Fletcham, John, of Yorkshire 5
4587191 2227400 2227400 defendant Morton Robert esq 612968 612968 Morton, Robert, of Yorkshire, esq 0
4587415 2227471 2227471 defendant Sauvage William   612968 612968 Sauvage, William, of Yorkshire 1
4587423 2227472 2227472 defendant Sauvage William   612968 612968 Sauvage, William, of Yorkshire 1
4592987 2229124 2229124 defendant Mareschall John   612968 612968 Mareschall, John, of Yorkshire 1
4594281 2229473 2229473 defendant Stede Robert   612968 612968 Stede, Robert, of Yorkshire 0
4595339 2229794 2229794 defendant Eccon John   612968 612968 Eccon, John, of Yorkshire, knight 0
4595351 2229796 2229796 defendant Eccon John de   612968 612968 Eccon, John de, of Yorkshire, knight 0
4596492 2230145 2230145 defendant Boynton John esq 612968 612968 Boynton, John, of Yorkshire, esq 0
4596497 2230146 2230146 defendant Boynton John esq 612968 612968 Boynton, John, of Yorkshire, esq 0
4596502 2230147 2230147 defendant Boynton John esq 612968 612968 Boynton, John, of Yorkshire, esq 0
4597298 2230396 2230396 defendant Popilton Henry   612968 612968 Popilton, Henry, of Yorkshire 2
4597307 2230397 2230397 defendant Popylton Henry   612968 612968 Popylton, Henry, of Yorkshire 2
4602411 2231971 2231971 defendant Dene John de   612968 612968 Dene, John de, of Yorkshire 0
4602506 2232002 2232002 defendant Archer William   612968 612968 Archer, William, of Yorkshire 2
4603615 2232316 2232316 defendant Lovell John   612968 612968 Lovell, John, of Yorkshire 1
4608914 2233890 2233890 defendant Dannay John   612968 612968 Dannay, John, of Yorkshire 0
4608915 2233890 2233890 defendant Ledys Roger (legal representative) 612968 612968 Ledys, Roger, of Yorkshire, knight, administrator of 1
4612940 2235108 2235108 defendant Aveleby Thomas clerk 612968 612968 Aveleby, Thomas, of Yorkshire, clerk 0
4613521 2235247 2235247 defendant Rouche John   612968 612968 Rouche, John, of Yorkshire 3
4614388 2235508 2235508 defendant Forster Gilbert   612968 612968 Forster, Gilbert, of Yorkshire 2
4617881 2236594 2236594 defendant Dannay John   612968 612968 Dannay, John, of Yorkshire 0
4617882 2236594 2236594 defendant Ledys Roger (legal representative) 612968 612968 Ledys, Roger, of Yorkshire, knight, administrator of 1
4621011 2237556 2237556 defendant Elmesall Thomas   612968 612968 Elmesall, Thomas, of Yorkshire 0
4625608 2238968 2238968 defendant Constable Thomas   612968 612968 Constable, Thomas, of Yorkshire 2
4625612 2238969 2238969 defendant Constable Thomas esq 612968 612968 Constable, Thomas, of Yorkshire, esq 2
4629950 2240288 2240288 defendant Thirston William chapman 612968 612968 Thirston, William, of Yorkshire, chapman 0
4629955 2240289 2240289 defendant Thirston William chapman 612968 612968 Thirston, William, of Yorkshire, chapman 0
4639836 2243155 2243155 defendant Aneleby Thomas clerk 612968 612968 Aneleby, Thomas, of Yorkshire, clerk 2
4644183 2244392 2244392 defendant Rokeby Thomas   612968 612968 Rokeby, Thomas, of Yorkshire, knight 0
4644185 2244393 2244393 defendant Rokeby Thomas   612968 612968 Rokeby, Thomas, of Yorkshire, knight 0
4644399 2244453 2244453 defendant Wath William   612968 612968 Wath, William, of Yorkshire 3
4644451 2244465 2244465 defendant Morly John chaplain 612968 612968 Morly, John, of Yorkshire, chaplain 2
4644460 2244466 2244466 defendant Morby John chaplain 612968 612968 Morby, John, of Yorkshire, chaplain 2
4646271 2244982 2244982 defendant Warde Robert clerk 612968 612968 Warde, Robert, of Yorkshire, clerk 1
4646275 2244983 2244983 defendant Warde Robert clerk 612968 612968 Warde, Robert, of Yorkshire, clerk 1
4649947 2246002 2246002 defendant Dam Thomas de   612968 612968 Dam, Thomas de, of Yorkshire 2
4649952 2246003 2246003 defendant Dam Thomas de   612968 612968 Dam,Thomas de, of Yorkshire 2
4650098 2246046 2246046 defendant Hoton William   612968 612968 Hoton, William, of Yorkshire 0
4657965 2248377 2248377 plaintiff Constable William   612968 612968 Constable, William, of Yorkshire 0
4684428 2260732 2260732 plaintiff Gare Richard   612968 612968 Gare, Richard, of Yorkshire 6
4729905 2274561 2274561 defendant Swynflete Thomas de   612968 612968 Swynflete, Thomas de, of Yorkshire, son of Richard 1
4732964 2275487 2275487 defendant Thornholm John   612968 612968 Thornholm, John, of Yorkshire 2

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