names

41 rows where place_id = 588467

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594590 1865940 1865940 defendant Calwodley Oliver gent 588467 588467 Calwodley, Oliver, of Padstowe, gent 1
3711118 1929791 1929791 defendant Avery Walter husbandman 588467 588467 Avery, Walter, of Padstowe, husbandman 0
3728687 1935212 1935212 defendant Shetyk John husbandman 588467 588467 Shetyk, John, of Padstowe, husbandman 0
3741703 1939270 1939270 defendant Avery Walter husbandman 588467 588467 Avery, Walter, of Padstowe, husbandman 0
3783962 1952762 1952762 defendant Treveryn Thomas yeoman 588467 588467 Treveryn, Thomas, of Padstowe, yeoman 2
3797471 1957097 1957097 defendant David John merchant 588467 588467 David, John, of Padstowe, merchant 0
3801076 1958253 1958253 defendant Glover John husbandman 588467 588467 Glover, John, of Padstowe, husbandman 0
3801077 1958253 1958253 defendant Nanskue Thomas husbandman 588467 588467 Nanskue, Thomas, of Padstowe, husbandman 1
3872433 1981003 1981003 defendant Hupper Peter cooper 588467 588467 Hupper, Peter, of Padstowe, cooper 0
3872434 1981003 1981003 defendant Peryn John chaplain 588467 588467 Peryn, John, of Padstowe, chaplain 1
3897836 1989480 1989480 defendant Quynte Alice widow 588467 588467 (Quynte, Alice, of Padstowe, widow 1
3948422 2006512 2006512 defendant Assheridge John   588467 588467 Assheridge, John, of Padstowe, hook maker 0
3948425 2006512 2006512 defendant Towold Richarda widow 588467 588467 Towold, Richarda, of Padstowe, widow 3
3964815 2012302 2012302 defendant Mason Henry merchant 588467 588467 Mason, Henry, of Padstowe, merchant 2
3964816 2012302 2012302 defendant Caron Nicholas husbandman 588467 588467 Caron, Nicholas, of Padstowe, husbandman 3
4011125 2028748 2028748 defendant Tregegyowe John gent 588467 588467 Tregegyowe, John, of Padstowe, gent 1
4058040 2045256 2045256 defendant Harries George yeoman 588467 588467 Harries, George, of Padstowe, yeoman 0
4121336 2067927 2067927 defendant Prydyaux Richard gent 588467 588467 Prydyaux, Richard, of Padstowe, gent 0
4121343 2067930 2067930 defendant Prydiaux Richard gent 588467 588467 Prydiaux, Richard, of Padstowe, gent 0
4122741 2068425 2068425 defendant Bysshoppe John yeoman 588467 588467 Bysshoppe, John, of Padstowe, yeoman 0
4131609 2071625 2071625 defendant Midleton John yeoman 588467 588467 Midleton, John, of Padstowe, yeoman 0
4145968 2076744 2076744 defendant Warne George yeoman 588467 588467 Warne, George, of Padstowe, yeoman 1
4164020 2082944 2082944 defendant Trehar John yeoman 588467 588467 Trehar, John, of Padstowe, yeoman 0
4164021 2082944 2082944 defendant Jone Thomas husbandman 588467 588467 Jone, Thomas, of Padstowe, husbandman 1
4164022 2082944 2082944 defendant Symon John husbandman 588467 588467 Symon, John, of Padstowe, husbandman 2
4180339 2088602 2088602 defendant Baldram Evegon merchant 588467 588467 Baldram, Evegon , of Padstowe, merchant 1
4197394 2094643 2094643 defendant Rede William husbandman 588467 588467 Rede, William, of Padstowe, husbandman 0
4220367 2102629 2102629 defendant Quynte Henry   588467 588467 Quynte, Henry, of Padstowe, sailor 0
4246410 2111776 2111776 defendant Quynte Henry   588467 588467 Quynte, Henry, of Padstowe, sailor 0
4298533 2129577 2129577 defendant Howe William yeoman 588467 588467 Howe, William, of Padstowe, yeoman 0
4308357 2133074 2133074 defendant Prydiaux John gent 588467 588467 Prydiaux, John, of Padstowe, gent 0
4362099 2151488 2151488 defendant Prydeaux Richard gent 588467 588467 Prydeaux, Richard, of Padstowe, or of St Isie, gent 0
4381789 2158590 2158590 defendant Prideauxe Richard gent 588467 588467 Prideauxe, Richard, of Padstowe, gent 2
4408008 2167246 2167246 defendant Prideaux Richard gent 588467 588467 Prideaux, Richard, of Padstowe, gent 0
4766972 2285658 2285658 defendant Rostarrok Walter gent 588467 588467 Rostarrok, Walter, of Padstowe, gent 0
4992307 2354592 2354592 defendant bussell John fisherman 588467 588467 bussell, John, of Padstowe, fisherman 1
5142642 2398977 2398977 defendant Yeo Richard gent 588467 588467 Yeo, Richard, of Padstowe, gent 1
5319723 2450993 2450993 defendant Willyam Richard husbandman 588467 588467 Willyam, Richard, of Padstowe, husbandman 1
5456402 2491835 2491835 defendant Curdelyan James chapman 588467 588467 (Curdelyan, James, of Padstowe, chapman 1
5456403 2491835 2491835 defendant Porthmere John husbandman 588467 588467 Porthmere, John, of Padstowe, husbandman 2
5609039 2537731 2537731 defendant Tokyer Thomas husbandman 588467 588467 Tokyer, Thomas, of Padstowe, husbandman 1

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