names

306 rows where place_id = 588611

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593022 1865445 1865445 defendant Ferrour Eleanor widow 588611 588611 (Ferrour, Eleanor, of Strode Water, widow 1
3595049 1866084 1866084 defendant Loveday Henry husbandman 588611 588611 Loveday, Henry, of Strode, husbandman 2
3597744 1866915 1866915 defendant Russell John   588611 588611 Russell, John, of Strode, tallow chandler 0
3597745 1866915 1866915 defendant Norys Mathew yeoman 588611 588611 Norys, Mathew, of Strode, yeoman 1
3597746 1866915 1866915 defendant Yong William yeoman 588611 588611 Yong, William, of Strode, yeoman 2
3597784 1866924 1866924 defendant Short John yeoman 588611 588611 Short, John, of Strode, yeoman 0
3598093 1867032 1867032 defendant Banknate William yeoman 588611 588611 Banknate, William, of Strode, yeoman 0
3602398 1868411 1868411 defendant Lychefeld Edmund master of St Mary Hospital 588611 588611 Lychefeld, Edmund, of Strode, clerk, master of St Mary Hospital 0
3602400 1868412 1868412 defendant Lychefeld Edmund master of St Mary Hospital 588611 588611 Lychefeld, Edmund, of Strode, clerk, master of St Mary Hospital 0
3614591 1872212 1872212 defendant Hade Thomas (legal representative) 588611 588611 Hade, Thomas, of Strode, gent, executrix of 0
3614592 1872212 1872212 defendant Dunton Alice widow 588611 588611 Dunton, Alice, of Strode, widow 1
3617582 1873121 1873121 defendant Gryme Margery widow 588611 588611 Gryme, Margery, of Strode, widow 1
3617614 1873131 1873131 defendant Twysyll Thomas yeoman 588611 588611 Twysyll, Thomas, of Strode, yeoman 0
3617615 1873131 1873131 defendant Philip Richard baker 588611 588611 Philip, Richard, of Strode, baker 1
3618371 1873377 1873377 defendant Adams Geoffrey smith 588611 588611 Adams, Geoffrey, of Strode, smith 1
3625373 1875476 1875476 defendant Jonys Maud widow 588611 588611 Jonys, Maud, of Strode, widow 1
3625374 1875476 1875476 defendant Wye John   588611 588611 Wye, John, of Strode, mason 2
3625375 1875476 1875476 defendant Dudbrigge Henry tucker 588611 588611 Dudbrigge, Henry, of Strode, tucker 3
3637270 1906459 1906459 defendant Davy John yeoman 588611 588611 Davy, John, of Strode, yeoman 0
3637272 1906460 1906460 defendant Dunton Robert (legal representative) 588611 588611 Dunton, Robert, of Strode, yeoman, executors of 0
3637273 1906460 1906460 defendant Davy John yeoman 588611 588611 (Davy, John, of Strode, yeoman 1
3640543 1907479 1907479 defendant Munde John pardoner 588611 588611 Munde, John, of Strode, pardoner 0
3646818 1909409 1909409 defendant Banknop Thomas tucker 588611 588611 Banknop, Thomas, of Strode Water, tucker 0
3654424 1911646 1911646 plaintiff Atkynson Robert   588611 588611 Atkynson, Robert, of Strode, notary 0
3656680 1912341 1912341 defendant Long Richard fuller of cloth 588611 588611 Long, Richard, of Strode water, fuller of cloth 0
3664923 1914974 1914974 defendant Davy John yeoman 588611 588611 (Davy, John, of Strode, yeoman 1
3676311 1918635 1918635 plaintiff Atterbury John yeoman 588611 588611 Atterbury, John, of Strode, yeoman 1
3689432 1922853 1922853 defendant Atkynson Robert yeoman 588611 588611 Atkynson, Robert, of Strode, yeoman 0
3689437 1922854 1922854 defendant Atkynson Robert yeoman 588611 588611 Atkynson, Robert, of Strode, yeoman 0
3696803 1925225 1925225 defendant Carre Mathe yeoman 588611 588611 Carre, Mathe, of Strode, yeoman 0
3698052 1925618 1925618 defendant None Alice widow 588611 588611 (None, Alice, of Strode, widow 1
3698053 1925618 1925618 defendant Pesoke Thomas   588611 588611 Pesoke, Thomas, of Strode 2
3710535 1929616 1929616 defendant Carre Mathew yeoman 588611 588611 Carre, Mathew, of Strode, yeoman 0
3711798 1930004 1930004 defendant None Alice widow 588611 588611 (None, Alice, of Strode, widow 1
3711799 1930004 1930004 defendant Pesoke Thomas yeoman 588611 588611 Pesoke, Thomas, of Strode, yeoman 2
3715096 1931019 1931019 defendant Tayllour Edmund butcher 588611 588611 Tayllour, Edmund, of Strode, butcher 0
3716869 1931564 1931564 defendant Blakamore John laborer 588611 588611 (Blakamore, John, of Strode, laborer 1
3722759 1933384 1933384 defendant Carre Matthew   588611 588611 Carre, Matthew, of Strode 1
3723807 1933722 1933722 defendant Carre Mathew yeoman 588611 588611 Carre, Mathew, of Strode, yeoman 1
3726557 1934563 1934563 defendant Cloterbuk Thomas tucker 588611 588611 Cloterbuk, Thomas, of Strode Water, tucker 2
3729412 1935446 1935446 defendant Weyver Edward (legal representative) 588611 588611 Weyver, Edward, of Strode, clothman, executors of 0
3729413 1935446 1935446 defendant Selwyne William yeoman 588611 588611 (Selwyne, William, of Strode, yeoman 1
3732547 1936409 1936409 defendant None Thomas (legal representative) 588611 588611 None, Thomas, of Strode, executors of 0
3732548 1936409 1936409 defendant Blakemore John laborer 588611 588611 (Blakemore, John, of Strode, laborer 1
3732865 1936507 1936507 defendant Selwyn William yeoman 588611 588611 (Selwyn, William, of Strode, yeoman 1
3737784 1938038 1938038 defendant Davy John yeoman 588611 588611 Davy, John, of Strode, yeoman 0
3744474 1940175 1940175 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 1
3744475 1940175 1940175 defendant Dams Giles clothier 588611 588611 Dams, Giles, of Strode, clothier 2
3752009 1942551 1942551 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 0
3752010 1942551 1942551 defendant Vycaredye Richard laborer 588611 588611 Vycaredye, Richard, of Strode, laborer 1
3752022 1942554 1942554 defendant Erly John yeoman 588611 588611 Erly, John, of Strode, yeoman 0
3759376 1944920 1944920 defendant James John mercer 588611 588611 James, John, of Strode, mercer 1
3759377 1944920 1944920 defendant Mosam Alan brewer 588611 588611 Mosam, Alan, of Strode, brewer 2
3773657 1949479 1949479 defendant Edwyke Edward butcher 588611 588611 Edwyke, Edward, of Strode, butcher 0
3774758 1949834 1949834 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 0
3774759 1949834 1949834 defendant Davys Giles clothier 588611 588611 Davys, Giles, of Strode, clothier 1
3774764 1949835 1949835 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 1
3774765 1949835 1949835 defendant Davys Giles clothier 588611 588611 Davys, Giles, of Strode, clothier 2
3779531 1951323 1951323 defendant Mosyn Alan brewer 588611 588611 Mosyn, Alan, of Strode, brewer 0
3784691 1952999 1952999 defendant Dene William yeoman 588611 588611 Dene, William, of Strode, yeoman 0
3786305 1953508 1953508 defendant Vicarage Richard laborer 588611 588611 Vicarage, Richard, of Strode, laborer 0
3786306 1953508 1953508 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 1
3791414 1955151 1955151 defendant Edwyk Thomas butcher 588611 588611 Edwyk, Thomas, of Strode, butcher 1
3809016 1960702 1960702 defendant Colam Alice widow 588611 588611 Colam, Alice, of Strode, widow 0
3809017 1960702 1960702 defendant Davys Giles clothier 588611 588611 Davys, Giles, of Strode, clothier 1
3817281 1963316 1963316 defendant Pery Edward yeoman 588611 588611 Pery, Edward, of Strode, yeoman 1
3861514 1977313 1977313 defendant Peers John tucker 588611 588611 Peers, John, of Strode Water, tucker 0
3864134 1978190 1978190 defendant Otterbery John yeoman 588611 588611 Otterbery, John, of Strode, yeoman 0
3880103 1983600 1983600 defendant Fowler Roger tucker 588611 588611 Fowler, Roger, of Strode, tucker 2
3892522 1987744 1987744 defendant Evans Lewis tucker 588611 588611 Evans, Lewis, of Strode, tucker 0
3940696 2003895 2003895 defendant Newman John yeoman 588611 588611 Newman, John, of Strode, yeoman 0
3962602 2011511 2011511 defendant Davys William chapman 588611 588611 Davys, William, of Strode, chapman 0
4418620 2170694 2170694 defendant Derby Geoffrey de   588611 588611 Derby, Geoffrey de, of Strode 0
4421752 2171685 2171685 defendant Lymynge Thomas   588611 588611 Lymynge, Thomas, of Strode 0
4421754 2171686 2171686 defendant Lymynge Thomas   588611 588611 Lymynge, Thomas, of Strode 0
4438734 2181405 2181405 defendant Noble Richard   588611 588611 Noble, Richard, of Strode 1
4475582 2193049 2193049 defendant Penders Philip   588611 588611 Penders, Philip, of Strode 3
4478704 2194004 2194004 defendant Man William   588611 588611 Man, William, of Strode, son of William Man 0
4478714 2194008 2194008 plaintiff Hobbe Nicholas   588611 588611 Hobbe, Nicholas, of Strode 0
4487842 2196912 2196912 defendant Wade Henry   588611 588611 Wade, Henry, of Strode 0
4499910 2200609 2200609 plaintiff Hobbe Nicholas   588611 588611 Hobbe, Nicholas, of Strode 0
4514222 2204866 2204866 defendant Mounfort John   588611 588611 Mounfort, John, of Strode 0
4514893 2205071 2205071 defendant Cha_neys William   588611 588611 Cha_neys, William, of Strode, mason 0
4528572 2209214 2209214 defendant Lemman John   588611 588611 Lemman, John, of Strode 0
4529213 2209416 2209416 plaintiff Mill John   588611 588611 Mill, John, of Strode 0
4538801 2212408 2212408 defendant Reynner Nicholas   588611 588611 Reynner, Nicholas, of Strode 0
4538803 2212409 2212409 defendant Reyner Nicholas   588611 588611 Reyner, Nicholas, of Strode 0
4539319 2212557 2212557 defendant Chaumpeneys William   588611 588611 Chaumpeneys, William, of Strode 0
4546294 2214774 2214774 defendant Spicer Adam   588611 588611 Spicer, Adam, of Strode 0
4553635 2217061 2217061 defendant Dorylot John   588611 588611 Dorylot, John, of Strode 0
4555076 2217518 2217518 defendant Muriell John skinner 588611 588611 Muriell, John, of Strode, skinner 0
4555078 2217519 2217519 defendant Muryell John skinner 588611 588611 Muryell, John, of Strode, skinner 0
4564070 2220334 2220334 defendant Barbour John   588611 588611 Barbour, John, of Strode 0
4564071 2220334 2220334 defendant Lambe Robert   588611 588611 togther with Lambe, Robert, of Strode 1
4564073 2220335 2220335 defendant Lambe Robert   588611 588611 Lambe, Robert, of Strode 0
4569023 2221898 2221898 plaintiff Warner John   588611 588611 Warner, John, of Strode 0
4571402 2222642 2222642 defendant Neweman John   588611 588611 Neweman, John, of Strode 0
4572141 2222838 2222838 defendant Laurens Nicholas   588611 588611 Laurens, Nicholas, of Strode 1
4581674 2225714 2225714 defendant Bolle John   588611 588611 Bolle, John, of Strode 2
4588673 2227834 2227834 defendant Champeneys William   588611 588611 Champeneys, William, of Strode 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);