names

100 rows where place_id = 586443

✎ 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
3588735 1864120 1864120 defendant Rowe Richard husbandman 586443 586443 Rowe, Richard, of Colyton, husbandman 0
3615963 1872626 1872626 defendant Haydon Alan butcher 586443 586443 Haydon, Alan, of Colyton, butcher 10
3657213 1912520 1912520 defendant Halsyerd John chaplain 586443 586443 Halsyerd, John, of Colyton, chaplain 0
3657214 1912520 1912520 defendant Salter Edward chaplain 586443 586443 Salter, Edward, of Colyton, chaplain 1
3678697 1919403 1919403 defendant Philipp Agnes widow 586443 586443 Philipp, Agnes, of Colyton, widow 0
3678698 1919403 1919403 defendant Philipp Robert yeoman 586443 586443 Philipp, Robert, of Colyton, yeoman 1
3691852 1923613 1923613 defendant Wyker Gilbert husbandman 586443 586443 Wyker, Gilbert, of Colyton, husbandman 0
3698132 1925641 1925641 defendant Veryer Robert miller 586443 586443 Veryer, Robert, of Colyton, miller 0
3738808 1938343 1938343 defendant Fraunces John yeoman 586443 586443 Fraunces, John, of Colyton, yeoman 0
3738810 1938344 1938344 defendant Trowbrigge John, junior merchant 586443 586443 Trowbrigge, John, junior, of Colyton, merchant 0
3759338 1944910 1944910 defendant Strobrigge John merchant 586443 586443 Strobrigge, John, of Colyton, merchant 0
3759340 1944910 1944910 defendant Lecche William laborer 586443 586443 Lecche, William, of Colyton, laborer 2
3790572 1954873 1954873 defendant Dassell Richard husbandman 586443 586443 Dassell, Richard, of Colyton, husbandman 0
3797771 1957201 1957201 defendant Reede John carrier 586443 586443 Reede, John, of Colyton, carrier 6
3797772 1957201 1957201 defendant Hoker Roger carrier 586443 586443 Hoker, Roger, of Colyton, carrier 7
3797773 1957201 1957201 defendant Fyssher Philip carrier 586443 586443 Fyssher, Philip, of Colyton, carrier 8
3797774 1957201 1957201 defendant Marshall Hugh carrier 586443 586443 Marshall, Hugh, of Colyton, carrier 9
3832353 1968036 1968036 defendant Macy John husbandman 586443 586443 Macy, John, of Colyton, husbandman 1
3839450 1970263 1970263 defendant Byrche John husbandman 586443 586443 Byrche, John, of Colyton, husbandman 0
3862179 1977535 1977535 defendant Ferlond Robert yeoman 586443 586443 Ferlond, Robert, of Colyton, yeoman 4
3862180 1977535 1977535 defendant Dene John cooper 586443 586443 Dene, John, of Colyton, cooper 5
3862181 1977535 1977535 defendant Speler John weaver 586443 586443 Speler, John, of Colyton, weaver 6
3862182 1977535 1977535 defendant Rokatt Richard tanner 586443 586443 Rokatt, Richard, of Colyton, tanner 7
3862183 1977535 1977535 defendant Basseley John cooper 586443 586443 Basseley, John, of Colyton, cooper 8
3862184 1977535 1977535 defendant Langley Thomas yeoman 586443 586443 Langley, Thomas, of Colyton, yeoman 9
3881258 1983999 1983999 defendant Byrde John tanner 586443 586443 Byrde, John, of Colyton, tanner 2
3886822 1985854 1985854 defendant Langley Walter yeoman 586443 586443 Langley, Walter, of Colyton, yeoman 0
3896537 1989049 1989049 plaintiff Tyrlyng John merchant 586443 586443 Tyrlyng, John, of Colyton, merchant 0
3911795 1994269 1994269 defendant Terlyng John merchant 586443 586443 Terlyng, John, of Colyton, merchant 1
3914931 1995343 1995343 defendant Burche John hardwareman 586443 586443 Burche, John, of Colyton, hardwareman 0
3915871 1995686 1995686 defendant Carswyll John gent 586443 586443 Carswyll, John, of Colyton, gent 2
3917543 1996225 1996225 defendant Lecheland Nicholas yeoman 586443 586443 Lecheland, Nicholas, of Colyton, yeoman 0
3920299 1997128 1997128 defendant Carswyll John gent 586443 586443 Carswyll, John, of Colyton, gent 0
3921975 1997693 1997693 defendant Jefferey alias Farlong Robert yeoman 586443 586443 Jefferey alias Farlong, Robert, of Colyton, yeoman 0
3929590 2000247 2000247 defendant Furlong Robert husbandman 586443 586443 Furlong, Robert, of Colyton, husbandman 0
3936279 2002461 2002461 defendant Furlonge Robert husbandman 586443 586443 Furlonge, Robert, of Colyton, husbandman 0
3941058 2004014 2004014 defendant Dassell Richard gent 586443 586443 Dassell, Richard, of Colyton, gent 0
3941059 2004014 2004014 defendant Clarke John merchant 586443 586443 Clarke, John, of Colyton, merchant 1
3941060 2004014 2004014 defendant Baggewyll Peter husbandman 586443 586443 Baggewyll, Peter, of Colyton, husbandman 2
3941430 2004142 2004142 defendant Lowde John husbandman 586443 586443 Lowde, John, of Colyton, husbandman 0
3941605 2004205 2004205 plaintiff Vye Henry   586443 586443 Vye, Henry, of Colyton 0
3947181 2006081 2006081 plaintiff Clarke John   586443 586443 Clarke, John, of Colyton 0
3952203 2007846 2007846 defendant Strowbrydge John, junior gent 586443 586443 Strowbrydge, John, junior, of Colyton, gent 0
3952789 2008047 2008047 defendant Clarke John, senior merchant 586443 586443 Clarke, John, senior, of Colyton, merchant 0
3955456 2008974 2008974 defendant Hale John husbandman 586443 586443 Hale, John, of Colyton, husbandman 0
3956447 2009319 2009319 defendant Newton Richard husbandman 586443 586443 Newton, Richard, of Colyton, husbandman 0
3968857 2013735 2013735 defendant Rede John husbandman 586443 586443 Rede, John, of Colyton, husbandman 2
3977160 2016581 2016581 defendant Strowebrydge John, senior gent 586443 586443 Strowebrydge, John, senior, of Colyton, or of Hoberane, Devon, gent 0
3985337 2019513 2019513 defendant Clarke John, senior husbandman 586443 586443 Clarke, John, senior, of Colyton, husbandman 0
3992992 2022242 2022242 defendant Whytmore Henry husbandman 586443 586443 Whytmore, Henry, of Colyton, husbandman 8
4003025 2025845 2025845 defendant Raylyn or Rawlyn Walter clothier 586443 586443 Raylyn or Rawlyn, Walter, of Colyton, clothier 0
4007568 2027490 2027490 defendant Huyt John husbandman 586443 586443 Huyt, John, of Colyton, husbandman 1
4035006 2037202 2037202 defendant Marler John husbandman 586443 586443 Marler, John, of Colyton, husbandman 1
4041682 2039510 2039510 defendant Strowbridge George gent 586443 586443 Strowbridge, George, of Colyton, gent 6
4057834 2045188 2045188 defendant Whyker Richard yeoman 586443 586443 Whyker, Richard, of Colyton, yeoman 0
4085975 2055262 2055262 defendant Way John yeoman 586443 586443 Way, John, of Colyton, yeoman 0
4085976 2055262 2055262 defendant Newton Richard husbandman 586443 586443 Newton, Richard, of Colyton, husbandman 1
4122781 2068439 2068439 defendant Serle John, junior   586443 586443 Serle, John, junior, of Colyton, or of Auliscombe, Devon, gebt 0
4160239 2081646 2081646 defendant Hamlyn Richard husbandman 586443 586443 Hamlyn, Richard, of Colyton, husbandman 0
4211397 2099540 2099540 defendant Marwoode John, junior weaver 586443 586443 Marwoode, John, junior, of Colyton, weaver 1
4212719 2099990 2099990 defendant Tirlynge Andrew gent 586443 586443 Tirlynge, Andrew, of Colyton, gent 0
4229659 2105856 2105856 defendant Strowbridge George gent 586443 586443 Strowbridge, George, of Colyton, gent 0
4284863 2124633 2124633 defendant Owen William yeoman 586443 586443 (Owen, William, of Colyton, yeoman 1
4289322 2126241 2126241 defendant Bevys John blacksmith 586443 586443 Bevys, John, of Colyton, blacksmith 0
4323953 2138421 2138421 defendant Argenton Edmund gent 586443 586443 Argenton, Edmund, of Colyton, or of Yarberie, Devon, gent 0
4361550 2151292 2151292 defendant Travers Ralph clerk 586443 586443 Travers, Ralph, of Colyton, clerk 0
4380983 2158314 2158314 defendant Carpenter alias Rawlen John (legal representative) 586443 586443 Carpenter alias Rawlen, John, of Colyton, clothier, executrix of 0
4380984 2158314 2158314 defendant Cooper Elizabeth widow 586443 586443 Cooper, Elizabeth, of Colyton, widow 1
4458123 2187572 2187572 defendant Ferour Thomas   586443 586443 Ferour, Thomas, of Colyton 1
4525812 2208372 2208372 defendant Strete John   586443 586443 Strete, John, of Colyton 13
4526535 2208583 2208583 defendant Crosse John   586443 586443 Crosse, John, of Colyton 0
4553507 2217028 2217028 defendant Crosse John   586443 586443 Crosse, John, of Colyton 0
4571282 2222594 2222594 defendant Crosse John (legal representative) 586443 586443 Crosse, John, of Colyton, administratrix of 1
4582465 2225957 2225957 defendant Crosse John   586443 586443 Crosse, John, of Colyton, administrators of 0
4625081 2238812 2238812 defendant Brounvyle Maud   586443 586443 Brounvyle, Maud, of Colyton 0
4651552 2246487 2246487 defendant Strete John   586443 586443 Strete, John, of Colyton, bailiff 10
4652972 2246861 2246861 defendant Lynke Henry husbandman 586443 586443 Lynke, Henry, of Colyton, husbandman 0
4655389 2247577 2247577 defendant Barneburgh John gent 586443 586443 Barneburgh, John, of Colyton, gent 0
4657586 2248261 2248261 defendant Huwet John husbandman 586443 586443 Huwet, John, of Colyton, husbandman 0
4714452 2269850 2269850 defendant Slade Walter   586443 586443 Slade, Walter, of Colyton, mason 3
4769412 2286407 2286407 defendant Wever John butcher 586443 586443 Wever, John, of Colyton, butcher 0
4769413 2286408 2286408 plaintiff Payn Robert   586443 586443 Payn, Robert, of Colyton 0
4775171 2288229 2288229 defendant Pulford William butcher 586443 586443 Pulford, William, of Colyton, butcher 0
4962989 2345845 2345845 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 1
4982015 2351538 2351538 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 5
4990741 2354138 2354138 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 4
4990749 2354139 2354139 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 4
5016067 2361580 2361580 defendant Hille Richard   586443 586443 Hille, Richard, of Colyton, bailiff 2
5059705 2374467 2374467 defendant Bore John, junior laborer 586443 586443 Bore, John, junior, of Colyton, laborer 0
5059706 2374467 2374467 defendant Hare William laborer 586443 586443 Hare, William, of Colyton, laborer 1
5309189 2447785 2447785 defendant Wyscombe John yeoman 586443 586443 Wyscombe, John, of Colyton, yeoman 0
5309192 2447785 2447785 defendant Parys Robert husbandman 586443 586443 Parys, Robert, of Colyton, husbandman 3
5309193 2447785 2447785 defendant Frensshe Robert husbandman 586443 586443 Frensshe, Robert, of Colyton, husbandman 4
5361372 2463577 2463577 defendant Frankleyn Richard butcher 586443 586443 Frankleyn, Richard, of Colyton, butcher 1
5371980 2466828 2466828 defendant Neuton Richard   586443 586443 Neuton, Richard, of Colyton, free mason 0
5493694 2503025 2503025 defendant Neweton John husbandman 586443 586443 Neweton, John, of Colyton, husbandman 2
5493697 2503026 2503026 defendant Neweton alias Hemberhayne John husbandman 586443 586443 Neweton alias Hemberhayne, John, of Colyton, husbandman 0
5523718 2512246 2512246 defendant Boll John husbandman 586443 586443 Boll, John, of Colyton, husbandman 4
5523719 2512246 2512246 defendant Lyon John husbandman 586443 586443 Lyon, John, of Colyton, husbandman 5
5535401 2515598 2515598 defendant Rowe Richard husbandman 586443 586443 Rowe, Richard, of Colyton, husbandman 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);