names

47 rows where place_id = 591260

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603876 1868884 1868884 plaintiff FitzHerbert John   591260 591260 FitzHerbert, John, of Norbury 0
4024530 2033450 2033450 defendant Wymble Edward yeoman 591260 591260 Wymble, Edward, of Norbury, yeoman 0
4024532 2033450 2033450 defendant Jervys John yeoman 591260 591260 Jervys, John, of Norbury, yeoman 2
4024533 2033450 2033450 defendant Lydgelet Thomas laborer 591260 591260 Lydgelet, Thomas, of Norbury, laborer 3
4024534 2033450 2033450 defendant Nyckeson William laborer 591260 591260 Nyckeson, William, of Norbury, laborer 4
4024535 2033450 2033450 defendant Skrymsher Richard yeoman 591260 591260 together with Skrymsher, Richard, of Norbury, yeoman 5
4024536 2033450 2033450 defendant Tyllesley Robert laborer 591260 591260 Tyllesley, Robert, of Norbury, laborer 6
4024537 2033450 2033450 defendant Rathbon John yeoman 591260 591260 Rathbon, John, of Norbury, yeoman 7
4086774 2055557 2055557 defendant Wyldyng Thomas yeoman 591260 591260 Wyldyng, Thomas, of Norbury, or of Wentenor, yeoman 1
4108312 2063235 2063235 defendant Phellipps William husbandman 591260 591260 Phellipps, William, of Norbury, husbandman 0
4108313 2063235 2063235 defendant Whitcote John husbandman 591260 591260 Whitcote, John, of Norbury, husbandman 1
4108314 2063235 2063235 defendant Mountford William husbandman 591260 591260 Mountford, William, of Norbury, husbandman 2
4118899 2067041 2067041 defendant Rathebone Richard yeoman 591260 591260 Rathebone, Richard, of Norbury, yeoman 0
4469941 2191265 2191265 plaintiff Bragge Thomas   591260 591260 Bragge, Thomas, of Norbury 0
4648698 2245675 2245675 defendant Pyard Roger   591260 591260 Pyard, Roger, of Norbury 0
4648700 2245676 2245676 defendant Pyard Roger   591260 591260 Pyard, Roger, of Norbury 0
4891143 2323968 2323968 defendant Pell Robert yeoman 591260 591260 Pell, Robert, of Norbury, yeoman 2
4940671 2339111 2339111 defendant Boston John chaplain 591260 591260 Boston, John, of Norbury, chaplain 0
4960399 2345077 2345077 defendant FitzHerberd Nicholas esq 591260 591260 FitzHerberd, Nicholas, of Norbury, esq 0
4960400 2345077 2345077 defendant Petur John yeoman 591260 591260 Petur, John, of Norbury, yeoman 1
4960401 2345077 2345077 defendant Lyghtwode John miller 591260 591260 Lyghtwode, John, of Norbury, miller 2
4960409 2345077 2345077 defendant Mylner John laborer 591260 591260 Mylner, John, of Norbury, laborer 10
4960412 2345077 2345077 defendant Frenshman John husbandman 591260 591260 Frenshman, John, of Norbury, husbandman 13
5019946 2362715 2362715 defendant Arthur John husbandman 591260 591260 Arthur, John, of Norbury, husbandman 0
5019947 2362715 2362715 defendant Bayle John husbandman 591260 591260 Bayle, John, of Norbury, husbandman 1
5076031 2379327 2379327 defendant Downe Ralph husbandman 591260 591260 Downe, Ralph, of Norbury, husbandman 0
5077046 2379634 2379634 defendant Colyer William yeoman 591260 591260 Colyer, William, of Norbury, yeoman 0
5283866 2440312 2440312 plaintiff FitzHerbert Nicholas esq 591260 591260 FitzHerbert, Nicholas, of Norbury, esq 0
5413071 2478839 2478839 plaintiff Prynce Henry   591260 591260 Prynce, Henry, of Norbury, parson 4
5428137 2483357 2483357 plaintiff Prynce Henry   591260 591260 Prynce, Henry, of Norbury, parson 4
5428144 2483358 2483358 plaintiff Prince Henry   591260 591260 Prince, Henry, of Norbury 4
5428151 2483359 2483359 plaintiff Prynce Henry   591260 591260 Prynce, Henry, of Norbury, parson 4
5441561 2487396 2487396 defendant fitz Herbert Elizabeth widow & formerly wife of Ralph 591260 591260 (fitz Herbert, Elizabeth, of Norbury, widow & formerly wife of Ralph 1
5441563 2487396 2487396 defendant fitz Herbert Thomas clerk 591260 591260 fitz Herbert, Thomas, of Norbury, clerk 3
5441564 2487396 2487396 defendant Prynce Henry clerk 591260 591260 Prynce, Henry, of Norbury, clerk 4
5454341 2491207 2491207 defendant fitz Herbert Thomas clerk 591260 591260 fitz Herbert, Thomas, of Norbury, clerk 2
5454342 2491207 2491207 defendant Prynce Henry clerk 591260 591260 Prynce, Henry, of Norbury, clerk 3
5458389 2492401 2492401 plaintiff Prynce Henry   591260 591260 Prynce, Henry, of Norbury, parson 4
5470018 2495951 2495951 plaintiff Prynce Henry   591260 591260 Prynce, Henry, of Norbury, parson 4
5529947 2513868 2513868 defendant Wolley John laborer 591260 591260 Wolley, John, of Norbury, laborer 1
5543106 2517964 2517964 defendant Grene Richard   591260 591260 Grene, Richard, of Norbury, shepherd 0
5543107 2517964 2517964 defendant Hauke or Hanke William laborer 591260 591260 Hauke or Hanke, William, of Norbury, laborer 1
5571051 2526096 2526096 defendant Corke Reginald yeoman 591260 591260 (Corke, Reginald, of Norbury, yeoman 1
5571052 2526096 2526096 defendant Corke Maud widow 591260 591260 Corke, Maud, of Norbury, widow 2
5571065 2526098 2526098 defendant Corke Reginald yeoman 591260 591260 (Corke, Reginald, of Norbury, yeoman 5
5571066 2526098 2526098 defendant Corke Matilda widow 591260 591260 Corke, Matilda, of Norbury, widow 6
5621605 2550658 2550658 defendant Kyneton Henry de   591260 591260 Kyneton, Henry de, of Norbury, parson 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);