names

221 rows where place_id = 756733

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4414087 2169310 2169310 plaintiff Cliflok William (legal representative) 756733 756733 Cliflok, William, of Kirketon in Holand, executor of 0
4431714 2174691 2174691 plaintiff Brunthorp Walter de   756733 756733 Brunthorp, Walter de, of Kirketon in Holand, vicar 0
4439954 2181778 2181778 defendant Bukhole John   756733 756733 Bukhole, John, of Kirketon in Holand 0
4440329 2181888 2181888 defendant Cane Thomas   756733 756733 Cane, Thomas, of Kirketon in Holand 0
4443357 2182881 2182881 defendant Houghson John   756733 756733 Houghson, John, of Kirketon in Holand 1
4448955 2184614 2184614 plaintiff Gasson John (legal representative) 756733 756733 Gasson, John, of Kirketon in Holand, executors of 0
4448957 2184614 2184614 plaintiff Rome John   756733 756733 Rome, John, of Kirketon in Holand 2
4448958 2184614 2184614 defendant Shephird John   756733 756733 Shephird, John, of Kirketon in Holand, son of Martin 0
4452732 2185865 2185865 defendant Algar Thomas   756733 756733 Algar, Thomas, of Kirketon in Holand, son of Roger 0
4454839 2186525 2186525 plaintiff Marsshall Walter   756733 756733 Marsshall, Walter, of Kirketon in Holand 0
4454840 2186525 2186525 defendant Tutte Thomas   756733 756733 Tutte, Thomas, of Kirketon in Holand 0
4460620 2188379 2188379 plaintiff Skynner Thomas (legal representative) 756733 756733 Skynner, Thomas, of Kirketon in Holand, executors of 0
4465550 2189896 2189896 plaintiff Wrothe Alice   756733 756733 Wrothe, Alice, of Kirketon in Holand 0
4492576 2198377 2198377 defendant Byngham John de   756733 756733 Byngham, John de, of Kirketon in Holand 3
4497061 2199744 2199744 plaintiff del Grene John   756733 756733 del Grene, John, of Kirketon in Holand 0
4497062 2199744 2199744 defendant Baunburgh John   756733 756733 Baunburgh, John, of Kirketon in Holand 0
4497063 2199744 2199744 defendant Coupeman Alexander   756733 756733 Coupeman, Alexander, of Kirketon in Holand 1
4497066 2199744 2199744 defendant Beme John   756733 756733 Beme, John, of Kirketon in Holand 4
4497068 2199745 2199745 plaintiff del Grene John   756733 756733 del Grene, John, of Kirketon in Holand 0
4501970 2201214 2201214 plaintiff Marshall Alan   756733 756733 Marshall, Alan, of Kirketon in Holand 0
4501972 2201214 2201214 defendant Coupman Alexander   756733 756733 Coupman, Alexander, of Kirketon in Holand 1
4501973 2201214 2201214 defendant Foole Anngerus   756733 756733 Foole, Anngerus, of Kirketon in Holand 2
4501974 2201214 2201214 defendant Mershall John   756733 756733 Mershall, John, of Kirketon in Holand 3
4501975 2201215 2201215 plaintiff Marshall Alan   756733 756733 Marshall, Alan, of Kirketon in Holand 0
4501981 2201218 2201218 plaintiff Marssh Robert   756733 756733 Marssh, Robert, of Kirketon in Holand 0
4501987 2201219 2201219 plaintiff Marsshall Robert   756733 756733 Marsshall, Robert, of Kirketon in Holand 0
4501989 2201219 2201219 defendant Gedeson John   756733 756733 Gedeson, John, of Kirketon in Holand 1
4501993 2201219 2201219 defendant Dekyn Robert chaplain 756733 756733 Dekyn, Robert, of Kirketon in Holand, chaplain 5
4514327 2204897 2204897 defendant Colson John   756733 756733 Colson, John, of Kirketon in Holand 6
4519306 2206397 2206397 plaintiff Edon John   756733 756733 Edon, John, of Kirketon in Holand 0
4528907 2209321 2209321 plaintiff Welby Thomas de   756733 756733 Welby, Thomas de, of Kirketon in Holand 2
4536487 2211687 2211687 defendant Jonson Aleynson Richard   756733 756733 Jonson Aleynson, Richard, of Kirketon in Holand 0
4536488 2211687 2211687 defendant Toub John   756733 756733 Toub, John, of Kirketon in Holand 1
4538259 2212255 2212255 plaintiff Tomson Thomas   756733 756733 Tomson, Thomas, of Kirketon in Holand 1
4538260 2212255 2212255 defendant Aleyn John   756733 756733 Aleyn, John, of Kirketon in Holand 0
4544492 2214191 2214191 defendant Andreweson Thomas   756733 756733 Andreweson, Thomas, of Kirketon in Holand 0
4544494 2214192 2214192 defendant Andreweson Thomas   756733 756733 Andreweson, Thomas, of Kirketon In Holand 0
4548954 2215604 2215604 plaintiff Coke Alan   756733 756733 Coke, Alan, of Kirketon in Holand 0
4548955 2215604 2215604 defendant Edun John   756733 756733 Edun, John, of Kirketon in Holand, son of Robert 0
4559191 2218829 2218829 plaintiff Mason Gilbert   756733 756733 Mason, Gilbert, of Kirketon in Holand 0
4562197 2219745 2219745 defendant Howedale Robert   756733 756733 Howedale, Robert, of Kirketon in Holand 0
4562198 2219745 2219745 defendant Belers Roger   756733 756733 Belers, Roger, of Kirketon in Holand, vicar 1
4562199 2219745 2219745 defendant Stalworth William   756733 756733 Stalworth, William, of Kirketon in Holand 2
4563624 2220188 2220188 plaintiff Rogerson Thomas   756733 756733 Rogerson, Thomas, of Kirketon in Holand 0
4563625 2220188 2220188 defendant Foule John   756733 756733 Foule, John, of Kirketon in Holand, son of Alan 0
4570496 2222345 2222345 defendant Heyland Richard, sen   756733 756733 Heyland, Richard, sen, of Kirketon in Holand 2
4570498 2222346 2222346 defendant Bene John   756733 756733 Bene, John, of Kirketon in Holand 0
4570499 2222346 2222346 defendant (illegible) Richard   756733 756733 _, Richard, of Kirketon in Holand 1
4570500 2222346 2222346 defendant Heylond John   756733 756733 Heylond, John, of Kirketon in Holand 2
4583093 2226134 2226134 defendant Longelond John   756733 756733 Longelond, John, of Kirketon in Holand 0
4594350 2229490 2229490 defendant Poles John   756733 756733 Poles, John, of Kirketon in Holand 0
4595414 2229821 2229821 defendant Poles John   756733 756733 Poles, John, of Kirketon in Holand 0
4599505 2231060 2231060 defendant Welby Thomas   756733 756733 Welby, Thomas, of Kirketon in Holand 0
4602147 2231893 2231893 defendant Wace Thomas   756733 756733 Wace, Thomas, of Kirketon in Holand 1
4602349 2231951 2231951 plaintiff Welby Thomas de   756733 756733 Welby, Thomas de, of Kirketon in Holand 0
4602350 2231951 2231951 defendant Umfrey John   756733 756733 Umfrey, John, of Kirketon in Holand 0
4642450 2243915 2243915 defendant Iveson John   756733 756733 Iveson, John, of Kirketon in Holand 0
4676111 2258141 2258141 defendant Jonson Richard husbandman 756733 756733 Jonson, Richard, of Kirketon in Holand, husbandman 0
4678763 2258961 2258961 defendant Stalwroth John   756733 756733 Stalwroth, John, of Kirketon in Holand, wire drawer 0
4680251 2259435 2259435 defendant Hochonson Robert husbandman 756733 756733 Hochonson, Robert, of Kirketon in Holand, husbandman 0
4696620 2264419 2264419 defendant Wyndthorp John smith 756733 756733 Wyndthorp, John, of Kirketon in Holand, smith 3
4706114 2267288 2267288 defendant Poles John gent 756733 756733 Poles, John, of Kirketon in Holand, gent 0
4738280 2277067 2277067 defendant Littilbury Humphrey esq 756733 756733 Littilbury, Humphrey, of Kirketon in Holand, esq 0
4739741 2277504 2277504 defendant Knyght Richard weaver 756733 756733 Knyght, Richard, of Kirketon in Holand, weaver 1
4745982 2279326 2279326 defendant Iveson John yeoman 756733 756733 Iveson, John, of Kirketon in Holand, yeoman 0
4763012 2284417 2284417 defendant Iveson John husbandman 756733 756733 Iveson, John, of Kirketon in Holand, husbandman 0
4763014 2284417 2284417 defendant Hill William   756733 756733 Hill, William, of Kirketon in Holand, servant 2
4770374 2286704 2286704 defendant Hopkynson William husbandman 756733 756733 (Hopkynson, William, of Kirketon in Holand, husbandman 1
4770375 2286704 2286704 defendant Smyth John   756733 756733 Smyth, John, of Kirketon in Holand, husbandman, son of Alan Smyth 2
4773363 2287644 2287644 defendant Coke Richard husbandman 756733 756733 Coke, Richard, of Kirketon in Holand, husbandman 0
4784404 2291125 2291125 defendant Grayne or Grayve Alice   756733 756733 Grayne or Grayve, Alice, of Kirketon in Holand, widow of Grayne or Grayve, John, senior 1
4789321 2292723 2292723 defendant Trumpet Nicholas yeoman 756733 756733 Trumpet, Nicholas, of Kirketon in Holand, yeoman 0
4800694 2296399 2296399 defendant Porter William yeoman 756733 756733 Porter, William, of Kirketon in Holand, formerly of Quappelod, yeoman 1
4803092 2297153 2297153 defendant Heland John carter 756733 756733 Heland, John, of Kirketon in Holand, carter 0
4804043 2297448 2297448 defendant Iveson John husbandman 756733 756733 Iveson, John, of Kirketon in Holand, husbandman 0
4811536 2299717 2299717 defendant Barter Thomas laborer 756733 756733 Barter, Thomas, of Kirketon in Holand, laborer 0
4812723 2300092 2300092 defendant Grene Robert husbandman 756733 756733 Grene, Robert, of Kirketon in Holand, husbandman 1
4816354 2301203 2301203 defendant Grene John thatcher 756733 756733 Grene, John, of Kirketon in Holand, thatcher 0
4816376 2301213 2301213 defendant Bayly John tailor 756733 756733 Bayly, John, of Kirketon in Holand, tailor 0
4816378 2301214 2301214 defendant Heyland John husbandman 756733 756733 Heyland, John, of Kirketon in Holand, husbandman 0
4816450 2301235 2301235 defendant Stalworth John (legal representative) 756733 756733 Stalworth, John, of Kirketon in Holand, executor of 0
4816451 2301235 2301235 defendant Stalworth Robert husbandman 756733 756733 Stalworth, Robert, of Kirketon in Holand, husbandman 1
4817174 2301462 2301462 defendant Reynoldson Alan husbandman 756733 756733 Reynoldson, Alan, of Kirketon in Holand, husbandman 0
4819378 2302133 2302133 defendant Hopkynson Dyconson William husbandman 756733 756733 Hopkynson Dyconson, William, of Kirketon in Holand, husbandman 0
4819907 2302301 2302301 defendant Bykersweve Robert husbandman 756733 756733 Bykersweve, Robert, of Kirketon in Holand, husbandman 0
4820538 2302492 2302492 defendant Fideler Roger husbandman 756733 756733 Fideler, Roger, of Kirketon in Holand, husbandman 2
4823651 2303489 2303489 defendant Hughson Robert gent 756733 756733 Hughson, Robert, of Kirketon in Holand, gent 0
4823891 2303553 2303553 defendant Clerk William pardoner 756733 756733 Clerk, William, of Kirketon in Holand, pardoner 0
4825554 2304033 2304033 defendant Iveson John husbandman 756733 756733 Iveson, John, of Kirketon in Holand, husbandman 4
4827432 2304627 2304627 defendant Broun Richard husbandman 756733 756733 Broun, Richard, of Kirketon in Holand, husbandman 5
4827433 2304627 2304627 defendant Stable John de laborer 756733 756733 Stable, John de, of Kirketon in Holand, laborer 6
4827437 2304629 2304629 defendant Taket John husbandman 756733 756733 Taket, John, of Kirketon in Holand, husbandman 0
4836207 2307305 2307305 defendant Harvy Simon husbandman 756733 756733 Harvy, Simon, of Kirketon in Holand, husbandman 0
4850224 2311528 2311528 defendant Stevenson Thomas husbandman 756733 756733 Stevenson, Thomas, of Kirketon in Holand, husbandman 1
4851485 2311908 2311908 defendant Hervy (illegible) chaplain 756733 756733 Hervy, _, of Kirketon in Holand, chaplain 7
4863225 2315473 2315473 defendant Bryghtye William chaplain 756733 756733 Bryghtye, William, of Kirketon in Holand, chaplain 1
4878919 2320341 2320341 defendant Hervy Alan husbandman 756733 756733 Hervy, Alan, of Kirketon in Holand, husbandman 0
4882115 2321306 2321306 defendant Hughson Robert husbandman 756733 756733 Hughson, Robert, of Kirketon in Holand, husbandman 0
4884707 2322124 2322124 defendant Lock Roger   756733 756733 Lock, Roger, of Kirketon in Holand, mason 17
4886079 2322505 2322505 defendant Mason Gilbert yeoman 756733 756733 Mason, Gilbert, of Kirketon in Holand, yeoman 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);