names

78 rows where place_id = 597006

✎ 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
3626914 1903270 1903270 defendant Pykeryng Richard husbandman 597006 597006 Pykeryng, Richard, of Assheley, husbandman 0
3626915 1903270 1903270 defendant Aleyn Richard husbandman 597006 597006 Aleyn, Richard, of Assheley, husbandman 1
3626916 1903270 1903270 defendant Barton Richard husbandman 597006 597006 Barton, Richard, of Assheley, husbandman 2
3626917 1903270 1903270 defendant Gervey Richard laborer 597006 597006 Gervey, Richard, of Assheley, laborer 3
3626918 1903270 1903270 defendant Stalworth John sawyer 597006 597006 Stalworth, John, of Assheley,sawyer 4
3631248 1904592 1904592 defendant Parker Thomas   597006 597006 Parker, Thomas, of Assheley 14
3631249 1904592 1904592 defendant Fenmall John   597006 597006 Fenmall, John, of Assheley 15
3631250 1904592 1904592 defendant Smyth Thomas   597006 597006 Smyth, Thomas, of Assheley 16
3631251 1904592 1904592 defendant Almer William   597006 597006 Almer, William, of Assheley 17
3632713 1905049 1905049 defendant Polard William husbandman 597006 597006 Polard, William, of Assheley, husbandman 1
3643883 1908517 1908517 defendant Lancastre Thomas gent 597006 597006 Lancastre, Thomas, of Assheley, gent 0
3736202 1937566 1937566 defendant Brenner Joan widow 597006 597006 Brenner, Joan, of Assheley, widow 0
3736203 1937566 1937566 defendant Brenner Thomas husbandman 597006 597006 Brenner, Thomas, of Assheley, husbandman 1
3760036 1945135 1945135 defendant Yattys alias Pate Thomas husbandman 597006 597006 Yattys alias Pate, Thomas, of Assheley, husbandman 2
3770505 1948457 1948457 defendant Walker Thomas husbandman 597006 597006 Walker, Thomas, of Assheley, husbandman 3
3785618 1953291 1953291 defendant Asshwell William yeoman 597006 597006 Asshwell, William, of Assheley, yeoman 2
3790195 1954752 1954752 defendant Clerk Edmund husbandman 597006 597006 Clerk, Edmund, of Assheley, husbandman 0
3790196 1954752 1954752 defendant Almer Robert husbandman 597006 597006 Almer, Robert, of Assheley, husbandman 1
3802021 1958530 1958530 defendant Lancaster Thomas gent 597006 597006 Lancaster, Thomas, of Assheley, gent 0
3824016 1965389 1965389 plaintiff Walker Thomas yeoman 597006 597006 Walker, Thomas, of Assheley, yeoman 0
3829928 1967253 1967253 defendant Selwyn Robert clothier 597006 597006 Selwyn, Robert, of Assheley, clothier 3
3834800 1968820 1968820 defendant Lancaster Thomas yeoman 597006 597006 Lancaster, Thomas, of Assheley, yeoman 1
3834801 1968820 1968820 defendant Asshewell William yeoman 597006 597006 Asshewell, William, of Assheley, yeoman 2
3851586 1974083 1974083 defendant Lancastre Thomas gent 597006 597006 Lancastre, Thomas, of Assheley, gent 0
3875057 1981887 1981887 defendant Goodale Roger husbandman 597006 597006 Goodale, Roger, of Assheley, husbandman 0
3913203 1994747 1994747 defendant Bannam Robert husbandman 597006 597006 Bannam, Robert, of Assheley, husbandman 1
3956253 2009250 2009250 defendant Mynshawe John weaver 597006 597006 Mynshawe, John, of Assheley, weaver 0
3989602 2021028 2021028 defendant Pitches George husbandman 597006 597006 Pitches, George, of Assheley, husbandman 1
4005887 2026875 2026875 defendant Edmund John husbandman 597006 597006 Edmund, John, of Assheley, husbandman 0
4029708 2035265 2035265 defendant Pitches George husbandman 597006 597006 Pitches, George, of Assheley, husbandman 0
4029709 2035265 2035265 defendant Edmond John husbandman 597006 597006 Edmond, John, of Assheley, husbandman 1
4038237 2038311 2038311 defendant Pytches John husbandman 597006 597006 Pytches, John, of Assheley, husbandman 1
4038240 2038312 2038312 defendant Pytches John husbandman 597006 597006 Pytches, John, of Assheley, husbandman 1
4038245 2038314 2038314 defendant Edmunde John yeoman 597006 597006 Edmunde, John, of Assheley, yeoman 0
4038246 2038314 2038314 defendant Clarke James husbandman 597006 597006 Clarke, James, of Assheley, husbandman 1
4098194 2059682 2059682 defendant Heymes Anne widow 597006 597006 Heymes, Anne, of Assheley, widow 0
4135682 2073088 2073088 defendant Longe Thomas gent 597006 597006 Longe Thomas, of Assheley, gent 0
4188493 2091447 2091447 defendant Heywood Henry yeoman 597006 597006 Heywood, Henry, of Assheley, yeoman 0
4661706 2249501 2249501 defendant Taverner William chaplain 597006 597006 Taverner, William, of Assheley, chaplain 0
4722781 2272441 2272441 defendant Bromley John gent 597006 597006 Bromley, John, of Assheley, gent 0
4722782 2272441 2272441 defendant Pettesey Henry yeoman 597006 597006 Pettesey, Henry, of Assheley, yeoman 1
4722783 2272441 2272441 defendant Hales Robert laborer 597006 597006 Hales, Robert, of Assheley, laborer 2
4722784 2272441 2272441 defendant Shawe Thomas yeoman 597006 597006 Shawe, Thomas, of Assheley, yeoman 3
4745039 2279062 2279062 defendant Drewe Richard husbandman 597006 597006 Drewe, Richard, of Assheley, husbandman 0
4745040 2279062 2279062 defendant Breton Richard   597006 597006 Breton, Richard, of Assheley, servant 1
5106398 2388312 2388312 defendant Bolde John husbandman 597006 597006 Bolde, John, of Assheley, husbandman 0
5106399 2388312 2388312 defendant Courtener John husbandman 597006 597006 Courtener, John, of Assheley, husbandman 1
5106400 2388312 2388312 defendant Broun John husbandman 597006 597006 Broun, John, of Assheley, husbandman 2
5106401 2388312 2388312 defendant Berlyng John husbandman 597006 597006 Berlyng, John, of Assheley, husbandman 3
5106402 2388312 2388312 defendant Bonde William husbandman 597006 597006 Bonde, William, of Assheley, husbandman 4
5118263 2391777 2391777 defendant Bolde John husbandman 597006 597006 together with Bolde, John, of Assheley, husbandman 14
5118264 2391777 2391777 defendant Courtener John husbandman 597006 597006 Courtener, John, of Assheley, husbandman 15
5118265 2391777 2391777 defendant Broune John husbandman 597006 597006 Broune, John, of Assheley, husbandman 16
5118266 2391777 2391777 defendant Berlyng John husbandman 597006 597006 Berlyng, John, of Assheley, husbandman 17
5118267 2391777 2391777 defendant Bonde William husbandman 597006 597006 Bonde, William, of Assheley, husbandman 18
5158386 2403574 2403574 defendant Janyns John yeoman 597006 597006 Janyns, John, of Assheley, yeoman 0
5158389 2403575 2403575 defendant Janyns John   597006 597006 Janyns, John, of Assheley, yeoman, also of Farnham, Surrey 0
5248563 2429705 2429705 defendant Mounteford John   597006 597006 Mounteford, John, of Assheley 0
5336196 2455907 2455907 defendant Betton Isabel widow 597006 597006 Betton, Isabel, of Assheley, widow 0
5336197 2455907 2455907 defendant Betton William husbandman 597006 597006 Betton, William, of Assheley, husbandman 1
5336204 2455910 2455910 defendant Becton William husbandman 597006 597006 Becton, William, of Assheley, husbandman 1
5338801 2456710 2456710 defendant Dodde John husbandman 597006 597006 Dodde, John, of Assheley, husbandman 1
5349067 2459836 2459836 defendant Gravener John husbandman 597006 597006 Gravener, John, of Assheley, husbandman 0
5378902 2468990 2468990 defendant Donyngton alias Dosyngton Thomas husbandman 597006 597006 Donyngton alias Dosyngton, Thomas, of Assheley, husbandman 0
5378904 2468991 2468991 defendant Donyngton Thomas husbandman 597006 597006 Donyngton, Thomas, of Assheley, husbandman 0
5381947 2469893 2469893 defendant Ryngold John tailor 597006 597006 Ryngold, John, of Assheley, tailor 0
5390245 2472274 2472274 defendant Ryngold John tailor 597006 597006 Ryngold, John, of Assheley, tailor 0
5390866 2472453 2472453 defendant Plante Richard yeoman 597006 597006 Plante, Richard, of Assheley, yeoman 0
5397285 2474306 2474306 defendant Boweman John husbandman 597006 597006 Boweman, John, of Assheley, husbandman 1
5410493 2478083 2478083 defendant Boweman John husbandman 597006 597006 Boweman, John, of Assheley, husbandman 1
5460376 2493044 2493044 defendant Morys Edward husbandman 597006 597006 Morys, Edward, of Assheley, husbandman 1
5495407 2503528 2503528 defendant Hales Richard husbandman 597006 597006 Hales, Richard, of Assheley, husbandman 0
5496833 2503980 2503980 defendant Weyborne Robert husbandman 597006 597006 Weyborne, Robert, of Assheley, husbandman 0
5517299 2510248 2510248 defendant Petchy Richard butcher 597006 597006 Petchy, Richard, of Assheley, butcher 2
5552807 2520871 2520871 defendant Smyth Thomas husbandman 597006 597006 Smyth, Thomas, of Assheley, husbandman 0
5565824 2524601 2524601 plaintiff Catesby Elizabeth widow 597006 597006 Catesby, Elizabeth, of Assheley Leger, widow 0
5605856 2536723 2536723 defendant Selwyn William husbandman 597006 597006 Selwyn, William, of Assheley, husbandman 0
5629130 2553084 2553084 plaintiff Pykeryng Henry   597006 597006 Pykeryng, Henry, of Assheley 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);