names

59 rows where place_id = 600204

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635915 1906030 1906030 defendant Crosse John   600204 600204 Crosse, John, of Holberton, franklin 0
3640158 1907366 1907366 defendant Fichet John clerk 600204 600204 Fichet, John, of Holberton, clerk 9
3646594 1909339 1909339 defendant Rede William cordwainer 600204 600204 Rede, William, of Holberton, cordwainer 0
3646595 1909339 1909339 defendant Reynold Richard sherman 600204 600204 Reynold, Richard, of Holberton, sherman 1
3660802 1913643 1913643 defendant Rede William   600204 600204 Rede, William, of Holberton, cord wainer 0
3675133 1918251 1918251 defendant Waryn John, junior yeoman 600204 600204 Waryn, John, junior, of Holberton, yeoman 0
3682341 1920578 1920578 defendant Waren John, senior tucker 600204 600204 Waren, John, senior, of Holberton, tucker 0
3705447 1927993 1927993 defendant Waren John yeoman 600204 600204 Waren, John, of Holberton, yeoman 0
3722702 1933368 1933368 defendant Mugge Robert husbandman 600204 600204 Mugge, Robert, of Holberton, husbandman 0
3722703 1933368 1933368 defendant Mugge Richard   600204 600204 Mugge, Richard, of Holberton, groom 1
3726559 1934564 1934564 defendant Cole William yeoman 600204 600204 Cole, William, of Holberton, yeoman 0
3726560 1934564 1934564 defendant Drake Vincent yeoman 600204 600204 Drake, Vincent, of Holberton, yeoman 1
3732079 1936267 1936267 defendant Parkhowse John husbandman 600204 600204 Parkhowse, John, of Holberton, husbandman 0
3736372 1937618 1937618 defendant Long Edmund husbandman 600204 600204 Long, Edmund, of Holberton, husbandman 0
3738552 1938266 1938266 defendant Mugge Robert husbandman 600204 600204 Mugge, Robert, of Holberton, husbandman 0
3738553 1938266 1938266 defendant Mugge Richard   600204 600204 Mugge, Richard, of Holberton, groom 1
3764239 1946471 1946471 defendant Wareyn John husbandman 600204 600204 Wareyn, John, of Holberton, husbandman 0
3796049 1956626 1956626 defendant Barnard Humphrey merchant 600204 600204 Barnard, Humphrey, of Holberton, merchant 0
3810865 1961301 1961301 defendant Loosemore John carpenter 600204 600204 Loosemore, John, of Holberton, carpenter 0
3838446 1969946 1969946 defendant Facy John husbandman 600204 600204 Facy, John, of Holberton, husbandman 0
3838447 1969946 1969946 defendant Ebelyng Thomas husbandman 600204 600204 Ebelyng, Thomas, of Holberton, husbandman 1
3844216 1971740 1971740 defendant Loysmore John carpenter 600204 600204 Loysmore, John, of Holberton, carpenter 0
3859686 1976739 1976739 defendant Burell Robert esq 600204 600204 Burell, Robert, of Holberton, esq 0
3866366 1978985 1978985 defendant Laneman Walter   600204 600204 Laneman, Walter, of Holberton, parish clerk 0
3866367 1978985 1978985 defendant Lake John husbandman or tucker 600204 600204 Lake, John, of Holberton, husbandman or tucker 1
3866368 1978985 1978985 defendant Caneworthy Nicholas husbandman 600204 600204 Caneworthy, Nicholas, of Holberton, husbandman 2
3894841 1988480 1988480 defendant Burell Robert esq 600204 600204 Burell, Robert, of Holberton, esq 0
3896862 1989163 1989163 defendant Berell Robert gent 600204 600204 Berell, Robert, of Holberton, gent 0
3901724 1990800 1990800 defendant Moll Humphrey husbandman 600204 600204 Moll, Humphrey, of Holberton, husbandman 3
3901725 1990800 1990800 defendant Ven John laborer 600204 600204 Ven, John, of Holberton, laborer 4
3907066 1992651 1992651 defendant Worthe Richard butcher 600204 600204 Worthe, Richard, of Holberton, butcher 0
3918316 1996462 1996462 defendant Strachelygh Elizabeth widow 600204 600204 Strachelygh, Elizabeth, of Holberton, widow 0
3918319 1996463 1996463 defendant Strachelygh Robert   600204 600204 Strachelygh, Robert, of Holberton, gent, son of Strachelygh, Elizabeth 0
4001449 2025296 2025296 defendant Boger William husbandman 600204 600204 Boger, William, of Holberton, husbandman 0
4002961 2025828 2025828 defendant Worthe Richard husbandman 600204 600204 Worthe, Richard, of Holberton, husbandman 3
4002962 2025828 2025828 defendant Lux alias Dotton John husbandman 600204 600204 Lux alias Dotton, John, of Holberton, husbandman 4
4002981 2025830 2025830 defendant Hyngeston Andrew husbandman 600204 600204 Hyngeston, Andrew, of Holberton, husbandman 0
4002982 2025830 2025830 defendant Maddocke Henry husbandman 600204 600204 Maddocke, Henry, of Holberton, husbandman 1
4015109 2030094 2030094 defendant Chubbe Walter yeoman 600204 600204 Chubbe, Walter, of Holberton, yeoman 0
4015116 2030096 2030096 defendant Chubbe Walter yeoman 600204 600204 Chubbe, Walter, of Holberton, yeoman 0
4035541 2037380 2037380 defendant Hyngeston Andrew husbandman 600204 600204 Hyngeston, Andrew, of Holberton, husbandman 0
4042630 2039836 2039836 defendant Berye Richard yeoman 600204 600204 Berye, Richard, of Holberton, yeoman 0
4290763 2126755 2126755 defendant Turner John (legal representative) 600204 600204 Turner, John, of Holberton, yeoman, executor of 0
4578218 2224683 2224683 defendant Ray John   600204 600204 Ray, John, of Holberton, formerly bailiff of Ermyngton 0
4685427 2261038 2261038 defendant Filbert Roger laborer 600204 600204 Filbert, Roger, of Holberton, laborer 0
4757123 2282600 2282600 defendant Cok Richard   600204 600204 Cok, Richard, of Holberton 3
4976707 2349988 2349988 defendant Vaysy John husbandman 600204 600204 Vaysy, John, of Holberton, husbandman 0
4976708 2349988 2349988 defendant Rytte Thomas husbandman 600204 600204 Rytte, Thomas, of Holberton, husbandman 1
4976709 2349988 2349988 defendant Hawell William husbandman 600204 600204 Hawell, William, of Holberton, husbandman 2
4978497 2350516 2350516 defendant Dolle Robert hosier 600204 600204 Dolle, Robert, of Holberton, hosier 1
5080601 2380686 2380686 defendant Doll John husbandman 600204 600204 Doll, John, of Holberton, husbandman 0
5357274 2462338 2462338 defendant Hamelyn John drover 600204 600204 Hamelyn, John, of Holberton, drover 0
5357275 2462338 2462338 defendant Forde William butcher 600204 600204 Forde, William, of Holberton, butcher 1
5398715 2474697 2474697 defendant Forge William butcher 600204 600204 Forge, William, of Holberton, butcher 4
5539193 2516744 2516744 defendant Whyler John husbandman 600204 600204 Whyler, John, of Holberton, husbandman 0
5539194 2516744 2516744 defendant Bokeram William butcher 600204 600204 Bokeram, William, of Holberton, butcher 1
5581768 2529378 2529378 defendant Mortymer Robert husbandman 600204 600204 Mortymer, Robert, of Holberton, husbandman 0
5602560 2535697 2535697 defendant Holmore John husbandman 600204 600204 (Holmore, John, of Holberton, husbandman 2
5632475 2554194 2554194 defendant Coteler William mercer 600204 600204 Coteler, William, of Holberton, mercer 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);