names

148 rows where place_id = 587294

✎ 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
3591013 1864815 1864815 defendant Suthwyke Richard yeoman 587294 587294 Suthwyke, Richard, of Todyngton, yeoman 0
3603622 1868801 1868801 defendant Dylle Mathew husbandman 587294 587294 Dylle, Mathew, of Todyngton, husbandman 0
3608577 1870341 1870341 plaintiff Tracy William gent 587294 587294 Tracy, William, of Todyngton, gent 0
3620654 1874039 1874039 defendant Raynold John cooper 587294 587294 Raynold, John, of Todyngton, cooper 0
3631851 1904771 1904771 defendant Reynold John carpenter 587294 587294 Reynold, John, of Todyngton, carpenter 0
3657592 1912636 1912636 defendant Hale John husbandman 587294 587294 Hale, John, of Todyngton, husbandman 1
3663763 1914600 1914600 defendant Dyer Henry husbandman 587294 587294 Dyer, Henry, of Todyngton, husbandman 1
3663764 1914600 1914600 defendant Couper Richard   587294 587294 Couper, Richard, of Todyngton 2
3663765 1914600 1914600 defendant Clokmaker Richard yeoman 587294 587294 Clokmaker, Richard, of Todyngton, yeoman 3
3666241 1915391 1915391 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3679946 1919793 1919793 defendant Dyer Henry maltman 587294 587294 Dyer, Henry, of Todyngton, maltman 2
3681584 1920331 1920331 defendant Dyer Henry yeoman 587294 587294 Dyer, Henry, of Todyngton, yeoman 0
3681585 1920331 1920331 defendant Clonyer or Clovyer Richard yeoman 587294 587294 Clonyer or Clovyer, Richard, of Todyngton, yeoman 1
3697919 1925572 1925572 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3697927 1925573 1925573 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3697929 1925574 1925574 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3700434 1926373 1926373 defendant Bagard John clerk 587294 587294 Bagard, John, of Todyngton, clerk 0
3707696 1928703 1928703 defendant Curwyn Henry butcher 587294 587294 Curwyn, Henry, of Todyngton, butcher 1
3711684 1929966 1929966 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3714771 1930922 1930922 defendant Izodde William yeoman 587294 587294 Izodde, William, of Todyngton, yeoman 1
3714772 1930922 1930922 defendant Casmore Richard yeoman 587294 587294 Casmore, Richard, of Todyngton, yeoman 2
3714778 1930924 1930924 defendant Tracy William, senior esq 587294 587294 Tracy, William, senior, of Todyngton, esq 0
3714779 1930924 1930924 defendant Tracy William, junior gent 587294 587294 Tracy, William, junior, of Todyngton, gent 1
3714781 1930925 1930925 defendant Tracy William, senior esq 587294 587294 Tracy, William, senior, of Todyngton, esq 0
3714782 1930925 1930925 defendant Tray William, junior gent 587294 587294 Tray, William, junior, of Todyngton, gent 1
3721079 1932888 1932888 defendant Paper Henry warrener 587294 587294 Paper, Henry, of Todyngton, warrener 1
3726284 1934489 1934489 defendant Reynold John cooper 587294 587294 Reynold, John, of Todyngton, cooper 0
3726637 1934591 1934591 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3742042 1939378 1939378 defendant Wykes Nicholas esq 587294 587294 Wykes, Nicholas, of Todyngton, esq 0
3752315 1942649 1942649 defendant Clokmaker John smith 587294 587294 Clokmaker, John, of Todyngton, smith 1
3755842 1943777 1943777 defendant Wellys William draper 587294 587294 Wellys, William, of Todyngton, draper 1
3765236 1946793 1946793 defendant Clerke Thomas baker 587294 587294 Clerke, Thomas, of Todyngton, baker 0
3778068 1950855 1950855 defendant Bagard John clerk 587294 587294 Bagard, John, of Todyngton, clerk 0
3778069 1950855 1950855 defendant Williams Edmund husbandman 587294 587294 Williams, Edmund, of Todyngton, husbandman 1
3782152 1952170 1952170 defendant Clarke Thomas husbandman 587294 587294 Clarke, Thomas, of Todyngton, husbandman 0
3787230 1953800 1953800 defendant Clement William yeoman 587294 587294 Clement, William, of Todyngton, yeoman 1
3787231 1953800 1953800 defendant Clarke Thomas yeoman 587294 587294 Clarke, Thomas, of Todyngton, yeoman 2
3788557 1954218 1954218 defendant Couper Henry haberdasher 587294 587294 Couper, Henry, of Todyngton, haberdasher 0
3799062 1957615 1957615 defendant Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
3805677 1959719 1959719 defendant Mannyng Hugh husbandman 587294 587294 Mannyng, Hugh, of Todyngton, husbandman 0
3813025 1961979 1961979 defendant Wedon alias Scarlet Alice single woman 587294 587294 Wedon alias Scarlet, Alice, of Todyngton, single woman 0
3815433 1962743 1962743 defendant Shelde Richard husbandman 587294 587294 Shelde, Richard, of Todyngton, husbandman 3
3850400 1973714 1973714 defendant Becher Robert butcher 587294 587294 Becher, Robert, of Todyngton, butcher 2
3857473 1975974 1975974 defendant William Thomas husbandman 587294 587294 William, Thomas, of Todyngton, husbandman 0
3857474 1975974 1975974 defendant Sothurn George gent 587294 587294 Sothurn, George, of Todyngton, gent 1
3857475 1975974 1975974 defendant Fensham John husbandman 587294 587294 Fensham, John, of Todyngton, husbandman 2
3859288 1976599 1976599 defendant Ingle Robert butcher 587294 587294 Ingle, Robert, of Todyngton, butcher 0
3860008 1976847 1976847 defendant Turveley John chaplain 587294 587294 Turveley, John, of Todyngton, chaplain 0
3879718 1983471 1983471 defendant Mynor alias Hoppar Thomas chapman 587294 587294 Mynor alias Hoppar, Thomas, of Todyngton, chapman 1
3909267 1993391 1993391 defendant A Downe alias Clochyar John laborer 587294 587294 A Downe alias Clochyar, John, of Todyngton, laborer 3
3920675 1997265 1997265 defendant Golde John   587294 587294 Golde, John, of Todyngton, wheelwright 1
4509429 2203419 2203419 defendant Frend Thomas barber 587294 587294 Frend, Thomas, of Todyngton, barber 0
4564897 2220585 2220585 defendant Webbe Thomas   587294 587294 Webbe, Thomas, of Todyngton 0
4584191 2226471 2226471 defendant Tracy William   587294 587294 Tracy, William, of Todyngton 0
4625197 2238848 2238848 defendant Symund Geoffrey   587294 587294 Symund, Geoffrey, of Todyngton 0
4664817 2250471 2250471 defendant Wyse Henry clerk 587294 587294 Wyse, Henry, of Todyngton, clerk 0
4726393 2273538 2273538 defendant (illegible) Richard laborer 587294 587294 _, Richard, of Todyngton, laborer 1
4837193 2307585 2307585 defendant Godhode Roger yeoman 587294 587294 Godhode, Roger, of Todyngton, yeoman 2
4837194 2307585 2307585 defendant Gerard John yeoman 587294 587294 Gerard, John, of Todyngton, yeoman 3
4839597 2308302 2308302 defendant Garbald John yeoman 587294 587294 Garbald, John, of Todyngton, yeoman 3
4850688 2311671 2311671 defendant Baron John husbandman 587294 587294 Baron, John, of Todyngton, husbandman 0
4858397 2313999 2313999 defendant Yve or Yne John   587294 587294 Yve or Yne, John, of Todyngton, servant 1
4907676 2328968 2328968 defendant Felmersha John husbandman 587294 587294 Felmersha, John, of Todyngton, husbandman 1
4930570 2335967 2335967 plaintiff Tracy William esq 587294 587294 Tracy, William, of Todyngton, esq 0
4933673 2336908 2336908 defendant Clerk Richard husbandman 587294 587294 Clerk, Richard, of Todyngton, husbandman 1
5009178 2359572 2359572 defendant Myles John   587294 587294 Myles, John, of Todyngton, worsted weaver 0
5054190 2372847 2372847 defendant Smyth Thomas smith 587294 587294 Smyth, Thomas, of Todyngton, smith 1
5096098 2385299 2385299 defendant Goos John husbandman 587294 587294 Goos, John,of Todyngton, husbandman 0
5100586 2386600 2386600 defendant Smyth Robert clerk 587294 587294 Smyth, Robert, of Todyngton, clerk 0
5142612 2398968 2398968 defendant Willyhams John   587294 587294 Willyhams, John, of Todyngton, shoe maker 2
5164014 2405212 2405212 defendant Willyhams John shoemaker 587294 587294 Willyhams, John, of Todyngton, shoemaker 2
5214098 2419850 2419850 defendant Reve John husbandman 587294 587294 Reve, John, of Todyngton, husbandman 0
5231428 2424779 2424779 plaintiff Bocher Nicholas   587294 587294 Bocher, Nicholas, of Todyngton 0
5254539 2431542 2431542 defendant Daubeney Simon yeoman 587294 587294 Daubeney, Simon, of Todyngton, yeoman 2
5255543 2431850 2431850 defendant Marchall John, junior tailor 587294 587294 Marchall, John, junior, of Todyngton, tailor 0
5262757 2434092 2434092 defendant Wythe Roger husbandman 587294 587294 Wythe, Roger, of Todyngton, husbandman 0
5275005 2437769 2437769 defendant Dawenam Thomas husbandman 587294 587294 Dawenam, Thomas, of Todyngton, husbandman 3
5276881 2438320 2438320 defendant Daubeney Simon yeoman 587294 587294 Daubeney, Simon, of Todyngton, yeoman 0
5285239 2440706 2440706 defendant Marchall William yeoman 587294 587294 Marchall, William, of Todyngton, yeoman 0
5289634 2441969 2441969 defendant Lynford Richard husbandman 587294 587294 Lynford, Richard, of Todyngton, husbandman 0
5290008 2442084 2442084 defendant Gibbe Francis tiler 587294 587294 Gibbe, Francis, of Todyngton, tiler 1
5291032 2442379 2442379 defendant Marchall John (legal representative) 587294 587294 Marchall, John, of Todyngton, executors of 0
5291035 2442379 2442379 defendant Comyn William yeoman 587294 587294 Comyn, William, of Todyngton, yeoman 3
5292851 2442900 2442900 defendant Reve John husbandman 587294 587294 Reve, John, of Todyngton, husbandman 4
5304956 2446486 2446486 defendant Marchall William yeoman 587294 587294 Marchall, William, of Todyngton, yeoman 0
5311736 2448531 2448531 defendant Reve Thomas butcher 587294 587294 Reve, Thomas, of Todyngton, butcher 1
5311738 2448531 2448531 defendant Reve John husbandman 587294 587294 Reve, John, of Todyngton, husbandman 3
5314032 2449219 2449219 defendant Reve Thomas butcher 587294 587294 Reve, Thomas, of Todyngton, butcher 1
5314034 2449219 2449219 defendant Reve John husbandman 587294 587294 Reve, John, of Todyngton, husbandman 3
5314043 2449221 2449221 defendant Parker John yeoman 587294 587294 Parker, John, of Todyngton, yeoman 1
5314044 2449221 2449221 defendant Parker Thomas laborer 587294 587294 Parker, Thomas, of Todyngton, laborer 2
5318660 2450674 2450674 defendant Marchall William yeoman 587294 587294 Marchall, William, of Todyngton, yeoman 0
5321874 2451612 2451612 plaintiff Marchall John, junior (legal representative) 587294 587294 Marchall, John, junior, of Todyngton, executors of 0
5321878 2451612 2451612 defendant Marchall Robert smith 587294 587294 Marchall, Robert, of Todyngton, smith 0
5331216 2454410 2454410 defendant Symond John chapman 587294 587294 Symond, John, of Todyngton, chapman 3
5333711 2455156 2455156 plaintiff Dey Walter chaplain 587294 587294 Dey, Walter, of Todyngton, chaplain 1
5348507 2459672 2459672 defendant Alwey Simon turner 587294 587294 Alwey, Simon, of Todyngton, turner 0
5348567 2459685 2459685 defendant Rugmer John baker 587294 587294 Rugmer, John, of Todyngton, baker 3
5350437 2460259 2460259 defendant Wollyngton Nicholas husbandman 587294 587294 Wollyngton, Nicholas, of Todyngton, husbandman 0
5362039 2463793 2463793 defendant Broun John tailor 587294 587294 Broun, John, of Todyngton, tailor 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);