names

124 rows where place_id = 585972

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587607 1863770 1863770 defendant Mason John merchant 585972 585972 Mason, John, of Abyngdon, Berks, merchant 4
3614156 1872092 1872092 defendant Wade alias Belyngdon John chapman 585972 585972 Wade alias Belyngdon, John, of Abyngdon, Berks, chapman 0
3614354 1872143 1872143 defendant Mille John clothier 585972 585972 Mille, John, of Abyngdon, Berks, clothier 3
3616422 1872770 1872770 defendant Aylmer alias Dier Thomas dyer 585972 585972 Aylmer alias Dier, Thomas, of Abyngdon, Berks, dyer 4
3625988 1902987 1902987 defendant Audelet John yeoman 585972 585972 Audelet, John, of Abyngdon, Berks, yeoman 0
3690959 1923335 1923335 defendant Smyth Richard smith 585972 585972 Smyth, Richard, of Abyngdon, Berks, smith 0
3728993 1935314 1935314 defendant Flynt John draper 585972 585972 Flynt, John, of Abyngdon, Berks, draper 0
3762537 1945926 1945926 defendant Skarlett Augustine dyer 585972 585972 Skarlett, Augustine, of Abyngdon, Berks, dyer 0
3826949 1966279 1966279 defendant Rode Thomas gent 585972 585972 Rode, Thomas, of Abyngdon, Berks, gent 0
3868298 1979639 1979639 plaintiff Stone Thomas gent 585972 585972 Stone, Thomas, of Abyngdon, Berks, gent 0
3884955 1985234 1985234 plaintiff Awdelett Katherine (legal representative) 585972 585972 Awdelett, Katherine, of Abyngdon, Berks, widow, exectrix of Awdelett, John, of Barton juxta Abyngdon, exq, executors of 0
3933768 2001589 2001589 defendant Wright Edward chapman 585972 585972 Wright, Edward, of Abyngdon, Berks, chapman 0
3942150 2004393 2004393 defendant Coke Thomas yeoman 585972 585972 Coke, Thomas, of Abyngdon, Berks, yeoman 0
3946648 2005891 2005891 defendant Coxe James vintner 585972 585972 Coxe, James, of Abyngdon, Berks, vintner 4
4075088 2051393 2051393 plaintiff Rockeholde Thomas   585972 585972 Rockeholde, Thomas, of Abyngdon, Berks 0
4087375 2055777 2055777 defendant Smyth Thomas gent 585972 585972 Smyth, Thomas, of Abyngdon, Berks, gent 0
4130306 2071152 2071152 defendant Fyssher James chapman 585972 585972 Fyssher, James, of Abyngdon, Berks, chapman 2
4151216 2078548 2078548 defendant Daye Arthur chapman 585972 585972 Daye, Arthur, of Abyngdon, Berks, chapman 0
4186211 2090661 2090661 defendant Hart William gent 585972 585972 Hart, William, of Abyngdon, Berks, gent 0
4362718 2151723 2151723 defendant Mighell James yeoman 585972 585972 Mighell, James, of Abyngdon, Berks, or of Sutton Waldron, Dorset, yeoman 0
4579496 2225067 2225067 defendant Asshperton John chapman 585972 585972 Asshperton, John, of Abyngdon, Berks, chapman 0
4662853 2249843 2249843 defendant Fysshere William fisher 585972 585972 Fysshere, William, of Abyngdon, Berks, fisher 0
4674328 2257577 2257577 defendant Elkyn John loder 585972 585972 Elkyn, John, of Abyngdon, Berks, loder 1
4731139 2274938 2274938 defendant Sadeler John sadler 585972 585972 Sadeler, John, of Abyngdon, Berks, sadler 0
4757366 2282675 2282675 defendant Machon Gilbert (legal representative) 585972 585972 Machon, Gilbert, of Abyngdon, Berks, executors of 0
4809127 2299030 2299030 defendant Long John yeoman 585972 585972 Long, John, of Abyngdon, Berks, yeoman 0
4815184 2300858 2300858 defendant Long John   585972 585972 Long, John, of Abyngdon, Berks, cosour or shoemaker 0
4840499 2308568 2308568 defendant Nores John husbandman 585972 585972 Nores, John, of Abyngdon, Berks, husbandman 1
4872364 2318317 2318317 defendant Burbache John gent 585972 585972 Burbache, John, of Abyngdon, Berks, gent 1
4872368 2318318 2318318 defendant Burbache John gent 585972 585972 Burbache, John, of Abyngdon, Berks, gent 1
4883019 2321613 2321613 defendant Smert Richard yeoman 585972 585972 Smert, Richard, of Abyngdon, Berks, yeoman 0
4893993 2324821 2324821 defendant Norys John ostler 585972 585972 Norys, John, of Abyngdon, Berks, ostler 3
4896493 2325572 2325572 defendant Bugwyth Richard chapman 585972 585972 Bugwyth, Richard, of Abyngdon, Berks, chapman 1
4901558 2327087 2327087 defendant Parker Nicholas courser 585972 585972 Parker, Nicholas, of Abyngdon, Berks, courser 0
4947959 2341351 2341351 defendant Wodstok John chapman 585972 585972 Wodstok, John, of Abyngdon, Berks, chapman 0
4947966 2341352 2341352 defendant Wodstok John chapman 585972 585972 Wodstok, John, of Abyngdon, Berks, chapman 0
5007427 2359065 2359065 defendant Wodelef William hosier 585972 585972 (Wodelef, William, of Abyngdon, Berks, hosier 1
5029471 2365491 2365491 defendant Gyfford John chapman 585972 585972 Gyfford, John, of Abyngdon, Berks, chapman 4
5037949 2367980 2367980 defendant Hosyer William chapman 585972 585972 Hosyer, William, of Abyngdon, Berks, chapman 1
5037952 2367981 2367981 defendant Hosyer William chapman 585972 585972 Hosyer, William, of Abyngdon, Berks, chapman 1
5040853 2368882 2368882 defendant Dyer alias Jonson Nicholas dyer 585972 585972 Dyer alias Jonson, Nicholas, of Abyngdon, Berks, dyer 0
5048154 2371074 2371074 defendant Bray Thomas   585972 585972 Bray, Thomas, of Abyngdon, Berks, tallow chandler 0
5053794 2372735 2372735 defendant Bray William yeoman 585972 585972 Bray, William, of Abyngdon, Berks, yeoman 2
5056496 2373522 2373522 defendant Johnson Nicholas dyer 585972 585972 Johnson, Nicholas, of Abyngdon, Berks, dyer 0
5056498 2373523 2373523 defendant Johnson Nicholas dyer 585972 585972 Johnson, Nicholas, of Abyngdon, Berks, dyer 0
5076253 2379400 2379400 defendant Benet Thomas merchant 585972 585972 Benet, Thomas, of Abyngdon, Berks, merchant 0
5094680 2384858 2384858 defendant Hille Thomas woolman 585972 585972 Hille, Thomas, of Abyngdon, Berks, woolman 0
5129895 2395231 2395231 defendant Wodestok John chapman 585972 585972 Wodestok, John, of Abyngdon, Berks, chapman 0
5158017 2403468 2403468 defendant Forth_ Robert chapman 585972 585972 Forth_, Robert, of Abyngdon, Berks, chapman 1
5159211 2403810 2403810 defendant Shotesbroke Peter esq 585972 585972 Shotesbroke, Peter, of Abyngdon, Berks, esq 1
5165952 2405786 2405786 defendant Somersette William weaver 585972 585972 Somersette, William, of Abyngdon, Berks, weaver 1
5167464 2406217 2406217 defendant Childe John chapman 585972 585972 Childe, John, of Abyngdon, Berks, chapman 2
5179591 2409766 2409766 defendant Poleyn William weaver 585972 585972 Poleyn, William, of Abyngdon, Berks, weaver 1
5180620 2410074 2410074 defendant Somersette William weaver 585972 585972 Somersette, William, of Abyngdon, Berks, weaver 0
5184012 2411055 2411055 defendant Wodestok John chapman 585972 585972 Wodestok, John, of Abyngdon, Berks, chapman 0
5188124 2412241 2412241 defendant atte Wode Thomas gent 585972 585972 atte Wode, Thomas, of Abyngdon, Berks, gent 3
5216287 2420501 2420501 defendant Johnson alias Dyer Nicholas dyer 585972 585972 Johnson alias Dyer, Nicholas, of Abyngdon, Berks, dyer 1
5220434 2421673 2421673 defendant Braye Edward chapman 585972 585972 Braye, Edward, of Abyngdon, Berks, chapman 0
5223542 2422573 2422573 defendant Fourde Roger chapman 585972 585972 Fourde, Roger, of Abyngdon, Berks, chapman 0
5240149 2427322 2427322 defendant Bray William chapman 585972 585972 Bray, William, of Abyngdon, Berks, chapman 0
5241026 2427576 2427576 defendant Forde Roger chapman 585972 585972 Forde, Roger, of Abyngdon, Berks, chapman 1
5244157 2428484 2428484 defendant Bray William chapman 585972 585972 Bray, William, of Abyngdon, Berks, chapman 0
5244378 2428538 2428538 defendant Bray Edward yeoman 585972 585972 Bray, Edward, of Abyngdon, Berks, yeoman 0
5246676 2429188 2429188 defendant Boone Thomas hosier 585972 585972 Boone, Thomas, of Abyngdon, Berks, hosier 0
5246682 2429190 2429190 defendant Boone Thomas hosier 585972 585972 Boone, Thomas, of Abyngdon, Berks, hosier 0
5249133 2429867 2429867 defendant Ford Roger chapman 585972 585972 Ford, Roger, of Abyngdon, Berks, chapman 1
5249221 2429893 2429893 defendant Bray William clothman 585972 585972 Bray, William, of Abyngdon, Berks, clothman 1
5258831 2432882 2432882 defendant Aleyn Thomas chapman 585972 585972 Aleyn, Thomas, of Abyngdon, Berks, chapman 0
5265089 2434840 2434840 defendant Bray William husbandman 585972 585972 Bray, William, of Abyngdon, Berks, husbandman 1
5268723 2435969 2435969 defendant Ford Robert chapman 585972 585972 Ford, Robert, of Abyngdon, Berks, chapman 2
5279584 2439106 2439106 defendant Ford Roger chapman 585972 585972 Ford, Roger, of Abyngdon, Berks, chapman 1
5279589 2439107 2439107 defendant Ford Roger chapman 585972 585972 Ford, Roger, of Abyngdon, Berks, chapman 1
5285037 2440647 2440647 defendant Bray Robert merchant 585972 585972 Bray, Robert, of Abyngdon, Berks, merchant 0
5288455 2441644 2441644 defendant Forde Roger yeoman 585972 585972 Forde, Roger, of Abyngdon, Berks, yeoman 2
5308920 2447712 2447712 defendant Hevy Thomas chapman 585972 585972 Hevy, Thomas, of Abyngdon, Berks, chapman 1
5324492 2452411 2452411 defendant Rokes John gent 585972 585972 Rokes, John, of Abyngdon, Berks, gent 5
5328012 2453444 2453444 defendant Crosse alias Tanner Thomas   585972 585972 Crosse alias Tanner, Thomas, of Abyngdon, Berks, cook 0
5328018 2453445 2453445 defendant Crosse alias Tanner Thoms   585972 585972 Crosse alias Tanner, Thoms, of Abyngdon, Berks, cook or tanner 0
5328960 2453740 2453740 defendant Rokys John   585972 585972 Rokys, John, of Abyngdon, Berks 5
5336606 2456015 2456015 defendant Bray William yeoman 585972 585972 Bray, William, of Abyngdon, Berks, yeoman 0
5338250 2456532 2456532 defendant Bray alias Marreyte William chapman 585972 585972 Bray alias Marreyte, William, of Abyngdon, Berks, chapman 0
5339127 2456815 2456815 defendant Forthey Richard esq 585972 585972 Forthey, Richard, of Abyngdon, Berks,or of Worcester, esq 0
5350312 2460217 2460217 defendant Neuman William chapman 585972 585972 Neuman, William, of Abyngdon, Berks, chapman 3
5368191 2465676 2465676 defendant Martram Alexander   585972 585972 Martram, Alexander, of Abyngdon, Berks, staple merchant 0
5368195 2465677 2465677 defendant Martram Alexander   585972 585972 Martram, Alexander, of Abyngdon, Berks, staple merchant 0
5370013 2466208 2466208 defendant Heney Thomas chapman 585972 585972 Heney, Thomas, of Abyngdon, Berks, chapman 1
5372199 2466898 2466898 defendant Grene John mercer 585972 585972 Grene, John, of Abyngdon, Berks, mercer 0
5376163 2468136 2468136 defendant Edward Mathew founder 585972 585972 Edward, Mathew, of Abyngdon, Berks, founder 0
5376941 2468385 2468385 defendant Boner or Bover Thomas mercer 585972 585972 Boner or Bover, Thomas,of Abyngdon, Berks, mercer 2
5382548 2470068 2470068 defendant Edward Mathew founder 585972 585972 Edward, Mathew, of Abyngdon, Berks, founder 0
5384400 2470625 2470625 defendant Braunston John husbandman 585972 585972 Braunston, John, of Abyngdon, Berks, husbandman 1
5388258 2471690 2471690 defendant Odmere John chapman 585972 585972 Odmere, John, of Abyngdon, Berks, chapman 0
5389756 2472135 2472135 defendant Wateley Isabel widow 585972 585972 Wateley, Isabel, of Abyngdon, Berks, widow 0
5392326 2472892 2472892 defendant Edward Mathew founder 585972 585972 Edward, Mathew, of Abyngdon, Berks, founder 0
5395788 2473879 2473879 defendant Walter Gilbert gent 585972 585972 Walter, Gilbert, of Abyngdon, Berks, gent 0
5397518 2474363 2474363 defendant Braunston John husbandman 585972 585972 Braunston, John, of Abyngdon, Berks, husbandman 1
5398567 2474651 2474651 defendant Bryton John yeoman 585972 585972 Bryton, John, of Abyngdon, Berks, yeoman 1
5402590 2475814 2475814 defendant Wateley Isabel widow 585972 585972 Wateley, Isabel, of Abyngdon, Berks, widow 0
5402593 2475815 2475815 defendant Wateley Isabel widow 585972 585972 Wateley, Isabel, of Abyngdon, Berks, widow 0
5410661 2478131 2478131 defendant Braunston John skynner 585972 585972 Braunston, John, of Abyngdon, Berks, husbandman Ryley, John, of Oxford, oxon, skynner 1

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