names

88 rows where place_id = 592068

✎ 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
3606458 1869689 1869689 defendant Skryven Robert innholder 592068 592068 Skryven, Robert, of Lostwythiell, innholder 0
3854693 1975114 1975114 defendant Johnsebell Richard tinner 592068 592068 Johnsebell, Richard, of Lostwythiell, tinner 1
3854694 1975114 1975114 defendant Johnsebell Philip tinner 592068 592068 Johnsebell, Philip, of Lostwythiell, tinner 2
4479487 2194241 2194241 defendant Umfray Roger   592068 592068 Umfray, Roger, of Lostwythiell 0
4521001 2206902 2206902 defendant Steynour William   592068 592068 Steynour, William, of Lostwythiell 5
4528031 2209048 2209048 plaintiff Mabbe Alexancer   592068 592068 Mabbe, Alexancer, of Lostwythiell 0
4529681 2209564 2209564 defendant Mounde John   592068 592068 Mounde, John, of Lostwythiell 0
4535634 2211421 2211421 defendant Welley William   592068 592068 Welley, William, of Lostwythiell 5
4535635 2211421 2211421 defendant Perot John   592068 592068 Perot, John, of Lostwythiell 6
4543762 2213942 2213942 plaintiff Awemarle John   592068 592068 Awemarle, John, of Lostwythiell 0
4580096 2225264 2225264 defendant Blaunchard William   592068 592068 Blaunchard, William, of Lostwythiell 0
4618806 2236879 2236879 plaintiff Hegowe Henry   592068 592068 Hegowe, Henry, of Lostwythiell 0
4618807 2236879 2236879 defendant Jankyn Thomas   592068 592068 Jankyn, Thomas, of Lostwythiell 0
4627279 2239479 2239479 defendant Bounty William   592068 592068 Bounty, William, of Lostwythiell 0
4627285 2239480 2239480 defendant Bounty William   592068 592068 Bounty, William, of Lostwythiell 0
4660266 2249043 2249043 defendant Lanedwen John parker 592068 592068 Lanedwen, John, of Lostwythiell, parker 0
4662008 2249595 2249595 defendant Vyvyan John yeoman 592068 592068 Vyvyan, John, of Lostwythiell, yeoman 6
4669237 2256084 2256084 plaintiff Body Peter   592068 592068 Body, Peter, of Lostwythiell 0
4682473 2260142 2260142 defendant Pery John smith 592068 592068 with Pery, John, of Lostwythiell, smith 1
4689016 2262123 2262123 defendant Hervy Richard   592068 592068 Hervy, Richard, of Lostwythiell, tin bailiff 0
4729382 2274406 2274406 defendant Hope Edmund gent 592068 592068 together with Hope, Edmund, of Lostwythiell, gent 2
4737041 2276715 2276715 defendant Galy Thomas husbandman 592068 592068 Galy, Thomas, of Lostwythiell, husbandman 0
4737135 2276732 2276732 defendant Trebarth John yeoman 592068 592068 Trebarth, John, of Lostwythiell, yeoman 0
4789444 2292764 2292764 defendant Lante John shipman 592068 592068 Lante, John, of Lostwythiell, shipman 4
4793688 2294139 2294139 defendant Rowe William merchant 592068 592068 (Rowe, William, of Lostwythiell, merchant 1
4793689 2294139 2294139 defendant Wollegh Roger yeoman 592068 592068 Wollegh, Roger, of Lostwythiell, yeoman 2
4799989 2296179 2296179 defendant Hygdon John yeoman 592068 592068 Hygdon, John, of Lostwythiell, yeoman 0
4808446 2298815 2298815 defendant Bailly John dyer 592068 592068 Bailly, John, of Lostwythiell, dyer 1
4822571 2303135 2303135 defendant Fynell John chaplain 592068 592068 Fynell, John, of Lostwythiell, chaplain 1
4831939 2306018 2306018 defendant Bonook Richard yeoman 592068 592068 Bonook, Richard, of Lostwythiell, yeoman 0
4831940 2306018 2306018 defendant Peyntour Roger yeoman 592068 592068 Peyntour, Roger, of Lostwythiell, yeoman 1
4881908 2321240 2321240 plaintiff Bonok Richard   592068 592068 Bonok, Richard, of Lostwythiell 1
4944287 2340189 2340189 defendant Hicke John husbandman 592068 592068 Hicke, John, of Lostwythiell, husbandman 0
4944289 2340189 2340189 defendant Hicke Stephen singleman 592068 592068 together with Hicke, Stephen, of Lostwythiell, singleman 2
4944293 2340190 2340190 defendant Hicke Stephen singleman 592068 592068 Hicke, Stephen, of Lostwythiell, singleman 0
4959200 2344720 2344720 plaintiff Amys Nicholas (legal representative) 592068 592068 Amys, Nicholas, of Lostwythiell, draper, executors of 0
4959207 2344720 2344720 defendant Giulle Thomas butcher 592068 592068 Giulle, Thomas, of Lostwythiell, butcher 4
4979890 2350941 2350941 defendant Costard Philip tailor 592068 592068 Costard, Philip, of Lostwythiell, tailor 0
4980387 2351077 2351077 plaintiff Sporyer Thomas   592068 592068 Sporyer, Thomas, of Lostwythiell 0
4983158 2351863 2351863 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 0
4985864 2352689 2352689 defendant Botreaux Vincent yeoman 592068 592068 Botreaux, Vincent, of Lostwythiell, yeoman 0
5010948 2360059 2360059 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 0
5213302 2419622 2419622 defendant Amys alias Nicolas Thomas tailor 592068 592068 Amys alias Nicolas, Thomas, of Lostwythiell, tailor 3
5240600 2427463 2427463 defendant Smyth Robert yeoman 592068 592068 Smyth, Robert, of Lostwythiell, yeoman 0
5240601 2427463 2427463 defendant Tregenawen William glover 592068 592068 Tregenawen, William, of Lostwythiell, glover 1
5240602 2427463 2427463 defendant Tomma Henry saddler 592068 592068 Tomma, Henry, of Lostwythiell, saddler 2
5240603 2427463 2427463 defendant Hawke John weaver 592068 592068 Hawke, John, of Lostwythiell, weaver 3
5240605 2427464 2427464 defendant Smyth Robert yeoman 592068 592068 Smyth, Robert, of Lostwythiell, yeoman 0
5240606 2427464 2427464 defendant Tregenawen William glover 592068 592068 Tregenawen, William, of Lostwythiell, glover 1
5240607 2427464 2427464 defendant Tomma Henry saddler 592068 592068 Tomma, Henry, of Lostwythiell, saddler 2
5240608 2427464 2427464 defendant Hawke John weaver 592068 592068 Hawke, John, of Lostwythiell, weaver 3
5293754 2443135 2443135 defendant Harry Thomas yeoman 592068 592068 Harry, Thomas, of Lostwythiell, yeoman 1
5309569 2447899 2447899 defendant Dey Lewis yeoman 592068 592068 Dey, Lewis, of Lostwythiell, yeoman 0
5309570 2447899 2447899 defendant Dey John yeoman 592068 592068 Dey, John, of Lostwythiell, yeoman 1
5318360 2450586 2450586 defendant Dey Lewis yeoman 592068 592068 Dey, Lewis, of Lostwythiell, yeoman 0
5318361 2450586 2450586 defendant Dey John   592068 592068 Dey, John, of Lostwythiell, groom 1
5318367 2450588 2450588 defendant Dey Lewis yeoman 592068 592068 Dey, Lewis, of Lostwythiell, yeoman 0
5318373 2450590 2450590 defendant Dey Lewis yeoman 592068 592068 Dey, Lewis, of Lostwythiell, yeoman 0
5332914 2454909 2454909 defendant Ude Tristram mariner 592068 592068 Ude, Tristram, of Lostwythiell, mariner 1
5368648 2465789 2465789 defendant Pontesyde Thomas chaplain 592068 592068 Pontesyde, Thomas, of Lostwythiell, chaplain 0
5368651 2465790 2465790 defendant Pontesyde Thomas chaplain 592068 592068 Pontesyde, Thomas, of Lostwythiell, chaplain 0
5391392 2472616 2472616 defendant Berde William pewterer 592068 592068 Berde, William, of Lostwythiell, pewterer 0
5398656 2474680 2474680 defendant Garreway Geoffgrey yeoman 592068 592068 Garreway, Geoffgrey, of Lostwythiell, yeoman 5
5417518 2480160 2480160 defendant Martyn William tanner 592068 592068 Martyn, William, of Lostwythiell, tanner 1
5417642 2480198 2480198 defendant Taylour Odenus tailor 592068 592068 Taylour, Odenus, of Lostwythiell, tailor 0
5426225 2482799 2482799 defendant Garrewey Geoffrey yeoman 592068 592068 Garrewey, Geoffrey, of Lostwythiell, yeoman 5
5426231 2482800 2482800 defendant Garrewey Geoffrey yeoman 592068 592068 Garrewey, Geoffrey, of Lostwythiell, yeoman 4
5426238 2482801 2482801 defendant Gerrowey Geoffrey yeoman 592068 592068 Gerrowey, Geoffrey, of Lostwythiell, yeoman 5
5431603 2484407 2484407 defendant Canell Ralph yeoman 592068 592068 Canell, Ralph, of Lostwythiell, yeoman 0
5434911 2485374 2485374 defendant Berde William pewterer 592068 592068 Berde, William, of Lostwythiell, pewterer 0
5447850 2489239 2489239 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 1
5457149 2492035 2492035 defendant Garreway Geoffrey yeoman 592068 592068 Garreway, Geoffrey, of Lostwythiell, yeoman 5
5460250 2493000 2493000 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 1
5460359 2493037 2493037 defendant Canell Ralph yeoman 592068 592068 Canell, Ralph, of Lostwythiell, yeoman 0
5463214 2493912 2493912 defendant Canell or Cavell Ralph yeoman 592068 592068 Canell or Cavell, Ralph, of Lostwythiell, yeoman 0
5471892 2496545 2496545 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 1
5471895 2496546 2496546 defendant Kendale Stephen gent 592068 592068 Kendale, Stephen, of Lostwythiell, gent 1
5483392 2499980 2499980 defendant Canell or Cavell Ralph yeoman 592068 592068 Canell or Cavell, Ralph, of Lostwythiell, yeoman 0
5483397 2499981 2499981 defendant Helyer John, senior yeoman 592068 592068 Helyer, John, senior, of Lostwythiell, yeoman 3
5487630 2501192 2501192 defendant Sherman Thomas husbandman 592068 592068 Sherman, Thomas, of Lostwythiell, husbandman 0
5487631 2501192 2501192 defendant homas Ralph husbandman 592068 592068 homas, Ralph, of Lostwythiell, husbandman 1
5487632 2501192 2501192 defendant Harry Walter husbandman 592068 592068 Harry, Walter, of Lostwythiell, husbandman 2
5487633 2501192 2501192 defendant Harry Stephen husbandman 592068 592068 Harry, Stephen, of Lostwythiell, husbandman 3
5487755 2501225 2501225 defendant Peryn Stephen baker 592068 592068 Peryn, Stephen, of Lostwythiell, baker 2
5488289 2501397 2501397 defendant Thomas Ralph merchant 592068 592068 Thomas, Ralph, of Lostwythiell, merchant 1
5533863 2515136 2515136 defendant Bryn Stephen smith 592068 592068 (Bryn, Stephen, of Lostwythiell, smith 1
5533864 2515136 2515136 defendant Peauterer Walter pewterer 592068 592068 Peauterer, Walter, of Lostwythiell, pewterer 2
5609043 2537733 2537733 defendant Olyver William merchant 592068 592068 Olyver, William, of Lostwythiell, merchant 0

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