names

115 rows where place_id = 586165

✎ 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
3588064 1863917 1863917 plaintiff Barbour Nicholas   586165 586165 Barbour, Nicholas, of Fowy 0
3599364 1867444 1867444 defendant Haryngdon Richard merchant 586165 586165 Haryngdon, Richard, of Fowy, merchant 0
3599366 1867445 1867445 defendant Haryngdon Richard merchant 586165 586165 Haryngdon, Richard, of Fowy, merchant 0
3634409 1905560 1905560 defendant Robyn Thomas mariner 586165 586165 Robyn, Thomas, of Fowy, mariner 0
3636310 1906148 1906148 defendant Haryngdon Richard merchant 586165 586165 Haryngdon, Richard, of Fowy, merchant 0
3639525 1907170 1907170 defendant Knyght William gent 586165 586165 Knyght, William, of Fowy, gent 1
3655970 1912118 1912118 defendant Henley William merchant 586165 586165 Henley, William, of Fowy, merchant 0
3660168 1913439 1913439 defendant Tomme Walter husbandman 586165 586165 Tomme, Walter, of Fowy, husbandman 0
3666265 1915395 1915395 defendant Walsale John merchant 586165 586165 Walsale, John, of Fowy, merchant 10
3824735 1965611 1965611 defendant Bruer Nicholas merchant 586165 586165 Bruer, Nicholas, of Fowy, merchant 0
3887221 1985992 1985992 defendant Teagge Nicholas smith 586165 586165 Teagge, Nicholas, of Fowy, smith 0
3921957 1997687 1997687 defendant Leve Thomas glover 586165 586165 Leve, Thomas, of Fowy, glover 0
3959609 2010455 2010455 defendant Raysshley Robert merchant 586165 586165 Raysshley, Robert, of Fowy, merchant 0
3959610 2010455 2010455 defendant Raysshley John merchant 586165 586165 Raysshley, John, of Fowy, merchant 1
3959611 2010455 2010455 defendant Steven Martin tanner 586165 586165 Steven, Martin, of Fowy, tanner 2
3959612 2010455 2010455 defendant Veysey Nicholas cordwainer 586165 586165 Veysey, Nicholas, of Fowy, cordwainer 3
4011129 2028748 2028748 defendant Tome alias Rawlyn William weaver 586165 586165 Tome alias Rawlyn, William, of Fowy, weaver 5
4463175 2189180 2189180 defendant Michel Thomas   586165 586165 Michel, Thomas, of Fowy 0
4500882 2200897 2200897 plaintiff Martyn Richard   586165 586165 Martyn, Richard, of Fowy 1
4523573 2207697 2207697 defendant Stonard Henry   586165 586165 Stonard, Henry, of Fowy 0
4538586 2212347 2212347 defendant Certayn John   586165 586165 Certayn, John, of Fowy 0
4559715 2218991 2218991 defendant Kyng John   586165 586165 Kyng, John, of Fowy 7
4559716 2218991 2218991 defendant Nicholl John   586165 586165 Nicholl, John, of Fowy 8
4578716 2224832 2224832 defendant Mayowe Robert   586165 586165 Mayowe, Robert, of Fowy 4
4579351 2225023 2225023 defendant Certayn John   586165 586165 Certayn, John, of Fowy 4
4579355 2225023 2225023 defendant Ermtye John   586165 586165 Ermtye, John, of Fowy 8
4585350 2226842 2226842 defendant Gascoygne John   586165 586165 Gascoygne, John, of Fowy 0
4589042 2227950 2227950 defendant Hunte John   586165 586165 Hunte, John, of Fowy 0
4593950 2229381 2229381 defendant Beoye William   586165 586165 Beoye, William, of Fowy 0
4626503 2239238 2239238 defendant Wynter Richard   586165 586165 Wynter, Richard, of Fowy 0
4662985 2249886 2249886 defendant Polmaryn John   586165 586165 Polmaryn, John, of Fowy, millward 1
4688995 2262115 2262115 defendant Saler John shipman 586165 586165 Saler, John, of Fowy, shipman 0
4726004 2273421 2273421 plaintiff Goody Peter merchant 586165 586165 Goody, Peter, of Fowy, merchant 0
4726005 2273421 2273421 defendant Badyn John mariner 586165 586165 Badyn, John, of Fowy, mariner 0
4736999 2276702 2276702 defendant Ballard John shipman 586165 586165 Ballard, John, of Fowy, shipman 0
4739977 2277582 2277582 defendant Synger Robert chaplain 586165 586165 Synger, Robert, of Fowy, chaplain 0
4779259 2289491 2289491 defendant Smyth John merchant 586165 586165 Smyth, John, of Fowy, merchant 1
4786781 2291920 2291920 defendant Cadnen or Cadven John tailor 586165 586165 Cadnen or Cadven, John, of Fowy, tailor 0
4821226 2302719 2302719 defendant Webber John weaver 586165 586165 Webber, John, of Fowy, weaver 0
4822570 2303135 2303135 defendant Trefry Thomas gent 586165 586165 Trefry, Thomas, of Fowy, gent 0
4876518 2319621 2319621 plaintiff Smyth John merchant 586165 586165 Smyth, John, of Fowy, merchant 0
4876521 2319622 2319622 plaintiff Smyth John merchant 586165 586165 Smyth, John, of Fowy, merchant 0
4902780 2327488 2327488 defendant Skynner Ralph yeoman 586165 586165 Skynner, Ralph, of Fowy, yeoman 0
4937272 2338022 2338022 defendant Gregor Robert   586165 586165 Gregor, Robert, of Fowy, millward 1
4937960 2338247 2338247 defendant Skynner Ralph husbandman 586165 586165 (Skynner, Ralph, of Fowy, husbandman 1
4982463 2351673 2351673 defendant Lanta Robert mariner 586165 586165 Lanta, Robert, of Fowy, mariner 0
4982464 2351673 2351673 defendant Symon Nicholas baker 586165 586165 Symon, Nicholas, of Fowy, baker 1
4982465 2351673 2351673 defendant Webbe Gilbert shipman 586165 586165 Webbe, Gilbert, of Fowy, shipman 2
4984240 2352217 2352217 defendant Lowe John shipman 586165 586165 Lowe, John, of Fowy, shipman 0
4984241 2352217 2352217 defendant Reith John shipman 586165 586165 Reith, John, of Fowy, shipman 1
4995110 2355394 2355394 defendant Thomas of Walter mariner 586165 586165 Thomas, of Walter, of Fowy, mariner 2
4995112 2355394 2355394 defendant Busshe Baronus mariner 586165 586165 Busshe, Baronus, of Fowy, mariner 4
5027841 2365022 2365022 defendant Smyth Thomas smith 586165 586165 Smyth, Thomas, of Fowy, smith 0
5039739 2368527 2368527 defendant Smyth Richard yeoman 586165 586165 Smyth, Richard, of Fowy, yeoman 1
5048458 2371177 2371177 plaintiff Roche John   586165 586165 Roche, John, of Fowy 0
5081584 2380996 2380996 defendant Balard Robert husbandman 586165 586165 Balard, Robert, of Fowy, husbandman 0
5100945 2386690 2386690 defendant Cornowe John mariner 586165 586165 Cornowe, John, of Fowy, mariner 0
5102666 2387191 2387191 defendant Smyth Richard gent 586165 586165 Smyth, Richard, of Fowy, gent 0
5106054 2388207 2388207 defendant Tomma John   586165 586165 Tomma, John, of Fowy 0
5150798 2401377 2401377 defendant Smyth Richard gent 586165 586165 Smyth, Richard, of Fowy, gent 0
5174688 2408298 2408298 plaintiff Salter John gent 586165 586165 Salter, John, of Fowy, gent 0
5179318 2409690 2409690 defendant Hellond Thomas gent 586165 586165 Hellond, Thomas, of Fowy, gent 0
5179320 2409690 2409690 defendant Smyth Richard gent 586165 586165 (Smyth, Richard, of Fowy, gent 2
5179321 2409690 2409690 defendant Countre John merchant 586165 586165 Countre, John, of Fowy, merchant 3
5179323 2409691 2409691 defendant Smyth Katherine gent 586165 586165 Smyth, Katherine, of Fowy, formerly wife & executrix of John Smyth, together with Hellond, Thomas, of Fowy, gent 0
5179325 2409691 2409691 defendant Smyth Richard gent 586165 586165 (Smyth, Richard, of Fowy, gent 2
5179326 2409691 2409691 defendant Countre John merchant 586165 586165 Countre, John, of Fowy, merchant 3
5183556 2410926 2410926 defendant Balard John mariner 586165 586165 Balard, John, of Fowy, mariner 0
5183631 2410946 2410946 defendant Countre John merchant 586165 586165 Countre, John, of Fowy, merchant 3
5198326 2415260 2415260 plaintiff Treffry Thomas   586165 586165 Treffry, Thomas, of Fowy 0
5198328 2415261 2415261 plaintiff Trefry Thomas   586165 586165 Trefry, Thomas, of Fowy 0
5198329 2415261 2415261 defendant Denys Thomas mariner 586165 586165 Denys, Thomas, of Fowy, mariner 0
5198330 2415261 2415261 defendant Mayow Thomas mariner 586165 586165 Mayow, Thomas, of Fowy, mariner 1
5213297 2419621 2419621 defendant Cornyssh William mariner 586165 586165 Cornyssh, William, of Fowy, mariner 2
5221021 2421847 2421847 defendant Edmond Richard   586165 586165 Edmond, Richard, of Fowy 0
5235820 2426055 2426055 defendant Raven Thomas merchant 586165 586165 Raven, Thomas, of Fowy, merchant 3
5237825 2426647 2426647 defendant Hunkyn John yeoman 586165 586165 Hunkyn, John, of Fowy, yeoman 1
5240897 2427543 2427543 defendant Barber John barber 586165 586165 Barber, John, of Fowy, barber 1
5248933 2429813 2429813 defendant Hopkyn Richard mariner 586165 586165 Hopkyn, Richard, of Fowy, mariner 0
5248934 2429813 2429813 defendant Barber John barber 586165 586165 Barber, John, of Fowy, barber 1
5249865 2430071 2430071 defendant Dawe William mariner 586165 586165 Dawe, William, of Fowy, mariner 6
5250189 2430172 2430172 defendant Roche John draper 586165 586165 Roche, John, of Fowy, draper 0
5260177 2433309 2433309 defendant Salter John merchant 586165 586165 Salter, John, of Fowy, merchant 0
5260179 2433310 2433310 defendant Salter John merchant 586165 586165 Salter, John, of Fowy, merchant 0
5347554 2459392 2459392 defendant Kendall John cordwainer 586165 586165 Kendall, John, of Fowy, cordwainer 0
5348850 2459769 2459769 defendant Petyt Mathew mariner 586165 586165 Petyt, Mathew, of Fowy, mariner 0
5348851 2459769 2459769 defendant Sheare John mariner 586165 586165 Sheare, John, of Fowy, mariner 1
5391490 2472638 2472638 defendant Ude Tristram merchant 586165 586165 Ude, Tristram, of Fowy, merchant 1
5404504 2476359 2476359 defendant Ude Christopher merchant 586165 586165 Ude, Christopher, of Fowy, merchant 1
5417517 2480160 2480160 defendant Pester Henry mercer 586165 586165 Pester, Henry, of Fowy, mercer 0
5417643 2480198 2480198 defendant Ude Tristram merchant 586165 586165 Ude, Tristram, of Fowy, merchant 1
5417828 2480257 2480257 defendant Malynsy John husbandman 586165 586165 Malynsy, John, of Fowy, husbandman 1
5448468 2489438 2489438 defendant George Lawrence carpenter 586165 586165 George, Lawrence, of Fowy, carpenter 0
5484671 2500339 2500339 defendant Stoner Richard yeoman 586165 586165 Stoner, Richard, of Fowy, yeoman 10
5487694 2501208 2501208 defendant Stokkys Ricjard yeoman 586165 586165 Stokkys, Ricjard, of Fowy, yeoman 5
5487923 2501278 2501278 defendant Philip Edward merchant 586165 586165 Philip, Edward, of Fowy, merchant 2
5487924 2501278 2501278 defendant Brewer William mariner 586165 586165 Brewer, William, of Fowy, mariner 3
5487927 2501278 2501278 defendant Ede Tristram mariner 586165 586165 Ede, Tristram, of Fowy, mariner: Sherethewyn, Renfrew, of St Columbe the Over, mariner 6
5488281 2501395 2501395 defendant Hycka Walter yeoman 586165 586165 Hycka, Walter, of Fowy, yeoman 3
5488290 2501397 2501397 defendant Wybbure John yeoman 586165 586165 Wybbure, John, of Fowy, yeoman 2

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