names

49 rows where place_id = 594056

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614398 1872153 1872153 defendant Ferrers Leonard gent 594056 594056 Ferrers, Leonard, of Tamworth, Warks, gent 0
3801561 1958392 1958392 defendant Archer Richard gent 594056 594056 Archer, Richard, of Tamworth, Warks, gent 0
3819000 1963834 1963834 defendant Archer Richard gent 594056 594056 Archer, Richard, of Tamworth, Warks, gent 0
3831888 1967866 1967866 defendant Morecok Thomas whitawer 594056 594056 Morecok, Thomas, of Tamworth, Warks, whitawer 1
3912765 1994601 1994601 defendant Gonson Robert butcher 594056 594056 Gonson, Robert, of Tamworth, Warks, butcher 0
3913567 1994879 1994879 defendant Ensour Richard mercer 594056 594056 Ensour, Richard, of Tamworth, Warks, mercer 0
3954010 2008471 2008471 defendant Nyckson Anthony chapman 594056 594056 Nyckson, Anthony, of Tamworth, Warks, chapman 0
3955275 2008913 2008913 defendant Dymmok John fisher 594056 594056 Dymmok, John, of Tamworth, Warks, fisher 0
3962979 2011649 2011649 defendant Dymocke John yeoman 594056 594056 Dymocke, John, of Tamworth, Warks, yeoman 0
4007736 2027551 2027551 defendant Badesley John yeoman 594056 594056 Badesley, John, of Tamworth, Warks, yeoman 2
4007747 2027555 2027555 defendant Harcott Walter gent 594056 594056 Harcott, Walter, of Tamworth, Warks, gent 0
4075170 2051423 2051423 defendant Weston Christopher yeoman 594056 594056 Weston, Christopher, of Tamworth, Warks, yeoman 0
4105075 2062088 2062088 defendant Fulwood Richard gent 594056 594056 Fulwood, Richard, of Tamworth, Warks, gent 1
4147799 2077370 2077370 defendant Wright Thomas baker 594056 594056 Wright, Thomas, of Tamworth, Warks, baker 0
4166588 2083810 2083810 defendant Stokys John, senior shoemaker 594056 594056 Stokys, John, senior, of Tamworth, Warks, shoemaker 0
4222326 2103298 2103298 defendant Baron Thomas draper 594056 594056 Baron, Thomas, of Tamworth, Warks, draper 2
4243897 2110938 2110938 defendant Wolfreston Herseus gent 594056 594056 Wolfreston, Herseus, of Tamworth, Warks, gent 3
4286384 2125171 2125171 defendant Wolfreston Herseys gent 594056 594056 Wolfreston, Herseys, of Tamworth, Warks, gent 1
4307540 2132774 2132774 defendant Ichymore William gent 594056 594056 Ichymore, William, of Tamworth, Warks, gent 1
4337160 2142724 2142724 defendant Wilkinson John gent 594056 594056 Wilkinson, John, of Tamworth, Warks, gent 1
4779682 2289633 2289633 defendant Bate Robert yeoman 594056 594056 Bate, Robert, of Tamworth, Warks, yeoman 0
4779686 2289634 2289634 defendant Bate Robert yeoman 594056 594056 Bate, Robert, of Tamworth, Warks, yeoman 0
4859668 2314397 2314397 defendant Byker William cutler 594056 594056 Byker, William, of Tamworth, Warks, cutler 0
4895419 2325230 2325230 defendant Dyker William cutler 594056 594056 Dyker, William, of Tamworth, Warks, cutler 2
4901642 2327116 2327116 defendant Dakton William chapman 594056 594056 Dakton, William, of Tamworth, Warks, chapman 3
5028248 2365138 2365138 defendant Jacob Humphrey gent 594056 594056 Jacob, Humphrey, of Tamworth, Warks, gent 1
5060002 2374555 2374555 defendant Ferrers Thomas, senior esq 594056 594056 Ferrers, Thomas, senior, of Tamworth, Warks, esq 0
5075857 2379269 2379269 defendant Crumwell Thomas walker 594056 594056 Crumwell, Thomas, of Tamworth, Warks, walker 0
5261768 2433790 2433790 defendant Wryght John chaplain 594056 594056 Wryght, John, of Tamworth, Warks, chaplain 1
5278146 2438701 2438701 defendant Wodshawe Thomas grasier 594056 594056 Wodshawe, Thomas, of Tamworth, Warks, grasier 1
5282103 2439839 2439839 defendant Brokes William   594056 594056 Brokes, William, of Tamworth, Warks, gold beater 0
5329101 2453784 2453784 defendant Shipherd Robert yeoman 594056 594056 Shipherd, Robert, of Tamworth, Warks, yeoman 1
5329935 2454027 2454027 defendant Reynold William yeoman 594056 594056 Reynold, William, of Tamworth, Warks, yeoman 1
5329938 2454028 2454028 defendant Reynold William yeoman 594056 594056 Reynold, William, of Tamworth, Warks, yeoman 1
5330102 2454079 2454079 defendant Overton William yeoman 594056 594056 Overton, William, of Tamworth, Warks, yeoman 1
5331696 2454568 2454568 defendant Baale Richard yeoman 594056 594056 Baale, Richard, of Tamworth, Warks, yeoman 1
5337337 2456238 2456238 defendant Hayward Richard dyer 594056 594056 Hayward, Richard, of Tamworth, Warks, dyer 1
5347130 2459261 2459261 defendant Byrmyngham William mercer 594056 594056 Byrmyngham, William, of Tamworth, Warks, mercer 0
5520184 2511134 2511134 defendant Ferrers Leonard gent 594056 594056 Ferrers, Leonard, of Tamworth, Warks, gent 0
5529285 2513674 2513674 defendant Ferrers Roger gent 594056 594056 Ferrers, Roger, of Tamworth, Warks, gent 0
5529288 2513675 2513675 defendant Ferrers Roger gent 594056 594056 Ferrers, Roger, of Tamworth, Warks, gent 0
5543432 2518064 2518064 defendant Ferrers Roger gent 594056 594056 Ferrers, Roger, of Tamworth, Warks, gent 0
5557796 2522232 2522232 defendant Meyre Ralph draper 594056 594056 Meyre, Ralph, of Tamworth, Warks, draper 1
5576758 2527776 2527776 defendant Ferrers John   594056 594056 Ferrers, John, of Tamworth, Warks, knight 0
5576763 2527777 2527777 defendant Ferrers John   594056 594056 Ferrers, John, of Tamworth, Warks, knight 0
5597043 2533987 2533987 defendant Mason Thomas fuller 594056 594056 Mason, Thomas, of Tamworth, Warks, fuller 0
5597379 2534085 2534085 defendant Ferrers John   594056 594056 Ferrers, John, of Tamworth, Warks, knight 0
5599215 2534635 2534635 defendant Wistowe John gent 594056 594056 Wistowe, John, of Tamworth, Warks, gent 0
5633263 2554407 2554407 defendant Purdon John yeoman 594056 594056 Purdon, John, of Tamworth, Warks, 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);