names

17 rows where case_id = 2312089

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4852102 2312089 2312089 plaintiff Walweyn Edmund     Walweyn, Edmund 0
4852103 2312089 2312089 defendant Parker Roger   618894 618894 Parker, Roger, of Tyso, park man 0
4852104 2312089 2312089 defendant Middilton William husbandman 618894 618894 Middilton, William, of Tyso, husbandman 1
4852105 2312089 2312089 defendant Daylesford Peter husbandman 793554 793554 Daylesford, Peter, of Great Wolford, husbandman 2
4852106 2312089 2312089 defendant Rose Thomas husbandman 793554 793554 Rose, Thomas, of Great Wolford, husbandman 3
4852107 2312089 2312089 defendant Rose William husbandman 793554 793554 Rose, William, of Great Wolford, husbandman 4
4852108 2312089 2312089 defendant Nicholas William husbandman 606465 606465 Nicholas, William, of Little Wolford, husbandman 5
4852109 2312089 2312089 defendant Williams John   808439 808439 Williams, John, of Burmynton, husb 6
4852110 2312089 2312089 defendant Williams Nicholas   808439 808439 Williams, Nicholas, of Burmynton, husb 7
4852111 2312089 2312089 defendant Drakewell Nicholas   808439 808439 Drakewell, Nicholas, of Burmynton, husb 8
4852112 2312089 2312089 defendant Gybbes NIcholas   808439 808439 Gybbes, NIcholas, of Burmynton, husb 9
4852113 2312089 2312089 defendant Holder Robert   808439 808439 Holder, Robert, of Burmynton, husb 10
4852114 2312089 2312089 defendant Hondes Thomas   808439 808439 Hondes, Thomas, of of Burmynton, husb 11
4852115 2312089 2312089 defendant Deken John   808439 808439 Deken, John, of Burmynton, husb 12
4852116 2312089 2312089 defendant Carpenter William   594018 594018 Carpenter, William, of Berston, husb 13
4852117 2312089 2312089 defendant Freman John   586442 586442 Freman, John, of Honyton, husb 14
4852118 2312089 2312089 defendant Bradele John   586442 586442 Bradele, John, of Honyton, husb 15

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