names

25 rows where place_id = 674353

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4013657 2029621 2029621 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4037524 2038082 2038082 defendant Wyllym John David Powell yeoman 674353 674353 Wyllym, John David Powell, of Trostrey, yeoman 3
4037525 2038082 2038082 defendant Howell William yeoman 674353 674353 Howell, William, of Trostrey, yeoman 4
4043777 2040230 2040230 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4065848 2048081 2048081 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4095136 2058590 2058590 defendant William William John yeoman 674353 674353 William, William John, of Trostrey, yeoman 0
4098005 2059615 2059615 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4099971 2060315 2060315 defendant William Cadogan husbandman 674353 674353 William, Cadogan, of Trostrey, husbandman 2
4119527 2067273 2067273 defendant Gwyllim John David Powell gent 674353 674353 Gwyllim, John David Powell, of Trostrey, gent 1
4135748 2073113 2073113 defendant Johns Andrew gent 674353 674353 Johns, Andrew, of Trostrey, gent 1
4141096 2075045 2075045 defendant Thomas John yeoman 674353 674353 Thomas, John, of Trostrey, yeoman 1
4143813 2075998 2075998 defendant William Thomas gent 674353 674353 William, Thomas, of Trostrey, gent 0
4143814 2075998 2075998 defendant Bean David yeoman 674353 674353 Bean, David, of Trostrey, yeoman 1
4165082 2083295 2083295 defendant William Thomas gent 674353 674353 William, Thomas, of Trostrey, gent 0
4165084 2083295 2083295 defendant Bean David husbandman 674353 674353 Bean, David, of Trostrey, husbandman 2
4165085 2083295 2083295 defendant David Maurice yeoman 674353 674353 David, Maurice, of Trostrey, yeoman 3
4165896 2083572 2083572 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4183187 2089600 2089600 defendant Cadogan William gent 674353 674353 Cadogan, William, of Trostrey, gent 0
4183193 2089603 2089603 defendant Jones Andrew gent 674353 674353 Jones, Andrew, of Trostrey, gent 0
4190912 2092385 2092385 defendant Gillam or Gwyllym John David Powell gent 674353 674353 Gillam or Gwyllym, John David Powell, of Trostrey, gent 1
4278003 2122238 2122238 defendant William John David Powell yeoman or gent 674353 674353 William, John David Powell, of Trostrey, yeoman or gent 0
4278963 2122575 2122575 defendant Arnold Thomas gent 674353 674353 Arnold, Thomas, of Trostrey, gent 1
4352527 2148122 2148122 defendant Cadogan William (legal representative) 674353 674353 Cadogan, William, of Trostrey, administrator of 3
4352528 2148122 2148122 defendant William Kadogan yeoman 674353 674353 William, Kadogan, of Trostrey, yeoman 4
4358613 2150251 2150251 defendant vergh John Margaret widow 674353 674353 vergh John, Margaret, of Trostrey, widow 3

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