names

37 rows where place_id = 598083

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631035 1904528 1904528 defendant Peny alias Waryng Robert clerk 598083 598083 Peny alias Waryng, Robert, of Ketylston, clerk 0
3710147 1929488 1929488 defendant Delahay William gent 598083 598083 Delahay, William, of Ketylston, gent 0
3807517 1960258 1960258 defendant Dalton William gent 598083 598083 Dalton, William, of Ketylston, gent 0
3807518 1960258 1960258 defendant Dalton Richard cler 598083 598083 Dalton, Richard, of Ketylston, cler 1
3881231 1983990 1983990 defendant Priour Peter husbandman 598083 598083 Priour, Peter, of Ketylston, husbandman 0
3887122 1985957 1985957 defendant Tooke John husbandman 598083 598083 Tooke, John, of Ketylston, husbandman 1
3904481 1991746 1991746 defendant Curson Richard esq 598083 598083 Curson, Richard, of Ketylston, esq 0
4072014 2050288 2050288 defendant Wyltropp Robert husbandman 598083 598083 Wyltropp, Robert, of Ketylston, husbandman 2
4872446 2318345 2318345 defendant Bynham Thomas smith 598083 598083 together with Bynham, Thomas, of Ketylston, smith 7
4952395 2342672 2342672 defendant Baxter Thomas, senior husbandman 598083 598083 Baxter, Thomas, senior, of Ketylston, husbandman 0
5058351 2374043 2374043 plaintiff Curson John esq 598083 598083 Curson,John, of Ketylston, esq 0
5265652 2435009 2435009 defendant Burnell John (legal representative) 598083 598083 Burnell, John, of Ketylston, husbandman, executors of 3
5265654 2435009 2435009 defendant Burnell Henry husbandman 598083 598083 Burnell, Henry, of Ketylston, husbandman 5
5316828 2450120 2450120 defendant Kyrby Nicholas husbandman 598083 598083 Kyrby, Nicholas, of Ketylston, husbandman 0
5326026 2452877 2452877 plaintiff Sparwe Richard   598083 598083 Sparwe, Richard, of Ketylston 0
5340906 2457351 2457351 defendant Burnell Henry yeoman 598083 598083 Burnell, Henry, of Ketylston, yeoman 0
5381636 2469801 2469801 defendant Ty Richard carpenter 598083 598083 Ty, Richard, of Ketylston, carpenter 0
5384775 2470725 2470725 defendant Gowty Thomas husbandman 598083 598083 Gowty, Thomas, of Ketylston, husbandman 20
5396792 2474170 2474170 defendant Gowty Thomas   598083 598083 Gowty, Thomas, of Ketylston 20
5401949 2475615 2475615 defendant Novell William husbandman 598083 598083 Novell, William, of Ketylston, husbandman 1
5410037 2477962 2477962 defendant Gowty Thomas husbandman 598083 598083 Gowty, Thomas, of Ketylston, husbandman 20
5414842 2479373 2479373 defendant Novell William husbandman 598083 598083 Novell, William, of Ketylston, husbandman 1
5430776 2484144 2484144 defendant Novell William husbandman 598083 598083 Novell, William, of Ketylston, husbandman 7
5443866 2488082 2488082 defendant Sparowe Isabel widow 598083 598083 Sparowe, Isabel, of Ketylston, widow 0
5443867 2488082 2488082 defendant Gylberd John laborer 598083 598083 Gylberd, John, of Ketylston, laborer 1
5443868 2488082 2488082 defendant Gilberd Thomas fishmonger 598083 598083 Gilberd, Thomas, of Ketylston, fishmonger 2
5467433 2495197 2495197 defendant Dowty Thomas husbandman 598083 598083 Dowty, Thomas, of Ketylston, husbandman 4
5478704 2498656 2498656 defendant Goughty Thomas laborer 598083 598083 Goughty, Thomas, of Ketylston, laborer 2
5482893 2499826 2499826 defendant Casterton Thomas husbandman 598083 598083 Casterton, Thomas, of Ketylston, husbandman 7
5508942 2507651 2507651 defendant Tye Richard carpenter 598083 598083 Tye, Richard, of Ketylston, carpenter 0
5553089 2520942 2520942 defendant Sparowe Isabel widow 598083 598083 Sparowe, Isabel, of Ketylston, widow 5
5553090 2520942 2520942 defendant Gylberd Thomas husbandman 598083 598083 Gylberd, Thomas, of Ketylston, husbandman 6
5553091 2520942 2520942 defendant Gylberd John husbandman 598083 598083 Gylberd, John, of Ketylston, husbandman 7
5553098 2520943 2520943 defendant Sparowe Isabel widow 598083 598083 Sparowe, Isabel, of Ketylston, widow 5
5553099 2520943 2520943 defendant Gylberd Thomas husbandman 598083 598083 Gylberd, Thomas, of Ketylston, husbandman 6
5553100 2520943 2520943 defendant Gylberd John husbandman 598083 598083 Gylberd, John, of Ketylston, husbandman 7
5559617 2522772 2522772 defendant Dalahay Thomas esq 598083 598083 (Dalahay, Thomas, of Ketylston, esq 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);