names

53 rows where place_id = 645251

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3884678 1985150 1985150 defendant Phelypp Henry Lewis John husbandman 645251 645251 Phelypp, Henry Lewis John, of Clodocke, husbandman 1
3884679 1985150 1985150 defendant Sadler John tiler 645251 645251 Sadler, John, of Clodocke, tiler 2
4073754 2050905 2050905 defendant Lewis Henry yeoman 645251 645251 Lewis, Henry, of Clodocke, yeoman 1
4091504 2057252 2057252 defendant Lewys Howell weaver 645251 645251 Lewys, Howell, of Clodocke, weaver 0
4100245 2060422 2060422 defendant Lewys Richard Harry yeoman 645251 645251 Lewys, Richard Harry, of Clodocke, yeoman 0
4107925 2063108 2063108 defendant Brasse Robert yeoman 645251 645251 Brasse, Robert, of Clodocke, yeoman 3
4152035 2078824 2078824 defendant John Thomas Philip yeoman 645251 645251 John, Thomas Philip, of Clodocke, yeoman 2
4152039 2078825 2078825 defendant John Thomas Philip yeoman 645251 645251 John, Thomas Philip, of Clodocke, yeoman 2
4155490 2080006 2080006 defendant Stompe Thomas ap Howell yeoman 645251 645251 Stompe, Thomas ap Howell, of Clodocke, yeoman 0
4155491 2080006 2080006 defendant Thomas Richard yeoman 645251 645251 Thomas, Richard, of Clodocke, yeoman 1
4155492 2080006 2080006 defendant verch Thomas Anne spinster 645251 645251 verch Thomas, Anne, of Clodocke, spinster 2
4155493 2080006 2080006 defendant Apowell Morgan Thomas yeoman 645251 645251 Apowell, Morgan Thomas, of Clodocke, yeoman 3
4157344 2080635 2080635 defendant Thomas Anthony tucker 645251 645251 Thomas, Anthony, of Clodocke, tucker 0
4160495 2081744 2081744 defendant verch Richard Joan widow 645251 645251 verch Richard, Joan, of Clodocke, widow 0
4165398 2083403 2083403 defendant ap Richard David butcher 645251 645251 ap Richard, David, of Clodocke, butcher 2
4167508 2084131 2084131 defendant vergh John Katherine widow 645251 645251 vergh John, Katherine, of Clodocke, widow 3
4167864 2084246 2084246 defendant James Thomas gent 645251 645251 James, Thomas, of Clodocke, gent 3
4179651 2088356 2088356 defendant Maddock Joan John spinster 645251 645251 Maddock, Joan John, of Clodocke, spinster 2
4179652 2088356 2088356 defendant ap John John Thomas husbandman 645251 645251 ap John, John Thomas, of Clodocke, husbandman 3
4179664 2088361 2088361 defendant Madocke Richard John husbandman 645251 645251 Madocke, Richard John, of Clodocke, husbandman 0
4179665 2088361 2088361 defendant Madocke Philip John husbandman 645251 645251 Madocke, Philip John, of Clodocke, husbandman 1
4179666 2088361 2088361 defendant Madocke Joan John spinster 645251 645251 Madocke, Joan John, of Clodocke, spinster 2
4179667 2088361 2088361 defendant John John Thomas husbandman 645251 645251 John, John Thomas, of Clodocke, husbandman 3
4179671 2088363 2088363 defendant Mason alias Butcher David butcher 645251 645251 Mason alias Butcher, David, of Clodocke, butcher 0
4183354 2089662 2089662 defendant Lewys David Harry yeoman 645251 645251 Lewys, David Harry, of Clodocke, yeoman 1
4183890 2089859 2089859 defendant vergh Cicill alias Morgan Maud widow 645251 645251 vergh Cicill alias Morgan, Maud, of Clodocke, widow 1
4183893 2089860 2089860 defendant vergh Cycill alias Morgan Maud widow 645251 645251 vergh Cycill alias Morgan, Maud, of Clodocke, widow 1
4219524 2102330 2102330 defendant Harry Philip yeoman 645251 645251 Harry, Philip, of Clodocke, yeoman 0
4229297 2105728 2105728 defendant Powell Griffin Harry yeoman 645251 645251 Powell, Griffin Harry, of Clodocke, yeoman 0
4229299 2105728 2105728 defendant Probert Simon Rice David yeoman 645251 645251 Probert, Simon Rice David, of Clodocke, yeoman 2
4236681 2108404 2108404 defendant Hughe Simon yeoman 645251 645251 Hughe, Simon, of Clodocke, yeoman 0
4237862 2108845 2108845 defendant Myle Richard yeoman 645251 645251 Myle, Richard, of Clodocke, yeoman 3
4245645 2111524 2111524 defendant Morgan Genry David yeoman 645251 645251 Morgan, Genry David, of Clodocke, yeoman 0
4295934 2128643 2128643 defendant Morgan Richard yeoman 645251 645251 Morgan, Richard, of Clodocke, yeoman 0
4298130 2129434 2129434 defendant Griffith Henry gent 645251 645251 Griffith, Henry, of Clodocke, gent 2
4304417 2131682 2131682 defendant Morgan Richard yeoman 645251 645251 Morgan, Richard, of Clodocke, yeoman 0
4306234 2132317 2132317 defendant Jenkyn John yeoman 645251 645251 Jenkyn, John, of Clodocke, yeoman 1
4306235 2132317 2132317 defendant Morgan John yeoman 645251 645251 Morgan, John, of Clodocke, yeoman 2
4321461 2137597 2137597 defendant ap Richard John Thomas yeoman 645251 645251 ap Richard, John Thomas, of Clodocke, yeoman 1
4334391 2141780 2141780 defendant Prees Henry William yeoman 645251 645251 Prees, Henry William, of Clodocke, yeoman 1
4377628 2157076 2157076 defendant ap Price Philip John yeoman 645251 645251 ap Price, Philip John, of Clodocke, yeoman 1
4379174 2157634 2157634 defendant Powell David husbandman 645251 645251 Powell, David, of Clodocke, husbandman 0
4379175 2157634 2157634 defendant Phillippe alias Smythe Howell smith 645251 645251 Phillippe alias Smythe, Howell, of Clodocke, smith 1
4383141 2159078 2159078 defendant ap John John yeoman 645251 645251 ap John, John, of Clodocke, yeoman 0
4383143 2159079 2159079 defendant ap John John yeoman 645251 645251 ap John, John, of Clodocke, yeoman 0
4399852 2164539 2164539 defendant Thomas Simon John yeoman 645251 645251 Thomas, Simon John, of Clodocke, yeoman 0
4401437 2165075 2165075 defendant Scudamore John Richard laborer 645251 645251 Scudamore, John Richard, of Clodocke, laborer 0
4403016 2165596 2165596 defendant Gillam or Gwillime William Philip   645251 645251 Gillam or Gwillime, William Philip, of Clodocke yeoman 1
4403947 2165890 2165890 defendant Thomas Thomas John yeoman 645251 645251 Thomas, Thomas John, of Clodocke, yeoman 0
4403948 2165890 2165890 defendant Trehern Rice yeoman 645251 645251 Trehern, Rice, of Clodocke, yeoman 1
4411853 2168556 2168556 defendant Harry John Griffith yeoman 645251 645251 Harry, John Griffith, of Clodocke, yeoman 0
4411895 2168571 2168571 defendant Morgan Watkin yeoman 645251 645251 Morgan, Watkin, of Clodocke, yeoman 0
4411897 2168572 2168572 defendant Morgan John yeoman 645251 645251 Morgan, John, of Clodocke, yeoman 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);