names

151 rows where place_id = 590412

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601132 1868017 1868017 defendant Kempe William cordwainer 590412 590412 Kempe, William, of Burford, Oxon, cordwainer 1
3601135 1868018 1868018 defendant Kempe William cordwainer 590412 590412 Kempe, William, of Burford, Oxon, cordwainer 1
3603695 1868827 1868827 plaintiff Ekynton William woolman 590412 590412 Ekynton, William, of Burford, Oxon, woolman 0
3616760 1872872 1872872 plaintiff Ekyngton William woolman 590412 590412 Ekyngton, William, of Burford, Oxon, woolman 0
3616763 1872873 1872873 plaintiff Ekyngton William woolman 590412 590412 Ekyngton, William, of Burford, Oxon, woolman 0
3624424 1875173 1875173 defendant Neweman John yeoman 590412 590412 Neweman, John, of Burford, Oxon, yeoman 3
3663703 1914583 1914583 defendant Clerke Thomas chapman 590412 590412 Clerke, Thomas, of Burford, Oxon, chapman 0
3676810 1918784 1918784 defendant Hannes Richard glover 590412 590412 Hannes, Richard, of Burford, Oxon, glover 1
3689306 1922820 1922820 defendant Prior alias Hyllys John yeoman 590412 590412 Prior alias Hyllys, John, of Burford, Oxon, yeoman 0
3689311 1922821 1922821 defendant Est William   590412 590412 (Est, William, of Burford, Oxon, mason 1
3734836 1937138 1937138 defendant Tyssedale Thomas haberdasher 590412 590412 Tyssedale, Thomas, of Burford, Oxon, haberdasher 0
3773669 1949483 1949483 defendant Aynesdayle Peter mercer 590412 590412 Aynesdayle, Peter, of Burford, Oxon, mercer 0
3788053 1954055 1954055 plaintiff Sharpe John innholder 590412 590412 Sharpe, John, of Burford, Oxon, innholder 0
3791427 1955155 1955155 defendant Aynedale Peter mercer 590412 590412 Aynedale, Peter, of Burford, Oxon, mercer 0
3796503 1956778 1956778 defendant Valence William   590412 590412 Valence, William, of Burford, Oxon, freemason 0
3798162 1957321 1957321 plaintiff Hannys Richard yeoman 590412 590412 Hannys, Richard, of Burford, Oxon, yeoman 0
3804265 1959267 1959267 plaintiff Sharpe John innholder 590412 590412 Sharpe, John, of Burford, Oxon, innholder 0
3807829 1960332 1960332 defendant Aynesdale Peter mercer 590412 590412 Aynesdale, Peter, of Burford, Oxon, mercer 0
3815539 1962775 1962775 plaintiff Hannys Richard yeoman 590412 590412 Hannys, Richard, of Burford, Oxon, yeoman 0
3827965 1966614 1966614 plaintiff Busby John (legal representative) 590412 590412 Busby, John, of Burford, Oxon, woolman, executors of 0
3840328 1970542 1970542 defendant Lyons John chapman 590412 590412 Lyons, John, of Burford, Oxon, chapman 4
3842776 1971274 1971274 plaintiff Busby John (legal representative) 590412 590412 Busby, John, of Burford, Oxon, woolman, executors of 0
3864871 1978452 1978452 defendant Pynnock William gent 590412 590412 Pynnock, William, of Burford, Oxon, gent 0
3873199 1981251 1981251 plaintiff Busby John (legal representative) 590412 590412 Busby, John, of Burford, Oxon, woolman, executors of 0
3873970 1981517 1981517 defendant Ryddeley Thomas yeoman 590412 590412 Ryddeley, Thomas, of Burford, Oxon, yeoman 2
3875101 1981907 1981907 plaintiff Dursby John (legal representative) 590412 590412 Dursby, John, of Burford, Oxon, executors of 0
3886492 1985737 1985737 plaintiff Busbye John (legal representative) 590412 590412 Busbye, John, of Burford, Oxon, woolman, executors of 0
3918813 1996615 1996615 defendant Wychester Simon chapman 590412 590412 Wychester, Simon, of Burford, Oxon, chapman 3
3981133 2018009 2018009 defendant Gest John mercer 590412 590412 Gest, John, of Burford, Oxon, mercer 2
3994102 2022639 2022639 defendant Phillipps William yeoman 590412 590412 Phillipps, William, of Burford, Oxon, yeoman 0
4003855 2026145 2026145 plaintiff Hunte John mercer 590412 590412 Hunte, John, of Burford, Oxon, mercer 0
4005533 2026753 2026753 defendant Geast John chapman or mercer 590412 590412 Geast, John, of Burford, Oxon, chapman or mercer 0
4005535 2026754 2026754 defendant Fawler Benedict yeoman 590412 590412 Fawler, Benedict, of Burford, Oxon, yeoman 0
4048141 2041771 2041771 plaintiff Sylvester Edmund mercer 590412 590412 Sylvester, Edmund, of Burford, Oxon, mercer 0
4052969 2043498 2043498 defendant West alias Hollyday Robert vintner 590412 590412 West alias Hollyday, Robert, of Burford, Oxon, vintner 0
4066623 2048357 2048357 defendant Grene Simon vintner 590412 590412 Grene, Simon, of Burford, Oxon, vintner 1
4093920 2058149 2058149 defendant Sell William haberdasher 590412 590412 Sell, William, of Burford, Oxon, haberdasher 1
4098235 2059696 2059696 defendant Weste alias Hollyday Robert vintner 590412 590412 Weste alias Hollyday, Robert, of Burford, Oxon, vintner 0
4113604 2065146 2065146 defendant Brewton Robert chapman 590412 590412 Brewton, Robert, of Burford, Oxon, chapman 0
4117606 2066591 2066591 defendant Brewton Robert chapman 590412 590412 Brewton, Robert, of Burford, Oxon, chapman 2
4121552 2068002 2068002 defendant Bedford Richard gent 590412 590412 Bedford, Richard, of Burford, Oxon, gent 0
4123762 2068797 2068797 defendant Gest John chapman 590412 590412 Gest, John, of Burford, Oxon, chapman 1
4129461 2070840 2070840 defendant West alias Halydaye Robert vintner 590412 590412 West alias Halydaye, Robert, of Burford, Oxon, vintner 0
4135474 2073008 2073008 defendant Grene Simon vintner 590412 590412 Grene, Simon, of Burford, Oxon, vintner 0
4136623 2073442 2073442 defendant West alias Holidaye Robert yeoman 590412 590412 West alias Holidaye, Robert, of Burford, Oxon, yeoman 0
4143554 2075902 2075902 defendant West alias Holliday Robert innholder 590412 590412 West alias Holliday, Robert, of Burford, Oxon, innholder 0
4145331 2076529 2076529 defendant Harman William gent 590412 590412 Harman, William, of Burford, Oxon, or of Canwall, Staffs, gent 0
4146960 2077085 2077085 defendant Gest John chapman 590412 590412 Gest, John, of Burford, Oxon, chapman 0
4160969 2081908 2081908 defendant West alias Holydaye Robert yeoman 590412 590412 West alias Holydaye, Robert, of Burford, Oxon, yeoman 0
4254460 2114482 2114482 defendant Wysdome Ralph chapman 590412 590412 Wysdome, Ralph, of Burford, Oxon, chapman 0
4267169 2118658 2118658 defendant Wisdome Ralph chapman 590412 590412 Wisdome, Ralph, of Burford, Oxon, chapman 1
4300978 2130453 2130453 defendant Dyckynson Robert chapman 590412 590412 Dyckynson, Robert, of Burford, Oxon, chapman 1
4303577 2131377 2131377 defendant Simons Simon clothier 590412 590412 Simons, Simon, of Burford, Oxon, clothier 0
4348609 2146768 2146768 defendant Hardynge Thomas clothier 590412 590412 Hardynge, Thomas, of Burford, Oxon, clothier 0
4358254 2150122 2150122 defendant Wysdom Ralph mercer 590412 590412 Wysdom, Ralph, of Burford, Oxon, mercer 0
4366092 2152916 2152916 defendant Jurden Richard   590412 590412 Jurden, Richard, of Burford, Oxon, yeoman, woollen draper 0
4384580 2159532 2159532 defendant Collyer Thomas chandler 590412 590412 Collyer, Thomas, of Burford, Oxon, yeoman, chandler 1
4385481 2159833 2159833 defendant Sutton Edmund clothier 590412 590412 Sutton, Edmund, of Burford, Oxon, clothier 0
4386502 2160160 2160160 defendant Sutton Edmund clothier 590412 590412 Sutton, Edmund, of Burford, Oxon, clothier 0
4630501 2240453 2240453 plaintiff Stowe John (legal representative) 590412 590412 Stowe, John, of Burford, Oxon, executors of 0
4630506 2240454 2240454 plaintiff Stowe John (legal representative) 590412 590412 Stowe, John, of Burford, Oxon, sen, executors of 0
4636456 2242234 2242234 defendant Ludlowe Thomas   590412 590412 Ludlowe, Thomas, of Burford, Oxon 1
4654238 2247206 2247206 defendant Webbe Philip weaver 590412 590412 Webbe, Philip, of Burford, Oxon, weaver 0
4655067 2247468 2247468 defendant Wynrysshe Thomas woolmonger 590412 590412 Wynrysshe, Thomas, of Burford, Oxon, woolmonger 0
4660683 2249163 2249163 defendant Wynryysshe Thomas woolman 590412 590412 Wynryysshe, Thomas, of Burford, Oxon, woolman 1
4664907 2250504 2250504 defendant Cobbe Robert husbandman 590412 590412 Cobbe, Robert, of Burford, Oxon, husbandman 3
4679947 2259331 2259331 defendant Taillour Nicholas tailor 590412 590412 Taillour, Nicholas, of Burford, Oxon, tailor 0
4682878 2260262 2260262 defendant Hille John gent 590412 590412 Hille, John, of Burford, Oxon, gent 1
4693874 2263588 2263588 defendant Howes Robert goldsmith 590412 590412 Howes, Robert, of Burford, Oxon, goldsmith 0
4695107 2263963 2263963 defendant Wynryssh Thomas chapman 590412 590412 Wynryssh, Thomas, of Burford, Oxon, chapman 0
4698959 2265152 2265152 defendant Wynrich Thomas chapman 590412 590412 Wynrich, Thomas, of Burford, Oxon, chapman 0
4705948 2267239 2267239 defendant Hill John gent 590412 590412 Hill, John, of Burford, Oxon, gent 0
4722628 2272392 2272392 defendant Howys John goldsmith 590412 590412 Howys, John, of Burford, Oxon, goldsmith 5
4723515 2272662 2272662 defendant Wynrysch Thomas   590412 590412 Wynrysch, Thomas, of Burford, Oxon, wool man 2
4727199 2273767 2273767 defendant Dyer Edmund dyer 590412 590412 Dyer, Edmund, of Burford, Oxon, dyer 3
4731750 2275119 2275119 defendant Wenrygge Thomas merchant 590412 590412 Wenrygge, Thomas, of Burford, Oxon, merchant 0
4739637 2277471 2277471 defendant Dyer Edmynd dyer 590412 590412 Dyer, Edmynd, of Burford, Oxon, dyer 0
4740935 2277858 2277858 defendant Howys Robert goldsmith 590412 590412 Howys, Robert, of Burford, Oxon, goldsmith 0
4744029 2278778 2278778 defendant Wynrysshe Agnes widow 590412 590412 Wynrysshe, Agnes, of Burford, Oxon, widow 4
4745305 2279139 2279139 defendant Punter John husbandman 590412 590412 Punter, John, of Burford, Oxon, husbandman 1
4749681 2280391 2280391 defendant Norton Thomas laborer 590412 590412 (Norton, Thomas, of burford, Oxon, laborer 4
4759942 2283447 2283447 defendant Hull John gent 590412 590412 Hull, John, of Burford, Oxon, gent 0
4782192 2290430 2290430 defendant Hull John gent 590412 590412 Hull, John, of Burford, Oxon, gent 0
4818259 2301788 2301788 defendant Martyn Richard chapman 590412 590412 Martyn, Richard, of Burford, Oxon, chapman 0
4822738 2303191 2303191 defendant Dygon William butcher 590412 590412 Dygon, William, of Burford, Oxon, butcher 0
4835392 2307066 2307066 defendant Coke Thomas   590412 590412 Coke, Thomas, of Burford, Oxon, servant 1
4856072 2313271 2313271 defendant Farreis John weaver 590412 590412 Farreis, John, of Burford, Oxon, weaver 1
4880059 2320672 2320672 defendant Punter John farmer 590412 590412 Punter, John, of Burford, Oxon, farmer 0
4882226 2321348 2321348 defendant Symondes William merchant 590412 590412 Symondes, William, of Burford, Oxon, merchant 0
4889339 2323457 2323457 defendant Cotes Richard husbandman 590412 590412 Cotes, Richard, of Burford, Oxon, husbandman 0
4906723 2328689 2328689 defendant Dygon William butcher 590412 590412 Dygon, William, of Burford, Oxon, butcher 0
4937872 2338225 2338225 defendant Freman William brasier 590412 590412 Freman, William, of Burford, Oxon, brasier 0
4968540 2347559 2347559 defendant Punter John husbandman 590412 590412 Punter, John, of Burford, Oxon, husbandman 0
4968546 2347560 2347560 defendant Punter John husbandman 590412 590412 Punter, John, of Burford, Oxon, husbandman 0
4975474 2349632 2349632 defendant Hosyer Joan widow 590412 590412 Hosyer, Joan, of Burford, Oxon, widow 0
4975476 2349633 2349633 defendant Hosyer Joan widow 590412 590412 Hosyer, Joan, of Burford, Oxon, widow 0
4990412 2354045 2354045 defendant Pynnok John mercer 590412 590412 Pynnok, John, of Burford, Oxon, mercer 0
4995987 2355649 2355649 defendant Suthwyk Henry husbandman 590412 590412 Suthwyk, Henry, of Burford, Oxon, husbandman 0
5006393 2358769 2358769 defendant Cardigan Thomas husbandman 590412 590412 Cardigan, Thomas, of Burford, Oxon, husbandman 2
5034884 2367059 2367059 defendant Brampton Thomas merchant 590412 590412 Brampton, Thomas, of Burford, Oxon, merchant 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);