names

72 rows where place_id = 586851

✎ 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
3589806 1864453 1864453 defendant Ardorn Robert husbandman 586851 586851 Ardorn, Robert, of Adyngton, husbandman 1
3589807 1864453 1864453 defendant Gadbury John husbandman 586851 586851 Gadbury, John, of Adyngton, husbandman 2
3615445 1872472 1872472 defendant Watton William gent 586851 586851 Watton, William, of Adyngton, gent 0
3615446 1872472 1872472 defendant Watton John gent 586851 586851 Watton, John, of Adyngton, gent 1
3620917 1874104 1874104 defendant Sayer Robert yeoman 586851 586851 Sayer, Robert, of Adyngton, yeoman 0
3637588 1906567 1906567 defendant Watton Edmund gent 586851 586851 Watton, Edmund, of Adyngton, gent 0
3637589 1906567 1906567 defendant Delton John yeoman 586851 586851 Delton, John, of Adyngton, yeoman 1
3699905 1926199 1926199 defendant Brougar or Brongar John collier 586851 586851 Brougar or Brongar, John, of Adyngton, collier 1
3718858 1932175 1932175 defendant Stydolf John husbandman 586851 586851 Stydolf, John, of Adyngton, husbandman 1
3756810 1944102 1944102 defendant Clemens Edmund husbandman 586851 586851 Clemens, Edmund, of Adyngton, husbandman 1
3756811 1944102 1944102 defendant Clerke William husbandman 586851 586851 Clerke, William, of Adyngton, husbandman 2
3769348 1948069 1948069 defendant Pursell Edward husbandman 586851 586851 Pursell, Edward, of Adyngton, husbandman 2
3775185 1949971 1949971 defendant Lygh Nicholas gent 586851 586851 Lygh, Nicholas, of Adyngton, gent 0
3775237 1949989 1949989 defendant Lygh Nicholas gent 586851 586851 Lygh, Nicholas, of Adyngton, gent 0
3804436 1959326 1959326 defendant Squery Henry yeoman 586851 586851 Squery, Henry, of Adyngton, yeoman 0
3842688 1971245 1971245 defendant Johnson John husbandman 586851 586851 Johnson, John, of Adyngton, husbandman 0
3902128 1990945 1990945 defendant Gambull Thomas husbandman 586851 586851 Gambull, Thomas, of Adyngton, husbandman 0
3902130 1990946 1990946 defendant Ganbull Thomas husbandman 586851 586851 Ganbull, Thomas, of Adyngton, husbandman 0
3937199 2002773 2002773 plaintiff Nethercot Thomas   586851 586851 Nethercot, Thomas, of Adyngton 0
3957816 2009794 2009794 defendant Ayre or Heyres Anthiny gent 586851 586851 Ayre or Heyres, Anthiny, of Adyngton, gent 0
4197121 2094546 2094546 defendant Balmer Reginald yeoman 586851 586851 Balmer, Reginald, of Adyngton, yeoman 0
4447484 2184125 2184125 defendant Frere Richard   586851 586851 Frere, Richard, of Adyngton 1
4460392 2188310 2188310 defendant Daundelyn John clerk 586851 586851 Daundelyn, John, of Adyngton, clerk 0
4460457 2188336 2188336 defendant Daundelyn John clerk 586851 586851 Daundelyn, John, of Adyngton, clerk 0
4471694 2191813 2191813 defendant Stones Thomas   586851 586851 Stones, Thomas, of Adyngton 2
4485387 2196132 2196132 defendant Auton John   586851 586851 Auton, John, of Adyngton, parson 0
4546235 2214768 2214768 defendant Leth John   586851 586851 Leth, John, of Adyngton 0
4646747 2245116 2245116 plaintiff Reyndon Richard   586851 586851 Reyndon, Richard, of Adyngton 0
4672899 2257164 2257164 defendant Claygate John husbandman 586851 586851 with Claygate, John, of Adyngton, husbandman 3
4675447 2257930 2257930 defendant Warla--r Thomas husbandman 586851 586851 Warla--r, Thomas, of Adyngton, husbandman 0
4675448 2257930 2257930 defendant Werdswy Simon laborer 586851 586851 Werdswy, Simon, of Adyngton, laborer 1
4698592 2265034 2265034 defendant Parker John   586851 586851 Parker, John, of Adyngton 1
4705331 2267040 2267040 defendant Parker John   586851 586851 Parker, John, of Adyngton 1
4706550 2267426 2267426 defendant Parker John   586851 586851 Parker, John, of Adyngton 1
4738372 2277098 2277098 defendant atte Ovene John husbandman 586851 586851 atte Ovene, John, of Adyngton, husbandman 0
4763252 2284496 2284496 defendant Monk William husbandman 586851 586851 Monk, William, of Adyngton, husbandman 0
4884215 2321972 2321972 defendant Bailly Robert yeoman 586851 586851 Bailly, Robert, of Adyngton, yeoman 0
4891801 2324178 2324178 defendant Kynot John laborer 586851 586851 Kynot, John, of Adyngton, laborer 0
4925708 2334473 2334473 defendant Kynot John husbandman 586851 586851 Kynot, John, of Adyngton, husbandman 1
4938720 2338496 2338496 defendant Godyn Thomas laborer 586851 586851 Godyn, Thomas, of Adyngton, laborer 0
4938725 2338498 2338498 defendant Gerard John mariner 586851 586851 Gerard, John, of Adyngton, mariner 0
4964442 2346275 2346275 defendant Frere John sawyer 586851 586851 Frere, John, of Adyngton, sawyer 0
4991071 2354219 2354219 defendant Kynet or Kyvet John laborer 586851 586851 Kynet or Kyvet, John, of Adyngton, laborer 0
5006342 2358753 2358753 defendant Martrete Walter husbandman 586851 586851 Martrete, Walter, of Adyngton, husbandman 2
5044939 2370120 2370120 defendant Waller or Walker John husbandman 586851 586851 Waller or Walker, John, of Adyngton, husbandman 0
5060069 2374578 2374578 defendant Keme William wheeler 586851 586851 Keme, William, of Adyngton, wheeler 0
5060070 2374578 2374578 defendant atte Stile Richard (legal representative) 586851 586851 atte Stile, Richard, of Adyngton, husbandman, executors of 1
5105233 2387970 2387970 defendant Bysshop John yeoman 586851 586851 Bysshop, John, of Adyngton, yeoman 2
5197600 2415035 2415035 defendant Legh John gent 586851 586851 Legh, John, of Adyngton, gent 0
5197601 2415035 2415035 defendant Legh Robert gent 586851 586851 Legh, Robert, of Adyngton, gent 1
5213094 2419564 2419564 defendant Godyn John wheeler 586851 586851 Godyn, John, of Adyngton, wheeler 3
5243579 2428315 2428315 defendant Osbern Robert laborer 586851 586851 Osbern, Robert, of Adyngton, laborer 4
5296089 2443845 2443845 defendant Watton Edmund gent 586851 586851 Watton, Edmund, of Adyngton, gent 0
5296092 2443846 2443846 defendant Watton Edmund gent 586851 586851 Watton, Edmund, of Adyngton, gent 0
5298170 2444482 2444482 defendant Baynton Thomas clerk 586851 586851 Baynton, Thomas, of Adyngton, clerk 0
5305349 2446606 2446606 defendant Godefelowe Henry clerk 586851 586851 Godefelowe, Henry, of Adyngton, clerk 0
5309788 2447962 2447962 defendant Witton Edmund gent 586851 586851 Witton, Edmund, of Adyngton, gent 0
5313891 2449177 2449177 defendant Hayward Thomas husbandman 586851 586851 Hayward, Thomas, of Adyngton, husbandman 1
5325354 2452669 2452669 defendant Elyse John husbandman 586851 586851 Elyse, John, of Adyngton, husbandman 0
5351381 2460530 2460530 defendant Fryre Stephen sawyer 586851 586851 Fryre, Stephen, of Adyngton, sawyer 2
5357158 2462301 2462301 defendant Harman Richard husbandman 586851 586851 Harman, Richard, of Adyngton, husbandman 4
5357164 2462302 2462302 defendant Godyn William wheeler 586851 586851 Godyn, William, of Adyngton, wheeler 4
5367624 2465517 2465517 defendant Clympton Roger loaborer 586851 586851 Clympton, Roger, of Adyngton, loaborer 2
5375867 2468044 2468044 defendant Deyse Thomas husbandman 586851 586851 Deyse, Thomas, of Adyngton, husbandman 0
5385884 2471037 2471037 defendant Idyknam Thomas laborer 586851 586851 Idyknam, Thomas, of Adyngton, laborer 0
5398082 2474520 2474520 defendant Pyknam Thomas laborer 586851 586851 Pyknam, Thomas, of Adyngton, laborer 0
5468510 2495523 2495523 defendant Arthern Robert husbandman 586851 586851 Arthern, Robert, of Adyngton, husbandman 0
5504951 2506466 2506466 defendant Richard Thomas husbandman 586851 586851 Richard, Thomas, of Adyngton, husbandman 1
5504952 2506466 2506466 defendant Godyng William wheeler 586851 586851 Godyng, William, of Adyngton, wheeler 2
5512788 2508852 2508852 defendant Joyner John husbandman 586851 586851 Joyner, John, of Adyngton, husbandman 1
5518059 2510486 2510486 defendant Coteler William husbandman 586851 586851 Coteler, William, of Adyngton, husbandman 4
5620538 2550282 2550282 defendant Bedoune Robert   586851 586851 Bedoune, Robert, of Adyngton 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);