names

66 rows where place_id = 635177

✎ 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
3685703 1921687 1921687 defendant Chamberleyn Edward   635177 635177 Chamberleyn, Edward, of Wodestoke, knight 0
3729649 1935524 1935524 defendant Chamberleyn Edward   635177 635177 Chamberleyn, Edward, of Wodestoke, knight 0
3823683 1965305 1965305 defendant Chamberleyn Edward   635177 635177 Chamberleyn, Edward, of Wodestoke, knight 0
3823684 1965305 1965305 defendant Fulshurst Ralph esq 635177 635177 Fulshurst, Ralph, of Wodestoke, esq 1
3823686 1965305 1965305 defendant Chamberleyn John gent 635177 635177 Chamberleyn, John, of Wodestoke, gent 3
3823690 1965306 1965306 defendant Fulhurst Ralph esq 635177 635177 Fulhurst, Ralph, of Wodestoke, esq 1
3823692 1965306 1965306 defendant Chamberleyn John gent 635177 635177 Chamberleyn, John, of Wodestoke, gent 3
4441036 2182121 2182121 plaintiff Blecchyngle John   635177 635177 Blecchyngle, John, of Wodestoke 0
4441038 2182121 2182121 defendant Marrshall Robert clerk 635177 635177 Marrshall, Robert, of Wodestoke, clerk 1
4443291 2182863 2182863 defendant Fysshere Richard   635177 635177 Fysshere, Richard, of Wodestoke 0
4485055 2196024 2196024 defendant Wythges William   635177 635177 Wythges, William, of Wodestoke 1
4494236 2198889 2198889 plaintiff Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke, on his own account 0
4494987 2199120 2199120 defendant Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 1
4511883 2204165 2204165 plaintiff Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 0
4512982 2204495 2204495 defendant Yle John   635177 635177 Yle, John, of Wodestoke 0
4513726 2204722 2204722 defendant Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 0
4528427 2209169 2209169 defendant Barbour John   635177 635177 Barbour, John, of Wodestoke 1
4534708 2211130 2211130 defendant Harry John chapman 635177 635177 Harry, John, of Wodestoke, chapman 0
4559448 2218902 2218902 defendant Cardemaker John   635177 635177 Cardemaker, John, of Wodestoke 0
4559450 2218903 2218903 defendant Cardemaker John   635177 635177 Cardemaker, John, of Wodestoke 0
4599117 2230938 2230938 defendant Bother Richard   635177 635177 Bother, Richard, of Wodestoke 0
4599118 2230938 2230938 defendant Shepherd William   635177 635177 Shepherd, William, of Wodestoke 1
4606415 2233121 2233121 defendant Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 1
4607917 2233596 2233596 plaintiff Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 0
4607919 2233597 2233597 plaintiff Bocher Richard   635177 635177 Bocher, Richard, of Wodestoke 0
4625336 2238889 2238889 defendant Erdelee Richard   635177 635177 Erdelee, Richard, of Wodestoke 2
4631228 2240665 2240665 defendant Erdelee Richard   635177 635177 Erdelee, Richard, of Wodestoke 1
4663745 2250148 2250148 defendant Tywe John chapman 635177 635177 Tywe, John, of Wodestoke, chapman 0
4663746 2250148 2250148 defendant Bedell Thomas husbandman 635177 635177 Bedell, Thomas, of Wodestoke, husbandman 1
4663748 2250148 2250148 defendant Sybbeford John   635177 635177 Sybbeford, John, of Wodestoke, friary clerk 3
4669889 2256279 2256279 plaintiff Bramptone Thomas   635177 635177 Bramptone, Thomas, of Wodestoke 0
4686699 2261452 2261452 defendant Tayllour Richard   635177 635177 Tayllour, Richard, of Wodestoke, millward 0
4725716 2273331 2273331 defendant Skynner Thomas skinner 635177 635177 Skynner, Thomas, of Wodestoke, skinner 0
4730047 2274599 2274599 defendant Cok John   635177 635177 Cok, John, of Wodestoke, card maker 0
4730050 2274600 2274600 defendant Cok John   635177 635177 Cok, John, of Wodestoke, card maker 0
4757003 2282561 2282561 plaintiff Bocher Thomas   635177 635177 Bocher, Thomas, of Wodestoke 0
4802770 2297052 2297052 plaintiff Wellere William   635177 635177 Wellere, William, of Wodestoke 3
4846749 2310492 2310492 defendant Sharp John husbandman 635177 635177 Sharp, John, of Wodestoke, husbandman 0
4846750 2310492 2310492 defendant Brether John husbandman 635177 635177 Brether, John, of Wodestoke, husbandman 1
4846751 2310492 2310492 defendant Roke John butcher 635177 635177 Roke, John, of Wodestoke, butcher 2
4846752 2310492 2310492 defendant Dyer Richard husbandman 635177 635177 Dyer, Richard, of Wodestoke, husbandman 3
4876654 2319669 2319669 plaintiff Wellere William yeoman 635177 635177 Wellere, William, of Wodestoke, yeoman 1
4889841 2323614 2323614 plaintiff Chapman Richard   635177 635177 Chapman, Richard, of Wodestoke 0
4905283 2328246 2328246 defendant Maykyn Thomas mercer 635177 635177 Maykyn, Thomas, of Wodestoke, mercer 0
4914443 2331034 2331034 defendant Mundy William laborer 635177 635177 Mundy, William, of Wodestoke, laborer 3
4940460 2339042 2339042 defendant Faukener William gent 635177 635177 Faukener, William, of Wodestoke, gent 0
4979039 2350689 2350689 plaintiff Savage William (legal representative) 635177 635177 Savage William, of Wodestoke, executors of 0
4979045 2350691 2350691 plaintiff Savage William (legal representative) 635177 635177 Savage, William, of Wodestoke, executors of 0
4980175 2351019 2351019 plaintiff Somerton Simon (legal representative) 635177 635177 Somerton, Simon, of Wodestoke, executors of 0
4980468 2351095 2351095 plaintiff Spyllysby Thomas   635177 635177 Spyllysby, Thomas, of Wodestoke 0
5001186 2357226 2357226 plaintiff Maykyn Thomas   635177 635177 Maykyn, Thomas, of Wodestoke 0
5013989 2360949 2360949 defendant Maykyn Thomas gent 635177 635177 Maykyn, Thomas, of Wodestoke, gent 0
5020036 2362746 2362746 defendant Faukener William gent 635177 635177 Faukener, William, of Wodestoke, gent 0
5020310 2362829 2362829 plaintiff Duffeld Luke   635177 635177 Duffeld, Luke, of Wodestoke 0
5024227 2364000 2364000 defendant Faukener William gent 635177 635177 Faukener, William, of Wodestoke, gent 0
5030652 2365834 2365834 defendant Tewe John summoner 635177 635177 Tewe, John, of Wodestoke, summoner 1
5030653 2365834 2365834 defendant Mondy William husbandman 635177 635177 Mondy, William, of Wodestoke, husbandman 2
5032534 2366399 2366399 plaintiff Savage William (legal representative) 635177 635177 Savage, William, of Wodestoke, executor of Stevenes, Joan, of Wodestoke, widow of Stevenys, Richard, of Wodestoke, executors of 0
5032538 2366399 2366399 defendant Fauconer William gent 635177 635177 Fauconer, William, of Wodestoke, gent 0
5093688 2384552 2384552 defendant Couper Geoffrey yeoman 635177 635177 Couper, Geoffrey, of Wodestoke, yeoman 0
5096106 2385303 2385303 defendant Boolde John gent 635177 635177 Boolde, John, of Wodestoke, gent 0
5096107 2385303 2385303 defendant Rooke Henry yeoman 635177 635177 Rooke, Henry, of Wodestoke, yeoman 1
5100653 2386617 2386617 defendant Gowlys John gent 635177 635177 Gowlys, John, of Wodestoke, gent 0
5360589 2463343 2463343 defendant Austyn Robert mercer 635177 635177 Austyn, Robert, of Wodestoke, mercer 0
5615936 2548782 2548782 plaintiff Harpour John   635177 635177 Harpour, John, of Wodestoke 0
5615939 2548783 2548783 plaintiff Harpour John   635177 635177 Harpour, John, of Wodestoke 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);