names

74 rows where place_id = 670896

✎ 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
3837393 1969606 1969606 plaintiff Smythe John (legal representative) 670896 670896 Smythe, John, of Stutton, executors of 0
3853454 1974706 1974706 plaintiff Smythe John (legal representative) 670896 670896 Smythe, John, of Stutton, executors of 0
3999319 2024516 2024516 defendant Skryvener Robert yeoman 670896 670896 Skryvener, Robert, of Stutton, yeoman 0
4052266 2043234 2043234 defendant Scryvener Robert husbandman 670896 670896 Scryvener, Robert, of Stutton, husbandman 0
4160166 2081620 2081620 defendant Rowndbould Thomas yeoman 670896 670896 Rowndbould, Thomas, of Stutton, yeoman 0
4168634 2084516 2084516 defendant Rumbolde Thomas yeoman 670896 670896 Rumbolde, Thomas, of Stutton, yeoman 0
4168635 2084516 2084516 defendant Phillipps Peter shoemaker 670896 670896 Phillipps, Peter, of Stutton, shoemaker 1
4195586 2094005 2094005 defendant Phillips Peter yeoman 670896 670896 Phillips, Peter, of Stutton, yeoman 0
4241065 2109996 2109996 defendant Elmes William husbandman 670896 670896 Elmes, William, of Stutton, husbandman 0
4281742 2123518 2123518 defendant Clyfford Christopher miller 670896 670896 Clyfford, Christopher, of Stutton, miller 3
4307348 2132707 2132707 defendant Smyth Francis husbandman 670896 670896 Smyth, Francis, of Stutton, husbandman 2
4332230 2141073 2141073 defendant Smyth Francis husbandman 670896 670896 Smyth, Francis, of Stutton, husbandman 2
4449327 2184739 2184739 defendant Caperon Roger   670896 670896 Caperon, Roger, of Stutton 0
4450384 2185078 2185078 defendant Custson William   670896 670896 Custson, William, of Stutton 0
4458728 2187776 2187776 defendant Balle Peter   670896 670896 Balle, Peter, of Stutton 0
4458732 2187776 2187776 defendant Reynold William   670896 670896 Reynold, William, of Stutton 4
4507809 2202900 2202900 defendant Clerk Nicholas   670896 670896 Clerk, Nicholas, of Stutton 0
4660603 2249143 2249143 defendant Denell William yeoman 670896 670896 Denell, William, of Stutton, yeoman 0
4704272 2266713 2266713 defendant Denyell William tailor 670896 670896 Denyell, William, of Stutton, tailor 0
4787547 2292179 2292179 defendant de Stutton Richard husbandman 670896 670896 de Stutton, Richard, of Stutton, husbandman 1
4966442 2346897 2346897 defendant Mannyng John fuller 670896 670896 Mannyng, John, of Stutton, fuller 0
5016906 2361836 2361836 plaintiff Campell William   670896 670896 Campell, William, of Stutton 0
5034143 2366852 2366852 defendant Yngram Nicholas laborer 670896 670896 Yngram, Nicholas, of Stutton, laborer 0
5038899 2368280 2368280 defendant Cole John woolman 670896 670896 Cole, John, of Stutton, woolman 0
5043586 2369702 2369702 defendant Cole John woolman 670896 670896 Cole, John, of Stutton, woolman 0
5049999 2371620 2371620 defendant Curson William gent 670896 670896 Curson, William, of Stutton, gent 1
5056414 2373492 2373492 defendant Cole John woolman 670896 670896 Cole, John, of Stutton, woolman 0
5056415 2373492 2373492 defendant Mors Roger fuller 670896 670896 Mors, Roger, of Stutton, fuller 1
5056416 2373492 2373492 defendant Turnebolle William weaver 670896 670896 Turnebolle, William, of Stutton, weaver 2
5101511 2386854 2386854 defendant Pepyr William laborer 670896 670896 Pepyr, William, of Stutton, laborer 1
5101513 2386854 2386854 defendant Payn John husbandman 670896 670896 Payn, John, of Stutton, husbandman 3
5118962 2391980 2391980 defendant Mason Richard husbandman 670896 670896 Mason, Richard, of Stutton, husbandman 0
5118963 2391980 2391980 defendant Parre Richard husbandman 670896 670896 Parre, Richard, of Stutton, husbandman 1
5127564 2394542 2394542 defendant Bagot John clerk 670896 670896 Bagot, John, of Stutton, clerk 0
5141110 2398525 2398525 defendant Bagotte John clerk 670896 670896 Bagotte, John, of Stutton, clerk 0
5141111 2398525 2398525 defendant Campelle William yeoman 670896 670896 Campelle, William, of Stutton, yeoman 1
5141112 2398525 2398525 defendant Bodde alias Podde Nicholas yeoman 670896 670896 Bodde alias Podde, Nicholas, of Stutton, yeoman 2
5146251 2400033 2400033 defendant Campell Thomas yeoman 670896 670896 Campell, Thomas, of Stutton, yeoman 2
5146511 2400112 2400112 defendant Bagot John clerk 670896 670896 Bagot, John, of Stutton, clerk 0
5162294 2404700 2404700 defendant Campelle William yeoman 670896 670896 Campelle, William, of Stutton, yeoman 1
5162295 2404700 2404700 defendant Bodde alias Podde Nicholas yeoman 670896 670896 Bodde alias Podde, Nicholas, of Stutton, yeoman 2
5165606 2405681 2405681 defendant Buxston John chapman 670896 670896 Buxston, John, of Stutton, chapman 2
5166457 2405914 2405914 defendant Campell Thomas yeoman 670896 670896 Campell, Thomas, of Stutton, yeoman 2
5176417 2408789 2408789 defendant Campelle William yeoman 670896 670896 Campelle, William, of Stutton, yeoman 1
5176418 2408789 2408789 defendant Bodde Nicholas yeoman 670896 670896 Bodde, Nicholas, of Stutton, yeoman 2
5181488 2410326 2410326 defendant Bagot John clerk 670896 670896 Bagot, John, of Stutton, clerk 0
5198452 2415304 2415304 defendant Campelle William yeoman 670896 670896 Campelle, William, of Stutton, yeoman 1
5198453 2415304 2415304 defendant Bodde Nicholas yeoman 670896 670896 Bodde, Nicholas, of Stutton, yeoman 2
5200975 2416047 2416047 defendant Fountance William husbandman 670896 670896 Fountance, William, of Stutton, husbandman 0
5216198 2420471 2420471 defendant Buxton John mercer 670896 670896 Buxton, John, of Stutton, mercer 0
5216199 2420471 2420471 defendant Bordinale or Bordmale Henry weaver 670896 670896 Bordinale or Bordmale, Henry, of Stutton, weaver 1
5216200 2420471 2420471 defendant Donkle John husbandman 670896 670896 Donkle, John, of Stutton, husbandman 2
5219120 2421318 2421318 defendant Mors Roger fuller 670896 670896 Mors, Roger, of Stutton, fuller 0
5223877 2422669 2422669 plaintiff Payne John husbandman 670896 670896 Payne, John, of Stutton, husbandman 0
5252262 2430816 2430816 defendant Payn John husbandman 670896 670896 Payn, John, of Stutton, husbandman 0
5252263 2430816 2430816 defendant Podde Nicholas husbandman 670896 670896 Podde, Nicholas, of Stutton, husbandman 1
5263213 2434240 2434240 defendant Fulthorp Thomas esq 670896 670896 Fulthorp, Thomas, of Stutton, esq 0
5265074 2434836 2434836 defendant Bagot John chaplain 670896 670896 Bagot, John, of Stutton, chaplain 0
5282425 2439920 2439920 defendant Turnour Peter yeoman 670896 670896 Turnour, Peter, of Stutton, yeoman 3
5282440 2439923 2439923 defendant Turnour Peter yeoman 670896 670896 Turnour, Peter, of Stutton, yeoman 3
5311907 2448588 2448588 defendant Gerard John husbandman 670896 670896 (Gerard, John, of Stutton, husbandman 1
5329062 2453772 2453772 defendant Ingforby William laborer 670896 670896 Ingforby, William, of Stutton, laborer 1
5347385 2459343 2459343 defendant Mason William husbandman 670896 670896 Mason, William, of Stutton, husbandman 1
5351462 2460556 2460556 defendant Crowe Nicholas husbandman 670896 670896 Crowe, Nicholas, of Stutton, husbandman 0
5351463 2460556 2460556 defendant Crowe John husbandman 670896 670896 Crowe, John, of Stutton, husbandman 1
5351467 2460557 2460557 defendant Bordemale Henry yeoman 670896 670896 Bordemale, Henry, of Stutton, yeoman 1
5351487 2460561 2460561 defendant Crowe Nicholas husbandman 670896 670896 together with Crowe, Nicholas, of Stutton, husbandman 1
5351488 2460561 2460561 defendant Crowe John husbandman 670896 670896 Crowe, John, of Stutton, husbandman 2
5375824 2468032 2468032 defendant Hungolde Robert husbandman 670896 670896 Hungolde, Robert, of Stutton, husbandman 1
5506964 2507094 2507094 defendant Mather William yeoman 670896 670896 Mather, William, of Stutton, yeoman 1
5541119 2517343 2517343 defendant Pynnot Richard husbandman 670896 670896 Pynnot, Richard, of Stutton, husbandman 0
5561379 2523305 2523305 defendant Bretan William husbandman 670896 670896 Bretan, William, of Stutton, husbandman 1
5568134 2525228 2525228 defendant Mason Ralph husbandman 670896 670896 Mason, Ralph, of Stutton, husbandman 2
5592057 2532508 2532508 defendant Jakson Henry miller 670896 670896 Jakson, Henry, of Stutton, miller 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);