names

24 rows where place_id = 623618

✎ 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
3753434 1943012 1943012 defendant Squyer Henry husbandman 623618 623618 Squyer, Henry, of Wyssett, husbandman 2
3759781 1945053 1945053 defendant Elmys John carver 623618 623618 Elmys, John, of Wyssett, carver 1
3851015 1973910 1973910 defendant Colvyle Gilbert gent 623618 623618 Colvyle, Gilbert, of Wyssett, gent 0
3860760 1977092 1977092 defendant Long William husbandman 623618 623618 Long, William, of Wyssett, husbandman 0
3873663 1981407 1981407 defendant Londe Robert tailor 623618 623618 Londe, Robert, of Wyssett, tailor 1
3887005 1985917 1985917 defendant Mulsford Richard carpenter 623618 623618 Mulsford, Richard, of Wyssett, carpenter 1
3889059 1986580 1986580 defendant Bramforth Robert laborer 623618 623618 Bramforth, Robert, of Wyssett, laborer 0
3890238 1986979 1986979 defendant Drane Richard husbandman 623618 623618 Drane, Richard, of Wyssett, husbandman 0
3911663 1994222 1994222 defendant Golvyle Gilbert gent 623618 623618 Golvyle, Gilbert, of Wyssett, gent 0
3916246 1995816 1995816 defendant Seman John husbandman 623618 623618 Seman, John, of Wyssett, husbandman 2
3924395 1998470 1998470 defendant Owles Thomas   623618 623618 Owles, Thomas, of Wyssett, wheel wright 0
4025086 2033631 2033631 defendant Richardson Philip yeoman 623618 623618 Richardson, Philip, of Wyssett, yeoman 0
4090896 2057035 2057035 defendant Gooch Richard merchant 623618 623618 Gooch, Richard, of Wyssett, yeoman, merchant 0
4121986 2068165 2068165 defendant Dawson George yeoman 623618 623618 Dawson, George, of Wyssett, yeoman 1
4124638 2069109 2069109 defendant Dawson George yeoman 623618 623618 Dawson, George, of Wyssett, yeoman 0
4126446 2069743 2069743 defendant Dawson George yeoman 623618 623618 Dawson, George, of Wyssett, yeoman 0
4132946 2072109 2072109 defendant Dawson George yeoman 623618 623618 Dawson, George, of Wyssett, yeoman, son of Thomas Dawson, of Wysset, yeoman 0
4132948 2072110 2072110 defendant Dawson Thomas yeoman 623618 623618 Dawson, Thomas, of Wyssett, yeoman 0
4177201 2087496 2087496 defendant Gooche Richard yeoman 623618 623618 Gooche, Richard, of Wyssett, yeoman 1
4177202 2087496 2087496 defendant Gooche Nicholas yeoman 623618 623618 Gooche, Nicholas, of Wyssett, yeoman 2
4196018 2094158 2094158 defendant Dawson Thomas yeoman 623618 623618 Dawson, Thomas, of Wyssett, yeoman 1
4208354 2098470 2098470 defendant Dawson Thomas yeoman 623618 623618 Dawson, Thomas, of Wyssett, yeoman 1
4208355 2098470 2098470 defendant Dawson Gerege yeoman 623618 623618 Dawson, Gerege, of Wyssett, yeoman 2
4284749 2124592 2124592 defendant Gooche Richard yeoman 623618 623618 Gooche, Richard, of Wyssett, yeoman 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);