names

71 rows where place_id = 611482

✎ 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
3688615 1922596 1922596 defendant Churche William husbandman 611482 611482 Churche, William, of Stacheden, husbandman 3
3707260 1928560 1928560 defendant Cokke Nicholas husbandman 611482 611482 Cokke, Nicholas, of Stacheden, husbandman 0
3708949 1929091 1929091 defendant Verneham John   611482 611482 Verneham, John, of Stacheden, horse courser 0
3746163 1940707 1940707 defendant Toller John husbandman 611482 611482 Toller, John, of Stacheden, husbandman 0
3798765 1957529 1957529 defendant Toller John husbandman 611482 611482 Toller, John, of Stacheden, husbandman 0
3799527 1957770 1957770 defendant Byngham Thomas gent 611482 611482 Byngham, Thomas, of Stacheden, gent 0
4439789 2181720 2181720 defendant Cok John   611482 611482 Cok, John, of Stacheden 0
4439790 2181720 2181720 defendant Daye John   611482 611482 Daye, John, of Stacheden 1
4457589 2187385 2187385 defendant Sampson Henry   611482 611482 Sampson, Henry, of Stacheden 0
4610341 2234320 2234320 defendant Sampson Richard   611482 611482 Sampson, Richard, of Stacheden 0
4616914 2236294 2236294 defendant Ratyll William   611482 611482 Ratyll, William, of Stacheden 0
4621103 2237582 2237582 defendant Kamstorre Robert   611482 611482 Kamstorre, Robert, of Stacheden 0
4624380 2238604 2238604 defendant Sampson Richard   611482 611482 Sampson, Richard, of Stacheden 0
4624392 2238610 2238610 defendant Sampson Richard   611482 611482 Sampson, Richard, of Stacheden 0
4628848 2239953 2239953 defendant Ratele William   611482 611482 Ratele, William, of Stacheden 0
4641760 2243689 2243689 defendant Sampson Richard   611482 611482 Sampson, Richard, of Stacheden 1
4656278 2247858 2247858 plaintiff Campyon John   611482 611482 Campyon, John, of Stacheden 0
4691393 2262832 2262832 defendant Cok Stepehn husbandman 611482 611482 Cok, Stepehn, of Stacheden, husbandman, Smyth, William, of Radewell, husbandman 2
4715551 2270193 2270193 defendant Sampson Richard yeoman 611482 611482 Sampson, Richard, of Stacheden, yeoman 3
4733402 2275625 2275625 defendant Cok Stephen husbandman 611482 611482 Cok, Stephen, of Stacheden, husbandman 0
4733404 2275625 2275625 defendant Cok John husbandman 611482 611482 Cok, John, of Stacheden, husbandman 2
4733405 2275625 2275625 defendant Cok Maud single woman 611482 611482 Cok, Maud, of Stacheden, single woman 3
4756571 2282418 2282418 defendant Langton Richard husbandman 611482 611482 Langton, Richard, of Stacheden, husbandman 0
4766896 2285637 2285637 defendant Mabele John husbandman 611482 611482 Mabele, John, of Stacheden, husbandman 0
4859235 2314264 2314264 defendant Sampson John, junior husbandman 611482 611482 Sampson, John, junior, of Stacheden, husbandman 0
4859236 2314264 2314264 defendant Tollere William husbandman 611482 611482 Tollere, William, of Stacheden, husbandman 1
4859237 2314264 2314264 defendant Wele Thomas husbandman 611482 611482 Wele, Thomas, of Stacheden, husbandman 2
4872212 2318270 2318270 defendant Ratill Robert yeoman 611482 611482 Ratill, Robert, of Stacheden, yeoman 0
4885745 2322415 2322415 defendant Sampson John, junior husbandman 611482 611482 Sampson, John, junior, of Stacheden, husbandman 0
4885746 2322415 2322415 defendant Toller William husbandman 611482 611482 Toller, William, of Stacheden, husbandman 1
4885747 2322415 2322415 defendant Wele Thomas husbandman 611482 611482 Wele, Thomas, of Stacheden, husbandman 2
4891502 2324078 2324078 defendant Sampson John, junior husbandman 611482 611482 Sampson, John, junior, of Stacheden, husbandman 0
4891503 2324078 2324078 defendant Toller William husbandman 611482 611482 Toller, William, of Stacheden, husbandman 1
4891504 2324078 2324078 defendant Wele Thomas husbandman 611482 611482 Wele, Thomas, of Stacheden, husbandman 2
4898009 2326046 2326046 defendant Wele Thomas husbandman 611482 611482 Wele, Thomas, of Stacheden, husbandman 0
4904248 2327940 2327940 defendant Wele Thomas husbandman 611482 611482 Wele, Thomas, of Stacheden, husbandman 0
4914020 2330895 2330895 defendant Etewell Henry gent 611482 611482 Etewell, Henry, of Stacheden, gent 0
4916645 2331717 2331717 plaintiff Feynaunce James   611482 611482 Feynaunce, James, of Stacheden, on his own account 0
4916647 2331717 2331717 defendant Somer Richard husbandman 611482 611482 Somer, Richard, of Stacheden, husbandman 1
4922049 2333307 2333307 defendant Leyger Thomas   611482 611482 Leyger, Thomas, of Stacheden, vicar 2
4939439 2338717 2338717 defendant Etewell Henry gent 611482 611482 Etewell, Henry, of Stacheden, gent 0
5002262 2357565 2357565 defendant Dane John husbandman 611482 611482 Dane, John, of Stacheden, husbandman 0
5151164 2401482 2401482 defendant Bacheford John laborer 611482 611482 Bacheford, John, of Stacheden, laborer 1
5151165 2401482 2401482 defendant Taillour Peter tailor 611482 611482 Taillour, Peter, of Stacheden, tailor 2
5175170 2408430 2408430 defendant Toller John laborer 611482 611482 Toller, John, of Stacheden, laborer 2
5196229 2414649 2414649 defendant Toller John laborer 611482 611482 together with Toller, John, of Stacheden, laborer 2
5196231 2414650 2414650 defendant Toller John laborer 611482 611482 Toller, John, of Stacheden, laborer 0
5209360 2418473 2418473 defendant Toller Richard husbandman 611482 611482 together with Toller, Richard, of Stacheden, husbandman 1
5221229 2421906 2421906 defendant Wryght Roger smith 611482 611482 Wryght, Roger, of Stacheden, smith 3
5264608 2434684 2434684 defendant Toller Richard husbandman 611482 611482 Toller, Richard, of Stacheden, husbandman 1
5264610 2434685 2434685 defendant Toller John laborer 611482 611482 Toller, John, of Stacheden, laborer 0
5287763 2441445 2441445 defendant Ratell Margery   611482 611482 Ratell, Margery, of Stacheden 0
5307073 2447114 2447114 defendant Ratyll Richard husbandman 611482 611482 Ratyll, Richard, of Stacheden, husbandman 0
5309222 2447794 2447794 defendant Ratell Richard husbandman 611482 611482 Ratell, Richard, of Stacheden, husbandman 0
5367502 2465483 2465483 defendant Cok John husbandman 611482 611482 Cok, John, of Stacheden, husbandman 0
5367504 2465484 2465484 defendant Eyer Agnes widow 611482 611482 Eyer, Agnes, of Stacheden, widow 0
5429124 2483636 2483636 defendant Goldston Thomas yeoman 611482 611482 Goldston, Thomas, of Stacheden, yeoman 1
5431144 2484255 2484255 defendant Shopthorp Thomas butcher 611482 611482 Shopthorp, Thomas, of Stacheden, butcher 1
5437840 2486249 2486249 defendant Goldstone Thomas   611482 611482 Goldstone, Thomas, of Stacheden, franklin 0
5437841 2486249 2486249 defendant Cok John husbandman 611482 611482 Cok, John, of Stacheden, husbandman 1
5446298 2488787 2488787 defendant Asteall Henry husbandman 611482 611482 Asteall, Henry, of Stacheden, husbandman 0
5447707 2489188 2489188 defendant Shipthorp Thomas butcher 611482 611482 Shipthorp, Thomas, of Stacheden, butcher 1
5487057 2501026 2501026 defendant Lylloyot Henry husbandman 611482 611482 Lylloyot, Henry, of Stacheden, husbandman 0
5487058 2501026 2501026 defendant Robynson Thomas carpenter 611482 611482 Robynson, Thomas, of Stacheden, carpenter 1
5548198 2519502 2519502 defendant Cok John smith 611482 611482 Cok, John, of Stacheden, smith 0
5569092 2525510 2525510 defendant Goldston John husbandman 611482 611482 Goldston, John, of Stacheden, husbandman 0
5614319 2548265 2548265 defendant Saunson Henry   611482 611482 Saunson, Henry, of Stacheden 0
5619339 2549899 2549899 defendant Alde John   611482 611482 Alde, John, of Stacheden 0
5620337 2550219 2550219 plaintiff Ryslee John   611482 611482 Ryslee, John, of Stacheden, on his own account 0
5620338 2550219 2550219 defendant Kelby John de   611482 611482 Kelby, John de, of Stacheden 0
5630014 2553390 2553390 defendant Ratell William husbandman 611482 611482 Ratell, William, of Stacheden, husbandman 0

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