names

10 rows where case_id = 2284555

✎ 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
4763448 2284555 2284555 plaintiff Grace John (legal representative) 798705 798705 Grace, John, of Landewade, Cambs, executors of 0
4763449 2284555 2284555 plaintiff Cotton Thomas clerk   (Cotton, Thomas, clerk 1
4763450 2284555 2284555 plaintiff Connesby John   635974 635974 Connesby, John, of Snaylwell, parson 2
4763451 2284555 2284555 plaintiff Wareyn John grocer 585869 585869 Wareyn, John, of London, grocer 3
4763452 2284555 2284555 plaintiff Grace William son of Richard Grace   Grace, William, son of Richard Grace 4
4763453 2284555 2284555 plaintiff Tredegold Henry     Tredegold, Henry 5
4763454 2284555 2284555 defendant Taillour Laurence husbandman 754890 754890 Taillour, Laurence, of Bodekesham, husbandman 0
4763455 2284555 2284555 defendant Meldeborne John husbandman 798707 798707 Meldeborne, John, of Bodekesham, Cambs, husbandman 1
4763456 2284555 2284555 defendant Burgeys John husbandman 754890 754890 Burgeys, John, of Bodekesham, husbandman 2
4763457 2284555 2284555 defendant Motte John husbandman 798708 798708 Motte, John, of Swafham Priory, Cambs, husbandman 3

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