names

26 rows where place_id = 615580

✎ 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
3709575 1929303 1929303 defendant Dey Thomas husbandman 615580 615580 Dey, Thomas, of Stocke, husbandman 0
4024517 2033445 2033445 plaintiff Bloggett Andrew (legal representative) 615580 615580 Bloggett, Andrew, of Stocke, yeoman, executrix of 0
4067215 2048573 2048573 defendant Caswall Richard yeoman 615580 615580 Caswall, Richard, of Stocke juxta Leominster, yeoman 1
4067216 2048573 2048573 defendant Caswall Alice widow 615580 615580 Caswall, Alice, of Stocke juxta Leominster, widow 2
4067231 2048578 2048578 defendant Watham Edward husbandman 615580 615580 Watham, Edward, of Stocke juxta Leominster, husbandman 0
4067232 2048578 2048578 defendant Watham Thomas husbandman 615580 615580 Watham, Thomas, of Stocke juxta Leominster, husbandman 1
4114462 2065457 2065457 defendant Tachell Thomas husbandman 615580 615580 Tachell, Thomas, of Stocke under Hamdowne, husbandman 0
4126957 2069934 2069934 defendant Hawkyns Thomas yeoman 615580 615580 Hawkyns, Thomas, of Stocke Gayler, yeoman 0
4134453 2072653 2072653 defendant Farechilde William clerk 615580 615580 Farechilde, William, of Stocke, clerk 0
4152308 2078917 2078917 defendant Petvyn Thomas gent 615580 615580 Petvyn, Thomas, of Stocke, gent 0
4152309 2078917 2078917 defendant Petvyn John gent 615580 615580 Petvyn, John, of Stocke, gent 1
4153898 2079458 2079458 defendant Bucknall Thomas gent 615580 615580 Bucknall, Thomas, of Stocke, or of Ubbeley, gent 0
4153900 2079458 2079458 defendant Turnor Richard blacksmith 615580 615580 Turnor, Richard, of Stocke, blacksmith 2
4172228 2085750 2085750 defendant Taverner Rumball yeoman 615580 615580 Taverner, Rumball, of Stocke, yeoman 1
4176486 2087258 2087258 defendant Petvyn John gent 615580 615580 Petvyn, John, of Stocke, gent 1
4208906 2098663 2098663 defendant Petvyn John gent 615580 615580 Petvyn, John, of Stocke, gent 1
4215876 2101053 2101053 defendant Richard William gent 615580 615580 Richard, William, of Stocke, gent 0
4223280 2103634 2103634 defendant Clatworthy William gent 615580 615580 Clatworthy, William, of Stocke, gent 1
4232477 2106866 2106866 defendant Wilkyns George gent 615580 615580 Wilkyns, George, of Stocke, gent 0
4241763 2110232 2110232 defendant Chaffye Edith widow 615580 615580 Chaffye, Edith, of Stocke under Hamdon, widow 0
4245371 2111426 2111426 defendant Richard William gent 615580 615580 Richard, William, of Stocke, gent 0
4279851 2122868 2122868 defendant Solme Edward glover 615580 615580 Solme, Edward, of Stocke, glover 1
4287087 2125435 2125435 defendant Hawkyns Thomas husbandman 615580 615580 Hawkyns, Thomas, of Stocke, husbandman 0
4303239 2131259 2131259 defendant Arteys John tailor 615580 615580 Arteys, John, of Stocke, tailor 0
4318658 2136634 2136634 defendant Cracknall Lionel yeoman 615580 615580 Cracknall, Lionel, of Stocke, yeoman 3
4407859 2167193 2167193 defendant Cokyn Thomas husbandman 615580 615580 Cokyn, Thomas, of Stocke, husbandman 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);