names

11 rows where place_id = 628847

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3784776 1953030 1953030 defendant Baret John clerk 628847 628847 Baret, John, of Monkeston, clerk 0
4469277 2191060 2191060 plaintiff Blyke John   628847 628847 Blyke, John, of Monkeston 0
4872526 2318366 2318366 defendant Thebolt Alice   628847 628847 Thebolt, Alice, of Monkeston 1
4953817 2343102 2343102 defendant Couper Nicholas smith 628847 628847 Couper, Nicholas, of Monkeston, smith 2
4991948 2354478 2354478 defendant Dollyng John husbandman 628847 628847 Dollyng, John, of Monkeston, husbandman 10
4991949 2354478 2354478 defendant Dollyng Philip husbandman 628847 628847 Dollyng, Philip, of Monkeston, husbandman 11
4998810 2356528 2356528 defendant Wake William laborer 628847 628847 Wake, William, of Monkeston, laborer 1
5409567 2477826 2477826 defendant Skete Thomas husbandman 628847 628847 Skete, Thomas, of Monkeston, husbandman 0
5517565 2510335 2510335 defendant Skete Thomas husbandman 628847 628847 Skete, Thomas, of Monkeston, husbandman 2
5567703 2525127 2525127 defendant Kete Thomas (legal representative) 628847 628847 Kete, Thomas, of Monkeston, husbandman, executors of 0
5567705 2525127 2525127 defendant Kete Richard husbandman 628847 628847 Kete, Richard, of Monkeston, husbandman 2

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