names

130 rows where place_id = 586868

✎ 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
3589848 1864466 1864466 defendant Canyn or Cavyn John yeoman 586868 586868 Canyn or Cavyn, John, of Kenton, yeoman 0
3590703 1864735 1864735 defendant Britknoll Roger fissher 586868 586868 Britknoll, Roger, of Kenton, fissher 0
3633375 1905250 1905250 defendant Elmer Thomas baker 586868 586868 Elmer, Thomas, of Kenton, baker 0
3634784 1905678 1905678 defendant Downe John   586868 586868 Downe, John, of Kenton, fish driver 0
3656515 1912289 1912289 defendant Garnysh Robert gent 586868 586868 Garnysh, Robert, of kenton, gent 0
3670408 1916700 1916700 defendant Stelle John husbandman 586868 586868 (Stelle, John,of Kenton, husbandman 1
3670609 1916771 1916771 defendant Clerk Nicholas yeoman 586868 586868 Clerk, Nicholas, of Kenton, yeoman 0
3671624 1917111 1917111 defendant Drewe John gent 586868 586868 Drewe, John, of Kenton, gent 1
3676188 1918597 1918597 defendant Browne John tucker 586868 586868 Browne, John, of Kenton, tucker 0
3681629 1920349 1920349 defendant Underhill Thomas yeoman 586868 586868 Underhill, Thomas, of Kenton, yeoman 0
3689807 1922968 1922968 defendant Gibbes Thomas gent 586868 586868 Gibbes, Thomas, of Kenton, gent 0
3690333 1923139 1923139 defendant Fulford Philip esq 586868 586868 Fulford, Philip, of Kenton, esq 0
3692304 1923763 1923763 defendant Toker Thomas yeoman 586868 586868 Toker, Thomas, of Kenton, yeoman 0
3696459 1925119 1925119 defendant Underhill Thomas yeoman 586868 586868 Underhill, Thomas, of Kenton, yeoman 0
3704747 1927773 1927773 defendant Drane William smith 586868 586868 Drane, William, of Kenton, smith 2
3704775 1927784 1927784 defendant Fulford Philip esq 586868 586868 Fulford, Philip, of Kenton, esq 0
3711723 1929980 1929980 defendant Cotton John yeoman 586868 586868 Cotton, John, of Kenton, yeoman 0
3711724 1929980 1929980 defendant Wylsford Peter gent 586868 586868 Wylsford, Peter, of Kenton, gent 1
3711728 1929982 1929982 defendant Wylsford Peter gent 586868 586868 Wylsford, Peter, of Kenton, gent 0
3711729 1929982 1929982 defendant Cotton John yeoman 586868 586868 Cotton, John, of Kenton, yeoman 1
3714942 1930968 1930968 defendant Drewe John gent 586868 586868 Drewe, John, of Kenton, gent 0
3718761 1932145 1932145 defendant Drane William smith 586868 586868 Drane, William, of Kenton, smith 0
3726697 1934612 1934612 defendant Cotton John yeoman 586868 586868 Cotton, John, of Kenton, yeoman 0
3726699 1934613 1934613 defendant Wylsford Peter gent 586868 586868 Wylsford, Peter, of Kenton, gent 0
3726700 1934613 1934613 defendant Cotton John yeoman 586868 586868 Cotton, John, of Kenton, yeoman 1
3728065 1935037 1935037 plaintiff Woode Lawrence (legal representative) 586868 586868 Woode, Lawrence, of Kenton, executors of 0
3729476 1935467 1935467 plaintiff Barlott Thomas (legal representative) 586868 586868 Barlott, Thomas, of Kenton, smith, executrix of 0
3743457 1939827 1939827 plaintiff Wode Lawrence (legal representative) 586868 586868 Wode, Lawrence, of Kenton, executor of 0
3779555 1951333 1951333 defendant Gylys Richard fisherman 586868 586868 Gylys, Richard, of Kenton, fisherman 2
3788758 1954288 1954288 defendant Jelys Richard   586868 586868 (Jelys, Richard, of Kenton, ship master 1
3797856 1957226 1957226 defendant Garneys John (legal representative) 586868 586868 Garneys, John, of Kenton, esq, executors of 0
3821632 1964649 1964649 defendant Novelott Robert husbandman 586868 586868 Novelott, Robert, of Kenton, husbandman 1
3825031 1965703 1965703 plaintiff Woode Lawrence (legal representative) 586868 586868 Woode, Lawrence, of Kenton, executor of 0
3832356 1968037 1968037 defendant Budde William beer brewer 586868 586868 Budde, William, of Kenton, beer brewer 1
3832478 1968079 1968079 defendant Keytt Edward laborer 586868 586868 Keytt, Edward, of Kenton, laborer 2
3844974 1971978 1971978 defendant Mabyn John yeoman 586868 586868 Mabyn, John, of Kenton, yeoman 2
3844975 1971978 1971978 defendant Awstyn Thomas yeoman 586868 586868 Awstyn, Thomas, of Kenton, yeoman 3
3844978 1971978 1971978 defendant Browne John yeoman 586868 586868 Browne, John, of Kenton, yeoman 6
3844979 1971978 1971978 defendant Borouth John yeoman 586868 586868 Borouth, John, of Kenton, yeoman 7
3846765 1972541 1972541 defendant Garnyshe John (legal representative) 586868 586868 Garnyshe, John, of Kenton, esq, executors of 0
3846766 1972541 1972541 defendant Garnyshe Elizabeth widow 586868 586868 (Garnyshe, Elizabeth, of Kenton, widow 1
3847921 1972926 1972926 defendant Budde William beer brewer 586868 586868 Budde, William, of Kenton, beer brewer 0
3848177 1972995 1972995 defendant Wytt Edmund laborer 586868 586868 Wytt, Edmund, of Kenton, laborer 2
3861725 1977386 1977386 plaintiff Garneys Robert esq 586868 586868 Garneys, Robert, of Kenton, esq 0
3863147 1977877 1977877 defendant Budde William beer brewer 586868 586868 Budde, William, of Kenton, beer brewer 0
3931268 2000749 2000749 defendant Maewe alias Maio Lawrence yeoman 586868 586868 Maewe alias Maio, Lawrence, of Kenton, yeoman 1
3931272 2000750 2000750 defendant Maewe alias Mais Lawrence yeoman 586868 586868 Maewe alias Mais, Lawrence, of Kenton, yeoman 2
3938315 2003152 2003152 defendant Gyllard Henry husbandman 586868 586868 Gyllard, Henry, of Kenton, husbandman 0
3941783 2004265 2004265 defendant Preston Thomas fuller of cloth 586868 586868 Preston, Thomas, of Kenton, fuller of cloth 0
3992164 2021961 2021961 defendant Peyrs William gent 586868 586868 Peyrs, William, of Kenton, gent 0
4091163 2057128 2057128 defendant Coxe Richard yeoman 586868 586868 Coxe, Richard, of Kenton, yeoman 0
4132628 2071991 2071991 defendant Luxe Thomas mariner 586868 586868 Luxe, Thomas, of Kenton, mariner 1
4191240 2092501 2092501 defendant Estchurche John yeoman 586868 586868 Estchurche, John, of Kenton, yeoman 0
4191241 2092501 2092501 defendant Estchurche Andrew yeoman 586868 586868 Estchurche, Andrew, of Kenton, yeoman 1
4191242 2092501 2092501 defendant Estchurche Thomas yeoman 586868 586868 Estchurche, Thomas, of Kenton, yeoman 2
4244019 2110981 2110981 defendant Garnyshe Nicholas   586868 586868 Garnyshe, Nicholas, of Kenton, esq, sheriff 0
4245082 2111339 2111339 defendant Garnishe Nicholas   586868 586868 Garnishe, Nicholas, of Kenton, esq, sheriff 0
4331308 2140767 2140767 defendant Fenn Bartholomew yeoman 586868 586868 Fenn, Bartholomew, of Kenton, yeoman 0
4338136 2143078 2143078 defendant Blakey or Blackey Walter yeoman 586868 586868 Blakey or Blackey, Walter, of Kenton, or of Sprawton, yeoman 0
4342541 2144664 2144664 defendant Canham Thomas miller 586868 586868 Canham, Thomas, of Kenton, miller 1
4382673 2158912 2158912 defendant Blakye Walter yeoman 586868 586868 Blakye, Walter, of Kenton, yeoman 1
4405002 2166244 2166244 defendant Acary John husbandman 586868 586868 Acary, John, of Kenton, husbandman 1
4441685 2182338 2182338 defendant Seye Geoffrey   586868 586868 Seye, Geoffrey, of Kenton 0
4452600 2185815 2185815 defendant Tok- Robert   586868 586868 Tok-, Robert, of Kenton 0
4515552 2205285 2205285 defendant Gateparth Nicholas   586868 586868 Gateparth, Nicholas, of Kenton 2
4538837 2212418 2212418 plaintiff Tyderlegh John   586868 586868 Tyderlegh, John, of Kenton 0
4596634 2230183 2230183 defendant Norton William   586868 586868 Norton, William, of kenton 0
4602985 2232148 2232148 defendant Provez William   586868 586868 Provez, William, of Kenton 2
4607873 2233578 2233578 defendant Dobbes Robert   586868 586868 Dobbes, Robert, of Kenton 0
4617831 2236580 2236580 defendant Feryman Robert chaplain 586868 586868 Feryman, Robert, of Kenton, chaplain 0
4647063 2245198 2245198 defendant Dobbe Robert   586868 586868 Dobbe, Robert, of Kenton 0
4660787 2249197 2249197 defendant Howelet Nicholas farmer 586868 586868 Howelet, Nicholas, of Kenton, farmer 2
4703675 2266529 2266529 defendant Crop William tailor 586868 586868 Crop, William, of Kenton, tailor 0
4754590 2281818 2281818 defendant Stannard Thomas   586868 586868 Stannard, Thomas, of Kenton, vicar 0
4775148 2288222 2288222 defendant Houlot John husbandman 586868 586868 Houlot, John, of Kenton, husbandman 0
4864715 2315934 2315934 defendant Hare John husbandman 586868 586868 Hare, John, of Kenton, husbandman 0
4884727 2322127 2322127 defendant Davy alias Ryng Richard yeoman 586868 586868 Davy alias Ryng, Richard, of Kenton, yeoman 0
4912906 2330532 2330532 defendant Payne Henry mariner 586868 586868 Payne, Henry, of Kenton, mariner 0
4919879 2332725 2332725 defendant Kene John mariner 586868 586868 Kene, John, of Kenton, mariner 3
4925141 2334297 2334297 defendant Croppe Willam husbandman 586868 586868 Croppe, Willam, of Kenton, tailor, Croppe, Thomas, of Kenton, husbandman 0
4925142 2334297 2334297 defendant Harry John husbandman 586868 586868 Harry, John, of Kenton, husbandman 1
4936376 2337769 2337769 defendant Sarger John fisher 586868 586868 Sarger, John, of Kenton, fisher 2
4939014 2338594 2338594 defendant Prewe John husbandman 586868 586868 Prewe, John, of Kenton, husbandman 0
4968235 2347453 2347453 defendant Biryknoll Richard butcher 586868 586868 Biryknoll, Richard, of Kenton, butcher 0
4985834 2352678 2352678 defendant Wynbroke Thomas skinner 586868 586868 Wynbroke, Thomas, of Kenton, skinner 2
5006454 2358787 2358787 defendant Shipmedewe John chaplain 586868 586868 Shipmedewe, John, of Kenton, chaplain 2
5012894 2360604 2360604 defendant Kenwode William husbandman 586868 586868 Kenwode, William, of Kenton, husbandman 0
5014989 2361263 2361263 plaintiff Toke Robert   586868 586868 Toke, Robert, of Kenton 1
5014992 2361264 2361264 plaintiff Toke Robert   586868 586868 Toke, Robert, of Kenton 1
5028026 2365076 2365076 defendant Nicoll Thomas husbandman 586868 586868 Nicoll, Thomas, of Kenton, husbandman 1
5028347 2365173 2365173 defendant Sturnell or Sturvell Peter yeoman 586868 586868 Sturnell or Sturvell, Peter, of Kenton, yeoman 0
5044768 2370071 2370071 defendant Kene John husbandman 586868 586868 Kene, John, of Kenton, husbandman 0
5044769 2370071 2370071 defendant Kene Joan widow 586868 586868 Kene, Joan, of Kenton, widow 1
5059732 2374474 2374474 defendant Robert John tailor 586868 586868 Robert, John, of Kenton, tailor 1
5059733 2374474 2374474 defendant Deryknoll John husbandman 586868 586868 Deryknoll, John, of Kenton, husbandman 2
5074514 2378878 2378878 defendant Aldrych John husbandman 586868 586868 Aldrych, John, of Kenton, husbandman 4
5131060 2395570 2395570 defendant Bury Thomas merchant 586868 586868 Bury, Thomas, of Kenton, merchant 1
5150567 2401307 2401307 defendant Bury Thomas merchant 586868 586868 Bury, Thomas, of Kenton, merchant 1
5190371 2412926 2412926 defendant Spych William husbandman 586868 586868 Spych, William, of Kenton, husbandman 0
5219384 2421395 2421395 defendant Piers John tailor 586868 586868 Piers, John, of Kenton, tailor 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);