names

97 rows where place_id = 589994

✎ 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
3599495 1867483 1867483 defendant Curson Richard esq 589994 589994 Curson, Richard, of Duffeld, esq 1
3599498 1867484 1867484 defendant Curson Richard esq 589994 589994 Curson, Richard, of Duffeld, esq 1
3610058 1870812 1870812 defendant Grendon Thomas laborer 589994 589994 Grendon, Thomas, of Duffeld, laborer 4
3634290 1905521 1905521 defendant Calton Robert husbandman 589994 589994 Calton, Robert, of Duffeld, husbandman 5
3666947 1915607 1915607 defendant Baylly William husbandman 589994 589994 Baylly, William, of Duffeld, husbandman 2
3771842 1948883 1948883 defendant Flyte William butcher 589994 589994 Flyte, William,of Duffeld, butcher 1
3774728 1949825 1949825 defendant Johnson Thomas tanner 589994 589994 Johnson, Thomas, of Duffeld, tanner 2
3789335 1954484 1954484 defendant Nuttye Ralph yeoman 589994 589994 Nuttye, Ralph, of Duffeld, yeoman 3
3793130 1955711 1955711 defendant Ekyngton Thomas laborer 589994 589994 Ekyngton, Thomas, of Duffeld, laborer 3
3846183 1972362 1972362 defendant Johnson Thomas yeoman 589994 589994 Johnson, Thomas, of Duffeld, yeoman 0
3846184 1972362 1972362 defendant Dudley John husbandman 589994 589994 Dudley, John, of Duffeld, husbandman 1
3846185 1972362 1972362 defendant Mylner Nicholas husbandman 589994 589994 Mylner, Nicholas, of Duffeld, husbandman 2
3846186 1972362 1972362 defendant Stevyns Henry husbandman 589994 589994 Stevyns, Henry, of Duffeld, husbandman 3
3847375 1972739 1972739 defendant Ive John laborer 589994 589994 Ive, John, of Duffeld, laborer 3
3847376 1972739 1972739 defendant Doley Richard laborer 589994 589994 Doley, Richard, of Duffeld, laborer 4
3873659 1981406 1981406 defendant Cletham Margaret spinster 589994 589994 Cletham, Margaret, of Duffeld, spinster 0
3873660 1981406 1981406 defendant Hellet John laborer 589994 589994 Hellet, John, of Duffeld, laborer 1
3876648 1982434 1982434 defendant Stephyns Henry husbandman 589994 589994 Stephyns, Henry, of Duffeld, husbandman 3
3877006 1982549 1982549 defendant Stephyns Henry husbandman 589994 589994 Stephyns, Henry, of Duffeld, husbandman 3
3949869 2007030 2007030 plaintiff Fenton William (legal representative) 589994 589994 Fenton, William, of Duffeld, executors of 0
3950715 2007323 2007323 defendant Smyth Thomas husbandman 589994 589994 Smyth, Thomas, of Duffeld, husbandman 1
3966009 2012734 2012734 defendant Deyne James yeoman 589994 589994 Deyne, James, of Duffeld, or of Wyrkesworth, Derbs, yeoman 0
4014434 2029885 2029885 defendant Fox John husbandman 589994 589994 Fox, John, of Duffeld, husbandman 1
4105468 2062233 2062233 defendant Jenny John yeoman 589994 589994 Jenny, John, of Duffeld, or of Shottyll, yeoman 0
4170130 2085046 2085046 defendant Somers Bartholomew butcher 589994 589994 Somers, Bartholomew, of Duffeld, butcher 0
4170132 2085047 2085047 defendant Somers Bartholomew butcher 589994 589994 Somers, Bartholomew, of Duffeld, butcher 0
4215679 2100982 2100982 defendant Jannynges John husbandman 589994 589994 Jannynges, John, of Duffeld, or of Shottle, husbandman 1
4217806 2101720 2101720 defendant Bruck Anthony carpenter 589994 589994 Bruck, Anthony, of Duffeld, carpenter 1
4222690 2103427 2103427 defendant Grene Thomas butcher 589994 589994 Grene, Thomas, of Duffeld, butcher 0
4287661 2125639 2125639 defendant Parker Thomas yeoman 589994 589994 Parker, Thomas, of Duffeld, yeoman 0
4292117 2127252 2127252 defendant Smythhurst alias Pichard Margaret widow 589994 589994 Smythhurst alias Pichard, Margaret, of Duffeld, widow 2
4296288 2128770 2128770 defendant Palphreman Ralph clerk 589994 589994 Palphreman, Ralph, of Duffeld, clerk 0
4310221 2133730 2133730 defendant Grace Thomas yeoman 589994 589994 Grace, Thomas, of Duffeld, yeoman 0
4310575 2133847 2133847 defendant Johnson William yeoman 589994 589994 Johnson, William, of Duffeld, yeoman 0
4313758 2134919 2134919 defendant Fletcher Christopher yeoman 589994 589994 Fletcher, Christopher, of Duffeld, or of Makeney, yeoman 0
4380237 2158035 2158035 defendant Manyfold Thomas yeoman 589994 589994 Manyfold, Thomas, of Duffeld, yeoman 0
4380238 2158035 2158035 defendant Brooke Anthony yeoman 589994 589994 Brooke, Anthony, of Duffeld, yeoman 1
4400578 2164785 2164785 defendant Brook Anthony carpenter 589994 589994 Brook, Anthony, of Duffeld, carpenter 0
4438202 2181246 2181246 defendant Waterhous Thomas de   589994 589994 Waterhous, Thomas de, of Duffeld 0
4439228 2181546 2181546 defendant Waterhous Thomas de   589994 589994 Waterhous, Thomas de, of Duffeld 0
4447149 2184015 2184015 defendant Ibson Richard   589994 589994 Ibson, Richard, of Duffeld 2
4475042 2192864 2192864 defendant Lylly William   589994 589994 Lylly, William, of Duffeld 3
4519440 2206439 2206439 defendant Lylly William   589994 589994 Lylly, William, of Duffeld 5
4565776 2220852 2220852 plaintiff Souter Robert   589994 589994 Souter, Robert, of Duffeld 0
4565777 2220852 2220852 plaintiff Wade Thomas   589994 589994 Wade, Thomas, of Duffeld 1
4572057 2222826 2222826 defendant Waterhouse Thomas   589994 589994 Waterhouse, Thomas, of Duffeld 0
4617028 2236335 2236335 defendant Daa John   589994 589994 Daa, John, of duffeld 1
4629490 2240152 2240152 plaintiff Souter Thomas   589994 589994 Souter, Thomas, of Duffeld, son of Robert 0
4688011 2261821 2261821 defendant Henryson John husbandman 589994 589994 Henryson, John, of Duffeld, husbandman 1
4692056 2263048 2263048 defendant Foliambe William gent 589994 589994 Foliambe, William, of Duffeld, gent 0
4708430 2268002 2268002 defendant Sumpnour Thomas yeoman 589994 589994 Sumpnour, Thomas, of Duffeld, yeoman 0
4713634 2269587 2269587 defendant Henryson John husbandman 589994 589994 Henryson, John, of Duffeld, husbandman 1
4729226 2274361 2274361 defendant Souter William husbandman 589994 589994 Souter, William, of Duffeld, husbandman 0
4749221 2280255 2280255 defendant Perfey or Persey John laborer 589994 589994 Perfey or Persey, John, of Duffeld, laborer 2
4750944 2280759 2280759 defendant Curteys John   589994 589994 Curteys, John, of Duffeld, scythe smith 2
4753022 2281333 2281333 defendant Balle John husbandman 589994 589994 Balle, John, of Duffeld, husbandman 3
4762925 2284388 2284388 plaintiff Gayford John (legal representative) 589994 589994 Gayford, John, of Duffeld, executors of 0
4786027 2291667 2291667 defendant Perisson John husbandman 589994 589994 Perisson, John, of Duffeld, husbandman 11
4787189 2292059 2292059 defendant Curteys John   589994 589994 Curteys, John, of Duffeld, scythe smith 2
4791525 2293445 2293445 defendant Balle John husbandman 589994 589994 Balle, John, of Duffeld, husbandman 0
4791526 2293445 2293445 defendant Fysshe John tailor 589994 589994 Fysshe, John, of Duffeld, tailor 1
4797798 2295486 2295486 defendant Bagworth Richard smith 589994 589994 Bagworth, Richard, of Duffeld, smith 0
4805326 2297870 2297870 defendant Duffeld Thomas ironmonger 589994 589994 Duffeld, Thomas, of Duffeld, ironmonger 1
4819725 2302246 2302246 defendant Elynson John husbandman 589994 589994 Elynson, John, of Duffeld, husbandman 0
4860421 2314623 2314623 defendant Whithove Thomas husbandman 589994 589994 Whithove, Thomas, of Duffeld, husbandman 1
4905302 2328252 2328252 defendant Balle Simon husbandman 589994 589994 Balle, Simon, of Duffeld, husbandman 0
4905303 2328252 2328252 defendant Ryver Nicholas husbandman 589994 589994 Ryver, Nicholas, of Duffeld, husbandman 1
4905304 2328252 2328252 defendant Stanley Nicholas husbandman 589994 589994 Stanley, Nicholas, of Duffeld, husbandman 2
4906241 2328542 2328542 defendant Curteys John   589994 589994 Curteys, John, of Duffeld, scythe smith 3
4915087 2331225 2331225 defendant Abbot Henry (legal representative) 589994 589994 Abbot, Henry, of Duffeld, husbandman, executors of 0
4936185 2337718 2337718 defendant Waterhous Lucy   589994 589994 Waterhous, Lucy, of Duffeld, widow of Waterhous, William 1
4949448 2341820 2341820 defendant Clerk John yeoman 589994 589994 Clerk, John, of Duffeld, yeoman 0
4949449 2341820 2341820 defendant Blaunchard John husbandman 589994 589994 Blaunchard, John, of Duffeld, husbandman 1
4951127 2342316 2342316 defendant Wylkynson John husbandman 589994 589994 Wylkynson, John, of Duffeld, husbandman 0
4954389 2343280 2343280 defendant Abbot Henry (legal representative) 589994 589994 Abbot, Henry, of Duffeld, executors of 0
4954390 2343280 2343280 defendant Abbot Nicholas husbandman 589994 589994 (Abbot, Nicholas, of Duffeld, husbandman 1
5036650 2367588 2367588 defendant Nicoll Thomas husbandman 589994 589994 Nicoll, Thomas, of Duffeld, husbandman 0
5045054 2370154 2370154 defendant Robynson Richard husbandman 589994 589994 Robynson, Richard, of Duffeld, husbandman 2
5063610 2375649 2375649 defendant Byrchemore John husbandman 589994 589994 Byrchemore, John, of Duffeld, husbandman 0
5252303 2430829 2430829 defendant Bothe Richard   589994 589994 Bothe, Richard, of Duffeld, scythe smith 3
5358722 2462789 2462789 defendant Johnson Ellen laborer 589994 589994 Johnson, Ellen , of Duffeld, laborer 2
5371876 2466789 2466789 defendant Ball John husbandman 589994 589994 Ball, John, of Duffeld, husbandman 0
5433318 2484932 2484932 defendant Malbone Richard   589994 589994 Malbone, Richard, of Duffeld, scythe grinder 0
5441562 2487396 2487396 defendant Babyngton Thomas gent 589994 589994 Babyngton, Thomas, of Duffeld, gent 2
5483130 2499893 2499893 defendant Ball John husbandman 589994 589994 Ball, John, of Duffeld, husbandman 1
5547392 2519248 2519248 defendant Bradshawe John gent 589994 589994 Bradshawe, John, of Duffeld, gent 3
5559696 2522794 2522794 defendant Bradshawe John yeoman 589994 589994 Bradshawe, John, of Duffeld, yeoman 0
5559697 2522794 2522794 defendant Souter John   589994 589994 Souter, John, of Duffeld, scythe smith 1
5594134 2533143 2533143 defendant Reyner Thomas husbandman 589994 589994 Reyner, Thomas, of Duffeld, husbandman 0
5595361 2533495 2533495 defendant Parker John yeoman 589994 589994 Parker, John, of Duffeld, yeoman 1
5600064 2534904 2534904 defendant Folowe John yeoman 589994 589994 Folowe, John, of Duffeld, yeoman 1
5600908 2535171 2535171 defendant Wilde John carpenter 589994 589994 Wilde, John, of Duffeld, carpenter 0
5600909 2535171 2535171 defendant Wilde Thomas carpenter 589994 589994 Wilde, Thomas, of Duffeld, carpenter 1
5600910 2535171 2535171 defendant Wilde Christopher carpenter 589994 589994 Wilde, Christopher, of Duffeld, carpenter 2
5631677 2553917 2553917 plaintiff Spycer Thomas   589994 589994 Spycer, Thomas, of Duffeld 1
5635287 2555001 2555001 plaintiff Watrehous Thomas   589994 589994 Watrehous, Thomas, of Duffeld 0
5635928 2555195 2555195 defendant Stanley Thomas ironmonger 589994 589994 Stanley, Thomas, of Duffeld, 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);