names

10 rows where place_id = 591014

✎ 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
3603022 1868612 1868612 defendant Hegger William husbandman 591014 591014 Hegger, William, of Ilestre, husbandman 1
3603026 1868613 1868613 defendant Hegger William husbandman 591014 591014 Hegger, William, of Ilestre, husbandman 1
3618094 1873281 1873281 defendant Horwode John husbandman 591014 591014 Horwode, John, of Ilestre, husbandman 3
3849675 1973483 1973483 defendant Clement John laborer 591014 591014 Clement, John, of Ilestre, laborer 0
3885205 1985303 1985303 defendant Hedger Humphrey maltman 591014 591014 Hedger, Humphrey, of Ilestre, maltman 1
3885217 1985307 1985307 defendant Hedger Humphrey maltman 591014 591014 Hedger, Humphrey, of Ilestre, maltman 1
4882097 2321300 2321300 defendant Abbot William husbandman 591014 591014 Abbot, William, of Ilestre, husbandman 0
4886829 2322734 2322734 defendant Wynge Richard husbandman 591014 591014 Wynge, Richard, of Ilestre, husbandman 0
4903591 2327736 2327736 defendant Abbot William husbandman 591014 591014 Abbot, William, of Ilestre, husbandman 0
5190674 2413019 2413019 defendant Flexmere John butcher 591014 591014 Flexmere, John, of Ilestre, butcher 2

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