names

24 rows where place_id = 846336

✎ 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
3774449 1949734 1949734 defendant Don Edward   846336 846336 Don, Edward, of Horsyngdon, Bucks, knight 0
3919003 1996679 1996679 defendant Dun Edward   846336 846336 Dun, Edward, of Horsyngdon, Bucks, knight 0
3921011 1997375 1997375 defendant Don Edward   846336 846336 Don, Edward, of Horsyngdon, Bucks, knight 0
5100019 2386442 2386442 defendant Brekenok John gent 846336 846336 Brekenok, John, of Horsyngdon, Bucks, gent 0
5123885 2393441 2393441 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5139030 2397908 2397908 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5139035 2397910 2397910 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5142636 2398975 2398975 defendant Breknok John esq & treasurer of the King's Hospice 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq & treasurer of the King's Hospice 0
5146093 2399983 2399983 defendant Breknok John esq & formerly treasurer of the King's hospice 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq & formerly treasurer of the King's hospice 0
5154286 2402411 2402411 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5155001 2402618 2402618 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 4
5159359 2403852 2403852 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5159480 2403887 2403887 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5161243 2404383 2404383 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5166332 2405876 2405876 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5171798 2407472 2407472 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 1
5176702 2408870 2408870 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5266548 2435287 2435287 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5266551 2435288 2435288 defendant Brekenok John esq 846336 846336 Brekenok, John, of Horsyngdon, Bucks, esq 0
5277294 2438440 2438440 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5280366 2439335 2439335 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 2
5280391 2439340 2439340 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 1
5325601 2452734 2452734 defendant Breknok John esq 846336 846336 Breknok, John, of Horsyngdon, Bucks, esq 0
5593931 2533092 2533092 defendant Dun Edward esq 846336 846336 Dun, Edward, of Horsyngdon, Bucks, 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);