names

162 rows where place_id = 585974

✎ 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
3587610 1863771 1863771 defendant Ayssheborne John innholder 585974 585974 Ayssheborne, John, of Shaftesbury, Dorset, innholder 1
3587641 1863778 1863778 defendant Shoyle William innholder 585974 585974 Shoyle, William, of Shaftesbury, Dorset, innholder 0
3588015 1863904 1863904 defendant Shoyle William innholder 585974 585974 Shoyle, William, of Shaftesbury, Dorset, innholder 0
3593106 1865471 1865471 defendant Collys Robert bowyer 585974 585974 Collys, Robert, of Shaftesbury, Dorset, bowyer 1
3605214 1869298 1869298 defendant Shoyle William innholder 585974 585974 Shoyle, William, of Shaftesbury, Dorset, innholder 0
3674405 1918040 1918040 defendant Amlen Christopher draper 585974 585974 Amlen, Christopher, of Shaftesbury, Dorset, draper 0
3681864 1920433 1920433 defendant Percy Thomas yeoman 585974 585974 Percy, Thomas, of Shaftesbury, Dorset, yeoman 1
3757816 1944421 1944421 defendant Horsey John, junior gent 585974 585974 Horsey, John, junior, of Shaftesbury, Dorset, gent 3
3769994 1948273 1948273 defendant Gawen Anne widow 585974 585974 Gawen, Anne, of Shaftesbury, Dorset, widow 0
3856644 1975703 1975703 defendant Lewys Hugh innholder 585974 585974 Lewys, Hugh, of Shaftesbury, Dorset, innholder 0
3861933 1977451 1977451 defendant Amlyn Christopher draper 585974 585974 Amlyn, Christopher, of Shaftesbury, Dorset, draper 0
3861975 1977465 1977465 defendant Amlyn Christopher Draper 585974 585974 Amlyn, Christopher, of Shaftesbury, Dorset, Draper 0
3870464 1980363 1980363 defendant Antell George esq 585974 585974 Antell, George, of Shaftesbury, Dorset, esq 0
3916209 1995809 1995809 defendant Redberd John chaplain 585974 585974 Redberd, John, of Shaftesbury, Dorset, chaplain 0
3945121 2005386 2005386 defendant Bayley John clothier 585974 585974 Bayley, John, of Shaftesbury, Dorset, clothier 3
3961528 2011132 2011132 defendant Bygg alias Neylle John clothier 585974 585974 Bygg alias Neylle, John, of Shaftesbury, Dorset, clothier 1
3982361 2018464 2018464 defendant Banester William yeoman 585974 585974 Banester, William, of Shaftesbury, Dorset, yeoman 2
3988502 2020631 2020631 defendant Wylkynes John cutler 585974 585974 Wylkynes, John, of Shaftesbury, Dorset, cutler 1
3988505 2020632 2020632 defendant Byrt James mercer 585974 585974 Byrt, James, of Shaftesbury, Dorset, mercer 1
3992818 2022186 2022186 plaintiff Byrte James innkeeper 585974 585974 Byrte, James, of Shaftesbury, Dorset, innkeeper 0
3997283 2023799 2023799 defendant Skydmore John gent 585974 585974 Skydmore, John, of Shaftesbury, Dorset, gent 2
4005582 2026772 2026772 defendant Poker John   585974 585974 Poker, John, of Shaftesbury, Dorset, yeoman, card maker 0
4017079 2030814 2030814 defendant Senyer John yeoman 585974 585974 Senyer, John, of Shaftesbury, Dorset, yeoman 1
4032564 2036295 2036295 defendant Bygge alias Bydyes Thomas glover 585974 585974 Bygge alias Bydyes, Thomas, of Shaftesbury, Dorset, glover 0
4077397 2052203 2052203 plaintiff Spiller John gent 585974 585974 Spiller, John, of Shaftesbury, Dorset, gent 0
4121063 2067822 2067822 defendant Spiller John gent 585974 585974 Spiller, John, of Shaftesbury, Dorset, gent 0
4124458 2069043 2069043 defendant Edward Thomas dyer 585974 585974 Edward, Thomas, of Shaftesbury, Dorset, dyer 0
4124467 2069047 2069047 defendant Spyllar John gent 585974 585974 Spyllar, John, of Shaftesbury, Dorset, gent 0
4124469 2069048 2069048 defendant Spyller John gent 585974 585974 Spyller, John, of Shaftesbury, Dorset, gent 0
4127239 2070034 2070034 defendant Hardy John haberdasher 585974 585974 Hardy, John, of Shaftesbury, Dorset, haberdasher 0
4131956 2071743 2071743 defendant Scudamore Thomas gent 585974 585974 Scudamore, Thomas, of Shaftesbury, Dorset, gent 0
4135472 2073007 2073007 defendant Edward Thomas vintner 585974 585974 Edward, Thomas, of Shaftesbury, Dorset, vintner 0
4190457 2092215 2092215 defendant Spyller John gent 585974 585974 Spyller, John, of Shaftesbury, Dorset, gent 0
4235637 2108033 2108033 defendant Anketill Christopher esq 585974 585974 Anketill, Christopher, of Shaftesbury, Dorset, esq 0
4292688 2127448 2127448 defendant Foyle Robert yeoman 585974 585974 Foyle, Robert, of Shaftesbury, Dorset, yeoman 1
4293664 2127797 2127797 defendant Foyle Robert yeoman 585974 585974 Foyle, Robert, of Shaftesbury, Dorset, yeoman 0
4318763 2136675 2136675 defendant Perne alias Reede Richard yeoman 585974 585974 Perne alias Reede, Richard, of Shaftesbury, Dorset, or of Launsels, Cornw, yeoman 0
4324474 2138578 2138578 defendant Cowper Thomas clerk 585974 585974 Cowper, Thomas, of Shaftesbury St Peter, Dorset, clerk 2
4347976 2146544 2146544 defendant Morgan Thomas draper 585974 585974 Morgan, Thomas, of Shaftesbury, Dorset, draper 0
4380636 2158182 2158182 defendant Morgan Thomas draper 585974 585974 Morgan, Thomas, of Shaftesbury, Dorset, draper 0
4451815 2185544 2185544 defendant Porter Robert   585974 585974 Porter, Robert, of Shaftesbury, Dorset 3
4651346 2246421 2246421 defendant Laurens John butcher 585974 585974 Laurens, John, of Shaftesbury, Dorset, butcher 1
4657733 2248303 2248303 defendant Osteler William ostler 585974 585974 Osteler, William, of Shaftesbury, Dorset, ostler 1
4658259 2248463 2248463 defendant Yorke Peter brasier 585974 585974 Yorke, Peter, of Shaftesbury, Dorset, brasier 0
4708674 2268087 2268087 defendant Eggeworth Edmund   585974 585974 Eggeworth, Edmund, of Shaftesbury, Dorset, brass worker 0
4717908 2270941 2270941 defendant Bagg Hugh fisher & ripyer 585974 585974 Bagg, Hugh, of Shaftesbury, Dorset, fisher & ripyer 3
4725310 2273207 2273207 defendant Haselmere Thomas mercer 585974 585974 Haselmere, Thomas, of Shaftesbury, Dorset, mercer 1
4728240 2274076 2274076 defendant Voke Richard   585974 585974 Voke, Richard, of Shaftesbury, Dorset, brass worker 0
4728243 2274077 2274077 defendant Voke Richard   585974 585974 Voke, Richard, of Shaftesbury, Dorset, brass worker 0
4728476 2274139 2274139 defendant Yorke Peter brasier 585974 585974 Yorke, Peter, of Shaftesbury, Dorset, brasier 0
4734558 2275974 2275974 defendant Voke Richard   585974 585974 Voke, Richard, of Shaftesbury, Dorset, brass worker 2
4739433 2277417 2277417 defendant Ostler Thomas ostler 585974 585974 Ostler, Thomas, of Shaftesbury, Dorset, ostler 2
4762998 2284411 2284411 defendant Bartylmewe John husbandman 585974 585974 Bartylmewe, John, of Shaftesbury, Dorset, husbandman 0
4765141 2285075 2285075 defendant Cokkes John butcher 585974 585974 Cokkes, John, of Shaftesbury, Dorset, butcher 1
4771083 2286936 2286936 defendant Colles John butcher 585974 585974 Colles, John, of Shaftesbury, Dorset, butcher 0
4771085 2286937 2286937 defendant Trill John butcher 585974 585974 Trill, John, of Shaftesbury, Dorset, butcher 0
4784478 2291150 2291150 defendant Osteler Thomas ostler 585974 585974 Osteler, Thomas, of Shaftesbury, Dorset, ostler 1
4784568 2291180 2291180 defendant Bole John carpenter 585974 585974 Bole, John, of Shaftesbury, Dorset, carpenter 0
4787106 2292030 2292030 defendant Gore Walter yeoman 585974 585974 Gore, Walter, of Shaftesbury, Dorset, yeoman 0
4793207 2293971 2293971 defendant Chaumbreleyn Robert yeoman 585974 585974 Chaumbreleyn, Robert, of Shaftesbury, Dorset, yeoman 4
4793215 2293972 2293972 defendant Chaumbreleyn Robert yeoman 585974 585974 Chaumbreleyn, Robert, of Shaftesbury, Dorset, yeoman 5
4800831 2296449 2296449 defendant Chaumbreleyn Robert yeoman 585974 585974 Chaumbreleyn, Robert, of Shaftesbury, Dorset, yeoman 4
4800839 2296450 2296450 defendant Chaumbreleyn Robert yeoman 585974 585974 Chaumbreleyn, Robert, of Shaftesbury, Dorset, yeoman 5
4828142 2304844 2304844 defendant Taillour John clothman 585974 585974 Taillour, John, of Shaftesbury, Dorset, clothman 0
4836078 2307263 2307263 defendant Willy John goldsmith 585974 585974 Willy, John, of Shaftesbury, Dorset, goldsmith 0
4845116 2309987 2309987 defendant Riggell Pepter   585974 585974 Riggell, Pepter, of Shaftesbury, Dorset, brass worker 2
4854891 2312883 2312883 defendant Taillour John mercer & brasier 585974 585974 Taillour, John, of Shaftesbury, Dorset, mercer & brasier 0
4854894 2312884 2312884 defendant Taillour John mercer & brasier 585974 585974 Taillour, John, of Shaftesbury, Dorset, mercer & brasier 0
4856592 2313443 2313443 defendant Mercer John mercer 585974 585974 Mercer, John, of Shaftesbury, Dorset, mercer 1
4856596 2313444 2313444 defendant Mercer John yeoman 585974 585974 Mercer, John, of Shaftesbury, Dorset, yeoman 2
4857370 2313693 2313693 defendant Style Walter husbandman 585974 585974 Style, Walter, of Shaftesbury, Dorset, husbandman 0
4859437 2314328 2314328 defendant Hopkyns Richard brewer 585974 585974 Hopkyns, Richard, of Shaftesbury, Dorset, brewer 0
4868014 2316964 2316964 defendant Cok John butcher 585974 585974 Cok, John, of Shaftesbury, Dorset, butcher 0
4872713 2318416 2318416 defendant Dyer John husbandman 585974 585974 Dyer, John, of Shaftesbury, Dorset, husbandman 3
4874349 2318921 2318921 defendant Frogmer William husbandman 585974 585974 Frogmer, William, of Shaftesbury, Dorset, husbandman 1
4878089 2320099 2320099 defendant Cornyssh John husbandman 585974 585974 Cornyssh, John, of Shaftesbury, Dorset, husbandman 2
4878095 2320100 2320100 defendant Cornyssh John husbandman 585974 585974 Cornyssh, John, of Shaftesbury, Dorset, husbandman 2
4878565 2320241 2320241 defendant Hugon Richard butcher 585974 585974 Hugon, Richard, of Shaftesbury, Dorset, butcher 0
4884793 2322144 2322144 defendant Pille John drover 585974 585974 Pille, John, of Shaftesbury, Dorset, drover 0
4885064 2322221 2322221 defendant Fore John   585974 585974 Fore, John, of Shaftesbury, Dorset 0
4890824 2323878 2323878 defendant Penin Roger gent 585974 585974 Penin, Roger, of Shaftesbury, Dorset, gent 0
4896112 2325441 2325441 defendant Dyer John husbandman 585974 585974 Dyer, John, of Shaftesbury, Dorset, husbandman 0
4899635 2326518 2326518 defendant Stille John fisher 585974 585974 (Stille, John, of Shaftesbury, Dorset, fisher 1
4901774 2327160 2327160 defendant Shefe John husbandman 585974 585974 Shefe, John, of Shaftesbury, Dorset, husbandman 2
4907531 2328918 2328918 defendant Dyer John husbandman 585974 585974 Dyer, John, of Shaftesbury, Dorset, husbandman 0
4938663 2338478 2338478 defendant Wegge William clerk 585974 585974 Wegge, William, of Shaftesbury, Dorset, clerk 0
4944702 2340329 2340329 defendant Cole William husbandman 585974 585974 Cole, William, of Shaftesbury, Dorset, husbandman 0
4963255 2345918 2345918 defendant Janyn Walter draper 585974 585974 Janyn, Walter, of Shaftesbury, Dorset, draper 2
4971485 2348399 2348399 defendant Mottecombe John mercer 585974 585974 Mottecombe, John, of Shaftesbury, Dorset, mercer 1
4973458 2349005 2349005 defendant Plummer John plumber 585974 585974 Plummer, John, of Shaftesbury, Dorset, plumber 0
4973793 2349118 2349118 defendant Serell John chapman 585974 585974 Serell, John, of Shaftesbury, Dorset, chapman 1
4976021 2349796 2349796 defendant Seerle John chapman 585974 585974 Seerle, John, of Shaftesbury, Dorset, chapman 1
4986747 2352974 2352974 defendant Peion Roger gent 585974 585974 Peion, Roger, of Shaftesbury, Dorset, gent 0
4991517 2354346 2354346 defendant Plomer John plumber 585974 585974 Plomer, John, of Shaftesbury, Dorset, plumber 0
4995867 2355610 2355610 defendant Sprak Richard   585974 585974 Sprak, Richard, of Shaftesbury, Dorset, fish jouter 0
5020931 2363017 2363017 defendant Payn John dyer 585974 585974 Payn, John, of Shaftesbury, Dorset, dyer 3
5053339 2372602 2372602 defendant Peton Roger gent 585974 585974 Peton, Roger, of Shaftesbury, Dorset, gent 0
5060499 2374718 2374718 defendant Mottecombe John, senior   585974 585974 Mottecombe, John, senior, of Shaftesbury, Dorset, chapman, administrators of 0
5060500 2374718 2374718 defendant Sexteyn John clerk 585974 585974 (Sexteyn, John, of Shaftesbury, Dorset, clerk 1
5073728 2378629 2378629 defendant Mottecombe John, senior   585974 585974 Mottecombe, John, senior, of Shaftesbury, Dorset, chapman, administrators of 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);