names

15 rows where place_id = 607657

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670235 1916636 1916636 defendant Hybottys Thomas gent 607657 607657 Hybottys, Thomas, of Barkeley, Glos, gent 2
3697063 1925301 1925301 defendant Hubande Thomas gent 607657 607657 Hubande, Thomas, of Barkeley, Glos, gent 1
3754506 1943364 1943364 defendant Tyler Thomas gent 607657 607657 Tyler, Thomas, of Barkeley, Glos, gent 3
3788836 1954312 1954312 defendant Deryett John husbandman 607657 607657 Deryett, John, of Barkeley, Glos, husbandman 0
3788839 1954313 1954313 defendant Deryett John husbandman 607657 607657 Deryett, John, of Barkeley, Glos, husbandman 1
3948998 2006715 2006715 defendant Taysem Thomas vintner 607657 607657 Taysem, Thomas, of Barkeley, Glos, vintner 0
3975955 2016153 2016153 defendant Sammiggar Richard husbandman 607657 607657 Sammiggar, Richard, of Barkeley, Glos, husbandman 0
3992666 2022126 2022126 defendant Dekyns Thomas yeoman 607657 607657 Dekyns, Thomas, of Barkeley, Glos, yeoman 0
4027976 2034655 2034655 defendant Machyn William yeoman 607657 607657 Machyn, William, of Barkeley, Glos, yeoman 0
4095402 2058679 2058679 defendant Gybbyns alias Carpenter Thomas husbandman 607657 607657 Gybbyns alias Carpenter, Thomas, of Barkeley, Glos, husbandman 0
4099746 2060232 2060232 defendant Hall Edward yeoman 607657 607657 Hall, Edward, of Barkeley, Glos, yeoman 0
4154318 2079604 2079604 defendant Hall Edward yeoman 607657 607657 Hall, Edward, of Barkeley, Glos, yeoman 0
4190748 2092325 2092325 defendant Barnard James yeoman 607657 607657 (Barnard, James, of Barkeley, Glos, yeoman 1
4968366 2347503 2347503 defendant Barkeley James   607657 607657 Barkeley, James, of Barkeley, Glos, knight 0
5290444 2442210 2442210 defendant Bolytonte or Bolytoute Walter chaplain 607657 607657 Bolytonte or Bolytoute, Walter, of Barkeley, Glos, chaplain 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);