names

38 rows where place_id = 600132

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639819 1907266 1907266 defendant Mundis Arnold husbandman 600132 600132 Mundis, Arnold, of Elmestede, husbandman 0
4626193 2239146 2239146 defendant Pycard William   600132 600132 Pycard, William, of Elmestede 0
4657470 2248229 2248229 defendant Fraunceys John yeoman 600132 600132 Fraunceys, John, of Elmestede, yeoman 0
4657471 2248229 2248229 defendant Wayte John yeoman 600132 600132 Wayte, John, of Elmestede, yeoman 1
4672872 2257158 2257158 defendant Somer Hamon smith 600132 600132 Somer, Hamon, of Elmestede, smith 1
4672873 2257158 2257158 defendant Edynger Hamon chapman 600132 600132 Edynger, Hamon, of Elmestede, chapman 2
4681245 2259760 2259760 defendant Pacard William yeoman 600132 600132 Pacard, William, of Elmestede, yeoman 0
4687115 2261573 2261573 defendant Seman alias Cristemasse Henry yeoman 600132 600132 Seman alias Cristemasse, Henry, of Elmestede, yeoman 2
4697796 2264809 2264809 plaintiff Coppe William   600132 600132 Coppe, William, of Elmestede 0
4697797 2264809 2264809 defendant Edynge William laborer 600132 600132 Edynge, William, of Elmestede, laborer 0
4726821 2273659 2273659 defendant Lucas John weaver 600132 600132 Lucas, John, of Elmestede, weaver 0
4735469 2276239 2276239 defendant Seman Henry yeoman 600132 600132 Seman, Henry, of Elmestede, yeoman 0
4825695 2304079 2304079 defendant German Thomas butcher 600132 600132 German, Thomas, of Elmestede, butcher 0
4835578 2307117 2307117 defendant German Thomas butcher 600132 600132 German, Thomas, of Elmestede, butcher 0
4862893 2315379 2315379 defendant German Thomas butcher 600132 600132 German, Thomas, of Elmestede, butcher 0
4875811 2319397 2319397 defendant Stephene Robert laborer 600132 600132 Stephene, Robert, of Elmestede, laborer 0
4883718 2321818 2321818 defendant Perkyn John husbandman 600132 600132 Perkyn, John, of Elmestede, husbandman 4
4888214 2323121 2323121 defendant Stephene John gent 600132 600132 Stephene, John, of Elmestede, gent 0
4904109 2327898 2327898 defendant Stephene John gent 600132 600132 Stephene, John, of Elmestede, gent 0
4904549 2328032 2328032 defendant Perkyn John husbandman 600132 600132 Perkyn, John, of Elmestede, husbandman 1
4907221 2328822 2328822 defendant Perkyn John husbandman 600132 600132 Perkyn, John, of Elmestede, husbandman 1
4930890 2336061 2336061 defendant Stephene John gent 600132 600132 Stephene, John, of Elmestede, gent 0
4979846 2350927 2350927 defendant Cartere Hamon husbandman 600132 600132 Cartere, Hamon, of Elmestede, husbandman 0
4979847 2350927 2350927 defendant Cooke John   600132 600132 Cooke, John, of Elmestede, holy water clerk 1
4979848 2350927 2350927 defendant atte Wode Hamon smith 600132 600132 atte Wode, Hamon, of Elmestede, smith 2
4989979 2353913 2353913 defendant Philpot William yeoman 600132 600132 Philpot, William, of Elmestede, yeoman 0
5065034 2376072 2376072 defendant Hunte John husbandman 600132 600132 Hunte, John, of Elmestede, husbandman 0
5083032 2381430 2381430 defendant Stevyn John yeoman 600132 600132 Stevyn, John, of Elmestede, yeoman 1
5085809 2382245 2382245 defendant Swayn John husbandman 600132 600132 Swayn, John, of Elmestede, husbandman 1
5246645 2429179 2429179 defendant Smothe Thomas husbandman 600132 600132 Smothe, Thomas, of Elmestede, husbandman 1
5319807 2451016 2451016 defendant Stephens John yeoman 600132 600132 Stephens, John, of Elmestede, yeoman 4
5338421 2456590 2456590 defendant Forde John, junior laborer 600132 600132 Forde, John, junior, of Elmestede, laborer 4
5360223 2463238 2463238 defendant Danyell William husbandman 600132 600132 Danyell, William, of Elmestede, husbandman 1
5413779 2479047 2479047 defendant Wodman Simon husbandman 600132 600132 Wodman, Simon, of Elmestede, husbandman 0
5527268 2513105 2513105 defendant Phylpotte William husbandman 600132 600132 Phylpotte, William, of Elmestede, husbandman 2
5631874 2553988 2553988 defendant Wodeman Robert husbandman 600132 600132 Wodeman, Robert, of Elmestede, husbandman 0
5634226 2554687 2554687 defendant Pykard William farmer 600132 600132 Pykard, William, of Elmestede, farmer 0
5636227 2555288 2555288 defendant Coppe William   600132 600132 Coppe, William, of Elmestede 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);