names

30 rows where place_id = 606197

✎ 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
3664393 1914814 1914814 defendant Edmonson Willliam draper 606197 606197 Edmonson, Willliam, of Highworth, draper 1
3680809 1920079 1920079 defendant Ardern Walter gent 606197 606197 Ardern, Walter, of Highworth, gent 0
3871046 1980566 1980566 defendant Bollar John yeoman 606197 606197 Bollar, John, of Highworth, yeoman 0
4076687 2051945 2051945 plaintiff Skynner Thomas yeoman 606197 606197 Skynner, Thomas, of Highworth, yeoman 0
4086793 2055565 2055565 defendant Skynner John yeoman 606197 606197 Skynner, John, of Highworth, yeoman 0
4136799 2073511 2073511 defendant Turner Hugh yeoman 606197 606197 Turner, Hugh, of Highworth, yeoman 1
4153537 2079331 2079331 defendant Skynner Thomas   606197 606197 Skynner, Thomas, of Highworth, woollen draper 0
4153538 2079331 2079331 defendant Skynner John yeoman 606197 606197 Skynner, John, of Highworth, yeoman 1
4169804 2084936 2084936 defendant Clynton Guy clerk 606197 606197 Clynton, Guy, of Highworth, clerk 0
4169806 2084937 2084937 defendant Cusse Lawrence yeoman 606197 606197 Cusse, Lawrence, of Highworth, yeoman 0
4169808 2084938 2084938 defendant Rose John yeoman 606197 606197 Rose, John, of Highworth, yeoman 0
4173400 2086154 2086154 defendant Abell John shoemaker 606197 606197 Abell, John, of Highworth, shoemaker 0
4178733 2088040 2088040 defendant Skynner Thomas chapman 606197 606197 Skynner, Thomas, of Highworth, chapman 0
4185258 2090353 2090353 defendant Temple John butcher 606197 606197 Temple, John, of Highworth, butcher 0
4232671 2106932 2106932 defendant Evans John yeoman 606197 606197 Evans, John, of Highworth, yeoman 0
4281799 2123538 2123538 defendant Malberley Alice widow 606197 606197 Malberley, Alice, of Highworth, widow 0
4318376 2136534 2136534 defendant Marklyn alias Maslinge John gent 606197 606197 Marklyn alias Maslinge, John, of Highworth, or of Marlborough, gent 0
4335767 2142239 2142239 defendant Fisher Thomas yeoman 606197 606197 Fisher, Thomas, of Highworth, yeoman 1
4342253 2144571 2144571 defendant Roose John yeoman 606197 606197 Roose, John, of Highworth, yeoman 0
4358991 2150381 2150381 defendant Fisher Thomas yeoman 606197 606197 Fisher, Thomas, of Highworth, yeoman 1
4359020 2150389 2150389 defendant Sadbury or Cadbury Edward mercer 606197 606197 Sadbury or Cadbury, Edward, of Highworth, mercer 0
4359021 2150389 2150389 defendant Balye John butcher 606197 606197 Balye, John, of Highworth, butcher 1
4359022 2150389 2150389 defendant Blagrove Parnell widow 606197 606197 Blagrove, Parnell, of Highworth, widow 2
4359936 2150718 2150718 defendant Milles Ambrose   606197 606197 Milles, Ambrose, of Highworth, woollen draper 0
4360314 2150856 2150856 defendant Yate Thomas tanner 606197 606197 Yate, Thomas, of Highworth, tanner 0
4360837 2151043 2151043 defendant Pleydell John gent 606197 606197 Pleydell, John, of Highworth, or of Lytle Parke, Wotton Bassett, gent 0
4370456 2154484 2154484 defendant Ryman John, junior husbandman 606197 606197 Ryman, John, junior, of Highworth, husbandman 0
4371672 2154925 2154925 defendant Butler Henry yeoman 606197 606197 Butler, Henry, of Highworth, yeoman 0
4373164 2155469 2155469 defendant Rose John yeoman 606197 606197 Rose, John, of Highworth, yeoman 2
4381429 2158465 2158465 defendant Fisher Thomas yeoman 606197 606197 Fisher, Thomas, of Highworth, yeoman 2

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