names

36 rows where place_id = 789300

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4579833 2225178 2225178 plaintiff (not given) John vicar of Crokhorne 789300 789300 Crokhorne, John, of Saltash, vicar of St Stephen's church 0
4712680 2269281 2269281 defendant Hawegell Alice spinster 789300 789300 together with Hawegell, Alice, of Saltash, spinster 1
4712681 2269281 2269281 defendant Robyn John husbandman 789300 789300 Robyn, John, of Saltash, husbandman 2
4712683 2269281 2269281 defendant Rawelyn William husbandman 789300 789300 Rawelyn, William, of Saltash, husbandman 4
4712686 2269282 2269282 defendant Hawegell Alice spinster 789300 789300 Hawegell, Alice, of Saltash, spinster 0
4712687 2269282 2269282 defendant Robyn John husbandman 789300 789300 Robyn, John, of Saltash, husbandman 1
4712689 2269282 2269282 defendant Rawelyn William husbandman 789300 789300 Rawelyn, William, of Saltash, husbandman 3
4818217 2301774 2301774 defendant Robyn Joan widow 789300 789300 Robyn, Joan, of Saltash, widow 2
4846213 2310321 2310321 defendant Gostard Richard mariner 789300 789300 Gostard, Richard, of Saltash, mariner 0
5004895 2358329 2358329 defendant Bayly Richard baker 789300 789300 Bayly, Richard, of Saltash, baker 0
5004896 2358329 2358329 defendant Eston John ostler 789300 789300 Eston, John, of Saltash, ostler 1
5006988 2358943 2358943 defendant Webbe John butcher 789300 789300 Webbe, John, of Saltash, butcher 0
5136250 2397119 2397119 defendant Rondell Robert mariner 789300 789300 Rondell, Robert, of Saltash, mariner 0
5146982 2400260 2400260 defendant Howe Robert skinner 789300 789300 Howe, Robert, of Saltash, skinner 0
5148063 2400580 2400580 defendant Fyssher Henry mariner 789300 789300 Fyssher, Henry, of Saltash, mariner 0
5162975 2404900 2404900 plaintiff Wase John (legal representative) 789300 789300 Wase, John, of Saltash, executors of 0
5162978 2404900 2404900 defendant Slegg Richard mariner 789300 789300 Slegg, Richard, of Saltash, mariner 0
5162979 2404901 2404901 plaintiff Wase John (legal representative) 789300 789300 Wase, John, of Saltash, executors of 0
5162982 2404901 2404901 defendant Slogg Richard mariner 789300 789300 Slogg, Richard, of Saltash, mariner 0
5167515 2406229 2406229 defendant Fyssher Henry mariner 789300 789300 Fyssher, Henry, of Saltash, mariner 0
5167518 2406229 2406229 defendant Slugge Richard merchant 789300 789300 Slugge, Richard, of Saltash, merchant 3
5167520 2406230 2406230 defendant Walter Gregory merchant 789300 789300 Walter, Gregory, of Saltash, merchant 0
5176839 2408915 2408915 plaintiff Wase John (legal representative) 789300 789300 Wase, John, of Saltash, executors of 0
5176842 2408915 2408915 defendant Slogg Richard mariner 789300 789300 Slogg, Richard, of Saltash, mariner 0
5199325 2415552 2415552 plaintiff Wase John (legal representative) 789300 789300 Wase, John, of Saltash, executors of 0
5199328 2415552 2415552 defendant Slogg Richard mariner 789300 789300 Slogg, Richard, of Saltash, mariner 0
5206854 2417741 2417741 plaintiff Lolla Nicholas   789300 789300 Lolla, Nicholas, of Saltash 0
5379265 2469109 2469109 defendant Bowey John husbandman 789300 789300 Bowey, John, of Saltash, husbandman 1
5387963 2471615 2471615 defendant Smyth Thomas smith 789300 789300 Smyth, Thomas, of Saltash, smith 0
5393548 2473215 2473215 defendant Lethe Thomas husbandman 789300 789300 Lethe, Thomas, of Saltash, husbandman 0
5413600 2478993 2478993 plaintiff Gaske William merchant 789300 789300 Gaske, William, of Saltash, merchant 0
5471891 2496545 2496545 defendant Kendale Thomas merchant 789300 789300 Kendale, Thomas, of Saltash, merchant 0
5471894 2496546 2496546 defendant Kendale Thomas merchant 789300 789300 Kendale, Thomas, of Saltash, merchant 0
5476701 2498029 2498029 defendant Jemco John merchant 789300 789300 Jemco, John, of Saltash, merchant 0
5476702 2498029 2498029 defendant Rovet Thomas merchant 789300 789300 Rovet, Thomas, of Saltash, merchant 1
5476704 2498029 2498029 defendant Agas Nicholas merchant 789300 789300 Agas, Nicholas, of Saltash, merchant 3

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