names

15 rows where case_id = 2328788

✎ 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
4907106 2328788 2328788 plaintiff Moresby Christopher knight   Moresby, Christopher, knight 0
4907107 2328788 2328788 defendant Walas John mercer 590660 590660 Walas, John, of Carlisle, mercer 0
4907108 2328788 2328788 defendant Robson John yeoman 802699 802699 Robson, John, of Richardby, yeoman 1
4907109 2328788 2328788 defendant Grame Thomas gent 776392 776392 Grame, Thomas, of Lynstok, gent 2
4907110 2328788 2328788 defendant Grame John gent 776392 776392 Grame, John, of Lynstok, gent 3
4907111 2328788 2328788 defendant Nicholson Robert yeoman 776392 776392 Nicholson, Robert, of Lynstok, yeoman 4
4907112 2328788 2328788 defendant Rosse John yeoman 776392 776392 Rosse, John, of Lynstok, yeoman 5
4907113 2328788 2328788 defendant Richardson John yeoman 776392 776392 Richardson, John, of Lynstok, yeoman 6
4907114 2328788 2328788 defendant Richardson Richard yeoman 776392 776392 Richardson, Richard, of Lynstok, yeoman 7
4907115 2328788 2328788 defendant Richardson Thomas yeoman 776392 776392 Richardson, Thomas, of Lynstok, yeoman 8
4907116 2328788 2328788 defendant Blaykeloc Robert yeoman 776392 776392 Blaykeloc, Robert, of Lynstok, yeoman 9
4907117 2328788 2328788 defendant Blaykelok Simon yeoman 776392 776392 Blaykelok, Simon, of Lynstok, yeoman 10
4907118 2328788 2328788 defendant Blaykeloc John yeoman 776392 776392 Blaykeloc, John, of Lynstok, yeoman 11
4907119 2328788 2328788 defendant Rokell John yeoman 776392 776392 Rokell, John, of Lynstok, yeoman 12
4907120 2328788 2328788 defendant Nicholason Richard yeoman 776392 776392 Nicholason, Richard, of Lynstok, yeoman 13

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