names

37 rows where place_id = 633800

✎ 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
3814862 1962564 1962564 defendant Skelton William butcher 633800 633800 Skelton, William, of Hovyngham, butcher 0
4028280 2034767 2034767 defendant Rede William husbandman 633800 633800 Rede, William, of Hovyngham, husbandman 0
4028281 2034767 2034767 defendant Barehead Thomas husbandman 633800 633800 Barehead, Thomas, of Hovyngham, husbandman 1
4468257 2190743 2190743 defendant Forster John   633800 633800 Forster, John, of Hovyngham 1
4504020 2201810 2201810 defendant Harum John   633800 633800 Harum, John, of Hovyngham 4
4621030 2237562 2237562 defendant Whyppe John   633800 633800 Whyppe, John, of Hovyngham 0
4621031 2237562 2237562 defendant Balcok Robert   633800 633800 Balcok, Robert, of Hovyngham 1
4646991 2245182 2245182 plaintiff Rous Eustace   633800 633800 Rous, Eustace, of Hovyngham 0
4696535 2264392 2264392 defendant Creyke John yeoman 633800 633800 Creyke, John, of Hovyngham, yeoman 2
4699318 2265250 2265250 defendant Rous Eustace husbandman 633800 633800 Rous, Eustace, of Hovyngham, husbandman 0
4699330 2265255 2265255 defendant Rous Eustace husbandman 633800 633800 Rous, Eustace, of Hovyngham, husbandman 0
4699360 2265262 2265262 defendant Pesgot Hugh husbandman 633800 633800 Pesgot, Hugh, of Hovyngham, husbandman 2
4699426 2265279 2265279 defendant Qwyrle John husbandman 633800 633800 Qwyrle, John, of Hovyngham, husbandman 2
4700364 2265529 2265529 defendant Rows Eustace   633800 633800 Rows, Eustace, of Hovyngham, franklin 0
4700373 2265531 2265531 defendant Crook John husbandman 633800 633800 Crook, John, of Hovyngham, husbandman 4
4700376 2265532 2265532 defendant Chapman William butcher 633800 633800 Chapman, William, of Hovyngham, butcher 1
4700378 2265532 2265532 defendant Elwy Geoffrey smith 633800 633800 Elwy, Geoffrey, of Hovyngham, smith 3
4700379 2265532 2265532 defendant Whirle John carpenter 633800 633800 Whirle, John, of Hovyngham, carpenter 4
4705996 2267250 2267250 defendant Rous Eustace husbandman 633800 633800 Rous, Eustace, of Hovyngham, husbandman 0
4708495 2268025 2268025 defendant Rous Eustace   633800 633800 Rous, Eustace, of Hovyngham, franklin 0
4714044 2269721 2269721 defendant Tylman Robert husbandman 633800 633800 Tylman, Robert, of Hovyngham, husbandman 0
4754992 2281945 2281945 defendant Clerk Richard husbandman 633800 633800 Clerk, Richard, of Hovyngham, husbandman 0
4756676 2282453 2282453 defendant Rous Eustace   633800 633800 Rous, Eustace, of Hovyngham, franklin 0
4762550 2284268 2284268 defendant Rous Eustace husbandman 633800 633800 Rous, Eustace, of Hovyngham, husbandman 0
4762762 2284336 2284336 defendant Hoton Alice de widow 633800 633800 Hoton, Alice de, of Hovyngham, widow 0
4806473 2298235 2298235 defendant Tilman Robert yeoman 633800 633800 Tilman, Robert, of Hovyngham, yeoman 0
4847338 2310671 2310671 defendant Cotus John gent 633800 633800 Cotus, John, of Hovyngham, gent 0
4986723 2352964 2352964 defendant Baroweby John gent 633800 633800 Baroweby, John, of Hovyngham, gent 0
5002352 2357595 2357595 defendant Growt John yeoman 633800 633800 Growt, John, of Hovyngham, yeoman 1
5047065 2370746 2370746 defendant Inwell John husbandman 633800 633800 Inwell, John, of Hovyngham, husbandman 1
5161904 2404590 2404590 defendant Norman John esq 633800 633800 Norman, John, of Hovyngham, esq 0
5428697 2483498 2483498 defendant Freman John yeoman 633800 633800 Freman, John, of Hovyngham, yeoman 2
5428705 2483499 2483499 defendant Freman John yeoman 633800 633800 Freman, John, of Hovyngham, yeoman 2
5431551 2484391 2484391 defendant Doget William gent 633800 633800 Doget, William, of Hovyngham, gent 1
5472775 2496823 2496823 defendant Graunt John husbandman 633800 633800 Graunt, John, of Hovyngham, husbandman 1
5624649 2551650 2551650 defendant de Hoton William esq 633800 633800 de Hoton, William, of Hovyngham, esq 0
5624650 2551650 2551650 defendant Hulyn Gilbert husbandman 633800 633800 Hulyn, Gilbert, of Hovyngham, husbandman 1

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);