names

101 rows where place_id = 587251

✎ 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
3587966 1863890 1863890 defendant Waryn alias Reynold Adelm chaplain 587251 587251 Waryn alias Reynold, Adelm, of Marleburgh, Wilts, or of Fressheford, chaplain 0
3590913 1864786 1864786 defendant Spycer John mercer 587251 587251 Spycer, John, of Marleburgh, Wilts, mercer 0
3591147 1864851 1864851 defendant Somerfeld Robert chapman 587251 587251 Somerfeld, Robert, of Marleburgh, Wilts, chapman 3
3592186 1865175 1865175 defendant Gaywode John dyer 587251 587251 Gaywode, John, of Marleburgh, Wilts, dyer 1
3613217 1871788 1871788 defendant Spicer John chapman 587251 587251 Spicer, John, of Marleburgh, Wilts, chapman 2
3619722 1873739 1873739 defendant Spycer John mercer 587251 587251 Spycer, John, of Marleburgh, Wilts, mercer 0
3619726 1873740 1873740 defendant Spycer John mercer 587251 587251 Spycer, John,of Marleburgh, Wilts, mercer 0
3653069 1911289 1911289 defendant Lancaster Ralph mercer 587251 587251 Lancaster, Ralph, of Marleburgh, Wilts, mercer 0
3653073 1911290 1911290 defendant Lancaster Ralph mercer 587251 587251 Lancaster, Ralph, of Marleburgh, Wilts, mercer 0
3706443 1928301 1928301 defendant Powell John cordwainer 587251 587251 Powell, John, of Marleburgh, Wilts, cordwainer 1
3721098 1932896 1932896 defendant Cole Richard yeoman 587251 587251 Cole, Richard, of Marleburgh, Wilts, yeoman 1
3751256 1942316 1942316 defendant Poungerton Robert yeoman 587251 587251 Poungerton, Robert, of Marleburgh, Wilts, yeoman 0
3775059 1949931 1949931 defendant Chylde Robert tailor 587251 587251 Chylde, Robert, of Marleburgh, Wilts, tailor 0
3786063 1953432 1953432 defendant Bartilmewe Richard yeoman 587251 587251 Bartilmewe, Richard, of Marleburgh, Wilts, yeoman 1
3804964 1959496 1959496 defendant Owen William chapman 587251 587251 Owen, William, of Marleburgh, Wilts, chapman 1
3911986 1994334 1994334 defendant Pynncherton John plumber 587251 587251 Pynncherton, John, of Marleburgh, Wilts, plumber 0
4673874 2257446 2257446 defendant Iremonger William ironmonger 587251 587251 Iremonger, William, of Marleburgh, Wilts, ironmonger 0
4678010 2258737 2258737 defendant Bowyer Thomas chapman 587251 587251 Bowyer, Thomas, of Marleburgh, Wilts, chapman 0
4679234 2259113 2259113 defendant Smyth Richard yeoman 587251 587251 Smyth, Richard, of Marleburgh, Wilts, yeoman 1
4682414 2260121 2260121 plaintiff Neweman Thomas   587251 587251 Neweman, Thomas, of Marleburgh, Wilts 0
4683994 2260602 2260602 defendant Combe John brasier 587251 587251 Combe, John, of Marleburgh, Wilts, brasier 0
4684538 2260767 2260767 defendant Talbot Richard skinner 587251 587251 Talbot, Richard, of Marleburgh, Wilts, skinner 4
4688252 2261894 2261894 defendant Norton John carpenter 587251 587251 Norton, John, of Marleburgh, Wilts, carpenter 0
4698021 2264870 2264870 defendant Dyer Robert dyer 587251 587251 Dyer, Robert, of Marleburgh, Wilts, dyer 0
4698248 2264934 2264934 defendant Peraunt William draper 587251 587251 Peraunt, William, of Marleburgh, Wilts, draper 1
4710353 2268591 2268591 defendant Talbot Richard skinner 587251 587251 Talbot, Richard, of Marleburgh, Wilts, skinner 2
4732063 2275209 2275209 defendant Brydde John gent 587251 587251 Brydde, John, of Marleburgh, Wilts, gent 0
4732065 2275210 2275210 defendant Brydde John gent 587251 587251 Brydde, John, of Marleburgh, Wilts, gent 0
4740557 2277751 2277751 defendant Talbot Henry   587251 587251 Talbot, Henry, of Marleburgh, Wilts 1
4748411 2280041 2280041 defendant Peyntour Robert woolmonger 587251 587251 Peyntour, Robert, of Marleburgh, Wilts, woolmonger 1
4749363 2280294 2280294 defendant Combe John   587251 587251 Combe, John, of marleburgh, Wilts, bell founder 1
4754198 2281691 2281691 defendant Godale Thomas buthcer 587251 587251 Godale, Thomas, of Marleburgh, Wilts, buthcer 4
4770810 2286849 2286849 defendant Sener Peter husbandman 587251 587251 Sener, Peter, of Marleburgh, Wilts, husbandman 1
4782646 2290585 2290585 defendant Dyer Robert dyer 587251 587251 Dyer, Robert, of Marleburgh, Wilts, dyer 0
4818543 2301879 2301879 defendant Rys William chapman 587251 587251 Rys, William, of Marleburgh, Wilts, chapman 0
4825021 2303865 2303865 defendant Ryse William draper 587251 587251 Ryse, William, of Marleburgh, Wilts, draper 0
4833751 2306567 2306567 plaintiff Coke William   587251 587251 Coke, William, of Marleburgh, Wilts, wool monger 0
4845123 2309988 2309988 defendant Combe John   587251 587251 Combe, John, of Marleburgh, Wilts, belleyetre or bell founder 2
4846647 2310461 2310461 defendant Hese Thomas (legal representative) 587251 587251 Hese, Thomas, of Marleburgh, Wilts, merchant, executors of 0
4846648 2310461 2310461 defendant Fryse Robert mercer 587251 587251 (Fryse, Robert, of Marleburgh, Wilts, mercer 1
4855831 2313194 2313194 defendant Dodmere William (legal representative) 587251 587251 Dodmere, William, of Marleburgh, Wilts, executors of 0
4859614 2314379 2314379 defendant Spicer Thomas spicer 587251 587251 Spicer, Thomas, of Marleburgh, Wilts, spicer 0
4867933 2316939 2316939 defendant Terent William chapman 587251 587251 Terent, William, of Marleburgh, Wilts, chapman 3
4882866 2321558 2321558 plaintiff Coke William woolman 587251 587251 Coke, William, of Marleburgh, Wilts, woolman 0
4899954 2326623 2326623 defendant Joynour John carpenter 587251 587251 Joynour, John, of Marleburgh, Wilts, carpenter 0
4911817 2330200 2330200 defendant Wodeford John yeoman 587251 587251 Wodeford, John, of Marleburgh, Wilts, yeoman 0
4916503 2331666 2331666 defendant Masey John   587251 587251 Masey, John, of Marleburgh, Wilts, wool monger 1
4921946 2333270 2333270 defendant Cheyne John weaver 587251 587251 Cheyne, John, of Marleburgh, Wilts, weaver 0
4948605 2341543 2341543 defendant Fryse Robert mercer 587251 587251 Fryse, Robert, of Marleburgh, Wilts, mercer 0
4948609 2341544 2341544 defendant Fryse Robert merchant 587251 587251 Fryse, Robert, of Marleburgh, Wilts, merchant 0
4948612 2341545 2341545 defendant Fryse Robert merchant 587251 587251 Fryse, Robert, of Marleburgh, Wilts, merchant 0
4957038 2344058 2344058 defendant Barbour John barber 587251 587251 Barbour, John, of Marleburgh, Wilts, barber 19
5004652 2358261 2358261 defendant Fryse Robert mercer 587251 587251 Fryse, Robert, of Marleburgh, Wilts, mercer 1
5018807 2362387 2362387 defendant Tylecote alias Skedere Robert yeoman 587251 587251 Tylecote alias Skedere, Robert, of Marleburgh, Wilts, yeoman 2
5026119 2364535 2364535 defendant Monke John yeoman 587251 587251 Monke, John, of Marleburgh, Wilts, yeoman 3
5031041 2365955 2365955 defendant Spycer Thomas chapman 587251 587251 Spycer, Thomas, of Marleburgh, Wilts, chapman 1
5031053 2365957 2365957 defendant Spycer Thomas chapman 587251 587251 Spycer, Thomas, of Marleburgh, Wilts, chapman 1
5035072 2367120 2367120 defendant Cokkys John dyer 587251 587251 Cokkys, John, of Marleburgh, Wilts, dyer 0
5039674 2368510 2368510 defendant Geynys Stephen tailor 587251 587251 Geynys, Stephen, of Marleburgh, Wilts, tailor 3
5039680 2368511 2368511 defendant Geynys Stephen tailor 587251 587251 Geynys, Stephen, of Marleburgh, Wilts, tailor 3
5072509 2378263 2378263 defendant Mayhewe Nicholas dyer 587251 587251 Mayhewe, Nicholas, of Marleburgh, Wilts, dyer 0
5076997 2379618 2379618 defendant Duddebroke David (legal representative) 587251 587251 Duddebroke, David, of Marleburgh, Wilts, executrix of 0
5101968 2386999 2386999 defendant Foster Thomas fisher 587251 587251 Foster, Thomas, of Marleburgh, Wilts, fisher 0
5116241 2391180 2391180 defendant Hynde John baker 587251 587251 Hynde, John, of Marleburgh, Wilts, baker 0
5123627 2393368 2393368 defendant Fryse Robert yeoman 587251 587251 Fryse, Robert, of Marleburgh, Wilts,yeoman 1
5178932 2409568 2409568 defendant Trewe William mercer 587251 587251 Trewe, William, of Marleburgh, Wilts, mercer 0
5201675 2416259 2416259 defendant Trewe William mercer 587251 587251 Trewe, William, of Marleburgh, Wilts, mercer 0
5212483 2419396 2419396 defendant Mogge William yeoman 587251 587251 Mogge, William, of Marleburgh, Wilts, yeoman 0
5223543 2422573 2422573 defendant Chylde John chapman 587251 587251 Chylde, John, of Marleburgh, Wilts, chapman 1
5225231 2423054 2423054 defendant Baker Richard tanner 587251 587251 Baker, Richard, of Marleburgh, Wilts, tanner 0
5228156 2423843 2423843 defendant Spencer Robert husbandman 587251 587251 Spencer, Robert, of Marleburgh, Wilts, husbandman 1
5245746 2428919 2428919 defendant Baker Richard tanner 587251 587251 Baker, Richard, of Marleburgh, Wilts, tanner 0
5246147 2429034 2429034 defendant Baker Richard tanner 587251 587251 Baker, Richard, of Marleburgh, Wilts, tanner 0
5249935 2430092 2430092 defendant Spencer Robert husbandman 587251 587251 Spencer, Robert, of Marleburgh, Wilts, husbandman 1
5256958 2432307 2432307 defendant Bayly Nicholas draper 587251 587251 Bayly, Nicholas, of Marleburgh, Wilts, draper 0
5257632 2432508 2432508 plaintiff Fryse Robert chapman 587251 587251 Fryse, Robert, of Marleburgh, Wilts, chapman 0
5260281 2433343 2433343 defendant Childe John chapman 587251 587251 Childe, John, of Marleburgh, Wilts, chapman 1
5283158 2440138 2440138 defendant Coton William cordwainer 587251 587251 Coton, William, of Marleburgh, Wilts, cordwainer 0
5283163 2440140 2440140 defendant Glasyer William husbandman 587251 587251 Glasyer, William, of Marleburgh, Wilts, husbandman 0
5283181 2440147 2440147 defendant Coton William cordwainer 587251 587251 Coton, William, of Marleburgh, Wilts, cordwainer 0
5283192 2440151 2440151 defendant Glasyer William husbandman 587251 587251 Glasyer, William, of Marleburgh, Wilts, husbandman 0
5284961 2440624 2440624 defendant Michell John, junior gent 587251 587251 Michell, John, junior, of Marleburgh, Wilts, gent 0
5290677 2442274 2442274 defendant Batyn John saddler 587251 587251 Batyn, John, of Marleburgh, Wilts, saddler 2
5299269 2444759 2444759 defendant Halle John butcher 587251 587251 Halle, John, of Marleburgh, Wilts, butcher 2
5318222 2450543 2450543 defendant Austyn Felicia widow 587251 587251 (Austyn, Felicia, of Marleburgh, Wilts, widow 4
5320430 2451192 2451192 defendant Cornewalle William tanner 587251 587251 Cornewalle, William, of Marleburgh, Wilts, tanner 0
5321051 2451389 2451389 defendant Hynde John baker 587251 587251 Hynde, John, of Marleburgh, Wilts, baker 3
5328794 2453689 2453689 defendant Webbe William buther 587251 587251 Webbe, William, of Marleburgh, Wilts, buther 0
5334187 2455293 2455293 defendant Dolman William (legal representative) 587251 587251 Dolman, William, of Marleburgh, Wilts, executor of 0
5334190 2455294 2455294 defendant Dolman William (legal representative) 587251 587251 Dolman, William, of Marleburgh, Wilts, executors of 0
5493138 2502857 2502857 defendant Somersfeld Robert chapman 587251 587251 Somersfeld, Robert, of Marleburgh, Wilts, chapman 1
5493869 2503074 2503074 defendant Spencer Thomas saddler 587251 587251 Spencer, Thomas, of Marleburgh, Wilts, saddler 2
5504616 2506365 2506365 defendant Waryn alias Reynold Aldelm chaplain 587251 587251 Waryn alias Reynold, Aldelm, of Marleburgh, Wilts, chaplain 0
5504621 2506366 2506366 defendant Waryn alias Reynold Aldelum chaplain 587251 587251 Waryn alias Reynold, Aldelum, of Marleburgh, Wilts, chaplain 0
5531650 2514433 2514433 defendant Kene John   587251 587251 Kene, John, of Marleburgh, Wilts, mason 0
5543336 2518033 2518033 defendant Spycer John mercer 587251 587251 Spycer, John, of Marleburgh, Wilts, mercer 0
5545775 2518755 2518755 plaintiff Stodham John (legal representative) 587251 587251 Stodham, John, of Marleburgh, Wilts, executor of 0
5545778 2518756 2518756 plaintiff Stodham John (legal representative) 587251 587251 Stodham, John, of Marleburgh, Wilts, executor of 0
5545781 2518757 2518757 plaintiff Stodham John (legal representative) 587251 587251 Stodham, John, of Marleburgh, Wilts, executor of 0
5626834 2552365 2552365 defendant Smyth Robert yeoman 587251 587251 Smyth, Robert, of Marleburgh, Wilts, 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);