names

25 rows where case_id = 1941743

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749444 1941743 1941743 plaintiff Howard Edward knight   Howard, Edward, knight 0
3749445 1941743 1941743 plaintiff Broun Matthew knight   Broun, Matthew, knight 1
3749446 1941743 1941743 plaintiff Gaynesford John knight   Gaynesford, John, knight 2
3749447 1941743 1941743 plaintiff Walsyngham Edward knight   Walsyngham, Edward, knight 3
3749448 1941743 1941743 plaintiff Dawtrey John knight   Dawtrey, John, knight 4
3749449 1941743 1941743 plaintiff Westbroke William     Westbroke, William 5
3749450 1941743 1941743 plaintiff Byrley John     Byrley, John 6
3749451 1941743 1941743 plaintiff Lysley Thomas     Lysley, Thomas 7
3749452 1941743 1941743 plaintiff Skynner John     Skynner, John 8
3749453 1941743 1941743 defendant Bray Edward   616598 616598 Bray, Edward, of Stoke Dabernon, knight 0
3749454 1941743 1941743 defendant Parcevell William yeoman 616598 616598 Parcevell, William, of Stoke Dabernon, yeoman 1
3749455 1941743 1941743 defendant Mylsam William yeoman 616598 616598 Mylsam, William, of Stoke Dabernon, yeoman 2
3749456 1941743 1941743 defendant Barbour John yeoman 616598 616598 Barbour, John, of Stoke Dabernon, yeoman 3
3749457 1941743 1941743 defendant Blundell Henry husbandman 616597 616597 Blundell, Henry, of Feccham, husbandman 4
3749458 1941743 1941743 defendant Man John husbandman 616597 616597 Man, John, of Feccham, husbandman 5
3749459 1941743 1941743 defendant Smyth Philip laborer 616597 616597 Smyth, Philip, of Feccham, laborer 6
3749460 1941743 1941743 defendant Gryffyn John laborer 616597 616597 Gryffyn, John, of Feccham, laborer 7
3749461 1941743 1941743 defendant Grove Richard laborer 616597 616597 Grove, Richard, of Feccham, laborer 8
3749462 1941743 1941743 defendant Hamond Henry laborer 616597 616597 Hamond, Henry, of Feccham, laborer 9
3749463 1941743 1941743 defendant Cheynell William laborer 616597 616597 Cheynell, William, of Feccham, laborer 10
3749464 1941743 1941743 defendant Neell homas laborer 616597 616597 Neell, homas, of Feccham, laborer 11
3749465 1941743 1941743 defendant Lamston Richard laborer 616597 616597 Lamston, Richard, of Feccham, laborer 12
3749466 1941743 1941743 defendant Tayllour Thomas laborer 616597 616597 Tayllour, Thomas, of Feccham, laborer 13
3749467 1941743 1941743 defendant Baylly Robert laborer 616597 616597 Baylly, Robert, of Feccham, laborer 14
3749468 1941743 1941743 defendant Sewar John laborer 619581 619581 Sewar, John, of Magna Bokeham, laborer 15

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