names

11 rows where place_id = 626592

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3771069 1948640 1948640 defendant Kyllygrewe John, junior gent 626592 626592 Kyllygrewe, John, junior, of Peryn, Cornw, gent 0
3957658 2009738 2009738 defendant Cowche Ralph, junior gent 626592 626592 Cowche, Ralph, junior, of Peryn, Cornw, gent 1
3978134 2016930 2016930 defendant Kyllygrewe Peter gent 626592 626592 Kyllygrewe, Peter, of Peryn, Cornw, gent 0
4018042 2031170 2031170 defendant Parker William gent 626592 626592 Parker, William, of Peryn, Cornw, gent 0
4069229 2049283 2049283 defendant Colroger John gent 626592 626592 Colroger, John, of Peryn, Cornw, gent 6
4125152 2069283 2069283 defendant Nanspian James gent 626592 626592 Nanspian, James, of Peryn, Cornw, gent 0
4162851 2082542 2082542 defendant Carmynowe Nicholas gent 626592 626592 Carmynowe, Nicholas, of Peryn, Cornw, gent 37
4198126 2094889 2094889 defendant Floude Roger merchant 626592 626592 Floude, Roger, of Peryn, Cornw, merchant 1
4338881 2143354 2143354 defendant Payne Thomas   626592 626592 Payne, Thomas, of Peryn, Cornw, gent, vice admiral of Cornwall 0
5377475 2468539 2468539 defendant Person Walter skinner 626592 626592 Person, Walter, of Peryn, Cornw, skinner 1
5486291 2500788 2500788 defendant Hoby or Hovy John clerk 626592 626592 Hoby or Hovy, John, of Peryn, Cornw, clerk 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);