names

28 rows where place_id = 605666

✎ 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
3662508 1914190 1914190 defendant Gardyner John gent 605666 605666 Gardyner, John, of Great Missenden, gent 0
3662509 1914190 1914190 defendant Ratclyff John fuller 605666 605666 Ratclyff, John, of Great Missenden, fuller 1
3667618 1915815 1915815 defendant Andlowe John husbandman 605666 605666 Andlowe, John, of Great Missenden, husbandman 2
4443066 2182793 2182793 defendant Smyth John   605666 605666 Smyth, John, of Great Missenden 0
4471970 2191900 2191900 defendant Taillour Richard   605666 605666 Taillour, Richard, of Great Missenden 0
4542348 2213498 2213498 defendant atte Hill William   605666 605666 atte Hill, William, of Great Missenden 1
4574050 2223407 2223407 defendant White Richard   605666 605666 White, Richard, of Great Missenden 0
4584889 2226705 2226705 defendant Waryner John   605666 605666 Waryner, John, of Great Missenden 2
4620210 2237301 2237301 defendant Gardener Simon   605666 605666 Gardener, Simon, of Great Missenden 0
4676743 2258347 2258347 defendant Belyng John husbandman 605666 605666 Belyng, John, of Great Missenden, husbandman 2
4677314 2258524 2258524 defendant Longe John husbandman 605666 605666 Longe, John, of Great Missenden, husbandman 0
4700814 2265653 2265653 defendant Belyng John husbandman 605666 605666 Belyng, John, of Great Missenden, husbandman 0
4764024 2284735 2284735 defendant Cryklade John yeoman 605666 605666 Cryklade, John, of Great Missenden, yeoman 0
4908902 2329331 2329331 defendant Amyot John butcher 605666 605666 Amyot, John, of Great Missenden, butcher 1
5183374 2410877 2410877 defendant Claydon Peter husbandman 605666 605666 Claydon, Peter, of Great Missenden, husbandman 0
5183375 2410877 2410877 defendant Dey John laborer 605666 605666 Dey, John, of Great Missenden, laborer 1
5191718 2413315 2413315 defendant Tyler John laborer 605666 605666 Tyler, John, of Great Missenden, laborer 0
5203860 2416880 2416880 defendant Claydon Peter husbandman 605666 605666 Claydon, Peter, of Great Missenden, husbandman 0
5203861 2416880 2416880 defendant Dey John laborer 605666 605666 Dey, John, of Great Missenden, laborer 1
5274741 2437690 2437690 plaintiff Risborough Robert   605666 605666 Risborough, Robert, of Great Missenden, abbot 0
5274749 2437691 2437691 plaintiff Risborough Robert   605666 605666 Risborough, Robert, of Great Missenden, abbot of the monastery of the BM, by divine permission 0
5274750 2437691 2437691 defendant Amyott John butcher 605666 605666 Amyott, John, of Great Missenden, butcher 0
5303095 2445916 2445916 plaintiff Gery Henry (legal representative) 605666 605666 Gery, Henry, of Great Missenden, executors of 0
5304379 2446308 2446308 defendant Bernard Thomas husbandman 605666 605666 Bernard, Thomas, of Great Missenden, husbandman 0
5378624 2468897 2468897 defendant Colet John husbandman 605666 605666 Colet, John, of Great Missenden, husbandman 1
5421516 2481367 2481367 defendant Bonyngton William husbandman 605666 605666 Bonyngton, William, of Great Missenden, husbandman 1
5433842 2485091 2485091 defendant Bodnyngton William husbandman 605666 605666 Bodnyngton, William, of Great Missenden, husbandman 1
5471116 2496300 2496300 defendant Rysborgh Robert (legal representative) 605666 605666 Rysborgh, Robert, of Great Missenden, abbot of the monastery of the BM & of London, executors of 4

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