names

42 rows where place_id = 595682

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621468 1874254 1874254 defendant Nanspyan Martin chaplain 595682 595682 Nanspyan, Martin, of St Probus, chaplain 2
3697967 1925588 1925588 defendant Chymeowe John clerk 595682 595682 Chymeowe, John, of St Probus, clerk 0
3707106 1928509 1928509 defendant Laa Thomas yeoman 595682 595682 Laa, Thomas, of St Probus, yeoman 1
3723335 1933568 1933568 defendant Treswythan John husbandman 595682 595682 Treswythan, John, of St Probus, husbandman 0
3749191 1941672 1941672 defendant Mayowe John husbandman 595682 595682 Mayowe, John, of St Probus, husbandman 13
3811316 1961435 1961435 plaintiff Carnarthe Lawrence   595682 595682 Carnarthe, Lawrence, of St Probus 0
3894919 1988510 1988510 defendant Jenkyn alias Namelyn John collier 595682 595682 Jenkyn alias Namelyn, John, of St Probus, collier 0
3894920 1988510 1988510 defendant Scanway John collier 595682 595682 Scanway, John, of St Probus, collier 1
3894921 1988510 1988510 defendant Polkynhorne Thomas collier 595682 595682 Polkynhorne, Thomas, of St Probus, collier 2
3894922 1988510 1988510 defendant John Stephen collier 595682 595682 John, Stephen, of St Probus, collier 3
3933587 2001520 2001520 defendant Andrewe John laborer 595682 595682 Andrewe, John, of St Probus, laborer 0
3965939 2012706 2012706 defendant Collyn John husbandman 595682 595682 Collyn, John, of St Probus, husbandman 0
4003657 2026073 2026073 defendant B--allack John gent 595682 595682 B--allack, John, of St Probus, gent 0
4129897 2071004 2071004 defendant Denys John merchant 595682 595682 Denys, John, of St Probus, merchant 1
4151225 2078550 2078550 defendant Hooper Henry husbandman 595682 595682 Hooper Henry, of St Probus, husbandman 1
4188538 2091466 2091466 defendant Hooper Henry husbandman 595682 595682 Hooper, Henry, of St Probus, husbandman 0
4298328 2129502 2129502 defendant Stephens Henry tanner 595682 595682 Stephens, Henry, of St Probus, tanner 2
4444682 2183315 2183315 plaintiff and Burley Thomas clerk 595682 595682 and Burley, Thomas, of St Probus, clerk 1
4621510 2237719 2237719 defendant Tregher Reginald   595682 595682 Tregher, Reginald, of St Probus 16
4712423 2269201 2269201 defendant Tomma Nansmelyn John carpenter 595682 595682 Tomma Nansmelyn, John, of St Probus, carpenter 0
4737381 2276808 2276808 defendant Smyth Drew smith 595682 595682 Smyth, Drew, of St Probus, smith 0
4784516 2291161 2291161 defendant Tommelamelyn John carpenter 595682 595682 Tommelamelyn, John, of St Probus, carpenter 1
4908367 2329172 2329172 defendant Raulyn Walter, senior husbandman 595682 595682 Raulyn, Walter, senior, of St Probus, husbandman 0
4908368 2329172 2329172 defendant Raulyn Michael husbandman 595682 595682 Raulyn, Michael, of St Probus, husbandman 1
4908369 2329172 2329172 defendant Raulyn Walter husbandman 595682 595682 Raulyn, Walter, of St Probus, husbandman 2
5059173 2374307 2374307 defendant Stephyns John smith 595682 595682 Stephyns, John, of St Probus, smith 0
5082614 2381305 2381305 defendant Stevyn John smith 595682 595682 Stevyn, John, of St Probus, smith 2
5082617 2381305 2381305 defendant Hucos John husbandman 595682 595682 Hucos, John, of St Probus, husbandman 5
5082618 2381305 2381305 defendant Wonot Clement husbandman 595682 595682 Wonot, Clement, of St Probus, husbandman 6
5097716 2385757 2385757 defendant Watte John cobbler 595682 595682 Watte, John, of St Probus, cobbler 0
5141039 2398502 2398502 defendant Hiobe Ralph husbandman 595682 595682 Hiobe, Ralph, of St Probus, husbandman 1
5162187 2404673 2404673 defendant Hicke Ralph husbandman 595682 595682 Hicke, Ralph, of St Probus, husbandman 7
5177321 2409062 2409062 defendant Tomas Benedict clerk 595682 595682 Tomas, Benedict, of St Probus, clerk 2
5196291 2414664 2414664 defendant Thomas Benedict clerk 595682 595682 Thomas, Benedict, of St Probus, clerk 2
5200267 2415838 2415838 defendant Thomas Benedict clerk 595682 595682 Thomas, Benedict, of St Probus, clerk 2
5211453 2419083 2419083 defendant Thomas Benedict clerk 595682 595682 (Thomas, Benedict, of St Probus, clerk 1
5245744 2428918 2428918 defendant Mewedyn Robert smith 595682 595682 Mewedyn, Robert, of St Probus, smith 4
5386893 2471314 2471314 defendant Tredower William fuller of cloth 595682 595682 Tredower, William, of St Probus, fuller of cloth 2
5386894 2471314 2471314 defendant Cassew John husbandman 595682 595682 Cassew, John, of St Probus, husbandman 3
5430694 2484119 2484119 defendant Wolvedon Robert gent 595682 595682 Wolvedon, Robert, of St Probus, gent 0
5447324 2489090 2489090 defendant Wolvedon Robert gent 595682 595682 Wolvedon, Robert, of St Probus, gent 0
5471442 2496403 2496403 defendant Wovedon Robert gent 595682 595682 Wovedon, Robert, of St Probus, gent 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);