names

85 rows where place_id = 591814

✎ 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
3605670 1869438 1869438 defendant Isham William gent 591814 591814 Isham, William, of Olney, gent 0
3645462 1908986 1908986 defendant Boterworth William yeoman 591814 591814 Boterworth, William, of Olney, yeoman 5
3645472 1908987 1908987 defendant Boterworth William yeoman 591814 591814 Boterworth, William, of Olney, yeoman 8
3807133 1960124 1960124 defendant Aleson Robert husbandman 591814 591814 Aleson, Robert, of Olney, husbandman 1
3807138 1960125 1960125 defendant Aleson Robert husbandman 591814 591814 Aleson, Robert, of Olney, husbandman 1
3813595 1962168 1962168 defendant Austen Robert husbandman 591814 591814 Austen, Robert, of Olney, husbandman 0
3875782 1982153 1982153 plaintiff Fyssher John (legal representative) 591814 591814 Fyssher, John, of Olney, executors of 0
3895515 1988704 1988704 defendant Smyth John tanner 591814 591814 Smyth, John, of Olney, tanner 1
3907270 1992723 1992723 defendant Knyght William butcher 591814 591814 Knyght, William, of Olney, butcher 0
3926498 1999193 1999193 defendant Arundell Thomas husbandman 591814 591814 Arundell, Thomas, of Olney, husbandman 0
3935744 2002264 2002264 plaintiff Lawe Francis gent 591814 591814 Lawe, Francis, of Olney, gent 0
4077431 2052216 2052216 defendant Peresone Thomas tanner 591814 591814 Peresone, Thomas, of Olney, tanner 0
4112849 2064862 2064862 defendant Osborne Thomas husbandman 591814 591814 Osborne, Thomas, of Olney, husbandman 0
4283695 2124207 2124207 defendant Stevenson Edward husbandman 591814 591814 Stevenson, Edward, of Olney, husbandman 0
4303664 2131407 2131407 defendant Stevenson Edward husbandman 591814 591814 Stevenson, Edward, of Olney, husbandman 0
4303665 2131407 2131407 defendant Stevenson Francis husbandman 591814 591814 Stevenson, Francis, of Olney, husbandman 1
4308163 2133002 2133002 defendant Pyers William gent 591814 591814 Pyers, William, of Olney, gent 0
4335508 2142151 2142151 defendant Taverner Thomas gent 591814 591814 Taverner, Thomas, of Olney, gent 0
4349630 2147133 2147133 defendant Stevensone Francis yeoman 591814 591814 Stevensone, Francis, of Olney, yeoman 0
4354987 2148958 2148958 defendant Rose Henry yeoman 591814 591814 Rose, Henry, of Olney, yeoman 0
4358784 2150305 2150305 defendant Taverner Thomas gent 591814 591814 Taverner, Thomas, of Olney, gent 0
4382992 2159025 2159025 defendant Trippe Henry yeoman 591814 591814 Trippe, Henry, of Olney, yeoman 0
4382995 2159026 2159026 defendant Trippe Henry yeoman 591814 591814 Trippe, Henry, of Olney, yeoman 1
4397489 2163739 2163739 defendant Wudmancy Francis tailor 591814 591814 Wudmancy, Francis, of Olney, tailor 0
4397490 2163739 2163739 defendant Kenby Abunelack tailor 591814 591814 Kenby, Abunelack, of Olney, tailor 1
4397491 2163739 2163739 defendant Knyght John yeoman 591814 591814 Knyght, John, of Olney, yeoman 2
4443018 2182779 2182779 defendant fitz Richard John, senior   591814 591814 fitz Richard, John, senior, of Olney 0
4482142 2195124 2195124 plaintiff Masoun John   591814 591814 Masoun, John, of Olney 0
4490336 2197678 2197678 defendant Horewode John   591814 591814 Horewode, John, of Olney 1
4509910 2203585 2203585 plaintiff Baker Ellis   591814 591814 Baker, Ellis, of Olney 0
4520541 2206774 2206774 defendant Milner Roger   591814 591814 Milner, Roger, of Olney 0
4528821 2209297 2209297 plaintiff Melner Roger   591814 591814 Melner, Roger, of Olney 0
4546380 2214804 2214804 defendant Marchall John   591814 591814 Marchall, John, of Olney 0
4561917 2219660 2219660 defendant Bailly Adam   591814 591814 Bailly, Adam, of Olney 0
4582919 2226084 2226084 defendant Milward Roger   591814 591814 Milward, Roger, of Olney 0
4582920 2226084 2226084 defendant Aleyne Richard   591814 591814 Aleyne, Richard, of Olney 1
4620055 2237255 2237255 defendant Wade John   591814 591814 Wade, John, of Olney 3
4642015 2243771 2243771 plaintiff Graunt John (legal representative) 591814 591814 Graunt, John, of Olney, parson, executor of 0
4667957 2255682 2255682 plaintiff Baker William   591814 591814 Baker, William, of Olney 0
4763648 2284617 2284617 defendant James John gent 591814 591814 James, John, of Olney, gent 0
4793478 2294069 2294069 defendant Fowene Simon husbandman 591814 591814 Fowene, Simon, of Olney, husbandman 1
4795523 2294752 2294752 defendant Cropedy William barker 591814 591814 Cropedy, William, of Olney, barker 0
4795524 2294752 2294752 defendant Spycer Thomas spicer 591814 591814 Spycer, Thomas, of Olney, spicer 1
4795525 2294752 2294752 defendant Catteworth Henry cordwainer 591814 591814 Catteworth, Henry, of Olney, cordwainer 2
4818551 2301882 2301882 defendant Rowyn Simon fisher 591814 591814 Rowyn, Simon, of Olney, fisher 0
4829771 2305358 2305358 plaintiff Baysham John   591814 591814 Baysham, John, of Olney, parson 0
4832744 2306264 2306264 defendant Herberd Thomas pulter 591814 591814 Herberd, Thomas, of Olney, pulter 0
4838129 2307848 2307848 defendant Rande John husbandman 591814 591814 Rande, John, of Olney, husbandman 0
4838130 2307848 2307848 defendant Wymyxt Thomas turner 591814 591814 Wymyxt, Thomas, of Olney, turner 1
4915539 2331358 2331358 defendant Taillour William husbandman 591814 591814 Taillour, William, of Olney, husbandman 1
4945241 2340487 2340487 defendant Harwold Thomas barber 591814 591814 Harwold, Thomas, of Olney, barber 0
5044364 2369947 2369947 defendant Warwyk William husbandman 591814 591814 Warwyk, William, of Olney, husbandman 0
5066394 2376476 2376476 defendant Mayewe Thomas yeoman 591814 591814 Mayewe, Thomas, of Olney, yeoman 1
5066397 2376477 2376477 defendant Mayewe Thomas yeoman 591814 591814 Mayewe, Thomas, of Olney, yeoman 1
5090978 2383757 2383757 defendant Heywode Agnes widow 591814 591814 Heywode, Agnes, of Olney, widow 1
5118079 2391721 2391721 plaintiff Rasure Thomas chapman 591814 591814 Rasure, Thomas, of Olney, chapman 0
5215268 2420195 2420195 defendant Curteys William husbandman 591814 591814 Curteys, William, of Olney, husbandman 0
5215269 2420195 2420195 defendant Hervy William yeoman 591814 591814 Hervy, William, of Olney, yeoman 1
5231735 2424852 2424852 plaintiff Bosno Robert   591814 591814 Bosno, Robert, of Olney 0
5234160 2425583 2425583 defendant Spycer John chapman 591814 591814 Spycer, John, of Olney, chapman 0
5269175 2436087 2436087 defendant Dally John   591814 591814 Dally, John, of Olney, notary public 0
5271537 2436769 2436769 defendant Curteys John yeoman 591814 591814 Curteys, John, of Olney, yeoman 1
5277104 2438392 2438392 defendant Dalley John   591814 591814 Dalley, John, of Olney, notary 0
5286079 2440936 2440936 defendant Curteys William yeoman 591814 591814 Curteys, William, of Olney, yeoman 1
5299332 2444778 2444778 defendant Whyrlot William yeoman 591814 591814 Whyrlot, William, of Olney, yeoman 0
5318531 2450640 2450640 defendant Danley John   591814 591814 Danley, John, of Olney, notary 0
5362107 2463812 2463812 defendant Deryke John tailor 591814 591814 Deryke, John, of Olney, tailor 0
5389229 2471965 2471965 defendant Joneson Thomas laborer 591814 591814 Joneson, Thomas, of Olney, laborer 1
5389230 2471965 2471965 defendant Brewester William yeoman 591814 591814 Brewester, William, of Olney, yeoman 2
5397061 2474243 2474243 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5410286 2478029 2478029 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5424112 2482173 2482173 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5424114 2482174 2482174 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5438254 2486375 2486375 defendant Ryseby Roger skinner 591814 591814 Ryseby, Roger, of Olney, skinner 1
5455799 2491636 2491636 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5455807 2491640 2491640 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5467669 2495261 2495261 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5478981 2498733 2498733 defendant Watford Henry yeoman 591814 591814 Watford, Henry, of Olney, yeoman 0
5512504 2508771 2508771 defendant Blot or Bloc John baker 591814 591814 Blot or Bloc, John, of Olney, baker 0
5550079 2520060 2520060 defendant Smyth John yeoman 591814 591814 Smyth, John, of Olney, yeoman 0
5550080 2520060 2520060 defendant Baker John yeoman 591814 591814 Baker, John, of Olney, yeoman 1
5602582 2535703 2535703 defendant Payn John yeoman 591814 591814 Payn, John, of Olney, yeoman 0
5602583 2535703 2535703 defendant Lawnder John husbandman 591814 591814 Lawnder, John, of Olney, husbandman 1
5602584 2535703 2535703 defendant Baker John husbandman 591814 591814 Baker, John, of Olney, husbandman 2
5623806 2551386 2551386 defendant Fawen Simon miller 591814 591814 Fawen, Simon, of Olney, miller 1

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