names

65 rows where place_id = 587824

✎ 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
3592540 1865282 1865282 defendant Newesom John husbandman 587824 587824 Newesom, John, of Campsall, husbandman 0
3599135 1867365 1867365 defendant Mossley Richard husbandman 587824 587824 Mossley, Richard, of Campsall, husbandman 2
3909167 1993364 1993364 defendant Chadwyke John husbandman 587824 587824 Chadwyke, John, of Campsall, husbandman 0
3940511 2003838 2003838 plaintiff St Paul Robert gent 587824 587824 St Paul, Robert, of Campsall, gent 0
3942929 2004640 2004640 defendant Wyntryngam alias Smythe Hugh husbandman 587824 587824 Wyntryngam alias Smythe, Hugh, of Campsall, husbandman 0
4075310 2051472 2051472 defendant Smythe John husbandman 587824 587824 Smythe, John, of Campsall, husbandman 2
4075314 2051473 2051473 defendant Smyth John husbandman 587824 587824 Smyth, John, of Campsall, husbandman 2
4075315 2051473 2051473 defendant Chadwicke Joan widow 587824 587824 Chadwicke, Joan, of Campsall, widow 3
4217730 2101690 2101690 defendant Rowlston Silvester gent 587824 587824 Rowlston, Silvester, of Campsall, gent 0
4217731 2101690 2101690 defendant Wintringham alias Smyth John husbandman 587824 587824 Wintringham alias Smyth, John, of Campsall, husbandman 1
4221036 2102853 2102853 defendant Gresham Edward schoolmaster 587824 587824 Gresham, Edward, of Campsall, schoolmaster 0
4228905 2105590 2105590 defendant Rowleston Silvester gent 587824 587824 Rowleston, Silvester, of Campsall, gent 0
4256858 2115264 2115264 defendant Chadwick Oliver husbandman 587824 587824 Chadwick, Oliver, of Campsall, husbandman 0
4266566 2118465 2118465 defendant Wrighte Robert husbandman 587824 587824 Wrighte, Robert, of Campsall, husbandman 0
4266643 2118489 2118489 defendant Cuscrofte John yeoman 587824 587824 Cuscrofte, John, of Campsall, yeoman 1
4271580 2120076 2120076 defendant Gresham Edward schoolmaster 587824 587824 Gresham, Edward, of Campsall, schoolmaster 0
4313116 2134704 2134704 defendant Rowleston Elizabeth widow 587824 587824 Rowleston, Elizabeth, of Campsall, widow 3
4321286 2137536 2137536 defendant Winteringham John husbandman 587824 587824 Winteringham, John, of Campsall, husbandman 1
4351388 2147736 2147736 defendant Huscrofte Thomas butcher 587824 587824 Huscrofte, Thomas, of Campsall, butcher 0
4351391 2147736 2147736 defendant Womlacke Dorothy widow 587824 587824 Womlacke, Dorothy, of Campsall, widow 3
4394316 2162697 2162697 defendant Swaynson Thomas cordwainer 587824 587824 Swaynson, Thomas, of Campsall, cordwainer 1
4397445 2163725 2163725 defendant Robinson Thomas husbandman 587824 587824 Robinson, Thomas, of Campsall, husbandman 0
4397446 2163725 2163725 defendant Atkinson Robert husbandman 587824 587824 Atkinson, Robert, of Campsall, husbandman 1
4551322 2216351 2216351 defendant Byrkyn Edmund   587824 587824 Byrkyn, Edmund, of Campsall 1
4613689 2235292 2235292 defendant Birkyn Edmund   587824 587824 Birkyn, Edmund, of Campsall 1
4643465 2244188 2244188 defendant Walker Richard   587824 587824 Walker, Richard, of Campsall 2
4733455 2275638 2275638 defendant Wilford Robert chaplain 587824 587824 Wilford, Robert, of Campsall, chaplain 0
4733456 2275638 2275638 defendant Cartwryght Richard chaplain 587824 587824 Cartwryght, Richard, of Campsall, chaplain 1
4837507 2307667 2307667 defendant Bolton William chaplain 587824 587824 Bolton, William, of Campsall, chaplain 0
4854304 2312754 2312754 defendant Smyth Henry husbandman 587824 587824 Smyth, Henry, of Campsall, husbandman 0
4854305 2312754 2312754 defendant Genet John husbandman 587824 587824 Genet, John, of Campsall, husbandman 1
4883915 2321879 2321879 defendant Lande Thomas husbandman 587824 587824 Lande, Thomas, of Campsall, husbandman 0
4975705 2349696 2349696 defendant Saynpoll Brian gent 587824 587824 Saynpoll, Brian, of Campsall, gent 0
4999349 2356676 2356676 plaintiff Lasyng John (legal representative) 587824 587824 Lasyng, John, of Campsall, chaplain, warden & farmer of the parish, executor of 0
4999351 2356676 2356676 defendant Talbot Ppeter esq 587824 587824 Talbot, Ppeter, of Campsall, esq 0
5006335 2358751 2358751 defendant Atkynson John husbandman 587824 587824 Atkynson, John, of Campsall, husbandman 0
5026318 2364588 2364588 defendant Talbot Peter esq 587824 587824 Talbot, Peter, of Campsall, esq 0
5064494 2375921 2375921 defendant Talbot Peter esq 587824 587824 Talbot, Peter, of Campsall, esq 0
5067821 2376877 2376877 defendant Alban Thomas husbandman 587824 587824 Alban, Thomas, of Campsall, husbandman 0
5104749 2387827 2387827 defendant Benet Thomas husbandman 587824 587824 Benet, Thomas, of Campsall, husbandman 2
5303831 2446143 2446143 defendant Atkynson John, sen husbandman 587824 587824 Atkynson, John, sen, of Campsall, husbandman 3
5303832 2446143 2446143 defendant Brayton Richard   587824 587824 Brayton, Richard, of Campsall, franklin 4
5346283 2458979 2458979 plaintiff Abde William   587824 587824 Abde, William, of Campsall 0
5383419 2470337 2470337 defendant Cloveley Ralph clerk 587824 587824 Cloveley, Ralph, of Campsall, clerk 1
5384621 2470687 2470687 defendant Abdy William yeoman 587824 587824 Abdy, William, of Campsall, yeoman 0
5384622 2470687 2470687 defendant Shagh Thomas yeoman 587824 587824 Shagh, Thomas, of Campsall, yeoman 1
5395200 2473699 2473699 defendant Cleveley Ralph clerk 587824 587824 Cleveley, Ralph, of Campsall, clerk 1
5396488 2474090 2474090 defendant Aldy William yeoman 587824 587824 Aldy, William, of Campsall, yeoman 0
5408433 2477494 2477494 defendant Cleveley Ralph   587824 587824 Cleveley, Ralph, of Campsall 1
5409757 2477895 2477895 defendant Aldy William yeoman 587824 587824 Aldy, William, of Campsall, yeoman 0
5409759 2477895 2477895 defendant Toly William yeoman 587824 587824 Toly, William, of Campsall, yeoman 2
5409760 2477895 2477895 defendant Mosselay Richard yeoman 587824 587824 Mosselay, Richard, of Campsall, yeoman 3
5423452 2481973 2481973 defendant Avery William yeoman 587824 587824 Avery, William, of Campsall, yeoman 0
5423453 2481973 2481973 defendant Ch__gh Thomas yeoman 587824 587824 Ch__gh, Thomas, of Campsall, yeoman 1
5430704 2484123 2484123 defendant Coly William husbandman 587824 587824 Coly, William, of Campsall, husbandman 0
5442751 2487745 2487745 defendant Abey William yeoman 587824 587824 Abey, William, of Campsall, yeoman 0
5447260 2489069 2489069 defendant Abde William yeoman 587824 587824 Abde, William, of Campsall, yeoman 0
5466144 2494816 2494816 defendant Saull Richard yeoman 587824 587824 Saull, Richard, of Campsall, yeoman 0
5466856 2495034 2495034 defendant Abdy William yeoman 587824 587824 Abdy, William, of Campsall, yeoman 0
5482393 2499675 2499675 defendant Lonkes or Loukes William tailor 587824 587824 Lonkes or Loukes, William, of Campsall, tailor 8
5506114 2506830 2506830 defendant Abdy William yeoman 587824 587824 Abdy, William, of Campsall, yeoman 0
5506116 2506831 2506831 defendant Abdy William yeoman 587824 587824 Abdy, William, of Campsall, yeoman 0
5544699 2518451 2518451 defendant Saule John yeoman 587824 587824 Saule, John, of Campsall, husbandman, son of Saule, Richard, of Campsall, yeoman 1
5584651 2530270 2530270 defendant Pullen Thomas husbandman 587824 587824 Pullen, Thomas, of Campsall, husbandman 1
5584652 2530270 2530270 defendant Hustoft John husbandman 587824 587824 Hustoft, John, of Campsall, husbandman 2

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