names

23 rows where place_id = 651063

✎ 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
3915540 1995565 1995565 defendant Frost Henry   651063 651063 Frost, Henry, of Goldclyff 0
3915542 1995566 1995566 defendant Frost Henry husbandman 651063 651063 Frost, Henry, of Goldclyff, husbandman 0
3919135 1996725 1996725 defendant Arney Richard yeoman 651063 651063 Arney, Richard, of Goldclyff, yeoman 0
3957567 2009709 2009709 defendant Arney or Arvey Philip yeoman 651063 651063 Arney or Arvey, Philip, of Goldclyff, yeoman 2
3964370 2012143 2012143 plaintiff Arney or Arvey William yeoman 651063 651063 Arney or Arvey, William, of Goldclyff, yeoman 0
3964371 2012143 2012143 defendant Coult William husbandman 651063 651063 Coult, William, of Goldclyff, husbandman 0
3964373 2012144 2012144 defendant Meke William yeoman 651063 651063 Meke, William, of Goldclyff, yeoman 0
3964374 2012144 2012144 defendant Boole Richard, senior yeoman 651063 651063 Boole, Richard, senior, of Goldclyff, yeoman 1
3964375 2012144 2012144 defendant Wathen Alice widow 651063 651063 Wathen, Alice, of Goldclyff, widow 2
3966200 2012807 2012807 defendant Griffith Richard husbandman 651063 651063 Griffith, Richard, of Goldclyff, husbandman 0
3972702 2015026 2015026 defendant Arney John yeoman 651063 651063 Arney, John, of Goldclyff, yeoman 0
4008713 2027879 2027879 defendant Boole William yeoman 651063 651063 Boole, William, of Goldclyff, yeoman 0
4008715 2027880 2027880 defendant Boole William yeoman 651063 651063 Boole, William, of Goldclyff, yeoman 0
4008717 2027881 2027881 defendant Boole William yeoman 651063 651063 Boole, William, of Goldclyff, yeoman 0
4008719 2027882 2027882 defendant Gladwyn John husbandman 651063 651063 Gladwyn, John, of Goldclyff, husbandman 0
4068161 2048917 2048917 defendant Wylkyn John yeoman 651063 651063 Wylkyn, John, of Goldclyff, yeoman 0
4068286 2048957 2048957 defendant Surman William yeoman 651063 651063 Surman, William, of Goldclyff, yeoman 2
4091656 2057308 2057308 defendant Robyn John husbandman 651063 651063 Robyn, John, of Goldclyff, husbandman 0
4099967 2060314 2060314 defendant ap John alias Robyn John yeoman 651063 651063 ap John alias Robyn, John, of Goldclyff, yeoman 0
4116706 2066269 2066269 defendant Boole Henry yeoman 651063 651063 Boole, Henry, of Goldclyff, yeoman 2
4118956 2067061 2067061 defendant Hye Philip yeoman 651063 651063 Hye, Philip, of Goldclyff, yeoman 1
4135749 2073113 2073113 defendant Hall or Haulle Thomas yeoman 651063 651063 Hall or Haulle, Thomas, of Goldclyff, yeoman 2
4141110 2075050 2075050 defendant Kyrste Richard yeoman 651063 651063 Kyrste, Richard, of Goldclyff, yeoman 1

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