names

148 rows where place_id = 590212

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3600252 1867726 1867726 defendant Harry John yeoman 590212 590212 Harry, John, of Dertford, Kent, yeoman 0
3602288 1868381 1868381 defendant Coke alias Loke Thomas innholder 590212 590212 Coke alias Loke, Thomas, of Dertford, Kent, innholder 0
3602977 1868597 1868597 defendant Rossell John   590212 590212 Rossell, John, of Dertford, Kent, wood monger 0
3604499 1869073 1869073 defendant Aboure Robert yeoman 590212 590212 Aboure, Robert, of Dertford, Kent, yeoman 0
3606441 1869682 1869682 defendant Cowele William gent 590212 590212 Cowele, William, of Dertford, Kent, gent 0
3608157 1870204 1870204 defendant Seynton John innholder 590212 590212 Seynton, John, of Dertford, Kent, innholder 0
3614520 1872189 1872189 defendant Cooke Thomas innholder 590212 590212 Cooke, Thomas, of Dertford, Kent, innholder 2
3614524 1872190 1872190 defendant Cooke Thomas innholder 590212 590212 Cooke, Thomas, of Dertford, Kent, innholder 2
3620651 1874038 1874038 defendant Quynton Thomas   590212 590212 Quynton, Thomas, of Dertford, Kent, wheelwright 2
3622495 1874573 1874573 defendant Quyntyn Thomas   590212 590212 Quyntyn, Thomas, of Dertford, Kent, wheelwright 2
3622633 1874609 1874609 defendant Coke Thomas innholder 590212 590212 Coke, Thomas, of Dertford, Kent, innholder 0
3622641 1874611 1874611 defendant Coke Thomas innholder 590212 590212 Coke, Thomas, of Dertford, Kent, innholder 2
3675459 1918362 1918362 defendant Whitefeld John butcher 590212 590212 Whitefeld, John, of Dertford, Kent, butcher 0
3700728 1926479 1926479 defendant Halkys or Hawys Thomas gent 590212 590212 Halkys or Hawys, Thomas, of Dertford, Kent, gent 0
3702320 1926984 1926984 defendant Chirche Thomas husbandman 590212 590212 Chirche, Thomas, of Dertford, Kent, husbandman 4
3705747 1928078 1928078 defendant Brande Roger yeoman 590212 590212 Brande, Roger, of Dertford, Kent, yeoman 3
3706623 1928356 1928356 defendant Apylton Roger gent 590212 590212 Apylton, Roger, of Dertford, Kent, gent 1
3708966 1929097 1929097 defendant Ellyngdon alias Glendon John yeoman 590212 590212 Ellyngdon alias Glendon, John, of Dertford, Kent, yeoman 0
3708968 1929098 1929098 defendant Elyngdon John yeoman 590212 590212 Elyngdon, John, of Dertford, Kent, yeoman 0
3723142 1933505 1933505 defendant Apulton Roger gent 590212 590212 Apulton, Roger, of Dertford, Kent, gent 0
3723326 1933566 1933566 defendant Long John smith 590212 590212 Long, John, of Dertford, Kent, smith 0
3733763 1936813 1936813 defendant Appulton Roger gent 590212 590212 Appulton, Roger, of Dertford, Kent, gent 0
3734497 1937034 1937034 defendant at Yerde Thomas smith 590212 590212 at Yerde, Thomas, of Dertford, Kent, smith 0
3742066 1939386 1939386 defendant Reynold Christopher carpenter 590212 590212 Reynold, Christopher, of Dertford, Kent, carpenter 0
3745430 1940475 1940475 defendant Appulton Roger esq 590212 590212 Appulton, Roger, of Dertford, Kent, esq 0
3751422 1942361 1942361 defendant Cochar Peter yeoman 590212 590212 Cochar, Peter, of Dertford, Kent, yeoman 0
3807749 1960311 1960311 defendant Wynne alias Whyte Richard husbandman 590212 590212 Wynne alias Whyte, Richard, of Dertford, Kent, husbandman 0
3807761 1960312 1960312 defendant Lloid Richard clerk 590212 590212 Lloid, Richard, of Dertford, Kent, clerk 3
3897779 1989462 1989462 defendant Parker Thomas yeoman 590212 590212 Parker, Thomas, of Dertford, Kent, yeoman 1
3899566 1990072 1990072 defendant Thompson John yeoman 590212 590212 Thompson, John, of Dertford, Kent, yeoman 0
3899570 1990074 1990074 defendant Tompson John yeoman 590212 590212 Tompson, John, of Dertford, Kent, yeoman 0
4015918 2030383 2030383 defendant Chamberlyne Christopher gent 590212 590212 Chamberlyne, Christopher, of Dertford, Kent, gent 0
4110960 2064169 2064169 defendant Rawson William yeoman 590212 590212 Rawson, William, of Dertford, Kent, yeoman 1
4127094 2069980 2069980 defendant Franck John chapman 590212 590212 Franck, John, of Dertford, Kent, chapman 2
4235866 2108118 2108118 defendant Estrigge Edward brewer 590212 590212 Estrigge, Edward, of Dertford, Kent, brewer 0
4681136 2259729 2259729 defendant Buston John   590212 590212 Buston, John, of Dertford, Kent, cook 3
4786870 2291954 2291954 defendant Gardynere John butcher 590212 590212 Gardynere, John, of Dertford, Kent, butcher 1
4786877 2291956 2291956 defendant Gardynere John butcher 590212 590212 Gardynere, John, of Dertford, Kent, butcher 1
4816133 2301134 2301134 defendant Bryd John hostiller 590212 590212 (Bryd, John, of Dertford, Kent, hostiller 1
4818592 2301896 2301896 defendant Howeton Thomas husbandman 590212 590212 Howeton, Thomas, of Dertford, Kent, husbandman 1
4818721 2301943 2301943 defendant Howeton Thomas husbandman 590212 590212 Howeton, Thomas, of Dertford, Kent, husbandman 1
4889372 2323468 2323468 defendant Warreve John clerk 590212 590212 Warreve, John, of Dertford, Kent, clerk 0
4894739 2325026 2325026 defendant Milford John chapman 590212 590212 Milford, John, of Dertford, Kent, chapman 0
4894741 2325027 2325027 defendant Milford John chapman 590212 590212 Milford, John, of Dertford, Kent, chapman 0
4896225 2325479 2325479 defendant Revet James husbandman 590212 590212 Revet, James, of Dertford, Kent, husbandman 0
4930212 2335852 2335852 defendant Godborowe m John chapman 590212 590212 Godborowe,m John, of Dertford, Kent, chapman 2
5022032 2363338 2363338 defendant Underdowne Thomas husbandman 590212 590212 Underdowne, Thomas, of Dertford, Kent, husbandman 0
5022416 2363455 2363455 defendant Adene John husbandman 590212 590212 (Adene, John, of Dertford, Kent, husbandman 4
5039794 2368545 2368545 plaintiff Bost Thomas gent 590212 590212 Bost, Thomas, of Dertford, Kent, gent 0
5042053 2369228 2369228 defendant Kyrkeby John husbandman 590212 590212 Kyrkeby, John, of Dertford, Kent, husbandman 1
5042930 2369498 2369498 defendant Kyrkeby John husbandman 590212 590212 Kyrkeby, John, of Dertford, Kent, husbandman 1
5044507 2369987 2369987 defendant Rodele William yeoman 590212 590212 Rodele, William, of Dertford, Kent, yeoman 0
5045176 2370189 2370189 defendant Revet Thomas husbandman 590212 590212 Revet, Thomas, of Dertford, Kent, husbandman 0
5052273 2372286 2372286 defendant Dene John yeoman 590212 590212 Dene, John, of Dertford, Kent, yeoman 2
5053777 2372730 2372730 defendant Martyn John gent 590212 590212 Martyn, John, of Dertford, Kent, gent 0
5077661 2379815 2379815 plaintiff Bolton Richard esq 590212 590212 Bolton, Richard, of Dertford, Kent, esq 0
5089268 2383230 2383230 defendant Appilton Roger, senior gent 590212 590212 Appilton, Roger, senior, of Dertford, Kent, gent 0
5089276 2383231 2383231 defendant Appilton Roger, senior gent 590212 590212 Appilton, Roger, senior, of Dertford, Kent, gent 0
5129304 2395058 2395058 defendant Gubbyn Thomas   590212 590212 Gubbyn, Thomas, of Dertford, Kent, wax chandler 3
5130063 2395280 2395280 defendant Appulton Roger, junior esq 590212 590212 Appulton, Roger, junior, of Dertford, Kent, esq 0
5133714 2396355 2396355 defendant Appelton Roger, junior gent 590212 590212 Appelton, Roger, junior, of Dertford, Kent, gent 0
5133890 2396405 2396405 defendant Auger of Anger Henry   590212 590212 Auger of Anger, Henry, of Dertford, Kent 0
5213689 2419738 2419738 defendant Appelton Roger gent 590212 590212 Appelton, Roger, of Dertford, Kent, gent 0
5217244 2420779 2420779 defendant Grenewode Thomas skinner 590212 590212 Grenewode, Thomas, of Dertford, Kent, skinner 0
5220647 2421734 2421734 defendant Worth William yeoman 590212 590212 Worth, William, of Dertford, Kent, yeoman 0
5225646 2423172 2423172 defendant Revet Thomas cooper 590212 590212 Revet, Thomas, of Dertford, Kent, cooper 0
5236618 2426293 2426293 defendant Bost Thomas husbandman 590212 590212 Bost, Thomas, of Dertford, Kent, husbandman 4
5239366 2427098 2427098 defendant Grenewod Thomas skinner 590212 590212 Grenewod, Thomas, of Dertford, Kent, skinner 2
5239370 2427099 2427099 defendant Grenewod Thomas skinner 590212 590212 Grenewod, Thomas, of Dertford, Kent, skinner 2
5241383 2427673 2427673 defendant Broun Thomas gent 590212 590212 Broun, Thomas, of Dertford, Kent, gent 0
5241385 2427674 2427674 defendant Broun Thomas gent 590212 590212 Broun, Thomas, of Dertford, Kent, gent 0
5244551 2428587 2428587 defendant Grenewode William   590212 590212 Grenewode, William, of Dertford, Kent, tallow chandler 4
5247259 2429358 2429358 defendant Goldewyn Richard glover 590212 590212 Goldewyn, Richard, of Dertford, Kent, glover 0
5254253 2431454 2431454 defendant Broun George gent 590212 590212 Broun, George, of Dertford, Kent, gent 0
5257098 2432353 2432353 defendant Hert Richard yeoman 590212 590212 Hert, Richard, of Dertford, Kent, yeoman 0
5259959 2433237 2433237 defendant Rotheley Roger gent 590212 590212 Rotheley, Roger, of Dertford, Kent, gent 0
5259980 2433244 2433244 defendant Rotheley Roger gent 590212 590212 Rotheley, Roger, of Dertford, Kent, gent 0
5271587 2436786 2436786 defendant Hebgode William husbandman 590212 590212 Hebgode, William, of Dertford, Kent, husbandman 0
5272306 2436970 2436970 defendant Hert Richard chapman 590212 590212 Hert, Richard, of Dertford, Kent, chapman 4
5272312 2436971 2436971 defendant Hert Richard chapman 590212 590212 Hert, Richard, of Dertford, Kent, chapman 4
5272543 2437045 2437045 defendant Appelton Roger gent 590212 590212 Appelton, Roger, of Dertford, Kent, gent 0
5272553 2437047 2437047 defendant Salet John smith 590212 590212 Salet, John, of Dertford, Kent, smith 2
5272688 2437089 2437089 defendant Cotys Robert gent 590212 590212 Cotys, Robert, of Dertford, Kent, gent 2
5272704 2437094 2437094 defendant Wyndesore Edmund yeoman 590212 590212 Wyndesore, Edmund, of Dertford, Kent, yeoman 0
5272706 2437095 2437095 defendant Wyndesore (illegible) yeoman 590212 590212 Wyndesore, ---, of Dertford, Kent, yeoman 0
5272710 2437096 2437096 defendant Cotys Robert gent 590212 590212 Cotys, Robert, of Dertford, Kent, gent 2
5283675 2440273 2440273 defendant Worthe William ostler 590212 590212 Worthe, William, of Dertford, Kent, ostler 0
5283875 2440314 2440314 defendant Coke Thomas hosteler 590212 590212 Coke, Thomas, of Dertford, Kent, hosteler 1
5283878 2440315 2440315 defendant Coke Thomas hosteler 590212 590212 Coke, Thomas, of Dertford, Kent, hosteler 1
5284971 2440627 2440627 defendant Boteller Richard draper 590212 590212 Boteller, Richard, of Dertford, Kent, draper 1
5285330 2440731 2440731 plaintiff Groveherst John gent 590212 590212 Groveherst, John, of Dertford, Kent, gent 0
5285334 2440732 2440732 plaintiff Groveherst John gent 590212 590212 Groveherst, John, of Dertford, Kent, gent 0
5285591 2440808 2440808 defendant Worth William yeoman 590212 590212 Worth, William, of Dertford, Kent, yeoman 0
5290563 2442242 2442242 defendant Blaknall John tailor 590212 590212 Blaknall, John, of Dertford, Kent, tailor 3
5291066 2442389 2442389 defendant Lucas John fuller 590212 590212 Lucas, John, of Dertford, Kent, fuller 4
5295314 2443625 2443625 defendant Wyndesore Edmund yeoman 590212 590212 Wyndesore, Edmund, of Dertford, Kent, yeoman 0
5295316 2443626 2443626 defendant Wyndesore Edmund yeoman 590212 590212 Wyndesore, Edmund, of Dertford, Kent, yeoman 0
5313952 2449196 2449196 defendant Wyndesore Edmund woodmonger 590212 590212 Wyndesore, Edmund, of Dertford, Kent, woodmonger 0
5314243 2449276 2449276 defendant Wyndesore Edmund woodmonger 590212 590212 Wyndesore, Edmund, of Dertford, Kent, woodmonger 0
5316411 2449988 2449988 defendant Warlowe alias Taylour John yeoman 590212 590212 Warlowe alias Taylour, John, of Dertford, Kent, yeoman 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);