names

142 rows where place_id = 587519

✎ 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
3591646 1865006 1865006 defendant Bedell John yeoman 587519 587519 Bedell, John, of Fulham, yeoman 0
3592781 1865354 1865354 defendant Brereton John esq 587519 587519 Brereton, John, of Fulham, esq 0
3612805 1871655 1871655 defendant Bedell John husbandman 587519 587519 Bedell, John, of Fulham, husbandman 2
3620939 1874111 1874111 defendant Lovell John yeoman 587519 587519 Lovell, John, of Fulham, yeoman 0
3621200 1874173 1874173 defendant Woode William husbandman 587519 587519 Woode, William, of Fulham, husbandman 0
3621204 1874173 1874173 defendant Roughede John yeoman 587519 587519 Roughede, John, of Fulham, yeoman 4
3621209 1874174 1874174 defendant Lovelles Nicholas yeoman 587519 587519 Lovelles, Nicholas, of Fulham, yeoman 2
3621210 1874174 1874174 defendant Mors John yeoman 587519 587519 Mors, John, of Fulham, yeoman 3
3627730 1903533 1903533 defendant Dakun John gent 587519 587519 Dakun, John, of Fulham, gent 0
3771151 1948666 1948666 defendant Dalle Nicholas (legal representative) 587519 587519 Dalle, Nicholas, of Fulham, husbandman, executors of 1
3771154 1948666 1948666 defendant Rowghhed John (legal representative) 587519 587519 Rowghhed, John, of Fulham, hudbandman, executors of 4
3771155 1948666 1948666 defendant Busshell William   587519 587519 (Busshell, William, of Fulham, mason 5
3776810 1950488 1950488 defendant Levys Robert smith 587519 587519 Levys, Robert, of Fulham, smith 2
3793574 1955852 1955852 defendant Gardun William yeoman 587519 587519 Gardun, William, of Fulham, yeoman 0
3793575 1955852 1955852 defendant Atwode Henry yeoman 587519 587519 Atwode, Henry, of Fulham, yeoman 1
3879088 1983259 1983259 defendant Stoke alias Kynnester Thomas yeoman 587519 587519 Stoke alias Kynnester, Thomas, of Fulham, yeoman 0
3962965 2011644 2011644 defendant Parker Henry gent 587519 587519 Parker, Henry, of Fulham, gent 0
4277740 2122139 2122139 defendant Hall John   587519 587519 Hall, John, of Fulham, wheelwright 0
4296225 2128748 2128748 defendant Hilton Edmund yeoman 587519 587519 Hilton, Edmund, of Fulham, yeoman 1
4393323 2162370 2162370 defendant Gryme George gent 587519 587519 Gryme, George, of Fulham, gent 0
4479755 2194331 2194331 defendant Parker John   587519 587519 Parker, John, of Fulham 0
4539536 2212626 2212626 defendant Hunt William, sen (legal representative) 587519 587519 Hunt, William, sen, of Fulham, executors of 0
4539537 2212626 2212626 defendant Hunt Alice   587519 587519 (Hunt, Alice, of Fulham, formerly wife of William 1
4601586 2231720 2231720 defendant Clerk John   587519 587519 Clerk, John, of Fulham 0
4638378 2242769 2242769 defendant Skynnere Walter   587519 587519 Skynnere, Walter, of Fulham 0
4645900 2244870 2244870 plaintiff Parker John   587519 587519 Parker, John, of Fulham 0
4645901 2244870 2244870 defendant Gerveys John   587519 587519 Gerveys, John, of Fulham, formerly parish clerk 0
4645902 2244871 2244871 plaintiff Parker John   587519 587519 Parker, John, of Fulham 0
4670146 2256368 2256368 defendant Clyfford Richard clerk 587519 587519 Clyfford, Richard, of Fulham, parson, formerly of Bishop's Clyve, Devon, clerk 0
4682255 2260073 2260073 plaintiff Navarne William   587519 587519 Navarne, William, of Fulham, on his own account 0
4682256 2260073 2260073 defendant Hardynge Richard husbandman 587519 587519 Hardynge, Richard, of Fulham, husbandman 0
4700395 2265537 2265537 defendant Edewen John husbandman 587519 587519 Edewen, John, of Fulham, husbandman 0
4782360 2290486 2290486 defendant Abbot Walter husbandman 587519 587519 Abbot, Walter, of Fulham, husbandman 0
4827869 2304771 2304771 defendant Eton Richard clerk 587519 587519 Eton, Richard, of Fulham, clerk 0
4827870 2304771 2304771 defendant Smalys Thomas yeoman 587519 587519 Smalys, Thomas, of Fulham, yeoman 1
4827871 2304771 2304771 defendant Haly Water Clerk Nicholas husbandman 587519 587519 Haly Water Clerk, Nicholas, of Fulham, husbandman 2
4845844 2310209 2310209 defendant Eton Richard clerk 587519 587519 Eton, Richard, of Fulham, clerk 0
4845845 2310209 2310209 defendant Smalys Thomas yeoman 587519 587519 Smalys, Thomas, of Fulham, yeoman 1
4845846 2310209 2310209 defendant Holy Water Clerk of Fulham Nicholas husbandman 587519 587519 Holy Water Clerk of Fulham, Nicholas, of Fulham, husbandman 2
4845884 2310223 2310223 defendant Eton Richard clerk 587519 587519 Eton, Richard, of Fulham, clerk 0
4845885 2310223 2310223 defendant Snalys Thomas yeoman 587519 587519 Snalys, Thomas, of Fulham, yeoman 1
4845886 2310223 2310223 defendant Haliwaterclerk Nicholas husbandman 587519 587519 Haliwaterclerk, Nicholas, of Fulham, husbandman 2
4962462 2345677 2345677 plaintiff Merssh Walter   587519 587519 Merssh, Walter, of Fulham 1
4991486 2354338 2354338 defendant Wakefeld Henry tailor 587519 587519 Wakefeld, Henry, of Fulham, tailor 0
5020557 2362903 2362903 defendant Shirborn John gent 587519 587519 Shirborn, John, of Fulham, gent 0
5056883 2373634 2373634 defendant atte Hunt John Adam (legal representative) 587519 587519 atte Hunt, John Adam, of Fulham, executrix of 2
5056884 2373634 2373634 defendant atte Hunt Edith widow 587519 587519 atte Hunt, Edith, of Fulham, widow 3
5061066 2374884 2374884 defendant Brook Henry gent 587519 587519 Brook, Henry, of Fulham, gent 0
5061068 2374885 2374885 defendant Brook Henry gent 587519 587519 Brook, Henry, of Fulham, gent 0
5061069 2374885 2374885 defendant Osebarne John husbandman 587519 587519 Osebarne, John, of Fulham, husbandman 1
5104357 2387699 2387699 defendant Southell John baker 587519 587519 Southell, John, of Fulham, baker 0
5106389 2388309 2388309 defendant Reynold John merchant 587519 587519 Reynold, John, of Fulham, merchant 0
5112927 2390174 2390174 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5112928 2390174 2390174 defendant Frankeleyn John husbandman 587519 587519 Frankeleyn, John, of Fulham, husbandman 1
5112929 2390174 2390174 defendant Bennyse or Benvyse Richard husbandman 587519 587519 Bennyse or Benvyse, Richard, of Fulham, husbandman 2
5112930 2390174 2390174 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 3
5112932 2390175 2390175 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5112933 2390175 2390175 defendant Frankeleyn John husbandman 587519 587519 Frankeleyn, John, of Fulham, husbandman 1
5112934 2390175 2390175 defendant Bennyse or Benvyse Richard husbandman 587519 587519 Bennyse or Benvyse, Richard, of Fulham, husbandman 2
5112935 2390175 2390175 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 3
5114046 2390499 2390499 defendant Shirwode John husbandman 587519 587519 Shirwode, John, of Fulham, husbandman 0
5130064 2395281 2395281 plaintiff Drevell or Dreuell John clerk & master 587519 587519 Drevell or Dreuell, John, of Fulham, clerk & master 0
5130066 2395282 2395282 plaintiff Drevell John   587519 587519 Drevell, John, of Fulham, Rector & Master 0
5158228 2403527 2403527 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5158229 2403527 2403527 defendant Frankelyn John husbandman 587519 587519 Frankelyn, John, of Fulham, husbandman 1
5158230 2403527 2403527 defendant Ben_ Richard husbandman 587519 587519 Ben_, Richard, of Fulham, husbandman 2
5158231 2403527 2403527 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 3
5159880 2403986 2403986 defendant Adam Hugh husbandman 587519 587519 Adam, Hugh, of Fulham, husbandman 0
5159881 2403986 2403986 defendant (not given) Henry vicar of Walfrey 587519 587519 Walfrey, Henry, of Fulham, clerk & vicar of the parish church 1
5159885 2403987 2403987 defendant Wakefeld John husbandman 587519 587519 Wakefeld, John, of Fulham, husbandman 1
5174291 2408186 2408186 defendant Bedyll Thomas husbandman 587519 587519 Bedyll, Thomas, of Fulham, husbandman 1
5184205 2411123 2411123 plaintiff Drevell John clerk & master 587519 587519 Drevell, John, of Fulham, clerk & master 0
5194083 2414001 2414001 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5194084 2414001 2414001 defendant Frankeleyn John husbandman 587519 587519 Frankeleyn, John, of Fulham, husbandman 1
5194085 2414001 2414001 defendant Bennyse Richard husbandman 587519 587519 Bennyse, Richard, of Fulham, husbandman 2
5194086 2414001 2414001 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 3
5194088 2414002 2414002 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5194089 2414002 2414002 defendant Bennyse Richard husbandman 587519 587519 Bennyse, Richard, of Fulham, husbandman 1
5194090 2414002 2414002 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 2
5194092 2414003 2414003 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5194093 2414003 2414003 defendant Bemyse Richard husbandman 587519 587519 Bemyse, Richard, of Fulham, husbandman 1
5194094 2414003 2414003 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 2
5194099 2414005 2414005 defendant Dalton William husbandman 587519 587519 Dalton, William, of Fulham, husbandman 0
5194100 2414005 2414005 defendant Bennyse Richard husbandman 587519 587519 Bennyse, Richard, of Fulham, husbandman 1
5194101 2414005 2414005 defendant Wakefeld Henry husbandman 587519 587519 Wakefeld, Henry, of Fulham, husbandman 2
5222202 2422199 2422199 defendant Bedell John husbandman 587519 587519 Bedell, John, of Fulham, husbandman 0
5222203 2422199 2422199 defendant Grene William husbandman 587519 587519 Grene, William, of Fulham, husbandman 1
5222204 2422199 2422199 defendant Raymond Henry husbandman 587519 587519 Raymond, Henry, of Fulham, husbandman 2
5240585 2427459 2427459 defendant Whithed Henry husbandman 587519 587519 Whithed, Henry, of Fulham, husbandman 2
5240586 2427459 2427459 defendant Benassh Richard husbandman 587519 587519 Benassh, Richard, of Fulham, husbandman 3
5241911 2427830 2427830 defendant Malory Margery   587519 587519 Malory, Margery, of Fulham, servant 2
5267809 2435694 2435694 defendant Walfrey Henry   587519 587519 Walfrey, Henry, of Fulham, vicar 1
5272294 2436968 2436968 defendant Walfrey Henry   587519 587519 Walfrey, Henry, of Fulham, vicar 1
5316055 2449878 2449878 defendant Colet Robert husbandman 587519 587519 Colet, Robert, of Fulham, or of Iseldon, husbandman 0
5320259 2451144 2451144 defendant Walter John husbandman 587519 587519 Walter, John, of Fulham, husbandman 2
5351828 2460674 2460674 defendant Moryell George husbandman 587519 587519 Moryell, George, of Fulham, husbandman 0
5383177 2470262 2470262 defendant Mitton Joan widow 587519 587519 Mitton, Joan, of Fulham, widow 0
5383178 2470262 2470262 defendant Wembeley George husbandman 587519 587519 Wembeley, George, of Fulham, husbandman 1
5383180 2470263 2470263 defendant Sturgion Beatrice widow 587519 587519 Sturgion, Beatrice, of Fulham, widow 0
5383182 2470264 2470264 defendant Sturgion Beatrice widow 587519 587519 Sturgion, Beatrice, of Fulham, widow 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);