names

21 rows where place_id = 684532

✎ 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
4058625 2045474 2045474 defendant Napper Walter tanner 684532 684532 Napper, Walter, of West Coker, Soms, tanner 0
4104409 2061860 2061860 defendant Middleton Henry yeoman 684532 684532 Middleton, Henry, of West Coker, Soms, yeoman 0
4128575 2070510 2070510 defendant Whyttington Francis gent 684532 684532 Whyttington, Francis, of West Coker, Soms, gent 0
4177714 2087680 2087680 defendant Mydelton Henry gent 684532 684532 Mydelton, Henry, of West Coker, Soms, gent 0
4193749 2093383 2093383 defendant Whitton alias Whittington Francis gent 684532 684532 Whitton alias Whittington, Francis, of West Coker, Soms, gent 1
4206163 2097705 2097705 defendant Grey John gent 684532 684532 (Grey, John, of West Coker, Soms, gent 1
4209196 2098767 2098767 defendant Slade Richard husbandman 684532 684532 Slade, Richard, of West Coker, Soms, husbandman 0
4227084 2104946 2104946 defendant Slade John yeoman 684532 684532 Slade, John, of West Coker, Soms, yeoman 1
4255038 2114680 2114680 defendant Slade John yeoman 684532 684532 Slade, John, of West Coker, Soms, yeoman 1
4307552 2132779 2132779 defendant Slade Roger husbandman 684532 684532 Slade, Roger, of West Coker, Soms, husbandman 0
4389132 2160996 2160996 defendant Palmer John husbandman 684532 684532 Palmer, John, of West Coker, Soms, husbandman 1
4655394 2247579 2247579 defendant Peny John gent 684532 684532 Peny, John, of West Coker, Soms, gent 0
4678901 2259004 2259004 defendant Richard William clerk 684532 684532 Richard, William, of West Coker, Soms, clerk 0
4957748 2344289 2344289 defendant Wellywroght Thomas gent 684532 684532 Wellywroght, Thomas, of West Coker, Soms, gent 0
4959052 2344673 2344673 defendant Welywrought Thomas gent 684532 684532 Welywrought, Thomas, of West Coker, Soms, gent 0
4959054 2344674 2344674 defendant Welywrought Thomas gent 684532 684532 Welywrought, Thomas, of West Coker, Soms, gent 0
4982402 2351656 2351656 defendant Welywrought Thomas gent 684532 684532 Welywrought, Thomas, of West Coker, Soms, gent 1
4982412 2351659 2351659 defendant Welywrought Thomas gent 684532 684532 Welywrought, Thomas, of West Coker, Soms, gent 0
5019900 2362699 2362699 defendant Welywrought Thomas gent 684532 684532 Welywrought, Thomas, of West Coker, Soms, gent 0
5381241 2469687 2469687 defendant Medylton William gent 684532 684532 Medylton, William, of West Coker, Soms, gent 3
5470395 2496065 2496065 defendant Medilton William   684532 684532 Medilton, William, of West Coker, Soms 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);