names

184 rows where place_id = 594993

✎ 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
3618403 1873390 1873390 defendant Puggesley Richard husbandman 594993 594993 Puggesley, Richard, of Whitchurche, husbandman 0
3619569 1873687 1873687 defendant Walshe Thomas butcher 594993 594993 Walshe, Thomas, of Whitchurche, butcher 0
3619570 1873687 1873687 defendant Shelton Richard barker 594993 594993 Shelton, Richard, of Whitchurche, barker 1
3637952 1906689 1906689 defendant Michell Joan widow 594993 594993 Michell, Joan, of Whitchurche, widow 2
3660565 1913565 1913565 defendant Nycke Robert gent 594993 594993 Nycke, Robert, of Whitchurche, gent 0
3665786 1915241 1915241 plaintiff Belles Richard   594993 594993 Belles, Richard, of Whitchurche 2
3671439 1917047 1917047 defendant Heywode John husbandman 594993 594993 Heywode, John, of Whitchurche, husbandman 0
3682431 1920606 1920606 defendant Shelton Roger yeoman 594993 594993 Shelton, Roger, of Whitchurche, yeoman 0
3682432 1920606 1920606 defendant Baker Thomas yeoman 594993 594993 Baker, Thomas, of Whitchurche, yeoman 1
3682956 1920784 1920784 defendant Rawe Richard yeoman 594993 594993 Rawe, Richard, of Whitchurche, yeoman 0
3682957 1920784 1920784 defendant Estman Richard   594993 594993 Estman, Richard, of Whitchurche, shepherd 1
3692658 1923893 1923893 defendant Resedewe Robert husbandman 594993 594993 Resedewe, Robert, of Whitchurche, husbandman 0
3692659 1923893 1923893 defendant Bremelcombe Richard   594993 594993 Bremelcombe, Richard, of Whitchurche, groom 1
3692660 1923893 1923893 defendant Goodyng William husbandman 594993 594993 Goodyng, William, of Whitchurche, husbandman 2
3692661 1923893 1923893 defendant Parquyn John husbandman 594993 594993 Parquyn, John, of Whitchurche, husbandman 3
3697582 1925466 1925466 defendant Shelton Roger yeoman 594993 594993 Shelton, Roger, of Whitchurche, yeoman 0
3697583 1925466 1925466 defendant Baker Thomas yeoman 594993 594993 Baker, Thomas, of Whitchurche, yeoman 1
3704773 1927783 1927783 defendant Cotton John fuller 594993 594993 Cotton, John, of Whitchurche, fuller 0
3706922 1928451 1928451 defendant Rosedewe Robert husbandman 594993 594993 Rosedewe, Robert, of Whitchurche, husbandman 0
3706923 1928451 1928451 defendant Bremylcombe Richard   594993 594993 Bremylcombe, Richard, of Whitchurche, groom 1
3706924 1928451 1928451 defendant Godyng William husbandman 594993 594993 Godyng, William, of Whitchurche, husbandman 2
3706925 1928451 1928451 defendant Parquyn John husbandman 594993 594993 Parquyn, John, of Whitchurche, husbandman 3
3718230 1931984 1931984 defendant Wylson John yeoman 594993 594993 Wylson, John, of Whitchurche, yeoman 0
3729808 1935579 1935579 defendant Walche Thomas tailor 594993 594993 Walche, Thomas, of Whitchurche, tailor 1
3733293 1936646 1936646 defendant Barfote William laborer 594993 594993 Barfote, William, of Whitchurche, laborer 0
3743714 1939916 1939916 defendant Wylson John yeoman 594993 594993 Wylson, John, of Whitchurche, yeoman 0
3751504 1942384 1942384 defendant Lowyn Agnes widow 594993 594993 Lowyn, Agnes, of Whitchurche, widow 0
3775198 1949977 1949977 defendant Whitburn John miller 594993 594993 Whitburn, John, of Whitchurche, miller 0
3775368 1950037 1950037 defendant Barfote William mercer 594993 594993 Barfote, William, of Whitchurche, mercer 0
3779837 1951427 1951427 defendant Marten John husbandman 594993 594993 Marten, John, of Whitchurche, gent, Farnborough, Edward, of Hartwell, husbandman 0
3779840 1951427 1951427 defendant Wylson John husbandman 594993 594993 Wylson, John, of Whitchurche, husbandman 3
3782848 1952385 1952385 defendant Barefote William maltman 594993 594993 Barefote, William, of Whitchurche, maltman 0
3794332 1956103 1956103 defendant Godgame John husbandman 594993 594993 Godgame, John, of Whitchurche, husbandman 1
3795085 1956329 1956329 defendant Marten John gent 594993 594993 Marten, John, of Whitchurche, gent 1
3795086 1956329 1956329 defendant Woode Roger toper 594993 594993 Woode, Roger, of Whitchurche, toper 2
3800002 1957924 1957924 defendant Marten John gent 594993 594993 Marten, John, of Whitchurche, gent 0
3800003 1957924 1957924 defendant Wylson John yeoman 594993 594993 Wylson, John, of Whitchurche, yeoman 1
3812093 1961694 1961694 defendant Marten John gent 594993 594993 Marten, John, of Whitchurche, gent 0
3812094 1961694 1961694 defendant Woode Roger roper 594993 594993 Woode, Roger, of Whitchurche, roper 1
3817734 1963451 1963451 defendant Wilson John husbandman 594993 594993 Wilson, John, of Whitchurche, husbandman 0
3823760 1965329 1965329 defendant Torperley Richard butcher 594993 594993 Torperley, Richard, of Whitchurche, butcher 0
3823761 1965329 1965329 defendant Broughall John innholder 594993 594993 Broughall, John, of Whitchurche, innholder 1
3825375 1965786 1965786 defendant Honer Richard husbandman 594993 594993 Honer, Richard, of Whitchurche, husbandman 3
3828225 1966698 1966698 defendant Graunge William husbandman 594993 594993 Graunge, William, of Whitchurche, husbandman 0
3833552 1968426 1968426 defendant Warde William laborer 594993 594993 Warde, William, of Whitchurche, laborer 1
3837176 1969528 1969528 defendant Ley John tailor 594993 594993 Ley, John, of Whitchurche, tailor 1
3862527 1977662 1977662 defendant Colles Richard yeoman 594993 594993 Colles, Richard, of Whitchurche, yeoman 0
3862528 1977662 1977662 defendant Grene Thomas yeoman 594993 594993 Grene, Thomas, of Whitchurche, yeoman 1
3862529 1977662 1977662 defendant Goodgame George husbandman 594993 594993 Goodgame, George, of Whitchurche, husbandman 2
3887740 1986155 1986155 defendant Cotton Ralph chapman 594993 594993 Cotton, Ralph, of Whitchurche, chapman 2
3901494 1990724 1990724 plaintiff Cotton Thomas tanner 594993 594993 Cotton, Thomas, of Whitchurche, tanner 0
3931431 2000811 2000811 defendant Pony John husbandman 594993 594993 Pony, John, of Whitchurche, husbandman 0
3933952 2001655 2001655 defendant Knappe Henry yeoman 594993 594993 Knappe, Henry, of Whitchurche, yeoman 1
3935754 2002266 2002266 defendant Sheldon Mary spinster 594993 594993 Sheldon, Mary, of Whitchurche, spinster 2
3935755 2002266 2002266 defendant Sheldon Margaret spinster 594993 594993 Sheldon, Margaret, of Whitchurche, spinster 3
3937732 2002952 2002952 defendant Homes Thomas husbandman 594993 594993 Homes, Thomas, of Whitchurche, husbandman 1
3938825 2003326 2003326 defendant Welle Edmund yeoman 594993 594993 Welle, Edmund, of Whitchurche, yeoman 1
3938826 2003326 2003326 defendant Martyn Richard yeoman 594993 594993 Martyn, Richard, of Whitchurche, yeoman 2
3956963 2009500 2009500 defendant Hames or Haines John yeoman 594993 594993 Hames or Haines, John, of Whitchurche, yeoman 4
3975805 2016100 2016100 defendant Sympoll John yeoman 594993 594993 Sympoll, John, of Whitchurche, yeoman 0
3977251 2016614 2016614 defendant Cotton William yeoman 594993 594993 Cotton, William, of Whitchurche, yeoman 1
3985136 2019436 2019436 defendant Chydley William gent 594993 594993 Chydley, William, of Whitchurche, gent 1
3989159 2020859 2020859 defendant Longe Nicholas husbandman 594993 594993 Longe, Nicholas, of Whitchurche, husbandman 1
3991829 2021831 2021831 defendant Morgan Edward gent 594993 594993 Morgan, Edward, of Whitchurche, or of Cleverton, Leye, gent 0
4009008 2027987 2027987 plaintiff Mullyns John (legal representative) 594993 594993 Mullyns, John, of Whitchurche, executrix of 0
4042343 2039745 2039745 defendant Vale William husbandman 594993 594993 Vale, William, of Whitchurche, husbandman 0
4042344 2039745 2039745 defendant Day John husbandman 594993 594993 Day, John, of Whitchurche, husbandman 1
4049278 2042189 2042189 plaintiff Turbervyll Nicholas esq 594993 594993 Turbervyll, Nicholas, of Whitchurche, esq 0
4063335 2047177 2047177 defendant Evered Richard yeoman 594993 594993 Evered, Richard, of Whitchurche, yeoman 0
4066970 2048483 2048483 defendant Constantine Richard gent 594993 594993 Constantine, Richard, of Whitchurche, gent 0
4082313 2053984 2053984 defendant Bagge John yeoman 594993 594993 Bagge, John, of Whitchurche, yeoman 0
4082315 2053985 2053985 defendant Bagge John yeoman 594993 594993 Bagge, John, of Whitchurche, yeoman 0
4098403 2059757 2059757 defendant Somer Alexander tailor 594993 594993 Somer, Alexander, of Whitchurche, husbandman, tailor 0
4102673 2061255 2061255 defendant Lee John sherman 594993 594993 Lee, John, of Whitchurche, sherman 1
4102675 2061255 2061255 defendant Walker John tailor 594993 594993 Walker, John, of Whitchurche, or of Edgemond, tailor 3
4106857 2062746 2062746 defendant Dounton Richard gent 594993 594993 Dounton, Richard, of Whitchurche, gent 0
4106858 2062746 2062746 defendant Dountonne Richard gent 594993 594993 Dountonne, Richard, of Whitchurche, gent 1
4126129 2069635 2069635 defendant Salter alias Ellyott John yeoman 594993 594993 Salter alias Ellyott, John, of Whitchurche, yeoman 0
4146621 2076971 2076971 defendant Wilcockes Jerome yeoman 594993 594993 Wilcockes, Jerome, of Whitchurche, yeoman 1
4146755 2077018 2077018 defendant Mullyns John yeoman 594993 594993 Mullyns, John, of Whitchurche, yeoman 1
4152988 2079150 2079150 defendant Boroughall Thomas innholder 594993 594993 Boroughall, Thomas, of Whitchurche, innholder 0
4172250 2085758 2085758 defendant Dennys John husbandman 594993 594993 Dennys, John, of Whitchurche, husbandman 0
4191203 2092489 2092489 defendant Gyttyn Hugh laborer 594993 594993 Gyttyn, Hugh, of Whitchurche, laborer 0
4191204 2092489 2092489 defendant Poole Nicholas carrier 594993 594993 Poole, Nicholas, of Whitchurche, carrier 1
4191205 2092489 2092489 defendant Newnam Martin capper 594993 594993 Newnam, Martin, of Whitchurche, capper 2
4191206 2092489 2092489 defendant Davyes Katherine spinster 594993 594993 Davyes, Katherine, of Whitchurche, spinster 3
4197644 2094732 2094732 defendant Haynes Thomas yeoman 594993 594993 Haynes, Thomas, of Whitchurche, yeoman 0
4206866 2097943 2097943 defendant Longe Walter victualer 594993 594993 Longe, Walter, of Whitchurche, victualer 0
4206868 2097943 2097943 defendant Mullyns John yeoman 594993 594993 Mullyns, John, of Whitchurche, yeoman 2
4209237 2098784 2098784 defendant Whitewood William   594993 594993 Whitewood, William, of Whitchurche, husbandman, his son 1
4209238 2098784 2098784 defendant Puxley Thomas husbandman 594993 594993 Puxley, Thomas, of Whitchurche, husbandman 2
4209239 2098784 2098784 defendant Gaye Thomas husbandman 594993 594993 Gaye, Thomas, of Whitchurche, husbandman 3
4210203 2099129 2099129 defendant Chepman John yeoman 594993 594993 Chepman, John, of Whitchurche, yeoman 2
4210207 2099130 2099130 defendant Molling John yeoman 594993 594993 Molling, John, of Whitchurche, yeoman 2
4212736 2099995 2099995 defendant Welsted William yeoman 594993 594993 Welsted, William, of Whitchurche, yeoman 1
4219862 2102447 2102447 defendant Lewes Thomas husbandman 594993 594993 Lewes, Thomas, of Whitchurche, or of New Woodhowse, Salop, husbandman 0
4228814 2105559 2105559 defendant Lewes Thomas husbandman 594993 594993 Lewes, Thomas, of Whitchurche, or of New Woodhowse, Salop, husbandman 0
4228815 2105559 2105559 defendant Whittingham Ralph husbandman 594993 594993 Whittingham, Ralph, of Whitchurche, husbandman 1
4231295 2106446 2106446 defendant Overton William chapman 594993 594993 Overton, William, of Whitchurche, chapman 0
4248185 2112381 2112381 defendant Phelpott David yeoman 594993 594993 Phelpott, David, of Whitchurche, yeoman 2

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