names

120 rows where place_id = 640711

✎ 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
3857047 1975837 1975837 defendant Conwaye Henry chapman 640711 640711 Conwaye, Henry, of Denbigh, chapman 1
3882691 1984477 1984477 defendant Fletcher Robert mercer 640711 640711 Fletcher, Robert, of Denbigh, mercer 1
3889111 1986596 1986596 defendant Rutter Fulk chapman 640711 640711 Rutter, Fulk, of Denbigh, chapman 2
3889112 1986596 1986596 defendant Knowesley Robert yeoman 640711 640711 Knowesley, Robert, of Denbigh, yeoman 3
3889113 1986596 1986596 defendant Wynwey William yeoman 640711 640711 Wynwey, William, of Denbigh, yeoman 4
3891468 1987414 1987414 defendant Flecher Robert yeoman 640711 640711 Flecher, Robert, of Denbigh, yeoman 0
3903215 1991300 1991300 defendant Reynold Fulk chapman 640711 640711 Reynold, Fulk, of Denbigh, chapman 1
3903216 1991300 1991300 defendant Pigott John gent 640711 640711 Pigott, John, of Denbigh, gent 2
3915099 1995406 1995406 defendant Henbury Thomas yeoman 640711 640711 Henbury, Thomas, of Denbigh, yeoman 1
3930364 2000501 2000501 defendant Latham John chapman 640711 640711 Latham, John, of Denbigh, Denbighs, chapman 1
3934406 2001800 2001800 defendant Floyde Richard chapman 640711 640711 Floyde, Richard, of Denbigh, chapman 3
3942243 2004420 2004420 defendant Lathumme John mercer 640711 640711 Lathumme, John, of Denbigh, mercer 3
3942249 2004421 2004421 defendant Lathmune John mercer 640711 640711 Lathmune, John, of Denbigh, mercer 3
3945174 2005407 2005407 defendant Lowe Francis esq 640711 640711 Lowe, Francis, of Denbigh, esq 0
3945175 2005407 2005407 defendant Lowe George gent 640711 640711 together with Lowe, George, of Denbigh, gent 1
3945176 2005407 2005407 defendant Staley William yeoman 640711 640711 Staley, William, of Denbigh, yeoman 2
3945177 2005407 2005407 defendant Grenewood Robert yeoman 640711 640711 Grenewood, Robert, of Denbigh, yeoman 3
3945178 2005407 2005407 defendant Garratt Edward yeoman 640711 640711 Garratt, Edward, of Denbigh, yeoman 4
3945179 2005407 2005407 defendant Smythe Robert yeoman 640711 640711 Smythe, Robert, of Denbigh, yeoman 5
3945180 2005407 2005407 defendant Homage Nicholas yeoman 640711 640711 Homage, Nicholas, of Denbigh, yeoman 6
3945181 2005407 2005407 defendant Fletcher William yeoman 640711 640711 Fletcher, William, of Denbigh, yeoman 7
3945182 2005407 2005407 defendant Belsor Henry yeoman 640711 640711 Belsor, Henry, of Denbigh, yeoman 8
3945183 2005407 2005407 defendant Nayler John laborer 640711 640711 Nayler, John, of Denbigh, laborer 9
3945184 2005407 2005407 defendant Dyconson Thomas yeoman 640711 640711 Dyconson, Thomas, of Denbigh, yeoman 10
3945185 2005407 2005407 defendant Gybson Thomas yeoman 640711 640711 Gybson, Thomas, of Denbigh, yeoman 11
3945187 2005408 2005408 defendant Lowe George gent 640711 640711 Lowe, George, of Denbigh, gent 0
3945188 2005408 2005408 defendant Staley William   640711 640711 Staley, William, of Denbigh yeoman 1
3945198 2005408 2005408 defendant Lowe Francis esq 640711 640711 together with Lowe, Francis, of Denbigh, esq 11
3945200 2005409 2005409 defendant Lowe Francis esq 640711 640711 Lowe, Francis, of Denbigh, esq 0
3945201 2005409 2005409 defendant Lowe George gent 640711 640711 Lowe, George, of Denbigh, gent 1
3945202 2005409 2005409 defendant Staley William yeoman 640711 640711 Staley, William, of Denbigh, yeoman 2
3945203 2005409 2005409 defendant Grenewood Robert yeoman 640711 640711 Grenewood, Robert, of Denbigh, yeoman 3
3945204 2005409 2005409 defendant Garrat Edward yeoman 640711 640711 Garrat, Edward, of Denbigh, yeoman 4
3945205 2005409 2005409 defendant Smyth Robert yeoman 640711 640711 Smyth, Robert, of Denbigh, yeoman 5
3945206 2005409 2005409 defendant Homage Nicholas yeoman 640711 640711 Homage, Nicholas, of Denbigh, yeoman 6
3945207 2005409 2005409 defendant Fletcher William yeoman 640711 640711 Fletcher, William, of Denbigh, yeoman 7
3945208 2005409 2005409 defendant Belser Henry yeoman 640711 640711 Belser, Henry, of Denbigh, yeoman 8
3945209 2005409 2005409 defendant Nayler John laborer 640711 640711 Nayler, John, of Denbigh, laborer 9
3945210 2005409 2005409 defendant Dyconson Thomas yeoman 640711 640711 Dyconson, Thomas, of Denbigh, yeoman 10
3945211 2005409 2005409 defendant Gybson Thomas yeoman 640711 640711 Gybson, Thomas, of Denbigh, yeoman 11
3961039 2010955 2010955 defendant Martyn Henry chapman 640711 640711 Martyn, Henry, of Denbigh, chapman 1
3973423 2015276 2015276 defendant Vaughan Owen gent 640711 640711 Vaughan, Owen, of Denbigh, gent 1
3974066 2015498 2015498 defendant Dryhurst Richard gent 640711 640711 Dryhurst, Richard, of Denbigh, gent 0
3974067 2015498 2015498 defendant Salesburye John   640711 640711 Salesburye, John, of Denbigh, knight 1
3981840 2018262 2018262 defendant Lowe Francis (legal representative) 640711 640711 Lowe, Francis, of Denbigh, gent, administrator of 0
3994663 2022844 2022844 defendant Fletcher Roger gent 640711 640711 Fletcher, Roger, of Denbigh, gent 0
3994665 2022845 2022845 defendant Salisbury Thomas gent 640711 640711 Salisbury, Thomas, of Denbigh, gent 0
3994681 2022850 2022850 defendant Lachom Robert chapman 640711 640711 Lachom, Robert, of Denbigh, chapman 0
3994685 2022851 2022851 defendant Lathom Robert chapman 640711 640711 Lathom, Robert, of Denbigh, chapman 0
4022422 2032745 2032745 plaintiff ap William John Wyn esq 640711 640711 ap William, John Wyn, of Denbigh, esq 0
4037091 2037929 2037929 defendant Burchynshawe Thomas gent 640711 640711 Burchynshawe, Thomas, of Denbigh, gent 2
4038944 2038550 2038550 plaintiff Lloyd David   640711 640711 Lloyd, David, of Denbigh 0
4046512 2041203 2041203 plaintiff Smyth Fulk gent 640711 640711 Smyth, Fulk, of Denbigh, gent 0
4046514 2041203 2041203 defendant Dryhurst John gent 640711 640711 Dryhurst, John, of Denbigh, gent 1
4046686 2041268 2041268 plaintiff Smythe Fulk gent 640711 640711 Smythe, Fulk, of Denbigh, gent 0
4046688 2041268 2041268 defendant Dryhurst John gent 640711 640711 Dryhurst, John, of Denbigh, gent 1
4048740 2041996 2041996 defendant Burchynshawe or Burtynshawe Thomas yeoman 640711 640711 Burchynshawe or Burtynshawe, Thomas, of Denbigh, yeoman 0
4077214 2052135 2052135 defendant Lloyd Henry chapman 640711 640711 Lloyd, Henry, of Denbigh, chapman 0
4083086 2054244 2054244 defendant Drihurst John gent 640711 640711 Drihurst, John, of Denbigh, gent 1
4089435 2056507 2056507 defendant Rutter Henry glover 640711 640711 Rutter, Henry, of Denbigh, glover 1
4099287 2060070 2060070 defendant Lloyde John mercer 640711 640711 Lloyde, John, of Denbigh, mercer 0
4102030 2061035 2061035 defendant Mathewe John goldsmith 640711 640711 Mathewe, John, of Denbigh, goldsmith 1
4110093 2063874 2063874 defendant Mathewe John chapman 640711 640711 Mathewe, John, of Denbigh, chapman 1
4110099 2063875 2063875 defendant Merton Henry mercer 640711 640711 Merton, Henry, of Denbigh, mercer 0
4113057 2064936 2064936 defendant Wynwey Robert saddler 640711 640711 Wynwey, Robert, of Denbigh, saddler 0
4113058 2064936 2064936 defendant ap Robert John Griffith saddler 640711 640711 ap Robert, John Griffith, of Denbigh, saddler 1
4113059 2064936 2064936 defendant Marten Richard saddler 640711 640711 Marten, Richard, of Denbigh, saddler 2
4123589 2068738 2068738 defendant Chaloner John gent 640711 640711 Chaloner, John, of Denbigh, gent 2
4128026 2070312 2070312 defendant Lloyd Hugh gent 640711 640711 (Lloyd, Hugh, of Denbigh, gent 2
4139902 2074638 2074638 defendant Salesbury Thomas esq 640711 640711 Salesbury, Thomas, of Denbigh, esq 3
4146917 2077073 2077073 defendant Cloughe Hugh chapman 640711 640711 Cloughe, Hugh, of Denbigh, chapman 2
4146920 2077074 2077074 defendant Huxley Robert chapman 640711 640711 Huxley, Robert, of Denbigh, chapman 1
4146921 2077074 2077074 defendant Lloyd John gent 640711 640711 Lloyd, John, of Denbigh, gent 2
4148977 2077762 2077762 defendant Latham Robert gent 640711 640711 Latham, Robert, of Denbigh, gent 0
4186694 2090835 2090835 defendant Huxley Edmund mercer 640711 640711 Huxley, Edmund, of Denbigh, mercer 0
4191286 2092517 2092517 defendant Clowghe Humphrey mercer 640711 640711 Clowghe, Humphrey, of Denbigh, mercer 1
4193931 2093439 2093439 defendant Lloyd Robert mercer 640711 640711 Lloyd, Robert, of Denbigh, mercer 0
4197160 2094557 2094557 defendant Latham Robert gent 640711 640711 Latham, Robert, of Denbigh, gent 0
4197215 2094576 2094576 defendant Latham Robert gent 640711 640711 Latham, Robert, of Denbigh, gent 0
4200528 2095746 2095746 defendant Salsbury George gent 640711 640711 Salsbury, George, of Denbigh, gent 0
4204203 2097021 2097021 defendant Patton Fulk   640711 640711 Patton, Fulk, of Denbigh, glover, administrators of 0
4204205 2097021 2097021 defendant Patton Agnes widow 640711 640711 Patton, Agnes, of Denbigh, widow 2
4210507 2099230 2099230 defendant Lloyde Hugh gent 640711 640711 Lloyde, Hugh, of Denbigh, gent 2
4212408 2099888 2099888 defendant Lloid Thomas chapman 640711 640711 Lloid, Thomas, of Denbigh, chapman 1
4212409 2099888 2099888 defendant Lloide Hugh gent 640711 640711 Lloide, Hugh, of Denbigh, gent 2
4246881 2111932 2111932 defendant Brihurste John gent 640711 640711 Brihurste, John, of Denbigh, gent 0
4249419 2112792 2112792 defendant Williams Richard chapman 640711 640711 Williams, Richard, of Denbigh, chapman 1
4249423 2112793 2112793 defendant Barker William chapman 640711 640711 Barker, William, of Denbigh, chapman 2
4249427 2112794 2112794 defendant Barker William chapman 640711 640711 Barker, William, of Denbigh, chapman 2
4249430 2112795 2112795 defendant Williams Richard chapman 640711 640711 Williams, Richard, of Denbigh, chapman 1
4252291 2113758 2113758 defendant Rosyndall alias Lloyd Thomas mercer 640711 640711 Rosyndall alias Lloyd, Thomas, of Denbigh, mercer 1
4252292 2113758 2113758 defendant Williams Richard merchant 640711 640711 Williams, Richard, of Denbigh, merchant 2
4262198 2117029 2117029 defendant Williams Richard chapman 640711 640711 Williams, Richard, of Denbigh, chapman 0
4265987 2118263 2118263 defendant Rosyndall alias Lloyd Thomas mercer 640711 640711 Rosyndall alias Lloyd, Thomas, of Denbigh, mercer 1
4265988 2118263 2118263 defendant Williams Richard merchant 640711 640711 Williams, Richard, of Denbigh, merchant 2
4273047 2120546 2120546 defendant Willyams Richard chapman 640711 640711 Willyams, Richard, of Denbigh, chapman 0
4289817 2126420 2126420 defendant Salesbury Thomas esq 640711 640711 Salesbury, Thomas, of Denbigh, esq 0
4302941 2131151 2131151 defendant Lloyd Robert chapman 640711 640711 Lloyd, Robert, of Denbigh, chapman 0
4314682 2135250 2135250 defendant Salsbury Thomas esq 640711 640711 Salsbury, Thomas, of Denbigh, esq 1
4324187 2138493 2138493 defendant Davyes John clerk 640711 640711 Davyes, John, of Denbigh, clerk 0

Next page

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