names

17 rows where place_id = 759138

✎ 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
4459446 2188005 2188005 defendant del Grene Edmund   759138 759138 del Grene, Edmund, of Craven 3
4459868 2188142 2188142 defendant Pudsey Henry de   759138 759138 Pudsey, Henry de, of Craven 0
4469640 2191170 2191170 defendant Idreston John de   759138 759138 Idreston, John de, of Craven 1
4474243 2192596 2192596 defendant Ferraunt John   759138 759138 Ferraunt, John, of Craven 1
4507750 2202882 2202882 defendant Horton Nicholas   759138 759138 Horton, Nicholas, of Craven 0
4518585 2206184 2206184 defendant del Holden Thomas   759138 759138 del Holden, Thomas, of Craven 1
4595750 2229924 2229924 defendant Laukeland Henry   759138 759138 Laukeland, Henry, of Craven 0
4616193 2236065 2236065 defendant Sergeauntson Thomas   759138 759138 Sergeauntson, Thomas, of Craven 0
4616195 2236066 2236066 defendant Sergeauntson Thomas   759138 759138 Sergeauntson, Thomas, of Craven 0
4623618 2238367 2238367 defendant Mallom William   759138 759138 Mallom, William, of Craven 1
4645044 2244621 2244621 defendant Mallom William   759138 759138 Mallom, William, of Craven 3
4781044 2290080 2290080 defendant Dawetre Gilbert (legal representative) 759138 759138 Dawetre, Gilbert, of Craven, gent, executors of 0
4825669 2304068 2304068 defendant Pacok John carpenter 759138 759138 Pacok, John, of Craven, carpenter 0
5076335 2379425 2379425 plaintiff Banastre Richard esq 759138 759138 Banastre, Richard, of Craven, or of Brokden, esq 0
5076338 2379426 2379426 plaintiff Banastre Richard esq 759138 759138 Banastre, Richard, of Craven, or of Brokden, esq 0
5387164 2471398 2471398 defendant Gawetre Richard husbandman 759138 759138 Gawetre, Richard, of Craven, husbandman 1
5387165 2471398 2471398 defendant Marshall Robert husbandman 759138 759138 Marshall, Robert, of Craven, husbandman 2

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