names

23 rows where place_id = 623575

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3753253 1942957 1942957 defendant Whyte Tristram husbandman 623575 623575 Whyte, Tristram, of Wutton, husbandman 0
3759290 1944895 1944895 defendant Coke John gent 623575 623575 Coke, John, of Wutton, gent 2
3787768 1953965 1953965 defendant Denny John husbandman 623575 623575 Denny, John, of Wutton, husbandman 2
3813078 1961997 1961997 defendant Coppyng Robert laborer 623575 623575 Coppyng, Robert, of Wutton, laborer 0
3813079 1961997 1961997 defendant Seman Robert laborer 623575 623575 Seman, Robert, of Wutton, laborer 1
3817102 1963262 1963262 defendant Russell John, junior yeoman 623575 623575 Russell, John, junior, of Wutton, yeoman 3
3859078 1976526 1976526 defendant Bocher Nicholas butcher 623575 623575 Bocher, Nicholas, of Wutton under Egge, butcher 2
3873239 1981266 1981266 defendant Bocher Nicholas butcher 623575 623575 Bocher, Nicholas, of Wutton under Egge, butcher 1
3905132 1991981 1991981 defendant Dalton Emery yeoman 623575 623575 Dalton, Emery, of Wutton, yeoman 1
3907647 1992846 1992846 defendant Moyse Anthony brickmaker 623575 623575 Moyse, Anthony, of Wutton, brickmaker 0
3941580 2004197 2004197 defendant Slade William yeoman 623575 623575 Slade, William, of Wutton, yeoman 0
4315637 2135581 2135581 defendant Downe Ralph collier 623575 623575 Downe, Ralph, of Wutton, collier 0
4400043 2164602 2164602 defendant Flud Richard miller 623575 623575 Flud, Richard, of Wutton, miller 0
4474504 2192685 2192685 plaintiff Dormyn Alice   623575 623575 Dormyn, Alice, of Wutton, on her own account 0
4491203 2197935 2197935 plaintiff Weston Thomas   623575 623575 Weston, Thomas, of Wutton 0
4506438 2202513 2202513 defendant Hopere Hugh   623575 623575 Hopere, Hugh, of Wutton 0
4896620 2325604 2325604 defendant Mody Richard tailor 623575 623575 Mody, Richard, of Wutton under Egge, tailor 3
4927066 2334895 2334895 defendant Milys Thomas husbandman 623575 623575 Milys, Thomas, of Wutton, husbandman 4
4975317 2349575 2349575 defendant Wutton Alexander husbandman 623575 623575 Wutton, Alexander, of Wutton, husbandman 0
5051214 2371978 2371978 defendant Stawere Richard husbandman 623575 623575 Stawere, Richard, of Wutton under Edge, shoemaker, husbandman 3
5197874 2415115 2415115 defendant Becheman John husbandman 623575 623575 Becheman, John, of Wutton by Gloucester, husbandman 0
5214142 2419862 2419862 defendant Hervy Thomas husbandman 623575 623575 Hervy, Thomas, of Wutton, husbandman 0
5214145 2419863 2419863 defendant Hervy Thomas husbandman 623575 623575 Hervy, Thomas, of Wutton, husbandman 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);