names

458 rows where place_id = 587418

✎ 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
3591349 1864921 1864921 defendant Bullour John mercer 587418 587418 Bullour, John, of Dysse, mercer 2
3596376 1866499 1866499 defendant Coty William husbandman 587418 587418 Coty, William, of Dysse, husbandman 0
3599525 1867490 1867490 defendant Allerede Robert gent 587418 587418 Allerede, Robert, of Dysse, gent 1
3605426 1869363 1869363 defendant Alred Thomas yeoman 587418 587418 Alred, Thomas, of Dysse, yeoman 2
3607241 1869929 1869929 defendant Waryn John yeoman 587418 587418 Waryn, John, of Dysse, yeoman 3
3607561 1870023 1870023 plaintiff Samson alias Sawnsham John   587418 587418 Samson alias Sawnsham, John, of Dysse, 0
3634758 1905668 1905668 defendant Couper Stephen mercer 587418 587418 Couper, Stephen, of Dysse, mercer 1
3639803 1907260 1907260 defendant Cowper Stephen   587418 587418 Cowper, Stephen, of Dysse, hat maker, son of Cooper, Edmund, of Dysse, hat maker 0
3640147 1907365 1907365 defendant Garbolesham John butcher 587418 587418 Garbolesham, John, of Dysse, butcher 0
3643284 1908324 1908324 defendant Hogon Thomas husbandman 587418 587418 Hogon, Thomas, of Dysse, husbandman 1
3643322 1908337 1908337 plaintiff Cowper Thomas (legal representative) 587418 587418 Cowper, Thomas, of Dysse, executrix of 0
3650656 1910570 1910570 defendant Couper Stephen yeoman 587418 587418 Couper, Stephen, of Dysse, yeoman 0
3657104 1912486 1912486 defendant Perse George gent 587418 587418 Perse, George, of Dysse, gent 0
3657105 1912486 1912486 defendant Folser John tanner 587418 587418 Folser, John, of Dysse, tanner 1
3657106 1912486 1912486 defendant Broun John tanner 587418 587418 Broun, John, of Dysse, tanner 2
3657107 1912486 1912486 defendant Cherwold Thomas laborer 587418 587418 Cherwold, Thomas, of Dysse, laborer 3
3659473 1913221 1913221 plaintiff Gothe John   587418 587418 Gothe, John, of Dysse 0
3673888 1917867 1917867 defendant Couper Stephen mercer 587418 587418 Couper, Stephen, of Dysse, mercer 0
3674578 1918100 1918100 defendant Brown John, junior husbandman 587418 587418 Brown, John, junior, of Dysse, husbandman 0
3674579 1918100 1918100 defendant Plumsted William carpenter 587418 587418 Plumsted, William, of Dysse, carpenter 1
3674620 1918113 1918113 defendant Coke Robert mercer 587418 587418 Coke, Robert, of Dysse, mercer 2
3674639 1918119 1918119 defendant Couper Stephen mercer 587418 587418 Couper, Stephen, of Dysse, mercer 1
3690661 1923244 1923244 defendant Cowper Stephen, junior chapman 587418 587418 Cowper, Stephen, junior, of Dysse, chapman 0
3704460 1927690 1927690 defendant Marten John husbandman 587418 587418 Marten, John, of Dysse, husbandman 3
3714980 1930981 1930981 defendant Edwardys Thomas saddler 587418 587418 Edwardys, Thomas, of Dysse, saddler 1
3719053 1932235 1932235 defendant Coke Robert mercer 587418 587418 Coke, Robert, of Dysse, mercer 0
3719055 1932236 1932236 defendant Folse John butcher 587418 587418 Folse, John, of Dysse, butcher 0
3719061 1932239 1932239 defendant Pryk Roger shoemaker 587418 587418 Pryk, Roger, of Dysse, shoemaker 0
3721027 1932872 1932872 defendant Chapman John courser 587418 587418 Chapman, John, of Dysse, courser 3
3724728 1934019 1934019 defendant Cooke Robert mercer 587418 587418 Cooke, Robert, of Dysse, mercer 1
3724733 1934020 1934020 plaintiff Bokenham William   587418 587418 Bokenham, William, of Dysse 2
3725291 1934203 1934203 plaintiff Smyth William tanner 587418 587418 Smyth, William, of Dysse, tanner 0
3734821 1937135 1937135 defendant Pryk Roger cordwainer 587418 587418 Pryk, Roger, of Dysse, cordwainer 2
3750872 1942193 1942193 defendant Cowper Henry butcher 587418 587418 Cowper, Henry, of Dysse, butcher 0
3752985 1942867 1942867 defendant Tobold Margery widow 587418 587418 Tobold, Margery, of Dysse, widow 1
3753480 1943026 1943026 plaintiff Smyth John barker 587418 587418 Smyth, John, of Dysse, barker 0
3753481 1943026 1943026 defendant Alred William butcher 587418 587418 Alred, William, of Dysse, butcher 0
3753534 1943042 1943042 plaintiff Smyth William tanner 587418 587418 Smyth, William, of Dysse, tanner 0
3759752 1945043 1945043 plaintiff Colman Thomas   587418 587418 Colman, Thomas, of Dysse 0
3759753 1945043 1945043 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 0
3759754 1945043 1945043 defendant Carman Robert butcher 587418 587418 Carman, Robert, of Dysse, butcher 1
3763122 1946097 1946097 defendant Fowlyser Roger butcher 587418 587418 Fowlyser, Roger, of Dysse, butcher 1
3769891 1948238 1948238 defendant Mortymer Walter weaver 587418 587418 Mortymer, Walter, of Dysse, weaver 1
3776167 1950290 1950290 plaintiff Broun John   587418 587418 Broun, John, of Dysse 0
3776224 1950309 1950309 defendant Revett John butcher 587418 587418 Revett, John, of Dysse, butcher 0
3779952 1951455 1951455 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 0
3779953 1951455 1951455 defendant Hervy John husbandman 587418 587418 Hervy, John, of Dysse, husbandman 1
3789311 1954476 1954476 defendant Chapman John courser 587418 587418 Chapman, John, of Dysse, courser 1
3793170 1955724 1955724 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 0
3793538 1955841 1955841 defendant Symson Nicholas husbandman 587418 587418 Symson, Nicholas, of Dysse, husbandman 3
3793724 1955902 1955902 defendant Yonger Edmund tailor 587418 587418 Yonger, Edmund, of Dysse, tailor 0
3793818 1955931 1955931 defendant Chapman John courser 587418 587418 Chapman, John, of Dysse, courser 0
3802389 1958647 1958647 defendant Chapman Thomas yeoman 587418 587418 Chapman, Thomas, of Dysse, yeoman 0
3808434 1960515 1960515 defendant Chapman John courser 587418 587418 Chapman, John, of Dysse, courser 1
3808692 1960599 1960599 plaintiff Sampson John   587418 587418 Sampson, John, of Dysse 1
3812763 1961884 1961884 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 3
3814330 1962394 1962394 defendant Aldred William butcher 587418 587418 Aldred, William, of Dysse, butcher 0
3814852 1962560 1962560 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 0
3814853 1962560 1962560 defendant Goos John   587418 587418 Goos, John, of Dysse, wheel wright 1
3815952 1962893 1962893 plaintiff Hendry Robert   587418 587418 Hendry, Robert, of Dysse 0
3819908 1964106 1964106 defendant Chapman Thomas husbandman 587418 587418 Chapman, Thomas, of Dysse, husbandman 0
3820183 1964192 1964192 defendant Goos John   587418 587418 Goos, John, of Dysse, wheel wright 2
3821128 1964504 1964504 defendant Anner John mercer 587418 587418 Anner, John, of Dysse, mercer 0
3826277 1966066 1966066 defendant Mably Robert yeoman 587418 587418 Mably, Robert, of Dysse, yeoman 0
3830695 1967484 1967484 plaintiff Fuller alias Garbolysham John   587418 587418 Fuller alias Garbolysham, John, of Dysse 0
3830697 1967484 1967484 defendant Assy William tailor 587418 587418 Assy, William, of Dysse, tailor 1
3831003 1967580 1967580 defendant Dobson Ralph chaplain 587418 587418 Dobson, Ralph, of Dysse, chaplain 0
3831184 1967643 1967643 defendant Cowper Nicholas yeoman 587418 587418 Cowper, Nicholas, of Dysse, yeoman 0
3831187 1967644 1967644 defendant Cowper Nicholas husbandman 587418 587418 Cowper, Nicholas, of Dysse, husbandman 0
3831203 1967647 1967647 defendant Cowper Nicholas yeoman 587418 587418 Cowper, Nicholas, of Dysse, yeoman 0
3831208 1967649 1967649 defendant Cowper Nicholas husbandman 587418 587418 Cowper, Nicholas, of Dysse, husbandman 0
3832008 1967909 1967909 plaintiff Hendry Robert (legal representative) 587418 587418 Hendry, Robert, of Dysse, executor of 0
3832010 1967909 1967909 defendant Cowper Nicholas tailor 587418 587418 Cowper, Nicholas, of Dysse, tailor 0
3832011 1967909 1967909 defendant Browne Edward butcher 587418 587418 Browne, Edward, of Dysse, butcher 1
3832012 1967909 1967909 defendant Wylbey John tailor 587418 587418 Wylbey, John, of Dysse, tailor 2
3832445 1968067 1968067 defendant Brown Edward butcher 587418 587418 Brown, Edward, of Dysse, butcher 0
3836364 1969281 1969281 defendant Fuller alias Garbysham John butcher 587418 587418 Fuller alias Garbysham, John, of Dysse, butcher 0
3836366 1969282 1969282 defendant Assey William tailor 587418 587418 Assey, William, of Dysse, tailor 0
3840236 1970513 1970513 defendant Knyghte John tailor 587418 587418 Knyghte, John, of Dysse, tailor 2
3843499 1971503 1971503 defendant Folser John butcher 587418 587418 Folser, John, of Dysse, butcher 2
3844012 1971671 1971671 defendant Folser John tanner 587418 587418 Folser, John, of Dysse, tanner 0
3846548 1972477 1972477 defendant Cowper Nicholas husbandman 587418 587418 Cowper, Nicholas, of Dysse, husbandman 0
3849749 1973509 1973509 defendant Holand John husbandman 587418 587418 Holand, John, of Dysse, husbandman 3
3851576 1974080 1974080 defendant Shrove John tailor 587418 587418 Shrove, John, of Dysse, tailor 3
3856241 1975572 1975572 defendant Cowper Edmund butcher 587418 587418 Cowper, Edmund, of Dysse, butcher 2
3856393 1975621 1975621 defendant Chapman Thomas, senior yeoman 587418 587418 Chapman, Thomas, senior, of Dysse, yeoman 0
3856394 1975621 1975621 defendant Chapman John, senior yeoman 587418 587418 Chapman, John, senior, of Dysse, yeoman 1
3857001 1975822 1975822 defendant Launcetour Richard husbandman 587418 587418 Launcetour, Richard, of Dysse, husbandman 4
3862059 1977498 1977498 defendant Cowper Nicholas husbandman 587418 587418 Cowper, Nicholas, of Dysse, husbandman 0
3862864 1977772 1977772 plaintiff Hendrye Joan (legal representative) 587418 587418 Hendrye, Joan, of Dysse, widow, executors of 0
3862950 1977805 1977805 defendant Sharpe Edward mercer 587418 587418 Sharpe, Edward, of Dysse, mercer 0
3863318 1977926 1977926 defendant Mabley Robert draper 587418 587418 Mabley, Robert, of Dysse, draper 0
3864012 1978145 1978145 defendant Alred William butcher 587418 587418 Alred, William, of Dysse, butcher 0
3864013 1978145 1978145 defendant Wylby John tailor 587418 587418 Wylby, John, of Dysse, tailor 1
3864265 1978241 1978241 defendant Clerk Robert   587418 587418 Clerk, Robert, of Dysse, wheelwright 1
3864462 1978314 1978314 defendant Launcetour Robert husbandman 587418 587418 Launcetour, Robert, of Dysse, husbandman 0
3866899 1979167 1979167 defendant Revet Robert husbandman 587418 587418 Revet, Robert, of Dysse, husbandman 1
3868968 1979862 1979862 defendant Assy William husbandman 587418 587418 Assy, William, of Dysse, husbandman 1
3868970 1979863 1979863 defendant Assy William husbandman 587418 587418 Assy, William, of Dysse, husbandman 0
3869518 1980047 1980047 defendant Chapman John   587418 587418 Chapman, John, of Dysse, horse courser 3

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