names

102 rows where place_id = 587219

✎ 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
3590795 1864760 1864760 defendant Knap Gregory butcher 587219 587219 Knap, Gregory, of Ufford, butcher 2
3646869 1909419 1909419 defendant Smyth Robert husbandman 587219 587219 Smyth, Robert, of Ufford, husbandman 1
3650551 1910540 1910540 defendant Norman Robert mercer 587219 587219 Norman, Robert, of Ufford, mercer 0
3715705 1931203 1931203 plaintiff Symond Thomas   587219 587219 (Symond, Thomas, of Ufford 1
3756804 1944100 1944100 defendant Chetylber Richard   587219 587219 Chetylber, Richard, of Ufford, wheelwright 1
3764786 1946651 1946651 defendant Aldred Robert mercer 587219 587219 Aldred, Robert, of Ufford, mercer 0
3772575 1949115 1949115 plaintiff Waller Thomas   587219 587219 Waller, Thomas, of Ufford 0
3906130 1992341 1992341 defendant Cooke Thomas butcher 587219 587219 Cooke, Thomas, of Ufford, butcher 0
3955327 2008932 2008932 defendant Goldyng Thomas husbandman 587219 587219 Goldyng, Thomas, of Ufford, husbandman 3
4057567 2045085 2045085 defendant Strycklond Anthony husbandman 587219 587219 Strycklond, Anthony, of Ufford, husbandman 1
4182342 2089300 2089300 defendant Lockwood Thomas blacksmith 587219 587219 Lockwood, Thomas, of Ufford, blacksmith 0
4204617 2097160 2097160 defendant Wyeth William husbandman 587219 587219 Wyeth, William, of Ufford, husbandman 1
4241959 2110302 2110302 defendant Martyn William husbandman 587219 587219 Martyn, William, of Ufford, husbandman 1
4301523 2130648 2130648 defendant Martyn William yeoman 587219 587219 Martyn, William, of Ufford, yeoman 0
4331858 2140948 2140948 defendant Angell Thomas butcher 587219 587219 Angell, Thomas, of Ufford, butcher 1
4335692 2142216 2142216 defendant Benstead James blacksmith 587219 587219 Benstead, James, of Ufford, blacksmith 0
4340701 2144021 2144021 defendant Hawes William tailor 587219 587219 Hawes, William, of Ufford, tailor 0
4424119 2172399 2172399 plaintiff Holdelond Margery (legal representative) 587219 587219 Holdelond, Margery, of Ufford, formerly wife of Hugh, executors of 0
4452214 2185674 2185674 defendant Halewade William   587219 587219 Halewade, William, of Ufford 0
4467749 2190592 2190592 plaintiff Balderton Richard (legal representative) 587219 587219 Balderton, Richard, of Ufford, executors of 0
4467754 2190593 2190593 plaintiff Balderton Richard (legal representative) 587219 587219 Balderton, Richard, of Ufford, executors of 0
4592151 2228900 2228900 defendant Priour John   587219 587219 Priour, John, of Ufford, mason 0
4638478 2242795 2242795 plaintiff Carlyll John   587219 587219 Carlyll, John, of Ufford, parson 0
4645962 2244891 2244891 defendant Pryour John   587219 587219 Pryour, John, of Ufford 4
4659701 2248886 2248886 defendant Lnt Richard chaplain 587219 587219 Lnt, Richard, of Ufford, chaplain 0
4671394 2256702 2256702 plaintiff Carlyll John   587219 587219 Carlyll, John, of Ufford, parson 0
4673891 2257450 2257450 defendant Heth William   587219 587219 Heth, William, of Ufford, parson 0
4678086 2258757 2258757 plaintiff Heth William   587219 587219 Heth, William, of Ufford, parson 0
4679411 2259176 2259176 defendant Baldewyn Robert husbandman 587219 587219 Baldewyn, Robert, of Ufford, husbandman 0
4716969 2270639 2270639 defendant Lachecold John husbandman 587219 587219 Lachecold, John, of Ufford, husbandman 1
4716970 2270639 2270639 defendant Smyth Thomas husbandman 587219 587219 Smyth, Thomas, of Ufford, husbandman 2
4721291 2271989 2271989 plaintiff Carlyll John   587219 587219 Carlyll, John, of Ufford, parson 0
4792718 2293809 2293809 defendant Artlyngburgh John husbandman 587219 587219 Artlyngburgh, John, of Ufford, husbandman 0
4822404 2303088 2303088 defendant Brook Robert yeoman 587219 587219 Brook, Robert, of Ufford, yeoman 0
4848882 2311116 2311116 defendant Golowe John miller 587219 587219 Golowe, John, of Ufford, miller 0
4848884 2311117 2311117 defendant Gelowe John miller 587219 587219 Gelowe, John, of Ufford, miller 0
4853890 2312625 2312625 defendant Turnour John tailor 587219 587219 Turnour, John, of Ufford, tailor 1
4862119 2315162 2315162 defendant Hakiswod John baker 587219 587219 Hakiswod, John, of Ufford, baker 0
4863703 2315617 2315617 defendant Caton Thomas butcher 587219 587219 Caton, Thomas, of Ufford, butcher 0
4875428 2319271 2319271 defendant Forster Gilbert husbandman 587219 587219 Forster, Gilbert, of Ufford, husbandman 3
4932848 2336660 2336660 plaintiff Wryght John   587219 587219 Wryght, John, of Ufford 0
4935083 2337382 2337382 defendant Leg John husbandman 587219 587219 Leg, John, of Ufford, husbandman 1
4937651 2338152 2338152 defendant Turnour Thomas husbandman 587219 587219 Turnour, Thomas, of Ufford, husbandman 0
4939357 2338690 2338690 defendant Caton Thomas butcher 587219 587219 Caton, Thomas, of Ufford, butcher 0
4943189 2339839 2339839 defendant Woderove Thomas yeoman 587219 587219 Woderove, Thomas, of Ufford, yeoman 2
4958269 2344441 2344441 plaintiff Wryghte John   587219 587219 Wryghte, John, of Ufford 0
4958270 2344441 2344441 plaintiff Rykkes William   587219 587219 Rykkes, William, of Ufford 1
4963030 2345851 2345851 defendant Cacchepol Richard husbandman 587219 587219 Cacchepol, Richard, of Ufford, husbandman 4
4963114 2345874 2345874 defendant Weyneld William yeoman 587219 587219 Weyneld, William, of Ufford, yeoman 0
4963403 2345963 2345963 defendant Fairhed John cordwainer 587219 587219 Fairhed, John, of Ufford, cordwainer 0
4999561 2356742 2356742 defendant Smalheth Robert husbandman 587219 587219 Smalheth, Robert, of Ufford, husbandman 0
5009761 2359735 2359735 defendant Everard William husbandman 587219 587219 Everard, William, of Ufford, husbandman 0
5016601 2361749 2361749 defendant Woderove Thomas shoemaker 587219 587219 Woderove, Thomas, of Ufford, shoemaker 1
5037550 2367857 2367857 defendant Ayston Robert shoemaker 587219 587219 Ayston, Robert, of Ufford, shoemaker 0
5059598 2374439 2374439 defendant Cuttyng Robert shoemaker 587219 587219 Cuttyng, Robert, of Ufford, shoemaker 0
5059599 2374439 2374439 defendant Tuffeld Stephen roper 587219 587219 Tuffeld, Stephen, of Ufford, roper 1
5059600 2374439 2374439 defendant Balhed William   587219 587219 Balhed, William, of Ufford, twill maker 2
5086673 2382493 2382493 defendant Broun Robert laborer 587219 587219 Broun, Robert, of Ufford, laborer 3
5086677 2382494 2382494 defendant Broun Robert laborer 587219 587219 Broun, Robert, of Ufford, laborer 2
5100542 2386583 2386583 defendant Smyth Robert yeoman 587219 587219 Smyth, Robert, of Ufford, yeoman 0
5124051 2393489 2393489 defendant Smyth Robert yeoman 587219 587219 Smyth, Robert, of Ufford, yeoman 0
5128767 2394898 2394898 defendant Flynt Thomas   587219 587219 Flynt, Thomas, of Ufford, parson 0
5130351 2395365 2395365 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5142433 2398912 2398912 defendant Smyth Robert yeoman 587219 587219 Smyth, Robert, of Ufford, yeoman 0
5149698 2401042 2401042 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5149703 2401044 2401044 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5168554 2406519 2406519 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5181434 2410311 2410311 defendant Bussh John   587219 587219 (Bussh, John, of Ufford, surgeon 1
5184529 2411218 2411218 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5184532 2411219 2411219 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5200166 2415802 2415802 defendant Smyth Robert yeoman 587219 587219 Smyth, Robert, of Ufford, yeoman 0
5200696 2415959 2415959 defendant Mannyng Roger yeoman 587219 587219 Mannyng, Roger, of Ufford, yeoman 0
5204347 2417025 2417025 defendant Cristemesse John tailor 587219 587219 Cristemesse, John, of Ufford, tailor 0
5214061 2419842 2419842 defendant Newhale John husbandman 587219 587219 Newhale, John, of Ufford, husbandman 5
5218763 2421215 2421215 plaintiff Grome John   587219 587219 Grome, John, of Ufford 0
5232811 2425180 2425180 defendant Smyth Robert yeoman 587219 587219 Smyth, Robert, of Ufford, yeoman 1
5241370 2427669 2427669 defendant Tonell Stephen roper 587219 587219 Tonell, Stephen, of Ufford, roper 0
5241371 2427669 2427669 defendant Cook Richard butcher 587219 587219 Cook, Richard, of Ufford, butcher 1
5258068 2432642 2432642 defendant Cook Richard butcher 587219 587219 Cook, Richard, of Ufford, butcher 0
5265098 2434843 2434843 defendant Cook Richard butcher 587219 587219 Cook, Richard, of Ufford, butcher 1
5267661 2435643 2435643 defendant Godard Robert   587219 587219 Godard, Robert, of Ufford, twill weaver 1
5267662 2435643 2435643 defendant Everard John laborer 587219 587219 Everard, John, of Ufford, laborer 2
5267663 2435643 2435643 defendant Skylman John laborer 587219 587219 Skylman, John, of Ufford, laborer 3
5267679 2435649 2435649 defendant Godard Robert   587219 587219 Godard, Robert, of Ufford, twill weaver 1
5267680 2435649 2435649 defendant Everard John laborer 587219 587219 Everard, John, of Ufford, laborer 2
5267681 2435649 2435649 defendant Skylman John laborer 587219 587219 Skylman, John, of Ufford, laborer 3
5268927 2436021 2436021 defendant Cook Richard butcher 587219 587219 Cook, Richard, of Ufford, butcher 2
5357368 2462371 2462371 plaintiff Multon William merchant of the staple 587219 587219 Multon, William, of Ufford, merchant of the staple 0
5360876 2463431 2463431 defendant Flynte John courser 587219 587219 Flynte, John, of Ufford, courser 0
5363974 2464385 2464385 defendant Pyk John chaplain 587219 587219 Pyk, John, of Ufford, chaplain 0
5376227 2468160 2468160 defendant Pryour John yeoman 587219 587219 Pryour, John, of Ufford, yeoman 0
5376228 2468160 2468160 defendant Seuell Thomas merchant 587219 587219 Seuell, Thomas, of Ufford, merchant 1
5407833 2477318 2477318 defendant Goodman William laborer 587219 587219 Goodman, William, of Ufford, laborer 1
5407834 2477318 2477318 defendant Crispyne John laborer 587219 587219 Crispyne, John, of Ufford, laborer 2
5407838 2477320 2477320 defendant Symond John mercer 587219 587219 Symond, John, of Ufford, mercer 0
5435695 2485613 2485613 defendant (not given) Thomas rector of Tuson 587219 587219 Tuson, Thomas, of Ufford, clerk, master & rector of the church of Ufford near Barnak, within Nasseburgh 1
5478987 2498735 2498735 defendant Multon Robert merchant 587219 587219 Multon, Robert, of Ufford, merchant 1
5478988 2498735 2498735 defendant Lyne Thomas husbandman 587219 587219 Lyne, Thomas, of Ufford, husbandman 2
5488765 2501515 2501515 defendant Multon William merchant 587219 587219 Multon, William, of Ufford, merchant 2
5509713 2507869 2507869 defendant Ketylbarn Drew butcher 587219 587219 Ketylbarn, Drew, of Ufford, butcher 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);