names

14 rows where place_id = 612892

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3695477 1924808 1924808 defendant Kyngbywest John yeoman 612892 612892 Kyngbywest, John, of Althorne, yeoman 0
3705831 1928105 1928105 defendant Stywarde John laborer 612892 612892 Stywarde, John, of Althorne, laborer 0
3705832 1928105 1928105 defendant Preston John, junior laborer 612892 612892 Preston, John, junior, of Althorne, laborer 1
3705833 1928105 1928105 defendant Batell Thomas laborer 612892 612892 Batell, Thomas, of Althorne, laborer 2
3709396 1929238 1929238 defendant Bywest John Kyng yeoman 612892 612892 Bywest, John Kyng, of Althorne, yeoman 0
3714142 1930724 1930724 defendant Causton Thomas yeoman 612892 612892 Causton, Thomas, of Althorne, yeoman 0
3727048 1934725 1934725 defendant Causton Thomas yeoman 612892 612892 Causton, Thomas, of Althorne, yeoman 0
3729490 1935470 1935470 defendant Cawston Thomas yeoman 612892 612892 Cawston, Thomas, of Althorne, yeoman 0
3763507 1946220 1946220 defendant Wade Robert yeoman 612892 612892 Wade, Robert, of Althorne, yeoman 1
3835327 1968988 1968988 defendant Balard Henry husbandman 612892 612892 Balard, Henry, of Althorne, husbandman 0
3848646 1973160 1973160 defendant Melborne Robert husbandman 612892 612892 Melborne, Robert, of Althorne, husbandman 1
3969283 2013863 2013863 defendant Trayford John yeoman 612892 612892 Trayford, John, of Althorne, yeoman 0
4055541 2044376 2044376 defendant Kynge John yeoman 612892 612892 Kynge, John, of Althorne, yeoman executor of 0
4281500 2123431 2123431 defendant Saffold John chapman 612892 612892 Saffold, John, of Althorne, chapman 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);