names

16 rows where case_id = 2551274

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5623461 2551274 2551274 plaintiff Wythyford William de     Wythyford, William de 0
5623462 2551274 2551274 defendant Roson John de   587710 587710 Roson, John de, of Fulford 0
5623463 2551274 2551274 defendant Fulford William de son of Edmund   Fulford, William de, son of Edmund 1
5623464 2551274 2551274 defendant Basset John     Basset, John 2
5623465 2551274 2551274 defendant atte Lowe Henry     atte Lowe, Henry 3
5623466 2551274 2551274 defendant Stalynton Thomas de chaplain   Stalynton, Thomas de, chaplain 4
5623467 2551274 2551274 defendant Bent Philip   906863 906863 Bent, Philip, of Severlay 5
5623468 2551274 2551274 defendant Coupe Stephen le   906864 906864 Coupe, Stephen le, of Lyegh 6
5623469 2551274 2551274 defendant Basset Roger   594609 594609 Basset, Roger, of Draycote 7
5623470 2551274 2551274 defendant Badelond Richard   629371 629371 Badelond, Richard, of Teyne 8
5623471 2551274 2551274 defendant Bathyne William   587710 587710 Bathyne, William, of Fulford 9
5623472 2551274 2551274 defendant Broune Henry   596482 596482 Broune, Henry, of Legh 10
5623473 2551274 2551274 defendant Cartere Adam   906865 906865 Cartere, Adam, of Checkelaye 11
5623474 2551274 2551274 defendant Hegh Peter de     Hegh, Peter de 12
5623475 2551274 2551274 defendant Parkere Thomas   641784 641784 Parkere, Thomas, of Meddelton 13
5623476 2551274 2551274 defendant Baile William   596482 596482 Baile, William, of Legh 14

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