names

15 rows where case_id = 2423296

✎ 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
5226073 2423296 2423296 plaintiff Somervyle John     Somervyle, John 0
5226074 2423296 2423296 defendant Hebande Edward gent 861424 861424 Hebande, Edward, of Ippursley, Warks, gent 0
5226075 2423296 2423296 defendant Lawghere Thomas yeoman 861425 861425 Lawghere, Thomas, of Ippursley, yeoman 1
5226076 2423296 2423296 defendant Turbut John husbandman 624741 624741 Turbut, John, of Astwode, husbandman 2
5226077 2423296 2423296 defendant Hewys William husbandman 624741 624741 Hewys, William, of Astwode, husbandman 3
5226078 2423296 2423296 defendant Mylner John oof Clotsale, husbandman   Mylner, John, oof Clotsale, husbandman 4
5226079 2423296 2423296 defendant Hayward Roger husbandman 618992 618992 Hayward, Roger, of Somborne, husbandman 5
5226080 2423296 2423296 defendant Tymms Richard husbandman 618992 618992 Tymms, Richard, of Somborne, husbandman 6
5226081 2423296 2423296 defendant Bonde John husbandman 592611 592611 Bonde, John, of Fekenham, husbandman 7
5226082 2423296 2423296 defendant Reve Thomas husbandman 592611 592611 Reve, Thomas, of Fekenham, husbandman 8
5226083 2423296 2423296 defendant Rawelyn Richard husbandman 592611 592611 Rawelyn, Richard, of Fekenham, husbandman 9
5226084 2423296 2423296 defendant Homan Thomas husbandman 592611 592611 Homan, Thomas, of Fekenham, husbandman 10
5226085 2423296 2423296 defendant CLerk John husbandman 592611 592611 CLerk, John, of Fekenham, husbandman 11
5226086 2423296 2423296 defendant Lawghere John yeoman 622224 622224 Lawghere, John, of Dombulton, yeoman 12
5226087 2423296 2423296 defendant Lawghere Richard yeoman 861426 861426 Lawghere, Richard, of Lebury, 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);