names

20 rows where place_id = 601192

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644279 1908637 1908637 defendant Frauncys John fisher 601192 601192 Frauncys, John, of St Keveren, fisher 0
3794342 1956107 1956107 defendant Josse William husbandman 601192 601192 Josse, William, of St Keveren, husbandman 1
3794343 1956107 1956107 defendant German Richard husbandman 601192 601192 German, Richard, of St Keveren, husbandman 2
3794344 1956107 1956107 defendant Rychard Reginald husbandman 601192 601192 Rychard, Reginald, of St Keveren, husbandman 3
3794345 1956107 1956107 defendant Vyncent Robert husbandman 601192 601192 Vyncent, Robert, of St Keveren, husbandman 4
4147071 2077119 2077119 defendant Trelyn John gent 601192 601192 Trelyn, John, of St Keveren, gent 0
4160719 2081826 2081826 defendant James Thomas husbandman 601192 601192 James, Thomas, of St Keveren, husbandman 0
4171235 2085401 2085401 defendant Williams John yeoman 601192 601192 Williams, John, of St Keveren, yeoman 0
4172092 2085701 2085701 defendant Trelyn William gent 601192 601192 Trelyn, William, of St Keveren, gent 2
4172093 2085701 2085701 defendant Trelyn John gent 601192 601192 Trelyn, John, of St Keveren, gent 3
4311803 2134265 2134265 defendant Mathewe John husbandman 601192 601192 Mathewe, John, of St Keveren, husbandman 0
4362679 2151711 2151711 defendant Vose John yeoman 601192 601192 Vose, John, of St Keveren, yeoman 0
4368394 2153741 2153741 defendant Langford John gent 601192 601192 Langford, John, of St Keveren, gent 1
4368395 2153741 2153741 defendant Vose John yeoman 601192 601192 Vose, John, of St Keveren, yeoman 2
4984437 2352278 2352278 defendant Rawlyn Thomas chaplain 601192 601192 Rawlyn, Thomas, of St Keveren, chaplain 0
4996245 2355733 2355733 defendant Edward Ralph husbandman 601192 601192 Edward, Ralph, of St Keveren, husbandman 1
4996246 2355733 2355733 defendant Bray Reginald yeoman 601192 601192 Bray, Reginald, of St Keveren, yeoman 2
5011999 2360358 2360358 defendant Tremoth Gilbert husbandman 601192 601192 Tremoth, Gilbert, of St Keveren, husbandman 1
5061125 2374904 2374904 defendant Chyvals or Chynals Ralph fisher 601192 601192 Chyvals or Chynals, Ralph, of St Keveren, fisher 0
5517213 2510218 2510218 defendant Botryaux Reginald tailor 601192 601192 Botryaux, Reginald, of St Keveren, tailor 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);