names

76 rows where place_id = 592182

✎ 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
3606866 1869813 1869813 defendant Bygge John miller 592182 592182 Bygge, John, of Wantyng, miller 1
3623850 1874989 1874989 defendant Estmond Richard yeoman 592182 592182 Estmond, Richard, of Wantyng, yeoman 0
3655670 1912038 1912038 defendant Frankelen William tanner 592182 592182 Frankelen, William, of Wantyng, tanner 0
3655672 1912039 1912039 defendant Frankeleyn William tinner 592182 592182 Frankeleyn, William, of Wantyng, tinner 0
3681846 1920427 1920427 defendant Leyche Thomas butcher 592182 592182 Leyche, Thomas, of Wantyng, butcher 1
3685194 1921520 1921520 defendant Rychardys Robert yeoman 592182 592182 Rychardys, Robert, of Wantyng, yeoman 0
3721116 1932901 1932901 defendant Radysshe Nicholas yeoman 592182 592182 Radysshe, Nicholas, of Wantyng, yeoman 0
3741477 1939203 1939203 defendant Radysshe Nicholas yeoman 592182 592182 Radysshe, Nicholas, of Wantyng, yeoman 0
3741479 1939204 1939204 defendant Radysshe Nicholas yeoman 592182 592182 Radysshe, Nicholas, of Wantyng, yeoman 0
3741481 1939205 1939205 defendant Radysshe Nicholas yeoman 592182 592182 Radysshe, Nicholas, of Wantyng, yeoman 0
3741620 1939248 1939248 defendant Tyler James barber 592182 592182 Tyler, James, of Wantyng, barber 0
3741621 1939248 1939248 defendant Newton alias Prykker Thomas tanner 592182 592182 Newton alias Prykker, Thomas, of Wantyng, tanner 1
3752442 1942686 1942686 plaintiff Radysche Nicholas   592182 592182 Radysche, Nicholas, of Wantyng 0
3752444 1942687 1942687 plaintiff Radysshe Nicholas yeoman 592182 592182 Radysshe, Nicholas, of Wantyng, yeoman 0
3789599 1954575 1954575 defendant Estmond William husbandman 592182 592182 Estmond, William, of Wantyng, husbandman 0
3836068 1969194 1969194 defendant Cawper Lawrence husbandman 592182 592182 Cawper, Lawrence, of Wantyng, husbandman 0
3863552 1978004 1978004 defendant Sarneham Stephen yeoman 592182 592182 Sarneham, Stephen, of Wantyng, yeoman 1
3863553 1978004 1978004 defendant Radige Nicholas yeoman 592182 592182 Radige, Nicholas, of Wantyng, yeoman 2
3863554 1978004 1978004 defendant Aldeworthe Robert yeoman 592182 592182 Aldeworthe, Robert, of Wantyng, yeoman 3
3863555 1978004 1978004 defendant Estmode William yeoman 592182 592182 Estmode, William, of Wantyng, yeoman 4
3863561 1978005 1978005 defendant Estmonde William yeoman 592182 592182 Estmonde, William, of Wantyng, yeoman 4
3869479 1980033 1980033 defendant Radyssh Nicholas yeoman 592182 592182 Radyssh, Nicholas, of Wantyng, yeoman 0
3902605 1991104 1991104 defendant Yate Edmund mercer 592182 592182 Yate, Edmund, of Wantyng, mercer 0
3907890 1992928 1992928 defendant Aldeworth Robert, junior tanner 592182 592182 Aldeworth, Robert, junior, of Wantyng, tanner 0
4109293 2063585 2063585 defendant Gryffyn or Gryffeth John tailor 592182 592182 Gryffyn or Gryffeth, John, of Wantyng, tailor 0
4223340 2103656 2103656 defendant Clarke John glover 592182 592182 Clarke, John, of Wantyng, glover 0
4501361 2201031 2201031 defendant Chapman John   592182 592182 Chapman, John, of Wantyng 1
4537867 2212128 2212128 defendant Baker William   592182 592182 Baker, William, of Wantyng 0
4606281 2233076 2233076 defendant Rys Philip   592182 592182 Rys, Philip, of Wantyng 1
4626617 2239269 2239269 defendant Payn John   592182 592182 Payn, John, of Wantyng 0
4626619 2239270 2239270 defendant Payn John   592182 592182 Payn, John, of Wantyng 0
4656845 2248036 2248036 defendant Mulleward William   592182 592182 Mulleward, William, of Wantyng, millward 0
4717759 2270894 2270894 defendant Sclatter John yeoman 592182 592182 Sclatter, John, of Wantyng, yeoman 0
4717760 2270894 2270894 defendant Salesbury John weaver 592182 592182 Salesbury, John, of Wantyng, weaver 1
4754284 2281718 2281718 defendant Shopper John husbandman 592182 592182 Shopper, John, of Wantyng, husbandman 1
4800674 2296393 2296393 defendant Graunt John husbandman 592182 592182 Graunt, John, of Wantyng, husbandman 2
4801351 2296612 2296612 defendant Clotheman John husbandman 592182 592182 Clotheman, John, of Wantyng, husbandman 0
4860414 2314621 2314621 defendant Kempe John laborer 592182 592182 Kempe, John, of Wantyng, laborer 0
4912536 2330422 2330422 defendant Tubbe Richard husbandman 592182 592182 Tubbe, Richard, of Wantyng, husbandman 0
4918151 2332197 2332197 defendant Heyward alias Freman Thomas shoemaker 592182 592182 Heyward alias Freman, Thomas, of Wantyng, shoemaker 0
4943773 2340021 2340021 defendant Tubbe Richard husbandman 592182 592182 (Tubbe, Richard, of Wantyng, husbandman 1
4943774 2340021 2340021 defendant Pleystowe Emma widow 592182 592182 Pleystowe, Emma, of Wantyng, widow 2
4966898 2347027 2347027 defendant Dyer Walter (legal representative) 592182 592182 Dyer, Walter, of Wantyng, executrix of 0
4966899 2347027 2347027 defendant Dyer Agnes widow 592182 592182 Dyer, Agnes, of Wantyng, widow 1
5037589 2367867 2367867 plaintiff Chunne John tanner 592182 592182 Chunne, John, of Wantyng, tanner 2
5046396 2370562 2370562 plaintiff Merlawe Roger   592182 592182 Merlawe, Roger, of Wantyng 0
5046400 2370562 2370562 defendant Wyot Alice   592182 592182 (Wyot, Alice, of Wantyng, widow, formerly wife of Testator 3
5046401 2370562 2370562 defendant Wyot Robert husbandman 592182 592182 Wyot, Robert, of Wantyng, son of Testator, husbandman 4
5080721 2380728 2380728 plaintiff Colyns John gent 592182 592182 Colyns, John, of Wantyng, gent 0
5126002 2394090 2394090 plaintiff Berymyll alias Northe Roger   592182 592182 Berymyll alias Northe, Roger, of Wantyng 0
5135878 2397009 2397009 plaintiff Mortemer John   592182 592182 Mortemer, John, of Wantyng 0
5135880 2397009 2397009 defendant Byrymyll (illegible) weaver 592182 592182 Byrymyll, ----, of Wantyng, weaver 1
5144624 2399586 2399586 plaintiff Berymyll Roger   592182 592182 Berymyll, Roger, of Wantyng 0
5155747 2402843 2402843 plaintiff Merlawe Roger gent 592182 592182 Merlawe, Roger, of Wantyng, gent 0
5242757 2428088 2428088 plaintiff Mortemer John (legal representative) 592182 592182 Mortemer, John, of Wantyng, executors of 0
5242761 2428088 2428088 defendant Byrymyll Roger osteler 592182 592182 Byrymyll, Roger, of Wantyng, osteler 0
5246393 2429105 2429105 defendant Burymyll Roger weaver 592182 592182 Burymyll, Roger, of Wantyng, weaver 3
5256948 2432303 2432303 defendant Estmond Thomas yeoman 592182 592182 Estmond, Thomas, of Wantyng, yeoman 0
5257282 2432400 2432400 defendant Lovetoppe John husbandman 592182 592182 Lovetoppe, John, of Wantyng, husbandman 1
5267550 2435611 2435611 defendant Wyllis John clerk 592182 592182 Wyllis, John, of Wantyng, clerk 0
5291542 2442529 2442529 plaintiff Pratte Henry   592182 592182 Pratte, Henry, of Wantyng 0
5374037 2467483 2467483 plaintiff Natsale Richard   592182 592182 Natsale, Richard, of Wantyng 0
5514228 2509296 2509296 defendant Fynch Richard husbandman 592182 592182 Fynch, Richard, of Wantyng, husbandman 0
5539196 2516745 2516745 defendant Clynche John butcher 592182 592182 Clynche, John, of Wantyng, butcher 0
5539197 2516745 2516745 defendant Ley John husbandman 592182 592182 Ley, John, of Wantyng, husbandman 1
5546736 2519049 2519049 defendant Estmond Richard yeoman 592182 592182 Estmond, Richard, of Wantyng, yeoman 0
5546737 2519049 2519049 defendant Colles Robert yeoman 592182 592182 Colles, Robert, of Wantyng, yeoman 1
5546747 2519052 2519052 defendant Estmond Richard yeoman 592182 592182 Estmond, Richard, of Wantyng, yeoman 0
5546748 2519052 2519052 defendant Colles Robert yeoman 592182 592182 Colles, Robert, of Wantyng, yeoman 1
5562432 2523612 2523612 defendant Pryker Thomas husbandman 592182 592182 Pryker, Thomas, of Wantyng, husbandman 0
5577590 2528057 2528057 defendant Tubbe Richard husbandman 592182 592182 Tubbe, Richard, of Wantyng, husbandman 1
5577592 2528057 2528057 defendant Hendyn Richard baker 592182 592182 Hendyn, Richard, of Wantyng, baker 3
5579646 2528718 2528718 defendant Whytburgh John tailor 592182 592182 Whytburgh, John, of Wantyng, tailor 0
5604202 2536176 2536176 defendant Leche Thomas butcher 592182 592182 Leche, Thomas, of Wantyng, butcher 0
5604207 2536176 2536176 defendant Kyllyngale John tailor 592182 592182 Kyllyngale, John, of Wantyng, tailor 5
5613583 2548025 2548025 defendant Doghere John   592182 592182 Doghere, John, of Wantyng 0

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);