names

9,876 rows where place_id = 586067

✎ 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
3587845 1863845 1863845 defendant Norman John mercer 586067 586067 Norman, John, of York, mercer 1
3587926 1863874 1863874 defendant Tode William   586067 586067 Tode, William, of York, knight 0
3589236 1864278 1864278 plaintiff Brown William dyer 586067 586067 Brown, William, of York, dyer 0
3589375 1864317 1864317 defendant Wandesford Thomas gent 586067 586067 Wandesford, Thomas, of York, gent 0
3589511 1864357 1864357 defendant Haryngton John   586067 586067 Haryngton, John, of York, clerk, bachelor of law 0
3590606 1864705 1864705 defendant Neleson Thomas (legal representative) 586067 586067 Neleson, Thomas, of York, esq, executors of 0
3590607 1864705 1864705 defendant Neleson Thomas gent 586067 586067 (Neleson, Thomas, of York, gent 1
3590608 1864705 1864705 defendant Neleson William gent 586067 586067 Neleson, William, of York, gent 2
3590609 1864705 1864705 defendant Wrangys Robert clerk 586067 586067 Wrangys, Robert, of York, clerk 3
3590833 1864770 1864770 defendant Londysdale John taverner 586067 586067 Londysdale, John, of York, taverner 0
3590834 1864770 1864770 defendant Hogeson Stephen   586067 586067 Hogeson, Stephen, of York, mattress maker 1
3590835 1864770 1864770 defendant Wylson Richard   586067 586067 Wylson, Richard, of York, parchment maker 2
3590836 1864770 1864770 defendant Smyth Thomas tailor 586067 586067 Smyth, Thomas, of York, tailor 3
3590837 1864770 1864770 defendant Atkynson Robert walker 586067 586067 Atkynson, Robert, of York, walker 4
3590838 1864770 1864770 defendant Bacon John cooper 586067 586067 Bacon, John, of York, cooper 5
3590839 1864770 1864770 defendant Sherowe Roger miller 586067 586067 Sherowe, Roger, of York, miller 6
3590840 1864770 1864770 defendant Hunter Thomas tiler 586067 586067 Hunter, Thomas, of York, tiler 7
3590841 1864770 1864770 defendant Lax Thomas walker 586067 586067 Lax, Thomas, of York, walker 8
3590842 1864770 1864770 defendant Breten John sherman 586067 586067 Breten, John, of York, sherman 9
3590843 1864770 1864770 defendant Huchenson John baker 586067 586067 Huchenson, John, of York, baker 10
3590844 1864770 1864770 defendant Bell John   586067 586067 Bell, John, of York, wright 11
3590845 1864770 1864770 defendant Teleson John currier 586067 586067 Teleson, John, of York, currier 12
3590846 1864770 1864770 defendant Larom Thomas   586067 586067 Larom, Thomas, of York, card maker 13
3590847 1864770 1864770 defendant Yonson John tailor 586067 586067 Yonson, John, of York, tailor 14
3590848 1864770 1864770 defendant Gybbys Thomas weaver 586067 586067 Gybbys, Thomas, of York, weaver 15
3590849 1864770 1864770 defendant Anderson Thomas miller 586067 586067 Anderson, Thomas, of York, miller 16
3590850 1864770 1864770 defendant Burton John miller 586067 586067 Burton, John, of York, miller 17
3590851 1864770 1864770 defendant Parot Peter baker 586067 586067 Parot, Peter, of York, baker 18
3590852 1864770 1864770 defendant Herryson John shoemaker 586067 586067 Herryson, John, of York, shoemaker 19
3590853 1864770 1864770 defendant Topshawe Thomas saddler 586067 586067 Topshawe, Thomas, of York, saddler 20
3590854 1864770 1864770 defendant Fere John tailor 586067 586067 Fere, John, of York, tailor 21
3590855 1864770 1864770 defendant Barbour Henry barber 586067 586067 Barbour, Henry, of York, barber 22
3590856 1864770 1864770 defendant Robynson William shoemaker 586067 586067 Robynson, William, of York, shoemaker 23
3591516 1864972 1864972 plaintiff Ellys John   586067 586067 Ellys, John, of York, wax chandler 0
3591518 1864973 1864973 plaintiff Ellys John   586067 586067 Ellys, John, of York, wax chandler 0
3591519 1864973 1864973 defendant Yon Richard merchant 586067 586067 Yon, Richard, of York, merchant 0
3592766 1865349 1865349 defendant Parke Robert   586067 586067 Parke, Robert, of York, parchment maker 0
3592768 1865350 1865350 defendant Parke Robert   586067 586067 Parke, Robert, of York, parchment maker 0
3592960 1865420 1865420 defendant Gray Ralph merchant 586067 586067 Gray, Ralph, of York, merchant 0
3592967 1865424 1865424 plaintiff Hadlowe John (legal representative) 586067 586067 Hadlowe, John, of York, mercer, executor of 0
3594076 1865789 1865789 defendant Snaweball Thomas butcher 586067 586067 Snaweball, Thomas, of York, butcher 0
3594077 1865789 1865789 defendant Stabill Richard saddler 586067 586067 Stabill, Richard, of York, saddler 1
3594078 1865789 1865789 defendant Bullok William smith 586067 586067 Bullok, William, of York, smith 2
3594638 1865952 1865952 defendant Hunter Thomas innholder 586067 586067 Hunter, Thomas, of York, innholder 0
3595254 1866149 1866149 defendant Rypley John clerk 586067 586067 Rypley, John, of York, clerk 0
3595888 1866348 1866348 defendant Flaxton Thomas butcher 586067 586067 Flaxton, Thomas, of York, butcher 5
3596476 1866528 1866528 plaintiff Pereson William chaplain 586067 586067 Pereson, William, of York, chaplain 0
3596477 1866528 1866528 plaintiff Pereson John dyer 586067 586067 Pereson, John, of York,dyer 1
3596879 1866658 1866658 defendant Slyngesby John gent 586067 586067 Slyngesby, John, of York, gent 3
3597592 1866872 1866872 defendant Lewesham Robert merchant 586067 586067 Lewesham, Robert, of York, merchant 0
3599784 1867577 1867577 defendant Arkilby Thomas laborer 586067 586067 Arkilby, Thomas, of York, laborer 0
3599785 1867577 1867577 defendant Pavar or Panar Bartholomew laborer 586067 586067 Pavar or Panar, Bartholomew, of York, laborer 1
3599827 1867593 1867593 defendant Borowedale John shoemaker 586067 586067 Borowedale, John, of York, shoemaker 0
3599861 1867607 1867607 defendant Davyson or Danyson Margaret widow 586067 586067 Davyson or Danyson, Margaret, of York, widow 0
3599872 1867611 1867611 defendant Stabill Richard smith 586067 586067 Stabill, Richard, of York, smith 0
3600076 1867673 1867673 plaintiff Wharfe Thomas clerk 586067 586067 Wharfe, Thomas, of York, clerk 0
3600086 1867677 1867677 plaintiff Wherfe Thomas clerk 586067 586067 Wherfe, Thomas, of York, clerk 0
3601149 1868023 1868023 defendant Williamson Henry merchant 586067 586067 Williamson, Henry, of York, merchant 0
3601577 1868149 1868149 plaintiff Barker William barker 586067 586067 Barker, William, of York, barker 0
3601979 1868277 1868277 defendant Tatt William draper 586067 586067 Tatt, William, of York, draper 0
3602764 1868531 1868531 defendant Haweselyn Thomas fishmonger 586067 586067 Haweselyn, Thomas, of York, fishmonger 0
3602766 1868531 1868531 defendant Whytehode John dyer 586067 586067 Whytehode, John, of York, dyer 2
3603287 1868701 1868701 plaintiff Danson Alexander (legal representative) 586067 586067 Danson, Alexander, of York, mercer, executors of 0
3603290 1868701 1868701 defendant Gray Ralph mercer 586067 586067 Gray, Ralph, of York, mercer 0
3603535 1868774 1868774 defendant Derby Thomas mercer 586067 586067 Derby, Thomas, of York, mercer 0
3603537 1868775 1868775 defendant Derby Thomas merchant 586067 586067 Derby, Thomas, of York, merchant 0
3603927 1868899 1868899 defendant Blakburn Richard chaplain 586067 586067 Blakburn, Richard, of York, chaplain 0
3605879 1869504 1869504 defendant Clerk William stringer 586067 586067 Clerk, William, of York, stringer 0
3606101 1869577 1869577 plaintiff Marshall William (legal representative) 586067 586067 Marshall, William, of York, merchant, executors of 0
3606103 1869577 1869577 defendant Darby Thomas merchant 586067 586067 Darby, Thomas, of York, merchant 0
3607520 1870010 1870010 defendant Thomson John   586067 586067 Thomson, John, of York, wire drawer 2
3608203 1870222 1870222 defendant Hoton John yeoman 586067 586067 Hoton, John, of York, yeoman 2
3608206 1870223 1870223 defendant Hoton John yeoman 586067 586067 Hoton, John, of York, yeoman 0
3609051 1870488 1870488 defendant Gray Ralph merchant 586067 586067 Gray, Ralph, of York, merchant 0
3609075 1870496 1870496 plaintiff White William   586067 586067 White, William, of York 0
3609077 1870497 1870497 plaintiff White William alderman 586067 586067 White, William, of York, alderman 0
3609078 1870497 1870497 defendant Skipwyth Christopher dyer 586067 586067 Skipwyth, Christopher, of York, dyer 0
3609448 1870620 1870620 plaintiff York Richard   586067 586067 York, Richard, of York, knight 0
3609451 1870621 1870621 plaintiff York Richard   586067 586067 York, Richard, of York, knight 0
3610210 1870858 1870858 defendant Derby Thomas merchant 586067 586067 Derby, Thomas, of York, merchant 0
3610397 1870909 1870909 defendant Kyrke James goldsmith 586067 586067 Kyrke, James, of York, goldsmith 0
3610482 1870941 1870941 defendant Barker William merchant 586067 586067 Barker, William, of York, merchant 0
3610487 1870943 1870943 defendant Godson John chaplain 586067 586067 Godson, John, of York, chaplain 0
3610489 1870944 1870944 defendant Godson John chaplain 586067 586067 Godson, John, of York, chaplain 0
3610550 1870962 1870962 defendant Barker William merchant 586067 586067 Barker, William, of York, merchant 0
3610552 1870963 1870963 defendant Barker William merchant 586067 586067 Barker, William, of York, merchant 0
3610554 1870964 1870964 defendant Machon James spicer 586067 586067 Machon, James, of York, spicer 0
3610556 1870965 1870965 defendant Machon James spicer 586067 586067 Machon, James, of York, spicer 0
3610944 1871095 1871095 defendant Curteys William walker 586067 586067 Curteys, William, of York, walker 0
3612584 1871573 1871573 defendant Hunter Thomas tiler 586067 586067 Hunter, Thomas, of York, tiler 0
3614020 1872043 1872043 defendant Sargeant Thomas draper 586067 586067 Sargeant, Thomas, of York, draper 2
3614041 1872052 1872052 defendant Catour John merchant 586067 586067 Catour, John, of York, merchant 0
3614594 1872213 1872213 defendant Fynche Thomas mercer 586067 586067 Fynche, Thomas, of York, mercer 0
3615323 1872437 1872437 defendant Jakson William merchant 586067 586067 Jakson, William, of York, merchant 0
3615924 1872620 1872620 defendant Gilmyn John butcher 586067 586067 Gilmyn, John, of York, butcher 0
3616108 1872676 1872676 defendant Rawelyn Richard shoemaker 586067 586067 Rawelyn, Richard, of York, shoemaker 0
3617066 1872961 1872961 defendant Neelson William merchant 586067 586067 Neelson, William, of York, merchant 0
3617067 1872961 1872961 defendant Thornton Richard merchant 586067 586067 Thornton, Richard, of York, merchant 1
3617069 1872962 1872962 defendant Neelson William merchant 586067 586067 Neelson, William, of York, merchant 0
3617070 1872962 1872962 defendant Thornton Richard merchant 586067 586067 Thornton, Richard, of York, merchant 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);