names

204 rows where place_id = 587187

✎ 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
3590705 1864736 1864736 plaintiff Crysp John (legal representative) 587187 587187 Crysp, John, of Laxfeld, tanner, executors of 0
3590707 1864736 1864736 plaintiff Smyth alias Dowsyng John   587187 587187 Smyth alias Dowsyng, John, of Laxfeld 2
3590708 1864736 1864736 defendant Noloth William husbandman 587187 587187 Noloth, William, of Laxfeld, husbandman 0
3639343 1907114 1907114 defendant Dowsyng Robert yeoman 587187 587187 Dowsyng, Robert, of Laxfeld, yeoman 0
3639344 1907114 1907114 defendant Dowsyng John husbandman 587187 587187 Dowsyng, John, of Laxfeld, husbandman 1
3641918 1907925 1907925 defendant Bocher William pedder 587187 587187 Bocher, William, of Laxfeld, pedder 3
3641922 1907925 1907925 defendant Clowtyng William pedder 587187 587187 Clowtyng, William, of Laxfeld, pedder 7
3642230 1908017 1908017 defendant Rous Robert yeoman 587187 587187 Rous, Robert, of Laxfeld, yeoman 3
3645369 1908961 1908961 defendant Trusse William cooper 587187 587187 Trusse, William, of Laxfeld, cooper 0
3655284 1911911 1911911 defendant Smyth Henry husbandman 587187 587187 Smyth, Henry, of Laxfeld, husbandman 0
3665539 1915172 1915172 defendant Hosbarne Richard husbandman 587187 587187 Hosbarne, Richard, of Laxfeld, husbandman 0
3666170 1915364 1915364 defendant Nooloth John   587187 587187 Nooloth, John, of Laxfeld 0
3669480 1916394 1916394 defendant Seman Thomas (legal representative) 587187 587187 Seman, Thomas, of Laxfeld, clerk, executors of 0
3669481 1916394 1916394 defendant Warde William clerk 587187 587187 (Warde, William, of Laxfeld, clerk 1
3672882 1917531 1917531 defendant Noloth Robert husbandman 587187 587187 Noloth, Robert, of Laxfeld, husbandman 0
3675293 1918312 1918312 defendant Noloth Robert husbandman 587187 587187 Noloth, Robert, of Laxfeld, husbandman 1
3690676 1923248 1923248 defendant Vale Thomas forester 587187 587187 Vale, Thomas, of Laxfeld, forester 0
3696597 1925169 1925169 defendant Marecaunt Robert butcher 587187 587187 Marecaunt, Robert, of Laxfeld, butcher 1
3721120 1932903 1932903 plaintiff Kyng William husbandman 587187 587187 Kyng, William, of Laxfeld, husbandman 0
3721122 1932903 1932903 defendant Baxster John yeoman 587187 587187 Baxster, John, of Laxfeld, yeoman 1
3721123 1932903 1932903 defendant Smyth Henry yeoman 587187 587187 Smyth, Henry, of Laxfeld, yeoman 2
3733206 1936618 1936618 plaintiff Dowsyng John   587187 587187 Dowsyng, John, of Laxfeld 0
3736983 1937813 1937813 plaintiff Kynge William   587187 587187 Kynge, William, of Laxfeld 0
3766360 1947133 1947133 defendant Dallyng Robert draper 587187 587187 Dallyng, Robert, of Laxfeld, draper 1
3769874 1948232 1948232 defendant Cowper William husbandman 587187 587187 Cowper, William, of Laxfeld, husbandman 0
3825047 1965708 1965708 defendant Elwys William husbandman 587187 587187 Elwys, William, of Laxfeld, husbandman 0
3834666 1968777 1968777 defendant Cryspe John, senior husbandman 587187 587187 Cryspe, John, senior, of Laxfeld, husbandman 0
3834667 1968777 1968777 defendant Cryspe John, junior husbandman 587187 587187 Cryspe, John, junior, of Laxfeld, husbandman 1
3837340 1969588 1969588 defendant Fale Thomas husbandman 587187 587187 Fale, Thomas, of Laxfeld, husbandman 2
3837377 1969602 1969602 plaintiff Smyth William (legal representative) 587187 587187 Smyth, William, of Laxfeld, executors of 0
3853449 1974705 1974705 plaintiff Smyth William (legal representative) 587187 587187 Smyth, William, of Laxfeld, executors of 0
3875628 1982091 1982091 defendant Fale John yeoman 587187 587187 Fale, John, of Laxfeld, yeoman 0
3875629 1982091 1982091 defendant Elwys William yeoman 587187 587187 Elwys, William, of Laxfeld, yeoman 1
3885860 1985527 1985527 defendant Artes Robert husbandman 587187 587187 Artes, Robert, of Laxfeld, husbandman 1
3886283 1985667 1985667 defendant Cryspe Christopher butcher 587187 587187 Cryspe, Christopher, of Laxfeld, butcher 0
3886284 1985667 1985667 defendant Dowsyng John yeoman 587187 587187 Dowsyng, John, of Laxfeld, yeoman 1
3886285 1985667 1985667 defendant Dowsyng Wulfram husbandman 587187 587187 Dowsyng, Wulfram, of Laxfeld, husbandman 2
3889391 1986683 1986683 defendant Cryspe John butcher 587187 587187 Cryspe, John, of Laxfeld, butcher 0
3889392 1986683 1986683 defendant Clark Robert tailor 587187 587187 Clark, Robert, of Laxfeld, tailor 1
3898695 1989770 1989770 defendant Bozett or Borett John yeoman 587187 587187 Bozett or Borett, John, of Laxfeld, yeoman 0
3898696 1989770 1989770 defendant Dowsyng Wilfrum husbandman 587187 587187 Dowsyng, Wilfrum, of Laxfeld, husbandman 1
3917938 1996363 1996363 defendant Crispe John butcher 587187 587187 Crispe, John, of Laxfeld, butcher 0
3923139 1998045 1998045 defendant Crispe John yeoman 587187 587187 Crispe, John, of Laxfeld, yeoman 0
3928090 1999734 1999734 defendant Jervys William yeoman 587187 587187 Jervys, William, of Laxfeld, yeoman 0
3940131 2003717 2003717 plaintiff Smyth Margaret single woman 587187 587187 Smyth, Margaret, of Laxfeld, single woman 0
3945354 2005459 2005459 defendant Jerveys William yeoman 587187 587187 Jerveys, William, of Laxfeld, yeoman 0
3947999 2006363 2006363 defendant Lovell Thomas gent 587187 587187 Lovell, Thomas, of Laxfeld, gent 1
3957831 2009800 2009800 defendant Burbage Richard gent 587187 587187 Burbage, Richard, of Laxfeld, gent 1
3964399 2012154 2012154 defendant Fyske Ralph (legal representative) 587187 587187 Fyske, Ralph, of Laxfeld, singleman, executrix of 0
3967347 2013208 2013208 plaintiff Burbage Richard gent 587187 587187 Burbage, Richard, of Laxfeld, gent 0
3971222 2014492 2014492 defendant Dowsyng alias Smyth William yeoman 587187 587187 Dowsyng alias Smyth, William, of Laxfeld, yeoman 0
3972364 2014907 2014907 defendant Crispe Thomas husbandman 587187 587187 Crispe, Thomas, of Laxfeld, husbandman 0
3972500 2014959 2014959 defendant Bocher George yeoman 587187 587187 Bocher, George, of Laxfeld, yeoman 1
3972501 2014959 2014959 defendant Warner William yeoman 587187 587187 Warner, William, of Laxfeld, yeoman 2
3977130 2016573 2016573 defendant Albye Geoffrey   587187 587187 Albye, Geoffrey, of Laxfeld, Suff yeoman 0
3982582 2018543 2018543 defendant Artrys Henry yeoman 587187 587187 Artrys, Henry, of Laxfeld, yeoman 2
3984862 2019340 2019340 defendant Artes Simon yeoman or singleman 587187 587187 Artes, Simon, of Laxfeld, yeoman or singleman 1
3985854 2019705 2019705 plaintiff Warner William victualer 587187 587187 Warner, William, of Laxfeld, victualer 0
3996010 2023327 2023327 defendant Noller John yeoman 587187 587187 Noller, John, of Laxfeld, yeoman 3
3999551 2024607 2024607 defendant Albye Geoffrey yeoman 587187 587187 Albye, Geoffrey, of Laxfeld, yeoman 0
3999552 2024607 2024607 defendant Cowper John, junior yeoman 587187 587187 Cowper, John, junior, of Laxfeld, yeoman 1
4004367 2026342 2026342 defendant Noller John yeoman 587187 587187 Noller, John, of Laxfeld, yeoman 1
4004368 2026342 2026342 defendant Borrett John, senior yeoman 587187 587187 Borrett, John, senior, of Laxfeld, yeoman 2
4004373 2026343 2026343 defendant Borrett John, senior yeoman 587187 587187 Borrett, John, senior, of Laxfeld, yeoman 1
4006801 2027210 2027210 defendant Murrell Christopher mercer 587187 587187 Murrell, Christopher, of Laxfeld, mercer 0
4025075 2033629 2033629 plaintiff Bradlaugh alias Jacob John (legal representative) 587187 587187 Bradlaugh alias Jacob, John, of Laxfeld, yeoman, executors of 0
4025080 2033630 2033630 plaintiff Bradlaugh alias Jacob John (legal representative) 587187 587187 Bradlaugh alias Jacob, John, of Laxfeld, yeoman, executors of 0
4042532 2039797 2039797 defendant Baldrye William yeoman 587187 587187 Baldrye, William, of Laxfeld, yeoman 0
4045689 2040908 2040908 defendant Baldry William yeoman 587187 587187 Baldry, William, of Laxfeld, yeoman 2
4076923 2052034 2052034 plaintiff Cock Simon yeoman 587187 587187 (Cock, Simon, of Laxfeld, yeoman 1
4237607 2108745 2108745 defendant Mowlton Edmund gent 587187 587187 Mowlton, Edmund, of Laxfeld, gent 0
4397809 2163845 2163845 defendant Grenlinge or Girlinge John yeoman 587187 587187 Grenlinge or Girlinge, John, of Laxfeld, yeoman 1
4397810 2163845 2163845 defendant Butcher Hugh yeoman 587187 587187 Butcher, Hugh, of Laxfeld, yeoman 2
4430289 2174259 2174259 plaintiff Gerveys John   587187 587187 Gerveys, John, of Laxfeld 1
4440978 2182101 2182101 defendant Rowys Richard   587187 587187 Rowys, Richard, of Laxfeld 0
4445373 2183502 2183502 defendant Nuwe Richard   587187 587187 Nuwe, Richard, of Laxfeld 1
4445374 2183502 2183502 defendant Ede Henry   587187 587187 Ede, Henry, of Laxfeld 2
4445504 2183547 2183547 defendant Rowe Richard   587187 587187 Rowe, Richard, of Laxfeld 1
4445505 2183547 2183547 defendant Ede Henry   587187 587187 Ede, Henry, of Laxfeld 2
4446312 2183765 2183765 plaintiff del Bregge John   587187 587187 del Bregge, John, of Laxfeld 0
4446314 2183765 2183765 defendant Geffrey John   587187 587187 Geffrey, John, of Laxfeld 0
4459276 2187948 2187948 plaintiff Rowe Richard   587187 587187 Rowe, Richard, of Laxfeld 0
4459277 2187948 2187948 plaintiff Gee Henry   587187 587187 Gee, Henry, of Laxfeld 1
4459279 2187949 2187949 plaintiff Rowe Richard   587187 587187 Rowe, Richard, of Laxfeld 0
4459280 2187949 2187949 plaintiff Ode Henry   587187 587187 Ode, Henry, of Laxfeld 1
4493287 2198604 2198604 defendant Bernard John, junior   587187 587187 Bernard, John, junior, of Laxfeld 0
4493298 2198608 2198608 defendant Eem Edmund chaplain 587187 587187 Eem, Edmund, of Laxfeld, chaplain 1
4573065 2223111 2223111 defendant Tynkere Robert barber 587187 587187 Tynkere, Robert, of Laxfeld, barber 0
4578554 2224782 2224782 defendant Dousyng Stephen   587187 587187 Dousyng, Stephen, of Laxfeld 0
4651282 2246408 2246408 plaintiff Alpot John   587187 587187 Alpot, John, of Laxfeld 0
4658383 2248506 2248506 defendant Smyth William   587187 587187 Smyth, William, of Laxfeld, parson of Brent Wenham, Suff 3
4662202 2249652 2249652 defendant Kempe Geoffrey husbandman 587187 587187 Kempe, Geoffrey, of Laxfeld, husbandman 3
4679378 2259167 2259167 plaintiff Kempe Godfrey   587187 587187 Kempe, Godfrey, of Laxfeld 0
4683215 2260366 2260366 defendant Noyse Edmunds husbandman 587187 587187 Noyse, Edmunds, of Laxfeld, husbandman 0
4683216 2260366 2260366 defendant Cove William husbandman 587187 587187 Cove, William, of Laxfeld, husbandman 1
4683218 2260366 2260366 defendant Blynde John husbandman 587187 587187 Blynde, John, of Laxfeld, husbandman 3
4688581 2261991 2261991 defendant Dowesyng William yeoman 587187 587187 Dowesyng, William, of Laxfeld, yeoman 0
4697391 2264669 2264669 defendant Dousyng William husbandman 587187 587187 Dousyng, William, of Laxfeld, husbandman 1
4722303 2272299 2272299 defendant Dousyng William husbandman 587187 587187 Dousyng, William, of Laxfeld, husbandman 1
4722306 2272300 2272300 defendant Dousyng William husbandman 587187 587187 Dousyng, William, of Laxfeld, husbandman 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);