names

17 rows where case_id = 2301448

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4817113 2301448 2301448 plaintiff Meleman John     Meleman, John 0
4817114 2301448 2301448 plaintiff Grene Thomas     Grene, Thomas 1
4817115 2301448 2301448 plaintiff Glover Thomas     Glover, Thomas 2
4817116 2301448 2301448 defendant Wilby Edward gent 599840 599840 Wilby, Edward, of Hyndryngham, Norf, gent 0
4817117 2301448 2301448 defendant Mortoft John husbandman 588509 588509 Mortoft, John, of Itryngham, husbandman 1
4817118 2301448 2301448 defendant Greneweye Robert husbandman 782190 782190 Greneweye, Robert, of Wodedallyng, husbandman 2
4817119 2301448 2301448 defendant Neuton Richard husbandman 806888 806888 Neuton, Richard, of Thrnyng, husbandman 3
4817120 2301448 2301448 defendant Grome John butcher 593923 593923 Grome, John, of Saxthorp, butcher 4
4817121 2301448 2301448 defendant Bennys John smith 806889 806889 Bennys, John, of Ermynglond, smith 5
4817122 2301448 2301448 defendant Flaxman William husbandman 588509 588509 Flaxman, William, of Itryngham, husbandman 6
4817123 2301448 2301448 defendant Jervys William shoemaker 662331 662331 Jervys, William, of Geystwheyt, shoemaker 7
4817124 2301448 2301448 defendant Skonle Robert laborer 597346 597346 Skonle, Robert, of Notton, laborer 8
4817125 2301448 2301448 defendant Wegge John butcher 777893 777893 Wegge, John, of Great Wychyngham, butcher 9
4817126 2301448 2301448 defendant Martyns John husbandman 806890 806890 Martyns, John, of Henynsham, husbandman 10
4817127 2301448 2301448 defendant Barker John tanner 589042 589042 Barker, John, of Heydon, tanner 11
4817128 2301448 2301448 defendant More James gent 585936 585936 More, James, of Norwich, gent 12
4817129 2301448 2301448 defendant Feltwell Thomas yeoman 806891 806891 Feltwell, Thomas, of Great Wychyngham, Norf, 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);