names

20 rows where place_id = 684524

✎ 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
4058591 2045464 2045464 defendant Gawpyn John yeoman 684524 684524 Gawpyn, John, of Iberton, yeoman 1
4119771 2067358 2067358 defendant Chepman Christopher yeoman 684524 684524 Chepman, Christopher, of Iberton, yeoman 0
4167529 2084137 2084137 defendant Symont Robert husbandman 684524 684524 Symont, Robert, of Iberton, husbandman 0
4212534 2099925 2099925 defendant Chypleye Henry yeoman 684524 684524 Chypleye, Henry, of Iberton, yeoman 1
4234906 2107761 2107761 defendant Shyplye Henry miller 684524 684524 Shyplye, Henry, of Iberton, miller 0
4243528 2110825 2110825 defendant Shyplye Henry miller 684524 684524 Shyplye, Henry, of Iberton, miller 0
4291039 2126861 2126861 defendant Strangways Agnes widow 684524 684524 Strangways, Agnes, of Iberton, or of Hassellbury Brian, widow 0
4304535 2131723 2131723 defendant Vawter Thomas yeoman 684524 684524 Vawter, Thomas, of Iberton, yeoman 0
4323718 2138345 2138345 defendant Vawter Thomas yeoman 684524 684524 together with Vawter, Thomas, of Iberton, yeoman 1
4323720 2138345 2138345 defendant Rogers Robert husbandman 684524 684524 Rogers, Robert, of Iberton, husbandman 3
4693868 2263586 2263586 defendant Vare William smith 684524 684524 Vare, William, of Iberton, smith 0
4747624 2279813 2279813 defendant Godewyn John husbandman 684524 684524 Godewyn, John, of Iberton, husbandman 0
4914179 2330948 2330948 defendant Lodyngton Robert   684524 684524 Lodyngton, Robert, of Iberton, parson 0
4914180 2330948 2330948 defendant Maydekyn John husbandman 684524 684524 Maydekyn, John, of Iberton, husbandman 1
4914181 2330948 2330948 defendant Suby John carpenter 684524 684524 Suby, John, of Iberton, carpenter 2
5129616 2395152 2395152 defendant Longe William   684524 684524 Longe, William, of Iberton, servant 0
5155123 2402647 2402647 defendant Pegon John husbandman 684524 684524 Pegon, John, of Iberton, husbandman 0
5190623 2413002 2413002 defendant Pegon John husbandman 684524 684524 Pegon, John, of Iberton, husbandman 0
5264956 2434796 2434796 defendant Okeford John husbandman 684524 684524 Okeford, John, of Iberton, husbandman 0
5604412 2536244 2536244 defendant Porter John husbandman 684524 684524 Porter, John, of Iberton, husbandman 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);