names

34 rows where place_id = 729578

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4167114 2084004 2084004 defendant Browne Richard carpenter 729578 729578 Browne, Richard, of Chertsey, or of Kingston on Thames, Surrey, carpenter 0
4283306 2124068 2124068 defendant Nicholas alias Morgan Morgan gent 729578 729578 Nicholas alias Morgan, Morgan, of Chertsey, gent 0
4284928 2124658 2124658 defendant Stidolphe John gent 729578 729578 Stidolphe, John, of Chertsey, gent 0
4304010 2131533 2131533 defendant Purdam Thomas yeoman 729578 729578 Purdam, Thomas, of Chertsey, yeoman 0
4354191 2148694 2148694 defendant Stodolphe John gent 729578 729578 Stodolphe, John, of Chertsey, gent 0
4418173 2170563 2170563 plaintiff Vyne Thomas de la   729578 729578 Vyne, Thomas de la, of Chertsey 0
4701061 2265738 2265738 defendant Hykedon Ralph   729578 729578 Hykedon, Ralph, of Chertsey, vicar 0
4717967 2270959 2270959 defendant Blysse Robert yeoman 729578 729578 Blysse, Robert, of Chertsey, yeoman 1
4755280 2282038 2282038 defendant atte Wode William fishmonger 729578 729578 atte Wode, William, of Chertsey, fishmonger 0
4828871 2305067 2305067 defendant fitz John Nicholas gent 729578 729578 fitz John, Nicholas, of Chertsey, gent 0
4849690 2311380 2311380 defendant Sparke john cooper 729578 729578 Sparke, john, of Chertsey, cooper 0
4882428 2321418 2321418 defendant Skelton Thomas baker 729578 729578 Skelton, Thomas, of Chertsey, baker 0
4982065 2351552 2351552 defendant FitzJohn Nicholas gent 729578 729578 FitzJohn, Nicholas, of Chertsey, gent 0
5048205 2371093 2371093 defendant Hert Thomas   729578 729578 Hert, Thomas, of Chertsey, bailiff 1
5149987 2401128 2401128 defendant Hert Thomas (legal representative) 729578 729578 Hert, Thomas, of Chertsey, yeoman, executors of 4
5191603 2413285 2413285 defendant Bedell Thomas yeoman 729578 729578 Bedell, Thomas, of Chertsey, yeoman 1
5207414 2417910 2417910 defendant Halley Thomas yeoman 729578 729578 Halley, Thomas, of Chertsey, yeoman 0
5207415 2417910 2417910 defendant Bedell Thomas yeoman 729578 729578 Bedell, Thomas, of Chertsey, yeoman 1
5304013 2446204 2446204 defendant Hert Thomas (legal representative) 729578 729578 Hert, Thomas, of Chertsey, executrix of 2
5365065 2464744 2464744 defendant Warner Thomas laborer 729578 729578 Warner, Thomas, of Chertsey, laborer 0
5422412 2481651 2481651 defendant Campon Isabel widow 729578 729578 Campon, Isabel, of Chertsey, widow 0
5437359 2486118 2486118 defendant Grene Robert   729578 729578 Grene, Robert, of Chertsey 0
5437363 2486119 2486119 defendant Grene Robert yeoman 729578 729578 Grene, Robert, of Chertsey, yeoman 0
5455399 2491529 2491529 plaintiff Bonne or Boune Henry shoemaker 729578 729578 Bonne or Boune, Henry, of Chertsey, shoemaker 0
5461985 2493524 2493524 defendant Braddoke Ralph yeoman & alablaster man 729578 729578 Braddoke, Ralph, of Chertsey, yeoman & alablaster man 0
5461986 2493524 2493524 defendant Braddoke William clerk 729578 729578 Braddoke, William, of Chertsey, clerk 1
5462010 2493533 2493533 defendant Braddok Ralph yeoman 729578 729578 Braddok, Ralph, of Chertsey, yeoman 0
5462012 2493534 2493534 defendant Braddok Ralph yeoman 729578 729578 Braddok, Ralph, of Chertsey, yeoman 0
5468029 2495380 2495380 defendant Braddoke Ralph alablaster man 729578 729578 Braddoke, Ralph, of Chertsey, alablaster man 0
5468030 2495380 2495380 defendant Braddoke William chaplain 729578 729578 Braddoke, William, of Chertsey, chaplain 1
5473256 2496963 2496963 defendant Broddoke Ralph potter in the monastery of St Peter 729578 729578 Broddoke, Ralph, of Chertsey, potter in the monastery of St Peter 0
5473495 2497035 2497035 defendant Braddoke Ralph yeoman & alablaster man 729578 729578 Braddoke, Ralph, of Chertsey, yeoman & alablaster man 0
5473496 2497035 2497035 defendant Braddoke William clerk 729578 729578 Braddoke, William, of Chertsey, clerk 1
5475297 2497600 2497600 defendant Grene Robert yeoman 729578 729578 Grene, Robert, of Chertsey, yeoman 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);