names

18 rows where place_id = 611673

✎ 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
3689535 1922881 1922881 defendant Assheburnham Thomas esq 611673 611673 Assheburnham, Thomas, of Gestlyng, Sussex, esq 0
3699412 1926039 1926039 defendant Deynyshe Richard gent 611673 611673 Deynyshe, Richard, of Gestlyng, Sussex, gent 1
3719687 1932424 1932424 defendant Stokes Henry gent 611673 611673 Stokes, Henry, of Gestlyng, Sussex, gent 0
3755087 1943538 1943538 defendant Assheburnham Thomas esq 611673 611673 Assheburnham, Thomas, of Gestlyng, Sussex, esq 0
3772599 1949122 1949122 defendant Asheburnham Thomas esq 611673 611673 Asheburnham, Thomas, of Gestlyng, Sussex, esq 0
3792643 1955558 1955558 defendant Stokes Henry gent and mercer 611673 611673 Stokes, Henry, of Gestlyng, Sussex, gent and mercer 0
3801211 1958300 1958300 defendant Hollok John yeoman 611673 611673 Hollok, John, of Gestlyng, Sussex, yeoman 1
3824104 1965411 1965411 defendant Assheburnham Thomas esq 611673 611673 Assheburnham, Thomas, of Gestlyng, Sussex, esq 0
3839272 1970211 1970211 defendant Assheburnham Thomas gent 611673 611673 Assheburnham, Thomas, of Gestlyng, Sussex, gent 0
3847984 1972944 1972944 defendant Assheburneham Thomas gent 611673 611673 Assheburneham, Thomas, of Gestlyng, Sussex, gent 0
3889625 1986760 1986760 defendant Assheborneham Thomas gent 611673 611673 Assheborneham, Thomas, of Gestlyng, Sussex, gent 0
3891351 1987374 1987374 defendant Asshebornham Thomas gent 611673 611673 Asshebornham, Thomas, of Gestlyng, Sussex, gent 1
3909892 1993615 1993615 defendant Donne Richard laborer 611673 611673 Donne, Richard, of Gestlyng, Sussex, laborer 0
3936541 2002545 2002545 defendant Harrys Hugh clerk & parson 611673 611673 Harrys, Hugh, of Gestlyng, Sussex, clerk & parson 0
3942595 2004531 2004531 defendant Harrys Hugh   611673 611673 Harrys, Hugh, of Gestlyng, Sussex, parson 0
3954930 2008787 2008787 defendant Stafford Thomas clerk 611673 611673 Stafford, Thomas, of Gestlyng, Sussex, clerk 6
4849913 2311444 2311444 defendant Clerk Roger   611673 611673 Clerk, Roger, of Gestlyng, Sussex, parson 0
5572405 2526472 2526472 defendant Asshburnham Thomas esq 611673 611673 Asshburnham, Thomas, of Gestlyng, Sussex, esq 4

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