names

204 rows where place_id = 586593

✎ 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
3589118 1864244 1864244 defendant Melborne Henry barber 586593 586593 Melborne, Henry, of Est Retford, barber 0
3603618 1868799 1868799 defendant Rudde John barber 586593 586593 Rudde, John, of Est Retford, barber 0
3605695 1869446 1869446 plaintiff Langwath Hugh (legal representative) 586593 586593 Langwath, Hugh, of Est Retford, administrator of 0
3605700 1869447 1869447 plaintiff Langweth Hugh (legal representative) 586593 586593 Langweth, Hugh, of Est Retford, administrator of 0
3609134 1870514 1870514 plaintiff Wilkynson Richard dyer 586593 586593 Wilkynson, Richard, of Est Retford, dyer 0
3613417 1871844 1871844 defendant Mosse Robert baker 586593 586593 Mosse, Robert, of Est Retford, baker 1
3613418 1871844 1871844 defendant Depyng William barker 586593 586593 Depyng, William, of Est Retford, barker 2
3615143 1872382 1872382 defendant Holbeche Richard cooper 586593 586593 Holbeche, Richard, of Est Retford, cooper 0
3619764 1873755 1873755 defendant Malyn John husbandman 586593 586593 Malyn, John, of Est Retford, husbandman 1
3619767 1873756 1873756 defendant Malyn John husbandman 586593 586593 Malyn, John, of Est Retford, husbandman 0
3619769 1873757 1873757 defendant Malyn John husbandman 586593 586593 Malyn, John, of Est Retford, husbandman 0
3636731 1906281 1906281 defendant Depyng Joan widow 586593 586593 Depyng, Joan, of Est Retford, widow 0
3689789 1922962 1922962 defendant Hamerton James fisher 586593 586593 Hamerton, James, of Est Retford, fisher 0
3711475 1929896 1929896 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 0
3712271 1930151 1930151 defendant Sturton William yeoman 586593 586593 Sturton, William, of Est Retford, yeoman 1
3727425 1934850 1934850 defendant Hamerton Hugh fisher 586593 586593 Hamerton, Hugh, of Est Retford, fisher 0
3731128 1935962 1935962 defendant Denman Nicholas gent 586593 586593 Denman, Nicholas, of Est Retford, gent 0
3741877 1939324 1939324 defendant Bowle Thomas mercer 586593 586593 Bowle, Thomas, of Est Retford, mercer 1
3741878 1939324 1939324 defendant Ludyngton John mercer 586593 586593 Ludyngton, John, of Est Retford, mercer 2
3743083 1939688 1939688 defendant Goldyng William butcher 586593 586593 Goldyng, William, of Est Retford, butcher 2
3752842 1942813 1942813 plaintiff Rossell William (legal representative) 586593 586593 Rossell, William, of Est Retford, executors of 0
3755192 1943574 1943574 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 3
3755193 1943574 1943574 defendant Marshall Robert husbandman 586593 586593 Marshall, Robert, of Est Retford, husbandman 4
3755864 1943786 1943786 defendant Hamerton James fisher 586593 586593 Hamerton, James, of Est Retford, fisher 0
3781882 1952079 1952079 defendant Feynton Ralph yeoman 586593 586593 Feynton, Ralph, of Est Retford, yeoman 0
3781884 1952080 1952080 defendant Feynton Ralph yeoman 586593 586593 Feynton, Ralph, of Est Retford, yeoman 0
3785318 1953195 1953195 defendant Denman William barber 586593 586593 Denman, William, of Est Retford, barber 0
3789341 1954487 1954487 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 0
3799213 1957665 1957665 defendant Stubbyng Thomas mercer 586593 586593 Stubbyng, Thomas, of Est Retford, mercer 0
3806680 1959988 1959988 defendant Blowmer John miller 586593 586593 Blowmer, John, of Est Retford, miller 0
3806681 1959988 1959988 defendant Sampson Edmund sherman 586593 586593 Sampson, Edmund, of Est Retford, sherman 1
3806686 1959989 1959989 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 2
3839528 1970289 1970289 defendant Womoke Robert butcher 586593 586593 Womoke, Robert, of Est Retford, butcher 0
3839529 1970289 1970289 defendant Womoke John butcher 586593 586593 Womoke, John, of Est Retford, butcher 1
3871185 1980616 1980616 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 0
3889140 1986603 1986603 defendant Womocke Thomas butcher 586593 586593 Womocke, Thomas, of Est Retford, butcher 3
3895895 1988835 1988835 plaintiff Swyft Alexander merchant 586593 586593 Swyft, Alexander, of Est Retford, merchant 0
3896205 1988935 1988935 defendant Gedlyng William butcher 586593 586593 Gedlyng, William, of Est Retford, butcher 0
3913040 1994691 1994691 defendant Eton William baker 586593 586593 Eton, William, of Est Retford, baker 3
3916268 1995826 1995826 defendant Wryght John laborer 586593 586593 Wryght, John, of Est Retford, laborer 0
3916377 1995859 1995859 defendant Shepard William butcher 586593 586593 Shepard, William, of Est Retford, butcher 2
3918568 1996536 1996536 defendant Warandyne John laborer 586593 586593 Warandyne, John, of Est Retford, laborer 0
3924019 1998343 1998343 plaintiff Swyft Alexander merchant 586593 586593 Swyft, Alexander, of Est Retford, merchant 0
3931341 2000777 2000777 plaintiff Denman Nicholas (legal representative) 586593 586593 Denman, Nicholas, of East Retford, esq, executors of 0
3942556 2004520 2004520 defendant Holmer Thomas yeoman 586593 586593 Holmer, Thomas, of East Retford, yeoman 1
3958541 2010056 2010056 defendant Rossell William   586593 586593 Rossell, William, of Est Retford, tanner, his servant 1
3958544 2010057 2010057 defendant Rossell William tanner 586593 586593 Rossell, William, of Est Retford, tanner 1
3958546 2010058 2010058 defendant Rossell William tanner 586593 586593 Rossell, William, of Est Retford, tanner 0
4047031 2041387 2041387 defendant Balie William smith 586593 586593 Balie, William, of East Retford, smith 1
4047033 2041388 2041388 defendant Peele Oliver tanner 586593 586593 Peele, Oliver, of Est Retford, tanner 0
4103629 2061579 2061579 defendant Barnesley William gent 586593 586593 Barnesley, William, of Est Retford, gent 0
4103646 2061584 2061584 defendant Burrell James   586593 586593 Burrell, James, of Est Retford, brick maker 1
4103647 2061584 2061584 defendant Beliald William yeoman 586593 586593 Beliald, William, of Est Retford, yeoman 2
4156550 2080366 2080366 defendant Barnesley William gent 586593 586593 Barnesley, William, of East Retford, gent 0
4156554 2080367 2080367 defendant Barnesley William gent 586593 586593 Barnesley, William, of Est Retford, gent 0
4180992 2088830 2088830 defendant Rossell Nicholas gent 586593 586593 Rossell, Nicholas, of East Retford, gent 0
4220962 2102825 2102825 defendant Bellome William gent 586593 586593 Bellome, William, of Est Retford, gent 0
4229724 2105876 2105876 defendant Beldome William gent 586593 586593 Beldome, William, of Est Retford, gent 0
4277519 2122060 2122060 defendant Palmer William yeoman 586593 586593 Palmer, William, of East Retford, yeoman 0
4280992 2123254 2123254 defendant Barnesley William gent 586593 586593 Barnesley, William, of East Retford, gent 0
4280994 2123254 2123254 defendant Crock or Crook Thomas cintner 586593 586593 Crock or Crook, Thomas, of East Retford, cintner 2
4315832 2135645 2135645 defendant Beldam William (legal representative) 586593 586593 Beldam, William, of East Retford, gent, administratrix of 2
4364329 2152303 2152303 defendant Denyson Thomas kaborer 586593 586593 Denyson, Thomas, of Est Retford, kaborer 2
4365614 2152765 2152765 defendant Belield Mark yeoman 586593 586593 Belield, Mark, of East Retford, yeoman 1
4400133 2164635 2164635 defendant Fletcher George mercer 586593 586593 Fletcher, George, of East retford, mercer 1
4470701 2191483 2191483 defendant Manton John de   586593 586593 Manton, John de, of East Retford 0
4491579 2198050 2198050 defendant Barker William   586593 586593 Barker, William, of East Retford 1
4507421 2202786 2202786 defendant Kelby William de   586593 586593 Kelby, William de, of East Retford 0
4534961 2211214 2211214 defendant Cave Robert   586593 586593 Cave, Robert, of East Retford, vicar 1
4564737 2220535 2220535 defendant Wadster Henry   586593 586593 Wadster, Henry, of East Retford 0
4627018 2239400 2239400 defendant Smyth John   586593 586593 Smyth, John, of East Retford, son of Henry 0
4679422 2259181 2259181 plaintiff Kendall John   586593 586593 Kendall, John, of East Retford 0
4700113 2265456 2265456 defendant Smyth William smith 586593 586593 Smyth, William, of East Retford, smith 2
4753683 2281525 2281525 defendant Milner John milner 586593 586593 Milner, John, of East Retford, milner 1
4819879 2302292 2302292 defendant Wyeston Nicholas yeoman 586593 586593 Wyeston, Nicholas, of East Retford, yeoman 0
4826328 2304271 2304271 defendant Bocher John John butcher 586593 586593 Bocher, John John, of Est Retford, butcher 0
4842730 2309264 2309264 plaintiff Lorde William butcher 586593 586593 Lorde, William, of East Retford, butcher 0
4922526 2333460 2333460 defendant Pycher John glover 586593 586593 Pycher, John, of East Retford, glover 0
4922527 2333460 2333460 defendant Harwod Robert yeoman 586593 586593 Harwod, Robert, of East Retford, yeoman 1
4922528 2333461 2333461 plaintiff Lord William butcher 586593 586593 Lord, William, of East Retford, butcher 0
4944369 2340215 2340215 defendant Statha William saddler 586593 586593 Statha, William, of Est Retford, saddler 0
4947660 2341257 2341257 defendant Bawetre John butcher 586593 586593 Bawetre, John, of Est Retford, butcher 0
4947666 2341259 2341259 defendant Sutton John goldsmith 586593 586593 Sutton, John, of Est Retford, goldsmith 0
4947672 2341260 2341260 defendant Fraunceys John miller 586593 586593 Fraunceys, John, of Est Retford, miller 0
4947676 2341261 2341261 plaintiff Lord William   586593 586593 Lord, William, of Est Retford 0
4947677 2341261 2341261 defendant Cutteler John husbandman 586593 586593 Cutteler, John, of Est Retford, husbandman 0
4947681 2341262 2341262 plaintiff Lord William   586593 586593 Lord, William, of Est Retford 0
4947687 2341263 2341263 plaintiff Lord William   586593 586593 Lord, William, of Est Retford 0
4947690 2341264 2341264 plaintiff Lord William   586593 586593 Lord, William, of Est Retford 0
4947694 2341265 2341265 plaintiff Lord William   586593 586593 Lord, William, of Est Retford 0
4947699 2341266 2341266 plaintiff Lord William butcher 586593 586593 Lord, William, of Est Retford, butcher 0
4947700 2341266 2341266 defendant Hillom Richard   586593 586593 Hillom, Richard, of Est Retford, servant 0
4947703 2341267 2341267 plaintiff Lord William butcher 586593 586593 Lord, William, of Est Retford, butcher 0
4947704 2341267 2341267 defendant Hilom Richard   586593 586593 Hilom, Richard, of Est Retford, servant 0
4953807 2343098 2343098 defendant Fraunceys John miller 586593 586593 Fraunceys, John, of Est Retford, miller 2
4961619 2345439 2345439 defendant Lord William butcher 586593 586593 Lord, William, of Est Retford, butcher 0
4967915 2347347 2347347 plaintiff Vicars John   586593 586593 Vicars, John, of Est Retford 1
4973533 2349033 2349033 defendant Bryg William cordwainer 586593 586593 Bryg, William, of Est Retford, cordwainer 0
4973537 2349034 2349034 defendant Donyngton Richard baker 586593 586593 Donyngton, Richard, of Est Retford, baker 2
4973538 2349034 2349034 defendant Bantre John butcher 586593 586593 Bantre, John, of Est Retford, butcher 3

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