names

156 rows where place_id = 594283

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615418 1872463 1872463 defendant Wychyngham William   594283 594283 Wychyngham, William, of Tunsted, worsted weaver 0
3615419 1872463 1872463 defendant Wychyngham Thomas   594283 594283 Wychyngham, Thomas, of Tunsted, worsted weaver 1
3615420 1872463 1872463 defendant Canche or Cauche John   594283 594283 Canche or Cauche, John, of Tunsted, worsted weaver 2
3615421 1872463 1872463 defendant Curre Mjohn   594283 594283 Curre, Mjohn, of Tunsted, worsted weaver 3
3615422 1872463 1872463 defendant Symmys Peter husbandman 594283 594283 Symmys, Peter, of Tunsted, husbandman 4
3632499 1904985 1904985 defendant Kechon Clement   594283 594283 Kechon, Clement, of Tunsted, worsted weaver 0
3649427 1910211 1910211 defendant Appulby John husbandman 594283 594283 Appulby, John, of of Tunsted, husbandman 1
3664138 1914734 1914734 defendant Barker John laborer 594283 594283 Barker, John, of Tunsted, laborer 0
3677224 1918921 1918921 defendant Appylby John yeoman 594283 594283 Appylby, John, of Tunsted, yeoman 1
3680228 1919888 1919888 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 2
3693647 1924207 1924207 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 4
3695753 1924901 1924901 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 1
3695760 1924903 1924903 defendant Kechon Clement   594283 594283 Kechon, Clement, of Tunsted, worsted weaver 0
3717074 1931624 1931624 defendant Lawes John   594283 594283 Lawes, John, of Tunsted, worsted weaver 0
3719145 1932272 1932272 defendant Kechon Clement   594283 594283 Kechon, Clement, of Tunsted, worsted weaver 0
3720761 1932782 1932782 defendant Neve Robert   594283 594283 Neve, Robert, of Tunsted, cartwright 1
3722193 1933200 1933200 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 0
3724394 1933918 1933918 plaintiff Rogerson John clerk 594283 594283 Rogerson, John, of Tunsted, clerk 0
3724397 1933918 1933918 defendant Camond John, senior   594283 594283 Camond, John, senior, of Tunsted, worsted weaver 2
3724398 1933918 1933918 defendant Camond Gregory   594283 594283 Camond, Gregory, of Tunsted, worsted weaver 3
3730039 1935635 1935635 defendant Wryght John husbandman 594283 594283 Wryght, John, of Tunsted, husbandman 1
3731882 1936202 1936202 defendant Appulby John yeoman 594283 594283 Appulby, John, of Tunsted, yeoman 4
3736586 1937694 1937694 defendant Neve Thomas   594283 594283 Neve, Thomas, of Tunsted, cartwright 2
3736587 1937694 1937694 defendant Neve Robert   594283 594283 Neve, Robert, of Tunsted, cartwright 3
3738185 1938156 1938156 defendant Wychyngham William   594283 594283 Wychyngham, William, of Tunsted, worsted weaver 1
3740175 1938786 1938786 defendant Molle Walter   594283 594283 Molle, Walter, of Tunsted, worsted weaver 1
3749734 1941826 1941826 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 2
3752014 1942552 1942552 defendant Arden John yeoman 594283 594283 Arden, John, of Tunsted, yeoman 2
3764814 1946662 1946662 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 1
3769289 1948048 1948048 defendant Kechyng Clement   594283 594283 Kechyng, Clement, of Tunsted, worsted weaver 3
3775126 1949952 1949952 defendant Kechon Clement   594283 594283 Kechon, Clement, of Tunsted, worsted weaver 0
3777348 1950660 1950660 defendant Sheryngham John   594283 594283 Sheryngham, John, of Tunsted, worsted weaver 1
3778462 1950979 1950979 defendant Wychyngham Thomas   594283 594283 Wychyngham, Thomas, of Tunsted, worsted weaver 0
3779034 1951165 1951165 defendant Moll Walter yeoman 594283 594283 Moll, Walter, of Tunsted, yeoman 5
3787117 1953764 1953764 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 2
3788733 1954279 1954279 defendant Bysshop Edward   594283 594283 (Bysshop, Edward, of Tunsted, worsted weaver 1
3800094 1957954 1957954 defendant Cory Robert husbandman 594283 594283 Cory, Robert, of Tunsted, husbandman 2
3813268 1962061 1962061 defendant Molle Walter husbandman 594283 594283 Molle, Walter, of Tunsted, husbandman 1
3823018 1965107 1965107 defendant Kechyn Clement   594283 594283 Kechyn, Clement, of Tunsted, worsted weaver 0
3832285 1968012 1968012 defendant Camont Gregory   594283 594283 Camont, Gregory, of Tunsted, worsted weaver 1
3835447 1969025 1969025 defendant Sheryngham John   594283 594283 Sheryngham, John, of Tunsted, thick woollen weaver 0
3857190 1975880 1975880 defendant Horne John tailor 594283 594283 Horne, John, of Tunsted, tailor 0
3861740 1977390 1977390 defendant Clerke Henry   594283 594283 Clerke, Henry, of Tunsted, worsted weaver 0
3863746 1978052 1978052 defendant Amys Christopher   594283 594283 Amys, Christopher, of Tunsted, worsted weaver 2
3863770 1978055 1978055 defendant Amys Christopher   594283 594283 Amys, Christopher, of Tunsted, worsted weaver 0
3864317 1978260 1978260 defendant Horne John husbandman 594283 594283 Horne, John, of Tunsted, husbandman 0
3867049 1979219 1979219 plaintiff Rogers William   594283 594283 Rogers, William, of Tunsted 0
3867053 1979220 1979220 plaintiff Rogers William   594283 594283 Rogers, William, of Tunsted 0
3870287 1980312 1980312 plaintiff Wrentham alias Couper John tailor 594283 594283 Wrentham alias Couper, John, of Tunsted, tailor 0
3870949 1980535 1980535 defendant Poyte Edward husbandman 594283 594283 Poyte, Edward, of Tunsted, husbandman 0
3874570 1981716 1981716 defendant Molle Walter yeoman 594283 594283 Molle, Walter, of Tunsted, yeoman 0
3874572 1981717 1981717 defendant Molle Walter yeoman 594283 594283 Molle, Walter, of Tunsted, yeoman 0
3877057 1982568 1982568 defendant Molle Walter   594283 594283 Molle, Walter, of Tunsted, worsted weaver 1
3877058 1982568 1982568 defendant Buntyng Robert carpenter 594283 594283 Buntyng, Robert, of Tunsted, carpenter 2
3877059 1982568 1982568 defendant Sheryngham John husbandman 594283 594283 Sheryngham, John, of Tunsted, husbandman 3
3880783 1983838 1983838 defendant Clerke Henry   594283 594283 Clerke, Henry, of Tunsted, worsted weaver 0
3884365 1985038 1985038 defendant Clerke Henry   594283 594283 Clerke, Henry, of Tunsted, worsted weaver 0
3930128 2000421 2000421 defendant Elles Richard laborer 594283 594283 Elles, Richard, of Tunsted, laborer 4
3956896 2009482 2009482 defendant Ilberd William yeoman 594283 594283 Ilberd, William, of Tunsted, yeoman 0
3988805 2020743 2020743 defendant Nepes John   594283 594283 Nepes, John, of Tunsted, wheelwright 1
3991473 2021703 2021703 plaintiff Brese Thomas tailor 594283 594283 Brese, Thomas, of Tunsted, tailor 0
3994124 2022647 2022647 defendant Busshopp Nicholas gent 594283 594283 Busshopp, Nicholas, of Tunsted, gent 0
4004574 2026408 2026408 plaintiff Jenkynson Thomas gent 594283 594283 Jenkynson, Thomas, of Tunsted, gent 0
4017783 2031071 2031071 defendant Norreth John husbandman 594283 594283 Norreth, John, of Tunsted, husbandman 1
4026655 2034179 2034179 plaintiff Camont or Camond Edmund   594283 594283 Camont or Camond, Edmund, of Tunsted, worsted weaver 0
4027423 2034455 2034455 defendant Trolloppe James husbandman 594283 594283 Trolloppe, James, of Tunsted, husbandman 1
4076954 2052042 2052042 defendant Amyas Thomas yeoman 594283 594283 Amyas, Thomas, of Tunsted, yeoman 3
4144698 2076306 2076306 defendant Nall Christopher husbandman 594283 594283 Nall, Christopher, of Tunsted, husbandman 2
4145511 2076585 2076585 defendant Hardingham Esau husbandman 594283 594283 Hardingham, Esau, of Tunsted, husbandman 1
4147729 2077348 2077348 defendant Ames Thomas yeoman 594283 594283 Ames, Thomas, of Tunsted, yeoman 1
4150169 2078193 2078193 defendant Wrighte Robert yeoman 594283 594283 Wrighte, Robert, of Tunsted, yeoman 0
4152452 2078969 2078969 defendant Wright Robert yeoman 594283 594283 Wright, Robert, of Tunsted, yeoman 0
4159341 2081337 2081337 defendant Clarke Henry husbandman 594283 594283 Clarke, Henry, of Tunsted, ,husbandman 0
4164878 2083227 2083227 defendant Candler Anne spinster 594283 594283 Candler, Anne, of Tunsted, spinster 2
4174466 2086537 2086537 defendant Benseley John husbandman 594283 594283 Benseley, John, of Tunsted, or of Northales alias Cove Hithe, Suff, husbandman 0
4174467 2086537 2086537 defendant Clarke Edward husbandman 594283 594283 Clarke, Edward, of Tunsted, or of Northales, husbandman 1
4203032 2096611 2096611 defendant Themylthorpe Thomas gent 594283 594283 Themylthorpe, Thomas, of Tunsted, gent 0
4223637 2103755 2103755 defendant Lawse Nicholas husbandman 594283 594283 Lawse, Nicholas, of Tunsted, husbandman 0
4228624 2105495 2105495 defendant Apleby Christopher   594283 594283 Apleby, Christopher, of Tunsted, worsted weaver 0
4228626 2105496 2105496 defendant Asleby Christopher   594283 594283 Asleby, Christopher, of Tunsted, worsted weaver 0
4228743 2105538 2105538 defendant Parker Robert sawyer 594283 594283 Parker, Robert, of Tunsted, sawyer 1
4251719 2113564 2113564 defendant Lawes Stephen husbandman 594283 594283 Lawes, Stephen, of Tunsted, husbandman 3
4258335 2115758 2115758 defendant Lawes Stephen carpenter 594283 594283 Lawes, Stephen, of Tunsted, carpenter 2
4258348 2115760 2115760 defendant Hardingham Esau husbandman 594283 594283 Hardingham, Esau, of Tunsted, husbandman 1
4261914 2116937 2116937 defendant Watt Clement husbandman 594283 594283 Watt, Clement, of Tunsted, husbandman 0
4261915 2116937 2116937 defendant Bunnynge Thomas husbandman 594283 594283 Bunnynge, Thomas, of Tunsted, husbandman 1
4281829 2123550 2123550 defendant Mallett Thomas husbandman 594283 594283 Mallett, Thomas, of Tunsted, or of Newton juxta Horsham St Faith, husbandman 0
4327649 2139567 2139567 defendant Gilbert Robert thatcher 594283 594283 Gilbert, Robert, of Tunsted, thatcher 1
4335207 2142050 2142050 defendant Lawes Nicholas husbandman 594283 594283 Lawes, Nicholas, of Tunsted, husbandman 2
4335208 2142050 2142050 defendant Lawes Stephen husbandman 594283 594283 Lawes, Stephen, of Tunsted, husbandman 3
4407132 2166949 2166949 defendant Tunsted John gent 594283 594283 Tunsted, John, of Tunsted, gent 0
4454380 2186381 2186381 defendant Coker William   594283 594283 Coker, William, of Tunsted 19
4479462 2194233 2194233 defendant Crowegate Joan   594283 594283 Crowegate, Joan, of Tunsted, formerly wife of Roger de Crowegate 0
4623407 2238294 2238294 defendant Middelton John   594283 594283 Middelton, John, of Tunsted 1
4628655 2239886 2239886 plaintiff Seket Henry   594283 594283 Seket, Henry, of Tunsted, vicar 0
4628656 2239886 2239886 plaintiff Sweyn John   594283 594283 Sweyn, John, of Tunsted, son of John 1
4768340 2286069 2286069 defendant Hopkynson Thomas (legal representative) 594283 594283 Hopkynson, Thomas, of Tunsted, executors of 2
4768341 2286069 2286069 defendant Hopkynson John yeoman 594283 594283 (Hopkynson, John, of Tunsted, yeoman 3
4818348 2301821 2301821 defendant Barker John laborer 594283 594283 with Barker, John, of Tunsted, laborer 1
4900865 2326902 2326902 defendant Sweyn Robert yeoman 594283 594283 Sweyn, Robert, of Tunsted, yeoman 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);