names

94 rows where place_id = 608645

✎ 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
3674648 1918121 1918121 defendant Marche Stephen pinner 608645 608645 Marche, Stephen, of Dekylburgh, pinner 1
3687166 1922163 1922163 defendant Frense Robert gent 608645 608645 Frense, Robert, of Dekylburgh, gent 0
3692269 1923752 1923752 defendant Gobet Robert smith 608645 608645 Gobet, Robert, of Dekylburgh, smith 2
3700163 1926284 1926284 defendant Frense Robert yeoman 608645 608645 Frense, Robert, of Dekylburgh, yeoman 0
3710025 1929445 1929445 defendant Crowlond Thomas yeoman 608645 608645 Crowlond, Thomas, of Dekylburgh, yeoman 0
3711566 1929928 1929928 defendant Frense Robert (legal representative) 608645 608645 Frense, Robert, of Dekylburgh, yeoman, executor of 0
3734815 1937134 1937134 defendant Gobett Robert smith 608645 608645 Gobett, Robert, of Dekylburgh, smith 2
3744351 1940135 1940135 defendant Conyngham Margaret widow 608645 608645 Conyngham, Margaret, of Dekylburgh, widow 1
3750886 1942199 1942199 defendant Crispe William tiler 608645 608645 Crispe, William, of Dekylburgh, tiler 0
3753031 1942884 1942884 defendant Hylle Nicholas roper 608645 608645 Hylle, Nicholas, of Dekylburgh, roper 0
3753032 1942884 1942884 defendant Estowe John husbandman 608645 608645 Estowe, John, of Dekylburgh, husbandman 1
3761978 1945753 1945753 defendant Estawe John gelder 608645 608645 Estawe, John, of Dekylburgh, gelder 0
3769394 1948084 1948084 defendant Erlond Thomas husbandman 608645 608645 Erlond, Thomas, of Dekylburgh, husbandman 3
3774076 1949607 1949607 defendant Harward Henry   608645 608645 Harward, Henry, of Dekylburgh, wheelwright 0
3783119 1952477 1952477 defendant Hill Nicholas roper 608645 608645 Hill, Nicholas, of Dekylburgh, roper 0
3791381 1955140 1955140 defendant Irlond Robert husbandman 608645 608645 Irlond, Robert, of Dekylburgh, husbandman 0
3795835 1956564 1956564 defendant Frensse Robert gent 608645 608645 Frensse, Robert, of Dekylburgh, gent 2
3801300 1958333 1958333 defendant Hill Nicholas roper 608645 608645 Hill, Nicholas, of Dekylburgh, roper 0
3801301 1958333 1958333 defendant Tebenham Thomas husbandman 608645 608645 Tebenham, Thomas, of Dekylburgh, husbandman 1
3806307 1959888 1959888 defendant Galle Robert yeoman 608645 608645 (Galle, Robert, of Dekylburgh, yeoman 4
3812345 1961752 1961752 defendant Frense Robert gent 608645 608645 Frense, Robert, of Dekylburgh, gent 0
3816513 1963069 1963069 defendant Hylle Nicholas roper 608645 608645 Hylle, Nicholas, of Dekylburgh, roper 0
3816514 1963069 1963069 defendant Tybbenham Thomas husbandman 608645 608645 Tybbenham, Thomas, of Dekylburgh, husbandman 1
3837110 1969508 1969508 defendant Woode William butcher 608645 608645 Woode, William, of Dekylburgh, butcher 1
3853584 1974747 1974747 defendant Gobett Robert blacksmith 608645 608645 Gobett, Robert, of Dekylburgh, blacksmith 2
3853587 1974748 1974748 defendant Frendys Robert gent 608645 608645 Frendys, Robert, of Dekylburgh, gent 0
3857111 1975855 1975855 defendant Humfrey John husbandman 608645 608645 Humfrey, John, of Dekylburgh, husbandman 1
3857920 1976118 1976118 defendant Frense Robert gent 608645 608645 Frense, Robert, of Dekylburgh, gent 0
3859172 1976558 1976558 defendant Conyngham Edward husbandman 608645 608645 Conyngham, Edward, of Dekylburgh, husbandman 0
3859244 1976585 1976585 defendant Conyngham Edward husbandman 608645 608645 Conyngham, Edward, of Dekylburgh, husbandman 0
3874909 1981833 1981833 defendant Bacon Elizabeth widow 608645 608645 Bacon, Elizabeth, of Dekylburgh, widow 0
3887263 1986005 1986005 defendant Estawe Thomas shoemaker 608645 608645 Estawe, Thomas, of Dekylburgh, shoemaker 2
3890547 1987100 1987100 defendant Uttyng William mercer 608645 608645 Uttyng, William, of Dekylburgh, mercer 0
3891449 1987408 1987408 defendant Cobbett Robert blacksmith 608645 608645 Cobbett, Robert, of Dekylburgh, blacksmith 0
3891454 1987409 1987409 defendant Gobbett Robert blacksmith 608645 608645 Gobbett, Robert, of Dekylburgh, blacksmith 0
3897478 1989370 1989370 defendant Underwode John yeoman 608645 608645 Underwode, John, of Dekylburgh, yeoman 1
3898203 1989606 1989606 defendant Uityng William mercer 608645 608645 Uityng, William, of Dekylburgh, mercer 1
3910166 1993713 1993713 defendant Gobbett Robert smith 608645 608645 Gobbett, Robert, of Dekylburgh, smith 1
3917323 1996152 1996152 defendant Frense Robert, senior gent 608645 608645 Frense, Robert, senior, of Dekylburgh, gent 0
3955832 2009113 2009113 defendant Frense Martin gent 608645 608645 Frense, Martin, of Dekylburgh, gent 0
4609386 2234035 2234035 defendant Heed Adam   608645 608645 Heed, Adam, of Dekylburgh 0
4818352 2301822 2301822 defendant Hendry John yeoman 608645 608645 Hendry, John, of Dekylburgh, yeoman 2
4897867 2325993 2325993 defendant Halle John husbandman 608645 608645 Halle, John, of Dekylburgh, husbandman 3
4901133 2326973 2326973 defendant Plomer Nicholas yeoman 608645 608645 Plomer, Nicholas, of Dekylburgh, yeoman 0
4949854 2341940 2341940 defendant Heed Thomas yeoman 608645 608645 Heed, Thomas, of Dekylburgh, yeoman 6
4949914 2341946 2341946 defendant Frense John butcher 608645 608645 Frense, John, of Dekylburgh, butcher 6
4962157 2345584 2345584 defendant Ely John husbandman 608645 608645 Ely, John, of Dekylburgh, husbandman 3
5008632 2359422 2359422 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5040032 2368616 2368616 defendant Baret William yeoman 608645 608645 Baret, William, of Dekylburgh, yeoman 0
5040120 2368644 2368644 defendant Bacon Richard   608645 608645 Bacon, Richard, of Dekylburgh, franklin 1
5057153 2373719 2373719 defendant Bakon Richard gent 608645 608645 Bakon, Richard, of Dekylburgh, gent 3
5123957 2393459 2393459 defendant Bakon Richard gent 608645 608645 Bakon, Richard, of Dekylburgh, gent 0
5123960 2393460 2393460 defendant Bakon Richard gent 608645 608645 Bakon, Richard, of Dekylburgh, gent 0
5180472 2410033 2410033 defendant Underwode John butcher 608645 608645 Underwode, John, of Dekylburgh, butcher 0
5212397 2419369 2419369 defendant Hed Thomas husbandman 608645 608645 Hed, Thomas, of Dekylburgh, husbandman 1
5214153 2419865 2419865 defendant Wederby Richard husbandman 608645 608645 Wederby, Richard, of Dekylburgh, husbandman 2
5218816 2421229 2421229 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5252604 2430931 2430931 plaintiff Baton or Bacon Richard gent 608645 608645 Baton or Bacon, Richard, of Dekylburgh, gent 0
5273804 2437416 2437416 defendant Hed (illegible) (legal representative) 608645 608645 Hed, ---, of Dekylburgh, butcher, executor of 3
5273805 2437416 2437416 defendant Hed John husbandman 608645 608645 Hed, John, of Dekylburgh, husbandman 4
5279390 2439056 2439056 defendant Bakon Richard gent 608645 608645 Bakon, Richard, of Dekylburgh, gent 7
5281452 2439645 2439645 defendant Stevenson William yeoman 608645 608645 Stevenson, William, of Dekylburgh, yeoman 1
5306055 2446799 2446799 defendant Sharpe William husbandman 608645 608645 Sharpe, William, of Dekylburgh, husbandman 0
5346849 2459171 2459171 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5346850 2459172 2459172 plaintiff Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5349711 2460046 2460046 defendant Trusse alias Arborogh Robert husbandman 608645 608645 Trusse alias Arborogh, Robert, of Dekylburgh, husbandman 0
5367516 2465486 2465486 defendant Uneyrwode John husbandman 608645 608645 Uneyrwode, John, of Dekylburgh, husbandman 1
5368742 2465814 2465814 plaintiff Dekys Walter   608645 608645 Dekys, Walter, of Dekylburgh 0
5368744 2465815 2465815 plaintiff Dekys Walter   608645 608645 Dekys, Walter, of Dekylburgh 0
5368746 2465816 2465816 plaintiff Dekys William   608645 608645 Dekys, William, of Dekylburgh 0
5386940 2471331 2471331 plaintiff Dokys Walter   608645 608645 Dokys, Walter, of Dekylburgh 0
5390140 2472241 2472241 defendant Wyte John husbandman 608645 608645 Wyte, John, of Dekylburgh, husbandman 1
5391853 2472746 2472746 defendant Karsey Nicholas yeoman 608645 608645 Karsey, Nicholas, of Dekylburgh, yeoman 1
5399243 2474853 2474853 plaintiff Dekys Walter   608645 608645 Dekys, Walter, of Dekylburgh 0
5399245 2474854 2474854 plaintiff Dekys Walter   608645 608645 Dekys, Walter, of Dekylburgh 0
5400991 2475349 2475349 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5404866 2476469 2476469 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5404867 2476469 2476469 defendant Karsey Nicholas yeoman 608645 608645 Karsey, Nicholas, of Dekylburgh, yeoman 1
5404869 2476470 2476470 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5414030 2479133 2479133 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5426874 2482984 2482984 plaintiff Dekys Walter   608645 608645 Dekys, Walter, of Dekylburgh 0
5429592 2483787 2483787 defendant Bacon Richard gent 608645 608645 Bacon, Richard, of Dekylburgh, gent 0
5435663 2485606 2485606 defendant Baton Richard gent 608645 608645 Baton, Richard, of Dekylburgh, gent 0
5435664 2485606 2485606 defendant Karsey Nicholas yeoman 608645 608645 Karsey, Nicholas, of Dekylburgh, yeoman 1
5459177 2492647 2492647 defendant Bakon Richard gent 608645 608645 Bakon, Richard, of Dekylburgh, gent 0
5509283 2507758 2507758 defendant Uttyng Richard yeoman 608645 608645 Uttyng, Richard, of Dekylburgh, yeoman 1
5538848 2516638 2516638 defendant Fuller John yeoman 608645 608645 Fuller, John, of Dekylburgh, yeoman 2
5568623 2525375 2525375 defendant Sherpyng John husbandman 608645 608645 Sherpyng, John, of Dekylburgh, husbandman 0
5568624 2525376 2525376 plaintiff Frense Robert, senior (legal representative) 608645 608645 Frense, Robert, senior, of Dekylburgh, executors of 0
5568632 2525377 2525377 plaintiff Frense Robert, senior (legal representative) 608645 608645 Frense, Robert, senior, of Dekylburgh, executors of 0
5577520 2528032 2528032 plaintiff Umfrey John   608645 608645 Umfrey, John, of Dekylburgh 1
5578217 2528258 2528258 defendant Tybenham William yeoman 608645 608645 Tybenham, William,of Dekylburgh, yeoman 0
5591871 2532444 2532444 defendant Harvy Robert husbandman 608645 608645 Harvy, Robert, of Dekylburgh, husbandman 1
5591872 2532444 2532444 defendant Baret John husbandman 608645 608645 Baret, John, of Dekylburgh, husbandman 2

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