names

84 rows where place_id = 607566

✎ 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
3669846 1916514 1916514 plaintiff Borowe Thomas husbandman 607566 607566 Borowe, Thomas, of Bonyngton, husbandman 0
3770632 1948499 1948499 defendant Byxson Humphrey husbandman 607566 607566 Byxson, Humphrey, of Bonyngton, husbandman 0
4497226 2199785 2199785 defendant Langwath Roger   607566 607566 Langwath, Roger, of Bonyngton 0
4535550 2211393 2211393 plaintiff Smyth Agnes daughter of John 607566 607566 Smyth, Agnes, of Bonyngton, daughter of John 0
4536787 2211777 2211777 defendant Wyldebore John   607566 607566 Wyldebore, John, of Bonyngton 2
4546291 2214773 2214773 defendant Wykeman William   607566 607566 Wykeman, William, of Bonyngton 0
4551269 2216335 2216335 defendant Wykman William cooper 607566 607566 Wykman, William, of Bonyngton, cooper 6
4572613 2222971 2222971 defendant Brede Richard weaver 607566 607566 Brede, Richard, of Bonyngton, weaver 0
4583416 2226233 2226233 defendant Wylymot Richard   607566 607566 Wylymot, Richard, of Bonyngton 2
4608813 2233860 2233860 defendant Kyvet Simon   607566 607566 Kyvet, Simon, of Bonyngton 0
4614767 2235630 2235630 plaintiff Caton William   607566 607566 Caton, William, of Bonyngton, formerly parson 4
4614793 2235635 2235635 plaintiff Caton William   607566 607566 Caton, William, of Bonyngton, formerly parson 4
4618445 2236779 2236779 defendant Caunton John   607566 607566 Caunton, John, of Bonyngton 2
4628560 2239856 2239856 defendant Kynet or Kyvet Simon   607566 607566 Kynet or Kyvet, Simon, of Bonyngton 0
4628562 2239857 2239857 defendant Kynet Simon   607566 607566 Kynet, Simon, of Bonyngton 0
4637564 2242536 2242536 defendant Kynet or Kyvet Simon   607566 607566 Kynet or Kyvet, Simon, of Bonyngton 0
4647209 2245239 2245239 defendant Bonyngton Henry   607566 607566 Bonyngton, Henry, of Bonyngton 0
4647211 2245240 2245240 defendant Kyvet or Kynet Simon   607566 607566 Kyvet or Kynet, Simon, of Bonyngton 0
4655101 2247478 2247478 defendant Kynet Simon   607566 607566 Kynet, Simon, of Bonyngton 0
4657362 2248194 2248194 defendant Holde John yeoman 607566 607566 Holde, John, of Bonyngton, yeoman 1
4677668 2258632 2258632 defendant Frensshe Reginald laborer 607566 607566 Frensshe, Reginald, of Bonyngton, laborer 2
4678950 2259022 2259022 defendant Hebbynge Robert clerk 607566 607566 Hebbynge, Robert, of Bonyngton, clerk 0
4742163 2278201 2278201 defendant Soket John husbandman 607566 607566 Soket, John, of Bonyngton, husbandman 0
4748266 2280001 2280001 defendant Bonyngton Henry yeoman 607566 607566 Bonyngton, Henry, of Bonyngton, yeoman 0
4757165 2282609 2282609 defendant Kynet or Kyvet Walter laborer 607566 607566 Kynet or Kyvet, Walter, of Bonyngton, laborer 0
4757166 2282609 2282609 defendant Lord William laborer 607566 607566 Lord, William, of Bonyngton, laborer 1
4757169 2282610 2282610 defendant Kynet or Kyvet Walter laborer 607566 607566 Kynet or Kyvet, Walter, of Bonyngton, laborer 0
4757170 2282610 2282610 defendant Lord William laborer 607566 607566 Lord, William, of Bonyngton, laborer 1
4767186 2285723 2285723 defendant Bonyngton Henry yeoman 607566 607566 Bonyngton, Henry, of Bonyngton, yeoman 0
4779172 2289461 2289461 defendant Kynet Walter laborer 607566 607566 Kynet, Walter, of Bonyngton, laborer 0
4779173 2289461 2289461 defendant Lord William laborer 607566 607566 Lord, William, of Bonyngton, laborer 1
4781385 2290189 2290189 defendant Brun Robert yeoman 607566 607566 Brun, Robert, of Bonyngton, yeoman 1
4791592 2293465 2293465 defendant Bonyngton Henry yeoman 607566 607566 Bonyngton, Henry, of Bonyngton, yeoman 0
4806694 2298302 2298302 defendant Clyffe Robert husbandman 607566 607566 Clyffe, Robert, of Bonyngton, husbandman 1
4806708 2298306 2298306 defendant Tomlynson Lawrence husbandman 607566 607566 Tomlynson, Lawrence, of Bonyngton, husbandman 2
4817037 2301427 2301427 defendant Deweson Nicholas husbandman 607566 607566 Deweson, Nicholas, of Bonyngton, husbandman 3
4832535 2306202 2306202 defendant Wykman William husbandman 607566 607566 Wykman, William, of Bonyngton, husbandman 0
4832536 2306202 2306202 defendant Wykman William laborer 607566 607566 Wykman, William, of Bonyngton, laborer 1
4832537 2306202 2306202 defendant atte Gate John laborer 607566 607566 atte Gate, John, of Bonyngton, laborer 2
4850221 2311528 2311528 plaintiff Fendyk William chaplain 607566 607566 Fendyk, William, of Bonyngton, chaplain 1
4852223 2312125 2312125 defendant Derby John gent 607566 607566 Derby, John, of Bonyngton, gent 3
4857583 2313761 2313761 defendant Sandre Michael husbandman 607566 607566 Sandre, Michael, of Bonyngton, husbandman 1
4857584 2313761 2313761 defendant Kynet William husbandman 607566 607566 Kynet, William, of Bonyngton, husbandman 2
4879355 2320471 2320471 defendant Clyff Robert husbandman 607566 607566 Clyff, Robert, of Bonyngton, husbandman 1
4907044 2328780 2328780 defendant Kynet Richard husbandman 607566 607566 Kynet, Richard, of Bonyngton, husbandman 0
4935578 2337520 2337520 defendant Sherman John husbandman 607566 607566 Sherman, John, of Bonyngton, husbandman 3
4963585 2346024 2346024 defendant Kempe Robert clerk 607566 607566 Kempe, Robert, of Bonyngton, clerk 0
4990776 2354144 2354144 defendant Kynet William yeoman 607566 607566 Kynet, William, of Bonyngton, yeoman 0
4998580 2356461 2356461 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5009262 2359594 2359594 defendant Elys Thomas husbandman 607566 607566 Elys, Thomas, of Bonyngton, husbandman 0
5025559 2364380 2364380 defendant Wykeman William cooper 607566 607566 Wykeman, William, of Bonyngton, cooper 0
5025560 2364380 2364380 defendant Godfrey Eustace laborer 607566 607566 Godfrey, Eustace, of Bonyngton, laborer 1
5025561 2364381 2364381 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025562 2364381 2364381 defendant Breggelond William yeoman 607566 607566 Breggelond, William, of Bonyngton, yeoman 0
5025563 2364382 2364382 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025565 2364383 2364383 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025568 2364383 2364383 defendant Frost Stephen   607566 607566 Frost, Stephen, of Bonyngton, repyar or fishmonger 2
5025571 2364384 2364384 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025573 2364385 2364385 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025575 2364385 2364385 defendant Frost Stephen repyer or fishmonger 607566 607566 Frost, Stephen, of Bonyngton, repyer or fishmonger 1
5025577 2364386 2364386 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025579 2364387 2364387 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025582 2364388 2364388 plaintiff Kenet William   607566 607566 Kenet, William, of Bonyngton 0
5025910 2364473 2364473 plaintiff Kynet William   607566 607566 Kynet, William, of Bonyngton 0
5025911 2364473 2364473 defendant Breggelond William husbandman 607566 607566 Breggelond, William, of Bonyngton, husbandman 0
5025912 2364473 2364473 defendant Gate John husbandman 607566 607566 Gate, John, of Bonyngton, husbandman 1
5025913 2364473 2364473 defendant Wykman William cooper 607566 607566 Wykman, William, of Bonyngton, cooper 2
5025914 2364473 2364473 defendant Godfrey Eustace laborer 607566 607566 Godfrey, Eustace, of Bonyngton, laborer 3
5025918 2364474 2364474 plaintiff Kynet William   607566 607566 Kynet, William, of Bonyngton 0
5045306 2370222 2370222 defendant William Simon laborer 607566 607566 William, Simon, of Bonyngton, laborer 2
5045307 2370222 2370222 defendant Wykman William laborer 607566 607566 Wykman, William, of bonyngton, laborer 3
5045433 2370263 2370263 plaintiff Kynet Wiilliam   607566 607566 Kynet, Wiilliam, of Bonyngton 0
5045489 2370280 2370280 defendant Breggelond William husbandman 607566 607566 Breggelond, William, of Bonyngton, husbandman 0
5045490 2370280 2370280 defendant Wykman William cooper 607566 607566 Wykman, William, of Bonyngton, cooper 1
5045491 2370280 2370280 defendant Godfrey Eustace laborer 607566 607566 Godfrey, Eustace, of Bonyngton, laborer 2
5045494 2370280 2370280 defendant Gate John husbandman 607566 607566 with Gate, John, of Bonyngton, husbandman 5
5113284 2390280 2390280 plaintiff Kynet or Kenet or Kyvet William (legal representative) 607566 607566 Kynet or Kenet or Kyvet, William, of Bonyngton, executors of 0
5133858 2396398 2396398 plaintiff Kenet William (legal representative) 607566 607566 Kenet, William, of Bonyngton, executors of 0
5153912 2402303 2402303 plaintiff Kynet alias Kenet William   607566 607566 Kynet alias Kenet, William, of Bonyngton 0
5171023 2407250 2407250 plaintiff Kenet William (legal representative) 607566 607566 Kenet, William, of Bonyngton, executors of 0
5385319 2470876 2470876 defendant Gollyffe Thomas husbandman 607566 607566 Gollyffe, Thomas, of Bonyngton, husbandman 0
5563927 2524061 2524061 defendant Felde Robert husbandman 607566 607566 Felde, Robert, of Bonyngton, husbandman 1
5593964 2533102 2533102 defendant Blakwall Robert laborer 607566 607566 Blakwall, Robert, of Bonyngton, laborer 4
5609904 2546803 2546803 defendant Bron Hugh   607566 607566 Bron, Hugh, of Bonyngton 3

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