names

139 rows where place_id = 589712

✎ 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
3598484 1867154 1867154 defendant Ynk Ralph clerk 589712 589712 Ynk, Ralph, of New Wyndesore, clerk 5
3615741 1872564 1872564 defendant Chery Roger innholder 589712 589712 Chery, Roger, of New Wyndesore, innholder 1
3615742 1872564 1872564 defendant Markham Richard fishmonger 589712 589712 Markham, Richard, of New Wyndesore, fishmonger 2
3641267 1907719 1907719 defendant (not given) John rector of Webbe 589712 589712 Webbe, John, of New Wyndesore, rector of Remnaham 0
3652828 1911210 1911210 plaintiff Webbe John clerk 589712 589712 Webbe, John, of New Wyndesore, clerk 0
3654146 1911559 1911559 defendant Cotyngham Robert gent 589712 589712 Cotyngham, Robert, of New Wyndesore, gent 0
3685861 1921737 1921737 defendant Conryk or Couryk John husbandman 589712 589712 Conryk or Couryk, John, of New Wyndesore, husbandman 0
3691969 1923651 1923651 plaintiff Howse Robert baker 589712 589712 Howse, Robert, of New Wyndesore, baker 0
3691971 1923652 1923652 plaintiff Howse Robert baker 589712 589712 Howse, Robert, of New Wyndesore, baker 0
3701361 1926670 1926670 defendant Laurence Robert yeoman 589712 589712 Laurence, Robert, of New Wyndesore, yeoman 0
3732985 1936537 1936537 defendant Jackson Richard   589712 589712 (Jackson, Richard, of New Wyndesore, singing man 2
3738325 1938203 1938203 defendant Symond William yeoman 589712 589712 Symond, William, of New Wyndesore, yeoman 1
3744688 1940233 1940233 defendant Horsted Thomas bargeman 589712 589712 Horsted, Thomas, of New Wyndesore, bargeman 0
3752287 1942638 1942638 plaintiff Prynce James skinner 589712 589712 Prynce, James, of New Wyndesore, skinner 0
3754234 1943276 1943276 plaintiff Symondys alias Bereman Andrew yeoman 589712 589712 Symondys alias Bereman, Andrew, of New Wyndesore, yeoman 0
3754239 1943277 1943277 plaintiff Symondys Andrew yeoman 589712 589712 Symondys, Andrew, of New Wyndesore, yeoman 0
3764348 1946512 1946512 plaintiff Hovyse alias Baker Robert   589712 589712 Hovyse alias Baker, Robert, of New Wyndesore, baker, administrators of 0
3764352 1946513 1946513 plaintiff Hovyse alias Baker Robert   589712 589712 Hovyse alias Baker, Robert, of New Wyndesore, baker, administrators of 0
3764356 1946514 1946514 plaintiff Hovyse alias Howse Robert   589712 589712 Hovyse alias Howse, Robert, of New Wyndesore, yeoman, administrators of 0
3764363 1946515 1946515 plaintiff Hovyse Robert   589712 589712 Hovyse, Robert, of new Wyndesore, yeoman, administrators of 0
3771475 1948771 1948771 plaintiff Symondys alias Bereman Andrew   589712 589712 Symondys alias Bereman, Andrew, of New Wyndesore 0
3771479 1948772 1948772 plaintiff Symondys Andrew yeoman 589712 589712 Symondys, Andrew, of New Wyndesore, yeoman 0
3782364 1952238 1952238 plaintiff Hovyse alias Howse Robert   589712 589712 Hovyse alias Howse, Robert, of New Wyndesore, yeoman, administrators of 0
3799639 1957811 1957811 defendant Rokys John gent 589712 589712 Rokys, John, of New Wyndesore, gent 0
3799640 1957811 1957811 defendant Symons William brewer 589712 589712 Symons, William, of New Wyndesore, brewer 1
3799641 1957811 1957811 defendant Gryffyth John yeoman 589712 589712 Gryffyth, John, of New Wyndesore, yeoman 2
3799642 1957811 1957811 defendant Avelyn Thomas husbandman 589712 589712 Avelyn, Thomas, of New Wyndesore, husbandman 3
3799643 1957811 1957811 defendant Baker Mathew baker 589712 589712 Baker, Mathew, of New Wyndesore, baker 4
3799644 1957811 1957811 defendant Prynce James skinner 589712 589712 Prynce, James, of New Wyndesore, skinner 5
3799645 1957811 1957811 defendant Frankelyn Henry husbandman 589712 589712 Frankelyn, Henry, of New Wyndesore, husbandman 6
3799646 1957811 1957811 defendant Hall John weaver 589712 589712 Hall, John, of New Wyndesore, weaver 7
3799647 1957811 1957811 defendant Galys James haberdasher 589712 589712 Galys, James, of New Wyndesore, haberdasher 8
3800688 1958127 1958127 defendant Rookys John gent 589712 589712 Rookys, John, of New Wyndesore, gent 0
3800689 1958127 1958127 defendant Symons William brewer 589712 589712 Symons, William, of New Wyndesore, brewer 1
3800690 1958127 1958127 defendant Gryffyth John yeoman 589712 589712 Gryffyth, John, of New Wyndesore, yeoman 2
3800691 1958127 1958127 defendant Avelyn Thomas husbandman 589712 589712 Avelyn, Thomas, of New Wyndesore, husbandman 3
3800692 1958127 1958127 defendant Maker Mathew baker 589712 589712 Maker, Mathew, of New Wyndesore, baker 4
3800693 1958127 1958127 defendant Prynce James skinner 589712 589712 Prynce, James, of New Wyndesore, skinner 5
3800694 1958127 1958127 defendant Frankelyn Henry husbandman 589712 589712 Frankelyn, Henry, of New Wyndesore, husbandman 6
3800695 1958127 1958127 defendant Hall John weaver 589712 589712 Hall, John, of New Wyndesore, weaver 7
3800696 1958127 1958127 defendant Gaylys James haberdasher 589712 589712 Gaylys, James, of New Wyndesore, haberdasher 8
3801298 1958332 1958332 defendant Fesaunt Robert butcher 589712 589712 Fesaunt, Robert, of New Wyndesore, butcher 0
3812208 1961721 1961721 defendant Halle William innholder 589712 589712 Halle, William, of New Wyndesore, innholder 0
3812210 1961722 1961722 defendant Shaddok Robert husbandman 589712 589712 Shaddok, Robert, of New Wyndesore, husbandman 0
3812212 1961723 1961723 defendant Tyle John baker 589712 589712 Tyle, John, of New Wyndesore, baker 0
3872885 1981148 1981148 defendant Benett Robert gent 589712 589712 Benett, Robert, of New Wyndesore, gent 0
3883293 1984675 1984675 defendant Bennett Robert brewer 589712 589712 Bennett, Robert, of New Wyndesore, brewer 0
3883295 1984676 1984676 defendant Bennett Robert brewer 589712 589712 Bennett, Robert, of New Wyndesore, brewer 0
3888114 1986282 1986282 defendant Benett Robert gent 589712 589712 Benett, Robert, of New Wyndesore, gent 1
3908879 1993262 1993262 defendant Benett Robert gent 589712 589712 Benett, Robert, of New Wyndesore, gent 0
3911871 1994296 1994296 defendant Bennett Robert gent 589712 589712 Bennett, Robert, of New Wyndesore, gent 0
3911872 1994296 1994296 defendant Tudway George innholder 589712 589712 Tudway, George, of New Wyndesore, innholder 1
3912899 1994646 1994646 defendant Benett Robert gent 589712 589712 Benett, Robert, of New Wyndesore, gent 0
3916207 1995808 1995808 defendant Sterkey Agnes widow 589712 589712 Sterkey, Agnes, of New Wyndesore, widow 0
4085855 2055217 2055217 defendant Truchild John yeoman 589712 589712 Truchild, John, of New Wyndesore, yeoman 0
4085857 2055218 2055218 defendant Truchild John yeoman 589712 589712 Truchild, John, of New Wyndesore, yeoman 0
4517653 2205909 2205909 defendant Broun John tailor 589712 589712 Broun, John, of New Wyndesore, tailor 0
4530800 2209923 2209923 defendant Broun John tailor 589712 589712 Broun, John, of New Wyndesore, tailor 0
4603649 2232327 2232327 defendant Sy Simon   589712 589712 Sy, Simon, of New Wyndesore 0
4603652 2232328 2232328 defendant Sy Simon   589712 589712 Sy, Simon, of New Wyndesore 0
4631006 2240592 2240592 plaintiff Parke William master & vicar 589712 589712 (Parke, William, of New Wyndesore, master & vicar 1
4654909 2247417 2247417 defendant Avelyn John husbandman 589712 589712 Avelyn, John, of New Wyndesore, husbandman 0
4654910 2247417 2247417 defendant Avelyn Robert husbandman 589712 589712 Avelyn, Robert, of New Wyndesore, husbandman 1
4654911 2247417 2247417 defendant Parker John yeoman 589712 589712 Parker, John, of New Wyndesore, yeoman 2
4691374 2262827 2262827 defendant Clerk Robert butcher 589712 589712 Clerk, Robert, of New Wyndesore, butcher 0
4691375 2262827 2262827 defendant Kemsale Nicholas butcher 589712 589712 Kemsale, Nicholas, of New Wyndesore, butcher 1
4691377 2262827 2262827 defendant Redich Nicholas butcher 589712 589712 Redich, Nicholas, of New Wyndesore, butcher 3
4691378 2262827 2262827 defendant Chevewell or Chenewell Ralph butcher 589712 589712 Chevewell or Chenewell, Ralph, of New Wyndesore, butcher 4
4707110 2267608 2267608 defendant Sadeler John sadler 589712 589712 Sadeler, John, of New Wyndesore, sadler 1
4760771 2283709 2283709 defendant Morer John   589712 589712 Morer, John, of New Wyndesore, shoe maker 0
4798965 2295849 2295849 defendant Halle John yeoman 589712 589712 Halle, John, of New Wyndesore, yeoman 0
4799182 2295924 2295924 defendant Somerton Thomas husbandman 589712 589712 Somerton, Thomas, of New Wyndesore, husbandman 0
4802600 2296998 2296998 defendant Clere John gent 589712 589712 Clere, John, of New Wyndesore, gent 0
4808037 2298693 2298693 defendant Somurton Thomas yeoman 589712 589712 Somurton, Thomas, of New Wyndesore, yeoman 0
4863296 2315487 2315487 defendant Hunte Henry husbandman 589712 589712 Hunte, Henry, of New Wyndesore, husbandman 0
4863360 2315508 2315508 defendant Curteys John   589712 589712 Curteys, John, of New Wyndesore, cook 1
4879359 2320472 2320472 defendant Clere John clerk 589712 589712 Clere, John, of New Wyndesore, clerk 0
4896427 2325549 2325549 defendant Tewe William baker 589712 589712 Tewe, William, of New Wyndesore, baker 0
4965022 2346456 2346456 defendant Assheley John   589712 589712 Assheley, John, of New Wyndesore, servant 0
4998929 2356562 2356562 defendant Towe William yeoman 589712 589712 Towe, William, of New Wyndesore, yeoman 3
4998930 2356562 2356562 defendant Hunte William sheerman 589712 589712 Hunte, William, of New Wyndesore, sheerman 4
5013465 2360776 2360776 plaintiff Avelyn John, senior   589712 589712 Avelyn, John, senior, of New Wyndesore 0
5016789 2361805 2361805 plaintiff Bythewod John   589712 589712 Bythewod, John, of New Wyndesore, bailiff 0
5016790 2361805 2361805 plaintiff Swan Thomas   589712 589712 Swan, Thomas, of New Wyndesore, bailiff 1
5025666 2364413 2364413 defendant Towe William husbandman 589712 589712 Towe, William, of New Wyndesore, husbandman 0
5067143 2376693 2376693 defendant Towe William husbandman 589712 589712 Towe, William, of New Wyndesore, husbandman 0
5067144 2376693 2376693 defendant Hunte Roger sherman 589712 589712 Hunte, Roger, of New Wyndesore, sherman 1
5070891 2377788 2377788 defendant Capron Thomas tanner 589712 589712 Capron, Thomas, of New Wyndesore, tanner 1
5076047 2379333 2379333 defendant Wayte Roger husbandman 589712 589712 Wayte, Roger, of New Wyndesore, husbandman 1
5088758 2383089 2383089 defendant Sherman Roger yeoman 589712 589712 Sherman, Roger, of New Wyndesore, yeoman 0
5091698 2383962 2383962 defendant Towe William husbandman 589712 589712 Towe, William, of New Wyndesore, husbandman 0
5091699 2383962 2383962 defendant Hunt Roger sherman 589712 589712 Hunt, Roger, of New Wyndesore, sherman 1
5096076 2385288 2385288 defendant Hunt alias Sherman Roger husbandman 589712 589712 Hunt alias Sherman, Roger, of New Wyndesore, husbandman 0
5118696 2391898 2391898 defendant Bythewode Wiliam husbandman 589712 589712 Bythewode, Wiliam, of New Wyndesore, husbandman 3
5120172 2392337 2392337 defendant Hacche Thomas smith 589712 589712 Hacche, Thomas, of New Wyndesore, smith 0
5134929 2396717 2396717 defendant Pyle Alice   589712 589712 Pyle, Alice, of New Wyndesore, widow, formerly wife of Richard Pyle 0
5156803 2403148 2403148 defendant Leneham John laborer 589712 589712 Leneham, John, of New Wyndesore, laborer 0
5224586 2422859 2422859 defendant mainpernors for Fastnam Roger yeoman 589712 589712 mainpernors for Fastnam, Roger, of New Wyndesore, yeoman 2
5244761 2428638 2428638 defendant Scot John saddler 589712 589712 Scot, John, of New Wyndesore, saddler 4
5246390 2429105 2429105 defendant Scherman Thomas sherman 589712 589712 Scherman, Thomas, of New Wyndesore, sherman 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);