names

80 rows where place_id = 603717

✎ 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
3655554 1911997 1911997 defendant Rant Christopher husbandman 603717 603717 Rant, Christopher, of Wursted, husbandman 0
3686774 1922018 1922018 defendant Tompson Robert   603717 603717 Tompson, Robert, of Wursted, worsted weaver 1
3695152 1924704 1924704 defendant Barne Edmund   603717 603717 Barne, Edmund, of Wursted, mason 0
3695567 1924841 1924841 defendant Mascall John   603717 603717 Mascall, John, of Wursted, worsted weaver 0
3695740 1924898 1924898 defendant Howchyns Edward   603717 603717 Howchyns, Edward, of Wursted, worsted weaver 0
3700891 1926524 1926524 defendant Jonson Richard thatcher 603717 603717 Jonson, Richard, of Wursted, thatcher 1
3715251 1931056 1931056 defendant Fene John butcher 603717 603717 Fene, John, of Wursted, butcher 0
3717089 1931629 1931629 defendant Boteson William   603717 603717 Boteson, William, of Wursted, worsted weaver 2
3723428 1933593 1933593 defendant Fenne John butcher 603717 603717 Fenne, John, of Wursted, butcher 4
3724158 1933840 1933840 defendant Baron Edmund   603717 603717 Baron, Edmund, of Wursted, mason 0
3726706 1934615 1934615 defendant Gumme Richard husbandman 603717 603717 Gumme, Richard, of Wursted, husbandman 0
3732772 1936479 1936479 defendant Boteson William   603717 603717 Boteson, William, of Wursted, worsted weaver 2
3732776 1936480 1936480 defendant Boteson William   603717 603717 Boteson, William, of Wursted, worsted weaver 2
3735684 1937395 1937395 defendant Bytson William   603717 603717 Bytson, William, of Wursted, worsted weaver 2
3737296 1937901 1937901 defendant Colt Robert   603717 603717 Colt, Robert, of Wursted, worsted weaver 1
3737297 1937901 1937901 defendant Cok John, junior husbandman 603717 603717 Cok, John, junior, of Wursted, husbandman 2
3740000 1938731 1938731 defendant Margareys Richard, senior husbandman 603717 603717 Margareys, Richard, senior, of Wursted, husbandman 1
3740001 1938731 1938731 defendant Margareys Richard, junior husbandman 603717 603717 Margareys, Richard, junior, of Wursted, husbandman 2
3762124 1945796 1945796 defendant Rooper Richard baker 603717 603717 Rooper, Richard, of Wursted, baker 0
3762125 1945796 1945796 defendant Eton Robert baker 603717 603717 Eton, Robert, of Wursted, baker 1
3791809 1955284 1955284 defendant Beteson William   603717 603717 Beteson, William, of Wursted, worsted weaver 0
3797449 1957090 1957090 plaintiff Glaven John (legal representative) 603717 603717 Glaven, John, of Wursted, executor of 0
3809285 1960783 1960783 defendant Dixe John   603717 603717 Dixe, John, of Wursted, worsted weaver 1
3809524 1960862 1960862 defendant Baron Edmund husbandman 603717 603717 Baron, Edmund, of Wursted, husbandman 0
3814385 1962414 1962414 defendant Percy Michael husbandman 603717 603717 Percy, Michael, of Wursted, husbandman 0
3819615 1964012 1964012 defendant Phelyppys Robert husbandman 603717 603717 Phelyppys, Robert, of Wursted, husbandman 1
3823304 1965202 1965202 defendant Gunne Richard husbandman 603717 603717 Gunne, Richard, of Wursted, husbandman 0
3831177 1967640 1967640 defendant Camplyng Robert shoemaker 603717 603717 Camplyng, Robert, of Wursted, shoemaker 0
3834594 1968753 1968753 defendant Gunne Robert   603717 603717 Gunne, Robert, of Wursted, worsted weaver 1
3836769 1969399 1969399 defendant Ponyet Thomas raffman 603717 603717 Ponyet, Thomas, of Wursted, raffman 0
3846525 1972470 1972470 defendant Ponyet Thomas chapman 603717 603717 Ponyet, Thomas, of Wursted, chapman 0
3846527 1972471 1972471 defendant Ponyet Thomas chapman 603717 603717 Ponyet, Thomas, of Wursted, chapman 0
3851785 1974147 1974147 defendant Wattes Richard   603717 603717 Wattes, Richard, of Wursted, worsted weaver 2
3851786 1974147 1974147 defendant Brigges Robert tanner 603717 603717 Brigges, Robert, of Wursted, tanner 3
3857819 1976084 1976084 defendant Moundys John   603717 603717 Moundys, John, of Wursted, worsted weaver 2
3865070 1978519 1978519 defendant Gunne Robert   603717 603717 Gunne, Robert, of Wursted, worsted weaver 2
3867097 1979234 1979234 defendant Phelyppys Robert baker 603717 603717 Phelyppys, Robert, of Wursted, baker 0
3875348 1982000 1982000 defendant Phyllyppe Robert baker 603717 603717 Phyllyppe, Robert, of Wursted, baker 0
3879849 1983518 1983518 defendant Flye Ralph   603717 603717 Flye, Ralph, of Wursted, worsted weaver 0
3880336 1983677 1983677 defendant Sower Thomas husbandman 603717 603717 Sower, Thomas, of Wursted, husbandman 2
3880338 1983677 1983677 defendant Goierston Simon husbandman 603717 603717 Goierston, Simon, of Wursted, husbandman 4
3880691 1983806 1983806 defendant Newman Richard tailor 603717 603717 Newman, Richard, of Wursted, tailor 2
3880696 1983807 1983807 defendant Newman Richard tailor 603717 603717 Newman, Richard, of Wursted, tailor 0
3882297 1984337 1984337 defendant Newman Richard tailor 603717 603717 Newman, Richard, of Wursted, tailor 2
3882301 1984338 1984338 defendant Newman Richard tailor 603717 603717 Newman, Richard, of Wursted, tailor 1
3882928 1984556 1984556 defendant Wryght John   603717 603717 Wryght, John, of Wursted, worsted weaver 0
3893964 1988204 1988204 defendant Purdy William   603717 603717 Purdy, William, of Wursted, "rafeman" 2
3919517 1996859 1996859 defendant Martyns alias Wright William   603717 603717 Martyns alias Wright, William, of Wursted, worsted weaver 1
3921830 1997646 1997646 defendant Hastyng Edward tailor 603717 603717 Hastyng, Edward, of Wursted, tailor 0
3929548 2000231 2000231 defendant Rysyng John   603717 603717 Rysyng, John, of Wursted, bone setter 0
3929550 2000232 2000232 defendant Wymonde John husbandman 603717 603717 Wymonde, John, of Wursted, husbandman 0
3950301 2007191 2007191 defendant Sepens Thomas husbandman 603717 603717 Sepens, Thomas, of Wursted, husbandman 0
4036465 2037728 2037728 defendant Martens John   603717 603717 Martens, John, of Wursted, worsted weaver 0
4077599 2052276 2052276 defendant Felmyngham Richard gent 603717 603717 Felmyngham, Richard, of Wursted, gent 0
4087476 2055817 2055817 defendant Watt Robert husbandman 603717 603717 Watt, Robert, of Wursted, husbandman 0
4087477 2055817 2055817 defendant Robert John yeoman 603717 603717 Robert, John, of Wursted, yeoman 1
4110165 2063898 2063898 defendant Yemes John butcher 603717 603717 Yemes, John, of Wursted, butcher 0
4110377 2063972 2063972 defendant Martens John   603717 603717 Martens, John, of Wursted, worsted weaver 1
4203035 2096611 2096611 defendant Woode John husbandman 603717 603717 Woode, John, of Wursted, husbandman 3
4577407 2224451 2224451 plaintiff Carleton Edmund de   603717 603717 Carleton, Edmund de, of Wursted, vicar 0
4812354 2299977 2299977 defendant Briggate Henry   603717 603717 Briggate, Henry, of Wursted, wool man 1
4960845 2345204 2345204 defendant Pampyng John husbandman 603717 603717 Pampyng, John, of Wursted, husbandman 0
5111879 2389863 2389863 defendant Gogman Richard husbandman 603717 603717 Gogman, Richard, of Wursted, husbandman 1
5125132 2393825 2393825 defendant Tilman John thatcher 603717 603717 Tilman, John, of Wursted, thatcher 0
5125134 2393826 2393826 defendant Tilman Bartholomew husbandman 603717 603717 Tilman, Bartholomew, of Wursted, husbandman 0
5135754 2396969 2396969 defendant Holerd (illegible) draper 603717 603717 Holerd, --, of Wursted, draper 0
5135755 2396969 2396969 defendant Red Isabel   603717 603717 Red, Isabel, of Wursted, widow, formerly wife of John Red 1
5141904 2398752 2398752 defendant Frende Clement   603717 603717 Frende, Clement, of Wursted, tallow chandler 0
5141905 2398752 2398752 defendant Wattes William butcher 603717 603717 Wattes, William, of Wursted, butcher 1
5162973 2404899 2404899 defendant Frend Clement   603717 603717 Frend, Clement, of Wursted, tallow chandler 0
5162974 2404899 2404899 defendant Wattes William butcher 603717 603717 Wattes, William, of Wursted, butcher 1
5172366 2407643 2407643 defendant Red Isabel   603717 603717 Red, Isabel, of Wursted, widow, formerly wife of John 0
5172368 2407643 2407643 defendant Hoberd John draper 603717 603717 Hoberd, John, of Wursted, draper 2
5199323 2415551 2415551 defendant Frende Clement   603717 603717 Frende, Clement, of Wursted, tallow chandler 0
5199324 2415551 2415551 defendant Wattes William butcher 603717 603717 Wattes, William, of Wursted, butcher 1
5258492 2432770 2432770 defendant atte Hyll Robert husbandman 603717 603717 atte Hyll, Robert, of Wursted, husbandman 1
5275073 2437789 2437789 defendant Rogers John husbandman 603717 603717 Rogers, John, of Wursted, husbandman 3
5399508 2474939 2474939 plaintiff Dykemans Thomas (legal representative) 603717 603717 Dykemans, Thomas, of Wursted, worsted weaver, executor of 0
5576743 2527772 2527772 defendant Ferrour Andrew husbandman 603717 603717 Ferrour, Andrew, of Wursted, husbandman 2
5589211 2531631 2531631 defendant Dey Geoffrey husbandman 603717 603717 Dey, Geoffrey, of Wursted, husbandman 0

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