names

161 rows where place_id = 588316

✎ 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
3594084 1865792 1865792 defendant Rolff John yeoman 588316 588316 Rolff, John, of Wye, yeoman 0
3625876 1902946 1902946 defendant Horton William carpenter 588316 588316 Horton, William, of Wye, carpenter 0
3633298 1905230 1905230 defendant Barrey John yeoman 588316 588316 Barrey, John, of Wye, yeoman 4
3671219 1916971 1916971 defendant Smyth Richard laborer 588316 588316 Smyth, Richard, of Wye, laborer 1
3691106 1923380 1923380 defendant Pers Nicholas yeoman 588316 588316 Pers, Nicholas, of Wye, yeoman 0
3722677 1933356 1933356 defendant keterell John butcher 588316 588316 keterell, John, of Wye, butcher 2
3743693 1939910 1939910 defendant Payne Richard smith 588316 588316 Payne, Richard, of Wye, smith 0
3774103 1949615 1949615 defendant Bedall William weaver 588316 588316 Bedall, William, of Wye, weaver 0
3774104 1949615 1949615 defendant A Mount Richard   588316 588316 A Mount, Richard, of Wye, tallow chandler 1
3774105 1949615 1949615 defendant Alye Richard laborer 588316 588316 Alye, Richard, of Wye, laborer 2
3774106 1949615 1949615 defendant Rattell Robert smith 588316 588316 Rattell, Robert, of Wye, smith 3
3787994 1954035 1954035 defendant Atwodde Thomas tailor 588316 588316 Atwodde, Thomas, of Wye, tailor 0
3804197 1959245 1959245 defendant at Wodde Thomas tailor 588316 588316 at Wodde, Thomas, of Wye, tailor 0
3821654 1964658 1964658 defendant Attwod Thomas tailor 588316 588316 Attwod, Thomas, of Wye, tailor 0
3823265 1965193 1965193 defendant Ederyche Alexander tanner 588316 588316 Ederyche, Alexander, of Wye, tanner 2
3851023 1973912 1973912 defendant Lechard Richard sawyer 588316 588316 Lechard, Richard, of Wye, sawyer 2
3879749 1983484 1983484 defendant Whetyngton Robert glover 588316 588316 Whetyngton, Robert, of Wye, glover 0
3891353 1987374 1987374 defendant Payne Thomas tailor 588316 588316 Payne, Thomas, of Wye, tailor 3
3954039 2008483 2008483 defendant Norden John yeoman 588316 588316 Norden, John, of Wye, yeoman 0
3954079 2008499 2008499 defendant Eggerden John husbandman 588316 588316 Eggerden, John, of Wye, husbandman 0
3955589 2009025 2009025 defendant Cooke Thomas tanner 588316 588316 Cooke, Thomas, of Wye, tanner 0
3957082 2009545 2009545 plaintiff Payne William smith 588316 588316 Payne, William, of Wye, smith 1
3978179 2016949 2016949 defendant Rolse or Rolfe John yeoman 588316 588316 Rolse or Rolfe, John, of Wye, yeoman 0
3978704 2017128 2017128 defendant Trytton William yeoman 588316 588316 Trytton, William, of Wye, yeoman 0
4056855 2044833 2044833 plaintiff Brooke Thomas   588316 588316 Brooke, Thomas, of Wye 0
4063294 2047165 2047165 defendant Swanne William gent 588316 588316 Swanne, William, of Wye, gent 2
4072171 2050346 2050346 defendant Sander John tanner 588316 588316 Sander, John, of Wye, tanner 2
4109623 2063700 2063700 defendant Alcock Richard butcher 588316 588316 Alcock, Richard, of Wye, butcher 0
4109624 2063700 2063700 defendant Browne William butcher 588316 588316 Browne, William, of Wye, butcher 1
4109630 2063702 2063702 defendant Pyme John butcher 588316 588316 Pyme, John, of Wye, butcher 0
4109631 2063702 2063702 defendant Beverley John yeoman 588316 588316 Beverley, John, of Wye, yeoman 1
4109632 2063702 2063702 defendant Pyne Richard yeoman 588316 588316 Pyne, Richard, of Wye, yeoman 2
4113195 2064987 2064987 defendant Dryland Richard gent 588316 588316 Dryland, Richard, of Wye, gent 1
4119075 2067105 2067105 defendant Castle Thomas carpenter 588316 588316 Castle, Thomas, of Wye, carpenter 0
4119076 2067105 2067105 defendant Butcher William carpenter 588316 588316 Butcher, William, of Wye, carpenter 1
4136517 2073404 2073404 defendant Grafton Robert tailor 588316 588316 Grafton, Robert, of Wye, tailor 1
4165468 2083424 2083424 defendant Pyne George laborer 588316 588316 Pyne, George, of Wye, laborer 2
4176460 2087247 2087247 defendant Grafton Robert yeoman 588316 588316 Grafton, Robert, of Wye, yeoman 1
4229690 2105865 2105865 defendant Wood Thomas clerk 588316 588316 Wood, Thomas, of Wye, clerk 0
4259835 2116262 2116262 defendant Wood Thomas clerk 588316 588316 Wood, Thomas, of Wye, clerk 0
4284323 2124442 2124442 defendant Warde John yeoman 588316 588316 Warde, John, of Wye, yeoman 0
4284325 2124443 2124443 defendant Warde John yeoman 588316 588316 Warde, John, of Wye, yeoman 0
4331125 2140709 2140709 defendant Smytheson William yeoman 588316 588316 Smytheson, William, of Wye, yeoman 0
4362749 2151736 2151736 defendant Sampson Isaac tailor 588316 588316 Sampson, Isaac, of Wye, tailor 0
4364213 2152258 2152258 defendant Beverley Joseph grocer 588316 588316 Beverley, Joseph, of Wye, yeoman, brothers and coheirs of Nicholas Beverley, of Canterbury, grocer 1
4431702 2174686 2174686 defendant Golle William   588316 588316 Golle, William, of Wye 0
4431704 2174687 2174687 defendant Bolle William   588316 588316 Bolle, William, of Wye 0
4452512 2185784 2185784 plaintiff Kempe Thomas   588316 588316 Kempe, Thomas, of wye 0
4477262 2193554 2193554 defendant Laurence John   588316 588316 Laurence, John, of Wye 1
4481128 2194777 2194777 defendant Miller Thomas   588316 588316 Miller, Thomas, of Wye 0
4491781 2198113 2198113 defendant Kempe Thomas   588316 588316 Kempe, Thomas, of Wye 1
4496480 2199574 2199574 defendant Clerk Ivan tanner 588316 588316 Clerk, Ivan, of Wye, tanner 1
4509663 2203501 2203501 defendant Lawerans John   588316 588316 Lawerans, John, of Wye 0
4528383 2209152 2209152 defendant Joye John   588316 588316 Joye, John, of Wye 0
4530997 2209988 2209988 defendant Clerk William   588316 588316 Clerk, William, of Wye 3
4534230 2210971 2210971 defendant A_ John   588316 588316 A_, John, of Wye 0
4549395 2215754 2215754 defendant Smyth John   588316 588316 Smyth, John, of Wye 0
4556972 2218110 2218110 plaintiff Kempe Thomas   588316 588316 Kempe, Thomas, of Wye 0
4563334 2220106 2220106 defendant Gibbe John   588316 588316 Gibbe, John, of Wye, son of Walter 0
4566759 2221174 2221174 defendant Berman (illegible) miller 588316 588316 Berman, _, of Wye, miller 7
4588134 2227687 2227687 plaintiff Edyngere John   588316 588316 Edyngere, John, of Wye 2
4606975 2233292 2233292 defendant Fordrede Nicholas   588316 588316 Fordrede, Nicholas, of Wye 0
4626496 2239235 2239235 defendant Belsyng John   588316 588316 Belsyng, John, of Wye 3
4644747 2244543 2244543 defendant Belfy John   588316 588316 Belfy, John, of Wye 0
4645657 2244794 2244794 defendant Wyllok William   588316 588316 Wyllok, William, of Wye 1
4699782 2265374 2265374 defendant Combe Philip gent 588316 588316 Combe, Philip, of Wye, gent 0
4703788 2266564 2266564 defendant Knygth Lawrence butcher 588316 588316 Knygth, Lawrence, of Wye, butcher 0
4703790 2266564 2266564 defendant Dod John butcher 588316 588316 Dod, John, of Wye, butcher 2
4704812 2266883 2266883 defendant Mercer Hugh fuller 588316 588316 Mercer, Hugh, of Wye, fuller 0
4709225 2268253 2268253 defendant Dodde John butcher 588316 588316 Dodde, John, of Wye, butcher 0
4728667 2274205 2274205 plaintiff Kempe Thomas   588316 588316 Kempe, Thomas, of Wye 0
4728670 2274205 2274205 defendant Swayn John   588316 588316 Swayn, John, of Wye, inland fish seller 2
4742307 2278241 2278241 defendant atte Wode William husbandman 588316 588316 atte Wode, William, of Wye, husbandman 0
4758721 2283084 2283084 defendant Chelchebourne Thomas fuller 588316 588316 Chelchebourne, Thomas, of Wye, fuller 0
4759340 2283265 2283265 defendant Germayn Gilbert gent 588316 588316 Germayn, Gilbert, of Wye, gent 0
4759341 2283265 2283265 defendant Chelchebourn Thomas husbandman 588316 588316 Chelchebourn, Thomas, of Wye, husbandman 1
4835577 2307117 2307117 plaintiff Dod John carpenter 588316 588316 Dod, John, of Wye, carpenter 0
4847114 2310599 2310599 defendant Sandre Thomas tanner 588316 588316 Sandre, Thomas, of Wye, tanner 0
4847218 2310629 2310629 defendant Germayn Hamon yeoman 588316 588316 Germayn, Hamon, of Wye, yeoman 0
4915414 2331326 2331326 defendant Knyght Lawrence butcher 588316 588316 Knyght, Lawrence, of Wye, butcher 0
4923454 2333764 2333764 defendant German William tanner 588316 588316 German, William, of Wye, tanner 0
4926889 2334840 2334840 defendant Grydle John yeoman 588316 588316 Grydle, John, of Wye, yeoman 0
4949153 2341725 2341725 defendant Pounfrete William tailor 588316 588316 Pounfrete, William, of Wye, tailor 0
4974824 2349441 2349441 defendant Andrewe Thomas husbandman 588316 588316 Andrewe, Thomas, of Wye, husbandman 1
4978316 2350464 2350464 plaintiff Richard Thomas   588316 588316 Richard, Thomas, of Wye 0
4984698 2352351 2352351 defendant Pak John dyer 588316 588316 Pak, John, of Wye, dyer 0
4999248 2356646 2356646 defendant Bolle John laborer 588316 588316 Bolle, John, of Wye, laborer 3
5005224 2358425 2358425 plaintiff Richard Thomas   588316 588316 Richard, Thomas, of Wye 0
5006060 2358658 2358658 defendant Joseph John tailor 588316 588316 Joseph, John, of Wye, tailor 2
5031697 2366136 2366136 plaintiff Richard Thomas   588316 588316 Richard, Thomas, of Wye 0
5050775 2371855 2371855 defendant Smethe Roger butcher 588316 588316 Smethe, Roger, of Wye, butcher 1
5052869 2372449 2372449 defendant German Simon butcher 588316 588316 German, Simon, of Wye, butcher 0
5107428 2388604 2388604 defendant Sandre Alice widow 588316 588316 Sandre, Alice, of Wye, widow 0
5121520 2392725 2392725 defendant Essex Thomas husbandman 588316 588316 Essex, Thomas, of Wye, husbandman 0
5138430 2397746 2397746 defendant Scot Roger husbandman 588316 588316 Scot, Roger, of Wye, husbandman 0
5140721 2398399 2398399 defendant Essex Thomas   588316 588316 Essex, Thomas, of Wye 0
5150813 2401382 2401382 plaintiff Gauge Thomas master or priest & chaplain of the college of Sts Gregory & Martin 588316 588316 Gauge, Thomas, of Wye, master or priest & chaplain of the college of Sts Gregory & Martin 0
5152535 2401878 2401878 defendant Kenet John husbandman 588316 588316 Kenet, John, of Wye, husbandman 0
5159234 2403819 2403819 defendant Scot Roger yeoman 588316 588316 Scot, Roger, of Wye, yeoman 0
5163861 2405164 2405164 defendant Coppe John chapman 588316 588316 Coppe, John, of Wye, chapman 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);