names

102 rows where place_id = 587577

✎ 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
3591812 1865060 1865060 defendant Doraunt Richard gent 587577 587577 Doraunt, Richard, of Wolston, gent 0
3652295 1911058 1911058 defendant Willys John husbandman 587577 587577 Willys, John, of Wolston, husbandman 1
3696331 1925074 1925074 defendant Merston Richard husbandman 587577 587577 Merston, Richard, of Wolston, husbandman 0
3696332 1925074 1925074 defendant Merston Ralph husbandman 587577 587577 Merston, Ralph, of Wolston, husbandman 1
3699451 1926055 1926055 plaintiff Wygston Roger gent 587577 587577 Wygston, Roger, of Wolston, gent 0
3712944 1930370 1930370 plaintiff Wygston Roger gent 587577 587577 Wygston, Roger, of Wolston, gent 0
3721254 1932951 1932951 plaintiff Lapworth John husbandman 587577 587577 Lapworth, John, of Wolston, husbandman 0
3737156 1937854 1937854 plaintiff Lapworth John husbandman 587577 587577 Lapworth, John, of Wolston, husbandman 0
3741098 1939079 1939079 defendant Clerke William clerk 587577 587577 Clerke, William, of Wolston, clerk 0
3770941 1948596 1948596 defendant Marston Richard husbandman 587577 587577 Marston, Richard, of Wolston, husbandman 1
3770942 1948596 1948596 defendant Marston Ralph husbandman 587577 587577 Marston, Ralph, of Wolston, husbandman 2
3811432 1961470 1961470 defendant Brabson John gent 587577 587577 Brabson, John, of Wolston, gent 3
3826066 1965994 1965994 defendant Sweyne William husbandman 587577 587577 Sweyne, William, of Wolston, husbandman 1
3840611 1970629 1970629 plaintiff Arthyngton John yeoman 587577 587577 Arthyngton, John, of Wolston, yeoman 0
3856316 1975594 1975594 defendant Wasberton Robert yeoman 587577 587577 Wasberton, Robert, of Wolston, yeoman 1
3857034 1975833 1975833 defendant George John yeoman 587577 587577 George, John, of Wolston, yeoman 2
3866450 1979009 1979009 defendant Pryce William husbandman 587577 587577 Pryce, William, of Wolston, husbandman 0
3870077 1980234 1980234 plaintiff Wigston Roger esq 587577 587577 Wigston, Roger, of Wolston, esq 0
3883869 1984876 1984876 plaintiff Wigston Roger esq 587577 587577 Wigston, Roger, of Wolston, esq 0
3884157 1984969 1984969 plaintiff Wygston Roger esq 587577 587577 Wygston, Roger, of Wolston, esq 0
3884468 1985078 1985078 defendant Venners alias Pecke William tucker 587577 587577 Venners alias Pecke, William, of Wolston, tucker 0
3897754 1989456 1989456 plaintiff Wygston Roger (legal representative) 587577 587577 Wygston, Roger, of Wolston, esq, executors of 0
3897758 1989456 1989456 defendant Durront William gent 587577 587577 Durront, William, of Wolston, gent 0
3917973 1996377 1996377 defendant Cokes John walker 587577 587577 Cokes, John, of Wolston, walker 0
4022593 2032804 2032804 defendant Arthington Joan (legal representative) 587577 587577 Arthington, Joan, of Wolston, widow, executors of 0
4022594 2032804 2032804 defendant Arthington John yeoman 587577 587577 (Arthington, John, of Wolston, yeoman 1
4022595 2032804 2032804 defendant Arthington Francis yeoman 587577 587577 Arthington, Francis, of Wolston, yeoman 2
4022596 2032804 2032804 defendant Arthington Alexander yeoman 587577 587577 Arthington, Alexander, of Wolston, yeoman 3
4022597 2032804 2032804 defendant Arthington Isabel spinster 587577 587577 Arthington, Isabel, of Wolston, spinster 4
4060937 2046320 2046320 defendant Davys alias Butler Luke husbandman 587577 587577 Davys alias Butler, Luke, of Wolston, husbandman 1
4092896 2057771 2057771 defendant ap Edward Griffin yeoman 587577 587577 ap Edward, Griffin, of Wolston, yeoman 0
4189679 2091886 2091886 defendant Pricke John husbandman 587577 587577 Pricke, John, of Wolston, husbandman 2
4225157 2104269 2104269 defendant Vicaredge or Vicares John yeoman 587577 587577 Vicaredge or Vicares, John, of Wolston, yeoman 0
4225158 2104269 2104269 defendant Davis aluas Butler Luke yeoman 587577 587577 Davis aluas Butler, Luke, of Wolston, yeoman 1
4236942 2108498 2108498 defendant Keake Nicholas clerk 587577 587577 Keake, Nicholas, of Wolston, clerk 2
4274046 2120867 2120867 defendant Powell William yeoman 587577 587577 Powell, William, of Wolston, yeoman 0
4286207 2125121 2125121 defendant Carman John husbandman 587577 587577 Carman, John, of Wolston, husbandman 0
4341650 2144358 2144358 defendant Keeke Nicholas clerk 587577 587577 Keeke, Nicholas, of Wolston, clerk 0
4359740 2150643 2150643 defendant Vicaries alias Ball John yeoman 587577 587577 Vicaries alias Ball, John, of Wolston,yeoman 0
4377069 2156871 2156871 defendant Davys Luke husbandman 587577 587577 Davys, Luke, of Wolston, husbandman 0
4393759 2162514 2162514 defendant Baker James yeoman 587577 587577 Baker, James, of Wolston, yeoman 2
4496337 2199527 2199527 defendant Hall Thomas of the   587577 587577 Hall, Thomas of the, of Wolston 2
4504327 2201902 2201902 defendant Folkesham Robert   587577 587577 Folkesham, Robert, of Wolston 1
4515629 2205311 2205311 defendant Walton John   587577 587577 Walton, John, of Wolston, parson 0
4531815 2210212 2210212 defendant Bole Robert   587577 587577 Bole, Robert, of Wolston 0
4610033 2234224 2234224 plaintiff Persones Thomas   587577 587577 (Persones, Thomas, of Wolston 1
4651544 2246487 2246487 defendant Husy Robert   587577 587577 Husy, Robert, of Wolston, bailiff 2
4651551 2246487 2246487 defendant Hondaller John   587577 587577 Hondaller, John, of Wolston, bailiff 9
4654902 2247414 2247414 defendant Comyn John gent 587577 587577 Comyn, John, of Wolston, gent 0
4654904 2247415 2247415 defendant Comyn John gent 587577 587577 Comyn, John, of Wolston, gent 0
4720830 2271846 2271846 defendant Hopell John husbandman 587577 587577 Hopell, John, of Wolston, husbandman 0
4720831 2271846 2271846 defendant William John husbandman 587577 587577 William, John, of Wolston, husbandman 1
4720832 2271846 2271846 defendant Mey John husbandman 587577 587577 Mey, John, of Wolston, husbandman 2
4724976 2273105 2273105 defendant Hastyng William gent 587577 587577 Hastyng, William, of Wolston, gent 0
4746042 2279344 2279344 plaintiff Halle William   587577 587577 Halle, William, of Wolston 0
4754547 2281801 2281801 plaintiff Yutte Henry smith 587577 587577 Yutte, Henry, of Wolston, smith 0
4765997 2285357 2285357 defendant Smyth Henry smith 587577 587577 Smyth, Henry, of Wolston, smith 1
4771384 2287033 2287033 plaintiff Benyll John esq 587577 587577 Benyll, John, of Wolston, esq 3
4771390 2287034 2287034 plaintiff Benyll John esq 587577 587577 Benyll, John, of Wolston, esq 3
4771976 2287208 2287208 defendant Quarriour Richard   587577 587577 Quarriour, Richard, of Wolston, school master 0
4817929 2301690 2301690 defendant Gerveys John husbandman 587577 587577 Gerveys, John, of Wolston, husbandman 3
4858871 2314151 2314151 defendant Mey John husbandman 587577 587577 Mey, John, of Wolston, husbandman 2
4915019 2331203 2331203 defendant Hueys Thomas clerk 587577 587577 Hueys, Thomas, of Wolston, clerk 0
4935110 2337389 2337389 defendant Quarryour Richard schoolmaster 587577 587577 Quarryour, Richard, of Wolston, schoolmaster 0
4940386 2339015 2339015 defendant Luwysshe Thomas clerk 587577 587577 Luwysshe, Thomas, of Wolston, clerk 1
4952299 2342654 2342654 defendant Cammell Robert gent 587577 587577 Cammell, Robert, of Wolston, gent 0
4997885 2356227 2356227 defendant Wattes Nicholas laborer 587577 587577 Wattes, Nicholas, of Wolston, laborer 0
5007507 2359090 2359090 defendant Hale William yeoman 587577 587577 Hale, William, of Wolston, yeoman 3
5035757 2367312 2367312 defendant Frankeleyn Ellen widow 587577 587577 Frankeleyn, Ellen, of Wolston, widow 3
5035762 2367313 2367313 defendant Frankeleyn Ellen widow 587577 587577 Frankeleyn, Ellen, of Wolston, widow 2
5055994 2373364 2373364 defendant Mone John gent 587577 587577 Mone, John, of Wolston, gent 2
5134817 2396686 2396686 defendant Lavyngton Thomas gent 587577 587577 Lavyngton, Thomas, of Wolston, gent 2
5141066 2398509 2398509 defendant Leche William husbandman 587577 587577 Leche, William, of Wolston, husbandman 4
5160928 2404301 2404301 defendant Dene William miller 587577 587577 Dene, William, of Wolston, miller 0
5175542 2408530 2408530 defendant Dene William miller 587577 587577 Dene, William, of Wolston, miller 0
5175544 2408531 2408531 defendant Dene William miller 587577 587577 Dene, William, of Wolston, miller 0
5202330 2416444 2416444 defendant Toly Robert husbandman 587577 587577 Toly, Robert, of Wolston, husbandman 0
5209840 2418613 2418613 defendant Dene William miller 587577 587577 Dene, William, of Wolston, miller 0
5216967 2420703 2420703 defendant Cammell Robert gent 587577 587577 Cammell, Robert, of Wolston, gent 2
5222364 2422249 2422249 defendant Greder Stephen butcher 587577 587577 Greder, Stephen, of Wolston, butcher 1
5226355 2423377 2423377 defendant Dene William weaver 587577 587577 Dene, William, of Wolston, weaver 0
5236053 2426128 2426128 defendant Bacon John husbandman 587577 587577 Bacon, John, of Wolston, husbandman 0
5253571 2431226 2431226 defendant Toly Robert husbandman 587577 587577 Toly, Robert, of Wolston, husbandman 0
5264850 2434764 2434764 defendant Patryche Richard laborer 587577 587577 Patryche, Richard, of Wolston, laborer 0
5265852 2435072 2435072 defendant Darlay Richard yeoman 587577 587577 Darlay, Richard, of Wolston, yeoman 2
5270685 2436529 2436529 defendant Colet Thomas yeoman 587577 587577 Colet, Thomas, of Wolston, yeoman 0
5278389 2438786 2438786 defendant Polson Henry yeoman 587577 587577 Polson, Henry, of Wolston, yeoman 6
5278390 2438786 2438786 defendant Medowe Richard yeoman 587577 587577 Medowe, Richard, of Wolston, yeoman 7
5333944 2455229 2455229 plaintiff Durant Edward   587577 587577 Durant, Edward, of Wolston, gent, administrators of 0
5496188 2503757 2503757 defendant Jacard Thomas miller 587577 587577 Jacard, Thomas, of Wolston, miller 0
5496190 2503758 2503758 defendant Jacard Tristram miller 587577 587577 Jacard, Tristram, of Wolston, miller 0
5508879 2507631 2507631 defendant Doraunt Richard gent 587577 587577 Doraunt, Richard, of Wolston, gent 0
5541032 2517319 2517319 defendant Hogeson Roger clerk 587577 587577 Hogeson, Roger, of Wolston, clerk 0
5560304 2522975 2522975 defendant Harryson Thomas butcher 587577 587577 Harryson, Thomas, of Wolston, butcher 0
5561299 2523285 2523285 defendant Kellygrewe Robert gent 587577 587577 Kellygrewe, Robert, of Wolston, gent 0
5561965 2523479 2523479 defendant Kelligrewe Robert gent 587577 587577 Kelligrewe, Robert, of Wolston, gent 0
5561967 2523480 2523480 defendant Kellygrewe Robert gent 587577 587577 Kellygrewe, Robert, of Wolston, gent 0
5564276 2524163 2524163 defendant Aleyn William butcher 587577 587577 Aleyn, William, of Wolston, butcher 0
5564277 2524163 2524163 defendant Mille Thomas tanner 587577 587577 Mille, Thomas, of Wolston, tanner 1
5582308 2529542 2529542 defendant Kyllygrewe Robert gent 587577 587577 Kyllygrewe, Robert, of Wolston, gent 0

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