names

79 rows where place_id = 593739

✎ 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
3613138 1871762 1871762 defendant Tomlyn Philip husbandman 593739 593739 Tomlyn, Philip, of Pencombe, husbandman 0
3675557 1918391 1918391 defendant Heynes John chaplain 593739 593739 Heynes, John, of Pencombe, chaplain 0
3701334 1926661 1926661 defendant Yolveld Thomas husbandman 593739 593739 Yolveld, Thomas, of Pencombe, husbandman 1
3884673 1985148 1985148 defendant Hyll Henry husbandman 593739 593739 Hyll, Henry, of Pencombe, husbandman 0
3897120 1989253 1989253 defendant Craswell Otto yeoman 593739 593739 Craswell, Otto, of Pencombe, yeoman 2
3932835 2001276 2001276 defendant Harys Robert husbandman 593739 593739 Harys, Robert, of Pencombe, husbandman 29
3934940 2001990 2001990 defendant Hyll Henry husbandman 593739 593739 Hyll, Henry, of Pencombe, husbandman 0
3941042 2004007 2004007 defendant Wyllyms Ralph husbandman 593739 593739 Wyllyms, Ralph, of Pencombe, husbandman 0
3985816 2019690 2019690 defendant Gorweye Roger yeoman 593739 593739 Gorweye, Roger, of Pencombe, yeoman 2
4037044 2037913 2037913 defendant Beysye Hugh husbandman 593739 593739 Beysye, Hugh, of Pencombe, husbandman 2
4056184 2044599 2044599 defendant Staple Elizabeth widow 593739 593739 Staple, Elizabeth, of Pencombe, widow 1
4056188 2044600 2044600 defendant Staple Elizabeth widow 593739 593739 Staple, Elizabeth, of Pencombe, widow 1
4057301 2044995 2044995 defendant Wynston Brigit widow 593739 593739 Wynston, Brigit, of Pencombe, widow 0
4095648 2058773 2058773 defendant Spencer Roger husbandman 593739 593739 Spencer, Roger, of Pencombe, husbandman 0
4150386 2078265 2078265 defendant Wynston Bridget widow 593739 593739 Wynston, Bridget, of Pencombe, widow 1
4150396 2078268 2078268 defendant Winston Brigit widow 593739 593739 Winston, Brigit, of Pencombe, widow 1
4159644 2081440 2081440 defendant Beysey Hugh yeoman 593739 593739 Beysey, Hugh, of Pencombe, yeoman 3
4168003 2084295 2084295 defendant Pytt Thomas husbandman 593739 593739 Pytt, Thomas, of Pencombe, husbandman 0
4168004 2084295 2084295 defendant Spencer Hugh weaver 593739 593739 Spencer, Hugh, of Pencombe, weaver 1
4168006 2084296 2084296 defendant Pytt Thomas husbandman 593739 593739 Pytt, Thomas, of Pencombe, husbandman 0
4168007 2084296 2084296 defendant Spencer Hugh weaver 593739 593739 Spencer, Hugh, of Pencombe, weaver 1
4169210 2084735 2084735 defendant Clarke John husbandman 593739 593739 Clarke, John, of Pencombe, husbandman 0
4169211 2084735 2084735 defendant Clarke James husbandman 593739 593739 Clarke, James, of Pencombe, husbandman 1
4214359 2100529 2100529 defendant Clarke John yeoman 593739 593739 Clarke, John, of Pencombe, yeoman 0
4214360 2100529 2100529 defendant Clarke James yeoman 593739 593739 Clarke, James, of Pencombe, yeoman 1
4219157 2102196 2102196 defendant Creswell Richard   593739 593739 Creswell, Richard, of Pencombe gent 1
4223089 2103565 2103565 defendant Nicolls Thomas yeoman 593739 593739 Nicolls, Thomas, of Pencombe, yeoman 0
4224954 2104196 2104196 defendant Nicholls Thomas yeoman 593739 593739 Nicholls, Thomas, of Pencombe, yeoman 1
4231196 2106415 2106415 defendant Nycoll Thomas yeoman 593739 593739 Nycoll, Thomas, of Pencombe, yeoman 0
4244177 2111035 2111035 defendant Maylard Stephen husbandman 593739 593739 Maylard, Stephen, of Pencombe, husbandman 0
4245208 2111382 2111382 defendant Creswell Richard gent 593739 593739 Creswell, Richard, of Pencombe, gent 1
4263653 2117506 2117506 defendant Creswell Richard gent 593739 593739 Creswell, Richard, of Pencombe, or of Marston, Herefs, gent 0
4298163 2129443 2129443 defendant Bowley John, senior yeoman 593739 593739 Bowley, John, senior, of Pencombe, yeoman 0
4298164 2129443 2129443 defendant Bowley John, junior husbandman 593739 593739 Bowley, John, junior, of Pencombe, husbandman 1
4305952 2132220 2132220 defendant Syrell James yeoman 593739 593739 Syrell, James, of Pencombe, yeoman 3
4322954 2138092 2138092 defendant Spencer Roger yeoman 593739 593739 Spencer, Roger, of Pencombe, yeoman 1
4323866 2138395 2138395 defendant Grafton Roger gent 593739 593739 Grafton, Roger, of Pencombe, gent 0
4327611 2139556 2139556 defendant Clarke James yeoman 593739 593739 Clarke, James, of Pencombe, yeoman 3
4371835 2154989 2154989 defendant Creswell Richard gent 593739 593739 Creswell, Richard, of Pencombe, gent 0
4377645 2157079 2157079 defendant Spencer Hugh yeoman 593739 593739 Spencer, Hugh, of Pencombe, yeoman 3
4380868 2158273 2158273 defendant Nicolls Thomas, senior yeoman 593739 593739 Nicolls, Thomas, senior, of Pencombe, yeoman 0
4380870 2158274 2158274 defendant Nicols Thomas, junior yeoman 593739 593739 Nicols, Thomas, junior, of Pencombe, yeoman 0
4386114 2160038 2160038 defendant Bowley John, senior yeoman 593739 593739 Bowley, John, senior, of Pencombe, yeoman 0
4386115 2160038 2160038 defendant Bowley John, junior yeoman 593739 593739 Bowley, John, junior, of Pencombe, yeoman 1
4386117 2160039 2160039 defendant Bowley John, senior yeoman 593739 593739 Bowley, John, senior, of Pencombe, yeoman 0
4386118 2160039 2160039 defendant Bowley John, junior yeoman 593739 593739 Bowley, John, junior, of Pencombe, yeoman 1
4389989 2161276 2161276 defendant Maylard Stephen yeoman 593739 593739 Maylard, Stephen, of Pencombe, yeoman 0
4399700 2164488 2164488 defendant Clerke James husbandman 593739 593739 Clerke, James, of Pencombe, husbandman 1
4399701 2164488 2164488 defendant Morton Richard smith 593739 593739 Morton, Richard, of Pencombe, smith 2
4827515 2304653 2304653 defendant dudston Robert clerk 593739 593739 dudston, Robert, of Pencombe, clerk 1
4890162 2323695 2323695 plaintiff Bayly Robert (legal representative) 593739 593739 Bayly, Robert, of Pencombe, executor of 0
5017383 2361972 2361972 defendant Mascalde Thomas husbandman 593739 593739 Mascalde, Thomas, of Pencombe, husbandman 2
5036873 2367658 2367658 defendant Mascall Thomas husbandman 593739 593739 Mascall, Thomas, of Pencombe, husbandman 1
5122607 2393044 2393044 defendant Brokhampton John husbandman 593739 593739 Brokhampton, John, of Pencombe, husbandman 1
5222621 2422333 2422333 defendant Mascald Thomas husbandman 593739 593739 Mascald, Thomas, of Pencombe, husbandman 2
5230589 2424559 2424559 defendant Mascald Thomas   593739 593739 Mascald, Thomas, of Pencombe, husbandma 4
5311422 2448446 2448446 defendant Pencombe Hugh chapman 593739 593739 Pencombe, Hugh, of Pencombe, chapman 1
5357537 2462424 2462424 defendant Brokehous Richard husbandman 593739 593739 Brokehous, Richard, of Pencombe, husbandman 2
5408461 2477500 2477500 defendant Mascalde Thomas husbandman 593739 593739 Mascalde, Thomas, of Pencombe, husbandman 1
5444366 2488222 2488222 defendant Hullys John husbandman 593739 593739 Hullys, John, of Pencombe, husbandman 0
5444367 2488222 2488222 defendant Tumlyns Philip husbandman 593739 593739 Tumlyns, Philip, of Pencombe, husbandman 1
5444368 2488222 2488222 defendant Adams Thomas husbandman 593739 593739 Adams, Thomas, of Pencombe, husbandman 2
5444369 2488222 2488222 defendant Mascalde Thomas husbandman 593739 593739 Mascalde, Thomas, of Pencombe, husbandman 3
5444374 2488223 2488223 defendant Menryk Geoffrey husbandman 593739 593739 Menryk, Geoffrey, of Pencombe, husbandman 3
5457027 2492009 2492009 defendant Hullys John husbandman 593739 593739 Hullys, John, of Pencombe, husbandman 0
5457028 2492009 2492009 defendant Tumlyns Philip husbandman 593739 593739 Tumlyns, Philip, of Pencombe, husbandman 1
5457029 2492009 2492009 defendant Adams Thomas husbandman 593739 593739 Adams, Thomas, of Pencombe, husbandman 2
5457030 2492009 2492009 defendant Mascalde Thomas husbandman 593739 593739 Mascalde, Thomas, of Pencombe, husbandman 3
5457035 2492010 2492010 defendant Menryk Geoffrey husbandman 593739 593739 Menryk, Geoffrey, of Pencombe, husbandman 3
5515198 2509599 2509599 defendant Tomlyns Philip husbandman 593739 593739 Tomlyns, Philip, of Pencombe, husbandman 0
5515199 2509599 2509599 defendant Craswalle William husbandman 593739 593739 Craswalle, William, of Pencombe, husbandman 1
5518252 2510538 2510538 defendant Gogh Thomas husbandman 593739 593739 Gogh, Thomas, of Pencombe, husbandman 0
5518859 2510735 2510735 defendant Tomlyns Philip yeoman 593739 593739 Tomlyns, Philip, of Pencombe, yeoman 0
5549300 2519844 2519844 defendant Grafton John husbandman 593739 593739 Grafton, John, of Pencombe, husbandman 0
5549301 2519844 2519844 defendant Arche Walter husbandman 593739 593739 Arche, Walter, of Pencombe, husbandman 1
5558302 2522377 2522377 defendant Baylly alias Tynker James husbandman 593739 593739 Baylly alias Tynker, James, of Pencombe, husbandman 3
5558303 2522377 2522377 defendant Baylly alias Tynker Richard husbandman 593739 593739 Baylly alias Tynker, Richard, of Pencombe, husbandman 4
5593283 2532879 2532879 defendant Hergest Roger gent 593739 593739 Hergest, Roger, of Pencombe, gent 4
5603045 2535837 2535837 defendant Grafton John husbandman 593739 593739 Grafton, John, of Pencombe, husbandman 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);