names

338 rows where place_id = 587846

✎ 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
3592609 1865304 1865304 defendant Cole Giles yeoman 587846 587846 Cole, Giles, of Evesham, yeoman 0
3618472 1873403 1873403 plaintiff Handy Robert   587846 587846 Handy, Robert, of Evesham 0
3621315 1874209 1874209 defendant Kerver alias Taillour Richard yeoman 587846 587846 Kerver alias Taillour, Richard, of Evesham, yeoman 0
3625139 1875396 1875396 defendant Sylmaker John tanner 587846 587846 Sylmaker, John, of Evesham, tanner 4
3628913 1903921 1903921 defendant Kynge John draper 587846 587846 Kynge, John, of Evesham, draper 0
3632892 1905105 1905105 defendant Dorley Thomas glover 587846 587846 Dorley, Thomas, of Evesham, glover 0
3632898 1905106 1905106 defendant Dorley Thomas glover 587846 587846 Dorley, Thomas, of Evesham, glover 0
3634164 1905487 1905487 defendant Langworth William brewer 587846 587846 Langworth, William, of Evesham, brewer 0
3643712 1908460 1908460 defendant Ynce Robert butcher 587846 587846 Ynce, Robert, of Evesham, butcher 0
3643713 1908460 1908460 defendant Hurst John yeoman 587846 587846 Hurst, John, of Evesham, yeoman 1
3648684 1909975 1909975 defendant Ynse Robert butcher 587846 587846 Ynse, Robert, of Evesham, butcher 0
3650159 1910419 1910419 defendant Luar John cordwainer 587846 587846 Luar, John, of Evesham, cordwainer 3
3650798 1910613 1910613 defendant Hyet Robert glover 587846 587846 Hyet, Robert, of Evesham, glover 0
3661746 1913956 1913956 plaintiff Lichfield Clement   587846 587846 Lichfield, Clement, of Evesham, abbot of the monastery of St Mary & St Egwin 0
3670360 1916682 1916682 defendant Abek Robert carrier 587846 587846 Abek, Robert, of Evesham, carrier 0
3677375 1918973 1918973 defendant Clerk Roger carver 587846 587846 Clerk, Roger, of Evesham, carver 0
3680655 1920028 1920028 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3680657 1920029 1920029 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3680659 1920030 1920030 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3693128 1924061 1924061 plaintiff Love Thomas   587846 587846 Love, Thomas, of Evesham 0
3693130 1924062 1924062 plaintiff Love Thomas   587846 587846 Love, Thomas, of Evesham 0
3693132 1924063 1924063 plaintiff Love Thomas   587846 587846 Love, Thomas, of Evesham 0
3693134 1924064 1924064 plaintiff Love Thomas   587846 587846 Love, Thomas, of Evesham 0
3693356 1924135 1924135 defendant Carpenter William tanner 587846 587846 Carpenter, William, of Evesham, tanner 0
3693357 1924135 1924135 defendant Hyll Thomas yeoman 587846 587846 Hyll, Thomas, of Evesham, yeoman 1
3701439 1926695 1926695 defendant Broune Richard mercer 587846 587846 Broune, Richard, of Evesham, mercer 0
3712012 1930074 1930074 defendant Paswar Thomas scrivener 587846 587846 Paswar, Thomas, of Evesham, scrivener 4
3712013 1930074 1930074 defendant Smyth Randolph smith 587846 587846 Smyth, Randolph, of Evesham, smith 5
3716474 1931444 1931444 defendant Colet Thomas chaplain 587846 587846 Colet, Thomas, of Evesham, chaplain 9
3743095 1939694 1939694 defendant Watson Thomas yeoman 587846 587846 Watson, Thomas, of Evesham, yeoman 0
3752887 1942827 1942827 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3752889 1942828 1942828 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3752891 1942829 1942829 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3752893 1942830 1942830 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3755203 1943579 1943579 defendant Love Thomas merchant 587846 587846 Love, Thomas, of Evesham, merchant 0
3755204 1943579 1943579 defendant Mawe George laborer 587846 587846 Mawe, George, of Evesham, laborer 1
3769787 1948205 1948205 plaintiff Rudhale John gent 587846 587846 Rudhale, John, of Evesham, gent 0
3774113 1949619 1949619 plaintiff Alye Adam (legal representative) 587846 587846 Alye, Adam, of Evesham, executors of 0
3774121 1949620 1949620 plaintiff Alye Adam (legal representative) 587846 587846 Alye, Adam, of Evesham, executors of 0
3791063 1955035 1955035 defendant Dyer Thomas dyer 587846 587846 Dyer, Thomas, of Evesham, dyer 2
3791899 1955312 1955312 defendant Cowper Peter fisher 587846 587846 Cowper, Peter, of Evesham, fisher 4
3791907 1955313 1955313 defendant Daly William mercer 587846 587846 Daly, William, of Evesham, mercer 3
3794931 1956281 1956281 defendant Wynton Henry yeoman 587846 587846 Wynton, Henry, of Evesham, yeoman 3
3796978 1956934 1956934 defendant Woode Thomas capper 587846 587846 Woode, Thomas, of Evesham, capper 1
3803847 1959118 1959118 plaintiff Rudhale John (legal representative) 587846 587846 Rudhale, John, of Evesham, gent, administratrix of 0
3804724 1959423 1959423 defendant Baly William mercer 587846 587846 Baly, William, of Evesham, mercer 0
3816315 1963010 1963010 defendant Collard Arthur draper 587846 587846 Collard, Arthur, of Evesham, draper 0
3824357 1965489 1965489 plaintiff Watson Thomas yeoman 587846 587846 Watson, Thomas, of Evesham, yeoman 0
3884280 1985007 1985007 defendant Wolryche Humphrey gent 587846 587846 Wolryche, Humphrey, of Evesham, gent 0
3896750 1989125 1989125 plaintiff Wall Philip (legal representative) 587846 587846 Wall, Philip, of Evesham, executrix of 0
3908009 1992971 1992971 defendant Parkys John clerk 587846 587846 (Parkys, John, of Evesham, clerk 1
3908010 1992971 1992971 defendant Bradley William yeoman 587846 587846 Bradley, William, of Evesham, yeoman 2
3911407 1994130 1994130 defendant Cotys Thomas gent or innholder 587846 587846 Cotys, Thomas, of Evesham, gent or innholder 0
3921726 1997609 1997609 defendant Parkys John clerk 587846 587846 (Parkys, John, of Evesham, clerk 1
3921727 1997609 1997609 defendant Bradeley William yeoman 587846 587846 Bradeley, William, of Evesham, yeoman 2
3925482 1998836 1998836 defendant Blewe William walker 587846 587846 Blewe, William, of Evesham, walker 0
3925483 1998836 1998836 defendant Nasshe William walker 587846 587846 Nasshe, William, of Evesham, walker 1
3927715 1999607 1999607 defendant Tynker Richard glover 587846 587846 Tynker, Richard, of Evesham, glover 1
3935497 2002180 2002180 defendant Eliottes John chapman 587846 587846 Eliottes, John, of Evesham, chapman 3
3935671 2002242 2002242 defendant Tolly Bartholomew   587846 587846 Tolly, Bartholomew, of Evesham 0
3938342 2003160 2003160 defendant Mun Richard tanner 587846 587846 Mun, Richard, of Evesham, tanner 1
3940699 2003896 2003896 defendant Madley John tanner 587846 587846 Madley, John, of Evesham, tanner 0
3942000 2004334 2004334 plaintiff Waynewryght William butcher 587846 587846 Waynewryght, William, of Evesham, butcher 0
3942002 2004335 2004335 plaintiff Waynwryght William   587846 587846 Waynwryght, William, of Evesham 0
3942638 2004546 2004546 defendant Elyottes John mercer 587846 587846 Elyottes, John, of Evesham, mercer 0
3958206 2009943 2009943 defendant Clarke William mercer 587846 587846 Clarke, William, of Evesham, mercer 0
3974785 2015744 2015744 defendant Mounde Thomas tanner 587846 587846 Mounde, Thomas, of Evesham, tanner 0
3974786 2015744 2015744 defendant Mounde Edward tanner 587846 587846 Mounde, Edward, of Evesham, tanner 1
3974787 2015744 2015744 defendant Allen Richard shoemaker 587846 587846 Allen, Richard, of Evesham, shoemaker 2
3988202 2020528 2020528 defendant Mounde Edward tanner 587846 587846 Mounde, Edward, of Evesham, tanner 0
4002809 2025772 2025772 defendant Tollie Philip (legal representative) 587846 587846 Tollie, Philip, of Evesham, yeoman, executors of 0
4017445 2030945 2030945 defendant Prescott Richard tailor 587846 587846 Prescott, Richard, of Evesham, tailor 0
4017704 2031040 2031040 plaintiff Tolly or Colly Philip (legal representative) 587846 587846 Tolly or Colly, Philip, of Evesham, executors of 0
4021970 2032586 2032586 defendant Mun Edward tanner 587846 587846 Mun, Edward, of Evesham, tanner 0
4022117 2032639 2032639 plaintiff Androwes William yeoman 587846 587846 Androwes, William, of Evesham, yeoman 0
4022119 2032640 2032640 plaintiff Androwes William yeoman 587846 587846 Androwes, William, of Evesham, yeoman 0
4022120 2032640 2032640 defendant Wynnoll Edmund butcher 587846 587846 Wynnoll, Edmund, of Evesham, butcher 0
4023937 2033266 2033266 defendant Androwes William yeoman 587846 587846 Androwes, William, of Evesham, yeoman 0
4062592 2046914 2046914 plaintiff Fotherye John haberdasher 587846 587846 Fotherye, John, of Evesham, haberdasher 0
4075768 2051638 2051638 defendant Pratt Richard yeoman or collar maker 587846 587846 Pratt, Richard, of Evesham, yeoman or collar maker 0
4082737 2054134 2054134 defendant Baylye Richard draper 587846 587846 Baylye, Richard, of Evesham, draper 0
4082738 2054134 2054134 defendant Baylye John bookbinder 587846 587846 Baylye, John, of Evesham, bookbinder 1
4082740 2054135 2054135 defendant Baylye Richard draper 587846 587846 Baylye, Richard, of Evesham, draper 0
4082749 2054137 2054137 defendant Mound or Munde Edward yeoman 587846 587846 Mound or Munde, Edward, of Evesham, yeoman 2
4082754 2054138 2054138 defendant Mound Edward yeoman 587846 587846 Mound, Edward, of Evesham, yeoman 2
4087947 2055982 2055982 defendant Byddell William clothier 587846 587846 Byddell, William, of Evesham, clothier 0
4087949 2055983 2055983 defendant Byddell William clothier 587846 587846 Byddell, William, of Evesham, clothier 0
4089648 2056591 2056591 plaintiff Cokesey William esq 587846 587846 Cokesey, William, of Evesham, esq 0
4090047 2056724 2056724 defendant Baylies Walter yeoman 587846 587846 Baylies, Walter, of Evesham, yeoman 0
4091408 2057216 2057216 defendant Mons or Monde Edward yeoman 587846 587846 Mons or Monde, Edward, of Evesham, yeoman 0
4130036 2071047 2071047 defendant Wynckle Robert butcher 587846 587846 Wynckle, Robert, of Evesham, butcher 0
4133647 2072367 2072367 defendant Saunders alias Baker William yeoman 587846 587846 Saunders alias Baker, William, of Evesham, yeoman 0
4134800 2072767 2072767 defendant Stanley Edward esq 587846 587846 Stanley, Edward, of Evesham, esq 0
4136543 2073413 2073413 defendant Bedell William clothier 587846 587846 Bedell, William, of Evesham, clothier 0
4136785 2073506 2073506 defendant Johnson Robert shoemaker 587846 587846 Johnson, Robert, of Evesham, shoemaker 0
4168405 2084435 2084435 defendant Vyse John yeoman 587846 587846 Vyse, John, of Evesham, yeoman 1
4177049 2087446 2087446 defendant Travis Henry mercer 587846 587846 Travis, Henry, of Evesham, mercer 0
4178137 2087823 2087823 defendant Banck James yeoman 587846 587846 Banck, James, of Evesham, yeoman 0
4181288 2088936 2088936 defendant Baylyes John bookbinder 587846 587846 Baylyes, John, of Evesham, bookbinder 1
4184266 2089996 2089996 defendant Byrd William chapman 587846 587846 Byrd, William, of Evesham, chapman 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);