names

28 rows where place_id = 682199

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4040628 2039144 2039144 defendant Hawkyns John husbandman 682199 682199 Hawkyns, John, of Almelye, yeoman, son of Richard Hawkyns, of Newporte, Almelye, husbandman 3
4040633 2039145 2039145 defendant Hawkyns John husbandman 682199 682199 Hawkyns, John, of Almelye, yeoman, son of Richard Hawkyns, of Newporte, Almelye, husbandman 3
4048549 2041929 2041929 defendant Turnor Walter yeoman 682199 682199 Turnor, Walter, of Almelye, yeoman 0
4061287 2046442 2046442 defendant Collyer Richard yeoman 682199 682199 Collyer, Richard, of Almelye, yeoman 2
4080950 2053500 2053500 defendant ap Thomas John yeoman 682199 682199 ap Thomas, John, of Almelye, yeoman 0
4081990 2053859 2053859 defendant Dryver John clerk 682199 682199 Dryver, John, of Almelye, clerk 1
4082392 2054012 2054012 plaintiff Alderne John   682199 682199 Alderne, John, of Almelye 0
4090950 2057054 2057054 defendant Collyer Richard yeoman 682199 682199 Collyer, Richard, of Almelye, yeoman 0
4090951 2057054 2057054 defendant Collyer Walter   682199 682199 Collyer, Walter, of Almelye, husbandman, his son 1
4135354 2072965 2072965 defendant Thomas John yeoman 682199 682199 Thomas, John, of Almelye, yeoman 1
4142184 2075445 2075445 defendant Parker Thomas husbandman 682199 682199 Parker, Thomas, of Almelye, husbandman 0
4142186 2075445 2075445 defendant Parker John husbandman 682199 682199 Parker, John, of Almelye, husbandman 2
4142187 2075445 2075445 defendant Fletcher Thomas husbandman 682199 682199 Fletcher, Thomas, of Almelye, husbandman 3
4152106 2078849 2078849 defendant Dryver John clerk 682199 682199 Dryver, John, of Almelye, clerk 0
4152108 2078850 2078850 defendant Dryver John clerk 682199 682199 Dryver, John, of Almelye, clerk 0
4152112 2078852 2078852 defendant Leythe John yeoman 682199 682199 Leythe, John, of Almelye, yeoman 0
4155968 2080162 2080162 defendant Dryver John clerk 682199 682199 Dryver, John, of Almelye, clerk 0
4176843 2087369 2087369 defendant Dryver John clerk 682199 682199 Dryver, John, of Almelye, clerk 0
4176845 2087369 2087369 defendant Turner Walter yeoman 682199 682199 Turner, Walter, of Almelye, yeoman 2
4230824 2106278 2106278 defendant Davys Margaret widow 682199 682199 Davys, Margaret, of Almelye, widow 2
4233370 2107185 2107185 defendant Wellyngton Richard yeoman 682199 682199 Wellyngton, Richard, of Almelye, yeoman 0
4233405 2107197 2107197 defendant Smythe John (legal representative) 682199 682199 Smythe, John, of Almelye, yeoman, executor of 0
4233406 2107197 2107197 defendant Smythe John yeoman 682199 682199 Smythe, John, of Almelye, yeoman 1
4233715 2107314 2107314 defendant Smythe Walter yeoman 682199 682199 Smythe, Walter, of Almelye, yeoman 1
4233716 2107314 2107314 defendant Hodges Thomas laborer 682199 682199 Hodges, Thomas, of Almelye, laborer 2
4233717 2107314 2107314 defendant Rosse John yeoman 682199 682199 Rosse, John, of Almelye, yeoman 3
4242287 2110415 2110415 defendant Hall Richard yeoman 682199 682199 Hall, Richard, of Almelye, yeoman 1
4398047 2163925 2163925 defendant Nashe John yeoman 682199 682199 Nashe, John, of Almelye, yeoman 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);