names

41 rows where place_id = 595797

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621943 1874407 1874407 defendant Pauncefote Eleanor widow 595797 595797 Pauncefote, Eleanor, of Hasfeld, widow 0
3621945 1874408 1874408 defendant Pauncefote Eleanor widow 595797 595797 Pauncefote, Eleanor, of Hasfeld, widow 0
3621946 1874408 1874408 defendant Heley William, senior yeoman 595797 595797 Heley, William, senior, of Hasfeld, yeoman 1
3621947 1874408 1874408 defendant Chamberleyn John husbandman 595797 595797 Chamberleyn, John, of Hasfeld, husbandman 2
3621948 1874408 1874408 defendant Michell John husbandman 595797 595797 Michell, John, of Hasfeld, husbandman 3
3621949 1874408 1874408 defendant Staunton Thomas husbandman 595797 595797 Staunton, Thomas, of Hasfeld, husbandman 4
3886876 1985871 1985871 defendant Partryge John husbandman 595797 595797 Partryge, John, of Hasfeld, husbandman 0
3898833 1989813 1989813 defendant Pauncefote Grombald yeoman 595797 595797 Pauncefote, Grombald, of Hasfeld, yeoman 0
3925183 1998733 1998733 defendant Jones Morgan gent 595797 595797 Jones, Morgan, of Hasfeld, gent 1
4463551 2189294 2189294 defendant Hayward John   595797 595797 Hayward, John, of Hasfeld 0
4520120 2206626 2206626 defendant Underhulle Richard   595797 595797 Underhulle, Richard, of Hasfeld 0
4668457 2255846 2255846 defendant Gryme William, junior yeoman 595797 595797 Gryme, William, junior, of Hasfeld, yeoman 3
4692006 2263036 2263036 defendant Wygmore William ploughman 595797 595797 Wygmore, William, of Hasfeld, ploughman 0
4720517 2271755 2271755 defendant Stocke John husbandman 595797 595797 Stocke, John, of Hasfeld, husbandman 0
4868872 2317240 2317240 plaintiff Kenyat Nicholas   595797 595797 Kenyat, Nicholas, of Hasfeld 0
4898023 2326051 2326051 defendant Pauncefot John   595797 595797 Pauncefot, John, of Hasfeld, knight 0
4898026 2326052 2326052 defendant Kynyet Nicholas yeoman 595797 595797 Kynyet, Nicholas, of Hasfeld, yeoman 0
4898027 2326052 2326052 defendant Birche Thomas husbandman 595797 595797 Birche, Thomas, of Hasfeld, husbandman 1
4898028 2326052 2326052 defendant Freman John husbandman 595797 595797 Freman, John, of Hasfeld, husbandman 2
4898029 2326052 2326052 defendant Rastell Thomas husbandman 595797 595797 Rastell, Thomas, of Hasfeld, husbandman 3
4898030 2326052 2326052 defendant Eliot Thomas, senior husbandman 595797 595797 Eliot, Thomas, senior, of Hasfeld, husbandman 4
4898031 2326052 2326052 defendant Geffys John husbandman 595797 595797 Geffys, John, of Hasfeld, husbandman 5
4898032 2326052 2326052 defendant Geffys Thomas husbandman 595797 595797 Geffys, Thomas, of Hasfeld, husbandman 6
4898033 2326052 2326052 defendant Kent Thomas tailor 595797 595797 Kent, Thomas, of Hasfeld, tailor 7
4898034 2326052 2326052 defendant Underhull Thomas husbandman 595797 595797 Underhull, Thomas, of Hasfeld, husbandman 8
4898035 2326052 2326052 defendant Wygmore John husbandman 595797 595797 Wygmore, John, of Hasfeld, husbandman 9
4898036 2326052 2326052 defendant Cokshete John, senior husbandman 595797 595797 Cokshete, John, senior, of Hasfeld, husbandman 10
5019657 2362635 2362635 defendant Pauncefote Hugh esq 595797 595797 together with Pauncefote, Hugh, of Hasfeld, esq 6
5019658 2362635 2362635 defendant Elyot Richard husbandman 595797 595797 Elyot, Richard, of Hasfeld, husbandman 7
5019659 2362635 2362635 defendant Gryme Richard laborer 595797 595797 Gryme, Richard, of Hasfeld, laborer 8
5019660 2362635 2362635 defendant York John husbandman 595797 595797 York, John, of Hasfeld, husbandman 9
5019661 2362635 2362635 defendant Ferley Thomas yeoman 595797 595797 Ferley, Thomas, of Hasfeld, yeoman 10
5019662 2362635 2362635 defendant Birche Thomas yeoman 595797 595797 Birche, Thomas, of Hasfeld, yeoman 11
5030076 2365668 2365668 defendant Frogmerton John gent 595797 595797 Frogmerton, John, of Hasfeld, gent 0
5035102 2367129 2367129 defendant Pauncefote Thomas esq 595797 595797 Pauncefote, Thomas, of Hasfeld, esq 0
5035111 2367131 2367131 defendant Pauncefote Thomas esq 595797 595797 Pauncefote, Thomas, of Hasfeld, esq 0
5223100 2422466 2422466 defendant Pauncesfote Thomas esq 595797 595797 Pauncesfote, Thomas, of Hasfeld, esq 0
5237214 2426468 2426468 defendant Elyott Richard husbandman 595797 595797 Elyott, Richard, of Hasfeld, husbandman 2
5244046 2428447 2428447 defendant Monyngton George gent 595797 595797 Monyngton, George, of Hasfeld, gent 1
5247522 2429428 2429428 defendant Pauncefote Thomas esq 595797 595797 Pauncefote, Thomas, of Hasfeld, esq 0
5362406 2463897 2463897 defendant Chamberleyn John husbandman 595797 595797 Chamberleyn, John, of Hasfeld, husbandman 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);