names

26 rows where place_id = 690564

✎ 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
3591961 1865098 1865098 defendant Eliston Richard   690564 690564 Eliston, Richard, of Parva Lymber 0
3623983 1875033 1875033 plaintiff Stevenson John, junior   690564 690564 Stevenson, John, junior, of Parva Chester 0
3779761 1951403 1951403 defendant Oldman John baker 690564 690564 Oldman, John, of Parva Walsyngman, baker 2
3790449 1954833 1954833 defendant Gylle John yeoman 690564 690564 Gylle, John, of Parva Lawser, yeoman 0
3817826 1963486 1963486 defendant Marchall John laborer 690564 690564 Marchall, John, of Parva Lawser, laborer 1
3832762 1968173 1968173 defendant Clerys John, junior husbandman 690564 690564 Clerys, John, junior, of Parva Livermer, husbandman 0
3832763 1968173 1968173 defendant Clerys Valentine laborer 690564 690564 Clerys, Valentine, of Parva Livermer, laborer 1
4085643 2055136 2055136 defendant Ellston John yeoman 690564 690564 Ellston, John, of Parva Limber, yeoman 0
4085645 2055137 2055137 defendant Ellston John yeoman 690564 690564 Ellston, John, of Parva Limber, yeoman 0
4088099 2056041 2056041 defendant Elson John yeoman 690564 690564 Elson, John, of Parva Lymber, yeoman 0
4088993 2056362 2056362 defendant Grimelbye Ralph husbandman 690564 690564 Grimelbye, Ralph, of Parva Lymber, husbandman 0
4171449 2085478 2085478 defendant Spencer James gent 690564 690564 Spencer, James, of Parva Limber, gent 0
4171451 2085479 2085479 defendant Spencer James gent 690564 690564 Spencer, James, of Parva Limber, gent 0
4218745 2102057 2102057 defendant Sumner Reginald yeoman 690564 690564 Sumner, Reginald, of Parva Laver, yeoman 4
4239107 2109301 2109301 defendant Bushoppe Roger yeoman 690564 690564 Bushoppe, Roger, of Parva Limber, yeoman 0
4244844 2111264 2111264 defendant Sumner Reginald yeoman 690564 690564 Sumner, Reginald, of Parva Laver, yeoman 4
4297039 2129038 2129038 defendant Elston James laborer 690564 690564 Elston, James, of Parva Lymber, laborer 1
4899390 2326449 2326449 defendant Toures Richard yeoman 690564 690564 Toures, Richard, of Parva Chester, yeoman 0
4978302 2350459 2350459 defendant Tracher Richard husbandman 690564 690564 Tracher, Richard, of Parva Wendover, husbandman 1
4984128 2352185 2352185 defendant Halle John gent 690564 690564 Halle, John, of Parva Onger, gent 0
4984132 2352186 2352186 defendant Halle John gent 690564 690564 Halle, John, of Parva Onger, gent 0
5092456 2384170 2384170 defendant Tregorney William chaplain 690564 690564 Tregorney, William, of Parva Stanmer, chaplain 3
5123298 2393254 2393254 defendant Thomasson Stephen husbandman 690564 690564 Thomasson, Stephen, of Parva Chester, husbandman 1
5543439 2518066 2518066 plaintiff Payn William, junior maltman 690564 690564 Payn, William, junior, of Parva Stanmer, maltman 0
5564670 2524252 2524252 defendant Punt Thomas yeoman of the crown 690564 690564 Punt, Thomas, of Parva Over, gent, yeoman of the crown 0
5604153 2536160 2536160 defendant Punte Thomas yeoman of the crown 690564 690564 Punte, Thomas, of Parva Over, yeoman of the crown, executors of 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);