names

90 rows where place_id = 655131

✎ 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
3935063 2002034 2002034 defendant Nutman Robert yoeman 655131 655131 Nutman, Robert, of Canston, yoeman 1
4431957 2174774 2174774 defendant Pertryk William warrener 655131 655131 Pertryk, William, of Canston, warrener 0
4431959 2174774 2174774 defendant Northgate Adam de   655131 655131 Northgate, Adam de, of Canston 2
4431960 2174774 2174774 defendant Lotes Robert   655131 655131 Lotes, Robert, of Canston 3
4431962 2174774 2174774 defendant Fox William   655131 655131 Fox, William, of Canston 5
4436052 2176010 2176010 defendant Sherehirde Simon le   655131 655131 Sherehirde, Simon le, of Canston 0
4437547 2176499 2176499 defendant Pertryke William warrener 655131 655131 Pertryke, William, of Canston, warrener 0
4437549 2176499 2176499 defendant Northgate Adam de   655131 655131 Northgate, Adam de, of Canston 2
4437550 2176499 2176499 defendant Lotes Robert   655131 655131 Lotes, Robert, of Canston 3
4536131 2211577 2211577 defendant Hert William   655131 655131 Hert, William, of Canston 1
4636850 2242342 2242342 defendant Skynnere Simon   655131 655131 Skynnere, Simon, of Canston 1
4684307 2260694 2260694 plaintiff Preston John   655131 655131 Preston, John, of Canston, on his own account 0
4684309 2260695 2260695 plaintiff Preston John   655131 655131 Preston, John, of Canston, on his own account 0
4713466 2269534 2269534 defendant Nicoll John yeoman 655131 655131 Nicoll, John, of Canston, yeoman 3
4741245 2277938 2277938 defendant Gloos Robert yeoman 655131 655131 Gloos, Robert, of Canston, yeoman 2
4747649 2279819 2279819 defendant Gloos Robert yeoman 655131 655131 Gloos, Robert, of Canston, yeoman 0
4752082 2281091 2281091 defendant Cogill Ralph yeoman 655131 655131 Cogill, Ralph, of Canston, yeoman 6
4756948 2282541 2282541 defendant Wattys John butcher 655131 655131 Wattys, John, of Canston, butcher 1
4756949 2282541 2282541 defendant Skynnere Simon skinner 655131 655131 Skynnere, Simon, of Canston, skinner 2
4772429 2287344 2287344 defendant Doobbys Joan spinster 655131 655131 Doobbys, Joan, of Canston, spinster 2
4772430 2287344 2287344 defendant Strem Emma widow 655131 655131 Strem, Emma, of Canston, widow 3
4813419 2300310 2300310 defendant Grym Thomas yeoman 655131 655131 Grym, Thomas, of Canston, yeoman 2
4820280 2302410 2302410 defendant Grym Thomas husbandman 655131 655131 Grym, Thomas, of Canston, husbandman 0
4820281 2302410 2302410 defendant Wyol William thatcher 655131 655131 Wyol, William, of Canston, thatcher 1
4827123 2304528 2304528 defendant Skynner Simon skinner 655131 655131 Skynner, Simon, of Canston, skinner 2
4827124 2304528 2304528 defendant Wellys Simon yeoman 655131 655131 Wellys, Simon, of Canston, yeoman 3
4924538 2334112 2334112 defendant Wyghton William pedder 655131 655131 Wyghton, William, of Canston, pedder 6
4930005 2335793 2335793 defendant Halle John husbandman 655131 655131 Halle, John, of Canston, husbandman 0
5047203 2370783 2370783 defendant Canon William chapman 655131 655131 Canon, William, of Canston, chapman 2
5048263 2371115 2371115 defendant Scarlet Thomas laborer 655131 655131 Scarlet, Thomas, of Canston, laborer 3
5048266 2371116 2371116 defendant Bayfeld Peter yeoman 655131 655131 (Bayfeld, Peter, of Canston, yeoman 1
5048267 2371116 2371116 defendant Alice formerly wife of Clement tuly, widow 655131 655131 Alice, formerly wife of Clement tuly, of Canston, widow 2
5049620 2371511 2371511 defendant Pycard Richard husbandman 655131 655131 Pycard, Richard, of Canston, husbandman 1
5188815 2412459 2412459 defendant Mustarder Robert husbandman 655131 655131 Mustarder, Robert, of Canston, husbandman 0
5197473 2415002 2415002 defendant Wyfeld Peter husbandman 655131 655131 Wyfeld, Peter, of Canston, husbandman 1
5280471 2439362 2439362 defendant Mego Edmund smith 655131 655131 Mego, Edmund, of Canston, smith 0
5302083 2445580 2445580 defendant Mego Edmund yeoman 655131 655131 Mego, Edmund, of Canston, yeoman 0
5366526 2465185 2465185 defendant Rede William husbandman 655131 655131 Rede, William, of Canston, husbandman 2
5366528 2465185 2465185 defendant Skynner Robert husbandman 655131 655131 Skynner, Robert, of Canston, husbandman 4
5383030 2470215 2470215 defendant Thorp Robert laborer 655131 655131 Thorp, Robert, of Canston, laborer 5
5400935 2475329 2475329 plaintiff Grene William   655131 655131 Grene, William, of Canston 0
5400936 2475329 2475329 defendant Boure Thomas, senior bleacher of cloth 655131 655131 Boure, Thomas, senior, of Canston, bleacher of cloth 0
5422844 2481786 2481786 defendant Shyringham John husbandman 655131 655131 Shyringham, John, of Canston, husbandman 1
5424420 2482270 2482270 defendant Gelyons William, sen husbandman & butcher 655131 655131 Gelyons, William, sen, of Canston, husbandman & butcher 0
5424429 2482274 2482274 defendant Gelyons William, sen husbandman & butcher 655131 655131 Gelyons, William, sen, of Canston, husbandman & butcher 0
5424432 2482275 2482275 defendant Gelyons William, sen husbandman 655131 655131 Gelyons, William, sen, of Canston, husbandman 0
5424817 2482378 2482378 defendant Broun Richard butcher 655131 655131 Broun, Richard, of Canston, butcher 1
5424946 2482427 2482427 defendant Smyth Richard chaplain 655131 655131 Smyth, Richard, of Canston, chaplain 1
5426757 2482947 2482947 defendant Machon Robert husbandman 655131 655131 Machon, Robert, of Canston, husbandman 1
5429430 2483737 2483737 plaintiff Grene William   655131 655131 Grene, William, of Canston 0
5429431 2483737 2483737 defendant Boure Thomas bleacher of cloth 655131 655131 Boure, Thomas, of Canston, bleacher of cloth 0
5433022 2484841 2484841 defendant Woderove Robert husbandman 655131 655131 Woderove, Robert, of Canston, husbandman 0
5433023 2484841 2484841 defendant Woderove William laborer 655131 655131 Woderove, William, of Canston, laborer 1
5440612 2487099 2487099 defendant Woderove William laborer 655131 655131 Woderove, William, of Canston, laborer 1
5440613 2487099 2487099 defendant Baldon William husbandman 655131 655131 Baldon, William, of Canston, husbandman 2
5443723 2488045 2488045 defendant Hervy John (legal representative) 655131 655131 Hervy, John, of Canston, shoemaker, executor of 3
5444774 2488333 2488333 defendant Mathon Robert husbandman 655131 655131 Mathon, Robert, of Canston, husbandman 1
5450065 2489909 2489909 defendant Woderove William husbandman 655131 655131 Woderove, William, of Canston, husbandman 1
5450728 2490104 2490104 defendant Mego Edmund   655131 655131 Mego, Edmund, of Canston 0
5450730 2490104 2490104 defendant Dobbys John barber 655131 655131 Dobbys, John, of Canston, barber 2
5450731 2490104 2490104 defendant (illegible) Richard, senior husbandman 655131 655131 _, Richard, senior, of Canston, husbandman 3
5453763 2491017 2491017 defendant Banburgh Henry   655131 655131 Banburgh, Henry, of Canston, tallow chandler 7
5453922 2491062 2491062 defendant Woderove William laborer 655131 655131 Woderove, William, of Canston, laborer 1
5454000 2491087 2491087 defendant Brigge John, sen yeoman 655131 655131 Brigge, John, sen, of Canston, yeoman 1
5455654 2491595 2491595 defendant Musterder Thomas husbandman 655131 655131 Musterder, Thomas, of Canston, husbandman 0
5455656 2491595 2491595 defendant Rychardys Thomas husbandman 655131 655131 Rychardys, Thomas, of Canston, husbandman 2
5455964 2491694 2491694 defendant Purry William husbandman 655131 655131 Purry, William, of Canston, husbandman 0
5456535 2491881 2491881 defendant Hervy John (legal representative) 655131 655131 Hervy, John, of Canston, shoemaker, executor of 3
5462237 2493608 2493608 defendant Woderove William husbandman 655131 655131 Woderove, William, of Canston, husbandman 0
5462865 2493805 2493805 defendant Mege Edmund smith 655131 655131 Mege, Edmund, of Canston, smith 0
5462867 2493805 2493805 defendant Dobbys John laborer 655131 655131 Dobbys, John, of Canston, laborer 2
5462868 2493805 2493805 defendant Houchons Richard, sen husbandman 655131 655131 Houchons, Richard, sen, of Canston, husbandman 3
5462870 2493806 2493806 defendant Mego Edmund smith 655131 655131 Mego, Edmund, of Canston, smith 0
5462872 2493806 2493806 defendant Dobbys John laborer 655131 655131 Dobbys, John, of Canston, laborer 2
5462873 2493806 2493806 defendant Houchons Richard, sen husbandman 655131 655131 Houchons, Richard, sen, of Canston, husbandman 3
5463656 2494046 2494046 defendant Shirlok Henry   655131 655131 Shirlok, Henry, of Canston, worsted weaver 2
5465821 2494694 2494694 defendant Woderove William laborer 655131 655131 Woderove, William, of Canston, laborer 1
5465822 2494694 2494694 defendant Balden William husbandman 655131 655131 Balden, William, of Canston, husbandman 2
5467814 2495312 2495312 defendant Purry William husbandman 655131 655131 Purry, William, of Canston, husbandman 0
5468315 2495464 2495464 defendant Hervy John (legal representative) 655131 655131 Hervy, John, of Canston, shoemaker, executor of 2
5472312 2496687 2496687 defendant Skynner John husbandman 655131 655131 Skynner, John, of Canston, husbandman 3
5472318 2496688 2496688 defendant Skynner John husbandman 655131 655131 Skynner, John, of Canston, husbandman 3
5472324 2496689 2496689 defendant Skynner John husbandman 655131 655131 Skynner, John, of Canston, husbandman 3
5474394 2497323 2497323 defendant Mego Edmund smith 655131 655131 Mego, Edmund, of Canston, smith 0
5474396 2497323 2497323 defendant Dobbys John latorer 655131 655131 Dobbys, John, of Canston, latorer 2
5474397 2497323 2497323 defendant Houchons Richard, sen husbandman 655131 655131 Houchons, Richard, sen, of Canston, husbandman 3
5475234 2497580 2497580 defendant Shirlok Henry   655131 655131 Shirlok, Henry, of Canston, worsted weaver 2
5477295 2498220 2498220 defendant Woderove William laborer 655131 655131 Woderove, William, of Canston, laborer 1
5477296 2498220 2498220 defendant Balden William husbandman 655131 655131 Balden, William, of Canston, husbandman 2
5608927 2537693 2537693 plaintiff Harre Thomas   655131 655131 Harre, Thomas, of Canston 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);