names

48 rows where place_id = 625044

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3761770 1945692 1945692 defendant Deyne Ralph husbandman 625044 625044 Deyne, Ralph, of Bankewell, husbandman 0
3816337 1963019 1963019 plaintiff Hooton Richard clerk 625044 625044 Hooton, Richard, of Bankewell, clerk 0
4487177 2196715 2196715 plaintiff Palmer Thomas   625044 625044 Palmer, Thomas, of Bankewell 1
4540262 2212856 2212856 defendant Smth Richard   625044 625044 Smth, Richard, of Bankewell 0
4540263 2212856 2212856 defendant Smythson Robert   625044 625044 Smythson, Robert, of Bankewell 1
4540264 2212856 2212856 defendant Chapman John   625044 625044 Chapman, John, of Bankewell 2
4540266 2212856 2212856 defendant Smythson Richard   625044 625044 Smythson, Richard, of Bankewell 4
4551228 2216325 2216325 defendant Burton John de chaplain 625044 625044 Burton, John de, of Bankewell, chaplain 0
4551230 2216325 2216325 defendant Drabull William   625044 625044 Drabull, William, of Bankewell 2
4572026 2222818 2222818 defendant Shawe John   625044 625044 Shawe, John, of Bankewell 0
4605430 2232838 2232838 defendant Whithill John de   625044 625044 Whithill, John de, of Bankewell 23
4628013 2239684 2239684 defendant Bradwall Robert   625044 625044 Bradwall, Robert, of Bankewell 0
4628017 2239684 2239684 defendant Drakull William   625044 625044 Drakull, William, of Bankewell 4
4651483 2246467 2246467 defendant del Shagh John   625044 625044 del Shagh, John, of Bankewell 0
4722328 2272307 2272307 defendant Hauson John walker 625044 625044 Hauson, John, of Bankewell, walker 2
4729545 2274452 2274452 defendant Berdehalgh Roger husbandman 625044 625044 Berdehalgh, Roger, of Bankewell, husbandman 0
5049217 2371399 2371399 defendant Harreson William husbandman 625044 625044 Harreson, William, of Bankewell, husbandman 3
5049218 2371399 2371399 defendant de Dale John husbandman 625044 625044 de Dale, John, of Bankewell, husbandman 4
5073347 2378516 2378516 defendant Boun John yeoman 625044 625044 Boun, John, of Bankewell, yeoman 1
5228089 2423821 2423821 defendant Shyngulherst John yeoman 625044 625044 Shyngulherst, John, of Bankewell, yeoman 0
5228090 2423821 2423821 defendant Colley John husbandman 625044 625044 Colley, John, of Bankewell, husbandman 1
5228091 2423821 2423821 defendant Henryson John husbandman 625044 625044 Henryson, John, of Bankewell, husbandman 2
5228092 2423821 2423821 defendant Crychelowe Richard clerk 625044 625044 Crychelowe, Richard, of Bankewell, clerk 3
5262988 2434168 2434168 defendant Boun Richard yeoman 625044 625044 Boun, Richard, of Bankewell, yeoman 0
5262989 2434168 2434168 defendant Grynleford Richard yeoman 625044 625044 Grynleford, Richard, of Bankewell, yeoman 1
5262990 2434168 2434168 defendant Herryson William yeoman 625044 625044 Herryson, William, of Bankewell, yeoman 2
5262991 2434168 2434168 defendant Shynglehurst John yeoman 625044 625044 Shynglehurst, John, of Bankewell, yeoman 3
5262992 2434168 2434168 defendant Lee William laborer 625044 625044 Lee, William, of Bankewell, laborer 4
5262993 2434168 2434168 defendant Purselewes Roger laborer 625044 625044 Purselewes, Roger, of Bankewell, laborer 5
5262994 2434168 2434168 defendant Boun John yeoman 625044 625044 Boun, John, of Bankewell, yeoman 6
5262995 2434168 2434168 defendant Dykar William laborer 625044 625044 Dykar, William, of Bankewell, laborer 7
5262996 2434168 2434168 defendant Caryour Beatrice widow 625044 625044 Caryour, Beatrice, of Bankewell, widow 8
5334667 2455436 2455436 defendant Harryson Roland husbandman 625044 625044 Harryson, Roland, of Bankewell, husbandman 0
5334669 2455437 2455437 defendant Hybelyn John yeoman 625044 625044 Hybelyn, John, of Bankewell, yeoman 0
5334670 2455437 2455437 defendant Herryson Thomas yeoman 625044 625044 Herryson, Thomas, of Bankewell, yeoman 1
5334671 2455437 2455437 defendant Berdall Ralph husbandman 625044 625044 Berdall, Ralph, of Bankewell, husbandman 2
5334672 2455437 2455437 defendant Mader John husbandman 625044 625044 Mader, John, of Bankewell, husbandman 3
5334673 2455437 2455437 defendant Bonne Godfrey yeoman 625044 625044 Bonne, Godfrey, of Bankewell, yeoman 4
5334674 2455437 2455437 defendant Wolstroncrofte Thomas husbandman 625044 625044 Wolstroncrofte, Thomas, of Bankewell, husbandman 5
5334675 2455437 2455437 defendant Fleccher Richard husbandman 625044 625044 Fleccher, Richard, of Bankewell, husbandman 6
5334676 2455437 2455437 defendant Harryesson Roland husbandman 625044 625044 Harryesson, Roland, of Bankewell, husbandman 7
5334677 2455437 2455437 defendant Sheldon John husbandman 625044 625044 Sheldon, John, of Bankewell, husbandman 8
5334678 2455437 2455437 defendant Jacson John butcher 625044 625044 Jacson, John, of Bankewell, butcher 9
5334679 2455437 2455437 defendant Knolles Richard husbandman 625044 625044 Knolles, Richard, of Bankewell, husbandman 10
5334680 2455437 2455437 defendant Mader Roger husbandman 625044 625044 Mader, Roger, of Bankewell, husbandman 11
5334681 2455437 2455437 defendant Crichelowe John husbandman 625044 625044 Crichelowe, John, of Bankewell, husbandman 12
5334682 2455437 2455437 defendant Leom John husbandman 625044 625044 Leom, John, of Bankewell, husbandman 13
5355753 2461876 2461876 defendant Tounrowe William chaplain 625044 625044 Tounrowe, William, of Bankewell, chaplain 3

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