names

42 rows where place_id = 591770

✎ 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
3605521 1869392 1869392 defendant Brayn John miller 591770 591770 Brayn, John, of Stapulton, miller 0
3617897 1873220 1873220 defendant Porter Thomas husbandman 591770 591770 Porter, Thomas, of Stapulton, husbandman 4
3772143 1948979 1948979 defendant Nychols Richard husbandman 591770 591770 Nychols, Richard, of Stapulton, husbandman 0
3875424 1982026 1982026 defendant Adams Thomas husbandman 591770 591770 Adams, Thomas, of Stapulton, husbandman 2
3885937 1985550 1985550 defendant Erwyth William husbandman 591770 591770 Erwyth, William, of Stapulton, husbandman 4
3954534 2008656 2008656 defendant Vicars alias Raynold John husbandman 591770 591770 Vicars alias Raynold, John, of Stapulton, husbandman 0
3984551 2019232 2019232 defendant Gawyn Richard husbandman 591770 591770 Gawyn, Richard, of Stapulton, husbandman 0
3984552 2019232 2019232 defendant Gawyn Margery widow 591770 591770 Gawyn, Margery, of Stapulton, widow 1
3995794 2023245 2023245 plaintiff Crumpton William   591770 591770 Crumpton, William, of Stapulton 0
4036821 2037854 2037854 defendant Pagett Thomas yeoman 591770 591770 Pagett, Thomas, of Stapulton, yeoman 1
4613704 2235298 2235298 defendant Aas Robert   591770 591770 Aas, Robert, of Stapulton 0
4628831 2239947 2239947 defendant Moton Alan   591770 591770 Moton, Alan, of Stapulton 0
4717019 2270652 2270652 defendant Nycoll Thomas husbandman 591770 591770 Nycoll, Thomas, of Stapulton, husbandman 0
4727560 2273860 2273860 defendant White William yeoman 591770 591770 White, William, of Stapulton, yeoman 0
4733566 2275675 2275675 defendant Moton Alan gent 591770 591770 Moton, Alan, of Stapulton, gent 0
4733568 2275676 2275676 defendant Moton Thomas gent 591770 591770 Moton, Thomas, of Stapulton, gent 0
4733570 2275676 2275676 defendant Bullok William laborer 591770 591770 Bullok, William, of Stapulton, laborer 2
4743095 2278502 2278502 defendant Smert John husbandman 591770 591770 Smert, John, of Stapulton, husbandman 0
4743096 2278502 2278502 defendant Wroxhale William husbandman 591770 591770 Wroxhale, William, of Stapulton, husbandman 1
4743098 2278503 2278503 defendant Smert John husbandman 591770 591770 Smert, John, of Stapulton, husbandman 0
4743099 2278503 2278503 defendant Wroxhale William husbandman 591770 591770 Wroxhale, William, of Stapulton, husbandman 1
4745549 2279209 2279209 defendant Raunsclyve Stephen husbandman 591770 591770 Raunsclyve, Stephen, of Stapulton, husbandman 0
4758119 2282913 2282913 defendant Baxsterley John husbandman 591770 591770 Baxsterley, John, of Stapulton, husbandman 1
4771522 2287075 2287075 defendant Marres Robert husbandman 591770 591770 Marres, Robert, of Stapulton, husbandman 3
4771523 2287075 2287075 defendant Bollosovyr Giles husbandman 591770 591770 Bollosovyr, Giles, of Stapulton, husbandman 4
4795457 2294731 2294731 defendant Huet John baker 591770 591770 Huet, John, of Stapulton, baker 2
4795458 2294731 2294731 defendant Cule Robert esq 591770 591770 Cule, Robert, of Stapulton, husbandman, mainpernors for Moton, Alan, of Stapulton, esq 3
4796581 2295083 2295083 defendant Marres Robert husbandman 591770 591770 Marres, Robert, of Stapulton, husbandman 3
4796582 2295083 2295083 defendant Bollesovyr Giles husbandman 591770 591770 Bollesovyr, Giles, of Stapulton, husbandman 4
4853757 2312588 2312588 defendant Dogeon Thomas husbandman 591770 591770 Dogeon, Thomas, of Stapulton, husbandman 1
4975244 2349550 2349550 plaintiff Moton Alan esq 591770 591770 Moton, Alan, of Stapulton, esq 0
4976217 2349839 2349839 defendant Lynyng or Lyvyng John, senior husbandman 591770 591770 Lynyng or Lyvyng, John, senior, of Stapulton, husbandman 0
5014628 2361144 2361144 defendant Dod John laborer 591770 591770 Dod, John, of Stapulton, laborer 1
5014629 2361144 2361144 defendant atte Wode Henry   591770 591770 atte Wode, Henry, of Stapulton, millward 2
5027668 2364970 2364970 defendant Olege Thomas (legal representative) 591770 591770 Olege, Thomas, of Stapulton, yeoman, executors of 0
5050604 2371807 2371807 defendant Culver Thomas husbandman 591770 591770 Culver, Thomas, of Stapulton, husbandman 1
5057196 2373729 2373729 defendant Brit Thomas yeoman 591770 591770 Brit, Thomas, of Stapulton, yeoman 2
5058950 2374242 2374242 defendant atte Hill Isabel widow 591770 591770 atte Hill, Isabel, of Stapulton, widow 4
5119550 2392148 2392148 defendant Lyde William husbandman 591770 591770 Lyde, William,of Stapulton, husbandman 1
5484233 2500209 2500209 defendant Mores William husbandman 591770 591770 Mores, William, of Stapulton, husbandman 0
5523735 2512249 2512249 defendant Porter Thomas husbandman 591770 591770 Porter, Thomas, of Stapulton, husbandman 2
5635998 2555214 2555214 defendant Bryt John husbandman 591770 591770 Bryt, John, of Stapulton, 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);