names

124 rows where place_id = 587901

✎ 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
3592772 1865351 1865351 defendant Wortley Thomas husbandman 587901 587901 Wortley, Thomas, of Holkham, husbandman 2
3593874 1865722 1865722 defendant Wortley Thomas husbandman 587901 587901 Wortley, Thomas, of Holkham, husbandman 2
3674891 1918177 1918177 defendant Clerke John husbandman 587901 587901 Clerke, John, of Holkham, husbandman 0
3719603 1932396 1932396 defendant Gygler John husbandman 587901 587901 Gygler, John, of Holkham, husbandman 2
3847398 1972747 1972747 defendant Dyckynson Roger clerk 587901 587901 Dyckynson, Roger, of Holkham, clerk 0
3865611 1978716 1978716 plaintiff Newgate John   587901 587901 Newgate, John, of Holkham 0
3865613 1978717 1978717 plaintiff Newgate John   587901 587901 Newgate, John, of Holkham 0
3922283 1997764 1997764 defendant Newgate John, senior (legal representative) 587901 587901 Newgate, John, senior, of Holkham, yeoman, executors of 0
3922284 1997764 1997764 defendant Tidde William husbandman 587901 587901 (Tidde, William, of Holkham, husbandman 1
4031181 2035821 2035821 defendant Mony John yeoman 587901 587901 Mony, John, of Holkham, yeoman 1
4031184 2035822 2035822 defendant Mony John yeoman 587901 587901 Mony, John, of Holkham, yeoman 1
4044405 2040452 2040452 defendant Seffoull Richard gent 587901 587901 Seffoull, Richard, of Holkham, gent 1
4044409 2040453 2040453 defendant Sefoule Richard gent 587901 587901 Sefoule, Richard, of Holkham, gent 1
4045426 2040815 2040815 defendant Monye John yeoman 587901 587901 Monye, John, of Holkham, yeoman 1
4067518 2048698 2048698 defendant Moneyman Francis laborer 587901 587901 Moneyman, Francis, of Holkham, laborer 0
4076937 2052038 2052038 defendant Monyman Francis yeoman 587901 587901 Monyman, Francis, of Holkham, yeoman 1
4081234 2053597 2053597 plaintiff Whetley William (legal representative) 587901 587901 Whetley, William, of Holkham, esq, Chief Prothonotary of the Court, executor of 0
4105325 2062185 2062185 defendant Whetley William esq 587901 587901 Whetley, William, of Holkham, esq 0
4184252 2089990 2089990 defendant Mansner Richard gent 587901 587901 Mansner, Richard, of Holkham, gent 0
4216722 2101342 2101342 defendant Whetley William (legal representative) 587901 587901 Whetley, William, of Holkham, gent, administratrix of 0
4216723 2101342 2101342 defendant Wyndham Alice widow 587901 587901 Wyndham, Alice, of Holkham, widow 1
4262950 2117272 2117272 defendant Wyndham Edmund (legal representative) 587901 587901 Wyndham, Edmund, of Holkham, esq, administratrix of 0
4273584 2120718 2120718 defendant Wyndham Edmund (legal representative) 587901 587901 Wyndham, Edmund, of Holkham, esq, administratrix of 0
4336204 2142393 2142393 defendant Monyman Francis yeoman 587901 587901 Monyman, Francis, of Holkham, yeoman 1
4389243 2161030 2161030 defendant Clarke William husbandman 587901 587901 Clarke, William, of Holkham, husbandman 2
4389736 2161191 2161191 defendant Clarke William husbandman 587901 587901 Clarke, William, of Holkham, husbandman 2
4406395 2166704 2166704 defendant Monyman Francis yeoman 587901 587901 Monyman, Francis, of Holkham, yeoman 0
4495377 2199234 2199234 defendant Bulwere Thomas   587901 587901 Bulwere, Thomas, of Holkham 1
4547052 2215013 2215013 plaintiff Bulwere Thomas   587901 587901 Bulwere, Thomas, of Holkham 0
4570982 2222490 2222490 defendant Burghman Thomas butcher 587901 587901 Burghman, Thomas, of Holkham, butcher 0
4570983 2222490 2222490 defendant Spellere John   587901 587901 Spellere, John, of Holkham 1
4603719 2232350 2232350 defendant Busshell John   587901 587901 Busshell, John, of Holkham 2
4614345 2235498 2235498 defendant Gonnore John   587901 587901 Gonnore, John, of Holkham 2
4634158 2241527 2241527 defendant Speller John   587901 587901 Speller, John, of Holkham 0
4637798 2242593 2242593 defendant Gunmore John   587901 587901 Gunmore, John, of Holkham 3
4640401 2243308 2243308 defendant Gonnore John   587901 587901 Gonnore, John, of Holkham 2
4644416 2244458 2244458 plaintiff Lyng John   587901 587901 Lyng, John, of Holkham 0
4649081 2245779 2245779 defendant Wharles John   587901 587901 Wharles, John, of Holkham 0
4649082 2245779 2245779 defendant Bulwere John   587901 587901 Bulwere, John, of Holkham 1
4692383 2263134 2263134 defendant Haliwell William yeoman 587901 587901 Haliwell, William, of Holkham, yeoman 0
4712343 2269175 2269175 defendant Halywell William yeoman 587901 587901 Halywell, William, of Holkham, yeoman 1
4754401 2281757 2281757 defendant atte Grene Sewall yeoman 587901 587901 atte Grene, Sewall, of Holkham, yeoman 1
4754402 2281757 2281757 defendant Doctour Robert yeoman 587901 587901 Doctour, Robert, of Holkham, yeoman 2
4754405 2281758 2281758 defendant atte Grene Sewall yeoman 587901 587901 atte Grene, Sewall, of Holkham, yeoman 1
4754406 2281758 2281758 defendant Doctour Robert yeoman 587901 587901 Doctour, Robert, of Holkham, yeoman 2
4813731 2300404 2300404 defendant Wryghte Richard husbandman 587901 587901 Wryghte, Richard, of Holkham, husbandman 0
4825810 2304109 2304109 defendant Holkham George esq 587901 587901 Holkham, George, of Holkham, esq 0
4834984 2306944 2306944 defendant Symms Robert husbandman 587901 587901 Symms, Robert, of Holkham, husbandman 2
4838323 2307903 2307903 defendant Langham John warrener 587901 587901 Langham, John, of Holkham, warrener 0
4839230 2308197 2308197 defendant Calwer William husbandman 587901 587901 Calwer, William, of Holkham, husbandman 0
4868072 2316986 2316986 defendant Langham John warrener 587901 587901 Langham, John, of Holkham, warrener 0
4871885 2318182 2318182 defendant Holkham George gent 587901 587901 Holkham, George, of Holkham, gent 0
4880005 2320659 2320659 defendant Holkham George esq 587901 587901 Holkham, George, of Holkham, esq 0
4916768 2331748 2331748 defendant Aylesham Thomas husbandman 587901 587901 Aylesham, Thomas, of Holkham, husbandman 0
4918286 2332241 2332241 defendant Weylond John husbandman 587901 587901 Weylond, John, of Holkham, husbandman 2
4936847 2337903 2337903 defendant Calware Robert husbandman 587901 587901 Calware, Robert, of Holkham, husbandman 1
4938023 2338265 2338265 defendant Lucas Thomas esq 587901 587901 Lucas, Thomas, of Holkham, esq 0
4943959 2340076 2340076 defendant Dokkyng Robert husbandman 587901 587901 Dokkyng, Robert, of Holkham, husbandman 0
4943960 2340076 2340076 defendant Odyman Roger husbandman 587901 587901 together with Odyman, Roger, of Holkham, husbandman 1
4943961 2340076 2340076 defendant Hendry Roger husbandman 587901 587901 Hendry, Roger, of Holkham, husbandman 2
4943962 2340076 2340076 defendant Ode Thomas husbandman 587901 587901 Ode, Thomas, of Holkham, husbandman 3
4943963 2340076 2340076 defendant Odyman John husbandman 587901 587901 Odyman, John, of Holkham, husbandman 4
4943965 2340077 2340077 defendant Odyman Roger husbandman 587901 587901 Odyman, Roger, of Holkham, husbandman 0
4943966 2340077 2340077 defendant Hendry Roger husbandman 587901 587901 Hendry, Roger, of Holkham, husbandman 1
4943967 2340077 2340077 defendant Ode Thomas husbandman 587901 587901 Ode, Thomas, of Holkham, husbandman 2
4943968 2340077 2340077 defendant Odyman John husbandman 587901 587901 Odyman, John, of Holkham, husbandman 3
4944893 2340393 2340393 defendant Gonnore William yeoman 587901 587901 Gonnore, William, of Holkham, yeoman 3
4985016 2352450 2352450 defendant Dodde Thomas husbandman 587901 587901 Dodde, Thomas, of Holkham, husbandman 0
4996133 2355701 2355701 defendant Weylond John husbandman 587901 587901 Weylond, John, of Holkham, husbandman 1
5030455 2365778 2365778 defendant Gunnore Robert yeoman 587901 587901 Gunnore, Robert, of Holkham, yeoman 0
5042593 2369386 2369386 plaintiff Dokkyng Robert   587901 587901 Dokkyng, Robert, of Holkham 0
5068029 2376940 2376940 defendant Newegate Agnes widow 587901 587901 Newegate, Agnes, of Holkham, widow 0
5068617 2377108 2377108 defendant Waylond John husbandman 587901 587901 Waylond, John, of Holkham, husbandman 0
5092608 2384215 2384215 defendant Newdegate Agnes widow 587901 587901 Newdegate, Agnes, of Holkham, widow 0
5104436 2387723 2387723 defendant Coo Roger husbandman 587901 587901 Coo, Roger, of Holkham, husbandman 3
5104437 2387723 2387723 defendant Coo Robert husbandman 587901 587901 Coo, Robert, of Holkham, husbandman 4
5114417 2390613 2390613 defendant Gunnore Robert yeoman 587901 587901 Gunnore, Robert, of Holkham, yeoman 0
5158174 2403511 2403511 plaintiff Porter Geoffrey   587901 587901 Porter, Geoffrey, of Holkham 0
5238239 2426769 2426769 defendant Weylond John husbandman 587901 587901 Weylond, John, of Holkham, husbandman 0
5238314 2426790 2426790 defendant Weylond John husbandman 587901 587901 Weylond, John, of Holkham, husbandman 0
5238316 2426791 2426791 defendant Weylond John husbandman 587901 587901 Weylond, John, of Holkham, husbandman 0
5244824 2428656 2428656 defendant Tayllour John husbandman 587901 587901 Tayllour, John, of Holkham, husbandman 2
5285361 2440739 2440739 defendant Tayllour John husbandman 587901 587901 Tayllour, John, of Holkham, husbandman 0
5285362 2440739 2440739 defendant Waylond William husbandman 587901 587901 Waylond, William, of Holkham, husbandman 1
5289044 2441806 2441806 plaintiff Mannyng Thomas   587901 587901 Mannyng, Thomas, of Holkham 0
5303511 2446046 2446046 defendant Talyour John (legal representative) 587901 587901 Talyour, John, of Holkham, husbandman, executors of 0
5303512 2446046 2446046 defendant Neugate John husbandman 587901 587901 (Neugate, John, of Holkham, husbandman 1
5303513 2446046 2446046 defendant Talyour Margaret widow 587901 587901 Talyour, Margaret, of Holkham, widow 2
5306054 2446799 2446799 plaintiff Mannyng Thomas   587901 587901 Mannyng, Thomas, of Holkham 0
5314600 2449400 2449400 defendant Tayllour Robert husbandman 587901 587901 Tayllour, Robert, of Holkham, husbandman 0
5314601 2449400 2449400 defendant Tayllour Richard husbandman 587901 587901 Tayllour, Richard, of Holkham, husbandman 1
5314603 2449401 2449401 defendant Weylond William husbandman 587901 587901 Weylond, William, of Holkham, husbandman 0
5314604 2449401 2449401 defendant Weylond Edmund husbandman 587901 587901 Weylond, Edmund, of Holkham, husbandman 1
5314605 2449401 2449401 defendant Andrewys John husbandman 587901 587901 Andrewys, John, of Holkham, husbandman 2
5314606 2449401 2449401 defendant Wryght William husbandman 587901 587901 Wryght, William, of Holkham, husbandman 3
5315112 2449577 2449577 plaintiff Clerk John   587901 587901 Clerk, John, of Holkham 0
5315113 2449577 2449577 plaintiff Pounfrete William   587901 587901 Pounfrete, William, of Holkham 1
5315114 2449577 2449577 defendant Elveryche John yeoman 587901 587901 Elveryche, John, of Holkham, yeoman 0
5321843 2451605 2451605 plaintiff Mannyng Thomas   587901 587901 Mannyng, Thomas, of Holkham 0
5324125 2452301 2452301 plaintiff Porte Geoffrey   587901 587901 Porte, Geoffrey, of Holkham 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);