names

17 rows where case_id = 2499166

✎ 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
5480586 2499166 2499166 plaintiff Denne William     Denne, William 0
5480587 2499166 2499166 defendant Catte James yeoman 590798 590798 Catte, James, of Gresham, yeoman 0
5480588 2499166 2499166 defendant Pycher Edward husbandman 591136 591136 Pycher, Edward, of Mateshalebergh, husbandman 1
5480589 2499166 2499166 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 2
5480590 2499166 2499166 defendant Keton Richard yeoman 590844 590844 Keton, Richard, of Lyng, yeoman 3
5480591 2499166 2499166 defendant Harowe John raffman 585936 585936 Harowe, John, of Norwich, raffman 4
5480592 2499166 2499166 defendant Frankyssh Luke yeoman 585869 585869 Frankyssh, Luke, of London, yeoman 5
5480593 2499166 2499166 defendant Saweton Richard yeoman 586940 586940 Saweton, Richard, of Baldeswell, yeoman 6
5480594 2499166 2499166 defendant Warner John yeoman 586940 586940 Warner, John, of Baldeswell, yeoman 7
5480595 2499166 2499166 defendant Broun Thomas yeoman 588848 588848 Broun, Thomas, of Magna Dunham, yeoman 8
5480596 2499166 2499166 defendant Cok Thomas yeoman 604275 604275 Cok, Thomas, of Gasthorp, yeoman 9
5480597 2499166 2499166 defendant ketelston Thomas yeoman 592166 592166 ketelston, Thomas, of Myleham, yeoman 10
5480598 2499166 2499166 defendant Holle William yeoman 626174 626174 Holle, William, of Wodenorton, yeoman 11
5480599 2499166 2499166 defendant Smyth William draper 585936 585936 Smyth, William, of Norwich, draper 12
5480600 2499166 2499166 defendant Payn John yeoman 891807 891807 Payn, John, of Tybenhale Longrowe, yeoman 13
5480601 2499166 2499166 defendant Salter John butcher   Salter, John, butcher, executor of 14
5480602 2499166 2499166 defendant Salter Walter yeoman 587294 587294 Salter, Walter, of Todyngton, yeoman 15

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