names

14 rows where place_id = 611430

✎ 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
3688382 1922523 1922523 defendant Ensore Thomas, senior yeoman 611430 611430 Ensore, Thomas, senior, of Cumberford, yeoman 0
3717061 1931621 1931621 defendant Alred Henry fisher 611430 611430 Alred, Henry, of Cumberford, fisher 2
3763226 1946136 1946136 plaintiff Halle Michael   611430 611430 Halle, Michael, of Cumberford 0
3805249 1959587 1959587 defendant Browne William husbandman 611430 611430 Browne, William, of Cumberford, husbandman 0
3887758 1986164 1986164 plaintiff Cumberford Humphrey esq 611430 611430 Cumberford, Humphrey, of Cumberford, esq 0
3994456 2022770 2022770 defendant Cumberford Thomas esq 611430 611430 Cumberford, Thomas, of Cumberford, esq 3
4029200 2035088 2035088 defendant Ensoure Thomas gent 611430 611430 Ensoure, Thomas, of Cumberford, gent 0
4029201 2035088 2035088 defendant Edge Roger husbandman 611430 611430 Edge, Roger, of Cumberford, husbandman 1
4043051 2039983 2039983 defendant Cumberford William gent 611430 611430 Cumberford, William, of Cumberford, gent, son of Thomas Cumberford, of Cumberford, gent 0
4053060 2043523 2043523 defendant Cumberford Thomas esq 611430 611430 Cumberford, Thomas, of Cumberford, esq 0
4093931 2058154 2058154 defendant Cumberford Thomas esq 611430 611430 Cumberford Thomas, of Cumberford, esq 0
4496719 2199641 2199641 defendant Wryte William   611430 611430 Wryte, William, of Cumberford 3
4861726 2315039 2315039 defendant Cubbe Richard husbandman 611430 611430 Cubbe, Richard, of Cumberford, husbandman 0
5099978 2386431 2386431 plaintiff Wright William   611430 611430 Wright, William, of Cumberford 0

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