names

15 rows where case_id = 2315339

✎ 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
4862757 2315339 2315339 plaintiff Depyng John prior of St Botolph Priory, Colchester   Depyng, John, prior of St Botolph Priory, Colchester 0
4862758 2315339 2315339 defendant Jakes Robert husbandman 591076 591076 Jakes, Robert, of Est Bergholt, husbandman 0
4862759 2315339 2315339 defendant Coke William husbandman 591076 591076 Coke, William, of Est Bergholt, husbandman 1
4862760 2315339 2315339 defendant Cukkowe Geoffrey fuller 591076 591076 Cukkowe, Geoffrey, of Est Bergholt, fuller 2
4862761 2315339 2315339 defendant Cukkowe Thomas husbandman 591076 591076 Cukkowe, Thomas, of Est Bergholt, husbandman 3
4862762 2315339 2315339 defendant Cukkowe John weaver 591076 591076 Cukkowe, John, of Est Bergholt, weaver 4
4862763 2315339 2315339 defendant Peverell Thomas pedder 591076 591076 Peverell, Thomas, of Est Bergholt, pedder 5
4862764 2315339 2315339 defendant Brokeman John pedder 591076 591076 Brokeman, John, of Est Bergholt, pedder 6
4862765 2315339 2315339 defendant Bayly John smith 591076 591076 Bayly, John, of Est Bergholt, smith 7
4862766 2315339 2315339 defendant Gryth John husbandman 591076 591076 Gryth, John, of Est Bergholt, husbandman 8
4862767 2315339 2315339 defendant Balsham Hugh skinner 591076 591076 Balsham, Hugh, of Est Bergholt, skinner 9
4862768 2315339 2315339 defendant Couper Thomas fuller 591076 591076 Couper, Thomas, of Est Bergholt, fuller 10
4862769 2315339 2315339 defendant Gryth Nicholas husbandman 591076 591076 Gryth, Nicholas, of Est Bergholt, husbandman 11
4862770 2315339 2315339 defendant Spillyng William smith 586470 586470 Spillyng, William, of Colchester, smith 12
4862771 2315339 2315339 defendant Spencer John, junior pewterer 586470 586470 Spencer, John, junior, of Colchester, pewterer 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);