names

47 rows where place_id = 659188

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3941336 2004109 2004109 plaintiff Trevour Robert esq 659188 659188 Trevour, Robert, of Wrexham, Denbighs, esq 0
3951442 2007565 2007565 defendant David David ap hugh tanner 659188 659188 David, David ap hugh, of Wrexham, Denbigh, tanner 2
3955941 2009147 2009147 defendant ap Robertys Hugh mercer 659188 659188 ap Robertys, Hugh, of Wrexham, Denbigh, mercer 0
3958739 2010132 2010132 defendant Robert Hugh mercer 659188 659188 Robert, Hugh, of Wrexham, Denbigh, mercer 0
3961038 2010955 2010955 defendant Gyttens Francis clothier 659188 659188 Gyttens, Francis, of Wrexham, Denbigh, clothier 0
3961048 2010958 2010958 defendant Robert Hugh chapman 659188 659188 Robert, Hugh, of Wrexham, Denbigh, chapman 0
3976112 2016213 2016213 defendant Tegyn Richard esq 659188 659188 Tegyn, Richard, of Wrexham, Denbigh, esq 2
3988462 2020617 2020617 defendant Erwathe Hugh ap John gent 659188 659188 Erwathe, Hugh ap John, of Wrexham, Denbigh, gent 1
3997573 2023880 2023880 defendant Pilleston John esq 659188 659188 Pilleston, John, of Wrexham, Denbigh, esq 0
4006686 2027170 2027170 defendant Tudder Elias gent 659188 659188 Tudder, Elias, of Wrexham, Denbigh, gent 3
4009743 2028252 2028252 defendant Puleston John esq 659188 659188 Puleston, John, of Wrexham, Denbigh, esq 0
4022283 2032693 2032693 defendant Puleston John esq 659188 659188 Puleston, John, of Wrexham, Denbigh, esq 0
4022289 2032694 2032694 defendant Puleston John esq 659188 659188 Puleston, John, of Wrexham, Denbigh, esq 0
4055977 2044517 2044517 defendant ap Thomas John yeoman 659188 659188 ap Thomas, John, of Wrexham, Denbigh, yeoman 0
4066595 2048348 2048348 defendant Stoneley Blanche widow 659188 659188 Stoneley, Blanche, of Wrexham, Denbigh, widow 1
4067878 2048821 2048821 defendant Edwardes David mercer 659188 659188 Edwardes, David, of Wrexham, Denbigh, mercer 1
4089863 2056663 2056663 defendant Hughe John ap John gent 659188 659188 Hughe, John ap John, of Wrexham, Denbigh, gent 0
4104065 2061728 2061728 defendant Edward David   659188 659188 Edward, David, of Wrexham, Denbigh, mercer son of Edward ap David ap Robert ap Jenkyn, of Stansty, Denbigh, franklin 0
4104097 2061740 2061740 defendant ap Tona Robert ap David ap John yeoman 659188 659188 (ap Tona, Robert ap David ap John, of Wrexham, Denbigh, yeoman 1
4118015 2066727 2066727 defendant Colyngborn Moses gent 659188 659188 Colyngborn, Moses, of Wrexham, Denbigh, gent 1
4136694 2073468 2073468 defendant ap David Hugh ap John butcher 659188 659188 ap David, Hugh ap John, of Wrexham, Denbigh, butcher 0
4136700 2073471 2073471 defendant Puleston Edward gent 659188 659188 Puleston, Edward, of Wrexham, Denbigh, gent 0
4136702 2073472 2073472 defendant Puleston Edward gent 659188 659188 Puleston, Edward, of Wrexham, Denbigh, gent 0
4136704 2073473 2073473 defendant Puleston Edward gent 659188 659188 Puleston, Edward, of Wrexham, Denbigh, gent 0
4141502 2075191 2075191 defendant ap Wylliam John ap Wynn yeoman 659188 659188 ap Wylliam, John ap Wynn, of Wrexham, Denbigh, yeoman 0
4156304 2080277 2080277 defendant ap Jevan John ap John yeoman 659188 659188 ap Jevan, John ap John, of Wrexham, Denbigh, yeoman 2
4160991 2081918 2081918 defendant Puleston Edward gent 659188 659188 Puleston, Edward, of Wrexham, Denbigh, gent 0
4166416 2083754 2083754 defendant ap William John Wynne yeoman 659188 659188 ap William, John Wynne, of Wrexham, Denbigh, yeoman 0
4167392 2084096 2084096 defendant David Hugh yeoman or franklin 659188 659188 David, Hugh, of Wrexham, Denbigh, yeoman or franklin 0
4191291 2092519 2092519 defendant Robert Hugh mercer 659188 659188 Robert, Hugh, of Wrexham, Denbigh, mercer 0
4207571 2098208 2098208 defendant Edward William gent 659188 659188 Edward, William, of Wrexham, Denbigh, gent 0
4248563 2112506 2112506 defendant Tayler John gent 659188 659188 Tayler, John, of Wrexham, Denbigh, gent 1
4249112 2112687 2112687 defendant ap Richard alias Tomlynson William cooper 659188 659188 ap Richard alias Tomlynson, William, of Wrexham, Denbigh, cooper 1
4249115 2112688 2112688 defendant ap Richard alias Tomlynson William cooper 659188 659188 ap Richard alias Tomlynson, William, of Wrexham, Denbigh, cooper 1
4263133 2117337 2117337 defendant Johns Hugh yeoman 659188 659188 Johns, Hugh, of Wrexham, Denbigh, yeoman 0
4263138 2117338 2117338 defendant Tayler John gent 659188 659188 Tayler, John, of Wrexham, Denbigh, gent 1
4273799 2120783 2120783 defendant Johns Hugh yeoman 659188 659188 Johns, Hugh, of Wrexham, Denbigh, yeoman 0
4275708 2121449 2121449 defendant Traford Thomas gent 659188 659188 Traford, Thomas, of Wrexham, Denbigh, gent 0
4287923 2125728 2125728 defendant Owen Francis gent 659188 659188 Owen, Francis, of Wrexham, Denbigh, gent 0
4300029 2130108 2130108 defendant Carden John tailor 659188 659188 Carden, John, of Wrexham, Denbigh, tailor 1
4304228 2131614 2131614 defendant Johnes Hugh gent 659188 659188 Johnes, Hugh, of Wrexham, Denbigh, gent 0
4306723 2132490 2132490 defendant Launcelott John gent 659188 659188 Launcelott, John, of Wrexham, Denbigh, gent 0
4307721 2132840 2132840 defendant Stiles William mercer 659188 659188 Stiles, William, of Wrexham, Denbigh, mercer 1
4309120 2133345 2133345 defendant Styles William mercer 659188 659188 Styles, William, of Wrexham, Denbigh, mercer 0
4329045 2140025 2140025 defendant Owen Francis gent 659188 659188 Owen, Francis, of Wrexham, Denbigh, gent 0
4359893 2150702 2150702 defendant Smythe alias Warbetton John vintner 659188 659188 Smythe alias Warbetton, John, of Wrexham, Denbigh, or of Wisbiche, Isle of Ely, Cams, vintner 0
4393697 2162494 2162494 defendant Warburton William gent 659188 659188 Warburton, William, of Wrexham, Denbigh, gent 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);