names

119 rows where place_id = 695204

✎ 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
4108326 2063236 2063236 defendant Alman Elizabeth widow 695204 695204 Alman, Elizabeth, of Abingdon, berks, widow 0
4118072 2066748 2066748 defendant Bostock Thomas yeoman 695204 695204 Bostock, Thomas, of Abingdon, Berks, yeoman 1
4121554 2068003 2068003 defendant Fyssher John mercer 695204 695204 Fyssher, John, of Abingdon, Berks, chapman, mercer 0
4142899 2075691 2075691 defendant Horton Roger gent 695204 695204 Horton, Roger, of Abingdon, Berks, gent 3
4143967 2076052 2076052 defendant Smythe Thomas gent 695204 695204 Smythe, Thomas, of Abingdon, Berks, gent 1
4151869 2078766 2078766 defendant Dawberne Francis chapman 695204 695204 Dawberne, Francis, of Abingdon, Berks, chapman 1
4226841 2104859 2104859 defendant Kent Thomas   695204 695204 Kent, Thomas, of Abingdon, Berks, white baker 0
4233582 2107266 2107266 defendant Bolte John innholder 695204 695204 Bolte, John, of Abingdon, Berks, innholder 0
4254562 2114515 2114515 defendant Kent Thomas   695204 695204 Kent, Thomas, of Abingdon, Berks, white baker 0
4258761 2115896 2115896 defendant Frye John gent 695204 695204 Frye, John, of Abingdon, Berks, gent 0
4258765 2115897 2115897 defendant Frye John gent 695204 695204 Frye, John, of Abingdon, Berks, gent 0
4268709 2119128 2119128 defendant Smythe Thomas gent 695204 695204 Smythe, Thomas, of Abingdon, Berks, gent 0
4292017 2127219 2127219 defendant Francklyn Anthony blacksmith 695204 695204 Francklyn, Anthony, of Abingdon, Berks, blacksmith 0
4296308 2128777 2128777 defendant Elye Richard yeoman 695204 695204 Elye, Richard, of Abingdon, Berks, yeoman 0
4300761 2130368 2130368 defendant Francklyn Anthony blacksmith 695204 695204 Francklyn, Anthony, of Abingdon, Berks, blacksmith 0
4305415 2132036 2132036 defendant Backhouse Thomas blacksmith 695204 695204 Backhouse, Thomas, of Abingdon, Berks, blacksmith 0
4308370 2133080 2133080 defendant Fysher John, junior   695204 695204 Fysher, John, junior, of Abingdon, Berks, linen draper 1
4332869 2141275 2141275 defendant Fyssher John, junior chapman 695204 695204 Fyssher, John, junior, of Abingdon, Berks, chapman 0
4332871 2141276 2141276 defendant Fyssher John, junior chapman 695204 695204 Fyssher, John, junior, of Abingdon, Berks, chapman 0
4340458 2143928 2143928 defendant Coates Nicholas brewer 695204 695204 Coates, Nicholas, of Abingdon, Berks, brewer 0
4357325 2149790 2149790 defendant Houldway Robert   695204 695204 Houldway, Robert, of Abingdon, Berks, millwright 0
4379603 2157797 2157797 defendant Harte William gent 695204 695204 Harte, William, of Abingdon, Berks, gent 0
4386815 2160258 2160258 defendant Terrett John chapman 695204 695204 Terrett, John, of Abingdon, Berks, chapman 0
4407323 2167010 2167010 defendant Terrett John chapman 695204 695204 Terrett, John, of Abingdon, Berks, chapman 0
4691850 2262986 2262986 defendant Lovecombe Nicholas yeoman 695204 695204 Lovecombe, Nicholas, of Abingdon, Berks, yeoman 1
4695450 2264055 2264055 defendant Hulle Thomas husbandman 695204 695204 Hulle, Thomas, of Abingdon, Berks, husbandman 2
4695549 2264091 2264091 defendant More John   695204 695204 More, John, of Abingdon, Berks, husb 0
4702313 2266132 2266132 defendant More John chapman 695204 695204 More, John, of Abingdon, Berks, chapman 0
4704135 2266672 2266672 defendant Jakeman William fishmonger 695204 695204 Jakeman, William, of Abingdon, Berks, fishmonger 0
4705387 2267054 2267054 defendant Bele Richard clerk 695204 695204 Bele, Richard, of Abingdon, Berks, clerk 0
4706450 2267398 2267398 defendant Jurdayn John chapman 695204 695204 Jurdayn, John, of Abingdon, Berks, chapman 3
4707532 2267727 2267727 defendant Markyate Thomas smith 695204 695204 Markyate, Thomas, of Abingdon, Berks, smith 0
4715278 2270111 2270111 defendant Spyder Maud widow 695204 695204 Spyder, Maud, of Abingdon, Berks, widow 0
4717188 2270706 2270706 defendant Whelere Ralph merchant 695204 695204 Whelere, Ralph, of Abingdon, Berks, merchant 2
4732143 2275237 2275237 defendant Hegham Joan   695204 695204 Hegham, Joan, of Abingdon, Berks, widow, formerly wife of Hugh 1
4755908 2282232 2282232 defendant Proffyt Thomas dyer 695204 695204 Proffyt, Thomas, of Abingdon, Berks, dyer 0
4757370 2282676 2282676 defendant Mason Gilbert (legal representative) 695204 695204 Mason, Gilbert, of Abingdon, Berks, executors of 0
4760969 2283774 2283774 defendant Plymmeswode Thomas dyer 695204 695204 Plymmeswode, Thomas, of Abingdon, Berks, dyer 0
4761555 2283959 2283959 defendant Bate Robert joiner 695204 695204 Bate, Robert, of Abingdon, Berks, joiner 0
4762177 2284149 2284149 defendant Parker Nicholas husbandman 695204 695204 Parker, Nicholas, of Abingdon, Berks, husbandman 0
4766451 2285499 2285499 defendant Draper John chapman 695204 695204 Draper, John, of Abingdon, Berks, chapman 0
4768621 2286165 2286165 defendant Boxor_ Richard   695204 695204 Boxor_, Richard, of Abingdon, Berks, abbot of the monastery 0
4775777 2288423 2288423 defendant Parker Nicholas   695204 695204 Parker, Nicholas, of Abingdon, Berks, horse dealer 0
4831600 2305916 2305916 defendant Appirle William   695204 695204 Appirle, William, of Abingdon, Berks, kersey man 3
4839308 2308220 2308220 defendant Appurley John weaver 695204 695204 Appurley, John, of Abingdon, Berks, weaver 0
4845990 2310250 2310250 defendant Appurley William   695204 695204 Appurley, William, of Abingdon, Berks, wool monger 0
4848259 2310926 2310926 defendant Crompe Ralph weaver 695204 695204 Crompe, Ralph, of Abingdon, Berks, weaver 0
4849443 2311301 2311301 defendant Grondy William husbandman 695204 695204 Grondy, William, of Abingdon, Berks, husbandman 1
4853343 2312457 2312457 defendant Nubury John skinner 695204 695204 Nubury, John, of Abingdon, Berks, skinner 0
4917656 2332036 2332036 defendant Man--- Hugh yeoman 695204 695204 Man---, Hugh, of Abingdon, Berks, yeoman 1
5137383 2397446 2397446 defendant For the Roger chapman 695204 695204 For the, Roger, of Abingdon, Berks, chapman 1
5143992 2399389 2399389 defendant Edward John weaver 695204 695204 Edward, John, of Abingdon, Berks, weaver 2
5143996 2399390 2399390 defendant Edward John weaver 695204 695204 Edward, John, of Abingdon, Berks, weaver 2
5145551 2399844 2399844 defendant Somersette William weaver 695204 695204 Somersette, William, of Abingdon, Berks, weaver 1
5145568 2399848 2399848 defendant Somersette William weaver 695204 695204 Somersette, William, of Abingdon, Berks, weaver 1
5146927 2400242 2400242 defendant Berbury Robert gent 695204 695204 Berbury, Robert, of Abingdon, Berks, gent 0
5152711 2401934 2401934 defendant Wodestoke John chapman 695204 695204 Wodestoke, John, of Abingdon, Berks, chapman 1
5152858 2401977 2401977 defendant Wodestoke John chapman 695204 695204 Wodestoke, John, of Abingdon, Berks, chapman 1
5153301 2402118 2402118 defendant Bray William chapman 695204 695204 Bray, William, of Abingdon, Berks, chapman 0
5153305 2402120 2402120 defendant Bray William chapman 695204 695204 Bray, William, of Abingdon, Berks, chapman 0
5155523 2402775 2402775 defendant Wodestoke John husbandman 695204 695204 Wodestoke, John, of Abingdon, Berks, husbandman 2
5157502 2403326 2403326 defendant Apurley John chapman 695204 695204 Apurley, John, of Abingdon, Berks, chapman 0
5157506 2403327 2403327 defendant Bray Robert yeoman 695204 695204 Bray, Robert, of Abingdon, Berks, yeoman 0
5159460 2403882 2403882 defendant Michell John draper 695204 695204 Michell, John, of Abingdon, Berks, draper 4
5159468 2403883 2403883 defendant Michell John draper 695204 695204 Michell, John, of Abingdon, Berks, draper 4
5160384 2404129 2404129 defendant Sextan Maud   695204 695204 Sextan, Maud, of Abingdon, Berks, widow, formerly wife of John 1
5162200 2404678 2404678 defendant Hille Thomas gent 695204 695204 (Hille, Thomas, of Abingdon, Berks, gent 1
5164407 2405322 2405322 defendant Appurley John chapman 695204 695204 Appurley, John, of Abingdon, Berks, chapman 0
5165004 2405503 2405503 defendant Edward John weaver 695204 695204 Edward, John, of Abingdon, Berks, weaver 2
5165008 2405504 2405504 defendant Edward John weaver 695204 695204 Edward, John, of Abingdon, Berks, weaver 2
5168668 2406559 2406559 defendant Tanner Nicholas yeoman 695204 695204 Tanner, Nicholas, of Abingdon, Berks, yeoman 0
5170461 2407090 2407090 defendant Wodestoke John chapman 695204 695204 Wodestoke, John, of Abingdon, Berks, chapman 1
5170467 2407091 2407091 defendant Wodestoke John chapman 695204 695204 Wodestoke, John, of Abingdon, Berks, chapman 1
5170558 2407110 2407110 defendant Bone Thomas hosier alias draper 695204 695204 Bone, Thomas, of Abingdon, Berks, hosier alias draper 0
5170776 2407175 2407175 defendant Bray William chapman 695204 695204 Bray, William, of Abingdon, Berks, chapman 0
5172133 2407569 2407569 defendant Wodestoke John husbandman 695204 695204 Wodestoke, John, of Abingdon, Berks, husbandman 2
5172465 2407672 2407672 defendant Bagge John chapman 695204 695204 Bagge, John, of Abingdon, Berks, chapman 0
5172467 2407673 2407673 defendant Benet Thomas chapman 695204 695204 Benet, Thomas, of Abingdon, Berks, chapman 0
5173399 2407926 2407926 defendant Bray Robert yeoman 695204 695204 Bray, Robert, of Abingdon, Berks, yeoman 0
5173736 2408015 2408015 defendant Forthe Roger chapman 695204 695204 Forthe, Roger, of Abingdon, Berks, chapman 1
5173739 2408016 2408016 defendant Forthe Roger chapman 695204 695204 Forthe, Roger, of Abingdon, Berks, chapman 1
5174588 2408267 2408267 defendant Mychell John draper 695204 695204 Mychell, John, of Abingdon, Berks, draper 4
5178248 2409342 2409342 defendant Thorne John chapman 695204 695204 Thorne, John, of Abingdon, Berks, chapman 3
5179405 2409712 2409712 defendant Sutton Thomas clerk 695204 695204 Sutton, Thomas, of Abingdon, Berks, clerk 0
5179557 2409753 2409753 defendant Jesep William   695204 695204 Jesep, William, of Abingdon, Berks, wool winder 2
5182396 2410607 2410607 defendant Penheleke John draper 695204 695204 Penheleke, John, of of Abingdon, Berks, draper 1
5182980 2410770 2410770 defendant Childe John chapman 695204 695204 Childe, John, of Abingdon, Berks, chapman 2
5182988 2410771 2410771 defendant Childe John chapman 695204 695204 Childe, John, of Abingdon, Berks, chapman 2
5184682 2411268 2411268 defendant Tanner Nicholas yeoman 695204 695204 Tanner, Nicholas, of Abingdon, Berks, yeoman 0
5188007 2412198 2412198 defendant Benet Thomas chapman 695204 695204 Benet, Thomas, of Abingdon, Berks, chapman 4
5188226 2412269 2412269 defendant Wodestoke John chapman 695204 695204 Wodestoke, John, of Abingdon, Berks, chapman 0
5188438 2412334 2412334 defendant Bray Robert yeoman 695204 695204 Bray, Robert, of Abingdon, Berks, yeoman 0
5188761 2412442 2412442 defendant Bray William chapman 695204 695204 Bray, William, of Abingdon, Berks, chapman 0
5188763 2412443 2412443 defendant Bray William chapman 695204 695204 Bray, William, of Abingdon, Berks, chapman 0
5191262 2413184 2413184 defendant Wodestoke John husbandman 695204 695204 Wodestoke, John, of Abingdon, Berks, husbandman 3
5191267 2413185 2413185 defendant Wodestoke John husbandman 695204 695204 Wodestoke, John, of Abingdon, Berks, husbandman 1
5193371 2413789 2413789 defendant Bray Robert yeoman 695204 695204 Bray, Robert, of Abingdon, Berks, yeoman 0
5194298 2414064 2414064 defendant Benet Thomas merchant 695204 695204 Benet, Thomas, of Abingdon, Berks, merchant 1
5195333 2414384 2414384 defendant Michell John draper 695204 695204 Michell, John, of Abingdon, Berks, draper 0
5196301 2414668 2414668 defendant Sextan John (legal representative) 695204 695204 Sextan, John, of Abingdon, Berks, executrix of 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);