names

22 rows where place_id = 778015

✎ 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
4512900 2204467 2204467 defendant Bray Hugh   778015 778015 Bray, Hugh, of Hogh, vicar 0
4651515 2246478 2246478 defendant Bradbourne John esq 778015 778015 Bradbourne, John, of Hogh, esq 2
4681073 2259707 2259707 defendant Jacson Thomas yeoman 778015 778015 Jacson, Thomas, of Hogh, yeoman 0
4750304 2280566 2280566 defendant Hough Henry gent 778015 778015 Hough, Henry, of Hogh, gent 0
4770298 2286682 2286682 defendant Hogh Henry gent 778015 778015 Hogh, Henry, of Hogh, gent 0
4795284 2294676 2294676 defendant Halden Lawrence husbandman 778015 778015 Halden, Lawrence, of Hogh, husbandman 1
4795285 2294676 2294676 defendant Halden Giles husbandman 778015 778015 Halden, Giles, of Hogh, husbandman 2
4795287 2294676 2294676 defendant White Robert husbandman 778015 778015 White, Robert, of Hogh, husbandman 4
4843032 2309356 2309356 defendant Fourth John chaplain 778015 778015 Fourth, John, of Hogh, chaplain 5
4851591 2311931 2311931 defendant White Robert husbandman 778015 778015 White, Robert, of Hogh, formerly of Welby, Lincs, husbandman 1
4857841 2313821 2313821 defendant Hogh Henry gent 778015 778015 Hogh, Henry, of Hogh, gent 1
4865777 2316263 2316263 defendant High Henry gent 778015 778015 High, Henry, of Hogh, gent 0
5014100 2360975 2360975 plaintiff Bradborne Henry esq 778015 778015 Bradborne, Henry, of Hogh, esq 1
5014103 2360976 2360976 plaintiff Bradborne Henry esq 778015 778015 Bradborne, Henry, of Hogh, esq 1
5051006 2371912 2371912 defendant and Jakson William   778015 778015 and Jakson, William, of Hogh 6
5076406 2379443 2379443 defendant Payn Richard husbandman 778015 778015 Payn, Richard, of Hogh, husbandman 3
5076407 2379443 2379443 defendant Wode Thomas husbandman 778015 778015 Wode, Thomas, of Hogh, husbandman 4
5205632 2417392 2417392 defendant Jay Thomas husbandman 778015 778015 Jay, Thomas, of Hogh, husbandman 2
5480978 2499265 2499265 defendant Martyn Thomas yeoman 778015 778015 Martyn, Thomas, of Hogh, yeoman 0
5531835 2514501 2514501 defendant Con Thomas husbandman 778015 778015 Con, Thomas, of Hogh, husbandman 0
5542474 2517770 2517770 defendant Bradburne Humphrey esq 778015 778015 Bradburne, Humphrey, of Hogh, esq 0
5614085 2548184 2548184 plaintiff Draycote Petronilla daughter of Philip 778015 778015 Draycote, Petronilla, of Hogh, daughter of Philip 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);