names

48 rows where place_id = 592427

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607666 1870052 1870052 defendant Amy Richard husbandman 592427 592427 Amy, Richard, of Kerbrook, husbandman 0
4506748 2202581 2202581 defendant Humfrey John   592427 592427 Humfrey, John, of Kerbrook 1
4630217 2240361 2240361 defendant Doleyn John   592427 592427 Doleyn, John, of Kerbrook 0
4659480 2248824 2248824 defendant Smyth John smith 592427 592427 Smyth, John, of Kerbrook, smith 3
4661610 2249467 2249467 defendant Saunsaille John butcher 592427 592427 Saunsaille, John, of Kerbrook, butcher 2
4684328 2260704 2260704 defendant Bedford Bartholomew carpenter 592427 592427 Bedford, Bartholomew, of Kerbrook, carpenter 0
4684329 2260704 2260704 defendant Just Robert husbandman 592427 592427 Just, Robert, of Kerbrook, husbandman 1
4802302 2296909 2296909 defendant Bougoum John   592427 592427 Bougoum, John, of Kerbrook, shepherd 0
4802303 2296909 2296909 defendant Bryxworth John husbandman 592427 592427 Bryxworth, John, of Kerbrook, husbandman 1
4832755 2306268 2306268 defendant Langstrot William   592427 592427 Langstrot, William, of Kerbrook, knight 0
4902495 2327395 2327395 defendant Spaldyng Geoffrey yeoman 592427 592427 Spaldyng, Geoffrey, of Kerbrook, yeoman 2
4919683 2332663 2332663 plaintiff Holderness John   592427 592427 Holderness, John, of Kerbrook 0
5011903 2360333 2360333 defendant Boteler Roger thatcher 592427 592427 Boteler, Roger, of Kerbrook, thatcher 1
5050428 2371753 2371753 plaintiff Toftes Robert   592427 592427 Toftes, Robert, of Kerbrook 0
5114458 2390627 2390627 plaintiff Saunder Thomas   592427 592427 Saunder, Thomas, of Kerbrook 1
5117711 2391617 2391617 defendant Holdernes John (legal representative) 592427 592427 Holdernes, John, of Kerbrook, gent, executors of 0
5117713 2391617 2391617 defendant Conyers Thomas esq 592427 592427 Conyers, Thomas, of Kerbrook, esq 2
5117715 2391617 2391617 defendant Rodeland Alexander chaplain 592427 592427 Rodeland, Alexander, of Kerbrook, chaplain 4
5117718 2391618 2391618 defendant Holdernes John (legal representative) 592427 592427 Holdernes, John, of Kerbrook, gent, executors of 0
5117720 2391618 2391618 defendant Conyers Thomas esq 592427 592427 Conyers, Thomas, of Kerbrook, esq 2
5117722 2391618 2391618 defendant Rodeland Alexander chaplain 592427 592427 Rodeland, Alexander, of Kerbrook, chaplain 4
5117725 2391619 2391619 defendant Holdernes John (legal representative) 592427 592427 Holdernes, John, of Kerbrook, gent, executors of 0
5117727 2391619 2391619 defendant Conyers Thomas esq 592427 592427 Conyers, Thomas, of Kerbrook, esq 2
5117729 2391619 2391619 defendant Rodeland Alexander chaplain 592427 592427 Rodeland, Alexander, of Kerbrook, chaplain 4
5117732 2391620 2391620 defendant Holdernes John (legal representative) 592427 592427 Holdernes, John, of Kerbrook, gent, executors of 0
5117734 2391620 2391620 defendant Conyers Thomas esq 592427 592427 Conyers, Thomas, of Kerbrook, esq 2
5117736 2391620 2391620 defendant Rodeland Alexander chaplain 592427 592427 Rodeland, Alexander, of Kerbrook, chaplain 4
5132959 2396133 2396133 plaintiff Holdirnes John (legal representative) 592427 592427 Holdirnes, John, of Kerbrook, executors of 0
5135056 2396750 2396750 plaintiff Saunder Thomas   592427 592427 Saunder, Thomas, of Kerbrook 1
5152763 2401951 2401951 plaintiff Holdirness John (legal representative) 592427 592427 Holdirness, John, of Kerbrook, executors of 0
5163269 2404989 2404989 plaintiff Saunder Thomas   592427 592427 Saunder, Thomas, of Kerbrook 1
5167411 2406203 2406203 defendant Gryce John laborer 592427 592427 Gryce, John, of Kerbrook, laborer 0
5217105 2420742 2420742 defendant Corpsty Thomas husbandman 592427 592427 Corpsty, Thomas, of Kerbrook, husbandman 3
5259329 2433038 2433038 plaintiff Holdernes John (legal representative) 592427 592427 Holdernes, John, of Kerbrook, executors of 0
5297243 2444189 2444189 defendant Saundres Thomas carpenter 592427 592427 Saundres, Thomas, of Kerbrook, carpenter 1
5346738 2459136 2459136 defendant Wennelok Richard yeoman 592427 592427 Wennelok, Richard, of Kerbrook, yeoman 3
5389158 2471950 2471950 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5395133 2473675 2473675 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5401869 2475600 2475600 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 4
5414803 2479364 2479364 defendant Pycher Robert yeoman 592427 592427 Pycher, Robert, of Kerbrook, yeoman 3
5439436 2486729 2486729 defendant Bowgeon John husbandman 592427 592427 Bowgeon, John, of Kerbrook, husbandman 0
5439437 2486729 2486729 defendant Scotte Thomas husbandman 592427 592427 Scotte, Thomas, of Kerbrook, husbandman 1
5439439 2486730 2486730 defendant Saundres John husbandman 592427 592427 Saundres, John, of Kerbrook, husbandman 0
5481243 2499337 2499337 defendant Bowgeon John husbandman 592427 592427 Bowgeon, John, of Kerbrook, husbandman 0
5481244 2499337 2499337 defendant Scotte Thomas husbandman 592427 592427 Scotte, Thomas, of Kerbrook, husbandman 1
5481245 2499337 2499337 defendant Saundres John husbandman 592427 592427 Saundres, John, of Kerbrook, husbandman 2
5514952 2509516 2509516 plaintiff Rysle John, senior esq 592427 592427 Rysle, John, senior, of Kerbrook, esq 1
5631128 2553743 2553743 defendant atte Spens Richard   592427 592427 atte Spens, Richard, of Kerbrook, wheelwright 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);