names

17 rows where place_id = 658426

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3948380 2006496 2006496 defendant de Balderram Junegus merchant of Spain 658426 658426 de Balderram, Junegus, of Padstowe, Cornw, merchant of Spain 0
4056430 2044684 2044684 defendant Balderam Enegon merchant stranger 658426 658426 Balderam, Enegon, of Padstowe, Cornw, merchant stranger 1
4067454 2048669 2048669 defendant George Simon gent 658426 658426 George, Simon, of Padstowe, Cornw, gent 0
4099961 2060311 2060311 defendant Marstocke alias Spycer James merchant 658426 658426 Marstocke alias Spycer, James, of Padstowe, Cornw, merchant 0
4155347 2079961 2079961 defendant Midleton John yeoman 658426 658426 Midleton, John, of Padstowe, Cornw, yeoman 0
4202985 2096592 2096592 defendant Bysshoppe John yeoman 658426 658426 Bysshoppe, John, of Padstowe, Cornw, yeoman 0
4223684 2103770 2103770 defendant Horne Henry mariner 658426 658426 Horne, Henry, of Padstowe, Cornw, mariner 0
4224416 2104023 2104023 defendant Myddelton John merchant 658426 658426 Myddelton, John, of Padstowe, Cornw, merchant 0
4231694 2106584 2106584 defendant Horne Henry mariner 658426 658426 Horne, Henry, of Padstowe, Cornw, mariner 0
4252553 2113844 2113844 defendant Middelton john merchant 658426 658426 Middelton, john, of Padstowe, Cornw, merchant 0
4307940 2132919 2132919 defendant Greynvyle George gent 658426 658426 Greynvyle, George, of Padstowe, Cornw, gent 0
4334367 2141771 2141771 defendant Calwoodley John gent 658426 658426 Calwoodley, John, of Padstowe, Cornw, gent 0
4337286 2142773 2142773 defendant Yeo Nicholas merchant 658426 658426 Yeo, Nicholas, of Padstowe, Cornw, merchant 0
4359913 2150709 2150709 defendant Yeo Nicholas merchant 658426 658426 Yeo, Nicholas, of Padstowe, Cornw, merchant 0
4360853 2151048 2151048 defendant Blakenbury Francis gent 658426 658426 Blakenbury, Francis, of Padstowe, Cornw, gent 0
4381788 2158590 2158590 defendant Prideauxe John gent 658426 658426 Prideauxe, John, of Padstowe, Cornw, gent 1
4399194 2164316 2164316 defendant Henrye John chapman 658426 658426 Henrye, John, of Padstowe, Cornw, chapman 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);