names

127 rows where place_id = 586237

✎ 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
3588233 1863974 1863974 defendant Knype John draper 586237 586237 Knype, John, of Daventre, draper 0
3595958 1866366 1866366 defendant Halle Thomas yeoman 586237 586237 Halle, Thomas, of Daventre, yeoman 0
3597984 1866994 1866994 defendant Sizell or Sirell Thomas butcher 586237 586237 Sizell or Sirell, Thomas, of Daventre, butcher 0
3597985 1866994 1866994 defendant Curteys William butcher 586237 586237 Curteys, William, of Daventre, butcher 1
3603514 1868766 1868766 defendant Barby John draper 586237 586237 Barby, John, of Daventre, draper 1
3603596 1868793 1868793 defendant Maydewell Richard husbandman 586237 586237 Maydewell, Richard, of Daventre, husbandman 0
3603597 1868793 1868793 defendant Maydewell William husbandman 586237 586237 Maydewell, William, of Daventre, husbandman 1
3615664 1872544 1872544 defendant Belle William yeoman 586237 586237 Belle, William, of Daventre, yeoman 0
3615665 1872544 1872544 defendant Manne George innholder 586237 586237 Manne, George, of Daventre, innholder 1
3622532 1874584 1874584 defendant Belle William yeoman 586237 586237 Belle, William, of Daventre, yeoman 0
3622533 1874584 1874584 defendant Manne George innholder 586237 586237 Manne, George, of Daventre, innholder 1
3628087 1903639 1903639 defendant Parke William innholder 586237 586237 Parke, William, of Daventre, innholder 0
3653640 1911401 1911401 defendant Baxter John innholder 586237 586237 Baxter, John, of Daventre, innholder 0
3737454 1937953 1937953 defendant Baxter Joan widow 586237 586237 Baxter, Joan, of Daventre, widow 0
3775395 1950047 1950047 defendant Blisse John husbandman 586237 586237 Blisse, John, of Daventre, husbandman 0
3800032 1957935 1957935 defendant Bate Thomas courser 586237 586237 Bate, Thomas, of Daventre, courser 3
3835205 1968949 1968949 defendant Lyon William butcher 586237 586237 Lyon, William, of Daventre, butcher 2
3869007 1979879 1979879 defendant Symmes William innholder 586237 586237 Symmes, William, of Daventre, innholder 0
3881081 1983943 1983943 defendant Browne Robert laborer 586237 586237 Browne, Robert, of Daventre, laborer 0
3884162 1984969 1984969 defendant Pell Edward yeoman 586237 586237 Pell, Edward, of Daventre, yeoman 4
3891197 1987322 1987322 defendant Symmes William yeoman 586237 586237 Symmes, William, of Daventre, yeoman 0
3924066 1998360 1998360 plaintiff Symmys William yeoman 586237 586237 Symmys, William, of Daventre, yeoman 0
3982915 2018668 2018668 defendant Smaulbon Richard glover 586237 586237 Smaulbon, Richard, of Daventre, glover 0
4431352 2174570 2174570 defendant Horn John   586237 586237 Horn, John, of Daventre 0
4437919 2181178 2181178 defendant Wilby John   586237 586237 Wilby, John, of Daventre 0
4439750 2181708 2181708 plaintiff Barkere John   586237 586237 Barkere, John, of Daventre 0
4443004 2182774 2182774 plaintiff Cammpeden Walter   586237 586237 Cammpeden, Walter, of Daventre 0
4443006 2182774 2182774 defendant Plomer Simon   586237 586237 Plomer, Simon, of Daventre 0
4446202 2183723 2183723 defendant Swan John   586237 586237 Swan, John, of Daventre 0
4459334 2187970 2187970 plaintiff Rumylowe Peter   586237 586237 Rumylowe, Peter, of Daventre 0
4462503 2188968 2188968 defendant Neuton Rober de mercer 586237 586237 Neuton, Rober de, of Daventre, mercer 0
4490827 2197830 2197830 plaintiff Waundell John   586237 586237 Waundell, John, of Daventre, on his own account 0
4490828 2197830 2197830 defendant Halle Richard   586237 586237 Halle, Richard, of Daventre 0
4490829 2197830 2197830 defendant Skynner John   586237 586237 Skynner, John, of Daventre 1
4490830 2197830 2197830 defendant Walkere William   586237 586237 Walkere, William, of Daventre 2
4504049 2201817 2201817 plaintiff Pyn Roger   586237 586237 Pyn, Roger, of Daventre 0
4504050 2201817 2201817 defendant Foston William tailor 586237 586237 Foston, William, of Daventre, tailor 0
4678860 2258989 2258989 plaintiff Hykedy Thomas   586237 586237 Hykedy, Thomas, of Daventre 0
4746786 2279560 2279560 plaintiff Horn Simon   586237 586237 Horn, Simon, of Daventre 0
4749136 2280230 2280230 defendant Dillyng John butcher 586237 586237 Dillyng, John, of Daventre, butcher 0
4788263 2292399 2292399 plaintiff Haywode John   586237 586237 Haywode, John, of Daventre 0
4823990 2303577 2303577 defendant Broun John husbandman 586237 586237 Broun, John, of Daventre, husbandman 2
4867846 2316916 2316916 plaintiff Horn Simon   586237 586237 Horn, Simon, of Daventre 0
4878613 2320253 2320253 defendant Graunt Richard gent 586237 586237 Graunt, Richard, of Daventre, gent 1
4878619 2320254 2320254 defendant Graunt Richard gent 586237 586237 Graunt, Richard, of Daventre, gent 1
4882644 2321485 2321485 plaintiff Horn Simon gent 586237 586237 Horn, Simon, of Daventre, gent 0
4885205 2322259 2322259 defendant Cleydon Hugh husbandman 586237 586237 Cleydon, Hugh, of Daventre, husbandman 3
4887332 2322871 2322871 defendant West Nicholas gent 586237 586237 West, Nicholas, of Daventre, gent 0
4900228 2326700 2326700 defendant Boteler Henry weaver 586237 586237 Boteler, Henry, of Daventre, weaver 0
4900229 2326700 2326700 defendant Boteler John weaver 586237 586237 Boteler, John, of Daventre, weaver 1
4900230 2326700 2326700 defendant Boteler William weaver 586237 586237 Boteler, William, of Daventre, weaver 2
4918038 2332158 2332158 defendant Broun John butcher 586237 586237 Broun, John, of Daventre, butcher 2
4918040 2332158 2332158 defendant Frankeleyn John ostler 586237 586237 Frankeleyn, John, of Daventre, ostler 4
4971431 2348383 2348383 defendant Stevenes Richard laborer 586237 586237 Stevenes, Richard, of Daventre, laborer 0
4971432 2348383 2348383 defendant Busshe Richard miller 586237 586237 Busshe, Richard, of Daventre, miller 1
4971433 2348383 2348383 defendant Blount John laborer 586237 586237 Blount, John, of Daventre, laborer 2
4971434 2348383 2348383 defendant Elyman William laborer 586237 586237 Elyman, William, of Daventre, laborer 3
4971435 2348383 2348383 defendant Haukyn Thomas miller 586237 586237 Haukyn, Thomas, of Daventre, miller 4
4971436 2348383 2348383 defendant Wyrall Thomas carpenter 586237 586237 Wyrall, Thomas, of Daventre, carpenter 5
4971437 2348383 2348383 defendant Carpenter Ralph   586237 586237 Carpenter, Ralph, of Daventre, servant 6
4971438 2348383 2348383 defendant Carter John laborer 586237 586237 Carter, John, of Daventre, laborer 7
4971439 2348383 2348383 defendant Baxter John laborer 586237 586237 Baxter, John, of Daventre, laborer 8
4971440 2348383 2348383 defendant Pavy or Pany Thomas currier 586237 586237 Pavy or Pany, Thomas, of Daventre, currier 9
4971441 2348383 2348383 defendant Byry Henry carpenter 586237 586237 Byry, Henry, of Daventre, carpenter 10
5017081 2361891 2361891 defendant Barker John gent 586237 586237 Barker, John, of Daventre, gent 0
5071634 2378010 2378010 defendant Strynger John mercer 586237 586237 Strynger, John, of Daventre, mercer 2
5098850 2386096 2386096 plaintiff Warrour John (legal representative) 586237 586237 Warrour, John, of Daventre, executors of 0
5101243 2386773 2386773 defendant Tewe Thomas courser 586237 586237 Tewe, Thomas, of Daventre, courser 0
5120153 2392330 2392330 defendant Brether Nicholas gent 586237 586237 Brether, Nicholas, of Daventre, gent 0
5120154 2392330 2392330 defendant Scotour John gent 586237 586237 Scotour, John, of Daventre, gent 1
5133996 2396439 2396439 defendant Wyldy William fisher 586237 586237 Wyldy, William, of Daventre, fisher 0
5235219 2425879 2425879 defendant Scoter John yeoman 586237 586237 Scoter, John, of Daventre, yeoman 0
5236168 2426166 2426166 plaintiff Dyry Richard chapman 586237 586237 Dyry, Richard, of Daventre, chapman 0
5251135 2430459 2430459 defendant Axbrigge William glover 586237 586237 Axbrigge, William, of Daventre, glover 0
5252532 2430904 2430904 defendant Santer or Sauter William gent 586237 586237 Santer or Sauter, William, of Daventre, gent 0
5253409 2431168 2431168 defendant Randull Thomas, senior butcher 586237 586237 Randull, Thomas, senior, of Daventre, butcher 0
5253412 2431169 2431169 defendant Randull Thomas, senior butcher 586237 586237 Randull, Thomas, senior, of Daventre, butcher 0
5253823 2431311 2431311 defendant Curteys John chaplain 586237 586237 Curteys, John, of Daventre, chaplain 0
5257712 2432531 2432531 defendant Yonge John elyman or laborer 586237 586237 Yonge, John, of Daventre, elyman or laborer 0
5264078 2434524 2434524 defendant Fyssher Thomas chaplain 586237 586237 Fyssher, Thomas, of Daventre, chaplain 0
5267775 2435681 2435681 plaintiff Yonge John   586237 586237 Yonge, John, of Daventre 0
5267776 2435681 2435681 defendant Fyssher John laborer 586237 586237 Fyssher, John, of Daventre, laborer 0
5267777 2435682 2435682 plaintiff Yonge John   586237 586237 Yonge, John, of Daventre 0
5267778 2435682 2435682 defendant Fyssher John laborer or "elyman" 586237 586237 Fyssher, John, of Daventre, laborer or "elyman" 0
5279953 2439210 2439210 defendant Bayle William gent 586237 586237 Bayle, William, of Daventre, gent 0
5279954 2439210 2439210 defendant Sharpe Thomas tailor 586237 586237 Sharpe, Thomas, of Daventre, tailor 1
5279955 2439210 2439210 defendant Braunden William husbandman 586237 586237 Braunden, William, of Daventre, husbandman 2
5280320 2439323 2439323 defendant Bayle William gent 586237 586237 Bayle, William, of Daventre, gent 0
5280321 2439323 2439323 defendant Sharpe Thomas tailor 586237 586237 Sharpe, Thomas, of Daventre, tailor 1
5280322 2439323 2439323 defendant Braunden William husbandman 586237 586237 Braunden, William, of Daventre, husbandman 2
5292823 2442893 2442893 defendant Randell John butcher 586237 586237 Randell, John, of Daventre, butcher 2
5294183 2443271 2443271 defendant Melton Maud widow 586237 586237 Melton, Maud, of Daventre, widow 1
5294184 2443272 2443272 plaintiff Staverton William   586237 586237 Staverton, William, of Daventre 0
5312140 2448664 2448664 defendant Fynoll William chapman 586237 586237 Fynoll, William, of Daventre, chapman 1
5318510 2450633 2450633 defendant Bolle Thomas butcher 586237 586237 (Bolle, Thomas, of Daventre, butcher 1
5318511 2450633 2450633 defendant Newell William spicer 586237 586237 Newell, William, of Daventre, spicer 2
5337323 2456234 2456234 plaintiff Horne John esq 586237 586237 Horne, John, of Daventre, esq 0
5339336 2456877 2456877 defendant Whelpdale Ralph ostler 586237 586237 Whelpdale, Ralph, of Daventre, ostler 5
5339337 2456877 2456877 defendant Smyth William smith 586237 586237 Smyth, William, of Daventre, smith 6
5353896 2461282 2461282 defendant Watford Thomas gent 586237 586237 Watford, Thomas, of Daventre, gent 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);