names

88 rows where place_id = 604145

✎ 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
3656989 1912445 1912445 defendant Tayler Thomas glover 604145 604145 Tayler, Thomas, of Pembridge, glover 0
3659121 1913112 1913112 defendant Conop Richard butcher 604145 604145 Conop, Richard, of Pembridge, butcher 0
3662735 1914264 1914264 defendant Conop Richard chapman & baker 604145 604145 Conop, Richard, of Pembridge, chapman & baker 0
3932809 2001276 2001276 defendant Gilbert Walter laborer 604145 604145 Gilbert, Walter, of Pembridge, laborer 3
3932810 2001276 2001276 defendant Counope George gent 604145 604145 Counope, George, of Pembridge, gent 4
3942065 2004361 2004361 defendant Jenkes Henry yeoman 604145 604145 Jenkes, Henry, of Pembridge, yeoman 3
3948506 2006542 2006542 defendant Longe Henry weaver 604145 604145 Longe, Henry, of Pembridge, weaver 2
3948507 2006542 2006542 defendant Moseley John glover 604145 604145 Moseley, John, of Pembridge, glover 3
3948508 2006542 2006542 defendant Sybbowe John capper 604145 604145 Sybbowe, John, of Pembridge, capper 4
3948509 2006542 2006542 defendant Stretton John miller 604145 604145 Stretton, John, of Pembridge, miller 5
3952782 2008045 2008045 defendant Stede Ralph yeoman 604145 604145 Stede, Ralph, of Pembridge, yeoman 0
3975998 2016172 2016172 defendant Hawkyns John gent 604145 604145 Hawkyns, John, of Pembridge, gent 0
4010591 2028564 2028564 defendant Jenk Henry gent 604145 604145 Jenk, Henry, of Pembridge, gent 4
4025634 2033820 2033820 defendant Morvan Hugh yeoman 604145 604145 Morvan, Hugh, of Pembridge, yeoman 0
4032374 2036245 2036245 defendant Jenkes Henry gent 604145 604145 Jenkes, Henry, of Pembridge, gent 3
4034791 2037122 2037122 defendant Wall Roger husbandman 604145 604145 Wall, Roger, of Pembridge, husbandman 1
4035814 2037482 2037482 plaintiff Hopley Richard husbandman 604145 604145 Hopley, Richard, of Pembridge, husbandman 0
4040587 2039129 2039129 defendant Kyrwood William yeoman 604145 604145 Kyrwood, William, of Pembridge, or of Marston, Herefs, yeoman 0
4046066 2041031 2041031 defendant Conoppe John yeoman 604145 604145 Conoppe, John, of Pembridge, yeoman 0
4086893 2055603 2055603 defendant Hyggyns Henry yeoman 604145 604145 Hyggyns, Henry, of Pembridge, yeoman 3
4087008 2055647 2055647 defendant Hyggyns Henry yeoman 604145 604145 Hyggyns, Henry, of Pembridge, yeoman 0
4108484 2063290 2063290 defendant Tanner Roger yeoman 604145 604145 Tanner, Roger, of Pembridge, yeoman 0
4108485 2063290 2063290 defendant Hoelles William yeoman 604145 604145 Hoelles, William, of Pembridge, yeoman 1
4108488 2063291 2063291 defendant Tanner Roger yeoman 604145 604145 Tanner, Roger, of Pembridge, yeoman 0
4108489 2063291 2063291 defendant Hoelles William yeoman 604145 604145 Hoelles, William, of Pembridge, yeoman 1
4118714 2066983 2066983 defendant Tanner Roger gent 604145 604145 Tanner, Roger, of Pembridge, gent 2
4118720 2066984 2066984 defendant Tanner Roger yeoman 604145 604145 Tanner, Roger, of Pembridge, yeoman 2
4156954 2080510 2080510 defendant Davys Richard fuller 604145 604145 Davys, Richard, of Pembridge, fuller 2
4159371 2081347 2081347 defendant Davys Richard yeoman 604145 604145 Davys, Richard, of Pembridge, yeoman 0
4185534 2090447 2090447 defendant Nyccolls Henry yeoman 604145 604145 Nyccolls, Henry, of Pembridge, or of Erislande, yeoman 2
4224956 2104196 2104196 defendant Baker John yeoman 604145 604145 Baker, John, of Pembridge, yeoman 3
4228167 2105332 2105332 defendant Steade Philip yeoman 604145 604145 Steade, Philip, of Pembridge, yeoman 1
4228508 2105454 2105454 defendant Jenk William gent 604145 604145 Jenk, William, of Pembridge, or of Brungwyn, Radnor, gent 0
4233418 2107202 2107202 defendant Connopp William, senior yeoman 604145 604145 Connopp, William, senior, of Pembridge, yeoman 0
4236988 2108516 2108516 defendant Jenk or Jenkes William gent 604145 604145 Jenk or Jenkes, William, of Pembridge, or of Brungwyne Radnor, gent 0
4237114 2108563 2108563 defendant Bowier John husbandman 604145 604145 Bowier, John, of Pembridge, husbandman 1
4238794 2109189 2109189 plaintiff Smythe Edward   604145 604145 Smythe, Edward, of Pembridge 0
4238796 2109190 2109190 plaintiff Smythe Edward   604145 604145 Smythe, Edward, of Pembridge 0
4242034 2110330 2110330 defendant Connopp William, senior yeoman 604145 604145 Connopp, William, senior, of Pembridge, yeoman 0
4242278 2110412 2110412 defendant Hunte Thomas husbandman 604145 604145 Hunte, Thomas, of Pembridge, husbandman 0
4242280 2110413 2110413 defendant Hunte Thomas husbandman 604145 604145 Hunte, Thomas, of Pembridge, husbandman 0
4245603 2111506 2111506 defendant Jenkes William gent 604145 604145 Jenkes, William, of Pembridge, or of Brungwyn, Radnor, gent 1
4247250 2112057 2112057 plaintiff Smythe Edward   604145 604145 Smythe, Edward, of Pembridge 0
4256982 2115306 2115306 defendant Bayly William yeoman 604145 604145 Bayly, William, of Pembridge, yeoman 0
4276281 2121648 2121648 defendant Tyler Thomas yeoman 604145 604145 Tyler, Thomas, of Pembridge, yeoman 0
4278723 2122493 2122493 defendant Steade Walter yeoman 604145 604145 Steade, Walter, of Pembridge, yeoman 0
4293478 2127730 2127730 defendant Forde John miller 604145 604145 Forde, John, of Pembridge, miller 1
4294165 2127991 2127991 defendant Connoppe William yeoman 604145 604145 Connoppe, William, of Pembridge, yeoman 0
4294167 2127991 2127991 defendant Higgyns Walter yeoman 604145 604145 Higgyns, Walter, of Pembridge, yeoman 2
4294168 2127991 2127991 defendant Codogan William yeoman 604145 604145 Codogan, William, of Pembridge, yeoman 3
4299902 2130057 2130057 defendant Jenkes William gent 604145 604145 Jenkes, William, of Pembridge, gent 0
4301046 2130476 2130476 defendant Steade Philip yeoman 604145 604145 Steade, Philip, of Pembridge, yeoman 3
4305655 2132114 2132114 defendant Bathoe or Bathoses William yeoman 604145 604145 Bathoe or Bathoses, William, of Pembridge, or of Old Radnor, yeoman 0
4305694 2132129 2132129 defendant Connoppe William, senior yeoman 604145 604145 Connoppe, William, senior, of Pembridge, yeoman 0
4305695 2132129 2132129 defendant Connoppe William, junior   604145 604145 Connoppe, William, junior, of Pembridge, yeoman, his son 1
4309268 2133393 2133393 defendant Steade Philip yeoman 604145 604145 Steade, Philip, of pembridge, yeoman 3
4309960 2133643 2133643 defendant Steade Walter yeoman 604145 604145 Steade, Walter, of Pembridge, yeoman 0
4311796 2134263 2134263 defendant Connoppe William, senior yeoman 604145 604145 Connoppe, William, senior, of Pembridge, yeoman 0
4312133 2134383 2134383 defendant Tanner Roger gent 604145 604145 Tanner, Roger, of Pembridge, gent 1
4312764 2134596 2134596 defendant Connoppe William, junior yeoman 604145 604145 Connoppe, William, junior, of Pembridge, yeoman 0
4312765 2134596 2134596 defendant Williams John husbandman 604145 604145 Williams, John, of Pembridge, husbandman 1
4312767 2134596 2134596 defendant Philpotte James laborer 604145 604145 Philpotte, James, of Pembridge, laborer 3
4316895 2136025 2136025 defendant Connoppe William, senior yeoman 604145 604145 Connoppe, William, senior, of Pembridge, yeoman 0
4316896 2136025 2136025 defendant Connoppe William, junior   604145 604145 Connoppe, William, junior, of Pembridge, yeoman, his son 1
4323095 2138138 2138138 defendant Bayly William butcher 604145 604145 Bayly, William, of Pembridge, yeoman, butcher 0
4330383 2140462 2140462 defendant Jenk William gent 604145 604145 Jenk, William, of Pembridge, gent 1
4331210 2140736 2140736 defendant Connope William, junior yeoman 604145 604145 Connope, William, junior, of Pembridge, yeoman 1
4333069 2141347 2141347 defendant Raffes Thomas yeoman 604145 604145 together with Raffes, Thomas, of Pembridge, yeoman 1
4333377 2141446 2141446 defendant Baker John, junior gent 604145 604145 Baker, John, junior, of Pembridge, or of Leominster, gent 2
4367176 2153317 2153317 defendant Mortrowe alias Morcott William yeoman 604145 604145 Mortrowe alias Morcott, William, of Pembridge, yeoman 0
4369281 2154077 2154077 defendant Ouldaker Henry yeoman 604145 604145 Ouldaker, Henry, of Pembridge, yeoman 2
4371745 2154953 2154953 defendant Robert Edward weaver 604145 604145 (Robert, Edward, of Pembridge, weaver 1
4383139 2159077 2159077 defendant Connop William, senior yeoman 604145 604145 Connop, William, senior, of Pembridge, yeoman 0
4383877 2159310 2159310 defendant Lyde Richard husbandman 604145 604145 Lyde, Richard, of Pembridge, husbandman 2
4387677 2160514 2160514 defendant Herringe William yeoman 604145 604145 Herringe, William, of Pembridge, or of Wellington, yeoman 0
4387908 2160587 2160587 defendant Higgins Henry husbandman 604145 604145 Higgins,Henry, of Pembridge, husbandman 3
4390095 2161307 2161307 defendant Walle Thomas   604145 604145 Walle, Thomas, of Pembridge 0
4394646 2162797 2162797 defendant Harper Isaac yeoman 604145 604145 Harper, Isaac, of Pembridge, yeoman 0
4394948 2162896 2162896 defendant Lewelyn Richard yeoman 604145 604145 Lewelyn, Richard, of Pembridge, yeoman 1
4399684 2164485 2164485 defendant Kirwoode William yeoman 604145 604145 Kirwoode, William, of Pembridge, yeoman 0
4403519 2165748 2165748 defendant Hall John gent 604145 604145 Hall, John, of Pembridge, gent 1
4409024 2167622 2167622 defendant Gregge John husbandman 604145 604145 Gregge, John, of Pembridge, husbandman 0
4409025 2167622 2167622 defendant Kyrwood Walter yeoman 604145 604145 Kyrwood, Walter, of Pembridge, yeoman 1
4409913 2167921 2167921 defendant Wall Simon husbandman 604145 604145 Wall, Simon, of Pembridge, husbandman 0
4411244 2168347 2168347 defendant Wellington Henry husbandman 604145 604145 Wellington, Henry, of Pembridge, husbandman 0
4411245 2168347 2168347 defendant Hopley Edward husbandman 604145 604145 Hopley, Edward, of Pembridge, husbandman 1
5186005 2411655 2411655 defendant Holwey John husbandman 604145 604145 Holwey, John, of Pembridge, husbandman 2
5193620 2413859 2413859 defendant Feryny John butcher 604145 604145 Feryny, John, of Pembridge, 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);