names

13 rows where case_id = 2353630

✎ 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
4988890 2353630 2353630 plaintiff Brook Roger     Brook, Roger 0
4988891 2353630 2353630 defendant Mikilhill John husbandman 637449 637449 Mikilhill, John, of Alderford, husbandman 0
4988892 2353630 2353630 defendant Egmere John thatcher 831270 831270 Egmere, John, of Whitewell, by Refham, thatcher 1
4988893 2353630 2353630 defendant Mathewe John hosier 607663 607663 Mathewe, John, of Southwerk, Surrey, hosier 2
4988894 2353630 2353630 defendant Gosselyn Richard husbandman 831271 831271 Gosselyn, Richard, of Little Purlond, husbandman 3
4988895 2353630 2353630 defendant Goselyn Emma   831271 831271 Goselyn, Emma, of Little Purlond, servant 4
4988896 2353630 2353630 defendant Pekhare William yeoman 598258 598258 Pekhare, William, of Bury St Edmunds, Suff, yeoman 5
4988897 2353630 2353630 defendant Lombe John   771530 771530 Lombe, John, of Wykylwode, servant 6
4988898 2353630 2353630 defendant Robbys Henry sawer 831274 831274 Robbys, Henry, of Hakford by Hengham, sawer 7
4988899 2353630 2353630 defendant Gylys William   831274 831274 Gylys, William, of Hakford by Hengham, mason 8
4988900 2353630 2353630 defendant Cobbe John jun, of Tunstede, husbandman   Cobbe, John, jun, of Tunstede, husbandman 9
4988901 2353630 2353630 defendant Wedir Rogert sawer 591466 591466 Wedir, Rogert, of Hakford, sawer 10
4988902 2353630 2353630 defendant Danyell John glover 585936 585936 Danyell, John, of Norwich, glover 11

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