names

62 rows where place_id = 592120

✎ 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
3606631 1869747 1869747 defendant Baten Henry butcher 592120 592120 Baten, Henry, of Tame, Oxon, butcher 3
3607043 1869869 1869869 defendant Benet Peter clothman 592120 592120 Benet, Peter, of Tame, Oxon, clothman 1
3607674 1870055 1870055 defendant Benet Peter yeoman 592120 592120 Benet, Peter, of Tame, Oxon, yeoman 0
3608273 1870244 1870244 defendant de Barde Adrian clerk 592120 592120 de Barde, Adrian, of Tame, Oxon, clerk 0
3624460 1875185 1875185 defendant de Bardys Adrian clerk 592120 592120 de Bardys, Adrian, of Tame, Oxon, clerk 0
3642981 1908253 1908253 defendant Middelcroft Richard yeoman 592120 592120 Middelcroft, Richard, of Tame, Oxon, yeoman 1
3657661 1912653 1912653 defendant Fultest John gent 592120 592120 Fultest, John, of Tame, Oxon, gent 3
3734855 1937143 1937143 defendant Tomlynson John butcher 592120 592120 Tomlynson, John, of Tame, Oxon, butcher 2
3738271 1938184 1938184 defendant Thomlynson John butcher 592120 592120 Thomlynson, John, of Tame, Oxon, butcher 2
3768145 1947673 1947673 defendant Bysshopp John (legal representative) 592120 592120 Bysshopp, John, of Tame, Oxon, yeoman, executors of 0
3775649 1950131 1950131 defendant Stokdale Geoffrey chapman 592120 592120 Stokdale, Geoffrey, of Tame, Oxon, chapman 1
3791303 1955114 1955114 defendant Heester Thomas   592120 592120 Heester, Thomas, of Tame, Oxon 1
3791306 1955115 1955115 defendant Heester Thomas yeoman 592120 592120 Heester, Thomas, of Tame, Oxon, yeoman 1
3802038 1958535 1958535 defendant Anfyld Thomas mercer 592120 592120 Anfyld, Thomas, of Tame, Oxon, mercer 2
3810700 1961245 1961245 defendant Blakgrove Richard   592120 592120 Blakgrove, Richard, of Tame, Oxon 0
3820281 1964217 1964217 defendant Tomlynson John butcher 592120 592120 Tomlynson, John, of Tame, Oxon, butcher 0
3820283 1964218 1964218 defendant Tomlynson John butcher 592120 592120 Tomlynson, John, of Tame, Oxon, butcher 0
3844873 1971940 1971940 defendant Hunt William chapman 592120 592120 Hunt, William, of Tame, Oxon, chapman 0
3896222 1988943 1988943 defendant Watson James mercer 592120 592120 Watson, James, of Tame, Oxon, mercer 0
3984515 2019218 2019218 defendant Symeon Thomas chapman 592120 592120 Symeon, Thomas, of Tame, Oxon, chapman 2
3988867 2020764 2020764 defendant Kettell George chapman 592120 592120 Kettell, George, of Tame, Oxon, chapman 0
4075633 2051588 2051588 defendant Hollynshed Elizabeth esq 592120 592120 Hollynshed, Elizabeth, of Tame, Oxon, widow of Hugh Hollynshed, and before that wife of William Dormer, of Tame, esq 0
4110576 2064042 2064042 defendant Fellowes Robert yeoman 592120 592120 Fellowes, Robert, of Tame, Oxon, yeoman 2
4115628 2065873 2065873 defendant Hall Francis clerk 592120 592120 Hall, Francis, of Tame, Oxon, clerk 0
4115630 2065874 2065874 defendant Hall Francis clerk 592120 592120 Hall, Francis, of Tame, Oxon, clerk 0
4162731 2082521 2082521 defendant Cope Robert husbandman 592120 592120 Cope, Robert, of Tame, Oxon, husbandman 0
4176912 2087396 2087396 defendant Graunte Reginald yeoman 592120 592120 Graunte, Reginald, of Tame, Oxon, yeoman 0
4204829 2097232 2097232 defendant Porter Nicholas butcher 592120 592120 Porter, Nicholas, of Tame, Oxon, butcher 0
4206367 2097771 2097771 defendant Jacobbe Stephen yeoman 592120 592120 Jacobbe, Stephen, of Tame, Oxon, yeoman 2
4209986 2099056 2099056 defendant Cope Robert husbandman 592120 592120 Cope, Robert, of Tame, Oxon, husbandman 0
4212309 2099851 2099851 defendant Lytle Christopher glasier 592120 592120 Lytle, Christopher, of Tame, Oxon, butcher, or of London, glasier 0
4231378 2106476 2106476 defendant Wolmer Francis chapman 592120 592120 Wolmer, Francis, of Tame, Oxon, chapman 1
4242900 2110617 2110617 defendant Carden Cornelius smith 592120 592120 Carden, Cornelius, of Tame, Oxon, smith 0
4263200 2117357 2117357 defendant Wolmer Francis chapman 592120 592120 Wolmer, Francis, of Tame, Oxon, chapman 1
4308930 2133275 2133275 defendant Hellyer John yeoman 592120 592120 Hellyer, John, of Tame, Oxon, yeoman 2
4382523 2158863 2158863 defendant Baker John chapman 592120 592120 Baker, John, of Tame, Oxon, chapman 0
4615115 2235737 2235737 defendant Bryghtowell Agnes   592120 592120 Bryghtowell, Agnes, of Tame, Oxon 0
4673565 2257364 2257364 defendant Stoke John yeoman 592120 592120 Stoke, John, of Tame, Oxon, yeoman 0
4712752 2269302 2269302 defendant Falley John tailor 592120 592120 Falley, John, of Tame, Oxon, tailor 0
4717345 2270758 2270758 defendant Nasshe Richard husbandman 592120 592120 Nasshe, Richard, of Tame, Oxon, husbandman 0
4717373 2270770 2270770 defendant Nashe Richard husbandman 592120 592120 Nashe, Richard, of Tame, Oxon, husbandman 0
4792433 2293718 2293718 defendant Hosyer Richard draper 592120 592120 Hosyer, Richard, of Tame, Oxon, draper 0
4795273 2294671 2294671 defendant Pede Richard chapman 592120 592120 Pede, Richard, of Tame, Oxon, ,chapman 0
4820227 2302396 2302396 defendant Brynsham Thomas chapman 592120 592120 Brynsham, Thomas, of Tame, Oxon, chapman 3
4845563 2310121 2310121 defendant Longe Thomas   592120 592120 Longe, Thomas, of Tame, Oxon, horse dealer 0
4856342 2313356 2313356 defendant Taillour Nicholas husbandman 592120 592120 Taillour, Nicholas, of Tame, Oxon, husbandman 3
5085116 2382051 2382051 defendant Luce William husbandman 592120 592120 Luce, William, of Tame, Oxon, husbandman 2
5092177 2384088 2384088 defendant Benet John husbandman 592120 592120 Benet, John, of Tame, Oxon, husbandman 0
5202241 2416419 2416419 defendant Lyndesey Richard   592120 592120 Lyndesey, Richard, of Tame, Oxon, abbot of the monastery of the BVM 1
5227576 2423687 2423687 defendant Benet John chapman 592120 592120 Benet, John, of Tame, Oxon, chapman 1
5237128 2426444 2426444 defendant Bates John gent 592120 592120 Bates, John, of Tame, Oxon, gent 2
5237134 2426445 2426445 defendant Bates John gent 592120 592120 Bates, John, of Tame, Oxon, gent 2
5341201 2457440 2457440 defendant Daunce John gent 592120 592120 Daunce, John, of Tame, Oxon, gent 0
5347422 2459357 2459357 defendant Water Hugh husbandman 592120 592120 Water, Hugh, of Tame, Oxon, husbandman 2
5347426 2459358 2459358 defendant Water Hugh husbandman 592120 592120 Water, Hugh, of Tame, Oxon, husbandman 2
5538572 2516543 2516543 defendant Bryghwell Nicholas gent 592120 592120 Bryghwell, Nicholas, of Tame, Oxon, gent 0
5569268 2525570 2525570 defendant Bartrope Augustine chapman 592120 592120 Bartrope, Augustine, of Tame, Oxon, chapman 2
5580395 2528952 2528952 defendant Toursey Nicholas husbandman 592120 592120 Toursey, Nicholas, of Tame, Oxon, husbandman 0
5580727 2529052 2529052 defendant Dormer Geoffrey, junior gent 592120 592120 Dormer, Geoffrey, junior, of Tame, Oxon, gent 2
5589861 2531813 2531813 defendant Dormer Geoffrey gent 592120 592120 Dormer, Geoffrey, of Tame, Oxon, gent 0
5608091 2537437 2537437 defendant Blakhed Thomas mercer 592120 592120 Blakhed, Thomas, of Tame, Oxon, mercer 1
5632487 2554195 2554195 defendant Bonde John ironmonger 592120 592120 Bonde, John, of Tame, Oxon, ironmonger 1

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