names

16 rows where place_id = 636826

✎ 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
3832882 1968208 1968208 defendant Purnyll alias Gregory Beatrice widow 636826 636826 Purnyll alias Gregory, Beatrice, of Wotton Basset, Wilts, widow 2
3832886 1968209 1968209 defendant Purnyll alias Grygory Beatrice widow 636826 636826 Purnyll alias Grygory, Beatrice, of Wotton Basset, Wilts, widow 2
4109441 2063638 2063638 defendant Phelpes Thomas yeoman 636826 636826 Phelpes, Thomas, of Wotton Basset, Wilts, yeoman 0
4722627 2272392 2272392 defendant Maydgood William tanner 636826 636826 Maydgood, William, of Wotton Basset, Wilts, tanner 4
4824322 2303670 2303670 defendant Sprot John tanner 636826 636826 Sprot, John, of Wotton Basset, Wilts, tanner 3
4863117 2315442 2315442 defendant Clenche Thomas chapman 636826 636826 Clenche, Thomas, of Wotton Basset, Wilts, chapman 2
4978273 2350449 2350449 defendant Drapere Thomas ploughman 636826 636826 Drapere, Thomas, of Wotton Basset, Wilts, ploughman 0
4989285 2353727 2353727 defendant Grenhill William yeoman 636826 636826 Grenhill, William, of wotton Basset, Wilts, yeoman 1
5097255 2385625 2385625 defendant Glasyer William slater 636826 636826 Glasyer, William, of Wotton Basset, Wilts, slater 3
5112470 2390033 2390033 defendant Doget Walter husbandman 636826 636826 Doget, Walter, of Wotton Basset, Wilts, husbandman 2
5232415 2425053 2425053 defendant Doget Walter butcher 636826 636826 Doget, Walter, of Wotton Basset, Wilts, butcher 0
5261742 2433781 2433781 defendant Byde John husbandman 636826 636826 Byde, John, of Wotton Basset, Wilts, husbandman 1
5268114 2435795 2435795 defendant Benet William, senior yeoman 636826 636826 Benet, William, senior, of Wotton Basset, Wilts, yeoman 0
5269043 2436048 2436048 defendant Doget Walter butcher 636826 636826 Doget, Walter, of Wotton Basset, Wilts, butcher 0
5523667 2512229 2512229 defendant Feryes Mathew gent 636826 636826 Feryes, Mathew, of Wotton Basset, Wilts, gent 0
5568079 2525213 2525213 defendant Gyan alias Fyssher Richard   636826 636826 Gyan alias Fyssher, Richard, of Wotton Basset, Wilts, merhant 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);