names

24 rows where place_id = 612205

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692110 1923702 1923702 defendant Ayre John clerk 612205 612205 Ayre, John, of Watford, Nhants, clerk 0
3744348 1940134 1940134 defendant Burneby Thomas Roger 612205 612205 Burneby, Thomas, of Watford, Nhants, gent, kinsman and heir of Philpotte, Roger 0
3769675 1948171 1948171 defendant Burneby Thomas   612205 612205 Burneby, Thomas, of Watford, Nhants, esq, or of Brendwode, Essex 4
3786537 1953582 1953582 defendant Burnebye Thomas esq 612205 612205 Burnebye, Thomas, of Watford, Nhants, esq 1
3786541 1953583 1953583 defendant Burnebye Thomas esq 612205 612205 Burnebye, Thomas, of Watford, Nhants, esq 1
3812819 1961907 1961907 defendant Wyllemecote Richard yeoman 612205 612205 Wyllemecote, Richard, of Watford, Nhants, yeoman 1
3821172 1964513 1964513 defendant Burnby Thomas esq 612205 612205 Burnby, Thomas, of Watford, Nhants, esq 4
3835422 1969017 1969017 defendant Burneby Thomas esq 612205 612205 Burneby, Thomas, of Watford, Nhants, esq 3
3835429 1969019 1969019 defendant Burneby Thomas esq 612205 612205 Burneby, Thomas, of Watford, Nhants, esq 3
3937698 2002941 2002941 defendant Gyfford William gent 612205 612205 Gyfford, William, of Watford, Nhants, gent 0
3995854 2023265 2023265 defendant Blabie Nicholas gent 612205 612205 Blabie, Nicholas, of Watford, Nhants, gent 0
4102469 2061179 2061179 defendant Barnabye Thomas gent 612205 612205 Barnabye, Thomas, of Watford, Nhants, gent 1
4235634 2108032 2108032 defendant Burneby Thomas esq 612205 612205 Burneby, Thomas, of Watford, Nhants, esq 0
4267783 2118858 2118858 defendant Burneby Thomas esq 612205 612205 Burneby, Thomas, of Watford, Nhants, esq 0
4362755 2151738 2151738 defendant Casemore Henry yeoman 612205 612205 Casemore, Henry, of Watford, Nhants, or of Meriden, Warks, yeoman, son of Richard Casemore, of Balsall, yeoman 0
4911793 2330192 2330192 defendant burneby Eustace esq 612205 612205 burneby, Eustace, of Watford, Nhants, esq 0
4955753 2343686 2343686 defendant Watford William gent 612205 612205 Watford, William, of Watford, Nhants, gent 1
4955758 2343687 2343687 defendant Watford William gent 612205 612205 Watford, William, of Watford, Nhants, gent 1
5014151 2360986 2360986 defendant Burnely Eustace esq 612205 612205 Burnely, Eustace, of Watford, Nhants, esq 1
5115986 2391103 2391103 defendant Chamberleyn William husbandman 612205 612205 Chamberleyn, William, of Watford, Nhants, husbandman 0
5466340 2494871 2494871 defendant West Richard (legal representative) 612205 612205 West, Richard, of Watford, Nhants, husbandman, executrix of 2
5466341 2494871 2494871 defendant West Joan   612205 612205 West, Joan, of Watford, Nhants, widow, formerly wife of Richard 3
5466345 2494872 2494872 defendant West Richard (legal representative) 612205 612205 West, Richard, of Watford, Nhants, husbandman, executrix of 2
5466346 2494872 2494872 defendant West Joan   612205 612205 West, Joan, of Watford, Nhants, widow, formerly wife of Richard 3

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