names

73 rows where place_id = 589228

✎ 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
3596954 1866677 1866677 defendant West James mercer 589228 589228 West, James, of Horncastre, mercer 9
3596955 1866677 1866677 defendant Bakster Robert baker 589228 589228 Bakster, Robert, of Horncastre, baker 10
3599247 1867408 1867408 defendant Rycherdson William miller 589228 589228 Rycherdson, William, of Horncastre, miller 0
3694374 1924444 1924444 defendant Parcely William yeoman 589228 589228 Parcely, William, of Horncastre, yeoman 0
4438083 2181210 2181210 plaintiff Amory John   589228 589228 Amory, John, of Horncastre 0
4471514 2191751 2191751 defendant Scot William   589228 589228 Scot, William, of Horncastre 0
4474465 2192673 2192673 plaintiff Donwod Simon   589228 589228 Donwod, Simon, of Horncastre 0
4477725 2193698 2193698 defendant Askeby John de butcher 589228 589228 Askeby, John de, of Horncastre, butcher 0
4488361 2197078 2197078 plaintiff Stirkelande William de   589228 589228 Stirkelande, William de, of Horncastre, parson 0
4490964 2197867 2197867 defendant Hauld Peter skinner 589228 589228 Hauld, Peter, of Horncastre, skinner 0
4497495 2199861 2199861 defendant Smyth Peter   589228 589228 Smyth, Peter, of Horncastre 1
4497496 2199861 2199861 defendant Ravon John   589228 589228 Ravon, John, of Horncastre 2
4500117 2200677 2200677 defendant Bokeland Thomas   589228 589228 Bokeland, Thomas, of Horncastre 1
4500918 2200907 2200907 defendant Askby John   589228 589228 Askby, John, of Horncastre 2
4512197 2204260 2204260 plaintiff Bonwod Simon de   589228 589228 Bonwod, Simon de, of Horncastre 0
4545469 2214505 2214505 defendant Bekdale Thomas   589228 589228 Bekdale, Thomas, of Horncastre 0
4547741 2215233 2215233 defendant Marom John   589228 589228 Marom, John, of Horncastre 1
4785060 2291342 2291342 defendant Wryght Robert   589228 589228 Wryght, Robert, of Horncastre, wright 3
4787997 2292313 2292313 defendant Grene John dyer 589228 589228 Grene, John, of Horncastre, dyer 0
4813182 2300237 2300237 defendant Hotoft John tailor 589228 589228 Hotoft, John, of Horncastre, tailor 1
4898996 2326331 2326331 defendant Hypeswell Henry draper 589228 589228 Hypeswell, Henry, of Horncastre, draper 0
4898997 2326331 2326331 defendant Forster John yeoman 589228 589228 Forster, John, of Horncastre, yeoman 1
4925077 2334274 2334274 defendant Amory Richard husbandman 589228 589228 Amory, Richard, of Horncastre, husbandman 0
4940847 2339164 2339164 defendant Fauconer John butcher 589228 589228 Fauconer, John, of Horncastre, butcher 0
4942304 2339584 2339584 defendant Jonson Thomas   589228 589228 (Jonson, Thomas, of Horncastre, bailiff 1
4942305 2339584 2339584 defendant Amery Hugh yeoman 589228 589228 Amery, Hugh, of Horncastre, yeoman 2
4954470 2343304 2343304 plaintiff Stanes William   589228 589228 Stanes, William, of Horncastre 0
4966954 2347043 2347043 defendant Sokke William miller 589228 589228 Sokke, William, of Horncastre, miller 0
4967358 2347177 2347177 defendant Amory Richard gent 589228 589228 Amory, Richard, of Horncastre, gent 0
4968211 2347444 2347444 defendant Amory Richard   589228 589228 Amory, Richard, of Horncastre, franklin 0
4980811 2351192 2351192 plaintiff Stanes William   589228 589228 Stanes, William, of Horncastre 0
4993490 2354924 2354924 defendant Stoke William husbandman 589228 589228 Stoke, William, of Horncastre, husbandman 0
5001906 2357456 2357456 defendant Crobber Thomas husbandman 589228 589228 Crobber, Thomas, of Horncastre, husbandman 0
5013952 2360935 2360935 defendant Coteler Thomas yeoman 589228 589228 Coteler, Thomas, of Horncastre, yeoman 0
5034092 2366837 2366837 plaintiff Stanes William   589228 589228 Stanes, William, of Horncastre 0
5035971 2367376 2367376 defendant Rycard John butcher 589228 589228 Rycard, John, of Horncastre, butcher 0
5056515 2373529 2373529 defendant Kele Richard ironmonger 589228 589228 Kele, Richard, of Horncastre, ironmonger 0
5056516 2373529 2373529 defendant Spycer Christopher spicer 589228 589228 Spycer, Christopher, of Horncastre, spicer 1
5059611 2374444 2374444 defendant Crobber Thomas husbandman 589228 589228 Crobber, Thomas, of Horncastre, husbandman 0
5061724 2375102 2375102 defendant Knyght John baker 589228 589228 Knyght, John, of Horncastre, baker 1
5077402 2379742 2379742 defendant Sharpe Thomas   589228 589228 Sharpe, Thomas, of Horncastre, mason 0
5083183 2381470 2381470 defendant Crobber Thomas husbandman 589228 589228 Crobber, Thomas, of Horncastre, husbandman 0
5089195 2383209 2383209 defendant Cutler Thomas chapman 589228 589228 Cutler, Thomas, of Horncastre, chapman 0
5095642 2385148 2385148 defendant Smyth Thomas smith 589228 589228 Smyth, Thomas, of Horncastre, smith 0
5095678 2385159 2385159 plaintiff Smyth John merchant 589228 589228 Smyth, John, of Horncastre, merchant 0
5095682 2385160 2385160 plaintiff Smyth John merchant 589228 589228 Smyth, John, of Horncastre, merchant 0
5103317 2387400 2387400 defendant Crobber Thomas husbandman 589228 589228 Crobber, Thomas, of Horncastre, husbandman 3
5113904 2390454 2390454 defendant Crobber Thomas husbandman 589228 589228 Crobber, Thomas, of Horncastre, husbandman 0
5230418 2424511 2424511 defendant Smyth Roger chaplain 589228 589228 Smyth, Roger, of Horncastre, chaplain 0
5247157 2429326 2429326 plaintiff Smyth John merchant 589228 589228 Smyth, John, of Horncastre, merchant 0
5248910 2429805 2429805 defendant Fauconer Robert   589228 589228 Fauconer, Robert, of Horncastre, parish clerk 0
5248911 2429805 2429805 defendant Takman Thomas shoemaker 589228 589228 Takman, Thomas, of Horncastre, shoemaker 1
5248913 2429806 2429806 defendant Fauconer Robert   589228 589228 Fauconer, Robert, of Horncastre, parish clerk 0
5248914 2429806 2429806 defendant Takman Thomas shoemaker 589228 589228 Takman, Thomas, of Horncastre, shoemaker 1
5248916 2429807 2429807 defendant Fauconer Robert   589228 589228 Fauconer, Robert, of Horncastre, parish clerk 0
5248917 2429807 2429807 defendant Takman Thomas shoemaker 589228 589228 Takman, Thomas, of Horncastre, shoemaker 1
5499680 2504847 2504847 defendant Wyllyot William butcher 589228 589228 Wyllyot, William, of Horncastre, butcher 0
5499681 2504847 2504847 defendant Baxster Robert baker 589228 589228 Baxster, Robert, of Horncastre, baker 1
5571605 2526250 2526250 defendant Palfreman Thomas husbandman 589228 589228 Palfreman, Thomas, of Horncastre, husbandman 1
5571606 2526250 2526250 defendant Whytt William husbandman 589228 589228 Whytt, William, of Horncastre, husbandman 2
5583124 2529796 2529796 plaintiff FitzWilliam Thomas   589228 589228 FitzWilliam, Thomas, of Horncastre 0
5583127 2529796 2529796 defendant Thomason William smith 589228 589228 Thomason, William, of Horncastre, smith 0
5583129 2529796 2529796 defendant Grene Thomas shoemaker 589228 589228 Grene, Thomas, of Horncastre, shoemaker 2
5583130 2529796 2529796 defendant Palfreman Thomas husbandman 589228 589228 Palfreman, Thomas, of Horncastre, husbandman 3
5586487 2530812 2530812 defendant Palfreman Thomas husbandman 589228 589228 Palfreman, Thomas, of Horncastre, husbandman 1
5588382 2531368 2531368 defendant Walker Richard saddler 589228 589228 Walker, Richard, of Horncastre, saddler 0
5591020 2532171 2532171 plaintiff Stevenson Philip merchant of the staple 589228 589228 Stevenson, Philip, of Horncastre, merchant of the staple 0
5628184 2552775 2552775 defendant Westerne John husbandman 589228 589228 Westerne, John, of Horncastre, husbandman 4
5631458 2553847 2553847 plaintiff Smyth Robert   589228 589228 Smyth, Robert, of Horncastre 0
5635618 2555099 2555099 plaintiff Western Randolph   589228 589228 Western, Randolph, of Horncastre 0
5635619 2555099 2555099 defendant Boukekonde Thomas shoemaker 589228 589228 Boukekonde, Thomas, of Horncastre, shoemaker 0
5635620 2555099 2555099 defendant Barbour Thomas barber 589228 589228 Barbour, Thomas, of Horncastre, barber 1
5635621 2555099 2555099 defendant Ravyn or Ranyn John tailor 589228 589228 Ravyn or Ranyn, John, of Horncastre, tailor 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);