names

18 rows where place_id = 778818

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4656880 2248049 2248049 defendant Sturte William tailor 778818 778818 Sturte, William, of Yalmpton, tailor 0
4912559 2330429 2330429 defendant Peye Thomas weaver 778818 778818 Peye, Thomas, of Yalmpton, weaver 2
4935266 2337432 2337432 defendant Martyn Edmund helyer or roofer 778818 778818 Martyn, Edmund, of Yalmpton, helyer or roofer 3
5014297 2361034 2361034 defendant Burgh John clerk 778818 778818 Burgh, John, of Yalmpton, clerk 0
5037030 2367700 2367700 defendant Stone Thomas gent 778818 778818 Stone, Thomas, of Yalmpton, gent 0
5044662 2370034 2370034 defendant Stone Thomas gent 778818 778818 Stone, Thomas, of Yalmpton, gent 0
5046332 2370538 2370538 defendant Stone Thomas gent 778818 778818 Stone, Thomas, of Yalmpton, gent 0
5051362 2372021 2372021 defendant Stone Thomas gent 778818 778818 Stone, Thomas, of Yalmpton, gent 0
5076831 2379566 2379566 defendant Wynston John husbandman 778818 778818 Wynston, John, of Yalmpton, husbandman 1
5086735 2382514 2382514 defendant Broun Walter yeoman 778818 778818 Broun, Walter, of Yalmpton, yeoman 0
5086736 2382514 2382514 defendant Walssh Nicholas husbandman 778818 778818 Walssh, Nicholas, of Yalmpton, husbandman 1
5234655 2425725 2425725 defendant Prendergest Thomas yeoman 778818 778818 Prendergest, Thomas, of Yalmpton, yeoman 0
5234656 2425725 2425725 defendant Trevy John soaper 778818 778818 Trevy, John, of Yalmpton, soaper 1
5252712 2430955 2430955 defendant Bea Thomas husbandman 778818 778818 Bea, Thomas, of Yalmpton, husbandman 2
5259581 2433117 2433117 defendant Hyllyng Peter husbandman 778818 778818 Hyllyng, Peter, of Yalmpton, husbandman 0
5331305 2454438 2454438 defendant Strethe Henry smith 778818 778818 Strethe, Henry, of Yalmpton, smith 1
5538623 2516561 2516561 defendant Copleston Walter (legal representative) 778818 778818 Copleston, Walter, of Yalmpton, administrator of 0
5538624 2516561 2516561 defendant Copleston Thomas gent 778818 778818 Copleston, Thomas, of Yalmpton, gent 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);