names

102 rows where place_id = 592527

✎ 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
3607972 1870144 1870144 defendant Bode John weaver 592527 592527 Bode, John, of Stenyng, weaver 0
3618137 1873297 1873297 defendant Pryklove Richard yeoman 592527 592527 Pryklove, Richard, of Stenyng, yeoman 1
3636507 1906212 1906212 defendant Bayly John carpenter 592527 592527 Bayly, John, of Stenyng, carpenter 0
3659690 1913286 1913286 defendant Gaddesden Richard tailor 592527 592527 Gaddesden, Richard, of Stenyng, tailor 0
3689458 1922863 1922863 plaintiff Farnfold Peter   592527 592527 Farnfold, Peter, of Stenyng 0
3689459 1922863 1922863 defendant Slater John butcher 592527 592527 Slater, John, of Stenyng, butcher 0
3722527 1933305 1933305 defendant Best Richard mercer 592527 592527 Best, Richard, of Stenyng, mercer 0
3762512 1945919 1945919 defendant Heseworth John tailor 592527 592527 Heseworth, John, of Stenyng, tailor 0
3775278 1950006 1950006 defendant Holmere John fuller 592527 592527 Holmere, John, of Stenyng, fuller 0
3779445 1951296 1951296 defendant Butte Robert fuller 592527 592527 Butte, Robert, of Stenyng, fuller 0
3780668 1951682 1951682 defendant Heseworth John tailor 592527 592527 Heseworth, John, of Stenyng, tailor 0
3782865 1952390 1952390 defendant Pyper John husbandman 592527 592527 Pyper, John, of Stenyng, husbandman 0
3799426 1957741 1957741 defendant Pyper John baker 592527 592527 Pyper, John, of Stenyng, baker 0
3834046 1968588 1968588 defendant Coke Richard chapman 592527 592527 Coke, Richard, of Stenyng, chapman 0
3893376 1988017 1988017 plaintiff Pellett James yeoman 592527 592527 Pellett, James, of Stenyng, yeoman 0
3902499 1991067 1991067 defendant Gillam John butcher 592527 592527 Gillam, John, of Stenyng, butcher 0
3902501 1991067 1991067 defendant Pryklove Richard butcher 592527 592527 Pryklove, Richard, of Stenyng, butcher 2
3906279 1992390 1992390 defendant Donstone Robert chapman 592527 592527 Donstone, Robert, of Stenyng, chapman 1
3907505 1992805 1992805 defendant Smyth William baker 592527 592527 Smyth, William, of Stenyng, baker 0
3933387 2001459 2001459 defendant Fraunces John butcher 592527 592527 Fraunces, John, of Stenyng, butcher 3
3968224 2013513 2013513 defendant Burnard Thomas draper 592527 592527 Burnard, Thomas, of Stenyng, draper 0
3974945 2015803 2015803 plaintiff Holland John mercer 592527 592527 Holland, John, of Stenyng, mercer 0
3984199 2019115 2019115 defendant Wepham Reginald yeoman 592527 592527 Wepham, Reginald, of Stenyng, yeoman 0
4078140 2052486 2052486 defendant Gravesend John tailor 592527 592527 Gravesend, John, of Stenyng, tailor 0
4078141 2052486 2052486 defendant Stydley Simon (legal representative) 592527 592527 Stydley, Simon, of Stenyng, tailor, executrix of 1
4097306 2059355 2059355 defendant Peerse James yeoman 592527 592527 Peerse, James, of Stenyng, yeoman 2
4127176 2070010 2070010 defendant Smyth John yeoman 592527 592527 Smyth, John, of Stenyng, yeoman 0
4141935 2075346 2075346 defendant Mytchell Richard gent 592527 592527 Mytchell, Richard, of Stenyng, or of Lynfyld, gent 0
4150471 2078295 2078295 defendant Mytchell Richard gent 592527 592527 Mytchell, Richard, of Stenyng, gent 0
4167123 2084007 2084007 defendant Smythe John yeoman 592527 592527 Smythe, John, of Stenyng, yeoman 0
4168873 2084604 2084604 defendant Smyth John yeoman 592527 592527 Smyth, John, of Stenyng, or of Peppers Combe, yeoman 0
4168874 2084604 2084604 defendant Smyth James butcher 592527 592527 Smyth, James, of Stenyng, butcher 1
4175250 2086808 2086808 defendant Mytchell Richard gent 592527 592527 Mytchell, Richard, of Stenyng, gent 0
4191814 2092692 2092692 defendant Smythe John yeoman 592527 592527 Smythe, John, of Stenyng, or of Peperscombe, yeoman 0
4192305 2092868 2092868 defendant Smyth James butcher 592527 592527 Smyth, James, of Stenyng, butcher 1
4195274 2093894 2093894 defendant Smythe John yeoman 592527 592527 Smythe, John, of Stenyng, or of Peperscombe, yeoman 0
4453004 2185949 2185949 defendant Burgeys Richard   592527 592527 Burgeys, Richard, of Stenyng 0
4655726 2247673 2247673 defendant Sherman John sherman 592527 592527 Sherman, John, of Stenyng, sherman 4
4656712 2247992 2247992 defendant Forton Richard tailor 592527 592527 Forton, Richard, of Stenyng, tailor 0
4670025 2256324 2256324 defendant Prat John carpenter 592527 592527 Prat, John, of Stenyng, carpenter 1
4690941 2262696 2262696 defendant Redyng William husbandman 592527 592527 Redyng, William, of Stenyng, husbandman 1
4691135 2262746 2262746 defendant Calf Thomas weaver 592527 592527 Calf, Thomas, of Stenyng, weaver 3
4720188 2271659 2271659 defendant Prat John carpenter 592527 592527 Prat, John, of Stenyng, carpenter 0
4738326 2277082 2277082 defendant Tayllour John husbandman 592527 592527 together with Tayllour, John, of Stenyng, husbandman 5
4782985 2290699 2290699 defendant Belton John yeoman 592527 592527 Belton, John, of Stenyng, yeoman 0
4786339 2291771 2291771 defendant Belton John yeoman 592527 592527 Belton, John, of Stenyng, yeoman 0
4812260 2299951 2299951 defendant Frenssh John glover 592527 592527 Frenssh, John, of Stenyng, glover 0
4820115 2302367 2302367 plaintiff Prykkelove John butcher 592527 592527 Prykkelove, John, of Stenyng, butcher, on his own account 0
4852032 2312067 2312067 defendant Colbarne Thomas yeoman 592527 592527 Colbarne, Thomas, of Stenyng, yeoman 1
4872816 2318448 2318448 defendant Farnefold Richard gent 592527 592527 Farnefold, Richard, of Stenyng, gent 0
4881541 2321128 2321128 defendant Slutter Thomas husbandman 592527 592527 Slutter, Thomas, of Stenyng, husbandman 2
4889452 2323495 2323495 defendant Pescod John butcher 592527 592527 Pescod, John, of Stenyng, butcher 2
4889453 2323495 2323495 defendant Wryght Thomas pewterer 592527 592527 Wryght, Thomas, of Stenyng, pewterer 3
4897404 2325847 2325847 defendant Rodhill John husbandman 592527 592527 Rodhill, John, of Stenyng, husbandman 2
4897405 2325847 2325847 defendant Payn John laborer 592527 592527 Payn, John, of Stenyng, laborer 3
4897406 2325847 2325847 defendant Spense William glover 592527 592527 Spense, William, of Stenyng, glover 4
4904576 2328043 2328043 defendant Pryklove John butcher 592527 592527 Pryklove, John, of Stenyng, butcher 0
4906559 2328636 2328636 defendant Routh Herman tailor 592527 592527 Routh, Herman, of Stenyng, tailor 0
4906829 2328720 2328720 defendant Slutter Thomas husbandman 592527 592527 Slutter, Thomas, of Stenyng, husbandman 0
4916441 2331643 2331643 plaintiff Faggers William   592527 592527 Faggers, William, of Stenyng 0
4916462 2331651 2331651 defendant Slutter Thomas husbandman 592527 592527 Slutter, Thomas, of Stenyng, husbandman 0
4916463 2331651 2331651 defendant Ladde John tanner 592527 592527 Ladde, John, of Stenyng, tanner 1
4943457 2339923 2339923 defendant Lambvale Thomas chapman 592527 592527 Lambvale, Thomas, of Stenyng, chapman 0
4951558 2342444 2342444 defendant Spencer John laborer 592527 592527 Spencer, John, of Stenyng, laborer 0
4951560 2342444 2342444 defendant Clyfford John carpenter 592527 592527 Clyfford, John, of Stenyng, carpenter 2
4989351 2353750 2353750 defendant Pryklove John butcher 592527 592527 Pryklove, John, of Stenyng, butcher 0
4989354 2353751 2353751 defendant Pryklove John butcher 592527 592527 Pryklove, John, of Stenyng, butcher 0
4994030 2355087 2355087 defendant Long John husbandman 592527 592527 Long, John, of Stenyng, husbandman 0
5004661 2358265 2358265 defendant Tolay John chandler 592527 592527 Tolay, John, of Stenyng, chandler 1
5014805 2361205 2361205 defendant Snellyng John husbandman 592527 592527 Snellyng, John, of Stenyng, husbandman 0
5016579 2361744 2361744 defendant Taylour Herman tailor 592527 592527 Taylour, Herman, of Stenyng, tailor 0
5019193 2362502 2362502 defendant Lamvale Thomas yeoman 592527 592527 Lamvale, Thomas, of Stenyng, yeoman 0
5064805 2376011 2376011 defendant Lamvale Thomas mercer 592527 592527 Lamvale, Thomas, of Stenyng, mercer 0
5134361 2396547 2396547 defendant Spencer John, senior laborer 592527 592527 Spencer, John, senior, of Stenyng, laborer 0
5142505 2398935 2398935 defendant Tele Philip seuyer or sawyer 592527 592527 Tele, Philip, of Stenyng, seuyer or sawyer 1
5147658 2400452 2400452 defendant Campyon Thomas yeoman 592527 592527 Campyon, Thomas, of Stenyng, yeoman 0
5150873 2401396 2401396 defendant Smyth John blacksmith 592527 592527 Smyth, John, of Stenyng, blacksmith 1
5167272 2406158 2406158 defendant Campyon Thomas yeoman 592527 592527 Campyon, Thomas, of Stenyng, yeoman 0
5169213 2406734 2406734 defendant Smyth John blacksmith 592527 592527 Smyth, John, of Stenyng, blacksmith 1
5185817 2411598 2411598 defendant Smyth John   592527 592527 Smyth, John, of Stenyng, black smith 1
5204952 2417194 2417194 defendant Smyth John   592527 592527 Smyth, John, of Stenyng, black smith 1
5228936 2424067 2424067 defendant Clopham William cordwainer 592527 592527 Clopham, William, of Stenyng, cordwainer 0
5237391 2426520 2426520 defendant Smyth John (legal representative) 592527 592527 Smyth, John, of Stenyng, blacksmith, executors of 0
5242927 2428133 2428133 defendant Ledys John gent 592527 592527 Ledys, John, of Stenyng, gent 0
5242928 2428133 2428133 defendant Ledys Peter gent 592527 592527 Ledys, Peter, of Stenyng, gent 1
5275014 2437772 2437772 defendant Boteler William chapman 592527 592527 Boteler, William, of Stenyng, chapman 0
5290054 2442095 2442095 defendant Benet Nigel draper 592527 592527 Benet, Nigel, of Stenyng, draper 1
5298437 2444518 2444518 defendant Campyon Thomas yeoman 592527 592527 Campyon, Thomas, of Stenyng, yeoman 2
5313752 2449140 2449140 defendant Faggar William gent 592527 592527 Faggar, William, of Stenyng, gent 0
5313754 2449141 2449141 defendant Fagger William gent 592527 592527 Fagger, William, of Stenyng, gent 0
5331012 2454341 2454341 defendant Faggar William gent 592527 592527 Faggar, William, of Stenyng, gent 0
5358483 2462708 2462708 defendant Wrey Henry cooper 592527 592527 Wrey, Henry, of Stenyng, cooper 0
5473946 2497180 2497180 defendant Testard Richard yeoman 592527 592527 Testard, Richard, of Stenyng, yeoman 0
5482924 2499835 2499835 defendant Hyder John draper 592527 592527 Hyder, John, of Stenyng, draper 3
5499089 2504667 2504667 defendant Fuller John   592527 592527 Fuller, John, of Stenyng, pedlar 0
5513480 2509061 2509061 defendant Spencer William tailor 592527 592527 Spencer, William, of Stenyng, tailor 0
5522688 2511922 2511922 defendant Body Thomas husbandman 592527 592527 Body, Thomas, of Stenyng, husbandman 1
5523069 2512040 2512040 defendant Gravysend John   592527 592527 Gravysend, John, of Stenyng, wax chandler 0
5529426 2513716 2513716 defendant Swyfte John husbandman 592527 592527 Swyfte, John, of Stenyng, husbandman 1
5597134 2534010 2534010 defendant Edward John smith 592527 592527 Edward, John, of Stenyng, smith 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);