names

18 rows where place_id = 606866

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637417 1906508 1906508 defendant Phetepace or Fetepace Thomas   606866 606866 Phetepace or Fetepace, Thomas, of Compton, Berks, knight 0
3653517 1911366 1911366 defendant Fetiplace Thomas   606866 606866 Fetiplace, Thomas, of Compton, Berks, knight 0
3666810 1915563 1915563 defendant Fetepace Edward esq 606866 606866 Fetepace, Edward, of Compton, Berks, esq 1
3666814 1915564 1915564 defendant Fetepacs Edward esq 606866 606866 Fetepacs, Edward, of Compton, Berks, esq 1
3677532 1919020 1919020 defendant Fetypace Thomas   606866 606866 Fetypace, Thomas, of Compton, Berks, knight 7
3727173 1934770 1934770 defendant Colsbonne Thomas   606866 606866 Colsbonne, Thomas, of Compton, Berks, shepherd 0
3783424 1952565 1952565 defendant Fetiplace Thomas (legal representative) 606866 606866 Fetiplace, Thomas, of Compton, Berks, knight, executor of 0
3783428 1952566 1952566 defendant Fetypace Thomas (legal representative) 606866 606866 Fetypace, Thomas, of Compton, Berks, knight, executors of 0
3783432 1952566 1952566 defendant Fetyplace John gent 606866 606866 Fetyplace, John, of Compton, Berks, gent 4
3900592 1990428 1990428 defendant Fabyan Edward esq 606866 606866 Fabyan, Edward, of Compton, Berks, esq 0
3975768 2016086 2016086 defendant Smyth Thomas yeoman 606866 606866 Smyth, Thomas, of Compton, Berks, yeoman 0
4022484 2032765 2032765 plaintiff Archard Edward gent 606866 606866 Archard, Edward, of Compton, Berks, gent 0
4108931 2063449 2063449 defendant Butler William yeoman 606866 606866 Butler, William, of Compton, Berks, yeoman 0
4160978 2081912 2081912 defendant Hilton Gawin gent 606866 606866 Hilton, Gawin, of Compton, Berks, gent 1
4287152 2125463 2125463 defendant Stampe John gent 606866 606866 Stampe, John, of Compton, Berks, gent 0
4288862 2126070 2126070 defendant Stempe John gent 606866 606866 Stempe, John, of Compton, Berks, gent 0
4848547 2311020 2311020 defendant Motrom Edmund clerk 606866 606866 Motrom, Edmund, of Compton, Berks, clerk 0
5316563 2450039 2450039 defendant Broun John yeoman 606866 606866 Broun, John, of Compton, Berks, yeoman 1

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