names

95 rows where place_id = 591805

✎ 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
3605642 1869430 1869430 defendant Walle William yeoman 591805 591805 Walle, William, of Otley, yeoman 0
3605646 1869431 1869431 defendant Walle William yeoman 591805 591805 Walle, William, of Otley, yeoman 0
3619099 1873575 1873575 defendant Donwell Richard weaver 591805 591805 Donwell, Richard, of Otley, weaver 0
3619101 1873576 1873576 defendant Michell William weaver 591805 591805 Michell, William, of Otley, weaver 0
3636700 1906271 1906271 defendant Brett John husbandman 591805 591805 Brett, John, of Otley, husbandman 0
3637487 1906534 1906534 defendant Goodwyn William husbandman 591805 591805 Goodwyn, William, of Otley, husbandman 2
3637488 1906534 1906534 defendant Bonde Robert laborer 591805 591805 Bonde, Robert, of Otley, laborer 3
3638236 1906779 1906779 defendant Abbot Thomas clerk 591805 591805 Abbot, Thomas, of Otley, clerk 0
3645317 1908945 1908945 plaintiff Gosnold John (legal representative) 591805 591805 Gosnold, John, of Otley, executors of 0
3660229 1913461 1913461 plaintiff Hayll John (legal representative) 591805 591805 Hayll, John, of Otley, administrator of 0
3673758 1917819 1917819 defendant Gosnold Robert yeoman 591805 591805 Gosnold, Robert, of Otley, yeoman 1
3698874 1925863 1925863 defendant Morse John yeoman 591805 591805 Morse, John, of Otley, yeoman 0
3737179 1937859 1937859 defendant Huchonson Henry clerk 591805 591805 Huchonson, Henry, of Otley, clerk 0
3737181 1937860 1937860 defendant Raulynson Thomas yeoman 591805 591805 Raulynson, Thomas, of Otley, yeoman 0
3798091 1957300 1957300 defendant Calverley Robert gent 591805 591805 Calverley, Robert, of Otley, gent 0
3971901 2014732 2014732 defendant Lofthowse George clothier 591805 591805 Lofthowse, George, of Otley, clothier 0
3972607 2014996 2014996 defendant Atkynson John tanner 591805 591805 Atkynson, John, of Otley, tanner 0
3999802 2024691 2024691 defendant Steade William yeoman 591805 591805 Steade, William, of Otley, yeoman 0
4033194 2036524 2036524 plaintiff Gosnold William gent 591805 591805 Gosnold, William, of Otley, gent 0
4036153 2037614 2037614 plaintiff Hosnold William gent 591805 591805 Hosnold, William, of Otley, gent 0
4064291 2047505 2047505 defendant Yngold Robert yeoman 591805 591805 Yngold, Robert, of Otley, yeoman 0
4077060 2052082 2052082 plaintiff Smythe John yeoman 591805 591805 Smythe, John, of Otley, ,yeoman 0
4094864 2058496 2058496 defendant Steade William cordwainer 591805 591805 Steade, William, of Otley, cordwainer 0
4100712 2060574 2060574 defendant Warde Anthony smith 591805 591805 Warde, Anthony, of Otley, smith 0
4137127 2073628 2073628 defendant West John laborer 591805 591805 West, John, of Otley, laborer 0
4161521 2082103 2082103 defendant West John laborer 591805 591805 West, John, of Otley, laborer 0
4171695 2085566 2085566 defendant Parker Henry merchant 591805 591805 Parker, Henry, of Otley, merchant 0
4177053 2087448 2087448 defendant Schacker Robert laborer 591805 591805 Schacker, Robert, of Otley, laborer 0
4178253 2087866 2087866 defendant Rogerson alias Weste William clothier 591805 591805 Rogerson alias Weste, William, of Otley, clothier 0
4178254 2087866 2087866 defendant West John clothier 591805 591805 West, John, of Otley, clothier 1
4215376 2100875 2100875 defendant Cave Christopher yeoman 591805 591805 Cave, Christopher, of Otley, yeoman 1
4240356 2109750 2109750 defendant Flower Thomas carpenter 591805 591805 Flower, Thomas, of Otley, carpenter 3
4254008 2114339 2114339 defendant Mason William (legal representative) 591805 591805 Mason, William, of Otley, clerk, executrix of 3
4254009 2114339 2114339 defendant Mason Alice widow 591805 591805 Mason, Alice, of Otley, widow 4
4279540 2122762 2122762 defendant Wythe Robert yeoman 591805 591805 Wythe, Robert, of Otley, yeoman 3
4280462 2123074 2123074 defendant Yong John cooper 591805 591805 Yong, John, of Otley, cooper 1
4326636 2139268 2139268 defendant Dymer Thomas yeoman 591805 591805 Dymer, Thomas, of Otley, or of Hollesley, yeoman 0
4333060 2141344 2141344 defendant Russell Thomas tailor 591805 591805 Russell, Thomas, of Otley, tailor 2
4345291 2145629 2145629 defendant Sikes James yeoman 591805 591805 Sikes, James, of Otley, yeoman 1
4376842 2156788 2156788 defendant Dickenson Mathew gent 591805 591805 Dickenson, Mathew, of Otley, gent 0
4392898 2162236 2162236 defendant Warde Anthony, senior yeoman 591805 591805 Warde, Anthony, senior, of Otley, yeoman 0
4392899 2162236 2162236 defendant Statchard William yeoman 591805 591805 Statchard, William, of Otley, yeoman 1
4396812 2163502 2163502 defendant West William yeoman 591805 591805 West, William, of Otley, yeoman 0
4396813 2163502 2163502 defendant Sikes James yeoman 591805 591805 Sikes, James, of Otley, yeoman 1
4396814 2163502 2163502 defendant Wilson George yeoman 591805 591805 Wilson, George, of Otley, yeoman 2
4529968 2209665 2209665 defendant Pek Richard   591805 591805 Pek, Richard, of Otley 0
4717295 2270740 2270740 defendant Pykerd Hugh   591805 591805 Pykerd, Hugh, of Otley, corsour 0
4874629 2319008 2319008 defendant Otley Adam yeoman 591805 591805 Otley, Adam, of Otley, yeoman 3
4936110 2337693 2337693 plaintiff Boleyn John   591805 591805 Boleyn, John, of Otley 0
4946368 2340854 2340854 defendant Bekwyth Richard husbandman 591805 591805 Bekwyth, Richard, of Otley, husbandman 0
4946369 2340854 2340854 defendant Marchall Richard smith 591805 591805 Marchall, Richard, of Otley, smith 1
4946371 2340855 2340855 defendant Bekwyth Richard husbandman 591805 591805 Bekwyth, Richard, of Otley, husbandman 0
4946372 2340855 2340855 defendant Marchall Richard smith 591805 591805 Marchall, Richard, of Otley, smith 1
4987549 2353231 2353231 defendant Kyghley Hugh yeoman 591805 591805 Kyghley, Hugh, of Otley, yeoman 3
5013865 2360907 2360907 defendant Colyngworth Thomas cordwainer 591805 591805 Colyngworth, Thomas, of Otley, cordwainer 1
5115754 2391037 2391037 defendant Gerlyng John yeoman 591805 591805 Gerlyng, John, of Otley, yeoman 0
5132882 2396110 2396110 defendant Rodes William yeoman 591805 591805 Rodes, William, of Otley, yeoman 6
5132883 2396110 2396110 defendant Cranyn Thomas yeoman 591805 591805 Cranyn, Thomas, of Otley, yeoman 7
5139480 2398032 2398032 defendant Goldsmyth John yeoman 591805 591805 Goldsmyth, John, of Otley, yeoman 1
5160474 2404152 2404152 defendant Goldsmyth John yeoman 591805 591805 Goldsmyth, John, of Otley, yeoman 0
5183520 2410914 2410914 defendant Goldsmyth John husbandman 591805 591805 Goldsmyth, John, of Otley, husbandman 3
5203905 2416892 2416892 defendant Goldsmith John husbandman 591805 591805 Goldsmith, John, of Otley, husbandman 3
5266559 2435291 2435291 defendant Goldsmyth John yeoman 591805 591805 Goldsmyth, John, of Otley, yeoman 0
5273978 2437467 2437467 defendant Shepard William yeoman 591805 591805 Shepard, William, of Otley, yeoman 2
5318794 2450711 2450711 defendant Armygeard William husbandman 591805 591805 Armygeard, William, of Otley, husbandman 1
5332458 2454774 2454774 defendant Broun alias Ferour Richard husbandman or glasswright 591805 591805 Broun alias Ferour, Richard, of Otley, husbandman or glasswright 0
5334614 2455420 2455420 defendant Baildon John gent 591805 591805 Baildon, John, of Otley, gent 1
5338572 2456634 2456634 defendant Armigeard John, senior husbandman 591805 591805 Armigeard, John, senior, of Otley, husbandman 2
5348488 2459668 2459668 defendant Oby or Ovy Richard yeoman 591805 591805 Oby or Ovy, Richard, of Otley, yeoman 0
5348491 2459669 2459669 defendant Ovy Richard yeoman 591805 591805 Ovy, Richard, of Otley, yeoman 0
5356824 2462198 2462198 defendant Mors John yeoman 591805 591805 Mors, John, of Otley, yeoman 4
5358521 2462724 2462724 defendant Ovy Richard yeoman 591805 591805 Ovy, Richard, of Otley, yeoman 0
5387170 2471399 2471399 defendant Grene John yeoman 591805 591805 Grene, John, of Otley, yeoman 0
5399611 2474971 2474971 defendant Grene John yeoman 591805 591805 Grene, John, of Otley, yeoman 0
5403451 2476059 2476059 defendant Broun Richard yeoman 591805 591805 Broun, Richard, of Otley, yeoman 4
5412619 2478720 2478720 defendant Grene John yeoman 591805 591805 Grene, John, of Otley, yeoman 0
5416522 2479858 2479858 defendant Broun Richard yeoman 591805 591805 Broun, Richard, of Otley, yeoman 4
5421508 2481364 2481364 defendant Broun Richard yeoman 591805 591805 Broun, Richard, of Otley, yeoman 1
5427490 2483172 2483172 defendant Grene John yeoman 591805 591805 Grene, John, of Otley, yeoman 0
5433412 2484950 2484950 defendant Broun Richard yeoman 591805 591805 Broun, Richard, of Otley, yeoman 3
5451569 2490344 2490344 defendant Scalwray Robert yeoman 591805 591805 Scalwray, Robert, of Otley, yeoman 3
5462030 2493538 2493538 defendant Wysdam William husbandman 591805 591805 Wysdam, William, of Otley, husbandman 6
5463566 2494018 2494018 defendant Scalwray Robert yeoman 591805 591805 Scalwray, Robert, of Otley, yeoman 3
5475121 2497546 2497546 defendant Scalwray Robert yeoman 591805 591805 Scalwray, Robert, of Otley, yeoman 3
5496739 2503946 2503946 defendant Skanwrey Robert yeoman 591805 591805 Skanwrey, Robert, of Otley, yeoman 0
5502191 2505612 2505612 defendant Wysdam William husbandman 591805 591805 Wysdam, William, of Otley, husbandman 1
5502748 2505774 2505774 defendant Ingland Robert yeoman 591805 591805 Ingland, Robert, of Otley, yeoman 0
5502749 2505774 2505774 defendant Crokebayn Richard yeoman 591805 591805 Crokebayn, Richard, of Otley, yeoman 1
5502750 2505774 2505774 defendant Craven William yeoman 591805 591805 Craven, William, of Otley, yeoman 2
5508656 2507571 2507571 defendant Wysdam William yeoman 591805 591805 Wysdam, William, of Otley, yeoman 1
5508662 2507572 2507572 defendant Ony or Ovy Richard yeoman 591805 591805 Ony or Ovy, Richard, of Otley, yeoman 2
5512721 2508835 2508835 defendant Scalwra Robert laborer 591805 591805 Scalwra, Robert, of Otley, laborer 0
5512723 2508835 2508835 defendant Broun Richard laborer 591805 591805 Broun, Richard, of Otley, laborer 2
5569030 2525491 2525491 defendant Walker Margaret spinster 591805 591805 Walker, Margaret, of Otley, spinster 4
5569042 2525494 2525494 defendant Walker Margaret spinster 591805 591805 Walker, Margaret, of Otley, spinster 4

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