names

23 rows where place_id = 808439

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4826067 2304185 2304185 defendant Williams John   808439 808439 Williams, John, of Burmynton 6
4826068 2304185 2304185 defendant William Nicholas   808439 808439 William, Nicholas, of Burmynton 7
4826069 2304185 2304185 defendant Blakwell Nicholas   808439 808439 Blakwell, Nicholas, of Burmynton 8
4826070 2304185 2304185 defendant Gibbes Nicholas   808439 808439 Gibbes, Nicholas, of Burmynton 9
4826071 2304185 2304185 defendant Holdere Robert   808439 808439 Holdere, Robert, of Burmynton 10
4826072 2304185 2304185 defendant Hondes Thomas   808439 808439 Hondes, Thomas, of Burmynton 11
4826073 2304185 2304185 defendant Deke John   808439 808439 Deke, John, of Burmynton 12
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
4880048 2320671 2320671 defendant Willyams John husbandman 808439 808439 Willyams, John, of Burmynton, husbandman 6
4880049 2320671 2320671 defendant Williams Nicholas husbandman 808439 808439 Williams, Nicholas, of Burmynton, husbandman 7
4880050 2320671 2320671 defendant Brakwell Nicholas husbandman 808439 808439 Brakwell, Nicholas, of Burmynton, husbandman 8
4880051 2320671 2320671 defendant Gybbes Nicholas husbandman 808439 808439 Gybbes, Nicholas, of Burmynton, husbandman 9
4880052 2320671 2320671 defendant Holdere Robert husbandman 808439 808439 Holdere, Robert, of Burmynton, husbandman 10
4880053 2320671 2320671 defendant Hondes Thomas husbandman 808439 808439 Hondes, Thomas, of Burmynton, husbandman 11
4880054 2320671 2320671 defendant Deken John husbandman 808439 808439 Deken, John, of Burmynton, husbandman 12
5429013 2483599 2483599 defendant Toly Robert husbandman 808439 808439 Toly, Robert, of Burmynton, husbandman 0
5446608 2488877 2488877 defendant Toly Robert husbandman 808439 808439 Toly, Robert, of Burmynton, husbandman 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);