names

396 rows where place_id = 592217

✎ 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
3606971 1869842 1869842 defendant Hiverden John husbandman 592217 592217 Hiverden, John, of Chichester, Sussex, husbandman 0
3606974 1869843 1869843 defendant Hyberden John husbandman 592217 592217 Hyberden, John, of Chichester, Sussex, husbandman 0
3616272 1872730 1872730 defendant Webbe Richard draper 592217 592217 Webbe, Richard, of Chichester, Sussex, draper 0
3616274 1872731 1872731 defendant Webbe Richard draper 592217 592217 Webbe, Richard, of Chichester, Sussex, draper 0
3619804 1873767 1873767 defendant Peyrs William saddler 592217 592217 Peyrs, William, of Chichester, Sussex, saddler 0
3622457 1874560 1874560 defendant Hardy Richard yeoman 592217 592217 Hardy, Richard, of Chichester, Sussex, yeoman 2
3645181 1908901 1908901 defendant Beverley William gent 592217 592217 (Beverley, William, of Chichester, Sussex, gent 1
3645842 1909104 1909104 defendant Ivery Thomas yeoman 592217 592217 Ivery, Thomas, of Chichester, Sussex, yeoman 0
3658819 1913017 1913017 defendant Troprote Robert merchant 592217 592217 Troprote, Robert, of Chichester, Sussex, merchant 0
3660780 1913636 1913636 defendant Topratt Robert yeoman 592217 592217 Topratt, Robert, of Chichester, Sussex, yeoman 0
3660782 1913637 1913637 defendant Topratt William yeoman 592217 592217 Topratt, William, of Chichester, Sussex, yeoman 0
3684678 1921340 1921340 defendant Hall John husbandman 592217 592217 Hall, John, of Chichester, Sussex, husbandman 1
3693476 1924172 1924172 defendant Hansfeld Richard butcher 592217 592217 Hansfeld, Richard, of Chichester, Sussex, butcher 1
3694370 1924443 1924443 defendant Beton William yeoman 592217 592217 Beton, William, of Chichester, Sussex, yeoman 2
3756240 1943911 1943911 defendant Broker John yeoman 592217 592217 Broker, John, of Chichester, Sussex, yeoman 0
3764553 1946571 1946571 defendant Byrcher Philip painter 592217 592217 Byrcher, Philip, of Chichester, Sussex, painter 0
3764558 1946572 1946572 defendant Byrcher Philip painter 592217 592217 Byrcher, Philip, of Chichester, Sussex, painter 0
3772874 1949212 1949212 defendant Freman Richard pewterer 592217 592217 Freman, Richard, of Chichester, Sussex, pewterer 0
3799133 1957638 1957638 defendant Philip John   592217 592217 Philip, John, of Chichester, Sussex, wax chandler 1
3799139 1957640 1957640 defendant Philipp John   592217 592217 Philipp, John, of Chichester, Sussex, wax chandler 1
3802036 1958535 1958535 defendant Owdeby Richard gent 592217 592217 Owdeby, Richard, of Chichester, Sussex, gent 0
3804240 1959260 1959260 plaintiff Shale alias Fryer William yeoman of the crown 592217 592217 Shale alias Fryer, William, of Chichester, Sussex, yeoman of the crown 0
3814149 1962329 1962329 defendant Awdeby Richard gent 592217 592217 Awdeby, Richard, of Chichester, Sussex, gent 0
3836632 1969361 1969361 defendant Hartley Adam mercer 592217 592217 Hartley, Adam, of Chichester, Sussex, mercer 0
3836638 1969363 1969363 defendant Cresweller Thomas mercer 592217 592217 Cresweller, Thomas, of Chichester, Sussex, mercer 2
3841346 1970870 1970870 defendant Gowlyff alias Godlyf John mercer 592217 592217 Gowlyff alias Godlyf, John, of Chichester, Sussex, mercer 0
3843253 1971423 1971423 defendant Redyng William pewterer 592217 592217 Redyng, William, of Chichester, Sussex, pewterer 1
3843257 1971424 1971424 defendant Redyng William pewterer 592217 592217 Redyng, William, of Chichester, Sussex, pewterer 1
3844053 1971685 1971685 defendant Harteley Adam yeoman 592217 592217 Harteley, Adam, of Chichester, Sussex, yeoman 1
3844057 1971686 1971686 defendant Hartley Adam yeoman 592217 592217 Hartley, Adam, of Chichester, Sussex, yeoman 1
3875242 1981960 1981960 defendant Forhey Thomas merchant 592217 592217 Forhey, Thomas, of Chichester, Sussex, merchant 0
3877356 1982673 1982673 defendant Ryve Richard mercer 592217 592217 Ryve, Richard, of Chichester, Sussex, mercer 1
3900849 1990513 1990513 defendant Cresweller John merchant 592217 592217 Cresweller, John, of Chichester, Sussex, merchant 0
3900858 1990516 1990516 defendant Hardham John, senior yeoman 592217 592217 Hardham, John, senior, of Chichester, Sussex, yeoman 0
3903564 1991420 1991420 defendant Draper Matthew innholder 592217 592217 Draper, Matthew, of Chichester, Sussex, innholder 1
3908715 1993211 1993211 defendant Exton John butcher 592217 592217 Exton, John, of Chichester, Sussex, butcher 0
3923164 1998055 1998055 plaintiff Sherwyn Peter (legal representative) 592217 592217 Sherwyn, Peter, of Chichester, Sussex, draper, executrix of 0
3924201 1998402 1998402 defendant Cresweller John merchant 592217 592217 Cresweller, John, of Chichester, Sussex, merchant 0
3925514 1998844 1998844 defendant Mullott Philip yeoman 592217 592217 Mullott, Philip, of Chichester, Sussex, yeoman 1
3926262 1999107 1999107 defendant Leweknor Nicholas gent 592217 592217 Leweknor, Nicholas, of Chichester, Sussex, gent 1
3928439 1999850 1999850 defendant Novey John chapman 592217 592217 Novey, John, of Chichester, sussex, chapman 1
3929416 2000183 2000183 defendant Ronyon Walter gent 592217 592217 Ronyon, Walter, of Chichester, Sussex, gent 0
3931079 2000709 2000709 defendant Payne Roger draper 592217 592217 Payne, Roger, of Chichester, Sussex, draper 0
3933295 2001431 2001431 defendant Novey alias Skynner John chapman 592217 592217 Novey alias Skynner, John, of Chichester, Sussex, chapman 0
3935642 2002233 2002233 defendant Barnam Robert merchant 592217 592217 Barnam, Robert, of Chichester, Sussex, merchant 0
3942390 2004467 2004467 defendant Barcombe William draper 592217 592217 Barcombe, William, of Chichester, Sussex, draper 0
3945260 2005427 2005427 defendant Russell Christopher yeoman 592217 592217 Russell, Christopher, of Chichester, Sussex, yeoman 0
3946274 2005774 2005774 defendant Adams Thomas chapman 592217 592217 Adams, Thomas, of Chichester, Sussex, chapman 1
3946646 2005891 2005891 defendant Westdene Ralph innheeper 592217 592217 Westdene, Ralph, of Chichester, Sussex, innheeper 2
3956809 2009452 2009452 defendant Knight Richard mercer 592217 592217 Knight, Richard, of Chichester, Sussex, mercer 0
3960066 2010618 2010618 defendant Lanes or Laues alias Hewys Thomas yeoman 592217 592217 Lanes or Laues alias Hewys, Thomas, of Chichester, Sussex, yeoman 0
3964644 2012241 2012241 defendant Barnet Mathew mercer 592217 592217 Barnet, Mathew, of Chichester, Sussex, mercer 0
3966723 2012995 2012995 defendant Tolpate Richard clothier 592217 592217 Tolpate, Richard, of Chichester, Sussex, clothier 0
3967226 2013166 2013166 defendant Barnerd Mathew merchant 592217 592217 Barnerd, Mathew, of Chichester, Sussex, merchant 0
3967228 2013167 2013167 defendant Taylor James merchant 592217 592217 Taylor, James, of Chichester, Sussex, merchant 0
3967230 2013168 2013168 defendant Taylor James merchant 592217 592217 Taylor, James, of Chichester, Sussex, merchant 0
3967621 2013310 2013310 defendant Elmes John innholder 592217 592217 Elmes, John, of Chichester, Sussex, innholder 0
3969539 2013957 2013957 defendant Barton Thomas merchant 592217 592217 Barton, Thomas, of Chichester, Sussex, merchant 0
3971692 2014660 2014660 defendant Barnard Mathew mercer 592217 592217 Barnard, Mathew, of Chichester, Sussex, mercer 0
3974842 2015766 2015766 plaintiff Hocke William   592217 592217 Hocke, William, of Chichester, Sussex 0
3977805 2016809 2016809 plaintiff Lyne Richard esq 592217 592217 Lyne, Richard, of Chichester, Sussex, esq 0
3978108 2016919 2016919 defendant Tolpatt Richard draper 592217 592217 Tolpatt, Richard, of Chichester, Sussex, draper 0
3980153 2017667 2017667 defendant Warde Richard draper 592217 592217 Warde, Richard, of Chichester, Sussex, draper 0
3990154 2021235 2021235 defendant Warde Richard alderman 592217 592217 Warde, Richard, of Chichester, Sussex, gent, alderman 0
3992150 2021956 2021956 defendant Taylor James merchant 592217 592217 Taylor, James, of Chichester, Sussex, merchant 0
4024270 2033381 2033381 defendant Moyses John beer brewer 592217 592217 Moyses, John, of Chichester, Sussex, beer brewer 2
4028413 2034814 2034814 defendant Machyn Thomas draper 592217 592217 Machyn, Thomas, of Chichester, Sussex, draper 1
4028416 2034815 2034815 defendant Machyn Thomas draper 592217 592217 Machyn, Thomas, of Chichester, Sussex, draper 1
4028976 2035008 2035008 defendant Wesden Ralph vintner 592217 592217 Wesden, Ralph, of Chichester, Sussex, vintner 0
4034512 2037015 2037015 defendant Fenner George gent 592217 592217 Fenner, George, of Chichester, Sussex, gent 0
4037781 2038164 2038164 defendant Taylor James yeoman 592217 592217 Taylor, James, of Chichester, Sussex, yeoman 0
4037783 2038165 2038165 defendant Taylor James yeoman 592217 592217 Taylor, James, of Chichester, Sussex, yeoman 0
4042602 2039824 2039824 defendant Howse Edmund innholder 592217 592217 Howse, Edmund, of Chichester, Sussex, innholder 0
4042729 2039875 2039875 defendant Higgones Thomas yeoman 592217 592217 Higgones, Thomas, of Chichester, Sussex, yeoman 3
4042946 2039952 2039952 defendant Elmes John innholder 592217 592217 Elmes, John, of Chichester, Sussex, innholder 2
4043647 2040185 2040185 defendant Fowle Robert goldsmith 592217 592217 Fowle, Robert, of Chichester, Sussex, goldsmith 3
4051458 2042942 2042942 defendant Sutton Jasper yeoman 592217 592217 Sutton, Jasper, of Chichester, Sussex, yeoman 1
4051462 2042943 2042943 defendant Sutton Jasper yeoman 592217 592217 Sutton, Jasper, of Chichester, Sussex, yeoman 1
4053960 2043793 2043793 defendant Sherwyn John mercer 592217 592217 Sherwyn, John, of Chichester, Sussex, mercer 0
4055763 2044446 2044446 defendant Fenner George gent 592217 592217 Fenner, George, of Chichester, Sussex, gent 0
4055767 2044447 2044447 defendant Fenner George gent 592217 592217 Fenner, George, of Chichester, Sussex, gent 0
4058281 2045346 2045346 defendant Temys Henry gent 592217 592217 Temys, Henry, of Chichester, Sussex, gent 0
4059486 2045789 2045789 defendant Haywarde Richard dyer 592217 592217 Haywarde, Richard, of Chichester, Sussex, dyer 1
4059502 2045793 2045793 plaintiff Cooke John, junior merchant 592217 592217 Cooke, John, junior, of Chichester, Sussex, merchant 0
4061076 2046369 2046369 defendant Bellingham Edward mercer 592217 592217 Bellingham, Edward, of Chichester, Sussex, mercer 0
4061468 2046501 2046501 defendant Dycconson William tailor 592217 592217 Dycconson, William, of Chichester, Sussex, tailor 1
4061955 2046675 2046675 defendant Devenishe William gent 592217 592217 Devenishe, William, of Chichester, Sussex, gent 0
4061957 2046676 2046676 defendant Devenishe William gent 592217 592217 Devenishe, William, of Chichester, Sussex, gent 0
4066530 2048322 2048322 defendant Yarworthe John gent 592217 592217 Yarworthe, John, of Chichester, Sussex, gent 0
4074359 2051133 2051133 defendant Devenyshe William gent 592217 592217 Devenyshe, William, of Chichester, Sussex, gent 0
4078512 2052613 2052613 defendant Gyllyngham Thomas gent 592217 592217 Gyllyngham, Thomas, of Chichester, Sussex, gent 0
4088256 2056095 2056095 defendant Turges Thomas merchant 592217 592217 Turges, Thomas, of Chichester, Sussex, merchant 1
4106747 2062706 2062706 defendant Bucks Robert gent 592217 592217 Bucks, Robert, of Chichester, Sussex, gent 0
4122836 2068460 2068460 defendant Turgys Thomas mercer 592217 592217 Turgys, Thomas, of Chichester, Sussex, mercer 0
4129003 2070676 2070676 defendant Fenner George   592217 592217 Fenner, George, of Chichester, Sussex, gernt 0
4135305 2072946 2072946 defendant Bennes Miles clerk 592217 592217 Bennes, Miles, of Chichester, Sussex, clerk 0
4141915 2075337 2075337 defendant Hudson John clerk 592217 592217 Hudson, John, of Chichester, Sussex, clerk 3
4142831 2075667 2075667 defendant Byrde John chapman 592217 592217 Byrde, John, of Chichester, Sussex, chapman 1
4142921 2075697 2075697 defendant Harmewood William mercer 592217 592217 Harmewood, William, of Chichester, Sussex, mercer 0
4152315 2078920 2078920 defendant Baker John blacksmith 592217 592217 Baker, John, of Chichester, Sussex, blacksmith 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);