names

13 rows where case_id = 2324919

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4894377 2324919 2324919 plaintiff Dacre Thomas Lord Dacre, knight   Dacre, Thomas, Lord Dacre, knight 0
4894378 2324919 2324919 defendant Noble Robert yeoman 779264 779264 Noble, Robert, of Bampton, Westmor, yeoman 0
4894379 2324919 2324919 defendant Mathewson John, junior yeoman 587559 587559 Mathewson, John, junior, of Bampton, yeoman 1
4894380 2324919 2324919 defendant Bakstare John yeoman 587559 587559 Bakstare, John, of Bampton, yeoman 2
4894381 2324919 2324919 defendant Noble John yeoman 587559 587559 Noble, John, of Bampton, yeoman 3
4894382 2324919 2324919 defendant Robynson John yeoman 587559 587559 Robynson, John, of Bampton, yeoman 4
4894383 2324919 2324919 defendant del Yate William yeoman 587559 587559 del Yate, William, of Bampton, yeoman 5
4894384 2324919 2324919 defendant del Yate John yeoman 587559 587559 del Yate, John, of Bampton, yeoman 6
4894385 2324919 2324919 defendant Hoghirde William yeoman 587559 587559 Hoghirde, William, of Bampton, yeoman 7
4894386 2324919 2324919 defendant Gibson Nicholas yeoman 587559 587559 Gibson, Nicholas, of Bampton, yeoman 8
4894387 2324919 2324919 defendant Matheweson William yeoman 587559 587559 Matheweson, William, of Bampton, yeoman 9
4894388 2324919 2324919 defendant Noble William yeoman 587559 587559 Noble, William, of Bampton, yeoman 10
4894389 2324919 2324919 defendant Noble Thomas yeoman 587559 587559 Noble, Thomas, of Bampton, yeoman 11

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