names

25 rows where place_id = 607626

✎ 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
3670107 1916595 1916595 defendant Davyes Nicholas husbandman 607626 607626 Davyes, Nicholas, of Stoke Gifford, husbandman 2
4286681 2125285 2125285 defendant Barkeley Richard   607626 607626 Barkeley, Richard, of Stoke Gifford, knight 0
4286685 2125287 2125287 defendant Dorney Christopher yeoman 607626 607626 Dorney, Christopher, of Stoke Gifford, yeoman 0
4295384 2128436 2128436 defendant Barkeley Richard   607626 607626 Barkeley, Richard, of Stoke Gifford, knight 0
4295385 2128436 2128436 defendant Dorney Christopher yeoman 607626 607626 Dorney, Christopher, of Stoke Gifford, yeoman 1
4389215 2161022 2161022 defendant Gibson Edith widow 607626 607626 Gibson, Edith, of Stoke Gifford, widow 1
4402666 2165477 2165477 defendant Gibson Henry yeoman 607626 607626 Gibson, Henry, of Stoke Gifford, yeoman 3
4706116 2267289 2267289 defendant Cook William   607626 607626 Cook, William, of Stoke Gifford, cook 0
4851674 2311956 2311956 defendant Bonde John husbandman 607626 607626 Bonde, John, of Stoke Gifford, husbandman 0
5091749 2383977 2383977 defendant Berkeley Maurice   607626 607626 Berkeley, Maurice, of Stoke Gifford, knight 0
5091750 2383977 2383977 defendant Berkeley William esq 607626 607626 Berkeley, William, of Stoke Gifford, esq 1
5091751 2383977 2383977 defendant Berkeley Maurice esq 607626 607626 Berkeley, Maurice, of Stoke Gifford, esq 2
5091752 2383977 2383977 defendant Hill Thurstan yeoman 607626 607626 Hill, Thurstan, of Stoke Gifford, yeoman 3
5091753 2383977 2383977 defendant Hourd William yeoman 607626 607626 Hourd, William, of Stoke Gifford, yeoman 4
5091754 2383977 2383977 defendant ap John Lewis yeoman 607626 607626 ap John, Lewis, of Stoke Gifford, yeoman 5
5091758 2383978 2383978 defendant Berkeley Maurice   607626 607626 Berkeley, Maurice, of Stoke Gifford, knight 0
5091759 2383978 2383978 defendant Berkeley William esq 607626 607626 Berkeley, William, of Stoke Gifford, esq 1
5091760 2383978 2383978 defendant Berkeley Maurice esq 607626 607626 Berkeley, Maurice, of Stoke Gifford, esq 2
5091761 2383978 2383978 defendant Hill Thurstan yeoman 607626 607626 Hill, Thurstan, of Stoke Gifford, yeoman 3
5091762 2383978 2383978 defendant Hourd William yeoman 607626 607626 Hourd, William, of Stoke Gifford, yeoman 4
5091763 2383978 2383978 defendant ap John Lewis yeoman 607626 607626 ap John, Lewis, of Stoke Gifford, yeoman 5
5091767 2383979 2383979 defendant Smyth Thomas chaplain 607626 607626 Smyth, Thomas, of Stoke Gifford, chaplain 0
5091771 2383979 2383979 defendant Hill Thirstan yeoman 607626 607626 Hill, Thirstan, of Stoke Gifford, yeoman 4
5091772 2383979 2383979 defendant Hourd William yeoman 607626 607626 Hourd, William, of Stoke Gifford, yeoman 5
5091773 2383979 2383979 defendant ap John Lewis yeoman 607626 607626 ap John, Lewis, of Stoke Gifford, yeoman 6

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