names

68 rows where place_id = 585915

✎ 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
3587486 1863733 1863733 defendant Bullok Ralph husbandman 585915 585915 Bullok, Ralph, of Shypdam, husbandman 0
3587487 1863733 1863733 defendant Lomberd John husbandman 585915 585915 Lomberd, John, of Shypdam, husbandman 1
3587488 1863733 1863733 defendant Deynys Thomas husbandman 585915 585915 Deynys, Thomas, of Shypdam, husbandman 2
3587489 1863733 1863733 defendant Vyncent William husbandman 585915 585915 Vyncent, William, of Shypdam, husbandman 3
3588050 1863914 1863914 defendant Secker John carpenter 585915 585915 Secker, John, of Shypdam, carpenter 3
3595686 1866278 1866278 defendant Newent John weaver 585915 585915 Newent, John, of Shypdam, weaver 0
3595687 1866278 1866278 defendant Meyke Henry husbandman 585915 585915 Meyke, Henry, of Shypdam, husbandman 1
3597464 1866826 1866826 defendant Platfote Ralph yeoman 585915 585915 Platfote, Ralph, of Shypdam, yeoman 0
3649378 1910194 1910194 defendant Elyngham Stephen husbandman 585915 585915 Elyngham, Stephen, of Shypdam, husbandman 1
3753546 1943047 1943047 defendant Gynne John butcher 585915 585915 Gynne, John, of Shypdam, butcher 1
3810233 1961094 1961094 defendant Gynne John butcher 585915 585915 Gynne, John, of Shypdam, butcher 3
3810234 1961094 1961094 defendant Mark John husbandman 585915 585915 Mark, John, of Shypdam, husbandman 4
3819947 1964120 1964120 defendant Harward Thomas husbandman 585915 585915 Harward, Thomas, of Shypdam, husbandman 0
3832025 1967914 1967914 defendant Yemys Simon husbandman 585915 585915 Yemys, Simon, of Shypdam, husbandman 0
3839778 1970369 1970369 defendant Burgh William   585915 585915 Burgh, William, of Shypdam, wax chandler 1
3859882 1976811 1976811 defendant Beles John, junior laborer 585915 585915 Beles, John, junior, of Shypdam, laborer 0
3860520 1977010 1977010 defendant Belys John tanner 585915 585915 Belys, John, of Shypdam, tanner 3
3861619 1977346 1977346 defendant Danny William, senior husbandman 585915 585915 Danny, William, senior, of Shypdam, husbandman 1
3861620 1977346 1977346 defendant Danny William, junior husbandman 585915 585915 Danny, William, junior, of Shypdam, husbandman 2
3861621 1977346 1977346 defendant Daunt John husbandman 585915 585915 Daunt, John, of Shypdam, husbandman 3
3861622 1977346 1977346 defendant Warne John husbandman 585915 585915 Warne, John, of Shypdam, husbandman 4
3865215 1978571 1978571 defendant Bennys Reginald tailor 585915 585915 Bennys, Reginald, of Shypdam, tailor 0
3879247 1983310 1983310 defendant Howlyng William tanner 585915 585915 Howlyng, William, of Shypdam, tanner 1
3886069 1985592 1985592 defendant Platfote William husbandman 585915 585915 Platfote, William, of Shypdam, husbandman 2
3895212 1988606 1988606 defendant Gynne John husbandman 585915 585915 Gynne, John, of Shypdam, husbandman 2
3895216 1988607 1988607 defendant Gynne John husbandman 585915 585915 Gynne, John, of Shypdam, husbandman 2
3896644 1989089 1989089 defendant Rows William husbandman 585915 585915 Rows, William, of Shypdam, husbandman 2
3896645 1989089 1989089 defendant Bullok Thomas husbandman 585915 585915 Bullok, Thomas, of Shypdam, husbandman 3
3900571 1990421 1990421 defendant Gunne Roger husbandman 585915 585915 Gunne, Roger, of Shypdam, husbandman 3
3904168 1991638 1991638 defendant Jyn John butcher 585915 585915 Jyn, John, of Shypdam, butcher 1
3952450 2007926 2007926 defendant Busgate Thomas butcher 585915 585915 Busgate, Thomas, of Shypdam, butcher 0
3961434 2011093 2011093 defendant Tuddenham John, junior butcher 585915 585915 Tuddenham, John, junior, of Shypdam, butcher 0
3974884 2015780 2015780 plaintiff Hogan Anthoy yeoman 585915 585915 Hogan, Anthoy, of Shypdam, yeoman 0
3984248 2019132 2019132 defendant Tybnam Thomas butcher 585915 585915 Tybnam, Thomas, of Shypdam, butcher 4
3985315 2019505 2019505 defendant Toddenham John husbandman 585915 585915 Toddenham, John, of Shypdam, husbandman 0
3985316 2019505 2019505 defendant Rowse Christopher cordwainer 585915 585915 Rowse, Christopher, of Shypdam, cordwainer 1
4049433 2042242 2042242 defendant Tudnam Thomas butcher 585915 585915 Tudnam, Thomas, of Shypdam, butcher 0
4060508 2046161 2046161 defendant Walsyngham Thomas   585915 585915 Walsyngham, Thomas, of Shypdam, hoop hewer 1
4071128 2049979 2049979 plaintiff Mordewe Thomas   585915 585915 Mordewe, Thomas, of Shypdam 0
4071130 2049979 2049979 defendant Hydeman John miller 585915 585915 Hydeman, John, of Shypdam, miller 1
4071131 2049979 2049979 defendant Barn Simon blacksmith 585915 585915 Barn, Simon, of Shypdam, blacksmith 2
4075414 2051509 2051509 defendant Bag Stephen tanner 585915 585915 Bag, Stephen, of Shypdam, tanner 0
4076638 2051942 2051942 defendant Tuddenham John husbandman 585915 585915 Tuddenham, John, of Shypdam, husbandman 1
4076650 2051942 2051942 defendant Whyte Edward gent 585915 585915 Whyte, Edward, of Shypdam, gent 13
4085526 2055098 2055098 defendant Barnes Simon blacksmith 585915 585915 Barnes, Simon, of Shypdam, blacksmith 2
4092098 2057469 2057469 defendant Tomson William miller 585915 585915 Tomson, William, of Shypdam, miller 2
4145659 2076633 2076633 defendant Pettytt Robert tailor 585915 585915 Pettytt, Robert, of Shypdam, tailor 3
4184264 2089995 2089995 defendant Walsyngham Thomas cooper 585915 585915 Walsyngham, Thomas, of Shypdam, cooper 1
4189130 2091689 2091689 defendant Robynson Sampson   585915 585915 Robynson, Sampson, of Shypdam, plough wheel maker 2
4329689 2140225 2140225 defendant Grene John   585915 585915 Grene, John, of Shypdam, wool comber 0
4329691 2140225 2140225 defendant Caly Richard shoemaker 585915 585915 Caly, Richard, of Shypdam, shoemaker 2
4331558 2140851 2140851 defendant Leverington William yeoman 585915 585915 Leverington, William, of Shypdam, yeoman 2
4609837 2234170 2234170 defendant Faukener John   585915 585915 Faukener, John, of Shypdam 0
4911447 2330082 2330082 defendant Colson John husbandman 585915 585915 Colson, John, of Shypdam, husbandman 3
4936559 2337817 2337817 defendant Marwe John yeoman 585915 585915 Marwe, John, of Shypdam, yeoman 0
5233765 2425462 2425462 defendant Elyngham John husbandman 585915 585915 Elyngham, John, of Shypdam, husbandman 1
5238150 2426746 2426746 defendant Barwyke John husbandman 585915 585915 Barwyke, John, of Shypdam, husbandman 0
5255853 2431952 2431952 plaintiff Candeler Geoffrey   585915 585915 Candeler, Geoffrey, of Shypdam 1
5268172 2435816 2435816 defendant Waren Robert husbandman 585915 585915 Waren, Robert, of Shypdam, husbandman 1
5271406 2436731 2436731 defendant Esthawe Gilbert husbandman 585915 585915 Esthawe, Gilbert, of Shypdam, husbandman 0
5273414 2437296 2437296 plaintiff Merchaunt Richard   585915 585915 Merchaunt, Richard, of Shypdam 0
5390984 2472487 2472487 defendant Platfoot Ralph   585915 585915 Platfoot, Ralph, of Shypdam 2
5405577 2476673 2476673 defendant Pewkyn John yeoman 585915 585915 Pewkyn, John, of Shypdam, yeoman 0
5405578 2476673 2476673 defendant Symondes Roger yeoman 585915 585915 Symondes, Roger, of Shypdam, yeoman 1
5405579 2476673 2476673 defendant Symondes John yeoman 585915 585915 Symondes, John, of Shypdam, yeoman 2
5422453 2481663 2481663 defendant Symond Henry carpenter 585915 585915 Symond, Henry, of Shypdam, carpenter 1
5521014 2511396 2511396 plaintiff Carter William (legal representative) 585915 585915 Carter, William, of Shypdam, "solman", administrator of 0
5521019 2511396 2511396 defendant Gyles Alexander shoemaker 585915 585915 Gyles, Alexander, of Shypdam, shoemaker 3

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