names

10 rows where place_id = 587923

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592843 1865378 1865378 defendant Alfray Nicholas husbandman 587923 587923 Alfray, Nicholas, of Wythyam, husbandman 0
3597228 1866756 1866756 defendant Alfray Nicholas husbandman 587923 587923 Alfray, Nicholas, of Wythyam, husbandman 0
3858995 1976502 1976502 defendant Alfry Richard yeoman 587923 587923 Alfry, Richard, of Wythyam, yeoman 0
4170785 2085273 2085273 defendant Harte John yeoman 587923 587923 Harte, John, of Wythyam, yeoman 1
4572050 2222825 2222825 defendant Pope Thomas   587923 587923 Pope, Thomas, of Wythyam 2
4668199 2255764 2255764 defendant Sakevyle Thomas   587923 587923 Sakevyle, Thomas, of Wythyam, knight 0
5065884 2376318 2376318 defendant Marryng William chaplain 587923 587923 Marryng, William, of Wythyam, chaplain 0
5225202 2423044 2423044 defendant Somer Henry yeoman 587923 587923 Somer, Henry, of Wythyam, yeoman 0
5542347 2517729 2517729 defendant Saxpays Richard yeoman 587923 587923 Saxpays, Richard, of Wythyam, yeoman 0
5587010 2530964 2530964 defendant Alverey Nicholas husbandman 587923 587923 Alverey, Nicholas, of Wythyam, husbandman 0

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