names

25 rows where place_id = 622496

✎ 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
3747339 1941081 1941081 defendant Wynt Henry butcher 622496 622496 Wynt, Henry, of Blandford, butcher 1
3850072 1973614 1973614 defendant Newns Thomas husbandman 622496 622496 Newns, Thomas, of Blandford, husbandman 0
3938742 2003298 2003298 defendant Hunt John   622496 622496 Hunt, John, of Blandford, inn holder 0
3940774 2003921 2003921 defendant Stokes Robert yeoman 622496 622496 Stokes, Robert, of Blandford, yeoman 0
4196709 2094396 2094396 defendant Goddard Thomas yeoman 622496 622496 Goddard, Thomas, of Blandford, yeoman 0
4218689 2102037 2102037 defendant Gardiner William yeoman 622496 622496 Gardiner, William, of Blandford, yeoman 0
4218690 2102037 2102037 defendant Gardiner Edward yeoman 622496 622496 Gardiner, Edward, of Blandford, yeoman 1
4222286 2103284 2103284 defendant Prince George tailor 622496 622496 Prince, George, of Blandford, yeoman, tailor 1
4256513 2115147 2115147 defendant Gardiner Richard yeoman 622496 622496 Gardiner, Richard, of Blandford, yeoman 0
4256514 2115147 2115147 defendant Gardiner Edward yeoman 622496 622496 Gardiner, Edward, of Blandford, yeoman 1
4256515 2115147 2115147 defendant Lane John yeoman 622496 622496 Lane, John, of Blandford, yeoman 2
4279905 2122885 2122885 defendant Sampson George yeoman 622496 622496 Sampson, George, of Blandford, or of Lopton, Soms, yeoman 0
4288319 2125870 2125870 defendant Charleman Richard saddler 622496 622496 Charleman, Richard, of Blandford, saddler 3
4346232 2145936 2145936 defendant Ollmer or Olliver William yeoman 622496 622496 Ollmer or Olliver, William, of Blandford, yeoman 0
4372441 2155212 2155212 defendant Gardner Mathew chapman 622496 622496 Gardner, Mathew, of Blandford, chapman 0
4375804 2156405 2156405 defendant Southcott Peter gent 622496 622496 Southcott, Peter, of Blandford, or of Bovitracie, Devon, gent 0
4377305 2156959 2156959 defendant Hanson George clerk 622496 622496 Hanson, George, of Blandford, or of Haselbury Briant, clerk 0
4489087 2197305 2197305 defendant Hert Richard   622496 622496 Hert, Richard, of Blandford 0
4568020 2221567 2221567 defendant Borys Robert   622496 622496 Borys, Robert, of Blandford 0
4576440 2224144 2224144 defendant Muryfeld Henry   622496 622496 Muryfeld, Henry, of Blandford Forum, scrivenor 0
4581266 2225607 2225607 defendant Pottere John   622496 622496 Pottere, John, of Blandford 2
4593840 2229348 2229348 defendant Chetham Robert   622496 622496 Chetham, Robert, of Blandford 2
4769762 2286514 2286514 defendant Peutrer John pewterer 622496 622496 Peutrer, John, of Blandford, pewterer 2
5161635 2404503 2404503 defendant Rale Simon gent 622496 622496 Rale, Simon, of Blandford, gent 0
5425062 2482459 2482459 defendant Smythe John cutler 622496 622496 Smythe, John, of Blandford, cutler 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);