names

355 rows where place_id = 588931

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596036 1866388 1866388 defendant Mey John husbandman 588931 588931 Mey, John, of Horsham St Faith, husbandman 1
3600488 1867799 1867799 defendant Rythers Thomas husbandman 588931 588931 Rythers, Thomas, of Horsham St Faith, husbandman 2
3602493 1868439 1868439 defendant Meye Robert husbandman 588931 588931 Meye, Robert, of Horsham St Faith, husbandman 7
3605488 1869382 1869382 defendant Meye Robert husbandman 588931 588931 Meye, Robert, of Horsham St Faith, husbandman 0
3605491 1869382 1869382 defendant Bolytont John husbandman 588931 588931 Bolytont, John, of Horsham St Faith, husbandman 3
3614965 1872324 1872324 defendant Benet Thomas carpenter 588931 588931 Benet, Thomas, of Horsham St Faith, carpenter 0
3614967 1872325 1872325 defendant Robyns Robert husbandman 588931 588931 Robyns, Robert, of Horsham St Faith, husbandman 0
3624075 1875060 1875060 defendant Rowell John yeoman 588931 588931 Rowell, John, of Horsham St Faith, yeoman 2
3626747 1903210 1903210 defendant Durhaunt Richard husbandman 588931 588931 Durhaunt, Richard, of Horsham St Faith, husbandman 1
3642775 1908188 1908188 defendant Thyrkyll Ralph smith 588931 588931 Thyrkyll, Ralph, of Horsham St Faith, smith 6
3645505 1908995 1908995 defendant Stowe Richard yeoman 588931 588931 Stowe, Richard, of Horsham St Faith, yeoman 1
3651953 1910957 1910957 defendant Dorand Richard husbandman 588931 588931 Dorand, Richard, of Horsham St Faith, husbandman 0
3670137 1916606 1916606 defendant Nicollys Thomas yeoman 588931 588931 Nicollys, Thomas, of Horsham St Faith, yeoman 2
3670141 1916607 1916607 defendant Nycollys Thomas yeoman 588931 588931 Nycollys, Thomas, of Horsham St Faith, yeoman 2
3698100 1925632 1925632 defendant Tolwyn Thomas husbandman 588931 588931 Tolwyn, Thomas, of Horsham St Faith, husbandman 0
3726846 1934665 1934665 defendant Telwyn Thomas husbandman 588931 588931 Telwyn, Thomas, of Horsham St Faith, husbandman 0
3730969 1935919 1935919 plaintiff Burton William tanner 588931 588931 Burton, William, of Horsham St Faith, tanner 0
3753970 1943191 1943191 defendant Barton William yeoman 588931 588931 Barton, William, of Horsham St Faith, yeoman 0
3780616 1951664 1951664 defendant Steward Ralph husbandman 588931 588931 Steward, Ralph, of Horsham St Faith, husbandman 1
3794987 1956295 1956295 defendant Colcy John   588931 588931 Colcy, John, of Horsham St Faith, coverlet weaver 2
3815071 1962635 1962635 defendant Lyng John, senior husbandman 588931 588931 Lyng, John, senior, of Horsham St Faith, husbandman 0
3826423 1966111 1966111 defendant Stapylton Thomas laborer 588931 588931 Stapylton, Thomas, of Horsham St Faith, laborer 2
3831303 1967678 1967678 plaintiff Grey Robert   588931 588931 Grey, Robert, of Horsham St Faith 0
3833282 1968336 1968336 defendant Foxe Robert husbandman 588931 588931 Foxe, Robert, of Horsham St Faith, husbandman 2
3868043 1979544 1979544 defendant Grey John gent 588931 588931 Grey, John, of Horsham St Faith, gent 3
3875959 1982211 1982211 defendant Bryntley John miller 588931 588931 Bryntley, John, of Horsham St Faith, miller 0
3875960 1982211 1982211 defendant None John tailor 588931 588931 None, John, of Horsham St Faith, tailor 1
3875961 1982211 1982211 defendant Rede John laborer 588931 588931 Rede, John, of Horsham St Faith, laborer 2
3875962 1982211 1982211 defendant Flette Agnes widow 588931 588931 Flette, Agnes, of Horsham St Faith, widow 3
3884638 1985133 1985133 defendant Walters Clement husbandman 588931 588931 Walters, Clement, of Horsham St Faith, husbandman 1
3884884 1985216 1985216 defendant Whall William husbandman 588931 588931 Whall, William, of Horsham St Faith, husbandman 0
3884885 1985216 1985216 defendant Whall William   588931 588931 Whall, William, of Horsham St Faith, worsted weaver 1
3887429 1986060 1986060 defendant Hodson Thomas butcher 588931 588931 Hodson, Thomas, of Horsham St Faith, butcher 3
3893981 1988207 1988207 defendant Gyll John   588931 588931 Gyll, John, of Horsham St Faith, worsted weaver 2
3893986 1988208 1988208 defendant Gyll John   588931 588931 Gyll, John, of Horsham St Faith, worsted weaver 2
3894110 1988246 1988246 defendant Steward Robert husbandman 588931 588931 Steward, Robert, of Horsham St Faith, husbandman 0
3897553 1989394 1989394 defendant Barrett John chaplain 588931 588931 Barrett, John, of Horsham St Faith, chaplain 2
3905151 1991986 1991986 defendant Hudson Thomas butcher 588931 588931 Hudson, Thomas, of Horsham St Faith, butcher 1
3905152 1991986 1991986 defendant Aldwyn John husbandman 588931 588931 Aldwyn, John, of Horsham St Faith, husbandman 2
3917235 1996124 1996124 defendant Owyntyn Robert husbandman 588931 588931 Owyntyn, Robert, of Horsham St Faith, husbandman 0
3917237 1996124 1996124 defendant Dyamond Thomas laborer 588931 588931 Dyamond, Thomas, of Horsham St Faith, laborer 2
3932804 2001275 2001275 defendant Note James smith 588931 588931 Note, James, of Horsham St Faith, smith 0
3933116 2001368 2001368 defendant Hudson Thomas butcher 588931 588931 Hudson, Thomas, of Horsham St Faith, butcher 2
3959107 2010269 2010269 defendant Southwell Anthony gent 588931 588931 Southwell, Anthony, of Horsham St Faith, gent 0
3963962 2012002 2012002 defendant Thyrlton Roger husbandman 588931 588931 Thyrlton, Roger, of Horsham St Faith, husbandman 2
3975854 2016117 2016117 defendant Emond Thomas husbandman 588931 588931 Emond, Thomas, of Horsham St Faith, husbandman 1
3983465 2018862 2018862 defendant Woodstocke John   588931 588931 Woodstocke, John, of Horsham St Faith, wool chapman 0
3983466 2018862 2018862 defendant Woodstocke Thomas   588931 588931 Woodstocke, Thomas, of Horsham St Faith, wool chapman 1
3984888 2019351 2019351 defendant Mortlocke John husbandman 588931 588931 Mortlocke, John, of Horsham St Faith, husbandman 0
3984890 2019352 2019352 defendant Mortlocke John husbandman 588931 588931 Mortlocke, John, of Horsham St Faith, husbandman 0
3996518 2023514 2023514 defendant Sherynge Fermer shoemaker 588931 588931 Sherynge, Fermer, of Horsham St Faith, shoemaker 0
3996557 2023527 2023527 plaintiff Deane Thomas tailor 588931 588931 Deane, Thomas, of Horsham St Faith, tailor 0
3996558 2023527 2023527 defendant Askewe Robert husbandman 588931 588931 Askewe, Robert, of Horsham St Faith, husbandman 0
3996687 2023579 2023579 defendant Bollys Thomas husbandman 588931 588931 Bollys, Thomas, of Horsham St Faith, husbandman 0
3999359 2024527 2024527 defendant Reve William husbandman 588931 588931 Reve, William, of Horsham St Faith, husbandman 3
4000041 2024779 2024779 defendant Johnson Robert clerk 588931 588931 Johnson, Robert, of Horsham St Faith, clerk 3
4000046 2024780 2024780 defendant Johnson Robert clerk 588931 588931 Johnson, Robert, of Horsham St Faith, clerk 3
4004575 2026408 2026408 defendant Shering Firmun cordwainer 588931 588931 Shering, Firmun, of Horsham St Faith, cordwainer 0
4006091 2026949 2026949 defendant Emonde Thomas husbandman 588931 588931 Emonde, Thomas, of Horsham St Faith, husbandman 0
4006092 2026949 2026949 defendant Woodstocke Thomas   588931 588931 Woodstocke, Thomas, of Horsham St Faith, wool chapman 1
4007346 2027409 2027409 defendant Deane Thomas tailor 588931 588931 Deane, Thomas, of Horsham St Faith, tailor 0
4007347 2027409 2027409 defendant Russell Andrew carpenter 588931 588931 Russell, Andrew, of Horsham St Faith, carpenter 1
4007352 2027410 2027410 defendant Deane Thomas tailor 588931 588931 Deane, Thomas, of Horsham St Faith, tailor 0
4007353 2027410 2027410 defendant Russell Andrew carpenter 588931 588931 Russell, Andrew, of Horsham St Faith, carpenter 1
4007359 2027412 2027412 defendant Banes William husbandman 588931 588931 Banes, William, of Horsham St Faith, husbandman 0
4007360 2027412 2027412 defendant Skott Gregory husbandman 588931 588931 Skott, Gregory, of Horsham St Faith, husbandman 1
4009289 2028087 2028087 plaintiff Narborowe William miller 588931 588931 Narborowe, William, of Horsham St Faith, miller 0
4015346 2030181 2030181 defendant Warden Robert yeoman 588931 588931 Warden, Robert, of Horsham St Faith, yeoman 1
4019094 2031569 2031569 defendant Thurton Roger laborer 588931 588931 Thurton, Roger, of Horsham St Faith, laborer 0
4019095 2031569 2031569 defendant Warde John laborer 588931 588931 Warde, John, of Horsham St Faith, laborer 1
4024515 2033444 2033444 defendant Woodstocke Thomas   588931 588931 Woodstocke, Thomas, of Horsham St Faith, wool chapman 0
4024516 2033444 2033444 defendant Bygott Henry   588931 588931 Bygott, Henry, of Horsham St Faith, wheelwright 1
4025995 2033946 2033946 defendant Wynter Richard husbandman 588931 588931 Wynter, Richard, of Horsham St Faith, husbandman 0
4025997 2033946 2033946 defendant Reve William husbandman 588931 588931 Reve, William, of Horsham St Faith, husbandman 2
4036902 2037877 2037877 defendant Emons Thomas yeoman 588931 588931 Emons, Thomas, of Horsham St Faith, yeoman 0
4036903 2037877 2037877 defendant Askue Robert husbandman 588931 588931 Askue, Robert, of Horsham St Faith, husbandman 1
4036904 2037877 2037877 defendant Howse Roger tailor 588931 588931 Howse, Roger, of Horsham St Faith, tailor 2
4042767 2039885 2039885 defendant Gosselynge Nicholas husbandman 588931 588931 Gosselynge, Nicholas, of Horsham St Faith, husbandman 1
4042771 2039886 2039886 defendant Gosselynge Nicholas husbandman 588931 588931 Gosselynge, Nicholas, of Horsham St Faith, husbandman 1
4046597 2041235 2041235 defendant Founde Thomas miller 588931 588931 Founde, Thomas, of Horsham St Faith, miller 1
4046916 2041351 2041351 defendant Woodstocke Thomas   588931 588931 Woodstocke, Thomas, of Horsham St Faith, wool chapman 0
4046917 2041351 2041351 defendant Carre Robert   588931 588931 Carre, Robert, of Horsham St Faith, rope maker 1
4046918 2041351 2041351 defendant Herdeman Roger butcher 588931 588931 Herdeman, Roger, of Horsham St Faith, butcher 2
4046919 2041351 2041351 defendant Russell Andrew carpenter 588931 588931 Russell, Andrew, of Horsham St Faith, carpenter 3
4054876 2044134 2044134 defendant Goslyng Nicholas yeoman 588931 588931 Goslyng, Nicholas, of Horsham St Faith, yeoman 2
4054951 2044165 2044165 plaintiff Bawdwyn or Baldwyn William (legal representative) 588931 588931 Bawdwyn or Baldwyn, William, of Horsham St Faith, yeoman, administratrix of 0
4057268 2044983 2044983 defendant Gostlyn Nicholas husbandman 588931 588931 Gostlyn, Nicholas, of Horsham St Faith, husbandman 0
4057269 2044983 2044983 defendant Reve William (legal representative) 588931 588931 Reve, William, of Horsham St Faith, husbandman, executor of 1
4057270 2044983 2044983 defendant Reve Robert husbandman 588931 588931 Reve, Robert, of Horsham St Faith, husbandman 2
4060883 2046299 2046299 defendant Hissham John blacksmith 588931 588931 Hissham, John, of Horsham St Faith, blacksmith 0
4060884 2046299 2046299 defendant Beecroft Roland husbandman 588931 588931 Beecroft, Roland, of Horsham St Faith, husbandman 1
4060885 2046299 2046299 defendant Moye William (legal representative) 588931 588931 Moye, William, of Horsham St Faith, husbandman, administratrix of 2
4061939 2046669 2046669 defendant Warde John husbandman 588931 588931 Warde, John, of Horsham St Faith, husbandman 0
4061940 2046669 2046669 defendant Balden or Bolden Cecily widow 588931 588931 Balden or Bolden, Cecily, of Horsham St Faith, widow 1
4061941 2046669 2046669 defendant Skott William husbandman 588931 588931 Skott, William, of Horsham St Faith, husbandman 2
4062322 2046813 2046813 defendant Emondes Thomas husbandman 588931 588931 Emondes, Thomas, of Horsham St Faith, husbandman 0
4062323 2046813 2046813 defendant Deynes John pinner 588931 588931 Deynes, John, of Horsham St Faith, pinner 1
4062324 2046813 2046813 defendant Reve William (legal representative) 588931 588931 Reve, William, of Horsham St Faith, husbandman, executor of 2
4062325 2046813 2046813 defendant Reve Richard husbandman 588931 588931 Reve, Richard, of Horsham St Faith, husbandman 3
4063007 2047073 2047073 defendant Plomer John husbandman 588931 588931 Plomer, John, of Horsham St Faith, husbandman 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);