names

45 rows where place_id = 683943

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4056060 2044552 2044552 defendant Scott Michael yeoman 683943 683943 Scott, Michael, of Carbrooke, yeoman 0
4062910 2047035 2047035 defendant Atmere Francis tailor 683943 683943 Atmere, Francis, of Carbrooke, tailor 0
4064192 2047467 2047467 defendant Sturgen John husbandman 683943 683943 Sturgen, John, of Carbrooke, husbandman 0
4064193 2047467 2047467 defendant Sturgen William husbandman 683943 683943 Sturgen, William, of Carbrooke, husbandman 1
4074337 2051123 2051123 defendant Aylmer Isabel   683943 683943 Aylmer, Isabel, of Carbrooke widow 1
4077624 2052284 2052284 defendant Stephenson William blacksmith 683943 683943 Stephenson, William, of Carbrooke, blacksmith 0
4113572 2065131 2065131 defendant Cooke Sampson husbandman 683943 683943 Cooke, Sampson, of Carbrooke, husbandman 3
4160296 2081672 2081672 defendant Yonges Richard carpenter 683943 683943 Yonges, Richard, of Carbrooke, carpenter 0
4160297 2081672 2081672 defendant Newton Ezekial carpenter 683943 683943 Newton, Ezekial, of Carbrooke, carpenter 1
4164843 2083215 2083215 defendant Yong or Yonges Richard carpenter 683943 683943 Yong or Yonges, Richard, of Carbrooke, carpenter 0
4165560 2083454 2083454 defendant Wyllyngton Alexander yeoman 683943 683943 Wyllyngton, Alexander, of Carbrooke, yeoman 1
4173647 2086238 2086238 defendant Wyther John husbandman 683943 683943 Wyther, John, of Carbrooke, husbandman 0
4186812 2090873 2090873 defendant Newton Ezechial carpenter 683943 683943 Newton, Ezechial, of Carbrooke, carpenter 3
4198992 2095204 2095204 defendant Rooke Roger laborer 683943 683943 Rooke, Roger, of Carbrooke, laborer 3
4221781 2103114 2103114 defendant Beedeman Thomas blacksmith 683943 683943 Beedeman, Thomas, of Carbrooke, blacksmith 3
4223585 2103736 2103736 defendant Scott William yeoman 683943 683943 Scott, William, of Carbrooke, yeoman 1
4223586 2103736 2103736 defendant Wyteman Richard tailor 683943 683943 Wyteman, Richard, of Carbrooke, yeoman, tailor 2
4268454 2119051 2119051 defendant Scott William tanner 683943 683943 Scott, William, of Carbrooke, yeoman, tanner 2
4310624 2133862 2133862 defendant George Thomas husbandman 683943 683943 George, Thomas, of Carbrooke, husbandman 1
4311715 2134239 2134239 defendant Wyteman Nicholas yeoman 683943 683943 Wyteman, Nicholas, of Carbrooke, yeoman 0
4334052 2141670 2141670 defendant Hall John husbandman 683943 683943 Hall, John, of Carbrooke, husbandman 0
4338913 2143364 2143364 defendant Ludkyn Valentine (legal representative) 683943 683943 Ludkyn, Valentine, of Carbrooke, tailor, executors of 0
4338914 2143364 2143364 defendant Grene Thomas yeoman 683943 683943 (Grene Thomas, of Carbrooke, yeoman 1
4342363 2144602 2144602 defendant Cracknell alias Munson Thomas laborer 683943 683943 Cracknell alias Munson, Thomas, of Carbrooke, laborer 1
4342616 2144690 2144690 defendant Kettle John husbandman 683943 683943 Kettle, John, of Carbrooke, husbandman 2
4342617 2144690 2144690 defendant Fryckett John husbandman 683943 683943 Fryckett, John, of Carbrooke, husbandman 3
4353957 2148612 2148612 defendant Reade William yeoman 683943 683943 Reade, William, of Carbrooke, yeoman 0
4353959 2148612 2148612 defendant Dowsyng Simon yeoman 683943 683943 Dowsyng, Simon, of Carbrooke, yeoman 2
4353960 2148612 2148612 defendant Hale John yeoman 683943 683943 Hale, John, of Carbrooke, yeoman 3
4353961 2148612 2148612 defendant Stevenson Cecily widow 683943 683943 Stevenson, Cecily, of Carbrooke, widow 4
4353963 2148613 2148613 defendant Watson George yeoman 683943 683943 Watson, George, of Carbrooke, yeoman 0
4353964 2148613 2148613 defendant Mayes William yeoman 683943 683943 Mayes, William, of Carbrooke, yeoman 1
4353965 2148613 2148613 defendant Wynter Thomas yeoman 683943 683943 Wynter, Thomas, of Carbrooke, yeoman 2
4353966 2148613 2148613 defendant Dowsynge John yeoman 683943 683943 Dowsynge, John, of Carbrooke, yeoman 3
4391567 2161792 2161792 defendant Pawmer Thomas miller 683943 683943 Pawmer, Thomas, of Carbrooke, miller 0
4391568 2161792 2161792 defendant Gibbon Henry yeoman 683943 683943 Gibbon, Henry, of Carbrooke, yeoman 1
4391570 2161792 2161792 defendant Masters Anne widow 683943 683943 Masters, Anne, of Carbrooke, widow 3
4393730 2162505 2162505 defendant Gate Geoffrey esq 683943 683943 Gate, Geoffrey, of Carbrooke, esq 0
4393731 2162505 2162505 defendant Hartley Barnard husbandman 683943 683943 Hartley, Barnard, of Carbrooke, husbandman 1
4393732 2162505 2162505 defendant Stevenson William blacksmith 683943 683943 Stevenson, William, of Carbrooke, blacksmith 2
4393733 2162505 2162505 defendant Beadman Thomas blacksmith 683943 683943 Beadman, Thomas, of Carbrooke, blacksmith 3
4399461 2164406 2164406 defendant Scotte Michael husbandman 683943 683943 Scotte, Michael, of Carbrooke, husbandman 3
4401187 2164993 2164993 defendant Gawdron John yeoman 683943 683943 Gawdron, John, of Carbrooke, yeoman 0
4401188 2164993 2164993 defendant Gawdron Richard yeoman 683943 683943 Gawdron, Richard, of Carbrooke, yeoman 1
4407006 2166901 2166901 defendant Graye Anthony gent 683943 683943 Graye, Anthony, of Carbrooke, gent 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);