names

117 rows where place_id = 587741

✎ 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
3592319 1865212 1865212 defendant Staunton John laborer 587741 587741 Staunton, John, of Wystowe, laborer 1
3640135 1907361 1907361 defendant Draycotys William gent 587741 587741 Draycotys, William, of Wystowe, gent 0
3671604 1917102 1917102 defendant Burton Roger gent 587741 587741 Burton, Roger, of Wystowe, gent 0
3672153 1917287 1917287 defendant Gelstrop Henry chaplain 587741 587741 Gelstrop, Henry, of Wystowe, chaplain 0
3800998 1958223 1958223 defendant Cokson Ambrose gent 587741 587741 Cokson, Ambrose, of Wystowe, gent 0
3827269 1966396 1966396 defendant Meitcalf Nicholas yeoman 587741 587741 Meitcalf, Nicholas, of Wystowe, yeoman 0
3828778 1966876 1966876 defendant Yong Robert yeoman 587741 587741 Yong, Robert, of Wystowe, yeoman 0
3833882 1968532 1968532 defendant Derley William yeoman 587741 587741 Derley, William, of Wystowe, yeoman 0
3841825 1971026 1971026 defendant Metcalffe Nicholas yeoman 587741 587741 Metcalffe, Nicholas, of Wystowe, yeoman 0
3851149 1973950 1973950 defendant Metcalfe Nicholas yeoman 587741 587741 Metcalfe, Nicholas, of Wystowe, yeoman 0
3853699 1974788 1974788 defendant Smyth Roger laborer 587741 587741 Smyth, Roger, of Wystowe, laborer 2
3879076 1983254 1983254 defendant Burton Alexander yeoman 587741 587741 Burton, Alexander, of Wystowe, yeoman 0
3879963 1983557 1983557 defendant Scott Thomas husbandman 587741 587741 Scott, Thomas, of Wystowe, husbandman 0
3899475 1990040 1990040 defendant Darley William gent 587741 587741 Darley, William, of Wystowe, gent 0
3977176 2016586 2016586 defendant Metcalf Geoffrey yeoman 587741 587741 Metcalf, Geoffrey, of Wystowe, yeoman 1
4001214 2025212 2025212 defendant Cowland John husbandman 587741 587741 Cowland, John, of Wystowe, husbandman 0
4001216 2025213 2025213 defendant Cowland John husbandman 587741 587741 Cowland, John, of Wystowe, husbandman 0
4055265 2044282 2044282 defendant Margett Henry husbandman 587741 587741 Margett, Henry, of Wystowe, husbandman 0
4055266 2044282 2044282 defendant Margett Nicholas husbandman 587741 587741 Margett, Nicholas, of Wystowe, husbandman 1
4055267 2044282 2044282 defendant Johnson Thomas husbandman 587741 587741 Johnson, Thomas, of Wystowe, husbandman 2
4055444 2044341 2044341 defendant Howley Thomas husbandman 587741 587741 Howley, Thomas, of Wystowe, husbandman 0
4055446 2044342 2044342 defendant Thompson John husbandman 587741 587741 Thompson, John, of Wystowe, husbandman 0
4113667 2065171 2065171 defendant Godshead Simon husbandman 587741 587741 Godshead, Simon, of Wystowe, husbandman 0
4125360 2069355 2069355 defendant Wakefelde Henry clerk 587741 587741 Wakefelde, Henry, of Wystowe, clerk 1
4141011 2075014 2075014 defendant Spofurthe Richard husbandman 587741 587741 Spofurthe, Richard, of Wystowe, husbandman 2
4143439 2075867 2075867 defendant Dyconson Richard husbandman 587741 587741 Dyconson, Richard, of Wystowe, husbandman 0
4143440 2075867 2075867 defendant Woodall Robert laborer 587741 587741 Woodall, Robert, of Wystowe, laborer 1
4143441 2075867 2075867 defendant Wolffe James laborer 587741 587741 Wolffe, James, of Wystowe, laborer 2
4191779 2092680 2092680 defendant Matherer John laborer 587741 587741 Matherer, John, of Wystowe, laborer 4
4192967 2093106 2093106 defendant Sturton Henry (legal representative) 587741 587741 Sturton, Henry, of Wystowe, gent, executor of 0
4192968 2093106 2093106 defendant Wylson Nicholas gent 587741 587741 Wylson, Nicholas, of Wystowe, gent 1
4284432 2124482 2124482 defendant Nelson Jasper yeoman 587741 587741 Nelson, Jasper, of Wystowe, yeoman 0
4317182 2136122 2136122 defendant Walker John laborer 587741 587741 Walker, John, of Wystowe, laborer 0
4317184 2136122 2136122 defendant Hopkyn William yeoman 587741 587741 Hopkyn, William, of Wystowe, yeoman 2
4399060 2164268 2164268 defendant Horseman Thomas   587741 587741 Horseman, Thomas, of Wystowe, brick maker 3
4399061 2164268 2164268 defendant Todd James   587741 587741 Todd, James, of Wystowe, brick maker 4
4460907 2188478 2188478 defendant Barleye Henry   587741 587741 Barleye, Henry, of Wystowe 1
4475958 2193152 2193152 plaintiff Folkyngham John   587741 587741 Folkyngham, John, of Wystowe, parson 0
4475960 2193153 2193153 plaintiff Folkyngham John   587741 587741 Folkyngham, John, of Wystowe, parson, on his own account 0
4498727 2200237 2200237 defendant Whitby John   587741 587741 Whitby, John, of Wystowe 0
4498728 2200237 2200237 defendant Se--- Thomas   587741 587741 Se---, Thomas, of Wystowe 1
4504008 2201809 2201809 defendant Barton Thomas de   587741 587741 Barton, Thomas de, of Wystowe 3
4575867 2223941 2223941 defendant Towery Thomas   587741 587741 Towery, Thomas, of Wystowe 0
4594283 2229473 2229473 defendant Towry Thomas   587741 587741 Towry, Thomas, of Wystowe 2
4612384 2234945 2234945 defendant Porter William chaplain 587741 587741 Porter, William, of Wystowe, chaplain 1
4616000 2236005 2236005 plaintiff Folkyngham John (legal representative) 587741 587741 Folkyngham, John, of Wystowe, clerk & parson, executor of 0
4616003 2236006 2236006 plaintiff Folkyngham John (legal representative) 587741 587741 Folkyngham, John, of Wystowe, parson, executor of 0
4616007 2236007 2236007 plaintiff Folkyngham John (legal representative) 587741 587741 Folkyngham, John, of Wystowe, parson, executors of 0
4621163 2237607 2237607 defendant Hirde Thomas   587741 587741 Hirde, Thomas, of Wystowe 0
4627944 2239668 2239668 defendant Cawod John   587741 587741 Cawod, John, of Wystowe 3
4627945 2239668 2239668 defendant Cawod William   587741 587741 Cawod, William, of Wystowe 4
4640986 2243460 2243460 defendant Tapell William   587741 587741 Tapell, William, of Wystowe 0
4642656 2243967 2243967 defendant Hemyngburgh Richard   587741 587741 Hemyngburgh, Richard, of Wystowe 0
4682227 2260063 2260063 defendant Wodeward John husbandman 587741 587741 Wodeward, John, of wystowe, husbandman 1
4706846 2267520 2267520 plaintiff Marchall John clerk & parson 587741 587741 Marchall, John, of Wystowe, clerk & parson 0
4706848 2267521 2267521 plaintiff Marchall John clerk & parson 587741 587741 Marchall, John, of Wystowe, clerk & parson 0
4706851 2267522 2267522 plaintiff Marchall John clerk & parson 587741 587741 Marchall, John, of Wystowe, clerk & parson 0
4706853 2267523 2267523 plaintiff Marchall John   587741 587741 Marchall, John, of Wystowe, parson 0
4706856 2267524 2267524 plaintiff Marchall John   587741 587741 Marchall, John, of Wystowe, parson 0
4706859 2267525 2267525 plaintiff Marchall John   587741 587741 Marchall, John, of Wystowe, parson & clerk 0
4706862 2267526 2267526 plaintiff Marchall John   587741 587741 Marchall, John, of Wystowe, parson & clerk 0
4706970 2267562 2267562 plaintiff Marshall John clerk & parson 587741 587741 Marshall, John, of Wystowe, clerk & parson 0
4750400 2280599 2280599 defendant Barlay Henry gent 587741 587741 Barlay, Henry, of Wystowe, gent 0
4786011 2291665 2291665 plaintiff Forster Robert   587741 587741 Forster, Robert, of Wystowe 0
4813583 2300355 2300355 defendant Ketrynges John husbandman 587741 587741 Ketrynges, John, of Wystowe, husbandman 0
4820448 2302468 2302468 defendant Barworth William husbandman 587741 587741 Barworth, William, of Wystowe, husbandman 0
4832824 2306289 2306289 defendant Slyngesby John husbandman 587741 587741 Slyngesby, John, of Wystowe, husbandman 0
4843622 2309528 2309528 defendant Hemyngburgh Thomas husbandman 587741 587741 Hemyngburgh, Thomas, of Wystowe, husbandman 0
4850766 2311690 2311690 defendant Towton Robert husbandman 587741 587741 Towton, Robert, of Wystowe, husbandman 1
4877102 2319806 2319806 defendant Wilson Robert laborer 587741 587741 Wilson, Robert, of Wystowe, laborer 1
4877266 2319845 2319845 defendant Ranere or Ravere Thomas husbandman 587741 587741 Ranere or Ravere, Thomas, of Wystowe, husbandman 0
4878717 2320283 2320283 defendant Hemmyngburgh Thomas gent 587741 587741 Hemmyngburgh, Thomas, of Wystowe, gent 0
4878718 2320283 2320283 defendant Towton Robert husbandman 587741 587741 Towton, Robert, of Wystowe, husbandman 1
4883114 2321643 2321643 defendant Barlay Henry   587741 587741 Barlay, Henry, of Wystowe, franklin 0
4883116 2321644 2321644 defendant Barlay Henry   587741 587741 Barlay, Henry, of Wystowe, franklin 0
4896677 2325623 2325623 defendant Barlay Henry   587741 587741 Barlay, Henry, of Wystowe, franklin 0
4901474 2327065 2327065 defendant Barlay Henry   587741 587741 Barlay, Henry, of Wystowe, franklin 0
4962276 2345618 2345618 defendant Keld Robert husbandman 587741 587741 Keld, Robert, of Wystowe, husbandman 0
4964979 2346442 2346442 defendant Spenser Richard husbandman 587741 587741 Spenser, Richard, of Wystowe, husbandman 0
4964981 2346442 2346442 defendant Durham John laborer 587741 587741 Durham, John, of Wystowe, laborer 2
4996785 2355896 2355896 defendant Aylmer Thomas yeoman 587741 587741 Aylmer, Thomas, of Wystowe, yeoman 1
5035666 2367286 2367286 defendant Carleton John husbandman 587741 587741 Carleton, John, of Wystowe, husbandman 4
5036897 2367666 2367666 defendant Barly Nicholas yeoman 587741 587741 Barly, Nicholas, of Wystowe, yeoman 0
5052188 2372262 2372262 defendant Whalley John   587741 587741 Whalley, John, of Wystowe husbandman 3
5052189 2372262 2372262 defendant Spencer John husbandman 587741 587741 Spencer, John, of Wystowe, husbandman 4
5056521 2373530 2373530 defendant Towere Christopher laborer 587741 587741 Towere, Christopher, of Wystowe, laborer 0
5080770 2380739 2380739 defendant Forster John   587741 587741 Forster, John, of Wystowe, wheelwright 0
5149651 2401027 2401027 defendant Routhe John husbandman 587741 587741 Routhe, John, of Wystowe, husbandman 0
5149652 2401027 2401027 defendant Palmer William husbandman 587741 587741 Palmer, William, of Wystowe, husbandman 1
5163067 2404924 2404924 defendant Forester John husbandman 587741 587741 Forester, John, of Wystowe, husbandman 4
5168522 2406509 2406509 defendant Routhe John husbandman 587741 587741 Routhe, John, of Wystowe, husbandman 0
5168523 2406509 2406509 defendant Palmer William husbandman 587741 587741 Palmer, William, of Wystowe, husbandman 1
5176881 2408927 2408927 defendant Forester John husbandman 587741 587741 Forester, John, of Wystowe, husbandman 4
5184499 2411210 2411210 defendant Routhe John husbandman 587741 587741 Routhe, John, of Wystowe, husbandman 0
5184500 2411210 2411210 defendant Palmer William husbandman 587741 587741 Palmer, William, of Wystowe, husbandman 1
5231242 2424736 2424736 defendant Routh John husbandman 587741 587741 Routh, John, of Wystowe, husbandman 2
5231619 2424830 2424830 defendant Barley Robert husbandman 587741 587741 Barley, Robert, of Wystowe, husbandman 1
5342031 2457697 2457697 defendant Barley Richard yeoman 587741 587741 Barley, Richard, of Wystowe, yeoman 0
5349107 2459851 2459851 defendant Darley Richard yeoman 587741 587741 Darley, Richard, of Wystowe, yeoman 0
5439384 2486714 2486714 defendant Smyth William yeoman 587741 587741 Smyth, William, of Wystowe, yeoman 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);