names

229 rows where place_id = 586784

✎ 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
3589613 1864392 1864392 defendant Kerre William husbandman 586784 586784 Kerre, William, of Burgh, husbandman 1
3609509 1870632 1870632 defendant Slak Richard husbandman 586784 586784 Slak, Richard, of Burgh, husbandman 16
3609510 1870632 1870632 defendant Marshall Nicholas husbandman 586784 586784 Marshall, Nicholas, of Burgh, husbandman 17
3609511 1870632 1870632 defendant Toftes Robert miller 586784 586784 Toftes, Robert, of Burgh, miller 18
3644493 1908695 1908695 defendant Blakeborne James yeoman 586784 586784 Blakeborne, James, of Burgh, yeoman 1
3689051 1922737 1922737 defendant Wryght Robert yeoman 586784 586784 Wryght, Robert, of Burgh, yeoman 2
3720916 1932837 1932837 defendant Webster John husbandman 586784 586784 Webster, John, of Burgh, husbandman 1
3764036 1946397 1946397 defendant Whitlok Thomas husbandman 586784 586784 Whitlok, Thomas, of Burgh, husbandman 0
3764037 1946397 1946397 defendant London John husbandman 586784 586784 London, John, of Burgh, husbandman 1
3772127 1948975 1948975 defendant Clerke Thomas husbandman 586784 586784 Clerke, Thomas, of Burgh, husbandman 0
3772128 1948975 1948975 defendant Averell John laborer 586784 586784 Averell, John, of Burgh, laborer 1
3772130 1948975 1948975 defendant Baker Peter husbandman 586784 586784 Baker, Peter, of Burgh, husbandman 3
3772189 1948989 1948989 defendant Arnold John husbandman 586784 586784 Arnold, John, of Burgh, husbandman 3
3772190 1948989 1948989 defendant Codde Thomas husbandman 586784 586784 Codde, Thomas, of Burgh, husbandman 4
3772194 1948989 1948989 defendant Jury John husbandman 586784 586784 Jury, John, of Burgh, husbandman 8
3789006 1954373 1954373 defendant Belle John husbandman 586784 586784 Belle, John, of Burgh, husbandman 0
3789007 1954373 1954373 defendant London John husbandman 586784 586784 London, John, of Burgh, husbandman 1
3827336 1966414 1966414 plaintiff Burgh Thomas   586784 586784 Burgh, Thomas, of Burgh, knight 2
3866183 1978917 1978917 defendant Metcalfe John yeoman 586784 586784 Metcalfe, John, of Burgh, yeoman 4
3883641 1984797 1984797 defendant Everard William husbandman 586784 586784 Everard, William, of Burgh, husbandman 0
3883642 1984797 1984797 defendant Everard Richard husbandman 586784 586784 Everard, Richard, of Burgh, husbandman 1
3885569 1985427 1985427 defendant Gyrlyng William husbandman 586784 586784 Gyrlyng, William, of Burgh, husbandman 0
4014331 2029849 2029849 defendant Evererd Henry yeoman 586784 586784 Evererd, Henry, of Burgh, yeoman 7
4095201 2058607 2058607 defendant Pawlynge George carpenter 586784 586784 Pawlynge, George, of Burgh, carpenter 0
4098896 2059933 2059933 defendant Tylles William yeoman 586784 586784 Tylles, William, of Burgh, yeoman 1
4205134 2097342 2097342 defendant Smythe John yeoman 586784 586784 Smythe, John, of Burgh, yeoman 0
4315837 2135646 2135646 defendant Wale Agnes widow 586784 586784 Wale, Agnes, of Burgh, widow 2
4335206 2142050 2142050 defendant Lawes Edward   586784 586784 Lawes, Edward, of Burgh, worsted weaver 1
4414146 2169329 2169329 defendant Bretoun Thomas   586784 586784 Bretoun, Thomas, of Burgh 0
4418429 2170640 2170640 plaintiff Whaytecroft William de   586784 586784 Whaytecroft, William de, of Burgh 0
4419928 2171135 2171135 defendant Bernak William   586784 586784 Bernak, William, of Burgh 0
4431791 2174718 2174718 defendant Stokton Lawrence de   586784 586784 Stokton, Lawrence de, of Burgh 0
4431792 2174718 2174718 defendant Robert-servant William   586784 586784 Robert-servant, William, of Burgh 1
4431794 2174719 2174719 defendant Stotton Robert de   586784 586784 Stotton, Robert de, of Burgh 0
4432258 2174871 2174871 defendant Bretoun Thomas   586784 586784 Bretoun, Thomas, of Burgh 0
4457572 2187380 2187380 plaintiff Petyclerk Walter   586784 586784 Petyclerk, Walter, of Burgh 0
4457715 2187424 2187424 defendant Emson John   586784 586784 Emson, John, of burgh 0
4458512 2187710 2187710 defendant Aleyn William   586784 586784 Aleyn, William, of Burgh 0
4460852 2188458 2188458 plaintiff Smyth William   586784 586784 Smyth, William, of Burgh 0
4462514 2188972 2188972 plaintiff Talbot Richard   586784 586784 Talbot, Richard, of Burgh 0
4466498 2190194 2190194 defendant Dobson Robert   586784 586784 Dobson, Robert, of Burgh 0
4466978 2190343 2190343 plaintiff Athelard John   586784 586784 Athelard, John, of Burgh, parson, on his own account 0
4468543 2190829 2190829 defendant Donald Norman servant of Thomas 586784 586784 Donald, Norman servant of Thomas, of burgh 1
4468683 2190880 2190880 defendant Spelkys Robert   586784 586784 Spelkys, Robert, of Burgh 0
4479960 2194396 2194396 defendant Draper William   586784 586784 Draper, William, of Burgh 1
4480171 2194457 2194457 plaintiff Knout Simon   586784 586784 Knout, Simon, of Burgh 0
4483681 2195588 2195588 defendant Ladde William   586784 586784 Ladde, William, of Burgh 1
4487680 2196863 2196863 defendant Leche William   586784 586784 Leche, William, of Burgh 0
4488334 2197069 2197069 defendant Whetcroft Richard   586784 586784 Whetcroft, Richard, of Burgh 2
4488370 2197079 2197079 defendant Smyth William   586784 586784 Smyth, William, of Burgh 2
4494666 2199024 2199024 defendant Tylford John   586784 586784 Tylford, John, of Burgh 0
4500865 2200891 2200891 defendant Rychecokes Thomas   586784 586784 Rychecokes, Thomas, of Burgh 1
4507653 2202856 2202856 defendant atte Neudyke Simon   586784 586784 atte Neudyke, Simon, of Burgh 0
4507655 2202856 2202856 defendant Munby John de   586784 586784 Munby, John de, of Burgh 2
4507658 2202857 2202857 defendant White Richard   586784 586784 White, Richard, of Burgh 0
4508473 2203130 2203130 defendant Ledall William de   586784 586784 Ledall, William de, of Burgh 0
4510816 2203840 2203840 defendant Rychecok Richard   586784 586784 Rychecok, Richard, of Burgh 3
4517614 2205901 2205901 defendant Leche William   586784 586784 Leche, William, of Burgh 4
4544496 2214193 2214193 defendant Gase James   586784 586784 Gase, James, of Burgh 0
4546874 2214952 2214952 defendant Yong Robert   586784 586784 Yong, Robert, of Burgh 0
4551608 2216447 2216447 plaintiff Dynys Robert   586784 586784 Dynys, Robert, of Burgh 0
4551610 2216448 2216448 plaintiff Dynys Robert   586784 586784 Dynys, Robert, of Burgh 0
4551871 2216532 2216532 defendant Calflete Alan   586784 586784 Calflete, Alan, of Burgh, vicar 0
4551905 2216545 2216545 defendant Calflete Alan   586784 586784 Calflete, Alan, of Burgh, vicar 0
4575308 2223788 2223788 defendant Willes Richard   586784 586784 Willes, Richard, of Burgh 9
4575741 2223923 2223923 defendant Bryt Randolf chaplain 586784 586784 Bryt, Randolf, of Burgh, chaplain 0
4581180 2225595 2225595 defendant Dynys Robert   586784 586784 Dynys, Robert, of Burgh 0
4581668 2225713 2225713 plaintiff Dymsse Robert   586784 586784 Dymsse, Robert, of Burgh 0
4581740 2225729 2225729 plaintiff Dynysse Robert   586784 586784 Dynysse, Robert, of Burgh 0
4605449 2232838 2232838 defendant Roworth Thomas de   586784 586784 Roworth, Thomas de, of Burgh 42
4608533 2233776 2233776 defendant Symson Robert   586784 586784 Symson, Robert, of Burgh under Stanmore 0
4618415 2236770 2236770 defendant Hugon John   586784 586784 Hugon, John, of Burgh, vicar 0
4618416 2236770 2236770 defendant Clerk Richard   586784 586784 Clerk, Richard, of Burgh 1
4618418 2236770 2236770 defendant Lecheman John   586784 586784 Lecheman, John, of Burgh 3
4629483 2240149 2240149 defendant Dobynson Thomas   586784 586784 Dobynson, Thomas, of Burgh 0
4631393 2240709 2240709 defendant Clerk Richard chaplain 586784 586784 Clerk, Richard, of Burgh, chaplain 1
4631774 2240818 2240818 defendant Clerk Robert   586784 586784 Clerk, Robert, of Burgh 1
4634764 2241723 2241723 defendant Clerk Robert   586784 586784 Clerk, Robert, of Burgh 0
4638944 2242913 2242913 defendant Harper John   586784 586784 Harper, John, of Burgh 0
4640951 2243451 2243451 defendant Crouder William   586784 586784 Crouder, William, of Burgh 0
4640952 2243451 2243451 defendant Dobson Robert   586784 586784 Dobson, Robert, of Burgh 1
4649005 2245756 2245756 defendant Clerk Robert   586784 586784 Clerk, Robert, of Burgh 1
4649006 2245756 2245756 defendant Martyn John   586784 586784 Martyn, John, of Burgh 2
4649893 2245985 2245985 defendant Baly John   586784 586784 Baly, John, of Burgh 2
4651046 2246328 2246328 defendant Marchall Thomas yeoman 586784 586784 Marchall, Thomas, of Burgh, yeoman 1
4651403 2246444 2246444 defendant Wacedale John yeoman 586784 586784 Wacedale, John, of Burgh under Stanesmore, yeoman 0
4651525 2246481 2246481 plaintiff Arnall William   586784 586784 Arnall, William, of Burgh 0
4652916 2246844 2246844 defendant Morce John husbandman 586784 586784 Morce, John, of Burgh, husbandman 1
4657310 2248176 2248176 defendant Blenkensopp Robert gent 586784 586784 Blenkensopp, Robert, of Burgh, gent 2
4657317 2248178 2248178 defendant Nabbes John yeoman 586784 586784 Nabbes, John, of Burgh, yeoman 0
4657319 2248179 2248179 defendant Nabbes John yeoman 586784 586784 Nabbes, John, of Burgh, yeoman 0
4659065 2248704 2248704 defendant Dyne William husbandman 586784 586784 Dyne, William, of Burgh, husbandman 0
4660318 2249057 2249057 defendant del Bowes William yeoman 586784 586784 del Bowes, William, of Burgh under Staynesmore, yeoman 3
4665709 2250747 2250747 defendant Milner Henry laborer 586784 586784 Milner, Henry, of Burgh, laborer 0
4666859 2255362 2255362 defendant Walle John   586784 586784 Walle, John, of Burgh, parson 1
4668174 2255754 2255754 plaintiff Barkoure Thomas   586784 586784 Barkoure, Thomas, of Burgh 0
4668175 2255754 2255754 defendant Haslok William husbandman 586784 586784 Haslok, William, of Burgh, husbandman 0
4670533 2256459 2256459 defendant Terald Robert husbandman 586784 586784 Terald, Robert, of Burgh, husbandman 1
4673937 2257465 2257465 defendant Dobson Robert husbandman 586784 586784 with Dobson, Robert, of Burgh, husbandman 2
4673938 2257465 2257465 defendant Langdale Robert husbandman 586784 586784 Langdale, Robert, of Burgh, husbandman 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);