names

15 rows where place_id = 586075

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587870 1863855 1863855 defendant Crowemer William esq 586075 586075 Crowemer, William, of Dunstall, Kent, esq 0
3671774 1917163 1917163 defendant Crowmer William   586075 586075 Crowmer, William, of Dunstall, Kent, knight 0
3682997 1920796 1920796 defendant Cromer William   586075 586075 Cromer, William, of Dunstall, Kent, knight 0
3703132 1927253 1927253 plaintiff Cromer William   586075 586075 Cromer, William, of Dunstall, Kent, knight 0
3703136 1927254 1927254 plaintiff Cromer William   586075 586075 Cromer, William, of Dunstall, Kent, knight 0
3716569 1931480 1931480 defendant Cromer William   586075 586075 Cromer, William, of Dunstall, Kent, knight 0
3738595 1938278 1938278 defendant Crowmer James gent 586075 586075 Crowmer, James, of Dunstall, Kent, gent 1
3940203 2003741 2003741 defendant Homewood Robert yeoman 586075 586075 Homewood, Robert, of Dunstall, Kent, yeoman 0
4896234 2325482 2325482 defendant Gore Walter gent 586075 586075 Gore, Walter, of Dunstall, Kent, gent 0
5219352 2421385 2421385 defendant Marchaunt John husbandman 586075 586075 Marchaunt, John, of Dunstall, Kent, husbandman 2
5224765 2422913 2422913 defendant Reynford Lawrence esq 586075 586075 Reynford, Lawrence, of Dunstall, Kent, esq 4
5342574 2457878 2457878 defendant Caym William yeoman 586075 586075 Caym, William, of Dunstall, Kent, yeoman 1
5530162 2513939 2513939 defendant Crowemer William, senior gent 586075 586075 Crowemer, William, senior, of Dunstall, Kent, gent 1
5545722 2518738 2518738 defendant Crowemer William esq 586075 586075 Crowemer, William, of Dunstall, Kent, esq 0
5545726 2518739 2518739 defendant Crowemer William esq 586075 586075 Crowemer, William, of Dunstall, Kent, esq 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);