names

14 rows where case_id = 2087269

✎ 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
4176521 2087269 2087269 plaintiff Hardwick Thomas attorney   Hardwick, Thomas, attorney 0
4176522 2087269 2087269 defendant Gyger John gent 709064 709064 Gyger, John, of Ludwell, gent 0
4176523 2087269 2087269 defendant Cole William Master of Arts 585970 585970 Cole, William, of Oxford, Master of Arts 1
4176524 2087269 2087269 defendant Bedforde Richard gent 709065 709065 Bedforde, Richard, of Burcott, gent 2
4176525 2087269 2087269 defendant Bewforest Luke gent 589851 589851 Bewforest, Luke, of Dorchester, gent 3
4176526 2087269 2087269 defendant Hore William yeoman 619415 619415 Hore, William, of Waterton, yeoman 4
4176527 2087269 2087269 defendant Banckes Richard yeoman 585970 585970 Banckes, Richard, of Oxford, yeoman 5
4176528 2087269 2087269 defendant Wyllys James mercer 585970 585970 Wyllys, James, of Oxford, mercer 6
4176529 2087269 2087269 defendant Clarke Ralph yeoman 585970 585970 Clarke, Ralph, of Oxford, yeoman 7
4176530 2087269 2087269 defendant Barrett Christopher yeoman 709066 709066 Barrett, Christopher, of Blechenton, yeoman 8
4176531 2087269 2087269 defendant Roper William gent 709067 709067 Roper, William, of Charburye, gent 9
4176532 2087269 2087269 defendant Tyrvyle Giles yeoman 585970 585970 Tyrvyle, Giles, of Oxford, yeoman 10
4176533 2087269 2087269 defendant Turner William draper 650337 650337 Turner, William, of Woodstock, draper 11
4176534 2087269 2087269 defendant Howse John yeoman 585970 585970 Howse, John, of Oxford, yeoman 12

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