names

23 rows where place_id = 768514

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4438104 2181217 2181217 defendant Cokerell John   768514 768514 Cokerell, John, of Stowe, Gloucs 0
4549704 2215840 2215840 defendant sergeant Richard   768514 768514 sergeant, Richard, of Stowe St Edward, Gloucs 1
4611823 2234762 2234762 plaintiff Collyng William   768514 768514 Collyng, William, of Stowe St Edward, Gloucs 0
4623278 2238252 2238252 defendant Spiser alias Spicer Robert   768514 768514 Spiser alias Spicer, Robert, of Stowe St Edward, Gloucs 0
4623280 2238253 2238253 defendant Spiser Robert   768514 768514 Spiser, Robert, of Stowe St Edward, Gloucs 0
4817107 2301445 2301445 defendant Benste John, junior draper 768514 768514 Benste, John, junior, of Stowe St Edward, Gloucs, draper 0
4817110 2301446 2301446 defendant Benste John, junior draper 768514 768514 Benste, John, junior, of Stowe St Edward, Gloucs, draper 0
4822739 2303191 2303191 defendant Collynge William drover 768514 768514 Collynge, William, of Stowe St Edward, Gloucs, drover 1
4843983 2309632 2309632 defendant Hambery Richard clerk 768514 768514 Hambery, Richard, of Stowe, Gloucs, clerk 0
4844017 2309638 2309638 defendant Hambery Richard clerk 768514 768514 Hambery, Richard, of Stowe, Gloucs, clerk 0
4924714 2334167 2334167 defendant Rogerys Roger chapman 768514 768514 Rogerys, Roger, of Stowe St Edward, Gloucs, chapman 0
5044174 2369884 2369884 defendant Wynford John merchant 768514 768514 Wynford, John, of Stowe, Gloucs, merchant 0
5051899 2372183 2372183 defendant Wynford John husbandman 768514 768514 Wynford, John, of Stowe St Edward, Gloucs, husbandman 0
5142735 2399000 2399000 defendant Pase Thomas yeoman 768514 768514 Pase, Thomas, of Stowe St Edward, Gloucs, yeoman 0
5152668 2401921 2401921 defendant Wynford John woolman 768514 768514 Wynford, John, of Stowe St Edward, Gloucs, woolman 0
5170730 2407161 2407161 defendant Wynford John   768514 768514 Wynford, John, of Stowe St Edward, Gloucs, wool man 0
5188657 2412406 2412406 defendant Wynford John   768514 768514 Wynford, John, of Stowe St Edward, Gloucs, wool man 0
5200836 2416005 2416005 defendant Wynford John   768514 768514 Wynford, John, of Stowe St Edward, Gloucs, wool man 0
5206166 2417534 2417534 defendant Wynford John   768514 768514 Wynford, John, of Stowe St Edward, Gloucs, wool man 0
5211659 2419148 2419148 defendant _ynford John   768514 768514 _ynford, John, of Stowe St Edward, Gloucs, wool man 0
5274770 2437698 2437698 defendant Wynford John dyer 768514 768514 Wynford, John, of Stowe St Edward, Gloucs, dyer 0
5402703 2475848 2475848 defendant Harrys William yeoman 768514 768514 Harrys, William, of Stowe St Edward, Gloucs, yeoman 0
5427722 2483251 2483251 defendant Ruddebye Thomas grocer 768514 768514 Ruddebye, Thomas, of Stowe St Edward, Gloucs, grocer 1

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