names

127 rows where place_id = 587379

✎ 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
3591251 1864890 1864890 defendant Grene John draper 587379 587379 Grene, John, of Doncastre, draper 0
3591252 1864890 1864890 defendant Myssyn or Myffyn William draper 587379 587379 Myssyn or Myffyn, William, of Doncastre, draper 1
3594895 1866032 1866032 plaintiff Leyston John (legal representative) 587379 587379 Leyston, John, of Doncastre, executors of 0
3652612 1911152 1911152 defendant Halton Oliver yeoman 587379 587379 Halton, Oliver, of Doncastre, yeoman 0
3673703 1917801 1917801 defendant Whitehede Thomas butcher 587379 587379 Whitehede, Thomas, of Doncastre, butcher 0
3699438 1926049 1926049 defendant Hudson George yeoman 587379 587379 Hudson, George, of Doncastre, yeoman 0
3856108 1975532 1975532 defendant Camsall Richard tanner 587379 587379 Camsall, Richard, of Doncastre, tanner 0
3856109 1975532 1975532 defendant Walker Edmund glover 587379 587379 Walker, Edmund, of Doncastre, glover 1
4441228 2182188 2182188 defendant Turclys Robert (legal representative) 587379 587379 Turclys, Robert, of Doncastre, administrator of 0
4441229 2182188 2182188 defendant Chapman William   587379 587379 Chapman, William, of Doncastre 1
4466380 2190149 2190149 defendant Barbour William   587379 587379 Barbour, William, of Doncastre 0
4498590 2200202 2200202 defendant Payntour Thomas   587379 587379 Payntour, Thomas, of Doncastre 0
4499265 2200419 2200419 defendant Smyth John   587379 587379 Smyth, John, of Doncastre 0
4502452 2201348 2201348 plaintiff Millet Robert   587379 587379 Millet, Robert, of Doncastre, on his own account 0
4508034 2202984 2202984 defendant Selby John de   587379 587379 Selby, John de, of Doncastre 0
4581272 2225609 2225609 defendant Hachet William   587379 587379 Hachet, William, of Doncastre 1
4590245 2228320 2228320 plaintiff Madyrsay John   587379 587379 Madyrsay, John, of Doncastre 0
4597510 2230467 2230467 plaintiff Shirburne John   587379 587379 Shirburne, John, of Doncastre 0
4661102 2249297 2249297 defendant Hervy John dyer 587379 587379 Hervy, John, of Doncastre, dyer 0
4671434 2256716 2256716 plaintiff Cartewryght Thomas   587379 587379 Cartewryght, Thomas, of Doncastre 0
4675033 2257802 2257802 defendant Wirksoppe William   587379 587379 Wirksoppe, William, of Doncastre 0
4677319 2258526 2258526 defendant Repers Robert tanner 587379 587379 Repers, Robert, of Doncastre, tanner 0
4677320 2258526 2258526 defendant Russhe Richard   587379 587379 Russhe, Richard, of Doncastre, arrow maker 1
4678029 2258741 2258741 defendant Spicer William spicer 587379 587379 Spicer, William, of Doncastre, spicer 0
4686565 2261407 2261407 defendant Yve Edmund laborer 587379 587379 Yve, Edmund, of Doncastre, laborer 0
4690813 2262660 2262660 defendant Barton Richard gent 587379 587379 Barton, Richard, of Doncastre, gent 1
4690824 2262661 2262661 defendant Barton Richard de gent 587379 587379 Barton, Richard de, of Doncastre, gent 2
4776414 2288618 2288618 defendant Sparke Reginald glover 587379 587379 Sparke, Reginald, of Doncastre, glover 0
4776575 2288667 2288667 plaintiff Anastace Robert   587379 587379 Anastace, Robert, of Doncastre 0
4777734 2289030 2289030 plaintiff Barbour William   587379 587379 Barbour, William, of Doncastre 0
4813547 2300346 2300346 defendant Elcok John   587379 587379 Elcok, John, of Doncastre, bailiff 0
4825381 2303979 2303979 defendant Bussell Thomas chapman 587379 587379 Bussell, Thomas, of Doncastre, chapman 0
4856686 2313466 2313466 defendant Banastre Roger gent 587379 587379 Banastre, Roger, of Doncastre, gent 0
4858505 2314036 2314036 defendant Elcok John yeoman 587379 587379 Elcok, John, of Doncastre, yeoman 1
4863410 2315525 2315525 defendant Scanseby James dyer 587379 587379 Scanseby, James, of Doncastre, dyer 0
4866765 2316567 2316567 defendant Cook John   587379 587379 Cook, John, of Doncastre, cook 0
4868686 2317179 2317179 defendant Mysyn Thomas gent 587379 587379 Mysyn, Thomas, of Doncastre, gent 0
4869120 2317315 2317315 defendant Barbour John barber 587379 587379 Barbour, John, of Doncastre, barber 3
4881919 2321243 2321243 defendant Banyster Roger gent 587379 587379 Banyster, Roger, of Doncastre, gent 1
4885374 2322311 2322311 defendant Fleccher Hugh fisher 587379 587379 Fleccher, Hugh, of Doncastre, fisher 11
4887630 2322964 2322964 defendant Grene John husbandman 587379 587379 Grene, John, of Doncastre, husbandman 4
4887646 2322967 2322967 defendant Elcok John   587379 587379 Elcok, John, of Doncastre, bailiff 2
4887647 2322967 2322967 defendant Turnour John yeoman 587379 587379 Turnour, John, of Doncastre, yeoman 3
4888717 2323261 2323261 defendant Bilton Thomas husbandman 587379 587379 Bilton, Thomas, of Doncastre, husbandman 1
4888730 2323264 2323264 defendant Grene John gent 587379 587379 Grene, John, of Doncastre, gent 1
4890534 2323799 2323799 defendant Dawson William carpenter 587379 587379 Dawson, William, of Doncastre, carpenter 2
4892505 2324395 2324395 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4892515 2324396 2324396 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4892521 2324396 2324396 defendant Misus or Mysyn Thomas gent 587379 587379 Misus or Mysyn, Thomas, of Doncastre, gent 1
4892525 2324397 2324397 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4892535 2324398 2324398 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4892545 2324399 2324399 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4892555 2324400 2324400 plaintiff Banastre Roger (legal representative) 587379 587379 Banastre, Roger, of Doncastre, executors of 0
4898207 2326100 2326100 defendant Ledys John   587379 587379 Ledys, John, of Doncastre 1
4898208 2326100 2326100 defendant Catton John   587379 587379 Catton, John, of Doncastre 2
4898630 2326217 2326217 defendant Grene John yeoman 587379 587379 Grene, John, of Doncastre, yeoman 0
4918793 2332391 2332391 defendant Grene John yeoman 587379 587379 Grene, John, of Doncastre, yeoman 0
4948664 2341565 2341565 defendant Shyrfeld John baker 587379 587379 Shyrfeld, John, of Doncastre, baker 0
4953419 2342988 2342988 defendant Peryn Peter vintner 587379 587379 Peryn, Peter, of Doncastre, vintner 0
4984892 2352411 2352411 defendant Wormley Thomas husbandman 587379 587379 Wormley, Thomas, of Doncastre, husbandman 0
5027687 2364972 2364972 defendant Byrkes George yeoman 587379 587379 Byrkes, George, of Doncastre, yeoman 0
5032431 2366367 2366367 defendant Heynd Thomas goldsmith 587379 587379 Heynd, Thomas, of Doncastre, goldsmith 0
5034590 2366976 2366976 defendant Yole John yeoman 587379 587379 Yole, John, of Doncastre, yeoman 2
5036577 2367562 2367562 defendant Hyll Robert yeoman 587379 587379 Hyll, Robert, of Doncastre, yeoman 0
5037689 2367896 2367896 defendant Aumbuler John husbandman 587379 587379 Aumbuler, John, of Doncastre, husbandman 0
5053438 2372633 2372633 plaintiff Barmburgh John gent 587379 587379 Barmburgh, John, of Doncastre, gent 0
5053443 2372634 2372634 plaintiff Barmburgh John gent 587379 587379 Barmburgh, John, of Doncastre, gent 0
5053470 2372642 2372642 defendant Dowesyng Robert roper 587379 587379 Dowesyng, Robert, of Doncastre, roper 0
5053471 2372642 2372642 defendant Briche or Birche John baker 587379 587379 Briche or Birche, John, of Doncastre, baker 1
5055046 2373076 2373076 defendant Walker Robert sheather 587379 587379 Walker, Robert, of Doncastre, sheather 0
5055920 2373338 2373338 defendant Barnburgh John vintner 587379 587379 Barnburgh, John, of Doncastre, vintner 1
5056061 2373387 2373387 defendant Dowesyng Robert roper 587379 587379 Dowesyng, Robert, of Doncastre, roper 3
5056062 2373387 2373387 defendant Fox Thomas yeoman 587379 587379 Fox, Thomas, of Doncastre, yeoman 4
5056063 2373387 2373387 defendant Hogeson John weaver 587379 587379 Hogeson, John, of Doncastre, weaver 5
5056064 2373387 2373387 defendant Sawer William yeoman 587379 587379 Sawer, William, of Doncastre, yeoman 6
5056065 2373387 2373387 defendant Lyncoln John shoemaker 587379 587379 Lyncoln, John, of Doncastre, shoemaker 7
5058659 2374151 2374151 defendant Busby Richard yeoman 587379 587379 Busby, Richard, of Doncastre, yeoman 4
5059437 2374390 2374390 plaintiff Eland John   587379 587379 Eland, John, of Doncastre 0
5070745 2377749 2377749 plaintiff Shether John chapman 587379 587379 Shether, John, of Doncastre, chapman 0
5083411 2381536 2381536 defendant Haryngton John esq 587379 587379 Haryngton, John, of Doncastre, esq 0
5083412 2381536 2381536 defendant Bethom William yeoman 587379 587379 together with Bethom, William, of Doncastre, yeoman 1
5083413 2381536 2381536 defendant Fox John   587379 587379 Fox, John, of Doncastre, servant 2
5083474 2381556 2381556 defendant Clerke Thomas yeoman 587379 587379 Clerke, Thomas, of Doncastre, yeoman 4
5103156 2387349 2387349 defendant Wilton Thomas dyer 587379 587379 Wilton, Thomas, of Doncastre, dyer 1
5104299 2387679 2387679 defendant Bower William chaplain 587379 587379 Bower, William, of Doncastre, chaplain 0
5107004 2388478 2388478 defendant Hogh Thomas draper 587379 587379 Hogh, Thomas, of Doncastre, draper 0
5123996 2393471 2393471 defendant Leycestre Ralph ostler 587379 587379 Leycestre, Ralph, of Doncastre, ostler 0
5220026 2421566 2421566 defendant Bryan Alice widow 587379 587379 Bryan, Alice, of Doncastre, widow 12
5220964 2421830 2421830 defendant Brian Richard (legal representative) 587379 587379 Brian, Richard, of Doncastre, executrix of 0
5220965 2421830 2421830 defendant Brian Alice widow 587379 587379 Brian, Alice, of Doncastre, widow 1
5228052 2423810 2423810 defendant Skynner William skinner 587379 587379 Skynner, William, of Doncastre, skinner 2
5228799 2424033 2424033 defendant Bladesmyth William yeoman 587379 587379 Bladesmyth, William, of Doncastre, yeoman 0
5228967 2424076 2424076 defendant de la Cre John butcher 587379 587379 de la Cre, John, of Doncastre, butcher 0
5229329 2424190 2424190 defendant Hewette John dyer 587379 587379 Hewette, John, of Doncastre, dyer 0
5229501 2424243 2424243 defendant Adamson Thomas yeoman 587379 587379 Adamson, Thomas, of Doncastre, yeoman 1
5231118 2424701 2424701 defendant Huwett John   587379 587379 Huwett, John, of Doncastre 0
5236022 2426117 2426117 defendant Leston William chapman 587379 587379 Leston, William, of Doncastre, chapman 0
5236643 2426301 2426301 defendant Brompton John plumber 587379 587379 Brompton, John, of Doncastre, plumber 2
5240724 2427496 2427496 defendant Littester Thomas yeoman 587379 587379 Littester, Thomas, of Doncastre, yeoman 8
5240725 2427496 2427496 defendant Parke Thomas yeoman 587379 587379 Parke, Thomas, of Doncastre, yeoman 9

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