names

31 rows where place_id = 655467

✎ 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
3936419 2002502 2002502 defendant Somner Ambrose husbandman 655467 655467 Somner, Ambrose, of Ilfardcombe, husbandman 0
4140508 2074849 2074849 defendant Harris Pascas tanner 655467 655467 Harris, Pascas, of Ilfardcombe, tanner 0
4140513 2074850 2074850 defendant Quynt John husbandman 655467 655467 Quynt, John, of Ilfardcombe, husbandman 1
4147455 2077250 2077250 defendant Soley Wallter yeoman 655467 655467 Soley, Wallter, of Ilfardcombe, yeoman 2
4149555 2077970 2077970 defendant Aysshe David husbandman 655467 655467 Aysshe, David, of Ilfardcombe, husbandman 0
4179688 2088368 2088368 defendant Toker Richard husbandman 655467 655467 (Toker, Richard, of Ilfardcombe, husbandman 4
4260191 2116372 2116372 defendant Robyns John husbandman 655467 655467 Robyns, John, of Ilfardcombe, husbandman 0
4306322 2132353 2132353 defendant Dyer Robert husbandman 655467 655467 Dyer, Robert, of Ilfardcombe, or of Porlock, Soms, husbandman 0
4306323 2132353 2132353 defendant Dyer John (legal representative) 655467 655467 Dyer, John, of Ilfardcombe, husbandman, executrix of 1
4306324 2132353 2132353 defendant Dyer Margaret widow 655467 655467 Dyer, Margaret, of Ilfardcombe, widow 2
4308888 2133259 2133259 defendant Griffen Anthony husbandman 655467 655467 Griffen, Anthony, of Ilfardcombe, husbandman 0
4308889 2133259 2133259 defendant Chollecombe John yeoman 655467 655467 Chollecombe, John, of Ilfardcombe, yeoman 1
4332574 2141182 2141182 defendant Frye Silvester   655467 655467 Frye, Silvester, of Ilfardcombe, sailor, captain 0
4376824 2156782 2156782 defendant Dyer William   655467 655467 Dyer, William, of Ilfardcombe, sailor 0
4807680 2298593 2298593 defendant Hoper Gilbert yeoman 655467 655467 Hoper, Gilbert, of Ilfardcombe, yeoman 1
4856695 2313470 2313470 defendant Elys Robert husbandman 655467 655467 Elys, Robert, of Ilfardcombe, husbandman 0
4915930 2331478 2331478 defendant Davy Richard baker 655467 655467 Davy, Richard, of Ilfardcombe, baker 0
4978714 2350584 2350584 defendant Elys John husbandman 655467 655467 Elys, John, of Ilfardcombe, husbandman 3
4985272 2352520 2352520 defendant Gobbe John, senior mariner 655467 655467 Gobbe, John, senior, of Ilfardcombe, mariner 0
4985273 2352520 2352520 defendant Garlond Thomas husbandman 655467 655467 Garlond, Thomas, of Ilfardcombe, husbandman 1
4985274 2352520 2352520 defendant Olyver John husbandman 655467 655467 Olyver, John, of Ilfardcombe, husbandman 2
4985275 2352520 2352520 defendant Davy Richard husbandman 655467 655467 Davy, Richard, of Ilfardcombe, husbandman 3
4985276 2352520 2352520 defendant Kycke John yeoman 655467 655467 Kycke, John, of Ilfardcombe, yeoman 4
4985277 2352520 2352520 defendant Broun Thomas seaman 655467 655467 Broun, Thomas, of Ilfardcombe, seaman 5
4985278 2352520 2352520 defendant Wylhay William smith 655467 655467 Wylhay, William, of Ilfardcombe, smith 6
4985279 2352520 2352520 defendant Stykke Thomas husbandman 655467 655467 Stykke, Thomas, of Ilfardcombe, husbandman 7
4985281 2352520 2352520 defendant Brounyng Thomas husbandman 655467 655467 Brounyng, Thomas, of Ilfardcombe, husbandman 9
4985282 2352520 2352520 defendant Rede Richard baker 655467 655467 Rede, Richard, of Ilfardcombe, baker 10
4985283 2352520 2352520 defendant Leye John mariner 655467 655467 Leye, John, of Ilfardcombe, mariner 11
4985284 2352520 2352520 defendant Wyke Auncel fisher 655467 655467 Wyke, Auncel, of Ilfardcombe, fisher 12
4985285 2352520 2352520 defendant Pytman Henry weaver 655467 655467 Pytman, Henry, of Ilfardcombe, weaver 13

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