names

28 rows where place_id = 657263

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3943606 2004879 2004879 defendant Stephyn Thomas yeoman 657263 657263 Stephyn, Thomas, of Pelynt, yeoman 0
3943607 2004879 2004879 defendant Cornysh John husbandman 657263 657263 Cornysh, John, of Pelynt, husbandman 1
3943608 2004879 2004879 defendant Hodge Robert husbandman 657263 657263 Hodge, Robert, of Pelynt, husbandman 2
3943609 2004879 2004879 defendant Ewstys John husbandman 657263 657263 Ewstys, John, of Pelynt, husbandman 3
3943610 2004879 2004879 defendant Dyer John husbandman 657263 657263 Dyer, John, of Pelynt, husbandman 4
3943611 2004879 2004879 defendant Lyle John husbandman 657263 657263 Lyle, John, of Pelynt, husbandman 5
3943612 2004879 2004879 defendant Boorne Robert husbandman 657263 657263 Boorne, Robert, of Pelynt, husbandman 6
3943613 2004879 2004879 defendant Cowche John husbandman 657263 657263 Cowche, John, of Pelynt, husbandman 7
3943614 2004879 2004879 defendant Boony Thomas husbandman 657263 657263 Boony, Thomas, of Pelynt, husbandman 8
3943615 2004879 2004879 defendant Lawry William husbandman 657263 657263 Lawry, William, of Pelynt, husbandman 9
3943616 2004879 2004879 defendant Waye Robert husbandman 657263 657263 Waye, Robert, of Pelynt, husbandman 10
3943617 2004879 2004879 defendant Thomas Nicholas husbandman 657263 657263 Thomas, Nicholas, of Pelynt, husbandman 11
3943618 2004879 2004879 defendant Jane Dina widow 657263 657263 Jane, Dina, of Pelynt, widow 12
3943619 2004879 2004879 defendant Growse Richard husbandman 657263 657263 Growse, Richard, of Pelynt, husbandman 13
3943620 2004879 2004879 defendant Lobbe John husbandman 657263 657263 Lobbe, John, of Pelynt, husbandman 14
3943621 2004879 2004879 defendant Jane Thomas husbandman 657263 657263 Jane, Thomas, of Pelynt, husbandman 15
3999310 2024513 2024513 defendant Twygge Thomas husbandman 657263 657263 Twygge, Thomas, of Pelynt, or of Lawhytton, husbandman 1
4069776 2049478 2049478 defendant Penquite Thomas husbandman 657263 657263 Penquite, Thomas, of Pelynt, husbandman 0
4079366 2052923 2052923 defendant Dygges John tailor 657263 657263 Dygges, John, of Pelynt, tailor 0
4079368 2052924 2052924 defendant Luggar Stephen husbandman 657263 657263 Luggar, Stephen, of Pelynt, husbandman 0
4114682 2065540 2065540 defendant Lugger Stephen husbandman 657263 657263 Lugger, Stephen, of Pelynt, husbandman 0
4128268 2070395 2070395 defendant Lugger Thomas husbandman 657263 657263 Lugger, Thomas, of Pelynt, husbandman 0
4130815 2071331 2071331 defendant Penquyte Thomas husbandman 657263 657263 Penquyte, Thomas, of Pelynt, husbandman 0
4167928 2084269 2084269 defendant Kynge Henry husbandman 657263 657263 Kynge, Henry, of Pelynt, husbandman 0
4247440 2112125 2112125 defendant Jenken Nicholas husbandman 657263 657263 Jenken, Nicholas, of Pelynt, husbandman 0
4368752 2153877 2153877 defendant Hoskyn Thomas husbandman 657263 657263 Hoskyn, Thomas, of Pelynt, husbandman 0
4412597 2168803 2168803 defendant Lybbye John huusbandman 657263 657263 Lybbye, John, of Pelynt, huusbandman 0
4412598 2168803 2168803 defendant Lybbye John husbandman 657263 657263 Lybbye, John, of Pelynt, 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);