names

46 rows where place_id = 588555

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594919 1866039 1866039 defendant Gravell or Granell James husbandman 588555 588555 Gravell or Granell, James, of Bradwardyn, husbandman 0
3647294 1909537 1909537 defendant Lloyd John husbandman 588555 588555 Lloyd, John, of Bradwardyn, husbandman 4
3653775 1911439 1911439 defendant ap Richard John David husbandman 588555 588555 ap Richard, John David, of Bradwardyn, husbandman 3
3667938 1915912 1915912 defendant ap Richard David husbandman 588555 588555 ap Richard, David, of Bradwardyn, husbandman 1
3667939 1915912 1915912 defendant Lluwellen Richard husbandman 588555 588555 Lluwellen, Richard, of Bradwardyn, husbandman 2
3684960 1921430 1921430 defendant Teowe Richard husbandman 588555 588555 Teowe, Richard, of Bradwardyn, husbandman 0
3712051 1930089 1930089 defendant Tewe Richard husbandman 588555 588555 Tewe, Richard, of Bradwardyn, husbandman 3
3718748 1932142 1932142 defendant Vaughan Richard   588555 588555 Vaughan, Richard, of Bradwardyn, knight 0
3728642 1935196 1935196 defendant Tewe Thomas husbandman 588555 588555 Tewe, Thomas, of Bradwardyn, husbandman 0
3749140 1941661 1941661 defendant James Thomas yeoman 588555 588555 James, Thomas, of Bradwardyn, yeoman 0
3749142 1941662 1941662 defendant James Thomas yeoman 588555 588555 James, Thomas, of Bradwardyn, yeoman 0
3749144 1941662 1941662 defendant ap Morgan Jenn laborer 588555 588555 ap Morgan, Jenn, of Bradwardyn, laborer 2
3749145 1941662 1941662 defendant Turnor Henry laborer 588555 588555 Turnor, Henry, of Bradwardyn, laborer 3
3749146 1941662 1941662 defendant ap Jenn Walter laborer 588555 588555 ap Jenn, Walter, of Bradwardyn, laborer 4
3763805 1946325 1946325 defendant James Thomas yeoman 588555 588555 James, Thomas, of Bradwardyn, yeoman 0
3763807 1946325 1946325 defendant ap Morgan Jenn laborer 588555 588555 ap Morgan, Jenn, of Bradwardyn, laborer 2
3763808 1946325 1946325 defendant Turnor Henry laborer 588555 588555 Turnor, Henry, of Bradwardyn, laborer 3
3763809 1946325 1946325 defendant ap Jenn Walter laborer 588555 588555 ap Jenn, Walter, of Bradwardyn, laborer 4
3763812 1946326 1946326 defendant ap Morgan Jenn laborer 588555 588555 ap Morgan, Jenn, of Bradwardyn, laborer 1
3763813 1946326 1946326 defendant Turnor Henry laborer 588555 588555 Turnor, Henry, of Bradwardyn, laborer 2
3763814 1946326 1946326 defendant ap Jenn Walter laborer 588555 588555 ap Jenn, Walter, of Bradwardyn, laborer 3
3806599 1959964 1959964 defendant Molde John chaplain 588555 588555 Molde, John, of Bradwardyn, chaplain 1
3829137 1966994 1966994 defendant Vaughan Walter esq 588555 588555 Vaughan, Walter, of Bradwardyn, esq 0
3830881 1967541 1967541 defendant Jamys Thomas yeoman 588555 588555 Jamys, Thomas, of Bradwardyn, yeoman 0
3830886 1967542 1967542 defendant Mold John clerk 588555 588555 Mold, John, of Bradwardyn, clerk 1
3839300 1970219 1970219 defendant Jamys Thomas husbandman 588555 588555 Jamys, Thomas, of Bradwardyn, husbandman 2
3858250 1976236 1976236 defendant Adams Thomas yeoman 588555 588555 Adams, Thomas, of Bradwardyn, yeoman 0
3885372 1985364 1985364 defendant Tewe James chaplain 588555 588555 Tewe, James, of Bradwardyn, chaplain 0
3896122 1988907 1988907 defendant Tewe Richard husbandman 588555 588555 Tewe, Richard, of Bradwardyn, husbandman 0
3896123 1988907 1988907 defendant ap Thomas John husbandman 588555 588555 ap Thomas, John, of Bradwardyn, husbandman 1
3899150 1989922 1989922 defendant Tewe James clerk 588555 588555 Tewe, James, of Bradwardyn, clerk 1
3925200 1998739 1998739 defendant ap Rychard Thomas husbandman 588555 588555 ap Rychard, Thomas, of Bradwardyn, husbandman 0
4022951 2032928 2032928 plaintiff Baker John yeoman 588555 588555 Baker, John, of Bradwardyn, yeoman 0
4059064 2045638 2045638 defendant Coode John husbandman 588555 588555 Coode, John, of Bradwardyn, husbandman 1
4451891 2185570 2185570 defendant Waghan Roger   588555 588555 Waghan, Roger, of Bradwardyn 0
5115169 2390858 2390858 defendant Hancok William husbandman 588555 588555 Hancok, William, of Bradwardyn, husbandman 3
5214928 2420088 2420088 defendant Scudamore Richard gent 588555 588555 Scudamore, Richard, of Bradwardyn, gent 0
5214929 2420088 2420088 defendant Molle Thomas yeoman 588555 588555 Molle, Thomas, of Bradwardyn, yeoman 1
5394648 2473531 2473531 defendant Wallewen John gent 588555 588555 Wallewen, John, of Bradwardyn, gent 0
5581920 2529427 2529427 defendant Tewe Richard yeoman 588555 588555 Tewe, Richard, of Bradwardyn, yeoman 1
5584299 2530157 2530157 defendant Vaughan Richard gent 588555 588555 Vaughan, Richard, of Bradwardyn, gent 0
5584300 2530157 2530157 defendant Tewe Hugh yeoman 588555 588555 Tewe, Hugh, of Bradwardyn, yeoman 1
5592329 2532589 2532589 defendant Tewe Hugh yeoman 588555 588555 Tewe, Hugh, of Bradwardyn, yeoman 1
5593273 2532878 2532878 defendant ap Owen David husbandman 588555 588555 ap Owen, David, of Bradwardyn, husbandman 0
5593274 2532878 2532878 defendant Davy James butcher 588555 588555 Davy, James, of Bradwardyn, butcher 1
5593279 2532879 2532879 defendant Tewe Thomas butcher 588555 588555 Tewe, Thomas, of Bradwardyn, butcher 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);