names

128 rows where place_id = 589214

✎ 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
3596917 1866668 1866668 defendant Copynger Richard yeoman 589214 589214 Copynger, Richard, of Myldenhale, yeoman 0
3596920 1866669 1866669 defendant Copynger Richard yeoman 589214 589214 Copynger, Richard, of Myldenhale, yeoman 0
3625747 1875591 1875591 defendant Brumwyn Robert husbandman 589214 589214 Brumwyn, Robert, of Myldenhale, husbandman 3
3635407 1905871 1905871 defendant Bryan Robert carver 589214 589214 Bryan, Robert, of Myldenhale, carver 2
3635408 1905871 1905871 defendant Webbe Edward yeoman 589214 589214 Webbe, Edward, of Myldenhale, yeoman 3
3635409 1905871 1905871 defendant Dobson John dyer 589214 589214 Dobson, John, of Myldenhale, dyer 4
3652836 1911211 1911211 defendant Clement William husbandman 589214 589214 Clement, William, of Myldenhale, husbandman 3
3671601 1917101 1917101 defendant Baunce Thomas husbandman 589214 589214 Baunce, Thomas, of Myldenhale, husbandman 2
3686883 1922061 1922061 defendant Roote John husbandman 589214 589214 Roote, John, of Myldenhale, husbandman 0
3692845 1923959 1923959 defendant Whytyng William husbandman 589214 589214 Whytyng, William, of Myldenhale, husbandman 0
3694204 1924391 1924391 defendant Bartlott Richard husbandman 589214 589214 Bartlott, Richard, of Myldenhale, husbandman 2
3709239 1929186 1929186 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 0
3710784 1929690 1929690 defendant Duffeld Humphrey mercer 589214 589214 Duffeld, Humphrey, of Myldenhale, mercer 1
3714546 1930847 1930847 defendant Halle Robert butcher 589214 589214 Halle, Robert, of Myldenhale, butcher 0
3731770 1936167 1936167 defendant Motte Thomas husbandman 589214 589214 Motte, Thomas, of Myldenhale, husbandman 0
3731774 1936168 1936168 defendant Roote John laborer 589214 589214 Roote, John, of Myldenhale, laborer 0
3733256 1936636 1936636 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 0
3741286 1939135 1939135 defendant Woderys John husbandman 589214 589214 Woderys, John, of Myldenhale, husbandman 0
3742852 1939617 1939617 defendant Hall William butcher 589214 589214 Hall, William, of Myldenhale, butcher 0
3742853 1939617 1939617 defendant Geson Thomas tanner 589214 589214 Geson, Thomas, of Myldenhale, tanner 1
3749531 1941766 1941766 defendant Hull Thomas (legal representative) 589214 589214 Hull, Thomas, of Myldenhale, merchant, executors of 0
3749532 1941766 1941766 defendant Palton Nicholas yeoman 589214 589214 (Palton, Nicholas, of Myldenhale, yeoman 1
3749533 1941766 1941766 defendant Larke Thomas yeoman 589214 589214 Larke, Thomas, of Myldenhale, yeoman 2
3754880 1943479 1943479 defendant Brown John, senior   589214 589214 Brown, John, senior, of Myldenhale, "corseour" 0
3760942 1945428 1945428 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 0
3764005 1946385 1946385 plaintiff Heynes Simon (legal representative) 589214 589214 Heynes, Simon, of Myldenhale, executor of 0
3764007 1946385 1946385 defendant Dobson Thomas dyer 589214 589214 Dobson, Thomas, of Myldenhale, dyer 0
3766031 1947041 1947041 defendant Warburton John gent 589214 589214 Warburton, John, of Myldenhale, gent 0
3769538 1948134 1948134 defendant Brown John, junior yeoman 589214 589214 Brown, John, junior, of Myldenhale, yeoman 2
3772339 1949034 1949034 defendant Brown John, senior courser 589214 589214 Brown, John, senior, of Myldenhale, courser 0
3783861 1952724 1952724 defendant Stokton Thomas laborer 589214 589214 Stokton, Thomas, of Myldenhale, laborer 0
3783862 1952724 1952724 defendant Stokton Richard laborer 589214 589214 Stokton, Richard, of Myldenhale, laborer 1
3796222 1956684 1956684 defendant Geson Cecilia widow 589214 589214 Geson, Cecilia, of Myldenhale, widow 0
3797701 1957178 1957178 defendant Sharhawke John husbandman 589214 589214 Sharhawke, John, of Myldenhale, husbandman 3
3804308 1959282 1959282 defendant Halstede Robert laborer 589214 589214 Halstede, Robert, of Myldenhale, laborer 3
3807723 1960303 1960303 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 1
3809493 1960849 1960849 defendant Tyrell Robert yeoman 589214 589214 Tyrell, Robert, of Myldenhale, yeoman 0
3819069 1963855 1963855 defendant Hebylwheyte Robert tinker 589214 589214 Hebylwheyte, Robert, of Myldenhale, tinker 1
3852431 1974366 1974366 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 0
3854158 1974938 1974938 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 1
3854159 1974938 1974938 defendant Tirrell Robert miller 589214 589214 Tirrell, Robert, of Myldenhale, miller 2
3859029 1976512 1976512 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 0
3862653 1977703 1977703 defendant Raynberd John butcher 589214 589214 Raynberd, John, of Myldenhale, butcher 1
3862836 1977763 1977763 defendant Lumkin Thomas husbandman 589214 589214 Lumkin, Thomas, of Myldenhale, husbandman 0
3910370 1993787 1993787 defendant Palton Nicholas yeoman 589214 589214 Palton, Nicholas, of Myldenhale, yeoman 0
3915949 1995713 1995713 defendant Webbe Thomas dyer 589214 589214 Webbe, Thomas, of Myldenhale, dyer 0
3915950 1995713 1995713 defendant Bugg William tanner 589214 589214 Bugg, William, of Myldenhale, tanner 1
3918481 1996511 1996511 defendant Bagott Thomas gent 589214 589214 Bagott, Thomas, of Myldenhale, gent 0
3921920 1997677 1997677 plaintiff Quasshe Thomas   589214 589214 Quasshe, Thomas, of Myldenhale 0
3923722 1998243 1998243 defendant Playse John roper 589214 589214 Playse, John, of Myldenhale, roper 0
3923723 1998243 1998243 defendant Carter William laborer 589214 589214 Carter, William, of Myldenhale, laborer 1
3923724 1998243 1998243 defendant Cole Richard tanner 589214 589214 Cole, Richard, of Myldenhale, tanner 2
3923725 1998243 1998243 defendant Hassett Richard husbandman 589214 589214 Hassett, Richard, of Myldenhale, husbandman 3
3941001 2003996 2003996 defendant Maye Nicholas husbandman 589214 589214 Maye, Nicholas, of Myldenhale, husbandman 0
3941733 2004250 2004250 defendant Quashe thomas yeoman of the Guard 589214 589214 Quashe, thomas, of Myldenhale, yeoman of the Guard 2
3954253 2008563 2008563 defendant Woodhowse Margery widow 589214 589214 Woodhowse, Margery, of Myldenhale, widow 0
3984877 2019346 2019346 plaintiff Thurston Robert tanner 589214 589214 Thurston, Robert, of Myldenhale, tanner 0
4136765 2073500 2073500 defendant Wright William butcher 589214 589214 Wright, William, of Myldenhale, butcher 1
4603504 2232284 2232284 defendant Dowe Bartholomew   589214 589214 Dowe, Bartholomew, of Myldenhale 0
4652443 2246713 2246713 plaintiff Backet John, senior   589214 589214 Backet, John, senior, of Myldenhale 0
4662913 2249863 2249863 plaintiff Galyon William   589214 589214 Galyon, William, of Myldenhale 0
4788543 2292478 2292478 defendant Hyne or Hyve William chapman 589214 589214 Hyne or Hyve, William, of Myldenhale, chapman 1
4944347 2340206 2340206 defendant Northen John   589214 589214 Northen, John, of Myldenhale, mason 0
4960494 2345107 2345107 defendant Bryghtwold John ostler 589214 589214 Bryghtwold, John, of Myldenhale, ostler 0
5032984 2366535 2366535 defendant Bery Roger dyer 589214 589214 Bery, Roger, of Myldenhale, dyer 0
5082932 2381396 2381396 defendant of Bury John dyer 589214 589214 of Bury, John, of Myldenhale, dyer 1
5101497 2386850 2386850 defendant Halsted Robert laborer 589214 589214 Halsted, Robert, of Myldenhale, laborer 0
5101564 2386876 2386876 defendant Halsted Robert laborer 589214 589214 Halsted, Robert, of Myldenhale, laborer 0
5102702 2387204 2387204 defendant Bowen Thomas gent 589214 589214 Bowen, Thomas, of Myldenhale, gent 0
5102703 2387204 2387204 defendant Sly John   589214 589214 Sly, John, of Myldenhale, wheelwright 1
5102704 2387204 2387204 defendant Cotton Thomas husbandman 589214 589214 Cotton, Thomas, of Myldenhale, husbandman 2
5102705 2387204 2387204 defendant Wryght Thomas husbandman 589214 589214 Wryght, Thomas, of Myldenhale, husbandman 3
5102706 2387204 2387204 defendant Wryght John laborer 589214 589214 Wryght, John, of Myldenhale, laborer 4
5102712 2387207 2387207 defendant Paget John husbandman 589214 589214 Paget, John, of Myldenhale, husbandman 0
5102714 2387207 2387207 defendant Sygeo Robert husbandman 589214 589214 Sygeo, Robert, of Myldenhale, husbandman 2
5102715 2387207 2387207 defendant Marette John butcher 589214 589214 Marette, John, of Myldenhale, butcher 3
5107894 2388745 2388745 defendant Osb- William dyer 589214 589214 Osb-, William, of Myldenhale, dyer 0
5117354 2391508 2391508 defendant Coo John barker 589214 589214 Coo, John, of Myldenhale, barker 1
5117355 2391508 2391508 defendant Aylesham John butcher 589214 589214 Aylesham, John, of Myldenhale, butcher 2
5117356 2391508 2391508 defendant Rost alias Howesse Robert butcher 589214 589214 Rost alias Howesse, Robert, of Myldenhale, butcher 3
5124468 2393618 2393618 plaintiff (illegible) (illegible) butcher 589214 589214 --, --, of Myldenhale, butcher 0
5141169 2398539 2398539 defendant Smyth John, junior yeoman 589214 589214 Smyth, John, junior, of Myldenhale, yeoman 0
5141170 2398539 2398539 defendant Cotton John yeoman 589214 589214 Cotton, John, of Myldenhale, yeoman 1
5141172 2398540 2398540 defendant Smyth John, junior yeoman 589214 589214 Smyth, John, junior, of Myldenhale, yeoman 0
5141173 2398540 2398540 defendant Cotton John yeoman 589214 589214 Cotton, John, of Myldenhale, yeoman 1
5169488 2406815 2406815 plaintiff Gregory John   589214 589214 Gregory, John, of Myldenhale 0
5186360 2411768 2411768 plaintiff Gregory John   589214 589214 Gregory, John, of Myldenhale 0
5201507 2416199 2416199 defendant Coleman Richard husbandman 589214 589214 Coleman, Richard, of Myldenhale, husbandman 0
5213314 2419626 2419626 defendant Sutton William glover 589214 589214 Sutton, William, of Myldenhale, glover 0
5232749 2425162 2425162 defendant Sutton John glover 589214 589214 Sutton, John, of Myldenhale, glover 0
5259112 2432963 2432963 plaintiff Dobyn John   589214 589214 Dobyn, John, of Myldenhale 7
5281134 2439554 2439554 defendant Chapman William (legal representative) 589214 589214 Chapman, William, of Myldenhale, executor of 4
5314177 2449255 2449255 plaintiff Dokyn John   589214 589214 Dokyn, John, of Myldenhale 1
5316572 2450042 2450042 plaintiff Dokyn John yeoman 589214 589214 Dokyn, John, of Myldenhale, yeoman 0
5323606 2452144 2452144 defendant Pynhorn Robert weaver 589214 589214 Pynhorn, Robert, of Myldenhale, weaver 2
5329741 2453967 2453967 defendant Bryghtwell Robert chapman 589214 589214 Bryghtwell, Robert, of Myldenhale, chapman 0
5332472 2454777 2454777 defendant Godard William husbandman 589214 589214 Godard, William, of Myldenhale, husbandman 0
5336816 2456076 2456076 defendant Mason Robert husbandman 589214 589214 Mason, Robert, of Myldenhale, husbandman 0
5340466 2457219 2457219 defendant Cullyng Thomas husbandman 589214 589214 Cullyng, Thomas, of Myldenhale, husbandman 0
5345260 2458689 2458689 defendant Kent John yeoman 589214 589214 Kent, John, of Myldenhale, yeoman 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);