names

84 rows where place_id = 594266

✎ 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
3615348 1872443 1872443 defendant Hunte William butcher 594266 594266 Hunte, William, of Wardon, butcher 0
3615349 1872443 1872443 defendant Chapon Robert laborer 594266 594266 Chapon, Robert, of Wardon, laborer 1
3637262 1906457 1906457 defendant Wydowson John husbandman 594266 594266 Wydowson, John, of Wardon, husbandman 0
3637263 1906457 1906457 defendant Bareleggys William husbandman 594266 594266 Bareleggys, William, of Wardon, husbandman 1
3637264 1906457 1906457 defendant (not given) Robert husbandman 594266 594266 -, Robert, of Wardon, husbandman 2
3637265 1906457 1906457 defendant Scote Nicholas husbandman 594266 594266 Scote, Nicholas, of Wardon, husbandman 3
3657444 1912587 1912587 defendant Hewkyns Richard hsubandman 594266 594266 Hewkyns, Richard, of Wardon, hsubandman 1
4451298 2185370 2185370 plaintiff Heynes William   594266 594266 Heynes, William, of Wardon, on his own account 0
4460725 2188413 2188413 defendant Taillour Giles   594266 594266 Taillour, Giles, of Wardon 0
4460733 2188414 2188414 defendant Sharp John   594266 594266 Sharp, John, of Wardon 1
4460734 2188414 2188414 defendant Wycham Thomas   594266 594266 Wycham, Thomas, of Wardon 2
4460735 2188414 2188414 defendant Rottele John   594266 594266 Rottele, John, of Wardon 3
4460739 2188415 2188415 defendant Bruwode Robert   594266 594266 Bruwode, Robert, of Wardon 0
4497847 2199970 2199970 plaintiff Elys John   594266 594266 Elys, John, of Wardon 0
4541471 2213229 2213229 defendant (not given) John vicar of Brewester 594266 594266 Brewester, John, of Wardon, vicar of Eyworth 0
4612858 2235083 2235083 defendant Scotour John   594266 594266 Scotour, John, of Wardon 0
4613982 2235387 2235387 defendant Scotur John   594266 594266 Scotur, John, of Wardon 0
4613983 2235387 2235387 defendant Luffe John   594266 594266 Luffe, John, of Wardon 1
4630919 2240564 2240564 defendant Bailly John   594266 594266 Bailly, John, of Wardon 0
4634151 2241525 2241525 defendant Barker Henry   594266 594266 Barker, Henry, of Wardon 0
4640641 2243372 2243372 defendant Scotour John   594266 594266 Scotour, John, of Wardon 4
4640869 2243427 2243427 plaintiff Elys John   594266 594266 Elys, John, of Wardon 0
4644187 2244394 2244394 defendant atte Halle John butcher 594266 594266 atte Halle, John, of Wardon, butcher 0
4644334 2244433 2244433 plaintiff Luffe John   594266 594266 Luffe, John, of Wardon 0
4661340 2249369 2249369 defendant Scotour John husbandman 594266 594266 Scotour, John, of Wardon, husbandman 1
4661341 2249369 2249369 defendant Luffe John husbandman 594266 594266 Luffe, John, of Wardon, husbandman 2
4666108 2250866 2250866 defendant Scoter John butcher 594266 594266 Scoter, John, of Wardon, butcher 0
4687350 2261645 2261645 defendant Underwode Thomas yeoman 594266 594266 Underwode, Thomas, of Wardon, yeoman 3
4691399 2262834 2262834 defendant Underwode Thomas husbandman 594266 594266 Underwode, Thomas, of Wardon, husbandman 1
4698619 2265044 2265044 defendant Fynden William chaplain 594266 594266 Fynden, William, of Wardon, chaplain 4
4701004 2265717 2265717 defendant Shelton John tanner 594266 594266 Shelton, John, of Wardon, tanner 0
4706488 2267409 2267409 defendant Adyngrave John husbandman 594266 594266 Adyngrave, John, of Wardon, husbandman 0
4740339 2277684 2277684 defendant Leper John husbandman 594266 594266 Leper, John, of Wardon, husbandman 2
4779738 2289655 2289655 defendant Bocher alias Denyas Roger butcher 594266 594266 Bocher alias Denyas, Roger, of Wardon, butcher 2
4801628 2296693 2296693 defendant Pande or Paude John husbandman 594266 594266 Pande or Paude, John, of Wardon, husbandman 3
4801629 2296693 2296693 defendant Haddekyn William husbandman 594266 594266 Haddekyn, William, of Wardon, husbandman 4
4803914 2297404 2297404 defendant Aspur Thomas   594266 594266 Aspur, Thomas, of Wardon, vicar 0
4816616 2301289 2301289 defendant Sharham William husbandman 594266 594266 Sharham, William, of Wardon, husbandman 0
4821995 2302950 2302950 defendant Goodlyff Thomas laborer 594266 594266 Goodlyff, Thomas, of Wardon, laborer 0
4831617 2305922 2305922 defendant Fraunceys John yeoman 594266 594266 Fraunceys, John, of Wardon, yeoman 0
4832618 2306224 2306224 defendant Cooke Robert yeoman 594266 594266 Cooke, Robert, of Wardon, yeoman 1
4838625 2308007 2308007 defendant Somer Richard husbandman 594266 594266 Somer, Richard, of Wardon, husbandman 0
4838627 2308008 2308008 defendant Somer Richard husbandman 594266 594266 Somer, Richard, of Wardon, husbandman 0
4845626 2310143 2310143 defendant Prutfote John husbandman 594266 594266 Prutfote, John, of Wardon, husbandman 0
4859449 2314332 2314332 defendant Cooke Robert yeoman 594266 594266 Cooke, Robert, of Wardon, yeoman 1
4859905 2314468 2314468 defendant Somer Richard husbandman 594266 594266 Somer, Richard, of Wardon, husbandman 0
4862846 2315364 2315364 defendant Pegge John husbandman 594266 594266 Pegge, John, of Wardon, husbandman 0
4874706 2319033 2319033 defendant Knyght John cordwainer 594266 594266 Knyght, John, of Wardon, cordwainer 0
4874707 2319033 2319033 defendant Pynne Robert laborer 594266 594266 Pynne, Robert, of Wardon, laborer 1
4874708 2319033 2319033 defendant Webbe John weaver 594266 594266 Webbe, John, of Wardon, weaver 2
4874709 2319033 2319033 defendant Carter John, junior husbandman 594266 594266 Carter, John, junior, of Wardon, husbandman 3
4874710 2319033 2319033 defendant Webbe Hugh weaver 594266 594266 Webbe, Hugh, of Wardon, weaver 4
4874711 2319033 2319033 defendant Barton John laborer 594266 594266 Barton, John, of Wardon, laborer 5
4874712 2319033 2319033 defendant Walker Hugh fuller 594266 594266 Walker, Hugh, of Wardon, fuller 6
4879284 2320455 2320455 defendant Somer Richard husbandman 594266 594266 Somer, Richard, of Wardon, husbandman 2
4889828 2323610 2323610 defendant Somer Richard husbandman 594266 594266 Somer, Richard, of Wardon, husbandman 0
4889829 2323610 2323610 defendant Halle Thomas butcher 594266 594266 together with Halle, Thomas, of Wardon, butcher 1
4894951 2325084 2325084 defendant Fille Richard   594266 594266 Fille, Richard, of Wardon, bailiff 0
4920505 2332928 2332928 defendant Westerdale Richard gent 594266 594266 Westerdale, Richard, of Wardon, gent 0
4944252 2340175 2340175 defendant Fille Richard yeoman 594266 594266 Fille, Richard, of Wardon, yeoman 0
4960683 2345153 2345153 defendant Fille Richard yeoman 594266 594266 Fille, Richard, of Wardon, yeoman 0
4977987 2350383 2350383 defendant Beton William husbandman 594266 594266 Beton, William, of Wardon, husbandman 0
4977988 2350383 2350383 defendant Ade William husbandman 594266 594266 Ade, William, of Wardon, husbandman 1
4977989 2350383 2350383 defendant Stekelyng John husbandman 594266 594266 Stekelyng, John, of Wardon, husbandman 2
4987151 2353106 2353106 defendant Fille Richard yeoman 594266 594266 Fille, Richard, of Wardon, yeoman 0
5004960 2358346 2358346 defendant Stekelyng John husbandman 594266 594266 Stekelyng, John, of Wardon, husbandman 2
5027664 2364969 2364969 plaintiff Mathewe Thomas   594266 594266 Mathewe, Thomas, of Wardon 0
5053638 2372691 2372691 defendant Fylle Robert yeoman 594266 594266 Fylle, Robert, of Wardon, yeoman 1
5053643 2372692 2372692 defendant Fylle Robert yeoman 594266 594266 Fylle, Robert, of Wardon, yeoman 1
5222381 2422255 2422255 defendant Slye John husbandman 594266 594266 Slye, John, of Wardon, husbandman 2
5222382 2422255 2422255 defendant Warner John husbandman 594266 594266 Warner, John, of Wardon, husbandman 3
5237884 2426663 2426663 defendant Sterland Thomas husbandman 594266 594266 Sterland, Thomas, of Wardon, husbandman 0
5248336 2429645 2429645 defendant Fraunceys John (legal representative) 594266 594266 Fraunceys, John, of Wardon, yeoman, executor of 0
5257292 2432405 2432405 defendant Giles John yeoman 594266 594266 Giles, John, of Wardon, yeoman 0
5326726 2453061 2453061 defendant Cheselden Robert yeoman 594266 594266 Cheselden, Robert, of Wardon, yeoman 0
5326727 2453061 2453061 defendant Cheselden Richard   594266 594266 Cheselden, Richard, of Wardon 1
5356909 2462224 2462224 defendant Adams Walter husbandman 594266 594266 Adams, Walter, of Wardon, husbandman 0
5394256 2473419 2473419 defendant Bouker William   594266 594266 Bouker, William, of Wardon, wheel wright 0
5407420 2477190 2477190 defendant Bunker William   594266 594266 Bunker, William, of Wardon, wheel wright 0
5407422 2477191 2477191 defendant Bunker William   594266 594266 Bunker, William, of Wardon, wheel wright 0
5598397 2534382 2534382 defendant Clement Thomas husbandman 594266 594266 Clement, Thomas, of Wardon, husbandman 0
5622323 2550901 2550901 defendant Middelton John   594266 594266 Middelton, John, of Wardon, parson 3
5634979 2554927 2554927 defendant Derlyng Thomas husbandman 594266 594266 Derlyng, Thomas, of Wardon, husbandman 2
5634983 2554928 2554928 defendant Derlyng Thomas husbandman 594266 594266 Derlyng, Thomas, of Wardon, husbandman 2

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