names

260 rows where place_id = 604961

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657759 1912680 1912680 defendant Middlton John   604961 604961 Middlton, John, of Westminster, Middx, gent, son of John Middelton, knight, deceased, living in Wanseley, Notts, 0
3659871 1913342 1913342 defendant Parom Thomas clerk 604961 604961 Parom, Thomas, of Westminster, Middx, clerk 0
3664411 1914818 1914818 defendant Wymer Clement chaplain 604961 604961 Wymer, Clement, of Westminster, Middx, chaplain 4
3927478 1999535 1999535 defendant Duddeley Edward   604961 604961 Duddeley, Edward, of Westminster, Middx, knight & King's servant 0
3927612 1999577 1999577 defendant Bryger George yeoman 604961 604961 Bryger, George, of Westminster, Middx, yeoman 2
3929784 2000300 2000300 defendant Moson alias Waltoame William grocer 604961 604961 Moson alias Waltoame, William, of Westminster, Middx, grocer 1
3929785 2000300 2000300 defendant Mason William grocer 604961 604961 Mason, William, of Westminster, Middx, grocer 2
3929786 2000300 2000300 defendant Elithorne Richard yeoman 604961 604961 Elithorne, Richard, of Westminster, Middx, yeoman 3
3931117 2000714 2000714 defendant Twytt Robert gent 604961 604961 Twytt, Robert, of Westminster, Middx, gent 1
3937457 2002863 2002863 defendant Pekyns John   604961 604961 Pekyns, John, of Westminster, Middx, prebendary & Batchelor of Theology 0
3938183 2003108 2003108 defendant Browne William yeoman 604961 604961 Browne, William, of Westminster, Middx, yeoman 0
3940815 2003934 2003934 defendant Jamys John gent & sernior valet guard to the King 604961 604961 Jamys, John, of Westminster, Middx, gent & sernior valet guard to the King 0
4067043 2048511 2048511 defendant Turnor Robert leather seller 604961 604961 Turnor, Robert, of Westminster, Middx, leather seller 0
4144064 2076088 2076088 defendant Willoughbye William gent 604961 604961 Willoughbye, William, of Westminster, Middx, gent 0
4672600 2257073 2257073 defendant Nelson Gilbert   604961 604961 Nelson, Gilbert, of Westminster, Middx, mason 3
4672607 2257075 2257075 defendant Nelson Robert   604961 604961 Nelson, Robert, of Westminster, Middx, mason 3
4678099 2258760 2258760 defendant Weston Thomas   604961 604961 Weston, Thomas, of Westminster, Middx, chopchirche 0
4680638 2259556 2259556 defendant de la Pomeray William esq 604961 604961 de la Pomeray, William, of Westminster, Middx, esq 0
4686233 2261294 2261294 defendant Pomeraye William esq 604961 604961 Pomeraye, William, of Westminster, Middx, esq 0
4693117 2263352 2263352 defendant Clyfford Richard clerk 604961 604961 Clyfford, Richard, of Westminster, Middx, clerk 2
4693123 2263353 2263353 defendant Clyfford Richard clerk 604961 604961 Clyfford, Richard, of Westminster, Middx, clerk 2
4710459 2268628 2268628 defendant Kelm William clerk 604961 604961 Kelm, William, of Westminster, Middx, clerk 3
4710463 2268629 2268629 defendant Kelm William, senior clerk 604961 604961 Kelm, William, senior, of Westminster, Middx, clerk 2
4710609 2268672 2268672 defendant Joll John carter 604961 604961 Joll, John, of Westminster, Middx, carter 0
4711061 2268811 2268811 defendant Mapulton Peter   604961 604961 Mapulton, Peter, of Westminster, Middx, now staying in Winchester, mason 4
4713918 2269679 2269679 defendant Pomeray William esq 604961 604961 Pomeray, William, of Westminster, Middx, esq 0
4714901 2269992 2269992 defendant Saxby John gent 604961 604961 Saxby, John, of Westminster, Middx, gent 0
4714903 2269993 2269993 defendant Kenert Eleanor   604961 604961 Kenert, Eleanor, of Westminster, Middx, gentle woman, lady of Chalfdon 0
4723560 2272672 2272672 plaintiff Dernewell John   604961 604961 Dernewell, John, of Westminster, Middx 0
4727713 2273910 2273910 defendant Knappe Richard tailor 604961 604961 Knappe, Richard, of Westminster, Middx, tailor 1
4733358 2275609 2275609 defendant Kelm William chaplain 604961 604961 Kelm, William, of Westminster, Middx, chaplain 1
4733731 2275731 2275731 defendant Cook Henry butcher 604961 604961 Cook, Henry, of Westminster, Middx, butcher 0
4736394 2276511 2276511 defendant Sutton Alice widow & formerly wife of John 604961 604961 Sutton, Alice, of Westminster, Middx, widow & formerly wife of John 0
4736396 2276512 2276512 defendant Sutton Alice   604961 604961 Sutton, Alice, of Westminster, Middx, widow, formerly wife of John 0
4742858 2278420 2278420 defendant de la Pomeray William esq 604961 604961 de la Pomeray, William, of Westminster, Middx, esq 0
4743386 2278595 2278595 defendant Eton John gent 604961 604961 Eton, John, of Westminster, Middx, gent 0
4747675 2279827 2279827 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the Monastery of St Peter 0
4749786 2280414 2280414 defendant Skelton John skinner 604961 604961 Skelton, John, of Westminster, Middx, skinner 2
4751317 2280862 2280862 defendant Magot Richard butcher 604961 604961 Magot, Richard, of Westminster, Middx, butcher 2
4752141 2281107 2281107 defendant Arneburgh Robert gent 604961 604961 Arneburgh, Robert, of Westminster, Middx, gent 0
4753246 2281400 2281400 defendant Caudelsby John chaplain 604961 604961 Caudelsby, John, of Westminster, Middx, chaplain 1
4756472 2282393 2282393 defendant Basset Thomas gent 604961 604961 Basset, Thomas, of Westminster, Middx, gent 0
4759209 2283223 2283223 defendant Coppe William   604961 604961 Coppe, William, of Westminster, Middx, shoe maker 0
4759390 2283278 2283278 defendant Ryver William   604961 604961 Ryver, William, of Westminster, Middx, gold smith 0
4759392 2283279 2283279 defendant Ryver William   604961 604961 Ryver, William, of Westminster, Middx, gold smith 0
4760888 2283746 2283746 defendant (illegible) John clerk 604961 604961 _, John, of Westminster, Middx, clerk 0
4763110 2284443 2284443 defendant Gernon John clerk 604961 604961 Gernon, John, of Westminster, Middx, clerk 1
4763112 2284443 2284443 defendant Goldsmyth William goldsmith 604961 604961 together with Goldsmyth, William, of Westminster , Middx, goldsmith 3
4764685 2284943 2284943 defendant Cristyne Thomas chaplain 604961 604961 Cristyne, Thomas, of Westminster, Middx, chaplain 0
4766245 2285435 2285435 defendant Tewe Thomas esq 604961 604961 Tewe, Thomas, of Westminster, Middx, esq 2
4767123 2285702 2285702 defendant Tomes John chaplain 604961 604961 Tomes, John, of Westminster, Middx, chaplain 0
4767712 2285883 2285883 defendant Molyneux John gent 604961 604961 Molyneux, John, of Westminster, Middx, gent 0
4768238 2286037 2286037 defendant Hachet Thomas   604961 604961 (Hachet, Thomas, of Westminster, Middx, cook 1
4769119 2286317 2286317 defendant Ogle Thomas husbandman 604961 604961 Ogle, Thomas, of Westminster, Middx, husbandman 0
4771431 2287046 2287046 defendant Boury Robert ostler 604961 604961 Boury, Robert, of Westminster, Middx, ostler 0
4775466 2288323 2288323 defendant Dransfeld John   604961 604961 Dransfeld, John, of Westminster, Middx, servant 1
4807244 2298466 2298466 defendant Gront Alan husbandman 604961 604961 Gront, Alan, of Westminster, Middx, husbandman 2
4807612 2298571 2298571 defendant Gernon John clerk 604961 604961 Gernon, John, of Westminster, Middx, clerk 2
4807941 2298667 2298667 plaintiff Corby John   604961 604961 Corby, John, of Westminster, Middx, on his own account 0
4807991 2298679 2298679 defendant Merston Henry clerk 604961 604961 Merston, Henry, of Westminster, Middx, clerk 2
4807998 2298680 2298680 defendant Merston Henry clerk 604961 604961 Merston, Henry, of Westminster, Middx, clerk 3
4808005 2298682 2298682 defendant Merston Henry clerk 604961 604961 Merston, Henry, of Westminster, Middx, clerk 2
4808015 2298684 2298684 defendant Merston Henry clerk 604961 604961 Merston, Henry, of Westminster, Middx, clerk 2
4808784 2298914 2298914 defendant Broune Richard butcher 604961 604961 Broune, Richard, of Westminster, Middx, butcher 2
4814957 2300789 2300789 plaintiff Knappe Richard (legal representative) 604961 604961 Knappe, Richard, of Westminster, Middx, executors of 0
4817456 2301548 2301548 defendant Corn Simon butcher 604961 604961 Corn, Simon, of Westminster, Middx, butcher 0
4818689 2301930 2301930 defendant Merrshe William gent 604961 604961 Merrshe, William, of Westminster, Middx, gent 0
4818884 2301991 2301991 defendant Mersshe William gent 604961 604961 Mersshe, William, of Westminster, Middx, gent 0
4820477 2302478 2302478 defendant Baker Richard baker 604961 604961 Baker, Richard, of Westminster, Middx, baker 3
4823082 2303303 2303303 defendant Savage Peter merchant 604961 604961 Savage, Peter, of Westminster, Middx, merchant 0
4823863 2303544 2303544 defendant Arneburgh Robert gent 604961 604961 Arneburgh, Robert, of Westminster, Middx, gent 0
4827985 2304801 2304801 defendant Crowener John gent 604961 604961 Crowener, John, of Westminster, Middx, gent 3
4829131 2305151 2305151 defendant Vyvyan Adam gent 604961 604961 Vyvyan, Adam, of Westminster, Middx, gent 0
4830454 2305556 2305556 defendant Verdon John, sen carter 604961 604961 Verdon, John, sen, of Westminster, Middx, carter 2
4836632 2307430 2307430 defendant Crystyne Thomas chaplain 604961 604961 Crystyne, Thomas, of Westminster, Middx, chaplain 0
4837159 2307574 2307574 defendant Charyngworth Robert gent 604961 604961 Charyngworth, Robert, of Westminster, Middx, gent 0
4837672 2307714 2307714 defendant Charyngworth Robert gent 604961 604961 Charyngworth, Robert, of Westminster, Middx, gent 0
4841201 2308786 2308786 defendant Cristyns Thomas chaplain 604961 604961 Cristyns, Thomas, of Westminster, Middx, chaplain 0
4843948 2309625 2309625 defendant Raulyn John skinner 604961 604961 Raulyn, John, of Westminster, Middx, skinner 0
4851832 2312009 2312009 defendant Eggerley Hugh tailor 604961 604961 Eggerley, Hugh, of Westminster, Middx, tailor 2
4861608 2315002 2315002 defendant Scharnesfeld Margery widow 604961 604961 Scharnesfeld, Margery, of Westminster, Middx, widow 0
4907645 2328957 2328957 defendant Ryver William goldsmith 604961 604961 Ryver, William, of Westminster, Middx, goldsmith 0
4907685 2328970 2328970 defendant Scarlet William gent 604961 604961 Scarlet, William, of Westminster, Middx, gent 3
4911188 2330007 2330007 defendant Pouchemaker Andrew   604961 604961 Pouchemaker, Andrew, of Westminster, Middx, pouch maker 3
4914338 2330998 2330998 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the church of St Peter 0
4914340 2330999 2330999 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the church of St Peter 0
4914342 2331000 2331000 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the church of St Peter 0
4916531 2331676 2331676 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the Monastery of St Peter 0
4916872 2331779 2331779 plaintiff Forster Robert gent 604961 604961 Forster, Robert, of Westminster, Middx, gent, on his own account 0
4917151 2331871 2331871 defendant Wadwyk Richard gent 604961 604961 Wadwyk, Richard, of Westminster, Middx, gent 3
4921852 2333248 2333248 defendant Tanfeld John   604961 604961 Tanfeld, John, of Westminster, Middx, attorney 0
4921861 2333249 2333249 defendant Tanfeld John   604961 604961 Tanfeld, John, of Westminster, Middx, attorney 0
4921867 2333250 2333250 defendant Tanfeld John   604961 604961 Tanfeld, John, of Westminster, Middx, attorney 0
4921879 2333252 2333252 defendant Tanfeld John   604961 604961 Tanfeld, John, of Westminster, Middx, attorney 0
4922389 2333413 2333413 defendant Dabryscourt Joan widow 604961 604961 Dabryscourt, Joan, of Westminster, Middx, widow 3
4923116 2333647 2333647 defendant Bathe William   604961 604961 Bathe, William, of Westminster, Middx, wax chandler 1
4925046 2334266 2334266 defendant Hamond John gent 604961 604961 Hamond, John, of Westminster, Middx, gent 3
4926285 2334645 2334645 defendant Harweden Richard   604961 604961 Harweden, Richard, of Westminster, Middx, abbot of the Monastery of St Peter 0
4926951 2334858 2334858 defendant Kempe William yeoman 604961 604961 Kempe, William, of Westminster, Middx, yeoman 1
4931566 2336258 2336258 defendant Wardwyke Richard yeoman 604961 604961 Wardwyke, Richard, of Westminster, Middx, 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);