names

23 rows where place_id = 629622

✎ 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
3789376 1954499 1954499 defendant Fryday John yeoman 629622 629622 Fryday, John, of Cryklade, yeoman 0
4748723 2280112 2280112 defendant Marner John husbandman 629622 629622 Marner, John, of Cryklade, husbandman 0
4805685 2297987 2297987 defendant Galon John yeoman 629622 629622 Galon, John, of Cryklade, yeoman 0
4808668 2298877 2298877 defendant Galon John yeoman 629622 629622 Galon, John, of Cryklade, yeoman 0
4943487 2339933 2339933 defendant Baker Richard baker 629622 629622 Baker, Richard, of Cryklade, baker 0
4947485 2341208 2341208 defendant Kyrton Thomas chapman 629622 629622 Kyrton, Thomas, of Cryklade, chapman 1
5065671 2376258 2376258 defendant Smyth Walter husbandman 629622 629622 Smyth, Walter, of Cryklade, husbandman 9
5065672 2376258 2376258 defendant Trowell William yeoman 629622 629622 Trowell, William, of Cryklade, yeoman 10
5065673 2376258 2376258 defendant Wexman Richard yeoman 629622 629622 Wexman, Richard, of Cryklade, yeoman 11
5065674 2376258 2376258 defendant Neweton Thomas yeoman 629622 629622 Neweton, Thomas, of Cryklade, yeoman 12
5117745 2391623 2391623 defendant Ddenys Richard, junior cordwainer 629622 629622 Ddenys, Richard, junior, of Cryklade, cordwainer 0
5122284 2392943 2392943 defendant Moreys William clerk 629622 629622 Moreys, William, of Cryklade, clerk 4
5222851 2422395 2422395 defendant Wexman Richard yeoman 629622 629622 Wexman, Richard, of Cryklade, yeoman 5
5294603 2443401 2443401 defendant Chaundeler aias Kirten Nicholas mercer 629622 629622 Chaundeler aias Kirten, Nicholas, of Cryklade, mercer 0
5310999 2448327 2448327 defendant Clacke John husbandman 629622 629622 Clacke, John, of Cryklade, husbandman 0
5311000 2448327 2448327 defendant Clacke Robert yeoman 629622 629622 Clacke, Robert, of Cryklade, yeoman 1
5311001 2448327 2448327 defendant Clacke William husbandman 629622 629622 Clacke, William, of Cryklade, husbandman 2
5372376 2466956 2466956 defendant Castelcombe January gent 629622 629622 Castelcombe, January, of Cryklade, gent 0
5499366 2504753 2504753 defendant Mynty John, senior butcher 629622 629622 Mynty, John, senior, of Cryklade, butcher 0
5499367 2504753 2504753 defendant Symmys John husbandman 629622 629622 together with Symmys, John, of Cryklade, husbandman 1
5499368 2504753 2504753 defendant Frensshe Nicholas tailor 629622 629622 Frensshe, Nicholas, of Cryklade, tailor 2
5499369 2504753 2504753 defendant Clakke Elizabeth widow 629622 629622 Clakke, Elizabeth, of Cryklade, widow 3
5607229 2537148 2537148 defendant Russheley Thomas husbandman 629622 629622 Russheley, Thomas, of Cryklade, 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);